October 2013 - Koha-bugs - lists.koha-community.org

[Bug 10633] New: Table suggestions needs some work
by bugzilla-daemon＠bugs.koha-community.org 08 Jan '15

08 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10633 Bug ID: 10633 Summary: Table suggestions needs some work Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org The table suggestions is missing FK constraints and cascades to ensure a suggestion is anonymized when the borrower who suggested it gets deleted. The current table definition is: 2077 DROP TABLE IF EXISTS `suggestions`; 2078 CREATE TABLE `suggestions` ( -- purchase suggestions 2079 `suggestionid` int(8) NOT NULL auto_increment, -- unique identifier assigned automatically by Koha 2080 `suggestedby` int(11) NOT NULL default 0, -- borrowernumber for the person making the suggestion, foreign key linking to the borrowers table 2081 `suggesteddate` date NOT NULL default 0, -- date the suggestion was submitted 2082 `managedby` int(11) default NULL, -- borrowernumber for the librarian managing the suggestion, foreign key linking to the borrowers table 2083 `manageddate` date default NULL, -- date the suggestion was updated 2084 acceptedby INT(11) default NULL, -- borrowernumber for the librarian who accepted the suggestion, foreign key linking to the borrowers table 2085 accepteddate date default NULL, -- date the suggestion was marked as accepted 2086 rejectedby INT(11) default NULL, -- borrowernumber for the librarian who rejected the suggestion, foreign key linking to the borrowers table 2087 rejecteddate date default NULL, -- date the suggestion was marked as rejected 2088 `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED) 2089 `note` mediumtext, -- note entered on the suggestion 2090 `author` varchar(80) default NULL, -- author of the suggested item 2091 `title` varchar(255) default NULL, -- title of the suggested item 2092 `copyrightdate` smallint(6) default NULL, -- copyright date of the suggested item 2093 `publishercode` varchar(255) default NULL, -- publisher of the suggested item 2094 `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the suggestion was updated 2095 `volumedesc` varchar(255) default NULL, 2096 `publicationyear` smallint(6) default 0, 2097 `place` varchar(255) default NULL, -- publication place of the suggested item 2098 `isbn` varchar(30) default NULL, -- isbn of the suggested item 2099 `mailoverseeing` smallint(1) default 0, 2100 `biblionumber` int(11) default NULL, -- foreign key linking the suggestion to the biblio table after the suggestion has been ordered 2101 `reason` text, -- reason for accepting or rejecting the suggestion 2102 `patronreason` text, -- reason for making the suggestion 2103 budgetid INT(11), -- foreign key linking the suggested budget to the aqbudgets table 2104 branchcode VARCHAR(10) default NULL, -- foreign key linking the suggested branch to the branches table 2105 collectiontitle text default NULL, -- collection name for the suggested item 2106 itemtype VARCHAR(30) default NULL, -- suggested item type 2107 quantity SMALLINT(6) default NULL, -- suggested quantity to be purchased 2108 currency VARCHAR(3) default NULL, -- suggested currency for the suggested price 2109 price DECIMAL(28,6) default NULL, -- suggested price 2110 total DECIMAL(28,6) default NULL, -- suggested total cost (price*quantity updated for currency) 2111 PRIMARY KEY (`suggestionid`), 2112 KEY `suggestedby` (`suggestedby`), 2113 KEY `managedby` (`managedby`) 2114 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 10631] New: Table alert should have a FK on borrowernumber and entries be deleted with the referenced borrower
by bugzilla-daemon＠bugs.koha-community.org 08 Jan '15

08 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10631 Bug ID: 10631 Summary: Table alert should have a FK on borrowernumber and entries be deleted with the referenced borrower Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org The table alert is currently used to store information about email subscriptons for new serial issues. The current table defnition is: 2682 DROP TABLE IF EXISTS `alert`; 2683 CREATE TABLE `alert` ( 2684 `alertid` int(11) NOT NULL auto_increment, 2685 `borrowernumber` int(11) NOT NULL default 0, 2686 `type` varchar(10) NOT NULL default '', 2687 `externalid` varchar(20) NOT NULL default '', 2688 PRIMARY KEY (`alertid`), 2689 KEY `borrowernumber` (`borrowernumber`), 2690 KEY `type` (`type`,`externalid`) 2691 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 2692 As I see it borrowernumber should be a FK and we are missing some cascades to make sure the table is cleaned up when a borrower is deleted. -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 6780] New: Log duplicate card issuance
by bugzilla-daemon＠bugs.koha-community.org 07 Jan '15

07 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6780 Bug #: 6780 Summary: Log duplicate card issuance Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_6 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Patrons AssignedTo: kyle.m.hall(a)gmail.com ReportedBy: savitra.sirohi(a)osslabs.biz QAContact: koha-bugs(a)lists.koha-community.org CC: gmcharlt(a)gmail.com If patron related logging is turned on, log duplicate card issuance -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 3

[Bug 6760] New: Generate new card number on renewals and duplicate card issuance
by bugzilla-daemon＠bugs.koha-community.org 07 Jan '15

