[OPEN-ILS-DEV] Adding copies in Evergreen

[Robert Soulliere]

Hi Dan,

We are importing from a SIRSI system. The export file was generated by
another person so we may not have much control over that part. The
export file is a standard marc format. Is there anything I can look at
in the file or the catalog to verify if the file does include holdings
information? 

Assuming I had copy information included, I followed the steps but need
a bit of clarification in regards to the parse_holdings.pl script which
I think is the key script for generating the sql statements that will
populate the holdings:

What should the holdings file variable be on the line beginning with:

my $holdings_file =

is this the original marc format or is this the bre file generated by
the marc2bre.pl script?to finish.

I mixed and matched my import methods since I used the Gutenberg example
for importing the records which got the records in the database but
followed the sample data example to try to generate the holdings. Let me
know if I would be better to simply following the sample data import
steps from start to finish?

Thanks,
Robert
 

  


----- Original Message -----
From: Dan Scott <denials at gmail.com>
Date: Sunday, August 17, 2008 10:10 pmthing 
Subject: Re: [OPEN-ILS-DEV] Adding copies in Evergreen
To: Evergreen Development Discussion List
<open-ils-dev at list.georgialibraries.org>

> Hi Robert:
> 
> 2008/8/14 Robert Soulliere <robert.soulliere at mohawkcollege.ca>:
> > We imported our records into Evergreen and can view them in the 
> staff> client, but I have one more hurdle to get over. I ran the
> > quick_metarecord_map.sql and it seemed to run OK with the output:
> >
> > BEGIN
> > ALTER TABLE
> > TRUNCATE TABLE
> > TRUNCATE TABLE
> > INSERT 0 37000
> > INSERT 0 39327
> > ALTER TABLE
> > COMMIT
> > [then the vacuuming stuff]
> >
> > but the copies are not added.
> >
> > Here are my questions:
> >
> > 1. Does this seem like to correct output if we imported 39327 
> records?
> That looks reasonable to me.
> 
> > 2. Was there a preliminary step I am missing where I need to add the
> > branch information to a file so that this step knows where to add 
> the> copies?
> 
> Importing bib records does not automatically import copies for those
> bib records; that's a separate step (somewhat documented in the
> "Adding copies" section of the import wiki page at
> http://open-ils.org/dokuwiki/doku.php?id=evergreen-
> admin:importing:bibrecords).
> I would recommend the "staging table" approach documented at
> http://open-
>
ils.org/dokuwiki/doku.php?id=importing:holdings:import_via_staging_table,if
you can get your hands on your holdings data. The demo import
> package uses a pretty dumb script "parse_holdings.pl" to pull holdings
> data from within the MARC records themselves, but depending on your
> system and how your bib records were exported, your records might not
> even contain embedded holdings.
> 
> -- 
> Dan Scott
> Laurentian University
> 


This E-mail contains privileged and confidential information intended
only for the individual or entity named in the message.  If the reader
of this message is not the intended recipient, or the agent responsible
to deliver it to the intended recipient, you are hereby notified that
any review, dissemination, distribution or copying of this communication
is prohibited.  If this communication was received in error, please
notify the sender by reply E-mail immediately, and delete and destroy
the original message.