Versions Compared

Old Version 3

changes.mady.by.user user-9f5ec

Saved on

compared with

New Version 4

changes.mady.by.user user-9f5ec

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Adding to this table one record at a time can be a slow process, but if you have a list of all the sys_id's then this process can be remarkably sped up by utilizing ServiceNow's Import a translation from an Excel spreadsheet function.

Prerequisites

(warning) First, you will need to create a bulk share without executing it

(warning) Then, enable share only sys_ids listed

Procedure

To quickly add records to the u_psp_bulk_share_sys_id table, follow these steps:


UI Steps


UI Step

First, you will need to create an Excel spreadsheet with the following format:

Save the Excel spreadsheet.

(info) NOTE: Notice that the Bulk Share column uses the display name of the bulk share instead of the sys_id. The record will not be created correctly if you use the sys_id of the bulk share.


UI Step

Navigate to the u_psp_bulk_share_sys_id table in ServiceNow by typing "u_psp_bulk_share_sys_id.list" in the navigation bar and hit enter.


UI Step

Right click the top of the table and click "Import"


UI Step

You will be brought to the following screen where you will click "Choose File" and select the Excel sheet you made in step 1. Once you've selected the file, click Upload.


UI Step

Click "Preview Imported Data"


UI Step

Finally, click Complete Import and your u_psp_bulk_share_sys_id table will be populated with the records listed in the Excel spreadsheet



For more information, contact Perspectium Support.



Similar topics

Content by Label
showLabelsfalse
max5
showSpacefalse
cqllabel = "bulk-share" and space in (currentSpace(),"gold","fluorineplus")

Contact Perspectium Support

Image ModifiedUS: 1 888 620 8880

UK: 44 208 068 5953

support@perspectium.com