Author |
Message |
julienbras Senior Member


Joined: 25 Jul 2007
            Posts: 94

|
Posted: 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
Last edited by julienbras on Sat Jan 19, 2008 1:12 pm, edited 2 times in total |
|
Back to top |
|
 |
darkstar09 Forum Member


Joined: 28 Sep 2004
               Posts: 4

|
Posted: 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.
 |
|
Back to top |
|
 |
Toral Goradia Senior Member


Joined: 22 Oct 2003
                Posts: 51

|
Posted: 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


Joined: 25 Jul 2007
            Posts: 94

|
Posted: 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 |
|
Back to top |
|
 |
rs90144 Principal Member


Joined: 18 Apr 2006
             Posts: 117

|
|
Back to top |
|
 |
Toral Goradia Senior Member


Joined: 22 Oct 2003
                Posts: 51

|
Posted: Fri Jan 04, 2008 11:23 am Post subject: Re: BOXI UserList & Group Excel Export |
|
|
Julien,
Thanks a ton!!! That worked beautifully
Toral. |
|
Back to top |
|
 |
Sheshachala5 Forum Enthusiast


Joined: 09 Jan 2004
               Posts: 1567 Location: California

|
Posted: Fri Jan 04, 2008 2:08 pm Post subject: Re: BOXI UserList & Group Excel Export |
|
|
I used it,Keep up the good work.  _________________ Kalyan,
PMP,CBIP,CDMP,BOCP,SCJA
Image link |
|
Back to top |
|
 |
taskoriented Senior Member


Joined: 08 May 2007
            Posts: 89

|
Posted: 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


Joined: 09 Jan 2004
               Posts: 1567 Location: California

|
Posted: 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


Joined: 08 May 2007
            Posts: 89

|
Posted: 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


Joined: 25 Jul 2007
            Posts: 94

|
Posted: 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
It's quite easy to add a column in the document
Regards, _________________ Julien Bras |
|
Back to top |
|
 |
julienbras Senior Member


Joined: 25 Jul 2007
            Posts: 94

|
Posted: 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 |
|
Back to top |
|
 |
julienbras Senior Member


Joined: 25 Jul 2007
            Posts: 94

|
Posted: 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 |
|
Back to top |
|
 |
taskoriented Senior Member


Joined: 08 May 2007
            Posts: 89

|
Posted: 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


Joined: 18 Jan 2007
            Posts: 213 Location: Birmingham

|
Posted: 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  |
|
Back to top |
|
 |
|