Layton ServiceDesk - Utilities - Import End User (CSV & TXT)
Contents |
Overview
The Import End User .CSV .TXT utility provides a means to import a large number of end users from a tab-delimited text file or a CSV (comma-separated-values) file. This is an alternative to LDAP (Active Directory) import.
File Structure
The first row of the data file contains the names of the columns. This is required, as it is used in identifying the columns to be mapped.
These are the most common columns, although the file does not need to contain all of these:
Username | Password | Forename | Surname | Phone | Fax | Department | Site |
---|
The column that will be mapped to the field sys_eusername must be unique. This will be the username and is the primary key for the End User table.
If there is no data for a column, it can be left null.
Examples
Tab-Delimited Text File (.txt Extension)
Here is an example of the contents of a tab-delimited text file:
Username Password Forename Surname Phone Fax Email Department Site Alexandra OBrien mib Alexandra O'Brien 123 456 7890 123 456 0987 [email protected] ACME Services/Services ACME Services/New York bblingo mib Bart Blingo 123 456 7891 123 456 0986 [email protected] ACME Services/Sales ACME Services/New York bwithers mib Bill Withers 123 456 7892 123 456 0985 [email protected] ACME Services/Sales ACME Services/Los Angeles Daniel Cheung mib Daniel Cheung 123 456 7893 123 456 0984 [email protected] ACME Services/Services ACME Services/New York Elizabeth Pearson mib Elizabeth Pearson 123 456 7894 123 456 0983 [email protected] ACME Services/Sales ACME Services/New York
Comma-Delimited Text File (.csv Extension)
Here is an example of the contents of an comma-delimited text file:
Username,Password,Forename,Surname,Phone,Fax,Email,Department,Site Alexandra OBrien,mib,Alexandra,O'Brien,123 456 7890,123 456 0987,[email protected],ACME Services/Services,ACME Services/New York bblingo,mib,Bart,Blingo,123 456 7891,123 456 0986,[email protected],ACME Services/Sales,ACME Services/New York bwithers,mib,Bill,Withers,123 456 7892,123 456 0985,[email protected],ACME Services/Sales,ACME Services/Los Angeles Daniel Cheung,mib,Daniel,Cheung,123 456 7893,123 456 0984,[email protected],ACME Services/Services,ACME Services/New York Elizabeth Pearson,mib,Elizabeth,Pearson,123 456 7894,123 456 0983,[email protected],ACME Services/Sales,ACME Services/New York
Column Mapping
Text File Header | euser Table Column |
---|---|
Username | sys_eusername |
Password | sys_euserpwd |
Forename | sys_forename |
Surname | sys_surname |
Phone | sys_phone |
Fax | sys_fax |
sys_email | |
Department | sys_eclient_id |
Site | sys_siteid |
Procedure
1. Enter all your Departments and Sites. If this step is not done first, the import will fail, as it needs to match the import file against these.
2. Copy the file to:
C:\Program Files (x86)\Layton Technology\Layton ServiceDesk\HB_Data\Import
3. Go to Administration > Utilities > Import End User .CSV .TXT.
4. All the files in the import folder will be listed, including sampleusersimport.txt, which is a sample file created on installation. Click the one you wish to import.
5. Map each column from the file to a field in the End User table. This includes user-defined fields. Note that department maps to sys_eclient_id:
6. Click the Save button .
7. On completion, the system will display a report. If the license limit is exceeded, the import will not be permitted. In this case, contact Layton Technology for a new license key to increase the number of end user licenses.
8. Click the Close button to close the dialog.