Blog Archives

Sample List???…. Do I need a Sample List??? Yes and here’s how to import one

So the basic element of data navigation and collection is a list of samples.

This list will identify the properties of the data collected and tell the system, what to do to and the names of the files collected or to be collected.

So TF has a couple of different ways to do this.

The first and easiest is to make a template of the defined sample grid you want to use. In TraceFinder, the user can define the columns that are displayed in both the data results and sample definition grids.

In Batch View or in the sample page of the Acquisition Mode/Wizard, right click the mouse in the grid and a menu dialog that opens up.

In that dialog , select “Export to CSV”. This will make a copy of the grid and the header lables is a file that can be opened by any editing grid application. The most common is Excel, but you could open in a text editor also.

Simply, open the file and for daily use just input  sample information in the template and save as a daily/batch .csv file.

A LIMS system, can create a .csv file in this same format  or even use a bar code reader to fill in certain fields even in Excel.

Once the sample input is done save the file as .csv and close the editor.

If  the file is still open in Excel,  MS Office will not let it be used by another program so TF can’t import it until it’s closed.

Right click in the grid and select “Import Samples”.

The Dialog below opens, then select the appropriate file.

The information contained in the CSV file will be inserted into the grid either at the end of the current data or where the index indicator is if that is the option selected in the drop down list below the browse section.

There is also a xml format that can be created fromat LIMS system that can be used, or if Xcalibur has previously been in use the .sld files can be utilized also. Any sample type that TF does not recognize will be set to the Unknown Sample type.





Preferred setup diagram for LIMS with TraceFinder

LIMS integration

If a customer wishes to interface TraceFinder with a LIMS (or “LIS” in clinical accounts) there is a preferred configuration. The setup diagrammed in the attached file has worked successfully with past LCQuan systems, and may be used as a model for forthcoming TraceFinder interfaces.

When the TraceFinder user clicks Import in Analysis tab, the last used folder will show up. This can be a designated drop folder to which the LIMS sends sample list .csv files. After the run is complete, TraceFinder will post the result as an xml file in a newly created batch folder. The LIMS sniffer program should be set to check for a “newly created” folder within C:ThermoTraceFinder[version#]Projects. The Data folder within that folder will contain files ending in .rsx, which are xml files. The LIMS sniffer program would then import the required accession numbers, calculated result, time stamp, etc directly from those xml files.