Error: When building rowset data", the root element did not match in the file

[anutta78]

Having error when reading XML.. please advise

My XML:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<ns0:Study xmlns:ns0="http://www.clientname.com/Site">
<ns0:StudyNum>XA123654</ns0:StudyNum>
<ns0:InformationContained>Full</ns0:InformationContained>
<ns0:StudyRowId>1-SETYE9</ns0:StudyRowId>
<ns0:ListOfSite>
<ns0:Site>
<ns0:SiteNum>12345</ns0:SiteNum>
<ns0:SiteName>University Name</ns0:SiteName>
<ns0:CountryCode>CA</ns0:CountryCode>
<ns0:SiteRowId>1-TYU7ER</ns0:SiteRowId>
</ns0:Site>
</ns0:ListOfSite>
</ns0:Study>

Project:

Code: Select all

<project name="xml to excel" mainModule="Main" version="2.0" logLevel="verbose">
	<module name="Main">
		<xmlRead file="\userdata\2016_part.xml" validation="none" processedInputFilesVariable="toExcel" version="1.0" logLevel="debug">
			<rowset name="data">
				<column index="1" value="/Study" />
				<column index="2" value="/Study/StudyNum" />
				<column index="3" value="/Study/StudyNum/InformationContained" />
				<column index="4" value="/Study/StudyNum/InformationContained/StudyRowId" />
                                 ....

			</rowset>
		</xmlRead>


		<writeExcel inputRowSetVariable="${data}" outputFile="\userdata\fromXML.xlsx" whenFileExists="overwrite" excelFormat="excel2007" includeHeadings="true" version="2.0" />

	</module>

</project>

error:
When building rowset "data", the root element did not match in the file

[Support_Rick]

anutta78,

Please review your access paths to your XML Data. Should be something like the following:

Code: Select all

		<xmlRead file="\Temp\Test XML Data.xml"
		         validation="none"
		         processedInputFilesVariable="toExcel"
		         version="1.0"
		         logLevel="debug">
			<rowset name="data">
				<column index="1"
				        value="/ns0:Study/ns0:StudyNum"
				        name="StudyNum" />
				<column index="2"
				        value="/ns0:Study/ns0:InformationContained"
				        name="InformationContained" />
				<column index="3"
				        value="/ns0:Study/ns0:StudyRowId"
				        name="StudyRowID" />
			</rowset>
		</xmlRead>