Excel to XML

Post Reply
LasseThid
Advanced member
Posts: 353
Joined: Tue Mar 03, 2015 2:30 pm
Location: Molndal, Sweden

Excel to XML

Post 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 7664 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 7664 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 7664 times
Any ideas why this doesn't work?
I'm running Mac OS X 10.10.5 on the computer.

Thanks in advance
Enfocus Switch, Enfocus PitStop Server, Enfocus PDF Review, HP SmartStream& Kodak Prinergy with RBA
Offset 72x102, Offset Large Format, Digital Large Format and Digital print.
Malcolm Mackenzie
Member
Posts: 121
Joined: Wed Mar 22, 2017 5:05 pm
Location: London, UK
Contact:

Re: Excel to XML

Post by Malcolm Mackenzie »

All looks fine.
I have the app running on a PC if you want to attach the file to test.
LasseThid
Advanced member
Posts: 353
Joined: Tue Mar 03, 2015 2:30 pm
Location: Molndal, Sweden

Re: Excel to XML

Post 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.
Enfocus Switch, Enfocus PitStop Server, Enfocus PDF Review, HP SmartStream& Kodak Prinergy with RBA
Offset 72x102, Offset Large Format, Digital Large Format and Digital print.
jan_suhr
Advanced member
Posts: 586
Joined: Fri Nov 04, 2011 1:12 pm
Location: Nyköping, Sweden

Re: Excel to XML

Post 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.
Jan Suhr
Color Consult AB
Sweden
=============
Check out my apps
LasseThid
Advanced member
Posts: 353
Joined: Tue Mar 03, 2015 2:30 pm
Location: Molndal, Sweden

Re: Excel to XML

Post 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.
Enfocus Switch, Enfocus PitStop Server, Enfocus PDF Review, HP SmartStream& Kodak Prinergy with RBA
Offset 72x102, Offset Large Format, Digital Large Format and Digital print.
jan_suhr
Advanced member
Posts: 586
Joined: Fri Nov 04, 2011 1:12 pm
Location: Nyköping, Sweden

Re: Excel to XML

Post 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.
Jan Suhr
Color Consult AB
Sweden
=============
Check out my apps
Post Reply