How To Install Limesurvey On Windows 7

The following answers have been provided past the LimeSurvey user community. In example you do not empathize something or you are unsure about what you accept to do next, y'all can accost your question(s) to the rest of community members: https://forums.limesurvey.org. For professional help, please check our list of authorized partners: https://limesurvey.com.

Getting started

If you don't want to read one-half the manual to get a feeling what tin be washed with LimeSurvey, we recommend you to lookout man some YouTube video tutorials:

• How to set up an account and survey installation
• Question blazon - Assortment
• Assessments
• Placeholder fields
• Radio listing
• Re-create/import survey
• Import question

If yous know whatever good video out there, do not hesitate to share it with united states of america.

I need a quick introduction for LimeSurvey

For a quick text introduction to LimeSurvey, check the following two links:

• LimeSurvey 2.50+
• Limesurvey 3+

  We are working at the moment on introductory videos to LimeSurvey.

Survey design and layout

How can I remove index.php from the URL path to get a shorter URL

If y'all want to use fancy URLs (non take /index.php in every URL), delight edit /application/config/config.php and change

                        'showScriptName'            =>            true            ,          

to

                        'showScriptName'            =>            simulated            ,          

For this to piece of work properly, yous must employ an Apache webserver with a properly installed mod_rewrite module.

With nginx webserver

