2022.2

ManualsBrandsObjectif Lune ManualsApplicationsPlanetPress Connect

201

202

203

204

205

206

207

208

209

210

Table Of Contents

l

CommaSeparatedValuesorExcel(CSV/XLSX/XLS),

l

MicrosoftAccess

l

PDF,PS,PCL

l

Text

l

XML

l

JSON

3. ClicktheBrowsebuttonandopenthefileyouwanttoworkwith(foradatabase,youmay

havetoenterapassword).

4. ClickFinish.

l

FromtheFilemenu

1. ClicktheFilemenuandselectNew.

2. ClicktheData mapping Configurationdrop-downandselectFilesandthenthefiletype:

l

CSV,XLSXorXLS(CommaSeparatedValuesorExcel),

l

JSONFile

l

MicrosoftAccess

l

PDF,PS,PCLFile

l

TextFile

l

XMLFile

3. ClickNext.

4. ClicktheBrowsebuttonandopenthefileyouwanttoworkwith.

5. ClickFinish.

Afteropeningthefile,youhavetomakesettingsfortheinputdata(see"Datasourcesettings"on

page223)tomakesurethatthesourcedataisparsedcorrectlyanddividedintologicalunitsofdatathe

wayyouwant.Thenyoucanstartbuildingthedataextractionworkflow.

l

AlsoselectXMLifyouwantaJSONfiletobeconvertedtoandtreatedlikeXML.Ifthereis

norootelementintheJSONitwillbeaddedandeachobjectwithoutanamedparentele-

mentiscalledan'item'.

Notethatinadditiontobeingvalid,theJSONshouldfollownamingrulesforXMLele-

ments.Forexample,"adress_line_1:"isavalidkeynameinJSON,butitcannotbecon-

vertedtoavalidelementnameinXMLbecausethecolonisreservedfornamespaces.For

Page 201