thanks a lot for pointing that one out HRS. Unfortunately it won’t work for me on BOXI 3.1 FP1.9 and office 2007
Tiger37 (BOB member since 2010-04-07)
thanks a lot for pointing that one out HRS. Unfortunately it won’t work for me on BOXI 3.1 FP1.9 and office 2007
Tiger37 (BOB member since 2010-04-07)
I removed the Add-Ins from Excel, however this did not resolve the issue.
I stepped through the VB Code and it failed in the “getCategories()” sub routine at the “esession.Logoff” line in the code segment -
CleanUp:
Me.Hide
On Error Resume Next
esession.Logoff
Exit Sub
Ruan
hbunicorns (BOB member since 2007-05-31)
I have incomplete user list in “Usage per user”, documents list is incomplete too why:(? I change record limit few times
BOXI 3.1 sp2
office 03
kkl (BOB member since 2009-07-16)
Try running it without dates, that way you will get all the data in your repository, the Documentor processes stats only the basis of what it’s gathered.
nnoori (BOB member since 2009-11-16)
i checked every combination. Nothing helped
kkl (BOB member since 2009-07-16)
Make sure you’re running it for all formats, remove the dates and increase the document limit, we don’t have this problem on R3 so I don’t think it’s the environment. Other than that not much else I can say, hopefully the OP will come back to you.
nnoori (BOB member since 2009-11-16)
checked too. same problem in v6 and v7
kkl (BOB member since 2009-07-16)
Very good tool. Thanks for sharing HRS. However , I am able to work it with Xir3 but not with Xir2. I tried changing the refernces. But still not able ot login. I have both Xir2 and Xir3 clients on my machine. I will try to run this excel sheet on another machine where I have only Xir2.
Indira_M (BOB member since 2006-11-27)
Hi,
I have the same problem, please someone know how could i solve it?
Hello HRS,
I would really love to use your tool, however I am receiving a Run-time error.
Here is the error message
Run-time error ‘-2147417848 (80010108)’:
Automation error
The object invoked has disconnected from its clients.
I am using BO XI 3.1 SP2 and Excel 2003 SP3. I have Designer installed on this PC and I have all the necessary 12.0 References.
Can you help?
Ruan
Best regards
ALDEHIDO (BOB member since 2009-10-05)
Is someone able to run it for XI R2? i have chnaged the ref but still it has errors
Can anyone please post working version of spreadsheet for XI R2, Really appreciate it
thanks
Nirav
nniravv (BOB member since 2007-08-16)
Hi Nniravv, i have a working version for XI R2, how can i send it to you?
Alex.
larrieae (BOB member since 2010-06-24)
Hi Alex
Thanks for response.
My id is nniravv@gmail.com…thanks a lot.
nniravv (BOB member since 2007-08-16)
anyone try with SP3 yet ?
BOXI 3.1 SP3/Excel 2007 … after clicking “Get Document Details” and typing in my CMS, administrator userid, password … :
Getting: Failure in GetCategories()
VBAProject - -2147024769: Automation error
The specified procedure could not be found. 1000440
after clicking OK, i get the same error message in this dialogue box: Failure in btnExtData_Click()
Chris Pohl (BOB member since 2002-06-18)
is it possible for CMS to = cluster name…
how do you setup if you are not running on default port 6400 ??
Thanks
Bryan
bthomps01 (BOB member since 2007-01-09)
I also get the error:
Run-time error ‘-2147417848 (80010108)’:
Automation error
The object invoked has disconnected from its clients.
I am using XIR3.0 Excel 2007.
I would really love to use this tool if someone could help.
kmacdonald (BOB member since 2009-01-08)
@bthomps01 - yes you can use all options you have when logging on to DESKI / Designer
@kmacdonald / Chris Pohl
This utility does work with XI R3.1 sp3 and Excel 2007. I have seen similar messages when running the utility on the Windows Server itself.
Could you please confirm that you have all the client tools installed and running the utility on a client machine.
HRS
Sushir Patel (BOB member since 2006-04-19)
It is strange because my colleague can run it and we seemingly have the same setup. We are both running it on our own machines and not the server itself. I have all of the client tools installed and I compared libraries and add-ins with her machine to see any differences there and there weren’t any.
kmacdonald (BOB member since 2009-01-08)
Hi Alex,
If you have working version for XI R2 could you please send it to me
Thanks
Murthy
mravikan (BOB member since 2008-03-12)
Hi Can you please post the Repository Documennter for BO Xi r2
Thanks
usbhargav (BOB member since 2006-10-26)
I got the same error and I solved it by removing the BQY add-in, exiting excel and double-click on the xls file to restart excel.
stef (BOB member since 2004-01-14)