In this lesson we'll go over how to upload historical lab data for your project.
On the side menu click the “Data” tab. You will see the different Media types you have selected for the project. For this example, we are going to use groundwater, however, all the media types behave and function similarly. We will click on “Lab Data” under the groundwater section. You will see a “drag and drop” upload box and a “select a file” icon within that box.
There are currently three formats you can use to upload your historical lab data. One format is to download the sample CSV file by clicking the “download a sample CSV” icon and an example csv. file data format will download to your desktop.
Simply clear out the example data in the file while maintaining the file format and structure with the rows and columns. Replace the project name and client name in rows 2 and 3 and when complete, save the file as a .csv and upload back to the platform by either a “drag and drop” into the upload box or selecting the file and uploading the traditional way.
Please note that the Chemical Abstract Service number, the CAS number, must be present and it must match the chemical name. Our system uses the CAS number to identify individual chemical components. Incorrect or missing CAS numbers will result in data mapping errors.
Please also note that sample IDs must match sample locations exactly. Sample IDs are case sensitive.
Another option, if you have been using EQUIS, is to export your data directly from EQUIS in their standard export csv. format. If you do this, you can simply drag and drop the file or upload the file without making any edits.
A third option is that we can also directly upload most lab EIM standard csv. file formats.
To show you how this works, we're going to upload an example groundwater lab data file by simply doing a “drag and drop” upload. Once it's uploaded, you'll see that file shows that it is imported and lists the file name, the time since upload, the upload status, and the email of the person that uploaded it.
We are happy to help you with any historical lab data upload issues you may initially be having. Simply send us your formatted lab data file in our standard format, the EQUIS csv. format or the EMI csv. format and we will trouble shoot any remaining formatting issues and assist you with the historical lab data upload.
That is how you upload historical lab data for your project.