Hi James, if you are not comfortable with SQL it's quite hard to explain how to do this from scratch. At least I am not sure how to explain it well. Sorry! Katrin On 13.03.21 13:47, muiru james wrote:

Thanks Katrin for your reply.

Could you give me more details on how to go about it so that I can give it a try?

Most appreciated

Regards James

On Sat, Mar 13, 2021 at 2:46 PM Katrin Fischer <katrin.fischer.83@web.de <mailto:katrin.fischer.83@web.de>> wrote:

Hi,

at the moment it's not possible to export/import reports from the staff interface/GUI. You could try and use SQL to do it server side. All reports can be found in the table saved_sql.

Hope this helps,

Katrin

On 13.03.21 10:07, muiru james wrote: > Hi, > > Is there a way to add export reports from one system and add them in bulk > to a new server? > > Regards > James > _______________________________________________ > > Koha mailing list http://koha-community.org <http://koha-community.org> > Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha <https://lists.katipo.co.nz/mailman/listinfo/koha> _______________________________________________

Koha mailing list http://koha-community.org <http://koha-community.org> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha <https://lists.katipo.co.nz/mailman/listinfo/koha>

Hello James, I suggest you search Google for mysqldump. it's usually something like mysqldump -u yourusername -p your_koha_database table > file.sql so for me, exporting my reports would look like mysqldump -u caroline -p koha_v20_inlibro_dev saved_sql > reports.sql Then you can import this sql file as is into your new installation (this will overwrite any reports that are already in your new installation) Something like mysql -u yourusername -p your_koha_database < file.sql If you don't want to overwrite the existing reports, you'd have to edit the sql file to remove everything except the "insert into" line. Save the file and then import it. I hope this helps, Caroline On 21-03-27 03 h 27, muiru james wrote:

Hello Katrin,

Any help you offer will be greatly appreciated on how to go about it.

Regards James

On Thu, 25 Mar 2021, 00:29 Katrin Fischer, <katrin.fischer.83@web.de> wrote:

...

Hi James,

if you are not comfortable with SQL it's quite hard to explain how to do this from scratch. At least I am not sure how to explain it well.

Sorry!

Katrin On 13.03.21 13:47, muiru james wrote:

Thanks Katrin for your reply.

Could you give me more details on how to go about it so that I can give it a try?

Most appreciated

Regards James

On Sat, Mar 13, 2021 at 2:46 PM Katrin Fischer <katrin.fischer.83@web.de> wrote:

...

Hi,

at the moment it's not possible to export/import reports from the staff interface/GUI. You could try and use SQL to do it server side. All reports can be found in the table saved_sql.

Hope this helps,

Katrin

On 13.03.21 10:07, muiru james wrote:

...

Hi,

Is there a way to add export reports from one system and add them in bulk to a new server?

Regards James _______________________________________________

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

-- Caroline Cyr La Rose, M.S.I. Bibliothécaire | Responsable de produit Tél. : 1-833-465-4276, poste 221 Caroline.Cyr-La-Rose@inLibro.com <mailto:caroline.cyr-la-rose@inLibro.com> INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com <http://www.inLibro.com>