Users cannot be loaded as External

ExLibrisGroup / alma-csv-user-load

Load users to Ex Libris Alma from CSV files

2 stars 0 forks source link

Users cannot be loaded as External #5

Closed leahbokar closed 3 years ago

leahbokar commented 4 years ago

I've configured a profile, user type "External". CSV file load to Alma produced an error- below. Not sure where to get the unique tracking ID mentioned in a report:

Parsing CSV file Failed: The web server encountered an unexpected condition that prevented it from fulfilling the request. If the error persists, please use the unique tracking ID when reporting it. Failed: The web server encountered an unexpected condition that prevented it from fulfilling the request. If the error persists, please use the unique tracking ID when reporting it. Failed: The web server encountered an unexpected condition that prevented it from fulfilling the request. If the error persists, please use the unique tracking ID when reporting it. Failed: The web server encountered an unexpected condition that prevented it from fulfilling the request. If the error persists, please use the unique tracking ID when reporting it. Finished

jweisman commented 4 years ago

Hi @leahbokar . I was able to create external accounts. Can you please provide a screen shot of the profile configuration and a sample file? Thanks.

leahbokar commented 4 years ago

Hi @jweisman,

It doesn't let me to attach files. Will email you my sample file and a screen shot.

Thanks, Leah

jweisman commented 4 years ago

Thanks for the files @leahbokar . A few notes:

According to the error message I received, we need to include the CODE of an SIS integration profile when creating External users.
```
Failed: External Id must be given for external user.
```
I added the ability to define an external system in the profile and added a default value (SIS1 in my case)
The next error message was a missing identifier value:
```
Failed: Mandatory field is missing: User identifier value
```
I think you meant to define barcode in the default column for identifier type:

Once I did that the file ran successfully.

Parsing CSV file
Created: 3305578
Created: 3455340
Created: 3355176
Finished

I appreciate you helping us iron out any issues in real-work scenarios! Please make those 2 changes to your profile and let me know how it goes.

leahbokar commented 4 years ago

Hi Josh,

I've updated my profile with two additional fixed values:

SIS ==> External System BARCODE ==> Identifier Type

I've got the following error - below.

Empty field address line1 was processed as mandatory + the error does not have user primary ID

Parsing CSV file Failed: The web server encountered an unexpected condition that prevented it from fulfilling the request. If the error persists, please use the unique tracking ID when reporting it. Failed: Mandatory field is missing: address line1 Created: 3305578 Created: 3355176 Created: 3455338 Created: 3455450 Created: 3305565 Failed: Mandatory field is missing: address line1 Failed: Identifier with type = BARCODE couldn't be added/updated. User with the same id (primary_id = 200056) exists. Created: 3255749 Created: 3435529 Created: 3365575 Finished

Thanks, Leah

jweisman commented 4 years ago

Thanks Leah. I'm glad you got it working, at least mostly.

The "unexpected error" message is unfortunate. I can make a change which will display the tracking number so that we can look into it further.
The mandatory fields are defined by the institution, I believe, as documented here. So I assume this error is correct.
If barcode is defined as cross-institution unique, then in face it cannot be added again- so I think this is correct too.