Forums

Can anyone point me in the right direction for adding new collections in Prism 3?

If I schedule a report to be saved in the original file location, the filename changes once it has run (and CMC shows it ran successfully), but there is no data. The data from any previous instance was purged before I started. 'Refresh'just seems to run it again.

Has anyone any advice on how to create half hourly issue statistics? I've managed to break it down into hours fairly easily but would like to break it down either further into half hourly timeslots, such as 09.00-09.29, 09.30-9.59, 10.00-10.29 etc.
Thanks

We are trying to automate the process of emailing the output from res_itm_noloan to the various libraries. In order to do this, we need to have the email address of each site appearing on the list in the output from this script.

We have added the following to retrieve.pl for res_itm_noloan:

($LocationEmailAddress) = &sql($d, "
select E_MAIL_NO
from LOCATION_ADDRESS
where LOCATION_ID = '$active_site_id'
") ;

We have revised our run of Borrower Anonymiser (Nony) to include borrowers with loans. However I have noticed that Nony does not quite go far enough in that it does not change the status of the items that it discharges. Therefore stock that we are never going to get back are still listed as being in stock. What I would like to be able to do is strip just the item barcodes from the Nony report file and import this into a script so that I can change the item status. Any ideas on how to do this would be gratefully received.

Thanks.

Rach
Rachel Underwood
Northamptonshire Libraries

I have a list of 20,000+ barcodes and need the bibliographic information related to each one.

Does anyone know if this is this possible via Decisions or another script?

Thanks in advance

Jamie

I have a list of 20,000+ barcodes and need the bibliographic information related to each one.

Does anyone know if this is this possible via Decisions or another script?

Thanks in advance

Jamie

From the Orders universe, I am trying to get at invoice totals and invoice charge totals, broken down by expenditure code.

At the moment, from the Orders Universe, I have:
Suppliers-Supplier Name

Invoices-Invoice Date, Invoice Number

Fund Accounting-Expenditure Code(base)

Invoices-Item net(base currency)

Is there any way I can pull in totals for invoice charges (i.e. amount paid) (as seen on the 'Invoice Charges' tab on the Alto invoice screen).

I can't seem to see this anywhere in the orders universe, but it may be possible by freehand SQL?

Thanks
Mark