Difference between revisions of "SOP-42Q-MES0079 Label Engine Admin"

From 42Q
Jump to navigation Jump to search
Line 1: Line 1:
 
<p style="text-align: center;">Administration</p> <p style="text-align: center;">Label Engine Admin</p> <p style="text-align: center;">Version MES 15.75</p> <p style="text-align: center;">Revision C1</p> <p style="text-align: center;">&nbsp;</p> <p style="text-align: center;">&nbsp;</p>  
 
<p style="text-align: center;">Administration</p> <p style="text-align: center;">Label Engine Admin</p> <p style="text-align: center;">Version MES 15.75</p> <p style="text-align: center;">Revision C1</p> <p style="text-align: center;">&nbsp;</p> <p style="text-align: center;">&nbsp;</p>  
= <span class="mw-headline" id="Administration">Administration</span> =
+
= <span class="mw-headline" id="Administration"><span class="mw-headline" id="Administration">Administration</span></span> =
  
Administrative privileges in 42Q are located in the Administration menu heading.&nbsp;
+
Administrative privileges in '''42Q''' are located in the '''Administration''' menu heading.&nbsp;
  
 
With the portal, Administrators are able to access privileges from one convenient location.
 
With the portal, Administrators are able to access privileges from one convenient location.
Line 16: Line 16:
 
&nbsp;
 
&nbsp;
  
Also located in the Administration menu heading are Shop Floor Control Administrator, Document Control, Traceability Administrator, Notification & Escalation, Meas Instance Admin, and Label Engine Admin.<br/> To access any of the Administration Portlet, the user must sign into 42Q and then select the Administration expandable heading located in the menu on the left of the screen.
+
Also located in the Administration menu heading are '''Shop Floor Control Administrator, Document Control, Traceability Administrator, Notification & Escalation, Meas Instance Admin, '''and '''Label Engine Admin'''.
 +
 
 +
<br/> To access any of the '''Administration Portlet''', the user must sign into '''42Q''' and then select the '''Administration''' expandable heading located in the menu on the left of the screen.
  
 
&nbsp;<br/> Figure 1: 42Q Sign-In
 
&nbsp;<br/> Figure 1: 42Q Sign-In
Line 22: Line 24:
 
&nbsp;
 
&nbsp;
  
To access the Label Engine Administration page, navigate to Administration > Label Engine Admin.
+
To access the '''Label Engine Administration''' page, navigate to '''Administration''' > '''Label Engine Admin'''.
  
 
<br/> Figure 2: 42Q Welcome
 
<br/> Figure 2: 42Q Welcome
Line 28: Line 30:
 
&nbsp;
 
&nbsp;
  
= <span class="mw-headline" id="Label_Engine_Administration">Label Engine Administration</span> =
+
= <span class="mw-headline" id="Label_Engine_Administration"><span class="mw-headline" id="Label_Engine_Administration">Label Engine Administration</span></span> =
  
 
Labels are critical to the overall manufacturing process. 42Q understands this need and has worked to develop a system for label creation, edition, and sharing.&nbsp;
 
Labels are critical to the overall manufacturing process. 42Q understands this need and has worked to develop a system for label creation, edition, and sharing.&nbsp;
Line 36: Line 38:
 
There is tremendous value in self-service functionality and in site-to-site collaboration. 42Q has made a significant step in both of these areas with the release of the Label Engine and is working on similar capabilities throughout the MES suite.&nbsp;
 
There is tremendous value in self-service functionality and in site-to-site collaboration. 42Q has made a significant step in both of these areas with the release of the Label Engine and is working on similar capabilities throughout the MES suite.&nbsp;
  
Label Engine Administration is responsible for System Configuration. In this portlet, Administrators can do the following:
+
'''Label Engine Administration''' is responsible for System Configuration. In this portlet, Administrators can do the following:
  
 
*Add/Edit and Delete a '''Customer''', '''Printer''', or '''Database''';  
 
*Add/Edit and Delete a '''Customer''', '''Printer''', or '''Database''';  
Line 45: Line 47:
 
&nbsp;
 
&nbsp;
  
Figure 3: LE Administration Portlet
+
'''Figure 3: LE Administration Portlet'''
  
 
&nbsp;
 
&nbsp;
  
== <span class="mw-headline" id="Customer_https:.2F.2Flh3.googleusercontent.com.2FmNYBYh88W6ODWEll2dgvAX3X5vcuhp_WoIe7w8_83IrVl5o7IT-r8zsLbSRgM95oTrpI32SXBg_c-l81mP9tQoWY-HJtwgBk2-Jqqwt_DEfvdMB49uFiravEFzQKT_6zFMD7gjIvb_JiKA2wJHdYsmgFqkWmWCzkksfHKJtPNZDffjAgo1sZ9clPeg">Customer&nbsp;</span> ==
+
== <span class="mw-headline" id="Customer"><span class="mw-headline" id="Customer_https:.2F.2Flh3.googleusercontent.com.2FmNYBYh88W6ODWEll2dgvAX3X5vcuhp_WoIe7w8_83IrVl5o7IT-r8zsLbSRgM95oTrpI32SXBg_c-l81mP9tQoWY-HJtwgBk2-Jqqwt_DEfvdMB49uFiravEFzQKT_6zFMD7gjIvb_JiKA2wJHdYsmgFqkWmWCzkksfHKJtPNZDffjAgo1sZ9clPeg">Customer&nbsp;</span></span> ==
  
 
<br/> The Customer sub-module is responsible to create, edit or delete customers in the database. &nbsp;
 
<br/> The Customer sub-module is responsible to create, edit or delete customers in the database. &nbsp;
  
To access the customer module, navigate to Administration > LE Engine Admin >Customer &nbsp;
+
To access the customer module, navigate to '''Administration''' > '''LE Engine Admin '''>'''Customer.''' &nbsp;
  
 
&nbsp;
 
&nbsp;
Line 63: Line 65:
 
From the main page (Customer) the following features can be selected:
 
From the main page (Customer) the following features can be selected:
  
*Filter: Filter and search the list on the page.  
+
*'''Filter''': Filter and search the list on the page.  
*Add: Add a Customer.  
+
*'''Add:''' Add a Customer.  
*Edit: Edit a Customer from the list.&nbsp;&nbsp;&nbsp;  
+
*'''Edit''': Edit a Customer from the list.&nbsp;&nbsp;&nbsp;  
*Delete: Delete a registered Customer from the list.  
+
*'''Delete''': Delete a registered Customer from the list.  
  
 
See below the details for each feature.
 
See below the details for each feature.
Line 72: Line 74:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Filter_Customers">Filter Customers</span> ===
+
=== '''<span class="mw-headline" id="Filter_Customers"><span class="mw-headline" id="Filter_Customers">Filter Customers</span></span>''' ===
  
 
&nbsp;
 
&nbsp;
  
