Openrosa for call centers

Slides of the 'Openrosa for call centers' talk at CSVConf 2014, Berlin.

Transcript

1. Openrosa for Call Centers Olaf Veerman CSVConf 2014, Berlin @obirdman | olaf@flipside.org
2. Outline 1. Openrosa 2. Airwolf 3. Lessons & challenges
3. Openrosa An ecosystem of tools that use an open-source and standardized format to build forms and collect, manage and analyze data.
4. Openrosa tools • OpenDataKit - opendatakit.org • Enketo - enketo.org • Formhub - formhub.org
5. Airwolf Built for Text to Change, Airwolf helps manage the data collection process of their call center. Difference with the other tools: • tight integration with respondents • access levels moderator vs. enumerators
6. Openrosa forms Subset of Xform, form definition and results are stored in XML. Form builders that enable collaboration around form design for non-technical users.
7. Lessons & challenges Repeat groups Converting a structured format (XML) to a flat file (CSV) Solutions used (all limited): 1. each repeat group in separate sheet (xls); 2. repeated columns; and 3. denormalized export of specific repeats.
8. Lessons & challenges Data exports 1. Different people, different needs. 2. CSV is still an issue for some. Performance For example with cascading selects.
9. Lessons & challenges Change mindset Openrosa form design is not about 1:1 conversion of paper-based survey. More possibilities: 1. media, GPS 2. (dynamic) constraints, skip logic
10. Olaf Veerman @obirdman | olaf@flipside.org More info flipside.org/projects/airwolf Github github.com/flipside-org/aw-datacollection Thanks!