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

From 42Q
Jump to navigation Jump to search
(Created page with " '''                            &nb...")
 
 
(53 intermediate revisions by 2 users not shown)
Line 1: Line 1:
  
'''                                      '''
+
<small>[[42Q_Cloud-Based_MES/MOMS|42Q Home]] > [[Administration|Administration]] > Label Enginge Admin</small><br/> &nbsp;
<br/> <br/> <br/> <br/> <br/> <br/> <br/> <br/> <br/> <br/> <br/> <br/> <br/> <br/> &nbsp;  
 
'''Administration'''
 
  
'''Label Engine Admin'''
+
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
<center>'''Administration'''</center> <center>'''Label Engine Admin'''</center> <center>'''Version MES 15.82'''</center> <center>&nbsp;</center> <p style="text-align: center;">&nbsp;</p> <p style="text-align: center;">&nbsp;</p>
 +
&nbsp;
 +
 
 +
= <span class="mw-headline" id="Introduction"><span class="mw-headline" id="Introduction">'''Introduction'''</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;
 +
 
 +
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.&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:
 +
 
 +
*Add/Edit and Delete a Customer, Printer, or Database;
 +
*Load a Database;
 +
*Token Creation;
 +
*Application Configuration;
 +
 
 +
To access the customer module, navigate to&nbsp;'''Administration > LE Engine Admin&nbsp;'''
 +
 
 +
<br/> '''Figure 1: Label Engine'''
 +
 
 +
'''[[File:LEAV maisscreen.png|900px]]'''
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
== <span class="mw-headline" id="Customer"><span class="mw-headline" id="Customer"><span class="mw-headline" id="Customer"><span class="mw-headline" id="Customer"><span class="mw-headline" id="Customer"><span class="mw-headline" id="Customer"><span class="mw-headline" id="Customer"><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;[[File:LEAV Customer icon.png]]</span></span></span></span></span></span></span></span></span> ==
 +
 
 +
<br/> The Customer sub-module is responsible for creating, editing, or deleting customers in the database. &nbsp;
 +
 
 +
To access the customer module, navigate to '''Administration''' > '''LE Engine Admin '''>'''Customer.''' &nbsp;
 +
 
 +
Users can select the following features:
 +
 
 +
*'''Filter''': Filter and search the list on the page.
 +
*'''Add:''' Add a Customer.
 +
*'''Edit''': Edit a Customer from the list.&nbsp;&nbsp;&nbsp;
 +
*'''Delete''': Delete a registered Customer from the list.
 +
 
 +
See below the details for each feature.
 +
 
 +
&nbsp;
  
'''Version MES 15.75'''
+
=== <span class="mw-headline" id="Filter_Customers"><span class="mw-headline" id="Filter_Customers"><span class="mw-headline" id="Filter_Customers"><span class="mw-headline" id="Filter_Customers"><span class="mw-headline" id="Filter_Customers"><span class="mw-headline" id="Filter_Customers"><span class="mw-headline" id="Filter_Customers"><span class="mw-headline" id="Filter_Customers"><span class="mw-headline" id="Filter_Customers"><span class="mw-headline" id="Filter_Customers">Filter Customers</span></span></span></span></span></span></span></span></span></span> ===
  
'''Revision C1'''
+
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.
<br/>
 
= '''Administration''' =
 
&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.'''
+
'''Figure 2: LE Customer Name/Filter'''
  
'''Privileges include:'''
+
'''[[File:LEA CustomerNameFilter.png|x230px|LEA CustomerNameFilter.png]]'''
&nbsp;  
+
 
*
+
To filter the Customer List page listings, select the&nbsp;'''Name''' field and apply by clicking the '''Filter '''button.&nbsp;&nbsp;
'''User Maintenance'''
+
 
 +
&nbsp;
  
*
+
=== <span class="mw-headline" id="Add_Customers"><span class="mw-headline" id="Add_Customers"><span class="mw-headline" id="Add_Customers"><span class="mw-headline" id="Add_Customers"><span class="mw-headline" id="Add_Customers"><span class="mw-headline" id="Add_Customers"><span class="mw-headline" id="Add_Customers"><span class="mw-headline" id="Add_Customers"><span class="mw-headline" id="Add_Customers"><span class="mw-headline" id="Add_Customers">Add Customers</span></span></span></span></span></span></span></span></span></span> ===
'''Plant Maintenance'''
 
  
*
+
The primary 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:
'''Site Maintenance'''
 
  
*
+
#To add a new customer, click the '''Add''' button on the main page. The '''Customer Details''' pop-up window displays:
'''Profile Maintenance'''
 
  
*
+
The system displays a Window allowing to fill up the following fields:
'''Generic Attribute Maintenance'''
 
  
&nbsp;
+
*'''Name''' - the name of the customer. (each customer name must be unique)&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.'''
+
*'''Comments''' - any additional free form information the user wishes to associate with the customer.  
<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-inhttps://lh3.googleusercontent.com/FWJA-wSr-L4QTScrSfAD4zbn1QVWKnGJn-7Gzb-LY_kuqz5gODdtqS3qiITYfKUId9XHqsyWGVEn3ctmZGSDcRbkK0T5Pg-IA1Oz5HWwZ4Q8Cqo_OU3IAEMlh8e2lqhGpzj3MCZm4Ab1TQqVtg5pczmLMiCHwN-bhZh-j7lZblOeQAA7EKk-ovEp'''
 
&nbsp;
 
'''To access the Label Engine Administration page, navigate to Administration > Label Engine Admin.'''
 
<br/>
 
'''Figure 2: 42Q Welcomehttps://lh3.googleusercontent.com/Y33pXBKdpLfblydIyAMaOP50CRLIbBjQRYBPCeWf7IO1YxqO5NPYMHrBtxalFeUp5ZZDtE-Hte1aQ4amTvlrbrpvw3hI5sdiz0aGjAAzhrcDvBQBjcWPscXKnc5VGKNH8ugTNHNNc4z69pyIkhrEoq132LzsELtRa2QPcA6JBNIehNCVZjOg4yoV'''
 
<br/> <ol start="2">
 
<li>
 
= '''Label Engine Administration''' =
 
</li>
 
</ol>
 
&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;'''
 
  
'''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.&nbsp;'''
+
'''Figure 3: Add LE Customer'''
  
'''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;'''
+
'''[[File:LEA .AddLECustomerpng.png|x285px|LEA .AddLECustomerpng.png]]'''
  
'''Label Engine Administration is responsible for System Configuration. In this portlet, Administrators can do the following:'''
+
Once this information is entered, select the '''Save''' button.
  
*
+
<u>'''Note:'''</u>Once created, a customer's details can be updated, however, only an unreferenced customer can be deleted.
'''Add/Edit and Delete a Customer, Printer, or Database;'''
 
  
*
+
&nbsp;
'''Load a Database;'''
 
  
*
+
=== <span class="mw-headline" id="Edit_LE_Customers_Information"><span class="mw-headline" id="Edit_LE_Customers_Information"><span class="mw-headline" id="Edit_LE_Customers_Information"><span class="mw-headline" id="Edit_LE_Customers_Information"><span class="mw-headline" id="Edit_LE_Customers_Information"><span class="mw-headline" id="Edit_LE_Customers_Information"><span class="mw-headline" id="Edit_LE_Customers_Information"><span class="mw-headline" id="Edit_LE_Customers_Information"><span class="mw-headline" id="Edit_LE_Customers_Information">Edit LE Customers Information</span></span></span></span></span></span></span></span></span> ===
'''Token Creation;'''
 
  
*
+
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:
'''Application Configuration;'''
 
  
 +
&nbsp;
  
'''&nbsp;'''
+
'''Figure 4: LE Edit Customer Information'''
  
'''&nbsp;'''
+
'''[[File:LEA EditCustomerInfo.png|x255px|LEA EditCustomerInfo.png]]'''
  
'''&nbsp;'''
+
Update any necessary information and select '''Save.'''
  
'''&nbsp;'''
+
&nbsp;
&nbsp;
 
'''Figure 3: LE Administration Portlethttps://lh6.googleusercontent.com/-HS3c92EhbzSfaVJuUOSTi4QbPBq6E3wJlVJDwnfNEtpV1PrD3l97H5B8s1URq_bxfhpuFTNEmAMg3Y3mwMsuhymOnM3Vj1O0x7bpNIE7Oj85fTyJ-vQRvb8qRgt19zVYXo9ZhZ4L1oxcoWCoRxCzk8YoBtRKLT8S9UzVf3GonglMMe92Jp9-Dgvbg'''
 
  
#
+
&nbsp;
== '''Customer https://lh3.googleusercontent.com/mNYBYh88W6ODWEll2dgvAX3X5vcuhp_WoIe7w8_83IrVl5o7IT-r8zsLbSRgM95oTrpI32SXBg_c-l81mP9tQoWY-HJtwgBk2-Jqqwt_DEfvdMB49uFiravEFzQKT_6zFMD7gjIvb_JiKA2wJHdYsmgFqkWmWCzkksfHKJtPNZDffjAgo1sZ9clPeg''' ==
 
  
<br/>  
+
=== <span class="mw-headline" id="Delete_Customers"><span class="mw-headline" id="Delete_Customers"><span class="mw-headline" id="Delete_Customers"><span class="mw-headline" id="Delete_Customers"><span class="mw-headline" id="Delete_Customers"><span class="mw-headline" id="Delete_Customers"><span class="mw-headline" id="Delete_Customers"><span class="mw-headline" id="Delete_Customers"><span class="mw-headline" id="Delete_Customers"><span class="mw-headline" id="Delete_Customers"><span class="mw-headline" id="Delete_Customers">Delete Customers&nbsp;</span></span></span></span></span></span></span></span></span></span></span> ===
'''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;
 
'''Figure 4: LE Customerhttps://lh5.googleusercontent.com/kBE2-Oje42NI1uI34lHiXeESMdo7K5bhZ_AfCH6rUKuU_JYSJeDDDwSdYrMTd7iqeY5wtELfEJEjE3cAcdUUdBw7XymSG4ylakr7VFeQykM6BH1tjnRae2H0Z_g6z3GnyUdicR2VF1dyhXfzxH1J1AiW8Igs0aVFo_86h92WLUh1OwLKlymr7r2A-A'''
 
  
'''From the main page (Customer) the following features can be selected:'''
+
#To delete customers, select a customer in the list and click the '''Delete''' button on the main page. A confirmation message pop-up window displays:  
  
