Repeating Group to CSV and XLS Plugin

Introduction

Exporting your data from your application will be now much easier with our CSV and XML export. This Zeroqode plugin will save every row in a selected repeating group into a downloadable CSV or XLS file with a single click. It will contain the same fields in the same order as they appear in the repeating group.

Exposed States

URL for downloading - type text.
Image without caption

Available Actions

Download File

Download File action has a few fields that have an impact on the output file.
  1. Format - dropdown with two options with the type of downloadable file (CSV or XLS)
  1. Insert RG ID - a dynamic value of a text type. Insert here your Repeating Group ID.
  1. Table captions from - dropdown with two options (Group and Manually). If the Group option is selected, the column's title captions will be taken from the group whose ID you have identified in the “Captions (group ID)” field (below). If the Manually option is selected, you have to type manually the column captions into the Captions (group ID) field below.
  1. Captions (group ID) - a field where you can insert your Group Captions’ ID or type manually captions for your Repeating Group columns.
  1. File Name - a dynamic value of the text type. Type here the preferable name for your resulting file.
  1. Separator - static text. The separator for the CSV file content. By default - it is a comma ‘,’. Required only for CSV file type.
  1. Content surrounded - static text. By default, the entire CSV content is surrounded with double quotes «». When the CSV file type is chosen it is advised to use 'Content surrounded' option to avoid issues. Also CSV convention is that fields containing a comma should be enclosed in double quotes. This way, the comma inside the quotes won't be treated as a separator.
  1. Enable Captions(headers) - checkbox. If left unchecked - the resulting file won’t have column captions.
  1. csv_ignored - is the ID attribute that you can assign to the element that you want to exclude from the resulting CSV file. If you place this ID to the table caption’s text element, the resulting CSV file won’t have this column name. If you place this ID to the RG column’s text element, the resulting CSV file won’t have this entire column.
Once you trigger this workflow action, the plugin will process the repeating group and then return a state with the download URL with CSV named file.
The plugin downloads only the data that is fully loaded and visible in the Repeating Group, available on a page.

Changelogs

Update 13/02/2021:
  • fixed problem with checkbox status (1.18.0): previously, checkbox status was converted to a CSV file as always "true"
Update 06/06/2022 - Version: 1.21.0.
  • minor fixes
Update 27/01/2023 - Version 1.25.0
  • Added possibility with id "css_ignored" ignore column
Update 07/03/2023 - Version 1.29.0
  • updated the plugin for the new responsive (and 21st Bubble version)
Update 13/03/2023 - Version: 1.30.0
  • Fixed Manual table captions
Update 22/03/2023 - Version: 1.31.0
  • added a possibility to ignore an RG from RG
Update 12/04/2023 - Version: 1.32.0
  • Fixed the "Download CSV" action
Update 17/05/2023 - Version: 1.34.0
  • Reforming the text that starts from the new line
Update 02/06/2023 - Version: 1.35.0
  • Added new options: “Save in the file manager”, “Download the file”, “Set column index”.
💡
How to use the “Set column index” feature: If you want your RG’s columns to appear in the resulting CSV file in a specific order, different from the one it renders on the page load, just assign the serial number value to the Column’s title ID field and indicate it in the Download CSV rg-to-csv A action:
Image without caption
Image without caption
Update 05/07/2023 - Version 1.37.0
  • Fixed default display captions
Update 27.07.23 - Version 1.39.0
  • Fixed extension of the uploaded file (firefox)
Update 13.09.23 - Version 1.42.0
  • Minor updates
Update 17.10.23 - Version 1.44.0
  • Added download XLSX action

Use case example

  1. Place the plugin element on the page:
Image without caption
  1. Create a Repeating Group, assign an ID to it:
Image without caption
  1. Create a group, place text elements inside with the names of your Repeating group columns. Assign an ID to this group:
Image without caption
  1. Add a button or any other element that will trigger the RG to CSV action. Assign a workflow to it - the “Download CSV rg-to-csv A” action:
Image without caption
  1. In the “Download CSV rg-to-csv A” action, assign the Repeating group ID into the “Insert RG ID” field, and the ID of your Captions group into the “Captions (group ID)” field:
Image without caption
  1. Add your resulting CSV file and other parameters, according to your preferences.
  1. There are a few ways to get the resulting CSV file: - use the “Open external website” action. It will automatically download the CSV file when the conversion is finished; - use the “Link” element. In any case, you need to use the “URL for downloading” plugin state:
Image without caption

Demo to preview the settings