Export to Database

Dear @bbrdes,

Thank you for the topic.

At the moment, unfortunately, the plugin doesn’t have the possibility to export its tables.

By the way, thank you very much for your suggestion.
All suggestions are welcomed as they are mutually beneficial for all of us.

We will let you know in case there is an update in this regard.

By the way, currently, the only possible solution to achieve this is by going to your cPanel > particular Database and exporting the tables from there.

Thank you.

No problem if individual submission data can be retrieved with phpMyAdmin from the WordPress database. But how exactly is it done? Is it enough to export the ayssurvey_submissions table? Or what else would need to be done? Could you give an example for the SQL query that needs to be run?

Dear @eicken71,

Thank you for your response.

I am not sure I understand your request correctly.
As far as I understand, you want?to select the whole data of both your mentioned table and the ayssurvey_submissions_questions table. This is the reason you want the SQL.

Here is an example of how you can take one submission from that tables:
Please note, that the WordPress_prefix?can be?subject to change,?by default it is written by?wp_.

You need to insert your desired Submission ID instead of the YOUR_SUBMISSION_ID.
You can find it in each submission list table on the Dashboard (Submissions tab).

See the screenshot: https://ibb.co/Yy4QgCk

SELECT * FROM ?wp_ayssurvey_submissions? WHERE id=YOUR_SUBMISSION_ID;

SELECT * FROM wp_ayssurvey_submissions_questions WHERE submission_id=YOUR_SUBMISSION_ID

Thank you.