[OPEN-ILS-DEV] 1.6RC1: Vandelay imported Bibliographic MFHD Records do not show holdings part

[Repke de Vries]

Hi Dan

sorry for the delay:  good to know Vandelay can *not* yet handle MFHD  
records like in our case with separate Holding Records.

Bit of a disappointment though:  MFHD is a major next step in 1.6  
(all the way down to the database) and Vandelay MARC Import / Export  
is not catching up.   I think this should be clearly noted in the  
Release Notes and the staff client Vandelay screen it self.
Will share with Evergreen DIG  (the migration focus - with evaluation  
as step preceding it) and good to learn about the command line  
alternative:

marc2sre.pl     which I checked out but does not have a -h  and I  
couldn't find other documentation either ? The code tells me

something but not the complete workflow: what comes before  
marc2sre.pl, which script has to follow - and does marc2sre.pl take  
straight MFHD 2709 combination records or should it be XML ?

On the non working "Add MFHD Record" button / link: this is the  
Evergreen DIG Test Server and don't have access to the Apache log but  
I guess you tackled that issue already [1]

Thx too for explaining Vandelay import formats (for single non-MFHD  
recods): will share with DIG.

Repke

[1] http://www.mail-archive.com/open-ils- 
dev at list.georgialibraries.org/msg03539.html

Op 29-sep-2009, om 19:05 heeft Dan Scott het volgende geschreven:

> Hi Repke:
>
> On Mon, 2009-09-28 at 17:27 +0200, Repke de Vries wrote:
>> Dear all
>>
>> the same Evergreen DIG 1.6RC1 server as in my report on problems
>> Importing Authority Records and getting them (not) available for
>> validated cataloging (September 23; could anyone reproduce this
>> problem?) but this time single bibliographic  MFHD record problems:
>>
>> Imported [1]:
>>
>> 1) the IISH Pravda MFHD record in Vandelay, checking the "Import
>> Attached Holdings" checkbox but ignoring the "Holdings Import  
>> Profile" ;
>> holding information does *not* show up:   http://screencast.com/t/
>> 42ggXx4P
>
> I haven't done much with Vandelay, but I think Vandelay's current
> holdings import support extends only to monograph holdings that are
> merged with the bibliographic record in a single MARC record. It
> definitely doesn't support the import of serials MFHD records (whether
> or not they're merged with the bibliographic record).
>
> I'm reasonably sure that Vandelay doesn't support the import of  
> holdings
> from separate bibliographic records and MFHD records like you have  
> with
> the Pravda record. We need to improve our clarity about the  
> limitations
> of our current support.
>
> To bulk load serials MFHD holdings, one would currently need to use  
> the
> marc2sre.pl script located in the Open-ILS/src/extras/import  
> directory.
>
>> Note that the screenshot  does show some signs of Evergreen trying to
>> present Holding information: as far as I remember did that happen
>> after hitting the "Add MFHD Record" ;  by the way:  this Evergreen
>> installation does not have that 404 error  fixed when trying to use
>> the "Edit Holdings" button
>
> Hmm. The "PLACEHOLDER" is consistent with what should be there after
> clicking "Add MFHD Record", but the 404 is unexpected. We definitely
> need to look into that 404 error. Would you have access to the Apache
> error log to find out what it was trying to load?
>
>> 2) the IISH Brecht MFHD record  but this time checked the "Import
>> Attached Holdings" *and* choose the "Evergreen 852 format .." as
>> Profile (even though it mentions "Export");
>> holding information does *not* show up: http://screencast.com/t/
>> zeWfAMC67oYE
>> 	Here I  didn't try anything further ;-)
>>
>> Something I am doing wrong with the Import ?  Something else the
>> matter ?         Repke. IISH
>
> To start with, this is probably the same problem as the Pravda record;
> the MFHD records are separate, rather than merged with the  
> bibliographic
> record. In addition, the incoming attached holdings need to adhere  
> to a
> particular format; there are two default formats that are set up with
> current installs, but you can customize those or add more formats.  
> From
> 950.data.seed-values.sql, you can see the field and the subfields &
> additional conditions that the particular attributes are drawn from:
>
> INSERT INTO vandelay.import_item_attr_definition (
>     owner, name, tag, owning_lib, circ_lib, location,
>     call_number, circ_modifier, barcode, price, copy_number,
>     circulate, ref, holdable, opac_visible, status
> ) VALUES (
>     1,
>     'Evergreen 852 export format',
>     '852',
>     '[@code = "b"][1]',
>     '[@code = "b"][2]',
>     'c',
>     'j',
>     'g',
>     'p',
>     'y',
>     't',
>     '[@code = "x" and text() = "circulating"]',
>     '[@code = "x" and text() = "reference"]',
>     '[@code = "x" and text() = "holdable"]',
>     '[@code = "x" and text() = "visible"]',
>     'z'
> );
>
> ... so the "Evergreen 852 export format" expects to find the  
> attributes
> in the 852 field, with the owning library in the first subfield  
> "b", the
> circulating library in the second subfield "b", the shelving  
> location in
> the "c" subfield, the call number in the "j" subfield, etc. I think  
> the
> values of the controlled fields (libraries, locations, circ  
> modifiers),
> will also need to match existing definitions in Evergreen.
>
> You can see that the "Unicorn import format" is a little simpler - for
> example, it doesn't support a circulating library:
>
> INSERT INTO vandelay.import_item_attr_definition (
>     owner,
>     name,
>     tag,
>     owning_lib,
>     location,
>     call_number,
>     circ_modifier,
>     barcode,
>     price,
>     status
> ) VALUES (
>     1,
>     'Unicorn Import format -- 999',
>     '999',
>     'm',
>     'l',
>     'a',
>     't',
>     'i',
>     'p',
>     'k'
> );
>
>
>> [1] the two files are here: http://www.xs4all.nl/~repke/Evergreen/
>
> Thanks for the files - that definitely helps!
>