BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

BOXI UserList & Group Excel Export
3 members found this topic helpful
Goto page Previous  1, 2, 3, 4, 5  Next
 
Search this topic... | Search General Discussion... | Search Box
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Author Message
Geo68
Forum Member
Forum Member



Joined: 12 Jun 2009

Posts: 12



PostPosted: Thu Mar 05, 2015 2:25 pm 
Post subject: Re: BOXI UserList & Group Excel Export

Hi, I really need to create a list of users we have in BOXI and found this download woould be ideal to do the job. I don't have access to CMS and there is a reluctance to run this application against the CMS. Is there any way this can be done just using the select statement as used by the application?

Thanks in advance

Geo68
Back to top
Lugh
Forum Enthusiast
Forum Enthusiast



Joined: 16 Jul 2009

Posts: 1158
Location: Herndon, VA



PostPosted: Fri Mar 06, 2015 11:14 am 
Post subject: Re: BOXI UserList & Group Excel Export

Sure. Walk through the VBA code and figure out what the query would look like. Plug that query into Query Builder (your BO admin should know how to get to that).

The big downside is that the results are not in a spreadsheet format. They are on an HTML page, with each record being a block of data. It is tedious at best to take that information and transform it into a useful list of users.

If it helps at all, I can personally vouch for the utility and safety of this tool, so long as you are only doing reads from the CMS. I have used several different versions against both R2 and 3.1 repositories.
Back to top
bobnoob
Senior Member
Senior Member



Joined: 16 Sep 2010

Posts: 55



PostPosted: Mon May 11, 2015 3:27 am 
Post subject: Re: BOXI UserList & Group Excel Export

Hello everybody,

What has to be changed in the macro, if you get the "Failure in UsersGroups()"-error message.

CrystalEnterprise14.SessionMgr.1 - ... FWB 00008

Can you post your workarounds to fix that?

That would be great!
Back to top
bobnoob
Senior Member
Senior Member



Joined: 16 Sep 2010

Posts: 55



PostPosted: Wed Jul 22, 2015 8:52 am 
Post subject: Re: BOXI UserList & Group Excel Export

Has someone a hint for me? That would be great icon_wink.gif
Back to top
venkat_dasari
Forum Member
Forum Member



Joined: 14 Aug 2015

Posts: 2



PostPosted: Thu Aug 20, 2015 5:33 am 
Post subject: Re: BOXI UserList & Group Excel Export

HI Julien,

When running the macro we are getting the error "vba project 429 activex component can't create object 1000429" i changed the code to Set sessionmanager = CreateObject("CrystalEnterprise12.SessionMgr.1")

we are on XI3.1 Sp6 but still getting the same error. Could you please help on this. Is there anything else i need to change in the code?

Regards,
Venkat
Back to top
Mingthingla Keishing
Forum Member
Forum Member



Joined: 08 Nov 2013

Posts: 5



PostPosted: Thu Oct 27, 2016 8:01 am 
Post subject: Re: BOXI UserList & Group Excel Export

I have been using the Macros successfully over the past years from a 32 bit PC. I haven't got it to work from a 64 bit PC, any idea?

I get the "VBAProject - 429: ActiveX component can't create object 1000429" Error from a 64 bit PC.

Business Objects Client Tool is installed. I have tried to register the dlls as well. Tried changing the code as below but no luck.

From:
Set SessionManager = CreateObject("CrystalEnterprise.SessionMgr")

To:
Set sessionmanager = CreateObject("CrystalEnterprise12.SessionMgr.1") OR Set SessionManager = New SessionMgr

Issue is not VBA Macro specific. Thank you in advance for your suggestions / inputs.
Back to top
Manasi
Forum Associate
Forum Associate



Joined: 17 Dec 2004

Posts: 510
Location: CA



PostPosted: Fri Jan 04, 2019 7:24 pm 
Post subject: Re: BOXI UserList & Group Excel Export

Hey-

I know this is an old thread but were you able to find a resolution for this issue.
Code works fine on 32 Bit windows but fails on 64 Bit windows 10.

Any ideas are appreciated

Code fails with the exact error message as above thread.

_________________
BI4.2 SP4
Windows 2012, RedHat Linux, TC8, SQL server.
Back to top
kaaoic001
Forum Member
Forum Member



Joined: 31 May 2016

Posts: 4



