[OPEN-ILS-GENERAL] quotes needed for migration of data

be interested. Many thanks, Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com 817-491-2691

[OPEN-ILS-GENERAL] SQL question

I need to count (via SQL) the number of checkout transactions that fall with 1/1/2012 and 12/31/2012. Could someone point me at the right table/fields to look at checkout transactions for my library (we are in a consortium). Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S

Re: [OPEN-ILS-GENERAL] SQL question

Thanks much, Aaron – I appreciate it! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com 817-491-2691 From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Aaron

Re: [OPEN-ILS-GENERAL] Evergreen T-Shirts

I would buy one if the background wasn't white. Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com 817-491-2691 From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf

[OPEN-ILS-GENERAL] physical and mailing addresses in database

Can anyone tell me where I can find a patron's mailing and physical addresses in the database? Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com 817-491-2691

Re: [OPEN-ILS-GENERAL] physical and mailing addresses in database

Well, duh, of course. I was doing something stupid. Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com 817-491-2691 -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general

Re: [OPEN-ILS-GENERAL] Dymo printer settings

We use the Dymo LabelWriter 450 (http://www.amazon.com/gp/product/B0027JIIKQ/ref=oh_details_o01_s00_i00). I can put you in contact with the staff member who set it up, if you like. Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com 817-491

Re: [OPEN-ILS-GENERAL] Where, oh where ...

to the installation process. Most of the major docs that have been done are available here: http://docs.evergreen-ils.org/ http://www.open-ils.org/dokuwiki/doku.php Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com 817-491-2691 From: open

[OPEN-ILS-GENERAL] circ numbers after status change

. Is there any way to retain those past statistics when an item's status is changed to missing? Thanks! Jesse Ephraim Roanoke Public Library Roanoke, TX

Re: [OPEN-ILS-GENERAL] shared report templates don't display correctly for one location

Thomas; Should we run it as non-admin, OpenSRF, or root? Should we run configure after that? Is it something we should do after hours, when the libraries are closed (we have 14 libraries on the system)? Will it need a server restart, or a restart of anything else? Jesse Ephraim Director

[OPEN-ILS-GENERAL] fine generator

to notify you when key processes hang up or stop? Thanks much! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com

Re: [OPEN-ILS-GENERAL] fine generator

Thanks, Thomas! I appreciate it! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun

Re: [OPEN-ILS-GENERAL] odd problem

/opensrf/opensrf-2.0.1/bin? Thanks much! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun

[OPEN-ILS-GENERAL] odd problem

anyone have any suggestions on what files I might need to look at to get a better grip on this issue? I'm sort of at a loss at the moment. Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com

Re: [OPEN-ILS-GENERAL] odd problem

Ben; We are on 2.0.9. Thank you for pointing out that bug report. We are going to test it this evening, and see if that is the root of the problem. The library in question is one of the largest in our consortium, so that may very well be the issue. Jesse Ephraim Director, Roanoke Public

Re: [OPEN-ILS-GENERAL] odd problem

] )@http://catalog.northtexaslibraries.org/opac/common/js/RemoteRequest.js:194\n;, name:TypeError } Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com From: open-ils-general-boun...@list.georgialibraries.org

Re: [OPEN-ILS-GENERAL] global.juvenile_age_threshold

Bill; Thanks much - I really appreciate it! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun

[OPEN-ILS-GENERAL] global.juvenile_age_threshold

a statistical category, or does it affect other things? Is it included in a SIP patron info response? Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com

[OPEN-ILS-GENERAL] screenshots

of these issues, we 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] Default state setting in patron driver's license field

Dan; Thank you very much! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org

Re: [OPEN-ILS-GENERAL] .iso file?

Rick; Thank you very, very much! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com From: Rick Mason [mailto:r...@libology.com] Sent: Wednesday, August 17, 2011 11:02 PM To: Evergreen Discussion Group Cc: Jesse Ephraim

Re: [OPEN-ILS-GENERAL] evergreen-ils footer change

on this list created such a thing? Has anyone created one in the interim? Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com

[OPEN-ILS-GENERAL] .iso file?

on this list created such a thing? Has anyone created one in the interim? Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.commailto:jephr...@roanoketexas.com

Re: [OPEN-ILS-GENERAL] Export patrons

