Compiled Lounge Details - Test

Status
Not open for further replies.

SeatBackForward

Established Member
Joined
Jun 20, 2006
Posts
4,897
Qantas
LT Gold
Oneworld
Emerald
Hi All,

So I think I'm in a position where I can re-start the blogs of monthly Lounge details. This time I want to try a new method of collecting data if others are interested. I've created a Google online form that can be populated with the minimum and additional data, which I can use to populate the monthly Blogs like I was running last year.

At this stage I want to just test it, but if anyone else is interested, they can enter real data and I'll publish based on that. Here is the Blog entry for it:

Complied Lounge Details - TEST - Blogs - The Australian Frequent Flyer Online Community

Or if you want to skip straight to the Data form:

https://docs.google.com/forms/d/1pQbuhxczSrVZDqLLbKFTEp9GC3b8YoHIlq1l3fSOCcw/viewform

Alternatively, if the data can be listed strictly as NAME,DATE,AIRPORT,TIME seperated by comma's that will make life easier (for me at least) easier.
 
Not an exciting start, and I would've had it much faster if someone hadn't come to speak to me (they expect me to work at work!??)

Code:
Sun, March 17		
	SYD - Sydney, New South Wales, Australia (SYD)	
		07:15, simongr, QF J DOM, 2 available
Mon, March 18		
	MEL - Melbourne, Victoria, Australia (MEL)	
		18:15, simongr, QF J DOM, 2 available
Sat, March 23		
	BNE - Brisbane, Queensland, Australia (BNE)	
		14:00, Lindsay Wilson, VA Lounge, +2
Sun, March 24		
	SYD - Sydney, New South Wales, Australia (SYD)	
		19:00, Lindsay Wilson, VA Lounge, +2
Wed, March 27		
	CBR - Canberra, Australia (CBR)	
		10:25, Rox, Qp, 1
		21:55, Rox, QP, 1
 
Last edited:
The Frequent Flyer Concierge team takes the hard work out of finding reward seat availability. Using their expert knowledge and specialised tools, they'll help you book a great trip that maximises the value for your points.

AFF Supporters can remove this and all advertisements

Does it not post automatically to the blog?

No, the form enters into a Google Spreadsheet, which I then push through an MS Access database to produce a "grouped" report, that groups on date and airport code to produce the list.

The reason I chose a Blog over a forum post is that a Blog can be editted at anytime, whereas forum posts can only be editted within 24hrs. Auto posting onto a blog would be sensational.

The big issue with this method, is that any changes to existing data can't be made by the users, I have to manually remove them. But i'm sure I'll figure something out in time. (I'm not in IT or a programmer of any sort, but my day job involves extensive use of spreadsheets/databases so I know a little thing or two)
 
Thanks - seems sensible.

Straitman does something similar for the Hilton meeting thread - without the bells and whistles...
 
The reason I chose a Blog over a forum post is that a Blog can be editted at anytime, whereas forum posts can only be editted within 24hrs.

The big issue with this method, is that any changes to existing data can't be made by the users, I have to manually remove them. But i'm sure I'll figure something out in time. (I'm not in IT or a programmer of any sort, but my day job involves extensive use of spreadsheets/databases so I know a little thing or two)

If you ask a Moderator very nicely, it can be done - so long as it isn't materially affecting the information which is already part of the public record ;)
 
If you ask a Moderator very nicely, it can be done - so long as it isn't materially affecting the information which is already part of the public record ;)

The Blog works well because It can be updated easily and frequently, and of course having a Blog post for each month means once the month has ended, the Blog just sits there quietly doing nothing. Plus I like not being an extra burden on the admin/mods :)
 
Code:
Sun, March 17		
	SYD - Sydney, New South Wales, Australia (SYD)	
		07:15, simongr, QF J DOM, 2 available
Mon, March 18		
	MEL - Melbourne, Victoria, Australia (MEL)	
		18:15, simongr, QF J DOM, 2 available
	SYD - Sydney, New South Wales, Australia (SYD)	
		13:00, Princess Fiona, T1 QF Flounge, 1
Sat, March 23		
	BNE - Brisbane, Queensland, Australia (BNE)	
		14:00, Lindsay Wilson, VA Lounge, +2
Sun, March 24		
	SYD - Sydney, New South Wales, Australia (SYD)	
		19:00, Lindsay Wilson, VA Lounge, +2
Wed, March 27		
	CBR - Canberra, Australia (CBR)	
		10:25, Rox, Qp, 1
		21:55, Rox, QP, 1
 
I have to park this for the day, will be back to update in the morning and see how it pans overnight.
 
i have submitted a few , so looking forward to the look of it all
 
Scored a seat on the bus ride home So i can keep updating for a little bit more

Code:
Sun, March 17		
	MEL - Melbourne, Victoria, Australia (MEL)	
		19:00, Bofter, Virgin, 1 available
	SYD - Sydney, New South Wales, Australia (SYD)	
		07:15, simongr, QF J DOM, 2 available
Mon, March 18		
	MEL - Melbourne, Victoria, Australia (MEL)	
		18:15, simongr, QF J DOM, 2 available
	SYD - Sydney, New South Wales, Australia (SYD)	
		13:00, Princess Fiona, T1 QF Flounge, 1
