 |
  |
|
|||||||
|
||||||||||||||||||||||||||||
|
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 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
