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: No events within the next 45 days.

BOXI UserList & Group Excel Export
3 members found this topic helpful
Goto page 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
julienbras
Senior Member
Senior Member



Joined: 25 Jul 2007

Posts: 93
Location: Montréal, Canada


flag
PostPosted: Fri Jan 04, 2008 4:19 am 
Post subject: BOXI UserList & Group Excel Export

This topic is dedicated to the BOXI UserList & Group Extraction located in the BOB's Download (here)

A little description :
Quote:

What is it ? :
It’s simply an Excel file ith a little VBA code to extract from a CMS the complete list of user and the list of groups each user is member of. Quite useful when you need to check group membership…
Information provided for each user : id, login, full name, email adress, group list, flag user activated, flag is password to change, description and last login time.
It’s now possible to edit the CMS data, simply by modify entries in the Excel File. You need then to export your modification back to the CMS. Modifiables column are : Login, FullName, Email, Disabled and Description.

You need BO libraries to run the VBA ; if you have installed the full client it's OK.


History:
V3 (17/01/2008) – Added the Last Login Time data, and the possibility to modifiy the Login, FullName, Email, Disabled and Description column and sync it to the CMS.
V2 (04/01/2008) – Corrected the 1000 objects limit (hard coded to 1000000 objects) ; and the FullUser parameters, add of a topic for discussion
V1 (25/07/2007) – Original Release

Feel free to post here remarks on this tool, possible improvements and bugs...

_________________
Julien Bras

360eyes Product Manager : Export your entire BOE platform data to a RDBMS. Run impact analysis.
Optimize Your Migration to SAP BusinessObjects BI4.2


Last edited by julienbras on Sat Jan 19, 2008 1:12 pm, edited 2 times in total
Back to top
darkstar09
Forum Member
Forum Member



Joined: 28 Sep 2004

Posts: 4



PostPosted: Fri Jan 04, 2008 10:40 am 
Post subject: Re: BOXI UserList & Group Excel Export

Excellent file!
Tested on a large enterprise BOXI infrastructure (3000+ users) and it is working perfectly.

icon_biggrin.gif
Back to top
Toral Goradia
Senior Member
Senior Member



Joined: 22 Oct 2003

Posts: 51



PostPosted: Fri Jan 04, 2008 10:52 am 
Post subject: Re: BOXI UserList & Group Excel Export

Hi,

I agree that this macro is excellent! However, my requirement is a little bit different. I want to be able to run this macro just for certain group. So, I modified the macro to pull in the users first and then filter it for a group.

However, what I am noticing is that the user object can bring in just 1000 rows. Thus it is providing me a partial resultset. I know that the query builder tool too has this limitation.

Will appreciate any suggestions regarding this.

Thanks in advance.

Toral.
Back to top
julienbras
Senior Member
Senior Member



Joined: 25 Jul 2007

Posts: 93
Location: Montréal, Canada


flag
PostPosted: Fri Jan 04, 2008 11:09 am 
Post subject: Re: BOXI UserList & Group Excel Export

Hi,

For the V2 version i have just released, i have corrected this '1000 objects' problem. It's just a syntax problem inside the infostore query (add after the SELECT a 'TOP xxxxx' where xxxx is the number of row you want to get, and it's set by default to 1000).

For my tool i have hard-coded the limit at 1,000,000 row, i think it will be enough ...

Regards,

_________________
Julien Bras

360eyes Product Manager : Export your entire BOE platform data to a RDBMS. Run impact analysis.
Optimize Your Migration to SAP BusinessObjects BI4.2
Back to top
rs90144
Principal Member
Principal Member



Joined: 18 Apr 2006

Posts: 117



PostPosted: Fri Jan 04, 2008 11:13 am 
Post subject: Re: BOXI UserList & Group Excel Export

You can use this tool to get the user list by group...

http://www.forumtopics.com/busobj/viewtopic.php?t=97773
Back to top
Toral Goradia
Senior Member
Senior Member



Joined: 22 Oct 2003

Posts: 51



PostPosted: Fri Jan 04, 2008 11:23 am 
Post subject: Re: BOXI UserList & Group Excel Export

Julien,

Thanks a ton!!! That worked beautifully icon_smile.gif

Toral.
Back to top
Sheshachala5
Forum Enthusiast
Forum Enthusiast



Joined: 09 Jan 2004

