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

Sample File

#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

#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
#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

Sample File

#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

#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, 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 Contact
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

Import Organization

Sample File

#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

#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
#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

Import Personal Data

Sample File

 
#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 Email 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

#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 Elm 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, Email, 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
#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 Elm 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	Email	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
Top