I have imported 30+ csv-files into my Enterprise Pro instance without any problems. Now I have a very small file (400 lines) that resists importing.
In the left hand column of the Data Importer, the sample record of the file does not come out in separate fields, but shows all field(names) on one line, separated by a semi-colon (see Literature2.csv at the bottom):
Tried several times but the result remains the same. Anybody any suggestions? Thanks!
Can you provide the file?
Hi Gary @glilienfield,
Of course, see attachment (.txt with tabs because .csv is not allowed)
Literature.txt (59.1 KB)
In the meantime I suspect it has to do with special characters.
So I replaced a number of them (] [, { }, |, etc.) but to no avail.
I cannot find a list of all "forbidden" characters in the documentation either.
Guido
Weird.
I repeated what you did: read the txt-file in Excel and saved it as csv.
Wouldn't load.
I then removed column C and it loaded fine.
I then added C1 through C4: loaded fine.
I added C5 and it wouldn't load.
I deleted lines 5 through 10: wouldn't load. So I removed everything under line 4 again. Loaded.
Then I tried different texts from other C-cells in C5, even the text in C19 which is very short: wouldn't load.
But when I put the word "test" in C5, it loads.
Can you send me the csv-file you created? One never knows...
Literature.csv.txt (60.2 KB)
I added the '.txt. extension so I could upload it. It is a proper csv file.
Thanks.
Loaded perfectly.
I don't get it, but maybe some things in the Universe are not meant to be understood...
Guido