The filter feature can be used to narrow the list that is displayed on the main Customer List page. This can be useful if the user wants to look at information pertaining to limited entries. Filters can be selected at the top of the Customer page.
+
The filter feature can be used to narrow the list that is displayed on the main '''Customer''' List page. This can be useful if the user wants to look at information pertaining to limited entries. Filters can be selected at the top of the Customer page.
  
Figure 5: LE Customer&nbsp;
+
&nbsp;
 +
 
 +
'''Figure 5: LE Customer Name/Filter'''
  
 
&nbsp;
 
&nbsp;
Line 84: Line 88:
 
&nbsp;
 
&nbsp;
  
To filter the Customer List page listings, select Name field and apply by clicking the Filter button. &nbsp;
+
To filter the Customer List page listings, select '''Name''' field and apply by clicking the '''Filter '''button. &nbsp;
  
*Name: customer name.  
+
*'''Name''': customer name.  
*Comments: any necessary information  
+
*'''Comments''': any necessary information  
  
 
&nbsp;
 
&nbsp;
 +
 +
=== '''<span class="mw-headline" id="Add_Customers"><span class="mw-headline" id="Add_Customers">Add Customers</span></span>''' ===
  
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Add_Customers">Add Customers</span> ===
+
The main purpose of this feature is to add customer information. Each label is associated with a customer so, to set up a customer, the user must provide the following information:
  
 
&nbsp;
 
&nbsp;
  
The main purpose of this feature is to add customer information. Each label is associated with a customer so, to set up a customer, the user must provide the following information:
+
#To add a new customer, click on the Add button on the main page. The '''Customer Details''' pop-up window displays:  
 
 
#To add a new customer, click on the Add button on the main page. The Customer Details pop-up window displays:  
 
  
 
&nbsp;
 
&nbsp;
  
Figure 6: Add LE Customer
+
'''Figure 6: Add LE Customer'''
  
 
&nbsp;
 
&nbsp;
Line 120: Line 124:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Edit_LE_Customers_Information">Edit LE Customers Information</span> ===
+
=== '''<span class="mw-headline" id="Edit_LE_Customers_Information"><span class="mw-headline" id="Edit_LE_Customers_Information">Edit LE Customers Information</span></span>''' ===
  
 
&nbsp;
 
&nbsp;
Line 126: Line 130:
 
&nbsp;
 
&nbsp;
  
To edit customer information, select a customer in the list and click on the Edit button on the main page. The Customer Details pop-up window displays:
+
To edit customer information, select a customer in the list and click on the '''Edit''' button on the main page. The '''Customer Details''' pop-up window displays:
  
 
&nbsp;
 
&nbsp;
  
Figure 7: LE Edit Customer Information
+
'''Figure 7: LE Edit Customer Information'''
  
 
&nbsp;
 
&nbsp;
Line 136: Line 140:
 
&nbsp;
 
&nbsp;
  
Update any necessary information and select Save.
+
Update any necessary information and select '''Save.'''
  
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Delete_Customers">Delete Customers&nbsp;</span> ===
+
=== '''<span class="mw-headline" id="Delete_Customers"><span class="mw-headline" id="Delete_Customers">Delete Customers&nbsp;</span></span>''' ===
  
 
&nbsp;
 
&nbsp;
Line 152: Line 156:
 
&nbsp;
 
&nbsp;
  
Select Yes to confirm deletion or No to abort. &nbsp; Note: Only an unreferenced customer can be deleted.
+
Select '''Yes''' to confirm deletion or '''No''' to abort. &nbsp;
  
 
&nbsp;
 
&nbsp;
  
== <span class="mw-headline" id="Printer_https:.2F.2Flh3.googleusercontent.com.2FzO5PICl_6uzuSxdCVvXBhPxeBmUml2IWPg_hW1S00Qead3Oi9cqMlk2HcRN2ZxbKwahKYrkcmXKJMGE5w7MlADrhNFeRvZP1DlHMyQg3MVSxgK_Zu3QqvKtb4tyx1ctFlCNWy0mCe66BDv3gC-ssbmn_IwU4Wsq31vZO2-aQUXOe7wYreSTv0yp16g">Printer&nbsp;</span> ==
+
<u>'''Note'''</u>: Only an unreferenced customer can be deleted.
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
== <span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer_https:.2F.2Flh3.googleusercontent.com.2FzO5PICl_6uzuSxdCVvXBhPxeBmUml2IWPg_hW1S00Qead3Oi9cqMlk2HcRN2ZxbKwahKYrkcmXKJMGE5w7MlADrhNFeRvZP1DlHMyQg3MVSxgK_Zu3QqvKtb4tyx1ctFlCNWy0mCe66BDv3gC-ssbmn_IwU4Wsq31vZO2-aQUXOe7wYreSTv0yp16g">Printer&nbsp;</span></span> ==
  
 
&nbsp;
 
&nbsp;
Line 164: Line 174:
 
LE Admin - Printers is the interface to manage the print queues for MES 101 printing activities. Label Engine has a list of printers to which it can print labels.&nbsp;
 
LE Admin - Printers is the interface to manage the print queues for MES 101 printing activities. Label Engine has a list of printers to which it can print labels.&nbsp;
  
<br/> To access the Printer module, navigate to Administration > LE Administration > Printer
+
<br/> To access the '''Printer''' module, navigate to '''Administration''' > '''LE Administration '''> '''Printer'''
  
The main Printer page displays as shown below:
+
&nbsp;
 +
 
 +
The main'''Printer '''page displays as shown below:
  
 
&nbsp;
 
&nbsp;
  
Figure 9: LE&nbsp;
+
'''Figure 9: LE Printer'''
  
 
&nbsp;
 
&nbsp;
Line 176: Line 188:
 
&nbsp;
 
&nbsp;
  
From the main page (Printer) the following features can be selected:
+
From the main page ('''Printer''') the following features can be selected:
  
*Filter: Filter and search the list on the page.  
+
*'''Filter''': Filter and search the list on the page.  
*Add: Add a Printer.  
+
*'''Add''': Add a Printer.  
*Edit: Edit a Printer from the list.&nbsp;&nbsp;&nbsp;  
+
*'''Edit''': Edit a Printer from the list.&nbsp;&nbsp;&nbsp;  
*Delete: Delete a registered Printer from the list.  
+
*'''Delete''': Delete a registered Printer from the list.  
  
 
See below the details for each feature.
 
See below the details for each feature.
Line 187: Line 199:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Filter_Printers">Filter Printers</span> ===
+
=== '''<span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers">Filter Printers</span></span>''' ===
 +
 
 +
&nbsp;
  
The filter feature can be used to narrow the list that is displayed on the main Printer List page. This can be useful if the user wants to look at information pertaining to limited entries. Filters can be selected at the top of the Printer page.
+
The filter feature can be used to narrow the list that is displayed on the main '''Printer''' List page. This can be useful if the user wants to look at information pertaining to limited entries. Filters can be selected at the top of the '''Printer''' page.
  
 
&nbsp;
 
&nbsp;
  
