Loading Sample List Into Qtegra

Issue

Want to load sample list into Qtegra from CSV file

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

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

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.

File	Last Modified
headers in excel.PNG	August 02, 2022
Open to edit default map file.PNG	August 02, 2022
default mapping file.PNG	August 02, 2022
setting up the mapping file.PNG	August 02, 2022
Headings in Qtegra sample list.PNG	August 02, 2022
Save as XML.PNG	August 02, 2022
Labbooks section.PNG	August 02, 2022
Create a labbook from an existing template.PNG	August 02, 2022
Name the lab book.PNG	August 02, 2022
Template choice.PNG	August 02, 2022
import from CSV.PNG	August 02, 2022
Create labbook.PNG	August 02, 2022