See if you can change the format. switch between windows format or mac/linux. it may be a problem with line endings.
I too am running into issues…I’ve tried Mac, Win, DOS, Unicode…nothing seems to work.
I gave up, just used PHPMyAdmin to import the data into the table I created under DB Toolkit.
Also tried the different formats using DostoUninx/UnixtoDos, no change for me.
I’m really glad I found this powerfull plugin, but have problems with the CSV import too.
It’s essential for the website I’m working on that users can import CSV-files to the tables. Any suggestions for a solution?
I confirm the issue. Changing encoding or line endings are not solving the problem.
There is some solution or workaround?
Thanks,
Rickyx
If anyone has a suggestion of some other way to let users import CSV-files to database tables, I would be very thankful.
Like, really thankful. Maybe offer my firstborn son or my collection of pokemon cards..
I have other DB problems, but I would suggest that you add a couple of test records and then export them to see how they get formatted. Then be sure that your csv file is formatted exactly the same way. Should work.
Gary, I have tried that, but it is still stuck at “0: 0 of X entries imported.”. Does it work for you?
sorry for the late post. I did a csv export using this plugin and found that he does not use commas for the delimiter. The fields were delimited by semicolons. Did you try that?
Yes, it doesn’t change anything :/
There’s automatically added an ID-field when importing, could that be the issue? I’ve tried various options like leaving it blank, making a new column for ID and choosing one of the existing columns as ID, but maybe there’s something I haven’t thought of?