*
+
<br/> '''Figure 5: LE Delete Customer'''
'''Filter: Filter and search the list on the page.'''
 
  
*
+
[[File:LEA LEDeleteCustomer.png|x230px|LEA LEDeleteCustomer.png]]
'''Add: Add a Customer.'''
 
  
*
+
Select '''Yes''' to confirm deletion or '''No''' to abort. &nbsp;
'''Edit: Edit a Customer from the list.&nbsp;&nbsp;&nbsp;'''
 
  
*
+
<u>'''Note'''</u>: Only an unreferenced customer can be deleted.
'''Delete: Delete a registered Customer from the list.'''
 
  
 +
&nbsp;
  
'''See below the details for each feature.'''
+
&nbsp;
  
#
 
=== '''Filter Customers''' ===
 
  
 +
== <span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer"><span class="mw-headline" id="Printer"><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;[[File:LEA printerIcon.png]]</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span> ==
  
'''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.'''
+
'''LE Admin Printers''' is the interface that manages the print queues for MES101 printing activities. Label Engine has a list of printers to which it can print labels.&nbsp;
  
'''Figure 5: LE Customer Name/Filterhttps://lh6.googleusercontent.com/0PPlU4HBKeMO2ousA18QjB8n029VZxx2v0edC1S1do0rPqli7NQSUKW8r2hTtxbdqiHKZ8_zPDyuVQ4CU9GZG1QIHl1WFG10bE-ZHYrqsbrkiycMJJkW5fw-7BY6uYyOcbCQMPCzgUaj-NfPluLGVIM7zKr-lYQomjUF0t_Db0oac0xU2yQLF4Q-XQ'''
+
To access the '''Printer''' module, navigate to '''Administration''' > '''LE Administration '''> '''Printer'''
  
'''To filter the Customer List page listings, select Name field and apply by clicking the Filter button.'''
+
Users are able to select the following features:
&nbsp;
 
*
 
'''Name: customer name.'''
 
  
*
+
*'''Filter''': Filter and search the list on the page.
'''Comments: any necessary information'''
+
*'''Add''': Add a Printer.
 +
*'''Edit''': Edit a Printer from the list.&nbsp;&nbsp;&nbsp;
 +
*'''Delete''': Delete a registered Printer from the list.
  
&nbsp;  
+
&nbsp;
#
 
=== '''Add Customers''' ===
 
  
 +
'''Figure 6: LE Printer'''
  
'''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:'''
+
[[File:LEA LEPrinter.png|900px|LEA LEPrinter.png]]
  
#
+
&nbsp;
'''To add a new customer, click on the Add button on the main page. The Customer Details pop-up window displays:'''
 
  
 +
See below the details for each feature.
  
'''Figure 6: Add LE Customer'''
+
&nbsp;
  
'''https://lh4.googleusercontent.com/dvwmolvPtUnMYfq8sp4fSFG73FYS6ahZEAC9VB3GIkN4Uf8qAhCu8qkOr1jFq97QHzrhkgtPgQzicHXvMIJuN_p4yD7dgQBRiOeH54Two8GqoLjjPjgHINB4KsA_cWKPQyX_j0sAqhodq8XTN_VUs3pwi-3N6YgqZsSWdm5dsIpZbWI9_6uukCmckg'''
+
=== <span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers"><span class="mw-headline" id="Filter_Printers">Filter Printers</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span> ===
  
'''The system displays a Window allowing fill up the following fields:'''
+
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.
  
*
+
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.
'''Name - the name of the customer. (each customer name must be unique)&nbsp;'''
 
  
*
+
*'''Queue Name''' - the name of the actual print queue&nbsp; '''Resolution''' - the resolution of the printer, e.g. 200 dpi, 300dpi, 600 dpi, etc.
'''Comments - any additional free form information the user wishes to associate with the customer.'''
+
*Printer Name - the friendly name, an alias to the actual print queue name.
  
 +
'''Figure 7: Filter Printer'''
  
'''Once this information is entered, select the Save button.<br/> Once created, a customer's details can be updated, however, only an unreferenced customer can be deleted.'''
+
'''[[File:LEA FilterPrinter.png|x145px|LEA FilterPrinter.png]]'''
&nbsp; <ol start="2">
 
<li>
 
=== '''Edit LE Customers Information''' ===
 
</li>
 
</ol>
 
&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:'''
 
  
 +
&nbsp;
  
'''Figure 7: LE Edit Customer Information'''
+
&nbsp;
  
'''https://lh4.googleusercontent.com/Rdb3CJYZZX5Sm2TBaNYV_4uDE0HVYo3L-Dd3GweJghXRDwZAaybpqMKJZo33HoypGHe6Gg6icoSMGbz8J1U03mWtTP8QFhlLB7T76bjJEITgpnJZupfLaWAEgjQii08z3IBmZKa_GtLyeAHPVS6F0cNnfeTWASCI5TJrXpe1rXa8cbt4aoL9zuXaPg'''
 
  
'''Update any necessary information and select Save.'''
+
=== <span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers"><span class="mw-headline" id="Add_Printers">Add Printers</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span> ===
&nbsp; <ol start="3">
 
<li>
 
=== '''Delete Customers&nbsp;''' ===
 
</li>
 
</ol>
 
&nbsp;
 
#
 
'''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:'''
 
  
<br/>
+
The main purpose of this feature is to create new print queues.&nbsp;
'''Figure 8: LE Delete Customer'''
 
  
'''https://lh3.googleusercontent.com/izNRH9hCcOPTYTTdw82MhATvehL9n_eckJaR7szLhc4LBa3d3naq4rAZ5X9j6G_7KYw2NmZrb8bL8VfdVAL0z1bCRrm6HeORtT3AKh29tCHop4TOct5vpSeyOClA9QOwR_XqDMpfo55clxWu1fwur8lqV2nFVnC3Lcrl-oXYQfXsH4K0ku15wI5ikg&nbsp;'''
+
#To add a new printer, click on the Add button on the main page. The Printer Details pop-up window displays.  
&nbsp;
 
'''Select Yes to confirm deletion or No to abort.'''
 
&nbsp;
 
'''Note: Only an unreferenced customer can be deleted.'''
 
&nbsp; <ol start="2">
 
<li>
 
== '''Printer https://lh3.googleusercontent.com/zO5PICl_6uzuSxdCVvXBhPxeBmUml2IWPg_hW1S00Qead3Oi9cqMlk2HcRN2ZxbKwahKYrkcmXKJMGE5w7MlADrhNFeRvZP1DlHMyQg3MVSxgK_Zu3QqvKtb4tyx1ctFlCNWy0mCe66BDv3gC-ssbmn_IwU4Wsq31vZO2-aQUXOe7wYreSTv0yp16g''' ==
 
</li>
 
</ol>
 
  
'''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;'''
+
<u>'''Note'''</u>: Print Queue names are automatically generated.
  
<br/> '''To access the Printer module, navigate to Administration > LE Administration > Printer'''
+
&nbsp;
  
'''The main Printer page displays as shown below:'''
+
'''Figure 8: Filter Printer Details'''
  
'''Figure 9: LE Printerhttps://lh6.googleusercontent.com/vCm4n3Iwg60EmDmzb3RRXLcoyAOfMtgiD-KFoslg7O-u1GiMmwjP17xWhBMS1jThpzjrKxRhajLexoeGJ96a7ZrABQn2YGUszt7WUPKGcZ_ekwYKnSi6484PqLG7pk5R9OZxJk2KbolpgtxxR-WlVOHRQ32v1nOLAaFt5jOZR9yz2FcQM2NaOULDDg'''
+
'''[[File:LEA FilterPrinterDetails.png|x365px|LEA FilterPrinterDetails.png]]'''
  
'''From the main page (Printer) the following features can be selected:'''
+
&nbsp;
  
*
+
Adding a printer is as easy as providing the following details:&nbsp;
'''Filter: Filter and search the list on the page.'''
 
  
 +
*'''Printer Name''' - the friendly name for the printer.&nbsp;&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.
 +
*'''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
 +
*'''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:
 
*
 
*
'''Add: Add a Printer.'''
+
**Edge Device&nbsp; 
 
 
 
*
 
*
'''Edit: Edit a Printer from the list.&nbsp;&nbsp;&nbsp;'''
+
**
 +
***Composed of hardware that performs the two essential functions of providing physical connectivity and enabling traffic between networks.    
  
*
+
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;[[File:LEA Edge Device.png|LEA Edge Device.png]]
'''Delete: Delete a registered Printer from the list.'''
 
  
 +
<u>'''Note'''</u>: Users can use the printer name or the printer queue name in the auto commands or macros to print Label Engine labels.&nbsp;
  
'''See below the details for each feature.'''
+
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.&nbsp; &nbsp;
  
#
+
<u>'''Note'''</u>: If there are no entries, then no edge devices are set up.&nbsp; 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 screens.&nbsp; &nbsp;
=== '''Filter Printers''' ===
 
  
&nbsp;
+
To navigate to the IIoT portlet, go to '''Shop Floor Control >Configuration > IIoT Configuration.'''
'''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 Printerhttps://lh4.googleusercontent.com/oz2Ju9HB_9M4QeyoW_yKoCacU5b9tSifgV7QA3ZQ-y0pak5GDKIhWBL7zRmWow3qR0Zv7EbYgw7SeYrMa5ItD9XFnYX4kXLoZzl9ZxK2F6gGVNjT_CrAhOl6VP1djZw33wtiNNvFiTBY8-mEnQkQnNQDG6ctc7PYvrWNRqygyG-pS842ViWVbDbsKQ'''
+
Users must also provide the IP address of the printer to which the prints will be directed.&nbsp;This IP network must be reachable from the edge device. Users will provide the port that the printer is listening on.&nbsp;&nbsp; &nbsp;
  
