Skip to content

Example Two

This Text File holds employment records.

It is a flat, comma delimited, unenclosed file without a header or type record.

It has 2 Lists.

The Schema File only has fields if they have a value (Base.[Field Presence]), and it does not have trailing delimiters (Base.[Trailing Delimiters]).

Sample Source File

magnis.dis@urna.co.uk,Dylan,Ramsey,Dylan Ramsey,IT Manager,Information Technology,123451,123-555-1211,123-555-6641,123-555-9821,1 Microsoft way,Redmond,Wa,98052,United States,2012-05-16
Nulla.tempor.augue@ipsumprimis.net,Carol,Key,Carol Key,IT Manager,Information Technology,123452,123-555-1212,123-555-6642,123-555-9822,1 Microsoft way,Redmond,Wa,98052,United States,2014-07-18
augue.ac@aliquamiaculislacus.net,Walter,Chandler,Walter Chandler,IT Manager,Information Technology,123453,123-555-1213,123-555-6643,123-555-9823,1 Microsoft way,Redmond,Wa,98052,United States,2015-11-23
lorem@aodiosemper.co.uk,Tallulah,Salinas,Tallulah Salinas,IT Manager,Information Technology,123454,123-555-1214,123-555-6644,123-555-9824,1 Microsoft way,Redmond,Wa,98052,United States,2016-01-28
scelerisque@mattisInteger.co.uk,Tara,Poole,Tara Poole,IT Manager,Information Technology,123455,123-555-1215,123-555-6645,123-555-9825,1 Microsoft way,Redmond,Wa,98052,United States,2016-10-10

Text File Schema Definition

Type=CONTROL,ID=1,SchemaEnclosureCharacter=22,Version=1.0.1.22
Type=META,ID=2,Name=Import_User_Sample,Version=2017-06-11 MDS,FileType=DELIMITED,DelimiterCharacter=2C,EnclosureCharacter=22,EncloseWhen=NEEDED,CharacterEncoding=UTF-8,EndOfLine=NEWLINE,FieldIDMethod=POSITION,OwnerName=Michael D. Shook,OwnerEmail=mike@omegatower.com
Type=RECORD,ID=3,Name=Data,Position=1,ParentID=2,Required=YES,HasData=ALWAYS,MinimumAllowed=1,MaximumAllowed=1,RecordIDPosition=1,IsHeader=NO,TrailingDelimiter=NO
Type=FIELD,ID=4,Name=User Name,Position=1,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=63,DataType=STRING,"StringRegex=^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$",Sample=chris@contoso.com
Type=FIELD,ID=5,Name=First Name,Position=2,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=63,DataType=STRING,Sample=Chris
Type=FIELD,ID=6,Name=Last Name,Position=3,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=63,DataType=STRING,Sample=Green
Type=FIELD,ID=7,Name=Display Name,Position=4,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=63,DataType=STRING,Sample=Chris Green
Type=FIELD,ID=8,Name=Job Title,Position=5,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=63,DataType=STRING,ListID=20,Sample=IT Manager
Type=FIELD,ID=9,Name=Department,Position=6,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=63,DataType=STRING,ListID=27,Sample=Information Technology
Type=FIELD,ID=10,Name=Office Number,Position=7,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=10,DataType=NUMBER,Sample=123451
Type=FIELD,ID=11,Name=Office Phone,Position=8,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=10,MaximumLength=31,DataType=STRING,StringRegex=^[1-9]\d{2}-\d{3}-\d{4}$,Sample=123-555-1211
Type=FIELD,ID=12,Name=Mobile Phone,Position=9,ParentID=3,Required=YES,HasData=OPTIONAL,MinimumLength=10,MaximumLength=31,DataType=STRING,StringRegex=^[1-9]\d{2}-\d{3}-\d{4}$,Sample=123-555-1211
Type=FIELD,ID=13,Name=Facsimile,Position=10,ParentID=3,Required=YES,HasData=OPTIONAL,MinimumLength=10,MaximumLength=31,DataType=STRING,StringRegex=^[1-9]\d{2}-\d{3}-\d{4}$,Sample=123-555-1211
Type=FIELD,ID=14,Name=Address,Position=11,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=63,DataType=STRING,Sample=1 Microsoft Way
Type=FIELD,ID=15,Name=City,Position=12,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=63,DataType=STRING,Sample=Redmond
Type=FIELD,ID=16,Name=State or Province,Position=13,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=63,DataType=STRING,Sample=Washington
Type=FIELD,ID=17,Name=ZIP or Postal Code,Position=14,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=15,DataType=STRING,Sample=98052
Type=FIELD,ID=18,Name=Country or Region,Position=15,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=3,MaximumLength=63,DataType=STRING,Sample=United States
Type=FIELD,ID=19,Name=Hire Date,Position=16,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=10,MaximumLength=10,DataType=DATETIME,DateTimeFormat=yyyy-MM-dd,Sample=2012-05-16
Type=LIST,ID=20,Name=JobTitle,Position=1
Type=VALUE,ID=21,Position=1,ParentID=20,Value=IT Manager
Type=VALUE,ID=22,Position=2,ParentID=20,Value=Sales Manager
Type=VALUE,ID=23,Position=3,ParentID=20,Value=Senior Analyst
Type=VALUE,ID=24,Position=4,ParentID=20,Value=Analyst
Type=VALUE,ID=25,Position=5,ParentID=20,Value=Junior Analyst
Type=VALUE,ID=26,Position=6,ParentID=20,Value=Salesman
Type=LIST,ID=27,Name=Department,Position=1
Type=VALUE,ID=28,Position=1,ParentID=27,Value=Information Technology
Type=VALUE,ID=29,Position=2,ParentID=27,Value=Sales
Type=VALUE,ID=30,Position=3,ParentID=27,Value=Human Resources
Type=VALUE,ID=31,Position=4,ParentID=27,Value=Accounting
Type=VALUE,ID=32,Position=5,ParentID=27,Value=Legal
Type=SUMMARY,ID=33,ControlCount=1,MetaCount=1,RecordCount=1,FieldCount=16,ListCount=2,ValueCount=11,ConditionCount=0,RuleCount=0,SummaryCount=1,TotalCount=33
Back to top