Re: [OPEN-ILS-GENERAL] TSP100 Printing Setup for Mac

2014-08-07 Thread Aaron Zsembery
- Original Message - 
 On Wednesday, August 6, 2014 10:24:54 AM Thomas Merkl 
 tme...@peasepubliclibrary.org wrote:
 We are setting up to go live on Evergreen 2.5.1 and am having
 problems printing to the Star Micronics TSP100 printer. After
 setting up the printer through a USB connection to an iMac the
 printed results are printing out, but are printing with a much
 smaller font and are only covering about half the width of the sheet
 of receipt paper. This is in comparison to the TSP100 printing
 through a USB connection to a Windows 7 workstation.
 Does anybody have a solution for this?
I would check your receipt printer settings first.
We have had people run into similar issues (on Windows) where they have Shrink 
to fit page width checked on the printer settings page.

See: 
http://plum.pls-net.org/twiki/bin/view/Evergreen/EvergreenReceiptPrinterInstallation#For_Receipt_printers_ie_SP500_SP
 for our Windows instructions

Aaron Zsembery
Library Systems Analyst

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260 x111


Re: [OPEN-ILS-GENERAL] Macros

2014-01-22 Thread Aaron Zsembery
On Wednesday, January 22, 2014 7:14:04 PM Holly Brennan 
haderh...@ci.homer.ak.us wrote:
 Here’s how I configured the top of our patron-oriented receipts
 (items out, renewals, etc):
[SNIP/]
 You set this up on one station, then copy the templates to all other
 computers at that branch. It’s a little work, but only has to be
 done once. And since you have to copy the customized templates to
 each workstation regardless, there’s not much difference in
 typing/coping a line of macros vs. typing the library name manually.
 Hope that helps. And thanks for the list, Lynn!
Another option (which we use) is to include one or more of the following in 
your receipt template: %INCLUDE(header_text)%, %INCLUDE(notice_text)%, 
%INCLUDE(footer_text)%, %INCLUDE(alert_text)%
Then for each library, set the header_text, notice_text, footer_text and 
alert_text settings in the library settings editor as needed.
We have those includes in our default template on the server, that way one 
template works for 98% of the libraries.

Aaron Zsembery
Library Systems Analyst

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260 x111


Re: [OPEN-ILS-GENERAL] Verification of Patron Data

2013-05-22 Thread Aaron Zsembery
One other comment, it appears that one of the options when creating a action 
trigger is to create a patron penalty. I don't know what the options are there, 
but that might do the same as a SQL command and be easier to manage

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260

- Original Message -
 From: Justin Hopkins jus...@mobiusconsortium.org
 To: Evergreen Discussion Group open-ils-general@list.georgialibraries.org
 Sent: Friday, May 17, 2013 11:23:43 AM
 Subject: Re: [OPEN-ILS-GENERAL] Verification of Patron Data
 
 If you have the ability to update the database I'd suggest writing a
 short sql script to be run on a daily basis that could add a patron
 alert/note when the criteria are met (every second year following the
 user create date).
 
 Regards,
 Justin Hopkins
 MOBIUS/Missouri Evergreen
 573-200-6134



Re: [OPEN-ILS-GENERAL] 3 day Courtesy Notice not being received

2013-05-16 Thread Aaron Zsembery
Meme,
It can be done, the code is there in Evergreen back to at least version 2.2 to 
do this and we are doing this now for us and our 42 member libraries.
It sounds like there is a problem with Bill's system where something perhaps 
isn't set correctly to make it work, but it can be done now on a correctly 
configured Evergreen system.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260

- Original Message -
 From: Meme Marlow marlo...@oplin.org
 To: Evergreen Discussion Group open-ils-general@list.georgialibraries.org
 Sent: Thursday, May 16, 2013 10:04:03 AM
 Subject: Re: [OPEN-ILS-GENERAL] 3 day Courtesy Notice not being received
 
 Hi, Bill.
 
 This is something we have been trying to do. I was told yesterday
 that the courtesy notices were not a possiblity and that code has to
 be written to get this done. I am interested in having this done, so
 would you keep me in the loop on this. I would be interested in
 helping to support this upgrade.
 
 Thanks,
 
 Meme
 
 - Original Message -
 From: Bill Coffey bill.cof...@waynegov.com
 To: Evergreen Discussion Group
 (open-ils-general@list.georgialibraries.org)
 open-ils-general@list.georgialibraries.org
 Sent: Wednesday, May 15, 2013 8:45:57 AM
 Subject: [OPEN-ILS-GENERAL] 3 day Courtesy Notice not being received
 
 I have been receiving numerous complaints from patrons about not
 getting a 3 Day Courtesy Notice.
 They are getting the Hold notices, and at least the first late
 notice, I am still verifying the other late notices.
 I have checked and triple checked the template and it is working when
 I test it in the local admin area for notices.
 Has anyone had this problem and know of a way to fix it.
 
 Thanks
 
 Bill Coffey
 Wayne County Public Library
 System Administrator
 1001 E. Ash St.
 Goldsboro NC, 27530
 bill.cof...@waynegov.commailto:bill.cof...@waynegov.com
 www.wcpl.orghttp://www.wcpl.org/
 Work ph: (919) 735-6249
 Fax: (919) 735-1824
 
 


Re: [OPEN-ILS-GENERAL] What should be done during unexpected library closings?

2013-04-24 Thread Aaron Zsembery
On Wednesday, April 24, 2013 2:08:28 PM Yamil Suarez ysua...@berklee.edu 
wrote:
 Thank you everyone for their reponses. Could someone share their
 workflow for back dating checked out items on the list, since I
 assume
 other would benefit. Is this something that is done en masse or
 individually?
Our documentation is available online and it explains the process MUCH better 
than I could:
http://plum.pls-net.org/twiki/bin/view/Evergreen/CheckInBackdate
http://plum.pls-net.org/twiki/bin/view/Evergreen/CheckInItems22#Back_dated_Check_In

On a side note, if you haven't run across it most of our Evergreen procedural 
documentation (such as it is) can be found at: 
http://plum.pls-net.org/twiki/bin/view/Evergreen/WebHome


Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] What should be done during unexpected library closings?

2013-04-24 Thread Aaron Zsembery
On Wednesday, April 24, 2013 3:21:05 PM chtrot...@ocrl.org wrote:
 I am not sure  if the closed date can be entered the same day and fines
 not accrue.
IIRC, in our install the fine generator runs at 23:59 to generate daily fines, 
so as long as the entry gets in, it should theoretically work. I haven't tried 
that though.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] Wireless Barcode Scanners

2013-04-18 Thread Aaron Zsembery
On 17 April 2013 at 2:58PM Tatiana H Prokrym tanya.prok...@ncdcr.gov wrote:
 Does anyone have recommendations for wireless barcode scanners that
 work well with Evergreen. We are running v2.3.1. We are about to
 purchase quite a few.
We have a library which is using wireless Honeywell 3800g (this appears to be 
the current version: 
https://www.honeywellaidc.com/en-US/Pages/Product.aspx?category=wireless-barcode-scannercat=HSMpid=3820_
 
)
Realistically, ANY scanner that acts like a keyboard, can scan your barcodes 
and can be programmed to do a carriage return after scanning the barcode will 
work just fine. Unlike some other ILS software, Evergreen is not picky.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260attachment: image001.pngattachment: image002.png

Re: [OPEN-ILS-GENERAL] Question regarding Evergreen and transit between libraries

2013-04-12 Thread Aaron Zsembery
On April 12, 2013 at 1:28:57 PM Deana Cunningham 
deana.cunning...@granvillecounty.org wrote:
 Does anyone deal with a similar situation? Can anyone tell me if
 Evergreen can handle multiple transit times appropriately?
In Evergreen, you scan the item to put it into In transit status at the 
sending library and then it gets scanned again at the destination library when 
it arrives to let the system know that it is no longer In Transit and the 
patron can be notified that their hold is available for pickup.
Evergreen doesn't care if 3 minutes, 3 weeks or 3 years pass between when the 
item is put In Transit and when it comes back out.
See http://docs.evergreen-ils.org/2.1/html/transititems.html for a little more 
info about how transits are handled.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] SQL question

2013-04-11 Thread Aaron Zsembery
You want the action.circulation table. 

I would use the following query: 
SELECT COUNT(action.circulation.id) AS Circs 
FROM action.circulation 
WHERE DATE(xact_start) BETWEEN '2012-01-01' AND '2012-12-31' 
AND circ_lib = XXX /*Put your library ID in here, it can be found in 
actor.org_unit.id*/ 
AND phone_renewal IS FALSE /*Remove this if you want Phone renewals to be 
counted*/ 
AND desk_renewal IS FALSE /*Remove this if you want Circ Desk renewals to be 
counted*/ 
AND opac_renewal IS FALSE /*Remove this if you want OPAC renewals to be 
counted*/; 

Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 

- Original Message -

 From: Jesse Ephraim jephr...@roanoketexas.com
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Sent: Thursday, April 11, 2013 1:36:47 PM
 Subject: [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. Walnut
 Roanoke, TX 76248
 jephr...@roanoketexas.com
 817-491-2691


Re: [OPEN-ILS-GENERAL] paypal credit card payment

2013-04-05 Thread Aaron Zsembery
On April 5, 2013 at 12:06:38 PM Tim Spindler tjspind...@gmail.com wrote:
 We have another question, can you have separate paypal accounts for
 different libraries (so libraries use their own accounts). I'm not
 sure we want to do this but the question has come up.
IIRC (not sitting in front of EG right now), the paypal settings are a standard 
setting so you could make them be library level or consortium level.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] Notifications Emails that Bounce are bounced back to the default email

2013-03-28 Thread Aaron Zsembery
On 28 Mar 2013 at 12:30:04 PM Wolf Halton wolf.hal...@gmail.com wrote:
 Rather than being bounced back to the originating branch email,
 messages that are un-deliverable are bouncing back to the default
 notifications email in an upgraded from 2.2.0 = 2.3.4 EG instance.
 Debian Squeeze, and Postgresql 9.1
There are two places this could be set (based on our 2.2 install): 
1. Server Administration  Organizational Units  Main Email 
2. Local Administration  Notifications/Action Triggers  Template. Look for 
From it should be followed with: [%- target.0.circ_lib.name %] [%- 
helpers.get_org_setting(target.0.circ_lib.id, 'org.bounced_emails') || 
lib.email || params.sender_email || default_sendr -%] 


If the main email address isn't setup for the branch, bounces will (by default) 
go back to the system default email address. If someone has been messing with 
the template, they might have removed the library email settign and just left 
the default_sender portion. 

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260



Re: [OPEN-ILS-GENERAL] SMS setup for consortium--all at once?

2013-03-07 Thread Aaron Zsembery
On 7 March 2013 Kathy Lussier kluss...@masslnc.org wrote:
 However, if you have a different tpac template for the library that
 wants SMS, maybe you can hide the SMS options in the template for
 your other libraries? Off the top of my head, I'm thinking there are
 three places where you would need to hide SMS: the record page where
 you have the option to text the call number, the place hold page,
 and the myopac notification preferences page.
TPAC does that automatically in our 2.2 install, but it would get confusing for 
patrons.
For example, if Library B has SMS turned on, but Library A has it turned off, 
if a patron from Library B goes to Library A, does a search for items available 
at Library A, then tries to place a hold, it will not show the SMS options. On 
the other hand, if the patron logs in before searching, SMS shows up when 
placign the hold (IIRC).

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] SMS setup for consortium--all at once?

2013-03-07 Thread Aaron Zsembery
On 7 March 2013 at 4:14:15 PM Alexey Vladimirovich Lazar 
alexey.la...@mnsu.edu wrote:
 Unless the SMS settings are tied to patron's home library/branch,
 perhaps, where if a user has SMS enabled at their home library, they
 would get an SMS option even if checking out material from a
 different library/branch that has SMS disabled for their own
 patrons. 
Our limited testing (turning it on for one library when we meant to turn it on 
for the whole system) showed that the SMS settings tie to EITHER your home 
library (if logged in) or your current search library (if not logged in).
In our testing, if your home library has SMS turned on, you place a hold from 
there (requesting SMS notification) and the checkout library has SMS turned 
off, you will get a SMS notification.
The SMS yes/no is set on the hold record, as such, if the SMS Hold Notification 
Action Trigger is turned on but SMS is completely off in settings, staff can 
edit the hold (from the staff client) to add the phone number/carrier and it 
WILL generate a hold notification (or at least it did in our test environment).
 Not sure how hairy this would be to actually implement or
 how useful having the option to configure this setting
 per-library/branch would be, in terms of number of libraries who
 would use the option.
I would just turn it on for everyone. If a library doesn't want to use it, they 
don't have to fill it in and if the patrons want it, they can enter that at the 
time of placing a hold.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] Mobile catalog?

2012-11-08 Thread Aaron Zsembery
On Thursday, November 8, 2012 at 2:30:59 PM Buzzy Nielsen 
bu...@hoodriverlibrary.org wrote:
 I think it's a lot more accessible, and less hassle,
 for our patrons if we don't require them to go out and download a
 separate app to access something that can be made accessible without one.
It also includes those (like myself) who use other mobile platforms (such as 
Windows Mobile) that aren't based on iOS or Android

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] How to remove previously used hostnames in EG client?

2012-11-05 Thread Aaron Zsembery
On Monday, November 5, 2012 11:32:20 AM Yamil Suarez ysua...@berklee.edu 
wrote:
 I have several EG 2.2 workstations that were registered with both our
 production server and our test server hostnames. Automatically the EG
 client remembers previously used server hostnames/IPs. In this case I
 would like to remove the entry in the hostnames drop down menu for
 our test server to avoid confusion in the future. Regretfully, if I
 uninstall the EG client I and reinstall it, the entries remain the
 same. Could someone provide me pointers on how to accomplish this?

