Conversion Information

Restrictions (Converting Up)

Because the PIES specification makes additions and deletions from one version to the next, there are certain implied limitations when moving between versions.

Here is a list of limitations necessary for the converted file to pass validation against the target xsd.

1. Kits cannot be converted from 6.4 and earlier to 6.5 due to the addition in 6.5 of required elements ComponentBrand and Description.

2. Kits cannot be converted from 7.0 to 7.1 due to the addition in 7.1 of the required element SoldSeparately.

Restrictions (Converting Down)

1. Kits that lack ComponentPartNumber / IDQualifier and ComponentBrand cannot be converted from 7.1 to 7.0 because they are optional in 7.1 and required in 7.0.

2. Prices with PriceMultiple cannot be converted from 7.1 to 7.0 (or lower) because it didn’t exist in those versions and dropping it would change the meaning of the price.

3. Interchanges involving multiple parts cannot be converted from 6.6 to 6.5 (or lower).

Of course, there can be other loss of information, especially when converting down where elements or codes don’t exist in the earlier version.

Version-Specific Rules

Converting from 6.1.2 to 6.2

• Need a default BrandAAIAID.
• Change Item - Hazardaous Material Code from X to N.

Converting from 6.2 to 6.1.2

• AttributeType may be too long. 6.2 - 80 characters, 6.1.2 - 20 characters

Converting from 6.2 to 6.3

• Limit GTIN Qualifier to UP or EN
• Drop EXPI PFP, PFU

Converting from 6.3 to 6.2

• Drop AssetType LGO
• Drop Market Copy Segment

Converting from 6.3 to 6.4

• Drop Digital Asset Old Filename.

Converting from 6.4 to 6.5

• Market Copy Type is required, so use GCC.
• Kit segment will be converted by using the file Brand AAIA ID from the Component Brand AAIA ID. Description will be populated with “Not Supplied”.

Converting from 6.5 to 6.4

• Drop any Market Copy that uses MarketCopySubCode, MarketCopySubCode Reference, or Record Sequence.
• Drop and Attribute that uses Multi-Value Quantity, Sequence

Converting from 6.5 to 6.6

• Drop Hazardous Class, Hazardous Material Class Code from HazMat.
• Convert Interchange to new format. No new required elements.

Converting from 6.6 to 6.5

• Drop interchanges where any of the following specified: SubBrand AAIAID, SubBrand Label, Reference Item.
• Drop any interchanges having more that one part.

Converting from 6.6 to 6.7

(changes to digital assets)

• Convert Details to DES description.
• Convert Additional Info to ASC description.
• Convert dates as required.

Converting from 6.7 to 6.6

• Based on the length choose either Details or Additional Info from the descriptions.
• Drop description if Sequence is used and greater than one. - Lose of information.

Converting from 6.7 to 7.0

• REM was removed from PCdb around PIES 7.0. It was replaced with Product Condition (PRC). The converter will change REM=“Y” to PRC=“REM”, but doesn’t convert REM=“N” because there isn’t a unique translation.

Converting from 7.0 to 6.7

• If Market Copy Record Sequence length > 3, drop (or should we just keep it and fail schema validation). This should be rare.

Converting from 7.0 to 7.1

• Convert Height, etc. to Merchandising Height, etc.
• Kits cannot be converted between 7.0 and 7.1 due to requirement of Component Part Terminology ID and Sold Separately.

Converting from 7.1 to 7.0

• Reverse the package dimension mapping.
• Drop kits that don’t have Component Part Number, Component Brand AAIA ID, Component ID Qualifier. These are required in PIES 7.0 and optional in PIES 7.1.