2022.2

Sorting Settings
l
Use standard sort:Sortusingthefieldsbelow:
l
Field Name:Usethedrop-downtoselectwhichfieldtosorton.
l
Order:Usethedrop-downtochooseAscendingorDescending.
l
Add:Clicktoaddanewrowtothesortlist.Thelistthatappearscontainsallthefieldsin
theDataModel,aswellasaspecial<DocumentLength>optionwhichisusedtosortby
thenumberofpagesineachdocument.
l
 Delete:Clicktodeletethecurrentlyselectedrowinthelist.
l
/ Move up / down:Clicktomovethecurrentlyselectedrowupordownwithinthelist.
l
Use external sort:Sorttherecordsusingsomeexternalsortingsoftware.ACSVfileisexported,
thensortedbytheexternalapplicationandtheresultantsortedCSVfileisreturnedandinteg-
rated,withalltherecordsnowbeingsortedaccordingtotheneworderwithintheCSVfile.
Note: External Sort commands must return a non-zero error code if an error
occurs.
Anexternalsortcommandcouldeasilyfailpartwaythroughprocessingandgenerateonly
apartialoutputfile.Withoutreceivingareturncodefromtheexternalsortprocess,
PrintShopMailConnectcannotknowifthesorthassuccessfullycompletedornot.Thus
thesortprogrammustgenerateareturncode,withacodeofzero('0')indicatingsuccess,
andallnon-zeroresultsindicatingfailure.
l
External Sort Settingsgroup:
ThissectionofthedialogisonlyactivatediftheUse external sortoptionhasbeenselected.
l
Command:EntereitherthefullpathoftheexecutablefilethatwillsorttheCSVfile,ora
validWindowscommandlineinstructiontosorttherecords.
Placeholderscanbeusedwithinthiscommand,andareavailableviathe Insert
input/output file placeholderoptions(expressedaseither${input}or${output})or
viaJobCreationruntimeParameters(expressedas${params.xxxx},wherethexxxxis
thenameoftheruntimeparameter).
TheWindowscommandlineinstructionshoulddosomethinglikethefollowing:
1. DosomeprocessingoftheinputCSVfilewhichPrintShopMailConnectwillpass
throughinthepositionofthe${input}placeholder.
Page 620