Problems Reading XML

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
2 posts Page 1 of 1

Grodaes

Posts: 10
Joined: Mon Dec 05, 2016 12:12 pm

Post by Grodaes » Wed Aug 16, 2017 4:05 pm
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>

Support_Julie

User avatar
Support Specialist
Posts: 91
Joined: Thu Mar 05, 2009 3:49 pm
Location: Ashland, NE USA

Post by Support_Julie » Tue Sep 12, 2017 3:07 pm
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.
Julie Rosenbaum
Sr Support Analyst
e. [email protected]
p. 1.800.949.4696
w. HelpSystems.com
2 posts Page 1 of 1