v9 Export to CSV

Brian Echard
Brian Echard
in AppWorks #1

Is there a simple command to create a button on a form that will take a SQL query and allow the user to save to CSV locally?

Tagged:

Comments

  • Jerome_Pearce
    Jerome_Pearce
    #2

    We have a "business Object Reporting' library that extracts the data from a Business Object into an HTML table (eg for emailing). WE have recently add the ability to convert the results of SelectSql().

     

    We could (and plan to) add an ability to generate a TSV file, and we could possibly add a CSV file. CSV is far more awkward however, as you have to identify text data, escape existing double quotes, etc, etc, etc. Would TSV do the job?

  • Brian Echard
    Brian Echard
    #3

    tsv would probably work too.

  • Jerome_Pearce
    Jerome_Pearce
    #4

    I'll have a go and see if I have time today.

  • Elena Kendall
    Elena Kendall
    #5

    Are there any updates on how to export to Excel?

     

    Thanks,

    Elena

Categories

image
OpenText CE Products
AppWorks
Gateway & Platform