Support is online

Export RsForm Submission #8038

Open erStaranta opened this topic Monday, 15 February 2016 · 8 replies
Author

Hello,

is there any way to export to RsForm submission?

Thanks a lot in advance!

Support

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?

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

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!

Support

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.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

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!

Support

Hello,

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

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

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

Thanks for your support!

Support

Hello,

I will email you the plugin.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Thank you very much!

Log in to reply to this topic.