Error in SQL syntax at import csv file

Hi Pieter,

Are you using the latest version of the plugin? If not, can you please update?

Do you have access to your webserver and MySQL log file? Does it give any useful information?

Maybe you can share an export of your database table and your CSV file, so I can have a closer look at this issue? Please use the contact form on the plugin website if you prefer to send this information in private.

Thanks,
Peter

Hi Peter,

Thanks for your response.

? I use the latest version
? Could not find any information from log

I think there was something wrong with the creation of the Custom Post Types with PODS.
But then I couldn’t find how to map my CSV to the table in WP Data Access, since PODS stores custom fields as meta. I am trying to see if I can change that to table storage in order to get separate tables for the mapping.
POD’s docs aren’t very clear in this regard.
If you happen to be able to help, that would be much appreciated.

Thanks,
Pieter

Hi Pieter,

It is not possible to create CPT’s from a CSV file. You can import CSV files to database tables only, which requires you to create a database table first, then map the table columns to your CSV cells and finally perform the import.

It is possible to skip the table creation and column mapping, but this requires a premium license. You can check out this brand new features here: https://wpdataaccess.com/docs/premium-data-services/remote-connection-wizard/
The remote connection wizard creates your database table automatically.

If you have a premium license or trial version, you can also use the Data Publisher to export your CPT’s. Custom post type queries in the Data Publisher are explained here:
https://wpdataaccess.com/docs/data-publisher/cpt-queries/

Export buttons are documented here:
https://wpdataaccess.com/docs/data-publisher/premium-extensions/

Does this help?
Peter