How to create an export method that exports database fields and tables in Empower - WKB3071

OBJECTIVE or GOAL

Create an export method that exports database fields and tables

ENVIRONMENT

• Empower 2
• Empower 3

PROCEDURE

Creating an Export Method that Exports Database Fields and Tables  - You can create an export method that exports database fields and/or tables in ASCII format (without specifying a report method) when you want to export large tables of data.

1. Access the Project window.
2. Select File > New Method > Export Method. The Export Method Editor appears.
3. Click the Fields tab.
4. Enter up to 32 characters for the filename. Empower software adds four additional characters (the ID from the database) to the end of the filename at the time of export.
5. Do either of the following:
   • To export data as a file, select the Export ASCII check box, and then specify the destination for the exported file in the field to the right. The destination can be a local or network drive or folder. Click the browse button on the right to locate and select the destination.
   • To export data by e-mail, select the Export E-Mail check box, and then click From E-Mail or From Field. From E-Mail specifies that the data is exported as an e-mail attachment and sent to the e-mail address you enter. From Field specifies that data is exported as an e-mail attachment (using an Empower field name that corresponds to an e-mail address).  Note: to use this export technique, your Empower system must be set up to handle MAPI-compliant e-mail. If necessary, contact your system administrator.
     • If you select From E-Mail, enter an e-mail address (or multiple, semicolon-separated addresses), and then click Verify to start a check of the e-mail addresses. If an address does not correspond to a MAPI-compliant name in your e-mail system, an error message appears.
     • If you select From Field, click Select to open the Select Field dialog box, where you select the Empower field name (typically a custom sample identifier) that corresponds to a destination e-mail address, and then click OK. The field name appears in the field to the left.
6. Specify a report type:
   • Individual – Specifies that the export method include a separate report for each of the exported data (unprocessed channel or injection, processed result, method, and so on).  For data in a sample set or result set, separate reports are generated for each channel or result in the set.
   • Summary By All – Specifies that the export method include one summary report for the exported data items.
   • Summary By Vial – Specifies that the export method include one summary report for each vial in the exported data items.
   • Summary By Injection – Specifies that the export method include one summary report for each injection in the exported data items.
7. Select or enter optional column, row, and text delimiters.
8. If you use the method to export both fields and table, select the Export Order Fields First or Table First).
9.  If you export the table:
   • Enable Export Table Data.
   • Enable Export Row Numbers (useful if exporting into a LIMS system).
   • Click Load Table. The Open Table dialog box appears.
   • Select a table type from the list and then click Open. The table loads into the table area in the Export Method Editor.
   • If you want to modify the table, click Edit Table.
10. You can customize the format of information in the export file, as follows:
    • Export Field Data – Exports sample identifier labels (Sample Name, for example).  You must select this check box before you set the Label Orientation parameter or enter sample identifier labels into the table.
    • Label Orientation – Sets the orientation (Row or Column) of sample identifiers and sample identifier data.
    • Sample Identifier List/Sample Identifier Table – Specifies sample identifiers to include in the export file. Select a sample identifier from the list, and then double-click the identifier (or drag it) to the table on the right. Sample identifiers in the table are included in the export file.
11. Save the method.

ADDITIONAL INFORMATION

See additional articles on creating Export Methods:

How to create an Export Method that uses a specified Report Method in Empower

How to create an Export Method for Raw Data that does not specify a Report Method in Empower