'''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.'''
+
<u>'''Note'''</u>: For external ports, don't limit the value, however, most of the time the value will be one of 9100, 515 or 631. &nbsp;
  
 +
*VPN&nbsp;
 +
*
 +
**Accessible Directly: using a TCPIP socket. 
 
*
 
*
'''Queue Name - the name of the actual print queue&nbsp; Resolution - the resolution of the printer, e.g. 200 dpi, 300dpi, 600 dpi, etc.'''
+
**'''VPN accessible printers:''' 
 +
 
 +
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;[[File:LEA VPN.png|LEA VPN.png]]
  
 +
&nbsp;
 +
 +
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
 
*
 
*
'''Printer Name - the friendly name, an alias to the actual print queue name.'''
+
**Zebra Link-OS enabled printers can print through the cloud 
 +
*
 +
**Zebra Cloud Connect accessible printers: 
  
 +
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [[File:LEA ZebraCloudConnect.png|LEA ZebraCloudConnect.png]]
  
'''&nbsp;'''
+
*For Zebra Cloud Connect printers, the only parameter the user needs to provide is the serial number of the Zebra Printer.&nbsp; 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
 
<ol start="2">
 
<ol start="2">
<li>
+
<li>Once the information is entered, select the '''Save '''button.&nbsp;</li>
=== '''Add Printers''' ===
 
</li>
 
 
</ol>
 
</ol>
  
'''The main purpose of this feature is to create new print queues&nbsp;'''
+
&nbsp;
 +
 
 +
=== <span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers"><span class="mw-headline" id="Edit_Printers">Edit Printers</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span> ===
 +
 
 +
&nbsp;
 +
 
 +
#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.
 +
 
 +
&nbsp;
 +
 
 +
'''Figure 9: LE Edit Printer Information'''
 +
 
 +
'''[[File:LEA EditPrinterInfo.png|x430px|LEA EditPrinterInfo.png]]'''
 +
 
 +
Update any necessary information and select Save.
 +
 
 +
&nbsp;
 +
 
 +
=== <span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers"><span class="mw-headline" id="Delete_Printers">Delete Printers&nbsp;&nbsp;</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span> ===
 +
 
 +
#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:
 +
 
 +
&nbsp;
 +
 
 +
'''Figure 10: Delete Printer'''
 +
 
 +
'''[[File:LEA DeleteLEPrinter.png|x250px|LEA DeleteLEPrinter.png]]'''
 +
 
 +
Select '''Yes''' to confirm deletion or '''No''' to cancel.
 +
 
 +
<u>'''Note'''</u>: Only an unreferenced customer can be deleted.
 +
 
 +
&nbsp;
 +
 
 +
== <span class="mw-headline" id="Database"><span class="mw-headline" id="Database"><span class="mw-headline" id="Database"><span class="mw-headline" id="Database"><span class="mw-headline" id="Database"><span class="mw-headline" id="Database"><span class="mw-headline" id="Database"><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&nbsp;[[File:LEAV DataBase icon.png]]</span></span></span></span></span></span></span></span></span> ==
 +
 
 +
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'''
 +
 
 +
Users are able to select the following features:
 +
 
 +
*'''Filter''': Filter and search the list on the page.
 +
*'''Add''': Add a Database.
 +
*'''Edit''': Edit a Database from the list.&nbsp;&nbsp;&nbsp;
 +
*'''Delete''': Delete a Database from the list.
 +
 
 +
&nbsp;
 +
 
 +
'''Figure 11: LE Database&nbsp;'''
 +
 
 +
'''[[File:LEA databaseLE.png|x130px|LEA databaseLE.png]]'''
 +
 
 +
See below the details for each feature.
 +
 
 +
&nbsp;
 +
 
 +
=== <span class="mw-headline" id="Filter_Databases"><span class="mw-headline" id="Filter_Databases"><span class="mw-headline" id="Filter_Databases"><span class="mw-headline" id="Filter_Databases"><span class="mw-headline" id="Filter_Databases"><span class="mw-headline" id="Filter_Databases"><span class="mw-headline" id="Filter_Databases"><span class="mw-headline" id="Filter_Databases"><span class="mw-headline" id="Filter_Databases">Filter Databases</span></span></span></span></span></span></span></span></span> ===
 +
 
 +
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.
 +
 
 +
To filter the '''Database''' List page listings, enter a database '''Name''' and/or Database '''Type''' fields and apply by clicking the '''Filter''' button.
 +
 
 +
<br/> '''Figure 12: LE Filter Database'''
 +
 
 +
[[File:LEA LEDataBasefields.png|x235px|LEA LEDataBasefields.png]]
 +
 
 +
<br/> &nbsp;
 +
 
 +
&nbsp;
 +
 
 +
=== <span class="mw-headline" id="Add_Databases"><span class="mw-headline" id="Add_Databases"><span class="mw-headline" id="Add_Databases"><span class="mw-headline" id="Add_Databases"><span class="mw-headline" id="Add_Databases"><span class="mw-headline" id="Add_Databases"><span class="mw-headline" id="Add_Databases"><span class="mw-headline" id="Add_Databases"><span class="mw-headline" id="Add_Databases"><span class="mw-headline" id="Add_Databases">Add Databases</span></span></span></span></span></span></span></span></span></span> ===
 +
 
 +
Adding a database is as easy as providing the Database details:&nbsp;
 +
 
 +
'''Figure 13: LE Add Database'''
 +
 
 +
'''[[File:LEA Add Database.png|x376px|LEA Add Database.png]]'''
 +
 
 +
*'''Name''' - the exact name of the database on the server (address);&nbsp;
 +
*'''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;
 +
*'''Address''' - the TCPIP address of the database server;&nbsp;
 +
*'''Port''' - the TCPIO port that the database is listening on;&nbsp;
 +
*'''Schema''' - the schema/owner 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;
 +
 
 +
Once the information is entered and the '''Test Connection''' was successful, select the '''Save''' button to save the database information.&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
=== <span class="mw-headline" id="Edit_Databases"><span class="mw-headline" id="Edit_Databases"><span class="mw-headline" id="Edit_Databases"><span class="mw-headline" id="Edit_Databases"><span class="mw-headline" id="Edit_Databases"><span class="mw-headline" id="Edit_Databases"><span class="mw-headline" id="Edit_Databases"><span class="mw-headline" id="Edit_Databases"><span class="mw-headline" id="Edit_Databases"><span class="mw-headline" id="Edit_Databases">Edit Databases</span></span></span></span></span></span></span></span></span></span> ===
 +
 
 +
#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:
 +
 
 +
&nbsp;
 +
 
 +
'''Figure 14: LE Edit Database'''
 +
 
 +
[[File:LEA editdb.png|x370px|LEA editdb.png]]
 +
 
 +
Update the necessary information, select '''Test Connection''', and if the test were successful, select '''Save'''.
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
=== <span class="mw-headline" id="Delete_Databases"><span class="mw-headline" id="Delete_Databases"><span class="mw-headline" id="Delete_Databases"><span class="mw-headline" id="Delete_Databases"><span class="mw-headline" id="Delete_Databases"><span class="mw-headline" id="Delete_Databases"><span class="mw-headline" id="Delete_Databases"><span class="mw-headline" id="Delete_Databases"><span class="mw-headline" id="Delete_Databases"><span class="mw-headline" id="Delete_Databases">Delete Databases&nbsp;</span></span></span></span></span></span></span></span></span></span> ===
 +
 
 +
#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:
 +
 
 +
&nbsp;
 +
 
 +
'''Figure 15: LE Delete Database'''
 +
 
 +
[[File:LEA DeleteBD.png|x220px|LEA DeleteBD.png]]
 +
 
 +
Select '''Yes''' to confirm deletion or '''No''' to abort.
 +
 
 +
&nbsp;
 +
 
 +
&nbsp;
 +
 
 +
== <span class="mw-headline" id="Load_Database"><span class="mw-headline" id="Load_Database"><span class="mw-headline" id="Load_Database"><span class="mw-headline" id="Load_Database"><span class="mw-headline" id="Load_Database"><span class="mw-headline" id="Load_Database"><span class="mw-headline" id="Load_Database"><span class="mw-headline" id="Load_Database"><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;[[File:LEAV LoadDatabase Icon.png]]</span></span></span></span></span></span></span></span></span></span> ==
 +
 
 +
&nbsp;
 +
 
 +
In order to map a label to pull data from a database, the database needs to be "loaded".&nbsp;<br/> To access the Load Database functionality, navigate to '''Administration''' > '''Label Engine Admin''' > '''Load Database'''.&nbsp; &nbsp;
 +
 
 +
The '''Load Database''' page displays:
 +
 
 +
To load databases follow the steps below:&nbsp;
 +
 
 +
#In the resulting screen, select the database from the drop-down list and the first load will be done.
 +
#A list of all tables will be loaded and displayed in the "'''Load Database'''" list.&nbsp;&nbsp;
  
#
+
&nbsp;
'''To add a new printer, click on the Add button on the main page. The Printer Details pop-up window displays.'''
 
  
 +
'''Figure 16: Load Database Main Page'''
  
'''Note: Print Queue names are automatically generated.'''
+
'''[[File:LEA LoadDatabaseMainPage.png|x200px|LEA LoadDatabaseMainPage.png]]'''
  
'''Figure 11: LE Filter Printerhttps://lh5.googleusercontent.com/coq2uYzvKdwPNyn3g5_SMkxp9RgJHVfBZCifbAo6r-uBVkXvMxG97X0vRGSrOZs_eJJXi_Qh0hkyf2fs05Cxkihft-j7kqic23WMD-x86Wak8sRdgj4Z8dg2BOCkPty0ibMwIvoIFpeRauz2mw5K0r1awWjSKjNfF_yUwfz38RaB6Li4oGJDEifAsg'''
+
&nbsp;
  
