Page 1 of 1

Problems Reading XML

Posted: Wed Aug 16, 2017 4:05 pm
by Grodaes
Hello, I am working on a project that reads a Fax number from an XML sheet however I always seem to get the error [8099 - Print] An unexpected error occurred. Invalid cursor position: BEFORE_FIRST Original expression: xmlData[1]. when trying to print out the information in ${xmlData[1]}. Any chance anyone has encountered this and solved it?


<project name="Test XML Default Read" mainModule="Main" version="2.0" logLevel="verbose">

<module name="Main">

<xmlRead label="Read XML File" file="d:\FTP\r04572t2__zjde0001_42455_pdf_121852_lbrochu_from_r04572t2e_eft_380680_121852.xml" defaultDateFormat="yyyy-MM-dd" defaultTimeFormat="HH:mm:ss" defaultTimestampFormat="MM/dd/yyyy HH:mm:ss.SSS" version="1.0">
<rowset name="xmlData">
<column index="1" value="/root/FaxCommands/@FaxNumber" name="COLUMN1" type="INTEGER" />
</rowset>
</xmlRead>


<print version="1.0">
<![CDATA[COLUMN1
${xmlData[1]}]]>
</print>

</module>

</project>

Re: Problems Reading XML

Posted: Tue Sep 12, 2017 3:07 pm
by Support_Julie
To resolve your issue, do a SET VARIABLE prior to the PRINT task.
Then in the PRINT task, use that variable.

Since the Set Variable is not inside a loop, use version 1.0 of the Set Variable task.