Smarts NCM - How To Import Users To NCM Using Bulk-Import Utility
Article ID: 330878
Updated On:
Products
VMware Smart Assurance
Environment
VMware Smart Assurance - NCM
Resolution
To show how to use the NCM bulk-import tool to import user accounts to the NCM application.
The bulk-import tool allows the import of user accounts formatted in such a way that they will import to the NCM User Interface and NCM Database.
The bulk-import utility can be found at: <VOYENCE_HOME>/tools/bulk-import
(Where <VOYENCE_HOME> is the installation directory of your NCM Application)
Firstly, source Voyence from the command line:
Figure 1
There is an example file (examples.tar) located in <VOYENCE_HOME>/tools/bulk-import which contains a csv file with the template to create a user import file. Extract this compressed file (examples.tar) and locate the file importUsers.csv. This is the template file used to populate the required user details to import into NCM. As an example, we will create a new user named John Murphy, who currently does not exist within the NCM application, Figure 3. Before adding users, remove all fields for the example users shown in Figure 2:
Figure 2
Figure 3
Once the importUsers.csv file is created with the required details above (saved in the existing format), browse to <VOYENCE_HOME>/tools/bulk-import and run the bulk-import utility using an NCM Administrator account such as the sysadmin user, Figure 4:
Figure 4:
To import the new user(s) into NCM using the importUsers.csv file you have created, enter the command importUsers <FILENAME>. Results will show the number of records imported and any records that may have failed, Figure 5. Type exit to leave the bulk-import utility:
Figure 5:
Note: In the above screenshot it reports that only one of two records was imported. This is due to the empty row 2 which must be left blank.
Now open the NCM application, go to System Administration (press F4) - Global - User Management - System Users.
Here you will see the new user(s) imported from the importUsers.csv file as per the example below, Figure 6:
Figure 6:
This can be a convenient way to import a large number of user accounts and can be used later to make amendments to existing user accounts.
The bulk-import tool allows the import of user accounts formatted in such a way that they will import to the NCM User Interface and NCM Database.
The bulk-import utility can be found at: <VOYENCE_HOME>/tools/bulk-import
(Where <VOYENCE_HOME> is the installation directory of your NCM Application)
Firstly, source Voyence from the command line:
Figure 1
There is an example file (examples.tar) located in <VOYENCE_HOME>/tools/bulk-import which contains a csv file with the template to create a user import file. Extract this compressed file (examples.tar) and locate the file importUsers.csv. This is the template file used to populate the required user details to import into NCM. As an example, we will create a new user named John Murphy, who currently does not exist within the NCM application, Figure 3. Before adding users, remove all fields for the example users shown in Figure 2:
Figure 2
Figure 3
Once the importUsers.csv file is created with the required details above (saved in the existing format), browse to <VOYENCE_HOME>/tools/bulk-import and run the bulk-import utility using an NCM Administrator account such as the sysadmin user, Figure 4:
Figure 4:
To import the new user(s) into NCM using the importUsers.csv file you have created, enter the command importUsers <FILENAME>. Results will show the number of records imported and any records that may have failed, Figure 5. Type exit to leave the bulk-import utility:
Figure 5:
Note: In the above screenshot it reports that only one of two records was imported. This is due to the empty row 2 which must be left blank.
Now open the NCM application, go to System Administration (press F4) - Global - User Management - System Users.
Here you will see the new user(s) imported from the importUsers.csv file as per the example below, Figure 6:
Figure 6:
This can be a convenient way to import a large number of user accounts and can be used later to make amendments to existing user accounts.
Feedback
Yes
No
Powered by
