Bug 12996

Summary: Tool to bulk export patrons images
Product: Koha Reporter: Pablo AB <pablo.bianchi>
Component: Command-line UtilitiesAssignee: Galen Charlton <gmcharlt>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: aidasarg, veron
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Bash script to bulk export patron images from a Koha instance and generate DATALINK.TXT to import into another instance

Description Pablo AB 2014-09-25 16:48:04 UTC
Created attachment 31884 [details]
Bash script to bulk export patron images from a Koha instance and generate DATALINK.TXT to import into another instance

I was trying to bulk export patrons images[0] so I created a bash script (attached) to export them all. This script will also generate a "DATALINK.TXT" to easily import into other Koha instance.

Usage: User have to just edit parameters section and run it on the host where MySQL database is. For security reasons will always prompt for password.

[0] https://www.mail-archive.com/koha@lists.katipo.co.nz/msg11711.html
Comment 1 Owen Leonard 2016-06-30 12:58:02 UTC
*** Bug 13126 has been marked as a duplicate of this bug. ***
Comment 2 Pablo AB 2018-10-04 03:03:30 UTC
The attached script wasn't working on current stable release. I've updated on this two places:
- https://wiki.koha-community.org/wiki/Debian_packages_script_library#Bulk_export_patrons_images
- https://gist.github.com/pabloab/347dc307a9650a5c4309c8fd6296c906
Tested on 17.11 and 18.05.