Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Publish a PC Outlook Calendar to .Mac Apps
I wanted to be able to see my Outlook calendar on PC laptop, which one of my clients makes me use, from iCal on my Powerbook -- the machine of choice. This isn't particularly easy -- you know Microsoft and industry standards. Anyway, I came across this neat little app for the PC called Outport (Outlook and Export), which I used to export the calendar. Now the trick is to export the Outlook Calendar in Evolution Calendar format -- not iCalendar (which generates a separate file for every event).

This creates a folder called Local with another folder called Calendar therein. In that folder is a file called Calendar.ics. The next trick is to copy this to the invisible folder on your .Mac account. That folder is in Sites and is called .Calendars. You can then subscribe to the calendar at this address:
   webcal://ical.mac.com/USERNAME/Calendar.ics
It isn't quite perfect -- iSync has a bit of trouble and spits out some errors intermittently -- but I have gotten the data onto my phone and iPod without too much trouble. Now if someone could just automate the process.
    •    
  • Currently 2.50 / 5
  • 1
  • 2
  • 3
  • 4
  • 5
  (2 votes cast)
 
[39,037 views]  

Publish a PC Outlook Calendar to .Mac | 7 comments | Create New Account
Click here to return to the 'Publish a PC Outlook Calendar to .Mac' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Publish a PC Outlook Calendar to .Mac
Authored by: fil_dawg on Nov 22, '04 11:55:34AM
This is great!!! Exactly what I've been looking for as I use a Dell laptop at work and when WFH use my iBook. One question though: When I manually moved the Calendar.ics file into the .calendar folder, I thought I'd be able to see it online as I can with my other calendars: http://ical.mac.com/WebObjects/iCal.woa/wa/default?u=USERID&n=CALENDARNAME.ics However I get the I'm sorry page. Is there another entry I need to manually enter somewhere? Great tip!

[ Reply to This | # ]
Publish a PC Outlook Calendar to .Mac
Authored by: blalor on Nov 22, '04 01:38:48PM

I've tried doing this, but many of my appointment times were off by several hours; I think there are timezone issues with either my computer(s) or outport.



[ Reply to This | # ]
Publish a PC Outlook Calendar to .Mac
Authored by: aMacUzur on Nov 22, '04 03:46:39PM
And there's always Groupcal from Snerdware. Groupcal nicely integrates iCal with your Microsoft Exchange calendar so you can use it from your Mac ... you know, in the way you'd really like to work. #;-)
The usual disclaimer: I do not work for Snerdware ... yadda, yadda, yadda.

[ Reply to This | # ]
Publish a PC Outlook Calendar to .Mac
Authored by: logo on Nov 23, '04 12:42:53PM

you would need webdav access to the exchange server!

too bad we don't have that



[ Reply to This | # ]
Publish a PC Outlook Calendar to .Mac
Authored by: mnb on Nov 22, '04 07:56:37PM

Why bother with the trouble of putting it up on .Mac?

Just open iCal and import the ics file. You can also import it via double clicking, but events tend to get listed twice when you do that (I logged a bug on that with Apple).

If you create a new calendar for that file, when you export a new one with Outport, just delete the old one in iCal and import the new .ics file.



[ Reply to This | # ]
Publish a PC Outlook Calendar to .Mac
Authored by: fil_dawg on Nov 23, '04 03:37:58AM
AUTOMATION!!! This isn't the best automation solution but it seems to be working for me so far. I downloaded 2 applications:
  • 1) AutoIt - http://www.hiddensoft.com/autoit3/index.php
  • 2) ClickYes - http://www.contextmagic.com/express-clickyes/
  • I then wrote the following AutoIt script:
    
    ;
    ; AutoIt Version: 3.0
    ; Language:       English
    ; Platform:       Win9x/NT
    ; Author:         Phil Newman (philnewman@mindspring.com)
    ;
    ; Script Function:
    ;   Runs OutPort.
    ;
    
    ; Run OutPort
    Run("Outport.exe")
    
    ; Wait for Outport to become active - it is titled "Outport"
    WinWaitActive("Outport")
    
    ;MouseClicks are relative to window
    AutoItSetOption("MouseCoordMode", 0)
    
    ;Select Calendar
    MouseClick("right",63,60,1,5)
    
    ;Select Overwrite
    MouseClick("right",203,274,5)
    
    ;Click Export
    MouseClick("right",311,353,5)
    
    ;My Outlook is warning me that another program is trying to access the address book
    ;I tried to code for it, but ended up using ClickYes (http://www.contextmagic.com/express-clickyes)
    
    ;Wait for export to complete
    ;I tried using WinWaitClose and WinWaitNotActive unsuccessfully
    ;So in order to wait for this to complete I'm using a sleep command
    Sleep(60000)
    
    ;Click Close
    WinActivate("Outport","")
    MouseClick("right",485,352,5)
    
    ;Now to copy the file to .Mac
    
    ;Finished!
    
    This is setup to run on my system and does not copy the output file to .MAC (yet!). I was able to compile this AutoIt script to and executatble (*.exe) and use the windows scheduler to run this periodically. Sort of sudo-publishing. Hope this helps :)

    [ Reply to This | # ]
    Publish a PC Outlook Calendar to .Mac
    Authored by: gboudrea on Dec 27, '04 10:02:28AM
    Here's a modified AutoIT script which uses the keyboard shortcuts when possible (instead of mouse clicks) and doesn't require any other software than AutoIT 3.
    
    ;
    ; AutoIt Version: 3.0
    ; Language:       English
    ; Platform:       Win9x/NT
    ; Authors:        Phil Newman, Guillaume Boudreau
    ;
    ; Script Function:
    ;   Runs OutPort.
    ;
    
    ; Run OutPort
    Run("Outport.exe")
    
    ; Wait for Outport to become active - it is titled "Outport"
    WinWaitActive("Outport")
    
    ;MouseClicks are relative to window
    AutoItSetOption("MouseCoordMode", 0)
    
    ;Select Calendar
    Send("{DOWN}{DOWN}{SPACE}")
    
    ;Select Overwrite
    MouseClick("left",204,279)
    
    ;Click Export
    Send("!e")
    
    ;Allow access Outlook warning
    AdlibEnable("allowAccess")
    
    ;Wait for export to complete
    WinWaitClose("Exporting...","Cancel",120)
    
    AdlibDisable()
    ;Close log warning, if any
    AdlibEnable("closeWarning")
    
    ;Click Close
    WinActivate("Outport")
    Send("!{F4}")
    
    AdlibDisable()
    
    ;Now to copy the file to .Mac
    
    ;Finished!
    Exit
    
    Func allowAccess()
        If WinExists("Microsoft Office Outlook","A program is trying to access") Then
    	WinActivate("Microsoft Office Outlook","A program is trying to access")
    	Send("{TAB}{TAB}{SPACE}")
    	Send("{TAB}{DOWN}{DOWN}{DOWN}")
    	Send("{TAB}{ENTER}")
        EndIf
    EndFunc
    
    Func closeWarning()
        If WinExists("Outport","There were messages logged while exporting the selected folder(s).") Then
    	WinActivate("Outport","There were messages logged while exporting the selected folder(s).")
    	Send("!n")
        EndIf
    EndFunc
    


    [ Reply to This | # ]