DOCUMENTUM - How can export the result of a DQL in CSV?

Answers

• Hari_Gadhamsetty EM

  March 4, 2018

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

  There 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
  OpenText

  0
• DJ_at_Times Sys Ad

  November 18

  Hi @Hari_Gadhamsetty , I tried your steps but CMD just hangs or it might be idql. the -udmadmin and -padmin inputs, does that mean username and password of the account logged into the server? Also, i noticed that you don't have any spaces between them. Thanks

  CMD> idql your_docbase -Udmadmin -Padmin -Rinput.dql -E -n >out.txt

  0
• Hari_Gadhamsetty EM

  November 19

  Hi,
  The syntax is,
  CMD> idql your_docbase -U -P -Rinput.dql -E -n >out.txt

  Use 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
  OpenText

  0
• DJ_at_Times Sys Ad

  November 19

  Hello @Hari_Gadhamsetty,

  Thank you for the quick response and explanation. You are correct, the results would be fairly big. I downloaded Repoint but it's just 3 folders, do you happen to know how to "install" it or get it to work? I can't find anything online.

  Thanks again.

  0