DOCUMENTUM - How can export the result of a DQL in CSV?
Comments
-
Hi,
Create new file: input.dql (Name can be any thing) and add required DQL file to the file.
Then, run the DQL from IDQL as below,
CMD> idql your_docbase -Udmadmin -Padmin -Rinput.dql -E -n >out.txtThere are many DQL/API utilities, like SAMSON, Repoint, DqMan..etc, to run DQL queries and export the results to excel/csv formats.
Hope this helps:)
Hari.Hari Gadhamsetty
Architect, Consulting Services
OpenText0 -
Hi,
The syntax is,
CMD> idql your_docbase -U -P -Rinput.dql -E -n >out.txtUse Documentum User name and its password in the above syntax. The above method is works properly with smaller result sets. If the result set is really huge, the command prompt might get hung. In case of huge result sets, use the third party tools suggested above as workaround.
Hope this helps:)
Hari.Hari Gadhamsetty
Architect, Consulting Services
OpenText0 -
Hi,
Does repoint work with CS 21.4. Facing multiple issues.
0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management