Applications - Technical Notes
Gen5™ File Export - Creating a File to Export to LIMs/LIS
Many commercially available LIMs/LIS applications can easily import text files (*.txt) from instrument control and analysis software programs like Gen5. This Tech Note describes the steps required to create a custom *.txt containing the required data, using the File Export Builder feature in the Gen5 protocol. The File Export Builder allows a user to create a template containing only the data that needs to be exported in the file, in either a column (table) or matrix (grid) format. See the example screens in the Appendix.
This Tech Note also describes the Gen5 protocol options available to define the exported file path, manual or automatic exporting and information about exporting each plate’s data to its own file or appending multiple plates to a single file.
Step 1: Select the data to be exported using the File Export Builder
In the screen below, we’ve selected 595 nm data, then clicked Add to add this to the Export Content:
- Open the Gen5 protocol file
- Double-click the File Export Builder in the protocol menu:
- In the File Export Builder, select data to be included in the export file from the Available Data Views list. “Matrix” data views will export data in a microplate matrix or grid format. “Table” views will export data in a column format. Table format is more commonly used for data that will be sent to a LIMs/LIS.
- Double-click on the item in the Export Content window to edit the contents. In this dialog, you may:
- Change the name of the contents
- Choose the well types to be included in the file (in the Selection tab, check all desired types)
- In the Data tab, select the type of data to be included. Several pieces of data are included by default. Any can be removed by right-mouse clicking and choosing Delete. Others may be added by clicking in an open row under the Data header:
Step 2: Define the File Export Settings
- The File Naming Convention should use the Extension “txt”. By default, the Experiment name is selected as the File Name. To change this, click the right arrow at the end of the File Name field, and choose the desired File Name parameter from the list.
- Select the appropriate path for the File Location
- It is best to de-select all of the “Include” options; Separator should be selected by the LIMs/LIS requirement.
- In the “When Exporting …” box, select the desired prompt. Note that if you wish to send multiple plates to a single Export file, you must choose the “Never, …” and Append option.
- The Protocol Options|File Export Settings screen is shown below. In this screen, several default selections are made, but all can be modified.
- To Export the data, highlight the Plate containing the data to be exported - right-mouse click to see the menu. Choose “File Export”. The data will be sent to the path specified in Step 2 above.
Step 3: Export the Data
Data can be exported from Gen5 either manually or automatically after each plate is read.
Each time a plate is read in the experiment file, the data will be automatically exported to the path defined in Step 2.
- To Export the data automatically after each plate is read, go to Protocol|Auto Output Options and select Execute File Export:
- To Export data manually from Gen5 to a *.txt file, first Read the plate. When reading is complete, right mouse click on the Plate in the menu tree and choose File Export. The data will be exported to the path defined in Step 2. If more than one plate exists in the Experiment, all plates can be highlighted and then exported.
Example of data exported in the Table format:
Example of data exported in the Matrix format: