Page 1 of 1

trouble with csv file leadloader

PostPosted: 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

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

PostPosted: Mon Jan 28, 2008 6:18 pm
by Michael_N
mflorell wrote:What is the full name of the file?

test.csv

PostPosted: 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.

PostPosted: 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

PostPosted: 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!