Posts: 1567
Location: California


flag
PostPosted: Fri Jan 04, 2008 2:08 pm 
Post subject: Re: BOXI UserList & Group Excel Export

I used it,Keep up the good work. icon_biggrin.gif
_________________
Kalyan,
PMP,CBIP,CDMP,BOCP,SCJA
Image link
Back to top
taskoriented
Senior Member
Senior Member



Joined: 08 May 2007

Posts: 89



PostPosted: Mon Jan 07, 2008 1:44 pm 
Post subject: Re: BOXI UserList & Group Excel Export

I downloaded the v2. But the button on the excel sheet is not clickable. Do I need to do some configuration before using the excel sheet?

THanks,
Back to top
Sheshachala5
Forum Enthusiast
Forum Enthusiast



Joined: 09 Jan 2004

Posts: 1567
Location: California


flag
PostPosted: Mon Jan 07, 2008 2:42 pm 
Post subject: Re: BOXI UserList & Group Excel Export

I guess you need to "Enable Macro" since the code is an executable
_________________
Kalyan,
PMP,CBIP,CDMP,BOCP,SCJA
Image link
Back to top
taskoriented
Senior Member
Senior Member



Joined: 08 May 2007

Posts: 89



PostPosted: Mon Jan 07, 2008 4:44 pm 
Post subject: Re: BOXI UserList & Group Excel Export

Thanks. It works. That was some problems with my system.

BTW, just wondered the possibility of adding the alias column into the spreadsheet. It will be extremly helpful for our project to do some house cleaning.
Back to top
julienbras
Senior Member
Senior Member



Joined: 25 Jul 2007

Posts: 93
Location: Montréal, Canada


flag
PostPosted: Thu Jan 10, 2008 11:34 am 
Post subject: Re: BOXI UserList & Group Excel Export

You are welcome to go into the code to improve it icon_wink.gif
It's quite easy to add a column in the document icon_smile.gif

Regards,

_________________
Julien Bras

360eyes Product Manager : Export your entire BOE platform data to a RDBMS. Run impact analysis.
Optimize Your Migration to SAP BusinessObjects BI4.2
Back to top
julienbras
Senior Member
Senior Member



Joined: 25 Jul 2007

Posts: 93
Location: Montréal, Canada


flag
PostPosted: Wed Jan 16, 2008 2:22 pm 
Post subject: Re: BOXI UserList & Group Excel Export

taskoriented, when you speak of alias column, what is the meaning ? The description ? The login name ?
_________________
Julien Bras

360eyes Product Manager : Export your entire BOE platform data to a RDBMS. Run impact analysis.
Optimize Your Migration to SAP BusinessObjects BI4.2
Back to top
julienbras
Senior Member
Senior Member



Joined: 25 Jul 2007

Posts: 93
Location: Montréal, Canada


flag
PostPosted: Sat Jan 19, 2008 1:13 pm 
Post subject: Re: BOXI UserList & Group Excel Export

V3 version available, with the Last Login date information, and R/W capactiy (it's now possible to modify data in the CMS with the excel file)
_________________
Julien Bras

360eyes Product Manager : Export your entire BOE platform data to a RDBMS. Run impact analysis.
Optimize Your Migration to SAP BusinessObjects BI4.2
Back to top
taskoriented
Senior Member
Senior Member



Joined: 08 May 2007

Posts: 89



PostPosted: Sun Jan 20, 2008 4:00 pm 
Post subject: Re: BOXI UserList & Group Excel Export

julienbras. Good job! It is glad to see the V3 out. I really like the tool. I am able to modify the code to get the alias information. In my environment, I created enterprise alias account from WinAD or LDAP account for troubleshoot purpose. So that I need to make sure all the enterprise alias are deleted afterwards. This tool is very useful for this purpose.
Back to top
Diane1969
Principal Member
Principal Member



Joined: 18 Jan 2007

Posts: 213
Location: Birmingham


flag
PostPosted: Mon Jan 21, 2008 3:51 am 
Post subject: Re: BOXI UserList & Group Excel Export

Great work, Julien. Just downloaded V3 and it is proving to be really useful.

Please keep them coming icon_biggrin.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 5 All times are GMT - 5 Hours
Goto page 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.0424 seconds using 17 queries. (SQL 0.0151 Parse 0.0010 Other 0.0263)
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