Can I import a pipe delimited fil?

(Tslater) #1

Hi,


We currently have a csv datasource to upload values from Excel.



Unfortunately, some of our data fields have commas in them, so the parsing messes up and we can no longer use it.



I'm trying to find other ways to upload the file to the cms, but have come up with a blank. Is there a way to import a pipe delimited file, or import XML from a file (not a URL).



Thanks for any assistance you can give.



Cheers,

Tys.

(Rhulse) #2

[quote]


Unfortunately, some of our data fields have commas in them, so the parsing messes up and we can no longer use it.

[/quote]



Hi,



This is a bug, somewhere.



Have a look at your CSV and check that the fields with commas inside them are double quoted. Fields with commas, quotes and double quotes according to the spec should be double quoted. (Double quotes in field should be escaped with a double quote.



e.g.



Field one, field two, “field three, with a comma”, field four



If these fields are not quoted then the CSV is broken.



I have checked the Matrix import code and they are using the according to the spec correctly, so my guess is your CSV is at fault.





Cheers

Richard

(Tslater) #3

[quote]
This is a bug, somewhere.

[/quote]



Hi Richard, yes there was a problem with our export from the cms, and Excel cell data types. All sorted now.



Thanks for pointing me in the right direction.



Cheers,

Tys.