Re: [OPEN-ILS-GENERAL] Z39.50 Searching
2009/10/8 Jason Etheridge : > On Thu, Oct 8, 2009 at 12:17 PM, Forrest, Stuart wrote: >> We have a weird problem here that happens only on certain PC’s. > > Stuart, to eliminate the possibility of some saved setting > interfering, try creating a new "profile" for the problem staff client > as described here: > http://pines.georgialibraries.org/creating-evergreen-workstation-profiles A quick test on trunk with a clean profile here results in LoC returning zero hits for author or title searches, while biblios.net does return hits. I don't have an OCLC account so I can't test that :) I'll try to compare the attribute values from opensrf.xml with the corresponding database settings later, when I have a few more minutes.
Re: [OPEN-ILS-GENERAL] Z39.50 Searching
Jason and Don, I just recreated it here. I was able to correctly re-execute the search after closing and reopening the z39.50 interface. I did not have to close the entire client. I will test with other title/author and ISBN combinations to see if it holds true for others. Elaine J. Elaine Hardy PINES Bibliographic Projects & Metadata Manager Georgia Public Library Service 1800 Century Place, Ste 150 Atlanta, Ga. 30345-4304 404.235-7128 404.235-7201, fax eha...@georgialibraries.org www.georgialibraries.org www.georgialibraries.org/pines - Original Message - From: "Jason Etheridge" To: "Evergreen Discussion Group" Sent: Thursday, October 8, 2009 12:28:14 PM GMT -05:00 US/Canada Eastern Subject: Re: [OPEN-ILS-GENERAL] Z39.50 Searching On Thu, Oct 8, 2009 at 12:17 PM, Forrest, Stuart wrote: > We have a weird problem here that happens only on certain PC’s. Stuart, to eliminate the possibility of some saved setting interfering, try creating a new "profile" for the problem staff client as described here: http://pines.georgialibraries.org/creating-evergreen-workstation-profiles -- 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
Re: [OPEN-ILS-GENERAL] Z39.50 Searching
2009/10/12 Hardy, Elaine : > Jason and Don, > > I just recreated it here. I was able to correctly re-execute the search > after closing and reopening the z39.50 interface. I did not have to close > the entire client. I will test with other title/author and ISBN combinations > to see if it holds true for others. In my case - trunk - I was able to search LoC and get results by updating the truncation attribute from a value of '0' (the default in Evergreen for attributes) to '1' (to correspond to the LoC-supported values of '1' and '100' as documented at http://www.loc.gov/z3950/lcserver.html#trua). The required SQL was: UPDATE config.z3950_attr SET truncation = 1 WHERE source = 'loc'; Then I shut everything down, wiped my staff client profile, started everything back up, and did a successful fresh search of LoC. This is consistent with what I see in yaz-client: $ yaz-client z3950.loc.gov:7090/Voyager Connecting...OK. Sent initrequest. Connection accepted by v3 target. ID : 34 Name : Voyager LMS - Z39.50 Server (YAZ Proxy) Version: 2006.5.2/1.2.1.1 Options: search present Elapsed: 0.130327 Z> find @attr 1=1003 @attr 4=6 @attr 5=0 "trudeau" Sent searchRequest. Received SearchResponse. Search was a bloomin' failure. Number of hits: 0 records returned: 0 Diagnostic message(s) from database: [120] Unsupported Truncation attribute -- v2 addinfo '0' Elapsed: 0.053904 Z> find @attr 1=1003 @attr 4=6 @attr 5=1 "trudeau" Sent searchRequest. Received SearchResponse. Search was a success. Number of hits: 218 records returned: 0 Elapsed: 0.390965 S, we'll want to add the accepted truncation value to the 950 seed data for LoC. This is probably required for 1.6 if the corresponding changes from trunk were backported, yes? In which case, I guess we won't need to create upgrade scripts as the base data will be correct as of 1.6.0.0. Dan
Re: [OPEN-ILS-GENERAL] Z39.50 Searching
On Mon, Oct 12, 2009 at 12:21 PM, Dan Scott wrote: > 2009/10/12 Hardy, Elaine : >> Jason and Don, >> >> I just recreated it here. I was able to correctly re-execute the search >> after closing and reopening the z39.50 interface. I did not have to close >> the entire client. I will test with other title/author and ISBN combinations >> to see if it holds true for others. > > In my case - trunk - I was able to search LoC and get results by > updating the truncation attribute from a value of '0' (the default in > Evergreen for attributes) to '1' (to correspond to the LoC-supported > values of '1' and '100' as documented at > http://www.loc.gov/z3950/lcserver.html#trua). > > The required SQL was: > > UPDATE config.z3950_attr SET truncation = 1 WHERE source = 'loc'; > > Then I shut everything down, wiped my staff client profile, started > everything back up, and did a successful fresh search of LoC. > > This is consistent with what I see in yaz-client: > [snip test case] > > S, we'll want to add the accepted truncation value to the 950 seed > data for LoC. This is probably required for 1.6 if the corresponding > changes from trunk were backported, yes? In which case, I guess we > won't need to create upgrade scripts as the base data will be correct > as of 1.6.0.0. > > Dan > Adding that now, as a part of my 1.6.0.0 polishing. -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@esilibrary.com | web: http://www.esilibrary.com
Re: [OPEN-ILS-GENERAL] Z39.50 Searching
Just to note: We at Beaufort are having this problem mainly with OCLC. I deleted the users profile, created a new one then tried the search process again. It eorked OK for about 5 or 6 tries then went back to what it was doing before. IE in this order: Search Auth/Title records returned Search ISBN records returned Search Auth/Title no records returned. Once the client is (Evergreen Staff Client that is) is reset Auth/Title searching works again until an ISBN search is performed and the Auth/Title search no longer works Thanks Stuart *** Stuart Forrest PhD Library Systems Specialist Beaufort County Library 311 Scott Street Beaufort SC 29902 Tel 843 470 6534 -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Mike Rylander Sent: Monday, October 12, 2009 12:50 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Z39.50 Searching On Mon, Oct 12, 2009 at 12:21 PM, Dan Scott wrote: > 2009/10/12 Hardy, Elaine : >> Jason and Don, >> >> I just recreated it here. I was able to correctly re-execute the search >> after closing and reopening the z39.50 interface. I did not have to close >> the entire client. I will test with other title/author and ISBN combinations >> to see if it holds true for others. > > In my case - trunk - I was able to search LoC and get results by > updating the truncation attribute from a value of '0' (the default in > Evergreen for attributes) to '1' (to correspond to the LoC-supported > values of '1' and '100' as documented at > http://www.loc.gov/z3950/lcserver.html#trua). > > The required SQL was: > > UPDATE config.z3950_attr SET truncation = 1 WHERE source = 'loc'; > > Then I shut everything down, wiped my staff client profile, started > everything back up, and did a successful fresh search of LoC. > > This is consistent with what I see in yaz-client: > [snip test case] > > S, we'll want to add the accepted truncation value to the 950 seed > data for LoC. This is probably required for 1.6 if the corresponding > changes from trunk were backported, yes? In which case, I guess we > won't need to create upgrade scripts as the base data will be correct > as of 1.6.0.0. > > Dan > Adding that now, as a part of my 1.6.0.0 polishing. -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@esilibrary.com | web: http://www.esilibrary.com
Re: [OPEN-ILS-GENERAL] Z39.50 Searching
2009/10/12 Mike Rylander : >> S, we'll want to add the accepted truncation value to the 950 seed >> data for LoC. This is probably required for 1.6 if the corresponding >> changes from trunk were backported, yes? In which case, I guess we >> won't need to create upgrade scripts as the base data will be correct >> as of 1.6.0.0. >> >> Dan >> > > Adding that now, as a part of my 1.6.0.0 polishing. miker++ You're on fire today!
Re: [OPEN-ILS-GENERAL] Z39.50 Searching
I've not been able to reliable recreate it in OCLC searching again. I tried about six other author/title/ISBN combinations as well as the example you sent again and it never occurred another time. Elaine J. Elaine Hardy PINES Bibliographic Projects & Metadata Manager Georgia Public Library Service 1800 Century Place, Ste 150 Atlanta, Ga. 30345-4304 404.235-7128 404.235-7201, fax eha...@georgialibraries.org www.georgialibraries.org www.georgialibraries.org/pines - Original Message - From: "Stuart Forrest" To: "Evergreen Discussion Group" Sent: Monday, October 12, 2009 12:56:38 PM GMT -05:00 US/Canada Eastern Subject: Re: [OPEN-ILS-GENERAL] Z39.50 Searching Just to note: We at Beaufort are having this problem mainly with OCLC. I deleted the users profile, created a new one then tried the search process again. It eorked OK for about 5 or 6 tries then went back to what it was doing before. IE in this order: Search Auth/Title records returned Search ISBN records returned Search Auth/Title no records returned. Once the client is (Evergreen Staff Client that is) is reset Auth/Title searching works again until an ISBN search is performed and the Auth/Title search no longer works Thanks Stuart *** Stuart Forrest PhD Library Systems Specialist Beaufort County Library 311 Scott Street Beaufort SC 29902 Tel 843 470 6534 -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Mike Rylander Sent: Monday, October 12, 2009 12:50 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Z39.50 Searching On Mon, Oct 12, 2009 at 12:21 PM, Dan Scott wrote: > 2009/10/12 Hardy, Elaine : >> Jason and Don, >> >> I just recreated it here. I was able to correctly re-execute the search >> after closing and reopening the z39.50 interface. I did not have to close >> the entire client. I will test with other title/author and ISBN combinations >> to see if it holds true for others. > > In my case - trunk - I was able to search LoC and get results by > updating the truncation attribute from a value of '0' (the default in > Evergreen for attributes) to '1' (to correspond to the LoC-supported > values of '1' and '100' as documented at > http://www.loc.gov/z3950/lcserver.html#trua). > > The required SQL was: > > UPDATE config.z3950_attr SET truncation = 1 WHERE source = 'loc'; > > Then I shut everything down, wiped my staff client profile, started > everything back up, and did a successful fresh search of LoC. > > This is consistent with what I see in yaz-client: > [snip test case] > > S, we'll want to add the accepted truncation value to the 950 seed > data for LoC. This is probably required for 1.6 if the corresponding > changes from trunk were backported, yes? In which case, I guess we > won't need to create upgrade scripts as the base data will be correct > as of 1.6.0.0. > > Dan > Adding that now, as a part of my 1.6.0.0 polishing. -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@esilibrary.com | web: http://www.esilibrary.com
[OPEN-ILS-GENERAL] Assistance needed with a report
I'm trying to create a report that will give me the number of users by patron type *for a specific date*. That last one is stumping me. I can't figure out how to get a timestamp for say, Sept. 30. My source is ILS User. Any assistance would be appreciated. (We're on Evergreen 1.4.0.6) Thanks, Catherine. -- Catherine Buck Morgan Director, Division of Innovation, Technology & Library Services South Carolina State Library POB 11469, 1500 Senate Street, Columbia, SC 29211 Phone: 803.734.8651 | Cell: 803.239.8363 | Fax: 803.734.4757 cmor...@statelibrary.sc.gov www.statelibrary.sc.gov The South Carolina State Library is a national model for innovation, collaboration, leadership and effectiveness. It is the keystone in South Carolina's intellectual landscape.
Re: [OPEN-ILS-GENERAL] Assistance needed with a report
Hi Catherine, Would it be patrons who used the library (checked out, placed a hold, etc) on a specific date? Or patrons who were created on a specific date? What is the importance of the date in your report? Dates in Evergreen are almost always tied to actions. Chris Chris Sharp PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, Georgia 30345 (404) 235-7147 csh...@georgialibraries.org http://pines.georgialibraries.org/ - "Catherine Buck Morgan" wrote: > I ’ m trying to create a report that will give me the number of users > by patron type * for a specific date * . That last one is stumping me. > I can ’ t figure out how to get a timestamp for say, Sept. 30. My > source is ILS User. > > Any assistance would be appreciated. (We ’ re on Evergreen 1.4.0.6) > > Thanks, > > Catherine. > > > > -- > > Catherine Buck Morgan > > Director, Division of Innovation, Technology & Library Services > > South Carolina State Library > > POB 11469, 1500 Senate Street, Columbia , SC 29211 > > Phone: 803.734.8651 | Cell: 803.239.8363 | Fax: 803.734.4757 > > cmor...@statelibrary.sc.gov www.statelibrary.sc.gov > > The South Carolina State Library is a national model for innovation, > collaboration, leadership and effectiveness. It is the keystone in > South Carolina ’ s intellectual landscape.
Re: [OPEN-ILS-GENERAL] Assistance needed with a report
I did it. I need to know the total number of registered patrons on the last day of the month. I ended up filtering this: ILS User ---> User Demographics ---> Record Creation Date/Time, with a field transform of Year+Month and an Operator of On or Before (Date/Time). When I compared the data between Aug and Sept, I came up with a difference of 79, which is the number of new users added in Sept. Thanks, Catherine. -Original Message- From: Sharp, Chris [mailto:csh...@georgialibraries.org] Sent: Monday, October 12, 2009 4:06 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Assistance needed with a report Hi Catherine, Would it be patrons who used the library (checked out, placed a hold, etc) on a specific date? Or patrons who were created on a specific date? What is the importance of the date in your report? Dates in Evergreen are almost always tied to actions. Chris Chris Sharp PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, Georgia 30345 (404) 235-7147 csh...@georgialibraries.org http://pines.georgialibraries.org/ - "Catherine Buck Morgan" wrote: > I ’ m trying to create a report that will give me the number of users > by patron type * for a specific date * . That last one is stumping me. > I can ’ t figure out how to get a timestamp for say, Sept. 30. My > source is ILS User. > > Any assistance would be appreciated. (We ’ re on Evergreen 1.4.0.6) > > Thanks, > > Catherine. > > > > -- > > Catherine Buck Morgan > > Director, Division of Innovation, Technology & Library Services > > South Carolina State Library > > POB 11469, 1500 Senate Street, Columbia , SC 29211 > > Phone: 803.734.8651 | Cell: 803.239.8363 | Fax: 803.734.4757 > > cmor...@statelibrary.sc.gov www.statelibrary.sc.gov > > The South Carolina State Library is a national model for innovation, > collaboration, leadership and effectiveness. It is the keystone in > South Carolina ’ s intellectual landscape.