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

RFDIASF

Still need help? Create a Support Ticket with Stratum Support

Send comments on this topic.

← Previous Next →

 

 

Binding Function

RFDIASF

 

Binding ID

IMPORT_ASSET_FOLDER

 

Binding Description

Imports Object Data from Folder

 

Purpose

This is an data import Binding that is used to import customer Object data from files placed into a folder.  This includes Base Items, GTINS, Parts, Products, PDI Data as well as serialized asset data including Asset UDA's. This binding is based on RFDIAST and is more flexible as it does not require that the customer specify a specific file name and/or sheet name. See below on bottom of page for examples.

Logic

This Binding function performs the following logic:

Processes the folder path specified, validates the data and then produces an audit log with any errors

Can be run automatically at selected intervals using the Scheduled Task Manager

An example of the Import layout can be found here

NOTE: When importing Asset data 1:1 do not make the Asset ID and the Base Item the exact same value as this will cause issue with TagNet resolving to Object Type. For example if Asset ID = 'M-100245' make its corresponding Base Item identifier 'M100245' (no dash)

Import logic can be modified using Asset Import Templates defined in Asset Master Settings. As an example, the Asset referenced Base Item ID can be auto generated with a specified prefix and length using Template ID *AUTOGEN_BASEITEM. An example of the import sheet can be seen here with logic specifics below:

The [Item Brand Name] + [ERP Item] are concatenated together to make a match on TagNet Product Master, if a match is found then that BaseItem is used, if no match then a BaseItem (GTIN) will be created as below:

The logic to create the next Base Item (GTIN) will follow that of Asset ID using the System Settings. That is, it looks at the last one issued in Asset Master (of that prefix) and adds one. If none exists it starts at XX0000001

Action column not required if ADD or UPD.  If the Asset ID exists its an update, else is an Add.  Only if the asset needs to be specifically deleted is action column required using DLT action code.

The Short name and long description will default from ERP Item # (if values are blank). Example  'CISCO 1002' or 'DL 580' or 'HP BLC7000'. ** note that many Make/Model values start with Manf so it is redundant to include the Manf as well in description.

The UCCITMGTN column is not req'd as the import will always include base Item info so it is redundant.

 

Restrictions

** there are no restrictions on the file name or XLS sheet name

Files Updated

RFDASSM, RFDASSEX, UCCRCIM

Program Name

URI set to RFDIASF

Binding Setup

Binding Properties

 

Folder to Process

Enter the folder path where the import files will be placed

 

Data Format

Specify the file format type, either XLS or CSV

 

Rename File As

This statement attempts to rename the file so that it is not locked and can be processed by the import job

 

Archive File As

Specify the folder path and appended file name for archiving

 

Excel Sheet Name

If using XLS format, either a specific sheet name can be specified or *FIRST which will process the first sheet in the file.

 

Generate Audit File

Specify the folder path and appended file name for archiving

 

Audit File Format

Specify the file format type for audit file, either XLS or CSV

 

 

Import Asset Data Example Layout (Standard)

 

Import Asset Data Example Layout (Using Template)

 

 

Delete Assets via standard Import Layout using (DLT) action

 

PDI_Import_Example

 

RFDTAGXR

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

RFDLOCEX

ACTION

PDI

UNIT_HEIGHT

UNIT_WIDTH

UNIT_THICKNESS

SPECIES

DOOR_MODEL

HANDING

DOOR_ORIENTATION

COLOR_DOOR_INTERIOR

COLOR_DOOR_EXTERIOR

COLOR_SIDELITE_INTERIOR

COLOR_SIDELITE_EXTERIOR

COLOR_FRAME_INTERIOR

COLOR_FRAME_EXTERIOR

COLOR_COMPONENT_INTERIOR

COLOR_COMPONENT_EXTERIOR

PRODUCTION_DATE

QTY_ORDERED

ORDER_LINE

ORDER_NUMBER

ORDER_LINE_NUMBER

CUSTOMER_NAME

BILLING_ADDRESS

SHIPPING_ADDRESS

SHOP_DEPARTMENT

CUSTOMER_PO

JOB_NAME

ORDER_DATE

SHIP_DATE

ORIGINAL_SHIP_DATE

TRUCK_ROUTE

DOCK_DOOR

DROP_NUMBER

ADD

37467900_1

108-1/8"

32"

1-3/4"

Pine

Panel

RH

RH

ALSKN STRM

TOTL ECLIPSE

ALSKN STRM

TOTL ECLIPSE

ALSKN STRM

MRNG DOVE

ALSKN STRM

MRNG DOVE

8/29/2014

2

37467900-1

37467900

1

ACME DOOR & GLASS CO       

123 Jones RD, Chantilly, VA 20151-2948

NASSAU SUFFOLK - LOCUST VALLEY

38

492333477

CRAIG/CAB/CAM

8/29/2014

8/29/2014

8/29/2014

ENV

18

05

ADD

589430B1_1

122-1/4"

32-1/2"

1-3/4"

Pine

Panel

RH

RH

ALSKN STRM

TOTL ECLIPSE

ALSKN STRM

TOTL ECLIPSE

ALSKN STRM

MRNG DOVE

ALSKN STRM

MRNG DOVE

8/29/2014

2

589430B1-1

589430B1

1

ACME DOOR & GLASS CO       

450 Walnut St. Richmond, VA 20151-2948

NASSAU SUFFOLK - LOCUST VALLEY

38

492333477

CRAIG/CAB/CAM

8/29/2014

8/29/2014

8/29/2014

ENV

18

05

ADD

37467900_2

100-5/8"

36"

1-1/2"

Oak

Louver

RH

RH

Louver

Louver

Louver

Louver

Louver

Louver

 

 

20140829

 

 

 

 

ACME DOOR & GLASS CO       

ACME DOOR & GLASS CO       

ACME DOOR & GLASS CO       

 

 

 

 

 

 

 

 

 

DLT

37206100_1

100-5/8"

30"

1-3/4"

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

UPD

37295600_3

100-5/8"

30"

1-3/4"

Maple

Louver

 

 

Louver

Louver

Louver

Louver

Louver

Louver

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Copyright © 2023 Stratum Global, Inc.