- Koha - lists.katipo.co.nz

Koha-NA General Meeting - Thursay, Feburary 12th, 1pm EST
by Nick Clemens 12 Feb '15

12 Feb '15

Hi All, The next meeting of the Koha-NA group is tomorrow, Thursday, Feburary 12th at 1pm EST The link to join (via Blackboard) is: *https://sas.elluminate.com/site/external/jwsdetect/meeting.jnlp?sid=2011591&password=M.F770A6F4D9DD4C6E335EAAFED1332B <https://sas.elluminate.com/site/external/jwsdetect/meeting.jnlp?sid=2011591…>* First time participants on this platform will find this information helpful: http://support.blackboardcollaborate.com/ics/support/default.asp?deptID=833… Meeting info and notes from previous meetings can be found here: http://koha-na.org/index.php/Monthly_online_meetings To sign up for the KohaNA mailing list: http://lists.bywatersolutions.com/mailman/listinfo/kohana -- Nick Clemens Quechee & Wilder Libraries Nick(a)quecheelibrary.org http://www.QuecheeLibrary.org Q (802) 295-1232 W (802) 295-6341

1 0

Report help
by Nicole Engard 11 Feb '15

11 Feb '15

Hi all, I'm looking for a report to give the average age of the collection in a few item types. This report runs but isn't right: SELECT i.itype, avg(b.pubdate REGEXP '^[0-9]+$') as average FROM items i left join (select biblionumber, ExtractValue(marcxml, '//datafield[@tag="264"]/subfield[@code="c"]') as pubdate from biblioitems where ExtractValue(marcxml, '//datafield[@tag="264"]/subfield[@code="c"]') is not null and ExtractValue(marcxml, '//datafield[@tag="264"]/subfield[@code="c"]') != '' union all select biblionumber, copyrightdate as pubdate from biblio where copyrightdate is not null) b using (biblionumber) where i.itype in ('JBK','JPLUS') group by i.itype Also on large collections it takes too long to run so any more efficient suggestions are welcome - I am terrible at math :) Nicole

1 0

Koha 3.18 adding T-Prefix to all scanned barcodes
by bowmanrt 11 Feb '15

11 Feb '15

We have a library system which we migrated from Follett years ago. We left all of the old barcodes with the T-prefix, and use the barcode input filter which removes the T-prefix from our old barcode stickers. Lately, a different issue is occurring with checkout. Most of our barcode stickers have no T-prefix, but when scanned into the Checkout field a T-prefix appears. I'm not sure how Koha is adding the prefix. Is there a setting I'm missing? Thanks! Todd -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-3-18-adding-T-Prefix-to-all-scanned-… Sent from the Koha-general mailing list archive at Nabble.com.

2 2

Mixed Materials showing up as
by Heidi Addy 11 Feb '15

11 Feb '15

I am creating a number of records that are mixed materials. I select this "type of material" in the 008 field, but often these items are still showing up as 'books' in the OPAC. Any suggestions? Thanks, Heidi

3 2

Search shows nothing
by Jack Morash 11 Feb '15

11 Feb '15

Morning Everyone, Apparently ever since we converted to 3.18.03 the search hasn't been working. Just got the rebuild-zebra cron job running, we're slow because we are a private library, and now searches show nothing. Even searching for know items returns nothing. I saw this same/similar problem in the Koha Digest Vol. 111 issue 24, message 1, "Help Lost all Biblio information". I must have deleted issues 25 & 26 so I couldn't see the followups. I went through the trouble shooting listed there with these results. a. Search results. Always indicates nothing found with either title, call number, barcode, etc. Sometime would show items in Biblios Reservoir. b. Check out to Patron. Am able to check out to Patron with a known barcode. c. Counts for biblios, items, and biblioitems ok. The counts look likw what we have. d. Zebra Service running? If the Zebra service is part of the koha-common service, then yes. If not no. e. Fast Indexing running? Don't know as I do not know what to look for. If someone could tell me what to look for on item e, I will check. Did issues 25 & 26 have any resolutions for this?? Anything else I should be looking for?? We are running Koha 3.16.03 System is an Amazon EC2 linux Debian server. OS is Ubuntu Thank Jack

2 1

deleting koha-opac-error_log
by Mesfin Teshome 10 Feb '15

10 Feb '15

Dear all,The koha-opac-error_log file has grown very big 65GB and filling up the server harddisk. Can I delete this file and recreate a new empty one? What will be the effect? We are running Koha 3.12 Mesfin

2 2

slow processing
by Sandra Busutel 10 Feb '15

10 Feb '15

Hi It takes up to 6 seconds for our students to borrow but our staff borrowing takes upto 15-20 seconds per item. Can anyone suggest why this is so slow. Sandra Mrs Sandra Busutel Director of Information Services sbusutel(a)stpeters.nsw.edu.au <Email%3Asbusutel(a)stpeters.nsw.edu.au> -- 5 Howe Street, Campbelltown NSW 2560 *| *PO Box 997, Campbelltown NSW 2560 02 4627 2990 *| *administration(a)stpeters.nsw.edu.au *| * www.stpeters.nsw.edu.au Disclaimer: The contents of this email may be confidential and is intended for the addressee only. Any unauthorised use of the contents is prohibited. If you have received the document in error, please contact the sender by telephone immediately on 02 4627 2990 and then destroy the email. St. Peter's Anglican Primary School do not permit unauthorised use or copying of the email or its contents.

2 1

