WCS SWM Demo Postgres job

[aleksa-krolls]

Develop 1 job to map Rural Consumption Kobo form to Postgres Database

1. Sample data

• For new State.json see https://github.com/OpenFn/wcs-consocsci/blob/master/sample_data/ruralConForm.json
• I've submitted one Kobo form to OpenFn already: https://www.openfn.org/projects/1767/messages/7644977
• Link to Kobo source project & form: https://kf.kobotoolbox.org/#/forms/aopf2bJ4cVqEXCrjnwAoHd/landing

2. Mapping specifications

• See this GoogleSheet for specifications: https://docs.google.com/spreadsheets/d/1VzXjbab2HoU-QChLac0RHFENV2FGUWEU3MXC5tklHL4/edit#gid=1486178795
• Feel free to comment in the specs or chat at me on Flowdock for questions

3. Destination DB

• Jonathan/Steven have shared these creds (see email/ Flowdock)
• Usman (on email chain) can help us answer any DB or mapping questions (but be mindful of language barrier–so be super clear with any questions... and I find emailing him directly to be the most effective)

Keep me posted on how I can help!