Problem with CSV file / Beginner

stephenmcateer posted 3 weeks ago in Import/Export


I'm trying to import data from a CSV file to an existing MySQL database. I am unable to do this successfully. I get various errors. The best I have been able to do it import the correct number of rows but all zeros in the first column and the rest of the columns are full of nulls. I think the problem is with the Control Characters settings in the Heidi import tool. I tried replacing the TAB characters separating the data items in the CSV file with commas but no joy. First two lines of CSV file are:

"race,age,engnat,gender,hand,source,country,E1,E2,E3,E4,E5,E6,E7,E8,E9,E10,N1,N2,N3,N4,N5,N6,N7,N8,N9,N10,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,C1,C2,C3,C4,C5,C6,C7,C8,C9,C10,O1,O2,O3,O4,O5,O6,O7,O8,O9,O10" "3,53,1,1,1,1,US,4,2,5,2,5,1,4,3,5,1,1,5,2,5,1,1,1,1,1,1,1,5,1,5,2,3,1,5,4,5,4,1,5,1,5,1,4,1,4,5,4,1,3,1,5,1,4,2,5,5"

Thanks for any help.

BubikolRamios posted 2 weeks ago

are these " actually in file ?

If so, replace each , with ","

Then it should be generaly doable.

Please login to leave a reply, or register at first.