The a patron's userid should be a matchpoint in the same manner as cardnumber. Though not enforced as a unique key by the database yet ( pending bug 1861 ), this field is effectively unique as uniqueness is enforced by Koha itself.
Created attachment 29574 [details] [review] Bug 12543 - Add userid as matchpoint for "Import patrons" tool The a patron's userid should be a matchpoint in the same manner as cardnumber. Though not enforced as a unique key by the database yet ( pending bug 1861 ), this field is effectively unique as uniqueness is enforced by Koha itself. Test Plan: 1) Apply this patch 2) Browse to tools/import_borrowers.pl 3) Download the starter CSV file 4) Edit the csv file to include 1 or more patrons * Make sure to leave the borrowernumber field empty * Make sure the userid field matches the patrons you wish to overwrite 5) From import_borrowers.pl, upload your file * Set "Field to use for record matching" to "Username" * Set "If matching record is already in the borrowers table" to "Overwrite the existing one with this" 6) Click "Import" 7) Verify the patrons in your file have been updated in Koha
Created attachment 32793 [details] [review] Bug 12543 - Add userid as matchpoint for "Import patrons" tool The a patron's userid should be a matchpoint in the same manner as cardnumber. Though not enforced as a unique key by the database yet ( pending bug 1861 ), this field is effectively unique as uniqueness is enforced by Koha itself. Test Plan: 1) Apply this patch 2) Browse to tools/import_borrowers.pl 3) Download the starter CSV file 4) Edit the csv file to include 1 or more patrons * Make sure to leave the borrowernumber field empty * Make sure the userid field matches the patrons you wish to overwrite 5) From import_borrowers.pl, upload your file * Set "Field to use for record matching" to "Username" * Set "If matching record is already in the borrowers table" to "Overwrite the existing one with this" 6) Click "Import" 7) Verify the patrons in your file have been updated in Koha Signed-off-by: Frederic Demians <f.demians@tamil.fr> Do exactly what's announced. This may help.
There is a dependency on bug 1861 for this - Kyle, could you take a look please?
Created attachment 35307 [details] [review] Bug 12543 - Add userid as matchpoint for "Import patrons" tool The a patron's userid should be a matchpoint in the same manner as cardnumber. Though not enforced as a unique key by the database yet ( pending bug 1861 ), this field is effectively unique as uniqueness is enforced by Koha itself. Test Plan: 1) Apply this patch 2) Browse to tools/import_borrowers.pl 3) Download the starter CSV file 4) Edit the csv file to include 1 or more patrons * Make sure to leave the borrowernumber field empty * Make sure the userid field matches the patrons you wish to overwrite 5) From import_borrowers.pl, upload your file * Set "Field to use for record matching" to "Username" * Set "If matching record is already in the borrowers table" to "Overwrite the existing one with this" 6) Click "Import" 7) Verify the patrons in your file have been updated in Koha Signed-off-by: Frederic Demians <f.demians@tamil.fr> Do exactly what's announced. This may help. Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Patch pushed to master. Thanks Kyle!