setting up XPath Loop expression in XML Repeater

Post Reply
Aar096
Newbie
Posts: 2
Joined: Fri May 28, 2021 8:20 pm

setting up XPath Loop expression in XML Repeater

Post by Aar096 » Thu Jul 22, 2021 5:28 am

Hello,

I have been trying to split Group XML into individual XML files using XML Repeater. But I'm unable to set up XPath loop expression properties. I tried, it's not splitting into individual XML files. Could you please guide me to set up Xpath loop expression? Below is my XML.

<?xml version="1.0" encoding="UTF-8"?>
<csv entries="1224">
<entry num="1">
<Name>Job_0001</Name>
<TrimHeight>6.85</TrimHeight>
<TrimWidth>9.75</TrimWidth>
<Copies>6</Copies>
<Material>Foamboard</Material>
<Thickness>0.2in</Thickness>
<Bleed>0</Bleed>
<PDF_Path>D:\DATA\ImpFlow_US\LFP\Gang_FB_Rect_CSV2_1224\6.85x9.75.pdf</PDF_Path>
</entry>
<entry num="2">
<Name>Job_0002</Name>
<TrimHeight>6.85</TrimHeight>
<TrimWidth>9.75</TrimWidth>
<Copies>5</Copies>
<Material>Foamboard</Material>
<Thickness>0.2in</Thickness>
<Bleed>0</Bleed>
<PDF_Path>D:\DATA\ImpFlow_US\LFP\Gang_FB_Rect_CSV2_1224\6.85x9.75.pdf</PDF_Path>
</entry>
<entry num="3">
<Name>Job_0003</Name>
<TrimHeight>6.85</TrimHeight>
<TrimWidth>9.75</TrimWidth>
<Copies>11</Copies>
<Material>Foamboard</Material>
<Thickness>0.2in</Thickness>
<Bleed>0</Bleed>
<PDF_Path>D:\DATA\ImpFlow_US\LFP\Gang_FB_Rect_CSV2_1224\6.85x9.75.pdf</PDF_Path>
</entry>
<entry num="4">
<Name>Job_0004</Name>
<TrimHeight>6.85</TrimHeight>
<TrimWidth>9.75</TrimWidth>
<Copies>5</Copies>
<Material>Foamboard</Material>
<Thickness>0.2in</Thickness>
<Bleed>0</Bleed>
<PDF_Path>D:\DATA\ImpFlow_US\LFP\Gang_FB_Rect_CSV2_1224\6.85x9.75.pdf</PDF_Path>
</entry>
</csv>
Last edited by Aar096 on Mon Jul 26, 2021 11:44 am, edited 1 time in total.

rzacherl
Member
Posts: 38
Joined: Mon Mar 21, 2011 3:29 pm

Re: setting up XPath Loop expression

Post by rzacherl » Thu Jul 22, 2021 9:39 am

Hello unknown XML Repeater user,

the loop XPath expression needed to split this XML file into separate entry entities should simply be
/csv/entry

If it doesn't work, please contact me again.

Best regards,

Robert

Aar096
Newbie
Posts: 2
Joined: Fri May 28, 2021 8:20 pm

Re: setting up XPath Loop expression

Post by Aar096 » Thu Jul 22, 2021 2:43 pm

Hello Robert,

Thank you for your reply.

I tried it, but my file is disappearing in messages it is showing "IJT could not be opened: '000GZ.ijt'", attached my flow & XML repeater screenshot. Kindly help.
Attachments
Prop.png
Prop.png (6.15 KiB) Viewed 121 times
Prop.png
Prop.png (6.15 KiB) Viewed 123 times
Flow.png
Flow.png (20.24 KiB) Viewed 133 times

rzacherl
Member
Posts: 38
Joined: Mon Mar 21, 2011 3:29 pm

Re: setting up XPath Loop expression in XML Repeater

Post by rzacherl » Mon Jul 26, 2021 1:57 pm

Hello Aar096,

please send me your flow and a CSV file (or at least the XML file which comes out of CSV2XML).

Just out of personal interest: why don't you output single XML files for each CSV record from within CSV2XML? Alle you have to do is to switch the script property Output as single XML file from Yes to No.

Post Reply