Vendor records (supplier's contact info) import
We don't use a jobber or any other sort of centralized system of purchasing. All our subscriptions are done on an individual basis through the publisher. Which means we have a large number of vendors that have to go into the system in order for us to set up subscriptions and track incoming serials, etc. All the relevant information is present in our old database system . I would dearly love to be able to bring it into Koha without having to retype everything. koha/acqui/supplier.pl seems to be what governs this chunk of information. Is there a list somewhere of the relevant tags/fields that we need to map our data to Koha? Has anyone done this sort of thing? -- 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)
Elaine Bradtke schreef op ma 16-12-2013 om 18:44 [+0000]:
All the relevant information is present in our old database system . I would dearly love to be able to bring it into Koha without having to retype everything.
koha/acqui/supplier.pl seems to be what governs this chunk of information. Is there a list somewhere of the relevant tags/fields that we need to map our data to Koha?
You certainly can, though you'll have to insert it directly into the database. The table you want to put the data into is aqbooksellers, and the schema is here: http://schema.koha-community.org/tables/aqbooksellers.html you could probably do something like convert your existing data to a spreadsheet and import that directly into mysql, or write a script that'll convert the data and put it straight in for you (which is how I usually do this.) -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
participants (2)
-
Elaine Bradtke -
Robin Sheat