By: Ezequiel Sandoval user 12 Nov 2016 at 12:44 p.m. CST

6 Responses
Ezequiel Sandoval gravatar
Hi Community, I want to ask, if there is any possibility to do an import with XLS files with more parameters than the ones showed on https://gluu.org/docs/user-management/xlsfile/ (Username, First Name, Last Name, Email). I saw under 'Configuration -> JSON Configuration -> OXTrust Import Person Configuration' some parameters that can work, but when i add parameters, nothing happens on the import xls. Should i configure something more in order to import users with more parameters from xls? I don't want to put the customer in a situation like 'develop his own import module with scim'. And would be great to find a cool solution like xls import for him. thanks so much!

By Mohib Zico staff 12 Nov 2016 at 12:56 p.m. CST

Mohib Zico gravatar
I think we need to do some testing on this issue.

By Michael Schwartz Account Admin 12 Nov 2016 at 4:57 p.m. CST

Michael Schwartz gravatar
"massive import from XLS file" is a bad idea. This feature is for 100 users or so for a small organization... For a large import, you should genereate LDIF, and use slapdd (openldap) or import-ldif (OpenDJ).

By Kannan Venkataraman user 23 May 2019 at 11:34 p.m. CDT

Kannan Venkataraman gravatar
Hi, I am looking at a similar requirement where I need to import millions of users from a MySQL database. Can you please elaborate on this. Has there been any further enhancements on how to go about this ?

By Michael Schwartz Account Admin 24 May 2019 at 4:13 a.m. CDT

Michael Schwartz gravatar
Maybe read chapter two of my book: https://gluu.co/book

By Kannan Venkataraman user 24 May 2019 at 7:16 a.m. CDT

Kannan Venkataraman gravatar
Is There any other way I can get the information, without having to buy that book? Regards, V. Kannan +91 988 400 2190 Venba Information Technology Pvt Ltd., http://www.venbainfotech.com/> Confidentiality Notice: This message is private and may contain confidential and proprietary information. If you have received this message in error, please notify us and remove it from your system and note that you must not copy, distribute or take any action in reliance on it. Any unauthorized use or disclosure of the contents of this message is not permitted and may be unlawful.

By Michael Schwartz Account Admin 24 May 2019 at 8:04 a.m. CDT

Michael Schwartz gravatar
Read the [RFC on LDIF](https://tools.ietf.org/html/rfc2849) and write a script to generate it properly. Also look hard at the ldap data under `ou=people,o=(org-inum),o=gluu` and make sure the data that you generate is consistent with that.