Hope everyone is doing well.
At the end of a flow, I have a folder with a number of XML files inside. Each xml file is structured in the same way and simply has a different file name. All I am after is sending ONE email with a resumé of the number of xml files and a short description from elements within.
I can use metadata>text>build location path with an external metadata dataset and I can see – one at a time – the data tree for each xml file.
By using [Job.FileCount] and [Job.NestedName:Prefix="<li>",Suffix="</li>",Segment="7-99"] I can get a list of each xml file name into one single email. The email body text is “multi-line text with variables defined”. So, inside the email, I end up with
- We have received 2 files:
• 19_MONACO_1000_3.xml
• 32_MONACO_2000_27.xml
19 = Order N°
1000 = Ticket variety
3 = number of tickets
What I can’t seem to fathom is how to get several parts from inside each xml file into the same email. Basically, I would like to obtain:
- There are 3 tickets to print on the model 1000 for Monaco (where "3" and "1000" are the variables)
There are 27 tickets to print on the model 2000 for Monaco (where "27" and "2000" are also the variables
Each xml looks like this:
<?xml version="1.0" encoding="UTF-8" ?>
<ETIQUETTE>
<Lieu>MONACO</Lieu>
<LieuInt>C2</LieuInt>
<Lib>PEINTURE</Lib>
<Article>TOLLENS BLANC 50L</Article>
<Date>2022-01-21</Date>
<EtiquetteNo>1000</EtiquetteNo>
<PrixOrig>100.00</PrixOrig>
<PrixNouv>50.00</PrixNouv>
<Remise>50</Remise>
<GenCode>123456</GenCode>
<NoEx>3</NoEx>
</ETIQUETTE>
I’ve tried a variety of things with some try for free apps from the store (Create Log; Inject XML; Meta Tagger; Take Notes)
I’ve been pointing to [Metadata.Text:Path="/ETIQUETTE/NoEx",Dataset="Xml",Model="XML"] but no matter how many xml files I have I only ever get one result.
If anyone has a pointer I would be more than happy to learn.
Thankyou
Sean