trouble with csv file leadloader

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

trouble with csv file leadloader

Postby Michael_N » Mon Jan 28, 2008 4:20 pm

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
Michael_N
 
Posts: 687
Joined: Wed Jul 05, 2006 3:13 pm
Location: sweden

Postby mflorell » Mon Jan 28, 2008 5:44 pm

What is the full name of the file?
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby Michael_N » Mon Jan 28, 2008 6:18 pm

mflorell wrote:What is the full name of the file?

test.csv
Michael_N
 
Posts: 687
Joined: Wed Jul 05, 2006 3:13 pm
Location: sweden

Postby mflorell » Mon Jan 28, 2008 10:53 pm

Had you tried tab delimited?

It looks like your format is not true CSV since there are no Quote qualifiers.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby Michael_N » Tue Jan 29, 2008 10:38 am

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
Michael_N
 
Posts: 687
Joined: Wed Jul 05, 2006 3:13 pm
Location: sweden

Postby rajeevpn » Tue Jan 29, 2008 1:04 pm

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!
rajeevpn
 
Posts: 48
Joined: Wed Aug 16, 2006 7:42 am


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 158 guests