Re: [OPEN-ILS-GENERAL] introduction and quick database question
Acquisitions is one addition in 1.6, Serials and all holding information in *separate* records (following MFHD) another: is there an update of the 1.4 schema below that covers the 1.6 serials schema and everything related ? Did a Google search and found bits and pieces but nothing systematic in one place - may have overlooked. Thanks (thx for this 1.4 pointer), Repke IISH Op 8-dec-2009, om 0:39 heeft Don McMorris het volgende geschreven: snip If you haven't yet seen it, this (http://open-ils.org/documentation/evergreen-schema-1.4.0.2.html) can be pretty helpful. There are some additions in 1.6 (Ex: Acq), but I find it quite helpful quite often. Hope this helps! --Don snip
[OPEN-ILS-GENERAL] introduction and quick database question
I am the director of a library in a consortium of small libraries in the Dallas-Fort Worth metroplex area of Texas. We launched Evergreen a few months ago. I am working on some reports that go beyond the basic capabilities of the built-in reporting tool in Evergreen, so I am pulling the data via standard SQL queries. I have one quick question: I don't see title and author information anywhere within any of the ASSET tables (other than empty dummy_title and dummy_author fields in asset_copy), so I looked to the METABIB table to pull that information. However, I am having trouble locating the common identifier to tie the tables together when I JOIN them so I can link the appropriate author and title information to the individual copies. I know I must be overlooking something obvious, but if someone could give me a quick hint, I would really appreciate it! Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com
Re: [OPEN-ILS-GENERAL] introduction and quick database question
I don’t see “title” and “author” information anywhere within any of the ASSET tables (other than empty “dummy_title” and “dummy_author” fields in asset_copy), so I looked to the METABIB table to pull that information. However, I am having trouble locating the common identifier to tie the tables together when I JOIN them so I can link the appropriate author and title information to the individual copies. I know I must be overlooking something obvious, but if someone could give me a quick hint, I would really appreciate it! Hi Jesse, asset.copy has .call_number, which links to asset.call_number asset.call_number has .record, which links to biblio.record_entry biblio.record_entry has .marc, which contains the entire bib record in MARCXML But unless you want to use XPATH, that's probably not convenient, so... that XML has been exploded into metabib.full_rec metabib.full_rec has .record, which links back to biblio.record_entry and metabib.full_rec has .tag, .subfield, and .value, which can get you anything you need. But even more convenient is reporter.materialized_simple_record, which is based off of reporter.simple_record, which is a large view based on metabib.full_rec. It has fields for .title, .author, .publisher, .pubdate, .isbn and .issn. reporter.materialized_simple_record has a .id field which corresponds with the .id field for biblio.record_entry Does this help? -- Jason Etheridge | VP, Tactical Development | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: ja...@esilibrary.com | web: http://www.esilibrary.com Please join us for the Evergreen 2010 International Conference, April 20-23, 2010 at the Amway Grand Hotel and Convention Center, Grand Rapids, Michigan. http://www.evergreen2010.org/
Re: [OPEN-ILS-GENERAL] introduction and quick database question
I believe you're looking for biblio.record_entry. This (generally) corresponds to the source or record value of your metabib tables (if you do a '\d metabib.title_field_entry' [for example], you should see a foreign key constraint'). An item (asset.copy) will link to a title (biblio.record_entry) via a volume (asset.call_number). There are also a number of useful views in the reporter schema. If you haven't yet seen it, this (http://open-ils.org/documentation/evergreen-schema-1.4.0.2.html) can be pretty helpful. There are some additions in 1.6 (Ex: Acq), but I find it quite helpful quite often. Hope this helps! --Don On Mon, Dec 7, 2009 at 6:30 PM, Jesse Ephraim jephr...@roanoketexas.com wrote: I am the director of a library in a consortium of small libraries in the Dallas-Fort Worth metroplex area of Texas. We launched Evergreen a few months ago. I am working on some reports that go beyond the basic capabilities of the built-in reporting tool in Evergreen, so I am pulling the data via standard SQL queries. I have one quick question: I don’t see “title” and “author” information anywhere within any of the ASSET tables (other than empty “dummy_title” and “dummy_author” fields in asset_copy), so I looked to the METABIB table to pull that information. However, I am having trouble locating the common identifier to tie the tables together when I JOIN them so I can link the appropriate author and title information to the individual copies. I know I must be overlooking something obvious, but if someone could give me a quick hint, I would really appreciate it! Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com
Re: [OPEN-ILS-GENERAL] introduction and quick database question
Don and Jason; That's perfect - exactly what I needed! Thanks much (and thanks for the link to the schema)! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com