Issue reading XML file

Post any question you may have in regards to GoAnywhere Services and let our talented support staff and other users assist you.
1 post Page 1 of 1

martin1b

Posts: 1
Joined: Mon May 15, 2017 2:43 pm

Post by martin1b » Wed May 17, 2017 10:48 am
I have an XML file saved from Excel. Trying to import it into a rowset to insert it into an iseries file. My test project (attached) treats each cell as a row, rather than the rows treated as a row. Any ideas what I'm doing wrong?

Here is my XML:
Code: Select all
<project name="Read XML" mainModule="Main" version="2.0" logLevel="verbose">

	<module name="Main">

		<xmlRead file="resource:smb://server1/Information Technology/Web/Temp/GA/test.xml" version="1.0">
			<rowset name="data" nestedSharedValues="true">
				<column index="1" value="/Workbook/Worksheet/Table/Row/Cell" name="lastName" />
				<column index="2" value="/Workbook/Worksheet/Table/Row/Cell" name="firstName" />
			</rowset>
		</xmlRead>

		<forEachLoop itemsVariable="${data}" currentItemVariable="item" currentIterationVariable="loopCount" disabled="false">

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

		</forEachLoop>
	</module>

</project>
Attachments
test.xml
(4.07 KiB) Downloaded 1104 times
1 post Page 1 of 1