Resolved How to export submission from RSForm

Hello Rudolf,
Can you confirm if you have installed CSVI RSForm addon extension? You can download this extension from CSVI site and in downloads page.

Of course,
I instaled CSVI Pro and RSForm Addon

Hello Rudolf,
Try doing reset of tasks and update of your available fields too.

Hi,
reset avalaible fields I did, but tasks didn't.

Now I update both and voila! I see RSForm

Ok, this topic You can closed.

But now I need add static field (my custom fields with my custom text for every template another).

How can I add custom field (not from table submission) in my template?

ETC:
ID - FormID
COMPANY - cname
CONTACT - name
EMAIL - email
TEL - tel
SOURCE - webform (my custom static text)
TYPE - form_123_export.csv (my custom static text)
NOTE - all another fields from submission table (groupped and set delimiter as - I think only with change code CSVImproved, isn't it?

Thanks Rudolf




Rudolf

Ok, I think I need use this?
https://csvimproved.com/support/questions-and-answers/902-adding-your-own-custom-fields

And for my case is this right? Because I don't see my custom fields after update fileds inside Submission:

INSERT IGNORE INTO `#__csvi_available_fields` (`csvi_name`, `component_name`, `component_table`, `component`) VALUES
('typ', 'typ', 'submission', 'com_rsform');

Hello Rudolf,
Yes, you can update your own custom available fields as explained in the document. Just a small change in the query

INSERT IGNORE INTO `#__csvi_available_fields` (`csvi_name`, `component_name`, `component_table`, `component`, `action`) VALUES
('typ', 'typ', 'submission', 'com_rsform', 'export');

Try and let me know if it works.

Hi,

it works, but you can't say in which files.

So I think in sql in addon rsfom?

Hello,
No, it should go into com_csvi/install/availablefields/. This is also explained in the document.

Hello Rudolf,
I just realised that override functionality for custom available fields doesn't work anymore in CSVI 6 version. I am working on this fix and will send the patch file when it is ready.

Hello all,

Let me clarify one thing, in an earlier post I read this:

SOURCE - webform (my custom static text)
TYPE - form_123_export.csv (my custom static text)

If these fields are static, why not just add them as custom field in CSVI and set a default value. CSVI will then always export only the default value.

The submission export currently only exports what is in the submission table. I never realized that the static texts were not stored as part of the submissions.

Rather than building your own SQL files, I would say just use the custom field, that is why it is there.

Hi,
ok, send me the patch after finished.

In this time i put override inside addon rsform folder and I see my customfiled.

Hello,
The patch file is ready and is attached with the post. You need to load the patch file with CSVI maintenance option and create a file with name override.sql with your custom fields and put it in administrator/components/com_csvi/addon/com_rsform/install/ folder. CSVI will read this file and update your custom fields along with other available fields.
patch_override_2016_09_07.zip

Hello,

Have you tried using the custom field as I described earlier?