Figure 10: LE Filter&nbsp;
+
'''Figure 10: LE Filter Printer'''
  
 
&nbsp;
 
&nbsp;
Line 206: Line 220:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Add_Printers">Add Printers</span> ===
+
=== <span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers">Add Printers</span></span> ===
  
The main purpose of this feature is to create new print queues&nbsp;
+
The main purpose of this feature is to create new print queues.&nbsp;
  
 
#To add a new printer, click on the Add button on the main page. The Printer Details pop-up window displays.  
 
#To add a new printer, click on the Add button on the main page. The Printer Details pop-up window displays.  
  
'''Note''': Print Queue names are automatically generated.
+
<u>'''Note'''</u>: Print Queue names are automatically generated.
  
Figure 11: LE Filter&nbsp;
+
&nbsp;
 +
 
 +
'''Figure 11: LE Filter Printer'''
  
 
&nbsp;
 
&nbsp;
Line 222: Line 238:
 
Adding a printer is as easy as providing the following details:&nbsp;
 
Adding a printer is as easy as providing the following details:&nbsp;
  
*Printer Name - the friendly name for the printer.&nbsp;&nbsp;  
+
*'''Printer Name''' - the friendly name for the printer.&nbsp;&nbsp;  
*Print Queue - the actual print queue name which is system generated. system generated &nbsp;  
+
*'''Print Queue''' - the actual print queue name which is system generated. system generated &nbsp;  
*Resolution - the resolution of the printer, e.g. 200 dpi, 300dpi, 600 dpi, etc.  
+
*'''Resolution''' - the resolution of the printer, e.g. 200 dpi, 300dpi, 600 dpi, etc.  
*Make (optional) - Description of the brand of the printer. A non functional attribute but provided to assist the plant with printer management&nbsp;  
+
*'''Make (optional)''' - Description of the brand of the printer. A non functional attribute but provided to assist the plant with printer management&nbsp;  
*Printer Model (optional) - description of the specific printer. A non functional attribute but provided to assist the plant with printer management  
+
*'''Printer Model (optional)''' - description of the specific printer. A non functional attribute but provided to assist the plant with printer management  
*Description&nbsp; (optional)- a free-form description of the printer. A non functional attribute but provided to assist the plant with printer management  
+
*'''Description&nbsp;(optional)''' - a free-form description of the printer. A non functional attribute but provided to assist the plant with printer management  
 
*Connectivity Type options:  
 
*Connectivity Type options:  
 
*
 
*
Line 251: Line 267:
 
**Accessible Directly: using a TCPIP socket.   
 
**Accessible Directly: using a TCPIP socket.   
 
*
 
*
**VPN accessible printers:   
+
**'''VPN accessible printers:'''    
  
 
&nbsp;
 
&nbsp;
Line 274: Line 290:
  
 
&nbsp;
 
&nbsp;
<ol start="3">
+
 
<li>
+
=== '''<span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers">Edit Printers</span></span>''' ===
=== <span class="mw-headline" id="Edit_Printers">Edit Printers</span> ===
 
</li>
 
</ol>
 
  
 
&nbsp;
 
&nbsp;
Line 286: Line 299:
 
&nbsp;
 
&nbsp;
  
Figure 12: LE Edit Printer Information
+
'''Figure 12: LE Edit Printer Information'''
  
 
&nbsp;
 
&nbsp;
Line 293: Line 306:
  
 
&nbsp;
 
&nbsp;
<ol start="4">
+
 
<li>
+
=== <span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers">Delete Printers&nbsp;&nbsp;</span></span> ===
=== <span class="mw-headline" id="Delete_Printers">Delete Printers&nbsp;&nbsp;</span> ===
 
</li>
 
</ol>
 
  
 
&nbsp;
 
&nbsp;
Line 303: Line 313:
 
#To delete a printer , select a printer in the list and click on the Delete button on the main page. A confirmation message pop-up window displays:  
 
#To delete a printer , select a printer in the list and click on the Delete button on the main page. A confirmation message pop-up window displays:  
  
Figure 13: LE Delete Printer
+
&nbsp;
 +
 
 +
'''Figure 13: LE Delete Printer'''
  
 
&nbsp;
 
&nbsp;
Line 310: Line 322:
  
 
Select '''Yes''' to confirm deletion or '''No''' to abort.
 
Select '''Yes''' to confirm deletion or '''No''' to abort.
 +
 +
&nbsp;
  
 
<u>'''Note'''</u>: Only an unreferenced customer can be deleted.
 
<u>'''Note'''</u>: Only an unreferenced customer can be deleted.
Line 315: Line 329:
 
&nbsp;
 
&nbsp;
  
== <span class="mw-headline" id="Databasehttps:.2F.2Flh5.googleusercontent.com.2FhNX7fmM6l_DjXja8qGz6j6whfeNqsHnZvSG5bE3W6jUkJrkRkNk_DgO2KLF_RdsOKBoObaFk3HIvGX1EknbNPmfBECtEdrRHLHJcLLL4M9LzNiEvZDXcJ1_sSx-Lhgb_dbLON0geOTWfYKCwFLP17ZhPg_zq1MW0h564oLrWUrGNMdoqvcoklCYnxg">Database</span> ==
+
== <span class="mw-headline" id="Database"><span class="mw-headline" id="Databasehttps:.2F.2Flh5.googleusercontent.com.2FhNX7fmM6l_DjXja8qGz6j6whfeNqsHnZvSG5bE3W6jUkJrkRkNk_DgO2KLF_RdsOKBoObaFk3HIvGX1EknbNPmfBECtEdrRHLHJcLLL4M9LzNiEvZDXcJ1_sSx-Lhgb_dbLON0geOTWfYKCwFLP17ZhPg_zq1MW0h564oLrWUrGNMdoqvcoklCYnxg">Database</span></span> ==
  
 
Before a label can use a database, a database needs to be set up and configured within the Label Engine.
 
Before a label can use a database, a database needs to be set up and configured within the Label Engine.
Line 321: Line 335:
 
<br/> To access the Database module, navigate to '''Administration''' > '''Label''' '''Engine Admin''' > '''Database'''
 
<br/> To access the Database module, navigate to '''Administration''' > '''Label''' '''Engine Admin''' > '''Database'''
  
Figure 14: LE Database&nbsp;
+
&nbsp;
 +
 
 +
'''Figure 14: LE Database&nbsp;'''
  
 
&nbsp;
 
&nbsp;
Line 327: Line 343:
 
&nbsp;
 
&nbsp;
  
From the main page (Database) the following features can be selected:
+
From the main page ('''Database''') the following features can be selected:
  
*Filter: Filter and search the list on the page.  
+
*'''Filter''': Filter and search the list on the page.  
*Add: Add a Database.  
+
*'''Add''': Add a Database.  
*Edit: Edit a Database from the list.&nbsp;&nbsp;&nbsp;  
+
*'''Edit''': Edit a Database from the list.&nbsp;&nbsp;&nbsp;  
*Delete: Delete a Database from the list.  
+
*'''Delete''': Delete a Database from the list.  
  
 
See below the details for each feature.
 
