Re: converting MFHD dates to other formats Lai-Ying Hsiung 19 Dec 2011 16:54 UTC

Hi, Amanda:

III has a separate holding record that has free text "Library Has: ".
However, are you aware that anyone has just mapped III's holding
record "Library Has:" to MARC holding 866, unless they also start to
use 853/863?  I am still wondering whether it is optimal to spend lots
of resources in coding 853/863 for print holdings when they are
dwindling, while e-serial holdings are still in free text 856 $3.

Our library is debating whether we should adopt 853/863 for print
holdings now.  Thus my question here. Any comments?
Lai-Ying

On Fri, Dec 16, 2011 at 11:49 AM, Amanda Xu <axu789@gmail.com> wrote:
> It's hard to tell you how without looking into something like, e.g. if your
> original holdings statement in text format or even MARC format has any
> pattern or not.  To make such conversion happen, I worked with Gary L.
> Strawn, ExLibris Voyager Tech Support and our systems office due to limited
> access to the systems, etc.
>
> We migrated all of serials holdings statement from MARC bib 590 field into
> MARC holdings 86x fields in Voyager MFHD, including periodicals and
> continuations during migration from PALS to Voyager in summer 2004.
>
> Later for data recovery, I recovered holdings and barcoded item data through
> Voyager Oracle report in Web Admin, and converted the files into MARC
> holdings format and Voyager item format in batch processing mode using
> UltraEdit, MARCEdit, and asked ExLibris Voyager Tech Support team to load
> the data into our Voyager database.
>
> It's a round trip data mapping and conversion process using NotePad,
> UltraEdit, Access, Excel, MARCEdit, Voyager Bulk import and export utility,
> and data report utilities in Voyager Web Admin, etc.
>
> It still required some manual verification and a little cleanup because the
> input data was not consistent in MARC 590 field due to the changing of
> encoding format for serials, turnover of the people working on holdings
> updates in local systems, and OCLC Union List of Serials, etc.  However, we
> proved that it's a scalable solution for library wanting to automate
> holdings data, including e-holdings for MFHDs and items.
>
>
> Hope it helps!
>
> Amanda Xu
>
>
> On Fri, Dec 16, 2011 at 11:13 AM, Christina Torbert <ctorbert@olemiss.edu>
> wrote:
>>
>> Our library has worked very hard to get our print holdings into MARC
>> Format, but now we want to share that information with a third party listing
>> service that has its own, different date format options.  Specifically, they
>> need the beginning and ending dates in separate, delimited fields.  And they
>> don’t want the volume information at all.
>>
>>
>>
>> Customer Service says they do not have an automated way to convert our
>> information and did not answer when I asked if their offer to copy-and-paste
>> included moving date information.
>>
>>
>>
>> So I am looking for a way to more easily convert MFHD into different date
>> formats without setting the whole department to cutting and pasting,
>> line-by-line.  Has anyone else worked through this problem successfully?
>>
>>
>>
>> Thank you .
>>
>>
>>
>> Christina Torbert
>>
>> Head of Serials and
>>
>> Bibliographer for Philosophy and Religion
>>
>> J.D. Williams Library
>>
>> University of Mississippi
>>
>> 662-915-7059
>>
>> 662-915-6744 fax
>>
>> ctorbert@olemiss.edu
>>
>>
>>
>>
>
>
>
>
>