Exporting Captured Data

When response data has been captured it can be easily exported to a spreadsheet via a CSV(Comma Separated Value) file. Before you export the data you can use the export options to sort it by column name.
Note: You must have an office package such as Microsoft Office or Open Office installed on your computer, to open the exported CSV file in.

Exporting the Captured Data to a CSV File
Exporting the CSV file to a Spreadsheet
Delimited File Export Options

Open the Captured Data Application.

 

 

---

Exporting the Captured Data to a CSV File.

Captured data from your publication can be exported and saved on your computer as a CSV file so it is able to be exported to a spreadsheet.

Choose the Publications tab in the Captured Data application.

 

 

 

 

Click to Select the Publication Name you want to export.

---

Click the Export Data button in the publications panel.

 

 

 

 

 

 

 

A dialog box called Delimited File Export Options will open, where you can choose which columns of captured data you want to appear on the spreadsheet and the order it will appear in.

 

 

 

 

 

 

 

 

 

 

Click OK

Choose a name for your document and a location to save it on your computer and click Save.

A Success dialog box will open.

 

 

 

 

Click OK and the CSV File will be saved and located on your computer wherever you chose to save it.

---

Exporting the CSV File to a Spreadsheet.

Open the newly created CSV File, containing the Captured Data Text Import.

 

 

 

 

 

 

 

 

 

 

Screenshot: CSV file text import

Click OK and the CSV file will be saved to a spreadsheet, which will open in whichever office package you have, installed on your computer.

 

 

 

Screenshot: Captured response Data exported from the CSV file to a spreadsheet.

---

Delimited File Export Options

Choose the order of the columns for exported Captured Data.

 

 

 

 

 

 

 

 

 

The export order of captured data uses the numeric column values given to the column headings. These values revolve around zero.

Columns numbered before zero will appear first, therefor because the numbering of Source Data fieldnames starts at 0 zero and the numbering of your Captured Data fieldnames starts at 1000, when exported to the spreadsheet, the source data fieldnames will appear before the captured data fieldnames.

Deselecting any of the columns in export options, means those columns and their data won't show up in the exported data.

---

Order Columns

 

 

By Order Index - The fieldnames taken from your source data table will be exported using the numeric values of the order index, which was set when you added the fieldnames to your data table.

 

 

 

By Fieldname Ascending - The fieldnames from your source data table would be exported alphabeticaly in ascending order.

By Fieldname Decending - The fieldnames from your source data table would be exported alphabeticaly in decending order.

---

Included Columns In Export

Screenshot of Captured Data exported to a spreadsheet.

---

 

 

 

 

 

Because the Order Index is below zero, the fields, publication_id, form_id and form_score will appear first in the exported data.

 

 

 

---

Because the Order Index of the Data table fieldnames is above zero and below 1000, they will appear after the form_score but before the Captured Data.

 

 

 

---

Because the Order Index of Captured Data is from 1000 and onwards - The Captured Data Fieldnames for each question and the Score_fieldnames (if there was an aggregation rule), will appear directly after the Source Data Fieldnames

 

 

 

---