Identify which External Tables/Fields to Update with the Information

Top  Previous  Next

UXMLWhat are the tables/fields that need to be updated in the external application? The information obtained from the document needs to be linked to values in the report and eventually used to update the RESULTS table of an external database. The following fields need to be updated in the table:

 

Keyword1: TESTER - User name
Keyword2: ORDNO - Sample ID
Keyword3: METHOD - Method name
Graph1: Optionally the chromatogram (Graph1) can be imported to a LIMS area such as an attachment depending on the import script, so it is included in this example and is placed in the UXML template in the next procedure. For more information about import scripts, see section Import Scripts and the UXML Structure.
Table1:

ANALYTE - Analyte name

NUMRES -  Retention time

RN1 - Sample amount

 

The UXML template for this document should link the required data in the document to these fields.

 

You can rename the keywords as follows when creating the UXML template (by typing an alternative name in the Custom name field; see the screenshot in the next procedure):

Keyword 2: Sample ID --> ORDNO
Keyword 3: Method name --> METHOD
Keyword 1: User name --> TESTER
Image 1: Chromatogram --> GRAPH
Table 1: Results --> RESULTS

 Field: Analyte name --> ANALYTE

 Field: Retention time --> NUMRES

 Field: Sample amount --> RN1

SDMS allows you to create templates using the Unified XML Designer window. The following section provides step-by-step instructions on how a UXML template can be built using this window.