Ticket Order Import Utility

Thanks everyone for your help! That was awesome!

>>> "Jonathan Smillie" 4/12/2011 11:59 AM >>>

Hi Amy,
Try this: when you save the export file, include the column headers. Then before you upload the file, edit it in Notepad (or Notepad++, a very handy free utility you can download, and which is much more versatile) and remove the header line. That should preserve those columns.
Alternatively, do a variation on that theme and put some dummy data in the first row of data for those five columns, save the file, edit it and remove the dummy data. Again, that should preserve the existence of the columns.

From: Amy Aldrich
Sent: 4/12/2011 10:46:12 AM

Hello,
I am preparing an excel file for the Ticket Import Utility, and the first 5 columns in the spreadsheet are to be left blank as we don't have any data to input in them. According to the documentation, they have to be present even though there isn't any data for them. I am running into the issue that when the file is saved it deletes those first blank 5 columns. There is no header so it just thinks its blank data. The rest of the blank columns in the spreadsheet are fine, its just the ones at the beginning before the data in the columns begins.
Has anyone ran into this before and might you have a solution to keep the blank columns?
Thanks!



This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Thanks everyone for your help! That was awesome!

>>> "Jonathan Smillie" 4/12/2011 11:59 AM >>>

Hi Amy,
Try this: when you save the export file, include the column headers. Then before you upload the file, edit it in Notepad (or Notepad++, a very handy free utility you can download, and which is much more versatile) and remove the header line. That should preserve those columns.
Alternatively, do a variation on that theme and put some dummy data in the first row of data for those five columns, save the file, edit it and remove the dummy data. Again, that should preserve the existence of the columns.

From: Amy Aldrich
Sent: 4/12/2011 10:46:12 AM

Hello,
I am preparing an excel file for the Ticket Import Utility, and the first 5 columns in the spreadsheet are to be left blank as we don't have any data to input in them. According to the documentation, they have to be present even though there isn't any data for them. I am running into the issue that when the file is saved it deletes those first blank 5 columns. There is no header so it just thinks its blank data. The rest of the blank columns in the spreadsheet are fine, its just the ones at the beginning before the data in the columns begins.
Has anyone ran into this before and might you have a solution to keep the blank columns?
Thanks!



This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!