[OPEN-ILS-GENERAL] ***SPAM*** Importing holdings data

[Dan Wells]

Hello John,

I haven't kept up on the very newest tools, but we successfully migrated around a year ago using customized versions of (and/or ideas from) this:

http://svn.open-ils.org/trac/ILS-Contrib/wiki/ImportDemo 

and this:

http://www.open-ils.org/dokuwiki/doku.php?id=importing:holdings:import_via_staging_table

The basic process is:

1) parse your records (using parse_holdings.pl or something similar) to generate SQL inserts
2) insert the parsed data into a temporary 'staging_items' table
3) run a query which uses the data in the staging table to populate asset.copy, asset.call_number, and probably config.circ_modifier (e.g. "item type" in certain legacy systems)

The trickiest part is probably getting the proper biblio.record_entry_id values for each item being imported.  We had the somewhat clever idea of hard-coding biblio.record_entry_id values to be identical to the internal ids of our old system (not to be confused with TCNs, in this case), and that made importing holdings and circ data much simpler.

This is a very basic rundown, so please do write back if you get stuck at a specific point.

Dan


-- 
*********************************************************************************
Daniel Wells, Library Programmer Analyst dbw2 at calvin.edu
Hekman Library at Calvin College
616.526.7133


>>> On 1/13/2011 at 3:11 PM, John Morris <jmorris at beau.org> wrote:
> On Thu, 2011-01-13 at 08:59 -0500, Dan Wells wrote:
>> Hello John,
>> 
>> Before I offer any specific suggestions, can you point me to the 
> documentation you are using at this point?
> 
> Mostly reading here:
> http://docs.evergreen-ils.org/1.6/draft/html/migratingdata.html 
> 
> The details of the schema in that same document helps but isn't
> sufficient to answer every question.  Have also poked around in the
> various wiki material a bit.