search

onaio / reveal-frontend

WebUI for the Reveal epidemiological surveillance platform
8 stars 4 forks source link

CSV import of arbitrary jurisdiction metadata #909

Closed moshthepitt closed 4 years ago

moshthepitt commented 4 years ago

We want to create a simple Formik form that takes a CSV file upload.

The CSV file will contain these standard fields:

Any other field that the CSV contains will be considered to be metadata for the jurisdiction that it is attached to.

On submitting the form, we will use papaparse to convert the CSV to JSON and then submit it using the OpenSRP server service so the OpenSRP server settings API endpoint.

This is part of https://github.com/onaio/reveal-frontend/issues/892

moshthepitt commented 4 years ago

If a row/record in the CSV file does not have jurisdiction_id then it should be ignored

moshthepitt commented 4 years ago

Some extra info from a slack conversation with Roger and Sam K:

A sample CSV file may have these columns jurisdiction_id, jurisdiction_name, risk_2019 and another may have jurisdiction_id, jurisdiction_name, risk_2019, target_2019 etc. All of the values in the columns not named jurisdiction_id or jurisdiction_name will be uploaded and attached to jurisdictions (and will overwrite anything previously uploaded).

When uploaded, the name of the metadata field on the description will be prefixed by something so that the web app can identify such metadata and make its retrieval possible. So this means we will be able to present a list to the user of metadata that was previously uploaded, and should they want, we can allow them to view or download the metadata

Naima-Bashir commented 4 years ago

This has failed QA. image @gmwasi @moshthepitt

moshthepitt commented 4 years ago

@Naima-Bashir do you have more details?

Naima-Bashir commented 4 years ago

@moshthepitt https://github.com/onaio/reveal-frontend/issues/940
here is a more detailed issue