[OPEN-ILS-DEV] Help with expected valuesinvandelay.import_item_attr_definition?

[Dan Wells]

Hello Michael,

I am unsure why some parts of the process are not working for you, but I can say that our working 949s use the Org Unit short name (e.g. BR1) for both the owning_lib and circ_lib fields, and also that status and location simply use the 'name' field (e.g. '3rd floor').  It looks like you are on the right track there.

What exact version are you on?  I recall we had some import issues on 1.6.0.0 which were fixed fairly early on, somewhere in the 1.6.0.2-1.6.0.4 range.

I would perhaps suggest starting with a simpler profile which only defines the critical fields and work up from there.  In our experience you do not need to populate every column in import_item_attr_definition.

Dan

>>> On 12/9/2010 at 10:48 AM, "Peters, Michael" <MRPeters at library.IN.gov> wrote:
> Doh!  Hit send too fast...also meant to copy the results from 
> vandelay.import_item!
> 
> evergreen=# SELECT * FROM vandelay.import_item WHERE id=4;
> -[ RECORD 1 ]--+----------------------------
> id             | 4
> record         | 27525
> definition     | 3
> owning_lib     |
> circ_lib       |
> call_number    | CD DMBAND
> copy_number    |
> status         |
> location       |
> circulate      | t
> deposit        | f
> deposit_amount |
> ref            | f
> holdable       | t
> price          | 9.99
> barcode        | 1234567891234
> circ_modifier  | cd-music
> circ_as_type   |
> alert_message  | Private alert message here
> pub_note       | Public Note Here
> priv_note      | Private Note Here
> opac_visible   | t
> 
> Sincerely,
> Michael Peters
> Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana 
> Helpdesk
> office - 317.234.2128
> email - mrpeters at library.in.gov<mailto:mrpeters at library.in.gov>
> 
> From: open-ils-dev-bounces at list.georgialibraries.org 
> [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of 
> Peters, Michael
> Sent: Thursday, December 09, 2010 10:47 AM
> To: Evergreen Development Discussion List
> Subject: Re: [OPEN-ILS-DEV] Help with expected values 
> invandelay.import_item_attr_definition?
> 
> If it helps, here also is the MARC I'm attempting to import (along with 
> holdings, embedded in the 949).  I know I have to be REALLY close on this!
> 
> Sincerely,
> Michael Peters
> Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana 
> Helpdesk
> office - 317.234.2128
> email - mrpeters at library.in.gov<mailto:mrpeters at library.in.gov>
> 
> From: open-ils-dev-bounces at list.georgialibraries.org 
> [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of 
> Peters, Michael
> Sent: Thursday, December 09, 2010 10:43 AM
> To: open-ils-dev at list.georgialibraries.org 
> Subject: [OPEN-ILS-DEV] Help with expected values in 
> vandelay.import_item_attr_definition?
> 
> Hi all!
> 
> I'm experimenting with the "Import embedded holdings" feature in Vandelay 
> and running into some trouble.  Consider the following:
> 
> --SQL to create new profile
> INSERT INTO vandelay.import_item_attr_definition (
>     owner,
>     name,
>     tag,
>         owning_lib,
>         circ_lib,
>         call_number,
>         copy_number,
>         status,
>         location,
>         circulate,
>         deposit,
>         deposit_amount,
>         ref,
>         holdable,
>         price,
>         barcode,
>         circ_modifier,
>         circ_as_type,
>         alert_message,
>         opac_visible,
>         pub_note_title,
>         pub_note,
>         priv_note_title,
>         priv_note
> ) VALUES (
>     1,
>     'OCLC Connexion Format (Indiana Custom) -- 949',
>     '949',
>     'a',
>     'b',
>     'c',
>     'd',
>     'e',
>     'f',
>     'g',
>     'h',
>     'i',
>     'j',
>     'k',
>     'l',
>     'm',
>     'n',
>     'o',
>     'p',
>     'q',
>     'r',
>     's',
>     't',
>     'u'
> );
> 
> 
> ASSUMED Definitions for how to catalog in Connexion
> 
> name            | OCLC Connexion Format (Indiana Custom) -- 949
> tag             | 949
> owning_lib      | a -- ?
> circ_lib        | b -- ?
> call_number     | c -- text string containing your call number label
> copy_number     | d -- text string or integer
> status          | e -- ?
> location        | f -- ?
> circulate       | g -- "t" or "f" boolean values
> deposit         | h -- "t" or "f" boolean values
> deposit_amount  | i -- text string (do not use $)
> ref             | j -- "t" or "f" boolean values
> holdable        | k -- "t" or "f" boolean values
> price           | l -- text string (do not use $)
> barcode         | m -- text string
> circ_modifier   | n -- text string matching one of the circ modifiers in EI 
> circ matrix (ex. "book" or "video new")
> circ_as_type    | o -- text string corresponding to a MARC code (a, j, i, e, 
> o, etc.)
> alert_message   | p -- text string for staff client alert message
> opac_visible    | q -- "t" or "f" boolean values
> pub_note_title  | r -- text string
> pub_note        | s -- text string
> priv_note_title | t -- text string
> priv_note       | u -- text string
> 
> 
> 949 tag snippet from a binary marc to be loaded with Vandelay
> 
> ...
> =949  \\$aAPLSD<file:///\\$aAPLSD> $bAPLSD $cCD BTNHR $eIn process $fAV $gt 
> $hf $jf $kt $l9.99 $m1234567891234 $ncd-music $pPrivate alert message here $qt 
> $rPublic $sPublic Note Here $tPrivate Note $uPrivate Note Here
> 
> I'm having trouble getting things like the status, copy location, etc. to 
> load.  I've tried using both "id" values that correspond and the plain text 
> (like you see here).  Barcode, price and notes load up well.
> 
> Can anyone help?
> 
> Sincerely,
> Michael Peters
> Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana 
> Helpdesk
> office - 317.234.2128
> email - mrpeters at library.in.gov<mailto:mrpeters at library.in.gov>