On Windows 7 (and possibly in XP) if you go to 
%APPDATA%\OpenILS\open_ils_staff_client\Profiles\PROFILE_NAME\chrome there 
should be a file named ws_info which has the following string for each 
server: 
SERVER_ADDRESS:{name:WORKSTATION_NAME,owning_lib:LIB_ID,lib_shortname:LIBRARY_SHORTNAME}}
 with a comma between each entry.
Remove the entries that you don't want and they should disappear from the 
dropdown list.

If you don't mind re-registering the workstations (or want to clear some random 
data that wont go away), you could just delete the 
%APPDATA%\OpenILS\open_ils_staff_client\Profiles folder and the 
%APPDATA%\OpenILS\open_ils_staff_client\profiles.ini file

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260



Re: [OPEN-ILS-GENERAL] Courtesy report

2012-10-30 Thread Aaron Zsembery
On Monday, October 29, 2012 at 5:06:32 PM Yeisa Fredrickson 
yfredrick...@egf.mn wrote:
 I have been struggling with creating a recurring report for items due
 2 days from now. We send emails, but not all of our patrons have an
 email address or may not regularly check it. Has anyone else created
 a report that produces similar results?
So, you want a daily report that shows the titles (and possibly other info) of 
all items that will be due in 2 days along with the patron name, phone number 
and email address?

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] ***SPAM*** Importing from ISBN

2012-10-16 Thread Aaron Zsembery
On Tuesday, October 16, 2012 at 1:18:10 PM Cassondra Vick 
cassondra.v...@kentonlibrary.org wrote:
 According to my research, ISBNs are unique.
 http://www.isbn.org/standards/home/isbn/us/major.asp
In an ideal world, yes. In the real world? It happens, see: 
http://www.goodreads.com/topic/show/975488-isbn-duplication 
www.amazonsellercommunity.com/forums/message.jspa?messageID=2531583 and many 
others

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] Circulation Statistics

2012-09-11 Thread Aaron Zsembery
On Tuesday, September 11, 2012 at 9:33:37 AM Chauncey Montgomery 
montg...@oplin.org wrote:
   So, I am beginning to suspect that perhaps TLC counted things
 differently than Evergreen.
I have never used or heard of TLC, but here are two things that I have noticed 
in our migration from Unicorn to Evergreen:
1. Do your libraries use in-house circulations to track items used for 
storytime and other such activities? If so, are you looking up those 
circulations in your report? They are stored separately from regular 
circulations and will need to be retrieved separately.

2. How about inter library loan, did the sending library get credit for that in 
TLC? If so, you may need to add something to the report to count that as by 
default Evergreen does not credit the sending library for that circulation in 
most reports.

HTH

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] permissions and editing patron records

2012-08-20 Thread Aaron Zsembery
On Monday, August 20, 2012 at 1:51:57 PM Erik Stevens 
technol...@haineslibrary.org wrote:
 I feel like the fact that I put the Volunteer permission group as a
 child of the Patron permission group may have something to do with
 it. I do not want to put it under the Staff group because that
 parent already has more permissions than we would like volunteers to
 have.
 I'm going to try to re-creating the group under the parent of Users
 and see if that makes a difference.
That will probably fix it. IIRC, in MOST (all?) cases the most restrictive 
permissions win out, so having a child group with more permissions than the 
parent group doesn't work.


Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] Date Checked Out Macros

2012-08-16 Thread Aaron Zsembery
On Thursday, August 16, 2012 at 10:43:28 AM Geoff Brown 
gebr...@niagaracollege.ca wrote: 
 Niagara College is trying to add the Date Checked Out to our overdue
 notices however we are unable to find the macros for this.  I have
 searched the Evergreen documentation and there is no list for the
 notice macros. Would anyone happen to know the appropriate macros
 for Date Checked Out?
We use: [% date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %] for 
our due date, so I would try 
[% date.format(helpers.format_date(circ.create_time), '%Y-%m-%d') %] as the 
create_time field in the action.circulation table is the checkout time.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] Standalone Pending Transactions

2012-08-01 Thread Aaron Zsembery
On August 1, 2012 at 11:54:11 AM Jennifer M Turner jennifer.tur...@mnsu.edu 

 Thanks for the response! Unfortunately, the transactions were
 uploaded and the directions for exporting/importing transactions
 were - as far as I know - followed.

Once they do the export, there is a popup that comes up and says: 
 Your transactions have been exported to the file FILENAME . We strongly 
recommend that you now purge the transactions from this staff client. Would you 
like for us to do this ? 
I would guess that they clicked no instead of yes in that popup as we have 
had several libraries do that. 

If they re-export, click yes and have the same issue, the file can be manually 
deleted with the following steps: 
1. Login as the user who is having the issue 
2. Go to %AppData%\OpenILS\open_ils_staff_client\Profiles\ 
3. Open the profile folder (usually something like ja3rm3ja.DefaultUser) 
4. Open the chrome folder 
5. Find the pending_xacts file. 
6. Delete it, rename it or whatever you prefer and that should eliminate the 
offline transactions warning. 

Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 

Re: [OPEN-ILS-GENERAL] Barcode scanners

2012-06-25 Thread Aaron Zsembery
On Monday, June 25, 2012 at 4:08:56 PM J. Sara Paulk 
jsarapaulk-w...@gmx.com wrote:
 thinking of moving to Evergreen - does anyone use Metrologic MS9525
 voyager Bluetooth scanners?
As long as they show up as a keyboard to Windows, they should work fine.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] Recommendations for PC reservation print management software needed

2012-06-01 Thread Aaron Zsembery
On Friday, June 1, 2012 3:40:16 PM Elizabeth Longwell blong...@eou.edu 
wrote:
 Evergreen libraries,
 One of our district libraries is looking at PC reservation/time
 management/print management software solutions. They have polled our
 local consortia but would like to find out what other Evergreen
 libraries are using and/or recommending. We are currently on
 Evergreen 2.1, soon to upgrade to 2.2.
We have ~6 libraries using CASSIE (http://librarica.com/) with good results. 
Once caveat, it is picky about having the correct drivers for printers and it 
does not allow you to specify which driver to use when setting up print 
management on the public machines.
As such, if you have Win 7 public machines, the computer that you use for print 
management needs to have Win 7 installed as well.
Our libraries get a discount with them as we (the system, or me specifically) 
do the initial install and level 1 tech support to get them off of the ground.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] Evergreen Staff Client Interface for Use of Physical Cash Drawers

2012-05-31 Thread Aaron Zsembery
 Jessie Bunker-Maxwell je...@santacruzpl.org wrote:
 Has anyone out there replaced their cash registers with cash drawers
 and if so, is there an interface that allows the Evergreen Staff
 Client to work with the cash drawers?
 Scanning posts to this list and the Evergreen documentation, I am
 unable to determine if this interface even exists.
 Thanks for any info or personal experience.
