Time Nick Message 14:54 kyle hey all 14:55 paul hey kyle 14:55 kyle I have a question you may be able to answer 14:55 paul throw it 14:56 kyle I'm writing a perl script that will delete all biblios that have no items attached, I'm puting it in koha/utils as that seems an appropriate place for it to go, 14:56 paul right 14:56 kyle but when I run it, it can't locate the C4 perl modules 14:56 kyle what should I do? 14:56 paul it's a web based script ? 14:57 paul or a command line one ? 14:57 kyle I figure I'd attach it to a button somewhere in koha AND have it run nightly as a cron job 14:57 paul to run it as cron job, you need to EXPORT PERL5LIB=/path/to/koha 14:58 paul (or perl -l /path/to/koha ) 14:58 paul ( and it's not koha/utils/ but koha/tools/ ) 14:59 paul I don't see how you'll be able to have a script running on command line AND on web interface. 14:59 paul because to run on web interface, you need to have auth enabled. 14:59 paul and on cron you can't/don't need it 15:00 kyle I can have it check for a command line argument, and if it doesn't find it, output html 15:00 paul OK 15:00 paul don't forget some libraries also catalogate websites. 15:00 kyle can you give me more detail? 15:00 paul so you should be able to avoid removing some biblios even if they don't have any item attached 15:00 kyle will this cause a problem with the script. 15:01 kyle is there anything in the biblio that defines if it is a website link? 15:01 paul for example, add a parameter to limit the script to a given itemtype 15:01 kyle so websites have an itemtype of say 'WEB' 15:01 paul for example 15:02 kyle that shouldn't be hard to add, I can have it check command line and form variables for itemtypes to ignore. 15:05 kyle I'm testing it and when I try to run DelBiblio I get a failure message for each one: 224 ES: immediate execuation failed. 15:06 kyle nevermind, I typed a var wrong. 15:07 kyle now I'm getting: Undefined subroutine &C4::Search::itemissues called at C4/Biblio.pm line 440. 15:07 kyle I probably just have to include C4::Search in my script. 15:08 kyle fixed that, now I'm getting: DBD::mysql::st execute failed: Unknown column 'lcsort' in 'field list' at C4/Biblio.pm line 2320. 15:08 kyle I'm just having all kinds of fun ; ) 15:08 paul lcsort... I think it's a LibLime column ;-) 15:08 kyle should I fix it? 15:11 kyle I suppose all I have to do is add the column lcsort to my deleteedbiblioitems table 15:17 kyle paul: assuming this script is only run from the command line, where should I put it? 15:17 paul koha/misc/cronjobs 15:18 kyle thanks. 18:00 kyle I finished the script, it's call scrub_orphaned_biblios.pl and is in /misc in dev_week 23:29 chris kyle you about?