ldap vs spreadsheet import for user creation

Asked by Richard Bychowski on 2014-07-25

I am setting up a new school. LDAP is not completely set up yet, but I intend to have LDAP as the primary user creation for staff.

Until I get the LDAP worked out, I'd like to start importing users through a spreadsheet.

How do I import users through a spreadsheet, AND be sure that my subsequent LDAP users will map to the correct SchoolTool user?

Or should I NOT try to create new users by spreadsheet that are to be created later by LDAP?


Question information

English Edit question
SchoolTool Edit question
No assignee Edit question
Last query:
Last reply:
Tom Hoffman (tom-hoffman) said : #1

I'll follow up with our LDAP gurus, but basically it should mostly be dependent on making sure you have the usernames consistent between the two.

Tom is correct, making sure usernames in the spreadsheet match the LDAP usernames exactly is sufficient, and you can start importing SchoolTool users.

SchoolTool LDAP auth works by querying LDAP directory for users that have a specific attribute equal to SchoolTool username/login. You can set the attribute to query in schooltool.conf.

If you'd rather take a safe path, you can delay the import:
- configure LDAP first
- experiment with SchoolTool configuration until you successfully log in with at least one user
- check if spreadsheet username matches the one you logged in with
- update spreasheet if neccessary
- finally, import

P.S.: Just in case, if by any chance you missed the section in SchoolTool book, this might help: http://book.schooltool.org/ldap.html

Tom Hoffman (tom-hoffman) said : #3

Thanks Justas! Ah, the book!

Can you help with this problem?

Provide an answer of your own, or ask Richard Bychowski for more information if necessary.

To post a message you must log in.