Re: [Koha] Editing MARC Frameworks

2019-07-29 Thread Sally Stewart
Thanks to you both! A fab solution. I didn't understand initially, but after a cup of tea, what you both have communicated, has sunk in. Greatly appreciated. Sally Sally Stewart Librarian Library Royal Botanic Gardens Victoria Birdwood Avenue Melbourne Victoria 3004 T +61 3 9252 2320

Re: [Koha] Source of acquisition

2019-07-29 Thread Carlos Lopez
Hi Katrin > You say the behavior changed - can you verify and tell us the version? Sorry no - I'm no longer sure there was a change in behaviour; it may instead have been that vendor names carried through to item records on migration from our old system. I'll keep an eye on this just in case.

Re: [Koha] Editing MARC Frameworks

2019-07-29 Thread Carlos Lopez
Hi Katrin Thanks for that. So what you're saying is that we should open the MARC editor, set the values we want for that material type in the leader, then copy the entire leader into 'Advanced constraints > Default value' for the leader in the new MARC framework. Is that right? With kind

Re: [Koha] Incomplete import of framework

2019-07-29 Thread Katrin Fischer
Hi Michael, I just retested on master and had the same bad result. I have filed a bug: *BugĀ 23398* - Exporting/Reimporting frameworks in XML format will give incomplete results Katrin On 23.07.19 18:25, Michael Kuhn wrote: Hi

Re: [Koha] Source of acquisition

2019-07-29 Thread Katrin Fischer
Hi Carlos, I believe this has always been the default behavior for items created through the acquisitions module vs. items created in cataloging where people tend to put the vendor's name into the field. You say the behavior changed - can you verify and tell us the version? Katrin On 29.07.19

Re: [Koha] Editing MARC Frameworks

2019-07-29 Thread Katrin Fischer
Hi Sally, I usually use the default setting in the bibliographic frameworks as suggested by Carlos. I create a record setting the defaults I want using the plugin (for the 00x this refers to the pop-up window you get instead of entering the values manually). Then I copy the value created and

[Koha] POS software

2019-07-29 Thread Robin Hastings
Anyone out there using an open source Point-Of-Sale software that works for your library? I'm looking for something simple that just keeps track of money collected for replacement costs and various fees. If so, can you send me links? Thanks in advance!! -- Robin Hastings Library Services

Re: [Koha] invalid data, cannot decode object

2019-07-29 Thread dolf
I'm getting the same error with one book. We also haven't seen this error before version 19.05. Here is the offending MARC record: MariaDB [koha_rsc]> select * from biblio_metadata where biblionumber=39335; *** 1. row *** id: 32057

Re: [Koha] Suddenly can't check in items

2019-07-29 Thread drojup
Thank you very much Ere! Finally, I managed to checkin the items! Thank you all! -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz

Re: [Koha] Suddenly can't check in items

2019-07-29 Thread Ere Maijala
You're not in mysql if you get an error message like that. Start with just the following: sudo mysql -uroot -p Then issue the command: use koha_library; Then the rest of the commands. Exit mysql by entering: exit Hope this helps, Ere drojup kirjoitti 29.7.2019 klo 12.34: > Thank you

Re: [Koha] Suddenly can't check in items

2019-07-29 Thread drojup
Thank you Michael, Please see the messages: ~$ DELETE FROM old_issues WHERE issue_id IN (1539, 1540, 1541); /bash: syntax error near unexpected token `('/ and ~$ DELETE FROM old_issues WHERE issue_id=1539; /DELETE: command not found/ -- Sent from:

Re: [Koha] Suddenly can't check in items

2019-07-29 Thread Michael Kuhn
Hi > /DELETE FROM old_issues WHERE issue_id IN (1539,1540,1541) ;/ > > and I got this message: > > /bash: syntax error near unexpected token `('/ Try DELETE FROM old_issues WHERE issue_id IN (1539, 1540, 1541); Or: DELETE FROM old_issues WHERE issue_id=1539; DELETE FROM old_issues WHERE

Re: [Koha] Suddenly can't check in items

2019-07-29 Thread drojup
I used this way: /sudo mysql -uroot -p use koha_library;/ then /DELETE FROM old_issues WHERE issue_id IN (1539,1540,1541) ;/ and I got this message: /bash: syntax error near unexpected token `('/ -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

Re: [Koha] Editing MARC Frameworks

2019-07-29 Thread Sally Stewart
Hey Carlos! Yes - we've had a look at the .pl files and can see that the various types are noted within, but I don't know enough about coding to make sense of it. Perhaps we have to create custom .pl files for each framework, and refer to them in the 'Other options' tab? Thanks for your

Re: [Koha] Editing MARC Frameworks

2019-07-29 Thread Carlos Lopez
Hi Sally I'm no expert on this but it looks as though there is a box for 'Default value' -- of course, I don't know how you'd enter a default value there (regular expressions?) so that the system fills in characters 0-5, then 'km', then the rest of the leader. Same deal for the 008. Both

Re: [Koha] Suddenly can't check in items

2019-07-29 Thread drojup
Thanks for the help! Does anyone know what commands should I run in order to delete the affected records? Regards -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___ Koha mailing list http://koha-community.org

[Koha] Editing MARC Frameworks

2019-07-29 Thread Sally Stewart
Hi All, we are new to Koha, and have not been able to find an answer to this problem... We are trying to create MARC Frameworks for various record types, but cannot work out how to set the Leader 06 (Type of material), 07 (Bib level) and 008 fields to correctly define the materials. For