XLSForm Parsing and Upload

Org Admins should be able to create XLSForms and Upload them to the Cadasta Platform when creating project to define the data schema of their project

Detailed Description

Users need to be able to upload data into Cadasta from GeoODK. GeoODK uses the XLSForms standard in the creation of its mobile survey forms. When creating a project (for version 1 release) it is required you upload an XLSForm in order to define the data schema of your project. Cadasta will provide default forms for users to use (for the initial release this will be via a github project of survey forms).

User Stories

Upload New Form

1. Org admin selects "Create New Project"
2. Org admin enters detailed project information including uploads XLSForm
3. After Org admin has finished creating project they press "save"
4. XLSForm is parsed and project attribute schema is created

Re-Upload Form

1. Org admin/Project Admin selects "Edit Project Details"
2. Org admin/Project Admin selects "Reupload XLSForm"
3. Org admin/Project Admin selects "Save"
4. XLSForm is parsed and project attribute schema is updated

Creation of Project Attribute Schema

When a form is parsed it adds the custom project attributes to the project. There needs to be a way to know if the attribute should be part of the Location, Relationship or Party. For Version 1 the following logic will be used:

• For location "l_" will be put in front of the name in the XLSForm
• For relationship "r_" will be put in the front of the name in the XLSForm
• For party "p_" will be put in front of the name in the XLSForm

**Note:**XLSForms that change the field type the user should be warned that they can't change the field type.

Field Mapping from XLSForm Types to Cadasta data types

• integer: integer
• decimal: decimal
• text: text
• select_one: text
• select_multiple: text
• geopoint: for location already the spatial unit
• geotrace: for location already the spatial unit
• geoshape: for location already the spatial unit
• date: date
• time: time
• dateTime: timestamp

file type data types such as images, audio and video do not need to be put into the data schema since they will be handled as resources in the Cadasta platform

For the initial version release the form needs to have the following types in it with the prefix (l_, r_, p_)

• Location: type, geometry
• Relationship: type
• Parties: name, type

Ancillary Information

• Version 1: XLSForms must be uploaded as part of project creation. User can upload one form per project; future versions will support more forms per projects, this should be considered when implementing the data model.
• Version 2: Users will be able to reupload forms to add additional fields to the project data schema
• This process also will create mobile data collection forms for GeoODK

Dependencies

Project creation wizard

Wireframes

Project Creation Wireframes