ReadMe for Soundings License: Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. This readme file only contains release notes and changes. For more information, read the Welcome to Soundings document included with the zip. If you find this application useful, please consider visitng my Amazon wishlist: http://www.amazon.com/o/registry/2TCL1D08EZEYE Last Update: August 22, 2007 (Version 2.003) /includes/udf.cfm - added a new udf /tags/surveydisplay.cfm - fix for broken Arrays Last Update: August 16, 2007 (Version 2.002) Updated MySQL install script by Jared Raddigan Last Update: August 7, 2007 (Version 2.001) Updated MySQL install script by Lola Beno Changed title of admin/password.cfm Last Update: August 3, 2007 (Version 2) Most files were updated. I didn't correctly log them all, so just consider everything updated. John Ramon did the new design. Logo by Alex McKinney. Major new features: Pagination is supported in surveys now. Currently set to soundings.ini perpage value. Next version will allow per survey page setting. Reports updated to include PDF. Reports now let you filter out questions using Spry. Admin has new look and feel. True user manager for admin. Right now all users can do anything they want in admin. You need to add the users table to your database. Last Update: April 10, 2006 (Version 1.6) I haven't tracked particular files, but this update includes a fix for CF8 compatability and some minor layout updates. More updates coming soon. Last Update: April 10, 2006 (Version 1.5.2) /cfcs/question.cfc and survey.cfc: Fixes for a bug that occurs when you delete a question and don't correct rank. /handlers/text/display.cfm /handlers/truefalse/display.cfm /pagetemplates/admin_header.cfm /pagetemplates/main_header.cfm /pagetemplates/main_footer.cfm /pagetemplates/plain_header.cfm /stylesheets/style.css All of the above: Minor layout changes by John Paul Ashenfelter. Less use of tables. More CSS. good++; /tags/surveydisplay.cfm - show name of survey in survey display /handlers/matrix/display.cfm - wasn't working when you went backwards. Last Update: March 30, 2006 (Version 1.5.1) /admin/stats.cfm - tableprefix fix /admin/surveys_edit.cfm - support for Clear Results action /cfcs/question.cfc - tableprefix fix /cfcs/survey.cfc - support for Clear Results action /handlers/matrix/save.cfm and stats.cfm - tableprefix fix /handlers/muptiplechoice/ Ditto the above /handlers/textbox/ Ditto the above /handlers/truefalse/ DItto the abofe Last Update: March 22, 2006 (Version 1.5.003) /cfcs/survey.cfm - Forgot one thing for CFMX6 support. Last Update: March 22, 2006 (Version 1.5.002) /admin/stat.cfm - Forgot one thing for CFMX6 support. Last Update: March 22, 2006 (Version 1.5.001) /cfcs/survey.cfc for a table prefix fix. /cfcs/question.cfc - Make getAnswers order by rank Last Update: March 10, 2006 Update: 3/10/06 (Version 1.5) /admin/* - All files in admin touched as part of 'Remove Mapping' update. Note that I didn't bother updating the headers for some pages. /admin/stats* - Support for CFMX6 brought back in. Charts now all have a set height. Kinda big - but simpler. /cfc/* - Support for table prefix. Removed mapping setting from ini file. /pagetemplates/main_header and plain_header - Modded to work w/o mapping /tags/layout.cfm, surveycomplete.cfm, surveydisplay.cfm - ditto /Application.cfm, ditto, plus IE fix for hitting Enter in logon form /index.cfm, /survey.cfm - removed mapping need Docs updated to reflect no mapping and tableprefix feature. Update: 2/11/06 (Version 1.4) /admin/index.cfm - I just changed the text a bit. /admin/stats.cfm - Fixed an ordering bug in matrix reports. /cfcs/survey.cfc - Caching to help excel reporting. /handlers/matrix/stats.cfm - Helps fix ordering issue in matrix reports. /install/ - Word doc updated with license and PDF added. 12/19/05 MySQL file had a bug. It marked answers.rank as unsigned. It needs to be signed for Matrix support. 11/22/05 /handlers/matrix/edit.cfm - error when deleting item - Thanks to Mal Brisbane 11/2/05 /admin/index.cfm - just changed the date /handlers/multiplechoice/stats.cfm - major fix handlers/matrix/display.cfm - fix for UUIDs with #s in them 10/28/05 admin/stats - forgot to remove debug code, fix in matrix stat colors handlers/multiplechoice/edit and display - limits to field size handlers/textbox/ditto install/mysql.sql - typo fix 10/8/05 Many files changed, so I recommend copying all of them over. Added support for Matrix style questions. This requires 1-2 database changes. The first change you must make. Edit the results table and add a itemidfk column. Type should be nvarchar (or equivalent) with size=35. Null ok. The second change is to add support for Matrix style questions. You can either copy the insert from the db script, or use the Soundings admin to add it yourself. Name should be Matrix, and handler root should be matrix.