Macro Express at the UF Smathers Libraries

Communication Area for Macro Express Unit Developers

Friday, September 23, 2005

> Removing text from ISSN fields

I just created a one time small project macro for removing print from ISSN fields in the bib record.
 
First I had to create a report in Aleph that listed all the ISSN fields of records with active orders.
 
I migrated this report to excel and stripped out all the records without text in the ISSN fields.
 
The macro looked at the bib record and copied the 022 field info. If the ISSN included the phrase (paper) or (print) then it deleted that information and saved the record.
 
75 records were updated using this proccess.
 

Jason 


Monday, September 19, 2005

> Macros created

Consultation with Naomi Young for Serials Solutions macro nearly complete.
This macro goes down a list in excel and pushes an ISSN to the Search module (ALEPH).
 
The user is asked to find the print record and send it to the Cataloging module. In the Cataloging module the electronic link is deleted and the Electronic holdings record is suppressed.
 
 
 

Jason Fleming