[pywin32-bugs] [ pywin32-Bugs-3555112 ] EnsureDispatch error 2147352567 but not Dispatch

[SourceForge.net <no...@so...>]

Bugs item #3555112, was opened at 2012-08-07 07:19
Message generated for change (Comment added) made by 
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=551954&aid=3555112&group_id=78018

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: com
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: franckgaga ()
Assigned to: Nobody/Anonymous (nobody)
Summary: EnsureDispatch error 2147352567 but not Dispatch

Initial Comment:
I've got a strange problem :

I'e trying to export Outlook Contacts in a List of Dictionnary. My code works perfectly with win32com.client.Dispatch("Outlook.Application). But it returns 0 contacts with win32com.client.gencache.EnsureDispatch("Outlook.Application) that is supposed to be faster and "safer". Here's my code :

class MapiImport():     
	def __init__(self):         
		self.olApp = win32com.client.Dispatch("Outlook.Application")         
		self.namespace = self.olApp.GetNamespace(u"MAPI")         
		# olFolderContacts = 10 :         
		self.mapiContacts = self.namespace.GetDefaultFolder(10).Items      
	def getContacts(self, *fields):         
		contacts = []         
		# Class == 40 is ContactItem         
		# Class == 69 is DistListItem         
		# Exclude ditribution list and others objects != ContactItem         
		for contact in filter(lambda x: x.Class == 40,self.mapiContacts) :             
			if not fields :                 
				ctact = dict((x.Name,x.Value) for x in contact.ItemProperties)             
			else :                 
				ctact = {}                 
				for field in fields :                     
					itemProp = contact.itemProperties[field]                     
					ctact[field] = itemProp.Value             
			contacts.append(ctact)         
		return contacts  
#====TEST SCRIPT==== 
myMAPI = MapiImport() 
fields = (u"LastName",u"FirstName",u"Companies",           
		  u"HomeTelephoneNumber",u"Home2TelephoneNumber",           
		  u"MobileTelephoneNumber",           
		  u"BusinessTelephoneNumber",u"Business2TelephoneNumber",           
		  u"Email1Address",u"Email2Address",u"Email3Address",           
		  u"HomeAddress",u"BusinessAddress",           
		  u"Birthday",u"Anniversary",           
		  u"Body") 
print(myMAPI.getContacts(*fields)) 


So when i replace :

olApp = win32com.client.Dispatch("Outlook.Application") 

With : 

olApp = win32com.client.gencache.EnsureDispatch("Outlook.Application") 

It returns this errors :

Traceback (most recent call last):   
  File "D:\Documents and Settings\da7950\Mes documents\Dropbox\cheetahImporter\mapiImport.py", line 42, in <module>     
    print(myMAPI.getContacts(*fields))   
  File "D:\Documents and Settings\da7950\Mes documents\Dropbox\cheetahImporter\mapiImport.py", line 19, in getContacts     
    for contact in filter(lambda x: x.Class == 40,self.mapiContacts) :   
  File "D:\Documents and Settings\da7950\Mes documents\Python27\lib\site-packages\win32com\gen_py\00062FFF-0000-0000-C000-000000000046x0x9x2\_Items.py", line 122, in __getitem__     
    return self._get_good_object_(self._oleobj_.Invoke(*(81, LCID, 1, 1, item)), "Item") 
com_error: (-2147352567, "Une exception s'est produite.", (4096, u'Microsoft Office Outlook', u'Index de la matrice en dehors des limites.', None, 0, -2147352567), None) 

The message means "Matrix index out of bounds". The strangiest thing is that after I called EnsureDispatch, win32com.client.Dispatch doesn't works anymore. I have to uninstall pywin32 and reinstall it...

I'm running with Python2.7.3 32-bit with Outlook 2003 32-bit

Thanks


----------------------------------------------------------------------

Comment By: franckgaga ()
Date: 2012-08-07 20:04

Message:
Thx for fast answer !

you're both right, outlook is using a 1-base index. If i try this simple
code :

import win32com.client
olApp = win32com.client.gencache.EnsureDispatch("Outlook.Application")
namespace = olApp.GetNamespace(u"MAPI")
# olFolderContacts = 10 :
mapiContacts = namespace.GetDefaultFolder(10).Items
print mapiContacts[0]    # INDEX 0 CRASHES

It crashes with the same error. But if i try with index 1, 2, 3 etc. it
works !

My code works with win32com.client.dynamic.DumbDispatch. What's the cons of
DumbDispatch ?

----------------------------------------------------------------------

Comment By: Mark Hammond (mhammond)
Date: 2012-08-07 16:34

Message:
oops - I wrote that before seeing Roger's reply...

----------------------------------------------------------------------

Comment By: Mark Hammond (mhammond)
Date: 2012-08-07 16:33

Message:
FWIW, EnsureDispatch will generated code into the win32com\client\gen_py
directory (or possibly in %temp%\gen_py) - removing that directory should
avoid needing to reinstall pywin32 to reset the behaviour.

As to the problem itself, can you check if "self.mapiContacts.Items(0)"
throws an exception?  I'm wondering if the code is looping, but isn't
handling the exception to stop the looping correctly (ie, I'm wondering if
the code is failing *after* it successfully enumerates the contacts or
before).

----------------------------------------------------------------------

Comment By: Roger Upole (rupole)
Date: 2012-08-07 12:10

Message:
It appears outlook is using a 1-based index for the contact items.
When using the generated wrapper classes, iteration is performed by
calling for Items starting with 0, and throws the error you're seeing.

The dynamic Dispatch is querying for an iterator using DISPID_NEWENUM,
and the resulting enumerator works regardless of the indexing scheme.
The makepy generated classes should probably use that same process.

As a workaround, you can use win32com.client.dynamic.DumbDispatch to
get the dynamic behaviour for just the mapiContacts object.
You can remove the makepy support by simply clearing the \win32com\gen_py
directory rather than reinstalling.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=551954&aid=3555112&group_id=78018