DQL for output in excel

anu1

Hi,

My requirement is as below to have output in excel -

User/Group Name

User email Address

Belongs to Group

Access Level

ACL Name

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

Thanks.

Find more posts tagged with

Documentum

Comments

Prabhadhit

HI i want the answer for above one. pls help

Pedro Maia

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

DCTM_Guru

@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.

Pedro Maia

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...

Rafa_Escribano

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

samgabarielbb

SivDM is possible to export DQL result to excel

DCTM_Guru

@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

samgabarielbb

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