trouble with csv file leadloader

Posted:
Mon Jan 28, 2008 4:20 pm
by Michael_N
I have csv file that looks like this
8,111111,802,46,700180,lastname,surname,adress,11,12632,city,1,2630
When i use customleadloader
It says its pipedelimeted
I have created the file in openoffice
Vhat have i done wrong?
And yes i have read manager manual

Posted:
Mon Jan 28, 2008 5:44 pm
by mflorell
What is the full name of the file?

Posted:
Mon Jan 28, 2008 10:53 pm
by mflorell
Had you tried tab delimited?
It looks like your format is not true CSV since there are no Quote qualifiers.

Posted:
Tue Jan 29, 2008 10:38 am
by Michael_N
mflorell wrote:Had you tried tab delimited?
It looks like your format is not true CSV since there are no Quote qualifiers.
No but i will try that,
and also try with csvfile made with M/S excel

Posted:
Tue Jan 29, 2008 1:04 pm
by rajeevpn
We've found that pipe-delimited works best - particularly when you have csvs generated by oocalc vs those generated by Excel. I'm sorry we haven't dug deeper to see why but pipe-delimited ones work perfectly!