See below the details for each feature.
  
=== &nbsp; ===
+
=== <span class="mw-headline" id="">&nbsp;</span> ===
  
=== <span class="mw-headline" id="Filter_Databases">Filter Databases</span> ===
+
=== <span class="mw-headline" id="Filter_Databases"><span class="mw-headline" id="Filter_Databases">Filter Databases</span></span> ===
  
 
&nbsp;
 
&nbsp;
  
The filter feature can be used to narrow the list that is displayed on the main '''Database''' List page. This can be useful if the user wants to look at information pertaining to limited entries. Filters can be selected at the top of the Database page.<br/> <br/> <br/> <br/> Figure 15: LE Filter Database
+
The filter feature can be used to narrow the list that is displayed on the main '''Database''' List page. This can be useful if the user wants to look at information pertaining to limited entries. Filters can be selected at the top of the '''Database''' page.<br/> <br/> <br/> <br/> '''Figure 15: LE Filter Database'''
  
 
&nbsp;
 
&nbsp;
Line 352: Line 368:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Add_Databases">Add Databases</span> ===
+
=== '''<span class="mw-headline" id="Add_Databases"><span class="mw-headline" id="Add_Databases">Add Databases</span></span>''' ===
  
 
&nbsp;
 
&nbsp;
Line 358: Line 374:
 
Adding a database is as easy as providing the Database details:&nbsp;
 
Adding a database is as easy as providing the Database details:&nbsp;
  
Figure 16: LE Add Database
+
&nbsp;
  
*Name - the exact name of the database on the server (address);&nbsp;  
+
'''Figure 16: LE Add Database'''
*Type - the type of database. Currently, Label Engine can extract data from Progress, ERP, PostgreSQL, MS SQL Server, and MySQL;&nbsp;  
+
 
*Plant - the plant associated with the database;&nbsp;  
+
*'''Name''' - the exact name of the database on the server (address);&nbsp;  
*Address - the TCPIP address of the database server;&nbsp;  
+
*'''Type''' - the type of database. Currently, Label Engine can extract data from Progress, ERP, PostgreSQL, MS SQL Server, and MySQL;&nbsp;  
*Port - the TCPIO port that the database is listening on;&nbsp;  
+
*'''Plant '''- the plant associated with the database;&nbsp;  
*Schema - the schema/owner of the database;&nbsp;  
+
*'''Address''' - the TCPIP address of the database server;&nbsp;  
*User - the user id to use when Label Engine connects to the database;&nbsp;  
+
*'''Port''' - the TCPIO port that the database is listening on;&nbsp;  
*Password - the password associated with User;&nbsp;  
+
*'''Schema''' - the schema/owner of the database;&nbsp;  
*Description - a freeform description of the database.&nbsp;  
+
*'''User''' - the user id to use when Label Engine connects to the database;&nbsp;  
 +
*'''Password '''- the password associated with User;&nbsp;  
 +
*'''Description''' - a freeform description of the database.&nbsp;  
  
 
&nbsp;
 
&nbsp;
Line 376: Line 394:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Edit_Databases">Edit Databases</span> ===
+
=== <span class="mw-headline" id="Edit_Databases"><span class="mw-headline" id="Edit_Databases">Edit Databases</span></span> ===
  
 
&nbsp;
 
&nbsp;
Line 384: Line 402:
 
&nbsp;
 
&nbsp;
  
Figure 17: LE Edit Database
+
'''Figure 17: LE Edit Database'''
  
 
&nbsp;
 
&nbsp;
Line 392: Line 410:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Delete_Databases">Delete Databases&nbsp;</span> ===
+
=== <span class="mw-headline" id="Delete_Databases"><span class="mw-headline" id="Delete_Databases">Delete Databases&nbsp;</span></span> ===
  
 
&nbsp;
 
&nbsp;
Line 400: Line 418:
 
&nbsp;
 
&nbsp;
  
Figure 18: LE Delete Database
+
'''Figure 18: LE Delete Database'''
  
 
&nbsp;
 
&nbsp;
Line 408: Line 426:
 
&nbsp;
 
&nbsp;
  
== <span class="mw-headline" id="Load_Database_https:.2F.2Flh5.googleusercontent.com.2FBNwKEY2yPeVR1pYWkw8b7Izjn0mdtK5EbGUXs9OWhftyUFwxo2ofeFs6fqXVMEP5hI0UOvsZ11r9klTGSVQW_iSqGSSvA7vtugJjoKPSeyxz87WqFYIlr9Y9YLeotZHtKON_-8j5gz0afapzQktbby5QBZn34podVVkdCe6KA6TxHDOlCLifzWw5Dw">Load Database&nbsp;</span> ==
+
== <span class="mw-headline" id="Load_Database"><span class="mw-headline" id="Load_Database_https:.2F.2Flh5.googleusercontent.com.2FBNwKEY2yPeVR1pYWkw8b7Izjn0mdtK5EbGUXs9OWhftyUFwxo2ofeFs6fqXVMEP5hI0UOvsZ11r9klTGSVQW_iSqGSSvA7vtugJjoKPSeyxz87WqFYIlr9Y9YLeotZHtKON_-8j5gz0afapzQktbby5QBZn34podVVkdCe6KA6TxHDOlCLifzWw5Dw">Load Database&nbsp;</span></span> ==
  
 
&nbsp;
 
&nbsp;
Line 423: Line 441:
 
&nbsp;
 
&nbsp;
  
Figure 19: LE Load Database Main Page
+
'''Figure 19: LE Load Database Main Page'''
  
 
&nbsp;
 
&nbsp;
Line 438: Line 456:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="No_Action.2FEnable.2FDisable_Tables">No Action/Enable/Disable Tables</span> ===
+
=== <span class="mw-headline" id="No_Action.2FEnable.2FDisable_Tables"><span class="mw-headline" id="No_Action.2FEnable.2FDisable_Tables">No Action/Enable/Disable Tables</span></span> ===
  
 
&nbsp;
 
&nbsp;
Line 446: Line 464:
 
&nbsp;
 
&nbsp;
  
Figure 20: LE Load Database Enable Table
+
'''Figure 20: LE Load Database Enable Table'''
  
 
&nbsp;
 
&nbsp;
Line 456: Line 474:
 
&nbsp;
 
&nbsp;
  
Figure 21: LE Load Database Disable Table.
+
'''Figure 21: LE Load Database Disable Table.'''
  
 
&nbsp;
 
&nbsp;
Line 470: Line 488:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Reload_Tables">Reload Tables</span> ===
+
=== '''<span class="mw-headline" id="Reload_Tables"><span class="mw-headline" id="Reload_Tables">Reload Tables</span></span>''' ===
  
 
&nbsp;
 
&nbsp;
  
