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, [email protected] wrote: > > Send Koha mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: koha <[email protected]> > Subject: Re: [Koha] Importing Koha Database to a new install > Message-ID: <1388709796.12800.38.camel@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 <[email protected]> > To: Koha-List <[email protected]> > Subject: Re: [Koha] SQL report 650 a > Message-ID: <2C614FEEE2356A428DC65441E30302E06F6EDC@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 <[email protected]> > To: [email protected] > Subject: Re: [Koha] How to print checked out items and news from the > quick > Message-ID: <[email protected]> > 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 <[email protected]> > To: "[email protected]" <[email protected]> > Subject: [Koha] Status of item = Checked out ...and waiting? > Message-ID: > <CAEboqJP2=fg0rk96awkiex-jazjdnmg4-dz-jfzodt3okyh...@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 <[email protected]> > To: [email protected] > Subject: Re: [Koha] SQL report 650 a > Message-ID: <[email protected]> > 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 > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 99, Issue 4 > *********************************** _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
