MyPyramid Menu Planner Software Development Package

This CD includes all software components for the MICROSOFT Windows based web application called MyPyramid Menu Planner (Menu Planner). Menu Planner was developed by the AMERICAN SYSTEMS for USDA'S Center for Nutrition Policy and Promotion (USDA/CNPP) and is available to general public at http://www.mypyramidtracker.gov/planner. 

This package is intended for application developers who would like to use the Menu Planner code base and provide their own customizations, enhancements, or complete rewrites using the nutritional data and algorithms used by Menu Planner. It contains a backup of the Menu Planner database and complete source code of the Visual Studio 2005 Menu Planner project.

SYSTEM REQUIREMENTS:

1- Operating System: MICROSOFT Windows XP, service pack 2 with IIS component installed and enabled.
2- Visual Studio 2005 or later.
3- SQL server 2005 or later (a local or remote instance accessible from the client running VS2005)
4- .Net 2.0 framework
5- VB.NET and ASP.NET 2.0

INSTALLATION INSTRUCTIONS:

1- Unzip the content of the package in the compressed folder (using WinZip(R) version 9.0 SR-1 or later) called Mypyramid Planner Application.zip to local hard drive.
2- For the protected files use the password: Mypyr@midPl@nner 
3- Restore the database to your Microsoft SOL Server 2005 or later from the backup provided in the “MyPyramid planner application\database” directory of the unzipped package.
4- Create a user login for the restored database with “db owner” privileges.
5- Create a new web site in IIS, make it an application, and set its ASP.NET version to 2.0, also add "launch.aspx" to the Default Document list in IIS.
6- On the virtual directory tab, set the local path to the 'MyPyramid planner application' directory of the unzipped package.
7- Open the PyramidVB2.sln file residing in the “MyPyramid planner application” directory, in a text editor and modify the 3rd line from the top: 
project("{E24C65DC-7377-472B-9ABA-BC803B73C61A}") = "http://localhost/MypyramidPlanner/", "http://localhost/MypyramidPLanner", "{A8E2A3C1-9F5A-4DD8-BDAD-7AE0E0204B4C}"  so that both instances of http://localhost/MyPyramidPlanner match the address of the web site you created in IIS during step 4.
8- Open the solution in VS 2005 by double clicking the PyramidVB2.sln file. The solution will contain two projects:
	
1) DAL (data access layer)
	2) The web site



9- Scroll down the solution explorer to the web.config file and open it.
10- Replace the servername,databasename,username, and password in the "siteSqlServer" key in the appSettings with the correct information for your environment.
11- Set "LauchPage.aspx" as start page for general public, or Set “LauchPage_pb.aspx” as start page for Moms in the solution explorer within Visual Studio.

<appSettings>
<add key="SmtpServer" value="192.168.1.1"/>
<add key="FromEmail" value="mypyramid-planner-noreply@cnpp.usda.gov"/>
<add key="SiteSqlServer"  value="SERVER=servername;DATABASE=databasename;UID=username;PWD=password;Enlist=false;Pooling=true;Min Pool Size=5;Max Pool Size=60;"/>
</appSettings> 

OTHER NOTES:

1.	This application uses Ajax.NET Professional for interactive components and log4net utility for logging purposes.

2.	This application also uses Adobe Flash for the main portion of the application which will require Adobe Flash profession version 9.0 or higher to edit.

3.	The source code for the main movie within the application is called "USDA Bar Chart.fla" which generates the barchart.swf file.

4.	The sitetour source code is "USDA Site Tour.fla" in the sitetour folder and it generates the siteTour.swf file.

5.	This software package is provided as is. Installation support is not included.