Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#50 Self Service - Configurable.

open
nobody
None
5
2008-06-23
2008-06-23
H.-J. Tappe
No

This patch adds a configuration option which enables self-service, to be used in small, private (i.e. adult school) libraries.

It opens access to the following functions:
- Member search (by card number or name)
- Show member info
- Member history display
- Place an item onhold
- Checkout
- Member print checkouts
- Put books back to shelfing cart
- Show shelfing cart

Not included in self-service (need staff logged in):
- Edit / add / modify user
- Shelfing cart / book checkin to bookshelfes

Note that a new database table entry is neccessary in order to use this patch.
This can be added via any mysql administration tool in a running system (like "use_image_flg"). On a fresh database population / install after applying
this patch, the database entry will automatically be added.

Translation-ready (en part of this patch).

Discussion

  • Logged In: NO

    I get a zip error after download, please check the file. Thanks. Bastor

     
  • H.-J. Tappe
    H.-J. Tappe
    2008-07-30

    Logged In: YES
    user_id=2125563
    Originator: YES

    The zip file downloads and extracts cleanly on several systems - except: I fail to download *any* zip file (also other people's patches) from sourceforge using Windows and Internet Explorer. Please try another Browser Software.

     
  • Orso
    Orso
    2008-08-28

    Logged In: YES
    user_id=1605054
    Originator: NO

    How do I use this patch? I'm running OpenBiblio in XAMPP; OS: Windows XP

    Kind regards, Clemens

     
  • H.-J. Tappe
    H.-J. Tappe
    2008-08-31

    Logged In: YES
    user_id=2125563
    Originator: YES

    I'm not sure if I understand the question, but I'll give it a try:
    A *.patch file is a standard "unified diff" format (which can be read with
    a text editor) to show or apply changes to software source code:
    - Lines starting with "+++" or "---" show the original file names.
    - Lines starting with "@@" show the patch start lines in the original and
    modified file plus the lines resulting from the patch (patch length),
    separated from the start lines by a comma.
    - Lines starting with "-" have been removed,
    - Lines starting with "+" have been added.

    A "patch" program can be used to apply the patch to the source code. If
    you start in the main openbiblio directory, this patch includes two levels
    of other directories, which the patch program needs to strip, so e.g.
    "patch -p2 < advancedSearch.patch" will do the job (Linux example).

    See also (also watch the links to Windows programs at the end of the
    articles):
    - http://en.wikipedia.org/wiki/Diff#Unified_format
    - http://en.wikipedia.org/wiki/Patch_\(Unix)
    - http://en.wikipedia.org/wiki/Patch_\(computing)

    Another option (in case you don't have access to a patch program) is to
    modify the source code according to the differences as shown in the file.

     
  • Orso
    Orso
    2008-10-08

    Hello!

    I used the patch...

    patch -p2 < selfService.patch
    patching file admin/settings_edit.php
    patching file admin/settings_edit_form.php
    patching file classes/Settings.php
    patching file classes/SettingsQuery.php
    patching file locale/en/admin.php
    Hunk #1 succeeded at 187 (offset 6 lines).
    patching file shared/read_settings.php
    patching file circ/checkin_form.php
    Hunk #1 succeeded at 51 (offset 27 lines).
    patching file circ/checkout.php
    patching file circ/index.php
    patching file circ/mbr_history.php
    Hunk #1 succeeded at 35 (offset 27 lines).
    patching file circ/mbr_print_checkouts.php
    patching file circ/mbr_search.php
    patching file circ/mbr_view.php
    Hunk #1 succeeded at 41 (offset 29 lines).
    patching file circ/place_hold.php
    patching file circ/shelving_cart.php
    patching file navbars/circulation.php
    Hunk #1 FAILED at 7.
    1 out of 1 hunk FAILED -- saving rejects to file navbars/circulation.php.rej
    patching file classes/UpgradeQuery.php
    patching file install/0.6.0/sql/settings.sql

    ..now I get mysql errors:

    Database query failed

    Please give all the information on this page to your support personnel.

    Query update settings set library_name='GT Bibliothek', library_image_url='../images/sampleLogo.png', use_image_flg='Y', self_service_flg='Y', library_hours='M-F 8:00-21, Sa 12-17, So 13-17', library_phone='111-222-3333', library_url='', opac_url='../opac/index.php', session_timeout=20, items_per_page=10, purge_history_after_months=6, block_checkouts_when_fines_due='Y', hold_max_days=14, locale='de', charset='iso-8859-1', html_lang_attr='' failed. The DBMS said this:

    Unknown column 'self_service_flg' in 'field list'

    Debug Backtrace (most recent call first):

    /proryuyc/www.xyxyxy.eu/openbiblio/classes/Error.php:100 fatalhandler->printbacktrace()
    /proryuyc/www.xyxyxy.eu/openbiblio/classes/Error.php:68 fatalhandler->dberror('update settings set library_name=\'GT Bibliothek\', library_image_url=\'../images/sampleLogo.png\', use_image_flg=\'Y\', self_service_flg=\'Y\', library_hours=\'M-F 8:00-21, Sa 12-17, So 13-17\', library_phone=\'111-222-3333\', library_url=\'\', opac_url=\'../opac/index.php\', session_timeout=20, items_per_page=10, purge_history_after_months=6, block_checkouts_when_fines_due=\'Y\', hold_max_days=14, locale=\'de\', charset=\'iso-8859-1\', html_lang_attr=\'\' ', 'Database query failed', 'Unknown column \'self_service_flg\' in \'field list\'')
    /proryuyc/www.xyxyxy.eu/openbiblio/classes/Query.php:91 fatal::dberror('update settings set library_name=\'GT Bibliothek\', library_image_url=\'../images/sampleLogo.png\', use_image_flg=\'Y\', self_service_flg=\'Y\', library_hours=\'M-F 8:00-21, Sa 12-17, So 13-17\', library_phone=\'111-222-3333\', library_url=\'\', opac_url=\'../opac/index.php\', session_timeout=20, items_per_page=10, purge_history_after_months=6, block_checkouts_when_fines_due=\'Y\', hold_max_days=14, locale=\'de\', charset=\'iso-8859-1\', html_lang_attr=\'\' ', 'Database query failed', 'Unknown column \'self_service_flg\' in \'field list\'')
    /proryuyc/www.xyxyxy.eu/openbiblio/classes/Query.php:286 settingsquery->_act('update settings set library_name=\'GT Bibliothek\', library_image_url=\'../images/sampleLogo.png\', use_image_flg=\'Y\', self_service_flg=\'Y\', library_hours=\'M-F 8:00-21, Sa 12-17, So 13-17\', library_phone=\'111-222-3333\', library_url=\'\', opac_url=\'../opac/index.php\', session_timeout=20, items_per_page=10, purge_history_after_months=6, block_checkouts_when_fines_due=\'Y\', hold_max_days=14, locale=\'de\', charset=\'iso-8859-1\', html_lang_attr=\'\' ')
    /proryuyc/www.xyxyxy.eu/openbiblio/classes/SettingsQuery.php:107 settingsquery->_query('update settings set library_name=\'GT Bibliothek\', library_image_url=\'../images/sampleLogo.png\', use_image_flg=\'Y\', self_service_flg=\'Y\', library_hours=\'M-F 8:00-21, Sa 12-17, So 13-17\', library_phone=\'111-222-3333\', library_url=\'\', opac_url=\'../opac/index.php\', session_timeout=20, items_per_page=10, purge_history_after_months=6, block_checkouts_when_fines_due=\'Y\', hold_max_days=14, locale=\'de\', charset=\'iso-8859-1\', html_lang_attr=\'\' ', 'Fehler beim Speichern der Bibliothekseinstellungen!')
    /proryuyc/www.xyxyxy.eu/openbiblio/admin/settings_edit.php:78 settingsquery->update(class settings {
    var $_libraryName = 'GT Bibliothek';
    var $_libraryImageUrl = '../images/sampleLogo.png';
    var $_isUseImageSet = true;
    var $_isSelfServiceSet = true;
    var $_libraryHours = 'M-F 8:00-21, Sa 12-17, So 13-17';
    var $_libraryPhone = '111-222-3333';
    var $_libraryUrl = '';
    var $_opacUrl = '../opac/index.php';
    var $_sessionTimeout = '20';
    var $_sessionTimeoutError = '';
    var $_itemsPerPage = '10';
    var $_itemsPerPageError = '';
    var $_version = '';
    var $_themeid = 0;
    var $_purgeHistoryAfterMonths = '6';
    var $_purgeHistoryAfterMonthsError = '';
    var $_isBlockCheckoutsWhenFinesDue = true;
    var $_holdMaxDays = '14';
    var $_locale = 'de';
    var $_charset = 'iso-8859-1';
    var $_htmlLangAttr = '';
    })

    PLease, help!

    Kind regards, Orso

     
  • Orso
    Orso
    2008-10-08

    I get this error after ticking on "selfservice" and clicking "refresh" in biblio settings.

     
  • H.-J. Tappe
    H.-J. Tappe
    2008-11-09

    1. Your patch did not cleanly apply. Check navbars/circulation.php.rej for the rejected lines of code.

    2. Unknown column 'self_service_flg' in 'field list'
    Repeating the patch summary:
    Note that a new database table entry is neccessary in order to use this patch.
    This can be added via any mysql administration tool in a running system (like "use_image_flg").

     
  • I tried it again on a different system. I patched the openbiblio files and installed. Everything looks ok and is useable (search, adding books, etc.). When I click "update" in the library settings I get the error as mentioned in my previous posting.

    Does anybody has an idea how to solve this?

    Kind regards, Clemens

     
  • H.-J. Tappe
    H.-J. Tappe
    2009-02-11

    I uploaded a new zip file which patches the install routine of this patch.
    Try to first apply the patch and then run the database setup.

    Please try the new installation information (selfService.txt) in the updated patch. It explains that the openbiblio setup will have an additional setting ("Self Service"), which will need an additional entry in the database (this is what your problem is). To solve your problem, either try a fresh install after applying the patch OR in a production system, go to the database administration (e.g. phpmyadmin), go to the "settings" table and add the required "self_service_flg char(1) not null" table column.
    File Added: selfService.patch-0.6.X.zip

     
  • H.-J. Tappe
    H.-J. Tappe
    2009-02-11

    Self Service 0.6.X - install routine fixed

     
  • Hi Clemens!
    The updated patch will work (add the mysql table column) if you do a fresh database install (http://your.domain/openbiblio/install/) after applying the patch. NOTE that you must use the patch version uploaded 2009-02-11 in order to get it working with the install/ page.
    If your system is already in production mode, you will need to modify the database if you need to use this patch.
    The new table column is necessary in order to have the feature configurable.

     
  • Hi H.-J. Tappe!

    IT WORKS! Many thanky for your patience and this new version of the patch! It wasn't a problem to install it with the english language file. With the german language file there was an error. I installed it with the english language file and switched afterwards to german -> everything's okay!

    Thank you for this important improvement!

    Kind regards from Austria!

    Clemens

    orso %AT% gmx.at