If yous are using the Nginx http server (with php running via FastCGI) and want to employ the 'urlFormat' => 'path' setting (meet config.php), consider the following Nginx website configuration:

                        server            {            set            $host_path            "/PATH/TO/LIMESURVEY";            server_name            YOUR.SERVER.FQDN;            root            /PATH/TO/LIMESURVEY;            charset            utf-8;            try_files            $uri $uri/            /index.php?r=$uri&$args;            #Disallow reading inside php script directory, come across upshot with debug > i on notation            location            ~ ^/(application|docs|framework|locale|protected|tests|themes/\w+/views) {            deny            all;            }            #     Allow access to well-known directory, different usage, for example Peak Challenge for Let's Encrypt            location            ~ /\.well-known {            allow            all;            }            # Deny all attempts to access subconscious files            # such equally .htaccess, .htpasswd, .DS_Store (Mac).            location            ~ /\. {            deny            all;            }            #Disallow straight read user upload files            location            ~ ^/upload/surveys/.*/fu_[a-z0-9]*$ {            return            444;            }            #Disallow uploaded potential executable files in upload directory            location            ~*            /upload/.*\.(pl|cgi|py|pyc|pyo|phtml|sh|lua|php|php3|php4|php5|php6|pcgi|pcgi3|pcgi4|pcgi5|pcgi6|icn)$ {            return            444;            }            #avoid processing of calls to unexisting static files by yii            location            ~ \.(js|css|png|jpg|gif|swf|ico|pdf|mov|fla|cipher|rar)$ {            try_files            $uri =404;            }            location            ~ \.php$ {            fastcgi_split_path_info            ^(.+\.php)(.*)$;            try_files            $uri index.php;            fastcgi_pass            127.0.0.one:9000; # Change this to friction match your settings            fastcgi_index            index.php;            include            fastcgi_params;            fastcgi_param            SCRIPT_FILENAME  $document_root$fastcgi_script_name;            fastcgi_param            SCRIPT_NAME      $fastcgi_script_name;            }            }          

This disables access to files within application. Some JavaScript and CSS files located within the awarding have to be readable with debug > 0. You can strength the usage of the asset managing director when the debug mode is enabled with 'use_asset_manager' => 1, in your config file (or remove application from the directory list).

The finish outcome should expect like this:

How do I become rid of the * (red asterisk) of mandatory questions?

Instructions for LimeSurvey two

In LimeSurvey 2.x, the carmine asterisk of mandatory questions is ready inside the template.css file ("asterisk" grade). To hide information technology:

• Open the template editor
• Create a copy of the template you lot wish to change
• Select the "template.css" file and search for the asterix grade
• Add together the following line at the stop of the asterix class".asterisk {display: none;}".
• Salvage template.css
• Clear your browser cache so that the edited template.css is reloaded and not taken from cache.

Instructions for LimeSurvey 3

The instructions are similar to the ones presented higher up for LimeSurvey 2.

• Access the desired theme. If it is a default theme, create a copy of information technology by clicking on the "extend" button.
• Access the list of themes and click on the theme editor that corresponds to the newly created theme.
• On the left side, y'all can visualise the corresponding CSS files of your theme.
• Click on custom.css and add together the following line:

                        .            asterisk            {            display            :            none            ;}          

• Save the changes. The scarlet asterisk that is usually displayed at the showtime of the question text is hidden.

How can I embed a wink file?

Starting time, become to Global settings and deactivate the XSS-filter. Delight besides read upward the implications deactivating that filter has on your instance. The following steps will not work if the filter is active.

1. Navigate to the identify in your survey where you want insert your Wink file. This can be anywhere where you tin can utilise the integrated HTML editor, for example in questions, subquestions, answers, survey welcome/end text and many more than.
2. Open the full-screen editor mode by clicking the 'LimeFitWin' button on the editor tool-bar.
3. On the full-screen editor tool-bar you lot will detect a trivial button with a Wink symbol. Click on it. A dialog box will open.
4. In this box you can give either the path to an existing Wink file somewhere or you click the 'Browse server' push.
5. If you clicked the 'Browse server' button you volition be presented with a file browser and on the bottom an file upload field. Choose at present an existing file or upload a file first.

That's it! If you find this description incomplete please update it accordingly.

Attention : The steps to use it in LimeSurvey 3 are similar. Yet, we do not recommend our users to use wink files!

How practice I create a survey which is open to everyone?

To create a survey that can be filled out by anyone, exercise not create a survey participants table! Share the survey link located on the overview panel.

Public registration - mandatory fields

If yous use a survey participants table and you besides allow public registration, then users volition be prompted by the following bulletin:

Every bit information technology tin can be observed above, merely the email field is mandatory.

To have all three fields marked as existence mandatory, please edit your survey theme accordingly. If you use Fruity, yous have to go to the registration screen and see how the participants electronic mail field looks like:

                                                {# Participants electronic mail #}                                      <div class='            {{            aSurveyInfo.class.registerformcolrowc            }}                          form-group row'                        {{            aSurveyInfo.attr.registerformcolrowc            }}            >                          <label                        {{            aSurveyInfo.attr.registerformcolrowclabel            }}                          class='            {{            aSurveyInfo.class.registerformcolrowclabel            }}                          command-characterization'>                        {{            gT            (            "Electronic mail address:"            )            }}                                    {{            include            (            './subviews/registration/required.twig'            )            }}            </label>                          <div                        {{            aSurveyInfo.attr.registerformcolrowcdiv            }}                          >                                    {{            C.H            tml.textField            (            'register_email'            ,            aSurveyInfo.sEmail            ,            ({            'id'            :            'register_email'            ,            'class'            :            'form-control input-sm'            ,            'required'            :            truthful            }))            }}                                      </div>                          </div>          

After that, brand sure to edit the commencement proper name and last proper noun fields correspondingly by adding the label:

                        {{            include            (            './subviews/registration/required.twig'            )            }}                      

and this line which makes the field mandatory to exist filled out:

The edited file should expect like this:

                                                {# Participants kickoff name #}                                      <div class='            {{            aSurveyInfo.class.registerformcolrow            }}                          form-group row'                        {{            aSurveyInfo.attr.registerformcolrow            }}            >                          <characterization for='register_firstname' course='            {{            aSurveyInfo.class.registerformcolrowlabel            }}                          command-label '>            {{            gT            (            "First name:"            )            }}                                    {{            include            (            './subviews/registration/required.twig'            )            }}            </label>                        {# extra label #}                                      <div grade="">                                    {{            C.H            tml.textField            (            'register_firstname'            ,            aSurveyInfo.sFirstName            ,            ({            'id'            :            'register_firstname'            ,            'class'            :            'form-control'            ,            'required'            :            true            }))            }}                                    {# mandatory field #}                                      </div>                          </div>                                    {# Participants last name #}                                      <div course='            {{            aSurveyInfo.class.registerformcolrowb            }}                          form-grouping row'                        {{            aSurveyInfo.attr.registerformcolrowb            }}            >                          <label                        {{            aSurveyInfo.attr.registerformcolrowblabel            }}                          class='            {{            aSurveyInfo.class.registerformcolrowblabel            }}                          control-label '>            {{            gT            (            "Terminal name:"            )            }}                                    {{            include            (            './subviews/registration/required.twig'            )            }}            </label>                        {# extra characterization #}                                      <div                        {{            aSurveyInfo.attr.registerformcolrowbdiv            }}                          >                                    {{            C.H            tml.textField            (            'register_lastname'            ,            aSurveyInfo.sLastName            ,            ({            'id'            :            'register_lastname'            ,            'class'            :            'form-command'            ,            'required'            :            true            }))            }}                                    {# mandatory field #}                                      </div>                          </div>          

Now, the public registration folio should wait like this (all the fields being mandatory):

Hiding the language switcher

The steps to hide both the language switchers (near the survey title and on the meridian-right side of the page) are described in our wiki department defended to multilingual surveys.

Hiding "Exit and clear survey"

In example you wish to hibernate the button "Go out and clear survey", you take to edit the nav_bar.twig file located inside your survey theme.

The line that needs to be removed (or commented out) is:

                        {{            include            (            './subviews/navigation/clearall_links.twig'            )            }}                      

At present, in that location is no option to leave and clear the survey.

Note: This customization can be used when you create long surveys and require from your respondents to save and resume later the survey. Sometimes, the users tend to click the "Go out and articulate survey" button which deletes the entry from the partially completed responses tabular array.

Help, I accidentally...

I forgot my admin countersign. How do I reset it?

Version 2.ten

1. Access to your server with a command line (ssh for instance)
2. Ensure yous have php command line admission (meet http://php.cyberspace/features.commandline.php).
3. Go to your LimeSurvey directory
4. Launch this command php application/commands/starter.php resetpassword NEW_ADMIN_NAME NEW_ADMIN_PASS or php awarding/commands/panel.php resetpassword NEW_ADMIN_NAME NEW_ADMIN_PASS ^{The php can demand complete directory access, instance /usr/bin/php}

  Please note that this method volition not work in LimeSurvey iii.10!

Version 2.x.10 and newer with only FTP access

See ResetPasswordController

Directly alter the password in the database

If y'all take direct admission to the Limesurvey database you can modify the old password there by uploading the new password as SHA256 hash. You tin can create the SHA256 hash of your countersign here.

For example, you tin employ this teaching to prepare countersign to password:

                        UPDATE            lime_users            SET            password            =            0            x35653838343839386461323830343731353164306535366638646336323932373733363033643064366161626264643632613131656637323164313534326438            WHERE            uid            =            ane            ;          

Here with prefix to lime_ and database selected.

How can I restore information from a deactivated survey?

We recommend to always use the time-out option instead of deactivating a survey. If you closed your survey accidentally, it is of import that yous don't change annihilation in the survey!

Then, and only then the following steps volition work:

1. Actuate your survey once more
2. Select Responses from the survey toolbar.
3. Click on Import and select the "Import answers from a deactivated survey tabular array" menu entry.
4. Choose your source tabular array.
5. Click on the "Import" button located on the upper-right role of the screen.

To empathize the difference betwixt "expiry" and "deactivation", visit this following wiki section.

I deleted a question/question grouping/survey!

If you delete it, it is gone. Only a backup could assist you recover it.

If you are a LimeSurvey GmbH professional person user, please open up a back up ticket and ask the team to provide you the backup associated to your business relationship. Please note that this service is not free of charge!

Hard- and Software requirements

For general requirements please refer to our installation instructions.

What limitations does LimeSurvey have...

...regarding speed

In that location is no existing speed limit on LimeSurvey. Everything depends on how fast your server and your connection are. If you expect a big number of users within a short amount of time and yous are not certain if your server can handle this, check our forum for like topics! or contact an authorized LimeSurvey partner: https://limesurvey.com.

...regarding survey size

MySQL and MariaDB

Note: 'Survey size' refers to the maximum number of questions (and answers) in your survey - don't confuse this with the number of replies on your survey (there is no limitation on that). Theoretically there would likewise be no limit on the maximum number of questions/answers in LimeSurvey. But the database engine you are using has several limits. The most important one is the limit on the number of fields(columns) in the effect tabular array.

• MySQL ISAM: The sum of the lengths of the VARCHAR and CHAR columns in a table may be upwards to 64KB.
• MySQL InnoDB: Maximum number of yard columns
• MS SQL Server 2000: Maximum number of 1024 columns. There are a maximum of 8,060 bytes for size ane row, then even is survey can be activated, if you have a lot of text data : participant can not submit…
• Postgres: Maximum number of 250-1600 columns depending on column types. The maximum number of columns can exist quadrupled by increasing the default block size to 32k. Meet Installation FAQ and PostgreSQL FAQ.

Attention : Please think about what yous do before you do information technology! An array of 10 ten 10 items already costs you 100 columns. Rule of thumb: every detail on the screen that tin exist filled in or selected costs one column!

The mySQL ISAM engine is the most catchy one (see mysql documentation for more information). Equally it allows only up to 65,535 bytes per row and utf8 characters, it can require up to iii bytes per grapheme. The maximum may exist only 21,844 characters (but this depends on your DB encoding).

You tin roughly calculate the size of your survey like this:

• Every multiple numerical question: 20 chars for each answer
• Every multiple choice & array question answers: five chars for each respond
• Every other question blazon: v chars
• Add 10% for the usual overhead

With Microsoft SQL

There are no fixed limit on MSSQL. Some information on microsoft website.

The viii,060 bytes per row can appear after activation when you want to browse response and data. You tin export answer code and not reply text or try to consign but some columns.

With PostgreSQL

When you try to export response : y'all tin can have SQLSTATE[54000] error. Y'all can export some columns. Meet forum mail service.

How to increase the maximum number of columns in PostgreSQL

In case your survey contains too many questions, you lot can ascertain a different block size in PostgreSQL to create more columns. This might be tricky considering you have to recompile PostgreSQL and set up BLCKSZ to a college value, similar 16kiB or 32kiB. Watch for the configuration option "--with-blocksize=BLOCKSIZE". For details see the archives of the PostgreSQL mailing list or inquire there (pgsql-patches(at)postgresql(dot)org).

Instructions for Debian (cheers to Martin Pitt):

            sudo apt-get build-dep postgresql-8.three apt-get            source            postgresql-viii.3            cd            postgresql-viii.3-* debian/rules patch sensible-editor build-tree/postgresql-8.iii.5/src/include/pg_config_manual.h dpkg-buildpackage -us -uc -b -nc          

Note: the in a higher place could not be reproduced on Ubuntu 14.04 in August 2014. A patch is required (the configuration option is not enough). Encounter (tested with PostgreSQL 9.3 on Linux): Instructions for increasing the maximum number of columns in PostgreSQL on Linux

Fatal mistake: Allowed memory size

Depending on your server configuration you lot might run into memory issues being reported by an mistake like "Fatal mistake: Allowed memory size of 8388608 bytes wearied (tried to allocate 233472 bytes) in /path/to/htdocs/limesurvey/filename.php on line 7296".

You can try to raise the limit by adding an optional setting to LimeSurvey's config file.

Delight bear in mind that changes in the default settings of an application can always be overruled by global server settings. To increment the memory limit of your sever to 128M:

• memory_limit = 128M to your server's main php.ini file (recommended, if you have access)
• memory_limit = 128M to a php.ini file in the LimeSurvey root
• php_value memory_limit 32M in a .htaccess file located in the LimeSurvey root binder
• " ini_set('memory_limit', '128M'); " in your config.php

Specific configuration

Under certain circumstances, y'all need to update the LimeSurvey configuration in awarding/config/config.php

IE eleven and Windows vii / Windows 8

In that location is a known outcome with the session with IE 11, that leads to users non being able to finish a survey.

It is solved by giving the session a unique name.

This is done past adding this to the config file.

                        // Set the name of the session            'session'            =>            array            (            'sessionName'            =>            "YOURUNIQUESESSIONNAME"            ,            ),          

Two LimeSurvey instances on same domain

If you lot run 2 LimeSurvey instances on the same domain, but within unlike directories, you lot need to update the session configuration.

For example, if you lot have example.org/ls1 and example.org/ls2, update the ls1 config file:

                        'session'            =>            assortment            (            'cookieParams'            =>            array            (            'path'            =>            '/ls1'            ,            ),            ),            'asking'            =>            assortment            (            'csrfCookie'            =>            assortment            (            'path'            =>            '/ls1'            )            ),          

Source: https://manual.limesurvey.org/General_FAQ

Posted by: levesquefroutichfuld.blogspot.com

Share this post