Difficulty importing users from Excel file

By: Michael Dark user 27 Aug 2021 at 10:09 a.m. CDT

5 Responses
Michael Dark gravatar
I'm having a hard time importing users from an Excel file. I've got a file I can upload and get no errors when I click Validate: Username | First Name | Last Name | Email | User Status | Password -- | -- | -- | -- | -- | -- michael.james.dark | Michael | Dark | michael.james.dark@gmail.com | active | root@123 test92 | test92 | test92 | test92@test.com | inactive | root@321 However, the users never show up afterwards. oxtrust.log: 2021-08-27 14:53:07,553 INFO [qtp222511810-18] [org.gluu.oxtrust.service.ConfigurationService] (ConfigurationService.java:265) - Starting App version 4.2.3.Final 2021-08-27 14:59:03,817 ERROR [qtp222511810-17] [org.gluu.util.properties.FileConfiguration] (FileConfiguration.java:81) - Failed to load '/etc/gluu/conf//gluuImportPerson.properties' configuration file from resources 2021-08-27 14:59:12,731 INFO [qtp222511810-20] [org.gluu.oxtrust.action.PersonImportAction] (PersonImportAction.java:285) - Prepared 2 persons for creation 2021-08-27 15:00:08,065 INFO [qtp222511810-17] [org.gluu.oxtrust.service.ConfigurationService] (ConfigurationService.java:265) - Starting App version 4.2.3.Final 2021-08-27 15:04:11,263 INFO [qtp222511810-20] [org.gluu.oxtrust.action.PersonImportAction] (PersonImportAction.java:285) - Prepared 2 persons for creation In oxTrust Import Config, I've got the default - uid - required givenName - required sn - required mail - required userPassword - optional gluuStatus - optional Does anyone have an idea of what I'm doing wrong?
Gluu 4.2.3 Ubuntu 20.04
closed

Answers

By Mohib Zico staff 28 Aug 2021 at 1:21 a.m. CDT

Copy
Mohib Zico gravatar
I wonder why there are two `/` in this: ``` Failed to load '/etc/gluu/conf//gluuImportPerson.properties' configuration file ```

By Michael Dark user 08 Sep 2021 at 3:56 p.m. CDT

Copy
Michael Dark gravatar
Does anyone have a working gluuImportPerson.properties file I can look at? I can't find one (or what's supposed to be in it) online.

By Mohib Zico staff 24 Oct 2021 at 11:54 p.m. CDT

Copy
Mohib Zico gravatar
@Mobarak Hosen.Shakil: can we test this please?

By Mobarak Hosen Shakil staff 25 Oct 2021 at 1:35 p.m. CDT

Copy
Mobarak Hosen Shakil gravatar
Hi Michael Dark, Have you noticed that users have been added? How many users in your excel file? I have found this issue '`Failed to load '/etc/gluu/conf//gluuImportPerson.properties' configuration file` during first attempt to import users. During 2nd attempt, users were added. authentication also works. Interesting find: `gluuImportPerson.properties` file is missing in `/etc/gluu/conf`. Regards ~ Shakil

By Mobarak Hosen Shakil staff 11 Nov 2021 at 7:44 a.m. CST

Copy
Mobarak Hosen Shakil gravatar
closing this ticket. please reopen if required. Regards ~ Shakil

Post an answer