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

How can export the result of a DQL in CSV? I would like to export the result of my DQL search in .CSV to analyse it. Does anyone know how to do this?

Answers

  • 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

Sign In or Register to comment.