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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (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
mukul.jain
Senior Member
Senior Member



Joined: 25 Oct 2005

Posts: 51


flag
PostPosted: Thu Jul 24, 2008 9:26 am 
Post subject: Re: BOXI UserList & Group Excel Export

Is it possible to inlcude information whether user is enabled or disabled?

Thanks
Back to top
julienbras
Senior Member
Senior Member



Joined: 25 Jul 2007

Posts: 95
Location: Montreal, QC


flag
PostPosted: Thu Jul 24, 2008 9:31 am 
Post subject: Re: BOXI UserList & Group Excel Export

mukul.jain wrote:
Is it possible to inlcude information whether user is enabled or disabled?

Thanks


Check the column F (title : Disabled) icon_smile.gif

_________________
Julien Bras
Back to top
mukul.jain
Senior Member
Senior Member



Joined: 25 Oct 2005

Posts: 51


flag
PostPosted: Thu Jul 24, 2008 9:32 am 
Post subject: Re: BOXI UserList & Group Excel Export

Sorry..found it
headers got deleted to couldn't figure out initially.

thanks
Back to top
jgorricho
Senior Member
Senior Member



Joined: 21 Oct 2005

Posts: 35


flag
PostPosted: Fri Jul 25, 2008 8:20 am 
Post subject: Re: BOXI UserList & Group Excel Export

This is excellent, thanks. I tried to run it and I am getting this error: CrystalEnterprise12.SessionMgr.1 - -2147024891: Access denied. You cannot log on to an older version of the CMS. 1000440

We have BOXI R2 SP3. Any ideas?

Thanks!
Back to top
ced
Senior Member
Senior Member



Joined: 27 Jun 2005

Posts: 41
Location: Belgium


flag
PostPosted: Thu Aug 28, 2008 9:42 am 
Post subject: Re: BOXI UserList & Group Excel Export

Hi all,

The solution is great !!! icon_wink.gif But unfortunately, I haven't Excel application on my production server and I can't install it....

I receive error message during code debuging :
"Set SessionManager = CreateObject("CrystalEnterprise.SessionMgr")
'Enterprise Session instanciation
Set esession = SessionManager.Logon(tbName, tbPassword, tbCMS, "secEnterprise")
"
Has anybody create a connection string to CMS concerning table

Thanks in advance for you reply

CeD

_________________
working with BO 6.5, XI R2, XI 3.1 & SAP BI 4.*
Migration BI/DWH
DS 4.*
SAP HANA certified associate
Back to top
julienbras
Senior Member
Senior Member



Joined: 25 Jul 2007

Posts: 95
Location: Montreal, QC


flag
PostPosted: Mon Sep 15, 2008 4:40 am 
Post subject: Re: BOXI UserList & Group Excel Export

Just for info :

the file have been successfully tested on BO XI R2 (SP1/SP2/SP3)

Regards,

_________________
Julien Bras
Back to top
F.Richard
Forum Member
Forum Member



Joined: 27 Aug 2008

Posts: 8
Location: Mussy-La-Ville


flag
PostPosted: Wed Sep 24, 2008 1:05 am 
Post subject: Re: BOXI UserList & Group Excel Export

icon_biggrin.gif Thanks it works fine. Very usefull.
Back to top
Molly
Senior Member
Senior Member



Joined: 16 Mar 2004

Posts: 70



PostPosted: Fri Dec 05, 2008 4:15 pm 
Post subject: Re: BOXI UserList & Group Excel Export

this is pretty awesome. How could i leverage this to use if we want listing of users who have not logged on last 90 or 120 days?
Back to top
meichu
Forum Member
Forum Member



Joined: 24 Mar 2009

Posts: 2



PostPosted: Wed Apr 29, 2009 3:38 pm 
Post subject: Re: BOXI UserList & Group Excel Export

This macro is great. However I am not able to run it when change the authentication to secWinAD. Any idea? I am able to login to CMC with Windows AD authentication though.
Back to top
julienbras
Senior Member
Senior Member



Joined: 25 Jul 2007

Posts: 95
Location: Montreal, QC


flag
PostPosted: Thu Apr 30, 2009 2:23 am 
Post subject: Re: BOXI UserList & Group Excel Export

i have hardcoded the secEnterprise authentification in my excel macro, but you can surely change that to an other authentification icon_smile.gif

Or use the Administrator account which is a Enterprise account !

Regards,

_________________
Julien Bras
Back to top
kevinmo13
Forum Member
Forum Member



Joined: 29 Apr 2009

Posts: 4



PostPosted: Fri May 01, 2009 9:34 am 
Post subject: Re: BOXI UserList & Group Excel Export

Found some info to make this work with BOXI R3. You will need to open the excel file, hit Alt+F-11. Then go to tools, References and find the missing checked items. Check the identical item in the list for version 12 and uncheck the 11.5 version as you go. Save the file and it will now work with BOXI R3.

If you receive an error stating that an account could not be found in active directory when running your extract, log into CMC and go to authentication. Select Windows AD. Scroll to the bottom and click Update. This will clear all accounts that do not have an AD accont associated with them so you dont have to delete them manually.

Hope this helps anyone that is using this tool.
Back to top
mishelhere
Senior Member
Senior Member



Joined: 24 Jan 2008

Posts: 76
Location: Singapore


flag
PostPosted: Tue Dec 01, 2009 2:14 am 
Post subject: Re: BOXI UserList & Group Excel Export

this is great! icon_mrgreen.gif KUDOS! icon_smile.gif
how do i add on which reports users are accessing?
Back to top
mithungo
Forum Member
Forum Member



Joined: 01 Sep 2009

Posts: 15



PostPosted: Tue Dec 29, 2009 5:09 am 
Post subject: Re: BOXI UserList & Group Excel Export

Hi,

Superb tool. One issue though..doesn't work in a system having both XI R3 and R2 SP2.

Getting the following error.

CrystalEnterprise12.SessionMgr.1 - -2147024891: Access denied. You cannot log on to an older version of the CMS. 1000440

Works fine with R2 SP2 alone. Any ideas?
Back to top
ethaihunt
Forum Member
Forum Member



Joined: 07 Oct 2010

Posts: 15



PostPosted: Thu Dec 09, 2010 3:31 pm 
Post subject: Re: BOXI UserList & Group Excel Export

Hi All,

The code works great in excel! I really need to get this code to work in BO(XI/R2 SP5). I have to compare the data with another report and schedule this report.

I need to get
Code:
Set Rng = Sheets("Users").Cells
to work in BO. Can someone please tell the replacement in BO; for eg: Thisdocument.reports(0).,if it can be used to replicate the function.

Thanks in Advance,
Ethan
Back to top
Ahchay
Forum Member
Forum Member



Joined: 28 Jun 2011

Posts: 1



PostPosted: Wed Jul 06, 2011 6:09 am 
Post subject: Re: BOXI UserList & Group Excel Export

bmalak_98 wrote:
I used to be able to use this tool with no problems and I really like it.

However, I'm suddenly getting an error box when clicking on the "Get Users & Groups" button.

Failure in UserGroups()
VBA Project - 429: ActiveX component can't create object 1000429

Attached a screenshot.

Any ideas?

Not sure if you ever resolved this, but I've just had the exact same issue - the following change to the code seems to have resolved it:

Change this line:
Code:

    'Session Manager instanciation
    Set SessionManager = CreateObject("CrystalEnterprise.SessionMgr")


To this:
Code:

    'Session Manager instanciation
    Set SessionManager = New SessionMgr
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 3 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.0299 seconds using 17 queries. (SQL 0.0030 Parse 0.0009 Other 0.0260)
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