WP7 Data Export process

[marshalc]

Provide a csv extract of data for WP7 to ingest with the following information:

(from email 23-05-2917@13:10)

a CSV export function for BP to share data with WP7
Import data set WP4>WP7:
·        Sample process – type (blood, urine, perfusate, biopsy) STATIC
·        Sample sub-type (sample code i.e. DB1, DU1, P1, etc.) STATIC
·        Trial ID - STATIC
·        Barcode – VARIABLE
·        Date and time of collection - STATIC

[marshalc]

Duplicate of #293

[marshalc]

Produce a minimalist dataset for populating information in the WP7 DB

- Sample process – type (blood, urine, perfusate, biopsy) STATIC
- Sample sub-type (sample code i.e. DB1, DU1, P1, etc.) STATIC
- Trial ID - STATIC
- Barcode – VARIABLE
- Date and time of collection - STATIC

This is essentially four downloads rolled into one - the four sample types need iterating over slightly
differently to get the same information out of them.

[marshalc]

Interpreted as:

writer.writerow([
        "sample.event.get_type_display",
        "sample.event.get_name_display",
        "sample.person|organ.trial_id",
        "sample.barcode",
        "sample.event.taken_at",
    ])

[marshalc]

VERY slow though. Too slow to be deployed in this state, so need to now work on optimising.

[marshalc]

Admin page layout need modifying so upload and download are better laid out.

[marshalc]

... and today it is lightning quick when tested...

And spacing now adjusted.

[marshalc]

Will send a sample of the export file to BP and RK to test.

[marshalc]

Added extra type field for Blood and Tissue