Jason Silver

Friday, May 7th, 2004

Outlook Calendar Script

This is long overdue.

I Finally had a brainwave last night about how to sync our Outlook church calendar with the getChurch.org web site. It's easy! Simply export the data in tab format, and save it to the anonymous folder on our server.

My script does the next. Once a day, when it's first called that day, it FTP's the church network, grabs the file and saves it to the getChurch.org server. Then it calculates todays date, and parses the tab text file, searching for the date. It displays a search box and all records containing todays date in seconds.

Easy to implement, easy to use, and easy to search. I love it. Now I'm going to think about how I can write a macro for our Secretary that automatically exports the church calendar every evening. With that done, it's a no maintenance solution.

Check it out!

~Jason