PostPosted: Mon Jun 03, 2019 3:55 am 
Post subject: Re: BOXI UserList & Group Excel Export

Anyone?
bobnoob wrote:
Has someone a hint for me? That would be great icon_wink.gif
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6635
Location: Connecticut, USA


flag
PostPosted: Tue Jun 04, 2019 10:37 am 
Post subject: Re: BOXI UserList & Group Excel Export

What is the exact problem you're having? I just ran this on Win7 with BI4.2 SP06 Patch 4 installed. I replaced the missing libraries with:

Crystal Enterprise Framework Library 14.0
Crystal Enterprise InfoStore Library 14.0
Crystal Enterprise User PlugIn 12
Crystal Enterprise UserGroup PlugIn 12
Back to top
kaaoic001
Forum Member
Forum Member



Joined: 31 May 2016

Posts: 4



PostPosted: Thu Jun 06, 2019 3:33 am 
Post subject: Re: BOXI UserList & Group Excel Export

Hi Joepeters,
Have VBA code in MS Access to extract the list of users from BO 4.1. Code was working fine with Office 2013, but just updated to Office 2016 and now the code is failing.

The error being generated is: 13 - Type mismatch 1000013

The only change was the Office upgrade.
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6635
Location: Connecticut, USA


flag
PostPosted: Thu Jun 06, 2019 6:08 am 
Post subject: Re: BOXI UserList & Group Excel Export

Eh, I probably won't be of much help to you. What line is it failing on?
Back to top
kaaoic001
Forum Member
Forum Member



Joined: 31 May 2016

Posts: 4



PostPosted: Thu Jun 06, 2019 6:34 am 
Post subject: Re: BOXI UserList & Group Excel Export

Code:
'---Vars for BO Session---
Dim SessionManager As New SessionMgr
Dim esession As EnterpriseSession
Dim iStore As InfoStore

'---Vars for User Info---
Dim BOUsers As InfoObjects
Dim BOUserItem As InfoObject
Dim BOUserObject As User
'Dim BOUserObject As CrystalUserPluginLib.User

'Enterprise Session
Set esession = SessionManager.Logon(Me.tbUserName, Me.tbPassword, Me.cboCMS, Me.cboAuth)

'Infostore instanciation
Set iStore = esession.Service("", "InfoStore")

'--Get User Info
Set BOUsers = iStore.Query("SELECT TOP 1000000 SI_EMAIL_ADDRESS, SI_FORCE_PASSWORD_CHANGE, SI_NAME, SI_ID, SI_USERGROUPS, SI_USERFULLNAME, SI_ALIASES, SI_DESCRIPTION, SI_LASTLOGONTIME, SI_PASSWORDEXPIRE, SI_NAMEDUSER FROM CI_SYSTEMOBJECTS Where SI_KIND='User'")

For Each BOUserItem In BOUsers 'Loop through users

Set BOUserObject = BOUserItem


The code is now failing on the last line above, setting BOUserObject = BOUserIte
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6635
Location: Connecticut, USA


flag
PostPosted: Thu Jun 06, 2019 7:53 am 
Post subject: Re: BOXI UserList & Group Excel Export

It's likely that there is another reference that includes a "User" class, and that is being used for your UserObject object.

I noticed you had this line commented out:
Code:
'Dim BOUserObject As CrystalUserPluginLib.User

That would be the correct way to explicitly reference the correct class. If you had that originally and it didn't compile, then that would indicate that you don't have the Crystal Enterprise User Plugin 12 library selected in References.

Joe
Back to top
giggles7840
Senior Member
Senior Member



Joined: 13 Jul 2007

Posts: 74



PostPosted: Fri Aug 30, 2019 2:38 pm 
Post subject: Re: BOXI UserList & Group Excel Export

Did you get this figured out? This is my favorite file and the 64-bit has ruined it!!! icon_sad.gif
Back to top
SuKA
Forum Member
Forum Member



Joined: 20 Oct 2018

Posts: 18



PostPosted: Tue Sep 03, 2019 2:42 am 
Post subject: Re: BOXI UserList & Group Excel Export

Hello,

this macro works with 32/64 bit Windows and 32 bit Office.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 4 of 5 All times are GMT - 5 Hours
Goto page Previous  1, 2, 3, 4, 5  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0534 seconds using 17 queries. (SQL 0.0242 Parse 0.0009 Other 0.0283)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo