How to Create an Export Design (ICP-WinLab32)

This tutorial describes how to create a data export design.  The design is required to be standardized across all the labs to utilize generic LIMS importing set-up.  This design will contain all the necessary elements for successful ICP data import into LIMS.

Before attempting this tutorial user must ensure that LIMS server drive has been mapped to the specific instrument's folder.  For instructions on how to map a network drive please follow tutorial "How to Map a Network Drive"

1. Data Manager

  1. Open Data Manager
  2. Select a "Result" data set (this can be any result data set)
  3. Click "Export"

The Export Design you create will be generic and applicable to export any result set.  This is why it doesn't matter what result you choose when creating it.

2. Data Export Wizard

2.1. Select Export Design

  1. Click on "Create New Design"
  2. Click "Next"

2.2. Select Samples to Export

  1. The only set of results that should be selected "All Unknowns"
  2. Analysis Dates to Include should be set to "All"
  3. Sort Display should be set to "Chronologically"
  4. Click "Next"

2.3. Select Analytes to Export

  1. Click to "Add All"
  2. Select "Alphabetically by Name" for Sort Display
  3. Click "Next"

All parameters within the result set should be exported.  In LIMS, methods and items are configured to only pull the necessary parameters with associated wavelength.  This is key behind having a "Generic export design"

2.4. Select Export Options

  1. Exported File Name, select "Same as Data Set"
  2. Exported File Extension, select ".csv"
  3. Exported File Directory, click on "Browse" and navigate to the correct folder on the mapped drive
  4. If File Already Exists, select "Overwrite"
  5. Data Delimited By Select a comma ","
  6. Check the box for "Include Descriptive Header"
  7. Click "Next"

File directory will vary for each site based on process followed and drive selected when it's mapped.  Usually drive letter "I" will be selected and LIMS folder will follow this naming convention: 3-Letter abbreviated site name, Machine Name and Model, C-Pro Equipment number (where applicable)

2.5. Select Sample Parameters

  1. Select "Sample ID (name)"  from the "Available Parameter" list
  2. Click "Add"
  3. The parameter will append to the "Selected Parameters" list.
  4. Click "Next"
  1. Select "Analyte Name"  from the "Available Parameter" list
  2. Click "Add"
  3. The parameter will append to the "Selected Parameters" list.  Perform this for the "Concentration (Samp Units)" parameter as well.
  4. When parameter "Analyte Name" and "Concentration (Samp Units" are on the Selected Parameters list, click "Next"

Analyte Name will include both the Atomic symbol and wavelength

Do not add an parameters from this section

Click "Next"

2.8. Export Data Set

  1. Click on "Save Design"

This is where the export design will be saved so do not change the directory it must be in it's default location

  1. Name the design: "LIMS_Export_Generic"
  2. Click "Save"

3. Test Export Design

After saving the design you can test the export and check the data file it generates

  1. Click on "Export Data" button (this will automatically send that specific result file into the LIMS folder, which was mapped and directory to which was set in step: 3.4 of this procedure)
  2. Click "Finish"

4. Review Export File

  1. Open the data file from LIMS folder
  2. Ensure all the export parameters are in the file
    • Sample ID
    • Analyte Name
    • Conc (Samp)

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.