Some printers (such as the Star SP200, SP500 and TSP100 series machines) have 
an interface where you could plug a cash drawer into them and then send a 
control character (as part of a receipt template) to open the drawer when that 
receipt prints. I remember having such a conversation last year and I found 
some documentation from Star and a drawer OEM, but I have never used such a 
device.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] Evergreen Staff Client Interface for Use of Physical Cash Drawers

2012-05-31 Thread Aaron Zsembery
 Galen Charlton g...@esilibrary.com wrote:
 There is no defined interface, but there was some discussion [1] last
 year on a possible workaround, involving use of certain models of
 printers that can have cash drawers attached to them and using a
 control code in the circ receipt as a signal to open the drawer.  I
 would be curious to know if anybody ever got that working.
 [1] 
 http://list.georgialibraries.org/pipermail/open-ils-general/2011-June/thread.html#5035
Looks like you beat me to it, that is the thread I remembered.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] receipt problems

2012-05-24 Thread Aaron Zsembery
It sounds like this may be something with the printer. I would check the paper 
size, zoom settings and header/footer from the printer selection page. 

If you want to remove all traces of Evergreen from her computer, I use the 
attached file ( Remove Evergreen.bat.old ) which if renamed as a batch file, 
will remove all traces of Evergreen. 
Specifically, you want to delete %AppData%\OpenILS \open_ils_staff_client\ 
folder (which on my Win7 box translates to 
C:\Users\Aaron\AppData\Roaming\OpenILS\open_ils_staff_client) to erase the 
workstation registration. 

Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 

- Original Message -

 From: Gordana Vitez gvi...@niagaracollege.ca
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Sent: Thursday, May 24, 2012 4:06:12 PM
 Subject: [OPEN-ILS-GENERAL] receipt problems

 Hi there,

 We're having a problem with one of our staff members' receipts and I
 could really use some help.

 Whenever this staff member logs in to one particular circ computer,
 the receipts are terrible. They cut short, run long, don't appear
 like anyone else's, even though we use the exact same settings. I've
 tried uninstalling the client but it still recognizes her as
 registered to the workstation and setting defaults doesn't seem to
 work.

 Is there a way to disassociate a staff member with a workstation so
 that everything starts from scratch?

 Thanks!
 Gordana

 Gordana Vitez
 Library Services  Systems Coordinator
 NC Libraries and Learning Commons
 Niagara College
 300 Woodlawn Rd
 Welland Ontario
 L3C 7L3
 Phone: (905) 735 2211 ext 7404
 Fax: (905) 736 6021
 gvi...@niagaracollege.ca

Remove Evergreen.bat.old
Description: application/trash


[OPEN-ILS-GENERAL] ***SPAM*** Re: Fwd: campus card compatibility with Evergreen Library installation

2012-05-08 Thread Aaron Zsembery
From my time working for a small hotel that used magnetic key cards and credit 
card readers, I can say that (generally speaking): A magcard reader is very 
much like a barcode reader . It reads the data from the card and puts it out 
as if it was typed into a keyboard. 
I would get a card and cardreader and see what data it puts into notepad (or 
something similar) when you swipe it. 

Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 

- Original Message -

 From: Tim Spindler tspind...@cwmars.org
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Sent: Tuesday, May 8, 2012 7:23:28 PM
 Subject: [OPEN-ILS-GENERAL] Fwd: campus card compatibility with
 Evergreen Library installation

 Hello,

 One of our member libraries is looking at a new campus card system.
 Please see her message below. She is wonderiing if any other
 Evergreen libraries in an academic library has run into any issues.

 Tim

 -- Forwarded message --
 From: Beth, Amy  ab...@stcc.edu 
 Date: Tue, May 8, 2012 at 3:38 PM
 Subject: Fwd: campus card compatibility with Evergreen Library
 installation
 To: Tim Spindler  tspind...@cwmars.org , Noel, Kim 
 kn...@stcc.edu 

 Greetings. Hoping you can help.

 We are working with the following consultant/vendor
 http://www.allcampuscard.com/ to implement an All Campus Card system
 at our institution Springfield Technical Community College). The
 representative, Bob Huber, claims he never contacts the ILS vendors
 to determine compatibility. I am, of course, at a loss as to
 determining if our upcoming installation of Evergreen (we are a C/W
 Mars academic library in Massachusetts due to migrate on May 31st)
 will interface well with this magnetic strip one card platform or
 not. Our campus card would go into effect by Fall. No other C/W Mars
 libraries use a magnetic strip card on their sites-- but that
 doesn't indicate anything since the overwhelming libraries
 participating in this consortium are small public libraries and we
 are an outlier as an academic campus. I have already asked the staff
 at C/W Mars to vet this and they state it is beyond their scope for
 this project (which is focused on an ILS migration for a majority of
 public libraries)

 Please direct me to an Evergreen community member or developer or a
 client who could assist. I would be extremely grateful.

 All best, ab
 --
 Amy Beth
 Dean of Library Services
 Springfield Technical Community College
 1 Armory Sq.
 Springfield, MA 01105
 Phone: 413 755-4531
 http://library.stcc.edu/
 email: ab...@stcc.edu

 --
 Amy Beth
 Dean of Library Services
 Springfield Technical Community College
 1 Armory Sq.
 Springfield, MA 01105
 Phone: 413 755-4531
 http://library.stcc.edu/
 email: ab...@stcc.edu

 --

 Tim Spindler
 Manager of Library Applications
 tspind...@cwmars.org
 508-755-3323 x20

 C/W MARS, Inc.
 67 Millbrook St, Suite 201
 Worcester , MA 01606
 http://www.cwmars.org

 P Go Green - Save a tree! Please don't print this e-mail unless it's
 really necessary.


Re: [OPEN-ILS-GENERAL] Report : Retrieve last patron who circulated item

2012-03-23 Thread Aaron Zsembery
Assuming that you have the rest setup (to find the items), add the circ 
transaction start date/time (ItemCirculationsCheckout Date/Time) as a Max 
aggregate filter to the list of filters and it should only return the info the 
the last checkout.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260

- Original Message -
 From: Geoff Brown gebr...@niagaracollege.ca
 To: open-ils-general@list.georgialibraries.org
 Sent: Friday, March 23, 2012 3:11:15 PM
 Subject: [OPEN-ILS-GENERAL] Report : Retrieve last patron who circulated item
 
 Hi,
 
 Can anyone advise on creating a report which mimics the function of
 retrieving the last who circulated an item? Ideally, we would like
 to make use circ modifier as a filter and have the patron details,
 item title/call number display.
 
 I know this is asking a lot on a Friday ..but any input would be
 appreciated.
 
 Thanks,
 Geoff Brown
 
 Library Technician - eResources,
 NC Libraries and Learning Commons
 Niagara College, Welland Campus
 300 Woodlawn Road
 Welland, ON L3C 7L3
 Tel.  (905) 735-2211  Welland x 7731
 Fax  (905) 736-6021
 gebr...@niagaracollege.ca
 www.niagaracollege.ca/library
 
 
 .
 


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

2012-03-02 Thread Aaron Zsembery
Can you post the query? Hard to tell what you need to do without seeing the 
query you are working from.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York 14424
Phone: (585) 394-8260

