Hello everyone, Is there an easy way to export a list of all items in a Koha database? TIA FV
On Sun 27 May, 2018, 2:33 AM Father Vlasie, <fv@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 Particularly at the section Bibliographic / Catalogue reports.
TIA FV _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@gmail.com> wrote:
On Sun 27 May, 2018, 2:33 AM Father Vlasie, <fv@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
Particularly at the section Bibliographic / Catalogue reports.
TIA FV _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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@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@gmail.com <mailto:indradg@gmail.com>> wrote: On Sun 27 May, 2018, 2:33 AM Father Vlasie, <fv@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@lists.katipo.co.nz <mailto:Koha@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@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha <https://lists.katipo.co.nz/mailman/listinfo/koha>
participants (3)
-
Ah Win -
Father Vlasie -
Indranil Das Gupta