Create lists - bibliographic and item level call numbers

[Colleen Cleary <c.cleary@xxxxxxxxxx>]

Hello INNOPAC users,

When I output a list (I've tried both bib and item lists) I get all
attached items and not just the items associated with a particular
bibliographic location.     Can anyone advise if
it is possible to output a list of item records associated with a
particular bibliographic location only and no other item records
associated with other bibliographic locations?   I hope I
am missing the obvious.    If not, we are looking at some
reasonably complex programming after the output list stage and  any
help with that angle would also be appreciated.  The background to
this query is below:

QUT Library stores call numbers in the bibliographic and item records
because we use two different classification systems (Moyes for Law
Library, Dewey for the other Branch libraries).   Generally,
the Dewey classification is stored in the bibliographic record  and
the exception Moyes classification in the item record.  However,
while we have more recently endeavoured to follow this principle, this
was not always the case in the early post-implementation stage and
consequently storage of call numbers can be vice-versa - depending upon
which Branch purchased a copy first.

 We are trying to output our records to our national database
Kinetica and will be creating four separate output files, one for each
Branch library.   For each bibliographic location (equivalent
to each Branch) we need to create a file consisting of one only 984
record per marc record to show that the item is held by the Branch. 
The 984 is a simple combination of a subfield created from the BIB LOCN
for the Branch National Union Catalogue symbol (eg. QUT-L) and a subfield
for the call number drawn from the bib or item record as 
applicable.

Below is a segment of my current output to create the 984's for your
perusal.  I am thinking that if programming is the only way to
achieve this, that we will also have to accept as incorrect those call
numbers output in those instances where we have been inconsistent with
our application of the bib/item level call number rule.  The logic I
am currently planning is as follows, in the absence of a better
idea:

To create the 984 for BIB LOCN = k, c and g use the CALL NO = field
immediately after the BIB LOCN = or LOCATIONS = field.
To create the 984 for BIB LOCN = l do the following:
If there is a CALL NO = field after the ITEM LOCN = field,  use the
CALL NO = field which appears after the ITEM LOCN = field.  
Otherwise, use the CALL NO = field which appears after the BIB LOCN = or
LOCATIONS = field.

Any better ideas?

Sample from output:
RECORD # = b10000409. BIB LOCN = l. 
CALL NO = 340.11509944 1. 
ITEM LOCN = lgen. 
CALL NO = 345.069944 TOMA. 

RECORD # = b10001062. LOCATIONS = g,l. 
CALL NO = 346.940488 2. 
ITEM LOCN = ggen. 
ITEM LOCN = lgen. 
CALL NO = 347.3772 SHAN. 

RECORD # = b10001098. LOCATIONS = g,l. 
CALL NO = 344.095 2. 
ITEM LOCN = ggen. 
ITEM LOCN = lgen. 
CALL NO = 340.16 KIRB. 

RECORD # = b10001116. LOCATIONS = g,l. 
CALL NO = 423 40. 
ITEM LOCN = gref. 
ITEM LOCN = lref. 
CALL NO = 423 MACQ. 

RECORD # = b10003563. LOCATIONS = c,g,k,l. 
CALL NO = 321.020994 3. 
ITEM LOCN = cgen. 
ITEM LOCN = g7day. 
ITEM LOCN = ggen. 
ITEM LOCN = ggen. 
ITEM LOCN = ggen. 
ITEM LOCN = kgen. 
ITEM LOCN = lgen. 
CALL NO = 321.020994 AUST. 

RECORD # = b10005596. LOCATIONS = c,k,l. 
CALL NO = 306.890994 2. 
ITEM LOCN = cgen. 
ITEM LOCN = cgen. 
ITEM LOCN = cgen. 
ITEM LOCN = cgen. 
ITEM LOCN = kgen. 
ITEM LOCN = lgen. 
CALL NO = 306.890994 MACN. 
ITEM LOCN = llegp. 
CALL NO = 306.890994 MACN. 



RECORD # = b10007714. LOCATIONS = c,g,k,l,s. 
CALL NO = 994.031 1. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 
ITEM LOCN = gref. 
ITEM LOCN = gref. 
ITEM LOCN = gref. 
ITEM LOCN = gref. 
ITEM LOCN = gref. 
ITEM LOCN = gref. 
ITEM LOCN = gref. 
ITEM LOCN = gref. 
ITEM LOCN = gref. 
ITEM LOCN = gref. 
ITEM LOCN = gref. 
ITEM LOCN = gref. 
ITEM LOCN = gref. 
ITEM LOCN = sper. 
ITEM LOCN = sper. 
ITEM LOCN = sper. 
ITEM LOCN = sper. 
ITEM LOCN = sper. 
ITEM LOCN = sper. 
ITEM LOCN = kref. 
ITEM LOCN = kref. 
ITEM LOCN = kref. 
ITEM LOCN = kref. 
ITEM LOCN = kref. 
ITEM LOCN = kref. 
ITEM LOCN = kref. 
ITEM LOCN = kref. 
ITEM LOCN = kref. 
ITEM LOCN = kref. 
ITEM LOCN = kref. 
ITEM LOCN = kref. 
ITEM LOCN = kref. 
ITEM LOCN = kgen. 
ITEM LOCN = cgen. 
ITEM LOCN = cgen. 
ITEM LOCN = cgen. 
ITEM LOCN = cgen. 
ITEM LOCN = cgen. 
ITEM LOCN = cgen. 
ITEM LOCN = cgen. 
ITEM LOCN = cgen. 
ITEM LOCN = cgen. 
ITEM LOCN = cgen. 


ITEM LOCN = cgen. 
ITEM LOCN = lref. 
CALL NO = 994.031 AUST. 
ITEM LOCN = lref. 
CALL NO = 994.031 AUST. 
ITEM LOCN = lref. 
CALL NO = 994.031 AUST. 
ITEM LOCN = lref. 
CALL NO = 994.031 AUST. 
ITEM LOCN = lref. 
CALL NO = 994.031 AUST. 
ITEM LOCN = lref. 
CALL NO = 994.031 AUST. 
ITEM LOCN = lref. 
CALL NO = 994.031 AUST. 
ITEM LOCN = lref. 
CALL NO = 994.031 AUST. 
ITEM LOCN = lref. 
CALL NO = 994.031 AUST. 
ITEM LOCN = lref. 
CALL NO = 994.031 AUST. 
ITEM LOCN = lref. 
CALL NO = 994.031 AUST. 
ITEM LOCN = lref. 
CALL NO = 994.031 AUST. 
ITEM LOCN = cref. 
ITEM LOCN = cref. 

RECORD # = b10008937. BIB LOCN = l. 
CALL NO = 808.02 108 /3. 
ITEM LOCN = lref. 
CALL NO = 808.02 STYL. 

RECORD # = b1001035x. LOCATIONS = c,g,k,l. 
CALL NO = 364.155 2. 
ITEM LOCN = cgen. 
ITEM LOCN = ggen. 
ITEM LOCN = kgen. 
ITEM LOCN = kgen. 
ITEM LOCN = lgen. 
CALL NO = 346.985 POLI. 

Thanks for your advice.

Ms Colleen Cleary

INNOPAC Coordinator

Queensland University of Technology Library

Kelvin Grove Campus

Victoria Park Road

Kelvin Grove QLD 4059 AUSTRALIA

ph. 61 7 3864 5577

fax. 61 7 3864 3994

email: c.cleary@xxxxxxxxxx