- Original Message -

 From: Jesse Ephraim jephr...@roanoketexas.com
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Sent: Thursday, March 1, 2012 4:41:49 PM
 Subject: [OPEN-ILS-GENERAL] circ numbers after status change

 We just noticed that an item that was marked as “missing” (but later
 returned to the library) no longer reflects the past number of
 circulations. There is a SQL query I use to see individual
 circulation statistics for groups of items in our collection, and it
 is now returning a “0” for that one. 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] Report View error

2012-01-17 Thread Aaron Zsembery
 Original Message - 
 From: Araik Manukyan ar...@flib.sci.am
 However, when we try export ILC Users report, the Evergreen responses
 with this error text
 -
 DBD::Pg::st execute failed: ERROR: column
 fe21ca9ecd516f33ec379ecc11aa7051.groups does not exist LINE 2:
 fe21ca9ecd516f33ec379ecc11aa7051.groups AS Additional ... ^ at
 /openils/bin/clark-kent.pl line 217.
 ---
That would indicate that you have a problem with your template, namely, it 
cannot find the column groups in the database table 
fe21ca9ecd516f33ec379ecc11aa7051.
If you click on the Debugging Info link from the report page, there should be 
a Generated SQL section. In there where should be a FROM statement with a 
bunch of LEFT OUTER JOIN and other JOIN statments. They will each have a 
table name after the JOIN along with an AS. One of the text strings after the 
AS should match the one you posted above.
For example, one of our reports has the following:
FROMreporter.overdue_circs AS c8a790b472655be78d781328a75d9fb5
LEFT OUTER JOIN asset.copy AS 4dea4106377793e92f172d1c616f01d1
That should let you see which table and column it cannot find.

If you have SQL access, you should be able to copy/paste the whole Generated 
SQL section and run that as a query to get the same data as the report will 
give you.

HTH

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260 


Re: [OPEN-ILS-GENERAL] Windows 7 64 bit compatibility issues?

2011-11-03 Thread Aaron Zsembery
What happens when they try to print a Windows test page on these printers, or 
from another program? 
What happens if you print to a virtual printer (like CutePDF) from Evergreen? 

Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 

- Original Message -

 From: Evette Atkin atk...@mcls.org
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Sent: Thursday, November 3, 2011 10:33:36 AM
 Subject: Re: [OPEN-ILS-GENERAL] Windows 7 64 bit compatibility
 issues?

 The receipt printers are Epson TM-T88IV Model #M129H. The big printer
 in
 the office is a Zerox Phaser 7400.

 Evette M. Atkin
 Evergreen Coordinator
 Midwest Collaborative for Library Services
 1407 Rensen St., Suite 1, Lansing, MI 48910-3657
 Phone (800)530-9019 ext 152 Fax (517)492-3808
 atk...@mcls.org
 www.mcls.org

 From: Aaron Zsembery azsemb...@pls-net.org
 To:   Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Date: 11/02/2011 02:53 PM
 Subject:  Re: [OPEN-ILS-GENERAL] Windows 7 64 bit compatibility
 issues?
 Sent by:  open-ils-general-boun...@list.georgialibraries.org

 What is the printer make and model? What version of EG?
 We have Win7 x64 working with Star SP512 and SP212 printers under EG
 1.6.2.4.

 Aaron Z
 Jr. Systems Administrator

 Pioneer Library System
 2557 State Rt. 21
 Canandaigua, New York 14424
 Phone: (585) 394-8260

 From: Evette Atkin atk...@mcls.org
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Sent: Wednesday, November 2, 2011 1:55:21 PM
 Subject: [OPEN-ILS-GENERAL] Windows 7 64 bit compatibility issues?

 Hi all. One of our libraries recently purchased new computers for
 their circulation department. When trying to print (from Evergreen)
 to a regular printer, nothing but garbage comes out. When they
 attempt to print to the receipt printer, there is a spooling error
 and the machine crashes and needs to be rebooted. The new machines
 are Window 7 64-bit. Has this happened to anyone else and does
 anyone have any suggestions on how to fix this?

 Thanks!

 Evette M. Atkin
 Evergreen Coordinator
 Midwest Collaborative for Library Services
 1407 Rensen St., Suite 1, Lansing, MI 48910-3657
 Phone (800)530-9019 ext 152 Fax (517)492-3808
 atk...@mcls.org
 www.mcls.org


Re: [OPEN-ILS-GENERAL] Windows 7 64 bit compatibility issues?

2011-11-02 Thread Aaron Zsembery
What is the printer make and model? What version of EG? 
We have Win7 x64 working with Star SP512 and SP212 printers under EG 1.6.2.4. 

Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 

- Original Message -

 From: Evette Atkin atk...@mcls.org
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Sent: Wednesday, November 2, 2011 1:55:21 PM
 Subject: [OPEN-ILS-GENERAL] Windows 7 64 bit compatibility issues?

 Hi all. One of our libraries recently purchased new computers for
 their circulation department. When trying to print (from Evergreen)
 to a regular printer, nothing but garbage comes out. When they
 attempt to print to the receipt printer, there is a spooling error
 and the machine crashes and needs to be rebooted. The new machines
 are Window 7 64-bit. Has this happened to anyone else and does
 anyone have any suggestions on how to fix this?

 Thanks!

 Evette M. Atkin
 Evergreen Coordinator
 Midwest Collaborative for Library Services
 1407 Rensen St., Suite 1, Lansing, MI 48910-3657
 Phone (800)530-9019 ext 152 Fax (517)492-3808
 atk...@mcls.org
 www.mcls.org


Re: [OPEN-ILS-GENERAL] Windows 7 64 bit compatibility issues?

2011-11-02 Thread Aaron Zsembery
 From: jcl...@spendmanagementpartners.com
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Sent: Wednesday, November 2, 2011 2:53:51 PM
 Subject: Re: [OPEN-ILS-GENERAL] Windows 7 64 bit compatibility
 issues?
 Please remove me from this list. Thanks.
I recommend that you visit the link you should have received in the list 
membership reminder that went out yesterday 
(http://libmail.georgialibraries.org/mailman/options/open-ils-general/jclift%40spendmanagementpartners.com)
 and click on the Unsubscribe button 

Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 Aaron Z Jr. Systems Administrator Pioneer Library System 
2557 State Rt. 21 Canandaigua, New York 14424 Phone: (585) 394-8260 


Re: [OPEN-ILS-GENERAL] Evergreen and book groups

2011-10-20 Thread Aaron Zsembery
 Original Message -
 From: Thomas Berezansky tsb...@mvlc.org
 Sent: Thursday, October 20, 2011 11:23:01 AM
 Subject: Re: [OPEN-ILS-GENERAL] Evergreen and book groups
 Alternatively, when I try and check an item out to a different
 patron,
 I get a Normal Checkin then Checkout button on the you can't do
 that, it is already checked out prompt. Dunno when the system
 started
 doing that.
We have had that when checking in an item with an open checkout since we went 
live 1.6.0.8 (and I think it was there in our testing on 1.6.0.4)

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] Evergreen Cassie from Librarica

