Jeff
Do you also need to set passwords for local users? Or just create accounts?
Updating users table probably the way to accomplish it.
You can build SQL query for each user using Excel (or parse input file via
perl).
INSERT INTO user
(unityid, affiliationid, firstname, lastname, email, lastupdated)
VALUES
('$username', (SELECT id FROM affiliation WHERE name LIKE 'Local'),
'$first_name', '$last_name', '$email_address', NOW())
If you need to set passwords - it's more complicated, as you will need encrypt
passwords using sha1 and add salt - this will require to use perl/php to parse
file and update DB.
--
Thank you,
Dmitri Chebotarov
VCL Sys Eng, Engineering & Architectural Support, TSD - Ent Servers & Messaging
223 Aquia Building, Ffx, MSN: 1B5
Phone: (703) 993-6175 | Fax: (703) 993-3404
From: Jeffrey Kirby <[email protected]<mailto:[email protected]>>
Reply-To: "[email protected]<mailto:[email protected]>"
<[email protected]<mailto:[email protected]>>
Date: Tuesday, September 3, 2013 11:33
To: "[email protected]<mailto:[email protected]>"
<[email protected]<mailto:[email protected]>>
Subject: Re: User administration
Paste at what root prompt? The method I'm finding in docs say to run
/pathto/vcld -setup and then start typing numbers to get through the menu tree
and enter information by hand. I'd much rather do something like
/pathto/vcld -setup < loaduser.csv
Alternately, I can throw it into mysql (which I'm guessing is the root prompt
of which you speak), but is the only place I have to do it in VCL.user? What
are the required values? Is it just unityid, firstname, lastname, email,
adminlevel, and lastupdate? Is there a place where this is documented that I'm
just not finding?
Thanks!
jeff
From: Larry Burton
<[email protected]<mailto:[email protected]>>
To: [email protected]<mailto:[email protected]>,
Date: 09/03/2013 11:15 AM
Subject: Re: User administration
________________________________
Create a spreadsheet with columns for first name, last name, password. Use the
substring functions to create a username. Finally, use the concatenate function
to create the useradd command. Extend the first line down, add the rest of your
users. Copy the useradd column into a text file, or just paste at a root
prompt. If you already have a CSV file, you can just create the useradd column.
Not a single click, but works well to add a lot of local users.
Larry
On 09/03/2013 10:54 AM, Jeffrey Kirby wrote:
I'm feeling stupid. We have a v2.2 VCL running. I need to add a lot of users
to it. We authenticate to Jasig CAS. Still, the procedure is to add local
users. Is there any way to batch load users froma CSV or am I stuck adding one
at a time through vcld -setup? I'm not seeing anything in any docs anywhere.
Thanks
jeff