'''Adding a printer is as easy as providing the following details:&nbsp;'''
+
From this list, the user can:
  
*
+
*'''Enable\Disable Tables'''
'''Printer Name - the friendly name for the printer.&nbsp;&nbsp;'''
+
*'''Reload&nbsp;'''
 +
*'''View Columns'''
 +
*'''Expose Tables'''
 +
 
 +
&nbsp;
 +
 
 +
=== <span class="mw-headline" id="No_Action.2FEnable.2FDisable_Tables"><span class="mw-headline" id="No_Action.2FEnable.2FDisable_Tables"><span class="mw-headline" id="No_Action.2FEnable.2FDisable_Tables"><span class="mw-headline" id="No_Action.2FEnable.2FDisable_Tables"><span class="mw-headline" id="No_Action.2FEnable.2FDisable_Tables"><span class="mw-headline" id="No_Action.2FEnable.2FDisable_Tables"><span class="mw-headline" id="No_Action.2FEnable.2FDisable_Tables"><span class="mw-headline" id="No_Action.2FEnable.2FDisable_Tables"><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></span></span></span></span></span></span></span></span> ===
 +
 
 +
The user can enable or disable tables to be used in the LE Labels.&nbsp;
 +
 
 +
&nbsp;
  
*
+
'''Figure 17: Load Database Enable Table'''
'''Print Queue - the actual print queue name which is system generated. system generated &nbsp;'''
 
  
*
+
'''[[File:LEA LoadDatabaseEnableTable.png|x200px|LEA LoadDatabaseEnableTable.png]]'''
'''Resolution - the resolution of the printer, e.g. 200 dpi, 300dpi, 600 dpi, etc.'''
 
  
*
+
Select the table to be enabled (in '''black''') and click on '''Enable Tables'''.
'''Make (optional) - Description of the brand of the printer. A non functional attribute but provided to assist the plant with printer management&nbsp;'''
 
  
*
+
The table will be enabled and will be displayed (in <span style="color:#3498db;">blue</span>).
'''Printer Model (optional) - description of the specific printer. A non functional attribute but provided to assist the plant with printer management'''
 
  
*
+
&nbsp;
'''Description&nbsp; (optional)- a free-form description of the printer. A non functional attribute but provided to assist the plant with printer management'''
 
  
*
+
'''Figure 18: Load Database Disable Table'''
'''Connectivity Type options:'''
 
  
**
+
'''[[File:LEA LoadDatabaseDisableTable.png|x200px|LEA LoadDatabaseDisableTable.png]]'''
'''Edge Device&nbsp;'''
 
  
***
+
Select the table to be disabled (in <span style="color:#2980b9;">blue)</span> and click on '''Disable Tables.'''
'''Composed of hardware that performs the two essential functions of providing physical connectivity and enabling traffic between networks.'''
 
   
 
  
'''https://lh3.googleusercontent.com/3iFifosr5o1Jo9_COEOKnuQqMgD-8eqfcyVC7PYITZIkyxBNnwF55sYyvgnz1pJ-axtX0JNsPmfXuNALzp3ujNLZYlnh-uGJdqQ9Xv1d20q_KbeWZxMUV3PBoUVKZSD89-H4YnPe4VSBhgWUb1ChSZ3_DQ7RPkrSA1bvSaTFvYOpOOktFxevBwyapA'''
+
The table will be disabled and will be displayed (in '''black''').
  
'''Note: Users can use the printer name or the printer queue name in the auto commands or macros to print Label Engine labels.&nbsp;'''
+
&nbsp;
  
'''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.&nbsp;'''
+
&nbsp;
&nbsp;
 
'''Note: If there are no any entries, then no edge devices are set up.&nbsp; 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&nbsp;'''
 
&nbsp;
 
'''To navigate to the IIoT portlet, go to Administration > Shop Floor Control > IIoT.'''
 
&nbsp;
 
'''Users must also provide the IP address of the printer to which the prints will be directed.&nbsp; This IP network must be reachable from the edge device. Users will provide the port that the printer is listening on.&nbsp;&nbsp;'''
 
&nbsp;
 
'''Note: For external ports, don't limit the value, however, most of the time the value will be one of 9100, 515 or 631.'''
 
&nbsp;
 
*
 
'''VPN&nbsp;'''
 
  
**
+
=== <span class="mw-headline" id="Reload_Tables"><span class="mw-headline" id="Reload_Tables"><span class="mw-headline" id="Reload_Tables"><span class="mw-headline" id="Reload_Tables"><span class="mw-headline" id="Reload_Tables"><span class="mw-headline" id="Reload_Tables"><span class="mw-headline" id="Reload_Tables"><span class="mw-headline" id="Reload_Tables"><span class="mw-headline" id="Reload_Tables"><span class="mw-headline" id="Reload_Tables">Reload Tables</span></span></span></span></span></span></span></span></span></span> ===
'''Accessible Directly: using a TCPIP socket.'''
 
  
**
+
This functionality will reload any updates done in the database tables to the current list.
'''VPN accessible printers:'''
 
 
 
  
'''https://lh4.googleusercontent.com/_mDdQcJvQcZqJlL5iWV_CE8IkUKfgC4jZJXKL708ro6S5M2Jv14P3IJ07VUTn4UI7vJ1gjQ9ns06GKgHmdK1Wd1ClLDDYhaFgJ2ecywVvqqrzr7GbQ_L1V5vypw2Ik5oCr8fnzQn__oQx6IEsSAfz9o8a_iLx6Tp8BVWAmPzpbDUMXFkN4y6uJ7AKg'''
+
<br/> Click on the Reload button. A confirmation message is displayed.
&nbsp;
 
*
 
'''The user must specify the IP address of the network reachable printer and they must select the port on which the printer is listening.'''
 
  
 +
Select '''Yes''' to reload or '''No''' to abort. &nbsp;
  
'''&nbsp;'''
+
&nbsp;
  
*
+
'''Figure 19: Load Database Reload Tables'''
'''Zebra Cloud Connect'''
 
  
**
+
'''[[File:LEA LoadDatabaseReloadTables.png|x200px|LEA LoadDatabaseReloadTables.png]]'''
'''Zebra Link-OS enabled printers can print through the cloud..&nbsp;'''
 
  
**
+
&nbsp;
'''Zebra Cloud Connect accessible printers:'''
 
 
 
  
'''https://lh4.googleusercontent.com/waG4Sfn2dJLqeOvpFpdriH51zowetazD7TrR8YinOvkNzU_jma7nJf9I9LWr-pc-lN5Ez-FlHpl85UH_XzI3axQrjObjeg30-RPVIcWbe2ZJhv-yNVYIl1pokEoWId5Es8W3qhtFXX0ONhkV93nsvyArK6AWMQGCiFv-8zik_0A8YHC4dIei_pbFFg'''
+
&nbsp;
&nbsp;  
 
*
 
'''For Zebra Cloud Connect printers, the only parameter the user needs to provide is the serial number of the Zebra Printer.&nbsp; However, the customer must first register their zebra for use with 42-q Zebra Cloud Connect.&nbsp; &nbsp;'''
 
  
&nbsp;
+
=== <span class="mw-headline" id="View_Columns"><span class="mw-headline" id="View_Columns"><span class="mw-headline" id="View_Columns"><span class="mw-headline" id="View_Columns"><span class="mw-headline" id="View_Columns"><span class="mw-headline" id="View_Columns"><span class="mw-headline" id="View_Columns"><span class="mw-headline" id="View_Columns"><span class="mw-headline" id="View_Columns"><span class="mw-headline" id="View_Columns">View Columns</span></span></span></span></span></span></span></span></span></span> ===
*
 
'''PDD File - if a printer requires a PPD file for extra configuration it can be .'''
 
  
<ol start="2">
+
Click on '''View Columns''' to display the columns list that belongs to the selected table.
<li>
 
'''Once the information is entered, select the Save button.&nbsp;'''
 
</li>
 
</ol>
 
  
'''&nbsp;'''
+
&nbsp;
<ol start="3">
 
<li>
 
=== '''Edit Printers''' ===
 
</li>
 
</ol>
 
&nbsp;
 
#
 
'''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 20: Load Database View Columns'''
  
'''Figure 12: LE Edit Printer Informationhttps://lh5.googleusercontent.com/nog170GmMcRzDScXyseCJMZeVIocPDDYff11fnqozIEmxQQ1PmHnu2ozG2-Sgdws9f8SHCJF6WnvlxKR_W-lYsJXOVqg23LmCMsYMyVXl2rcs2u3AwAUbDPICrrl0H6ebYTvaptaGeIjEtOdP45bKa6gsr73XDQ3sPrkd6atVAjf6Bj4s6S1FA-dDg'''
+
'''[[File:LEA LoadDatabaseViewColumns.png|x355px|LEA LoadDatabaseViewColumns.png]]'''
  
'''Update any necessary information and select Save.'''
+
&nbsp;
  
'''&nbsp;'''
+
&nbsp;
<ol start="4">
 
<li>
 
=== '''Delete Printers&nbsp;&nbsp;''' ===
 
</li>
 
</ol>
 
&nbsp;
 
#
 
'''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:'''
 
  
&nbsp;
+
=== <span class="mw-headline" id="Expose_Tables"><span class="mw-headline" id="Expose_Tables"><span class="mw-headline" id="Expose_Tables"><span class="mw-headline" id="Expose_Tables"><span class="mw-headline" id="Expose_Tables"><span class="mw-headline" id="Expose_Tables"><span class="mw-headline" id="Expose_Tables"><span class="mw-headline" id="Expose_Tables"><span class="mw-headline" id="Expose_Tables"><span class="mw-headline" id="Expose_Tables">Expose Tables&nbsp;&nbsp;</span></span></span></span></span></span></span></span></span></span> ===
'''Figure 13: LE Delete Printerhttps://lh3.googleusercontent.com/r8Al0pd-Ikjbo_KVpFeyrX3Rq0FPgKZ8rQwUuP7mtOn1XWl645Ez3bxbPmUHmZF1Kv86IELg0W1YrvBgSWplXhL8Un_19Mop-7p3_ygBRUXNMIPxgz6f7W-NdkQoWEMgtQN-180iyvo8TDiWbVNiUBJSUDTUqc_Lke4R0wrcIf1e7kSkdMZGptTAkw'''
 
