importing Minor Branched versions to Documentum from excel sheet

Hi All ,

We have one requirement to load the documents(physical location) metadata(Spreadsheet) to Documentum .

we have minor branched versions as part of the sheet as below example .

r_object_id	object_name	i_chronicle_id	r_version_label
09015da883544975	Operations Manual.pdf	09015da8834097b5	1.3
09015da88360ca9c	Operations Manual.pdf	09015da8834097b5	1.4
09015da8834097b5	Operations Manual.pdf	09015da8834097b5	1
09015da8834a687c	Operations Manual.pdf	09015da8834097b5	1.1
09015da8834d4866	Operations Manual.pdf	09015da8834097b5	1.2
09015da88384a224	Operations Manual.pdf	09015da8834097b5	1.4.1.0
09015da8837fb283	Operations Manual.pdf	09015da8834097b5	1.4.1.1

How to achieve this ? any code sample would really help .

Find more posts tagged with

Documentum

Comments

DCTM_Guru

Is it just these 7 files or do you have a lot? If its just these 7 files, you can do use Webtop and manually checkout/checkin and duplicate the branching of the versions.

If there is a lot of files, then I suggest your write a DFC app to do this. It should be straight-forward, but you will need to do a lot of testing to get the branching correct.

itzmeyuva

Johnny, we have so many files with branching .

DCTM_Guru

Then, writing a DFC app is the way to go. I know there are migration tools out there (e.g. OpenMigrate), but I'm not sure if they support branching.

itzmeyuva

Thanks Johnny

itzmeyuva

One more query Johnny .. We are mapping r_modifier,r_modify_date and owner_name attributes from source to target Documentum environment .. After the migration , owner name and r_ modifier shows the superuser account name which we used to migrate and modify date as current date when migration happened . Is there any way to map these attributes as in source system .

DCTM_Guru

Yes, but you need to update them using SQL (not DQL).