This functionality will reload any updates done in the database tables to the current list.<br/> Click on the Reload button. A confirmation message is displayed.<br/> Select '''Yes''' to reload or '''No''' to abort. &nbsp;
+
This functionality will reload any updates done in the database tables to the current list.
 +
 
 +
<br/> Click on the Reload button. A confirmation message is displayed.
 +
 
 +
<br/> Select '''Yes''' to reload or '''No''' to abort. &nbsp;
  
 
&nbsp;
 
&nbsp;
  
Figure 22: LE Load Database Reload Tables
+
'''Figure 22: LE Load Database Reload Tables'''
  
 
&nbsp;
 
&nbsp;
Line 484: Line 506:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="View_Columns">View Columns</span> ===
+
&nbsp;
 +
 
 +
=== '''<span class="mw-headline" id="View_Columns"><span class="mw-headline" id="View_Columns">View Columns</span></span>''' ===
  
 
&nbsp;
 
&nbsp;
Line 496: Line 520:
 
&nbsp;
 
&nbsp;
  
Figure 23: LE Load Database View Columns
+
'''Figure 23: LE Load Database View Columns'''
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
  
 
&nbsp;
 
&nbsp;
<ol start="4">
+
 
<li>
+
=== '''<span class="mw-headline" id="Expose_Tables"><span class="mw-headline" id="Expose_Tables">Expose Tables&nbsp;&nbsp;</span></span>''' ===
=== <span class="mw-headline" id="Expose_Tables">Expose Tables&nbsp;&nbsp;</span> ===
 
</li>
 
</ol>
 
  
 
&nbsp;
 
&nbsp;
  
Click on Expose Tables to display the relationships between activated tables.
+
Click on '''Expose Tables''' to display the relationships between activated tables.
  
 
&nbsp;
 
&nbsp;
  
Figure 24: LE Load Database Expose Tables
+
'''Figure 24: LE Load Database Expose Tables'''
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
  
 
&nbsp;
 
&nbsp;
Line 523: Line 552:
 
&nbsp;
 
&nbsp;
  
==== <span class="mw-headline" id="Expose_Tables_-_Enable.2FDisable_Custom_Joins">Expose Tables - Enable/Disable Custom Joins</span> ====
+
==== '''<span class="mw-headline" id="Expose_Tables_-_Enable.2FDisable_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Enable.2FDisable_Custom_Joins">Expose Tables - Enable/Disable Custom Joins</span></span>''' ====
  
 
&nbsp;
 
&nbsp;
  
Select the join in the list and click on Enable Join for an available join or Disable Join for an unavailable join.&nbsp; &nbsp;
+
Select the join in the list and click on '''Enable Join''' for an available join or '''Disable Join''' for an unavailable join.&nbsp; &nbsp;
  
 
&nbsp;
 
&nbsp;
  
Figure 25: Enable/Disable Joins
+
'''Figure 25: Enable/Disable Joins'''
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
  
 
&nbsp;
 
&nbsp;
Line 539: Line 574:
 
&nbsp;
 
&nbsp;
  
==== <span class="mw-headline" id="Expose_Tables_-_Add_Custom_Joins">Expose Tables - Add Custom Joins</span> ====
+
==== '''<span class="mw-headline" id="Expose_Tables_-_Add_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Add_Custom_Joins">Expose Tables - Add Custom Joins</span></span>''' ====
  
 
&nbsp;
 
&nbsp;
Line 551: Line 586:
 
&nbsp;
 
&nbsp;
  
Figure 26: Add Custom Joins
+
'''Figure 26: Add Custom Joins'''
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
  
 
&nbsp;
 
&nbsp;
Line 568: Line 607:
 
&nbsp;
 
&nbsp;
  
==== <span class="mw-headline" id="Edit_Custom_Joins">Edit Custom Joins</span> ====
+
==== '''<span class="mw-headline" id="Edit_Custom_Joins"><span class="mw-headline" id="Edit_Custom_Joins">Edit Custom Joins</span></span>''' ====
  
 
&nbsp;
 
&nbsp;
Line 576: Line 615:
 
&nbsp;
 
&nbsp;
  
Figure 27: Edit Custom Joins
+
'''Figure 27: Edit Custom Joins'''
  
 
&nbsp;
 
&nbsp;
Line 582: Line 621:
 
&nbsp;
 
&nbsp;
  
Update the necessary information, and select Save.
+
Update the necessary information, and select '''Save'''.
  
 
&nbsp;
 
&nbsp;
  
==== '''<span class="mw-headline" id="Delete_Custom_Joins">Delete Custom Joins</span>''' ====
+
==== <span class="mw-headline" id="Delete_Custom_Joins">'''<span class="mw-headline" id="Delete_Custom_Joins">Delete Custom Joins</span>'''</span> ====
  
 
&nbsp;
 
&nbsp;
Line 594: Line 633:
 
&nbsp;
 
&nbsp;
  
Figure 28: Delete Custom Joins
+
'''Figure 28: Delete Custom Joins'''
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
  
 
&nbsp;
 
&nbsp;
Line 600: Line 643:
 
Select '''Yes''' to confirm deletion or '''No''' to abort.
 
Select '''Yes''' to confirm deletion or '''No''' to abort.
  
== &nbsp; ==
+
== <span class="mw-headline" id="_2">&nbsp;</span> ==
  
== <span class="mw-headline" id="Token_Creation_https:.2F.2Flh6.googleusercontent.com.2FsurjFDy8CRpv8XLNfF9IXCus4mZZx7CvCOWck5pl6lp9OCmrd1JnOga-J80zhPrLTwOoXxDiRUv6Bld5907MFckJ-B0E2NdeQ2tgBiNX8uVfcdkuSzfTxSC7rX9Mfj-lErYP76jm9CCxZkvecwKZrA9uS4aOGtNnbAteuW4Ch7oblBXXDYAGutwX">Token Creation&nbsp;</span> ==
+
== <span class="mw-headline" id="Token_Creation"><span class="mw-headline" id="Token_Creation_https:.2F.2Flh6.googleusercontent.com.2FsurjFDy8CRpv8XLNfF9IXCus4mZZx7CvCOWck5pl6lp9OCmrd1JnOga-J80zhPrLTwOoXxDiRUv6Bld5907MFckJ-B0E2NdeQ2tgBiNX8uVfcdkuSzfTxSC7rX9Mfj-lErYP76jm9CCxZkvecwKZrA9uS4aOGtNnbAteuW4Ch7oblBXXDYAGutwX">'''Token Creation'''&nbsp;</span></span> ==
  
 
&nbsp;
 
&nbsp;
Line 616: Line 659:
 
&nbsp;
 
&nbsp;
  
Figure 29: LE Token Main Page
+
'''Figure 29: LE Token Main Page'''
  
 
&nbsp;
 
&nbsp;
Line 633: Line 676:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Filter_Tokens">Filter Tokens</span> ===
+
=== '''<span class="mw-headline" id="Filter_Tokens"><span class="mw-headline" id="Filter_Tokens">Filter Tokens</span></span>''' ===
  
 
&nbsp;
 