&nbsp;  
 
'''Select Yes to confirm deletion or No to abort.'''
 
  
'''Note: Only an unreferenced customer can be deleted.'''
+
Click on '''Expose Tables''' to display the relationships between activated tables.
&nbsp; <ol start="3">
 
<li>
 
== '''Databasehttps://lh5.googleusercontent.com/hNX7fmM6l_DjXja8qGz6j6whfeNqsHnZvSG5bE3W6jUkJrkRkNk_DgO2KLF_RdsOKBoObaFk3HIvGX1EknbNPmfBECtEdrRHLHJcLLL4M9LzNiEvZDXcJ1_sSx-Lhgb_dbLON0geOTWfYKCwFLP17ZhPg_zq1MW0h564oLrWUrGNMdoqvcoklCYnxg''' ==
 
</li>
 
</ol>
 
  
'''Before a label can use a database, a database needs to be set up and configured within the Label Engine.<br/> To access the Database module, navigate to Administration > Label Engine Admin>Database'''
+
&nbsp;
  
'''Figure 14: LE Database https://lh6.googleusercontent.com/RnwCyOZVi9vIfU4CFyJNtETxeNqkxci_Gx9i6MgtuLimm9HTXfXL6RssIwZjvfAa5otIcDp8EOIthIkSn_lF1SKvCLBtxnShKgZexspgCLlNv0P0VMydTNFjd4Aw28rvOGecRkzqWgHKnWLsOzS1yhM4pSexpHUGiDRgyqb2jtKIKgZAUtWihUV01g'''
+
'''Figure 21: Load Database Expose Tables'''
&nbsp;
 
'''From the main page (Database) the following features can be selected:'''
 
  
*
+
'''[[File:LEA LoadDatabaseExposeTables.png|x425px|LEA LoadDatabaseExposeTables.png]]'''
'''Filter: Filter and search the list on the page.'''
 
  
*
+
From this functionality, the user is able to: &nbsp;
'''Add: Add a Database.'''
 
  
*
+
*'''Add Custom Join'''
'''Edit: Edit a Database from the list.&nbsp;&nbsp;&nbsp;'''
+
*'''Edit Custom Join'''
 +
*'''Delete Custom Join'''  
  
*
+
&nbsp;
'''Delete: Delete a Database from the list.'''
 
  
 +
&nbsp;
  
'''See below the details for each feature.'''
+
==== <span class="mw-headline" id="Expose_Tables_-_Enable.2FDisable_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Enable.2FDisable_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Enable.2FDisable_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Enable.2FDisable_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Enable.2FDisable_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Enable.2FDisable_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Enable.2FDisable_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Enable.2FDisable_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Enable.2FDisable_Custom_Joins"><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></span></span></span></span></span></span></span></span></span> ====
  
#
+
Select&nbsp;join in the list and click on '''Enable Join''' for an available join or '''Disable Join''' for an unavailable join.&nbsp; &nbsp;
=== '''Filter Databases''' ===
 
  
&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/> <br/> &nbsp;
 
'''Figure 15: LE Filter Databasehttps://lh6.googleusercontent.com/Mgk3-wq0KHUcfWjX6VWkALeDI7qOdjMnM-s6wpxmOnDAylQ_biUNVDI3jFwJtftvjZOQYOtnTOhCSrIycvLAJcpWJbFDoyW4CpuWyrRXLmjR9KdH9p5HFhYlrwY6hR-pv6UneQccmv6JRHjX9787zS9vVSWEDF8YXPHMFzGafiUDd4GangQJzafwhw'''
 
  
'''To filter the Database List page listings, enter a database Name and/or Database Type fields and apply by clicking the Filter button.'''
+
'''Figure 22: Enable/Disable Joins'''
<br/> <ol start="2">
 
<li>
 
=== '''Add Databases''' ===
 
</li>
 
</ol>
 
  
'''Adding a database is as easy as providing the Database details:&nbsp;'''
+
[[File:LEA EnableDisableJoins.png|x370px|LEA EnableDisableJoins.png]]
  
'''Figure 16: LE Add Databasehttps://lh4.googleusercontent.com/ZTLjioLDqIGqJcSUzyxad1gjHh6Bhj0kHtE06nnLCbJ7jkw3VyjTAdIInNQGpDvHNArYihIUFyJKiDy24YWxGdryQBslMYrdgyEojPY9lHsdjciBU4h5L1KB2DtMEPlkYEqBRybcGSs567NmZ_Jo_v_adWJMAgbwqwIl9wXvOI01Bzm3y6enLyLroA'''
+
This functionality is used together with Enable\Disable tables. Both need to be enabled to be used on LE Labels otherwise it will not be possible to extract data from the database.
&nbsp;
 
*
 
'''Name - the exact name of the database on the server (address);&nbsp;'''
 
  
*
+
&nbsp;
'''Type - the type of database. Currently, Label Engine can extract data from Progress, ERP, PostgreSQL, MS SQL Server, and MySQL;&nbsp;'''
 
  
*
+
&nbsp;
'''Plant - the plant associated with the database;&nbsp;'''
 
  
*
+
==== <span class="mw-headline" id="Expose_Tables_-_Add_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Add_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Add_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Add_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Add_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Add_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Add_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Add_Custom_Joins"><span class="mw-headline" id="Expose_Tables_-_Add_Custom_Joins"><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></span></span></span></span></span></span></span></span></span> ====
'''Address - the TCPIP address of the database server;&nbsp;'''
 
  
*
+
This functionality is used when tables do not have relationships and this is necessary to extract some data from the database.
'''Port - the TCPIO port that the database is listening on;&nbsp;'''
 
  
*
+
To add a custom join, select '''Add Custom Joins''' button in the expose tables’ grid.
'''Schema - the schema/owner of the database;&nbsp;'''
 
  
*
+
The '''Custom Table Join''' page is displayed. &nbsp;
'''User - the user id to use when Label Engine connects to the database;&nbsp;'''
 
  
*
+
&nbsp;
'''Password - the password associated with User;&nbsp;'''
 
  
*
+
'''Figure 23: Add Custom Joins'''
'''Description - a freeform description of the database.&nbsp;'''
 
  
 +
[[File:LEA AddCustomsJoins.png|x400px|LEA AddCustomsJoins.png]]
  
'''Once the information is entered and the Test Connection was successful, select the Save button to save the database information.&nbsp;'''
+
&nbsp;
  
'''&nbsp;'''
+
All fields below must be filled: &nbsp;
<ol start="3">
 
<li>
 
=== '''Edit Databases''' ===
 
</li>
 
</ol>
 
&nbsp;
 
#
 
'''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:'''
 
  
 +
*'''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?
  
'''Figure 17: LE Edit Databasehttps://lh4.googleusercontent.com/owO7mnJ6Gb-7pcHWJ4HdymwBmtgVtHwpvXwrvJpT0x0JuWTSLL4WZ_2joY_OnNKMLJvVQsTgVKY5Vq7-SPFTCXwziZehXXMJ5ENPjA4rvtgMYvwDlFqJWTGVMTTG_05yv8FlvZ0rdZLUG7NgrRgs8PnLwBmBQC55zebMMpm0X1ESc6MS9gd3ba6m7Q'''
+
<u>'''Note'''</u>: All these fields above will create the custom join the user needs to link a database field to a field number.&nbsp;
  
'''Update the necessary information, select Test Connection, and if the test were successful, select Save.'''
+
&nbsp;
  
'''&nbsp;'''
+
&nbsp;
<ol start="4">
 
<li>
 
=== '''Delete Databases&nbsp;''' ===
 
</li>
 
</ol>
 
<br/>
 
#
 
'''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:'''
 
  
&nbsp;
+
==== <span class="mw-headline" id="Edit_Custom_Joins"><span class="mw-headline" id="Edit_Custom_Joins"><span class="mw-headline" id="Edit_Custom_Joins"><span class="mw-headline" id="Edit_Custom_Joins"><span class="mw-headline" id="Edit_Custom_Joins"><span class="mw-headline" id="Edit_Custom_Joins"><span class="mw-headline" id="Edit_Custom_Joins"><span class="mw-headline" id="Edit_Custom_Joins"><span class="mw-headline" id="Edit_Custom_Joins"><span class="mw-headline" id="Edit_Custom_Joins"><span class="mw-headline" id="Edit_Custom_Joins">Edit Custom Joins</span></span></span></span></span></span></span></span></span></span></span> ====
'''Figure 18: LE Delete Databasehttps://lh3.googleusercontent.com/tWus4hFGeLgNa84jhasc5MfPhUORcuMT_LOXhNHxWtHl9ucHIC3QMPhh5QywMmxxcIcLmA9U8H-5hyPKcujqCeR8hzb3Bt_PTt-EhuuFyAybDzc2m9CRC1v6gz9VtzYtcNUzAzXdYi_R5-biGEJK2HuSYSCMBW-bbR-Rj3rhHWTGqCd1zSBDqPQu4Q'''
 
&nbsp;
 
'''Select Yes to confirm deletion or No to abort.'''
 
<ol start="4">
 
<li>
 
== '''Load Database https://lh5.googleusercontent.com/BNwKEY2yPeVR1pYWkw8b7Izjn0mdtK5EbGUXs9OWhftyUFwxo2ofeFs6fqXVMEP5hI0UOvsZ11r9klTGSVQW_iSqGSSvA7vtugJjoKPSeyxz87WqFYIlr9Y9YLeotZHtKON_-8j5gz0afapzQktbby5QBZn34podVVkdCe6KA6TxHDOlCLifzWw5Dw''' ==
 
</li>
 
</ol>
 
&nbsp;
 
'''In order to map a label to pull data from a database, the database needs to be "loaded".&nbsp;<br/> To access the Load Database functionality, navigate to Administration > Label Engine Admin>Load Database.&nbsp;'''
 
