Importing Chemistry

The import of chemistry data is not straight forward as it always involves several tables. The “main” table is the chem_000, which stores the sample information, which in turn is linked to the sites. All other tables (chem_001 to chem_006, deteclim and userchem) are linked to the samples table with the CHM_REF_NR field, which is a unique identifier and foreign key.

Therefore, when importing chemistry data, one needs to make sure to create records in the samples table first and then import the results data for the linked tables. Both import processes therefore need the CHM_REF_NR in one of the columns so that the results know to which sample they are linked.

The Help items below explain the imports in more detail.