SOP-MES0084 Target Maintenance
42Q Home > Shop Floor Control > Configuration > Target Maintenance
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
