Perfect. Thanks,
Adam Ray SLCC IT Director (314) 837-6777 x1250 ----- Original Message ----- From: "Mike Rylander" <[email protected]> To: "Evergreen Discussion Group" <[email protected]> Sent: Friday, April 10, 2009 8:07:35 AM GMT -06:00 US/Canada Central Subject: Re: [OPEN-ILS-GENERAL] MARC Imports On Fri, Apr 10, 2009 at 2:52 AM, Adam Ray <[email protected]> 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" <[email protected]> > To: "Evergreen Discussion Group" > <[email protected]> > 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 <[email protected]> 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" <[email protected]> >> To: "Evergreen Discussion Group" >> <[email protected]> >> 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: [email protected] >> | 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: [email protected] > | 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: [email protected] | web: http://www.esilibrary.com
