IRC log for #koha, 2007-03-31

All times shown according to UTC.

Time S 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?

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary