Hi, Is there is a way to batch export patron data from one Koha to another Koha? Thank you in advance! Regards, Russel Librarian Namibia Library and Archives Service
Hi Russel, Since you can batch import patrons <https://koha-community.org/manual/21.05/en/html/tools.html#patron-import> using a CSV and export reports to CSV, yes, there's a relatively simple way to transfer patrons from one instance to another. Write a report that grabs all the columns and patrons you want to transfer (essentially `SELECT * FROM borrowers`), download it to a CSV, and import on your other instance. There are more options and nuances to it, but that is all you have to do. Best, ERIC PHETTEPLACE Systems Librarian, Libraries (he/him) ephetteplace@cca.edu | o 510.594.3660 (cca) 5212 Broadway | Oakland, CA | 94618 CCA is situated on the traditional unceded lands of the Ohlone peoples. Black-owned bookstores in Oakland: Ashay by the Bay <https://ashaybythebay.com/>, Marcus Books <https://www.facebook.com/marcus.books/> :(){ :|: & };: On Tue, Nov 30, 2021 at 5:56 AM Russel G. P. Shihepo <russellgeeps@gmail.com> wrote:
Hi,
Is there is a way to batch export patron data from one Koha to another Koha?
Thank you in advance!
Regards, Russel Librarian Namibia Library and Archives Service _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Just thinking aloud here. Will this process take care of active loans linked to these patrons? Any past anonymised stats, etc. Regards On Tue, 30 Nov 2021, 19:06 Eric Phetteplace, <ephetteplace@cca.edu> wrote:
Hi Russel,
Since you can batch import patrons <https://koha-community.org/manual/21.05/en/html/tools.html#patron-import> using a CSV and export reports to CSV, yes, there's a relatively simple way to transfer patrons from one instance to another. Write a report that grabs all the columns and patrons you want to transfer (essentially `SELECT * FROM borrowers`), download it to a CSV, and import on your other instance. There are more options and nuances to it, but that is all you have to do.
Best,
ERIC PHETTEPLACE Systems Librarian, Libraries (he/him)
ephetteplace@cca.edu | o 510.594.3660 (cca)
5212 Broadway | Oakland, CA | 94618
CCA is situated on the traditional unceded lands of the Ohlone peoples.
Black-owned bookstores in Oakland: Ashay by the Bay <https://ashaybythebay.com/>, Marcus Books <https://www.facebook.com/marcus.books/>
:(){ :|: & };:
On Tue, Nov 30, 2021 at 5:56 AM Russel G. P. Shihepo < russellgeeps@gmail.com> wrote:
Hi,
Is there is a way to batch export patron data from one Koha to another Koha?
Thank you in advance!
Regards, Russel Librarian Namibia Library and Archives Service _______________________________________________
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
Dear ERIC Thank you, this was very helpful. Regards, Russel On Wed, Dec 1, 2021 at 5:11 AM Bravismore Mumanyi <bravismore@gmail.com> wrote:
Just thinking aloud here. Will this process take care of active loans linked to these patrons? Any past anonymised stats, etc.
Regards
On Tue, 30 Nov 2021, 19:06 Eric Phetteplace, <ephetteplace@cca.edu> wrote:
Hi Russel,
Since you can batch import patrons <https://koha-community.org/manual/21.05/en/html/tools.html#patron-import
using a CSV and export reports to CSV, yes, there's a relatively simple way to transfer patrons from one instance to another. Write a report that grabs all the columns and patrons you want to transfer (essentially `SELECT * FROM borrowers`), download it to a CSV, and import on your other instance. There are more options and nuances to it, but that is all you have to do.
Best,
ERIC PHETTEPLACE Systems Librarian, Libraries (he/him)
ephetteplace@cca.edu | o 510.594.3660 (cca)
5212 Broadway | Oakland, CA | 94618
CCA is situated on the traditional unceded lands of the Ohlone peoples.
Black-owned bookstores in Oakland: Ashay by the Bay <https://ashaybythebay.com/>, Marcus Books <https://www.facebook.com/marcus.books/>
:(){ :|: & };:
On Tue, Nov 30, 2021 at 5:56 AM Russel G. P. Shihepo < russellgeeps@gmail.com> wrote:
Hi,
Is there is a way to batch export patron data from one Koha to another Koha?
Thank you in advance!
Regards, Russel Librarian Namibia Library and Archives Service _______________________________________________
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
Hi, moving all this data would be much more complicated than just moving the patrons from one installation to the other. In order to move the loans, you'd also need to add the bibliographic records/items to the other system, possibly matching with existing records, etc. There are currently no scripts/tools in Koha to do this. Hope this helps, Katrin On 01.12.21 04:11, Bravismore Mumanyi wrote:
Just thinking aloud here. Will this process take care of active loans linked to these patrons? Any past anonymised stats, etc.
Regards
On Tue, 30 Nov 2021, 19:06 Eric Phetteplace, <ephetteplace@cca.edu> wrote:
Hi Russel,
Since you can batch import patrons <https://koha-community.org/manual/21.05/en/html/tools.html#patron-import> using a CSV and export reports to CSV, yes, there's a relatively simple way to transfer patrons from one instance to another. Write a report that grabs all the columns and patrons you want to transfer (essentially `SELECT * FROM borrowers`), download it to a CSV, and import on your other instance. There are more options and nuances to it, but that is all you have to do.
Best,
ERIC PHETTEPLACE Systems Librarian, Libraries (he/him)
ephetteplace@cca.edu | o 510.594.3660 (cca)
5212 Broadway | Oakland, CA | 94618
CCA is situated on the traditional unceded lands of the Ohlone peoples.
Black-owned bookstores in Oakland: Ashay by the Bay <https://ashaybythebay.com/>, Marcus Books <https://www.facebook.com/marcus.books/>
:(){ :|: & };:
On Tue, Nov 30, 2021 at 5:56 AM Russel G. P. Shihepo < russellgeeps@gmail.com> wrote:
Hi,
Is there is a way to batch export patron data from one Koha to another Koha?
Thank you in advance!
Regards, Russel Librarian Namibia Library and Archives Service _______________________________________________
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
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Dear Katrin Thank you for the valuable input. Regards Russel On Mon, Dec 6, 2021 at 1:25 AM Katrin Fischer <katrin.fischer.83@web.de> wrote:
Hi,
moving all this data would be much more complicated than just moving the patrons from one installation to the other. In order to move the loans, you'd also need to add the bibliographic records/items to the other system, possibly matching with existing records, etc. There are currently no scripts/tools in Koha to do this.
Hope this helps,
Katrin
On 01.12.21 04:11, Bravismore Mumanyi wrote:
Just thinking aloud here. Will this process take care of active loans linked to these patrons? Any past anonymised stats, etc.
Regards
On Tue, 30 Nov 2021, 19:06 Eric Phetteplace, <ephetteplace@cca.edu> wrote:
Hi Russel,
Since you can batch import patrons < https://koha-community.org/manual/21.05/en/html/tools.html#patron-import> using a CSV and export reports to CSV, yes, there's a relatively simple way to transfer patrons from one instance to another. Write a report that grabs all the columns and patrons you want to transfer (essentially `SELECT * FROM borrowers`), download it to a CSV, and import on your other instance. There are more options and nuances to it, but that is all you have to do.
Best,
ERIC PHETTEPLACE Systems Librarian, Libraries (he/him)
ephetteplace@cca.edu | o 510.594.3660 (cca)
5212 Broadway | Oakland, CA | 94618
CCA is situated on the traditional unceded lands of the Ohlone peoples.
Black-owned bookstores in Oakland: Ashay by the Bay <https://ashaybythebay.com/>, Marcus Books <https://www.facebook.com/marcus.books/>
:(){ :|: & };:
On Tue, Nov 30, 2021 at 5:56 AM Russel G. P. Shihepo < russellgeeps@gmail.com> wrote:
Hi,
Is there is a way to batch export patron data from one Koha to another Koha?
Thank you in advance!
Regards, Russel Librarian Namibia Library and Archives Service _______________________________________________
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
_______________________________________________
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 (4)
-
Bravismore Mumanyi -
Eric Phetteplace -
Katrin Fischer -
Russel G. P. Shihepo