importing xml into excel
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].
importing xml into excel
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.
Last edited by ehersh on Mon Jul 17, 2017 2:45 pm, edited 1 time in total.
- Support_Rick Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: importing xml into excel
Check the paths for your XML data. They must match exactly (including case).
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Re: importing xml into excel
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 Offline
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
- Contact:
Re: importing xml into excel
Please send a copy of your project XML and the full DEBUG joblog to [email protected] for additional assistance.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Re: importing xml into excel
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