WP Data Access Plug in

That’s bad news! Must be a content issue. I guess there is a quote in your text, and I realize now that the plugin does not substitute those quotes.

Can you check if there is a quote in your CSV content? Maybe you remove it temporarily?

If there is no quote in your content, can you send me your CSV file? Please you the contactform of the plugin website if you prefer to send it in private.

Thanks,
Peter

I have experimented with several methods with mixed results.

I used Excel for a file (SCHEDULE) to save as a common delimited (UTF-8) file and was able to import this file. Before I had used Google Sheets.

My second file (ROSTER) using Excel also still gives me the same error. I can complete the data mapping and preview the CSV file. But get the same error as before. I do not see any quotes in the CSV file.

The SCHEDULE file has a date column, but is all text data otherwise. The ROSTER table has an integer column (GHIN). Otherwise just text. I will send the file privately.

I’ll have a look at Google Sheets. For my tests I used Excel. It should not make a difference, should… ?? Thanks for the tip!

You can use the contactform on the plugin website to send me a message. I’ll reply from my private mail, so you can reply with the attachment.

Thank you for your co-operation!

Best regards,
Peter

Hi,

A short note/update…

Google Sheets works fine with my example. CSV as well as TSV. Be aware that you need to remap when you switch between CSV and TSV. This is fixed in the next release. If you want to use it right away you can download an update from Bitbucket. I guess it is a content issue, so I wait for your CSV file and test again…

Thanks,
Peter

So I created a new table with the same columns as ROSTER. Then successfully imported the CSV file. So there must have been a problem with the ROSTER table.

So all is well. I am closing this out.