Hi All - doing: select status from message_queue group by status gives me 3 values: sent pending failed Are these 3 values the only value "allowed" in this field? Or, putting it another way, if messages are added to the table with a different status value would it cause problems in Koha? The reason I'm asking is: as soon a book with a reservation is returned on our selfcheck machines an email is added to the message_queue table with the status of pending. A lot can happen to this book before it actually gets on the reserve shelf, and may never actually get to the reserve shelf. If the book does go missing, gets hidden etc, the user with the reservation still gets an email telling them that the book is ready to collect (when it's not). To avoid this we are wondering if could stop this email from being sent (we only send out email notices once a day). We could delete the email from the message_queue table - I don't really like deleting stuff - or we could change the status. I guess I could change to "failed", but "cancelled" sounds better. I thinking of writing a bit of code to allow library staff to do this easily from the staff client - could I change the status to "cancelled" or is it better to stay with one of the original three? Cheers, Stephen Stephen Graham Library Technology Consultant Academic Resources Library and Computing Services University of Hertfordshire Hatfield AL10 9AB UK Tel. 01707 286111 Ext: 77751 Email s.graham4@herts.ac.uk
I'm looking at kohastructure.sql on master, and the status column of the message_queue table seems to also allow a 'deleted' value. On Mon, Oct 17, 2016 at 9:13 AM, Graham, Stephen <s.graham4@herts.ac.uk> wrote:
Hi All – doing:
select status from message_queue group by status
gives me 3 values:
sent
pending
failed
Are these 3 values the only value “allowed” in this field? Or, putting it another way, if messages are added to the table with a different status value would it cause problems in Koha?
The reason I’m asking is: as soon a book with a reservation is returned on our selfcheck machines an email is added to the message_queue table with the status of pending. A lot can happen to this book before it actually gets on the reserve shelf, and may never actually get to the reserve shelf. If the book does go missing, gets hidden etc, the user with the reservation still gets an email telling them that the book is ready to collect (when it’s not). To avoid this we are wondering if could stop this email from being sent (we only send out email notices once a day). We could delete the email from the message_queue table – I don’t really like deleting stuff – or we could change the status. I guess I could change to “failed”, but “cancelled” sounds better. I thinking of writing a bit of code to allow library staff to do this easily from the staff client – could I change the status to “cancelled” or is it better to stay with one of the original three?
Cheers, Stephen
Stephen Graham
Library Technology Consultant
Academic Resources
Library and Computing Services University of Hertfordshire Hatfield AL10 9AB UK
Tel. 01707 286111 Ext: 77751
Email s.graham4@herts.ac.uk
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
-- Michael Hafen Washington County School District Technology Department Systems Analyst
The reason I’m asking is: as soon a book with a reservation is returned on our selfcheck machines an email is added to the message_queue table with the status of pending.
It sounds to me like the problem isn't that the message in the queue should be marked differently. It sounds like the problem is that check-ins from the self checkout module are automatically being marked as "waiting." If you could have Koha consider an self-checked-in item to be "in transit" or something like that it would then require that the staff check it in again before marking the item waiting and putting the notification in the message queue. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
participants (3)
-
Graham, Stephen -
Michael Hafen -
Owen Leonard