Import an XLSForm

The XLSForm is a widely-used standard for defining mobile data collection questionnaires. Instead of adding and designing a Form in ActivityInfo, you can import an already existing XLSForm into ActivityInfo.

The XLSForm import function is designed to facilitate data migration from XLSForm-based tools by translating XLSForm questions, choices, and Formulas into ActivityInfo.

How to import an XLSForm into ActivityInfo

Follow these steps to use the feature:

  1. Navigate to the Databases.
  2. Select the Database where you want to import the XLSForm.
  1. Click on the “Import XLSFormBeta” button.
  1. Select the XLSForm file from your device, and click “Open.”

Success, the XLSForm is imported and turned into a Form in ActivityInfo.

Important consideration

By default, a select_one question type in XLSForms is treated as a Single Selection field type in ActivityInfo. However, under any of these conditions, it is translated into a Reference form:

  • The select field contains over 100 choices.
  • The choice list includes additional attributes, commonly used in choice filters, the select field.
  • When your choice list is referenced in another choice filter, a relationship is inferred. As a result, both the original choice list and the referencing choice list is converted into linked Reference forms. When a change occurs in one Reference form, it has a ripple effect or influence on the other Form(s). For example, if you have separate choice lists for provinces and territories, inferring a relationship between them leads to the conversion of both into linked Reference forms.
Next item
XLSForm Support