&nbsp;
Line 641: Line 684:
 
&nbsp;
 
&nbsp;
  
<br/> Figure 30: LE Filter Token
+
<br/> '''Figure 30: LE Filter Token'''
  
 
&nbsp;
 
&nbsp;
Line 651: Line 694:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Add_Tokens">Add Tokens</span> ===
+
=== '''<span class="mw-headline" id="Add_Tokens"><span class="mw-headline" id="Add_Tokens">Add Tokens</span></span>''' ===
  
 
&nbsp;
 
&nbsp;
Line 663: Line 706:
 
&nbsp;
 
&nbsp;
  
Figure 31: LE Add Token
+
'''Figure 31: LE Add Token'''
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
  
 
*'''Token name''' - the name of the token&nbsp;  
 
*'''Token name''' - the name of the token&nbsp;  
Line 677: Line 726:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Edit_Tokens">Edit Tokens</span> ===
+
=== '''<span class="mw-headline" id="Edit_Tokens"><span class="mw-headline" id="Edit_Tokens">Edit Tokens</span></span>''' ===
  
 
&nbsp;
 
&nbsp;
Line 683: Line 732:
 
#To edit the token information, select a token in the list and click on the Edit button in the main page. The '''Tokens Creation '''pop-up window displays:  
 
#To edit the token information, select a token in the list and click on the Edit button in the main page. The '''Tokens Creation '''pop-up window displays:  
  
Figure 32: LE Edit Token
+
'''Figure 32: LE Edit Token'''
  
 
&nbsp;
 
&nbsp;
Line 695: Line 744:
 
&nbsp;
 
&nbsp;
  
=== <span class="mw-headline" id="Delete_Token">Delete Token</span> ===
+
=== '''<span class="mw-headline" id="Delete_Token"><span class="mw-headline" id="Delete_Token">Delete Token</span></span>''' ===
  
 
&nbsp;
 
&nbsp;
Line 703: Line 752:
 
&nbsp;
 
&nbsp;
  
Figure 33: LE Delete Token
+
'''Figure 33: LE Delete Token'''
  
 
&nbsp;
 
&nbsp;
Line 714: Line 763:
  
 
&nbsp;
 
&nbsp;
<ol start="6">
+
 
<li>
+
== '''<span class="mw-headline" id="Application_Configuration"><span class="mw-headline" id="Application_Configuration_https:.2F.2Flh3.googleusercontent.com.2FZ2n1GunNXopn6Hxs2muBqBtAbCx8wJFLd33jxfszfURymDc-zfF4IGcH3-_hNLxlzKdN5Xnysm8BWd-KLtPDialLEj9DRHM0HTzy7L8WWOzG8Wu1R7Ni7y22aUuqRK1_yqXVcEK0GgL8QlHkbBcbT088ihD1kx_wpioGc4eRjx1ZG4u6w0l0b7wC">Application Configuration&nbsp;</span></span>''' ==
== <span class="mw-headline" id="Application_Configuration_https:.2F.2Flh3.googleusercontent.com.2FZ2n1GunNXopn6Hxs2muBqBtAbCx8wJFLd33jxfszfURymDc-zfF4IGcH3-_hNLxlzKdN5Xnysm8BWd-KLtPDialLEj9DRHM0HTzy7L8WWOzG8Wu1R7Ni7y22aUuqRK1_yqXVcEK0GgL8QlHkbBcbT088ihD1kx_wpioGc4eRjx1ZG4u6w0l0b7wC">Application Configuration&nbsp;</span> ==
 
</li>
 
</ol>
 
  
 
&nbsp;
 
&nbsp;
Line 728: Line 774:
 
&nbsp;
 
&nbsp;
  
To access the '''Application Configuration''' functionality, navigate to '''Administration''' >'''Label Engine Admin''' > '''Application Configuration'''.&nbsp;
+
To access the '''Application Configuration''' functionality, navigate to '''Administration''' >&nbsp;'''Label Engine Admin''' > '''Application Configuration'''.&nbsp;
  
 
&nbsp;
 
&nbsp;
Line 734: Line 780:
 
The '''Application Configuration''' page is displayed:
 
The '''Application Configuration''' page is displayed:
  
<br/> Figure 34: Application Configuration Main Page
+
<br/> '''Figure 34: Application Configuration Main Page'''
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
  
 
&nbsp;
 
&nbsp;

Revision as of 22:59, 18 October 2022

Administration

Label Engine Admin

Version MES 15.75

Revision C1

 

 

Administration

Administrative privileges in 42Q are located in the Administration menu heading. 

With the portal, Administrators are able to access privileges from one convenient location.

Privileges include:  

  • User Maintenance
  • Plant Maintenance
  • Site Maintenance
  • Profile Maintenance
  • Generic Attribute Maintenance

 

Also located in the Administration menu heading are Shop Floor Control Administrator, Document Control, Traceability Administrator, Notification & Escalation, Meas Instance Admin, and Label Engine Admin.


To access any of the Administration Portlet, the user must sign into 42Q and then select the Administration expandable heading located in the menu on the left of the screen.

 
Figure 1: 42Q Sign-In

 

To access the Label Engine Administration page, navigate to Administration > Label Engine Admin.


Figure 2: 42Q Welcome

 

Label Engine Administration

Labels are critical to the overall manufacturing process. 42Q understands this need and has worked to develop a system for label creation, edition, and sharing. 

The Label Engine tool empowers users to control the label design and implementation process. It also provides users and their teams with a shared library of designs to further reduce the overall effort to establish a new label. 

There is tremendous value in self-service functionality and in site-to-site collaboration. 42Q has made a significant step in both of these areas with the release of the Label Engine and is working on similar capabilities throughout the MES suite. 

Label Engine Administration is responsible for System Configuration. In this portlet, Administrators can do the following:

  • Add/Edit and Delete a Customer, Printer, or Database;
  • Load a Database;
  • Token Creation;
  • Application Configuration;

 

Figure 3: LE Administration Portlet

 

Customer 


The Customer sub-module is responsible to create, edit or delete customers in the database.  

To access the customer module, navigate to Administration > LE Engine Admin >Customer.  

 

Figure 4: LE Customer

 

From the main page (Customer) the following features can be selected:

  • Filter: Filter and search the list on the page.
  • Add: Add a Customer.
  • Edit: Edit a Customer from the list.   
  • Delete: Delete a registered Customer from the list.

See below the details for each feature.

 

Filter Customers

 

The filter feature can be used to narrow the list that is displayed on the main Customer List page. This can be useful if the user wants to look at information pertaining to limited entries. Filters can be selected at the top of the Customer page.

 

Figure 5: LE Customer Name/Filter

 

 

To filter the Customer List page listings, select Name field and apply by clicking the Filter button.  

  • Name: customer name.
  • Comments: any necessary information

 

Add Customers

 

