- Koha-devel - lists.koha-community.org

UUIDs?
by Tomas Cohen Arazi 24 May '17

24 May '17

Has anyone considered the option to use UUIDs for our PK? I'm pretty sure DBIx::Class supports them. I'm not sure how SQL::Abstract handles them, but I know MySQL provides the uuid() function. This way we could get rid of this auto increment problem... and get new ones of course :-P I'm just wondering if there's been any discussion about that. Regards -- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F

2 1

REMINDER: Koha IRC Developers Meeting - Tomorrow, May 24th, 14 UTC
by Nick Clemens 23 May '17

23 May '17

Hello Koha community! Just a reminder that tomorrow is our next devel meeting in IRC. https://koha-community.org/get-involved/irc/ Time & Date: 24 May 2017, 14:00 UTC Time and Date.com converter for various local times <https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+Developers+I…> Agenda: https://wiki.koha-community.org/wiki/Development_IRC_meeting_24_May_2017 Please add anything you wish to discuss. Look forward to seeing you all there. -Nick

1 0

Adding new authority types
by Tomas Cohen Arazi 22 May '17

22 May '17

Hi, bug 17805 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17805> proposes to add a new authority type, and I was wondering what has been the normal handling for this, specially regarding the upgrade process. Should it be added automatically? Regards -- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F

3 2

Koha 3.22.21 release
by Julian Maurice 22 May '17

22 May '17

The Koha community is proud to announce the release of Koha 3.22.21. This is a maintenance release and contains several bugfixes. The full release notes are available at https://koha-community.org/koha-3-22-21-release/ Please note that Koha version 3.22 won't be maintained anymore and this is the last 3.22 release. If you are still using it, you should consider upgrading to a more recent version.

2 2

marcxml > biblio_metadata - Automatically convert reports
by Jonathan Druart 22 May '17

22 May '17

Hi guys, It seems like my calls did not get the expected attention, so I am trying once again. Bug 17196 (Move marcxml out of the biblioitems table) has been pushed to master a while ago and 17.05 will be the first release with this change. I wrote bug 17898 (Add a way to automatically convert SQL reports) 4 months ago asking for a special attention: librarians will need it to update easily their reports. Since 17.05 is going to be released in a week and we are in string freeze, I guess there is no way to get it in. But I personally think that we should make an exception for this one. Please do not let this request without answer once again. Cheers, Jonathan

3 2

Koha 16.11.08 released
by Katrin 22 May '17

22 May '17

The Koha community is proud to announce the release of Koha 16.11.08. This is a maintenance release of 16.11 and includes 5 enhancements and 50 bugfixes. The full release notes are available at https://koha-community.org/koha-16-11-08-release/ Packages will be available soon.

2 1

Koha 17.05 Release Notes - Draft 2 + Beta
by Kyle Hall 19 May '17

19 May '17

Hey all, Here is the second version of the Release Notes and the beta! The release notes have the same issues as before. I'll fix the character encodings by hand in the final release. https://github.com/kylemhall/Koha/blob/v17.05.00_RC1/misc/release_notes/rel… I've included the tarball in the repo rather than muck up the ftp server with it: https://github.com/kylemhall/Koha/tree/v17.05.00_RC1/releases Kyle http://www.kylehall.info ByWater Solutions ( http://bywatersolutions.com ) Meadville Public Library ( http://www.meadvillelibrary.org ) Crawford County Federated Library System ( http://www.ccfls.org )

1 0

Re: [Koha-devel] [ByWater Partners] Acquisitions change in Koha 16.11 and forward
by Nick Clemens 19 May '17

19 May '17

