| Name | Language or Tool | Date | Main Features |
| Library Hours | PHP3, MySQL | March-May |
The program dynamically displays library hours. Users can select day, month, year or library.
It takes into account leap year, daylight saving time, length of month and partial data. Database
was fairly complex and flexible so it accommodates the University's quarter schedules. It takes
into account regular, break, exam and holiday schedules. It also facilitates the need to constantly
update hour information.
The program has been placed for public use by Access & Circulation Services at the libraries of the University of Chicago since 2001. |
| Accruals | PHP3, MySQL | April-May |
This program extracts data from a table in a MySQL
database which is periodically updated by the Personnel and Budget
Department. It displays accruals information on the web. It allows
library staff to check their current accruals. It also allows managers
to view their own as well as their staff's accruals. The program uses
HTTP Basic authentication method for access control. It also
implements some degree of Subnet security.
The current Accruals program is an update of the old Accruals
program. Major aspects of the update include user authentication,
subnet security and processing of user inputs.
The program has been placed for library staff use by the Personnel and Budget Department in the libraries of the University of Chicago since March 2002. |
| Staff Directory (Replaced) | PHP3, MySQL | Jan.-March | The program provides staff info., including office, phone, email, and department, searchable by name, div., dept. or unit. It also provides an a-z employeee list with an alphabar for quick navigation. |
| Macroeconomic Time Series Data Source Locator | PHP3, MySQL | Finished in March | The program created a searchable database of macroeconomic time
series sources available at the University of Chicago. It takes user inputs as search criterion for
period of publication, geographic coverage and content/subject area(s), and displays search results by
content/subject relevance (and then by titles).
The program has been placed for public use by Business and Economics at the library of the University of Chicago since March 2002. |
| JLoader | Java, Java Servlet | Finished in Oct. |
This program was based on a Java program I wrote in April 2003, and added
to it a web interface. It authenticates user and then checks to see if the
uploaded file has the right number of fields and format. Once the file is
deemed as acceptable, it reads, cleans up and writes up a cleaned-up data file.
It then loads old records in the target table to the backup database table, and updates
records in the target table.
The program has been placed for internal use by Personnel and Budget Department at the library of the University of Chicago since 2003. |
| Travel Training Request | PHP, MySQL | Revised in July |
Using PHP4 and MySQL, this program consists of three modules, one for
filing a travel request form, one for listing and/or approving a request,
the third for listing a travel request that has completed the filing
process. The program authenticates the user prior to his/her access to a
module. For the travel request form, it validates user input, cleans up
and stores the validated information to a database. For listing and approval
of a travel request, it allows for viewing processing status as well as
details of filed travel request(s). It also collects recommendation when
applicable. When applicable and depending on administrative role, it
dynamically generates a dropdown menu of the names of signature persons
for both the application form page and the signature page. It sends an
email informing the designated individual to view and approve the application.
Once an application completed its circle, i.e., application filed and in case
of non-div heads, approved from a division head, Personnel Office receives an
email with a link to a displaying page (with details of that particular request).
The program has been placed for library staff use by Personnel and Budget Department at the library of the University of Chicago since 2004. |