I have received some csv/excel files exported from EQuIS, how do I import them into ESdat?

There is no single common export in EQuIS systems that has a common set of csv files and reference values, so there isn't a one size fits all approach to transferring EQuIS files between systems, which means that some data mapping is required - and that also applies when importing the various EQuIS exports into ESdat.   There are however typically some commonalities such that a general approach can be adopted, described below.

Unless you are experienced in performing data migrations from EQuIS you can expect it will take a few attempts to get it correct, so plan on a few practice runs and doing data validations in ESdat prior to importing.  

Firstly, determine which csv file types have been provided, typically these will include those listed below, and guidance for importing these is provided:

EQuIS csv or Excel sheet types:

From the above, identify which ESdat tables you will need in order to import the data and generate an appropriate ESdat Excel Import Template.  The ESdat Table Names for each Data Type are given below:

Generate an ESdat Import Template for these Tables.  Click Data Migration - New Import - Other and select the Tables you have identified you will need.

This will generate Import Templates for these tables in the browser.  From the menu shown below you can select "Excel Template", which will create an Excel file into which you can copy the EQuIS data.  Select this.      

You will now need to copy the data from the EQuIS data files into the ESdat Excel Import Template.  Data Mapping from EQuIS to ESdat for columns typically included in EQuIS exports is below. Additional columns with data may be included in the EQuIS export, to import that data you will need to assess the most appropriate column in ESdat to copy the data into.  

Locations

Wells

*Note EQuIS exports typically dont include the screened interval for each Well/Piezometer but this may be included in seperate "Well Construction" files/sheets. It can be challenging to identify which screened interval relates to which Well/Piezometer, the data provider should be contacted for clarification if needed.

Chemistry Samples and Results

Chemistry Sample Fields are given below:

Where the EQuIS export has Samples and Results exported as seperate files/sheets the Sample information generally maps to the ESdat Chemistry_Samples import sheet, and the Results information generally maps to the ESdat Chemistry_Results sheet as in the table below.  

Where the EQuIS export has a mix of Sample and Result fields (eg if you have a BasicChemistry or FieldChemistry EQuIS EDD) the sample information will need to be copied into the ESdat Chemistry Samples sheet, one row per sample (ie remove any duplication), and the Result information coped into the ESdat Chemistry Results sheet. 

Chemistry Sample Data

Chemistry Result Data

Water Levels

Geology

Other

The above are the most common data exports provided from EQuIS.  Both EQuIS and ESdat support additional data tables, and data columns in the above tables.  Mapping of other data will need to be done after considering the data exported from EQuIS and the Import Templates available in ESdat.