Interpreting the CSV

I downloaded another copy of the file and it looked identical to the one I used yesterday. I opened it with Excel(2013) originally and today opened it with Notepad and it is indeed Comma delimited. Am i correct that the stage in the CSV is on the left?

Here’s the url to the site where I am testing this…
http://www.dsvanprooyen.net/test-page

Ultimately, I want to set up events and sell tickets for this nonprofit organization http://www.peoriacivicchorale.org

This is what the CSV file I downloaded looks like…. (below the Equals signs)
===============================================
,”Legend: Y= Available,B=block”,,,,,,,,,,,,,,,,,
,”Row # ex. [A, B, C, etc]”,,,,,,,,,,,,,,,,,
,”Seat # ex [1, 2, 3, 4, etc]”,,,,,,,,,,,,,,,,,
Price,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11,11
,ROW,ROW,ROW,ROW,ROW,ROW,STALL,ROW,ROW,ROW,BALCONY,ROW,ROW,ROW,CIRCLE,ROW,ROW,ROW
SEAT #,BB,AA,A,B,C,D,,E,F,G,,H,I,J,,K,L,M
1,,,,,,,S,,,,L,,,,C,,,
2,,,,,,,S,,,,L,,,,C,Y,Y,Y
3,,,,,,,S,,,,L,,,,C,Y,Y,Y
4,,,,,,,S,,,,L,Y,Y,Y,C,Y,Y,Y
5,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,Y,Y,Y
6,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,Y,Y,Y
7,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,Y,Y,Y
8,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,Y,Y,Y
9,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,Y,Y,Y
10,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,Y,Y,Y
11,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,Y,Y,Y
12,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,,,Y
13,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,,,Y
14,,,,,,,S,,,Y,L,,,,C,,,Y
15,,,,,,,S,,,Y,L,,,,C,,,Y
16,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,,,
17,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,,,
18,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,,,
19,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,,,
20,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,,,
21,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,,,
22,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,,,
23,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,,,
24,Y,Y,Y,Y,Y,Y,S,Y,Y,Y,L,Y,Y,Y,C,,,
25,,,,,,,S,,,,L,Y,Y,Y,C,,,
26,,,,,,,S,,,,L,Y,Y,Y,C,,,
27,,,,,,,S,,,,L,Y,Y,Y,C,,,

If I put an “N” in a given spot that seat should show up as sold or not available, correct?

Also, Should I be seeing a seating chart when I click on “See the Show” or when I display http://www.dsvanprooyen.net/test-page using the shortcode?

I sure must be missing something…

Also in the template I downloaded as shown above there are other letters like C, S, L that are not in the legend and words like Row, Price, Circle and Stall should I remove those lines from the CSV?

I should add that I have not purchased any of the paid modules… I am manually editing the CSV with Excel 2013. I want do the proof of concept before I go to the board of trustees for the organization for funding. We are very interested in being able to sell tickets via our website and RowSeats looks like a good solution. We have been trying the Modern Tribe product suite but they do not have seat selection. Woo allowed us to have a free copy of their plugins as we are a non profit organization

When I set up my show in the calendar i had the orientation left to right but in the downloadable CSV it appears the seating orientation is right to left. I changed the orientation in the show and the chart looks a lot better 🙂

http://www.dsvanprooyen.net/test-page

Not sure why Stall, Balcony and Circle appear the way they do but I will figure it out

Thanks for your patience…

gcwebsolutions

With your help… I think I have figured out how to create a seating chart for the various venues where our chorale performs. I have a couple of related questions about the creation of the show itself. We typically have 2 or 3 concerts per series. One series in the fall around Christmas and the other in the Spring (usually in May)

Is there a way the buying public can go to the calendar and select the specific concert (event) for which they want to purchase tickets. From my perspective it looked like the calendar was only accessible on the backend.

Related to the above, when I setup my events using either the date or week option, I could set the start time but could not set an end time. Not a big deal but the documentation said one could

gcwebsolutions

Sure would appreciate a pointer to the page…

Thanks,
Dutch65