&nbsp;
 
'''The Load Database page displays:'''
 
  
'''To load databases follow the steps below:&nbsp;'''
+
#To edit the custom joins information, select a join in the list and click on the Edit button on the main page. The Custom Table Join&nbsp; pop-up window displays:
  
#
+
&nbsp;
'''In the resulting screen, select the database from the drop-down list and the first load will be done.'''
 
  
#
+
'''Figure 24: Edit Custom Joins'''
'''A list of all tables will be loaded and displayed in the "Load Database" list.&nbsp;&nbsp;'''
 
  
&nbsp;
+
'''[[File:LEA EditCustomJoins.png|x400px|LEA EditCustomJoins.png]]'''
'''Figure 19: LE Load Database Main Pagehttps://lh5.googleusercontent.com/jPX_vqmiAxd_DQXgzpL0-SdPfbJa8zFXXxcRPtrzxlWpni9WdD-LH9VZNZP5MhhraSNqyaaqzhDCOLDnnlHikqj0bhYK4jBEAO9rDLSLTtLW0uZlqmDyFU9xfHanhG9k7cIN7JeGobMjPykSx2KZiEqW9fv2fzK2MV110XKsG20jikZVq3JFILSSfA'''
 
  
'''From this list, the user cancan:'''
+
Update the necessary information, and select '''Save'''.
  
*
+
&nbsp;
'''Enable\Disable Tables'''
 
  
*
+
&nbsp;
'''Reload&nbsp;'''
 
  
*
+
==== <span class="mw-headline" id="Delete_Custom_Joins"><span class="mw-headline" id="Delete_Custom_Joins"><span class="mw-headline" id="Delete_Custom_Joins"><span class="mw-headline" id="Delete_Custom_Joins"><span class="mw-headline" id="Delete_Custom_Joins"><span class="mw-headline" id="Delete_Custom_Joins"><span class="mw-headline" id="Delete_Custom_Joins"><span class="mw-headline" id="Delete_Custom_Joins"><span class="mw-headline" id="Delete_Custom_Joins"><span class="mw-headline" id="Delete_Custom_Joins"><span class="mw-headline" id="Delete_Custom_Joins"><span class="mw-headline" id="Delete_Custom_Joins">Delete Custom Joins</span></span></span></span></span></span></span></span></span></span></span></span> ====
'''View Columns'''
 
  
*
+
#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:
'''Expose Tables'''
 
  
 +
&nbsp;
  
'''&nbsp;'''
+
'''Figure 25: Delete Custom Joins'''
  
#
+
[[File:LEA DeleteCustomJoins.png|x270px|LEA DeleteCustomJoins.png]]
=== '''No Action/Enable/Disable Tables''' ===
 
  
 +
Select '''Yes''' to confirm deletion or '''No''' to cancel.
  
'''The user can enable or disable tables to be used in the LE Labels.&nbsp;'''
+
&nbsp;
  
'''Figure 20: LE Load Database Enable Tablehttps://lh3.googleusercontent.com/pAxlAuDjeL9y7jYak3wKmXdq5z2QEwnOWxOrF89Vebb-ZuDiIX1zm26exjRbq1pB7PdzCukzUKMmmDHhJ9WdZZW8qAwarA3nNaPyjMiUyXeetYHha5nHGMR9G42OhhNF6jbBrlOAPszrpdxEaSaUp75vJLwfkUW5Xd1p5HUSYR1LQ0xQk8POL0_jfw'''
+
&nbsp;
  
'''Select the table to be enabled (in black) and click on Enable Tables.'''
+
== <span class="mw-headline" id="Token_Creation"><span class="mw-headline" id="Token_Creation"><span class="mw-headline" id="Token_Creation"><span class="mw-headline" id="Token_Creation"><span class="mw-headline" id="Token_Creation"><span class="mw-headline" id="Token_Creation"><span class="mw-headline" id="Token_Creation"><span class="mw-headline" id="Token_Creation"><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;[[File:LEAV Token Creation Icon.png]]</span></span></span></span></span></span></span></span></span></span> ==
  
'''The table will be enabled and will be displayed (in blue).'''
+
The token creation was developed to check the service call integrity.&nbsp;<br/> To access the '''Token Creation''' functionality, navigate to '''Administration''' > '''LE Administration''' > '''Token Creation'''.&nbsp;
  
'''&nbsp;'''
+
Users are able to perform the following actions:
&nbsp;
 
'''Figure 21: LE Load Database Disable Tablehttps://lh6.googleusercontent.com/JkCtFdPcS0xJco1upt9Ib5zHSTU2N61UWNHa_HAJJTqkH-exdiwmt3T8KhrK255aI3QY1h-3DPNFnGD0CDM___DgU_KPGr5RpDdKRoRZlwxNIWAX36glxGnDuFwjq7gHBstutiEZYhkH6hi5rRab3i5Akv4D7ylh19Y1fAfEkb5JG1g92HKpPjztAg'''
 
  
'''Select the table to be disabling (in blue) and click on Disable Tables.'''
+
*'''Filter''': Filter and search the list on the page.
 +
*'''Add''': Add Tokens.  
 +
*'''Edit''': Edit a Token from the list.&nbsp;&nbsp;&nbsp;
 +
*'''Delete''': Delete a Token from the list.
  
'''The table will be disabled and will be displayed (in black).'''
+
&nbsp;
  
'''&nbsp;'''
+
'''Figure 26: LE Token Main Page'''
  
'''&nbsp;'''
+
[[File:LEA Tokecreation.png|900px|LEA Tokecreation.png]]
<ol start="2">
 
<li>
 
=== '''Reload Tables''' ===
 
</li>
 
</ol>
 
  
'''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;  
 
'''Figure 22: LE Load Database Reload Tableshttps://lh5.googleusercontent.com/lD4HqBvCtjhOCcXFHjpoNvYuZHV2lH3F-2QkWssTqb76j2tYhPBqMcw7_poIE4TSbss-emTFlrA0V_jmSKdd3hUnbxwTAIPJe1EKV5aVduqRGdAJ6n2-iibbJmaDTL4hztztKxNvkp_QCbco68wPfZwayU1I8bxACbMaLoUkWTFKqlDEOfzn2riiXw'''
 
&nbsp; <ol start="3">
 
<li>
 
=== '''View Columns''' ===
 
</li>
 
</ol>
 
<br/>
 
'''Click on View Columns to display the columns list that belongs to the selected table.'''
 
  
'''&nbsp;'''
+
&nbsp;
  
'''&nbsp;'''
+
=== <span class="mw-headline" id="Filter_Tokens"><span class="mw-headline" id="Filter_Tokens"><span class="mw-headline" id="Filter_Tokens"><span class="mw-headline" id="Filter_Tokens"><span class="mw-headline" id="Filter_Tokens"><span class="mw-headline" id="Filter_Tokens"><span class="mw-headline" id="Filter_Tokens"><span class="mw-headline" id="Filter_Tokens"><span class="mw-headline" id="Filter_Tokens"><span class="mw-headline" id="Filter_Tokens">Filter Tokens</span></span></span></span></span></span></span></span></span></span> ===
  
'''Figure 23: LE Load Database View Columnshttps://lh5.googleusercontent.com/gqU-k_d0WdjFL21HZiHuKDxp-CnKMefuxb6_kSwUW20AtJGzyximNgNRSBhyrb65HUFDzfc72yx_5UEd_j9lV_TtoQCJWgiBeOG0odpjBGORcxcg7fHHsXDQ02hVi8idyHilF-oCXAft7o003ICCSSmof3-342vy82I5pu69TGw09U4YozCEoQyllg'''
+
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.
&nbsp; <ol start="4">
 
<li>
 
=== '''Expose Tables&nbsp;&nbsp;''' ===
 
</li>
 
</ol>
 
  
'''&nbsp;'''
+
<br/> '''Figure 27: LE Filter Token'''
  
'''Click on Expose Tables to display the relationships between activated tables.'''
+
[[File:LEA FilterToken.png|900px|LEA FilterToken.png]]
  
'''&nbsp;'''
+
&nbsp;
  
'''Figure 24: LE Load Database Expose Tableshttps://lh5.googleusercontent.com/foxcRWhEEvRT9gJV3LAwYQGRKImccjY3LfwG5dsnjBBs9qcYxYekejfzC4420Fu0S5op2hkOcpk8T0cZdO6HzEs_Aur5JvTbIk9LP_ZeyBq7cQcAyIljYIK9hDVyyxoQbAtbUXfodlMvY4yRUleq0WkFlt-aqeceszSOHvrKEE7BQHena8paOcx06A'''
+
To filter the '''Token''' List page listings, enter a token&nbsp;'''Name''' and/or '''System''' fields and apply by clicking the '''Filter''' button.
&nbsp;  
 
'''From this functionality, the user is able to:'''
 
&nbsp;
 
*
 
'''Add Custom Join'''
 
  
*
+
&nbsp;
'''Edit Custom Join'''
 
  
*
+
=== <span class="mw-headline" id="Add_Tokens"><span class="mw-headline" id="Add_Tokens"><span class="mw-headline" id="Add_Tokens"><span class="mw-headline" id="Add_Tokens"><span class="mw-headline" id="Add_Tokens"><span class="mw-headline" id="Add_Tokens"><span class="mw-headline" id="Add_Tokens"><span class="mw-headline" id="Add_Tokens">'''<span class="mw-headline" id="Add_Tokens"><span class="mw-headline" id="Add_Tokens">Add Tokens</span></span>'''</span></span></span></span></span></span></span></span> ===
'''Delete Custom Join'''
 
  
 +
To add tokens, provide the following information: &nbsp;
  
'''&nbsp;'''
+
'''Figure 28: LE Add Token'''
  
