Page History: MBS Description (XRef) Import
Compare Page Revisions
Page Revision: Wed, 17 Jul 2019 14:59
General Information
Default Menu Location Transactions >> Importers/Exporters >> Item Control >> MBS Description Import
Screen Name IMPORTMBSDESC
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.
Additional Information
MBS X-REF Attribute: The MBS X-Ref Attribute (text1 Name = 'MBS X-REF') must exist in Rule Maintenance with the 'MBSDESCRIP' form name. 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 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)
