Outputting data from Calypso to XML

[[Cl...]]

Has anyone done, or have knowledge of how this is done.
We will be using a customer portal to enter variable CMM
data and it needs to be in the XML format. I do have PCM.

[[Je...]]

Clarke,

I've attached a data compiler macro that outputs to .xls.. My apology, but I don't remember the author. Perhaps you could edit the vba code by simply swapping the .xls extension .xml. That's probably a too optimistic on my part.

If you have a support license with Zeiss, contact Greg Ellington. He is a software specialist for Zeiss and is basically a genius when it comes to excel and anything coding-related.






Jeff Frodermann
Windings, Inc.
New Ulm, Minnesota

[[Cl...]]

Many thanks Jeff, I'll give it a try.

[[Er...]]

What have Excel to do with xml?

How should it be tagged? Its hard to say anything else then yes, if you dont provide how it shall be formatted.

<char>
<title>abc</title>
<nom>123</nom>
<act>124</nom>
</char>

Should be very easy to accomplish. How ever, using PCM might be pretty slow if your programs is on the lager side. Table files and som scripting language is propabilly preferable.

This is written on my phone, so dont expect it to work. But you get the idèa if you go the pcm route..

for i =1 to getCFNames().size
   addToFile("xx","<char>"+getParameterNamed(getCFNames,i)+"</char>")
   addToFile("xx","<act>"+getActual(getParameterNamed(getCFNames,i)).actual+"</act>")
...... 

[[Er...]]

Now when I have had a minute, the "special program" function output in xml. See if you can use that?

[[Cl...]]

Please sign in to view this quote.

Ya, I wasn't sure what Jeff was suggesting, I just assumed it was a place to start? However Jeff, I do appreciate the input.

How should it be tagged? Its hard to say anything else then yes, if you dont provide how it shall be formatted.

<char>
<title>abc</title>
<nom>123</nom>
<act>124</nom>
</char>

Should be very easy to accomplish. How ever, using PCM might be pretty slow if your programs is on the lager side. Table files and som scripting language is propabilly preferable.

This is written on my phone, so dont expect it to work. But you get the idèa if you go the pcm route..

for i =1 to getCFNames().size
   addToFile("xx","<char>"+getParameterNamed(getCFNames,i)+"</char>")
   addToFile("xx","<act>"+getActual(getParameterNamed(getCFNames,i)).actual+"</act>")
...... 

[/quote] Thank Eric!