Create Location Visit test data configuration spreadsheet

[mmannion]

In order to quickly test different scenarios, setup an excel sheet of URL parameters that can be used to quickly create Survey123 custom URL.

To Do tasks:

• [ ] Create excel spreadsheet of all fields and URL parameters
• [ ] Test issue with field names in repeats
• [ ] Confirm the automation of submitting the form from URL parameters
• [ ] Send link / presentation materials for DevSummit test data script

Blockers

• Blocked pending decision about whether we need test data automation at this point in the project
  • Aquarius integration moving faster than expected
  • May be complete with integration development using manually-created test data faster than we can build automated test data solution

[mmannion]

2024-05-20 meeting:

• Custom URL can pre-fill Survey form, but cannot submit survey automatically
• @dbench1 attending internal meeting on automated survey submission tomorrow

[mmannion]

Internal tool, briefed at DevSummit, for handling complex surveys with repeat sections. 20 hour initial setup. Run ourselves afterward.

[dbench1]

Attached are two example scripts for submitting a Survey123 form with repeats

example_s123script.txt survey123_executor.txt

[mmannion]

This task is on-hold due to recent progress on Aquarius integration being ahead of schedule. Will resume if we determine we need more comprehensive test data solution.

Dave (Esri) has offered to meet to discuss test data loading (in lieu of doc) if we decide to continue.