Re: [Koha] Patron Import via csv file (SATISH)
by Crago, Rebecca 10 Feb '15

10 Feb '15

The import csv must contain the attributes you wish to load in the patron record from the columns in the manual: http://manual.koha-community.org/3.16/en/tools.html#patronimport Column categorycode must match the categorycode corresponding to the patron attribute in http://manual.koha-community.org/3.16/en/patscirc.html#patcats. You must also match the branchcode if you have more than one library. Special attributes must match a corresponding column titled patron_attributes. In that column the attribute is listed with the CODE followed by a colon and then the value. Each attribute is separated by a comma. Example: patron_attributes ID:22222,GRAD:2015,CLASS:SENIOR Hope this helps. Rebecca Crago Systems and Teaching Librarian Mercyhurst University Erie, PA http://library.mercyhurst.edu ________________________________________ From: Koha [koha-bounces(a)lists.katipo.co.nz] on behalf of koha-request(a)lists.katipo.co.nz [koha-request(a)lists.katipo.co.nz] Sent: Monday, February 09, 2015 6:00 PM To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 112, Issue 19 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. slow processing (Sandra Busutel) 2. Re: Patron Import via csv file (SATISH) 3. Koha web installation page downloading (Admire Mutsikiwa) 4. Re: Testing to move a koha 3.08 system to 3.18, on Debian. (Howard Fleming) 5. Re: Koha web installation page downloading (Chris Cormack) ---------------------------------------------------------------------- Message: 1 Date: Mon, 9 Feb 2015 10:07:39 +1100 From: Sandra Busutel <sbusutel(a)stpeters.nsw.edu.au> To: koha(a)lists.katipo.co.nz Subject: [Koha] slow processing Message-ID: <CAPBObDrzZtm3uCfsHA2BWLUVB9WjbiBxdJozCLxQvcUak_FX0Q(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Hi It takes up to 6 seconds for our students to borrow but our staff borrowing takes upto 15-20 seconds per item. Can anyone suggest why this is so slow. Sandra Mrs Sandra Busutel Director of Information Services sbusutel(a)stpeters.nsw.edu.au <Email%3Asbusutel(a)stpeters.nsw.edu.au> -- 5 Howe Street, Campbelltown NSW 2560 *| *PO Box 997, Campbelltown NSW 2560 02 4627 2990 *| *administration(a)stpeters.nsw.edu.au *| * www.stpeters.nsw.edu.au Disclaimer: The contents of this email may be confidential and is intended for the addressee only. Any unauthorised use of the contents is prohibited. If you have received the document in error, please contact the sender by telephone immediately on 02 4627 2990 and then destroy the email. St. Peter's Anglican Primary School do not permit unauthorised use or copying of the email or its contents. ------------------------------ Message: 2 Date: Mon, 9 Feb 2015 11:24:22 +0530 From: SATISH <lis4satish(a)gmail.com> To: Sean Monaghen <smonaghen(a)usd259.net> Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Patron Import via csv file Message-ID: <CAJkM6UEkziF2YZAzr-+7U-nUa=fqAqiCB9-uEObKP+YRA9qdLg(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Hi Sean, You could copy and paste card number and patron's sir name, branch code, patron category, date enrolled, date expired, information from source file to patron_import.csv and when you try to open csv file with LibreOfficeCalc, cross check, the Separator Options ..Tab and Comma are not selected. So that, preview would be comma separated and if you do not have borrowernumber informaiton, you can delete that entire column in the csv file. with thanks, Satish Librarian GEC Hassan. Karnataka. On Thu, Feb 5, 2015 at 8:49 PM, Sean Monaghen <smonaghen(a)usd259.net> wrote: > I can not seem to import patrons even using the provided blank file and > adding one person to the file. Below is the output. Attached is the cvs > file I am trying to import. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > -- ------------------------------ Message: 3 Date: Mon, 9 Feb 2015 16:26:34 +0200 From: "Admire Mutsikiwa" <amutsikiwa(a)uzlib.uz.ac.zw> To: <koha(a)lists.katipo.co.nz> Subject: [Koha] Koha web installation page downloading Message-ID: <014501d04474$68552510$38ff6f30$(a)uzlib.uz.ac.zw> Content-Type: text/plain; charset="us-ascii" Hi I have installed Koha 3.18.03 on Ubuntu using the tarball. When I try to access the web-based page http://hostname:8080 , instead of presenting the web page, the page is downloading. I cannot figure out what the issue. Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263782476883 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp> ------------------------------ Message: 4 Date: Mon, 09 Feb 2015 11:44:18 -0500 From: Howard Fleming <hfleming(a)mei.edu> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Testing to move a koha 3.08 system to 3.18, on Debian. Message-ID: <54D8E3E2.5060402(a)mei.edu> Content-Type: text/plain; charset=utf-8; format=flowed Just a quick note to let you know your instructions on upgrading/moving the system seems to have fixed the problem I was running into, thanks! Howard On 02/03/2015 05:43 PM, Robin Sheat wrote: > Robin Sheat schreef op wo 04-02-2015 om 11:36 [+1300]: >> * Make sure you've reindexed everything: sudo koha-rebuild-zebra -f >> -v > And by that, I actually mean: > sudo koha-rebuild-zebra -f -v instancename > ------------------------------ Message: 5 Date: Tue, 10 Feb 2015 08:23:51 +1300 From: Chris Cormack <chrisc(a)catalyst.net.nz> To: Admire Mutsikiwa <amutsikiwa(a)uzlib.uz.ac.zw> Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Koha web installation page downloading Message-ID: <20150209192351.GE26338(a)rorohiko.wgtn.cat-it.co.nz> Content-Type: text/plain; charset=us-ascii * Admire Mutsikiwa (amutsikiwa(a)uzlib.uz.ac.zw) wrote: > Hi > > > > I have installed Koha 3.18.03 on Ubuntu using the tarball. When I try to > access the web-based page http://hostname:8080 , instead of presenting the > web page, the page is downloading. I cannot figure out what the issue. > > > Hi Admire Id recommend the packages on Ubuntu, but that is a separate thing, the fix for your issue is http://wiki.koha-community.org/wiki/Koha_on_Debian#Troubleshooting_Ubuntu_1… The third one there sudo a2enmod cgi sudo service apache2 restart Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand ------------------------------ Subject: Digest Footer _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ------------------------------ End of Koha Digest, Vol 112, Issue 19 *************************************

1 0

Koha web installation page downloading
by Admire Mutsikiwa 09 Feb '15

09 Feb '15

Hi I have installed Koha 3.18.03 on Ubuntu using the tarball. When I try to access the web-based page http://hostname:8080 , instead of presenting the web page, the page is downloading. I cannot figure out what the issue. Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263782476883 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>

2 1

Testing to move a koha 3.08 system to 3.18, on Debian.
by Howard Fleming 09 Feb '15

09 Feb '15

Good afternoon, I am working on moving our current koha 3.08 setup over to Debian 7.8 and koha 3.18. (I am also new to koha, so learning as I go....). The problem I am running into is once the data has been moved over to the new machine, and koha is up and running, everything appears to be working except for searches (you can search, but never get any hits). It looks like it could be a grs1 vs. dom issue, but not sure on this, and nothing that I have tried has resolved this problem (related to bug 13404?). Steps taken: Using http://wiki.koha-community.org/wiki/Debian as a guide, I got the new system up and running (Debian 7.8, koha 3.18). Using http://kohageek.pbworks.com/w/page/60452540/How%20to%20move%20your%20koha%2… and other sites for a guide setup did the following: In mysql, created a database with the same name as the current production system (kohadb). Imported the sql backup from the production system into mysql. Ran the command "koha-create --use-db kohadb. Ran "koha-upgrade-schema kohadb". Got the following output: Upgrading database schema for kohadb Upgrade to 3.09.00.001 done. (Bug 8002: Update patron attribute types table to allow NULL category_code) Upgrade to 3.09.00.002 done (Added cache_expiry and public fields in saved_reports table.) Upgrade to 3.09.00.003 done (Added SvcMaxReportRows syspref) Upgrade to 3.09.00.004 done (Adds permissions flag for access to the patron modifications tool) Upgrade to 3.09.00.005 done (Adding Quote of the Day Option.) Upgrade to 3.09.00.006 done (Changed system preference OPACDisplayRequestPriority -> OPACShowHoldQueueDetails) Upgrade to 3.09.00.007 done (Insert ReservesControlBranch systempreference into systempreferences table ) Upgrade to 3.09.00.008 done (redefine the field id as PRIMARY KEY of sessions) Upgrade to 3.09.00.009 done (redefine the field branchcode as PRIMARY KEY of branches) Upgrade to 3.09.00.010 done (Add system preference issuelostitem )) Upgrade to 3.09.00.011 done (Adding ean in biblioitems and deletedbiblioitems) DBD::mysql::db do failed: Duplicate entry 'SuspendHoldsIntranet' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5335. DBD::mysql::db do failed: Duplicate entry 'SuspendHoldsOpac' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5336. Upgrade to 3.09.00.012 done (Add system preference OpacBrowseResults )) Upgrade to 3.09.00.013 done (Add system preference DefaultLanguageField008)) Upgrade done (Support for Talking Tech i-tiva phone notification system) Upgrade to 3.09.00.015 done (Add System preference StatisticsFields) Upgrade to 3.09.00.016 done (Add syspref OPACShowBarcode) Upgrade to 3.09.00.017 done (Add customizable OpacNavRight region to the OPAC main page) Upgrade to 3.09.00.018 done (Add aqbudgetborrowers table) Upgrade to 3.09.00.019 done (Add OPACShowUnusedAuthorities system preference) Upgrade to 3.09.00.020 done (Added borrow_files table, EnableBorrowerFiles syspref) Upgrade to 3.09.00.021 done (Add syspref UpdateTotalIssuesOnCirc) Upgrade to 3.09.00.022 done (Change search_history.query_cgi type to text. bug 5981) Upgrade to 3.09.00.023 done (Add system preference SearchEngine ) Upgrade to 3.09.00.024 done (Add system preference IntranetSlipPrinterJS)) Upgrade to 3.09.00.025 done (add reserve_id to reserves & old_reserves tables) Upgrade to 3.09.00.026 done (Added parameters subpermissions) Upgrade to 3.09.00.027 done (Bug 7420 add overduefinescap to circulation matrix) Upgrade to 3.09.00.028 done (Add thesaurus links for MARC21/NORMARC) Upgrade to 3.09.00.029 done (Add itemBarcodeInputFilter choice EAN13) Upgrade to 3.09.00.029 done ( Added EAN13 barcode autogeneration sequence ) Upgrade to 3.09.00.030 done (BZ 8263: Make OPAC stylesheet preferences more consistent) Upgrade to 3.09.00.031 done ('Remove preferences controlling broken Amazon features (Bug 8679') Upgrade to 3.09.00.032 done (Bug 8657 - Default sort by call number does not work. Correcting system preference value.) Upgrade to 3.09.00.033 done (Add OpacSuppressionByIPRange syspref) Upgrade to 3.09.00.034 done (Bug 8207: correct typo in authority types) Upgrade to 3.09.00.035 done (Adding PrefillItem and SubfieldsToUseWhenPrefill sysprefs) Upgrade to 3.09.00.036 done (Add colum agerestriction to biblioitems and deletedbiblioitems, add system preferences AgeRestrictionMarker and AgeRestrictionOverride) Upgrade to 3.09.00.037 done (creating `transport_cost` table; adding UseTransportCostMatrix systempref, in circulation) Upgrade to 3.09.00.038 done (Increase the maximum size of a borrower attribute value) Upgrade to 3.09.00.039 done (Add system preference DidYouMeanFromAuthorities) Upgrade to 3.09.00.040 done (Add IncludeSeeFromInSearches system preference) Upgrade to 3.09.00.041 done (Add system preference ExportRemoveFields) Upgrade to 3.09.00.042 done (Adds New System preference ExportWithCsvProfile) Upgrade to 3.09.00.043 done (Adding parent_ordernumber in aqorders) Upgrade done ( Added Collection Code to Statistics table. ) Upgrade to 3.09.00.045 done. (Bug 8002: Update patron attribute types table from varchar(1) to varchar(10) category_code) Warning to Koha System Administrators: If you use borrower attributes defined by borrower categories, you have to check your configuration. A bug may have removed your attribute links to borrower categories. Please check, and fix it if necessary.Upgrade to 3.09.00.046 done (adding accountlines_id field in accountlines table) Upgrade to 3.09.00.047 done: adding AllowReturnToBranch syspref (bug 6151)Upgrade to 3.09.00.048 done (Raise the length of Authorised Values descriptions) Upgrade to 3.09.00.049 done (Add OPACMobileUserCSS, OpacMainUserBlockMobile, OpacShowLibrariesPulldownMobile and OpacShowFiltersPulldownMobile sysprefs) Upgrade to 3.09.00.050 done saved_sql new fields report_group and report_area; authorised_values.category 16 char Upgrade to 3.09.00.051 done (Add aqinvoices table) Upgrade to 3.09.00.052 done (Add systempreferences to decrease loan length on high demand items decreaseLoanHighHolds, decreaseLoanHighHoldsValue and decreaseLoanHighHoldsDuration) Upgrade to 3.09.00.053 done (Added support for staging authorities) Upgrade to 3.09.00.054 done (Change column name in aqorders gst --> gstrate) Upgrade to 3.09.00.055 done (Add discount field in aqorders table) Upgrade to 3.09.00.056 done (Add system preference AuthDisplayHierarchy) Upgrade to 3.09.00.057 done (Bug 5356: Added billingplace, deliveryplace to the aqbasket table) Upgrade to 3.09.00.058 done (Add Did You Mean? configuration) Upgrade to 3.09.00.059 done (Add system preference BlockReturnOfWithdrawnItems) Upgrade to 3.09.00.060 done (Added HoldsToPullStartDate syspref) Upgrade to 3.09.00.061 done (Fixes Bug 5409, Set the syspref value to 1 if it is itemdetails and 0 if it is statuses, leaving it alone if it is already 1 or 0 and change the type of the syspref to YesNo.) Upgrade to 3.09.00.062 done (Disable obsolete NoZebra and QueryRemoveStopwords sysprefs) Upgrade to 3.09.00.063 done (Bug 8832, Set the syspref gist with the existing values) Upgrade to 3.09.00.064 done (Bug 6428: Added coded_location_qualifier to the items table) Upgrade to 3.09.00.065 done (Bug 6428: Added coded_location_qualifier to the deleteditems table) Upgrade to 3.09.00.066 done (Bug 9107: remove DidYouMeanFromAuthorities syspref) Upgrade to 3.09.00.067 done (Bug 9064: statistics.ccode potentially wrongly defined) Upgrade to 3.10.00.00 done (release tag) Upgrade to 3.11.00.001 done (Bug 2832 - Add alphabet syspref) Upgrade to 3.11.00.002 done (Bug 9030: Add constraint on aqorders_items.ordernumber) Upgrade to 3.11.00.003 done (Bug 7189: Add system preference RefundLostItemFeeOnReturn) Upgrade to 3.11.00.004 done (Bug 8782: Add field subscription.closed) Upgrade to 3.11.00.005 done (Bug 7919: Display of values depending on the connexion library) Upgrade to 3.11.00.006 done (Bug 9167: Update the virtualshelves.sortfield column with 'copyrightdate' if needed) Upgrade to 3.11.00.007 done (Bug 9056: add German and a couple of French translations to language_descriptions) Upgrade to 3.11.00.008 done (Bug 7067: Add Patron Self Registration) Upgrade to 3.11.00.009 done (Bug 7674: Add systempreferences SeparateHoldings, SeparateHoldingsBranch, OpacSeparateHoldings and OpacSeparateHoldingsBranch) Upgrade to 3.11.00.010 done (Bug 9151 - Renewal notice according to patron alert preferences) Upgrade to 3.11.00.011 done (Bug 8377: Add HTML5MediaEnabled and HTML5MediaExtensions sysprefs) Upgrade to 3.11.00.012 done (Bug 9206: Only allow place holds in records that the patron don't have in his possession) Upgrade to 3.11.00.013 done (Bug 9162 - Add a system preference to set which notes fields appears on title notes/description separator) Upgrade to 3.11.00.014 done (Bug 9009: Add SCOUserCSS and SCOUserJS sysprefs) Upgrade to 3.11.00.015 done (Add sysprefs RentalsInNoissuesCharge and ManInvInNoissuesCharge.) Upgrade to 3.11.00.016 done (Bug 9382 (updated with bug 9745) - refresh permission descriptions to make more sense) Upgrade to 3.11.00.017 done (Add IDreamBooks enhanced content) Upgrade to 3.11.00.018 done (Bug 9395: Problem with callnumber and standard number search in OPAC and Staff Client) Upgrade to 3.11.00.019 done (Bug 9145 - Add syspref UNIMARCAuthorityField100) Upgrade to 3.11.00.020 done (Bug 8347 - Koha forces UNIMARC 100 field code language to 'fre') Upgrade to 3.11.00.021 done (Bug 5888 - Subject search pop-up for the OPAC) Upgrade to 3.11.00.022 done (Bug 9587 - Allow login via Persona) Upgrade to 3.11.00.023 done (Bug 9520 - Update default LOC Z39.50 target) Upgrade to 3.11.00.024 done (Bug 5079: Add OpacItemLocation syspref) Upgrade to 3.11.00.025 done (Adds feature Bug 8917, the ability to track links clicked) Upgrade to 3.11.00.026 done (Bug 9207: Add new index batch_id_record_type to import_records) Upgrade to 3.11.00.027 done ( Add circ permission overdues_report ) Upgrade to 3.11.00.028 done (Bug 9756 - Patron self registration missing the system preference PatronSelfRegistrationAdditionalInstructions) Upgrade to 3.11.00.029 done (Bug 9239: Make it possible for Koha to use QueryParser) Upgrade to 3.11.00.030 done (Add system preference FinesIncludeGracePeriod) Upgrade to 3.11.00.100 done (3.12-alpha release) Upgrade to 3.11.00.101 done (Bug 9341: Problem with UNIMARC authors facets) Upgrade to 3.11.00.102 done (Remove deprecated NoZebra and QueryRemoveStopwords sysprefs) Upgrade to 3.11.00.103 done (Bug 9827 - Remove 'insecure' system preference) Upgrade to 3.11.00.104 done (3.12-alpha2 release) Upgrade to 3.11.00.105 done (Bug 9353: Missing subfields on MARC21 frameworks) Upgrade to 3.11.00.106 done (Bug 7804: Added plugin system.) Upgrade to 3.11.00.107 done (Bug 9014: Add syspref TimeFormat) Upgrade to 3.11.00.108 done (Bug 7241: Fix on circulation logs) WARNING about bug 7241: to partially correct the broken logs, the log history is filled with the first found item for each biblio. Upgrade to 3.11.00.109 done (Bug 9403: Add DisplayIconsXSLT) Upgrade to 3.11.00.110 done (Bug 8220 - Allow koc uploads to go to process queue) Upgrade to 3.11.00.111 done (use new <<items.fine>> syntax in notices) Upgrade to 3.11.00.112 done (Bug 8365: Add colum issuingrules.renewalperiod) Upgrade to 3.11.00.113 done (Bug 9257 - Add groups to normal search pulldown) Upgrade to 3.11.00.115 done (Bug 7740: Add syspref HighlightOwnItemsOnOPAC) Upgrade to 3.11.00.116 done (Bug 5343: table aqorders: DROP serialid and subscription fields and ADD subscriptionid, table subscription: ADD reneweddate) Upgrade to 3.11.00.200 done (3.12-beta1 release) Upgrade to 3.11.00.201 done (Bug 9498 - Update encoding for Norwegian sample Z39.50 servers) Upgrade to 3.11.00.202 done (Bug 9381: Add Catalan laguage) Upgrade to 3.11.00.203 done (Bug 2046 - increasing title column length for suggestions) Upgrade to 3.11.00.300 done (3.12-beta3 release) Upgrade to 3.11.00.301 done (Bug 9681: Add some database indexes) Upgrade to 3.12.00.000 done (3.12.0 release) Upgrade to 3.13.00.000 done (start the journey to Koha Pi) Upgrade to 3.13.00.001 done (Add Course Reserves ( system preference UseCourseReserves )) Upgrade to 3.13.00.002 done (Bug 10080 - Change system pref IndependantBranches to IndependentBranches) Upgrade to 3.13.00.003 done (Bug 7718 - Remove itemnumber column from serials table) Upgrade to 3.13.00.004 done (Bug 9722: Allow users to add notes when placing a hold in OPAC) Upgrade to 3.13.00.005 done (Bug 10052: Make intranetstylesheet and intranetcolorstylesheet behave exactly like their opac counterparts) Upgrade to 3.13.00.006 done (Bug 10120 - Fines on item return controlled by a systempreference) Upgrade to 3.13.00.007 done (Bug 10343: Rename OpacShowHoldNotes to OpacHoldNotes) Upgrade to 3.13.00.008 done (Bug 10443: make sure borrower_files table exists) Upgrade to 3.13.00.009 done (Bug 9987 - Drop column aqorders.biblioitemnumber) Upgrade to 3.13.00.010 done (Bug 10366 - Add system preference to enabling warning librarian when invoice is duplicated) Upgrade to 3.13.00.011 done (Bug 9519: Wrong language code for Italian in the advanced search language limitations) Upgrade to 3.13.00.012 done (Bug 10490: Correct datatype for overduefinescap in issuingrules) Upgrade to 3.13.00.013 done (Bug 9576: add AllowTooManyOverride syspref to enable or disable issue limit confirmation) Upgrade to 3.13.00.014 done (Bug 10604: correct width of courses.department and courses.term) Upgrade to 3.13.00.015 done (Bug 7494: Add itemBarcodeFallbackSearch syspref) Upgrade to 3.13.00.016 done (Bug 10550 - Fix database typo wthdrawn) Upgrade to 3.13.00.017 done (Bug 10320 - Show results from library's OverDrive collection in OPAC search) Upgrade to 3.13.00.018 done (Bug 5349: Add aqorders_transfers table) Upgrade to 3.13.00.019 done (Bug 10513 - Light up a warning/message when returning a chosen item type) Upgrade to 3.13.00.020 done (Bug 7639: system preferences to forgive fines on lost items) Upgrade to 3.13.00.021 done (Bug 9761: Add ConfirmFutureHolds pref) Upgrade to 3.13.00.022 done (Bug 10687 - Delete erroneous tags 68a and 68b on default MARC21 auth framework) Upgrade to 3.13.00.023 done (Bug 9611 upgrading password storage system) Upgrade to 3.13.00.024 done (Bug 10096 - Add a Z39.50 interface for authority searching) Upgrade to 3.13.00.025 done (Bug 9295: OAI notequal: add operator column to OAI mappings table) Upgrade to 3.13.00.026 done (Bug 10602: Add the column auth_subfield_structure.defaultvalue) Upgrade to 3.13.00.027 done (Bug 10240: Add syspref AllowOfflineCirculation) Upgrade to 3.13.00.028 done (Bug 10853: Add new field export_format.type and rename export_format.marcfields with export_format.content) Upgrade to 3.13.00.029 done (Bug 10854: Add the default CSV profile for claiming issues) Upgrade to 3.13.00.030 done (Bug 10636 - patronimage should have borrowernumber as PK, not cardnumber) Upgrade to 3.13.00.031 done (Bug 10565 - Add a 'Patron List' feature for storing and manipulating collections of patrons) Upgrade to 3.13.00.032 done (Bug 5336: Add the new column aqorders.orderstatus) Upgrade to 3.13.00.033 done (Bug 7688: add subscription_frequencies and subscription_numberpatterns tables) Upgrade to 3.13.00.034 done (Bug 7131 - way to overlay items in in marc import) Upgrade to 3.13.00.035 done (Bug 2720 - Overdues which debar automatically should undebar automatically when returned) Upgrade to 3.13.00.036 done (Add system preference StaffDetailItemSelection) Upgrade to 3.13.00.037 done (Bug 10572: Add phone to message_transport_types table for new installs) Upgrade to 3.13.00.038 done (Bug 8435: Add superserials permission) Upgrade to 3.13.00.039 done (Add branch and users list to baskets. New permission order_manage_all) Upgrade to 3.13.00.040 done ( Bug 8015: Added tables for MARC Modification Framework ) Upgrade to 3.13.00.041 done (Bug 10986: Added AcqItemSetSubfieldsWhenReceived syspref) Upgrade to 3.13.00.042 done (Koha 3.14 beta) Upgrade to 3.13.00.043 done (Bug 11196: Add system preference SearchEngine if missing ) Upgrade to 3.14.00.000 done (3.14.0 release) Upgrade to 3.15.00.000 done (the road goes ever on) Upgrade to 3.15.00.001 done (Bug 11040: Add option to print full slip when checking out a null barcode) Upgrade to 3.15.00.002 done (Bug 11275: alter deleteditems.materials from varchar(10) to text) Upgrade to 3.15.00.003 done (Bug 2546: Update fine descriptions) Upgrade to 3.15.00.004 done (Bug 10970 - Update MARC21 frameworks to Update Nr. 17 - DB update) Upgrade to 3.15.00.005 done (Bug 8230: Add AcquisitionDetails system preference) Upgrade to 3.15.00.006 done (Bug 11249 - Add DB indexes on borrower names) Upgrade to 3.15.00.007 done (Bug 9673 - Track when items are marked as lost or withdrawn) Upgrade to 3.15.00.008 done (Bug 11384) - change name of collections_tracker.ctId column) Upgrade to 3.15.00.009 done (Bug 11391) - drop default value on suggestions.suggesteddate column) Upgrade to 3.15.00.010 done (Bug 6331: remove obsolete column in deleteditems.marc) Upgrade to 3.15.00.011 done (Bug 8018: set 9999 as default max length for subfields) Upgrade to 3.15.00.012 done (Bug 10863 - Add permissions force_checkout and manage_restrictions) Upgrade to 3.15.00.013 done (Bug 11237: Update explanation and default value for AcqItemSetSubfieldsWhenReceived syspref) Upgrade to 3.15.00.014 done (Bug 11415: add system preference for automatic self checkout receipt printing) Upgrade to 3.15.00.015 done (Bug 10907: Add OpacSuggestionManagedBy system preference) Upgrade to 3.15.00.016 done (Bug 11268 - Biblioitems URL field is too small for some URLs) Upgrade to 3.15.00.017 done (Bug 11611 - fix possible confusion between UNIMARC and MARC21 in some sysprefs) Upgrade to 3.15.00.018 done (Bug 7372: Move road types from the roadtype table to the ROADTYPE authorised values) Upgrade to 3.15.00.019 done (Bug 11256: Add system preference OpacMaxItemsToDisplay) Upgrade to 3.15.00.020 done (Bug 11343: Add system preference MaxItemsForBatch ) Upgrade to 3.15.00.021 done (Bug 3445: Add indexes to action_logs table) Upgrade to 3.15.00.022 done (Bug 11751: Remove memberofinstitytion system preference) Upgrade to 3.15.00.023 done (Bug 10861: Add CardnumberLength syspref) Upgrade to 3.15.00.024 done (Bug 10012 - remove last vestiges of NoZebra) Upgrade to 3.15.00.025 done (Bug 11928 - remove unused table) Upgrade to 3.15.00.026 done (Bug 11973 - Fix Armenian language description) Upgrade to 3.15.00.027 done (Bug 7567: Add branchcode to opac_news) Upgrade to 3.15.00.028 done (Bug 7413: Allow OPAC renewal x days before due date) Upgrade to 3.15.00.029 done (Bug 11846 - correct borrower_debarments with expiration 9999-12-31) Upgrade to 3.15.00.030 done (Bug 12052: Add OPACMySummaryNote syspref) Upgrade to 3.15.00.031 done (Bug 9448 - Add separate permission for writing off fees) Upgrade to 3.15.00.032 done (Bug 9416 - In each order, add a new note made for the vendor) Upgrade to 3.15.00.033 done (Bug 10951: Add NoLoginInstructions pref) Upgrade to 3.15.00.034 done (Bug 10986: system preferences to limit languages in advanced search ) Upgrade to 3.15.00.035 done (Bug 9032: Share a list) Upgrade to 3.15.00.036 done (Bug 10859 - Add system preference AllowMultipleIssuesOnABiblio) Upgrade to 3.15.00.037 done (Bug 11351 - Add support for SIP2 media type) Upgrade to 3.15.00.038 done (Bug 11334 - Add facet for home library) Upgrade done (Bug 9016: Adds multi transport types management for notices) Upgrade to 3.15.00.040 done (Bug 10845: Multi transport types for holds) Upgrade to 3.15.00.041 done (Bug 11867: Update letters *_PHONE) Upgrade to 3.15.00.042 done (Bug 10694 - Allow arbitrary backdating of returns) Upgrade to 3.15.00.043 done (Bug 7180: Added MarcFieldsToOrder syspref) Upgrade to 3.15.00.044 done (Added isocode to the currency table) Upgraded to 3.15.00.045 done (Bug 6739 - expired patrons not blocked from opac actions) Upgrade to 3.15.00.046 done (Bug 10807 - Add db field search_history.type) Upgrade to 3.15.00.047 done (Bug 10862: Add EnableSearchHistory syspref) Upgrade to 3.15.00.048 done (Bug 10195: Records hidden with OpacSuppression can still be accessed) Upgrade to 3.15.00.049 done (Bug 5377 - Biblioitems isbn and issn fields too small for multiple ISBN and ISSN) Upgrade to 3.15.00.050 done (Bug 10500 - Improve isbn matching when importing records) Upgrade to 3.15.00.051 done (Koha 3.16 beta) Upgrade to 3.15.00.052 done (Koha 3.16 RC) Upgrade to 3.16.00.000 done (3.16.0 release) Upgrade to 3.17.00.000 done (there is no time to rest on our laurels) Upgrade to 3.17.00.001 done (Bug 10330 - Rename system preference authoritysep to AuthoritySeparator) Upgrade to 3.17.00.002 done (Bug 3050 - Add an option to upload scanned invoices) Upgrade to 3.17.00.003 done (Bug 7825 - Changed OPACItemHolds syspref to Choice) Upgrade to 3.17.00.004 done (Bug 6254 - can't set patron privacy by default) Upgrade to 3.17.00.005 done (Bug 12230: Add new issuing rule maxsuspensiondays) Upgrade to 3.17.00.006 done (Bug 7720 - Ambiguity in OPAC Details location.) Upgrade to 3.17.00.007 done (Bug 11629 - Add ability to update not for loan status on checkin) Upgrade to 3.17.00.008 done (Bug 11169 - Add OPACAcquisitionDetails syspref) Upgrade to 3.17.00.009 done (Bug 11703 - Remove UseTablesortForCirc syspref) Upgrade to 3.17.00.010 done (Bug 11347 - PROG/CCSR deprecation: Remove opacsmallimage system preference) Upgrade to 3.17.00.011 done (Bug 12649: Add Croatian language) Upgrade to 3.17.00.012 done ( Bug 12512 - PROG/CCSR deprecation: Remove OpacShowFiltersPulldownMobile system preference ) Upgrade to 3.17.00.013 done (Re-add system preference maxreserves) Upgrade to 3.17.00.014 done (Bug 12529 - Adding a syspref to allow the overdue notices to consider the calendar when generating notices) Upgrade to 3.17.00.015 done (Bug 10212 - Create new table columns_settings) Upgrade to 3.17.00.016 done (Bug 10402: Move bookseller contacts to separate table) Upgrade to 3.17.00.017 done (Bug 6536: Z3950 improvements) Upgrade to 3.17.00.018 done (Bug 12205: Add HoldsInNoissuesCharge systempreference) Upgrade to 3.17.00.019 done (Bug 6149: Operator highlighted in search results) Upgrade to 3.17.00.020 done (Bug 8735 - Expire holds waiting only on days the library is open) Upgrade to 3.17.00.021 done (Bug 12582 - Control of branch displayed in search results linked to HomeOrHoldingBranch) Upgrade to 3.17.00.022 done (Bug 7817: Check for permanent_location) Upgrade to 3.17.00.023 done (Bug 11169 - Add AcqItemSetSubfieldsWhenReceiptIsCancelled syspref) Upgrade to 3.17.00.024 done (Bug 11577: [ENH] Automatic renewal feature) Upgrade to 3.17.00.025 done (Bug 12728: Checked syspref StatisticsFields) Upgrade to 3.17.00.026 done (Bug 12435 - Update MARC21 frameworks to Update No. 18 (April 2014)) Upgrade to 3.17.00.027 done (Bug 12538 - Remove SearchEngine syspref) Upgrade to 3.17.00.028 done (Bug 12296 - search box replaceable with a system preference) Upgrade to 3.17.00.029 done (Bug 12424 - ddc sorting of call numbers truncates long Cutter parts) Upgrade to 3.17.00.030 done (Bug 11926: Add UsageStats systempreferences (HEA)) Upgrade to 3.17.00.031 done (Bug 2969: Report Name should be mandatory for saved reports) Upgrade to 3.17.00.032 done (Bug 9530: Adding replyto and returnpath addresses.) Upgrade to 3.17.00.033 done (Bug 13088 - Allow the user to specify a max amount of facets to show) Upgrade to 3.17.00.034 done (Bug 11007 - DROP column aqorders.cancelledby) Upgrade to 3.17.00.035 done (Bug 5342: Add claims_count field in serial table) Upgrade to 3.17.00.036 done ( Bug 12513 - PROG/CCSR deprecation: Remove OpacShowLibrariesPulldownMobile system preference ) Upgrade to 3.17.00.037 done ( Bug 12246 - PROG/CCSR deprecation: Remove OpacMainUserBlockMobile system preference ) Upgrade to 3.17.00.038 done ( Bug 12245 - PROG/CCSR deprecation: Remove OPACMobileUserCSS system preference ) Upgrade to 3.17.00.039 done (Bug 12539 - PROG/CCSR deprecation: Remove hardcoded theme from C4/Templates.pm) Upgrade to 3.17.00.040 done (Bug 12223: 'prog' and 'ccsr' themes removed) Upgrade to 3.17.00.041 done (Bug 11346: Deprecate the 'prog' and 'CCSR' themes) Upgrade to 3.17.00.042 done (Bug 12494: Remove yuipath system preference) Upgrade to 3.17.00.043 done (Bug 7162: Add aqorders.cancellationreason) Upgrade to 3.17.00.044 done (Bug 10860: Add new system preference OnSiteCheckouts + fields [old_]issues.onsite_checkout) Upgrade to 3.17.00.045 done (Bug 11126 - Make the holds system optionally give precedence to local holds) Upgrade to 3.17.00.046 done (Bug 11425: Add items_search_fields table) Upgrade to 3.17.00.047 done (Bug 8836 - Resurrect Rotating Collections) Upgrade to 3.17.00.048 done (Bug 12448 - Add RentalFeesCheckoutConfirmation syspref) Upgrade to 3.17.00.049 done (Bug 12250: Update descriptions for languages, scripts and regions) Upgrade to 3.17.00.050 done (Bug 12403: Add permission tools_records_batchdelitem) Upgrade to 3.17.00.051 done (Bug 13211: Added system preferences GoogleIndicTransliteration on the OPAC) Upgrade to 3.17.00.052 done (Bug 9043: Add system preference OpacAdvSearchOptions and OpacAdvSearchMoreOptions) Upgrade to 3.17.00.053 done (Bug 7673: Adds 2 new prefs (SubfieldsToAllowForRestrictedEditing and SubfieldsToAllowForRestrictedBatchmod) and 3 new permissions (edit_items_restricted and delete_all_items and items_batchmod_restricted)) Upgrade to 3.17.00.054 done (Bug 11634 - Allow renewal of item with unfilled holds if other available items can fill those holds) Upgrade to 3.17.00.055 done (Bug 11401 - Add support for Norwegian national library card) Upgrade to 3.17.00.056 done (Bug 9043 - Update the values for OpacAdvSearchOptions and OpacAdvSearchOptions) Upgrade to 3.17.00.057 done (Koha 3.18 beta) Upgrade to 3.17.00.058 done (Bug 8337: System preferences for longoverdue cron) Upgrade to 3.17.00.059 done (Bug 10749: Fix typo in budget_add_del permission description) Upgrade to 3.17.00.060 done (Bug 12298: Delete the 'feed' message transport type (deleted!)) Upgrade to 3.18.00.000 done (3.18.0 release) Upgrade to 3.18.01.000 done (3.18.1 release) Upgrade to 3.18.02.000 done (3.18.2 release) Upgrade to 3.18.02.001 done (Bug 13436: Add more options to UsageStatsLibraryType) upgrade to 3.18.02.002 done (Bug 10753: replace __ANY__ with empty string in suggestions.branchcode) Upgrade to 3.18.02.003 done (Bug 1861 - Unique patrons logins not (totally) enforced) Upgrade to 3.18.03.000 done (3.18.3 release) I am able to login into the koha site ok, but as mentioned earlier, the search function is not working (never finds anything). Thanks, Howard Howard Fleming hfleming(a)mei.edu

2 3