Hi Sandre, The current replacement/rrp field is used for two things: 1 - passing through from the orders as the items.replacementprice field 2 - the basis for calculating prices (minus discount, plus tax, etc) Splitting the replacement cost out will allow proper discount/tax calculation while allowing manual edit to the replacement cost to add fees etc. I believe our proposal works for your workflow. -Nick On Tue, May 16, 2017 at 5:40 PM Sandre Cunha <cunha(a)monterey.org> wrote: > Before you add yet another price field to acquisitions, I would like to > understand the intended function of the "replacement/rrp" field. > > I realize that not all libraries operate the same and that they have a > variety of needs and restraints. For Monterey Public Library, the only > reason to even have replacement cost in the order screen is to streamline > processing when the item gets to cataloging, i.e., so they don't have to > enter it. > For us, the replacement cost is the price we charge the customer if they > lose or damage the item. Is this the intended purpose of this field? > > Our replacement cost used to be the list price plus $10 for processing, > but never included tax. > > Example 1: > Retail price: $27.99 Actual cost: $15.34 Sales tax:$1.34 In this > scenario, the replacement price = $37.99 [27.99 + $10.00 processing] > > Now, we use our actual cost [the price discounted from retail]; the only > time it is different is when the cost is less than our maximum fine, in > which case the maximum fine fee becomes the replacement price. > > Example 2: > Retail price: $27.99 Actual cost: $15.34 Sales tax: $1.34 > Replacement price = $15.34 > > Example 3: > > Retail price: $18.00 Actual cost: $9.86 Sales tax: $0.83 Replacement > price: $10.00 [our maximum late fine for this collection is $10.00, which > is more than 9.86] > > Other drawbacks to the new way "replacement/rrp" is handled: when you need > to create an order for which the cost is $0 (gift, credit allocation, or > pre-order for next fiscal year) but you want to have a replacement cost > recorded. > > Additionally, please note that we do not enter discounts in our vendor > records, as even with our largest two vendors the discount varies depending > on the type of material and source. With one vendor our contract specifies > a 42% discount for many items, but for some we get less, some no discount, > and every once in a while we pay more than retail due to a surcharge. > > I would be interested to know the methods acquisitions staff at other > libraries use. It would be useful to have a better understanding of usage > and needs before adding yet another field to the order details. > > ________________________ > Sandre Cunha > Technical Services Supervisor > Monterey Public Library > 625 Pacific Street > Monterey, CA 93940 > Tel. 831-646-3740 <(831)%20646-3740> > > “If you want to build a ship, don’t drum up your men to collect wood and > give orders and distribute the work. Instead, teach them to yearn for the > vast and endless sea." -- Antoine de Saint-Exupéry > > On Tue, May 9, 2017 at 1:44 PM, Nick Clemens <nick(a)bywatersolutions.com> > wrote: > >> Hello All, >> >> With the current versions of Koha there have been some changes in >> acquisitions and how prices are calculated and there seems to be some >> confusion in terms and how things are currently being used. >> >> We wanted to clarify what is happening, propose a change and get feedback >> on what needs to happen. >> >> When placing an order there are several price fields: >> Vendor price (listprice in db) >> -This is used to populate the Replacement cost and budgeted cost on the >> order page. It is not used against the budget >> >> Replacement cost (rrp in db) >> -This is used to calculate the 'budgeted cost/ecost' in the budget - it >> also populates the replacement price in the item created by the aqc process >> once received >> >> Budgeted cost (ecost in db) >> -This is the replacement/rpp minus any discount on the order - this is >> the value that will be encumbered when the order is placed >> >> Actual cost (unitprice) >> -This is the eventual 'price' of the item and is the encumbered amount >> once the item has been received. >> >> With the changes that were made one can no longer adjust the >> 'Replacement/RRP' once an order is placed - this is because this value is >> adjusted for tax in the db (rrp_tax_excluded, rrp_tax_included) and used >> for calculating the ecost tax adjusted (ecost_tax_excluded, >> ecost_tax_included) >> >> Some libraries have been having issues as they use 'Replacement' cost >> mostly for populating items and are not used to it being unable to be >> edited and/or affecting budgets. >> >> We are proposing to rename the current 'Replacement cost' field to match >> the db value - 'Recommended retail price' (RRP) and add a new 'Replacement >> cost' field, editable at any point, that is only used for populating the >> item field. >> >> We think this will clear up how the other values are being used and >> restore functionality that changed. >> >> Please let us know if this works or what other suggestions you have here. >> >> Thank you, >> Nick, Kyle, Jonathan >> >> _______________________________________________ >> Partners mailing list >> Partners(a)lists.bywatersolutions.com >> http://lists.bywatersolutions.com/mailman/listinfo/partners >> >>

1 0

Koha 17.05 Release Notes - Draft One ( 2nd attempt ; )
by Kyle Hall 18 May '17

18 May '17

I think my first attempt may be caught in mailing list moderation, so here is a link to the markdown version available on GitHub: https://github.com/kylemhall/Koha/blob/bc497cd58a874c4c10f214e7c2a8d5b35aa4… Kyle http://www.kylehall.info ByWater Solutions ( http://bywatersolutions.com ) Meadville Public Library ( http://www.meadvillelibrary.org ) Crawford County Federated Library System ( http://www.ccfls.org )

5 6

Koha 17.05 Dates
by Kyle Hall 17 May '17

17 May '17

Here is my planned timeline for the Koha 17.05 release: May 5 - Feature Slush May 12 - 1st Draft of Release Notes May 19 - Feature Freeze, Release Beta, 2nd Draft of Release Notes May 26th - Final Release If anyone sees a need to modify this timeline, please let me know! Kyle http://www.kylehall.info ByWater Solutions ( http://bywatersolutions.com ) Meadville Public Library ( http://www.meadvillelibrary.org ) Crawford County Federated Library System ( http://www.ccfls.org )

4 6