Export as file
Jadu Central provides an action for creating a CSV or XML file of each submission, containing only the fields that you choose.
In order to use the Export as File action, you'll need to create a template, which tells Jadu Central how to convert information from the form into a XML file.
Export as file template
- Open a form, and navigate to Templates in the top navigation bar.
- Click the Create Template button. A window will open, asking which type of action we want to create a template for.
- Choose Export as File under the "File Output" section, and click the Next button.
- Enter a title, and click the Next button.
- Select the type of file to export and update the file settings as required. Click the Next button to proceed.
- Select the fields to include in your file. You can either choose all fields, or custom. Choosing custom will allow you to select exactly the fields you want to include. It is possible to include question answers, standard form data such as the Form Title or the value of logic formulae. To include most fields, click Select All and then uncheck any you do not want to export. Once you've selected each field you want to export click the Next button.
- Select a connector to use to transmit the exported file, or create a new one. Then click the Save button to create the template.
XML file settings
| Field | Notes |
|---|---|
| XML Template | The body of the XML document |
| Field XML | The XML markup for each field. |
When completing these fields, you can use the following placeholders:
[FIELD_XML]- one or more instances of the Field XML template, with all placeholder populated.[FIELD_NAME]- the name of the question or variable.[FIELD_VALUE]- the question answer or variable value.
CSV file settings
| Field | Notes |
|---|---|
| CSV Header | If checked, the CSV file will contain the field names above relevant columns within the first row of the data file. |
| Field Terminator | A single character used to separate fields. Defaults to comma (,). |
| Line Terminator | Choose a line ending type, from Windows (\r\n), Linux (\n) and OSX (\r). Defaults to use the Windows option. |