[OPEN-ILS-DEV] Problem Importing MARC records

[Karen Collier]

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 <kcollier at kent.lib.md.us>
To: open-ils-dev at list.georgialibraries.org
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 <atzberger at MECDC.ORG>
> To: open-ils-dev at list.georgialibraries.org
> 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
> > atzberger at mecdc.org
> > 
> > 
> > 
>