Document Packager
The Document Packager is a mechanism that runs within the Trace Tree (Backward and Forward) and allows collecting the Document References added in different areas within Visual Mfg. such as Work Orders, Purchase Orders, etc. Depending on where you attach the documents, slightly different rules must be written to find the path to them. These rules are added within the Logic Extender module.
The snapshot below shows an example of a rule for the Backward Trace Tree for collecting Document References
Query:
SELECT [DOCUMENT].DOC_FILE_PATH + '\' + [DOCUMENT].ID AS [Document Reference] FROM [DOCUMENT] INNER JOIN DOCUMENT_REF_WO ON DOCUMENT_REF_WO.DOCUMENT_ID = [DOCUMENT].ID WHERE (DOCUMENT_REF_WO.WORKORDER_BASE_ID = @WORKORDER_BASE_ID) AND (DOCUMENT_REF_WO.WORKORDER_LOT_ID = @WORKORDER_LOT_ID) AND (DOCUMENT_REF_WO.WORKORDER_SPLIT_ID = @WORKORDER_SPLIT_ID) AND (DOCUMENT_REF_WO.WORKORDER_SUB_ID = @WORKORDER_SUB_ID) AND (DOCUMENT_REF_WO.SEQUENCE_NO = @OPERATION_SEQ_NO) AND (DOCUMENT_REF_WO.PIECE_NO = @PIECE_NO)
Values for the "Lookup Column Name":
WORKORDER_BASE_ID,WORKORDER_LOT_ID,WORKORDER_SPLIT_ID,WORKORDER_SUB_ID,OPERATION_SEQ_NO,PIECE_NO
Notes:
-
The values listed above are the parameters for the query and must be entered separated by commas without spaces.
-
The BMS-BDI app expects that the query returns a column called "Document Reference"
Procedure:
Once you have created a Backward or Forward Trace Tree, press the "Trace to Table" button.
If there were rules for collecting Document References defined within the Logic Extender, you will see a new column in the grid (table) called "Document Reference" which will contain the complete network path to the documents.
Then press the "Document Packager" button and the app will review all those paths copying the documents to a new folder called "Trace Tree Doc Packages" automatically created by the BMS-BDI app within the main application folder
The snapshot below shows some of the tables that store the relevant data depending on how the Document References are created. These tables are used for creating the rules within the Logic Extender.
