Datadeploy fields A or B to DB

Andy Knipp

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