Want to load sample list into Qtegra from CSV file
- iCAP 7000 Series
- iCAP 6000 Series
- iCAP Q
- iCAP RQ
- iCAP TQ
Change Excel File to CSV
- Open sample list file in excel
- Note the headers for the mapping file, see example headers in Figure 1
Figure 1: Headers in excel, "Sample Name, Rack, Vial"
- Click "Save As" and choose CSV UTF-8 (Comma delimited)(*.csv), name and choose a location you can easily locate to save the file in, see Figure 2
Figure 2: Use the drop down to select CSV UTF-8
Editing the default mapping file
- Find the default map database by following this pathway: C:\ProgramData\Thermo\Qtegra\_Application Data\SampleLists\TranslationTable
- Edit the mapping file by opening with notepad see Figure 3
Figure 3: Right- Click-> open with-> Notepad
- Once open in Notepad you can edit the mapping file for your specific sample list
- In the "Default" mapping file you have many lines that can be edited see Figure 4 for the default mapping file shown in Notepad
Figure 4: Default Mapping File opened in Notepad
- Now you can edit the mapping file in accordance with your sample list headers noted in the above section
- Each line should be adjust as so: <Name>Name</Name> from the LIMS is translated to
<Translation>Label</Translation> for Qtegra.
- Figure 5: Shows where to put headings in mapping file
- In RED, Green, and Purple, are the headers from the excel sample list. They go in the <Name> x </Name> section in place of x
- The Blue color shows what those headers need to translate to in Qtegra. These should be columns that are already in Qtegra.
- If there are any extra lines, you can leave them. If you need more lines than are given, you can add them in sections above </TranslationTable>
- A whole section is <Item> <Name> x </Name> <Translation> x </Translation> </Item>
- Save the mapping file using "Save As" and save as a .xml file in the Translation Table folder that you opened it from
Loading the Sample List and Mapping File into Qtegra
- Open Qtegra and go to the Labbooks Section,
- Choose "Create a new Labbook from an existing Template"
- Name the labbook,
- Select the template you want to use
- Check the box "import from CSV"
- Choose the CSV file that saved in the first section, and the mapping file that was created in the second section.
- Click "Create LabBook"
Once you click Create LabBook, the sample list will reflect the sample list file from the LIMS or excel file created earlier.