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:
- Navigate to the Databases.
- Select the Database where you want to import the XLSForm.
- Click on the “Import XLSFormBeta” button.
- 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.