2022.2

Table Of Contents
2. Generateanoutputfilethatcontainsthesorteddataandmustbenamedaccording
thefilenamePrintShopMailConnectwillpassthroughinthepositionofthe${out-
put}placeholder
Forexample:cmd /C sort /R ${input} ${output}
Thiswouldreversetheorderofthe${input}file,andsenttheoutputtothe${output}
file.
l
Timeout:Enterthenumberofsecondstowaitforanexternalsortcommandtocomplete
beforeabandoningtheexternalsort.
l
Separator:EnterthefieldseparatorusedintheCSVfile,suchasacomma(,),pipe(|),
semicolon(;),etc.
l
Quote Character:Enterthequotingcharacterthatwrapsaroundanyfieldthatcontains
theseparator.
l
Escape Character:EnterthecharacterusetoescapetheQuotecharacterifitappearsin
thefieldvalue.
l
Line Ending:Usethedrop-downtoselectwhichlineendingtouse.Theselectionsare:
WindowsCarriage Return/Line Feedcombination(CRLF),LinuxLine Feed(LF)orApple
MacintoshCarriage Return(CR).
l
Character Set:Usethedrop-downtoselectwhichcharactersettousewhenencodingthe
CSVfile.ThisalwaysdefaultstoUTF-8,asthiscatersforallpossiblecharacters,isrel-
ativelycompact(intermsofUnicodecharactersets)andiscompatiblewithstandard
ASCII.
l
Exported sort datagroup:
l
First row of sort data has field namescheckbox:selecttohavefieldnames
placedonthefirstlineoftheexportedCSVfile.
l
Fields to export:ListsthefieldstoexportintheCSVfile.Thebuttonstotherightof
thetableprovidethefollowingfunctionality:
l
Clicktoselectfromavailabledatatfields.TheFieldSelectiondialogwill
appear,whichallowsselectionofoneorseveralfieldsfromthoseavailable.
l
Clicktoremoveafieldfromthelist.
l
/ Clicktomovefieldsupordownintheorderofoutput.
l
Record ID Field:TheRecordIDfieldisadatabasePrimary Keyfield,whichisauto-
maticallyaddedtotheexporteddatafile.TheRecordIDfieldnamedefaultsto
RecID,butcanbechangedhereasdesired.
Page 621