CSV Transfer not dong anything.

Questions related to using nuBuilder Forte.

CSV Transfer not dong anything.

Unread postby icoso » Fri Jun 11, 2021 1:54 am

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?
icoso
 
Posts: 173
Joined: Mon Feb 08, 2021 7:39 am
nuBuilder Version: 4.5

Re: CSV Transfer not dong anything.

Unread postby icoso » Fri Jun 11, 2021 2:17 am

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?
icoso
 
Posts: 173
Joined: Mon Feb 08, 2021 7:39 am
nuBuilder Version: 4.5

Re: CSV Transfer not dong anything.

Unread postby kev1n » Fri Jun 11, 2021 2:18 am

Have you done this?
Also open nuDebug results (CTRL+SHIFT+D) and check your (Apache) server logs.
kev1n
nuBuilder Team
 
Posts: 1763
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: CSV Transfer not dong anything.

Unread postby icoso » Fri Jun 11, 2021 2:48 am

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.
icoso
 
Posts: 173
Joined: Mon Feb 08, 2021 7:39 am
nuBuilder Version: 4.5


Return to General

Who is online

Users browsing this forum: No registered users and 10 guests