Content-Type: multipart/related; type="multipart/alternative"; boundary="----_=_NextPart_002_01CD847E.2D280D63" ------_=_NextPart_002_01CD847E.2D280D63 Content-Type: multipart/alternative; boundary="----_=_NextPart_003_01CD847E.2D280D63" ------_=_NextPart_003_01CD847E.2D280D63 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Demian, =20 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. =20 Mark =20 =20 Mark Sandford Special Formats Cataloger Cheng Library William Paterson University (973) 720-2437 =20 =20 =20 From: Demian Katz [mailto:demian.katz@villanova.edu]=20 Sent: Wednesday, August 22, 2012 2:06 PM To: Wagner, Kurt; vufind-general Subject: Re: [VuFind-General] Voyager "EFFECT_DATE" and course reserves inVUFind =20 I've just talked to one of the people here who works on course reserves. Apparently the 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 are finished with them. That's probably why the Voyager driver was not implemented to pay attention to EFFECT_DATE - we don't really use the feature here. =20 In order to implement support for EFFECT_DATE, you probably just need to modify the SQL statements in the getDepartments, getInstructors, getCourses and findReserves methods. 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 current date to filter out expired or not-yet-available data. =20 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 figure 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 off the top of my head, but it shouldn't be too hard to look up. =20 Let me know if you need 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 releases. =20 thanks, Demian =20 From: Wagner, Kurt [mailto:WagnerK@wpunj.edu]=20 Sent: Wednesday, August 22, 2012 11:26 AM To: vufind-general Subject: [VuFind-General] Voyager "EFFECT_DATE" and course reserves in VUFind =20 Could someone who uses the Voyager ILS beneath VUFind discuss how they handle 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, 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 being used by others? =20 This is our first semester using VUFind, and there are always details like this to consider. =20 Thanks Kurt =20 ------------------------------------------------------------------------ Kurt W. Wagner Assistant Director, Library Information Systems David and Lorraine Cheng Library =20 William Paterson University - Wayne, NJ USA 07470 TEL: 973-720-2285 CELL: 973-907-4376 mailto:wagnerk@wpunj.edu=20 =20 =20 SKYPE: kurt.wagner61 =20 =20 ------_=_NextPart_003_01CD847E.2D280D63 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 = inVUFind

 

I’ve just talked to one of the people here = who works on course reserves.  Apparently the 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 are finished with them.  = That’s probably why the Voyager driver was not implemented to pay = attention to EFFECT_DATE – we don’t really use the feature = here.

 

In order to implement = support for EFFECT_DATE, you probably just need to modify the SQL = statements in the getDepartments, getInstructors, getCourses and = findReserves methods.  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 current 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 = tables and fields, so that might be the best way to figure 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 off 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 feature to the = driver, please share a patch and I’ll make it available in future = 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 = VUFind

 

Could = someone who uses the Voyager ILS beneath VUFind discuss how they handle = 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:

ht= tp://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 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 =

   <= a href=3D"http://www.linkedin.com/in/kurtwagner61">   <= a href=3D"mailto:wagnerk@wpunj.edu">  SKYPE: kurt.wagner61

 

 

