How do I import my users via Excel?
I use the KACE system to manage my equipment at my customers locations across the contry. My users are my clients that I have in an Excel spreadsheet. They are not in my LDAP.
Answers (3)
There *might be* a method to import users from an Excel sheet into KACE.
First, you save the excel file as a CSV file.
LOAD DATA LOCAL INFILE 'useraccounts.csv' INTO TABLE ORG1.USER FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' (id, user_name, password, email, full_name) or whatever other fields you want.
This will get the data into your database, but I'm not sure if it'll work out as well as you planned.
Comments:
-
Much appreciated. - tthomson@miracals.com 12 years ago
There is no method to import users into KACE other than LDAP.
It may be possible through a custom ticket rule but not a point and click interface.
Some more info on possiblities with the custom ticket process:
http://www.itninja.com/question/importing-users-from-a-csv-file-into-a-software-group
John
