Example Three

This Text File holds a user login creation record.

It is a flat, comma delimited, unenclosed file with header and type records.

The Schema File has all fields even if they have no value (Base.[Field Presence]), and it has trailing delimiters (Base.[Trailing Delimiters]). It also has all of the Record Records before all of the Field Records (Base.[Record Order]).

Sample Source File

SRM_SaaS_ES,MXPERUSERInterface,Add,EN
LOGINID,PERSONID,USERID,PASSWORDINPUT,PASSWORDCHECK,PRIMARYEMAIL
manoel01,manoel01,manoel01,manoelpwd,manoelpwd,manoel01@email.com

Text File Schema Definition

Type=CONTROL,ID=1,SchemaEnclosureCharacter=22,Version=1.0.1.22,,,,,,,,,,,,,,,,,
Type=META,ID=2,Name=UsersImportMinimumSample,Annotation=,Version=2017-06-14,FileType=DELIMITED,DelimiterCharacter=2C,EnclosureCharacter=22,EncloseWhen=NEEDED,CharacterEncoding=UTF-8,EndOfLine=NEWLINE,FieldIDMethod=HEADER,SchemaURL=,OwnerName=,OwnerEmail=,OwnerPhone=,,,,,
Type=RECORD,ID=3,Name=Command,Annotation=,Position=1,ParentID=2,Required=YES,HasData=ALWAYS,MinimumAllowed=1,MaximumAllowed=1,KeyField=,ParentKeyField=,RecordIDPosition=,RecordIDValue=,RecordRow=1,Width=,IsHeader=,TrailingDelimiter=,,,
Type=RECORD,ID=4,Name=Header,Annotation=,Position=2,ParentID=2,Required=YES,HasData=ALWAYS,MinimumAllowed=1,MaximumAllowed=1,KeyField=,ParentKeyField=,RecordIDPosition=,RecordIDValue=,RecordRow=2,Width=,IsHeader=YES,TrailingDelimiter=,,,
Type=RECORD,ID=5,Name=Data,Annotation=,Position=3,ParentID=2,Required=NO,HasData=OPTIONAL,MinimumAllowed=1,MaximumAllowed=,KeyField=,ParentKeyField=,RecordIDPosition=,RecordIDValue=,RecordRow=,Width=,IsHeader=,TrailingDelimiter=,,,
Type=FIELD,ID=6,Name=System,Annotation=,Position=1,ParentID=1,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=7,Name=Interface,Annotation=,Position=2,ParentID=1,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=8,Name=Action,Annotation=,Position=3,ParentID=1,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=9,Name=Language,Annotation=,Position=4,ParentID=1,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=10,Name=LOGINID Header,Annotation=,Position=1,ParentID=2,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^LOGINID$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=11,Name=PERSONID Header,Annotation=,Position=2,ParentID=2,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^PERSONID$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=12,Name=USERID Header,Annotation=,Position=3,ParentID=2,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^USERID$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=13,Name=PASSWORDINPUT Header,Annotation=,Position=4,ParentID=2,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^PASSWORDINPUT$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=14,Name=PASSWORDCHECK Header,Annotation=,Position=5,ParentID=2,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^PASSWORDCHECK$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=15,Name=PRIMARYEMAIL Header,Annotation=,Position=6,ParentID=2,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=^PRIMARYEMAIL$,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=16,Name=LOGINID,Annotation=,Position=1,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=17,Name=PERSONID,Annotation=,Position=2,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=18,Name=USERID,Annotation=,Position=3,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=19,Name=PASSWORDINPUT,Annotation=,Position=4,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=20,Name=PASSWORDCHECK,Annotation=,Position=5,ParentID=3,Required=YES,HasData=ALWAYS,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=FIELD,ID=21,Name=PRIMARYEMAIL,Annotation=,Position=6,ParentID=3,Required=YES,HasData=OPTIONAL,MinimumLength=,MaximumLength=,DataType=STRING,DateTimeFormat=,ListID=,StringRegex=,NumericMinimumValue=,NumericMaximumValue=,Start=,Width=,Alignment=,FillCharacter=,Sample=
Type=SUMMARY,ID=22,ControlCount=1,MetaCount=1,RecordCount=3,FieldCount=16,ListCount=0,ValueCount=0,ConditionCount=0,RuleCount=0,SummaryCount=1,TotalCount=22,,,,,,,