DQL for output in excel
Comments
-
HI i want the answer for above one. pls help
0 -
Just use a tool like DQLTester or dqMan to execute the DQL and export to Excel.
Pedro Maia
Senior Consultant
OpenText1 -
@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.
0 -
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
OpenText0 -
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
0 -
SivDM is possible to export DQL result to excel
0 -
@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
0 -
if configured as DFC project along with latest jar, it is working fine
0
Categories
- All Categories
- 109 Developer Announcements
- 49 Articles
- 100 General Questions
- 122 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 123 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management