{"id":6354,"date":"2018-03-09T19:47:49","date_gmt":"2018-03-09T19:47:49","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=6354"},"modified":"2020-07-02T10:27:16","modified_gmt":"2020-07-02T17:27:16","slug":"output-from-row-project","status":"publish","type":"post","link":"https:\/\/www.minisoft.com\/support\/output-from-row-project\/","title":{"rendered":"Output From Row Project"},"content":{"rendered":"<p>To follow along with the guide please download the project files:\u00a0<a href=\"\/support\/wp-content\/uploads\/2018\/03\/RowoutExample.zip\">Rowout Example Project Files<\/a><\/p>\n<p>For an explanation of Project D click here <a href=\"\/support\/index.php\/row-output-project-d\/\">Row Output: Project D<\/a><br \/>\nFor an explanation of Project C click here\u00a0<a href=\"\/support\/index.php\/row-output-project-c\/\">Row Output: Project C<\/a><\/p>\n<p>NOTE: The &#8220;<a href=\"\/support\/index.php\/split-string\/\">Split String<\/a>&#8221; function is only in version 11.01.10 and after for eFORMz.<\/p>\n<p>This guide is about how to handle XML input that has multiple XML tags which loop more than once. What does it mean for XML input tag to loop more than once? It simply means that the XML tag does not define a set number of times it will be placed into the XML document. It could be 1-n items. Here is an example of XML with multiple XML tags that loop more than once. The XML tags POs, PODETAIL1, SKU, and QTY are all examples of an XML tag that loops more than once in this instance. In this example, it&#8217;s important to print out the SKUs and QTYs underneath their respective POs (PO1 and PO2).<\/p>\n<pre>&lt;Data&gt;\n\n&lt;POs&gt;\n\n&lt;PONBR&gt;PO1&lt;\/PONBR&gt;\n\n&lt;PODETAIL1&gt;&lt;SKU&gt;SKU01&lt;\/SKU&gt;&lt;QTY&gt;2&lt;\/QTY&gt;&lt;\/PODETAIL1&gt;\n\n&lt;PODETAIL1&gt;&lt;SKU&gt;SKU02&lt;\/SKU&gt;&lt;QTY&gt;21&lt;\/QTY&gt;&lt;\/PODETAIL1&gt;\n\n&lt;\/POs&gt;\n\n&lt;POs&gt;\n\n&lt;PONBR&gt;PO2&lt;\/PONBR&gt;\n\n&lt;PODETAIL1&gt;&lt;SKU&gt;SKUB01&lt;\/SKU&gt;&lt;QTY&gt;2&lt;\/QTY&gt;&lt;\/PODETAIL1&gt;\n\n&lt;PODETAIL1&gt;&lt;SKU&gt;SKUB02&lt;\/SKU&gt;&lt;QTY&gt;21&lt;\/QTY&gt;&lt;\/PODETAIL1&gt;\n\n&lt;\/POs&gt;\n\n&lt;\/Data&gt;<\/pre>\n<p>The document template in eFORMz can only iterate through one XML tag that loops. Notice how inside of the POs XML tag there are more looping XML tags inside of it, such as SKU and QTY. If you would like to see what happens when you don\u2019t call another project to grab the SKU\u2019s and QTY please active \u201cRow: Item Detail\u201d, deactivate \u201cRow output from project\u201d and \u201cRow: Call ProjectC\u201d in ProjectD.<\/p>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/ItemDetailActive.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6355\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/ItemDetailActive.png\" alt=\"\" width=\"594\" height=\"281\" srcset=\"https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/ItemDetailActive.png 594w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/ItemDetailActive-300x142.png 300w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/ItemDetailActive-150x71.png 150w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/ItemDetailActive-250x118.png 250w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/ItemDetailActive-550x260.png 550w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/ItemDetailActive-380x180.png 380w\" sizes=\"(max-width: 594px) 100vw, 594px\" \/><\/a><\/p>\n<p>In order to grab the SKU and QTY underneath each of its respective POs, we must call another Project. In our case we will use Row output from project.<\/p>\n<p><a href=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/Rowoutput.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6356\" src=\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/Rowoutput.png\" alt=\"\" width=\"594\" height=\"281\" srcset=\"https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/Rowoutput.png 594w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/Rowoutput-300x142.png 300w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/Rowoutput-150x71.png 150w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/Rowoutput-250x118.png 250w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/Rowoutput-550x260.png 550w, https:\/\/www.minisoft.com\/support\/wp-content\/uploads\/2018\/03\/Rowoutput-380x180.png 380w\" sizes=\"(max-width: 594px) 100vw, 594px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To follow along with the guide please download the project files:\u00a0Rowout Example Project Files For an explanation of Project D click here Row Output: Project D For an explanation of Project C click here\u00a0Row Output: Project C NOTE: The &#8220;Split String&#8221; function is only in version 11.01.10 and after for eFORMz. This guide is about [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59,3],"tags":[379,385,132,384],"_links":{"self":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/6354"}],"collection":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=6354"}],"version-history":[{"count":11,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/6354\/revisions"}],"predecessor-version":[{"id":8199,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/6354\/revisions\/8199"}],"wp:attachment":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=6354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=6354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=6354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}