Delimited File Examples

New Patrons

Configuration File:

[OPTIONS]

Description=NEW EMPLOYEES

Source=Mainframe Database

Created=2022-06-01 11:30:00

BatchID=4395

RecordCount=5

 

[FORMAT]

Version=4.3

Delimiter=Comma

 

[FIELDS]

POSITION=1,NAME=IDNumber,TYPE=Core

POSITION=2,NAME=CardNumber,TYPE=Core

POSITION=3,NAME=Plan,TYPE=Core

POSITION=4,NAME=LastName,TYPE=Core

POSITION=5,NAME=FirstName,TYPE=Core

POSITION=6,NAME=MiddleName,TYPE=Core

Import (Data) File:

123243434,12324343400,1,Smith,John,Henry

232434543,23243454300,1,Wright,Karen,Lucy

343556665,34355666500,1,Thompson,Robert,Albert

456321123,45632112300,1,Kaufmann,,

544388328,54438832800,1,Jenkins,Kathleen,Susan

ID Number Conversion

Configuration File:

[OPTIONS]

Description=ID CONVERSION

RecordCount=3

 

[FORMAT]

Version=4.3

Delimiter=Comma

 

[FIELDS]

POSITION=1,NAME=IDNumber,TYPE=Core

POSITION=2,NAME=New_IDNumber,TYPE=Core

Import (Data) File:

545444545,A77767876

675747473,A12283332

453399004,A21332111