BOXI UserList & Group Extraction

This looks like a wonderful to but I still can’t get it off the 12.0 drivers even after I have gone in and told it where the dll where.

Something I might be missing or should this be run where 3.x tools are not installed.


tenather :us: (BOB member since 2002-08-29)

how it work ?
I don’t know its meaning?
can you give me a detail explain? :arrow_forward: :?


lingoes (BOB member since 2008-07-10)

Hi,

This is exactly what we need in our project. We are on XI 3.0. I have downloaded the 3.0 version and put it on the server. However when I enter the CMS, username, password detail and press the button to Extract data from the CMS, I get the following error

Compile Error
Cant find project or library.

I am wondering if this is due to the fact that our BO set up is on D:/ drive and maybe the document has the libraries pointing to C:/ ? If so how do I change the location? Or could there be any other reasons?


BO_TN (BOB member since 2008-07-30)

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 :wink: )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.

Coming soon…
I have realised a V4 version with some bug correction on XIR2, i will publish it sooner, but it’s available here : http://sidoine.org/node/58

I am actually working on a XI3 version, with substancially more things (list of folders, universes, reports, and the security attached to theise items)…

Bernard Timbal, where are you working ? As you are french, maybe i already know you :wink:

Regards,

Awesome! Will keep checking this section Julien.

meanwhile will try your recommendation about XI 3.0 changes and see how that goes. :+1:


BO_TN (BOB member since 2008-07-30)

Did anyone figure out the solution to the “Type Mismatch” error message? For me, it is happening on this line in the code:

Set UserObject = UserItem


beckercd (BOB member since 2009-01-26)

Hey Julien, I work in Paris and I am french, you can contact me PM on my website :lol:


bernard timbal :fr: (BOB member since 2003-05-26)

Hi Julien,
This is working like a champ. Thank you so much for this VERY VERY useful tool. the best part is that it works with both XI R2 and XI R3.x version.

Thanks,
BNReddy


BNReddy :us: (BOB member since 2006-06-27)

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?


alpha1145 :us: (BOB member since 2006-01-04)

Look strange…

I have never installed on the same computer XIR2 and XI3.x client, so i don’t know how the macro work in this case…

Hi Julian,

Great Work…

I am facing one problem …I am able to use this excel file against Dev but its not working against Prod

Can u suggest me what could be the reason for this .

Please do reply.


msandy7 (BOB member since 2009-03-11)

Hi,

This is a great tool. Need help as I am a little stuck…

I need to write back to CMS the Fullnames for all users. We are using SSO login for all users and Windows AD Id shows up in Fullname field because that is how it was set up initially. Now we want to replace that with Employee’s full name.

Here’s where I am stuck:- when I try to write back to CMS the Fullname, I can only write back for the user with which I am logged into CMS (this user has administrative rights). For all the other users, neither can I modify successfully nor do I get any error messages.

Please advice on how to proceed.

Thanks!


Muru09 (BOB member since 2009-02-10)

I am getting VBAproject -5 Invalid procedure call or argument error. Tried V3 & V4 nothing works, It use to work on XI R3 but even after changing library references to 12.0 but its not working for BO3.1

I am not sure whats happening? Is any one able to use with 3.1?


makadiar (BOB member since 2007-07-02)

Hello

I need your help :cry:

I have to get a Group List from BO. I have this oder:

select * from ci_systemobjects where si_kind=‘Usergroup’

but with this order I can not see the UserID that belong to ever gruop.

Please, could you help me?

Regards from Spain.


pleasures (BOB member since 2009-05-05)

I have too this secuence:

Select top 5000 SI_NAME,SI_USERFULLNAME,SI_DESCRIPTION, SI_GROUP_MEMBERS from CI_SYSTEMOBJECTS Where SI_KIND=‘Usergroup’

but I can not get the UserId :cry:

Thanks.


pleasures (BOB member since 2009-05-05)

R u on XI R2 or 3.0/3.1 ?

If you are on 3.0/3.1 you can use Query builder

http://URL:8080/AdminTools

Select top 5000 SI_ID,SI_NAME,SI_USERFULLNAME,SI_DESCRIPTION, SI_GROUP_MEMBERS from CI_SYSTEMOBJECTS Where SI_KIND=‘User’

Select top 5000 SI_ID,SI_NAME,SI_USERFULLNAME,SI_DESCRIPTION, SI_GROUP_MEMBERS from CI_SYSTEMOBJECTS Where SI_KIND=‘Usergroup’

you will have to map the objects from above queries.

Hope its useful…


makadiar (BOB member since 2007-07-02)

To use this spreadsheet (XI 3.1 v3), what permissions do you need on the account. When the user is an administrator, they can use the spreadsheet. When they are a normal user, the spreadsheet doesn’t populate.

For the XI R2 spreadsheet, it worked for our normal user.


Schmitty (BOB member since 2006-11-16)

I am using Administrator as a user to extract the data. I have Excel 2007.

I am getting error

Failure in UserGroups()

VBAProject -5: Invalid Procedure call or argument 1000005

Followed by another prompt

Microsoft Visual Basic
Runtime error ‘-2147417848 (80010108)’;

Automation error
The object invoked has disconnected from the clients.

I will be really thankful for any help I can get.


makadiar (BOB member since 2007-07-02)

I am getting a error “Failure in UserGroups()”

CrystalEnterprise.SessionMgr.1–2147210751: Unable to connect to APS (my CMS name:port) to retrieve cluster members.Logon can not contiue. 1000440.

This utility used to work great. The only thing that changed on this client is that I had to install an older version of Crystal (8.5) to debug another problem.

Unfortunately, I can’t uninstall CR 8.5 right now.


BOBJ_MAN (BOB member since 2008-12-08)

I had to give top-level view permission to the user and groups for the group that needed to use the spreadsheet.


Schmitty (BOB member since 2006-11-16)