General Info
Screen Name: IMPORTITEMID
Function: Import new and update existing subinventory items.
File Name/Browse: Use the Browse button to locate and select the completed contact import template file (in XLS format)
Export Template: Generates a blank Contact Import template file
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.
Validate to XLS file: Will produce an Excel file containing any errors the prevented the import.
Item ID Import File Definitions
f1 - Item - Adjutant item number
f2 - ID1 - Value for the item's ID1 field. For example, if ID1 is Length and you want to import information to stock a 20-foot piece enter '20' here.
f3 - ID2 - Value of the item's ID2 field.
f4 - Minqty - The minimum qty for ordering (in eaches)
f5 - Maxqty - The maximum qty for ordering (in eaches)
f6 - Basecost - The base cost for the item (per each).
f7 - wtval - The weight for the item (per each).
f8 - Lenval - The length of the piece. (If ID1 is lenght then import the same value here as you did for ID1.)
f9 - Sqftval - The square footage of the piece.
f10 - Wtcalc - The calculation to determine weight for the specified piece. More information about calculations can be found in the following link:
CLICK HEREf11 - Lencalc - The calculation to determine length for the specified piece. More information about calculations can be found in the following link:
CLICK HEREf12 - Costcalc - The calculation to determine the base cost for the specified piece. More information about calculations can be found in the following link:
CLICK HEREf13 - Sqftcalc - The calculation to determine square footage for the specified piece. More information about calculations can be found in the following link:
CLICK HEREf14 - Costfact - This field can be used to import a cost factor (cost per foot, for example).
f15 - Wtfact - This field can be used to import a weight factor (pound per foot, pound per sqft, etc.)
f16 - Lenfact - This field can be used to import a length factor. For example if ID1 is in inches this field could be '12' to convert the Lenghth value to feet. (In order to do this the lencalc would be '
id1/
lf'.)
f17 - Sqftfact - This field can be used to import a square footage factor.
General Import Template File Notes
*
