[Koha] Koha & rfid
Remark
opensistem at yahoo.com
Sat Jan 4 22:37:33 NZDT 2014
Any members here have experienced using uhf rfid with koha ? If any pls share some important tips. I ask this becouse one user here (malaysia) to implement rfid uhf.
Refards
Esmael
Sent from my iPhone
> On 04/01/2014, at 7:00, koha-request at lists.katipo.co.nz wrote:
>
> Send Koha mailing list submissions to
> koha at 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 at lists.katipo.co.nz
>
> You can reach the person managing the list at
> koha-owner at 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. Re: Importing Koha Database to a new install (Robin Sheat)
> 2. Re: SQL report 650 a (Holger Meissner)
> 3. Re: How to print checked out items and news from the quick
> (magmatic)
> 4. Status of item = Checked out ...and waiting? (Chad Roseburg)
> 5. Re: SQL report 650 a (Bob Birchall)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 03 Jan 2014 13:43:16 +1300
> From: Robin Sheat <robin at catalyst.net.nz>
> To: koha <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Importing Koha Database to a new install
> Message-ID: <1388709796.12800.38.camel at zarathud>
> Content-Type: text/plain; charset="UTF-8"
>
> Please reply to the list, so that other people with the same problem in
> the future can see information on it.
>
> Phillip Ponchot schreef op do 02-01-2014 om 15:48 [-0800]:
>> After I install Koha and do everything mentioned before importing my
>> database, do I log into the staff koha web interface and setup the
>> database like set language to en, choose marc21 records etc.
>
> No, I always start from a clean database and import my database directly
> into there.
>
>> all one line:
>> (I assume this is clearing the database)
>> mysql -u koha_library -p xxxxxxxxxxxxxx -Nse 'show tables'
>> koha_library | while read table; do mysql -u koha_library
>> -p xxxxxxxxxxxxxxxxxxxx -e "drop table $table" koha_library ; done
>
> That will go some way to clearing the database, but I would expect you
> get a lot of errors about foreign relationships, if so, run it multiple
> times until you get no errors. Best just start from an empty database
> though.
>
>> (the data imports just fine)
>> 5. sudo koha-mysql library < backedup.sql
>
> This will abort if there is any error, so that it doesn't is a good
> sign.
>
> However, you say that it imports just fine. How do you know? That there
> are no errors isn't good enough. Did you look in the tables and count
> the records to make sure the right number are there? Did you have a look
> in backedup.sql to make sure that it's got the right data in it? Did you
> compare some things between them. I think that there is something going
> wrong around here.
>
>> (seems to work but does this extremely fast, I figured it would take
>> longer)
>> 6. sudo koha-upgrade-schema library
>
> It should _definitely_ take some time. I think the fact that it's not is
> the primary symptom of the issue. Is there any output at all? There
> should be heaps of it, stuff like "Upgrade to version 3.12.34 done (Add
> widget to foobar)" type things.
>
> At this point, what I think is happening is that you are adding sample
> data into the database, and when you think you are importing your real
> data over the top of it, you actually aren't.
>
> I don't know where it's going, your steps look correct, but I suspect
> that the reason that it's going fast is because it's looking at the
> database and saying "oh, already at the latest version, let's do
> nothing" because you have your sample data still there rather than real
> data.
>
>> (if I run this I get a complaint that ean and agerestriction is not in
>> biblioitems. If I create these tables in biblioitems, it takes about
>> an hour so upgrade all 37400 records.
>> 7. sudo koha-upgrade-to-3.4 library
>
> Yeah, it'll be expecting a more modern schema. For 37,400 records, I
> would consider an hour to be roughly right. It's been a long while since
> I've had to run that though.
>
> ean and agerestriction came in in 3.09, so that they're not there
> suggests that something before this step is definitely wrong.
>
>> (during the upgrade zebra rebuild is run, but I've run it just in case
>> since it is in the instructions)
>> 8. ran zebra rebuild - koha-rebuild-zebra -v -f library
>
> My rule of thumb is to run this after anything significant has happened.
> It doesn't hurt, and is the first port of call when something weird is
> happening.
>
>> I try to login to the web interface as the old staff user (in the
>> database) but it does not work.
>
> Don't say "doesn't work." What actually happens? What I would expect,
> given the apparent failure of step 6, is that it redirects you do the
> web installer and says "upgrading to version 3.12.whatever" or something
> along those lines. If it says that, what does it actually say? If it
> doesn't say that, what does it actually say? Details are vital here.
>
> I would fully expect that login to not work in this case though, you
> should be using the database username/password for the schema upgrade.
>
>> I log into the web interface with the koha_library account and I can
>> get into Koha but there is just mylibrary and several other samples.
>
> So, are these the samples you created when you installed it the first
> time?
>
>> After I install Koha, do I immediate login as Koha_library with the
>> supplied password do the setup (set english, set marc21) etc.
>
> No.
>
>> After I import data, fix the schema, upgrade to 3.4 and rebuild zebra,
>> how to I setup the web interface to see the my library's data.
>
> You don't, it just works.
>
> Provide the result of doing all this with the "script" command, there
> may be clues in there.
>
> --
> Robin Sheat
> Catalyst IT Ltd.
> ? +64 4 803 2204
> GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
>
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 3 Jan 2014 12:31:21 +0000
> From: Holger Meissner <Holger.Meissner at hs-gesundheit.de>
> To: Koha-List <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] SQL report 650 a
> Message-ID: <2C614FEEE2356A428DC65441E30302E06F6EDC at nero>
> Content-Type: text/plain; charset="us-ascii"
>
> yoonus para wrote:
>> Dear all,
>>
>> How to create a SQL report using field 650 a with barcode and title,Please help me to create this report.
>>
>> Thanks
>> Yoonus
>
> Did you find a solution? I thought it might be interesting, but I also can't figure it out.
>
> When I run
> SELECT * FROM marc_subfield_structure WHERE tagfield = 650 AND tagsubfield = 'a'
>
> it tells me the "kohafield" is bibliosubject.subject, yet it seems that I don't have a table called bibliosubject. Is that normal?
>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 3 Jan 2014 11:39:12 -0800 (PST)
> From: magmatic <magmatic at timkoop.com>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] How to print checked out items and news from the
> quick
> Message-ID: <1388777952692-5782744.post at n5.nabble.com>
> Content-Type: text/plain; charset=us-ascii
>
> I just got it working the way I wanted it to work. I want to print Slips
> instead of Quick Slips when enter is pressed. This is how:
>
> Edit the file:
> /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/circ/circulation.tt
>
> On line 79 or so, replace
> printx_window('qslip');
> with
> printx_window('slip');
>
> That should do it.
>
> --
> Tim
>
>
>
> --
> View this message in context: http://koha.1045719.n5.nabble.com/Re-How-to-print-checked-out-items-and-news-from-the-quick-tp5780917p5782744.html
> Sent from the Koha-general mailing list archive at Nabble.com.
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 3 Jan 2014 12:54:10 -0800
> From: Chad Roseburg <croseburg at ncrl.org>
> To: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
> Subject: [Koha] Status of item = Checked out ...and waiting?
> Message-ID:
> <CAEboqJP2=fg0rK96AwKieX-jAZjDNMg4-dZ-jfzodT3okyHhEA at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Wondering what scenario would result in the following:
>
> * Patron places hold on item
> * Item arrives at branch ...placed on holds shelf
> * Patron arrives at branch and checks out item
>
> Item status for the last week appears as follows in the staff interface:
>
> "Checked out to JOE D PATRON : due 01/04/2014 23:59
> Waiting for JOE D PATRON at RANDOM COMMUNITY LIBRARY since 12/18/2013"
>
> It also shows on the branch's expired holds list.
>
> Ideas?
>
> Thank you ~
>
> --
> Chad Roseburg
> Automation Dept.
> North Central Regional Library
>
>
> ------------------------------
>
> Message: 5
> Date: Sat, 04 Jan 2014 07:57:19 +1100
> From: Bob Birchall <bob at calyx.net.au>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] SQL report 650 a
> Message-ID: <52C7242F.7020407 at calyx.net.au>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>> On 03/01/14 23:31, Holger Meissner wrote:
>> yoonus para wrote:
>>> Dear all,
>>>
>>> How to create a SQL report using field 650 a with barcode and title,Please help me to create this report.
>>>
>>> Thanks
>>> Yoonus
>> Did you find a solution? I thought it might be interesting, but I also can't figure it out.
>>
>> When I run
>> SELECT * FROM marc_subfield_structure WHERE tagfield = 650 AND tagsubfield = 'a'
>>
>> it tells me the "kohafield" is bibliosubject.subject, yet it seems that I don't have a table called bibliosubject. Is that normal?
> Yes that is normal. 'Subject' is not separately defined in the data
> base. Subject data are stored as part of biblioitems.marcxml. You can
> report on the data using the 'extract value' command in SQL. There
> should be examples in the library:
> http://wiki.koha-community.org/wiki/SQL_Reports_Library
>
> Best wishes,
> Bob Birchall
> Calyx
>
>
> ------------------------------
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> End of Koha Digest, Vol 99, Issue 4
> ***********************************
More information about the Koha
mailing list