exporting MARC records on mysql conditions
Hi, the online export tool for bibliographic records allows to select records in a given range of either biblio number, or item call number, or accession date. Would it be possible (perhaps via an off-line script) to select records fulfilling other constraints? (Say, a full mysql "where..." condition.) If not, would it be possible to extract (single) MARC records by off-line invoking export.pl on (single) biblio numbers? (One could have saved a list thereof in an auxiliary file, and then iteratively call export.pl via some script.) Many thanks in advance. Giuseppe.
If you have activated the z39 server in koha you can add it as a source in Marcedit and do a batch search using a file of biblionumbers. A script would probably be faster, but I use that as an easy workaround. On Sat, Jan 31, 2015 at 1:25 AM, Giuseppe Angilella < Giuseppe.Angilella@ct.infn.it> wrote:
Hi,
the online export tool for bibliographic records allows to select records in a given range of either biblio number, or item call number, or accession date.
Would it be possible (perhaps via an off-line script) to select records fulfilling other constraints? (Say, a full mysql "where..." condition.)
If not, would it be possible to extract (single) MARC records by off-line invoking export.pl on (single) biblio numbers? (One could have saved a list thereof in an auxiliary file, and then iteratively call export.pl via some script.)
Many thanks in advance.
Giuseppe. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Nick Clemens Quechee & Wilder Libraries Nick@quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341
If you have installed Koha by debian packages, you can use koha-mysql <instance> command in linux shell script like this: biblionumbers = $(echo "select biblionumber from biblio where [your condition]" | koha-mysql) and than you can work variable $biblionumbers, save it in some temporary file and use it as list for export.pl. There should be a parameter to set file with biblionumbers as base for export I think... Josef On Sat, Jan 31, 2015 at 7:25 AM, Giuseppe Angilella < Giuseppe.Angilella@ct.infn.it> wrote:
Hi,
the online export tool for bibliographic records allows to select records in a given range of either biblio number, or item call number, or accession date.
Would it be possible (perhaps via an off-line script) to select records fulfilling other constraints? (Say, a full mysql "where..." condition.)
If not, would it be possible to extract (single) MARC records by off-line invoking export.pl on (single) biblio numbers? (One could have saved a list thereof in an auxiliary file, and then iteratively call export.pl via some script.)
Many thanks in advance.
Giuseppe. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Josef Moravec josef.moravec@gmail.com
participants (3)
-
Giuseppe Angilella -
Josef Moravec -
Nick Clemens