The main purpose of this feature is to add customer information. Each label is associated with a customer so, to set up a customer, the user must provide the following information:

 

  1. To add a new customer, click on the Add button on the main page. The Customer Details pop-up window displays:

 

Figure 6: Add LE Customer

 

 

The system displays a Window allowing fill up the following fields:

  • Name - the name of the customer. (each customer name must be unique) 
  • Comments - any additional free form information the user wishes to associate with the customer.

Once this information is entered, select the Save button.


Once created, a customer's details can be updated, however, only an unreferenced customer can be deleted.

 

Edit LE Customers Information

 

 

To edit customer information, select a customer in the list and click on the Edit button on the main page. The Customer Details pop-up window displays:

 

Figure 7: LE Edit Customer Information

 

 

Update any necessary information and select Save.

 

Delete Customers 

 

  1. To delete customers, select a customer in the list and click on the Delete button on the main page. A confirmation message pop-up window displays:


Figure 8: LE Delete Customer

 

 

Select Yes to confirm deletion or No to abort.  

 

Note: Only an unreferenced customer can be deleted.

 

 

Printer 

 

 

LE Admin - Printers is the interface to manage the print queues for MES 101 printing activities. Label Engine has a list of printers to which it can print labels. 


To access the Printer module, navigate to Administration > LE Administration > Printer

 

The mainPrinter page displays as shown below:

 

Figure 9: LE Printer

 

 

From the main page (Printer) the following features can be selected:

  • Filter: Filter and search the list on the page.
  • Add: Add a Printer.
  • Edit: Edit a Printer from the list.   
  • Delete: Delete a registered Printer from the list.

See below the details for each feature.

 

Filter Printers

 

The filter feature can be used to narrow the list that is displayed on the main Printer List page. This can be useful if the user wants to look at information pertaining to limited entries. Filters can be selected at the top of the Printer page.

 

Figure 10: LE Filter Printer

 

 

To filter the Printer List page listings, enter a Printer Friendly Name and/or a Print Queue Name and/or Resolution fields and apply by clicking the Filter button.

  • Queue Name - the name of the actual print queue  Resolution - the resolution of the printer, e.g. 200 dpi, 300dpi, 600 dpi, etc.
  • Printer Name - the friendly name, an alias to the actual print queue name.

 

Add Printers

The main purpose of this feature is to create new print queues. 

  1. To add a new printer, click on the Add button on the main page. The Printer Details pop-up window displays.

Note: Print Queue names are automatically generated.

 

Figure 11: LE Filter Printer

 

 

Adding a printer is as easy as providing the following details: 

  • Printer Name - the friendly name for the printer.  
  • Print Queue - the actual print queue name which is system generated. system generated  
  • Resolution - the resolution of the printer, e.g. 200 dpi, 300dpi, 600 dpi, etc.
  • Make (optional) - Description of the brand of the printer. A non functional attribute but provided to assist the plant with printer management 
  • Printer Model (optional) - description of the specific printer. A non functional attribute but provided to assist the plant with printer management
  • Description (optional) - a free-form description of the printer. A non functional attribute but provided to assist the plant with printer management
  • Connectivity Type options:
    • Edge Device 
      • Composed of hardware that performs the two essential functions of providing physical connectivity and enabling traffic between networks.

Note: Users can use the printer name or the printer queue name in the auto commands or macros to print Label Engine labels. 

Users must first select the Edge Device (also known as green grass group for legacy) from the drop down list. The above list is based upon SQA and contains testing information, and the list provided will typically contain one entry.   

Note: If there are no any entries, then no edge devices are set up.  The user can go to the IIoT portlet to create a new edge device, with details primarily outside the scope of comparison amongst the new and old LE printer screen.   

To navigate to the IIoT portlet, go to Administration > Shop Floor Control > IIoT.  

Users must also provide the IP address of the printer to which the prints will be directed. This IP network must be reachable from the edge device. Users will provide the port that the printer is listening on.    

Note: For external ports, don't limit the value, however, most of the time the value will be one of 9100, 515 or 631.  

  • VPN 
    • Accessible Directly: using a TCPIP socket.
    • VPN accessible printers:

 

The user must specify the IP address of the network reachable printer and they must select the port on which the printer is listening.

 

  • Zebra Cloud Connect
    • Zebra Link-OS enabled printers can print through the cloud.. 
    • Zebra Cloud Connect accessible printers:

 

  • For Zebra Cloud Connect printers, the only parameter the user needs to provide is the serial number of the Zebra Printer.  However, the customer must first register their zebra for use with 42-q Zebra Cloud Connect.   
  • PDD File - if a printer requires a PPD file for extra configuration it can be .
  1. Once the information is entered, select the Save button. 

 

Edit Printers

 

  1. To edit the printer information, select a printer in the list and click on the Edit button on the main page. The Printer Details pop-up window displays.

 

Figure 12: LE Edit Printer Information

 

Update any necessary information and select Save.

 

Delete Printers  

 

  1. To delete a printer , select a printer in the list and click on the Delete button on the main page. A confirmation message pop-up window displays:

 

Figure 13: LE Delete Printer

 

 

Select Yes to confirm deletion or No to abort.

 

Note: Only an unreferenced customer can be deleted.

 

Database

Before a label can use a database, a database needs to be set up and configured within the Label Engine.


To access the Database module, navigate to Administration > Label Engine Admin > Database

 

Figure 14: LE Database 

 

 

From the main page (Database) the following features can be selected:

  • Filter: Filter and search the list on the page.
  • Add: Add a Database.
  • Edit: Edit a Database from the list.   
  • Delete: Delete a Database from the list.

See below the details for each feature.

 

Filter Databases

 

The filter feature can be used to narrow the list that is displayed on the main Database List page. This can be useful if the user wants to look at information pertaining to limited entries. Filters can be selected at the top of the Database page.



Figure 15: LE Filter Database

 

 

To filter the Database List page listings, enter a database Name and/or Database Type fields and apply by clicking the Filter button.

 

Add Databases

 

Adding a database is as easy as providing the Database details: 

 

Figure 16: LE Add Database

  • Name - the exact name of the database on the server (address); 
  • Type - the type of database. Currently, Label Engine can extract data from Progress, ERP, PostgreSQL, MS SQL Server, and MySQL; 
  • Plant - the plant associated with the database; 
  • Address - the TCPIP address of the database server; 
  • Port - the TCPIO port that the database is listening on; 
  • Schema - the schema/owner of the database; 
  • User - the user id to use when Label Engine connects to the database; 
  • Password - the password associated with User; 
  • Description - a freeform description of the database. 

 

Once the information is entered and the Test Connection was successful, select the Save button to save the database information. 

 

Edit Databases

 

  1. To edit the database information, select a database in the list and click on the Edit button on the main page. The Database Details pop-up window displays:

 

Figure 17: LE Edit Database

 

Update the necessary information, select Test Connection, and if the test were successful, select Save.

 

