PS Query & SQL

 View Only

  • 1.  PT 8.62 Query CSV Output - header row

    Posted 27 days ago

    Hello,

    I recall reading that PT 8.62 would add the ability for CSV query output to include a header row. However, I haven't been able to find any documentation in PeopleBooks or anyone else describing this.
    Is this feature configurable?
    Any insight would be helpful.
    Thanks!
    Jeff


    ------------------------------
    Jeff Wilson
    Lead Systems Analyst
    Northwestern University
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------
    Alliance 2026 Recordings are coming soon!


  • 2.  RE: PT 8.62 Query CSV Output - header row

    Posted 27 days ago
    You can use transformation for that.   I'm at Alliance, but I can send you the presentation I used and what mine looks like when I get back to the office on Thursday.


    Thanks!

    Dana Pawlowicz

    Business Systems Analyst Sr - ERP

    Business Enterprise Systems and Technologies
    Digital Technology Solutions

    University of Cincinnati

    51 Goodman Dr.

    Cincinnati, Oh 45221

     

     




    Original Message
    Alliance 2026 Recordings are coming soon!


  • 3.  RE: PT 8.62 Query CSV Output - header row

    Posted 26 days ago

    I'd be interested as well, Dana.  Thank you!



    ------------------------------
    Joanne Nikkel
    Business Analyst
    University of Calgary
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Original Message
    Alliance 2026 Recordings are coming soon!


  • 4.  RE: PT 8.62 Query CSV Output - header row

    Posted 26 days ago

    I should probably clarify.  In 8.62, the CSV query output includes a file header (e.g. column names) by default.  So, my question is, does anyone know if there is a setting to toggle this new feature on/off?



    ------------------------------
    Jeff Wilson
    Lead Systems Analyst
    Northwestern University
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Original Message
    Alliance 2026 Recordings are coming soon!


  • 5.  RE: PT 8.62 Query CSV Output - header row

    Posted 25 days ago
      |   view attached

    Okay, so you are wanting to remove the header.   I don't know.  But, for someone wanting to use transformation, this is the presentation I used to set mine up.

     

     

     

    Thanks!

    Dana Pawlowicz

    Business Systems Analyst Sr - ERP

    Business Enterprise Systems and Technologies
    Digital Technology Solutions

    University of Cincinnati

    51 Goodman Dr.

    Cincinnati, Oh 45221

     

     




    Attachment(s)

    pdf
    Alliance2014 Query-Transformations.pdf   4.02 MB 1 version
    Original Message
    Alliance 2026 Recordings are coming soon!


  • 6.  RE: PT 8.62 Query CSV Output - header row

    Posted 25 days ago

    This must be a configuration setting, because the headers have always appeared for me, when I run to TXT (which has the CSV file extension). I have never not seen headers, before and after 8.62.

     

     

    Stephen Forrest

     

    Institutional Research Analyst the Third

    University Decision Support

    Enrollment Management Research Group

    Office of the Provost

    Southern Methodist University

    sforrest@smu.edu

    214-768-4015

     

    "The only reason we put the data in, is to take the data out."

     

     

     

     




    Original Message
    Alliance 2026 Recordings are coming soon!


  • 7.  RE: PT 8.62 Query CSV Output - header row

    Posted 25 days ago
    Thought I would ask Google AI....  Two similar tries... here's what I got (summarized: "No" along with a few workaround options):


    ...and the similar question with a slightly expanded "No" and same workaround options (not included)....



    David Ehrlich | Senior Business System Analyst

    Duke University | Student Information Services & System (SISS)

    david.ehrlich@duke.edu | 919-684-1206

    www.sissoffice.duke.edu





    Original Message
    Alliance 2026 Recordings are coming soon!


  • 8.  RE: PT 8.62 Query CSV Output - header row

    Posted 25 days ago

    Headers are always there unless you create a Transformation for the query as Dana indicated.  Bear in mind that if you are using Scheduled Query within JobSets, Transformation (XFORM) will not be honored even though it is an option.

     




    Original Message
    Alliance 2026 Recordings are coming soon!


Related Content