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
Usage is as follows
-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
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 upload groups from a file using the below given format, by default utility performs a merge option with the group’s assignment.
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”.
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.