Re: [OPEN-ILS-GENERAL] Introduction
Lori, Your experience with programming helped develop your brain to understand machine processes. It's a pretty invaluable thing when it comes to making Evergreen hum. Who knows? You might be ready to learn a new computer language ;) -- Ruth Frasur Director of the Historic(ally Awesome) Hagerstown - Jefferson Township Library 10 W. College Street in Hagerstown, Indiana (47346) p (765) 489-5632; f (765) 489-5808 Our Kickin' Website http://hagerstownlibrary.org/ Our Rockin' Facebook Page http://facebook.com/hjtplibrary and Stuff I've Read http://pinterest.com/hjtplibrary/ruth-reads/
Re: [OPEN-ILS-GENERAL] Introduction
Welcome to the group, Lori! I agree with Ruth - even if you don't participate in any programming, your understanding of machine logic and processes can be invaluable in participating in testing and documentation :) Terran McCanna PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, GA 30345 404-235-7138 tmcca...@georgialibraries.org - Original Message - From: leichterl leicht...@larl.org To: open-ils-general@list.georgialibraries.org Sent: Wednesday, August 19, 2015 2:19:37 PM Subject: [OPEN-ILS-GENERAL] Introduction Hello, Evergreen Community, I'm Lori Leichter, a library assistant at the Detroit Lakes branch of the Lake Agassiz Regional Library system. I've been here just over 7 years. Many, many, many years before starting here I did programming- in assembly language, using floppy disks (an upgrade from the IBM cards I used while getting my degree.) Pretty sure that, even if I could remember any of those skill, they would not be too useful now, but that experience is the source of my great respect for modern programmers and the amazing things they can get computers to do. Hope I can be of some help!
[OPEN-ILS-GENERAL] Introduction
Hello, Evergreen Community, I'm Lori Leichter, a library assistant at the Detroit Lakes branch of the Lake Agassiz Regional Library system. I've been here just over 7 years. Many, many, many years before starting here I did programming- in assembly language, using floppy disks (an upgrade from the IBM cards I used while getting my degree.) Pretty sure that, even if I could remember any of those skill, they would not be too useful now, but that experience is the source of my great respect for modern programmers and the amazing things they can get computers to do. Hope I can be of some help!
Re: [OPEN-ILS-GENERAL] Introduction
Welcome to the community, Danell, Kristi, Matthew, and Jennifer! I've been an Evergreen user since 2009, but I've only started becoming involved in the broader community in the past two years so I still feel relatively new, but I participate as much as I am able to. People are very helpful, and I find it very gratifying to be able to play a part in improving the product and the documentation and seeing it make a difference (even if it's in a very small way - one of my bug fixes involved getting rid of a stray semicolon in the OPAC!) Best of luck with your upcoming migration, Kristi. I think you'll be very happy with how all of the improvements that have been made to the software since you were with Indiana. Terran McCanna PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, GA 30345 404-235-7138 tmcca...@georgialibraries.org
Re: [OPEN-ILS-GENERAL] Introduction
Hello, Welcome to the community. I volunteer with the documentation group, so we will probably be crossing paths sooner or later. Take care, Yamil On Thu, Aug 13, 2015 at 5:27 PM, Danell Haspel hasp...@exchange.larl.org wrote: Hello Evergreen Community, I am a staff member at Lake Agassiz Regional Library System in the Detroit Lakes Library. Detroit Lakes and surrounding area is known for its many lakes. We provide many services in our library for summer tourists, and we have many patrons/customers that are snowbirds going south for the long Minnesota winters. I've been at the Detroit Lakes Library as an associate librarian for 10 years. I write a weekly library column for our newspaper, The Detroit Lakes Tribune, and I really enjoy proofreading, so when I saw catching typos on the list of possible tasks for the Evergreen Committee I joined up. My husband and I were high school sweethearts, and have been married 37 years. We have three grown children, Nate, Erin and Ryan who are all married. We have six grandchildren whose ages range from 2-12 years old, and they keep us young (and busy). I loved the slide show, and so far I'm just trying to fight the fear factor! Danell Haspel -- Yamil Suarez, MCS Library System Administrator/Developer Stan Getz Library Berklee College of Music 1140 Boylston St Boston, MA 02215 ysua...@berklee.edu 617-747-2617
[OPEN-ILS-GENERAL] Introduction
Good morning, I'm Kristi Hanson, and I am the director of the Northwest Regional Library. My office is in Thief River Falls, MN. There are seven libraries and two LINK sites in my region. I have been a librarian for 17 years. While I was in Indiana, I chaired the Evergreen committee for a year, when the state library was helping to migrate public libraries to Evergreen. I am familiar with Evergreen from the admin side as well as the library staff/patron side and I am very excited that my library region, along with LARL, is going to migrate this year. Kristi -- Kristi D. Hanson, NWRL Director 210 LaBree Avenue North Thief River Falls, MN 56701 218-681-1066 x 1
[OPEN-ILS-GENERAL] Introduction
Hello, My name is Jenn Johnson and my journey at Lake Agassiz Regional Library as a Branch Librarian started in January of 2015. I try to make sure all the little pieces of the library come together in a neat and orderly fashion for the Hawley Public Library patrons. I graduated from Minnesota State University, Moorhead in 2012 with psychology and Criminal Justice degrees but decided to take another road after graduation. I am now enrolled as an online Graduate Student at Southern New Hampshire University in the Public History program. I keep busy with my two jobs, school, amazing husband of a year and half, and my highly entertaining and busy 9 year old step son. -- Jennifer Johnson - Library Associate I Hawley Public Library Lake Agassiz Regional Library
Re: [OPEN-ILS-GENERAL] Introduction
Kristi, Welcome to the EG general list. Good luck on the migration. Have a good weekend, Yamil On Fri, Aug 14, 2015 at 10:01 AM, Kristi Hanson hans...@nwrlib.org wrote: Good morning, I'm Kristi Hanson, and I am the director of the Northwest Regional Library. My office is in Thief River Falls, MN. There are seven libraries and two LINK sites in my region. I have been a librarian for 17 years. While I was in Indiana, I chaired the Evergreen committee for a year, when the state library was helping to migrate public libraries to Evergreen. I am familiar with Evergreen from the admin side as well as the library staff/patron side and I am very excited that my library region, along with LARL, is going to migrate this year. Kristi -- Kristi D. Hanson, NWRL Director 210 LaBree Avenue North Thief River Falls, MN 56701 218-681-1066 x 1 -- Yamil Suarez, MCS Library System Administrator/Developer Stan Getz Library Berklee College of Music 1140 Boylston St Boston, MA 02215 ysua...@berklee.edu 617-747-2617
Re: [OPEN-ILS-GENERAL] Introduction
Matt, Nice to meet you. Josh has been very helpful to the community in a short amount of time. I am glad he is involving his co-workers to help the EG community grow. Take care, Yamil On Fri, Aug 14, 2015 at 10:25 AM, Matthew Berowski berows...@exchange.larl.org wrote: Hello Evergreen Community, My name is Matt Berowski and I work with the Lake Agassiz Regional Library in Moorhead in the Regional office as the computer technician for the past year working with Josh on many projects, as well as helping maintaining our public/staff machines for the 13 branches and 9 Link sites. I Graduated from Minnesota State University December 19, 2013 with a Bachelors in Information technology and have lived in the Moorhead area for the past 6 years. My Girlfriend and I met at 4 years ago at a previous job and now have one child (Brayden) who will be turning 2 on Christmas of this year, who is really good at keeping both of us busy when he’s in one of his moods, which thankfully isn’t often. Matt Berowski Computer Tech Lake Agassiz Regional Library 118 5th Street South Moorhead, MN 56560 -- Yamil Suarez, MCS Library System Administrator/Developer Stan Getz Library Berklee College of Music 1140 Boylston St Boston, MA 02215 ysua...@berklee.edu 617-747-2617
Re: [OPEN-ILS-GENERAL] Introduction
Jenn, Welcome aboard. So far I have worked extensively with Josh from your system within the EG community. Looking forward to collaborating with you and others from this system. Yamil On Fri, Aug 14, 2015 at 2:40 PM, Jennifer Johnson johns...@larl.org wrote: Hello, My name is Jenn Johnson and my journey at Lake Agassiz Regional Library as a Branch Librarian started in January of 2015. I try to make sure all the little pieces of the library come together in a neat and orderly fashion for the Hawley Public Library patrons. I graduated from Minnesota State University, Moorhead in 2012 with psychology and Criminal Justice degrees but decided to take another road after graduation. I am now enrolled as an online Graduate Student at Southern New Hampshire University in the Public History program. I keep busy with my two jobs, school, amazing husband of a year and half, and my highly entertaining and busy 9 year old step son. -- Jennifer Johnson - Library Associate I Hawley Public Library Lake Agassiz Regional Library -- Yamil Suarez, MCS Library System Administrator/Developer Stan Getz Library Berklee College of Music 1140 Boylston St Boston, MA 02215 ysua...@berklee.edu 617-747-2617
[OPEN-ILS-GENERAL] Introduction
Hello Evergreen Community, My name is Matt Berowski and I work with the Lake Agassiz Regional Library in Moorhead in the Regional office as the computer technician for the past year working with Josh on many projects, as well as helping maintaining our public/staff machines for the 13 branches and 9 Link sites. I Graduated from Minnesota State University December 19, 2013 with a Bachelors in Information technology and have lived in the Moorhead area for the past 6 years. My Girlfriend and I met at 4 years ago at a previous job and now have one child (Brayden) who will be turning 2 on Christmas of this year, who is really good at keeping both of us busy when he's in one of his moods, which thankfully isn't often. Matt Berowski Computer Tech Lake Agassiz Regional Library 118 5th Street South Moorhead, MN 56560
[OPEN-ILS-GENERAL] Introduction
Hello Evergreen Community, I am a staff member at Lake Agassiz Regional Library System in the Detroit Lakes Library. Detroit Lakes and surrounding area is known for its many lakes. We provide many services in our library for summer tourists, and we have many patrons/customers that are snowbirds going south for the long Minnesota winters. I've been at the Detroit Lakes Library as an associate librarian for 10 years. I write a weekly library column for our newspaper, The Detroit Lakes Tribune, and I really enjoy proofreading, so when I saw catching typos on the list of possible tasks for the Evergreen Committee I joined up. My husband and I were high school sweethearts, and have been married 37 years. We have three grown children, Nate, Erin and Ryan who are all married. We have six grandchildren whose ages range from 2-12 years old, and they keep us young (and busy). I loved the slide show, and so far I'm just trying to fight the fear factor! Danell Haspel
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
Re: [OPEN-ILS-GENERAL] Introduction to Evergreen Development workshop, October 29, 2009
Hi Dan, Any chance I can get you to do this workshop in California? If yes, let me know what your fee would be and how many hours it is. Lori Ayre On Sun, Oct 4, 2009 at 8:13 PM, Dan Scott d...@coffeecode.net wrote: Evergreen folks in the Toronto, Ontario area might be interested in attending the 3-hour workshop that I'll be giving at the Free Software / Open Source Symposium (FSOSS) on October 29, 2009. More information about the workshop is available on my blog at: http://coffeecode.net/archives/199-Evergreen-Developer-Basics-Workshop-at-FSOSS-2009.html More information about FSOSS is available from http://fsoss.ca - but the basics are that $70 gets you a day of workshops and a day of presentations - and some food, too, if the pattern holds from last year's event.
Re: [OPEN-ILS-GENERAL] Introduction to Evergreen Development workshop, October 29, 2009
Hi Lori: On Tue, 2009-10-06 at 15:58 -0700, Lori Ayre wrote: Hi Dan, Any chance I can get you to do this workshop in California? If yes, let me know what your fee would be and how many hours it is. Hmm... we're heading into winter here in Canada, my arm could probably be twisted... For anyone interested in the workshop content but not able to get to Toronto this month, I intend to make all of the workshop materials that I develop freely available under a CC license, and I will refine and extend them over time. The FSOSS time slot is for a three hour workshop but given the complexity of the subject matter it could easily be extended for subsequent sessions. For example, I will be giving a similar four hour workshop at the OLA SuperConference in Toronto at the end of January 2010 (http://www.accessola.com/superconference2010/ - although the content on the site still seems to mostly be from 2009). On Sun, Oct 4, 2009 at 8:13 PM, Dan Scott d...@coffeecode.net wrote: Evergreen folks in the Toronto, Ontario area might be interested in attending the 3-hour workshop that I'll be giving at the Free Software / Open Source Symposium (FSOSS) on October 29, 2009. More information about the workshop is available on my blog at: http://coffeecode.net/archives/199-Evergreen-Developer-Basics-Workshop-at-FSOSS-2009.html More information about FSOSS is available from http://fsoss.ca - but the basics are that $70 gets you a day of workshops and a day of presentations - and some food, too, if the pattern holds from last year's event.
[OPEN-ILS-GENERAL] Introduction to Evergreen Development workshop, October 29, 2009
Evergreen folks in the Toronto, Ontario area might be interested in attending the 3-hour workshop that I'll be giving at the Free Software / Open Source Symposium (FSOSS) on October 29, 2009. More information about the workshop is available on my blog at: http://coffeecode.net/archives/199-Evergreen-Developer-Basics-Workshop-at-FSOSS-2009.html More information about FSOSS is available from http://fsoss.ca - but the basics are that $70 gets you a day of workshops and a day of presentations - and some food, too, if the pattern holds from last year's event.