Oops, sorry, I hit the wrong button and it sent before I included the errors.
Here they are:
psql:/home/evergreen-admin/kent1000records.sql:36945: invalid command \N
psql:/home/evergreen-admin/kent1000records.sql:36978: invalid command \N
psql:/home/evergreen-admin/kent1000records.sql:36979: invalid command \N
psql:/home/evergreen-admin/kent1000records.sql:36980: invalid command \N
psql:/home/evergreen-admin/kent1000records.sql:37029: invalid command \N
psql:/home/evergreen-admin/kent1000records.sql:37030: invalid command \N
psql:/home/evergreen-admin/kent1000records.sql:37031: invalid command \N
psql:/home/evergreen-admin/kent1000records.sql:37032: invalid command \N
psql:/home/evergreen-admin/kent1000records.sql:37072: invalid command \N
psql:/home/evergreen-admin/kent1000records.sql:37073: invalid command \N
psql:/home/evergreen-admin/kent1000records.sql:37074: invalid command \N
psql:/home/evergreen-admin/kent1000records.sql:37075: invalid command \N
psql:/home/evergreen-admin/kent1000records.sql:39210: invalid command \.
psql:/home/evergreen-admin/kent1000records.sql:40341: invalid command \.
psql:/home/evergreen-admin/kent1000records.sql:41810: invalid command \.
psql:/home/evergreen-admin/kent1000records.sql:42920: ERROR: syntax error at
or near "2"
LINE 1: 2 a 010 80-050399 //r843
^
evergreen=#
Thanks,
Karen
----- Original Message -----
From: Karen Collier <[EMAIL PROTECTED]>
To: [email protected]
Sent: Thu, 2 Aug 2007 12:02:16 -0400
Subject: Re: [OPEN-ILS-DEV] Problem Importing MARC records
> I went through the .marc file and found the records containing some of the
> strange characters, and went back and looked at those records in Horizon.
> They
> display as diamond shapes with question marks there, and the odd
> capitalization
> you mentioned shows up there as well. Our cataloger is looking at those
> records, intending to correct them.
>
> Meanwhile, I tried using a smaller set of MARC records that didn't include any
> of the records I had problems with in the .marc to .bre phase. Everything
> went
> smoothly with no apparent errors until I got to:
>
> psql -U evergreen evergreen
> evergreen# \i ~/kent1000records.sql;
>
> and I got a whole series of these guys again:
>
>
>
>
>
> ----- Original Message -----
> From: Joe Atzberger <[EMAIL PROTECTED]>
> To: [email protected]
> Sent: Wed, 1 Aug 2007 17:24:36 -0400
> Subject: Re: [OPEN-ILS-DEV] Problem Importing MARC records
>
>
> > Karen --
> >
> > Is there something strange going on with your character set (and
> > capitalizations)? In your records, what are the
> > characters that display in the error log (or at least in my email) as
> > squares?
> > Perhaps they are illegal escape
> > characters or something more appropriate in UTF-8.
> >
> > Is is possible your line endings were reformatted or scripts randomly forced
> to
> > uppercase? To me, "nEW yORK" looks like
> > the result of a tr/[A-z]/a-Z/ and "\N" looks suspiciously like the newline
> > character "\n".
> >
> > --Joe Atzberger
> > INFOhio Technical Specialist
> > Metropolitan Educational Council
> > (614) 473-8300 x22
> > [EMAIL PROTECTED]
> >
> >
> >
>
