4th March 2011: Get the project from Dr S.Manoharan. Build a bird view of ISSG through their official website.
9th March 2011: Kick-off meeting with Mrs. Shyama. Mrs. Shyama provided a brief introduction about ISSG. Also we have a look about the existed web-page and database. We have discussed some possible layout and functions about the future website.
15th March 2011: Angela has sent me an email about how the project should work. After a few discussions with her, we decided to transfer the existed MySQL database to MSSQL database and use Asp.net to construct the webpage.
21st March 2011:Mrs. Shyama has sent me the existed MySQL database issg_mssql_export. I have loaded this database to my local service and looks through the details about this database.
2nd April 2011: A second copy of MySQL database has been created for testing purpose. The existed database is being uploaded to the university database service.
8th April 2011: All bugs from the existed database are being fixed. Start to convert the MySQL database to MSSQL database by using third party application: MySQL to MSSQL v4.3.
14th April 2011:Another meeting with Angela to confirm the web page layout and designs. SQL data structures for all tables as a virtual map is created for analyze purpose.
21st April 2011: Research paper for how to build user friendly web page is collected from the university library and internet. A paper design of how the web page will looks like is been created.
3rd May 2011: Introduction presentation is done in Tamaki Campus. A presentation can be found in the related works web page.
27th May 2011: Another meeting with Mrs.Shyama. During the meeting, we have discussed the structure and content of the new database. We have also confirmed that we are going to use MSSQL. At the end, we request a new SQL file as the previous SQL database have empty data for some important tables such as (eradication).
30th May 2011: A excel file rather than SQL file has been received from Mrs.Shyama. The excel file contains most of the data for the eradication table. We have to input these data manually by ourselves.
4th June 2011: The main table (eradication) has been restructured to with actual data.
5th June 2011: A prototype of DAL has been created. All interfaces for the websites has been designed on paper.
20th June 2011: A new database form Microsoft Access has replaced the previous MySQL database.
27th June 2011: The structure of the new database has been refined with two extra tables: world region and country.
1st August 2011: DAL for select island and species is done.
3rd August 2011: All DAL for the version1 of the webpage is done.
7th August 2011: An incomplete version for testing purpose is done. This page will only select the related island based the user input.
Exam & Holiday
30th August 2011: DALs have been reconstructed with the correct outer join instead of inner join. The previous inner join will crashed in some rare cases.
5th September 2011: The search by location is done for version1.
7th September 2011: The search by name is done for vesrion1.
8th September 2011: Background image and buttons have been added to the version1, a copy version of the webpage has been emailed to Mrs.Shyama.
16th September 2011: the database has been updated with more eradication records and islands. Also some unnecessary tables have been deleted.
26th September 2011: A meeting with Mrs.Shyama. During the meeting we decide to implement Telerik Control Kit to the project and make a new version of the webpage.
28th September 2011: A Telerik Radgrid View has been added to the webpage.
1st October 2011: The first two level of the Radgrid View has been completed for both search by location and search by Name.
5th October 2011: The third level of the Radgrid view has been completed; search by location and search by name have been merged to one webpage by using tab view.
6th October 2011: The layout of the new webpage has been completed with new images and links.
17th October 2011: Null data will not display in the details view any more. Also the presentation has been made.
20th October 2011: Final presentation has been made.
21st October 2011: Webpage and database has been uploaded to the services, performance tests have been completed.
24th October 2011: Final report is done and host to the main page.
