importing xml into excel

[ehersh]

I am trying to read an XML file and write it to excel. When I do I get the following log and the job bombs. Any help would be appreciated.

9/26/16 2:51:12 PM INFO Start Date and Time: 9/26/16 2:51:12 PM
9/26/16 2:51:12 PM INFO Job Number: 1397289275519
9/26/16 2:51:12 PM INFO Project Name: /Test Projects/test_imports/test_import_xml
9/26/16 2:51:12 PM INFO Submitted By: eshersh
9/26/16 2:51:12 PM INFO Submitted From: Administrator UI
9/26/16 2:51:12 PM INFO GoAnywhere 5.2.3 running on Windows Server 2012 6.2 (amd64)
9/26/16 2:51:12 PM INFO ******************** Debug Mode ********************
9/26/16 2:51:12 PM INFO Executing project 'test_import_xml'
9/26/16 2:51:12 PM INFO Project location: C:\Program Files\Linoma Software\GoAnywhere\userdata\projects\Test Projects\test_imports\test_import_xml.xml
9/26/16 2:51:12 PM INFO Executing module 'Main'
9/26/16 2:51:19 PM INFO Executing task 'xmlRead 1.0'
9/26/16 2:51:19 PM INFO Data parsed successfully and the rowset variable(s) 'eshtestimport' were created
9/26/16 2:51:19 PM INFO Finished task 'xmlRead 1.0'
9/26/16 2:51:19 PM INFO Executing task 'writeExcel 2.0'
9/26/16 2:51:19 PM WARN Overwriting the output file 'resource:smb://sdfs01_ASPClients_SD_SFTPHome/test_import/test_import.xlsx'
9/26/16 2:51:19 PM INFO [Read XML] Rowset "eshtestimport" is beginning to process file "resource:smb://sdfs01_ASPClients_SD_SFTPHome/test_import/test.xml".
9/26/16 2:51:19 PM INFO Finished task 'writeExcel 2.0'
9/26/16 2:51:19 PM ERROR [8098 - Write Excel] [9006 - Read XML] When building rowset "eshtestimport", the root element did not match in the file "resource:smb://sdfs01_ASPClients_SD_SFTPHome/test_import/test.xml". Full stack trace written to '1397289275519_error_1.log'
9/26/16 2:51:19 PM INFO Finished project 'test_import_xml'
9/26/16 2:51:19 PM ERROR [8098 - Write Excel] [9006 - Read XML] When building rowset "eshtestimport", the root element did not match in the file "resource:smb://sdfs01_ASPClients_SD_SFTPHome/test_import/test.xml".
9/26/16 2:51:19 PM INFO End Date and Time: 9/26/16 2:51:19 PM

[Support_Rick]

Check the paths for your XML data. They must match exactly (including case).

[ehersh]

I did check that for most of the path I use a resource so that would be correct and I double checked the folder and that is spelled correctly. I even copied the name of the folder from the folder to the go anywhere task and still does not work.

[Support_Rick]

Please send a copy of your project XML and the full DEBUG joblog to Support@Linoma.com for additional assistance.

[ehersh]

I am able to load XML into excel but one record is being written to 3 rows which may be a function of excel more that go anywhere