Support is online

How to export submission from RSForm #8473

Open easysoftware opened this topic Tuesday, 30 August 2016 · 13 replies
Author

Hi,
after instalation RSForm addon I dont see any table when I create new template for export, only CSVI Pro and Joomla

Rudolf

  • ScreenShot2016-08-30at11.27.34.png
  • ScreenShot2016-08-30at11.27.43.png
Support

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.

Kind regards,

Tharuna

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

Author

Of course,
I instaled CSVI Pro and RSForm Addon

  • ScreenShot2016-08-30at12.03.03.png
Support

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

Kind regards,

Tharuna

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

Author

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

Author

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');

Support

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.

Kind regards,

Tharuna

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

Author

Hi,

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

So I think in sql in addon rsfom?

Support

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

Kind regards,

Tharuna

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

Support

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.

Kind regards,

Tharuna

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

Support

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.

Kind regards,

RolandD

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

Author

Hi,
ok, send me the patch after finished.

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

Support

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

Kind regards,

Tharuna

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

Support

Hello,

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

Kind regards,

RolandD

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

Log in to reply to this topic.