Compiled Lounge Details - Test

Status
Not open for further replies.
SeatBackForward

SeatBackForward

Senior Member
Joined
Jun 20, 2006
Posts
5,218
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:
simongr said:
Does it not post automatically to the blog?
Click to expand...

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...
 
SeatBackForward said:
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)
Click to expand...

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 ;)
 
Lindsay Wilson said:
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 ;)
Click to expand...

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
 
Check out the latest credit card signup bonus point offers
Read our AFF credit card guides and start earning more points now.

AFF Supporters can remove this and all advertisements

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.
 

[TD="width: 1530, bgcolor: #FFFFFF"] Sun, March 17 [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] MEL - Melbourne, Victoria, Australia (MEL) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 19:00, Bofter, Virgin, 1 available [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] SYD - Sydney, New South Wales, Australia (SYD) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 07:15, simongr, QF J DOM, 2 available [/TD]

[TD="width: 1530, bgcolor: #FFFFFF"] Mon, March 18 [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] MEL - Melbourne, Victoria, Australia (MEL) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 18:15, simongr, QF J DOM, 2 available [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] SYD - Sydney, New South Wales, Australia (SYD) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 13:00, Princess Fiona, T1 QF Flounge, 1 [/TD]

[TD="width: 1530, bgcolor: #FFFFFF"] Sat, March 23 [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] BNE - Brisbane, Queensland, Australia (BNE) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 14:00, Lindsay Wilson, VA Lounge, +2 [/TD]

[TD="width: 1530, bgcolor: #FFFFFF"] Sun, March 24 [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] SYD - Sydney, New South Wales, Australia (SYD) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 19:00, Lindsay Wilson, VA Lounge, +2 [/TD]

[TD="width: 1530, bgcolor: #FFFFFF"] Wed, March 27 [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] CBR - Canberra, Australia (CBR) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 10:25, Rox, Qp, 1 [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 21:55, Rox, QP, 1 [/TD]

[TD="width: 1530, bgcolor: #FFFFFF"] Wed, April 10 [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] BNE - Brisbane, Queensland, Australia (BNE) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 09:00, GPH, QF J Lounge, 2 [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] SYD - Sydney, New South Wales, Australia (SYD) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 13:00, GPH, QF F lounge, 0 [/TD]

[TD="width: 1530, bgcolor: #FFFFFF"] Thu, May 9 [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] SYD - Sydney, New South Wales, Australia (SYD) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 06:00, GPH, QF F Lounge, 2 [/TD]
 
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

[TD="width: 1507, bgcolor: #FFFFFF"] BNE - Brisbane, Queensland, Australia (BNE) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 09:00, GPH, QF J Lounge, 2 [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] SYD - Sydney, New South Wales, Australia (SYD) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 13:00, GPH, QF F lounge, 0 [/TD]

[TD="width: 1530, bgcolor: #FFFFFF"] Thu, April 25 [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] CBR - Canberra, Australia (CBR) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 05:30, wingspan, QF J Lounge, 2 [/TD]

[TD="width: 1530, bgcolor: #FFFFFF"] Mon, April 29 [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] ADL - Adelaide, Australia (ADL) [/TD]

[TD="width: 1506, bgcolor: #FFFFFF"] 06:00, wingspan, QF J Lounge, 2 [/TD]

[TD="width: 1530, bgcolor: #FFFFFF"] Thu, May 9 [/TD]

[TD="width: 1507, bgcolor: #FFFFFF"] SYD - Sydney, New South Wales, Australia (SYD) [/TD]
06:00, GPH, QF F Lounge, 2
 
Status
Not open for further replies.

Become an AFF member!

Join Australian Frequent Flyer (AFF) for free and unlock insider tips, exclusive deals, and global meetups with 65,000+ frequent flyers.

AFF members can also access our Frequent Flyer Training courses, and upgrade to Fast-track your way to expert traveller status and unlock even more exclusive discounts!

AFF forum abbreviations

Wondering about Y, J or any of the other abbreviations used on our forum?

Check out our guide to common AFF acronyms & abbreviations.

Recent Posts

Currently Active Users

Total: 185 (members: 13, guests: 172)
Back
Top