A possibile solution: mysql_prompt> SELECT marc FROM biblioitems WHERE ExtractValue(marcxml,'count(//datafield[@tag="040"]/subfield[@code="a"])>0') into outfile '/full/path/to/yourfile.mrc' fields terminated by '' lines terminated by '';
HTH. Stefano On 04/giu/2013, at 12.00, Mohamed zalabany wrote: > Date: Tue, 4 Jun 2013 07:28:27 +0000 > From: Mohamed zalabany <[email protected]> > To: koha_developers <[email protected]> > Subject: [Koha-devel] Extracting bibliographic records with specified > criteria > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > Hi all > i wish you all fine > I need to extract some bibliographic record from my catalog depanding on > search criterea in MARC field 040$c > how could i do that and extract this records in one file > i think i could do that from the reports but how to make one file of all the > record to import it later in another system > Thanks, > Best Regrades > > Mohamed El-Zalabany > Librotech group > for library systems and information technology _______________________________________________ Koha-devel mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
