Automating the posting of results requires:
- login to the web site
- a file in .csv format with column headings (not necessarily in this order):
| entity_type | entity_id | analyte_name | analyte_value | analyte_unit | analyte_source |
- entity_type: always "node"
- entity_id: the Content ID of the Water Sample tested for the analyte
- from the Navigation Menu choose Field Trips
- select the appropriate field trip (date - sampling group)
- all the samples (sites) of the field trip are listed, with their Content IDs
- analyte_name, analyte_value, & analyte_unit: from the file containing the report submitted by the laboratory
- analyte_source: usually "C" for CARO Lab
To import the .csv file:
- using the Admin Menu choose Structure > Webforms > Forms
- select the Analyte form
- from the drop-down Tabs on the form select "Results"
- from the submenu select "Upload"
- "Browse" and upload the Submission CSV file, and select "Continue"
- Carefully examine the Review mapping to be sure all above fields are represented
- Check "Treat all warnings as errors" and "Yes, I want to import these submissions", then "Import"
- Carefully examine the resulting message concerning the number of transactions processed, and particularly whether any were skipped (none will have been updated, because no UUID is included - see Correcting Analyte Posts).
The accepted format for reporting results from samples sent to a laboratory like CARO Analytical Services is Portable Document Format developed by Adobe, known as PDF. This provides only a difficult method of uploading a batch of results to this web site, so in most cases other derivative sources from CARO have been used.