# Export Outlook data to N3 - and synch and import?!! # An attempt to se how one can get into MS Outlook from Python # Ideal - to export to RDF. # To do: # # Check Date format vs ISO/XML date #----------------------------------------------------- # Refs: # http://www.oreilly.com/catalog/pythonwin32/chapter/ch12.html # Derived from # # Dan writes: # This code sort of works, at least to demonstrate python/Outlook # integration. I got through two of the categories of stylized # data that I keep in my Pilot Address book (caller-id info, # and business cards; the others are email, post, etc.) # Then I got bored. # Especially watch out for stuff marked with @@. # # But I'm documenting it carefully, # because I've been looking for these clues for # *months* and I don't want to lose them. # And I'm releasing it. Share and Enjoy. # Dan Connolly # # http://www.w3.org/People/Connolly/ # Copyright © 1998 World Wide Web Consortium, # (Massachusetts Institute of Technology, Institut National de # Recherche en Informatique et en Automatique, Keio University). All # Rights Reserved. # # Permission to use, copy, modify, and distribute this software # and its documentation for any purpose and without fee or # royalty is hereby granted, per the terms and conditions in # # W3C IPR SOFTWARE NOTICE # http://www.w3.org/COPYRIGHT # September 1997 # This module depends on standard and built-in python modules, per # Python Library Reference # April 14, 1998 # Release 1.5.1 # http://www.python.org/doc/lib/lib.html import string, StringIO, sys # It also uses the win32com package # maintained by Mark Hammond # http://www.python.org/windows/win32com/ # # specifically, as documented in # PythonWin Help # Help file built: 04/26/98 # available in http://www.python.org/windows/win32all/win32all.exe # Here we bind to the the actual Outlook 98 runtime, # whose interface is documented in a # Microsoft help file, "Microsoft Outlook Visual Basic" # # I found the help file via the Microsoft Knowledge Base: # # "OL98: How to Install Visual Basic Help" # Last reviewed: April 1, 1998 # Article ID: Q183220 # http://support.microsoft.com/support/kb/articles/q183/2/20.asp from win32com.client import gencache PREFIX = "ms:" DETAILS = [ # "Attachments" # Links to follow for details we want # , "Recipients" ] # Many of the fields whicha re available are heuristic reformattings of real data. # for example: LastFirstSpaceOnly. Some, like "unread", and "saved" are local and don't have # a global significance in that form. Some I just don't understand. # The read-only ones are in general less useful. global boring global verbose verbose=0 boring = [ # Example value: # Fields from Contacts: "LastFirstSpaceOnly", # "Layman Andrew" ; # r "Email2EntryID", # "x\000x\000" ; # r "Email3EntryID", # "0" ; # r "MessageClass", # "IPM.Contact" ; # rw "Class", # "40" ; # r "Saved", # "1" ; # r "Size", # "228" ; # r "LastNameAndFirstName" # "Layman, Andrew" ; # r # "LastModificationTime:, # "2001-04-10T20:33:41Eastern Daylight Time "Journal", # "0" ; # rw "EntryID", # "00000000244B683ABE71D211A4D300A02443E5B8E00A02443E5B800000000042F0000F29E49725C70D211A4CE00A02443E5B80000031906020000 "MAPIOBJECT", # ." print "@prefix util: ." print if option_calendar: print "# Calendar:" oapp.getFolder(outlook.constants.olFolderCalendar, []) if option_contacts: print "# Contacts:" oapp.getFolder(outlook.constants.olFolderContacts, [ # "Attachments" , # Links to follow for details we want "Recipients" ] ) print "# ENDS" # DWC: outlook.Application is the Application class, per # the type library and help file cited above. # # It integrates completely seamlessly into the python # object model. # # Hence, for methods such as GetNamespace, see # the help file. I found the following article quite # helpful as well. The examples are in visual basic, but # the translation to python is straightforward. # # The Microsoft Outlook 97 Automation Server Programming Model # Last Updated: June 26, 1998 # http://www.microsoft.com/OutlookDev/Articles/Outprog.htm # from notation3 import stringToN3 # http://www.w3.org/2000/10/swap/notation3.py # Note was is a copy of the version in notation3.py: def stringToN3_OLD(str): res = "" if len(str) > 20 and string.find(str, "\n") >=0: delim= '"""' forbidden = "\\\"\a\b\f\r\t\v" else: delim = '"' forbidden = "\\\"\a\b\f\r\t\v\n" for i in range(len(str)): ch = str[i] j = string.find(forbidden, ch) if j>=0: ch = "\\" + '\\\"abfrtvn'[j] elif (ch < " " or ch > "}")and ch != "\n": ch= 'x'+`ch`[1:-1] # Use python res = res + ch return delim + res + delim def stripCR(str): res = "" for i in range(len(str)): ch = str[i] if ch != "\r": res = res + ch return res # For MS Outlook, the convention seems to be CRLF. # This adds the CRs to a unix-style multiline string just before the LF. def addCR(str): res = "" for i in range(len(str)): ch = str[i] if ch == "\n": res = res + "\r" res = res + ch return res def _toString(x): """ In N3 everything is represented as a string (at the moment), so we need to turn everything into a string without Python encoding. """ if type(x) is type(' '): return stringToN3(stripCR(x)) if type(x) is type(u' '): return stringToN3(stripCR(x)) # @@ sure? if type(x) is type(6): return '"'+`x`+'"' y = `x` if y[:5]=="\n util:item ." % (folderId, id) # if i" % id except: return None def _getItem(self, item, indent=0, noun=0): global verbose try: gkeys = item._prop_map_get_.keys() pkeys = item._prop_map_put_.keys() # don't in case it sets "changed" bit # pkeys = [] except: print "[ a ms:weirdThing ] #", `self` return print "\n", " "*indent, need_semicolon = 0 key = "EntryID" try: id = item.__getattr__(key) print " " % id except: id = None print " [ " latest = {} for k in range(len(gkeys)): key = gkeys[k] _w = (key in pkeys) # Is this writable? if not _w : pass # print " # Read only:", key try: x = item.__getattr__(key) except: print "# ", key, " cannot be read @@\n ", break if x != "" and key not in boring and key != "EntryID": str = _toString(x) if str[:9] == "