Tech Kraft

Documentum, AWS, Java, Ruby on Rails, Linux, Windows, App Servers

Documentum

  • DQL: Hidden DQL Tricks and Behaviors

    Here are a few DQL tricks and behaviors that are not always obvious. Using r_object_id in the select statement changes the resultset. The following DQL for any r_folder_path will return multiple rows for the same object. select object_name, r_folder_path from dm_folder where any r_folder_path is not nullstring By adding r_object_id to the select statement, the Continue reading

    ,

  • DQL: How to find Documentum folders with 0 (zero) documents in any subfolders

    I was recently asked to find all custom folders in a cabinet which may have other nested folders, but no documents. In other words, folders can have other folders, but not documents. In order to find empty folders, with no documents or sub-folders, is straightforward: select * from dm_folder where i_reference_cnt=0 But what we are Continue reading

    ,

  • Documentum: Software to Download Documents and Metadata

    I have written a software in Java using DFC. This software performs the following tasks: Performs export or import of documentum data Download all documents given a folder/cabinet in Documentum Download all document metadata, including custom metadata without having to specify the specific fields All the metadata is saved in an xml file The field Continue reading

    , ,

  • DQL: Listing documents with their Folderpaths

    Here’s a DQL to get a listing of Documents along with their folderpaths in the repository: select fld.r_folder_path, doc.r_object_id, doc.object_name, doc.r_content_size, doc.acl_name, doc.r_creation_date, doc.r_modify_date, doc.r_creator_name, doc.title, doc.subject, doc.keywords from dm_document doc, dm_folder fld where folder(‘/<CABINET_NAME>’, descend) and fld.r_object_id = doc.i_folder_id and any r_folder_path is not nullstring enable (ROW_BASED) Continue reading

    ,

  • DQL: Total Document Content Size By Cabinet

    Here is a DQL statement to find the total document size by cabinet. You may be aware that dm_document has two different attributes for content size: r_content_size, r_full_content_size The first one, r_content_size, can only store sizes upto 2 GB. r_full_content_size stores the correct size if the content is larger than 2 GB. Weird. I know. Continue reading

    ,

  • Documentum DFC: How to get custom attributes

    Here is a way to get all the custom attributes of an object in DFC without knowing them ahead of time:                 //Custom Attributes                 String allAttributes = dctmFileObject.dump();                 String customAttributes = allAttributes.substring(allAttributes.indexOf(“language_code”), allAttributes.indexOf(“SYSTEM ATTRIBUTES”));                                  try (BufferedReader Continue reading

    ,

  • Documentum: How to Delete TBO

    Steps for deleting a TBO…. Delete the module under /System/Modules/TBO folder Delete it from the app server cache ($DOCUMENTUM_SHARED/cache/<version>/bof/<docbase name> Restart application server Continue reading

  • Documentum: DQL to get folders and permissions

    To retrieve the folder paths and permissions on each folder, use the following query: SELECT sr.r_folder_path, ar.r_accessor_name, ar.r_accessor_permit, ar.r_accessor_xpermit FROM dm_acl_s a, dm_acl_r ar, dm_folder s, dm_folder_r sr WHERE a.r_object_id = ar.r_object_id AND s.r_object_id=sr.r_object_id AND a.object_name = s.acl_name AND sr.r_folder_path like ‘/CABINET_NAME%’ AND sr.i_position = -1     Continue reading

    ,

  • Documentum: How to encrypt password

    In order to encrypt a password, go to where the dfc.jar is located using command prompt Type in the following command, and the result is the encrypted password: java -cp dfc.jar com.documentum.fc.tools.RegistryPasswordUtils password_to_encrypt   Continue reading

  • DQL:How to get count of all documents by folder

    Here is how to get a count of all the documents in a cabinet by folder: select count(*), f.r_folder_path from dm_document d, dm_folder f where d.i_folder_id = f.r_object_id and folder(‘/CABINET_NAME’, descend) and f.r_folder_path is not nullstring group by f.r_folder_path enable(row_based) Continue reading

    ,

About Me

Senior Software Engineer professional with over 16 years of success with multiple open source technologies and various Content Management platforms and solutions.

Proven technical abilities through numerous projects involving enterprise web application design and development, application installation, configuration and support, and workflow and collaboration system designs.

  • Ability to learn new technologies and platforms quickly and apply them to the task at hand.
  • Excellent analytical skills, and strong communication and collaboration abilities.
  • Technical emphasis in including but not limited to Java, Ruby on Rails, Documentum and Alfresco
    in both Linux and Windows based environments

Recent Posts

Newsletter