Content Identifier

Hi,

I am working on TS 6.7.1/OD 6.1.1 on Windows. Right now, we have been deploying content to the database using custom perl scripts thro OD. I am checking to see if we can use DD config instead of the perl scripts. I have two questions here -
1. Could you think of any guidelines for choosing between perl scripts and DD config?
2. If you use DD config, what data field would you use as the "primary key" for uniquely identifying the content?

TIA!

Find more posts tagged with

Comments

cesarecastro

If you own the DD module I would suggest using DD configs unless you are deploying to a non supported database. DataDeploy is a great tool to deploy data and it is constantly evolving.

As far as creating a primary key there are many approaches to this. We have an ecm_id that is assigned to each new DCR upon save. This key just takes a date/time stamp and converts to milliseconds. This assures that no ecm id will ever be the same. Oh! and it also allows us to set the same ID, if we wanted to, to display the same content across locales in different languages.

sumitk

I completely agree with the first reply. DD is indeed a great tool to deploy data into database. As far as the primary key is concerned, you can decide based on your form fields or you can generate a unique number for each DCR. The application of database design should be as per your form.

kshitiz

Always take care while deciding your primary key. You have to either auto-generate that particular value while saving your DCR or if it is being entered by user, you have to take care of its uniqueness. The best way is to treat the path of the DCR as primary key.