Andres, use the regularly defined MARC tags (depending on your MARC flavor) to store the data from your "title" database. Store the information from your "copy" database in holdings tags (in MARC21 either 852 or a user-defined 9xx tag). The holdings tag is repeatable, each repetition containing the information for one copy. So if you have three copies of a title, your (very abbreviated) MARC21 record might look like: 100 Author 245 Title 852 Copy 1 info 852 Copy 2 info 852 Copy 3 info Are you using MARC::Record to build the records for import? Stephen Andres Tarallo said:
We're currently finishing our mapping to import our database (CEPAL catalog in DOS/ISIS) to Koha. We have a question, and we want to know the best solution to feed data for bulkmarcimport.pl.
Our library has two databases. The first one has a detailed description of each title avaliable in the library; this database has one record for each title we have, no matter how many copies of it we have. The second one has all the purchase information, in this database you have one record for every copy of a book you have. Both databases are releted via a pointer in the first one that references the records of the second one.
Now, we don't want to lose information and we're facing that many of our books have many copies, so we want to know whats the best way to build our MARC records, A record with full information from both databases for each book we have?
Thanks for your feedback
Andres
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com