Issue on Importing a File

Jsdeloria21
Jsdeloria21
in Integrations and extensibility

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).

Jsdeloria21_0-1578300624684.png

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:

 

Jsdeloria21_1-1578300745576.png

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,

Tagged:

Best Answers

  • VIGNESH.M
    VIGNESH.M
    Answer ✓

    Hi,

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

    #1. Delete the file source in Import data source

    001.png

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

     

    Regards,

    Vignesh M

  • nathan_rudman
    nathan_rudman
    Answer ✓
    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
    nathan_rudman
    Answer ✓
    you might want to open with notepad++ and show special chars
  • Misbah
    Misbah
    Answer ✓

    @Jsdeloria21 

     

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

     

    Misbah

  • usman.zia
    usman.zia
    Answer ✓

    @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

Answers

  • Nikita_S_Gnilozub
    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!

Categories