BOXI UserList & Group Extraction

[system]

Team - May I get the same kind of macro for SAP BO BI 4 - Looking forward to hear from you -

---

stsrin (BOB member since 2005-07-21)

[system]

I get a compile error when I try this tool. error:
Compile error. Cannot find project or library. When I look at the code. It shows Dim SessionManager, Sess As SessionMgr

Thanks
Ram

---

Ram31 (BOB member since 2004-11-29)

[system]

Thank you Ram - I am facing same error …

---

stsrin (BOB member since 2005-07-21)

[system]

@Bo_Arale

very usefull tool… I’m working with BOXIr3 and it works fine.

Now we are upgrading our BO so, is there something like this for B.O. 4.0?

Thank you,
Ale

Hi Bo_Arale,

Could you please post the tool which is working for BO XI R3.

Thanks,
CK

---

Chandru 901 (BOB member since 2007-07-20)

[system]

Hello all BI4.x users,

I was able to extract BO Users and Groups lists using BI40 repository. Just FYI, we are currently on BI4.0 SP4, Patch 4.

I was trying to upload the new script for anyone who’s interested. But for some reason can’t do it with my profile. Let me know.

uploaded topic here:

BI40 Users and Groups Lists

Hello All, Here’s an update to the BO Users list script, which was developed originally by Julien Bras, 01/2008. To view the original link, click topic below: https://bobj-board.org/t/89434 The latest file contains references to the BI4.0 assemblies. If you haven’t installed the BI4.x client, the script will fail. So, make sure to install the BI40 Platform Client tool first before executing the script. Moderators please review the uploaded file for everyone to use: <BOBI4_UserList_V001.zip> …

Marek - can you grant me the privilege to upload the code?

-Fernand_DaCien
Los Angeles, CA

---

Fernand_DaCien (BOB member since 2006-05-06)

[system]

Hi,

It’s done:

BI40 Users and Groups Lists

Moderator note: Approved, and moved to BOB’s Downloads. Thanks for sharing. Marek Chladny (BOB member since 2003-11-27)

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Hi,

It’s very usefull and works very well with XI 3.1 SP3.

Thank you very much

Regards,
Ben

---

b_gonzalez (BOB member since 2008-10-23)

[system]

Do we have anything useful for BO4?

---

dmitry.anoshin (BOB member since 2013-03-28)

[system]

@Fernand_DaCien

I was able to extract BO Users and Groups lists using BI40 repository. Just FYI, we are currently on BI4.0 SP4, Patch 4.

---

Nick Daniels (BOB member since 2002-08-15)

[system]

Nick,

I run BOXI UserList V3, and got “Compile error: Can’t find project library”

How can i fix it?

---

dmitry.anoshin (BOB member since 2013-03-28)

[system]

Hi Julien. Thank you very much for the Excel macro, it’s proven very useful for mass user loads.

I’m wondering if there is a way to automate the process of adding users (members) to groups in the BOXI3.1 CMC. Could this functionality be added to the macro, or is this better left for a separate macro/thread?

Also, is there any way to extend the timeout limit when either extracting from or modifying to the repository?

Thanks,
Michael Rodriguez

---

michael.rodriguez (BOB member since 2013-05-02)

[system]

Hi,

I am getting the following error when using this utility.

Run-time error ‘-2147417848 (80010108)’:

Automation error
The object invoked has disconnected from its clients.

Please suggest.

Regards,
Sadiq.

---

sk_sadiq (BOB member since 2007-09-17)

[system]

Hi

Can this be used to get the user group list in BI 4.0 we have this new platform and I don’t see any Macro’s for this BI 4.0

---

bodiscussion (BOB member since 2010-07-11)

[system]

Hi,

How can I make this utility work with Win AD authentication?
We have BO XIR3.1 SP4 with Win AD authentication?

When I try to connect with the utility, it is giving me connection error:
“Enterprise Authentication could not log you on. Please make sure your logon information is correct. (FWB 00008) 1000440.”

Any idea how to get it connected?

Thanks in advance.

---

izak004 (BOB member since 2010-11-10)

[system]

Hi,

The same answer as I replied to you other question:

@izak004

How can I make this utility work with Win AD authentication?

Open the utilitie’s VBA code and replace every occurence of

secEnterprise

with

secWinAD

That would be the easiest and fastest way.

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Hi Marek,

Thank you for replying quickly.

Please excuse my ignorance for another doubt.

I have the ‘BOXI UserListV4’ version of the utility and when I open it, press ALT+F11, it opens VB for applications with one window with the following code

“Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If (Target.Row > 2 And Target.Column < 13) Then
Dim Rng As Excel.Range
Set Rng = Sheets(“Users”).Cells
For Each cell In Target
Rng(cell.Row, 13) = “1”
Next cell
End If
End Sub”

I looked into other options from the menu and on the right pane, but couldn’t understand where to change the code. Could you please guide me?

I was able to edit the code for the other utility but with error on some of the tabs, which I will ask/post later in that topic

Thanks again

---

izak004 (BOB member since 2010-11-10)

[system]

@izak004

I have the ‘BOXI UserListV4’ version of the utility

Where did you get the version 4 of the utility? I can’t find it now. :?

---

Marek Chladny (BOB member since 2003-11-27)

[system]

The link to V4 is in the first post of this topic,

History:
V4 (07/03/2008) - To be download here : http://sidoine.org/node/58 (Just changed alittle property in Excel selection ; when you copy-past a value for more than one user ; all the users will be flagged for update (and not just one like previous version)).

I tried with V3, and I have the same problem, not able to understand where to edit it

---

izak004 (BOB member since 2010-11-10)

[system]

@izak004

…and when I open it, press ALT+F11, it opens VB for applications with one window with the following code…

Close that window (not the whole VBA editor). Then in the left panel you should see “Forms” folder. Open it and then right click on the fLogin form and select view code. This is the code where you need to replace secEnterprise with secWinAD.

---

Marek Chladny (BOB member since 2003-11-27)

[system]

I think somethings wrong with passing the credentials to WinAD.

I logged in with my credentials, the utility tried to validate it and errors out.

"Active Directory Authentication failed to get Active Directory groups for the account with the ID CN:AMA455, OU=USERS, OU=Mis, OU=Accounts " etc.

AMA455 is not my ID and I checked in our users, it seems to be an invalid user. There was a user with this ID and shes not with us anymore.
Wondering why it is trying to authenticate her when I’m providing my credentials.

Same error with V3 and V4 as well

Any idea?

---

izak004 (BOB member since 2010-11-10)