[OPEN-ILS-GENERAL] MARC Imports

[Mike Rylander]

On Fri, Apr 10, 2009 at 2:52 AM, Adam Ray <aray at slcconline.edu> wrote:
> OK, so it seems that they are imported now. I have 12,550 records in the
> biblio.records_entry table, but I still am unable to search for anything in
> the staff client. What else do I need to do in order to make the records
> visible to the search?

Step 5 in the Project Gutenberg example is:

-------------------

psql -U postgres evergreen
# \i Evergreen/src/extras/import/quick_metarecord_map.sql

This creates the metarecord entries in the database that are necessary
for placing holds and grouping volumes and editions. Of course, with
the Gutenberg records there are no volumes, copies, ISBNs, or other
metadata, so these features will not make any visible difference with
this data set.

-------------------

You can use that script for the first, full batch load of records, or
use the variant here, which is safe for use in a live system if you
just added records:

http://open-ils.org/dokuwiki/doku.php?id=scratchpad:random_magic_spells#how_to_generate_metarecords_for_a_newly_loaded_bib_batch

--miker

>
> Thanks,
>
> Adam Ray
> SLCC IT Director
>
>
>
> ----- Original Message -----
> From: "Mike Rylander" <mrylander at gmail.com>
> To: "Evergreen Discussion Group"
> <open-ils-general at list.georgialibraries.org>
> Sent: Thursday, April 9, 2009 7:30:02 PM GMT -06:00 US/Canada Central
> Subject: Re: [OPEN-ILS-GENERAL] MARC Imports
>
> On Thu, Apr 9, 2009 at 4:01 PM, Adam Ray <aray at slcconline.edu> wrote:
>> OK, so I changed to the parallel_pg_loader.pl that was in the import_demo
>> folder and it appears to have started working, but now I get:
>>
>> SET
>> BEGIN
>> COPY
>> COPY
>> COPY
>> COPY
>> COPY
>> COPY
>>
>> This has been followed by 2 1/2 hours of 100% CPU usage which is still
>> running.
>> Is it working or is something wrong?
>
> It's running the commit.  Postgres checks referential integrity
> constraints at commit time (ref checks are deferred by default) and
> depending on the speed of the server, the amount of RAM, the
> configuration of Postgres and the size of the dataset you're loading,
> it can take a while.
>
> --miker
>
>>
>> Adam Ray
>> SLCC IT Director
>>
>> ----- Original Message -----
>> From: "Jason Etheridge" <jason at esilibrary.com>
>> To: "Evergreen Discussion Group"
>> <open-ils-general at list.georgialibraries.org>
>> Sent: Thursday, April 9, 2009 11:08:47 AM GMT -06:00 US/Canada Central
>> Subject: Re: [OPEN-ILS-GENERAL] MARC Imports
>>
>>> So you should enter after you get the # prompt back.
>>
>> Enter
>>
>>   COMMIT;
>>
>> that is.
>>
>> --
>> Jason Etheridge
>>  | VP, Community Support and Advocacy
>>  | Equinox Software, Inc. / The Evergreen Experts
>>  | phone:  1-877-OPEN-ILS (673-6457)
>>  | email:  jason at esilibrary.com
>>  | web:  http://www.esilibrary.com
>>
>
>
>
> --
> Mike Rylander
>  | VP, Research and Design
>  | Equinox Software, Inc. / The Evergreen Experts
>  | phone:  1-877-OPEN-ILS (673-6457)
>  | email:  miker at esilibrary.com
>  | web:  http://www.esilibrary.com
>



-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com