Generating a New XML file from and Existing XML File 1

[andre66]

Hi all,

Hopefully some one here will be able to help me with this problem, as im pretty stumped.

I have an XML document provided by one of our customers that containd data in both the attributes and the elements.

Access only lets you import the data from the elements, but i also need the data from the attributes.

I have created an XSL document that uses XLST to create a new XML file with the attributes converted into elements.

My problem is that i cannot view result of the XSL document properly. Instead of a nicely formed XML document, it is output as a huge text string.

Here are the links to the documents:

http://www.uk-marketingdatabase.com/asp/profiler_template.xml

- XML Document

http://www.uk-marketingdatabase.com/asp/dyn2.xs

- XSL Document

http://www.uk-marketingdatabase.com/asp/demo2.html

- XSL Output

http://www.uk-marketingdatabase.com/asp/required.xml

- XSL Required Output

Many thanks in Advance.

Matt

 

[JontyMC]

IE is viewing the output as HTML, so it will ignore the tags and just output the values. Thus, you either have to escape all the < and > to &lt; and &gt; respectively, or simply save the output to an XML file rather than outputting it.

Jon

"I don't regret this, but I both rue and lament it.

 

[andre66]

Hi Jonty,

Thanks for your reply.

I am unsure however how to escape the values as i hav not had to do this before, might you be able to point me in the right direction?

regards

Matt

 

[JontyMC]

Something like this (not tested):

var output = proc.output;
output = output.replace(/</g, "&lt;").replace(/>/g, "&gt;");
target.innerHTML = output;

Jon

"I don't regret this, but I both rue and lament it.