On Tue, Sep 27, 2011 at 06:32:55AM -0400, Dan Scott wrote: > Hi Armen: > > On Tue, Sep 27, 2011 at 01:44:14PM +0500, Armen wrote: > > Dear Evergreen community > > I am from the Fundamental Scientific Library of Armenia. We use Evergreen > > 2.0.5 and now we need to import a database of bibliographic records from an > > older version of Ervergreen, namely 1.4.0.4. I have clearly followed the > > instructions available at this address > > http://docs.evergreen-ils.org/1.6/draft/html/exportingbibrecordsintoMARC.htm > > l. > > > > However, after the command > > > > " SELECT DISTINCT bre.id FROM biblio.record_entry AS bre > > JOIN asset.call_number AS acn ON acn.record-bre.id > > WHERE bre.deleted='false' and ownling_lib=101 \g > > /home/opensrf/records.txt; " > > > > the system pops out an error, namely this > > > > "argument of JOIN/ON must be type boolean, not type bigint". > > It looks like this is a typo in the documentation. I would expect the > "ON" clause to read "ON acn.record = bre.id". > > Also, ensure that the ID of the library for which you are exporting the > records is 101; you can check that in the actor.org_unit table. > > I hope this helps!
Also noted - it should be "owning_lib" instead of "ownling_lib". I have prepared a patch for the pertinent section of the documentation and will be sending that to the DIG. :)