Delete Databases 

 

  1. To delete databases, select a database in the list and click on the Delete button on the main page. A confirmation message pop-up window displays:

 

Figure 18: LE Delete Database

 

Select Yes to confirm deletion or No to abort.

 

Load Database 

 

In order to map a label to pull data from a database, the database needs to be "loaded". 
To access the Load Database functionality, navigate to Administration > Label Engine Admin > Load Database.   

The Load Database page displays:

To load databases follow the steps below: 

  1. In the resulting screen, select the database from the drop-down list and the first load will be done.
  2. A list of all tables will be loaded and displayed in the "Load Database" list.  

 

Figure 19: LE Load Database Main Page

 

 

From this list, the user cancan:

  • Enable\Disable Tables
  • Reload 
  • View Columns
  • Expose Tables

 

No Action/Enable/Disable Tables

 

The user can enable or disable tables to be used in the LE Labels. 

 

Figure 20: LE Load Database Enable Table

 

Select the table to be enabled (in black) and click on Enable Tables.

The table will be enabled and will be displayed (in blue).

 

Figure 21: LE Load Database Disable Table.

 

 

Select the table to be disabling (in blue) and click on Disable Tables.

The table will be disabled and will be displayed (in black).

 

 

Reload Tables

 

This functionality will reload any updates done in the database tables to the current list.


Click on the Reload button. A confirmation message is displayed.


Select Yes to reload or No to abort.  

 

Figure 22: LE Load Database Reload Tables

 

 

 

View Columns

 

 


Click on View Columns to display the columns list that belongs to the selected table.

 

 

Figure 23: LE Load Database View Columns

 

 

 

Expose Tables  

 

Click on Expose Tables to display the relationships between activated tables.

 

Figure 24: LE Load Database Expose Tables

 

 

 

From this functionality, the user is able to:  

  • Add Custom Join
  • Edit Custom Join
  • Delete Custom Join

 

Expose Tables - Enable/Disable Custom Joins

 

Select the join in the list and click on Enable Join for an available join or Disable Join for an unavailable join.   

 

Figure 25: Enable/Disable Joins

 

 

 

 

This functionality is used together with Enable\Disable tables. Both need to be Enable to be used on LE Labels otherwise it will not be possible to extract data from the database.

 

Expose Tables - Add Custom Joins

 

This functionality is used when tables do not have relationships and this is necessary to extract some data from the database.

To add a custom join, select Add Custom Joins button in the expose tables’ grid.

The Custom Table Join page is displayed.  

 

Figure 26: Add Custom Joins

 

 

 

 

All fields below must be filled:  

  • Entry Table/Entry Column → Destination Table/Destination Column Filter
  • Filter Name: it is the filter name.
  • Param Prompts: it is used to define a variable name. E.g: ?p1?=Attribute Name
  • Filter: it is used to define manually the joins for a destination table. E.g: serial.serial_key=attribute.serial_key AND attribute.attr_name_key = attr_name.attr_name_key AND attribute.removed = 0 and attr_name.name = ?p1?

Note: All these fields above will create the custom join the user needs to link a database field to a field number. 

 

Edit Custom Joins

 

  1. To edit the custom joins information, select a join in the list and click on the Edit button in the main page. The Custom Table Join  pop-up window displays:

 

Figure 27: Edit Custom Joins

 

 

Update the necessary information, and select Save.

 

Delete Custom Joins

 

  1. To delete custom joins, select a join in the list and click on the Delete button on the main page. A confirmation message pop-up window displays:

 

Figure 28: Delete Custom Joins

 

 

 

Select Yes to confirm deletion or No to abort.

 

Token Creation 

 

 

The token creation was developed to check the service call integrity. 
To access the Token Creation functionality, navigate to Administration > LE Administration > Token Creation

 

The Token Creation page displays:

 

Figure 29: LE Token Main Page

 

 

 

From the main page (Token Creation) the following features can be selected:

  • Filter: Filter and search the list on the page.
  • Add: Add Tokens.
  • Edit: Edit a Token from the list.   
  • Delete: Delete a Token from the list.

 

Filter Tokens

 

The filter feature can be used to narrow the list that is displayed on the main Token Creation List page. This can be useful if the user wants to look at information pertaining to limited entries. Filters can be selected at the top of the Token Creation page.

 


Figure 30: LE Filter Token

 

 

To filter the Token List page listings, enter a tokenName and/or System fields and apply by clicking the Filter button.

 

Add Tokens

 

 

To add tokens, provide the following information:  

 

 

Figure 31: LE Add Token

 

 

 

  • Token name - the name of the token 
  • Token value - this is read-only and is set by the button "Get Token Value" that generates the token automatically.
  • System – The system that will use the created token (MDS, PTS.SFDC, and rTO)

 

Once the information is entered, select the Save button. The token's details can be updated, or it can also be deleted. 

 

 

Edit Tokens

 

  1. To edit the token information, select a token in the list and click on the Edit button in the main page. The Tokens Creation pop-up window displays:

Figure 32: LE Edit Token

 

 

 

Update the necessary information, select Get Token Value, and if the test were successful select Save.

 

Delete Token

 

  1. To delete tokens, select a token in the list and click on the Delete button on the main page. A confirmation message pop-up window displays:

 

Figure 33: LE Delete Token

 

 

 

Select Yes to confirm deletion or No to abort.

 

Application Configuration 

 

 

This configuration page is used directly in the LE Labels. 

 

To access the Application Configuration functionality, navigate to AdministrationLabel Engine Admin > Application Configuration

 

The Application Configuration page is displayed:


Figure 34: Application Configuration Main Page

 

 

 

 

The application configuration displays some options that, according to the user selection, will enable or disable functionalities in the Label Engine Labels Application. See below the options description:  

 

1. Label Engine Admin View: ‘Enforce Part Number Mapping’ Section  

  • Allow Individual Labels - By selecting this option, the Part Must be Mapped option in the LE Labels can be updated according to the user's needs.

  2. Label Engine Admin View: ‘Duplicate Label-Entrol Printing Prevention Controls’ Section  

  • Enable Duplicate Printing Prevention - The default value is checked to allow the plant the ability to print duplicate printing. It can be turned off (unchecked) and the feature “Prevent duplicate printing for the same entry value” will not be available in the Label Engine Labels application.

 

  • Allow per Label Disabling of the Duplicate Printing Prevention - Once this is turned on (checked),  along with “Duplicate Printing Prevention”, the plant will have the ability to turn on duplication prevention for some labels and off for others (Default value is checked). 

 

  • Default Value of “Enable Duplicate Prevention” for New Labels - If checked, every label's initial value will be checked, if unchecked, the initial value in every label, when starting a new label will be off, and the plant will have to turn it on. (Default value is unchecked)  

 

  • Reprint Controls - If duplicate printing is turned off, this special mechanism was created to allow the ability to reprint labels that have already been printed. This feature also gives the plant the ability to turn off web service integration with Label Engine for reprinting. (Default value is unchecked)