07 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6760 Bug #: 6760 Summary: Generate new card number on renewals and duplicate card issuance Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_6 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Patrons AssignedTo: kyle.m.hall(a)gmail.com ReportedBy: savitra.sirohi(a)osslabs.biz QAContact: koha-bugs(a)lists.koha-community.org CC: gmcharlt(a)gmail.com Some libraries need a new card to be generated on membership renewal and duplicate card issuance. A new sys pref will be created for this purpose. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 2

[Bug 8601] New: Allow more pictures on Patron Cards
by bugzilla-daemon＠bugs.koha-community.org 07 Jan '15

07 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8601 Priority: P5 - low Change sponsored?: --- Bug ID: 8601 Assignee: cnighswonger(a)foundations.edu Summary: Allow more pictures on Patron Cards Severity: enhancement Classification: Unclassified OS: All Reporter: derrynj(a)gmail.com Hardware: All Status: NEW Version: rel_3_8 Component: Label printing Product: Koha Currently there is only 2 pictures allowed on patron card. This is acceptable, however it would be nice to be able to add more with an "add another image" button or something along those lines. At the very least, could we free up a custom image by making the patron image a separate component? I've tried adding extra images to the XML code in the database, and it seems to work just by incrementing the image number value. -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 7569] New: Add Google Transliteration tool to fields during cataloging and in advanced search in OPAC
by bugzilla-daemon＠bugs.koha-community.org 07 Jan '15

07 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7569 Bug #: 7569 Summary: Add Google Transliteration tool to fields during cataloging and in advanced search in OPAC Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_8 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging AssignedTo: gmcharlt(a)gmail.com ReportedBy: savitra.sirohi(a)osslabs.biz QAContact: koha.sekjal(a)gmail.com Google's transliteration tool can be turned on for basic search in OPAC's masthead. Attemt to add this tool to: 1. Cataloging pages especially addbooks.pl: this will allow users to catalog items in other languages efficiently 2. Advanced search fields in the OPAC -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.

1 2

[Bug 6778] New: Display suggestor's name in catalog detail page
by bugzilla-daemon＠bugs.koha-community.org 07 Jan '15

07 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6778 Bug #: 6778 Summary: Display suggestor's name in catalog detail page Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_6 Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Acquisitions AssignedTo: henridamien(a)koha-fr.org ReportedBy: savitra.sirohi(a)osslabs.biz QAContact: koha-bugs(a)lists.koha-community.org Display suggestor's name in catalogue detail page (both regular and XSLT views) -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.

1 4

[Bug 11044] New: All the librarians managing a fund should see the suggestions related to this fund
by bugzilla-daemon＠bugs.koha-community.org 07 Jan '15

07 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11044 Bug ID: 11044 Summary: All the librarians managing a fund should see the suggestions related to this fund Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: mathieu.saby(a)univ-rennes2.fr QA Contact: testopia(a)bugs.koha-community.org All the librarians managing a fund should see the suggestions related to this fund If the librarian managing history collections is replaced by an other colleague, this other librarian should have access to all suggestions accepted by his colleague. Not sure it is currently possible M. Saby -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 10162] New: holds shouldn't be allowed on the title level of analytics
by bugzilla-daemon＠bugs.koha-community.org 07 Jan '15

07 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10162 Bug ID: 10162 Summary: holds shouldn't be allowed on the title level of analytics Classification: Unclassified Change sponsored?: --- Product: Koha Version: 3.10 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: nengard(a)gmail.com CC: m.de.rooy(a)rijksmuseum.nl For this example I have a Kindle bib record with analytic records for each title on the Kindle. If you place a hold on the next available copy of 'Gone Girl' (a title on the Kindle) it goes on the holds queue for the analytic record (the title) but it should go on the Kindle because the title isn't really it's own item. I haven't tried checking in the barcode associated with the Kindle and the title, but I would assume that it would confuse Koha quite a bit if there were holds on the title and on the Kindle. Nicole -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 8179] New: Receiving items requires repetitive clicking.
by bugzilla-daemon＠bugs.koha-community.org 07 Jan '15

07 Jan '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8179 Priority: P5 - low Change sponsored?: --- Bug ID: 8179 Assignee: henridamien(a)koha-fr.org Summary: Receiving items requires repetitive clicking. Severity: enhancement Classification: Unclassified OS: All Reporter: fred.pierre(a)smfpl.org Hardware: All Status: NEW Version: rel_3_6 Component: Acquisitions Product: Koha Our Acquisitions workflow is currently hindered by a repetitive process of receiving individual items. The parcel.pl and orderreceive.pl scripts in Koha 3.5 do not provide us with a way to checkbox individual items for receipt, or alternatively, "Receive All." We have to click receive on each item, then save the individual item and return to the receive screen. On orders where we have a hundred items, you can imagine this process of receiving is very tiresome, when a "Receive All" function could be implemented. Because several Acquisitions team members may be receiving items in the same basket, a checkbox on each line and a "Receive checked" would allow each worker to receive their specific items - giving the option to check all and receive, or just receive the items on your specific physical cart. This would be a benefit when large orders are being processed. By combining orderreceive.pl and finishreceive.pl we expect to be able to automate the process for batch receiving of items on an order. -- You are receiving this mail because: You are watching all bug changes.

1 4