Yamil, First, and most importantly, skip step 1 as that's bib-only.
Then replace references to biblio.record_entry with authority.record_entry in steps 2-4, and proceed. Also, please do test that on non-production data first! Let us know if that goes well for you. --miker On Thu, Jun 27, 2013 at 3:31 PM, Yamil Suarez <[email protected]> wrote: > > On Jun 25, 2013, at 4:41 PM, Mike Rylander <[email protected]> wrote: > >> On Tue, Jun 25, 2013 at 4:26 PM, Yamil Suarez <[email protected]> wrote: >>> Mike, >>> >>> Thanks for looking into this. Can you or anyone else tell me if I can just >>> re-declare the two updated stored procedures (see below) and re-ingest the >>> auth records on my test server to see the code in action? I guess I can >>> just build a new test VM, but I want to know if I have another option. >>> >> >> That would be a great test. Just make sure that you enable the >> force_on_same_marc internal flag. >> >>> Also, I made a mistake in my example when I placed the "Jazz England" auth >>> record at the bottom. Thanks for catching that Mike. >>> >> >> Good. I'm glad we were on the same page all along! >> >> --miker > > > Mike, > > Before I do the re-ingest I wanted to run a few things by you or others. Here > I am pasting some re-ingest instructions I put together from information I > got form you over time. Though I will replace "biblio.record_entry" for > "authority.record_entry" in the instructions. > > I am not sure how to "enable the force_on_same_marc internal flag," though > these instructions might do it already. > > Also, my understanding is that these instructions are supposed to be designed > to allow me to run re-ingest while still allowing the EG server to be usable > by patrons by allowing batching, etc. In this particular case I am using a > tests server so I can be as aggressive as I want. Is there a different way I > can use to get the re-ingest done faster than this approach? > > > ------------------- > 1) remove the browse data > TRUNCATE metabib.browse_entry_def_map CASCADE; > > > > > 2) select the bib ids into a file. From within psql: > > =# \t > =# \o /home/opensrf/mass_re-ingest/reingest_bib_ids.txt > =# select id from biblio.record_entry where not deleted and id > 0; > =# \q > > > > 3) Then, from the shell: > > ~$ awk '{print "update biblio.record_entry set id = id where id = " $1 ";"}' > < reingest_bib_ids.txt > reingest.sql > > Then, edit /tmp/reingest.sql to add the following at the top: > > UPDATE config.internal_flag SET enabled = TRUE WHERE name = > 'ingest.reingest.force_on_same_marc'; > > > > > and then the following at the bottom: > > UPDATE config.internal_flag SET enabled = FALSE WHERE name = > 'ingest.reingest.force_on_same_marc'; > VACUUM ANALYZE; > > > > 4) the opensrf user > psql -d evergreen -U evergreen -f reingest.sql > > > ------------- -- Mike Rylander | Director of Research and Development | Equinox Software, Inc. / Your Library's Guide to Open Source | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://www.esilibrary.com
