Prepare Smart 3D Report
Create the target MTO data from Smart 3D. The picture below shows a sample spreadsheet.
Generate a fixed length flat file using Microsoft Excel.
The following is a sample flat file:
A2 U03 300-W GMAHACABXBEPUS 8 0 0 in SP3DTEST2 1
A2 U03 300-W PPP70ABA74LGS-XS22 PPP70ABA74LG 2 0 0 in SP3DTEST2 0.25
A2 U03 300-W PWRP0A5G00S-STDS-STD108 PWRP0A5G00 10 8 0 in SP3DTEST2 1
A2 U03 300-W PFWN51FA11ADS-XSS-XS22 PFWN51FA11AD 2 0 0 in SP3DTEST2 1
BOM Import Setup
To load the file as a PDS ASCII file with company ident, we setup the Company mapping on the PDS 10.01 Configure PDS screen.
Use the following example information to set up the import in PDS 30.01 Configure BOM Import screen.
SP3D Part Number |
POS_IDENT |
SP3D Commodity Code |
POS_CC |
POS_CC_MAP is required |
BOM Import
On B.40.01 BOM Import, start the BOM import job.
When the import of the Pipe, ReinforcingPad, and Flange is complete, the Ident Code is set correctly.
Please, note that for option code there is a special behavior.
We imported this Flange ident with Option Code 1. This would not be in line with the specification which has Option Code 172.
This and other cases will be resolved in the following way:
Case 1:
If spec code and ident code exists in the import file, then check if ident exists within the spec.
If the ident does not exist in the spec, then set IdentCode = NULL.
Case 2:
If spec code, commodity code and size1 (size2, schedules) exist in the import file, then check if an Ident for this commodity code (with sizes and schedules) exists in the spec.
If one ident exists, then set the ident code.
Case 3:
Smart Materials finds and sets the correct option code by specification and ident within the specification.