Patron Notices (UXPROD-18)

[UXPROD-3787] Provide all communications sent to patrons by FOLIO Created: 24/Aug/22  Updated: 30/Nov/23

Status: Draft
Project: UX Product
Components: None
Affects versions: None
Fix versions: None
Parent: Patron Notices

Type: New Feature Priority: P3
Reporter: julie.bickle Assignee: julie.bickle
Resolution: Unresolved Votes: 0
Labels: notice_other, patron_notice
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Attachments: Microsoft Word memail_ex.xlsx    
Release: Not Scheduled
Epic Link: Patron Notices
Development Team: None
PO Rank: 0
Rank: Cornell (Full Sum 2021): R4

 Description   

Current situation or problem: Message from Aaron Neslin:
"Talking with my colleagues at the five colleges, we have discovered that the state of Massachusetts requires us to keep all communications- that includes notices sent to patrons by FOLIO.
We're still trying to figure out our exact requirements, but the simplest would be the ability to export the full text of each notice in a circ log result."

In scope

Out of scope

Use case(s)

Proposed solution/stories

  • WHU and IU International University of Applied Sciences would like to have their institution email address in CC, so to have all notices in their inbox.

Links to additional info

Questions



 Comments   
Comment by Erin Nettifee [ 24/Aug/22 ]

Aaron Neslin - I don't remember, does 5 Colleges have a reporting tool? You're talking about something that could very quickly become a large dataset, and just exporting from the circ log is not going to be a sustainable approach IMO.

Comment by Aaron Neslin [ 24/Aug/22 ]

Still awaiting requirements from the billing office.

In Aleph, we stored the xml data use to generate the notice, and when it was necessary to provide the full text of the notice, the email was reproduced from xml data and the template.  I'm hoping a similar case will be acceptable here, where all that is required is that we can view the text of the email by generating the notice on the fly  as needed from saved data.     

Comment by julie.bickle [ 29/Aug/22 ]

Great input from Cheryl:

"Email notifications are stored in the ldp (history.email_mail) and metadb (folio_email.email_statistics__t).  As well as the content of the notices each entry has a fail or success (Delivered) message.   The metadb table is easy to query since the data such as header and to are broken into columns.  In the ldp, the data is all in the json field.  I attached the results of the query

SELECT * FROM folio_email.email_statistics__t where "to" = 'bitbucket@lib.uchicago.edu' limit

These are notices that would go to ILL borrowing institutions that we don't send.  No individual borrower data is in the notice." (memail_ex.xlsx)

Generated at Fri Feb 09 00:34:48 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.