A CSV file is a text file used to store database entries where each line is a unique record and each record consists of fields of data separated by commas. You must not add any trailing spaces in the properties you define in the CSV file. The easiest way to create a CSV file is by using a spreadsheet program such as Microsoft Excel; however, you can use any text editor, such as Notepad, to create a comma-delineated file, as long as you save the file with a .csv file type extension.
The order of the columns is not important, but the title of the column must match the property name.
To create a customized .csv file template
- In the Import dialog, click CSV Template Assistant.
Select specific template properties from the template properties table, or select the select all check box in the heading. Safeguard for Privileged Passwords preselects the required properties; you can select any additional properties you desire.
Select Download Template to save a copy of the template properties table to a location of your choice.
- Click the View icon in the Values column to display a list of allowable values. Click Copy to copy the selected value to your copy buffer which can then be pasted into your CSV file.
- Click Export Full Table, in upper the right corner above the properties table, to save a copy of the properties table.
Locate the downloaded template and add your specific information to the template.
- Users AdminRoles property: The value for the Authorizer Administrator is "GlobalAdmin".
- Safeguard for Privileged Passwords does not add an object if any column contains invalid data in the .csv file with the follow exceptions:
Note:Safeguard for Privileged Passwords does not add an object if any column contains invalid data in the .csv file with the follow exceptions:
- Assets PlatformDisplayName property.
- If Safeguard for Privileged Passwords does not find an exact match, it looks for a partial match. If it finds a partial match it supplies the <platform> Other platform, such as "Other Linux".
- If it does not find a partial match, it supplies the Other platform type.
- Users TimeZoneId property.
- If Safeguard for Privileged Passwords does not find a valid TimeZoneId property (that is, does not find an exact match or no timezone was provided), it uses the local workstation's current timezone. Do not enter numbers or abbreviations for TimeZoneId.
- Users Password property.
- Safeguard for Privileged Passwords adds a user without validating the password you provide.
- Use the customized .csv file to import the objects.