Adjutant Wiki MW Pivot Skin

General Data Import Notes

Refer to the Data Import General Information page for information and guidance on general import timeline, formatting import templates, as well as how to ensure you are using the most current template information for data imports.

MBS Description (XRef) Import Notes

Timing and Preparation

The MBS Description (XRef) Import can be run any time after the associated Item Master records have been completely set up.

The MBS X-Ref Attribute (text1 Name = 'MBS X-REF') must exist in Rule Maintenance with the 'MBSDESCRIP' form name.

General Notes

The MBS Description (XRef) Import will NOT create the required MBS X-REF attribute for all imported item records. The MBS X-REF attribute must be added to each item record before or after the MBS Description (XRef) Import.

MBS Description (XRef) File Data Scrubbing

There are no unique requirements for scrubbing MBS Description data.

MBS Description (XRef) Import Screen (IMPORTMBSDESC)

Desktop Menu Location: Transaction>>Importers/Exporters>>Item Control>>MBS Description Import

ADJ20/20 Menu Location: Transaction>>Importers>>File Import Master (importmaster_s.HTM)

Item File Name/Browse: Use the Browse button to locate and select the completed MBS Description (XRef) Import template file (in XLS format).

Map Fields: Fields must be mapped prior to importing. If no changes have been made to the column headings, the mapping screen should show all green, and you can click OK to continue. If any of the Input Field Name columns on the left are red, single-click on the line on the left column, and then double-click the desired mapped field in the right column to complete the mapping. Repeat for any red lines on the left that should be mapped. If there are additional columns in the source file that should NOT be mapped, they can be left unmapped (displayed in red). Mandatory fields will require that they be mapped before clicking OK.

Export Template: Generates a blank MBS Description Import file

Delete ALL existing records before import: If checked, ALL existing MBS Description details will be deleted prior to importing. This checkbox should only be used if you intend to do a complete re-import of ALL MBS Description details.

Import duplicate records: If checked, duplicate line entries for the same item record will be imported and will append to any existing MBS Description details for the same item record. If unchecked, only the last line of information associated with an item record will be imported.

MBS Description (XRef) File Definitions

Required fields are indicated with an *

*Item - Item code in Adjutant

*MBSDesc - MBS Description used to match the MBS import details to the Adjutant item code (allows 50 characters, alphanumeric)

MBSColor - MBS color value from MBS file (allows 20 characters, alphanumeric)

MBSPart - MBS part value from MBS file (allows 21 characters, alphanumeric)

MBSThick - MBS thickness value from MBS file (allows 6 digits, with a decimal in the format ##.#### or ###.###)

MBSCCode - MBS color code value from MBS file (allows 2 characters, alphanumeric)

MBSClass - MBS color value from MBS file (allows 30 characters, alphanumeric)

MBS Description (XRef) Import Additional Steps

There are no additional steps needed after the import.

MBS Description (XRef) Import Reconciliation

Reconciling imported data should begin with spot-checking several records field-by-field for complete data import. Pick records from the source file that have the most data columns filled in. Verify that all source file data fields imported correctly and display as expected.

Verify that imported MBS X-REF attribute details display as expected.

MBS Description (XRef) Database Tables

PCXREF - Attributes added to item records will create cross-reference entries in the PCXREF table. The TYPE will generally be the attribute name or code. The PARENTID and CHILDID will generally match the IKEY value of the associated item.

MBSDESCRIPTION - Attributes such as MBS X-REF and Coil Receipt Defaults create their own data tables with details from the attribute jump screens. The associated FORM (jump screen) name from the ITEMATTRIB rule is generally the same name as the data table. These tables will usually link to the item using the IKEY value. AMS Cross-Reference information is stored in the MBSDESCRIPTION table linked to the IKEY of the associated item.