Layton ServiceDesk - Utilities - Import End User (CSV & TXT)
m (Jpainter moved page Layton ServiceDesk™ - Utilities - Import End User (CSV & TXT) to Layton ServiceDesk - Utilities - Import End User (CSV & TXT): Removed the TM symbol for a cleaner URL) |
m (Updated links) |
||
Line 1: | Line 1: | ||
+ | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> | ||
+ | __FORCETOC__ | ||
=Overview= | =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. | 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. | ||
− | To import the End Users you must copy the file into the HB_Data/Import sub folder in Layton | + | To import the End Users you must copy the file into the HB_Data/Import sub folder in Layton ServiceDesk(LaytonServiceDesk\HB_Data\Import). You can then start the import process by clicking '''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. | 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. | ||
Line 14: | Line 16: | ||
Here is an example of the contents of an import tab-delimited text file: | Here is an example of the contents of an import tab-delimited text file: | ||
− | Username Password | + | Username Password Forename Surname Phone Fax Email Department Site |
user1 mib user 1 1234567 1234568 [email protected] IT Dept Head Office | user1 mib user 1 1234567 1234568 [email protected] IT Dept Head Office | ||
user2 mib user 2 1234567 1234568 [email protected] | user2 mib user 2 1234567 1234568 [email protected] | ||
Line 30: | Line 32: | ||
user4,mib,user,4,1234567,1234568,[email protected],, | user4,mib,user,4,1234567,1234568,[email protected],, | ||
user5,mib,user,5,1234567,1234568,[email protected],, | user5,mib,user,5,1234567,1234568,[email protected],, | ||
+ | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk]] [[User Guide for Layton ServiceDesk|<u>Back to Contents</u>]]</p> |
Revision as of 05:17, 10 October 2016
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.
To import the End Users you must copy the file into the HB_Data/Import sub folder in Layton ServiceDesk(LaytonServiceDesk\HB_Data\Import). You can then start the import process by clicking 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.
Examples
Tab-Delimited Text File (.txt Extension)
Here is an example of the contents of an import tab-delimited text file:
Username Password Forename Surname Phone Fax Email Department Site user1 mib user 1 1234567 1234568 [email protected] IT Dept Head Office user2 mib user 2 1234567 1234568 [email protected] user3 mib user 3 1234567 1234568 [email protected] user4 mib user 4 1234567 1234568 [email protected] user5 mib user 5 1234567 1234568 [email protected]
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 user1,mib,user,1,1234567,1234568,[email protected],IT Dept,Head Office user2,mib,user,2,1234567,1234568,[email protected],, user3,mib,user,3,1234567,1234568,[email protected],, user4,mib,user,4,1234567,1234568,[email protected],, user5,mib,user,5,1234567,1234568,[email protected],,