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...@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...@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-r...@inlibro.com <mailto:caroline.cyr-la-r...@inlibro.com>
INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com
<http://www.inLibro.com>
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
