search

ExLibrisGroup / Cloud-App-Create-User-Request-By-Excel

0 stars 0 forks source link

"Error: No items can fulfill the submitted request" #1

Open MblackUC opened 1 year ago

MblackUC commented 1 year ago

When we try to create requests in bulk we are receiving a "no items can fulfill the submitted request" error message. When I test creating requests manually for these items in Alma, the request are created without issue. I have attached a screenshot of the error message and the error file. We tried adding the item_pid but this still did not work.

Error Message results (27).xlsx

Thank you, Matt

ori229 commented 1 year ago

Can you try with item_pid and without description? Please attach the input file you sent (Only one line should be enough for testing).

MblackUC commented 1 year ago

Thank you.

I have a test input file with 1 row. Attached is the input file and the results. @. Thank you, Matt From: ori229 @.> Sent: Thursday, May 18, 2023 12:09 AM To: ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel @.> Cc: Matthew Black @.>; Author @.***> Subject: Re: [ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel] "Error: No items can fulfill the submitted request" (Issue #1)

[△EXTERNAL]

Can you try with item_pid and without description? Please attach the input file you sent (Only one line should be enough for testing).

— Reply to this email directly, view it on GitHubhttps://github.com/ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel/issues/1#issuecomment-1552485894, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOVJUZGQMYQO5OLHBPG4ZYTXGW4I3ANCNFSM6AAAAAAYFQAROA. You are receiving this because you authored the thread.Message ID: @.***>

ori229 commented 1 year ago

The attachment didn't make its way here. Can you try again?

MblackUC commented 1 year ago

Thanks for confirming this. It must have been because I replied by email. Here are the attachments results (6).xlsx 4 ASC bulk hold test excel.xlsx .

ori229 commented 1 year ago

We were not able to reproduce this on our QA servers (with the same data as in your prod server the requests were created). Can we try one line on your prod?

MblackUC commented 1 year ago

Thank you for this update. I tried a one line on our prod and still receive the error message (see below). request_type pickup_location_type pickup_location_library user_id comment mms_id item_pid HOLD LIBRARY ASC ASCcommunityusers Test Request 22858680360004336 23860627220004336

Error message: Total number of requests is: 1 Number of created requests is: 0 Number of failed requests is: 1

Error: No items can fulfill the submitted request. (ASCcommunityusers, 22858680360004336, 23860627220004336)

Thank you, Matt From: ori229 @.> Sent: Wednesday, May 31, 2023 5:57 AM To: ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel @.> Cc: Matthew Black @.>; Author @.> Subject: Re: [ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel] "Error: No items can fulfill the submitted request" (Issue #1)

[△EXTERNAL]

We were not able to reproduce this on our QA servers (with the same data as in your prod server the requests were created). Can we try one line on your prod?

— Reply to this email directly, view it on GitHubhttps://github.com/ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel/issues/1#issuecomment-1570053820, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOVJUZFFHDJSW65SRVL5QZ3XI4WXHANCNFSM6AAAAAAYFQAROA. You are receiving this because you authored the thread.Message ID: @.***>

ori229 commented 1 year ago

I see. Thanks. The question is if you allow me to try myself on your server (with the exl_impl user)?

MblackUC commented 1 year ago

Oh I see thank you. Do you need me to provide credentials for this or are you able to access it?

Thank you, Matt

From: ori229 @.> Sent: Wednesday, May 31, 2023 10:59 AM To: ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel @.> Cc: Matthew Black @.>; Author @.> Subject: Re: [ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel] "Error: No items can fulfill the submitted request" (Issue #1)

[△EXTERNAL]

I see. Thanks. The question is if you allow me to try myself on your server (with the exl_impl user)?

— Reply to this email directly, view it on GitHubhttps://github.com/ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel/issues/1#issuecomment-1570590843, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOVJUZFJFZTWDXZSNJ7LOWTXI52FPANCNFSM6AAAAAAYFQAROA. You are receiving this because you authored the thread.Message ID: @.***>

ori229 commented 1 year ago

No need for credentials (I'm from within Ex Libris). Just your permission and a sample input file we can use with one line.

MblackUC commented 1 year ago

I understand. Thank you for clarifying this. You can try this in our Alma, I have attached a one line file. 4 ASC bulk hold test excel.xlsx

ori229 commented 1 year ago

We tried with the attached file and it works. Works for you? The change is from: pickup_location_type pickup_location_library LIBRARY ASC

to: pickup_location_type pickup_location_circulation_desk CIRCULATION_DESK DEFAULT_CIRC_DESK

4.ASC.bulk.hold.test.excel.xlsx

ori229 commented 1 year ago

The API requests that the Cloud App sent to Alma was: /almaws/v1/users/ASCcommunityusers/requests?mms_id=991029881398204336 { "description": "3000.001 | Box 013", "request_type": "HOLD", "mms_id": "991029881398204336", "pickup_location": "Archives & Special Collections", "pickup_location_type": "CIRCULATION_DESK", "pickup_location_library": "ASC", "pickup_location_circulation_desk": "DEFAULT_CIRC_DESK" }

MblackUC commented 1 year ago

Thank you for testing this and for the update. Just to confirm.

We need to update the columns in the Excel sheet from: pickup_location_type = LIBRARY pickup_location_circulation_desk DEFAULT_CIRC_DESK pickup_location_library = ASC

to: pickup_location_type = CIRCULATION_DESK pickup_location_circulation_desk = DEFAULT_CIRC_DESK pickup_location_library = ASC

We will try this in our file and confirm it works.

Thank you, Matt

From: ori229 @.> Sent: Thursday, June 1, 2023 3:28 AM To: ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel @.> Cc: Matthew Black @.>; Author @.> Subject: Re: [ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel] "Error: No items can fulfill the submitted request" (Issue #1)

[△EXTERNAL]

The API requests that the Cloud App sent to Alma was: /almaws/v1/users/ASCcommunityusers/requests?mms_id=991029881398204336 { "description": "3000.001 | Box 013", "request_type": "HOLD", "mms_id": "991029881398204336", "pickup_location": "Archives & Special Collections", "pickup_location_type": "CIRCULATION_DESK", "pickup_location_library": "ASC", "pickup_location_circulation_desk": "DEFAULT_CIRC_DESK" }

— Reply to this email directly, view it on GitHubhttps://github.com/ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel/issues/1#issuecomment-1571682159, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOVJUZG7H4SFML2UQQ7QK63XJBODBANCNFSM6AAAAAAYFQAROA. You are receiving this because you authored the thread.Message ID: @.***>

ori229 commented 1 year ago

Works?

MblackUC commented 1 year ago

Thank you for following up. It seems to work now. However, we noted that it seems to require the PID now. Previously, this wasn’t required.

Can you confirm this?

Thank you, Matt

From: ori229 @.> Sent: Wednesday, June 7, 2023 4:44 AM To: ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel @.> Cc: Matthew Black @.>; Author @.> Subject: Re: [ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel] "Error: No items can fulfill the submitted request" (Issue #1)

[△EXTERNAL]

Works?

— Reply to this email directly, view it on GitHubhttps://github.com/ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel/issues/1#issuecomment-1580490262, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOVJUZEDXKYQQYV4XH5FVMLXKBLOVANCNFSM6AAAAAAYFQAROA. You are receiving this because you authored the thread.Message ID: @.***>

ori229 commented 1 year ago

It's complicated... Hold request and the API used by the Cloud App. Without item_pid it can work if you add a description (for example: 3000.001 | Box 001) See the attached file, but note that in this case it was also required to change to using pickup_location_type= LIBRARY

bibtest.excel.xlsx

MblackUC commented 1 year ago

Thank you for this clarification! That makes sense to me. It needs some item specific data.

Thank you, Matt From: ori229 @.> Sent: Thursday, June 8, 2023 2:44 AM To: ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel @.> Cc: Matthew Black @.>; Author @.> Subject: Re: [ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel] "Error: No items can fulfill the submitted request" (Issue #1)

[△EXTERNAL]

It's complicated... Hold request and the API used by the Cloud App. Without item_pid it can work if you add a description (for example: 3000.001 | Box 001) See the attached file, but note that in this case it was also required to change to using pickup_location_type= LIBRARY

bibtest.excel.xlsxhttps://github.com/ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel/files/11685900/bibtest.excel.xlsx

— Reply to this email directly, view it on GitHubhttps://github.com/ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel/issues/1#issuecomment-1582154623, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOVJUZFBUKGEQ54TPFNJX6DXKGGETANCNFSM6AAAAAAYFQAROA. You are receiving this because you authored the thread.Message ID: @.***>

MblackUC commented 1 year ago

Hello,

We did some further testing and my colleague Maggie noted that the bibtest.excel.xlsx file you provided didn’t work for her when she tried using it with the cloud app and that this format was similar to that of the Excel sheet we initially had issues with.

Thank you, Matt

From: Matthew Black Sent: Thursday, June 8, 2023 8:44 AM To: ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel @.>; ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel @.> Cc: Author @.>; Maggie Hunter @.>; Lelland Reed @.***> Subject: RE: [ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel] "Error: No items can fulfill the submitted request" (Issue #1)

Thank you for this clarification! That makes sense to me. It needs some item specific data.

Thank you, Matt From: ori229 @.**@.>> Sent: Thursday, June 8, 2023 2:44 AM To: ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel @.**@.>> Cc: Matthew Black @.**@.>>; Author @.**@.>> Subject: Re: [ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel] "Error: No items can fulfill the submitted request" (Issue #1)

[△EXTERNAL]

It's complicated... Hold request and the API used by the Cloud App. Without item_pid it can work if you add a description (for example: 3000.001 | Box 001) See the attached file, but note that in this case it was also required to change to using pickup_location_type= LIBRARY

bibtest.excel.xlsxhttps://github.com/ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel/files/11685900/bibtest.excel.xlsx

— Reply to this email directly, view it on GitHubhttps://github.com/ExLibrisGroup/Cloud-App-Create-User-Request-By-Excel/issues/1#issuecomment-1582154623, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AOVJUZFBUKGEQ54TPFNJX6DXKGGETANCNFSM6AAAAAAYFQAROA. You are receiving this because you authored the thread.Message ID: @.**@.>>