You can get much more robust reports if you run SQL queries against the PostgreSQL database. The reporting tool built into the Evergreen client was too basic for our needs, so we switched to doing direct SQL queries a year ago. Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut

[OPEN-ILS-GENERAL] Where can I find the staff client for 1.6.0.2?

Does anyone know where I can download the staff client for 1.6.0.2? Thanks! Jesse

Re: [OPEN-ILS-GENERAL] Where can I find the staff client for 1.6.0.2?

Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Where can I find the staff client for 1.6.0.2? Hi, On Apr 12, 2011, at 5:15 PM, Jesse Ephraim wrote: Does anyone know where I can download the staff client for 1.6.0.2? This is an old version, but: http://evergreen-ils.org/downloads/evergreen-setup

Re: [OPEN-ILS-GENERAL] Newbie Question: Any live cd for evergreen?

It would be really nice if there were one, but I haven’t encountered one. Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general

[OPEN-ILS-GENERAL] cash and Evergreen

to generate a receipt for cash taken without having to bill a generic account and then pay it? We are trying to streamline and improve our cash handling procedures. Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com

[OPEN-ILS-GENERAL] circulation

? Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com

Re: [OPEN-ILS-GENERAL] circulation

Bill; That's exactly what I needed. Thank you VERY much! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun

Re: [OPEN-ILS-GENERAL] ports

Robert; Thanks for doing that! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun

Re: [OPEN-ILS-GENERAL] RFID

I would be very interested in that information, too. Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun

Re: [OPEN-ILS-GENERAL] Spine Labels

While we're talking about spine labels, is there any way (from Evergreen) to make the letters bold? Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com -Original Message- From: open-ils-general-boun

[OPEN-ILS-GENERAL] receipt printers

I need to buy two more receipt printers. Our current one is a Star SP200. Does anybody have any recommendations of good ones (impact or thermal) that play well with Evergreen? Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691

Re: [OPEN-ILS-GENERAL] installation question

kept watching for it during the OpenSRF installation, but never saw it appear. Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com -Original Message- From: open-ils-general-boun...@list.georgialibraries.org

Re: [OPEN-ILS-GENERAL] installation question

I reinstalled Debian Lenny with no problems. I am partway through installing OpenSRF, to the point where I need to set up the Jabber users. After making the appropriate changes to ejabberd.cfg, I restarted ejabberd, as per the instructions. When I issued this command roanoke:/etc/ejabberd#

Re: [OPEN-ILS-GENERAL] installation question

for the help! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason

Re: [OPEN-ILS-GENERAL] installation question

What should $PERL5LIB have in it? Do you think I should re-install OpenSRF? If so, should I just install over the current one, or do something to remove the current one? Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr

Re: [OPEN-ILS-GENERAL] OPEN-ILS-GENERAL] Spine Label Printers?

. Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com

[OPEN-ILS-GENERAL] open source status

of Evergreen/Equinox and Koha/LibLime), but wanted to double-check it here. Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com

Re: [OPEN-ILS-GENERAL] open source status

Jason; Thanks for the quick answer! I figured the rumor was incorrect, but I thought it best to ask anyway, so I can pass on the definitive answer to others. Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com

Re: [OPEN-ILS-GENERAL] open source status

Wow. That's a crazy rumour. Did it come from a salescritter? They have been known to suffer from prevarication-and-wild-distortion syndrome. No, I suspect that it came from a mis-reading of an article about the Koha code forking arguments. Jesse Ephraim Director, Roanoke Public Library 308 S

Re: [OPEN-ILS-GENERAL] open source status

Wow. That would seem to be a poor decision on LibLime's part. Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com -Original Message- Ack, let's not FUD the FUD Koha is not releasing a special version. Liblime

Re: [OPEN-ILS-GENERAL] Email notification

to a patron? Thanks much! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com

Re: [OPEN-ILS-GENERAL] holds

Jason and Mike; Thanks much! I appreciate it! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691 jephr...@roanoketexas.com

[OPEN-ILS-GENERAL] holds

We have noticed that patrons are able to renew items even if other patrons have placed holds on them. Does anyone know if that is a settings issue, or is it an inherent flaw in Evergreen? Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, Texas 76262 (817) 491-2691

[OPEN-ILS-GENERAL] introduction and quick database question

! 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