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].
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
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>
<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 Specialist
- Posts: 91
- Joined: Thu Mar 05, 2009 3:49 pm
- Location: Ashland, NE USA
-
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.
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.
2 posts
Page 1 of 1