1 / 11

Plant Accession Application

Plant Accession Application. Maintenance Manual. Test Software. MySQL Database. Test Plant Accesion Database. Production Software. MySQL Database. Style Sheets. Style Sheets. Constants. Constants. Production Plant Accession Database. VBScript Procs. VBScript Procs. ASP Pages.

chiku
Download Presentation

Plant Accession Application

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Plant Accession Application Maintenance Manual

  2. Test Software MySQL Database Test Plant Accesion Database Production Software MySQL Database Style Sheets Style Sheets Constants Constants Production Plant Accession Database VBScript Procs VBScript Procs ASP Pages ASP Pages Accession Application Website Environment Overview • Development and DB Administration performed on local PC • WinHost.com used as webserver to Internet users Development Environment PC Running Windows 8 • Web Browsers • Firefox • Internet Explorer • IIS Services Version 8.5.9600.16384 • Classic ASP • VBScript • SQL Client (SQLyog) • SQL Server (MySQL) • FTP (AceFTP) • Text Editor (Metapad) • Email active server component (ASPMail)* Production Environment WinHost.com • Hosts the application website • WinHost Max Package Including: • Windows IIS V8 • MySQL • FTP • Classic ASP • VB Script • ASP Mail* • PHP* • Many others (See WinHost.com)* * Not required for this application Developer User * Not required for this application

  3. Test Software Microsoft Internet Information Services (IIS) Web Browser Text Editor (Metapad) MySQL Server MySQL Database Test Plant Accesion Database Style Sheets Constants SQL Client (SQLyog) VBScript Procs ASP Pages Accession Website Development Environment • All development and testing occurs locally on the developer’s PC • Root node is “localhost” PC Running Windows 8 Developer

  4. Two Products used in local development environment • AceFTP provides a GUI for FTP • It can be used for moving files back and forth between the development environment and the web server. • Other FTP packages similar to AceFTP can also be used. • SQLyog is a client program which provides a GUI for maintaining your MySQL databases. • It can connect to your local database, the database on WinHost, or to both at the same time. • It provide facilities for backup and restore as well as maintaining db structure and data • Other packages similar to SQLyog can also be used

  5. FTP Test Software PC Running Windows 8 WinHost.com FTP (AceFTP) Test Database Production Software MySQL Database Developer Style Sheets Style Sheets Constants Constants VBScript Procs VBScript Procs ASP Pages ASP Pages Updating the Accession Website Once a change has been made and tested in the development environment, it is moved to the production environment where it becomes visible to the general public.

  6. PC Running Windows Vista WinHost.com MySQL Server MySQL Client (SQLyog) Database Administrator Plant Accession Database LWAF Database Administration Environment • Database administration takes advantage of the MySQL Client/Server model. • Database backups, mass changes and other ad-hoc operations are done using the “SQLyog” client on the PC which is connected to the MySQL server on WinHost.com. • You can also use this same architecture to connect to the “localhost” server to do database administration on the local test database.

  7. Accession Website Directory Structure The directories shown below are those that contain accession website files. plantslw Root (/) directory Newsletters Administrative Arboretum Images CommonCode AppLWAF AppAccession JMNSoftware ArbDocs Help

  8. Single Plant Record Update Form Lookup Table Selection Menu Report Page Custom Report Menu Accession Home Page Lookup Table Update Form Mulitple Plant Records Update Form General Flow of Webpages Note: You can always go back to the Home Page or the Custom Report Menu from any screen.

  9. Accession Application Programs

  10. Accession Application Programs (Cont.)

  11. Submitted to plants.asp Redirects to Creates form Transfers to db_plant_maintain.asp Transfers to Creates form db_plant_maintain_list.asp Submitted to Creates form Submitted to Creates page Creates form Creates form Links to db_plant_report.asp Submitted to Submitted to Mulitple Plant Records Update Form Single Plant Record Update Form Lookup Table Update Form Accession Home Page Custom Report Menu Report Page Lookup Table Selection Menu Links to db_plant_select.asp Creates form Sumitted to index.asp db_plant_lookup_select.asp db_plant_lookup_maintain.asp Program/Webpage Relationship This chart shows: • What programs create what pages or forms • What programs forms are submitted to • What programs are invoked via links* • What programs are invoked via transfers * Note: All pages provide links back to plants.asp and db_plant_select.asp to show the accession home page and custom report menu respectively. However, these links are not shown on this diagram in order to limit the number of lines shown.

More Related