[OPEN-ILS-DEV] Problem Importing MARC records

Mike Rylander mrylander at gmail.com
Thu Aug 2 13:35:45 EDT 2007


On 8/2/07, Karen Collier <kcollier at kent.lib.md.us> wrote:
> Don,
>
> Thank you. That sounds like a very good possibility.  Just one quick
> followup question.  If SELECT COUNT(*) FROM biblio.record_entry; gives
> 14,486, would my startid be 14,486 or 14,487?

Karen,

You'll actually want to use

  SELECT MAX(id) + 1 FROM biblio.record_entry;

--miker

>
> Thanks,
> Karen
>
>
> -----Original Message-----
> From: open-ils-dev-bounces at list.georgialibraries.org
> [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Don
> Hamilton
> Sent: Thursday, August 02, 2007 12:45 PM
> To: open-ils-dev at list.georgialibraries.org
> Subject: Re: [OPEN-ILS-DEV] Problem Importing MARC records
>
> [snip]
>
> perl marc2bre.pl -startid=2017 ebooks/gale.mrc |  perl direct_ingest.pl  |
> perl pg_loader.pl -or bre -or mrd -or mfr -or mtfe -or mafe -or msfe -or
> mkfe -or msefe -a mrd -a mfr -a mtfe -a mafe -a msfe -a mkfe -a msefe >
> gale.sql
>
> don (not mcmorris, and not dan, either)
>
>
>
>


-- 
Mike Rylander
Equinox Software, Inc
miker at esilibrary.com
http://esilibrary.com/


More information about the Open-ils-dev mailing list