Welcome Guest, Not a member yet? Register   Sign In
Datamapper - importing csv file and skipping blank cells
#1

[eluser]Unknown[/eluser]
Hi..

I have a program I purchased that is using DataMapper 1.0 to import my data through myphpadmin. Currently it doesn't allow me to skip over blank cells in my csv file, but instead creates a row in the table with the field value being blank. The csv file has 500,000 rows and 30 columns, so it is creating 15,000,000 rows in the table which is causing long queries.

Is there a way to have it skip over the blank cells?
#2

[eluser]WanWizard[/eluser]
Datamapper 1.0? Don't think that ever existed, but if so, it's an antique...

If you're importing through phpmyadmin, you'll have to look at that. Datamapper's import_csv() method does skip lines that are blank...




Theme © iAndrew 2016 - Forum software by © MyBB