RFDIOIN

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

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