DCR's from database

I need to convert 16000 database records to DCR's. I've already built the necessary config files for Datadeploy and the standalone deployment works fine.

Can I use the config files I created for datadeploy to extract content from a database and create a set of DCR's (with custom xml format) in Teamsite? How would the files be named?

If I can't do the above does anyone have any suggestions for converting these database records to our custom xml format?

Using TS 6.1, datadeploy 5.6, solaris, oracle, standalone deployment.

Thank you,

Michael

Find more posts tagged with

Comments

nipper

Yes, DD has a DB to XML setting. Though I have never used it.

Either way you have a couple issues to figure out, first DCR name as you pointed out,
second is DCR location. You do not wat 16K DCRs in one directory, so you will need
to determine a directory structure.

We did something on that order of magnitude, wrote a perl script to read the DB, determine the
path (dir and filename from entries in each record) and wrote out XML.

One point that hurt us was the fact that there were some unescaped characters in the DB
that caused problems later (like &). I built the XML by hand, not using the perl utilities, which
should have fixed those.

So in a nutshell, you will likely have a script that reads the DB, determines file and dir
and then kicks off XML generation via DD or script.

Andy

monk1

Thanks Andy. I was hoping someone had used DD for something this specific but my suspicion is that while DD does offer a DB to XML conversion the actual results are too crude for our requirements. Too bad, it would be a useful feature for DD. Time to write that script.

Michael

nipper

& DD does move a record at a time. Like I say your biggest issue will
be creating a directory structure and DCR names based on those DB records.

No chance DD ca do that for you

Andy