2011-10-18 Thread Aaron Zsembery
- Original Message -
 From: Heidi Florenzen hfloren...@hermiston.or.us
 To: open-ils-general@list.georgialibraries.org
 Sent: Tuesday, October 18, 2011 7:30:00 PM
 Subject: [OPEN-ILS-GENERAL] Evergreen  Cassie from Librarica
 Has anyone successfully paired Cassie with Evergreen?  (We're
 currently running Evergreen version 2.1)   If so can you please
 share details?  We've been without integration for 10 months.
We are using CASSIE with 1.6.2.4. It worked with 1.6.0.x up to 1.6.0.8 and we 
have not had any issues after the initial setup.
You must have a login on the server and tell CASSIE to use it to authenticate.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] patron checkout history

2011-09-23 Thread Aaron Zsembery
Where do you need to access this information? It is not really accessible 
dynamically through the staff client, but is readily available through SQL or 
the reporting interface. 

Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 
 From: Gordana Vitez gvi...@niagaracollege.ca
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Sent: Friday, September 23, 2011 1:29:24 PM
 Subject: [OPEN-ILS-GENERAL] patron checkout history

 Hello everyone!

 I am trying to figure out how to get a patron's checkout history. I
 did a search and found a thread from May 31, 2011 on the general
 listserv giving some info on what I need. In an email from Lisa
 Hill, there was a link to an attachment called checkouthistory.pdf.
 Unfortunately, that link no longer works. I also tried searching
 specifically for the pdf itself, but no luck.

 Would anyone know what I'm referring to and be willing to share?

 Thanks!
 Gordana

 Gordana Vitez
 Library Services  Systems Coordinator
 NC Libraries and Learning Commons
 Niagara College
 300 Woodlawn Rd
 Welland Ontario
 L3C 7L3
 Phone: (905) 735 2211 ext 7404
 Fax: (905) 736 6021
 gvi...@niagaracollege.ca

Re: [OPEN-ILS-GENERAL] Bug Tracking and Enhancment Requests

2011-09-16 Thread Aaron Zsembery
On Friday, September 16, 2011 12:28:21 PM Galen Charlton wrote:
 [2] RT (http://bestpractical.com/rt/)
 I believe this is being used successfully by at least one other
 Evergreen consortium.
We use RT here at PLS.
I like it, it lets us setup permissions, add requestors to tickets, merge 
tickets, have automatic responses when something happens to a ticket, 
automatically BCC people when something happens to a ticket (ie: there are 4-5 
people who get BCCed with any updates are made to a ticket in the Evergreen 
queue), mark tickets as dependent on other tickets, depended on by other 
tickets, mark tickets as parents or children of other tickets, etc.
We have it setup with our mail system, so when you send an email, it will 
automatically open a ticket for the sender in the correct queue.
Also (unlike some ticketing systems) when you reply via email from the ticket, 
the reply goes into the ticket. You can either reply to the requestor or you 
can add a comment (added to the ticket, but not sent to the requestor) via 
email.

Downsides: The web UI on our version is clunky (but the libraries never use it, 
they just use email to interact with RT), and our antiquated version needs some 
tweaks to the config files from time to time.
See: http://issues.bestpractical.com/Dashboards/1408/RT?user=guest;pass=guest 
for the interface of a current version.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] Batch Delete Records

2011-08-24 Thread Aaron Zsembery
I am not sure what a TSN is (perhaps you meant TCN?), but if you have a list of 
barcodes, you can paste them into a text file, import it into Check Item 
Status (rather than scanning the items in) and manage the items from there. 
Otherwise, I don't think there is any way to batch select items, volumes, 
records etc without going directly into the database. 
It is possible to have EG delete the Call Number/Volume record when all copies 
are deleted and the Bib record when all Call Number/Volume records are deleted 
, but it doesnt sound like that is what you want to do. 

Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 

- Original Message -

 From: Brian Greene bgre...@cgcc.cc.or.us
 To: open-ils-general@list.georgialibraries.org
 Sent: Tuesday, August 23, 2011 7:37:49 PM
 Subject: [OPEN-ILS-GENERAL] Batch Delete Records

 Is there a way to batch delete records automatically from an Excel
 file with TSNs (in my case, provided by ebrary)? It seems tedious to
 delete them manually, but I haven't figured out how to create a
 search that would enable me to isolate all of them into a bucket for
 deletion.

 Thanks,

 Brian Greene, Library Director
 Columbia Gorge Community College
 The Dalles, Oregon 97058
 (541) 506-6080 | www.cgcc.cc.or.us

Re: [OPEN-ILS-GENERAL] Batch Delete Records

2011-08-24 Thread Aaron Zsembery
So, there is only one copy per bib record? If that is the case, you could dump 
the TCNs to a comma seperated list and run a query which returned the barcodes 
of the attached copies for the list of TCNs 
An example would be: 
SELECT biblio.record_entry.tcn_value, 
asset.copy.barcode 
FROM biblio.record_entry 
INNER JOIN asset.call_number ON (biblio.record_entry.id = 
asset.call_number.record) 
INNER JOIN asset.copy ON (asset.call_number.id = asset.copy.call_number) 
WHERE biblio.record_entry.tcn_value IN ('abj00018615', 'u220115') 
ORDER BY 1, 2 ASC 

This will not work in the EG reporter unless you are willing to past each and 
every TCN into a list 

Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 

- Original Message -

 From: Brian Greene bgre...@cgcc.cc.or.us
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Sent: Wednesday, August 24, 2011 12:20:38 PM
 Subject: Re: [OPEN-ILS-GENERAL] Batch Delete Records

 Thanks Aaron,

 Yes, I meant TCN. What I'm trying to do is minimize the work involved
 in keeping up with the titles periodically removed from our ebrary
 subscription. Ebrary provides a list of removed titles that can
 include more than a hundred at a time and deleting them manually is
 time consuming. The file containing the titles isn't associated with
 barcodes, so that option is out. Batch edit might provide us with a
 way to delete our copies (our holdings data is in the 856 field)
 then your thought about having EG delete the call number/volume
 record and then the bib record may be a solution.

 Thanks again,
 Brian

  Aaron Zsembery azsemb...@pls-net.org 8/24/2011 5:42 AM 

 I am not sure what a TSN is (perhaps you meant TCN?), but if you have
 a list of barcodes, you can paste them into a text file, import it
 into Check Item Status (rather than scanning the items in) and
 manage the items from there.
 Otherwise, I don't think there is any way to batch select items,
 volumes, records etc without going directly into the database.
 It is possible to have EG delete the Call Number/Volume record when
 all copies are deleted and the Bib record when all Call
 Number/Volume records are deleted , but it doesnt sound like that is
 what you want to do.

 Aaron Z
 Jr. Systems Administrator

 Pioneer Library System
 2557 State Rt. 21
 Canandaigua, New York 14424
 Phone: (585) 394-8260

 - Original Message -

  From: Brian Greene bgre...@cgcc.cc.or.us
 
  To: open-ils-general@list.georgialibraries.org
 
  Sent: Tuesday, August 23, 2011 7:37:49 PM
 
  Subject: [OPEN-ILS-GENERAL] Batch Delete Records
 

  Is there a way to batch delete records automatically from an Excel
  file with TSNs (in my case, provided by ebrary)? It seems tedious
  to
  delete them manually, but I haven't figured out how to create a
  search that would enable me to isolate all of them into a bucket
  for
  deletion.
 

  Thanks,
 

  Brian Greene, Library Director
 
  Columbia Gorge Community College
 
  The Dalles, Oregon 97058
 
  (541) 506-6080 | www.cgcc.cc.or.us
 

