thanks, Katrin, I think that's what I needed to know.
On Tue, Mar 4, 2014 at 8:55 AM, Fischer, Katrin <katrin.fisc...@bsz-bw.de>wrote: > 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-boun...@lists.katipo.co.nz [mailto:koha- > > boun...@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@lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > -- 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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha