importing xml into excel
For questions and information regarding GoAnywhere MFT.
Feel free to share ideas, workflows or other best practices with other users.
Feel free to share ideas, workflows or other best practices with other users.
Forum rules
If you have a support request, please raise a support ticket via the customer portal my.goanywhere.com or contact our support team by email at [email protected].
If you have a support request, please raise 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: 588
- 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: 588
- 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