Faculty A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Decades
1940s
1950s
1960s
1970s
1980s
1990s
2000s

 

Methods Used to Add Components to Photo History

Introduction

††††††††††Throughout the design and implementation of the Department of Computer Science Photo History project, we have attempted to simplify and organize the procedures for adding new information and pictures to the chronology. Our ultimate goal is to create a script that will prompt a public user (or webmaster) to input the proper information required and load pictures. However, at the present time, adding can only be performed by users with Photo History accounts on the hcil.cs.umd.edu server. The user must know that there exists a MySQL database (CSPhotoHistory) with four tables (Faculty, Images, NamePhotos, and Timeline) that need to be modified when one makes changes.

One easy way to manage the database is to download the mysql control center (mysqlcc.exe) from the sourceforge repository.

The databases needed to manage the repository are:

Faculty: consists of LastName, FirstName, start year, end year, and FacultyText (professional bio) fields.

Images: consists of PicURL, PicDate (currently all NULL), Photographer (currently all NULL), Caption fields.

NamePhotos: consists of LastName, FirstName, PicURL, FirstPic (for determining which is the best/default picture) fields.

††††††††† Timeline: consists of Date, Description, Picture, Caption fields.

 

Adding New Faculty

††††††††††† In order to add a new faculty member to the Photo History project, one must make changes to all four tables in CSPhotoHistory. This can most efficiently be done using MySQL Control Center to log into the database and bring up a spreadsheet layout of any table in the database. The following changes need to be made:

1)      Add a new record to Faculty with the information of the new faculty member.

2)      Add a new record to NamePhotos and Images if uploading new images of this person.

a.       Create a thumbnail of the picture and upload it to the /fs/www/projects/photohistory/faculty_pictures directory of the project space.

b.      Upload original photo to the /fs/www/projects/photohistory/faculty_pictures_full directory of the project space.

3)      Add a new record to Timeline including the date of arrival of the new member along with the default picture of the person.

 

 

Adding New Photos

To add a new photo to the Photo History site, the same procedure applies as above for adding pictures to new faculty:

1)      Create a thumbnail of the picture and upload it to the /fs/www/projects/photohistory/faculty_pictures directory of the project space.

2)      Upload original photo to the /fs/www/projects/photohistory/faculty_pictures_full directory of the project space.

3)      Create an entry in Images to record the new photo.

(When adding new photos for existing or new faculty, it is also important to include a new record in NamePhotos so that the new picture will show up on the memberís description page.)

 

Adding New Events

††††††††To add a new event to the Photo History site (separate from events involving when new faculty members), the following steps need to be performed:

1)      Add a new record to Timeline including the date of arrival of the new member along with the picture of the event.

2)      Add a new record to NamePhotos and Images if uploading new images for this event.

a.       Create a thumbnail of the picture and upload it to the /fs/www/projects/photohistory/faculty_pictures directory of the project space.

b.      Upload original photo to the /fs/www/projects/photohistory/faculty_pictures_full directory of the project space.

If this is an event involving a new faculty member, it is also necessary to add a new faculty member as described above.

 

 

   

Last Modified: May 7, 2008

Web Accessibility