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

RFDIOIN

Still need help? Create a Support Ticket with Stratum Support

Send comments on this topic.

← Previous Next →

 

 

Binding Function

RFDIOIN

 

Binding ID

IMPORT_OBJ_INFO

 

Binding Description

Imports Object Data

 

Purpose

This is a data import Binding that is used to import customer PDI (Production Data Input) into a staging table (RFDUDAXR).  This data is typically related to Customer or Production Orders and are UDA's that are associated at the Tag level (RFDLOCEX). Subsequent workflow will access this data when tags are commissioned for orders matching on the PDI Key value.

Logic

This Binding function performs the following logic:

Polls the specified folder for any file objects that are copied there and automatically processes them

File must be a CSV (UTF-8) with all values in "double quotes" as shown in example below

Can also be XLS (Excel 97-2003) format however dates must specifed as Text format. It is not typical for systems to kick out XLS file, CSV is a more universal file format.

Valid Action codes are ADD, UPD and DLT. 

The data is transferred from UDAXR to LOCEX by means of an URI call in downstream workflow

Can be executed as needed or automatically at selected intervals using the Scheduled Task Manager

An example of the Import layout can be found here

Restrictions

 

Files Updated

RFDUDAXR

Program Name

URI set to RFDIOIN

Binding Setup

Binding Properties

 

Folder to Process

Specifies the folder path for the import to process. When a file is placed in the folder it will be processed immediately.

 

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 Object Data Example Layout in XLS

 

RFDTAGXR

RFDLOCIN

RFDLOCIN

RFDLOCIN

RFDLOCIN

RFDLOCIN

RFDLOCIN

Action

PDI

DOOR_HEIGHT

DOOR_WIDTH

DOOR_THICKNESS

DOOR_COLOR

DOOR_SPECIE

DOOR_TYPE

ADD

132000010001234567890123456

60

32

1.375

Brown

Pine

Panel

UPD

132000010001234567890123457

80

36

1.250

White

Oak

Louver

DLT

132000010001234567890123458

55

18

1.500

Black

Maple

Flush

 

Import Object Data Example Layout in CSV. (Note: must be UTF-8 format)

Notes:

ADD action will add a new PDI and any UDA's declared in the import file

UPD action will update an existing PDI including adding any new UDA's to that PDI Key

DLT action will remove an existing PDI (if exists) and delete all associated UDA's


Copyright © 2022 Stratum Global, Inc.