XML Pickup to retreive pdf job
Posted: Sun Mar 05, 2017 3:13 pm
Hello,
As a newbee in manipulating xml files and data, i'm looking correct ways to use XML Pickup and Inject Job in sw 13 up1.
For example, in a folder I have pdf files and xml files name like this:
12345_aaaaaaa.pdf
23456_bbbbbbbbb.pdf
56789_ccccc.pdf
and
12345_zzzzz.xml
23456_xxx.xml
56789_yyyyyyyy.xml
Informations about the pdf files are stored in the xml files matching the first 5 numbers in their names.
My goal is to remame the pdf files with informations (like name and date) that are in fields <Agency> and <IssueDate> of the matching xml file.
For example obtain pdf: 12345_MyAgency_2017-03-05.pdf with datas from the xml 12345_zzzzz.xml in the fields <Agency>MyAgency</Agency> and <Issuedate>2017-03-05</IssueDate>
I think is possible standard function XML Pickup and Inject Job, but I don't know how to retreive information about xml files.
Many many Thanks for your help and advices.
Thierry.
As a newbee in manipulating xml files and data, i'm looking correct ways to use XML Pickup and Inject Job in sw 13 up1.
For example, in a folder I have pdf files and xml files name like this:
12345_aaaaaaa.pdf
23456_bbbbbbbbb.pdf
56789_ccccc.pdf
and
12345_zzzzz.xml
23456_xxx.xml
56789_yyyyyyyy.xml
Informations about the pdf files are stored in the xml files matching the first 5 numbers in their names.
My goal is to remame the pdf files with informations (like name and date) that are in fields <Agency> and <IssueDate> of the matching xml file.
For example obtain pdf: 12345_MyAgency_2017-03-05.pdf with datas from the xml 12345_zzzzz.xml in the fields <Agency>MyAgency</Agency> and <Issuedate>2017-03-05</IssueDate>
I think is possible standard function XML Pickup and Inject Job, but I don't know how to retreive information about xml files.
Many many Thanks for your help and advices.
Thierry.