#
+
'''[[File:LEA AddToken.png|x228px|LEA AddToken.png]]'''
==== '''Expose Tables - Enable/Disable Custom Joins''' ====
 
  
&nbsp;
+
*'''Token name''' - the name of the token&nbsp;  
'''Select the join in the list and click on Enable Join for an available join or Disable Join for an unavailable join.&nbsp;'''
+
*'''Token value''' - this is read-only and is set by the button "Get Token Value" that generates the token automatically.  
&nbsp;
+
*'''System''' The system that will use the created token (MDS, PTS.SFDC, and rTO)
'''Figure 25: Enable/Disable Joinshttps://lh3.googleusercontent.com/jcUtfx88cyrNEQeosvmbUY0Ijve9b03BJbiP8ogpKxiJxMiYRh5M1KrfHxkTjzIpcjaExzs2t_ZQG3wA3P285ZrKdVCjysvrN-NsyJuTgL8GUusMJhyAxcRPxXN1uubVGGycNtYdm-mMrDaFAwP5PrUWAkjB2p8bXS_r8ta93rY4qVPa9ikkcwMm'''
 
&nbsp;  
 
'''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.'''
 
<br/> <ol start="2">
 
<li>
 
==== '''Expose Tables - Add Custom Joins''' ====
 
</li>
 
</ol>
 
&nbsp;
 
'''This functionality is used when tables do not have relationships and this is necessary to extract some data from the database.'''
 
&nbsp;
 
'''To add a custom join, select Add Custom Joins button in the expose tables’ grid.'''
 
&nbsp;
 
'''The Custom Table Join page is displayed.'''
 
&nbsp;
 
'''Figure 26: Add Custom Joinshttps://lh3.googleusercontent.com/67i_ZmwOasRxEJnt2PksZZu_d7hqS8UW-j7Eu4Ah5_Y3nKZ-sefXcjTWBqoeIokdrP3iDIbrfejCWnpQalMmxpjkFnSgK8BgtF3tRUlACxG3OfZA23A6sIjky7Hwz4KxPaz-miqNXYa6MnPZ0jIypg-QwEtJCr6O-9dky9_oOJFJ9uhmExo7hZFV'''
 
&nbsp;
 
'''All fields below must be filled:'''
 
&nbsp;
 
*
 
'''Entry Table/Entry Column → Destination Table/Destination Column Filter'''
 
  
 +
&nbsp;
  
*
+
Once the information is entered, select the Save button. The token's details can be updated, or it can also be deleted.&nbsp;
'''Filter Name: it is the filter name.'''
 
  
*
+
&nbsp;
'''Param Prompts: it is used to define a variable name. E.g: ?p1?=Attribute Name'''
 
  
*
+
&nbsp;
'''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?'''
 
  
&nbsp;
+
=== <span class="mw-headline" id="Edit_Tokens"><span class="mw-headline" id="Edit_Tokens"><span class="mw-headline" id="Edit_Tokens"><span class="mw-headline" id="Edit_Tokens"><span class="mw-headline" id="Edit_Tokens"><span class="mw-headline" id="Edit_Tokens"><span class="mw-headline" id="Edit_Tokens"><span class="mw-headline" id="Edit_Tokens"><span class="mw-headline" id="Edit_Tokens"><span class="mw-headline" id="Edit_Tokens">Edit Tokens</span></span></span></span></span></span></span></span></span></span> ===
'''Note: All these fields above will create the custom join the user needs to link a database field to a field number.&nbsp;'''
 
<br/> <ol start="3">
 
<li>
 
==== '''Edit Custom Joins''' ====
 
</li>
 
</ol>
 
&nbsp;
 
#
 
'''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&nbsp; 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 27: Edit Custom Joins'''
+
'''Figure 29: Edit Token'''
  
'''https://lh4.googleusercontent.com/CnTjlOWOWxFBmZsbHP1nvGm2-6TpynIRMMgvJ4606ZDQd9oTC0IOoQj9XehbLLC1FsVKkq4zvry22YvK1MVA4kQh-8qOF7GkbB_Htd_lfV5A_XHg5OETmJPU6puYAlAjfAvS4uQFLKbyv1gRPo3pxL1coxrlqwz56atov5yj6rGf-a2nSGcadggU'''
+
[[File:LEA EditToken.png|x270px|LEA EditToken.png]]
&nbsp;
 
'''Update the necessary information, and select Save.'''
 
<br/> <ol start="4">
 
<li>
 
==== '''Delete Custom Joins''' ====
 
</li>
 
</ol>
 
&nbsp;
 
#
 
'''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:'''
 
  
&nbsp;
+
Update the necessary information, select '''Get Token Value''', and if the test were successful select '''Save'''.
'''Figure 28: Delete Custom Joinshttps://lh3.googleusercontent.com/3SWzP1E-zdyX1I9nxPCihCFusDfCDJiv3BF13QbnkzvovbdQtUtkYbvAMFjPqlPO1ZLJq1iLWfL2BXzX5Ygh3zrGuen18uIg2L2pUehC9M_1u9pMgmWRMALznFx5Dm69Ba9fWeF7Ihutj1gXPMKu4r5sRK4OYmrdqbcWNxA_YLBKh_usJBOp80ET'''
 
&nbsp;
 
'''Select Yes to confirm deletion or No to abort.'''
 
<ol start="5">
 
<li>
 
== '''Token Creation https://lh6.googleusercontent.com/surjFDy8CRpv8XLNfF9IXCus4mZZx7CvCOWck5pl6lp9OCmrd1JnOga-J80zhPrLTwOoXxDiRUv6Bld5907MFckJ-B0E2NdeQ2tgBiNX8uVfcdkuSzfTxSC7rX9Mfj-lErYP76jm9CCxZkvecwKZrA9uS4aOGtNnbAteuW4Ch7oblBXXDYAGutwX''' ==
 
</li>
 
</ol>
 
&nbsp;
 
'''The token creation was developed to check the service call integrity.&nbsp;<br/> To access the Token Creation functionality, navigate to Administration > LE Administration > Token Creation.&nbsp;'''
 
  
'''&nbsp;'''
+
&nbsp;
  
'''The Token Creation page displays:'''
+
=== <span class="mw-headline" id="Delete_Token"><span class="mw-headline" id="Delete_Token"><span class="mw-headline" id="Delete_Token"><span class="mw-headline" id="Delete_Token"><span class="mw-headline" id="Delete_Token"><span class="mw-headline" id="Delete_Token"><span class="mw-headline" id="Delete_Token"><span class="mw-headline" id="Delete_Token"><span class="mw-headline" id="Delete_Token"><span class="mw-headline" id="Delete_Token">Delete Token</span></span></span></span></span></span></span></span></span></span> ===
  
'''Figure 29: LE Token Main Pagehttps://lh5.googleusercontent.com/EVgR_9qZ2332TnbxbD-BOVr1fh7Nps7ZJo3YtaVJrkz6ZBoGr7cSMg2J-sQ7hkpb-E7rR0ua6r0-bNCAFazFh30s-TxVYCE719g1aG6TA2FgmKwGy_6oK8rjxmfToTwEHx95HjX9A3el58GYJgccb9DtJxVI9mp4vODti2eWBWc1_DP85g0tItYT'''
+
#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:
  
'''From the main page (Token Creation) the following features can be selected:'''
+
&nbsp;
  
*
+
'''Figure 30: LE Delete Token'''
'''Filter: Filter and search the list on the page.'''
 
  
*
+
[[File:LEA DeleteToken.png|x220px|LEA DeleteToken.png]]
'''Add: Add Tokens.'''
 
  
*
+
Select '''Yes''' to confirm deletion or '''No''' to abort.
'''Edit: Edit a Token from the list.&nbsp;&nbsp;&nbsp;'''
 
  
*
+
&nbsp;
'''Delete: Delete a Token from the list.'''
 
  
&nbsp;
+
== <span class="mw-headline" id="Application_Configuration"><span class="mw-headline" id="Application_Configuration"><span class="mw-headline" id="Application_Configuration"><span class="mw-headline" id="Application_Configuration"><span class="mw-headline" id="Application_Configuration"><span class="mw-headline" id="Application_Configuration"><span class="mw-headline" id="Application_Configuration"><span class="mw-headline" id="Application_Configuration"><span class="mw-headline" id="Application_Configuration"><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;[[File:LEAV Application Config Icon.png]]</span></span></span></span></span></span></span></span></span></span></span> ==
#
 
=== '''Filter Tokens''' ===
 
  
&nbsp;
+
This configuration page is used directly in the LE Labels.&nbsp;
'''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.'''
 
<br/>
 
'''Figure 30: LE Filter Tokenhttps://lh5.googleusercontent.com/ykaL8O-k5b4SppvaddqKK5Xff_GYIYziRTzQ6X1TM9uLNtT81Cv84qK7OQy4ro-ffTc2DuKaF8_mFAKT68U7Tsas2yBVrRIF4wv5Jy4Yw0uyJhmA_mpSl-G2NGUXg8TtWHcMDgzT1Cher-K1JPmq6cz1tB4aZ0WspNY4We676_LRvas4m6HXUZPM'''
 
  
'''To filter the Token List page listings, enter a token Name and/or System fields and apply by clicking the Filter button.'''
+
To access the '''Application Configuration''' functionality, navigate to '''Administration''' >&nbsp;'''Label Engine Admin''' > '''Application Configuration'''.&nbsp;
&nbsp; <ol start="2">
 
<li>
 
=== '''Add Tokens''' ===
 
</li>
 
</ol>
 
&nbsp;  
 
'''To add tokens, provide the following information:'''
 
&nbsp;
 
'''Figure 31: LE Add Tokenhttps://lh5.googleusercontent.com/MSeUXpB4R39YJJ6DhtYuO83PYPXXxmr_h49pzThH61OVlICYuEpnwT1qpZR0cGGPXfgUMl4O_cUV2WC86Po7Fhk3Wx7Ym-fhFcoQuyry9RK2cLjFULSKD9-aOXRfpPPAJa7N16vAiAIIkYqgQrssRw4PWL9dI5Gyewq3RFwtTqayhhcHBhRMlPpv'''
 
&nbsp;  
 
*
 
