Exporting Data, Results, and Reports with Export Methods in Empower - Tip218

OBJECTIVE or GOAL

Get Empowered: Export Methods

Tip #218: Exporting Data, Results, and Reports with Export Methods in Empower

This tip begins a new series on creating and working with Export Methods. There may be times when raw data, results, and/or reports need to be exported out of Empower to another application. For example, some need to send information from Empower to a LIMS. An Export Method can accomplish this goal.
 

ENVIRONMENT

• Empower

PROCEDURE

1. You can export data from Empower in several file formats. The file extension for the exported data varies depending on which format you select.
   
2. From the Methods tab in the Project, right-click and select New Method > Export Method.
   
3. The Export Method Editor opens on the Fields tab.
   
4. In this example, we will export a table of data. We first need to define the destination of the exported file.
   In the Filename field, enter a "root name" for the exported file.
   Select the "Export ASCII File" check box.
   To the right of the empty field, click the box with the three dots.
   Find the path to the folder or drive to which the data will be exported, and click OK.
   
5. Now, you can define the fields of information you want exported.
   
6. Check the Export Table Data box and, optionally, the Export Row Numbers box. The easiest way to configure the fields is to select a preconfigured table and then modify it accordingly. These tables are the same ones found in the Report Publisher. Click Load Table, select a table, and click Open.
   
7. You can modify the table by clicking Edit Table and editing as you would a table in a Report Method. It's recommended to export Sample Information so that you know which sample the data came from. Check the Export Field Data box.
   
8. Add some basic information, such as Sample Name and Injection.
   
9. Save all changes to the Export Method, go to the Results tab, right-click on a result or results, and select Export.
   
10. In the Exporting section of the Background Processing and Reporting dialog box, select Use Specified Export Method, select the Export Method from the drop-down list, and click OK.
    
11. The file is opened and parsed in Microsoft Excel. The four-digit number in the file name is the Result ID.
    

ADDITIONAL INFORMATION

You can use either the Pro or the QuickStart interface for this tip.