Layton ServiceDesk - Utilities - Import End User (CSV & TXT)

From Layton Support
Jump to: navigation, search

Btn back up.png Back to Contents

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.

Lsd admin util import file 01.png

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

Download a copy.

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

Download a copy.

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

    Lsd admin util import file 02.png

  6. Click the Save button Lsd btn save.png.
  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.

    Lsd admin util import file 03.png

  8. Click the Close button Lsd btn cancel 24px.png to close the dialog.

Btn back up.png Back to Contents

Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox