|
Binding Function |
RFDIITM |
|
|
Binding ID |
IMPORT_ITEM_MAP_LOCN |
|
|
Binding Description |
Imports Object Data and Inventory |
|
|
Purpose |
This is a data import Binding that is used to import customer Product data including Tag mapping and Inventory. This includes Base Items. GTINS, Parts, Products, etc. TagNet referential data needs to be setup prior such as Product Category, Inventory Type and Location matrix. |
|
|
Logic |
This Binding function performs the following logic: üProcesses the file path specified, validates the data and then produces an audit log with any errors. üPolls the specified folder for any file objects that are copied there and automatically processes them üCan be executed run as needed or automatically at selected intervals using the Scheduled Task Manager üAn example of the XLS Import layout can be found here üAn example of an XML/JSON Import schema can be found here |
|
|
Restrictions |
In order to be run from the Object Maintenance menu the Binding function must be name exactly as shown |
|
|
Files Updated |
UCCRCIM, RFDTGMAP, RFDLOCIN |
|
|
Program Name |
URI set to RFDPIITM |
|
|
Binding Setup |
|
|
|
Binding Properties |
||
.png)
.png)
.png){kind=small}
.png){kind=small}
|
File Paths |
|
|
Processes the file path specified, renames & archives. Note: *name is variable representing the source name of the file that is being processed. Below is an example, refer to the the Binding Change for detailed explanations of each directive. |
|
|
|
|
.png){kind=small}
.png)
Import Item Data Example Layout
This layout imports both Location Inventory (LOCIN) as well as builds the Tag Mapping (TGMAP) association, as well as adds the GTIN (if new).
|
|
RFDTGMAP |
RFDTGMAP |
UCCRCIM |
UCCRCIM |
UCCRCIM |
UCCRCIM |
UCCRCIM |
UCCRCIM |
RFDINVTP |
UCCRCIM |
RFDLOCIN |
RFDLOCIN |
RFDLOCIN |
RFDLOCIN |
RFDLOCIN |
RFDLOCIN |
RFDLOCIN |
RFDLOCIN |
RFDTGMAP |
RFDTGMAP |
RFDTGMAP |
RFDTGMAP |
|
Action |
RFDTAGID |
RFDIID |
UCCITMGTN |
UCCERPITM |
UCCITMCCD |
UCCITMBRN |
UCCITMNAM |
UCCITMDSC |
RFDINVCCD |
UCCCRTIDN |
RFDLVL1ID |
RFDLVL2ID |
RFDLVL3ID |
RFDLVL4ID |
RFDLVL5ID |
RFDLOCQTY |
RFDLOCLOT |
RFDLTCODE |
RFDBINDTE |
RFDBINTME |
RFDITMDTE |
RFDITMTME |
|
ADD |
AAC100000000000000000011 |
|
SU_HSC01 |
SU_HSC01 |
CAT_1 |
TPD |
SU BID |
SU BID Inventory Box |
PARTS TRACKING |
SU_BID.jpg |
HSC |
COLD_ROOM |
CR_STORAGE |
|
|
|
|
20180124 |
141000 |
20180124 |
141000 |
|
|
ADD |
AAC100000000000000000012 |
|
SU_HSC02 |
SU_HSC02 |
CAT_2 |
TPD |
SU BID |
SU BID Inventory Box |
FG |
SU_BID.jpg |
HSC |
COLD_ROOM |
CR_STORAGE |
|
|
|
|
20180124 |
141000 |
20180124 |
141000 |
|
|
ADD |
AAC100000000000000000013 |
|
SU_HSC03 |
SU_HSC03 |
CAT_3 |
TPD |
Inventory BID |
Inventory BID Packet |
STOCK |
INV_BID.jpg |
HSC |
COUNTING |
ZONE_1 |
|
|
|
|
|
20180124 |
141000 |
20180124 |
141000 |
|
ADD |
AAC100000000000000000014 |
|
SU_HSC04 |
SU_HSC04 |
CAT_4 |
TPD |
Inventory BID |
Inventory BID Packet |
ITEM TRACKING |
INV_BID.jpg |
HSC |
COLD_ROOM |
CR_STORAGE |
|
|
|
|
20180124 |
141000 |
20180124 |
141000 |
|
|
ADD |
AAC100000000000000000015 |
|
SU_HSC05 |
SU_HSC05 |
CAT_5 |
TPD |
Inventory BID |
Inventory BID Packet |
CAGE TRACKING |
INV_BID.jpg |
HSC |
COUNTING |
ZONE_1 |
|
|
|
|
|
20180124 |
141000 |
20180124 |
141000 |
** NOTE: if the GTIN already exists the row will error on DUP and not be added
XML/JSON Version of the above import
The above data can be imported via a POST (XML or JSON) to the following URI http://localhost/ef/api/add-item-and-map-tags
Referential integrity still applies.. Category Code and Item Type must be defined ahead of time and Tag Location levels must match existing matrix.
|
Action |
XML & JSON Schema Options |
|
HTTP Post of XML |
<?xml version="1.0" encoding="UTF-8"?> <AddItemAndMapTags> <ItemID>NU12345</ItemID> <PartID>NU 12345</PartID> <ItemDescription>Item Description</ItemDescription> <CategoryCode>GENERIC</CategoryCode> <ItemName>NU</ItemName> <ItemBrandName>NU</ItemBrandName> <InventoryType>NU</InventoryType> <Image>NU.jpg</Image> <Tags> <Tag TagID="NUABCD1" Level1="ONE" Level2="TWO" Level3="THREE" Level4="FOUR" Level5="FIVE" Quantity="1" LotStatus="LO" LotCode="A"/> <Tag TagID="NUABCD2" Level1="ONE" Level2="TWO" Level3="THREE" Level4="FOUR" Level5="FIVE" Quantity="1" LotStatus="LO" LotCode="A"/> <Tag TagID="NUABCD3" Level1="ONE" Level2="TWO" Level3="THREE" Level4="FOUR" Level5="FIVE" Quantity="1" LotStatus="LO" LotCode="A"/> </Tags> </AddItemAndMapTags> |
|
HTTP Post of JSON |
{ "ItemID": "NU12345", "PartID": "NU 12345", "ItemDescription": "Item Description", "CategoryCode": "GENERIC", "ItemName": "NU", "ItemBrandName": "NU", "InventoryType": "NU", "Image": "NU.jpg", "Tags": [ { "@TagID": "NUABCD1", "@Level1": "ONE", "@Level2": "TWO", "@Level3": "THREE", "@Level4": "FOUR", "@Level5": "FIVE", "@Quantity": "1", "@LotStatus": "LO", "@LotCode": "A" }, { "@TagID": "NUABCD2", "@Level1": "ONE", "@Level2": "TWO", "@Level3": "THREE", "@Level4": "FOUR", "@Level5": "FIVE", "@Quantity": "1", "@LotStatus": "LO", "@LotCode": "A" }, { "@TagID": "NUABCD3", "@Level1": "ONE", "@Level2": "TWO", "@Level3": "THREE", "@Level4": "FOUR", "@Level5": "FIVE", "@Quantity": "1", "@LotStatus": "LO", "@LotCode": "A" } ] } |
Copyright © 2024 Stratum Global, Inc.