2022.2

Table Of Contents
ofthesoftware,sothatyoumayrestoreadatamappingconfigurationthatwasaccidentallyopenedand
savedinanewerversion,orshareadatamappingconfigurationwithusersofapreviousversionof
Connect.
Notethatitmaynotalwaysbepossibletodown-saveadatamappingconfigurationtoaanolderver-
sion.Forinstance,aJSON-baseddatamappingconfigurationcannotbesavedtoaversionearlierthan
2021.1becausetheJSONdatatypedidnotexistpriortothatversion.
Todown-saveadatamappingconfiguration,selectFile > Save a Copy,fromthemenu.Selectthe
softwareversionandclickOK.Nextyoucanselectalocationandgivethedatamappingconfiguration
aname,asusual.
Tosave a copy,followthesameprocedurewithoutselectingapreviousversionofthesoftware.
Note: SinceitwasnotpossibletocreateadatamappingconfigurationforaJSONfile(without
conversiontoXML)untilversion2021.1,thesedatamappingconfigurationscannotbesavedin
theformatofanearlierversion.
Using the wizard for CSV and Excel files
TheDataMapperwizardforCSVandExcelfileshelpsyoucreateadatamappingconfigurationforsuch
files.Thewizardautomaticallydetectsdelimitersandextractsalldatainoneextractionstep.
Thewizardinterpretseachlineinthefileasarecord.Ifyourdatafilecontainstransactionaldata,you
willprobablywantmorelinestogoinonerecordandputthetransactionaldataindetailtables.
Thewizardcannotcreatedetailtables.Ifthefilecontainstransactionaldata,thedatamappingcon-
figurationisbestcreatedwithoutawizard(see"Creatinganewdatamappingconfiguration"on
page200).
TherearetwowaystoopenaCSVfileorExcelfilewithawizard:fromtheWelcomescreenorfromthe
Filemenu.
l
FromtheWelcomescreen
1.
OpenthePlanetPressConnectWelcomepagebyclickingthe iconatthetopright,or
selecttheHelpmenuandthenWelcome.
2. ClickNew DataMapper Configuration.
3. FromtheUsing a wizardpane,selectCSV/XLSX/XLS.
4. ClicktheBrowsebuttonandopenthefileyouwanttoworkwith.
5. ClickNext.
Page 205