Exporting Ticket data

When exporting a ticket data file from EasyTicketScan, it can be saved in either XML, CSV or TXT format. The file does not need to be exported in the same file format that it was imported in.

CSV

The CSV export provides a simple comma separated list of the ticket data. The export file contains the following data:

Ticket Number of all the tickets in the original import
Date and Time of those tickets scanned - blank if the ticket wasn’t scanned

Duplicate rows show if a ticket has been scanned more than once - see ticket 123123115

example of an CSV file

"123123111","2017-03-14T09:25:10.347Z"
"123123112","2017-03-14T09:25:21.132Z"
"123123113",""
"123123114",""
"123123115","2017-03-14T09:26:01.184Z"
"123123115","2017-03-14T09:26:11.403Z"
"123123116","2017-03-14T09:25:32.405Z"
"123123117","2017-03-14T09:25:42.255Z"

TXT

The TXT export provides a simple text file of ticket data. Fields are separated with a TAB character. The export file contains the following data:

Ticket Number of all the tickets in the original import
Date and Time of those tickets scanned - blank if the ticket wasn’t scanned

Duplicate rows show if a ticket has been scanned more than once - see ticket 123123115

example of an TXT file

"123123111" "2017-03-14T09:25:10.347Z"
"123123112" "2017-03-14T09:25:21.132Z"
"123123113" ""
"123123114" ""
"123123115" "2017-03-14T09:26:01.184Z"
"123123115" "2017-03-14T09:26:11.403Z"
"123123116" "2017-03-14T09:25:32.405Z"
"123123117" "2017-03-14T09:25:42.255Z"

XML

XML is the preferred export format as it provides the most information. The export file contains the following data:

Event ID
Event Name
Ticket Number (barcode) of all the tickets in the original import
Date and Time of those tickets scanned - if the ticket has not been scanned this field is not included

Duplicate tickets show if a ticket has been scanned more than once - see ticket 123123115

example of an XML file

<?xml version="1.0" encoding="UTF-8"?>
<event>
   <id>DM22</id>
   <name>Cinderella Matinee</name>
   <tickets>
      <ticket>
         <barcode>123123111</barcode>
         <datetime>2017-03-14T09:25:10.347Z</datetime>
      </ticket>
      <ticket>
         <barcode>123123112</barcode>
         <datetime>2017-03-14T09:25:21.132Z</datetime>
      </ticket>
      <ticket>
         <barcode>123123113</barcode>
      </ticket>
      <ticket>
         <barcode>123123114</barcode>
      </ticket>
      <ticket>
         <barcode>123123115</barcode>
         <datetime>2017-03-14T09:26:01.184Z</datetime>
      </ticket>
      <ticket>
         <barcode>123123115</barcode>
         <datetime>2017-03-14T09:26:11.403Z</datetime>
      </ticket>
      <ticket>
         <barcode>123123116</barcode>
         <datetime>2017-03-14T09:25:32.405Z</datetime>
      </ticket>
      <ticket>
         <barcode>123123117</barcode>
         <datetime>2017-03-14T09:25:42.255Z</datetime>
      </ticket>
   </tickets>
</event>

It is possible to easily import XML files into applications such as Microsoft Excel/Access.