People and Projects Database System
By Zachary Olson (zolson@umd.edu)
Last Revision: 11/15/2008

Overview
The People and Projects database is a system designed to display information about all of the people who work here at LAMP and showcase all of the projects finished and in progress. The system is in addition to the PubDB system that manages publications for the department. As the PUbDB system does, this system is broken into two parts: the public display of the information and the private forms for editing the information.

Public Display
The public listing of information about people at LAMP is here: http://lampsrv02.umiacs.umd.edu/projdb/person.php, and the public listing of projects is here: http://lampsrv02.umiacs.umd.edu/projdb/project.php. The public interface is fairly simple, the person.php page displays a list of the people designated to be displayed to the public, and clicking on the link for any certain person on the list will take you to a page with that person's information on it. To the right is a box that allows the viewer to filter the list of people by their status. Unchecking an option from this list and hitting "View", will remove any people from the list who are of that type. By default, all types will be shown. To the left of the content are navigation links that will take you to the list of projects, which works the same way. Project.php will list the projects that have been designated to be displayed to the public on this page, and clicking a link will take you to a page with information about that project on it.
It should be noted, however, that not ALL people or projects that are stored in the database are listed on these two pages - some may have been marked on the edit pages for exclusion from these lists.

Private Database Editing
To edit information in the database, you must have a username and password, which you can obtain from Dr. Doermann (doermann@umiacs.umd.edu) or Zachary Olson (zolson@umd.edu). To log in, go to: http://lampsrv02.umiacs.umd.edu/projdb/edit/. Once logged in, choose whether you would like to edit people or projects, and you will be taken to a list of entries of that type in the database.

