DMXzone Data Importer Support Product Page

First column of the first record is not receiving a value, everything else works great.

Reported 15 Oct 2018 21:44:25
1
has this problem
15 Oct 2018 21:44:25 Lee Woolsey posted:
I am importing a .csv file into a MySQL table. Everything works perfectly... except the first column of the first record does not get the import value


0364050,103,Ambriz Sanchez,Jesus,Ambriz,KG,20180904,M,12/22/2012,na, ,2031,31ambrij@xxxxxxx.k12.or.us
0340826,103,Acosta-Lopez,Jesus,Chuy Noe,02,20180904,M,09/17/2010,email@hotmail.com, ,2029,29acostj@xxxxxxx.k12.or.us
0344255,103,Ahumada,Iliana, ,02,20180904,F,07/08/2011, ,email@xxxxxxx.k12.or.us,2029,29ahumai@xxxxxxx.k12.or.us
0361946,103,Alba Lopez,Evan, ,KG,20180904,M,06/01/2013,email@hotmail.com,email@live.com,2031,31albale@xxxxxxx.k12.or.us
0347152,103,Allen,Isis, ,02,20180905,F,04/18/2011,email@ymail.com,email@gmail.com,2029,29alleni@xxxxxxx.k12.or.us


My CSV file does not include a header row, I have tried deleting several rows, in case there was something about the first record causing the issue. When I do this, the first field of the first record still does not receive it's value. I have no trouble with any other record in the set (a total of 5140 records), just the first value of the first record.

Reply to this topic