Database to xml for data migration

Hi Everyone,

I have searched google for answers and have gone down a few paths of
investigation… But being a newbie I am rapidly getting confused and
this should essentially be a very simple task.

What I need is some advice on the best way to go about this problem.

We are needing to generate XML documents for a migration into a new
system from an existing database.

I looked into the ruby builder library, but couldn’t see too many
examples outside of rails to build the XML up from a template. I know I
can put together a rails app to use an rxml template etc, but going down
that path seems to much effort for this…

I have a template of the xml I need to upload, what I need is to
populate that template for each db record. What is the simplest, best
ruby way to export from the db into xml?

Thanks for your help!

A rails application would be the most suitable to generate an XML from
database.

http://www.xml.com/pub/a/2007/01/17/making-xml-in-a-rails-app-xml-builder.html
Cameron S. [email protected] wrote:
Hi Everyone,

I have searched google for answers and have gone down a few paths of
investigation… But being a newbie I am rapidly getting confused and
this should essentially be a very simple task.

What I need is some advice on the best way to go about this problem.

We are needing to generate XML documents for a migration into a new
system from an existing database.

I looked into the ruby builder library, but couldn’t see too many
examples outside of rails to build the XML up from a template. I know I
can put together a rails app to use an rxml template etc, but going down
that path seems to much effort for this…

I have a template of the xml I need to upload, what I need is to
populate that template for each db record. What is the simplest, best
ruby way to export from the db into xml?

Thanks for your help!

XML output may be generated from database query using
DBI::Utils::XMLFormatter module.

Refer Listing 5.
http://www.oracle.com/technology/pub/articles/marx-ruby.html

Cameron S. [email protected] wrote:
Hi Everyone,

I have searched google for answers and have gone down a few paths of
investigation… But being a newbie I am rapidly getting confused and
this should essentially be a very simple task.

What I need is some advice on the best way to go about this problem.

We are needing to generate XML documents for a migration into a new
system from an existing database.

I looked into the ruby builder library, but couldn’t see too many
examples outside of rails to build the XML up from a template. I know I
can put together a rails app to use an rxml template etc, but going down
that path seems to much effort for this…

I have a template of the xml I need to upload, what I need is to
populate that template for each db record. What is the simplest, best
ruby way to export from the db into xml?

Thanks for your help!

Great - thanks for the responses!

I had mostly discounted the rails option but it seems to be the best way
to control the actual output, as there is a bit of processing that needs
to be done on the data.

I just wanted to make sure I wasn’t missing the easy way to do this
rather than wrap a framework like rails around a simple db export ruby
script!

thanks again.

require “rexml/document” ;include REXML

@Skeleton = <<EOF

EOF

someItems= REXML::Document.new(@Skeleton)

Then you could add an/some elements:

Iterate here

someItems.elements[’//anItem’].text = “someThing”

@drTransactionFile = File.open( “someXML.xml”, “w”)
@drTransactionFile.write("" << someItems.to_s <<
“”); @drTransactionFile.close

Not necessarily fast, maybe simple, doubtfully best.

MarkT

2007/12/10, cs ss [email protected]:

Great - thanks for the responses!

I had mostly discounted the rails option but it seems to be the best way
to control the actual output, as there is a bit of processing that needs
to be done on the data.

I just wanted to make sure I wasn’t missing the easy way to do this
rather than wrap a framework like rails around a simple db export ruby
script!

Well, if it is just a single and static template you could even use
string interpolation to do the job. Certainly faster than REXML but
YMMV.

Kind regards

robert

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs