Re: Serial Solution and III

[John Wynstra <john.wynstra@xxxxxxxxxx>]

Doug,

Would you be willing to share your VBA program?

Doug Payne wrote:
> 
> Hi John,
> 
> Here at Boston University we are preparing to enter
> SerialsSolutions data into our Innopac catalog.  A staff
> member has taken the SerialsSolutions spreadsheet and
> has massaged the data into the format:
> 
> Title   ISSN      BeginDate  EndDate Source      WebLink
> Adole.. 0001-8449 03/01/1995         SocSFullTxt http://hww..
> 
> [I've obviously abbreviated some of the info]
> 
> I wrote a VBA [Visual Basic for Applications] program that
> takes this info and converts it into a text file in the
> format used by LC's MARCMaker and MARCBreaker program.  I
> then ran the text file through the MARCMaker program to
> create a file of MARC records.  I then created a new Innopac
> "load profile template" that takes the MARC records and
> loads them into Innopac, creating a new bib record and an
> attached "summary holdings" record.
> 
> This works ok.  I'm still thinking about how to identify
> and deal with duplicate bibliographic records.  And, I
> am not sure how to update the summary holdings records
> once they have been created.
> 
> As you can see, we are still working out the details.
> 
> --  Doug
> 
> --
> Doug Payne     Boston University - Mugar Library &
> dbp@xxxxxxxxxx     Boston University Office of Information Technology
>                TEL:  (617) 353-0602  FAX:  (617) 353-2084
> 
> John Wynstra wrote:
> >
> > I'm curious to know if any III libraries are incorporating Serial
> > Solutions data into the library catalog in any way.  We are just
> > starting with Serial Solutions and are contemplating the issues that we
> > need to address to create and import brief records into our system on a
> > regular basis using a .csv output file generated by Serials Solution.
> > I would appreciate any input on this, and it might even be worth a Birds
> > of a Feather session at IUG if there is enough interest (Is it really
> > just 4 days from now? Wow!).
> > --
> > <><><><><><><><><><><><><><><><><><><>
> > John Wynstra
> > Library Information Systems Specialist
> > Rod Library
> > University of Northern Iowa
> > Cedar Falls, IA  50613
> > wynstra@xxxxxxxxxx
> > (319)273-3619
> > <><><><><><><><><><><><><><><><><><><>
> --
> This message was distributed through the Innovative Users Group INNOPAC list
> Public replies:  INNOPAC@xxxxxxxxxx
> Update your subscription options: http://innopacusers.org/list/listinfo/innopac

-- 
<><><><><><><><><><><><><><><><><><><>
John Wynstra
Library Information Systems Specialist
Rod Library
University of Northern Iowa
Cedar Falls, IA  50613
wynstra@xxxxxxxxxx
(319)273-3619
<><><><><><><><><><><><><><><><><><><>