------_=_NextPart_003_01CD847E.2D280D63-- ------_=_NextPart_002_01CD847E.2D280D63 Content-Type: image/png; name="image001.png" Content-Transfer-Encoding: base64 Content-ID: Content-Description: image001.png Content-Location: image001.png iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAIAAABvFaqvAAAAAXNSR0IArs4c6QAAABl0RVh0U29m dHdhcmUATWljcm9zb2Z0IE9mZmljZX/tNXEAAAKhSURBVDhPnVTPaxNBGN3dNGkTkyabhKRt2myk haZRRIpKjVJqUEFtD1YEQSIVBEE8eFXE/gE9FAT1YqGhitCTBykEJBC1aARB/BW10p8HMTFW25Qk ze6M32RrWGcnh3R5hNnJ27fv+743y3Mc59vZc2z4crPogXW919pqJjkztZB+w7cFgmcv3Qp1tdqt 5npVgP8nX5hf+fn44W1+6ML140cjyNC4kCltQ8htM7aKwovUR8Hr73Y4dnz7XlAUtA38+F2SEW93 OBrgYYSwjHAtO0OHugZ6/eYmo0q4MhanmOVNxPO8IIMOXApmYjDceSLcWVUBiXs3n9BMDoMbgTjC GH6Y6NvlU9+/tJxLPp8DcKQB/5FlhQM3FSEoTUFMOB1bozw/EoucujsYnbT6RIpJ6gFHsgJVgSM2 qu3gFRQZ3nP6Yh+AIoMP0BLKxBECbxSCkgtQFdrX27432AI7eiYIgaMGGQyRFT21GyNh7XTGx8+p twPR+17Jrf0LDMHQoUek2/rSaqUh+SChLw1skhwpGHKEqCenn6bTs59GR8+o+7HYs8XFbGUpU2TQ BSNqjkiRFKbiHyZn3lfVJyYSdx69gp3AgRDFVIeujp8UqUfwcEhjE0u7JdgBUEwSq8r4wRlWZDY0 QqQDTBqkhwQShMBbGSEmNELkxUwOOPlXGiYZZ0IjJIMKk4NJHrHqCIokUdJD2yM1bnpAy7aOSCUX 7ENLlcakVb5C1dNfw9HVsXh//zVAKvVZhmazaILAFUtlg8nZ4fW0tYiWldVN+LpRWM7ms0W8ZrTa ApLFJWLBQBH8LpPbwr1+95VvFP3SweiR/d0epy2Xl2udDOZ+s9mwsVGYfTv/5eU0DwyT2GHvOWlo sre77XUJrReKv3KZ9blEMTv3FyIo6NmopWmeAAAAAElFTkSuQmCC ------_=_NextPart_002_01CD847E.2D280D63 Content-Type: image/png; name="image002.png" Content-Transfer-Encoding: base64 Content-ID: Content-Description: image002.png Content-Location: image002.png iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAIAAABvFaqvAAAAAXNSR0IArs4c6QAAABl0RVh0U29m dHdhcmUATWljcm9zb2Z0IE9mZmljZX/tNXEAAAMASURBVDhPnVPtS1NRGH/O3YtrbG1uOIiZpmRm L7IwqEhSa+uDVJIGhRD0saD6LIF98lP4Jf+CSPoUlC8QhEmJSFFiJmq2WGpKNDfndOLmfTmn59w7 3VUXvjx77vbc5+V3fud3zggA2AvKDl25Z3Z4MN6tiYtzMz3P4z8Hie1g2fHbjwNHvXlOy25RsD8S T32enBt8+ZQU3XzUEPC3Wy3h2OoegMBqbLGSFwNjgtlbesBlDUdTQNlefFkKEcHjdAhUpmigudfR Ue9DhyJ3OrNe+n8wLzMDIYKIMIyBwj1ae7LOm4se9ZfBRFhLbuuKwskIksKRtPXdFpMmEw86vu2Y FKMKFfBRgbhfHwhpQM1P3sLS6g4lkxlDBCHFJUpr1NEfJLVtJOd+S3M3VBXvmBGVFWpERrICfHGA h4FjlxrPYNAbXmrrGYcT3s7yfI1j3chsZ7n3WoEb42A8Wdo7Dj/CWgnpIBXjMqUKF5tiyu+xXy1w YWD7u9jWPXKj8vA19RWNrQUYH3HuYw0VpP0TTEXxVaFMQrFVjXBrqkxrZkhK8HuBZBJZrurUhRIY /aMOUjw4ARQ0it/ckVraGDBZwAXWrKtrKCfnLvr0NGeBVljoto/N8nHKNUKgjNgkA0SBSbpXaG19 I3pt4oOaplBkHd3nMsN8giGCoqwzQlKZ9VETZKQHQingbDGYDJuTCwmkgyYAVfBeZtka4Nb0Isla T5YkwnBG/Cd9j3TqZmNEFWzezAiH+UcTmzPStqYTm27QCEBC7tizEYgnJY7EGamnhpcSXX9qfGt6 1ZAO79maJCojI9Y4I3WmfyZmjcQEURweDqHYfdHld0MhUyKBpVhsAXI92LY1ieNMVgj4m+74Tz+b XEwfat9HmFMP2JMHVefgexBGJ9Kl6vOQx/8im5KVvsKRr0ECp27VVF98b7FCJJnl/m6bspvqbYZX HwYJOPOhojHgK/E47UMpedtBfUOp2SCuJHvHfq1+eU14wZEPJZfBst/psu8KKL4iQjwCk30wH/oH GC6mds9Ry4AAAAAASUVORK5CYII= ------_=_NextPart_002_01CD847E.2D280D63 Content-Type: image/png; name="image003.png" Content-Transfer-Encoding: base64 Content-ID: Content-Description: image003.png Content-Location: image003.png iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAIAAABvFaqvAAAAAXNSR0IArs4c6QAAABl0RVh0U29m dHdhcmUATWljcm9zb2Z0IE9mZmljZX/tNXEAAAMOSURBVDhPnVRdSFNhGD7nTHOba2eYDp0/c9q0 FJ0SSCjTpUUUtLAfSBLUbrrwahEEIRwG0m1dREFhU7DUAi+GJnqRrUCnSahY2ULLLZM23Q85p/Oc 7/TunDkWZbp9vBy+8533efY87/t+wzEMK1IWtupb5LI02Me6nF5X53DvO9s0XpRTYGy6la7OFJHJ sbJAfsDnX7U77/U9xNsabtSdrP1Fo0+LK3EQpaeSBdmpH6yzxJHMw2KZZO7LMsOgOGL5p8cfpGWk jEAIsSxLIybuCAZpFscJRCMWuOAZb2AAZxBuar1boC0ZfjsHBcrIShOKD+yzUpsbwZXvLkiuKFGt 250JUBiMYaE6cJSjVhwtz1flZe/JtbTkeDVgZQUMCuIhQ4ghEINYEMeE4uxF3fzcwtDA6P+JLJax zs6+ltbLWCJye9wcDyKYUKtAEQ0B+DN6XZmm2PSoZzeurq4en89HUTch4fXkqNu7FmoXw3KKOEoI HpyRLW9orH9q6vd6vdF08Go03tHpqvT6MzvnAAMwBlp4ovAERWBCsfBqy4XH97utY5P84czMrNHY TlG3lcqcKPZtrijQcV4RC9ZCK/r3zWZzhbZUKiEHzSMWiwXkUFTbQP/In5ZpIIIKI0QTMD4hdfCk w9Yg1WAwKJXKmprqotLC2jptbm4u7GUyWd1prWVoIooLzHBwBiPA3k7TwkTA0tzcrNFoeIAoWQSk kX1FdanpQW+kfBwRpyg02WCNuyC8lmiWv3sHvFeazr948jLgD8BX7mLw7ee1cet5xyBFUREtu00A cDVer+/rGHLYl8NYBiXANQEamCKAfZxesE6MT82/2XOyIcG/HlBI1GKhhBcB1hjQxltbtDk+z9qT NtL3EymESiaRi5OkvDW8vc5wTF/ZbR7fj4p/5pyqKvbO2wk6VCQsjr+0CCRRIKC3tolvbofnh6uy PJ+/JbFGXtYhkQBfda7iSlJxreyS+nixNJVcWfPFZDBFmsxsbC6+tz2bMuOAVEoV51QnyKSDpJyM iWjTv+V0u0bsYzbP19/sIgg5jVNRaAAAAABJRU5ErkJggg== ------_=_NextPart_002_01CD847E.2D280D63--