Survey v. 1.1.0 - The open source web survey and form engine

Available release packages for the Survey v. 1.1.0 solution:

- Install : http://survey.codeplex.com/Release/ProjectReleases.aspx
- Upgrade : see instructions below
- Source : http://survey.codeplex.com/SourceControl/ListDownloadableCommits.aspx#DownloadLatest
- MSI install : available soon

Instructions "Survey 1.1.0 Install package" - New Installation

1. SYSTEM REQUIREMENTS
- .NET Framework 2.0 or higher must be installed
- IIS webserver
- Smpt mailserver account
- MsSqlserver 2000 database
- supported Operating Systems are Windows7, Vista, XP, Windows 2000, Windows Server 2003, Windows Server 2008
- you must have administrator privileges on your computer

Free downloads available at http://www.asp.net/downloads/

2. FILES
- download zipped install package to your computer
- unzip files to (new) file directory (e.g. C:/Survey/..)

3. IIS
- create a Virtual Directory in IIS e.g. called Survey which points to the directory where the Survey files are unzipped
- make sure you have default.aspx specified as a Default Document for your Virtual Directory
- set Aspnet to version 2.* (or higher)

4. DATABASE

Option 1. "Automated DB installation"

- start SQL Server 2000 or MSDE 2000 (using Enterprise Manager or your tool of choice )**
- open sql file Survey110DBInstall.sql from the SQL website directory in a query window
- set database to 'master' db (use master)
- run sql query to create "Nsurvey" database
- check to see if database was created correctly


Option 2. "Manual DB installation"

- start SQL Server 2000 or MSDE 2000 (using Enterprise Manager or your tool of choice )**
- create empty database

- open sql file Survey110DBInstall_manual.sql from SQL websitedirectory in query window
- set database to db you just created: use dbname
- run sql query to create "dbname" database
- check to see if database was created correctly

  • Both MsSqlserver 2005 and 2008 can be used to create and administer the Survey DB.
    • Optional: run queries from SurveySamples.sql to create an initial survey sample.

5. SECURITY
If using Windows 2000 or XP - IIS5
- the {Server}/ASPNET user account must have Read, Write and Change Control
of the root application directory (this allows the application to create files/folders )

If using Windows 2003 - IIS6
- the {Server}/NetworkService user account must have Read, Write and Change Control
of the root application directory (this allows the application to create files/folders )

6. CONNECTION
- open web.config in notepad or texteditor
- Check the connection string in web.config file. Default is:
<add key="NSurveyConnectionString" value="server=(local);Integrated Security=SSPI;database=nsurvey" />
- As an alternative try:
<add key="NSurveyConnectionString" value="Server=YourSqlServer;Database=YourDatabase;uid=YourDbUser;pwd=YourPassword" />

7. SMPT MAILSETTINGS
- open web.config in notepad or texteditor
- check smpt settings. Default is:
<add key="NSurveySMTPServer" value="127.0.0.1" />
<add key="NSurveySMTPServerPort" value="25" />
<add key="NSurveySMTPServerAuthUserName" value="" />
<add key="NSurveySMTPServerAuthPassword" value="" />

8. START SURVEY
- browse to localhost/NameOfSurveySite in your web browser
- the application will start running

Instructions "Survey 1.1.0 Install package" - Upgrade Installation

- No special upgrade package is available;
- To upgrade the Survey 1.0 installation to version 1.1:

a. Database
  • open sql file SurveyDBupgrade11.sql websitedirectory in query window
  • add additional entry in vts_tbSecurityRight for Help menu option

b. Webfiles
  • go to Survey webroot directory;
  • backup web.config file
  • delete all files from Survey webroot directory
  • copy new Survey 1.1 webfiles and directories to your Survey webroot
  • replace new web.config file with backup of web.config

Check:
- IIS settings
- Security settings

Next start Survey in webbrowser.

Last edited Mar 5, 2010 at 9:18 AM by fwsmaster, version 1

Comments

No comments yet.