[Koha] how to connect MARC records to a branch?

Jeffrey LePage jeffrey_lepage at yahoo.com
Tue Dec 9 09:49:48 NZDT 2008


Thanks for the quick response:



Joe said...
> I think you may be misunderstanding the problem.   It
> appears you have
> imported MARC data for biblio records, but not (item)
> holdings...

Yes, I have imported MARC records.  8038 records to be precise, which matches what I expected.

Also, when I search the catalogue I DO get results.  However, on the results page the Location column just says "No Items".  When I click on an individual item, the Holdings tab shows "No physical items for this record".  However, I can edit an item and assign it a "Current location". 

As you say, I have bibliographic records, but no item records.  I'd like to be able to tell Koha:
For each of those MARC records I gave you earlier, please create an entry stating that x copies are currently at my library branch.  And also, please use my barcodes.

 
> 
> The difference you report between STAFF and OPAC results
> suggests that you
> may not have moved the imported records out of the
> reservoir.  

I'm seeing no difference in the data between STAFF and OPAC; I merely meant that I'm working in STAFF right now and haven't checked OPAC. 


> So basically what you need to do is import items data.  I don't know what
> means are available to you in Sagebrush Athena to extract that info, if > you haven't already.

Assuming that I could get Athena to give me items info (rather than the bibliographic data contained with the MARC records), how would I go about importing this?

Athena exports MARC records in what it claims is an ISO2709/MARC21 file.  It claims to always export the same data, but it does allow you to order the data differently (by barcode, call #, etc).  

I used tools -> Stage Marc Records for Import
Then i used tools -> Managed Staged Records -> import into catalogue.

After a _very_ long time, 'import into catalogue' completed.  I can search the catalogue, and I see the books.  Yay.




> 
> --Joe
> 
> On Mon, Dec 8, 2008 at 1:44 PM, Jeffrey LePage
> <jeffrey_lepage at yahoo.com>wrote:
> 
> > Hello,
> >
> > First, an intro:
> > These days I do database stuff for a living, mostly
> Oracle.  I spent a year
> > doing web coding professionally: LAMP, where P=Perl. 
> I'm installing Koha
> > for a small charter school.  It's replacing
> Sagebrush  Athena.
> >
> > Now my problem:
> > I successfully installed Koha and imported MARC
> records from Sagebrush
> > Athena.  I can see the records in the database tables
> biblio and
> > biblioitems.  I can also see the records when I
> "Search the Catalog" from
> > the administrative site (not the OPAC).  However, the
> location column in the
> > search results page says "No Items".
> >
> > If I understand the schema correctly, the items table
> has info regarding
> > barcode, holdingbranch, homebranch.  My items table is
> EMPTY.  How do I tell
> > the system that all my marc records have
> holdingbranch=homebranch=<my
> > library> ?
> >
> > Thanks,
> > Jeff LePage
> >
> >


      


More information about the Koha mailing list