SPP allows you to import a .csv file containing a set of accounts, assets, or users. A .csv template for import can be downloaded when you click  Import from the toolbar then click Download Template. The hard limit on file size 100 MiB. For more information, see Creating an import file.

To import Assets and Users

  1. Navigate to Assets or Users based on what data you are importing.

  2. Click Import from the toolbar.

  3. In the Import dialog, click Import to select an existing .csv file containing a list of objects to import.

  4. Click OK. SPP imports the objects into its database. The dialog will update as the import progresses and will alert you should any errors be found.

To import Accounts

  1. Navigate to Accounts.

  2. Click  Import from the toolbar.

    When importing accounts, you can import accounts, passwords and SSH keys separately. In this case, the Import button works as a drop-down. First, you need to import accounts. Select Import Accounts.

    Then, depending on what data you want to import, select Import Passwords or Import SSH Keys.

  3. In the Import dialog, click Import to select an existing .csv file containing a list of objects to import.

  4. Click OK. SPP imports the objects into its database. The dialog will update as the import progresses and will alert you should any errors be found.

When importing Starling User accounts from Microsoft Azure Active Directory (AAD), there are some expected differences.

For Starling type Identity Provider required fields are:

  • Name: This must have an entry of the user UserPrincipalName. Any other entry will be overwritten.

  • PrimaryAuthenticationProvider/Name: This will be the Starling provider name.

  • PrimaryAuthenticationProvider/Identity: This is the AAD user Id.

  • IdentityProvider/Name: This tells the import what type of user to import.

The following fields will be populated from the AAD user properties. An entry for these fields in the CSV import file will be overwritten by the information from AAD.

  • FirstName

  • LastName

  • EmailAddress

  • MobilePhone

  • WorkPhone

For more information about asset creation, see Adding an asset.