Welcome Guest, you are in: <root>AFIweb • Login

Page History: Import ItemID Data

Compare Page Revisions

10 9 8 7 6 5 4 3 2 1 0 Current 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Fri, 19 Jun 2020 11:34

Table of Contents [Hide/Show]    General Info    Item ID Import File Definitions    General Import Template File Notes

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 HERE

f11 - Lencalc - The calculation to determine length for the specified piece. More information about calculations can be found in the following link: CLICK HERE

f12 - Costcalc - The calculation to determine the base cost for the specified piece. More information about calculations can be found in the following link: CLICK HERE

f13 - Sqftcalc - The calculation to determine square footage for the specified piece. More information about calculations can be found in the following link: CLICK HERE

f14 - 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¶

*