I think you may be misunderstanding the problem. It appears you have imported MARC data for biblio records, but not (item) holdings. So you should not attempt to insert "ownership" of the MARC biblio record for your single branch. Though you can represent things about branches in MARC, it won't really help your problem, since you will still not have any items and will get empty results. <br>
<br>The difference you report between STAFF and OPAC results suggests that you may not have moved the imported records out of the reservoir. Otherwise that behavior would be unexpected. Check Tools > Manage Staged Records if you used the staged records upload. It should identify how many items it found in the given upload. Confirm that number matches the number you expect.<br>
<br>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.<br><br>--Joe<br><br><div class="gmail_quote">
On Mon, Dec 8, 2008 at 1:44 PM, Jeffrey LePage <span dir="ltr"><<a href="mailto:jeffrey_lepage@yahoo.com">jeffrey_lepage@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello,<br>
<br>
First, an intro:<br>
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.<br>
<br>
Now my problem:<br>
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".<br>
<br>
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> ?<br>
<br>
Thanks,<br>
Jeff LePage<br>
<br></blockquote></div>