[OPEN-ILS-DEV] import data from voyager

[Jason Zou]

Mike Rylander wrote:
> On 5/24/07, Jason Zou <qzou at lakeheadu.ca> wrote:
>> Hi everyone,
>>
>> By using scripts in the Open-ILS/src/extra/import/, I imported about
>> 11,000 MARC records. Although the process was very slow, it seems that
>> it is working. And records have been added into the following tables:
>>           biblio.record_entry
>>           metabib.rec_descriptor
>>           metabib.full_rec
>>           metabib.title_field_entry
>>           metabib.author_field_entry
>>           metabib.subject_field_entry
>>           metabib.keyword_field_entry
>>           metabib.series_field_entry
>>
>> But when I tried to use OPAC to find some records, I always got nothing.
>> I am wondering whether there are something that I missed out.
>>
>> Any suggestions are highly appreciated.
>
> By default, records are required to have items attached in order to be
> visible in the public opac -- though they will show up inside the
> Staff Client with shading to indicate that they aren't publicly
> visible.  If that's of no concern in this case, you can run the
> following directly against the database:
>
> evergreen# UPDATE biblio.record_entry SET source = 3;
> evergreen# VACUUM ANALYZE biblio.record_entry;
>
> The second statement isn't strictly required, but it's a good idea.
> In fact, if you haven't already, you probably want to just go ahead
> and run
>
> evergreen# VACUUM ANALYZE VERBOSE;
>
> to clean up everything.
>
> Anyway, what the UPDATE does it make the records as "transcendent" so
> they will show up in every location, with or without holdings
> attached.  The main use case is for globally available electronic
> materials, and the functionality will probably end up being extended
> to be location-specific.
>
> --miker
>
>>
>> Jason
>>
>> Lakehead University
>>
>>
>
Thanks Miker.

Now I can see those records in OPAC.

Jason

Lakehead University