Lotus Notes to SharePoint Blog

Blog about Dell's Notes Migrator to SharePoint tool and other things related to Lotus Notes migration projects

Extracting all the users from a set of databases

The Extract Database Users tool (new in Notes Migrator for SharePoint 5.3) allows you to select one or more databases in any database view in the Migration Console and then extract all the user names contained in those databases.  This tool is useful for simply gaining an understanding of the users involved in a group of Notes applications, but the primary purpose of the tool is ultimately to generate a user mapping file that NMSP can use at migration time.


Depending on how much analysis has been done for these selected databases, we may extract user names from the database ACLs, the Created By/Modified By metadata, the document level security, or the usage activity.  As explained below, users may also be added to the list by expanding Domino groups and by importing existing NMSP User Mapping XML files.  The sources of the user names are listed in the view columns shown below, and you can filter the sources shown to only list users that came from certain sources.


The type of user name (Person, Group, Unspecified) is also shown and you can filter based on them.  Note that Unspecified users may become specified as you perform certain operations such as group expansion or imports.  Finally, you can manually set the user type by using the combo boxes in the view. 


You can also filter by the Notes domain.  This is a simple text match against the last part of the abbreviated name, so either “Westford/IBM” or just “IBM” would select “John Smith/Westford/IBM”.  If is common to want to select all the users plus all the groups, which the “No domain” checkbox allows you to do.


If a group is listed in a database, it is sometimes useful to be able to find all the members of the group.  If you press the Expand Groups button, NMSP will contact the configured Group Resolution Server (from Advanced Configuration) and look up every Group and Unspecified entry (in case it really is a group).  Any new members will be added to the list and indicated as “ACL via Group”.


To remove users from the list, you can select one or more row using the selection column on the right (or press Control-A to select all of them) and press the Remove button.


The last column in the view is the SharePoint names column.  You can set these names automatically using the Import function, using the Set SharePoint Names function, or by typing them in manually. 

The Import process loads in users from existing XML User Mapping files and sets the Imported column.  Imported data is merged with existing data but if a SharePoint name is specified in the imported file, it will overwrite the existing name every time. 

The Set SharePoint Names function gives you several ways to automatically assign your SharePoint names. 

· Load users from Domino Directory – use any field in the user’s Person document on the Domino directory as the new SharePoint name

· Set Default using Format String – Generate a new SharePoint name by substituting the various parts of the Notes name.

· Set Default using the Notes common name  – Use the simple common name as the SharePoint name

Note that in all these cases, existing SharePoint names will be preserved unless the override SharePoint names flag is already checked.


Finally, you can press the Export button to generate a User Mapping file (either in an XML or comma delimited format).


Comments are closed.