BOXI UserList & Group Extraction

system · October 21, 2009, 2:12pm

I am not seeing a response that resolves the issue described. I too have both instances installed and manually gone through the refrences to ensure only 11.5 versions are referenced, yet the errors are still suggesting version 12. Has anyone been able to resolve this?

alpha1145:

We are in the middle of an upgrade to XI 3.1 and so on my laptop I have both the XIr2 and XI 3.1 client tools installed. When I go to run the User List macro it throws the following error:
CrystalEnterprise12.SessionMgr.1- -2147024891: Access Denied.  You cannot log on to an older version of the CMS. 1000440
The first thing I checked was the .dll references and found them all still pointing to the 11.5 libraries. I went so far as to manually browse for the .dll files in the 11.5 directory path (per Bernard’s previous post).

The only thing I can think of is that when I installed the XI 3.1 client tools that a registry entry is forcing the macro to look at the version 12 dll’s. ANy ideas?

annablj (BOB member since 2005-04-04)

system · October 23, 2009, 11:47am

Hi Julien,

I used version3 excel file for extract users in my environment. Excel file is very usful… i got data in dev and stage environments. when i tried in production i am getting below error.
“crystalenterprise115.infostore.1 --2147213794: CMS operation timed out after 9 minutes.1000440”

Any suggestions…
Thanks in advance for ur help.

Thanks,
Venkat

venkata_somisetty (BOB member since 2009-08-12)

system · October 23, 2009, 12:34pm

HI

me also facing same timeout error issue. did u get resolve? please let me know the soulution.

thanks,
Venkat

venkata_somisetty (BOB member since 2009-08-12)

system · November 23, 2009, 6:00am

I have tried running the macro and I get the error as follow :

Run Time Error 9 :Subscript out of range and the debugger stops at this line :

Sheets(“Users”).Range(“A3:L65000”).ClearContents

Am using Excel 2003.

Anuputcha (BOB member since 2009-01-07)

system · November 24, 2009, 11:26am

Hi Julien,

Thanks for the Excel sheet. I am using XI R3. When I run the macro on R3 environment, I encounter a error on the Macro.
I checked with my friend who has XI R2. He was able to retrieve the list.

Please help me on resolving the error in the macro & retrieving the user list from R3.

Thanks

Ash

nvlashok (BOB member since 2005-10-20)

system · December 1, 2009, 4:54am

Is there any macro for extracting user list using Windows AD ?

Thanks
Asmitha

Asmitha (BOB member since 2008-06-06)

system · December 2, 2009, 11:49am

Not working for me tooo
When i enter CMS detail and click on “Extract data from CMS”, gives error,

“VBAProject - 458: Variable uses an Automation type not supported in Visual Basics 1000458.”

I am using BO XI 3.1 and MS Excel 2007.

Thanks in advance …

Vills (BOB member since 2007-10-24)

system · December 9, 2009, 8:55pm

Julian,

I have fixed the macro to work in 3.x. Should I send the macro back to you to upload the new version here ?

kapilmalik (BOB member since 2006-03-23)

system · January 12, 2010, 11:23am

Hi julienbras,

Thanks for your Excel sheet…I have one issue.

2months back i downloaded your Excel sheet it worked fine but last week I installed Live Office and today I am trying to run the excel sheet and it is throwing one error as:

“VBAProject-5 Invalid Procedure Call or Aruguemnt 1000005”

Please, help me …

Thanks [/b]

Nalin (BOB member since 2008-07-18)

system · January 20, 2010, 7:01am

How make these script works under LDAP login?

lunar3000 (BOB member since 2008-04-15)

system · February 3, 2010, 3:42pm

This utility is working great. I can able to pull all the users (~10K) from repository, however when I apply filter on group in the excelspread sheet it is not giving me all the users in that group. Am I doing something wrong?

-Nivas

Nivas74 (BOB member since 2009-12-07)

system · February 5, 2010, 1:23pm

Hi all,

with the download from this post I am able to extract and modify user list… is there any way to insert new users… we have a enterprise authenticated env and now there’s a req to add all users from a DL…

Thanks
Rekha

rcr (BOB member since 2009-04-13)

system · March 9, 2010, 11:02am

Hi OllyB,
Could you please send across the BO DeskI report which you created using the VBA code. It would be a BIG help for me.
Waiting for your reply.

Thanks
Prabhat Jha

itisprabhat (BOB member since 2007-07-04)

system · March 16, 2010, 5:05pm

Have you received an answer to your question?

tim schulte (BOB member since 2003-12-11)

SebastienGoiffon · March 17, 2010, 7:42am

Did you try simply using the import wizard …

system · March 26, 2010, 7:43pm

This is a great utility, however is it possible to extract the users and groups by using a batch (non-interactively) ?

thx in advance
vivek

vivekgandhi (BOB member since 2010-03-02)

system · March 26, 2010, 7:55pm

You can use csvde to extract AD user list.

regards
Vivek

vivekgandhi (BOB member since 2010-03-02)

system · April 8, 2010, 1:42pm

Hello,

I keep getting this error.

VBA Project - 458:Variable uses an automation type not supported in Visual Basic 1000458

I noticed more people had it but cannot find a solution.

Does anyone know why I get this error? I’m using Office 2007

thanks a lot

N

Tiger37 (BOB member since 2010-04-07)

gom · May 7, 2010, 9:11am

Hi all,

First of all THANK YOU VERY MUCH! Great Job!

julienbras:

Hi all,

I’ve posted anything since a long time, and it seems that my tool is still eavily used by lot of BOB fans … Some answers :

XI3 version
I have read that a lot of people can’t use the XLS tool on a XI3.x installation. It’s true, because th XLS file search for version 11.5(XIR2) librairies ; but there is only version 12(XI3.x) librairies. To change that, you just need to go to Visual BAsic (Alt + F11) ; go to Tools/References (or something like that, i’ve got a french version here )and change the 11.5 librairies reference to 12 librairies reference. There is about 5 BOXI librairies used :
[list]Crystal Enterprise Framework Library
Crystal Enterprise InfoStore Library
Crystal Enterprise Plugin Manager Library
Crystal Enterprise User PlugIn
Crystal Enterprise UserGroup PlugIn[/list]

BO Librairies
An other very important point is that the BO libs must be installed on the client where you launch the macro. Typically, you just need to install the client version of BO (with Designer, Desktop Intelligence) and theise lib are automatically installed.

SQL Used
There is no way to the equivalent using simple SQL and query a special database. There is no database containing theise infos ! Today, the only way to do that is query via the SDK, using a commercial tools (there are many like the Sebastien one, which is not dedicated for that) or using the CMC…

Audit DB
Last point, i am not using the auditing database ; just the repo.

I think all these information should be in the first post, no?

It would be very appreciated if this link could be too in the first post. Is there a moderator in da place?

No news? :?

Gôm

system · June 17, 2010, 5:41pm

I really like this file, it is very useful, and works great.

The only problem I had is that it uses Enterprise login instead of Windows AD (which my company uses).

So I modified it to use Windows AD, I wanted to see if anyone else is interested in that, if so I can post it up here.

Bolandb (BOB member since 2010-06-08)