Export of Stage Show Ticket Info in CSV format by default

  • Resolved feeman

    (@feeman)


    7 years, 5 months ago

    I want to know how difficult it would be export ticket info in CSV format.
    Currently, you can export in “TAB Separated Values”. However, I am trying to make it as easy as possible for others to review the ticket sales.

    I the US, if you double-click on a TAB Separated Value export (with a .txt extension) it is difficult for less techie folk to understand. However, a comma separated format, and the “.csv” extension that goes with it, will default to opening in a spreadsheet.

    The training for none technical staff goes WAY down.

    Can you help?

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Malcolm

    (@malcolm-oph)

    The reason it uses a TAB Delinated File (TDF) file is because it is easier (and probably more reliable) than a CSV file. The content can contain commas, but not TABs so a TDF file was much simpler to implement. Adding an export in CSV format would require significant development.

    Do you have “control” of the machines that are used to view the export files? If so changing the default file extension for the export could be a solution for you, and that is something that can be done relatively simply.

    Thread Starter feeman

    (@feeman)

    I’ll need to change the extention to something else ( like “.tab”) and then make it open in excel by default on each machine. We wouldn’t want “txt” to default to excel.

    Another way would be to offer export in CSV format, but use “|” instead of commas. This would bypass the “commas in the content” issue, and the user could make a one time change in thier international defaults to use | instead of comma for a default delimiter.

    Malcolm, perhaps i am approaching it wrong. If I have a box office person wanting to print out a list for a particular night to check people in (both sales and reservations), how SHOULD I be doing it? Maybe i am missing something….

    /patrick

    Plugin Author Malcolm

    (@malcolm-oph)

    This is the correct approach if you want a list.

    I think the best option is for you to change the file extension and set up each machine to open the file in excel.

    I’ve added two new (optional) constants STAGESHOW_EXPORT_TICKETS_FILEEXTN and STAGESHOW_EXPORT_SUMMARY_FILEEXTN which can be used to define the file extension for the two type of export. This will be in the next release, which I hope to get out later today.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Export of Stage Show Ticket Info in CSV format by default’ is closed to new replies.