Legacy: "All Form Activity" CSV Export Options

• About
  • Metadata Columns
  • Header Blocks
• Export Delivery
• Header Options
• Advanced Options

NOTE: This is a legacy feature for the All Form Activity view. This feature is no longer generally available.  

About

This page discusses exporting data as CSV from the "All Form Activity" page.

Please note that this CSV Export does NOT support exporting data from Repeatable sections. To download data from Repeatable Sections, perform a CSV export from a Submissions (by Form) page.

Note: If you are exporting a very high volume of submissions (for example, over 25000 submissions in a single export), depending on the size of your form, the export can take minutes to hours to complete.  If export takes too long, try filtering the results to export a smaller group of submissions.   We also recommend scheduled exports and data destinations, which can be used to automate the export of data to email or other systems on a regular basis, so that the regular export of large amounts of data becomes unnecessary.

Export Delivery

• Download Now:  This is only recommended for smaller exports, as large exports can result in long wait times.  This option opens a pop-up window; when the export is complete, open the file.
• Receive an email with a link to download: The system sends you an email when the download is complete. 

Header Options

Do you want a header?

Choose Yes to display column headers above the rows of submitted form data. Choose No to turn headers off. Your header row can be one of two options:

• Question Text - uses the actual text of each question in your form
• Question Unique Identifierl - uses the shorter Unique Identifier for each question in your form. You set up the question Unique Identifier when you add the question to the form..

Advanced Options

• Language: Choose what language metadata columns will appear in: English, French, Spanish, or Japanese.

• UTF-8 encoded: Special characters in TrueContext-generated CSV files might display incorrectly when opened in Microsoft Excel. Excel does not recognize UTF-8 encoded CSVs and may display them with the wrong encoding (i.e., "Stéphane" may display as "Stéphane"). To ensure data with special characters is imported properly, disable this option. For detailed information, please read: Display Accented Characters in TrueContext-Generated CSV Files

Metadata Columns

Select the metadata columns to include in your CSV export. These columns include additional information about your dispatched or submitted forms. The following image shows how to add or remove metadata columns.

You can add any of the following metadata columns to your CSV export:

• Address—Street address of the location where the user submitted the form.

• Data Record Name—Name of the dispatched or submitted form.

• Device Entry Time—Date and time when the mobile user submitted the form on the device. The date and time is shown in the mobile user’s local date and time.

• Device OS—Operating system of the device from which the user submitted the form.

• Device OS Version—Version of the operating system.

• Execution State—Indicates if the system successfully executed Data Destinations A Data Destination specifies where to send data from a submitted form. You can use Data Destinations to automate data sharing and storage, routing data to a specific service (such as email or cloud storage) in several different formats. and other processes related to the submitted form. This column is included by default.

• Form Name—Name of the form.

• Form Submission Status—Status of the dispatched or submitted form within your workflow. This column is included by default.

  Info:The topic Form Submission Status: Form Submission status descriptions describes each Status in more detail.

• Form Version—Version of the form.

• FormSpace FormSpaces are where forms are stored and organized in the TrueContext Web Portal. A TrueContext Team may have multiple FormSpaces, depending on their needs. Admins can set FormSpace permissions to control which users have access to the forms in that FormSpace. Name—Name of the FormSpace where the form is stored.

• Local Submitter Entry Time—Date and time when the user submitted the form. The date and time is shown in your local date and time.

• Location—Coordinates of the location where the user submitted the form. Coordinates are shown in a latitude | longitude format.

• Mobile Application Version—Version of the Mobile App.

• Reference Number—Data ID and date of the dispatched or submitted form. This column is included by default.

• Server Receive Time—Date and time when a submitted form reached the server. If the form hasn’t been submitted, it shows when the form was dispatched. The date and time is shown in your local date and time. This column is included by default.

• User Name—First name, last name, and username of the user who submitted the form. This column is included by default.

Header Blocks

Choose whether to include a single header block, or multiple header blocks. 

• Multiple: If submissions from multiple forms are included in the export, headers for each form will be included, and submissions will be sorted into groups by form for easier viewing.
• Single: Only the headers from the Master Form will be included.