Import File Samples
You can import your resource, user, organization, or personal details into the PAM360 database as CSV, TSV, or Excel files.
- The imported CSV files should have consistent lines, the same number of fields, and comma-separated entries.
- The imported TSV files should have even lines, equal number of fields, and tab-separated values. Allowed extensions are .txt and .tsv.
- Excel files should have consistent values separated by cells. Allowed extensions are .xls and .xlsx.
For user import, apart from standard details such as First Name, Last Name, User Name, Email Address, Department, Location, etc., you can also enable/disable Two-Factor Authentication for specific users by adding an additional text Enable/Disable.
Import Resources
#Resource Name | User Account | Password | Description | DNS Name | Department | Location | OS Type | Resource Type | Resource URL | Description | Distinguished Name |
---|---|---|---|---|---|---|---|---|---|---|---|
chtmkt-john-lt |
JohnM |
u4KM#&DU#9P8ZJND |
Office Laptop |
192.168.176.1 |
Marketing |
Chennai |
Windows |
Windows |
https://john-mathew:8282 |
Head of Marketing |
JohnM |
chtmkt-matt-pc |
MattH |
I#Uv4B0vpT5 |
Personal Computer |
192.168.178.4 |
Sales |
Chennai |
Linux |
Linux |
https://matt-hardy:8282 |
Sales Auditor |
MattH |
chtmkt-john-lt, JohnM, u4KM#&DU#9P8ZJND, Office Laptop, 192.168.176.1, Marketing, Chennai, Windows, Windows, https://john-mathew:8282, Head of Marketing, JohnM
chtmkt-matt-pc, MattH, I#Uv4B0vpT5, Personal Computer, 192.168.178.4, Sales, Chennai, Linux, Linux, https://matt-hardy:8282, Sales Auditor, MattH
#Resource Name User Account Password Description DNS Name Department Location OS Type Resource Type Resource URL Description Distinguished Name chtmkt-john-lt JohnM u4KM#&DU#9P8ZJND Office Laptop 192.168.176.1 Marketing Chennai Windows Windows https://john-mathew:8282 Head of Marketing JohnM chtmkt-matt-pc MattH I#Uv4B0vpT5 Personal Computer 192.168.178.4 Sales Chennai Linux Linux https://matt-hardy:8282 Sales Auditor MattH
Import Users
#First Name | Last Name | Username | E-Mail Address | Password | Department | Location | Two-Factor Authentication | RSA SecurID Username | RADIUS Username | PhoneFactor Username | Landline Phone Country Code | Landline Phone Number | Landline Phone Extension | Mobile Country Code | Mobile Number | Primary Contact |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
John |
Mathew |
JohnM |
John.Mathew@gmail.com |
u4KM#&DU#9P8ZJND |
Marketing |
Chennai |
Enable |
JohnM |
John |
Mathew |
John.Mathew@gmail.com |
44 |
90009000 |
001 |
91 |
9010901090 |
Matt |
Hardy |
MattH |
Matt.Hardy@gmail.com |
I#Uv4B0vpT5 |
Sales |
Chennai |
Disable |
MattH |
Matt |
Hardy |
Matt.Hardy@gmail.com |
44 |
80007000 |
002 |
91 |
8710872010 |
John, Mathew, JohnM, John.Mathew@gmail.com, u4KM#&DU#9P8ZJND, Marketing, Chennai, Enable, JohnM, JohnM, JohnM, 44, 90009000, 001, 91, 9010901090, JohnMathew
Matt, Hardy, MattH, Matt.Hardy@gmail.com, I#Uv4B0vpT5, Sales, Chennai, Disable, JohnM, JohnM, JohnM, 44, 80007000, 002, 91, 8710872010, MattHardy
#First Name Last Name Username E-Mail Address Password Department Location Two-Factor Authentication RSA SecurID Username RADIUS Username PhoneFactor Username Landline Phone Country Code Landline Phone Number Landline Phone Extension Mobile Country Code Mobile Number Primary ContactJohn Mathew JohnM John.Mathew@gmail.com u4KM#&DU#9P8ZJND Marketing Chennai Enable JohnM JohnM JohnM 44 90009000 001 91 9010901090 JohnMathew Matt Hardy MattH Matt.Hardy@gmail.com I#Uv4B0vpT5 Sales Chennai Disable JohnM JohnM JohnM 44 80007000 002 91 8710872010 MattHardy
Import Organization
#Organization Name | Display Name | Account Manager | Department | Location | City | State / Province | Country | Country Code |
---|---|---|---|---|---|---|---|---|
MSP |
MSPCorp |
JohnM |
Marketing |
Chennai |
Chennai |
TN |
India |
IN |
Zoho |
ZohoCorp |
MattH |
Sales |
Chennai |
Chennai |
TN |
India |
IN |
MSP, MSPCorp, JohnM, Marketing, Chennai, Chennai, TN, India, IN
Zoho, ZohoCorp, MattH, Sales, Chennai, Chennai, TN, India, IN
#Organization Name Display Name Account Manager Department Location City State / Province Country Country CodeMSP MSPCorp JohnM Marketing Chennai Chennai TN India IN Zoho ZohoCorp MattH Sales Chennai Chennai TN India IN
Import Personal Data
#Login Name | Password | Service Name | Service URL | Tags |
---|---|---|---|---|
JohnM |
u4KM#&DU#9P8ZJND |
John_Mathew |
https://john-mathew:8282 |
PasswordManagerPro |
MattH |
I#Uv4B0vpT5 |
Matt_Hardy |
https://matt-hardy:8282 |
PasswordManagerPro |
#Account Number | Address | Bank Contact | Bank Name | Branch Name | Phone Number | Tags |
---|---|---|---|---|---|---|
123456789012 |
12, Main Street |
John Mathew |
National Bank |
George Town |
+91 (723) 123-4567 |
Loan |
987654321098 |
46, 2nd Street |
Matt Hardy |
State Bank |
Saint Park |
+91 (945) 555-1212 |
Business |
#Card Name | Card Number | Card Type | Phone Number | Pin Code | Tags |
---|---|---|---|---|---|
John Mathew |
1234 5678 9123 |
Visa |
+91 (723) 123-4567 |
600234 |
Personal Account |
Matt Hardy |
9876 5432 1098 |
Mastercard |
+91 (945) 555-1212 |
600078 |
Business Account |
#Address | Contact Name | Date of birth | Mobile Number | Organization | Phone Number | Tags | |
---|---|---|---|---|---|---|---|
12, Main Street |
John Mathew |
01/01/1999 |
John.Mathew@gmail.com |
9010901090 |
MSP Corp |
+91 (723) 123-4567 |
Marketing |
46, 2nd Street |
Matt Hardy |
15/5/1999 |
Matt.Hardy@gmail.com |
8710872010 |
Zoho Corp |
+91 (945) 555-1212 |
Sales |
JohnM, u4KM#&DU#9P8ZJND, John_Mathew, https://john-mathew:8282, PasswordManagerPro
MattH, I#Uv4B0vpT5, Matt_Hardy, https://matt-hardy:8282, PasswordManagerPro
123456789012, 12 Main Street, John Mathew, National Bank, George Town, +91 (723) 123-4567, Loan
987654321098, 46 Elm Street, Matt Hardy, State Bank, Saint Park, +91 (945) 555-1212, Business
John Mathew, 1234 5678 9123, Visa, +91 (723) 123-4567, 600234, Personal Account
Matt Hardy, 9876 5432 1098, Mastercard, +91 (945) 555-1212, 600078, Business Account
12 Main Street, John Mathew, 01/01/1999, John.Mathew@gmail.com, 9010901090, MSP Corp, +91 (723) 123-4567, Marketing
46 2nd Street, Matt Hardy, 15/5/1999, Matt.Hardy@gmail.com, 8710872010, Zoho Corp, +91 (945) 555-1212, Sales
#Login Name Password Service Name Service URL TagsJohnM u4KM#&DU#9P8ZJND John_Mathew https://john-mathew:8282 PasswordManagerPro MattH I#Uv4B0vpT5 Matt_Hardy https://matt-hardy:8282 PasswordManagerPro
#Account Number Address Bank Contact Bank Name Branch Name Phone Number Tags123456789012 12 Main Street John Mathew National Bank George Town +91 (723) 123-4567 Loan 987654321098 46 Elm Street Matt Hardy State Bank Saint Park +91 (945) 555-1212 Business
#Card Name Card Number Card Type Phone Number Pin Code TagsJohn Mathew 1234 5678 9123 Visa +91 (723) 123-4567 600234 Personal Account Matt Hardy 9876 5432 1098 Mastercard +91 (945) 555-1212 600078 Business Account
#Address Contact Name Date of birth Email Mobile Number Organization Phone Number Tags12 Main Street John Mathew 01/01/1999 John.Mathew@gmail.com 9010901090 MSP Corp +91 (723) 123-4567 Marketing 46 2nd Street Matt Hardy 15/5/1999 Matt.Hardy@gmail.com 8710872010 Zoho Corp +91 (945) 555-1212 Sales