Datadeploy fields A or B to DB

OK, so I have a ton of legacy data.

I need to put title into a DB now.

The problem is that these are different template types and the XML is not consistent. It may be /root/0/a/0/title in one type and /root/0/b/0/title in another.

So my options are:

change them to be consistent. This is way too ugly to think about.

I could write different deployments for each (and then a lot of WF changes)

I could attach an EA for Title (and script to process the legacy data) and push from the EA. The good news is I know how to do this, it is just a pain in the ****.

Other options ? Can I use a preprocessor for this ?

Tips/Pointers/RTFMs appreciated.

Andy

Find more posts tagged with

Comments

nipper

Well since I saw no replies to this, I will post what I decided to do:

I need to push from one set of templates /root/0/FOO/0/Title/0 and from a second set, /root/0/Title/0 to the same DB location.

I decided to separate the two in my deployment script and use the same deployment. I am pushing this part of the template:

/Root/0/^PARAM$Title/0 and on one DD call I leave the parameter null, and on the second call I use -k PARAM=FOO/0/