Time Nick Message 13:13 danny hey owen 13:14 owen Hi danny 13:14 danny I was hoping I could get some more information from you about the use of "yui-b" and "yui-g" use in the opac templates 13:15 owen Sure 13:15 owen Have you checked out the Grids info on Yahoo's site? 13:15 danny I am trying to slightly tweak the formatting of our templates, but the use of each seems to be different depending on the page 13:15 danny I did take a look at it 13:16 owen I wouldn't be surprised if there were some inconsistencies in my implementation ;) 13:16 danny for example, opac-detail has both boxes surrounded by yui-b 13:16 danny but advanced search is only surrounded by yui-g 13:17 danny is this intended 13:18 kados danny: i think so because IIRC, advanced search is a single column 13:18 owen That's correct 13:19 kados danny: check out the yui docs for Grids 13:19 owen And I use this a lot: http://developer.yahoo.com/yui/grids/builder/ 13:19 kados danny: http://developer.yahoo.com/yui/grids/ 13:19 owen You can test out layouts and try replicating layouts from the opac 13:23 hdl hi 13:23 danny thanks owen and kados 15:44 owen DBD::mysql::st fetchrow_hashref failed: fetch() without execute() 15:45 owen Does that error mean that the query failed for some reason? 15:45 hdl yes. 15:45 hdl Normally, you should have the error some lines before. 15:46 owen Oh you're right, there it is 15:46 owen Unknown column 'aqorders.biblioitemnumber' in 'on clause' at /home/oleonard/kohaclone/acqui/spent.pl line 49 15:47 owen I'm rusty on SQL joins, but aqorders.biblioitemnumber does exist. 15:58 cau0730 i am having a tough time trying to figure out how this all works? what our schools want is a master biblio the items are tied to. the master biblio can have a lcn, but the items can also have an lcn 15:59 gmcharlt cau0730: by 'lcn' do you mean LC call number? 15:59 cau0730 see right now we are getting duplicate biblios in the db for every school that has a new book 15:59 cau0730 gmcharlt: yes 16:01 cau0730 it is kind of like a major rewrite, isn't it? i just want one master biblio and all the schools to tie onto that biblio 16:02 gmcharlt it would require some data processing to look for duplicates among the MARC bib records 16:03 gmcharlt pick one for each unique title 16:03 gmcharlt and move item information to that selected bib 16:03 gmcharlt e.g., in 952 fieldsa 16:04 cau0730 but the only thing is how to move the item information. searching the db for duplicates isn't the hard part. it is getting everything combined once we have them 16:05 cau0730 what table are the marc bib records stored in 16:06 cau0730 can you tell i am new at this lol 16:11 cau0730 see how we have it setup is really weird. we have 12 schools on the program right now. so each one of them have a branch... and the branch is determined by the ip, so when the user logs in the ip sets the branch name... following so far??? 16:15 gmcharlt yes 16:16 gmcharlt re moving records around, I'm more familiar with Koha 3, not Koha 2 16:16 gmcharlt and you'll have to decide whether to merge records now (in Koha 2), merge them after you go to 3 16:16 gmcharlt or try to merge and migrate in one fell swoop 16:17 cau0730 is there a simple way to merge in koha3? does it allow a biblio and items tied to the biblio by default 16:18 gmcharlt not at moment, but one is being developed for Koha 3.2 16:18 gmcharlt that being said, there are ways to do it if you don't mind delving in the code a bit 16:19 cau0730 no i don't mind... that is what i am here for :) 16:22 gmcharlt so the idea is after you migrate to Koha 3 16:23 gmcharlt you would use SQL to move items by changing items.biblionumber and items.biblioitemnumber to point to merged bib 16:24 gmcharlt then run misc/maintenance/sync_items_in_marc_bib.pl to update item information embedded as tags in the bib record 16:24 gmcharlt finally, reindex 16:29 cau0730 would that not mean that i would have to update code 16:31 cau0730 so you are saying that i would install and get running koha 3. then i would import my data using http://wiki.koha.org/doku.php?id=22_to_30&s=update22to30 information. then i would move those two fields to merged_bib and then i would run that script and reindex 16:32 gmcharlt basically, yes 16:32 gmcharlt you would have to write some code to identify the duplicate bibs 16:32 gmcharlt and you'd also have to delete the unwanted bibs, of course 16:35 cau0730 of course... that is easy to do though... 16:36 cau0730 search... display all bibs... set one as the master biblio... and delete the rest... 16:36 cau0730 and you are saying that the items field will be tied to the biblio right... so each branch will show up for each biblio? 16:37 gmcharlt each branch that has a copy of that title, at any rate 16:39 cau0730 well i think that is what we want then 16:41 cau0730 so does the biblio even contain the lcn... cause what i am seeing right now it does not 16:43 cau0730 also is there better flag support in koha 3... the guy here before tied certain patrons to certain pages... i want to change that so that say if i have masterlibririan set that that means i can do everything.... superlibririan can do most things, but can't add marcs... and so on 21:46 pianohacker Hello