Page 1 of 1

Excel to XML

Posted: Thu Jan 31, 2019 9:02 pm
by LasseThid
I downloaded a trial of the Excel to XML app from the Enfocus App Store, but even though I'm just playing around with a simple Excel file like this
Skärmavbild 2019-01-31 kl. 20.50.16.png
Skärmavbild 2019-01-31 kl. 20.50.16.png (38.87 KiB) Viewed 7763 times
I get the following error when running this simple flow: Error in line 129 of script: Trying to access undefined member '0'
Skärmavbild 2019-01-31 kl. 20.47.58.png
Skärmavbild 2019-01-31 kl. 20.47.58.png (48.31 KiB) Viewed 7763 times
with these settings
Skärmavbild 2019-01-31 kl. 20.48.08.png
Skärmavbild 2019-01-31 kl. 20.48.08.png (101.35 KiB) Viewed 7763 times
Any ideas why this doesn't work?
I'm running Mac OS X 10.10.5 on the computer.

Thanks in advance

Re: Excel to XML

Posted: Fri Feb 01, 2019 11:57 am
by Malcolm Mackenzie
All looks fine.
I have the app running on a PC if you want to attach the file to test.

Re: Excel to XML

Posted: Fri Feb 01, 2019 12:54 pm
by LasseThid
Thanks for the offer, but no need.

We will move the Switchserver from Mac to PC shortly to see if that resolves the issues we have with Switch failing to copy files to our Windows-servers every now and then. I downloaded the csv2xml app and it works like a treat, but it would be nice to figure out why the Excel to XML doesn't work.

Re: Excel to XML

Posted: Sat Feb 02, 2019 9:16 am
by jan_suhr
Hello Lasse,

You could email me directly about this :-)

Have you turned on debugging in the messages? and can you send me the results you get then.

Something has gone wrong in the first step of the conversion and it can't read the temporary file that it use to build the XML.

Email me the results you get,please.

Re: Excel to XML

Posted: Sat Feb 02, 2019 10:55 am
by LasseThid
I just created that simple trial flow and didn't get further that that. Didn't know what to do when I got that error.

I will try to find the debugging and send the info to you.

Thanks.

Re: Excel to XML

Posted: Sun Feb 03, 2019 2:10 pm
by jan_suhr
The problem was a corrupt Excel-file that couldn't be converted to XML.

A new version of the app is submitted to Enfocus. This new version will send the job to the Problems job folder.

The new version would hopefully be available in a few days on the App store.