[Koha] Backup of Patron Images

[Coehoorn, Joel]

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 at york.edu | york.edu



On Fri, Oct 27, 2023 at 12:11 PM Indranil Das Gupta <indradg at 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 at 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 at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>