[OPEN-ILS-GENERAL] Export error

[Dan Scott]

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!