Import CSV Problem?
Import CSV Problem?
I am trying to import a csv file into Appgini. What I have done is exported the csv from table view and then added the text i need to the exported csv. When I go to import it back in everything looks OK in preview but every time it only imports 2 records. There is 1200 records in the csv file. I also checked with phpmyadmin and there is only 2 records in there also. I did notice that the ID is increasing. If I add a third record the ID is 2798 so the import done something but nothing displays. I don't get any errors on import, it says import successful.
Re: Import CSV Problem?
First thought that comes to mind is there may be an issue with something you typed in when you added text. Without seeing the app and having more info it is very tough to know. Another guess is you have exceeded the length of the fields with what you are typing in. Example - you have a varChar field of length 40 and you are putting in more than 40 characters.
I would need to see more information before venturing any other sort of guess.
Alan
I would need to see more information before venturing any other sort of guess.
Alan
Calgary, Alberta, Canada - Using Appgini 5.50 -
Re: Import CSV Problem?
Agree with Alan that it's hard to comment without seeing the actual CSV but have you checked the "Show advanced options" on the Appgini CSV import page? Make sure your field separators and delimiters match the CSV format of the file being imported? Increase the "Maximum characters per line" if necessary, depending on what it is you are importing?
If your import only imports 2 rows, I would perhaps be looking at Row 2 or 3 or your CSV for something causing the error? Perhaps some characters in the text you are manually adding that may be affecting the field separators/delimiters and causing it to stop at row 2?
Can you successfully import the unedited exported file back into your Appgini app before you add your text? That would at least let you know that it is something in the text you are adding that is cause. Only guesswork but somewhere to start perhaps?
If your import only imports 2 rows, I would perhaps be looking at Row 2 or 3 or your CSV for something causing the error? Perhaps some characters in the text you are manually adding that may be affecting the field separators/delimiters and causing it to stop at row 2?
Can you successfully import the unedited exported file back into your Appgini app before you add your text? That would at least let you know that it is something in the text you are adding that is cause. Only guesswork but somewhere to start perhaps?