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?
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
CSV Transfer not dong anything.
Re: CSV Transfer not dong anything.
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?
Any ideas why nuBuilder can't import that part 1 file?
-
- nuBuilder Team
- Posts: 4299
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 445 times
- Contact:
Re: CSV Transfer not dong anything.
Have you done this?
Also open nuDebug results (CTRL+SHIFT+D) and check your (Apache) server logs.
Re: CSV Transfer not dong anything.
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.