ESdat Handy Hint – Managing Chem Codes EScIS (the producers of ESdat) provide a comprehensive list of unique ChemCodes with the installed version of ESDat to help clients manage the myriad of chemicals encountered in the Environmental and Earth Sciences.
While we try to keep with list as complete and up to date as possible with each ESdat release, clients will may require management of data associated compounds not previously included with ESdat or may wish to manage certain chemicals in a specific manner.
The Access version of ESdat allows clients to effectively maintain a 'master' copy of the zRef_Chemistry_Lookup table (where ChemCodes are stored) by several ways.
Copying from one project to another.
The first approach uses an existing project with an updated zRef_Chemistry_Lookup table that can be applied to new (other) projects.
- From an existing source project (database), export the zRef_Chemistry_Lookup table as an ESdat Data Interchange File (EDIF)
- From the existing (source) project, select:
- File --> Export --> Create Data Interchange File
- This will open a dialogue box to allow the selection of the Data (Tables) you wish to export from the project (Note - this step can be completed for any data table, not only zRef_Chemistry_Lookup)
- Save the EDIF at a convenient location
- From the new (destination) project, select the Import View and click the Data Interchange File button
- Navigate to the location of the EDIF
- An import template will be populated from the EDIF
- When importing (via Add-Ins and Upload Data), select Add New & Update Existing from the Record Action drop down list
Alternatively, zRef_Chemistry_Lookup data from the source project could be copied directly into an appropriate destination project import template.
This can be completed as follows:
From the source project, select the Import View and scroll down the All Data Tables list to zRef_Chemistry_Lookup table
- Highlight zRef_Chemistry_Lookup table , check the Populate with Imported Data check box
- Click Generate for Selected to create an import template that contains the entire contents of the zRef_Chemistry_Lookup table
- From the source project select Data Tables – zRef_Chemistry_Lookup. Export to Excel
From the new (destination) project, select the Import View and scroll down the All Data Tables list to zRef_Chemistry_Lookup table, creating a blank import template
- Copy the previously exported into the blank import template
- Import the zRef_Chemistry_Lookup to the destination project (via Add-Ins and Upload Data), again selecting Add New & Update Existing from the Record Action drop down list
A third method of managing ChemCodes is to develop a template project database that can be used to set up each new project.
New installations of ESdat use EScIS_Environmental_and_Hydrogeology.mdb and EScIS_Environmental_and_Hydrogeology.esd as the template database for all new projects. Both files (mdb & esd) are located within the installation folders.
Both files can be copied, renamed and saved within the Corporate Templates directory (which is generally located within the ESdat Network Directory) or in an Ad-Hoc Template Directory. (Avoid using the installation folder as template may be lost if ESdat updates are installed).
Once saved, any matching file pairs (i.e. matching .mdb and .esd files) can be selected as the basis for creating a new ESdat project.
To edit this database, open from within ESdat (File --> Open --> Other) and import/edit data as per a normal database. Typical edits may be to customise the Chem Group and output units in the zRef_Chemistry_Lookup table, or to import standards (i.e. guidelines) that will apply to all new projects.
It is important to avoid importing site data to the template database as it will be present in all new projects created with that template.
For guidance on importing data to ESdat projects:
For guidance on setting up project directories and templates:
With this handy hint, we hope some ESdat Access users can spend more time analysing and less time organising!