Exporting Records with Mercury Z39.50 Client

Records can be exported in a variety of formats. To export a record have the record you want exported displayed in the details pane. Then from the menu select export then the method you wish to use to export. Currently only one record can be exported at a time. Exporting multiple records is being worked on and should appear in the next version.

MARC

To export the current record, select from the menu Export -> MARC, then select the destination and name of the file you wish to save the record as.

Text

To export the current record, select from the menu Export -> TEXT, then select the destination and name of the file you wish to save the record as. The text format is a readable text version of a MARC record.

XML

To export the current record, select from the menu Export -> XML, then select the destination and name of the file you wish to save the record as.

XSL Transformation

To export the current record, select from the menu Export -> XSL Transformation, then select the XSL file you wish to use for the transformation then select the destination and name of the file you wish to save the record as.

Direct to Database

Records can be inserted directly into any OLE DB database.

The export to database feature is new and is currently very limited.

First construct an SQL INSERT query such as INSERT INTO tablename(title, record) VALUES('{TITLE}', '{MARCRECORD}') using tags for values. Before the query is executed the tags will be replaced by the data of the current selected record.

Currently only the following tags are supported:

{MARCRECORD} - insert MARC record

{XMLRECORD} - insert XML record

{TXTRECORD} - insert text record

{TITLE} - insert title from MARC field 245

{AUTHOR} - insert author. this can come from a variety of different locations depending on the MARC record

and

{TARGETNAME} - the name of the database Tags have to be enclosed in quotes.

Secondly select the database. Click on the edit button to create or edit a connection string to a database.

Lastly click on OK to execute the INSERT query.