Home Documentum

DQL for output in excel

edited September 23, 2014 in Documentum

Hi,

My requirement is as below to have output in excel -

User/Group NameUser email AddressBelongs to GroupAccess LevelACL Name

Please let me know how can this be achieved using DQL.

Thanks.

Comments

  • HI i want the answer for above one. pls help

  • PedroMaiaPedroMaia Senior Consultant (OpenText) EM
    edited January 29

    Just use a tool like DQLTester or dqMan to execute the DQL and export to Excel.

    Pedro Maia
    Senior Consultant
    OpenText

  • edited January 29

    @PedroMaia - have you ever tried using dqMan with repository that has records installed on it? We deployed records DAR and now dqMan no longer can connect to 7.3 repository. It worked perfectly before records installation. As part of records deployment, I vaguely remember seeing a warning that any 5.3 clients will no longer worked, but I figured dqMan was 6.x/7.x client since it uses dfc.jar.

  • PedroMaiaPedroMaia Senior Consultant (OpenText) EM
    edited January 29

    Hi Johnny - I'm afraid I haven't worked with RM for some years, so I haven't tried this.I am using dqMan 6.0.1.2 that still relies on dmcl40.dll and dmcl.ini...

    Pedro Maia
    Senior Consultant
    OpenText

  • From custom Java program, you can use DFC to run the DQL and get the results. Then, use Java libraries such as Apache POI to generate an Excel.

    dqMan has an option to export to Excel, but I am not quite sure it can connect to modern versions of Documentum 16.x

  • SivDM is possible to export DQL result to excel

  • @samagabrielb - does SivDM support Documentum 16.x? Most of the older DQL utilities are dmcl based and will not work on latest version of Documentum

  • if configured as DFC project along with latest jar, it is working fine

Sign In or Register to comment.