Copying Children From One ColdFusion XML Document To Another

Posted May 14, 2007 at 8:37 AM by Ben Nadel

Tags: ColdFusion

Reader Comments

Wow! This is a pretty impressive technique.

Do you know where documentation exists that talks about these built-in functions within the XML document object? I've only ever been familiar with the functions in the CF documentation, which aren't nearly this powerful.

Thanks in advance,
Toby

@Toby,

Take a look at this:

http://java.sun.com/j2se/1.4.2/docs/api/org/w3c/dom/Node.html

It covers the w3c.org java DOM stuff. It seems that ColdFusion is wrapping around that functionality.

Rock on! Thanks for the link!

On a recent project, I had the need to copy one node to another 'parent' node. I just used duplicate() on the node and it worked fine.

I was told by a co-worker that it would not work because every XML node has a 'parentNode'. Apparently in CFMX 7, Cf is smart enough to remove that reference when you duplicate(). I am not certain how this would work if I tried to move it to a completely different XML document.

Ben,

Check out this XMLMerge UDF I created back in February which uses XSLT to merge.

http://www.intersuite.com/client/index.cfm/2007/2/15/XMLMerge-UDF-Uses-XSLT-to-merge-root-child-nodes

Regards,

Chris

@Chris,

That looks pretty cool. I know nothing about XSLT (I have tried to learn it but I just can't seem to get a handle on its seemly irregular programming syntax). I like what you are doing; my only issue with it is that you have to re-parse XML, which might have a lot of over head.

Cool stuff though. I really should learn more about XSLT.

Working with XML in Coldfusion is painful and slow. There are much better Java library options available. My blog entry details the problems and a solution using XOM and a StAX processor:

http://orangepips.instantspot.com/blog/index.cfm/2007/3/28/XML-StAX-Processing-with-Coldfusion

@Matt,

That is some interesting stuff. I have not done anything with XML outside of the core ColdFusion installed libraries. I will have to take a look at that other stuff sometime.

Just wanted to say thanks for writing this comment! I ran into this same issue while doing some XML work today, and this saved me a TON of headache. Thanks!

Hey ben this is great and it almost solved my problem. Im trying to import a specific child to another xml document in the same parent. I tried to tweak your function to accept a new argument for a specific child but it doesnt seem to be working. Some of these functions are new to me.

Thanks, this worked great for me.

This worked great for manipulating a Word 2003 XML document. I'm using it to insert the contents of one document into another.

So this will work with merging a bunch of xml documents that are identical in structure?

@Don,

You should be able to do that. It's an interesting problem.

Yup. Basically I have information coming in from many different sources. It is the same format so it would be nice to have an easy way to just merge the documents. Right now I have to parse each one and build a master. Many steps and very slow since they can have up to a million + entries between them all. (Sales information).

Twould be nice to just say XMLMerge(doc1,doc2) or something like that.

@Don,

I've been thinking about this issue and the one thing that I realize will happen is that ColdFusion won't have the ability to hold such a large XML file in memory. Why are you trying to merge them? For transfer?

Hi Ben,
just out of curiosity, why didn't you do the code to also copy the attributes of NodeA to NodeB if Any? Is there a specific reason? I did the code, I'm just wondering if there is anything I should know.

Thanks
Faisal

How about this one -
If you work with the Amazon API for products, you know that the nodes come out basically in reverse order for any item. It will give you the node for the product, then the parent, then for the parent it gives the grandparent and so on. All digging deeper into the xml.
<node>
<ancestor>
<node>
<ancsetor>
.... up to top level node
</ancestor>
</node>
</ancestor>
</node>
So how to flip it around so I have an xml doc with the top level node (category) on down?
Lots of work. That's how. sigh.
Actually I'm thinking of converting it to an array and then going from there. Or a structure.

@Faisal,

I believe the node import bring the attributes along with it.

@Don,

Hmmm, sounds funky. I assume they are returning it that way for a practical reason?? I don't have much experience with Amazon's web services (just played around with it once or twice).

Hi, I would like to know if this is possible?

If yoou have:

<cfxml variable="xmlDate">

<date>

<meal>
<location>Ben's Pizza</location>
<time>7:30 PM</time>
</meal>

<movie>
<name>Friends With Money</name>
<time>9:15 PM</time>
</movie>

</date>

</cfxml>

And:

<cfxml variable="xmlGirls">

<girls>
<girl id="1">
<name>Kit Cat</name>
<hair>Brunette</hair>
<eyes>Blue</eyes>
</girl>
<girl id="4">
<name>Anna Banana</name>
<hair>Brunette</hair>
<eyes>Brown</eyes>
</girl>
<girl id="5">
<name>Marcie Darcey</name>
<hair>Blonde</hair>
<eyes>Brown</eyes>
</girl>
</girls>

</cfxml>

And you want to add girls as children of the root element date...
Thanks :)

