Layton ServiceDesk - Utilities - Import End User (CSV & TXT)
(New section: "Column Mapping") |
m (Minor text changes) |
||
| Line 27: | Line 27: | ||
Here is an example of the contents of a tab-delimited text file: | Here is an example of the contents of a tab-delimited text file: | ||
| − | Username Password | + | 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 | 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 | bblingo mib Bart Blingo 123 456 7891 123 456 0986 [email protected] ACME Services/Sales ACME Services/New York | ||
Revision as of 23:33, 23 May 2017
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 file. This is an alternative to the LDAP (Active Directory) import and allows you to import the end users from whatever system you have them in.
File Structure
The file must contain the following columns:
| Username | Password | Forename | Surname | Phone | Fax | Department | Site |
|---|
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,Forname,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
To import the End Users you must copy the file to
C:\Program Files (x86)\Layton Technology\Layton ServiceDesk\HB_Data\Import
You can then start the import process by going to Administration > Utilities > Import End User .CSV .TXT.
This will display all the files you have in the import folder. Click on the one you wish to import. You will be shown a screen that allows you map each column to a field in the End User table. This includes any user defined fields that have been created. Click Import to import the End Users.
The importing utility requires that the first row of the data file contains the column header and that the column you map to the field sys_eusername is unique.
When the import runs, the system will give a report on how many rows were processed and how many rows were omitted and how many rows were imported. If the License Limit is exceeded the import will not be permitted. You will need to contact Layton Technology for a new license key to increase the number of end user licenses. A sample import file is located in the program’s Import folder to give an example of how the file should be structured.
