Skip to Content
avatar image
Former Member

InfoSet Query export to csv

I need to automate the output of an HR InfoSet Query to a csv file.

What is the best, straight forward approach to this?

Thank you,

Tammy Strole

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 13, 2015 at 09:56 PM

    I'm still looking for a solution, but did find information an enhancement called SQUE0001.  There are also statements that this is an "older" solution.  I followed the instruction I found to install this enhancement, which activates a "Private File' radio button on SQ01.  Can anyone comment on this approach?  Is there a newer solution I should be reviewing?  Although I successfully implemented the enhancement and added the necessary include, SQ01 does not output a file to the location I specify.

    Thank you,

    Tammy

    Add comment
    10|10000 characters needed characters exceeded

    • As mentioned by Shivendra, after you activate the enhancement point, you have to write logic into the actual user exit to derive the filename to store at the Application server along with the path, and then capture the list and drop it using that information.

      Elsewhere in SDN, I've seen a suggestion about writing a wrapper program that will call your query saving the results, and then after execution, pull the results from memory and write it wherever you

      need/want it to go.

      This is the direction I am likely to go in -- writing a wrapper program that accepts query name and variant details, along with a path for the eventual output.  This will then be re-usable for anyone seeking to do the same task for another query using a repetitive execution via batch job/scheduler.

      I am working on this now -- so if you want the details, I can post/share them when finished, hopefully before the end of this week.