[Koha] Vendor number in serials records

[Fischer, Katrin]

Hi Elaine,

when you use the serials module, the link to the vendor goes into the subscription table - subscription.aqbooksellerid. Not sure if this is what you were looking for.

Katrin


> -----Original Message-----
> From: koha-bounces at lists.katipo.co.nz [mailto:koha-
> bounces at lists.katipo.co.nz] On Behalf Of Elaine Bradtke
> Sent: Monday, March 03, 2014 8:43 PM
> To: koha; Doug Kingston
> Subject: [Koha] Vendor number in serials records
> 
> We have over 200 active serial subscriptions, and 195 different vendors (ah,
> the joys of an esoteric collection). The vendor information has been
> successfully converted and uploaded to our test site. This in turn generated
> vendor numbers, which have been extracted so we know which serial should
> link to what vendor number.
> It would be a simple thing to add these vendor numbers to the serials
> records during the conversion process prior to upload.  But, unless I'm
> missing something, this number doesn't go into the MARC record.  If it does,
> what field (MARC 21)?
> 
> Where would the vendor number need to go in order to add the vendor number
> to the incoming serials records? Another table in the database?
> 
> I hope this is doable, otherwise my colleague who deals with the serials is
> going to have a tedious job manually linking them.
> 
> --
> Elaine Bradtke
> Data Wrangler
> VWML
> English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp
> House, 2 Regent's Park Road, London NW1 7AY
> Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send an
> e-mail first. I work off site)
> --------------------------------------------------------------------------
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
> ---------------------------------------------------------------------------
> "Writing about music is like dancing about architecture"
> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
> _______________________________________________
> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>