[Koha] Listing all biblio records

[Father Vlasie]

Dear Ah Win,

The SQL examples from this page: https://wiki.koha-community.org/wiki/SQL_Reports_Library <https://wiki.koha-community.org/wiki/SQL_Reports_Library>

Can be copied and pasted into the custom SQL reports in Home › Reports (your-koha-install/cgi-bin/koha/reports/reports-home.pl)

1) Copy the SQL from the sample

2) On the Reports page choose + Create from SQL

3) Enter a name for the report

4) Paste in the sample in the SQL box and click Save.

5) Click Saved Reports in the left hand column

6) Click Run on the report you would like.

Let us know if it works.

Father Vlasie

St. Photios Orthodox Theological Seminary
510 Collier Way, Etna, CA 96027, U.S.A.

Website: www.spots.school


> On 28 May 2018, at 20:29, Ah Win <ahwin2006 at gmail.com> wrote:
> 
> Dear Indranil,
> 
> I am new to the list and librarian from Myanmar.
> 
> Please help me the way if we are not handy with SQL.
> For both import and export, please.
> 
> Many thanks.
> Ah Win
> 
> 
> 
> 
> 
> 
> On 27 May 2018 at 03:37, Indranil Das Gupta <indradg at gmail.com <mailto:indradg at gmail.com>> wrote:
> On Sun 27 May, 2018, 2:33 AM Father Vlasie, <fv at spots.school> wrote:
> 
> > Hello everyone,
> >
> > Is there an easy way to export a list of all items in a Koha database?
> >
> 
> If you are handy with SQL, take a look at
> https://wiki.koha-community.org/wiki/SQL_Reports_Library <https://wiki.koha-community.org/wiki/SQL_Reports_Library>
> 
> Particularly at the section Bibliographic / Catalogue reports.
> 
> 
> 
> > TIA
> > FV
> > _______________________________________________
> > Koha mailing list  http://koha-community.org <http://koha-community.org/>
> > Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
> > 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 at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
> https://lists.katipo.co.nz/mailman/listinfo/koha <https://lists.katipo.co.nz/mailman/listinfo/koha>
>