SSDN - XML to XML

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Maggie Mell

Subject: XML to XML
Author: Maggie Mell
Date: 02 Oct 2007 05:33 PM

I need to convert one format of XML into another. I've been trying to do this using the mapping tool, but no matter what I do I can't get it to match.

post.properties.xml
Source File

template.xml
Desired File Format

(Deleted User)

Subject: XML to XML
Author: (Deleted User)
Date: 03 Oct 2007 10:16 AM

Hi Maggie,
in order to build that structure using XSLT Mapper, you should right click on the Column element in the target schema and pick "Duplicate Node"; do this operation for 12 times, and then right click on the attribute of each node to invoke "Set Literal Value", and entering the various SystemId/FirstName/etc values.
Then you can drag and drop the proper source node in the appropriate Column node.

Hope this helps,
Alberto

Maggie Mell

Subject: XML to XML
Author: Maggie Mell
Date: 03 Oct 2007 10:42 AM

Alberto,

Thank you. It's closer than what I had before, but still not the same.
When I do that I get something that looks like this:

<File><Row><Column>FirstName

Karin</Column></Row></File>

Maggie Mell

Subject: XML to XML
Author: Maggie Mell
Date: 03 Oct 2007 10:43 AM

Alberto,

Thank you. It's closer than what I had before, but still not the same.
When I do that I get something that looks like this:

<File><Row><Column>FirstName

Karin</Column></Row></File>

(Deleted User)

Subject: XML to XML
Author: (Deleted User)
Date: 03 Oct 2007 11:12 AM

Hi Maggie,
the "Set Literal Value" command should be executed on the "Name" attribute, not on the "Column" element.

Hope this helps,
Alberto

Maggie Mell

Subject: XML to XML
Author: Maggie Mell
Date: 03 Oct 2007 11:20 AM

Awesome! Thank you so much!

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.