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 >> >> >> >> > > > > >