IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#57679 - 09/15/20 01:20 PM Looking for the total number of XML records
ricks Offline
OL Guru

Registered: 04/17/10
Posts: 101
Loc: Seattle
Is there a way while in Design to know how many XML records are in the file being processed by Watch?

Ideally, we would not need to capture this in a Watch process and then use it in the Design, but that could be done. We do near zero stuff with Metadata so that would be possible with help in setting it up, but again it would add a Metadata step to the Workflow which is not ideal.

Our XML structure looks similar to this:

<TABLE>
<INVOICE>
<PP_DIR_OUTPUT>\\PPWATCH1\P\STMT\DAILYNOTICES\0908</PP_DIR_OUTPUT>
<PP_DOCUMENT>DAILYNOTICES</PP_DOCUMENT>
<PP_BRANCH>MICR</PP_BRANCH>
<PP_NUP>1</PP_NUP>
<O_TYPE>C</O_TYPE>
<O_PATH>p:\\stmt\dailynotices\0908\</O_PATH>
<O_PDF>CHECKS_090820.PDF</O_PDF>
<O_TOTPDFS>46</O_TOTPDFS>
<O_PDF_PGNO>6</O_PDF_PGNO>
<ACCTNO>00006778</ACCTNO>
<CHECKNO>000</CHECKNO>
<NEWPDFNAME>DN-Chk_01082B5MNN8GSD9.pdf</NEWPDFNAME>
<PKGBM></PKGBM>
<CTNBM></CTNBM>
<IMBTRACK>85793208</IMBTRACK>
</INVOICE>
</TABLE>


I want the count of the <INVOICE> tags.

Thoughts?

Top
#57680 - 09/15/20 02:44 PM Re: Looking for the total number of XML records [Re: ricks]
Jean-Cédric Offline
OL Expert

Registered: 10/03/16
Posts: 681
Loc: Québec, Canada
I've quickly looked on the web and found this.

You could then pass that variable to the form in Workflow.
_________________________
♪♫♪♫
99 frigging bugs in my code
99 frigging bugs
Take one down
Code around
127 frigging bugs in my code
♪♫♪♫

Top
#57682 - 09/15/20 04:57 PM Re: Looking for the total number of XML records [Re: Jean-Cédric]
ricks Offline
OL Guru

Registered: 04/17/10
Posts: 101
Loc: Seattle
Thanks for that idea.

If we are willing to do it with Metadata- can that accomplish this and if so, what would we do to get that value?D7y8

Top