RE: [IUG] off-system manipulation and return of data

["Yitzchak Schaffer" <yitzchas at touro dot edu>]

Two options come to mind:

- Make a script (e.g. AutoIt) to bounce back and forth between Excel and
Millennium to update records one by one, or alternately have the script do
the transform directly on a review file record by record

- Export in .mrc format, edit in e.g. MarcEdit, and send them back in .mrc
format.  You'd need a load table rigged to overlay based on record number in
your specific example, or any other unique field you have (often OCLC
number)


Yitzchak Schaffer
Systems Librarian
Touro College Libraries
33 West 23rd Street
New York, NY  10010
Tel (212) 463-0400 x230
Fax (212) 627-3197
yitzchas at touro dot edu

-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Doug Yancey
Sent: Monday, August 06, 2007 11:54 AM
To: innopac at innopacusers dot org
Subject: [IUG] off-system manipulation and return of data

Can anyone tell me if it's possible to export data from Millennium,
manipulate it another application and then import it back into Millennium so
that the new data overwrites the old?

For example, I would like to:

1.  gather a set of item records, export the following fields:

(i)  record number
(i)  call number
(b) author


2.  import the data into another app (i.e. MS Access or mysql)


3.  use the app to derive new call numbers by concatenating: a) the current
call number & b) a cuttered version of the related author name


4.  put the data back in Millennium:

item record number = item record number (matchpoint) new call number
(derived off system) >> replaces call number currently on system


I know that the first three steps are possible; it's the fourth that I'm
uncertain of.  I don't believe that what I would like to do is possible
through Global Update, which is why I'm asking about this method.  If it is,
I'd certainly like to know how to go about doing it.

Thanks,


Doug Yancey
Technical Services Manager
Salem Public Library
585 Liberty St SE
Salem, OR  97301
503.588.6020
dyancey at cityofsalem dot net
--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC at innopacusers dot org Update your subscription options:
http://innopacusers.org/mailman/listinfo/innopac