Categories
View Replies (6)

Resolved RO CSVI - RSForm!Pro to export RSForm submissions

  1. vetsapr
    vetsapr
  2. RO CSVI
  3. Friday, 29 July 2022
  4.  Subscribe via email
Hi,

I am using RO CSVI - RSForm!Pro to export RSForm submissions from my website's frontend. I have made some changes to Example RSForms! Pro Submissions Export included template but after running the template, I have the following issue:

Each of my submissions appears 9 times in the generated xlsx file.

I would also like to know if I could export my submissions to a pdf file. It would be useful for printing.

Thank you!
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
If I export my submissions to html is there some way to customize the output (center filed values, fix field width)? I need this in order to make it printable in a nice way from the frontend.

You can create a copy of HTML helper csvimproved.php in the folder administrator/components/com_csvi/helper/file/export/html/. Give a name like csvimprovedcustom.php. In the custom file change the class name from CsviHelperFileExportHtmlCsvimproved to CsviHelperFileExportHtmlCsvimprovedcustom and save the file. Customise the copied file as needed. You can then select this custom file in export template settings on File tab under Website field. See attached screenshot. Run the export and check.
Attachments (1)
Screenshot 2022-07-29 at 5.27.15 PM.png Screenshot 2022-07-29 at 5.27.15 PM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (6)
vetsapr
vetsapr
Accepted Answer Pending Moderation
Thank you. I will check it out and let you know.
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Each of my submissions appears 9 times in the generated xlsx file.

Please check Group by and Sort by document to avoid duplicates on export.

I would also like to know if I could export my submissions to a pdf file. It would be useful for printing.

We do not support export to PDF file. You can see the supported file types on File tab in export template settings.
Attachments (1)
Screenshot 2022-07-29 at 9.47.36 AM.png Screenshot 2022-07-29 at 9.47.36 AM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
vetsapr
vetsapr
Accepted Answer Pending Moderation
Thank you for your reply!

I grouped by Submission Id and problem is solved.

I have two other questions though.

1. I am exporting my submissions to xlsx. Is there some way to format through RO CSVI - RSForm!Pro the exported excel columns (type, width)?

2. I have a checkbox group field in my RSForm named 'events' where the uses can check two values (Church, Ceremony). When a user checks both options in the form, the corresponding field in the exported xlsx file shows the two values without a space in between (ChurchCeremony).
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
1. I am exporting my submissions to xlsx. Is there some way to format through RO CSVI - RSForm!Pro the exported excel columns (type, width)?

No, you cannot change the formatting of XLSX file in RO CSVI. We use an external library to generate XLSX file. You need to change these formating in the library files and that will be a hack in code.

2. I have a checkbox group field in my RSForm named 'events' where the uses can check two values (Church, Ceremony). When a user checks both options in the form, the corresponding field in the exported xlsx file shows the two values without a space in between (ChurchCeremony).

Yes, I was able to see this using Microsoft Excel and I think it has to do something with the Excel software. If the same file is opened with LibreOffice the values are shown as saved in the database. See attached screenshot. Can you try opening the file in LibreOffice and check?
Attachments (1)
Screenshot 2022-07-29 at 4.35.35 PM.png Screenshot 2022-07-29 at 4.35.35 PM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
vetsapr
vetsapr
Accepted Answer Pending Moderation
Thank you! I am working on a wedding website and I want the couple to be able to view their guest list online, download it for edit and also be able to print it. However, I want to make things as simple as possible for them.

If I export my submissions to html is there some way to customize the output (center filed values, fix field width)? I need this in order to make it printable in a nice way from the frontend.
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!