Resolved Export RsForm Submission

Hello,

There is no RSForms support in CSVI. The only thing that could be used is the custom table export option. This exports a complete table, so you can't do any filtering in CSVI. For more details see the Custom tables export document.

One question though, RSForms has an export option built-in to export submissions, why try to do it with CSVI?

Hello Rolandd,

Yes, I know that there is no support to RsForm in CSVI.
I tried with Custom Tables Export, but RsForm Table is not created in the right mode probably.

It has only 4 columns, and the data are not separated in colums, but in rows.

For example:
row1 | Name | Name:value
row2 | Surname | Surname:value

etc...

In your opinion is there any way to do it with csvi or I need to do the form with sql mapping starting from a sql table that I created manually?

I can't do it from the button export because I need to have a cron for automatically export.


Thanks a lot in advance!

Hello,

I can't do it from the button export because I need to have a cron for automatically export.

That was my suspicion, thanks for confirming

It has only 4 columns, and the data are not separated in colums, but in rows.

That is because of the way extensions like RSForms Pro store their data. It is stored in what we call key/value pairs rather than relational.

In your opinion is there any way to do it with csvi or I need to do the form with sql mapping starting from a sql table that I created manually?

You won't be able to get this out with SQL statements alone. You will need to assemble the data to get the data in one row as shown in the Submissions in RSForms.

In addition you also need to know which fields should be exported. Give me a few days to tinker with this and get back to you to see if we can implement this in CSVI.

Thank you very much for your answers Rolandd.

In these days I will try the mappings in a new table and I will give you a feedback, if you will find a solution, it will be the best and simply solution!

Thanks a lot for your patience and have a nice day!

Hello,

I have build an RSForm! Submission export for CSVI, if you are still interested I can send it to you for testing.

I solved with the mappings of rsform, but I would like to try your solution too, if possible!

Thanks for your support!

Hello,

I will email you the plugin.

Thank you very much!