'''Token name - the name of the token&nbsp;'''
 
  
*
+
The '''Application Configuration''' page is displayed:
'''Token value - this is read-only and is set by the button "Get Token Value" that generates the token automatically.'''
 
  
*
+
<br/> '''Figure 31: Application Configuration Main Page'''
'''System – The system that will use the created token (MDS, PTS.SFDC, and rTO)'''
 
  
 +
'''[[File:LEA ApplicationConfigurationMain.png|x360px|LEA ApplicationConfigurationMain.png]]'''
  
'''&nbsp;'''
+
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: &nbsp;
  
'''Once the information is entered, select the Save button. The token's details can be updated, or it can also be deleted.&nbsp;'''
+
&nbsp;
  
'''&nbsp;'''
+
1. Label Engine Admin View: ‘Enforce Part Number Mapping’ Section &nbsp;
  
'''&nbsp;'''
+
*'''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.  
<ol start="3">
 
<li>
 
=== '''Edit Tokens''' ===
 
</li>
 
</ol>
 
&nbsp;
 
#
 
'''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:'''
 
  
 +
&nbsp; 2. Label Engine Admin View: ‘'''Duplicate Label-Entrol Printing Prevention Controls'''’ Section &nbsp;
  
'''Figure 32: LE Edit Tokenhttps://lh3.googleusercontent.com/lnOu-yIQ-h_YQuNyjnHct7z4kbgtMxGS68SrTVr8s7TROhY1QTMMI6fQPV10xjw8zheMNVfHBekjJ6F3KIHDk7z_ynkU2cfDQyHPi9PIotOV708aavsoi2mXPidBc6x94SMsy9ocAK-lXLJ6uk-ctlOGuYphx4yjtPkE8-2eQqErmUdOy7Kq1uUj'''
+
*'''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.
  
'''Update the necessary information, select Get Token Value, and if the test were successful select Save.'''
+
&nbsp;
&nbsp; <ol start="4">
 
<li>
 
=== '''Delete Token''' ===
 
</li>
 
</ol>
 
&nbsp;
 
#
 
'''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:'''
 
  
&nbsp;
+
*'''Allow per Label Disabling of the Duplicate Printing Prevention''' - Once this is turned on (checked),&nbsp; 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).&nbsp;  
'''Figure 33: LE Delete Tokenhttps://lh4.googleusercontent.com/-QFDKKcVunmO1iuqhvthVeuajXmT2ezbMoKiWb3vYfxuQhQNusMLS8PnhdmTDiDEF6MwLvaOE9kdeX4a2KXLkTB7X6ijAPG2O-NyzIt6CtC51fxXkqnS7fcYtUp07PAC0BmCqOhai5WTJkxt9YiK9Y-UZSveJ4dD9LEXlwr7PSMYheh-SS2R2fhL'''
 
&nbsp;
 
'''Select Yes to confirm deletion or No to abort.'''
 
&nbsp; <ol start="6">
 
<li>
 
== '''Application Configuration https://lh3.googleusercontent.com/Z2n1GunNXopn6Hxs2muBqBtAbCx8wJFLd33jxfszfURymDc-zfF4IGcH3-_hNLxlzKdN5Xnysm8BWd-KLtPDialLEj9DRHM0HTzy7L8WWOzG8Wu1R7Ni7y22aUuqRK1_yqXVcEK0GgL8QlHkbBcbT088ihD1kx_wpioGc4eRjx1ZG4u6w0l0b7wC''' ==
 
</li>
 
</ol>
 
&nbsp;  
 
'''This configuration page is used directly in the LE Labels.&nbsp;'''
 
&nbsp;
 
'''To access the Application Configuration functionality, navigate to Administration > Label Engine Admin > Application Configuration.&nbsp;'''
 
&nbsp;
 
'''The Application Configuration page is displayed:'''
 
<br/>
 
'''Figure 34: Application Configuration Main Page'''
 
  
'''https://lh4.googleusercontent.com/kWOkHWA_RfR1S5oFh6A2oag0BhYjzaBr6Quqaks8b3P-eJ4UiO-5uddfiw1KXp-OCiJE2BY7Ji8GYRsEtsG2fLTBkUIazsA-QNp1sYoIJGcvw08wR7RUrQOwzwqQDFnGW1C0Lnowx16vSJGDe9lKAOyAY5zREo57fYlOnDAPEjxM8Xv6ifVVWVej'''
+
&nbsp;
&nbsp;  
 
'''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:'''
 
&nbsp;
 
'''1. Label Engine Admin View: ‘Enforce Part Number Mapping’ Section'''
 
&nbsp;
 
*
 
'''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.'''
 
  
&nbsp;
+
*'''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)&nbsp;&nbsp;
'''2. Label Engine Admin View: ‘Duplicate Label-Entrol Printing Prevention Controls’ Section'''
 
&nbsp;
 
*
 
'''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.'''
 
  
&nbsp;  
+
&nbsp;
*
 
'''Allow per Label Disabling of the Duplicate Printing Prevention - Once this is turned on (checked),&nbsp; 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).&nbsp;'''
 
  
 +
*'''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)&nbsp;
  
 
&nbsp;
 
&nbsp;
  
*
+
'''<u>Note:</u> '''For further details, see '''[[SOP-42Q-MDS0083_Label_Engine_Labels|Label Engine Labels]] '''documentation.
'''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)&nbsp;&nbsp;'''
 
  
&nbsp;
+
----
*
 
'''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)&nbsp;'''
 
  
<br/>
+
&nbsp;
'''Note: For further details, see [https://docs.google.com/document/d/1XoylUomqwCMYmKGUpQyu_p1ZSdnWFkeV459ifiLfyqE/edit?userstoinvite=Murray.Shultz@42-q.com&ts=5e74da34&actionButton=1# Label Engine Labels] documentation.'''
 
<br/> &nbsp;
 

Latest revision as of 17:09, 15 October 2024

42Q Home > Administration > Label Enginge Admin
 

 

 

 

Administration
Label Engine Admin
Version MES 15.82
 

 

 

 

Introduction

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;

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


Figure 1: Label Engine

LEAV maisscreen.png

 

 

 

Customer LEAV Customer icon.png


The Customer sub-module is responsible for creating, editing, or deleting customers in the database.  

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

Users can select the following features:

  • 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 2: LE Customer Name/Filter

LEA CustomerNameFilter.png

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

 

Add Customers

The primary 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 the Add button on the main page. The Customer Details pop-up window displays:

The system displays a Window allowing to 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.

Figure 3: Add LE Customer

LEA .AddLECustomerpng.png

Once this information is entered, select the Save button.

Note: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 4: LE Edit Customer Information

LEA EditCustomerInfo.png

Update any necessary information and select Save.

 

 

Delete Customers 

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


Figure 5: LE Delete Customer

LEA LEDeleteCustomer.png

Select Yes to confirm deletion or No to abort.  

Note: Only an unreferenced customer can be deleted.

 

 


Printer LEA printerIcon.png

LE Admin Printers is the interface that manages the print queues for MES101 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

Users are able to select the following features:

  • 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.

 

Figure 6: LE Printer

LEA LEPrinter.png

 

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.

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.

Figure 7: Filter Printer

LEA FilterPrinter.png

 

 


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 8: Filter Printer Details

LEA FilterPrinterDetails.png

 

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.

                              LEA Edge Device.png

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 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 screens.   

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

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:

                      LEA VPN.png

 

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:

                      LEA ZebraCloudConnect.png

  • 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 9: LE Edit Printer Information

LEA EditPrinterInfo.png

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 10: Delete Printer

LEA DeleteLEPrinter.png

Select Yes to confirm deletion or No to cancel.

Note: Only an unreferenced customer can be deleted.

 

Database LEAV DataBase icon.png

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

Users are able to select the following features:

  • 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.

 

Figure 11: LE Database 

LEA databaseLE.png

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.

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


Figure 12: LE Filter Database

LEA LEDataBasefields.png


 

 

Add Databases

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

Figure 13: LE Add Database

LEA Add Database.png

  • 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 14: LE Edit Database

LEA editdb.png

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 15: LE Delete Database

LEA DeleteBD.png

Select Yes to confirm deletion or No to abort.

 

 

Load Database LEAV LoadDatabase Icon.png

 

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 16: Load Database Main Page

LEA LoadDatabaseMainPage.png

 

From this list, the user can:

  • 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 17: Load Database Enable Table

LEA LoadDatabaseEnableTable.png

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 18: Load Database Disable Table

LEA LoadDatabaseDisableTable.png

Select the table to be disabled (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 19: Load Database Reload Tables

LEA LoadDatabaseReloadTables.png

 

 

View Columns

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

 

Figure 20: Load Database View Columns

LEA LoadDatabaseViewColumns.png

 

 

Expose Tables  

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

 

Figure 21: Load Database Expose Tables

LEA LoadDatabaseExposeTables.png

From this functionality, the user is able to:  

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

 

 

Expose Tables - Enable/Disable Custom Joins

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

 

Figure 22: Enable/Disable Joins

LEA EnableDisableJoins.png

This functionality is used together with Enable\Disable tables. Both need to be enabled 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 23: Add Custom Joins

LEA AddCustomsJoins.png

 

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 on the main page. The Custom Table Join  pop-up window displays:

 

Figure 24: Edit Custom Joins

LEA EditCustomJoins.png

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 25: Delete Custom Joins

LEA DeleteCustomJoins.png

Select Yes to confirm deletion or No to cancel.

 

 

Token Creation LEAV Token Creation Icon.png

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

Users are able to perform the following actions:

  • 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.

 

Figure 26: LE Token Main Page

LEA Tokecreation.png

 

 

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 27: LE Filter Token

LEA FilterToken.png

 

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

 

Add Tokens

To add tokens, provide the following information:  

Figure 28: LE Add Token

LEA AddToken.png

  • 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 29: Edit Token

LEA EditToken.png

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 30: LE Delete Token

LEA DeleteToken.png

Select Yes to confirm deletion or No to abort.

 

Application Configuration LEAV Application Config Icon.png

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 31: Application Configuration Main Page

LEA ApplicationConfigurationMain.png

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) 

 

Note: For further details, see Label Engine Labels documentation.