Page History: Import ItemID Data
Compare Page Revisions
Page Revision: Fri, 19 Jun 2020 10:32
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 -
f9 - Sqftval -
f10 - Wtcalc -
f11 - Lencalc -
f12 - Costcalc -
f13 - Sqftcalc -
f14 - Costfact -
f15 - Wtfact -
f16 - Lenfact -
f17 - Sqftfact -
General Import Template File Notes
*
