Content-Type: multipart/alternative; boundary="_000_FAA7DF3F09441B4DA93A34DF7459614005191EVUEX14MB1vuadvill_" --_000_FAA7DF3F09441B4DA93A34DF7459614005191EVUEX14MB1vuadvill_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Quick update: for future reference, I have opened a JIRA ticket containing = this patch: http://vufind.org/jira/browse/VUFIND-639 If there's any additional technical discussion of this subject, it might ma= ke sense to have it in the comments on the ticket. - Demian From: Demian Katz Sent: Monday, August 27, 2012 3:25 PM To: 'Sandford, Mark' Cc: vufind-general@lists.sourceforge.net; Wagner, Kurt Subject: RE: [VuFind-General] Voyager "EFFECT_DATE" and course reserves inV= UFind Thanks for sharing this. I've converted your diff file into an SVN patch u= sing TortoiseSVN - some people might find this format slightly more conveni= ent. One question: shouldn't there also be some changes to findReserves()? Othe= rwise, it seems like this patch will hide courses/instructors/departments w= here everything is expired, but you could still end up in a situation where= you search for a course/instructor/department that has some expired and so= me non-expired content, and you would see all matches, not just the non-exp= ired stuff. - Demian From: Sandford, Mark [mailto:SANDFORDM1@wpunj.edu] Sent: Monday, August 27, 2012 2:03 PM To: Demian Katz Cc: vufind-general@lists.sourceforge.net; Wagner, Kurt Subject: RE: [VuFind-General] Voyager "EFFECT_DATE" and course reserves inV= UFind Hi Demian, I modified our installation to check for EFFECT_DATE and EXPIRE_DATE. I've= attached a diff file based on the svn for 1.3, but having never done this = before, I'm not positive it's in the correct format. Let me know if there = are any problems. Mark Mark Sandford Special Formats Cataloger Cheng Library William Paterson University (973) 720-2437 From: Demian Katz [mailto:demian.katz@villanova.edu] Sent: Wednesday, August 22, 2012 2:06 PM To: Wagner, Kurt; vufind-general Subject: Re: [VuFind-General] Voyager "EFFECT_DATE" and course reserves inV= UFind I've just talked to one of the people here who works on course reserves. A= pparently the EFFECT_DATE is not really an issue for us, because we don't e= nter items into the system until they have been pulled to the reserve shelv= es, and we remove them from the system shortly after we are finished with t= hem. That's probably why the Voyager driver was not implemented to pay att= ention to EFFECT_DATE - we don't really use the feature here. In order to implement support for EFFECT_DATE, you probably just need to mo= dify the SQL statements in the getDepartments, getInstructors, getCourses a= nd findReserves methods. Presumably there are fields in the RESERVE_LIST t= able (or another table you can join) which reflect the dates, and you can a= dd some extra where clauses to compare these against the current date to fi= lter out expired or not-yet-available data. I believe if you have access to the Voyager technical manual, it includes a= list of database tables and fields, so that might be the best way to figur= e out exactly what field(s) you need to worry about. I don't have a whole = lot of Oracle experience, so I don't know the syntax for date comparisons o= ff the top of my head, but it shouldn't be too hard to look up. Let me know if you need more help... and if you succeed in adding this feat= ure to the driver, please share a patch and I'll make it available in futur= e VuFind releases. thanks, Demian From: Wagner, Kurt [mailto:WagnerK@wpunj.edu] Sent: Wednesday, August 22, 2012 11:26 AM To: vufind-general Subject: [VuFind-General] Voyager "EFFECT_DATE" and course reserves in VUFi= nd Could someone who uses the Voyager ILS beneath VUFind discuss how they hand= le course reserves? The Voyager OPAC uses the Voyager field EFFECT_DATE to= toggle material and list visibility. In our instance, the Voyager Reserves= interfaces shows not active course reserves at the present time: http://cheng.wpunj.edu/vwebv/enterCourseReserve.do?sk=3Den_US. In VUFind, h= owever, Courses, Instructors and Departments are all visible. Is there some= place in the VUFind config where visibility is controlled or is there some = other approach being used by others? This is our first semester using VUFind, and there are always details like = this to consider. Thanks Kurt ------------------------------------------------------------------------ Kurt W. Wagner Assistant Director, Library Information Systems David and Lorraine Cheng Library William Paterson University - Wayne, NJ USA 07470 TEL: 973-720-2285 CELL: 973-907-4376 mailto:wagnerk@wpunj.edu [cid:image001.png@01CD8468.A38A2FA0] [cid:image002.png@01CD8468.A38A2FA0] [cid:image003.png@01CD8468.A38A2FA0] = SKYPE: kurt.wagner61 --_000_FAA7DF3F09441B4DA93A34DF7459614005191EVUEX14MB1vuadvill_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Quick update: for futu= re reference, I have opened a JIRA ticket containing this patch:=

 

