Backup of Patron Images
Hi, When I migrated my koha from one server to another by migrating the MySQL database, I was able to see the complete data (Bibliography, Circulation, patron, etc) in the new server. However, I could not see the patron images on their profile page, which were earlier uploaded on the old server. I suppose when I migrated the SQL database, it just migrated the data to a new server, but the jpg files were stored in a folder in the koha installation, which is why the photos are not appearing in the new koha installation. Can anyone please help me with migrating the patron images as well? What is the folder location where koha stores the patron images uploaded for each patron? Thank you Rupinder Singh
Hi Rupinder, Koha stores uploaded patron images as MEDIUMBLOB data in the patronimage table in the Koha database. These are not stored separately in the filesystem. For more details : https://schema.koha-community.org/23_05/tables/patronimage.html Hope this helps. Indranil Das Gupta L2C2 Technologies. On Fri, Oct 27, 2023, 12:20 Rupinder Singh <jessedhammu@gmail.com> wrote:
Hi, When I migrated my koha from one server to another by migrating the MySQL database, I was able to see the complete data (Bibliography, Circulation, patron, etc) in the new server. However, I could not see the patron images on their profile page, which were earlier uploaded on the old server. I suppose when I migrated the SQL database, it just migrated the data to a new server, but the jpg files were stored in a folder in the koha installation, which is why the photos are not appearing in the new koha installation. Can anyone please help me with migrating the patron images as well? What is the folder location where koha stores the patron images uploaded for each patron?
Thank you Rupinder Singh _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Haha, I hadn't thought to load the DB directly. Just seeing this was enough I'm now feeding student and faculty photos to koha from our ID system automatically via powershell script. We use a discovery service, rather than the OPAC, for searching, so most students never see their account. But at least the circulation desk will see a matching photo when scanning the ID cards. *Joel Coehoorn* Director of Information Technology *York University* Office: 402-363-5603 | jcoehoorn@york.edu | york.edu On Fri, Oct 27, 2023 at 12:11 PM Indranil Das Gupta <indradg@gmail.com> wrote:
Hi Rupinder,
Koha stores uploaded patron images as MEDIUMBLOB data in the patronimage table in the Koha database. These are not stored separately in the filesystem.
For more details : https://schema.koha-community.org/23_05/tables/patronimage.html
Hope this helps.
Indranil Das Gupta L2C2 Technologies.
On Fri, Oct 27, 2023, 12:20 Rupinder Singh <jessedhammu@gmail.com> wrote:
Hi, When I migrated my koha from one server to another by migrating the MySQL database, I was able to see the complete data (Bibliography, Circulation, patron, etc) in the new server. However, I could not see the patron images on their profile page, which were earlier uploaded on the old server. I suppose when I migrated the SQL database, it just migrated the data to a new server, but the jpg files were stored in a folder in the koha installation, which is why the photos are not appearing in the new koha installation. Can anyone please help me with migrating the patron images as well? What is the folder location where koha stores the patron images uploaded for each patron?
Thank you Rupinder Singh _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Coehoorn, Joel -
Indranil Das Gupta -
Rupinder Singh