[Bug 19017] New: Script that checks and transforms SMS alert numbers
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 Bug ID: 19017 Summary: Script that checks and transforms SMS alert numbers 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: alex.arnaud@biblibre.com QA Contact: testopia@bugs.koha-community.org Here is a proposal for a script that would check SMS alert number field. Our need is to have number that are correctly formatted as expetced by the SMS provider (ie: 0033678240967 or +33678240967 and not 0678240967). -- 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=19017 Alex Arnaud <alex.arnaud@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |alex.arnaud@biblibre.com |ity.org | -- 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=19017 Alex Arnaud <alex.arnaud@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |Trivial patch -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 --- Comment #1 from Alex Arnaud <alex.arnaud@biblibre.com> --- Created attachment 65396 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=65396&action=edit Checks and transform SMS alert number This patch adds a new package C4::SMSNumber::Fr (new ones could be added for other countries) and a scrip (misc/check_smsalertnumber.pl): check_smsalertnumber.pl -a|--area fr [-h|--help] [-c|--confirm] [-o|--country-option] [-l|--liste-mode] Test plan #1: - Create or modify patrons and add some SMS alert numbers like: 06 98 35 72 28, 0656871221, +336-01-55-83-11, 0033 6.23.54.54.00, 0126698376 - launch perl misc/check_smsalertnumber.pl -a Fr - Transformation proposal should be like: - 06 98 35 72 28 => 0698357228, - 0656871221 => no proposal (number Ok), - +336-01-55-83-11 => 0601558311, - 0033 6.23.54.54.00 => 0623545400, - 0126698376 => Can't find a replacement Test plan #2: - with the same numbers launch perl misc/check_smsalertnumber.pl -a Fr -o +33 - Transformation proposal should be like: - 06 98 35 72 28 => +33698357228, - 0656871221 => +33656871221, - +336-01-55-83-11 => +33601558311, - 0033 6.23.54.54.00 => +33623545400, - 0126698376 => Can't find a replacement Test plan #3: - with the same numbers launch perl misc/check_smsalertnumber.pl -a Fr -o 0033 - Transformation proposal should be like: - 06 98 35 72 28 => 0033698357228, - 0656871221 => 0033656871221, - +336-01-55-83-11 => 0033601558311, - 0033 6.23.54.54.00 => 0033623545400, - 0126698376 => Can't find a replacement -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 Alex Arnaud <alex.arnaud@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 Alex Arnaud <alex.arnaud@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |alex.arnaud@biblibre.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Failed QA --- Comment #2 from Owen Leonard <oleonard@myacpl.org> --- This works as it should, but I get a couple of errors from the qa script. OK C4/SMSNumber/Fr.pm OK critic OK forbidden patterns OK git manipulation OK pod OK spelling OK valid FAIL misc/check_smsalertnumber.pl FAIL critic Stricture disabled at line 60, column 5. See page 429 of PBP. OK forbidden patterns OK git manipulation OK pod FAIL spelling tranform ==> transform OK valid -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 Alex Arnaud <alex.arnaud@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #65396|0 |1 is obsolete| | --- Comment #3 from Alex Arnaud <alex.arnaud@biblibre.com> --- Created attachment 65498 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=65498&action=edit Checks and transform SMS alert number This patch adds a new package C4::SMSNumber::Fr (new ones could be added for other countries) and a scrip (misc/check_smsalertnumber.pl): check_smsalertnumber.pl -a|--area fr [-h|--help] [-c|--confirm] [-o|--country-option] [-l|--liste-mode] Test plan #1: - Create or modify patrons and add some SMS alert numbers like: 06 98 35 72 28, 0656871221, +336-01-55-83-11, 0033 6.23.54.54.00, 0126698376 - launch perl misc/check_smsalertnumber.pl -a Fr - Transformation proposal should be like: - 06 98 35 72 28 => 0698357228, - 0656871221 => no proposal (number Ok), - +336-01-55-83-11 => 0601558311, - 0033 6.23.54.54.00 => 0623545400, - 0126698376 => Can't find a replacement Test plan #2: - with the same numbers launch perl misc/check_smsalertnumber.pl -a Fr -o +33 - Transformation proposal should be like: - 06 98 35 72 28 => +33698357228, - 0656871221 => +33656871221, - +336-01-55-83-11 => +33601558311, - 0033 6.23.54.54.00 => +33623545400, - 0126698376 => Can't find a replacement Test plan #3: - with the same numbers launch perl misc/check_smsalertnumber.pl -a Fr -o 0033 - Transformation proposal should be like: - 06 98 35 72 28 => 0033698357228, - 0656871221 => 0033656871221, - +336-01-55-83-11 => 0033601558311, - 0033 6.23.54.54.00 => 0033623545400, - 0126698376 => Can't find a replacement -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 Alex Arnaud <alex.arnaud@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 --- Comment #4 from Owen Leonard <oleonard@myacpl.org> --- This isn't correct is it? ------------ perl check_smsalertnumber.pl -a Fr Number: 0033 6.23.54.54.00 at /home/vagrant/kohaclone/C4/SMSNumber/Fr.pm line 24. Patron n° 58808 has an invalid phone number for area Fr ( 0033 6.23.54.54.00). Can't find a replacement -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 Simon Pouchol <simon.pouchol@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #65498|0 |1 is obsolete| | --- Comment #5 from Simon Pouchol <simon.pouchol@biblibre.com> --- Created attachment 68319 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=68319&action=edit Checks and transform SMS alert number This patch adds a new package C4::SMSNumber::Fr (new ones could be added for other countries) and a scrip (misc/check_smsalertnumber.pl): check_smsalertnumber.pl -a|--area fr [-h|--help] [-c|--confirm] [-o|--country-option] [-l|--liste-mode] Test plan #1: - Create or modify patrons and add some SMS alert numbers like: 06 98 35 72 28, 0656871221, +336-01-55-83-11, 0033 6.23.54.54.00, 0126698376 - launch perl misc/check_smsalertnumber.pl -a Fr - Transformation proposal should be like: - 06 98 35 72 28 => 0698357228, - 0656871221 => no proposal (number Ok), - +336-01-55-83-11 => 0601558311, - 0033 6.23.54.54.00 => 0623545400, - 0126698376 => Can't find a replacement Test plan #2: - with the same numbers launch perl misc/check_smsalertnumber.pl -a Fr -o +33 - Transformation proposal should be like: - 06 98 35 72 28 => +33698357228, - 0656871221 => +33656871221, - +336-01-55-83-11 => +33601558311, - 0033 6.23.54.54.00 => +33623545400, - 0126698376 => Can't find a replacement Test plan #3: - with the same numbers launch perl misc/check_smsalertnumber.pl -a Fr -o 0033 - Transformation proposal should be like: - 06 98 35 72 28 => 0033698357228, - 0656871221 => 0033656871221, - +336-01-55-83-11 => 0033601558311, - 0033 6.23.54.54.00 => 0033623545400, - 0126698376 => Can't find a replacement https://bugs.koha-community.org/show_bug.cgi?id=19017 Signed-off-by: Simon Pouchol <simon.pouchol@biblibre.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 Simon Pouchol <simon.pouchol@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off CC| |simon.pouchol@biblibre.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #6 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- This is too specific, we should provide a generic way to do that. The prefix code should be a parameter of the script. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de Keywords| |dependency --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Should we set this to In discussion or failed? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 --- Comment #8 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- I did not switch the status to get another QA point of view. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 --- Comment #9 from Alex Arnaud <alex.arnaud@biblibre.com> --- (In reply to Jonathan Druart from comment #6)
This is too specific, we should provide a generic way to do that. The prefix code should be a parameter of the script.
Prefix code is passed to the script with -o|--options. It is intentionally generic in the case an other country package needs a different parameter. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Failed QA --- Comment #10 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I agree with Jonathan: - The French country code +33 is hard coded into the script which makes it only useful for French telephone numbers, but not usable for example for German ones (+41). This could easily be more generic and then much more useful. - There is an option --country-option, but it doesn't appear to be used? - It adds a new module to C4, which we should not do anymore. - It doesn't include tests. I think if we want something like that, it might be better as a clean-up script in misc/maintenance. Possibly without a separate module? I think it's not quite ready, sorry! -- You are receiving this mail because: You are watching all bug changes.
I agree with Jonathan:
- The French country code +33 is hard coded into the script which makes it only useful for French telephone numbers, but not usable for example for German ones (+41). This could easily be more generic and then much more useful. +33 (or 0033) is not hard coded into the script. Only in the pod. It is only in
- There is an option --country-option, but it doesn't appear to be used? Yes, forgot to remove this from the pod - It adds a new module to C4, which we should not do anymore. Better in Koha/SMSNumber/* ? - It doesn't include tests. Right.
I think if we want something like that, it might be better as a clean-up script in misc/maintenance. Possibly without a separate module? Separate modules contain the logic specific to each area. It's not easy/clear/possible to have a script that check and transform number for all
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 --- Comment #11 from Alex Arnaud <alex.arnaud@biblibre.com> --- (In reply to Katrin Fischer from comment #10) the C4::SMSNumber::Fr package which is dedicated to french number. You can add a C4::SMSNumber::De package with a german logic for transforming number and add to the pod: - De: Checks german mobile number. options: '+41', ... \n" like i did for french the areas as the format of number could be different (i.e not the number of digit). So the area paramter determines which area module to use.
I think it's not quite ready, sorry!
-- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 --- Comment #12 from Alex Arnaud <alex.arnaud@biblibre.com> --- An other point i'm wondering about is the libraries having borrowers from different areas. It is the case for many universities. But, for now, the script runs for all the users in database without being aware of their country/area -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 --- Comment #13 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- You are right, the country-code is in the module. I am worried that different modules will be hard to maintain while containing a lot of duplicated code, at least for the European countries. I think better in Koha - but please check with Joubu for general approach. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19017 paxed <pasi.kallinen@joensuu.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |pasi.kallinen@joensuu.fi --- Comment #14 from paxed <pasi.kallinen@joensuu.fi> --- Like Katrin, I'm also worried about having numbers from different countries. Couldn't this functionality basically be done with a phone number validator written in javascript and hooked on to the borrower edit/add form inputs? And for checking the phone numbers in the database, a simple report could be done. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org