Welcome and thank you for joining our new OpenText forum. Your questions, responses, best practices, and tips shared with other members will help make this channel vibrant. We're glad you're joining us and look forward to collaborating with you online.

Check out the Getting Started With OpenText Forums for tips on personalizing your experience.

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.