SOP-MES0084 Target Maintenance

42Q Home > Shop Floor Control > Configuration > Target Maintenance
 

 

 

 

Shop Floor Control Configuration Target Maintenance Version MES15 1.0  

 

This SOP is 42Q's corporate standard.  This document is under revision control. The latest revision is located on Intranet.  Once printed it is an uncontrolled copy. All alterations to this SOP require approval.  Contact the IT Global Education and Training Department to submit suggested alterations and or updates.

This edition applies to MES 15 Portal 1.0 and all subsequent releases and modifications until otherwise indicated in new revisions.

---

Target Maintenance

Targets are meant to be used as a source of any custom data.

This work instruction is intended to guide users on how to manage and maintain spreadsheets faster and more efficiently and also helps any MES Application customization. It will show users how to create data adding columns (attributes) and defining the data type.

To access the target Maintenance functionalities, the user must sign into the 42Q Portal and then select the Shop Floor Control  Configuration expandable heading located in the menu on the left of the screen.

The Target Maintenance main page is displayed:

Figure 1: User Sign-in

All available Targets are listed by Target Name.
 

 

 

 

Target List

The Target List displays the following fields:

• Target Name: table name
• Last Modified: when the spreadsheet was updated and who (user) made the change
• Total Lines: the number of lines in the spreadsheet
• Verification Status: displays the target status for critical or non-critical targets

 

Note: The Total Lines have a configurable limit in the Generic Attribute enable_target_pagination_view. If the limit of rows exceeds the number of lines configured in the generic attribute a pop-up message will appear on the screen.

“Not allowed to open the target “MultiCost” it exceeds the limit of 22000 lines”

For more information, please refer to the Generic Attribute Maintenance SOP  

 

Figure 2: Total Lines Information

 

Figure 3: Target List

Filter

The user can filter the available targets by Target Name.

1. To filter the target list, enter the Target Name, and then select Filter.

Result: The target list will display the targets according to the user's entry.

Note: To begin a new search, select Clear to empty the fields and re-enter information into the available fields.
 

Add Target

Users can add a new target (empty) to add columns and lines or import a .CSV file from a local path.

1. To add a target, select the Add icon located next to the Target List tab.

Result: The target form displays.

Figure 4: Add Targets

2. Enter the Target Name; if there is a target to import, select it from the local path

3. When the user selects the checkbox Save Imported Data Right Away (selected by default), the imported target will be exactly as it is (with lines and columns filled); when left unselected, the target will be imported with only the columns and so no values are filled.

4. Select Save to complete.
 

Target Maintenance

Users can manage targets by double-clicking the target name in the Target List. The Target Maintenance page displays and the following functionalities will be available:

• Create Columns (Attributes)

• Create, Delete, and Copy Lines

• Manage Tab

• Reset, Delete, Save, and Download/ Upload Tab (.CSV)

Note: To save any table update, the user needs to select Save in the Manage Tab section.

Figure 5: Target Maintenance

 

Column (Attribute)

This functionality allows users to add columns to the selected target.

Figure 6: Target Column

 

Create Column

To access the Column Form in order to add a Column, the user should select Column.

Figure 7: Add Column Form

Fill in the available fields and select Insert.

• Column Name: The name of the new column

• Mask: enter a mask to be used in the attribute

• Type: Attribute type

• Required: if selected, the user must add a value for the column line

• Add More: if selected, a new Column Form displays automatically

• Select Save in the Manage Tab section to complete.

 

Delete Column

There is no rule to delete a column. To delete a column, simply roll the cursor over the column name and select Delete Column from the drop-down menu.

Figure 8: Delete Column

Select Save in the Manage Tab section to complete.
 

Edit Column

To edit a column, roll the cursor over the appropriate column name and select Edit Name Column from the drop-down menu.

Figure 9: Edit Column

The Edit Column Form displays. Edit the necessary fields and select Update to complete.

Figure 10: Edit Column Form

 

Target Key Column

When the user checks the Target Key checkbox, a key column displays showing a key for each table line.

Figure 11: Hide Column

 

Line Menu

This section allows users to Create, Delete, and Copy lines.

Figure 12: Line Menu

Note: To save any update in the table, select Save in the Manage Tab section.
 

Create Line

To create lines, select the Create icon within the Line Menu and a new line will be inserted at the end of the table. Repeat this process as often as necessary.

Figure 13: Create Line

Select Save in the Manage Tab section to complete.
 

Delete Line

There is no rule to delete a line. Select the line to be deleted and then select the Delete icon.

Figure 14: Delete Line

Select Save in the Manage Tab section to complete. No confirmation message is displayed when the line is deleted.
 

Copy Line

To copy a line, select the line to be copied and select the Copy line icon.

Figure 15: Copy Line

Select Save in the Manage Tab section to complete.
 

Manage Tab

This section allows users to Reset, Delete, Save, Import, and Export tables.

Figure 16: Manage Tab

 

Reset Tab

The Reset Tab icon will clear any update performed and will restore the original table values.

Figure 17: Reset Tab

 

Delete Tab

There is no rule to delete a table. Select the Delete Tab icon in the Manage Tab section. A confirmation message is displayed. Select Yes to complete.

Figure 18: Delete Tab

 

Save Tab

The Save Tab icon will save any changes made in the target. After the target has been updated, select Save.

Figure 19: Save Tab

 

Export Tab

To download tables, just select the Export Tab icon and a .CSV file should be saved locally by the user.

Figure 20: Export Tab

Sample of an exported file:

Figure 21: Exported File

 

Import Tab

To upload a target, select the Import Tab icon and select the necessary target to be uploaded.

Figure 22: Import Tab

 

---