@Christophe,

The code I have above is for copy one node's children to the child nodes of another node (in another document). Since you want to add the ROOT element of one XML document to the children of another node (in another document), you'd have to update the code to work with that.

I think it would work in basically the same way - you'd have to access the underlying Java methods on the root node to change it's document owner.

Okay, 2 answers long time coming.
1 - The reason to merge the documents is for reporting purposes. The full document would only be created once each day at night. The server it is done on has 12G of ram so that is not a problem. (Dual quad core wooo hooo). I finally just said to myself "self, just chop off the top level opening and closing of each document, put them together, and then put the opening and closing back on." Works well.
2 - Why does Amazon do what it does? Who knows. lol I have found many of these big companies are trying to create their own way of doing APIs etc forcing us developers to jump through hoops. I think it may be like IE marching to the beat of a different drum but being big enough to force others to follow along.
Google is doing this too in their new Analytics API. What a nightmare they have there. It is like "Geeks Gone Wild". They were told "Come up with something that will confuse the snot out of the average developer just to show how smart you are"

arg

@Don,

Ha ha, Geeks gone wild :) It sounds like you might want to explore some XML transform stuff if you need to get Amazon nodes in a different order (sorry, I sort of lost the conversation a bit).

Pretty sure that Xml Objects in coldfusion are collections of arrays and structs.

There is a reference here which says you can use all the native array and struct functions to manipulate the xml

http://www.co.multnomah.or.us/cfdocs/Developing_ColdFusion_MX_Applications_with_CFML/XML7.html

Is there ANYTHING you haven't done in ColdFusion, Mr. Nadel?

@Tony,

You can definitely treat XML objects like arrays and structures when it comes to things like XML children and XML attributes. There's also all kinds of pseudo-node-wrappers that can be used as well.

@Helgi,

Ha ha, I try to cover a lot of ground :)

F**king genius! Spent all day hitting brick wall after brick wall... Thanks mate!

@Joey,

Awesome - glad this helped. Even years later, I have not found a better way to move XML nodes from one document to another; I think dipping down into Java is the only way (without doing a lot of copying).

Today I came across this problem and your girls helped me a lot!

@Christian,

Ha ha, sometimes the girls really come through!

This solved a problem I had a while back and I've used it quite a lot since - but now found a problem. (CF8)

If the values in nodeB happen to have unicode escaped characters in them, then this UDF unescapes them.

For example:

nA:

nB:

result:

Having struggled with this for some time, the problem is not as described above.

It is actually appending just fine.

I think I must have done something to my dev server (CF8) which causes xmlParse() not to parse entities correctly because on my production server it is working as expected.

Even though that is Railo it's probably a .jar I've replaced by mistake on my dev server or something which is causing the problem....

Oh well... Happy new year anyway.

@Richard,

Is it possible that it's just outputting oddly when you debug it? Character encoding is a magical concept that my brain only understands slightly. I know there's a number of things that need to be in alignment for (moons, planets, etc.) in order for UTF-8 characters to display properly. This is doubly true when you add a database to the mix.

Thanks Ben :-)

Post A Comment

Comment Etiquette: Please do not post spam. Please keep the comments on-topic. Please do not post unrelated questions or large chunks of code. And, above all, please be nice to each other - we're trying to have a good conversation here.

Please review the following issues:

Author Name:
Author Email:
Author Website:
Comment:	Supported HTML tags for formatting: <strong>bold</strong>   <em>italic</em>   <code>code</code>
	Remember my information
	Subscribe to comments
	Send me a copy of this comment