August 2017 - Koha-bugs - lists.koha-community.org

[Bug 18048] New: Add index on biblioitems.ean
by bugzilla-daemon＠bugs.koha-community.org 17 Aug '17

17 Aug '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18048 Bug ID: 18048 Summary: Add index on biblioitems.ean Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: gmcharlt(a)gmail.com Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org In big databases querying on the EAN can take a while, it would be nice to have an index on this column as we have on other columns with standard numbers in this table already: 196 PRIMARY KEY (`biblioitemnumber`), 197 KEY `bibinoidx` (`biblioitemnumber`), 198 KEY `bibnoidx` (`biblionumber`), 199 KEY `itemtype_idx` (`itemtype`), 200 KEY `isbn` (`isbn`(255)), 201 KEY `issn` (`issn`(255)), 202 KEY `publishercode` (`publishercode`), -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 13766] Make biblioitems.ean longer and add index
by bugzilla-daemon＠bugs.koha-community.org 17 Aug '17

17 Aug '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13766 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|biblioitems.ean field is |Make biblioitems.ean longer |too short |and add index -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13766] biblioitems.ean field is too short
by bugzilla-daemon＠bugs.koha-community.org 17 Aug '17

17 Aug '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13766 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|trivial |minor Assignee|frederic(a)tamil.fr |katrin.fischer(a)bsz-bw.de CC| |katrin.fischer(a)bsz-bw.de --- Comment #8 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- Hi Frederic, I hope it's ok that I adopt this bug. I was not sure how best to do a follow up on yours with the need to also move the changes to an atomicupdate, so I have written a new patch from scratch. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13766] biblioitems.ean field is too short
by bugzilla-daemon＠bugs.koha-community.org 17 Aug '17

17 Aug '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13766 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #36251|0 |1 is obsolete| | --- Comment #7 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- Created attachment 66146 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66146&action=ed… Bug 13766 - Change *bibioitems.ean to mediumtext and add indexes - biblioitems.ean and deleteditems.ean are changed to mediumtext to match issn and isbn. - An index is added for ean on both tables. Patch cleans up inconsistencies caused by bug 5337 that causes some older databases to have an existing index on biblioitems.ean. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13766] biblioitems.ean field is too short
by bugzilla-daemon＠bugs.koha-community.org 17 Aug '17

17 Aug '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13766 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Needs Signoff Patch complexity|Trivial patch |Small patch -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14666] adds fixed_fines for overdues
by bugzilla-daemon＠bugs.koha-community.org 17 Aug '17

17 Aug '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14666 --- Comment #8 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- Patch doesn't apply at the moment: CONFLICT (content): Merge conflict in tools/overduerules.pl Auto-merging koha-tmpl/intranet-tmpl/prog/en/modules/tools/overduerules.tt Auto-merging installer/data/mysql/kohastructure.sql CONFLICT (content): Merge conflict in installer/data/mysql/kohastructure.sql The code looks clean, but appears to contain only the CRUD for the GUI, not the actually charging of the fine yet. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13371] Add filters to the supplier list view
by bugzilla-daemon＠bugs.koha-community.org 17 Aug '17

17 Aug '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13371 --- Comment #78 from Katrin Fischer <katrin.fischer(a)bsz-bw.de> --- CONFLICT (content): Merge conflict in koha-tmpl/intranet-tmpl/prog/en/modules/acqui/booksellers.tt I'd like to take a look, but patches no longer apply. Can you please rebase? -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 10306] Koha to MARC mappings (Part 1): Allow multiple mappings per kohafield (for say 260/RDA 264)
by bugzilla-daemon＠bugs.koha-community.org 17 Aug '17

17 Aug '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10306 --- Comment #44 from Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> --- Trivial rebase on current master. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 10306] Koha to MARC mappings (Part 1): Allow multiple mappings per kohafield (for say 260/RDA 264)
by bugzilla-daemon＠bugs.koha-community.org 17 Aug '17

17 Aug '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10306 Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #66135|0 |1 is obsolete| | --- Comment #43 from Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> --- Created attachment 66142 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66142&action=ed… Bug 10306: Adjusted online help text for koha2marclinks Test plan: Click on Help. Read the text. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 10306] Koha to MARC mappings (Part 1): Allow multiple mappings per kohafield (for say 260/RDA 264)
by bugzilla-daemon＠bugs.koha-community.org 17 Aug '17

17 Aug '17

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10306 Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #66134|0 |1 is obsolete| | --- Comment #42 from Marcel de Rooy <m.de.rooy(a)rijksmuseum.nl> --- Created attachment 66141 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66141&action=ed… Bug 10306: Support for multiple mappings in koha2marclinks This actually refactors koha2marclinks.pl in order to support multiple mappings per kohafield. Instead of three separate mapping pages for biblio, biblioitems and items, the script now lists them together. This gives a complete overview of all mappings rightaway. Changes are applied immediately across all frameworks. Note: This report handles the Default mappings just like it did before. In this script Koha already considered them as authoritative, although other parts of Koha did not. Follow-up report 19096 makes Default mappings authoritative throughout all Koha. On each line two buttons are provided, Add and Remove, in order to add or remove an individual mapping. We do no longer provide a separate form with the names of MARC tags. Since this form is targeted for administrators, it should be enough to ask for a field tag and subfield code. Note: The mappings for biblionumber, biblioitemnumber and itemnumber are so vital that this form marks them as readonly. It is not recommended to change them. Test plan: [1] Add a mapping. Verify via Frameworks or mysql command line that the kohafield is saved to the other frameworks too. [2] Remove the mapping again. Check Frameworks or mysql cl again. [3] Test adding a second mapping. Map copyrightdate to 260c and 264c. And map biblioitems.place to 260a and 264a. [4] Edit biblio record 1: Put 1980 in 260c. Do not include 264c. Edit biblio record 2: Put 1990 in 264c. Do not include 260c. Edit biblio record 3: Put 2000 in both 260c and 264c. Put CityA in 260a and in 264a. Edit biblio record 4: Put 2010 in 260c, and 2015 in 264c (which you should refuse normally). Put CityA in 260a, and CityB in 264a. [5] Create a report that shows biblioitems.place and biblio.copyrightdate for those biblio records. Record 4 should have 2010 in copyrightdate (since TransformMarcToKoha picks the first year for copyrightdate). Record 3 should have place CityA; record 4 should have CityA | CityB. Note: The CityA | CityB example illustrates that we should add some additional handling in TransformMarcToKoha for multiple 264s. [6] Add these four biblio records to a new list. Sort by Year. With OPACXSLTListsDisplay==default, check if the order = 1,2,3,4. (The order is based on biblio.copyrightdate.) Note that (RDA) record 2 would be on top without this patch set, since copyrightdate would have been null. -- You are receiving this mail because: You are watching all bug changes.

1 0