/build/static/layout/Breadcrumb_cap_w.png

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.


0 Comments   [ + ] Show comments

Answers (3)

Posted by: gcarpenter 11 years ago
Green Belt
2

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:
Posted by: jdornan 11 years ago
Red Belt
1

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.

Posted by: jverbosk 11 years ago
Red Belt
1

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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