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

[Peters, Michael]

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>



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20101209/d6d8847f/attachment-0001.htm