- Koha - lists.katipo.co.nz

bulk import of authorised values?
by Peter Huerter 26 Nov '10

26 Nov '10

Is there a way to do a bulk import of "authorized values"? I have not been able to find KOHA user interface support for this. If there is no user interface support for this, then can I *safely* add new authorised values to the SQL authorised_values table directly? I am wondering if I can do something like this: In MYSQL, to add a new "MILITARY" authorised value to LOC: 1. SELECT * from authorised_values; And determine the next 'id' available, call it <id> in what follows. 2. INSERT INTO authorised_values VALUES (<id>, 'LOC', 'military', 'MILITARY', NULL); Thanks, Pete. Context: Specifically, I'm interested in adding "LOC" authorized values. I've added two such values manually using the KOHA interface (Home › Administration › Authorized values). They are called "RARE", and "MILITARY". These values are making it into the following SQL table: (To dump all LOC authorised values I do this ..) mysql> select * from authorised_values where category = "LOC"; +----+----------+------------------+----------------------+----------+ | id | category | authorised_value | lib | imageurl | +----+----------+------------------+----------------------+----------+ | 12 | LOC | FIC | Fiction | NULL | | 13 | LOC | CHILD | Children's Area | NULL | | 14 | LOC | DISPLAY | On Display | NULL | | 15 | LOC | RARE | Rare book collection | | | 16 | LOC | STAFF | Staff Office | NULL | | 17 | LOC | GEN | General Stacks | NULL | | 18 | LOC | AV | Audio Visual | NULL | | 19 | LOC | REF | Reference | NULL | | 31 | LOC | military | Military | | +----+----------+------------------+----------------------+----------+ 9 rows in set (0.00 sec) (To dump the structure of authorised_value table I do this ..) mysql> show columns from authorised_values; +------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | category | varchar(10) | NO | MUL | | | | authorised_value | varchar(80) | NO | | | | | lib | varchar(80) | YES | | NULL | | | imageurl | varchar(200) | YES | | NULL | | +------------------+--------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec) mysql> -- View this message in context: http://koha.1045719.n5.nabble.com/bulk-import-of-authorised-values-tp328151… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

Re: [Koha] SQL report help
by Nicole Engard 26 Nov '10

26 Nov '10

Marlene, I'm happy to help, next time though email the entire list so they can all benefit from my answer. Try this: SELECT borrowers.surname, borrowers.firstname, borrowers.cardnumber, borrower_attributes.code, borrower_attributes.attribute FROM borrowers LEFT JOIN borrower_attributes ON (borrowers.borrowernumber=borrower_attributes.borrowernumber) LEFT JOIN borrower_attribute_types ON (borrower_attribute_types.code=borrower_attributes.code) group by borrower_attributes.attribute order by borrowers.surname, borrowers.firstname asc It doesn't format the report the way you want but it does give you the info you're looking for. Thanks Nicole On Fri, Nov 26, 2010 at 10:35 AM, marlene <marlene.delhaye(a)gmail.com> wrote: > Hello, > > I just found your sql report about patron attributes : > Patrons with Attribute Value > * Developer: Nicole C. Engard, ByWater Solutions > * Module: Patrons > * Purpose: Patron list with the value of one of their custom > patron attributes (student id) > * Status: Complete > > SELECT borrowers.surname, borrowers.firstname, > borrowers.cardnumber, borrower_attributes.attribute AS 'Student ID' > FROM borrowers > LEFT JOIN borrower_attributes ON > (borrowers.borrowernumber=borrower_attributes.borrowernumber) > LEFT JOIN borrower_attribute_types ON > (borrower_attribute_types.code=borrower_attributes.code) > WHERE borrower_attributes.code = 'STUID' > > My problem is that I want to list all the attributes of my patrons, this way : > borrower number | surname | firstname | attribute 1 | attribute 2 | > attribute 3 | ... > My goal is to get the most comprehensive list from SQL, so that I can > do more complicated things with excel afterwards. > So, do you have an idea of how to deal with several attributes ? > > Thanks a lot for what you do for OSS anyway, > > Best regards, > > Marlène Delhaye > Koha administrator for Université Paul Cézanne Aix-Marseille 3, France > > aim/Y! : ebibliothecaire > fb : http://www.facebook.com/marlenedelhaye > ff : http://friendfeed.com/marlened > twitter : http://twitter.com/marlened > blog : http://marlenescorner.net/ > old blog : http://www.biblioacid.org/ >

1 0

Re: [Koha] koha 3.0 compilation error
by DEEPTI 25 Nov '10

25 Nov '10

Hi Guys i am configure koha in open suse 11.1 for my office but i m finding some error. The following fatal error has occurred: Can't locate ZOOM.pm in @INC (@INC contains: /usr/share/koha/lib /usr/lib/perl5/5.10.0/i586-linux-thread-multi /usr/lib/perl5/5.10.0 /usr/lib/perl5/site_perl/5.10.0/i586-linux-thread-multi /usr/lib/perl5/site_perl/5.10.0 /usr/lib/perl5/vendor_perl/5.10.0/i586-linux-thread-multi /usr/lib/perl5/vendor_perl/5.10.0 /usr/lib/perl5/vendor_perl .) at /usr/share/koha/lib/C4/Context.pm line 84. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Context.pm line 84. Compilation failed in require at /usr/share/koha/lib/C4/Auth.pm line 29. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 29. Compilation failed in require at /usr/share/koha/intranet/cgi-bin/errors/404.pl line 21. BEGIN failed--compilation aborted at /usr/share/koha/intranet/cgi-bin/errors/404.pl line 21. I hope somebody can help please. it's really important for me.i m trainee in my company and i is my project. please i need help Deepti Ahlawat -- View this message in context: http://koha.1045719.n5.nabble.com/koha-3-0-compilation-error-tp3057457p3279… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 1