Editing People
You will be presented with a list of people currently entered into the database. As mentioned before, because the system includes options for excluding some people from the public listing, this list may be longer than the public list of people. Clicking on a name of a person will take you to a form to edit all of their information. You can also click the "DELETE" link next to a person's name to remove them from the database. Please note that this action is permanent, however, so only use it if necessary. On each person's page, there is, again, the option to omit them for whatever reason from the publicly displayed list - this may be a better alternative to completely deleting their record from the database. At the bottom and top of the list, there is a link to add a new record. Clicking this link will take you to a form exactly like that of the one you are taken to when editing a person, except it will be, obviously, blank. Also at the top of the page, there will be two check boxes - one to omit all people marked as "Alumni" and one to omit all people marked as "Associates." Just as with marking individual people to be omitted, these people will remain in the database, but will not be displayed as entries on the publicly viewable list of people.
Once on the form to either edit a person or add a new one, you have several pieces of information, all of which are optional, except the person's last name. The first three fields are "Prefix" "First Name" and "Last Name" the first is for any prefix to the person's name, such as "Dr." etc. The next option is the previously mentioned Omit checkbox. Selecting this will remove the person from the list of people that is displayed to the public. This option can be used to temporarily hide a person from the public list for whatever, or it may be a permanent choice so that for example, this person can be cited as an author for a project, but does not have enough information stored to be displayed on the main list of people. This option simply removes the person's name from the public list, but still allows people to view their profile by going to "person.php?id=####" where #### is the automatically generated id of this person's record. Next is a check box for "Alumni." Selecting this box will put "Alumni" next to their name in their profile, and will display a box for entering optional additional information about their new job, to be displayed in their profile in red before the rest of their information. The next option on the list is this person's "status" or relationship with LAMP. From here you can select one of the following: "Faculty," "Staff," "Researcher," "Visiting Researcher," "Affiliate," "Undergrad," "Intern," or "Graduate Student." If Graduate Student is chosen, a scroll box with checkboxes next to a list of people in the database will appear, so that advisors to this graduate student can be selected. This information will also be displayed under their name at the top of their profile page. The next field is "Position" - a brief statement of their title. "Years" is the next item on the form. Here you can input the year they started working, and if they have left, the year they left. Following is "Education" - a short statement of their highest degree achieved; for example: "Masters in Computer Engineering. University of Maryland, 2008." The next few fields deal with contact information - "Address", "Phone", "Fax", and "Email", all of which will be displayed EXACTLY as entered, so be sure to format it them way you wish. After the contact information, there is a field for "Homepage," a link to your personal website. Following this, is a group of fields to enter other relevant links, such as to other research you've done outside of LAMP. Enter a title and URL for each, and by clicking "More rows," you can add up to 10 entries at a time. If you wish to remove a saved link, simply clear its title and URL fields. Following "Other Links," is "Research Interests," a short couple of lines about primary focuses in research. Next is the ability to upload a picture. If there is already one connected to this profile, a link to preview it will be listed, and below it, an option to select a new file. "Biosketch" and "CV" are the next two options. They work the exact same way as uploading a picture, except that they must be either .txt or .pdf files, and will be displayed as links underneath the picture. Below these two, is a list of the currently documented projects in the database. Selecting any of these will not only link to this project on this person's profile page, but it will also cite this person as an author on that project's page. If you wish to cite a project that is not already in the database, you must create it separately before it will appear as an option on this list. The final item on the form is an option to change how the system lists publications for you. A list of publications will be displayed on each person's profile page, and this option allows you to tell the system to query the publications database by "last name only" (default), "Last name AND first name," or "Bibkeys" - which will then display a list of 5 fields for entry of 5 bibkeys of publications to be displayed on the profile page. In general, if publications are being displayed correctly on this person's profile page, there is no need to change this option. The three buttons at the top and bottom of the page are "Update" (which saves the new information), "Cancel" (which ignores the new information and redirects to the editable list of people), and "Preview" (Which opens a new window that displays preview of what the new information will look like - this will not reflect changes to the uploaded files, however - Pictures, Biosketches, and CVs).
Editing Projects
The edit page for projects is quite similar to that of people. You will be presented with a list of projects in the database, and next to each will be the same type of delete link, and again, at the top and bottom of the page, there is an option to create a new project.
On the page to edit a specific project (or create a new one), there will be a form, again, quite similar to that of a person's entry. The first field is for entering a title, and the second field allows for entry of authors - just as a person page allows for entry of projects. This list of will reflect which people in the database have selected this project as one that they worked on, and just as the list of projects on the people pages did, marking a person on this list will be reflected both on this project page AND on that person's profile page. Next is a field for entering an "Abstract" or general summary of the project. Following this is a form for entering a primary way of contacting someone about this project - it contains three fields: "Name," "Email," and "Phone," all of which are optional. Next is a keyword that will be used to query the database. If there are publications for this project, you should create a random unique key phrase for this project, enter it in this field, and then log into the publications database, and tag the matching publications with this keyword. Publications marked with this keyword will then be listed on the page for this project. Next are four upload sections: "Figures" (Images), "Software," "Datasets," and "Presentations." Any previously uploaded files will be displayed and the fields for uploading new files will be shown below. Just as with "Other Links" on the person editing pages, you can add up to ten records at a time by clicking the appropriate "More rows" link to the right of the fields. In addition, there is an option to select a "Primary Figure" to be displayed at the top of the page. To select one, click the bubble next to the file you wish to make primary; the file must be uploaded first, however, before it can be selected as primary. All four sections will also display a checkbox next to each previously entered file, which, if checked, will delete that file the next time this form is submitted via the "Update" button at the bottom or top of the page. The final field is for "Other Links," and works identically to the section for adding "Other Links" on the person page - enter a title and URL for each. You, again, can add up to ten at a time by hitting "More rows." To delete a record, simply clear the contents of both the url and the title fields for that record. Again, as with editing a person, there are buttons at the top and bottom of the page to "Update" the project, "Cancel" or delete any new changes and go back to the editable list of projects, and a button to "Preview" the new information on a page in a new window (Just as with people, this will not reflect any changes to files uploaded since the last submission - Figures, Software, Datasets, or Presentations).