Blog Archives

TF 3.0 Export Results Grid to Excel and Copy Images to Clip Board

Sticking to new features in data review, we’ll continue with a simple workflow.

One of the many request that TraceFinder has received over the last year has been to have the ability to export the results grid directly to Excel instead of having a Custom Report generated.

In TF 3.0 all data grid results whether in the quantitative views or targeted screening section, export all data to Excel or CSV files directly.

No need to produce a custom report and navigate through the files menus to go get it.

Simply export and place the file where you want it.

Also a feature that has been requested is the ability to copy high definition images of chromatograms and such to the clipboard for use in papers, lab notebooks and presentations/posters.

We also did this in TF 3.0

If the video is blurry please click the cog wheel at the bottom of the panel and increase the video display resolution.

 

Making changes in to the multiple peaks in a compound (Answer to a “Ask A Guru” question)

There are times that a chemist may make a method from a PMD file or from CDS, and things need to be changed.

An istance would be swapping an existing quan peak with its confirming peak, or removing a confirming peak.

These changes while seemingly trivial can be a hassel if you have to do many of them. So the TF team has given these options as right click contect menus to make it easier to perfrom these functions.

Watch the video below to get an idea of how to use these tools.

If the video is blurry please click the cog wheel at the bottom of the panel and increase the video display resolution.

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.