Import Person

By: Sakit Atakishiyev user 07 Jun 2017 at 10:16 a.m. CDT

12 Responses
Sakit Atakishiyev gravatar
Is it possible to import extra attribute information via `xls` file? [This link](https://gluu.org/docs/ce/2.4.4/admin-guide/user-group/) explain the file structure. I want to also add other existing attribute information such `phone`, `address` etc.
U1404
closed

Answers

By Mohib Zico Account Admin 07 Jun 2017 at 10:28 a.m. CDT

Copy
Mohib Zico gravatar
Please feel free to give a shot.

By Sakit Atakishiyev user 07 Jun 2017 at 10:29 a.m. CDT

Copy
Sakit Atakishiyev gravatar
Sorry but I don't understand what do you mean?

By Mohib Zico Account Admin 07 Jun 2017 at 10:37 a.m. CDT

Copy
Mohib Zico gravatar
Sorry, I meant... please go ahead and try.

By Sakit Atakishiyev user 07 Jun 2017 at 10:39 a.m. CDT

Copy
Sakit Atakishiyev gravatar
I already tried but did not import extra attributes

By Mohib Zico Account Admin 07 Jun 2017 at 10:43 a.m. CDT

Copy
Mohib Zico gravatar
What does oxtrust log say?

By Sakit Atakishiyev user 07 Jun 2017 at 10:54 a.m. CDT

Copy
Sakit Atakishiyev gravatar
This is the log. ```` 2017-06-07 14:51:02,917 INFO [qtp274064559-10] [org.gluu.oxtrust.ldap.service.OrganizationService] (OrganizationService.java:258) - Starting App version 3.0.1 2017-06-07 15:05:03,992 INFO [qtp274064559-17] [org.gluu.oxtrust.action.PersonImportAction] (PersonImportAction.java:405) - Found 1 persons in input Excel file 2017-06-07 15:13:02,054 INFO [qtp274064559-16] [org.gluu.oxtrust.action.PersonImportAction] (PersonImportAction.java:405) - Found 1 persons in input Excel file 2017-06-07 15:13:02,056 INFO [qtp274064559-16] [org.gluu.oxtrust.action.PersonImportAction] (PersonImportAction.java:282) - Prepared 1 persons for creation 2017-06-07 15:13:08,367 INFO [qtp274064559-14] [org.gluu.oxtrust.action.PersonImportAction] (PersonImportAction.java:137) - Attempting to add 1 persons 2017-06-07 15:13:08,431 INFO [qtp274064559-14] [org.gluu.oxtrust.action.PersonImportAction] (PersonImportAction.java:158) - All 1 persons added successfully ````

By Mohib Zico Account Admin 07 Jun 2017 at 10:57 a.m. CDT

Copy
Mohib Zico gravatar
I don't see any error here. Without error we can't say what's wrong where. At most, we can try to import your desired attribute locally and see if there is any issue anywhere.

By Sakit Atakishiyev user 07 Jun 2017 at 11:01 a.m. CDT

Copy
Sakit Atakishiyev gravatar
System import my file but took only `firstname`,`lastname`,`email`,`password`. Additionally I added `PersistentId` attribute to my excel. But import action did not consider this attribute

By Mohib Zico Account Admin 07 Jun 2017 at 11:05 a.m. CDT

Copy
Mohib Zico gravatar
'PersistentID' is a calculated attribute; basically a NameID which is generated inside IDP server. Importing PersistenID is a bad idea.

By Sakit Atakishiyev user 07 Jun 2017 at 11:09 a.m. CDT

Copy
Sakit Atakishiyev gravatar
If I change attribute for example `phone` attribute does it solve problem?

By Mohib Zico Account Admin 07 Jun 2017 at 11:12 a.m. CDT

Copy
Mohib Zico gravatar
Please try and if you have any issue open a new ticket with stack trace.

By Sakit Atakishiyev user 07 Jun 2017 at 1:07 p.m. CDT

Copy
Sakit Atakishiyev gravatar
This time I tested `Organization` attribute. Gluu import my person successfully but did not set `Organization` attribute and this the oxtrust.log ```` 2017-06-07 17:55:11,498 INFO [qtp274064559-15] [org.gluu.oxtrust.ldap.service.OrganizationService] (OrganizationService.java:258) - Starting App version 3.0.1 2017-06-07 17:55:22,709 INFO [qtp274064559-17] [org.gluu.oxtrust.action.PersonImportAction] (PersonImportAction.java:405) - Found 1 persons in input Excel file 2017-06-07 17:55:22,710 INFO [qtp274064559-17] [org.gluu.oxtrust.action.PersonImportAction] (PersonImportAction.java:282) - Prepared 1 persons for creation 2017-06-07 17:55:24,565 INFO [qtp274064559-19] [org.gluu.oxtrust.action.PersonImportAction] (PersonImportAction.java:137) - Attempting to add 1 persons 2017-06-07 17:55:24,620 INFO [qtp274064559-19] [org.gluu.oxtrust.action.PersonImportAction] (PersonImportAction.java:158) - All 1 persons added successfully 2017-06-07 17:55:47,614 ERROR [qtp274064559-12] [org.gluu.oxtrust.ldap.service.AttributeService] (AttributeService.java:582) - Failed to find attribute 'cn' metadata ````

Post an answer