Navigation: Filtering & Collection > Event Bindings > Available Bindings > Data Import Bindings >

RFDIITM

Still need help? Create a Support Ticket with Stratum Support

Send comments on this topic.

← Previous Next →

 

 

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

 

File Paths

Specifies the folder path for the import to process

 

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.

 

 

 

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 © 2022 Stratum Global, Inc.