Automatic export

I second that ??

it’s an interesting idea,but I don’t have plans to make something like this possible within the plugin.

It is possible to set up something like this on your server. You may need to get the help of your web host to write a short script to export the content of the main Participants Database table and email it. The data will be raw, however, so depending on what you want to do with it, you may need further processing to make it usable.

Thanks @xnau.
I was thinking about doing that but I didn’t find where the data is saved. Could you help me?
Thanks.

The records are stored in a separate database table in your WordPress database. It’s usually named “wp_participants_database” but the “wp_” part could be different in your case.

Great,
thanks!

stefania_it, I thought you might be interested to hear what I’ve been working on to automate imports of CSV data. I know you want to automate exports but that may also be possible (and is the next thing I need to work on, so I do hope it is!).

I’ve been putting together a PHP cURL script which logs in to the wordpress admin panel and POSTs the necessary data & file to the PdB CSV import page, allowing PdB to take care of the import itself. The script could then be run on a cron and stored in a protected directory or possibly above the web root, to keep the login details safe.

I haven’t started to play with the export automation yet, so will need to figure out how/if it is possible to get the file to save to the server (from where it can then be emailed or whatever) rather than the download prompt. Hopefully the file will be returned to the cURL script and can simply be handled from there, but I’m not very familiar with cURL yet so this is a wild guess!