+ Reply to Thread
Results 1 to 2 of 2

Parse Google calendar for addresses in appointments

  1. #1
    Registered User
    Join Date
    01-10-2011
    Location
    Lake Havasu City, AZ
    MS-Off Ver
    Excel 2010
    Posts
    4

    Parse Google calendar for addresses in appointments

    Greetings from Arizona -

    At the beginning of last year, I became a 1099 employee. As such, since tax time is approaching, I need to be able to claim my mileage with the IRS.

    I found that the Distance Module that Sir DonkeyOte devised is excellent if you are able to simply data-enter the addresses, etc.
    However, all my (hundreds of) customer appointments (including addresses) are stored in Google Calendar.

    I've found several calendar programs (aislebyaisle, wincalendar, etc.), but they can cost $60 and up. I don't, however, need all the information.
    Each appointment contains something like this :

    Mr. Arnold S.
    Wed, January 27, 2010, 9am – 11am
    Where 1526 H Street Sacramento, CA 95814

    If I follow the logic of the previous work, I imagine I would have to get a direct URL from Google calendar. A sample url would be something akin to
    "http://www.google.com/calendar/embed?src=SOMEADDY%40MYADDRESS.COM&ctz=America/Sacramento&pvttk=47789cdf3142a6314cae9b34f39f4348".
    However, this is only the address to the calendar, but not to the data itself.

    Can anyone think of a way (perhaps using the above-mentioned module) to bring in just these parts of the calendar for a week, month or year?

    Feedback would be appreciated.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Parse Google calendar for addresses in appointments

    Can't say I've tested it (I don't use a Google Calendar) but you could try creating exporting calendar to Excel directly: http://gcal2excel.syamantics.com/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1