Aquantify

Help updated for Aquantify v3.2.0.254

Import result files

Use Data > Imports to upload spreadsheet or CSV result files and review their processing.

Import dialog showing Organisation, File, Parse only and Import
Select the organisation whose mappings match the file.

Upload a file

  1. Check that the organisation’s lab identifiers and import column mappings are configured.
  2. Open Data > Imports and click Add new.
  3. Select Organisation.
  4. Use Select file to choose an XLSX, XLS or CSV file.
  5. Enable Parse only if you want to review the parsed rows before continuing the import.
  6. Click Import. The file is uploaded and queued for processing.

Review processing

Search the import browser by Date imported, File name, Testing organisation or User. Review Status, Total count and Imported count.

Select an import and open More > Go to rows to review rows and validation messages. A parsed import offers Continue import; rows also offer re-validation and importing selected rows as new.

Use Go to results or Go to issues where available to review the records produced by the import.

Prepare matching first

Check the supplying organisation’s identifier attributes and Import column mapping. Confirm codes on the actual parameter and sample point records and compatible method units. Use Parse only for a validation review that should not submit results.

Organisation mappings define the file headings used during parsing.
Organisation mappings define the file headings used during parsing.

Review status and rows

Open the import record after processing and read its status and row messages. Correct unknown codes, unsupported values or method/unit mismatches before the intended submission. Search Events for the same processing period if an error needs investigation.

See Complete setup and troubleshooting example.

Browse or search all help topics →