http://vufind.org/jira/browse/VUFIND-639=

 

If there’s any a= dditional technical discussion of this subject, it might make sense to have= it in the comments on the ticket.

 

- Demian

 

From: Demian K= atz
Sent: Monday, August 27, 2012 3:25 PM
To: 'Sandford, Mark'
Cc: vufind-general@lists.sourceforge.net; Wagner, Kurt
Subject: RE: [VuFind-General] Voyager "EFFECT_DATE" and co= urse reserves inVUFind

 

Thanks for sharing thi= s.  I’ve converted your diff file into an SVN patch using Tortoi= seSVN – some people might find this format slightly more convenient.<= o:p>

 

One question: shouldn&= #8217;t there also be some changes to findReserves()?  Otherwise, it s= eems like this patch will hide courses/instructors/departments where everyt= hing is expired, but you could still end up in a situation where you search for a course/instructor/department that has s= ome expired and some non-expired content, and you would see all matches, no= t just the non-expired stuff.

 

- Demian

 

From: Sandford= , Mark [mailto:SANDFORDM1@wpunj.edu]
Sent: Monday, August 27, 2012 2:03 PM
To: Demian Katz
Cc: vufind-general@lists.sourceforge.net; Wagner, Kurt
Subject: RE: [VuFind-General] Voyager "EFFECT_DATE" and co= urse reserves inVUFind

 

Hi Demian,<= /span>

 

I modified our install= ation to check for EFFECT_DATE and EXPIRE_DATE.  I’ve attached a= diff file based on the svn for 1.3, but having never done this before, I&#= 8217;m not positive it’s in the correct format.  Let me know if there are any problems.

 

Mark=

 

 

Mark Sandford

Special Formats Catalo= ger

Cheng Library

William Paterson Unive= rsity

(973) 720-2437

 

 

 

From: Demian K= atz [mailto:demian.katz@villanova.edu]
Sent: Wednesday, August 22, 2012 2:06 PM
To: Wagner, Kurt; vufind-general
Subject: Re: [VuFind-General] Voyager "EFFECT_DATE" and co= urse reserves inVUFind

 

I’ve just talked= to one of the people here who works on course reserves.  Apparently t= he EFFECT_DATE is not really an issue for us, because we don’t enter = items into the system until they have been pulled to the reserve shelves, and we remove them from the system shortly after we a= re finished with them.  That’s probably why the Voyager driver w= as not implemented to pay attention to EFFECT_DATE – we don’t r= eally use the feature here.

 

In order to implement = support for EFFECT_DATE, you probably just need to modify the SQL statement= s in the getDepartments, getInstructors, getCourses and findReserves method= s.  Presumably there are fields in the RESERVE_LIST table (or another table you can join) which reflect the dates= , and you can add some extra where clauses to compare these against the cur= rent date to filter out expired or not-yet-available data.

 

I believe if you have = access to the Voyager technical manual, it includes a list of database tabl= es and fields, so that might be the best way to figure out exactly what fie= ld(s) you need to worry about.  I don’t have a whole lot of Oracle experience, so I don’t know the syntax fo= r date comparisons off the top of my head, but it shouldn’t be too ha= rd to look up.

 

Let me know if you nee= d more help… and if you succeed in adding this feature to the driver,= please share a patch and I’ll make it available in future VuFind rel= eases.

 

thanks,
Demian

 

 

Could someone who uses the Voyager ILS beneath VUFin= d discuss how they handle course reserves?  The Voyager OPAC uses the = Voyager field EFFECT_DATE to toggle material and list visibility. In our in= stance, the Voyager Reserves interfaces shows not active course reserves at the present time:

http://cheng.wpunj.edu/vwebv/enterCourseReserve.do?sk= =3Den_US. In VUFind, however, Courses, Instructors and Departments are = all visible. Is there someplace in the VUFind config where visibility is controlled or is there some other approach bein= g used by others?

 

This is our first semester using VUFind, and there a= re always details like this to consider.

 

Thanks

Kurt

 

----------------= --------------------------------------------------------<= /b>

Kurt W. Wagner

Assistant Director,= Library Information Systems

David and Lorraine Cheng Library

William Paterson Un= iversity - Wayne, NJ USA 07470

TEL: 973-720-2285 C= ELL: 973-907-4376

mailto:wagnerk@wpunj.edu

        SKYPE: kurt.wagner61

 

 

--_000_FAA7DF3F09441B4DA93A34DF7459614005191EVUEX14MB1vuadvill_--