Page 1 of 1

CSV Transfer not dong anything.

Posted: Thu Jun 10, 2021 6:24 pm
by icoso
Im trying to import a CSV file with about 9800 records in it. The file is a little more than 2mb in size. When I select the info on the CSV Trassfer screen:
Import from CSV
mydata_data-part1.csv
comma
MYNewTable

And I click the Transfer button, a new window opens, but then nothing seems to happen, its blank. Any idea Why?

I tested this with an previous file that only have about 1000 records in it and it works fine. Any suggestions?

Re: CSV Transfer not dong anything.

Posted: Thu Jun 10, 2021 6:47 pm
by icoso
I split my file into 4 parts. It now imports the files. HOWEVER, I split it into 4 separate csv files. parts 2 3 & 4, import correctly. Part 1 does not. Now all I get are the column headings. no other data is imported from my part1 file. I even tried importing the data directly using MyPHPAdmin and that imports that part 1 file fine, with no problems. All records get imported using myPhpadmin.

Any ideas why nuBuilder can't import that part 1 file?

Re: CSV Transfer not dong anything.

Posted: Thu Jun 10, 2021 6:48 pm
by kev1n
Have you done this?
Also open nuDebug results (CTRL+SHIFT+D) and check your (Apache) server logs.

Re: CSV Transfer not dong anything.

Posted: Thu Jun 10, 2021 7:18 pm
by icoso
I finally got something in nuDebug after I split the records up. I found one of the fields had quotes in it. Just 1. So I deleted the quotes in my csv file and it imported it. Thanks for the help.