Author: lmorgan Posted: Fri Nov 20, 2009 1:39 pm (GMT 0) Topic Replies: 3 I'd second what's being said here. From what I understand there is a tick box to make certain information visible to us (the customer) and this tick box doesn't always get ticked. We can usually spot these because the last updated ...

Author: jerome Posted: Fri Nov 20, 2009 3:38 pm (GMT 0) Topic Replies: 1 The postponed meeting of the Southern section of the Talis User Group, which had been due to take place on 11th November, will now take place at 2.00pm on Wednesday 20th January at the University of Greenwich. More details to follow ...

Author: Mary Hough Posted: Fri Nov 20, 2009 10:39 am (GMT 0) Topic Replies: 2 I know it is some time since this question was raised but this is a report I am struggling with! I have been asked to produce numbers of borrowers who have only used one particular site over the past six months. I have run ...

Author: Urszula Subject: Talis Training Update Posted: Thu Nov 19, 2009 3:47 pm (GMT 0) Topic Replies: 0 This is to advise that there are limited spaces still available on the following Talis Training events: 24th November Using Talis Decisions A refresher on reporting basics (webinar) 25th November ...

Author: Esther Arens Posted: Thu Nov 19, 2009 3:55 pm (GMT 0) Topic Replies: 3 Browsing sounds good but since we only got auth ctrl some time post-Lyra I don't know any better. I'm the only 'authorisor' too and still struggling with the reports. I've just opened a service call but could I perhaps contact ...

Author: Esther Arens Posted: Thu Nov 19, 2009 3:06 pm (GMT 0) Topic Replies: 3 Hi Kate, as I understand it all subfields in authorisable fields are included in the matching, so yes differing dates will require a new auth rec. I've been wondering how other customers cope with this. At the moment we just ...

Author: Kate Bunting Posted: Thu Nov 19, 2009 3:37 pm (GMT 0) Topic Replies: 3 I find the inclusion of field 240 very irritating too. I don't attempt to authorise anything except names, because I'm the only person here checking authority reports and I don't have the time to deal with more than one! ...

Author: TGRIFFIN Posted: Thu Nov 19, 2009 9:43 am (GMT 0) Topic Replies: 4 D'oh! Tried it and it works perfectly. Many thanks for this, Brian!

Author: Brian Crampton Subject: item updates Posted: Thu Nov 19, 2009 9:08 am (GMT 0) Topic Replies: 3 The script should be Code: echo echo "Script started" date echo isql -Usa -P -o/scratch/mdi_archived.out <<-END use prod_talis go UPDATE ITEM set STATUS_ID = 117 where STATUS_ID = 5 and WORK_ID ...

Author: Brian Crampton Subject: Changing item status via SQL Posted: Thu Nov 19, 2009 8:29 am (GMT 0) Topic Replies: 3 I can't see anything inherently wrong with the SQL but it would be useful to know what, if anything, is returned when running the SQL. Thanks _________________ Brian Crampton Consultant, ...