Importing existing survey data

Описание: If you come to mWater or Solstice with an existing survey, whether that's on paper, in a spreadsheet, or another system, you can always import that into our platform with a few steps.

2:00 Basic Survey Import
10:45 Sites
13:45 Site Import
23:30 Linking Sites and Surveys


Slides: https://www.canva.com/design/DAEUgIY_...

The key steps are:
1) Design the survey in the Portal
2) Create a Deployment
3) Download the survey import template
4) Fill the template
5) Upload the template through survey responses

With this method you can bring in water point data, water system data, data on sanitation, hygiene or any other topic as long as you've created an appropriate survey to hold that data.

You can learn more about creating surveys in mWater and Solstice here:
https://portal.mwater.co/#/resource_c...
https://solstice.world/#/resource_center
The survey designer is flexible and can handle many types of questions in long and complex surveys.

If your survey contains geolocated data on infrastructure such as water points, water systems, schools, communities, and health facilities, we recommend you split off that infrastructure data into Sites in our system (lean more about Sites here: https://portal.mwater.co/#/dashboards...)

Using sites has a number of benefits including:
Less work for you. You only need to map the site data once, not over and over again for each visit to the site.
Easy tracking of data through time. Just link your surveys to the sites and you can build a longitudinal view, for example from project conception to completion and monitoring visits. Or just routine
Everyone can benefit from infrastructure being mapped and shared, if you set the permissions to Public or Protected.

The key concept is to have an appropriate site question in your survey and use that to link to the site with the site's system-generated Unique ID.

Following from the above, here are the basic steps to import sites and link them to surveys:

1) Download the Site import template
2) Fill the template and import the sites
3) Take note of the Unique IDs for those sites
4) Include the site question in your survey
5) Map over the site Unique IDs to this question and fill in the survey template
6) Import the survey data

Follow us on Twitter:   / mwaterco  
Facebook:   / mwaterco  
and LinkedIn:   / mwater  

And get in touch via [email protected] and [email protected]

Check out Solstice, mWater's sector-agnostic sister brand:
https://solstice.world