[Bug 28400] New: Add SMS providers message id to message_queue table
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Bug ID: 28400 Summary: Add SMS providers message id to message_queue table Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Notices Assignee: koha-bugs@lists.koha-community.org Reporter: johanna.raisa@koha-suomi.fi QA Contact: testopia@bugs.koha-community.org Some SMS providers give an id in response body which you can use to track message status. Now message_queue table doesn't have any field where this could be put. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Johanna Räisä <johanna.raisa@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Add SMS providers message |Add SMS provider's message |id to message_queue table |id to message_queue table -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Johanna Räisä <johanna.raisa@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Add SMS provider's message |Add SMS provider's response |id to message_queue table |to message_queue table -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 --- Comment #1 from Johanna Räisä <johanna.raisa@koha-suomi.fi> --- (In reply to Johanna Räisä from comment #0)
Some SMS providers give an id in response body which you can use to track message status. Now message_queue table doesn't have any field where this could be put.
Probably saving the whole response body is the best thing to do since there can be more useful data than just id. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Johanna Räisä <johanna.raisa@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Add SMS provider's response |Add response column to |to message_queue table |message_queue table -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 --- Comment #2 from Johanna Räisä <johanna.raisa@koha-suomi.fi> --- Updated the title, since this can be used for all the interfaces to save a response. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Johanna Räisä <johanna.raisa@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Add response column to |Add response_message column |message_queue table |to message_queue table -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Johanna Räisä <johanna.raisa@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff Assignee|koha-bugs@lists.koha-commun |johanna.raisa@koha-suomi.fi |ity.org | --- Comment #3 from Johanna Räisä <johanna.raisa@koha-suomi.fi> --- Created attachment 169812 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=169812&action=edit Bug 24800: Add response_message column to message_queue table Test Plan: 1) Run the updatedatabase.pl script 2) Run update_dbix_class_files.pl 3) Check the message_queue table for the new column Sponsored-by: Koha-Suomi Oy -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Johanna Räisä <johanna.raisa@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #169812|0 |1 is obsolete| | --- Comment #4 from Johanna Räisä <johanna.raisa@koha-suomi.fi> --- Created attachment 169813 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=169813&action=edit Bug 28400: Add response_message column to message_queue table Test Plan: 1) Run the updatedatabase.pl script 2) Run update_dbix_class_files.pl 3) Check the message_queue table for the new column Sponsored-by: Koha-Suomi Oy -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Johanna Räisä <johanna.raisa@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Change sponsored?|--- |Sponsored -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Johanna Räisä <johanna.raisa@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #169813|0 |1 is obsolete| | --- Comment #5 from Johanna Räisä <johanna.raisa@koha-suomi.fi> --- Created attachment 169821 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=169821&action=edit Bug 28400: Add response_message column to message_queue table Test Plan: 1) Run the updatedatabase.pl script 2) Run update_dbix_class_files.pl 3) Check the message_queue table for the new column Sponsored-by: Koha-Suomi Oy -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #169821|0 |1 is obsolete| | --- Comment #6 from David Nind <david@davidnind.com> --- Created attachment 177147 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=177147&action=edit Bug 28400: Add response_message column to message_queue table Test Plan: 1) Run the updatedatabase.pl script 2) Run update_dbix_class_files.pl 3) Check the message_queue table for the new column Sponsored-by: Koha-Suomi Oy Signed-off-by: David Nind <david@davidnind.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Text to go in the| |This enhancement adds a release notes| |'response_message' field to | |the 'message_queue' table. | |This can be used to save | |the message response. For | |example, some SMS providers | |give an ID in the response | |body that could be used to | |track the message status - | |this change adds a field | |where this information can | |be saved. CC| |david@davidnind.com --- Comment #7 from David Nind <david@davidnind.com> --- Testing notes (using KTD): 1. SQl to show the columns for a table: DESCRIBE message_queue; -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Patch doesn't apply -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Johanna Räisä <johanna.raisa@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #177147|0 |1 is obsolete| | --- Comment #8 from Johanna Räisä <johanna.raisa@koha-suomi.fi> --- Created attachment 181051 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=181051&action=edit Bug 28400: Add response_message column to message_queue table Test Plan: 1) Run the updatedatabase.pl script 2) Run update_dbix_class_files.pl 3) Check the message_queue table for the new column Sponsored-by: Koha-Suomi Oy -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Johanna Räisä <johanna.raisa@koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Patch doesn't apply |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Lin Wei <lin-wei.li@inLibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Lin Wei <lin-wei.li@inLibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #181051|0 |1 is obsolete| | --- Comment #9 from Lin Wei <lin-wei.li@inLibro.com> --- Created attachment 182314 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=182314&action=edit Bug 28400: Add response_message column to message_queue table Test Plan: 1) Run the updatedatabase.pl script 2) Run update_dbix_class_files.pl 3) Check the message_queue table for the new column Sponsored-by: Koha-Suomi Oy Signed-off-by: Lin Wei Li <lin-wei.li@inLibro.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28400 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |m.de.rooy@rijksmuseum.nl Status|Signed Off |Failed QA --- Comment #10 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Hi, Please add unit tests (hopefully showing how this is actually used too). Please add kohastructure.sql changes. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org