CSV Import: not all lines of CSV are imported

By maister - September 28, 2011 - edited: September 28, 2011

Hi,

I've a Excel list that was saved as CSV file. I'm using the CSV import plugin (v.1.03) to import the data into a Table into CMSB (v.2.12). I use the import plugin as follows:
1. Select the CSV file // File format: CSV (German) + select the Target Table which gives me a correct Live Preview (I supose it's normal that not all the lines are previewed).
2. Clicking 'Analyse Data' gives me a correct analyse (status: Done!, Total Records: 150, Total Columns: 8 => correct)
3. I 'choose options': wipe database // start numbering at record 1 // and I Map the fields. I still have a correct Live Preview (again, not all the lines of the CSV are shown, only 11).
4. Than I 'Validate Data' with a Status: Done!
5. Finally I 'Import Data' with result that not all the lines of the CSV are imported ...

I need to import a CSV with 45.000 lines, but I test with 150 lines.
Sometimes the import gives me 18 lines into the table, sometimes 24, ...

I've allready eliminated all empty fields in my test CSV. The table were I need to import in is very basic (all text fields with no Input Validation, ...)

What is going wrong???
Regards, Kristof

Re: [kristof] CSV Import: not all lines of CSV are imported

Hi Kristof,

Just a random thought.

I don't have this plugin, but you mentioned German as the language. Are there possibly illegal or foreign characters: umlauts etc. (or extra spaces) in the csv that might be causing an issue?

Best,

Jerry Kornbluth
The first CMS Builder reference book is now available on-line!







Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php