---
title: SAPM Accounts Bulk Import 
slug: singleconnect-reference-guide-3-1-0/sapm-accounts-bulk-import
description: Learn how to easily add multiple SAPM accounts to Single Connect with this comprehensive document. Discover step-by-step instructions on navigating the Bulk Import screen, downloading the Excel template file, and filling it with the required SAPM account 
docTags: 
createdAt: 2022-07-29T13:14:33.000Z
---

You can add SAPM Accounts in bulk to Single Connect by following the steps below:

1. Navigate to **SAPM Management** > **Bulk Import screen**.
2. Click **Download Template**. An Excel file named SAPMAccountBulkImportTemplate is downloaded.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/LYvVTCpw5GQvvNTfaTZOo_image.png "Uploading Bulk Import File")

1. Open the template file and enter SAPM account information as described in the column descriptions. Save the template file on your computer.
2. On the **Bulk Import** screen, clic&#x6B;**&#x20;Browse** and select the template file you saved.
3. Clic&#x6B;**&#x20;Upload File** to add the SAPM accounts list to the **Parse Results** section on the **Bulk Import** screen.
4. Click **Import SAPM Accounts**.

You added the SAPM accounts. However, the passwords will change next time the SAPM Password Change job runs again.

![](https://api.archbee.com/api/optimize/g9cApVza9NIhSh0pjZYtA/ALNP886DJ8KGdbFCQDR6Z_image.png "Bulk Import result screen")

**SAMP Account Bulk Import Template Column Descriptions**

| **Column**            | **Required/Optional** | **Description&#x20;**                                                                                                                                                                                                  |
| --------------------- | --------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| No                    | Required              | No refers to the row number.&#xD;<br />&#xD;Enter each account in a separate row.&#xD;                                                                                                                                 |
| Secret Type           | Required              | Secret Type indicates whether the account is Static or Dynamic.&#xD;<br />&#xD;Select Dynamic or Static from the combo box. Password rotation occurs for Dynamic accounts.&#xD;                                        |
| IP Adress/Hostname    | Optional              | Enter the IP Address / Hostname where the account exists. Not mandatory if the Static Strategy is selected.&#xD;<br />&#xD;You must select the IP address of a device that is already defined in the application.&#xD; |
| Secret Name           | Required              | All accounts to be managed must have a name.&#xD;<br />&#xD;Enter a name; this name will appear in the application.&#xD;                                                                                               |
| SAPM Group            | Optional              | Enter a group for the account to be managed through the specified group. &#xD;<br />&#xD;The account does not have to be in the specified group.&#xD;                                                                  |
| SAPM Configuration    | Required              | Select SAPM configuration from the pre-defined values. &#xD;<br />&#xD;SAPM Configuration combo box will also list the user-defined configurations.&#xD;                                                               |
| SAPM Account Username | Required              | Enter SAPM account user name.&#xD;<br />&#xD;It is important to write the username on the device correctly if you didn’t select a configuration with Static Strategy in the SAPM Configuration field.&#xD;             |
| SAPM Account Password | Required              | Enter SAPM account password.                                                                                                                                                                                           |
| Change Period (day)   | Required              | Enter password change frequency in days.                                                                                                                                                                               |
| Permissions           | Optional              | Enter the Permissions field as follows: \{UserGroupA=FULL\_CONTROL,UserGroupB=READ\_ONLY}                                                                                                                              |
| Passphrase            | Optional              | Enter the SSH passphrase if SSH Key Configuration is selected in the SAPM Configuration.                                                                                                                               |
| Private Type          | Required              | Private accounts cannot be seen by other users<br />in the same user group. Select Yes to set the SAPM account private.                                                                                                |
| Owner                 | Required              | Enter the owner’s username. Each account has one user ownership. Owners should be selected from existing users.                                                                                                        |
| Description           | Optional              | Enter SAPM account description.                                                                                                                                                                                        |
