outlook virtual calendar

[lebowski]

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...

[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

[Bushey Boy]

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  

[Samdy Gray]

Outlook > Calendar > Import > fixtures.csv

Bob's your Uncle.

[Give us an S]

I just printed them out and put em up at work. Ooooooh i cant wait for the season to start.

[Batch]

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.

[Mister Lorenzo]

then save it as fixtures.csv

Should the file type be fixtures.vcs?

[Samdy Gray]

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?

[ghanimah]

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

[flammableBen]

Sure it should be csv. Comma separated values or something.

[Bob's Orange]

Outlook > Calendar > Import > fixtures.csv

Bob's your Uncle.

No he isn't!!

[Samdy Gray]

Outlook > Calendar > Import > fixtures.csv

Bob's your Uncle.

No he isn't!!

I know, Bob's actually my Dad.

[Simon Pieman]

Outlook > Calendar > Import > fixtures.csv

Bob's your Uncle.

No he isn't!!

I know, Bob's actually my Dad.

Is Sandy your mum?

[Bob's Orange]

Outlook > Calendar > Import > fixtures.csv

Bob's your Uncle.

No he isn't!!

I know, Bob's actually my Dad.

Not possible!!

[Simon Pieman]

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.