Deleting Content with DataDeploy

Hi -
I am currently planning to use datadeploy to deploy xml files to a custom database. These xml files may be the actual dcrs or an output of a tpl (that has not been decided yet). My question is how can I set up datadeploy to automatically delete the content from the db when the user decides to delete the dcr/xml from TeamSite? If this information is discussed in any IWOV documentation please refer me to the document as well. Thank you in advance for your help.

Find more posts tagged with

Comments

janhavi

Hi -
I am currently planning to use datadeploy to deploy xml files to a custom database. These xml files may be the actual dcrs or an output of a tpl (that has not been decided yet). My question is how can I set up datadeploy to automatically delete the content from the db when the user decides to delete the dcr/xml from TeamSite? If this information is discussed in any IWOV documentation please refer me to the document as well. Thank you in advance for your help.

Check for dodelete=yes tag in the IWOV document. You can run one OD script which will delete the content from the target server once you delete it from teamsite.

Thanks,
Janvi

Adam Stoller

Check for dodelete=yes tag in the IWOV document. You can run one OD script which will delete the content from the target server once you delete it from teamsite.

Thanks,
Janvi

That's for OD - for deleting a physical file from a server.
The question was regarding DD for deleting data from a DB - however, I believe the answer is that as long as the file being deleted can be easily determined by DD / the DBschema - DD should delete the data for you without any issues.

A simple test trial should help you determine if this works or not.
If it doesn't work - then providing a detailed DB dump (of the specific record, not the entire DB), the DD config file, the command line used to issue the deployment and the path of the file that was deleted and being deployed (usually a combination of a filelist entry and command line parameters) - would go a long way to helping others help you figure out the problem --- but try it all first it might "just work". If it doesn't - spend at least a day trying to debug it yourself before casting out for assistance.

joyedele

Thank you for your reply and under normal circumstances, this is something that I would have tested this, but I currently do not have an environment to test it in and that's why I reached out to devnet for some insight.

Adam Stoller

Thank you for your reply and under normal circumstances, this is something that I would have tested this, but I currently do not have an environment to test it in and that's why I reached out to devnet for some insight.

I can understand someone saying they don't have an environment to test it in when they suggest a possible solution (such as my suggestion) - however if you post the issue looking for help - you are expected to have the environment in which to verify the suggestions.

Whatever gets suggested here should always be tested - so you either test it in the environment you have (I'm assuming you have a production environment that you don't feel comfortable testing in?), create an environment to test it in, or live with the problem and move on to something else.

nipper

Whatever gets suggested here should always be tested - so you either test it in the environment you have (I'm assuming you have a production environment that you don't feel comfortable testing in?), create an environment to test it in, or live with the problem and move on to something else.

Who needs to test ? If you write perfect code..... Smiley Very Happy

kummi_ram

There are several ways of doing this

Enabling DAS would automatically delete the rows in DB when the delete the DCR/File in TS and submit them..

You can also do with metadata deployment by writing an external task.

Ram