Re: [OPEN-ILS-GENERAL] Export patrons

2011-08-11 Thread Aaron Zsembery
What data are you looking to export? What criteria do you want to use? 
There are two ways to do something like this: 
1. Using the Evergreen Reporter (see: 
http://wiki.mnpals.org/index.php/Evergreen:User_Guide#Reports or look in the 
Sitka user manual for the basics) 
2. Connecting directly to the PostgreSQL server and running SQL commands 

Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 

- Original Message -

 From: Adam Marsy evergree...@rambler.ru
 To: open-ils-general@list.georgialibraries.org
 Sent: Thursday, August 11, 2011 3:08:09 AM
 Subject: [OPEN-ILS-GENERAL] Export patrons

 Export patrons
 Hi Evergreen users.
 I use the Evergreen 2.0 and i am interested how do i get Export
 patrons data? If someone can help me solve this question, please.
 Tanks.

Re: [OPEN-ILS-GENERAL] Star SP200

2011-07-14 Thread Aaron Zsembery
It is possible to print to a USB connected SP200, but you have:
1. Share it on the network
2. Add the the shared printer as a networked printer
3. Redirect LPT1 to the networked printer from step 2
If you have the ability to just use parallel, I would just do that. It would be 
MUCH simpler that way.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York 14424
Phone: (585) 394-8260

- Original Message -

 From: Joan Kranich jkran...@cwmars.org
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Sent: Thursday, July 14, 2011 10:01:55 AM
 Subject: Re: [OPEN-ILS-GENERAL] Star SP200

 Thank you Aaron. Your tip about DOS Mode and LPT1 made the
 difference. I can now print from Evergreen using the SP200 if I use
 a Parallel cable and set the Evergreen printer settings to DOS.
 Printing with the USB to Parallel cable does not work. Getting it to
 print at all is a big step forward.

 Joan

 Joan Kranich
 C/W MARS Member Services
 jkran...@cwmars.org

 From: open-ils-general-boun...@list.georgialibraries.org
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On
 Behalf Of Aaron Zsembery
 Sent: Wednesday, July 13, 2011 10:57 AM
 To: Evergreen Discussion Group
 Subject: Re: [OPEN-ILS-GENERAL] Star SP200

 I can send you the program I put together to share the printer and
 map it to LPT1 if you are interested. I have it as a VB project
 (made in Visual Basic 2010 Express), and a packaged executable. The
 basics can be found at:
 http://geekswithblogs.net/dtotzke/articles/26204.aspx

 Aaron Z
 Jr. Systems Administrator

 Pioneer Library System
 2557 State Rt. 21
 Canandaigua, New York 14424
 Phone: (585) 394-8260
 - Original Message -

  From: Joan Kranich jkran...@cwmars.org

  To: Evergreen Discussion Group
  open-ils-general@list.georgialibraries.org

  Sent: Wednesday, July 13, 2011 8:38:49 AM

  Subject: Re: [OPEN-ILS-GENERAL] Star SP200


  Thank you for the information Aaron. We are using a USP to Parellel
  printer cable so we’ll keep trying.


  Joan


  Joan Kranich

  C/W MARS Member Services

  jkran...@cwmars.org


  From: open-ils-general-boun...@list.georgialibraries.org
  [mailto:open-ils-general-boun...@list.georgialibraries.org] On
  Behalf Of Aaron Zsembery

  Sent: Tuesday, July 12, 2011 12:00 PM

  To: Evergreen Discussion Group

  Subject: Re: [OPEN-ILS-GENERAL] Star SP200


  There was a bug for the SP200s with Xulrunner 1.9 (which is used in
  EG 2.x). See: https://bugs.launchpad.net/evergreen/+bug/491537

  In 1.6.x, we have ONLY been able to use the SP200 series printers
  via
  parallel (The SP200 series printers do not handle HTML and EG will
  only send plaintext (DOS Mode) to LPT1). We had a library who was
  using USB to Parallel adapters. They ended up sharing their SP200s
  (to the network) and mapping them to LPT1 (from the same computer)
  with NET USE, but it was flaky and they ended up replacing their
  SP200 printers with SP512s.


  Aaron Z

  Jr. Systems Administrator


  Pioneer Library System

  2557 State Rt. 21

  Canandaigua, New York 14424

  Phone: (585) 394-8260


   From: Joan Kranich jkran...@cwmars.org
 

   To: Evergreen Discussion Group
   open-ils-general@list.georgialibraries.org
 

   Sent: Tuesday, July 12, 2011 10:39:23 AM
 

   Subject: [OPEN-ILS-GENERAL] Star SP200
 


   Hello,
 


   Is anyone printing to a Star SP200 receipt printer using
   Evergreen
   2.1? If you can print successfully to the SP200 from Evergreen
   can
   you tell me the driver you are using? We have tried the sp212
   driver
   but have not had success. The printer uses a USB connection.
 


   Thanks.
 

   Joan
 


   Joan Kranich
 

   C/W MARS Member Services
 

   jkran...@cwmars.org
 



Re: [OPEN-ILS-GENERAL] Star SP200

2011-07-13 Thread Aaron Zsembery
I can send you the program I put together to share the printer and map it to 
LPT1 if you are interested. I have it as a VB project (made in Visual Basic 
2010 Express), and a packaged executable. The basics can be found at: 
http://geekswithblogs.net/dtotzke/articles/26204.aspx

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York 14424
Phone: (585) 394-8260

