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

[Dan Wells]

Hello Michael,

Things have certainly changed a lot since 1.6.0.0.  For example, we couldn't get import to work at all before this changeset (which made it into 1.6.0.1):

http://svn.open-ils.org/trac/ILS/changeset/15356 

I would try to at *least* upgrade to 1.6.0.3 or 1.6.0.4, as quite a few significant bugs got squashed early on.

Dan

>>> On 12/9/2010 at 12:37 PM, "Peters, Michael" <MRPeters at library.IN.gov> wrote:
> 1.6.0.0....hope that's not the culprit!
> 
> Sincerely, 
> Michael Peters 
> Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana 
> Helpdesk
> office - 317.234.2128 
> email - mrpeters at library.in.gov 
> 
> 
> -----Original Message-----
> From: open-ils-dev-bounces at list.georgialibraries.org 
> [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Dan 
> Wells
> Sent: Thursday, December 09, 2010 12:01 PM
> To: Evergreen Development Discussion List
> Subject: Re: [OPEN-ILS-DEV] Help with expected 
> valuesinvandelay.import_item_attr_definition?
> 
> 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>