April 2004 - Koha-devel - lists.koha-community.org

Duplicate items in MARC tables
by Baiju M 13 Apr '04

13 Apr '04

Hi, When I imported some MARC records to Koha using bulkmarcimport.pl (I am using Koha 2.0.0) I get duplicate items in MARC tables (items just doubles in 'marc_subfield_table', but not in 'items' table) A portion from database dump : INSERT INTO marc_subfield_table VALUES (70064,3524,'952',8,'','p',3,'34511',NULL), (70065,3524,'952',8,'','u',5,'34511',NULL), (70066,3524,'090',9,'','c',1,'3524',NULL), (70067,3524,'090',9,'','d',2,'3524',NULL), (70068,3524,'952',10,'','b',1,'MAIN',NULL), (70069,3524,'952',10,'','d',2,'MAIN',NULL), (70070,3524,'952',10,'','p',3,'34511',NULL), (70071,3524,'952',10,'','u',5,'34511',NULL), (70072,3524,'952',10,'','u',7,'4339',NULL), (70073,3525,'100',1,'1','a',1,'David W Lindsay',NULL), (70074,3525,'245',2,'12','a',1,'English poetry 1700-1780',NULL), (70075,3525,'300',4,'','f',2,'BOOK',NULL), (70076,3525,'590',5,'','a',1,'ED',NULL), (70077,3525,'700',6,'1','a',1,'',NULL), (70078,3525,'852',7,'','k',1,'999.9997',NULL), (70079,3525,'852',7,'','h',2,'L4',NULL), (70080,3525,'952',8,'','b',1,'MAIN',NULL), (70081,3525,'952',8,'','d',2,'MAIN',NULL), (70082,3525,'952',8,'','p',3,'34514',NULL), (70083,3525,'952',8,'','u',5,'34514',NULL), (70084,3525,'090',9,'','c',1,'3525',NULL), (70085,3525,'090',9,'','d',2,'3525',NULL), (70086,3525,'952',10,'','b',1,'MAIN',NULL), (70087,3525,'952',10,'','d',2,'MAIN',NULL), (70088,3525,'952',10,'','p',3,'34514',NULL), (70089,3525,'952',10,'','u',5,'34514',NULL), (70090,3525,'952',10,'','u',7,'4340',NULL), See 952 'p' & 'u' repeats and 'u' not only repeats it gets one more value. Now, I just started looking to source codes. When I looked into bulkmarcimport.pl I found the last for loop creates this problem : for (my $i=0;$i<=$#items;$i++) { NEWnewitem($dbh,$items[$i],$bibid); } When I just commented this for loop, the problem in 'marc_subfield_table' got fixed. But then, there was no items in 'items' table. If this is really a bug, will try to fix it myself. Could anyone give any pointer? Now I am trying to explore it more, here is some other clues I got. NEWnewbiblio function creates bibio and items in MARC tables (and only bibio in NON-MARC tables) my ($bibid,$oldbibnum,$oldbibitemnum) = NEWnewbiblio($dbh,$newRecord); NEWnewitem function creates items in both MARC and NON-MARC tables, in addition to that it also creates one more 952 'u' for each item(?). NEWnewbiblio function is calling from acqui.simple/addbiblio.pl (Here it will not create any items, just because there is no items) ($bibid,$oldbibnum,$oldbibitemnum) = NEWnewbiblio($dbh,$record); So, I think NEWnewbiblio cannot use in bulkmarcimport.pl as in the case of addbiblio.pl Atleast it should have a parameter not to add 952 fields(?) NEWnewitem function is calling from acqui.simple/additem.pl my ($oldbiblionumber,$oldbibnum,$oldbibitemnum) = NEWnewitem($dbh,$record,$bibid) and this function should use to add items everywhere(including bulkmarcimport). See, I am just started looking to Koha source code, so my observation maynot be correct. With thanks and regards, Baiju M ____________________________________________________________ Find what you are looking for with the Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.as…

2 1

RE: unoffical Koha documents (was [Koha] Any Indian users?)
by Stephen Hedges 11 Apr '04

11 Apr '04

Hi, Nicholas - Nicholas S. Rosasco said: > Baiju, Steve, > The kind folks at http://www.skemotah.com/ - thank you Steve! - have > posted your material relating to koha, and are (de facto) functioning > nicely > indeed, I'd like to formally place this material at koha.org and in the > documentation & manual. The "official" documentation currently lags, and > your efforts will let me jump start the production of the 2.0 manual. > I'll > confess to stalling on a couple of times on that! > > However, to do that, I'm in need of explicit OK's from you - > preferably in the form of releasing your efforts under something like the > GPL or the Gnu Documentation License You certainly have my permission to use the "Migrating to Koha" document. At the end of the document I placed a notice (which I think I essentially stole from you!) releasing the document under the terms of the LDP. If you would like to have that changed in any way to be more flexible, just let me know. -- Stephen -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com

1 0

strange problem with passing $dbh value
by Stephen Hedges 09 Apr '04

09 Apr '04

I need a clue... I'm having a problem with import of bulk MARC records. We just moved all the Nelsonville Library Koha stuff to a new machine on Sunday, where we are now using the new 2.0 release. (Our old production machine had a pasted together collection of Koha stuff, some of it 7 months old.) In the process we also moved our MARC import script. Now something weird is happening. When I try to run the script as any user other than root, it fails because the bulkmarcimport call to the &MARCfind_marc_from_kohafield function in Biblio.pm is not passing the $dbh value. So Biblio.pm throws a 'no database' error: DBD::mysql::st execute failed: No Database Selected at /usr/local/koha/intranet/modules//C4/Biblio.pm line 258. (same error happens later in the script at Biblio.pm line 858) If I "su" to superuser and try running the script again, it works. (On our old machine, it worked either way.) The script is getting the value of $dbh from Context.pm without any problem. It just doesn't seem to pass the value to Biblio.pm unless the script is run by the superuser. All the Koha module permissions look OK (755) -- although that shouldn't even be a factor. I don't think this is a bug, I think I'm just overlooking something. Does anybody have any suggestions? -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com

4 4

Check list report patch
by Baiju M 05 Apr '04

05 Apr '04

Hi, I have checked new plugin based frameworks for reports in CVS head. I also just created few other reports for 2_0 release (its requied for my librarian). http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=738 http://bugs.koha.org/cgi-bin/bugzilla/showattachment.cgi?attach_id=34 Please test the patch if you are going to apply it into 2_0 branch. PS. I am just learning perl,CVS, Bugzilla etc. Regards, Baiju M ____________________________________________________________ Find what you are looking for with the Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.as…

1 0