Sat, March 23		
	BNE - Brisbane, Queensland, Australia (BNE)	
		14:00, Lindsay Wilson, VA Lounge, +2
Sun, March 24		
	SYD - Sydney, New South Wales, Australia (SYD)	
		19:00, Lindsay Wilson, VA Lounge, +2
Wed, March 27		
	CBR - Canberra, Australia (CBR)	
		10:25, Rox, Qp, 1
		21:55, Rox, QP, 1
Wed, April 10		
	BNE - Brisbane, Queensland, Australia (BNE)	
		09:00, GPH, QF J Lounge, 2
	SYD - Sydney, New South Wales, Australia (SYD)	
		13:00, GPH, QF F  lounge, 0
Thu, May 9		
	SYD - Sydney, New South Wales, Australia (SYD)	
		06:00, GPH, QF F Lounge, 2

I will eventually split it all into monthly posts too, if i have some spare time tomorrow, I'll trawl through the March, April, May, June threads and populate them myself.
 
Sun, March 17
MEL - Melbourne, Victoria, Australia (MEL)
19:00, Bofter, Virgin, 1 available
SYD - Sydney, New South Wales, Australia (SYD)
07:15, simongr, QF J DOM, 2 available
Mon, March 18
MEL - Melbourne, Victoria, Australia (MEL)
18:15, simongr, QF J DOM, 2 available
SYD - Sydney, New South Wales, Australia (SYD)
13:00, Princess Fiona, T1 QF Flounge, 1
Sat, March 23
BNE - Brisbane, Queensland, Australia (BNE)
14:00, Lindsay Wilson, VA Lounge, +2
Sun, March 24
SYD - Sydney, New South Wales, Australia (SYD)
19:00, Lindsay Wilson, VA Lounge, +2
Wed, March 27
CBR - Canberra, Australia (CBR)
10:25, Rox, Qp, 1
21:55, Rox, QP, 1
Wed, April 10
BNE - Brisbane, Queensland, Australia (BNE)
09:00, GPH, QF J Lounge, 2
SYD - Sydney, New South Wales, Australia (SYD)
13:00, GPH, QF F lounge, 0
Thu, May 9
SYD - Sydney, New South Wales, Australia (SYD)
06:00, GPH, QF F Lounge, 2
 
I loved this last year, SeatBackForward. Thanks for bringing it back - with a makeover too!
 
This looks good. Put an entry for Monday 18th in but may not be on the same flight as Princess Fiona
 
Thu, March 14
PER - Perth, Western Australia, Australia (PER)
08:30, dtm1, 1
Sat, March 16
BNE - Brisbane, Queensland, Australia (BNE)
08:25, samh004, Dom J, 2
19:00, samh004, Dom J, 2
MKY - Mackay, QL, Australia (MKY)
12:05, samh004, QP, 2
ROK - Rockhampton, QL, Australia (ROK)
11:15, samh004, QP, 2
16:50, samh004, QP, 2
Sun, March 17
MEL - Melbourne, Victoria, Australia (MEL)
19:00, Bofter, Virgin, 1 available
SYD - Sydney, New South Wales, Australia (SYD)
07:15, simongr, QF J DOM, 2 available
Mon, March 18
MEL - Melbourne, Victoria, Australia (MEL)
18:15, simongr, QF J DOM, 2 available
SYD - Sydney, New South Wales, Australia (SYD)
13:00, Princess Fiona, T1 QF Flounge, 1
15:00, Tooner, T1 Flounge, 1
Sat, March 23
BNE - Brisbane, Queensland, Australia (BNE)
14:00, Lindsay Wilson, VA Lounge, +2
SYD - Sydney, New South Wales, Australia (SYD)
19:30, The Mill, QF F Lounge, 1
Sun, March 24
SYD - Sydney, New South Wales, Australia (SYD)
19:00, Lindsay Wilson, VA Lounge, +2
Tue, March 26
PER - Perth, Western Australia, Australia (PER)
04:30, The Rok, QF Domestic, 1
Wed, March 27
CBR - Canberra, Australia (CBR)
10:25, Rox, Qp, 1
21:55, Rox, QP, 1
Sat, March 30
SYD - Sydney, New South Wales, Australia (SYD)
10:00, wingspan, QF F Lounge - can guest JQ1 pax, 4

Wed, April 10
BNE - Brisbane, Queensland, Australia (BNE)
09:00, GPH, QF J Lounge, 2
SYD - Sydney, New South Wales, Australia (SYD)
13:00, GPH, QF F lounge, 0
Thu, April 25
CBR - Canberra, Australia (CBR)
05:30, wingspan, QF J Lounge, 2
Mon, April 29
ADL - Adelaide, Australia (ADL)
06:00, wingspan, QF J Lounge, 2
Thu, May 9
SYD - Sydney, New South Wales, Australia (SYD)
06:00, GPH, QF F Lounge, 2
 
Status
Not open for further replies.

Enhance your AFF viewing experience!!

From just $6 we'll remove all advertisements so that you can enjoy a cleaner and uninterupted viewing experience.

And you'll be supporting us so that we can continue to provide this valuable resource :)


Sample AFF with no advertisements? More..
Back
Top