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

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

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