1. Home
  2. Database
  3. Configuring the External Database Feature – TEKLYNX CENTRAL Instructions

Configuring the External Database Feature – TEKLYNX CENTRAL Instructions

Bookmark(0)

Target Audience: Advanced User, IT Manager
Article #: 12063

Summary

The External Database feature in TEKLYNX CENTRAL allows users to access workorder and product information from a database located outside of TEKLYNX CENTRAL. Companies commonly use this capability to simplify the label printing process. The external database is already automatically and dynamically updated by the company’s own internal systems. Connecting TEKLYNX CENTRAL to the appropriate tables reduces potential human error and speeds up the printing process. This article will guide you through the steps of configuring the external database feature.

Preparation

  1. Verify with EBI that your license supports this feature. It is not supported by default.
  2. Your database should have three tables, each with a UID (Universal ID) field:
    a. Workorders
    b. Workorders-Products
    c. Products-Labels
    If your tables do not have a UID field, you can build a new one or set up a virtual UID.
  3. Create a data source with CODESOFT that allows TEKLYNX CENTRAL to connect to your external database.
  4. Check-in the sample labels into LABEL ARCHIVE as an Approved label in CODESOFT’s “root” file location. TEKLYNX CENTRAL’s External Database feature cannot read labels in subfolders.
  5. The Work Order feature will need to be enabled in the General Options tab in TCADMIN.

Instructions

  1. Log into the TEKLYNX Configure Web Printer Interface via the Command Center.
TEKLYNX CENTRAL Control Center
  1. Select the “Use external database” option in the Display options & external database tab.
External Database feature on the web configuration page
  1. Link to your target external database using the pull-down. Press the Test button, and if the link is successful, click Save at the bottom of the screen.
Select Data Source drop down selection box
  1. Connect to the Product-Labels table by first selecting Labels in the Data Configuration tab.
Labels selection on the web configuration page
  1. Next, define the Table Query Parameters
Mapping fields from the external Products-Labels table to the Labels Configuration page
  1. Then, for each label, select the “Define Label Data” button to set the label variable behavior for such things as Default Value, Prompt, Input Mask, etc.
Define Label Data screen in the Labels Configuration page
  1. Connect to the Workorder table by selecting Workorders in the Data Configuration tab.
Workorders selection on the web configuration page
  1. Then, define the Table Query Parameters.
Mapping the fields from the external Workorders table to the Workorders Configuration page
  1. Connect to the Workorder-Products table by selecting Products in the Data Configuration tab.
Products selection on the web configuration page
  1. Next, define the Table Query Parameters.
Mapping the fields from the external Workorder-Products table to the Products Configuration page
  1. Finally, verify that you were successful in configuring the external database feature using the Printing Interface (BBUI).
TEKLYNX CENTRAL printing browser interface with external database enabled

Additional Comments

Tested Using TEKLYNX v5.1

If you need further assistance, please contact us.

Updated on September 17, 2021

Was this article helpful?

Related Articles

Need Help?
Click the link below to submit a support ticket
Submit Ticket