Import File Format Examples

This section contains basic examples illustrating the file formats for the supplier, customer, and part entities.

This page discusses:

Supplier

Below is a sample import file for a supplier, ABC CO, with two plants (Detroit, Toledo), each plant with a contact, and a Ford- and GM-specific customer ID.

V<tab>ABC CO<tab>765432<tab>EXTERNAL<CR>
VP<tab>DETROIT<CR>
VC<tab>RICHARD SMITH<tab><tab>DETROIT<tab>MATLS MGR<tab>ENGINEERING<tab>L-001<tab>RSMITH@ABC.COM<tab>(313) 456-7890<tab><tab> (313) 456-7891<tab>123 CEDAR 
ST<tab><tab>LANSING<tab>MI<tab>48234<tab><tab><CR>
VPC<tab>Ford<tab>FOMO666<CR>
PC<tab>GM<tab>43523613<CR>
VP<tab>TOLEDO<CR>
VC<tab>TOM SMITH<tab><tab>TOLEDO<tab>PLANT MGR<tab>MANU<tab><tab> 
TSMITH@ABC.COM<tab>(616) 456-7890<tab><tab><tab><tab><tab><tab><tab><tab><CR>
VPC<tab>GM<tab>43963999<CR>
VPC<tab>Ford<tab>FOMO999<CR>

Customer

Below is a sample import file for a customer, ACME MOTORS, with two vehicle programs (Lightning, Thunder), each with a customer program contact.

C<tab>ACME MOTORS<CR>
CP<tab>Lightning<CR>
CC<tab>SALLY BAYS<tab><tab>Lightning<tab>PROG. ENGINEER<tab><tab><tab><tab> 313-131-3131<tab><tab><tab><tab><tab><tab><tab>74391<tab><tab><CR>
CP<tab>Thunder<CR>
CC<tab>KAREN FEEDING<tab><tab>Thunder<tab>PROG. ENGINEER<tab><tab><tab><tab> 248-842-2482<tab><tab><tab><tab><tab><tab><tab>74391<tab><tab><CR>

Part Add

This section shows an example of the BOM data import format, where the BOM system contains only part number, part name, revision, revision date, specification, part hierarchy, part stage, quantity and unit of measure fields. For purchased parts, it also contains the supplier name.

Shown below is one assembly (sold to ACME MOTORS, for the Thunder program), which is made up of two components. One of the components is purchased from ABC CO., the other is an in-house manufactured component. In this example, the BOM system is presumed to not contain any weight, materials, substance, or customer data.

P<tab>1<tab>A123456<tab>3<tab>2000-12-03<tab>I/P FUELGAGE Assembly<tab>ASSEMBLY<tab><tab> <tab><tab><tab><tab><tab>Yes<tab>2<tab>3<tab>Yes<.tab><tab>Released<tab><tab><tab><tab><tab><CR>
PS<tab>CT-86642<CR>
PC<tab>ACME MOTORS<tab>Thunder<tab>CT-43554-50<tab><tab><CR>
P<tab>2<tab>C111123<tab>2<tab>2000-11-13<tab>FUELGAGE<tab>Component<tab>1<tab>Each<tab> <tab><tab><tab><tab><tab><tab><tab><tab><tab><tab>Released<tab>ABC CO.<tab><tab><tab><tab> <tab><CR>
P<tab>2<tab>D435433<tab>2<tab>2000-12-18<tab>FUELGAGE BRACKET<tab>Component<tab>1 <tab>Each<tab><tab><tab><tab><tab><tab><tab><tab><tab><tab><tab>Released<tab>My Internal Code<tab><tab><tab><tab> <tab><CR>

If materials data were also included as part of the BOM extract in the example above, each of the bottom-level components (C111123, D435433) should have materials (RowType= M, and potentially MS) and applicable substances (RowType= S) in the file.

Part Update

Considering the above Part Add example, there might be a case where recycling and disassembly information is obtained from a different system and needs to be entered after the part is already in Materials Compliance Management. In this case, a Part Update would need to be done.

This would involve a PUI line that identifies the part to be updated and a PUD line that indicates the data to be modified, as follows:

PUI<tab>A123456<tab>3<tab>2000-12-03<CR>
PUD<tab><tab><tab><tab><tab><tab><tab><tab><tab><tab><tab><tab><tab><tab><tab>ISO 11469<tab>2<tab>4<CR>

When imported, the 3 recycling/disassembly properties (fields 15, 16, and 17) would be modified for the part(s) with part number A123456, revision level 3, and revision date 2000-12-03. Note that multiple parts would be updated if multiple parts matched the criteria on the PUI line.

Another case of a part update would be to replace the part specification (CT-86642 in the above example) with a different part specification, for example, XY-2122. The file would look like the following:

PUI<tab>A123456<tab>3<tab>2000-12-03<CR>
PS<tab>XY-2122<CR>

After the import, this part would have only XY-2122 as a part specification.

Part Append

Considering the above part update example, there could be a case where an additional part specification is to be added (instead of replacing the current part specification).

This would be accomplished using the PAI line instead of the PUI line:

PAI<tab>A123456<tab>3<tab>2000-12-03<CR>
PS<tab>XY-2122<CR>

After the import, this part would have both CT-86642 and XY-2122 as part specifications.