- Original Message -

 From: Joan Kranich jkran...@cwmars.org
 To: Evergreen Discussion Group
 open-ils-general@list.georgialibraries.org
 Sent: Wednesday, July 13, 2011 8:38:49 AM
 Subject: Re: [OPEN-ILS-GENERAL] Star SP200

 Thank you for the information Aaron. We are using a USP to Parellel
 printer cable so we’ll keep trying.

 Joan

 Joan Kranich
 C/W MARS Member Services
 jkran...@cwmars.org

 From: open-ils-general-boun...@list.georgialibraries.org
 [mailto:open-ils-general-boun...@list.georgialibraries.org] On
 Behalf Of Aaron Zsembery
 Sent: Tuesday, July 12, 2011 12:00 PM
 To: Evergreen Discussion Group
 Subject: Re: [OPEN-ILS-GENERAL] Star SP200

 There was a bug for the SP200s with Xulrunner 1.9 (which is used in
 EG 2.x). See: https://bugs.launchpad.net/evergreen/+bug/491537
 In 1.6.x, we have ONLY been able to use the SP200 series printers via
 parallel (The SP200 series printers do not handle HTML and EG will
 only send plaintext (DOS Mode) to LPT1). We had a library who was
 using USB to Parallel adapters. They ended up sharing their SP200s
 (to the network) and mapping them to LPT1 (from the same computer)
 with NET USE, but it was flaky and they ended up replacing their
 SP200 printers with SP512s.

 Aaron Z
 Jr. Systems Administrator

 Pioneer Library System
 2557 State Rt. 21
 Canandaigua, New York 14424
 Phone: (585) 394-8260
 - Original Message -

  From: Joan Kranich jkran...@cwmars.org

  To: Evergreen Discussion Group
  open-ils-general@list.georgialibraries.org

  Sent: Tuesday, July 12, 2011 10:39:23 AM

  Subject: [OPEN-ILS-GENERAL] Star SP200


  Hello,


  Is anyone printing to a Star SP200 receipt printer using Evergreen
  2.1? If you can print successfully to the SP200 from Evergreen can
  you tell me the driver you are using? We have tried the sp212
  driver
  but have not had success. The printer uses a USB connection.


  Thanks.

  Joan


  Joan Kranich

  C/W MARS Member Services

  jkran...@cwmars.org



Re: [OPEN-ILS-GENERAL] Star SP200

2011-07-12 Thread Aaron Zsembery
There was a bug for the SP200s with Xulrunner 1.9 (which is used in EG 2.x). 
See: https://bugs.launchpad.net/evergreen/+bug/491537 
In 1.6.x, we have ONLY been able to use the SP200 series printers via parallel 
(The SP200 series printers do not handle HTML and EG will only send plaintext 
(DOS Mode) to LPT1). We had a library who was using USB to Parallel adapters. 
They ended up sharing their SP200s (to the network) and mapping them to LPT1 
(from the same computer) with NET USE, but it was flaky and they ended up 
replacing their SP200 printers with SP512s. 

Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 

- Original Message -


From: Joan Kranich jkran...@cwmars.org 
To: Evergreen Discussion Group open-ils-general@list.georgialibraries.org 
Sent: Tuesday, July 12, 2011 10:39:23 AM 
Subject: [OPEN-ILS-GENERAL] Star SP200 



Hello, 

Is anyone printing to a Star SP200 receipt printer using Evergreen 2.1? If you 
can print successfully to the SP200 from Evergreen can you tell me the driver 
you are using? We have tried the sp212 driver but have not had success. The 
printer uses a USB connection. 

Thanks. 
Joan 

Joan Kranich 
C/W MARS Member Services 
jkran...@cwmars.org 





Re: [OPEN-ILS-GENERAL] Cash Drawers: How to they work?

2011-06-10 Thread Aaron Zsembery
- Justin Hopkins jus...@mobiusconsortium.org wrote:
 Apparently this functionality doesn't exist in Evergreen, but that
 seems odd.
Some printers (such as the Star SP512) have a place to connect a cash drawer 
[1], then when you send a specific character (such as CONTROL G (ASCII 7)[2] to 
the printer, it is sent to the cash drawer and opens the cash drawer. 
In such a case, you could include this character in your bill/payment receipt 
templates and it would only open when you printed one of those receipts.

Links:
[1] http://www.fyrnicedesigns.com/POS_Pricing.htm#Metal_Cash_Drawer_-_CD4141 
(Note: They say that they use a RS12 cable, but I think they mean an RJ12 cable)
[2] http://www.mscashdrawer.com/KLICInstructions.pdf

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260


Re: [OPEN-ILS-GENERAL] implementing Summon with Evergreen

2011-04-19 Thread Aaron Zsembery
Deleted Records Export: Deleted records are still in the system, they just have 
the deleted flag in the Bib record set to true, so you can run reports on 
them if needed. 

Deleted Records Export: We have a report that runs every week which grabs all 
of the bib records deleted in the last week and returns the following 
information about them: Last edit date, Last editor, Create date, ISBN, OCLC 
number, Record ID, Title and Author. This allows us to update our holdings in 
OCLC and it works well.


Aaron Z 
Jr. Systems Administrator 

Pioneer Library System 
2557 State Rt. 21 
Canandaigua, New York 14424 
Phone: (585) 394-8260 

- Gordana Vitez gvi...@niagaracollege.ca wrote: 
 From: Gordana Vitez gvi...@niagaracollege.ca 
 To: Evergreen Discussion Group open-ils-general@list.georgialibraries.org 
 Sent: Friday, April 15, 2011 1:21:02 PM GMT -05:00 US/Canada Eastern 
 Subject: [OPEN-ILS-GENERAL] implementing Summon with Evergreen 
 
 
Hi everyone, 

Niagara College is working on implementing Summon. We will need to export our 
added and deleted records on a regular basis. One of the questions that has 
come up is how Evergreen treats deleted records. The questions are: 


When you run an export of updated records, are deleted records included in the 
file? Do they have a flag in the MARC record to signal that the record has been 
deleted? III Millennium is an example of an ILS that has this capability. 

or 

Does the ILS output deleted records to a file on the server? Ex Libris Voyager 
is an example of an ILS that has this capability. 
or 

Does the ILS provide a report of MARC records by ID number? SirsiDynix Symphony 
is an example of an ILS that has this capability. 

I really have no idea how to go about answering these questions. Could anyone 
help me with this? 

Btw, any Evergreen libraries implementing Summon? 

Thanks! 
Gordana 


Gordana Vitez 
Library Services  Systems Coordinator 
 Niagara College Libraries 
 Welland Campus 
 300 Woodlawn Rd 
 Welland Ontario 
 L3C 7L3 
 Phone: (905) 735 2211 ext 7404 
 Fax: (905) 736 6021 
 gvi...@niagaracollege.ca 


[OPEN-ILS-GENERAL] ***SPAM*** Re: [Fwd: Re: Printing to a USB receipt printer]

2010-08-24 Thread Aaron Zsembery
 On Tue, Aug 24, 2010 at 11:18 AM, JohnRoy McVicker jmcvi...@grpl.org
 wrote:
  Am I going about this the wrong way?  Any tips of how to setup a USB
 receipt
  printer and use the Mozilla Print strategy?
I am a little late to this discussion, do you have a model printer that you are 
planning on using? 

We are not yet live on Evergreen yet, but in my printer testing, I have tested 
the Star TSP100 (USB, Thermal) with the staff client versions 1.6.3, .4, .6 and 
.7. It seems to handle both Mozilla mode and DOS mode without any noticeable 
issues.

I think that the Star SP512 (LPT, Dot Matrix) could also work (with a LPT to 
USB adapter or if there is a USB variant of it). In our testing, it has handled 
Mozilla print mode properly as well as DOS print mode.

Aaron Z
Jr. Systems Administrator

Pioneer Library System
2557 State Rt. 21
Canandaigua, New York  14424
Phone: (585) 394-8260