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