[Koha] BULK IMPORT REPORTS

[Caroline Cyr-La-Rose]

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 at 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 at 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 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
>>>
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at 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 at inLibro.com <mailto:caroline.cyr-la-rose at inLibro.com>

INLiBRO | Spécialistes en technologies documentaires | www.inLibro.com 
<http://www.inLibro.com>