Macro Express at the UF Smathers Libraries

Communication Area for Macro Express Unit Developers

Thursday, October 13, 2005

> example code:record saving

Description
Saves records in Aleph Cataloging module 15.5.2
often used as a sub-macro

Download:
text file with code (.txt)
macro express file (.mex)


Tuesday, October 11, 2005

> Paying Unit Macros in use

Since roughly January 2005, Paying Unit has been using macros I developed to cut down invoice processing time. While there are 11 different macros, they're all slightly modified versions of the same basic macro. It essentially assigns "chartfield string" information to an active ALEPH invoice record in fields specified by FCLA for this purpose. Then it approves the invoice and closes the ALEPH general invoice.

I've created two macros to accomplish updating the budget workbook and publishing an updated Acquisitions Report on the web. They've been in use since October 7. Both routines rely on importing the same table of data from ALEPH ARROW. The budget workbook is an MS Xcel document, while the Acquisitions Report is updated and published to the web using MS Access. The Acq report can be acessed by going to: http://www.uflib.ufl.edu/acqlic/paying/payreports.htm , then clicking Current Acquisitions Report.


> Versioning macros

Versioning is when you assign a name to a file that is updated every time you make a change. This would be helpful for macro files that you may make available to users for download.
 
An example would be if the copycat macro has been changed slightly.
The current name of the macro is copycat1.mex. The new file might be named copycat2.mex. The difference in names suggests that it is a different file. The numeric increase in the number after the name would suggest to the user that copycat 2 is the newer file.
 
If the macro changes more frequently than say once a month you might want to add another level to the version number. (i.e. copycat1-1.mex, copycat1-2.mex, copycat1-3.mex etc...)
 
contributed by Doug Smith
 
 


Tuesday, October 04, 2005

> Training session

Consulted on 10/03/04 with Gerald Langford in Cataloging and Metadata.
 
First macro creation: ybp barcode correction
 
Training elements:
 
If/Else/Endif
Test Insertion
Variable Creation
Variable Modification
Delays: wait for window title, mouse cursor, set time limit
Get Control
Click on Control
Dialog Box: display, multiple choice
Documentation (Remarks)
Scope
 
 
Looping and sub macros to be taught at a later point.
 

Jason Fleming