cart button - change or remove
by Elaine Bradtke 25 Nov '10

25 Nov '10

We are in the process of fine tuning the OPAC display, and have an outside web designer providing a 'skin' in the house style so it matches the rest of the Society's web sites. Having learned html back in the dark ages, I'm not yet up to speed on css. I'm not even sure which parts are governed by the skin and which are internal koha stylesheets. Is this spelled out somewhere? My boss has taken an extreme dislike to the 'cart' button. He would like it removed, or at least called something else (still pondering about what to change it to). I have experimented with them both, and there seems to be very little difference between the cart function and the list function. Am I wrong in this? Has anyone switched it off, or changed the name of the button? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 ext 36 -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

4 5

Field Mapping to koha
by makekee＠msu.ac.zw 25 Nov '10

25 Nov '10

Hi All My current system keeps its call number in one field with 3 subfields for example: QA75.4SMI QA Call number prefix is 852k 75.4 Classification part is 852h SMI Item part is 852i Now i want to map all the above into koha field for class number what do I really do? Ephazz ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.

2 1

how to search articles details in journals? any option from koha
by Yatheesh Y 25 Nov '10

25 Nov '10

Is there any option in koha to search "articles details" in print journals ? all libraries are subscribing print journal if a user want to search an article he has to search all previous issues. If any option is available to enter articles details under" journal" user can search from OPAC can we create ? Yatheesh

2 1

having trouble installing zebra on RHEL5
by Gallagher, Sean (sfg6n) 25 Nov '10

25 Nov '10

Hi all, I am having a heck of a time installing all the dependencies for Zebra. Has anyone recently installed Zebra on a RHEL5 machine? If so, could you help me out? What I would like to know is what order you installed the dependencies Zebra asked for. Thanks, Sean

2 1

Installing translation in 3.2.04
by Beda Szukics 25 Nov '10

25 Nov '10

Hi all I tried to install the german translation with: web-kso1:/usr/share/koha/misc/translator# perl translate install de-DE It gave me: readdir() attempted on invalid dirhandle $fh at LangInstaller.pm line 62. closedir() attempted on invalid dirhandle $fh at LangInstaller.pm line 63. Install templates Install templates 'opac From: /usr/share/koha/opac/htdocs/opac-tmpl/prog/en/ To : /usr/share/koha/opac/htdocs/opac-tmpl/prog/de-DE With: /usr/share/koha/intranet/cgi-bin/misc/translator/po/de-DE-i-opac-t-prog-v-30 02000.po Can't exec "/usr/share/koha/intranet/cgi-bin/misc/translator/tmpl_process3.pl": Datei oder Verzeichnis nicht gefunden at LangInstaller.pm line 286. Install templates 'intranet From: /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/ To : /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/de-DE With: /usr/share/koha/intranet/cgi-bin/misc/translator/po/de-DE-i-staff-t-prog-v-3 002000.po Can't exec "/usr/share/koha/intranet/cgi-bin/misc/translator/tmpl_process3.pl": Datei oder Verzeichnis nicht gefunden at LangInstaller.pm line 286. Update 'de-DE' preferences .po file from 'en' .pref files Use of uninitialized value $pref_name in concatenation (.) or string at LangInstaller.pm line 132. Saved in file: /usr/share/koha/intranet/cgi-bin/misc/translator/po/de-DE-pref.po Write opac.pref [and so on] The rest works fine. The script seems to search tmpl_process3.pl in the wrong directory. Using the script directly as shown in the documentation worked fine. Is this a bug or am I doing something wrong? Greetings Beda

2 1

I can't separate Branch information
by Geovana de Paula Santos Tarricone 24 Nov '10

24 Nov '10

That's my situation... I have just one installation for three branches. In each branch I have patrons, specific rules for circulation and catalogued itens. But I don't want all the information, that belongs to the thtee, mixed. I'd like to separate it.... Like, if I define my library as 1, in the top of the window (set up library), when I search for my patrons, I'd like to see just mine and not all the patrons inserted on my Koha. Should I do some configuration that I'am forgetting? So, I have another problem, when I search books using as parameter the name of my branchs, Koha says me that there=B4s no book catalogued for the branch. Should I do some configuration? My Koha Version is: 3.00.06.010 mysql Ver 14.14 Ubuntu 10.04 Apache/2.2.14 (Ubuntu) Thanks in advance, Gi. -- Geovana de Paula Santos Tarricone

2 1

Hidden attribute of subfields in cataloguing frameworks
by Stefano Bargioni 24 Nov '10

24 Nov '10

In my Koha 3.2.0 test installation, hidden attributes of subfields have these values: 9 7 6 5 4 1 0 -1 -5 -6 I'm not able to find the meaning of each code in manuals, FAQs, forums... Thanks. Stefano

3 3