[OPEN-ILS-DEV] Custom Booking module and Evergreen Database structure

[James Fournie]

Hi Robert,

I can venture a response and tell you that yes, it will likely require
pages of code and new database tables.  I think there definitely is a
desire for this in the community, however I think considering the
amount of effort involved, it is probably a very low priority for
production sites.

Some of our SITKA sites already had vendor-based booking systems prior
to migration which used the SIP protocol to authenticate with their
legacy ILS, so we were able to just adjust the SIP settings to
authenticate with the Evergreen SIP server.

I would guess there are also open source booking systems that do what
you want, and it would probably be less code to modify an existing
system to authenticate with Evergreen, rather than write one from
scratch.

~James Fournie
BC SITKA Team


On Thu, Mar 12, 2009 at 8:00 AM, Robert Soulliere
<robert.soulliere at mohawkcollege.ca> wrote:
> I asked a question about booking modules and Evergreen database
> structure on the general board a few weeks ago but didn't get a
> response. I might have asked the wrong list at that time?
>
> I was hoping for clarification on whether creating a booking module
> would require pages of code or would require adding entirely new tables
> to Evergreen?
>
> I was thinking that the staff holds module could be used as a template
> or starting point?
>
> Does that make sense?
>
> Would it be possible to create a booking module within Evergreen or
> should I develop something outside of the Evergreen framework which
> interacts with the database?
>
> Thanks,
> Robert
>
>
> This E-mail contains privileged and confidential information intended
> only for the individual or entity named in the message.  If the reader
> of this message is not the intended recipient, or the agent responsible
> to deliver it to the intended recipient, you are hereby notified that
> any review, dissemination, distribution or copying of this communication
> is prohibited.  If this communication was received in error, please
> notify the sender by reply E-mail immediately, and delete and destroy
> the original message.
>
>
> ---------- Forwarded message ----------
> From: Robert Soulliere <robert.soulliere at mohawkcollege.ca>
> To: Evergreen Discussion Group <open-ils-general at list.georgialibraries.org>
> Date: Fri, 06 Mar 2009 15:08:26 -0500
> Subject: Custom Booking module and Evergreen Database structure
> To create a material booking module for a library, would someone be able
> to use the existing database tables for holds and just differentiate it
> with a "booking" identifier in the hold_type field or would creating a
> booking module require entire new tables? It seems that the
> action.hold_requests table structure allows for hourly bookings on
> materials but I wasn't sure?
>
> Thanks,
> Robert
>
> ----- Original Message -----
> From: Dan Scott <denials at gmail.com>
> Date: Friday, March 6, 2009 9:13 am
> Subject: Re: [OPEN-ILS-GENERAL] strange behavior during record update
> To: tigran at flib.sci.am, Evergreen Discussion Group
> <open-ils-general at list.georgialibraries.org>
> Cc: Jason Etheridge <jason at esilibrary.com>
>
>> This bug is fixed as of last night (thanks miker!); it will show up in
>> the next 1.4 release. There are a few more bugs that we're working on
>> before that next release will be cut.
>>
>> If you want to apply the fix for the problem right away to your 1.4
>> install, you can:
>>
>> 1. download the latest version of Cat.pm
>> (http://svn.open-ils.org/trac/ILS/browser/branches/rel_1_4_0/Open-
>> ILS/src/perlmods/OpenILS/Application/Cat.pm?rev=12435)2. copy it
>> over your existing version of the file in in
>> /openils/lib/perl5/OpenILS/Application/
>> 3. restart the Perl services
>>
>> Thanks again for the bug report, Tigran.
>>
>> (Oh, and Jason fixed my fix for the "Record 1 of 0" annoyance... heh).
>>
>> Dan
>>
>> 2009/3/5 Dan Scott <denials at gmail.com>:
>> > Hi Tigran:
>> >
>> > These are the same problems that I have reported in bug #47
>> > (http://svn.open-ils.org/trac/ILS/ticket/47) - I don't know of
>> any way
>> > around the problem, other than to restart the OpenSRF services every
>> > time you want to edit an existing bibliographic record. Which is, of
>> > course, completely unworkable. Essentially, this makes the 1.4
>> release> currently unusable.
>> >
>> > On the bright side, I did commit a fix for the "Record 1 of 0"
>> > annoyance last night. :-/
>> >
>> > Dan
>> >
>> > 2009/3/5 Tigran Zargaryan <tigran at flib.sci.am>:
>> >> Hello Jason,
>> >> we have drooped the database to the initial status, and started
>> the new
>> >> cataloging.
>> >> Here is the picture.
>> >> 1. For the first record we have done full bibl. level
>> description and have
>> >> added the holdings data. This record is being saved and
>> displayed in a
>> >> normal way. After that I have started to do the changes using
>> 'MARC Edit'.
>> >> First time update on the fields for the Author, Title, etc are
>> going normal,
>> >> and the system is saving all the changes.
>> >> 2. When I am starting to update the same fields for the first
>> record second
>> >> time, the system is not saving that changes.
>> >> 3. I am creating another bibl. record (with holding information).
>> >> For this and other records no any changes are being saved,
>> although the
>> >> system is replying that the Changes are saved.
>> >>
>> >> So I can create the new records without problems. When trying to
>> update the
>> >> field content, the system is not saving the changes.
>> >> Any ideas what to do?
>> >> thanks,
>> >> Tigran
>> >>
>> >> Jason Etheridge wrote:
>> >>>>
>> >>>> Why when I am having more that one Bib. records in my
>> database, my
>> >>>> changes are not being saved?
>> >>>>
>> >>>
>> >>> I think Dan noticed the same bug.  Does it seem to make a
>> difference>>> if you have items attached to the records being edited?
>> >>>
>> >>>
>> >>>>
>> >>>> I noticed that when viewing the record, on the top left side
>> of the
>> >>>> screen the system is displaying 'Record 1 of 0', which I guess
>> is something
>> >>>> abnormal.(see attached image).
>> >>>>
>> >>>
>> >>> This is just a harmless cosmetic bug you can ignore, unrelated
>> to your
>> >>> main issue.
>> >>>
>> >>>  ---------------------------------------------------------------
>> ---------
>> >>>
>> >>>
>> >>> No virus found in this incoming message.
>> >>> Checked by AVG - www.avg.com Version: 8.0.237 / Virus Database:
>> >>> 270.11.6/1980 - Release Date: 03/02/09 23:02:00
>> >>>
>> >>>
>> >>
>> >>
>> >> --
>> >> Dr. Tigran Zargaryan
>> >> Director
>> >> Fundamental Scientific Library
>> >> Academy of the Sciences
>> >> Republic of Armenia
>> >> Baghramyan ave., 24D
>> >> 0019, Armenia
>> >> Yerevan
>> >> T. +37410 524750
>> >> F. +37410 524750
>> >> URL: http://www.flib.sci.am
>> >> e-mail: tigran at flib.sci.am
>> >> Google talk: tigran at flib.sci.am
>> >>
>> >>
>> >
>> >
>> >
>> > --
>> > Dan Scott
>> > Laurentian University
>> >
>>
>>
>>
>> --
>> Dan Scott
>> Laurentian University
>>
>
>
> This E-mail contains privileged and confidential information intended
> only for the individual or entity named in the message.  If the reader
> of this message is not the intended recipient, or the agent responsible
> to deliver it to the intended recipient, you are hereby notified that
> any review, dissemination, distribution or copying of this communication
> is prohibited.  If this communication was received in error, please
> notify the sender by reply E-mail immediately, and delete and destroy
> the original message.
>
>