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

RFDEIMP

Still need help? Create a Support Ticket with Stratum Support

Send comments on this topic.

← Previous Next →

 

 

Binding Function

RFDEIMP

 

Binding ID

IMPORT_EMPLOYEE_DATA

 

Binding Description

Imports Employee Object Data

 

Purpose

This is a data import Binding that is used to import employee data and any UDA's. TagNet referential data needs to be setup prior such as Company and Trade.

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.

üPrerequisite tables must be setup prior such as Company, Trade, and UDA's

üCan be executed run as needed from the Object Maintenance menu or automatically at selected intervals using the Scheduled Task Manager

üAn example of the Import layout 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

RFDEMPLM

Program Name

URI set to RFDPEIMP

Binding Setup

Binding Properties

 

File Paths and Formats

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 Employee Data Example Layout

This layout imports to Employee  table (RFDEMPLM).

Action

RFDEMPFNM

RFDEMPLNM

RFDEMPBDG

RFDEMPCOI

RFDEMPTRI

RFDEMPIMG

RFDEMPSTS

AUTHLEVEL

PSWD

DEPT

 

 

 

 

 

 

 

 

 

 

 

ADD

Peter

Smith

B12345

Acme Construction

Inspector

Peter_Smith.jpg

A

ADMIN

12345

QA

ADD

Gordon

Davis

B12300

Acme Construction

Operator

Gordon_Davis.jpg

A

USER

A5679

Production

ADD

Brett

Jones

B14000

Acme Construction

Electrician

Brett_Jones.jpg

A

USER

123402

Engineering

 

 

 

 

 

 

 

 

 

 

 

** NOTE: once added the Employee must be mapped to an RFID tag to be used for event management association.


Copyright © 2024 Stratum Global, Inc.