[OPEN-ILS-GENERAL] Problem of importing the Gutenberg records

[Araik Manukyan]

Hi Mike,

Thanks  for your assistance, we have downloaded and  changed your suggested 
file on our server.
After this we have success on importing records.

----- Original Message ----- 
From: "Mike Rylander" <mrylander at gmail.com>
To: "Evergreen Discussion Group" 
<open-ils-general at list.georgialibraries.org>
Sent: Thursday, October 29, 2009 7:44 AM
Subject: Re: [OPEN-ILS-GENERAL] Problem of importing the Gutenberg records


On Thu, Oct 29, 2009 at 2:57 AM, Araik Manukyan <araik at flib.sci.am> wrote:
> Thank you for your quick response.
>
> We are sending your requested files that we have received during the
> conversion.

Thanks.

It looks like you're using an older version of the pg_loader.pl script
-- probably as distributed with the RC1 tarball.  Can you grab this
newer version[1] and use that in the last step of generating the SQL?

[1] 
http://svn.open-ils.org/trac/ILS/browser/tags/rel_1_6_0_0/Open-ILS/src/extras/import/pg_loader.pl

--miker

>
> ----- Original Message ----- From: "Mike Rylander" <mrylander at gmail.com>
> To: "Evergreen Discussion Group"
> <open-ils-general at list.georgialibraries.org>
> Sent: Wednesday, October 28, 2009 8:54 AM
> Subject: Re: [OPEN-ILS-GENERAL] Problem of importing the Gutenberg records
>
>
> Would you mind sending that file?
>
> TIA,
>
> --miker
>
> 2009/10/28 araik <araik at flib.sci.am>:
>>
>> Hello list,
>>
>> We installed Evergreen 1.6 version on ubuntu 8.10 server.
>> We tried importing the Project Gutenberg records to our server, as
>> described
>> on the following link
>>
>> http://www.open-ils.org/dokuwiki/doku.php?id=evergreen-admin:importing:bibrecords&s[]=import&s[]=record.
>> We passed 3 steps successful and we have file gutenberg.sql.
>> After trying to implement the step 4, \i ~/gutenberg.sql,
>> we have the following error
>>
>> **************************************************
>> evergreen=# \i /root/gutenberg.sql
>> SET
>> BEGIN
>> setval
>> --------
>> 1
>> (1 row)
>>
>> psql:/root/gutenberg.sql:16: ERROR: trigger
>> "zzz_update_materialized_simple_record_tgr" for table "real_full_rec" 
>> does
>> not exist
>> CONTEXT: SQL function "disable_materialized_simple_record_trigger"
>> statement 1
>> psql:/root/gutenberg.sql:17: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> psql:/root/gutenberg.sql:18: invalid command \N
>> psql:/root/gutenberg.sql:19: invalid command \N
>> psql:/root/gutenberg.sql:20: invalid command \N
>> psql:/root/gutenberg.sql:21: invalid command \N
>> psql:/root/gutenberg.sql:42: invalid command \.
>> psql:/root/gutenberg.sql:44: ERROR: syntax error at or near "1"
>> LINE 1: 1 a 040 pgusa
>> ^
>> psql:/root/gutenberg.sql:45: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> psql:/root/gutenberg.sql:47: invalid command \.
>> psql:/root/gutenberg.sql:49: ERROR: syntax error at or near "6"
>> LINE 1: 6 1 five years of theosophy
>> ^
>> psql:/root/gutenberg.sql:51: invalid command \.
>> psql:/root/gutenberg.sql:53: ERROR: syntax error at or near "15"
>> LINE 1: 15 1 five years of theosophy text eng electronic electronic ...
>> ^
>> psql:/root/gutenberg.sql:55: invalid command \.
>> psql:/root/gutenberg.sql:57: ERROR: syntax error at or near "1"
>> LINE 1: 1 1 project gutenberg 14378
>>
>> *********************************************************************************************
>>
>> Could you tell the reason of our problem?
>>
>> Thank you in advance
>>
>> Araik
>> Fundamental Scientific Library of NAS RA
>
>
>
> --
> Mike Rylander
> | VP, Research and Design
> | Equinox Software, Inc. / The Evergreen Experts
> | phone: 1-877-OPEN-ILS (673-6457)
> | email: miker at esilibrary.com
> | 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:  miker at esilibrary.com
 | web:  http://www.esilibrary.com