• Beta
Exporting and Importing Dynamic Forms Data
  • 09 Aug 2024
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

Exporting and Importing Dynamic Forms Data

  • Dark
    Light
  • PDF

Article summary

Data from Dynamic Form Checklists on Schedules / ECHs can be exported in Excel format. The export is useful for additional data analysis in Excel. Also, the exported sheets can be used to update / add additional data and then be imported back into IMS, i.e., this way you can make bulk updates to your Checklists.

Exporting Dynamic Form Checklists

Export Formats

You can export Checklist data in one of two formats:

  • Checklist: Data are arranged with one Question/Field per row. 

Example of Checklist export.

  •  Pivoted Checklist: Data are pivoted so that Questions/Fields are columns, sorted by sequence.

Example of Pivoted Checklist export.

Exporting Checklist Data from the Schedules / ECH Main Screen

To export your Checklists:

  • Open the Schedules / ECH Main Screen.
  • Select the desired Schedules / ECHs.
  • In the toolbar click the Export button.
  • Click here to export in your desired format.

Exporting Dynamic Forms Checklist Answers

Exporting Checklist Data from the Dynamic Forms Interface

You can also export the data collected with any Dynamic Form directly from the Dynamic Forms wizard. 

To export Collected Data from the Dynamic Forms wizard:

  • Select the desired Dynamic Form from the Main Grid.
  • Select the Collected Data tab.
  • Select the Answers tab.
  • Click Export

This option will only be shown when there are more than 100 records associated with the selected Dynamic Form Checklist.  All of the Collected Data will be exported.

Dynamic Forms Collected Data export.

Importing Checklist Data

Your Exported (and updated) Dynamic Form Checklist data can be imported back into IMS via the Import Wizard in Settings \ Data Transfer \ Import Data, using either the Schedule Dynamic Forms or Condition History Dynamic Forms import type. Rows for which the Value column is empty, will be skipped by the importer, so not all Checklist questions need to be answered for this import to work.

NoteThe respective templates are also available to download from here, and filled in. 

Importing Checklist Data

 


Was this helpful? Click to add feedback comments

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.
ESC

Eddy AI, facilitating knowledge discovery through conversational intelligence