How to update attributes of some documents with values from an Excel file?

We need to update couple of attributes for hundreds of documents stored in Documentum. We cannot manually update one by one. Therefore, we would like to update the attributes of documents through a script / query, which should read the attributes value from Excel file and accordingly update the attributes of documents.
Please let me know, How to read values from an Excel file and Update couple of custom attributes for multiple documents within Documentum?
Thanks in advance.
Regards,
Arun
Comments
-
Search for Apache POI. Get the jars from apache website. Than google or check for samples on the website itself for how to read excel using POI. You can find most of the code online. Than just customize it as per your need and write dfc code for updating it. That's it. once you have a template ready, it could be of great help to you in future as well.
Hope that helps!!
0 -
In such cases I write an excel formula:
=CONCATENATE("UPDATE dm_document object set title='";$B2;"', set subject='";$C2;"' where r_object_id='";$A2;"'")
Of course you need the r_object_ids for each row (in this case column A is r_object_id, B is the title and C is subject to set), to know which document to update with those values...
You only need to add a "go" statement between each row (copy paste into a text editor, search-and-replace "\n" with "\ngo\n") and save this file, then run it with idql:
$DM_HOME/bin/idql reponame -Uuser -Ppassword -Ryour_input_file.dql
Mike
0 -
Can we use REST API to update objects and their metadata? Could you please share syntax for that? Thanks.
0
Categories
- All Categories
- 124 Developer Announcements
- 54 Articles
- 156 General Questions
- 155 Thrust Services
- 56 Developer Hackathon
- 38 Thrust Studio
- 20.6K Analytics
- 4.2K AppWorks
- 9.1K Extended ECM
- 920 Core Messaging
- 84 Digital Asset Management
- 9.4K Documentum
- 34 eDOCS
- 195 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 11 XM Fax
- Follow Categories