Importing user entries from a CSV file

Data Security Manager Help | TRITON AP-DATA | Version 8.1.x

User directories can be in comma-separated values (CSV) files. You have the option to import user directory entries from such files. To do that, you must generate a set of files in a specific structure.

Create 3 text files named computers.csv, users.csv, and groups.csv. See CSV file formatting for details on the format.

Click New in the User Directory Servers toolbar.

Select CSV File in the Type field.

Enter the path of the CSV files.

Enter a user name and a password with access to this directory.

Click OK.

Each time you want to import user, group, or computer data from the CSV files, go to Settings > General > User Directories and click Import Now on the menu bar. For CSV directories, you cannot schedule automatic synchronization.

CSV file formatting

When you create your CSV user directory files, ensure that these conditions are met:

Encoding:

Use the UTF-8 character set or use a character set that is supported by its JVM installation.

Separate fields using commas.

End each record with a line feed or carriage return/line feed.

Escaping and quotes:

Enclose fields that contain a special character (semicolon, new line, or double quote) in double quotes.

If a field's value contains a double-quote character, escape it by placing another double-quote character next to it.

Omit optional fields and replace them with the delimiter.

When a field contains a list, separate the list elements using a semicolon (;) and enclose the entire field in double quotes, unless the list contains 1 element or none.

Groups file format

Each row in the groups.csv file should contain:


Name	Data Type	Optional	Description
UUID	String	No	The record's universal unique identifier
Name	String	No	Group name
Description	String	Yes	Description
memberOf	List of UUID	Yes	UUIDs of which this group is a member (can be empty)

For example:

08b3b46b-3631-46cb-adc7-176c2871e94c,Marketing - EMEA, Marketing department,7c9d4db6-1737-4b80-9e6e-42f415300a05

40632a33-db39-4f93-bd80-093e0b3230ca,Marketing - APAC, Marketing department,7c9d4db6-1737-4b80-9e6e-42f415300a05

7c9d4db6-1737-4b80-9e6e-42f415300a05,Marketing all,All Marketing departments

Users file format

Each row in the users.csv file should contain:


Name	Data Type	Optional	Description
UUID	String	No	The record's universal unique identifier
Name	String	No	User name
Email	String	Yes	Email address (primary)
Description	String	Yes	Description
UUID	String	Yes	UUID of the current user's manager
memberOf	List of UUID	Yes	UUIDs of which this group is a member (can be empty)
Zero or more "additional attributes" fields	String	Yes	See "Additional Attributes" below

Additional attributes

User records can have additional attributes attached. The additional attributes are name value pairs containing information that you might want attached to users. Some of these attributes have predefined names (see below). A file containing an additional attribute should be defined as a regular expression of the following format:

[aA][tT][tT][rR]:(.+)/=/(.+)

You can choose to use any name you wish for custom attributes; they will be stored as an associated array on the user object and are used only for display. However, the following includes a well-known list of attribute names:

wbsn_proxy_address - secondary (alternative) email address

wbsn_nt_domain\wbsn_login_name - the user login name (principal name on Windows-based systems)

wbsn_full_name - the user's display name

wbsn_department - department

wbsn_telephone_number - the user's telephone number

wbsn_title - the user's title

wbsn_mailbox_store - the server on which the user's Exchange mailbox is stored

The table below illustrates some attributes:


String	Name	Value
attr:wbsn_title/=/Manager	wbsn_title	Manager
aTTr:my amazing attr/=/the value	my amazing attr	the value
"ATTR:name/=/value1,value2"	name	value1,value2

For example:

6278ab76-2ce2-4f16-8e49-aa5104da7d0b, jdoe-mgr, jdoe.manager@example.com,CEO,7c9d4db6-1737-4b80-9e6e-42f415300a05,attr:room/=/201,attr:parkingSpace/=/1

ff255105-4e43-4e9a-b2bd-e366872cd212, jdoe, jdoe@example.com, administrator, 6278ab76-2ce2-4f16-8e49-aa5104da7d0b,"08b3b46b-3631-46cb-adc7-176c2871e94c;7c9d4db6-1737-4b80-9e6e-42f415300a05",attr:room/=/101

Computers file format

Each row in computers.csv should contain:


Name	Data Type	Optional	Description
UUID	String	No	The record's universal unique identifier
Name	String	No	Computer name (hostname)
FQDN	String	Yes	DNS fully qualified domain name
Description	String	Yes	Description
memberOf	List of UUID	Yes	UUIDs of which this group is a member (can be empty)

For example:

379a287f-0a5c-40ff-85fd-fae3da462d03,gumby, gumby.example.com, print server,"7c9d4db6-1737-4b80-9e6e-42f415300a05"