{"id":452,"date":"2012-03-09T16:27:50","date_gmt":"2012-03-09T21:27:50","guid":{"rendered":"http:\/\/xlinesoft.com\/blog\/?p=452"},"modified":"2013-05-28T19:13:16","modified_gmt":"2013-05-29T00:13:16","slug":"survey-template","status":"publish","type":"post","link":"https:\/\/xlinesoft.com\/blog\/2012\/03\/09\/survey-template\/","title":{"rendered":"Survey template"},"content":{"rendered":"<p>This article explains the inner workings of Survey template.<\/p>\n<p>Before we start I encourage you to check <a href=\"http:\/\/xlinesoft.com\/livedemo\/survey\/login.php\">Survey template live demo<\/a>. Register, then login and add a new Survey. Add questions, answers and answer options where necessary. Once done with setup activate the survey. Now you can take survey, view responses etc.<\/p>\n<p><a href=\"https:\/\/usd.swreg.org\/cgi-bin\/s.cgi?s=32557&amp;p=32557-5&amp;q=1&amp;v=0&amp;d=0\">Purchase Survey template for $50<\/a><\/p>\n<h3>Application setup<\/h3>\n<p>Once you create a project using Survey template you can simply build your project and start using it. Security model is simple. There is one user by default (admin\/admin) with full access to all data. There is also Guest account enabled with access to Response view Add page so guest users are able to take surveys without logging in.<\/p>\n<p>There is also Registration page enabled. Users can register and create their own surveys. This option is mostly for demo purposes and you may want to turn it off.<\/p>\n<h3>Managing surveys<\/h3>\n<p>Once you are logged in create a new survey and add questions. Questions are grouped into groups. If you don&#8217;t need grouping simply add all question to default group (Group 1).<\/p>\n<p>List of surveys is your start screen. You can add or delete surveys here, make them active or inactive, take surveys and view responses.<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_surveys.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455 aligncenter\" title=\"survey_surveys\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_surveys.png\" alt=\"\" width=\"755\" height=\"266\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_surveys.png 944w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_surveys-300x105.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_surveys-150x52.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_surveys-400x141.png 400w\" sizes=\"auto, (max-width: 755px) 100vw, 755px\" \/><\/a><\/p>\n<p><!--more--><\/p>\n<p>Each survey is created as inactive. You are free to modify survey structure, add or delete groups and questions. Once you done customizing your survey activate it. Survey activation creates a physical table in the database that will store all responses. You should only activate a survey when you are absolutely certain that your survey setup is finished and will not need changing.<\/p>\n<p>Once a survey is activated you can no longer:<\/p>\n<ul>\n<li>Add or delete groups<\/li>\n<li>Add or delete questions<\/li>\n<li>Add or delete answers<\/li>\n<\/ul>\n<p>However you can still:<\/p>\n<ul>\n<li>Edit your questions code\/title\/text and advanced options<\/li>\n<li>Edit your group names or descriptions<\/li>\n<li>Add, remove or edit answer options<\/li>\n<li>Change survey name or description<\/li>\n<\/ul>\n<p>Once data has been entered into this survey, if you want to add or remove groups or questions, you will need to deactivate this survey, which will move all data that has already been entered into a separate archived table.<\/p>\n<p>Typical survey table name is <strong>sv_survey_{ID}<\/strong> where {ID} is survey id from <strong>sv_surveys<\/strong> table. When survey is deactivated table with responses renamed to something like <strong>sv_survey_old_1_20120307233417<\/strong> (20120307233417 is the timestamp).<\/p>\n<h3>List of questions<\/h3>\n<p>This is you main single survey management screen. You can add\/edit\/delete questions, answers and answer options here, reorder groups and questions.<\/p>\n<p><a href=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_questions.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-454\" title=\"survey_questions\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_questions.png\" alt=\"\" width=\"604\" height=\"559\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_questions.png 604w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_questions-300x277.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_questions-150x138.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_questions-400x370.png 400w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/a><\/p>\n<h3>Question types<\/h3>\n<p>Survey template allows you to choose from the following question types<\/p>\n<p>&nbsp;<\/p>\n<p><strong>List<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list.png\" alt=\"\" title=\"survey_list\" width=\"449\" height=\"202\" class=\"size-full wp-image-474\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list.png 449w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list-300x134.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list-150x67.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list-400x179.png 400w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>List (5 point choice)<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list5.png\" alt=\"\" title=\"survey_list5\" width=\"448\" height=\"198\" class=\"size-full wp-image-475\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list5.png 448w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list5-300x132.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list5-150x66.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list5-400x176.png 400w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>List (10 point choice)<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list10.png\" alt=\"\" title=\"survey_list10\" width=\"498\" height=\"197\" class=\"size-full wp-image-476\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list10.png 498w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list10-300x118.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list10-150x59.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_list10-400x158.png 400w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Dropdown box<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_dropdown.png\" alt=\"\" title=\"survey_dropdown\" width=\"451\" height=\"194\" class=\"size-full wp-image-473\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_dropdown.png 451w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_dropdown-300x129.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_dropdown-150x64.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_dropdown-400x172.png 400w\" sizes=\"auto, (max-width: 451px) 100vw, 451px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Date<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_date.png\" alt=\"\" title=\"survey_date\" width=\"450\" height=\"246\" class=\"size-full wp-image-472\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_date.png 450w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_date-300x164.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_date-150x82.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_date-400x218.png 400w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Long text<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_longtext.png\" alt=\"\" title=\"survey_longtext\" width=\"511\" height=\"264\" class=\"size-full wp-image-477\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_longtext.png 511w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_longtext-300x154.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_longtext-150x77.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_longtext-400x206.png 400w\" sizes=\"auto, (max-width: 511px) 100vw, 511px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Multiple choice<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_multiple_choice.png\" alt=\"\" title=\"survey_multiple_choice\" width=\"449\" height=\"153\" class=\"size-full wp-image-478\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_multiple_choice.png 449w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_multiple_choice-300x102.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_multiple_choice-150x51.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_multiple_choice-400x136.png 400w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Number<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_number.png\" alt=\"\" title=\"survey_number\" width=\"243\" height=\"83\" class=\"size-full wp-image-481\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_number.png 243w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_number-150x51.png 150w\" sizes=\"auto, (max-width: 243px) 100vw, 243px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Multiple choice with comments<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_multiple_choice.png\" alt=\"\" title=\"survey_multiple_choice\" width=\"449\" height=\"153\" class=\"size-full wp-image-478\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_multiple_choice.png 449w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_multiple_choice-300x102.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_multiple_choice-150x51.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_multiple_choice-400x136.png 400w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Radio-buttons<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_radio_buttons.png\" alt=\"\" title=\"survey_radio_buttons\" width=\"447\" height=\"174\" class=\"size-full wp-image-482\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_radio_buttons.png 447w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_radio_buttons-300x116.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_radio_buttons-150x58.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_radio_buttons-400x155.png 400w\" sizes=\"auto, (max-width: 447px) 100vw, 447px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Simple text, no question<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_no_question.png\" alt=\"\" title=\"survey_no_question\" width=\"456\" height=\"93\" class=\"size-full wp-image-480\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_no_question.png 456w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_no_question-300x61.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_no_question-150x30.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_no_question-400x81.png 400w\" sizes=\"auto, (max-width: 456px) 100vw, 456px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Text<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_text.png\" alt=\"\" title=\"survey_text\" width=\"446\" height=\"82\" class=\"size-full wp-image-483\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_text.png 446w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_text-300x55.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_text-150x27.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_text-400x73.png 400w\" sizes=\"auto, (max-width: 446px) 100vw, 446px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>File upload<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_upload.png\" alt=\"\" title=\"survey_upload\" width=\"508\" height=\"191\" class=\"size-full wp-image-484\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_upload.png 508w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_upload-300x112.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_upload-150x56.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_upload-400x150.png 400w\" sizes=\"auto, (max-width: 508px) 100vw, 508px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Checkbox<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_checkbox.png\" alt=\"\" title=\"survey_checkbox\" width=\"382\" height=\"66\" class=\"size-full wp-image-471\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_checkbox.png 382w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_checkbox-300x51.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/survey_checkbox-150x25.png 150w\" sizes=\"auto, (max-width: 382px) 100vw, 382px\" \/><\/p>\n<h3>Visual appearance and additional files<\/h3>\n<p>To tweak visual appearance of your surveys modify the following files (can be found in project directory):<br \/>\nbusiness\\Survey\\source\\templates\\survey.htm &#8211; &#8216;take a survey&#8217; template<br \/>\nbusiness\\Survey\\source\\templates\\survey_view.htm &#8211; &#8216;view single response&#8217; template<br \/>\nbusiness\\Survey\\source\\templates\\activate_survey.htm &#8211; message displayed in popup before survey activation<br \/>\nbusiness\\Survey\\source\\templates\\deactivate_survey.htm &#8211; message displayed in popup before survey deactivation<br \/>\nbusiness\\Survey\\source\\survey.css &#8211; survey style sheet<\/p>\n<p>HTML templates are similar to standard PHPRunner\/ASPRunnerPro templates and use the same <a href=\"http:\/\/xlinesoft.com\/phprunner\/docs\/smarty_templates.htm\">template language<\/a>.<\/p>\n<p>Here is the sample of <strong>survey.htm<\/strong> template:<\/p>\n<pre lang=\"html4strict\">\r\n<form id=\"surveyform\" action=\"response_add.php{$page}\" method=\"post\">\r\n<input name=\"a\" type=\"hidden\" value=\"added\" \/>\r\n<input id=\"locat\" name=\"locat\" type=\"hidden\" \/>\r\n<input id=\"error\" name=\"error\" type=\"hidden\" \/>\r\n<input name=\"hash\" type=\"hidden\" value=\"{$hash}\" \/>\r\n<input id=\"format_date\" name=\"format_date\" type=\"hidden\" value=\"{$format_date}\" \/>\r\n\r\n<div class=\"showtest\">\r\n{BEGIN group}\r\n\r\n<div class=\"question\">\r\n\r\n<div class=\"qnumdiv\">\r\n\r\n{$group_name}\r\n\r\n<\/div>\r\n\r\n{BEGIN description_block}\r\n\r\n{$group_description}\r\n\r\n{END description_block}\r\n{$questions}\r\n\r\n<\/div>\r\n\r\n{END group}\r\n\r\n<div class=\"buttons\">\t\r\n{BEGIN prev_button}\r\n<input class=\"button\" onclick=\"validation('prev');\" type=\"button\" value=\"Prev\" \/>\r\n{END prev_button}\r\n{BEGIN finish_button}\r\n<input class=\"button\" onclick=\"validation('next');\" type=\"button\" value=\"{$buttonname}\" \/>\r\n{END finish_button}<\/div>\r\n<\/div>\r\n\r\n\u00a0<\/form><\/pre>\n<h3>Update: Version 1.1, May 24, 2012<\/h3>\n<p>In this update:<\/p>\n<ul>\n<li>Question preview in popup.<\/li>\n<li>View all responses for selected question.<\/li>\n<li>New Survey layout. When you create\/edit survey choose between Silver-Blue and Grey templates<\/li>\n<li>Add optional long question description.<\/li>\n<li>Display additional question instructions under the question or on the right.<\/li>\n<\/ul>\n<p>Grey template<br \/>\n<a href=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/grey.png\"><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/grey-300x270.png\" alt=\"\" title=\"grey\" width=\"300\" height=\"270\" class=\"size-medium wp-image-615\" style=\"display: block\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/grey-300x270.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/grey-150x135.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/grey-400x360.png 400w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/grey.png 822w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><br \/>\n<\/a><\/p>\n<p>Silver-blue template<br \/>\n<a href=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/silver-blue.png\"><br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/silver-blue-300x256.png\" alt=\"\" title=\"silver-blue\" width=\"300\" height=\"256\" class=\"size-medium wp-image-616\" style=\"display: block\" srcset=\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/silver-blue-300x256.png 300w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/silver-blue-150x128.png 150w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/silver-blue-400x341.png 400w, https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2012\/03\/silver-blue.png 825w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><br \/>\n<\/a><\/p>\n<p><strong>Upgrade instructions<\/strong><\/p>\n<p>If you upgrading your projects from previous version of Survey template and want to keep existing surveys\/responses here is what you need to do:<\/p>\n<p>&#8211; If you use SQL Server database execute database\\db_update.sql script against your existing database. If you use MySQL execute database\\dbmysql_update.sql script. This will create new tables and fields. Then create a new project using Survey Template and point it to existing database. Choose &#8216;Use existing&#8217; option to reuse existing tables. <\/p>\n<p>&#8211; MS Access Survey projects cannot be upgraded automatically. You will need to create a new project and then copy data from old database file to new one manually.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article explains the inner workings of Survey template. Before we start I encourage you to check Survey template live demo. Register, then login and add a new Survey. Add questions, answers and answer options where necessary. Once done with setup activate the survey. Now you can take survey, view responses etc. Purchase Survey template for $50 Application setup Once you create a project using Survey template you can simply build your project and start using it. Security model is simple. There is one user&#8230;<span class=\"clearfix clearfix-post\"><\/span><a href=\"https:\/\/xlinesoft.com\/blog\/2012\/03\/09\/survey-template\/\" class=\"more-link\">Continue Reading <span class=\"screen-reader-text\">&#8220;Survey template&#8221;<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,8],"tags":[],"class_list":["post-452","post","type-post","status-publish","format-standard","hentry","category-php-category","category-tutorials"],"_links":{"self":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/452","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/comments?post=452"}],"version-history":[{"count":33,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/452\/revisions"}],"predecessor-version":[{"id":839,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/posts\/452\/revisions\/839"}],"wp:attachment":[{"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/media?parent=452"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/categories?post=452"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlinesoft.com\/blog\/wp-json\/wp\/v2\/tags?post=452"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}