Re: [OPEN-ILS-GENERAL] Z39.50 Searching

2009-10-12 Thread Dan Scott
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

2009-10-12 Thread 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. 




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 Thread Dan Scott
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

2009-10-12 Thread Mike Rylander
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 Thread Forrest, Stuart
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 Thread Dan Scott
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

2009-10-12 Thread Hardy, Elaine
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

2009-10-12 Thread Catherine Buck Morgan
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

2009-10-12 Thread Sharp, Chris
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

2009-10-12 Thread Catherine Buck Morgan
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.