|
Title: outlook virtual calendar Post by: lebowski on Tuesday, August 29, 2006, 17:27:11 does anyone know how to make a virtual calendar, and set it up with all town's fixtures, so that i can download it onto my microsoft outlook calendar at work? i know it can be done because i got one off the internet for the world cup...
Title: outlook virtual calendar Post by: lebowski on Monday, June 18, 2007, 20:05:10 it's taken almost a year and a lot of soul searching, but i have finally found out how to do this.
copy and paste the table below into notepad, then save it as fixtures.csv (make sure the file type is set to "all files"), then when you open up outlook import the file to the calendar, and your calendar will be populated with the fixtures. Start Time,End Time,Subject,Location,Start Date,End Date,Show time as 15:00,16:45,Northampton Town,Away,11/08/2007,11/08/2007,0 19:45,21:30,Carling Cup Round 1 Charlton Athletic,Home,14/08/2007,14/08/2007,0 15:00,16:45,Luton Town,Home,18/08/2007,18/08/2007,0 15:00,16:45,Cheltenham Town,Away,25/08/2007,25/08/2007,0 15:00,16:45,Crewe,Home,01/09/2007,01/09/2007,4 15:00,16:45,Yeovil Town,Home,08/09/2007,08/09/2007,0 15:00,16:45,Hartlepool United,Away,15/09/2007,15/09/2007,0 15:00,16:45,Bournemouth,Home,22/09/2007,22/09/2007,0 15:00,16:45,Millwall,Away,29/09/2007,29/09/2007,0 19:45,21:30,Swansea City,Away,02/10/2007,02/10/2007,0 15:00,16:45,Gillingham,Home,06/10/2007,06/10/2007,0 15:00,16:45,Oldham Athletic,Away,13/10/2007,13/10/2007,0 15:00,16:45,Tranmere Rovers,Home,20/10/2007,20/10/2007,0 15:00,16:45,Port Vale,Away,27/10/2007,27/10/2007,0 15:00,16:45,Doncaster Rovers,Home,03/11/2007,03/11/2007,0 19:45,21:30,Leyton Orient,Home,06/11/2007,06/11/2007,0 15:00,16:45,Leeds United,Away,17/11/2007,17/11/2007,0 15:00,16:45,Bristol Rovers,Home,24/11/2007,24/11/2007,0 19:45,21:30,Carlisle United,Away,04/12/2007,04/12/2007,0 15:00,16:45,Southend United,Away,08/12/2007,08/12/2007,0 15:00,16:45,Brighton & Hove Albion,Home,15/12/2007,15/12/2007,0 15:00,16:45,Hartlepool United,Home,22/12/2007,22/12/2007,0 15:00,16:45,Yeovil Town,Away,26/12/2007,26/12/2007,0 15:00,16:45,Bournemouth,Away,29/12/2007,29/12/2007,0 15:00,16:45,Swansea City,Home,01/01/2008,01/01/2008,0 15:00,16:45,Huddersfield Town,Home,05/01/2008,05/01/2008,0 15:00,16:45,Walsall,Away,12/01/2008,12/01/2008,0 15:00,16:45,Nottingham Forest,Home,19/01/2008,19/01/2008,0 15:00,16:45,Crewe Alexandra,Away,26/01/2008,26/01/2008,0 19:45,21:30,Luton Town,Away,29/01/2008,29/01/2008,0 15:00,16:45,Northampton Town,Home,02/02/2008,02/02/2008,0 15:00,16:45,Huddersfield Town,Away,09/02/2008,09/02/2008,0 19:45,21:30,Cheltenham Town,Home,12/02/2008,12/02/2008,0 15:00,16:45,Nottingham Forest,Away,16/02/2008,16/02/2008,0 15:00,16:45,Walsall,Home,23/02/2008,23/02/2008,0 15:00,16:45,Leeds United,Home,01/03/2008,01/03/2008,0 15:00,16:45,Bristol Rovers,Away,08/03/2008,08/03/2008,0 19:45,21:30,Leyton Orient,Away,11/03/2008,11/03/2008,0 15:00,16:45,Carlisle United,Home,15/03/2008,15/03/2008,0 15:00,16:45,Brighton & Hove Albion,Away,22/03/2008,22/03/2008,0 19:45,21:30,Southend United,Home,24/03/2008,24/03/2008,0 15:00,16:45,Tranmere Rovers,Away,29/03/2008,29/03/2008,0 15:00,16:45,Oldham Athletic,Home,05/04/2008,05/04/2008,0 15:00,16:45,Doncaster Rovers,Away,12/04/2008,12/04/2008,0 15:00,16:45,Port Vale,Home,19/04/2008,19/04/2008,0 15:00,16:45,Gillingham,Away,26/04/2008,26/04/2008,0 15:00,16:45,Millwall,Home,03/05/2008,03/05/2008,0 Title: outlook virtual calendar Post by: Bushey Boy on Monday, June 18, 2007, 21:44:28 so talk me through this..... how do I do this easily? oh fuck it I will just cut out the adver fixtures and stick it on my laptop :D
Title: outlook virtual calendar Post by: Samdy Gray on Tuesday, June 19, 2007, 07:05:04 Outlook > Calendar > Import > fixtures.csv
Bob's your Uncle. Title: outlook virtual calendar Post by: Give us an S on Tuesday, June 19, 2007, 07:39:47 I just printed them out and put em up at work. Ooooooh i cant wait for the season to start.
Title: outlook virtual calendar Post by: Batch on Tuesday, June 19, 2007, 07:55:51 Ace, cheers lebowski.
The last value controls the "show time as" attribute when imported. I haven't been through them but 4=out of office. Title: outlook virtual calendar Post by: Mister Lorenzo on Tuesday, June 19, 2007, 08:00:00 Quote then save it as fixtures.csv Should the file type be fixtures.vcs? Title: outlook virtual calendar Post by: Samdy Gray on Tuesday, June 19, 2007, 08:53:55 Boooo, my trial version of Outlook 2007 won't let me import files. Damn 'reduced functionality' shit.
Anyone know if you can do this with Lotus Notes? Title: outlook virtual calendar Post by: ghanimah on Tuesday, June 19, 2007, 12:17:17 Quote from: "Mister Lorenzo" Quote then save it as fixtures.csv Should the file type be fixtures.vcs? You can import *.csv files as long as the converter in the import wizard is up to date Title: outlook virtual calendar Post by: flammableBen on Tuesday, June 19, 2007, 13:55:23 Sure it should be csv. Comma separated values or something.
Title: outlook virtual calendar Post by: Bob's Orange on Tuesday, June 19, 2007, 15:06:13 Quote from: "sam_stfc" Outlook > Calendar > Import > fixtures.csv Bob's your Uncle. No he isn't!! :mrgreen: Title: outlook virtual calendar Post by: Samdy Gray on Tuesday, June 19, 2007, 16:57:03 Quote from: "Bob's Orange" Quote from: "sam_stfc" Outlook > Calendar > Import > fixtures.csv Bob's your Uncle. No he isn't!! :mrgreen: I know, Bob's actually my Dad. Title: outlook virtual calendar Post by: Simon Pieman on Tuesday, June 19, 2007, 17:05:24 Quote from: "sam_stfc" Quote from: "Bob's Orange" Quote from: "sam_stfc" Outlook > Calendar > Import > fixtures.csv Bob's your Uncle. No he isn't!! :mrgreen: I know, Bob's actually my Dad. Is Sandy your mum? Title: outlook virtual calendar Post by: Bob's Orange on Tuesday, June 19, 2007, 21:51:46 Quote from: "sam_stfc" Quote from: "Bob's Orange" Quote from: "sam_stfc" Outlook > Calendar > Import > fixtures.csv Bob's your Uncle. No he isn't!! :mrgreen: I know, Bob's actually my Dad. Not possible!! :mrgreen: Title: outlook virtual calendar Post by: Simon Pieman on Saturday, August 11, 2007, 09:48:37 As I was feeling super geeky I managed to sync my phone to Outlook so I now have all the fixtures in my phone calendar.
Title: outlook virtual calendar Post by: land_of_bo on Saturday, August 11, 2007, 10:10:03 me too :oops:
Title: outlook virtual calendar Post by: Samdy Gray on Monday, June 16, 2008, 12:16:54 Because I'm sad enough and bored at work...
Start time,End time,Subject,Location,Start Date,End Date,Show time as 15:00,16:45,Tranmere,Home,09/08/2008,09/08/2008,0 19:45,21:30,Carling Cup - QPR,Home,12/08/2008,12/08/2008,0 15:00,16:45,Cheltenham,Away,16/08/2008,16/08/2008,0 15:00,16:45,Colchester,Home,23/08/2008,23/08/2008,0 15:00,16:45,Milton Keynes,Away,30/08/2008,30/08/2008,0 15:00,16:45,Hereford,Away,06/09/2008,06/09/2008,0 15:00,16:45,Leeds,Home,13/09/2008,13/09/2008,0 15:00,16:45,Stockport,Away,20/09/2008,20/09/2008,0 15:00,16:45,Milwall,Home,27/09/2008,27/09/2008,0 15:00,16:45,Hartlepool,Away,04/10/2008,04/10/2008,0 15:00,16:45,Huddersfield,Home,11/10/2008,11/10/2008,0 15:00,16:45,Southend,Away,18/10/2008,18/10/2008,0 19:45,21:30,Northampton,Home,21/10/2008,21/10/2008,0 15:00,16:45,Oldham,Home,25/10/2008,25/10/2008,0 19:45,21:30,Walsall,Away,28/10/2008,28/10/2008,0 15:00,16:45,Scunthorpe,Away,01/11/2008,01/11/2008,0 15:00,16:45,Leicester,Home,15/11/2008,15/11/2008,0 15:00,16:45,Bristol Rovers,Away,22/11/2008,22/11/2008,0 19:45,21:30,Peterborough,Home,25/11/2008,25/11/2008,0 19:45,21:30,Buy fB a Pint,Home,26/11/2008,26/11/2008,0 15:00,16:45,Carlisle,Home,06/12/2008,06/12/2008,0 15:00,16:45,Crewe,Away,13/12/2008,13/12/2008,0 15:00,16:45,Yeovil,Home,20/12/2008,20/12/2008,0 15:00,16:45,Leyton Orient,Away,26/12/2008,26/12/2008,0 15:00,16:45,Brighton,Home,28/12/2008,28/12/2008,0 15:00,16:45,Milwall,Away,03/01/2009,03/01/2009,0 15:00,16:45,Stockport,Home,10/01/2009,10/01/2009,0 15:00,16:45,Huddersfield,Away,17/01/2009,17/01/2009,0 15:00,16:45,Hartlepool,Home,24/01/2009,24/01/2009,0 19:45,21:30,Walsall,Home,27/01/2009,27/01/2009,0 15:00,16:45,Oldham,Away,31/01/2009,31/01/2009,0 19:45,21:30,Northampton,Away,03/02/2009,03/02/2009,0 15:00,16:45,Southend,Home,07/02/2009,07/02/2009,0 15:00,16:45,Leicester,Away,14/02/2009,14/02/2009,0 15:00,16:45,Scunthorpe,Home,21/02/2009,21/02/2009,0 15:00,16:45,Tranmere,Away,28/02/2009,28/02/2009,0 19:45,21:30,Cheltenham,Home,03/03/2009,03/03/2009,0 15:00,16:45,Milton Keynes,Home,07/03/2009,07/03/2009,0 19:45,21:30,Colchester,Away,10/03/2009,10/03/2009,0 15:00,16:45,Leeds,Away,14/03/2009,14/03/2009,0 15:00,16:45,Hereford,Home,21/03/2009,21/03/2009,0 15:00,16:45,Yeovil,Away,28/03/2009,28/03/2009,0 15:00,16:45,Crewe,Home,04/04/2009,04/04/2009,0 15:00,16:45,Brighton,Away,11/04/2009,11/04/2009,0 19:45,21:30,Leyton Orient,Home,13/04/2009,13/04/2009,0 15:00,16:45,Carlisle,Away,18/04/2009,18/04/2009,0 15:00,16:45,Bristol Rovers,Home,25/04/2009,25/04/2009,0 15:00,16:45,Peterborough,Away,02/05/2009,02/05/2009,0 Title: outlook virtual calendar Post by: Batch on Monday, June 16, 2008, 12:18:52 Cheers Sam.
Title: outlook virtual calendar Post by: Northern Red on Monday, June 16, 2008, 12:48:07 Grrr I've just spent a while doing the same myself... :|
Why coudln't you have posted that 20 minutes earlier :wink: Title: outlook virtual calendar Post by: flammableBen on Monday, June 16, 2008, 12:52:50 Shall I move this into matchday so more people are likely to read it?
I think I might. Good work sam. Title: outlook virtual calendar Post by: Fred Elliot on Monday, June 16, 2008, 13:23:26 Quote from: "lebowski" it's taken almost a year and a lot of soul searching, but i have finally found out how to do this. copy and paste the table below into notepad, then save it as fixtures.csv (make sure the file type is set to "all files"), then when you open up outlook import the file to the calendar, and your calendar will be populated with the fixtures. Start Time,End Time,Subject,Location,Start Date,End Date,Show time as 15:00,16:45,Northampton Town,Away,11/08/2007,11/08/2007,0 19:45,21:30,Carling Cup Round 1 Charlton Athletic,Home,14/08/2007,14/08/2007,0 15:00,16:45,Luton Town,Home,18/08/2007,18/08/2007,0 15:00,16:45,Cheltenham Town,Away,25/08/2007,25/08/2007,0 15:00,16:45,Crewe,Home,01/09/2007,01/09/2007,4 15:00,16:45,Yeovil Town,Home,08/09/2007,08/09/2007,0 15:00,16:45,Hartlepool United,Away,15/09/2007,15/09/2007,0 15:00,16:45,Bournemouth,Home,22/09/2007,22/09/2007,0 15:00,16:45,Millwall,Away,29/09/2007,29/09/2007,0 19:45,21:30,Swansea City,Away,02/10/2007,02/10/2007,0 15:00,16:45,Gillingham,Home,06/10/2007,06/10/2007,0 15:00,16:45,Oldham Athletic,Away,13/10/2007,13/10/2007,0 15:00,16:45,Tranmere Rovers,Home,20/10/2007,20/10/2007,0 15:00,16:45,Port Vale,Away,27/10/2007,27/10/2007,0 15:00,16:45,Doncaster Rovers,Home,03/11/2007,03/11/2007,0 19:45,21:30,Leyton Orient,Home,06/11/2007,06/11/2007,0 15:00,16:45,Leeds United,Away,17/11/2007,17/11/2007,0 15:00,16:45,Bristol Rovers,Home,24/11/2007,24/11/2007,0 19:45,21:30,Carlisle United,Away,04/12/2007,04/12/2007,0 15:00,16:45,Southend United,Away,08/12/2007,08/12/2007,0 15:00,16:45,Brighton & Hove Albion,Home,15/12/2007,15/12/2007,0 15:00,16:45,Hartlepool United,Home,22/12/2007,22/12/2007,0 15:00,16:45,Yeovil Town,Away,26/12/2007,26/12/2007,0 15:00,16:45,Bournemouth,Away,29/12/2007,29/12/2007,0 15:00,16:45,Swansea City,Home,01/01/2008,01/01/2008,0 15:00,16:45,Huddersfield Town,Home,05/01/2008,05/01/2008,0 15:00,16:45,Walsall,Away,12/01/2008,12/01/2008,0 15:00,16:45,Nottingham Forest,Home,19/01/2008,19/01/2008,0 15:00,16:45,Crewe Alexandra,Away,26/01/2008,26/01/2008,0 19:45,21:30,Luton Town,Away,29/01/2008,29/01/2008,0 15:00,16:45,Northampton Town,Home,02/02/2008,02/02/2008,0 15:00,16:45,Huddersfield Town,Away,09/02/2008,09/02/2008,0 19:45,21:30,Cheltenham Town,Home,12/02/2008,12/02/2008,0 15:00,16:45,Nottingham Forest,Away,16/02/2008,16/02/2008,0 15:00,16:45,Walsall,Home,23/02/2008,23/02/2008,0 15:00,16:45,Leeds United,Home,01/03/2008,01/03/2008,0 15:00,16:45,Bristol Rovers,Away,08/03/2008,08/03/2008,0 19:45,21:30,Leyton Orient,Away,11/03/2008,11/03/2008,0 15:00,16:45,Carlisle United,Home,15/03/2008,15/03/2008,0 15:00,16:45,Brighton & Hove Albion,Away,22/03/2008,22/03/2008,0 19:45,21:30,Southend United,Home,24/03/2008,24/03/2008,0 15:00,16:45,Tranmere Rovers,Away,29/03/2008,29/03/2008,0 15:00,16:45,Oldham Athletic,Home,05/04/2008,05/04/2008,0 15:00,16:45,Doncaster Rovers,Away,12/04/2008,12/04/2008,0 15:00,16:45,Port Vale,Home,19/04/2008,19/04/2008,0 15:00,16:45,Gillingham,Away,26/04/2008,26/04/2008,0 15:00,16:45,Millwall,Home,03/05/2008,03/05/2008,0 Can one of you geeks do this for this seasons fixtures pretty please Title: outlook virtual calendar Post by: flammableBen on Monday, June 16, 2008, 13:33:25 Sam already has you silly cunt.
Title: outlook virtual calendar Post by: Fred Elliot on Monday, June 16, 2008, 13:37:38 allright you fucking dosser
Title: outlook virtual calendar Post by: flammableBen on Monday, June 16, 2008, 13:47:44 fuck off oap
Title: outlook virtual calendar Post by: Fred Elliot on Monday, June 16, 2008, 13:49:26 get a job you lazy cunt
Title: outlook virtual calendar Post by: flammableBen on Monday, June 16, 2008, 13:57:01 Oh the originality.
Title: outlook virtual calendar Post by: Fred Elliot on Monday, June 16, 2008, 13:58:05 I'm going to go home now and drink your Birthday present
:beers: Title: outlook virtual calendar Post by: flammableBen on Monday, June 16, 2008, 14:02:55 Nooooooo....
I take it all back. Title: outlook virtual calendar Post by: Fred Elliot on Monday, June 16, 2008, 14:10:29 deal
:mrgreen: Title: outlook virtual calendar Post by: jayohaitchenn on Monday, June 16, 2008, 14:22:55 Well done all.
Title: outlook virtual calendar Post by: Berniman on Monday, June 16, 2008, 16:08:58 :Ride On Fatbury's Lovestick:
Fred and Ben, you crack me up! Make I Laugh! :Ride On Fatbury's Lovestick: Title: outlook virtual calendar Post by: Fred Elliot on Monday, June 16, 2008, 16:45:42 We love eachother really
he is like Jenna's unofficial god father :? Title: outlook virtual calendar Post by: flammableBen on Monday, June 16, 2008, 16:53:21 I definitely set a good moral example.
Title: outlook virtual calendar Post by: lebowski on Monday, June 16, 2008, 17:38:50 Could someone be a love and put the friendlies on the beginning?
Title: outlook virtual calendar Post by: axs on Monday, June 16, 2008, 20:12:07 I've put them all on my phone because I was quite quite bored.
Title: outlook virtual calendar Post by: sonic youth on Monday, June 16, 2008, 21:16:16 i was planning to do this at work. good stuff.
Title: outlook virtual calendar Post by: sonic youth on Monday, June 16, 2008, 21:23:43 including friendlies:
Start time,End time,Subject,Location,Start Date,End Date,Show time as 19:45,21:30,Portsmouth (Friendly),Home,18/07/2008,18/07/2008,0 19:45,21:30,Hampton & Richmond (Friendly),Away,22/07/2008,22/07/2008,0 19:30,21:15,Salisbury (Friendly),Away,23/07/2008,23/07/2008,0 15:00,16:45,Chippenham (Friendly),Away,26/07/2008,26/07/2008,0 19:45,21:30,Cardiff (Friendly),Home,29/07/2008,29/07/2008,0 19:45,21:30,Supermarine (Friendly),Away,30/07/2008,30/07/2008,0 19:30,21:15,Hungerford (Friendly),Away,01/08/2008,01/08/2008,0 19:45,21:30,Plymouth (Friendly),Home,04/08/2008,04/08/2008,0 15:00,16:45,Tranmere,Home,09/08/2008,09/08/2008,0 19:45,21:30,Carling Cup - QPR,Home,12/08/2008,12/08/2008,0 15:00,16:45,Cheltenham,Away,16/08/2008,16/08/2008,0 15:00,16:45,Colchester,Home,23/08/2008,23/08/2008,0 15:00,16:45,Milton Keynes,Away,30/08/2008,30/08/2008,0 15:00,16:45,Hereford,Away,06/09/2008,06/09/2008,0 15:00,16:45,Leeds,Home,13/09/2008,13/09/2008,0 15:00,16:45,Stockport,Away,20/09/2008,20/09/2008,0 15:00,16:45,Milwall,Home,27/09/2008,27/09/2008,0 15:00,16:45,Hartlepool,Away,04/10/2008,04/10/2008,0 15:00,16:45,Huddersfield,Home,11/10/2008,11/10/2008,0 15:00,16:45,Southend,Away,18/10/2008,18/10/2008,0 19:45,21:30,Northampton,Home,21/10/2008,21/10/2008,0 15:00,16:45,Oldham,Home,25/10/2008,25/10/2008,0 19:45,21:30,Walsall,Away,28/10/2008,28/10/2008,0 15:00,16:45,Scunthorpe,Away,01/11/2008,01/11/2008,0 15:00,16:45,Leicester,Home,15/11/2008,15/11/2008,0 15:00,16:45,Bristol Rovers,Away,22/11/2008,22/11/2008,0 19:45,21:30,Peterborough,Home,25/11/2008,25/11/2008,0 19:45,21:30,Buy fB a pint,Home,26/11/2008,26/11/2008,0 15:00,16:45,Carlisle,Home,06/12/2008,06/12/2008,0 15:00,16:45,Crewe,Away,13/12/2008,13/12/2008,0 15:00,16:45,Yeovil,Home,20/12/2008,20/12/2008,0 15:00,16:45,Leyton Orient,Away,26/12/2008,26/12/2008,0 15:00,16:45,Brighton,Home,28/12/2008,28/12/2008,0 15:00,16:45,Milwall,Away,03/01/2009,03/01/2009,0 15:00,16:45,Stockport,Home,10/01/2009,10/01/2009,0 15:00,16:45,Huddersfield,Away,17/01/2009,17/01/2009,0 15:00,16:45,Hartlepool,Home,24/01/2009,24/01/2009,0 19:45,21:30,Walsall,Home,27/01/2009,27/01/2009,0 15:00,16:45,Oldham,Away,31/01/2009,31/01/2009,0 19:45,21:30,Northampton,Away,03/02/2009,03/02/2009,0 15:00,16:45,Southend,Home,07/02/2009,07/02/2009,0 15:00,16:45,Leicester,Away,14/02/2009,14/02/2009,0 15:00,16:45,Scunthorpe,Home,21/02/2009,21/02/2009,0 15:00,16:45,Tranmere,Away,28/02/2009,28/02/2009,0 19:45,21:30,Cheltenham,Home,03/03/2009,03/03/2009,0 15:00,16:45,Milton Keynes,Home,07/03/2009,07/03/2009,0 19:45,21:30,Colchester,Away,10/03/2009,10/03/2009,0 15:00,16:45,Leeds,Away,14/03/2009,14/03/2009,0 15:00,16:45,Hereford,Home,21/03/2009,21/03/2009,0 15:00,16:45,Yeovil,Away,28/03/2009,28/03/2009,0 15:00,16:45,Crewe,Home,04/04/2009,04/04/2009,0 15:00,16:45,Brighton,Away,11/04/2009,11/04/2009,0 19:45,21:30,Leyton Orient,Home,13/04/2009,13/04/2009,0 15:00,16:45,Carlisle,Away,18/04/2009,18/04/2009,0 15:00,16:45,Bristol Rovers,Home,25/04/2009,25/04/2009,0 15:00,16:45,Peterborough,Away,02/05/2009,02/05/2009,0 p.s. ben you rock Title: outlook virtual calendar Post by: flammableBen on Monday, June 16, 2008, 21:54:29 Too fucking right I do :D
Title: Re: outlook virtual calendar Post by: Samdy Gray on Sunday, September 7, 2008, 14:50:57 19:45,21:30,Buy fB a pint,Home,26/11/2008,26/11/2008,0 Just checking through the fixtures today and noticed this entry in my calendar. Nice try, Ben. |