importing Minor Branched versions to Documentum from excel sheet

itzmeyuva
edited August 23, 2016 in Documentum #1

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_idobject_namei_chronicle_idr_version_label
09015da883544975Operations Manual.pdf09015da8834097b51.3
09015da88360ca9cOperations Manual.pdf09015da8834097b51.4
09015da8834097b5Operations Manual.pdf09015da8834097b51
09015da8834a687cOperations Manual.pdf09015da8834097b51.1
09015da8834d4866Operations Manual.pdf09015da8834097b51.2
09015da88384a224Operations Manual.pdf09015da8834097b51.4.1.0
09015da8837fb283Operations Manual.pdf09015da8834097b51.4.1.1

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

Tagged:

Comments

  • DCTM_Guru
    edited August 12, 2016 #2

    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
    edited August 12, 2016 #3

    Johnny, we have so many files with branching .

  • DCTM_Guru
    edited August 12, 2016 #4

    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
    edited August 22, 2016 #5

    Thanks Johnny

  • itzmeyuva
    edited August 22, 2016 #6

    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
    edited August 23, 2016 #7

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