[OPEN-ILS-GENERAL] import exsel in postgres

[Jason Etheridge]

Hi Levani,

> i try with biblio record but nothing.

In general, you should be modeling your materials into 3 different
Evergreen tables:

biblio.record_entry
asset.call_number
asset.copy

biblio.record_entry contains a field called .marc, which needs to
contain MARCXML for your bibliographic record.

asset.call_number points to a specific row in biblio.record_entry, a
specific row in the actor.org_unit table (that represents your
libraries), and has a free-text label for holding information from a
classification scheme like the Dewey Decimal System or the Library of
Congress Classification scheme.

asset.copy records the fact that you have a physical instance of some
item, and contains a reference to the item's "barcode" or material
number.  It has a .call_number field which points to a specific row in
asset.call_number, and indirectly through that table, to a specific
bib record in biblio.record_entry.

There's more to it than this.  Specifically, once you have data in
biblio.record_entry, you'll need to run a process called "ingest"
against each row that will explode the data into other tables used for
specific types of searching.

It may be easier to convert your Excel database into a text format and
use one of the example import demos for loading into Evergreen rather
than something like navicat or pgadmin.  See
http://svn.open-ils.org/trac/ILS-Contrib/wiki/ImportDemo

Also, there is an application called MARCEdit may be useful for
converting text into MARC format:
http://oregonstate.edu/~reeset/marcedit/html/index.php

I hope this helps!

-- 
Jason Etheridge
 | VP, Community Support and Advocacy
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  jason at esilibrary.com
 | web:  http://www.esilibrary.com