NUMSysCMDLauncher – Bulk User/Group Import/Modify/Delete from command line

This was something I always wanted to do, however kept skipping this. However I had a compelling reason to finish this on Friday.

Scott, this is my Guru Dakshina.

Some of the people who know me (which is a very few) knows that I started with Hyperion Web Analysis (which I still love) World wide support team. However they don’t know that Scott Metzler and Nouria Kehli (that’s a real small circle) were the ones who introduced me to the world of Hyperion.

Scott reached out to me with a business case this Friday (which was really nice of him), where he need to import some users to Shared Services Native Groups. He’ll get those users as a file which their respective native groups. My first advice was to use LCM and I know that Scott was going to say the following.

When you try to use LCM for importing users/groups the migration option is set to create/update. Once that option is set and you try to import new users to existing groups, the old users will be overwritten.

I know I can change that behavior in the API whether to overwrite or merge. I always wanted to give NUMSys a command line interface and I thought why not do it right here, right now :).

This is my way of saying Thank you Scott

You can use NUMSysCMDLauncher to import users/groups from a file now.

I’ll add this to NUMSys Web in the upcoming version. (It got delayed a lot, I know been, cray busy with lot of stuff)

NUMSysCMDLauncher 1.0 supports the following operations

1. importuser
2. importgroup
3. deleteuser
4. deletegroup

Usage is as follows

usage: NUMSysCMDLauncher
-D <-D>                               Use this if you are using encryption
-deletegroup                          Delete Group operation
-deleteuser                           Delete User operation
-encrypt <-encrypt=<encryptstring>>   Use this for encrypting strings
-file <-file=filename>                File with Users, Groups information
-help                                 prints usage
-importgroup                          Import Group operation
-importuser                           Import User operation
-p <-p=password>                      Password for connecting to Shared Services
-u <-u=username>                      Username for connecting to Shared Services

Encryption

NUMSysCMDLauncher also supports encryption and you can encrypt the entire command by navigating to the lib folder and issuing the following command

java -jar NUMSysCMDLauncher.jar -encrypt="-u=admin -p=password -deleteuser -file=C:TempHSSUsers.csv"

Copy the encrypted text to the bat file.

Import User(s)You can upload users from a file using the below given format.

If this is an existing user, the utility will skip the creation and switch to a modify mode.

You can perform creation of the group(s) along with group’s assignment. If this is an existing group(s) then utility will switch to modify mode.

In this example I’m creating a group called “AllAdmins” and adding “EPM Admins” group and “testuser1” user to this group.

You can mention the provider of the group/user, default is “Native Directory”.

Delete User/Group

You can bulk delete user(s)/group(s) by passing the username/groupname in a file

You can download NUMSysCMDLauncher from here

Documentation can be accessed here

I think I’ll add a new option in the next release where you can specify whether to overwrite a group assignment or perform a merge.