On Thu, Dec 15, 2011 at 6:26 PM, Elliot Voris <[email protected]> wrote: > Hi, Dev Group! > > I've made some great progress, albeit in a round-about way. For whatever > reason, I could not get the .sql file to work properly. I ended up having to > copy/paste in a few waves my Marc records into the marcxml_import table using > webmin. Not ideal, but I now have all the records in my database. > > I'm having trouble inserting it into the biblio.record_entry table, now. I'm > taking the line right out of the sample script you gave, but it's having the > following effect: > > evergreen=# > evergreen=# INSERT INTO biblio.record_entry (marc, last_xact_id) SELECT marc, > 'IMPORT' FROM marcxml_import; > ERROR: Unable to provide required features > CONTEXT: PL/Perl function "maintain_control_numbers" > evergreen=# > > I found that there was mention in the changelog from 1.6.1.0 to 2.0.0 to the > global flag 'cat.maintain_control_numbers', but I can't tell if I'm supposed > to enable/disable it on my installation, or what. What do I need to do to > insert my records from the one table to the next?
Elliot: Rather than using Webmin, from the command line the command to load a random SQL file is: psql -U <username> -h <hostname> -f <filename> So... "psql -U evergreen -h localhost -f concerto.sql" should be all you need, possibly passing in a password as well. I can't say I've ever seen "ERROR: Unable to provide required features" before... a quick Googling suggests that it's a problem with your Perl XML modules (http://cpansearch.perl.org/src/GRANTM/XML-SAX-0.99/SAX/ParserFactory.pm). Assuming you've run the Makefile.install for Ubuntu Lucid on both OpenSRF and Evergreen, it should work, but at this point I'll have to defer to people with current Ubuntu experience. Dan
