ActiveState Code

"""
Copyright 2004 Mike Owens
Export data from MS Outlook using COM automation to ZODB database format.

"""

from win32com.client import Dispatch, constants
from ZODB import FileStorage, DB
import os.path

CWD = os.getcwd()
class Exporter(object):
    db = None
    app = None
    root = None
    conn = None
    def __init__ (self, filename = "out.fs"):
        storage = FileStorage.FileStorage(filename)
        self.db = DB(storage)
        self.app = Dispatch("Outlook.Application")
        self.conn = self.db.open()
        self.root = self.conn.root()
        if not self.app <> None:
            raise Exception, "Unable to create an Outlook application object"

        if not self.db <> None:
            raise Exception, "Unable to create a database instance."
            
        if not self.root <> None:
            raise Exception, "Unable to get the root of the database instance."
            
        return

    def ExportContacts (self, Folder):
        if Folder.DefaultItemType <> constants.olContactItem:
            raise Exception, "This is not a contact folder."

        contacts = []
        cnt = len(Folder.Items)
        print "Found %s contacts"%cnt
        for i in range(1, cnt + 1):
            #print i
            item = Folder.Items.Item(i)
            contact = {}
            contact["Account"] = item.Account
            #contact["Anniversary"] = item.Anniversary
            contact["assistantname"] = item.AssistantName
            contact["body"] = item.Body
            contact["business2 telephonenumber"] = item.Business2TelephoneNumber
            contact["business address"] = item.BusinessAddress
            contact["business address city"] = item.BusinessAddressCity
            contact["business address country"] = item.BusinessAddressCountry
            contact["business address postal code"] = item.BusinessAddressPostalCode
            contact["business addresspost office box"] = item.BusinessAddressPostOfficeBox
            contact["business address state"] = item.BusinessAddressState
            contact["business address street"] = item.BusinessAddressStreet
            contact["business fax number"] = item.BusinessFaxNumber
            contact["business homepage"] = item.BusinessHomePage
            contact["bussiness telephone number"] = item.BusinessTelephoneNumber
            contact["callback telephone number"] = item.CallbackTelephoneNumber
            contact["categories"] = item.Categories
            contact["companies"] = item.Companies
            contact["company last first no space"] = item.CompanyLastFirstNoSpace
            contact["company last first space only"] = item.CompanyLastFirstSpaceOnly
            contact["company main telephone number"] = item.CompanyMainTelephoneNumber
            contact["company name"] = item.CompanyName
            contact["computer network name"] = item.ComputerNetworkName
            contact["conversation index"] = item.ConversationIndex
            contact["conversation topic"] = item.ConversationTopic
            contact["customer id"] = item.CustomerID
            contact["department"] = item.Department
            contact["email1 address"] = item.Email1Address
            contact["email1 address type"] = item.Email1AddressType
            contact["email1 display name"] = item.Email1DisplayName
            contact["email1 entry id"] = item.Email1EntryID
            contact["email2 address"] = item.Email2Address
            contact["email2 address type"] = item.Email2AddressType
            contact["email2 display name"] = item.Email2DisplayName
            contact["email2 entry id"] = item.Email2EntryID
            contact["email3 address"] = item.Email3Address
            contact["email3 address type"] = item.Email3AddressType
            contact["email3 display name"] = item.Email3DisplayName
            contact["email3 entry id"] = item.Email3EntryID
            contact["entry id"] = item.EntryID
            contact["file as"] = item.FileAs
            contact["first name"] = item.FirstName
            contact["ftp site"] = item.FTPSite
            contact["full name"] = item.FullName
            contact["full name and company"] = item.FullNameAndCompany
            contact["gender"] = item.Gender
            contact["government id number"] = item.GovernmentIDNumber
            contact["hobby"] = item.Hobby
            contact["home2 telephone number"] = item.Home2TelephoneNumber
            contact["home address"] = item.HomeAddress
            contact["home address city"] = item.HomeAddressCity
            contact["home address country"] = item.HomeAddressCountry
            contact["home address postal code"] = item.HomeAddressPostalCode
            contact["home address postoffice box"] = item.HomeAddressPostOfficeBox
            contact["home address state"] = item.HomeAddressState
            contact["home address street"] = item.HomeAddressStreet
            contact["home fax number"] = item.HomeFaxNumber
            contact["home telephone number"] = item.HomeTelephoneNumber
            contact["initials"] = item.Initials
            contact["internet free busy address"] = item.InternetFreeBusyAddress
            contact["isdn number"] = item.ISDNNumber
            contact["job title"] = item.JobTitle
            contact["language"] = item.Language
            contact["lastfirst and suffix"] = item.LastFirstAndSuffix
            contact["lastfirst no space"] = item.LastFirstNoSpace
            contact["lastfirst space only"] = item.LastFirstSpaceOnly
            contact["lastfirst space only company"] = item.LastFirstSpaceOnlyCompany
            contact["lastname"] = item.LastName
            contact["lastname and first name"] = item.LastNameAndFirstName
            contact["mailing address"] = item.MailingAddress
            contact["mailing address city"] = item.MailingAddressCity
            contact["mailing address country"] = item.MailingAddressCountry
            contact["mailing address postalcode"] = item.MailingAddressPostalCode
            contact["mailing address postoffice box"] = item.MailingAddressPostOfficeBox
            contact["mailing address state"] = item.MailingAddressState
            contact["mailing address street"] = item.MailingAddressStreet
            contact["manager name"] = item.ManagerName
            contact["middle name"] = item.MiddleName
            contact["mileage"] = item.Mileage
            contact["mobile telephone number"] = item.MobileTelephoneNumber
            contact["netmeeting alias"] = item.NetMeetingAlias
            contact["nickname"] = item.NickName
            contact["netmeeting server"] = item.NetMeetingServer
            contact["office location"] = item.OfficeLocation
            contact["organization id number"] = item.OrganizationalIDNumber
            contact["other address"] = item.OtherAddress
            contact["other address city"] = item.OtherAddressCity
            contact["other address county"] = item.OtherAddressCountry
            contact["other address postal code"] = item.OtherAddressPostalCode
            contact["other address postoffice box"] = item.OtherAddressPostOfficeBox
            contact["other address street"] = item.OtherAddressStreet
            contact["other fax number"] = item.OtherFaxNumber
            contact["other telephonenumber"] = item.OtherTelephoneNumber
            contact["pager number"] = item.PagerNumber
            contact["personal homepage"] = item.PersonalHomePage
            contact["primary telephone number"] = item.PrimaryTelephoneNumber
            contact["profession"] = item.Profession
            contact["radio telephone number"] = item.RadioTelephoneNumber
            contact["referred by"] = item.ReferredBy
            contact["spouse"] = item.Spouse
            contact["subject"] = item.Subject
            contact["suffix"] = item.Suffix
            contact["telex number"] = item.TelexNumber
            contact["tty tdd Telephone number"] = item.TTYTDDTelephoneNumber
            contact["Title"] = item.Title
            contact["user1"] = item.User1
            contact["user2"] = item.User2
            contact["user3"] = item.User3
            contact["user4"] = item.User4
            contact["user certificate"] = item.UserCertificate
            contact["webpage"] = item.WebPage
            contact["yomi Company Name"] = item.YomiCompanyName
            contact["yomi first name"] = item.YomiFirstName
            contact["yomi last name"] = item.YomiLastName
            
            contacts.append(contact)
            
        foldername = Folder.Name.lower()
        self.root[foldername] = contacts
        get_transaction().commit()
        return
        
    def ExportMessages (self, Folder):
        if Folder.DefaultItemType <> constants.olMailItem:
            raise Exception, "Folder is not a mail folder."
        maillist = [] 
        cnt = len(Folder.Items)
        print "Fount %s Mail items"%cnt  
        for i in range(1, cnt + 1):
            #print i
            item = Folder.Items.Item(i)
            if not hasattr(item, "To"):
                print "Skipped non-mail message."
                continue
            message = {}
            attlist = []
            cnt = len(item.Attachments)
            if cnt:
                for i in range(1, cnt + 1):
                    try:
                        a = item.Attachments.Item(i)
                        att = {}
                        att["name"] = a.FileName
                        tpath = CWD + "\\tempfile"
                        a.SaveAsFile(tpath)
                        f = open(tpath, "r")
                        att["contents"] = f.read()
                        f.close()
                        attlist.append(att)
                    except:
                        pass
                
            message["attachments"] = attlist
            message["body"] = item.Body
            if hasattr(item, "CC"):
                message["cc"] = item.CC
            message["categories"] = item.Categories
            message["companies"] = item.Companies
            if hasattr(item, "HTMLBody"):
                message["html body"] = item.HTMLBody
            message["sender name"] = item.SenderName
            message["subject"] = item.Subject

            message["to"] = item.To
            maillist.append(message)
            
        foldername = Folder.Name.lower()
        self.root[foldername] = maillist

        get_transaction().commit()
        return
     
    def ExportNotes(self, Folder):
        if Folder.DefaultItemType <> constants.olNoteItem:
            raise Exception, "Folder is not a Notes folder."
        
        notelst = []
        cnt = len(Folder.Items)
        print "Found %s notes"%cnt
        for i in range(1, cnt + 1):
            #print i
            item = Folder.Items.Item(i)
            note = {}
            note["subject"] = item.Subject
            note["categories"] = item.Categories
            note["body"] = item.Body
            notelst.append(note)
            
        foldername = Folder.Name.lower()
        self.root[foldername] = notelst

        get_transaction().commit()
        return
    def __call__ (self, *args, **kwargs):
        ns = self.app.GetNamespace("MAPI")
        contlst = kwargs["contacts"]
        maillst = kwargs["mail"]
        notelst = kwargs["notes"]
        Folders = ns.Folders.Item(1).Folders#Usually the users folders
        if contlst:
            print "Contacts: %s"%len(contlst)
            for foldername in contlst:
                print foldername
                Folder = Folders.Item(foldername)
                if Folder:
                    self.ExportContacts(Folder)
        if maillst:
            print "Mail messages: %s"%len(maillst)
            for foldername in maillst:
                print foldername
                Folder = Folders.Item(foldername)
                if Folder:
                    self.ExportMessages(Folder)

        if notelst:
            print "Notes: %s"%len(notelst)
            for foldername in notelst:
                print foldername
                Folder = Folders.Item(foldername)
                if Folder:
                    self.ExportNotes(Folder)
        return
    def __del__ (self):
        self.root = None
        self.conn.close()
        self.conn = None
        self.db = None
        self.app = None
        return

def main ():
    export = Exporter("out.fs")
    export(contacts=["Contacts"], mail=["Inbox"], notes=["Notes"])
    return

    
if __name__ == "__main__":
    main();