import VIP users

[Ralton Stewart]

Hello All I have been given a list of over 200 VIP's that need to be enabled how can I do this in bulk, also we tend to have a few VIP's added almost weekly is there a way to automate the process please?

[Community Alums · Accepted solution]

Hi @Ralton Stewart ,

To import VIP users in bulk in ServiceNow, you can follow these steps:

1. Create a CSV file with the following columns: First Name, Last Name, Email, and any other necessary fields for your organization.

2. Save the file in CSV format and ensure that it is saved in a location that you can access from the ServiceNow instance.

3. Navigate to "System Import Sets" in the navigator and select "Data Sources".

4. Click on "New" to create a new data source and specify the following information:

• Name: Enter a name for the data source.
• File: Click on the magnifying glass icon to select the CSV file you created in Step 1.
• Format: Select "Comma-separated" as the file format.
• Character Encoding: Select the appropriate character encoding for your file.
• Header Rows: Enter "1" to indicate that the first row contains column headers.

5. Click on "Submit" to create the data source.

6. Once the data source is created, navigate to "System Import Sets" again and select "Import Sets".

7. Click on "New" to create a new import set and specify the following information:

• Name: Enter a name for the import set.
• Table Name: Select the table where you want to import the data (e.g. VIP Users [sn_vip_user]).
• Data Source: Select the data source you created in Step 4.
• Format: Select "Comma-separated" as the file format.

8. Click on "Submit" to create the import set.

9. In the "Import Set" form, click on "Load Data" to load the data from the CSV file into the import set.

10. Once the data is loaded, you can map the fields from the CSV file to the corresponding fields in the target table.

11. Click on "Transform Map" to open the transform map form, and specify the following information:

• Name: Enter a name for the transform map.
• Target Table: Select the target table where you want to import the data (e.g. VIP Users [sn_vip_user]).
• Source Table: Select the import set table.

12. Map the fields from the import set table to the corresponding fields in the target table.

13. Once the fields are mapped, click on "Run Transform" to transform the data and import it into the target table.

14. Once the import is complete, you can review the imported data in the target table.

That's it! By following these steps, you can import VIP users in bulk into ServiceNow.

[Prince Arora · Accepted solution]

@Ralton Stewart 

There is one more method for doing the same:

1) Add the name and VIP in the list view

2) Copy All the names from the CSV and paste in the ServiceNow filter as "Name isOneOf CopiedNames", it will show you all the results

3) Then select the first record of column "VIP" and shift + downArray, select all the records and change it to true.

If my answer solved your issue, please mark my answer as ✅ Correct & 👍Helpful based on the Impact.

[Community Alums · Accepted solution]

Hi @Ralton Stewart ,

To import VIP users in bulk in ServiceNow, you can follow these steps:

1. Create a CSV file with the following columns: First Name, Last Name, Email, and any other necessary fields for your organization.

2. Save the file in CSV format and ensure that it is saved in a location that you can access from the ServiceNow instance.

3. Navigate to "System Import Sets" in the navigator and select "Data Sources".

4. Click on "New" to create a new data source and specify the following information:

• Name: Enter a name for the data source.
• File: Click on the magnifying glass icon to select the CSV file you created in Step 1.
• Format: Select "Comma-separated" as the file format.
• Character Encoding: Select the appropriate character encoding for your file.
• Header Rows: Enter "1" to indicate that the first row contains column headers.

5. Click on "Submit" to create the data source.

6. Once the data source is created, navigate to "System Import Sets" again and select "Import Sets".

7. Click on "New" to create a new import set and specify the following information:

• Name: Enter a name for the import set.
• Table Name: Select the table where you want to import the data (e.g. VIP Users [sn_vip_user]).
• Data Source: Select the data source you created in Step 4.
• Format: Select "Comma-separated" as the file format.

8. Click on "Submit" to create the import set.

9. In the "Import Set" form, click on "Load Data" to load the data from the CSV file into the import set.

10. Once the data is loaded, you can map the fields from the CSV file to the corresponding fields in the target table.

11. Click on "Transform Map" to open the transform map form, and specify the following information:

• Name: Enter a name for the transform map.
• Target Table: Select the target table where you want to import the data (e.g. VIP Users [sn_vip_user]).
• Source Table: Select the import set table.

12. Map the fields from the import set table to the corresponding fields in the target table.

13. Once the fields are mapped, click on "Run Transform" to transform the data and import it into the target table.

14. Once the import is complete, you can review the imported data in the target table.

That's it! By following these steps, you can import VIP users in bulk into ServiceNow.

[Ralton Stewart]

thank you for this, can this be automated when I get new VIP's weekly?

[Community Alums · Accepted solution]

Hi @Ralton Stewart ,

You can Write a BR with the logic after insert.

[Community Alums]

Hi @Ralton Stewart ,