Issue on Importing a File

Hi Community,

I would like to ask this issue. I have never encountered this before so I hope you can provide me some insight.

For example:

This is the view of the file I am going to Import ini Excel mode(just a sample).

I do the usual Save as "CSV format". I open the CSV format and everything is fine. I proceeded in importing it to Anaplan and this is what I got:

I only have 1 column present. I tried to recreate the file over and over again and I still got the same issue.

Is this an issue in Anaplan or Excel. I just finish loading the other csv files that I have and there seem to be no problem just this one.

Appreciate the help.

Regards,

Accepted answers

VIGNESH.M

Hi,

I think it's not because of Anaplan. Try this,

#1. Delete the file source in Import data source

#2. Create a new one.CSV file and load it.

Regards,

Vignesh M

nathan_rudman

this happens when you have a special character in the file that is breaking the column separator logic. try to make a csv with something else than comma and see if it solves it.
or try to find that character....

nathan_rudman

you might want to open with notepad++ and show special chars

Misbah

@Jsdeloria21

Check your delimiters if it is comma, pipe or anything else. Looks like Delimiter issue as @nathan_rudman highlighted

Misbah

usman.zia

@Jsdeloria21

As all the bosses mention it could be a number of different issues...

One option you could try:

It is also possible that text encoding type is not the correct format sometimes selecting UTF8 works for me when the file is saved as a .csv utf8 format.

Alternatively you could try to save it as .txt file and upload it this way.

Thanks,

Usman

All comments

VIGNESH.M

Hi,

I think it's not because of Anaplan. Try this,

#1. Delete the file source in Import data source

#2. Create a new one.CSV file and load it.

Regards,

Vignesh M

nathan_rudman

you might want to open with notepad++ and show special chars

Misbah

@Jsdeloria21

Check your delimiters if it is comma, pipe or anything else. Looks like Delimiter issue as @nathan_rudman highlighted

Misbah

usman.zia

@Jsdeloria21

As all the bosses mention it could be a number of different issues...

One option you could try:

It is also possible that text encoding type is not the correct format sometimes selecting UTF8 works for me when the file is saved as a .csv utf8 format.

Alternatively you could try to save it as .txt file and upload it this way.

Thanks,

Usman

Nikita_S_Gnilozub

Hello to those from the future in case you are experiencing the same issue.

I had to bang my head against the same problem.

The culprits were line breaks (somebody pasted headers with enter signs) and a dot in the columns. After I removed the dots and removed line breaks (so that it's all in one line when you click into the excel cell) Anaplan finally recognized it all fine.

Clearing the data sources had nothing to do with it.

Good luck!

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…