[Koha] Importing data into MARC

[Andres Tarallo]

Baljkas Family wrote:

>[..]
>
>As for your databases, I suppose the solution you would want would bring the copy specific information in the second database into the title specific records of the first.
>  
>
The first idea that came to my mind was merging records from the Title
databse with the records i have in the databse were i have purchase
information.

>Perhaps someone else on the listserv can suggest/help write a script that could merge the databases. 
>  
>
I'm currently working on that, i was a litle delyaed because for some
reason one of our databases had some garbage that prevented me from
reading correctly the record, now i'm on track.

>How many records are we talking about? And how many fields of information do you want/need preserved from the second database with the purchase info?
>  
>
i have to libraries with about  30.000 record each.  The titles datasbes
has an average of 21.000 records the purchase database has about 30000,
meny titles are repeated and we just keep there five or six fields that
are relevant for purchases.

>In terms of MARC coding solutions, would the 852 field suffice alone? The $z subfield is repeating.
>  
>
Maybe, I'm not a MARC expert, we need to keep track of the purchase
information.

>There is also the 541 note which is repeating and could be incorporated to contain more copy-specific information with defined subfields. Check that out at URL <http://www.loc.gov/marc/bibliographic/ecbdnot2.html#mrcb541>.
>  
>
It's becoming like my pillow :), at the same time I have to map our
current Isisi datasbe in CEPAL layout to Marc21.

>Take a look at the Holdings information at URL <http://www.loc.gov/marc/holdings/echditem.html> ; this gives guidance on embedding holdings information, i.e. including an 876 note within each MARC record for an item.
>
>You would be repeating the 852 field (and/or 541) for each different copy of the item within the item record and (keeping in mind that I've never had to do this but from my reading) you would be linking these to their corresponding 876 notes (which have enough fields available for fairly detailed acquisitions data) using the $8 to clarify which item was meant (I suppose the bar code would be the natural choice).
>  
>

This week I'm working in mapping CEPAL ==> MARC21, with some help from
the librarians. We were somewhat stuck becouse in CEPAL laoyuot we have
a filed coded 002 were we have an inventory number: it seems to us that
this maps to field 035 of MARC21.

You'll here from me soon.


                                                                Andres