QPL Reference Manual

Warning! This page is in the process of being rewritten for QPL Version 6. It may still have references to QPL Version 5.

The administrative pages may only be accessed by people who have been given administrative user accounts. There are three levels of administrative accounts:

You can use these different types of accounts to control who has access to the various administrative functions. For example, the person who installs a questionnaire project on a web server will have the only System Administrator account so he can set the operational options. Someone who is providing telephone or email support for a particular project while it is running only needs an Administrative account so he can view and edit respondent accounts and see summary information about the project. The person who is analyzing the data or managing the content analysis of open-ended responses needs a Data Administrator account.

Function Group Administrator Data Administrator System Administrator
Project Statistics
System Maintenance    
User Maintenance
Summary Reports
Export Data  
Content Analysis*

*Administrators, by default, may not use content analysis functions to define topic tags or see how other Administrators have tagged resposes. A Data or System Administrator, however, may delegate these capabilities to specific Administrators.

The picture below shows a sample main administrative page. You can click on the items on this picture to learn more about each function.

Main Administrative Page (System Administrator View)

Administrator and Data Administrator accounts may be created using SQL scripts or through the user account functions on the main administrative page shown below. System Administrator accounts, however, may only be created or modified using an SQL script.


The top of the main administrative is used to show the results of various functions. For example, if you use the purge expired sessions function, the number of sessions that were deleted will be listed here when the page refreshes.


You should always use the "Cancel" button at the bottom of the page to log out of the administrative pages. Logging out this deletes any export files on the server that you may have created and closes your user session.

Project Statistics

The Project Statistics section of the page provides summary information about the current state of your questionnaire project.

Statistic Comment
Cases The total number of questionnaire records in the data base. This includes any records created by test accounts. Administrative accounts do not create questionnaire records.
Cases being edited The total number of cases that are currently open. A case is returned to normal status when the respondent closes the questionnaire by clicking on the Exit or Submit buttons.

If a respondent does not close a questionnaire properly (if, for example, the respondent closes the browser window without submitting the page), then the case is left in a "Being edited" status.

You can use the Release being edited cases function below to check-in cases where the respondent's session time has expired.

If your project allows respondent's to share cases, other respondents may not open cases that are "Being edited."
Cases file size The size of the main questionnaire data table in megabytes.
Cases last updated The date and time when the questionnaire data table was last updated.
User accounts The total number of user accounts. This all types of user accounts, including test accounts and administrative accounts.
User sessions The total number of people currently logged into the questionnaire project, including administrators.

If a respondent does not close a questionnaire properly (if, for example, the respondent closes the browser window without submitting the page), then the respondent is still listed as being logged in. You can use the Purge expired sessions function to clear log-ins that are no longer valid.

A respondent or administrator may log in again even if he has an open or expired session.
User sessions that have expired The total number of active sessions that have expired. (See notes above.)
History log entries The total number of entries in the history log table.

An entry in the project history log is made every time a user logs in or out, receives an error message (i.e., Notice page), or changes questionnaire pages.

You can use the View recent history log function to see the last 100 log entries.
History log file sizes The size of history log table file in megabytes.
Content analysis tags defined (Max 256) The total number of tags that have been defined. The default maximum number of tags that may be defined is set using the /c converter option when the project files are compiled. The maximum can be increased after a project is deployed by writing and running a MySQL script.
Responses analyzed The total number tag records that have been created by all administrators for all questions. The total possible tag records is the product of (administrators) * (questions) * (respondents).

System Maintenance

The system maintenance functions are used by the System Administrator to set the project default settings and perform various maintenance tasks.

Function Comment
Set project defaults Select configuration options for your project. You can, for example, let respondents answer a questionnaire anonymously or require a respondent to have a predefined user name and password. You can also restrict respondents to a single questionnaire or let them access multiple questionnaires or share questionnaires. See Default Project Settings for more information.
Send email messages Send messages to user accounts which have email addresses. You can create template messages that are uniquely modified for each user, such as including a user's personal log on information in his message. See Email for more information.
Expired Sessions Delete all log in sessions that have expired.
Purge History Log Delete all log file entries. The log file option on the Project Default Settings must be turned off before this function will work.
Optimize This function lets you optimize all of the project data base tables. This will reclaim lost space, compact the data files, and improve data base performance.
Scratch Temporary Export Files Delete all copies of export files that may have been created. These files are automatically deleted if the administrator logs off correctly (by pressing the Cancel button while viewing the main administrative page).
Reset Expiration Dates Change the expiration date for all Normal user accounts. Accounts will expire at midnight (according to your server's clock, which may not be your local time) on the day you specify.

User Maintenance

The User Maintenance functions may be used by any administrator create, update, or close a user account.

Function Comment
Edit user accounts Add or modify user accounts. For example, you may change a respondent's password or change the expiration date on his account. See Edit user accounts for more information.
Release Being Edited Cases This function resets the status for all cases that have been opened but not properly closed or closed within the project's maximum session time.

Summary Reports

The Summary Reports functions let you run reports to monitor what is happening on your project. These reports are summarized below.

Report Comment
Recent History Log Show the last 100 log entries. The most recent entries are listed first.
Custom Log Report Show log entries according to a query set by the System Administrator on the Default Project Settings page. You can use this report, for example, to see all of the log entries for a particular user.
Respondent Activity Compare the user accounts to the questionnaire records to show how many questionnaires were created by each respondent. If a respondent has not created a questionnaire record, his count will be zero.

This option is only available when there are less than 200 user accounts in the project.
All Sessions Show all the users who are currently logged in and when their session expires. Expiration times shown in bold type indicate expired sessions.
Mail queue Show status of all the mail jobs that have been submitted by this project to the QPL mail queue for processing. Each job may include one or more messages.
Questionnaire Summary Statistics Summary statistics on questionnaire responses. By default, all of the non-VOid questions are included in the report. STRING and OPENEND questions will not be included in the report if no responses to those questions have been entered. If no cases have been entered, no summary report will be generated. If you have preloaded data into questionnaire data records, then that data will be used in the summary report.

By default, the report will include all the cases entered by respondents, except cases that were entered using a test account. The System Administrator may change this setting by editing the WHERE clause for tabulation report on the Default Project Settings page.

You can remove questions from the report using the /dv (drop variables) or /kv (keep variables) command line option when compiling your project. See Converter Command Line Options and Viewing Real-Time Summary Statistics for more information.
Long and Short Custom Reports The System Administrator can enter any SQL "SELECT" query in the Select Statement For Custom Reports on the Default Project Settings page. to list any information in your project. The "Short" option lists the fields in your query as separate columns in one table. The "Long" option lists each field on separate rows, and each record in separate tables (this layout is useful if your report lists many long text fields).


The export functions let a Data or System Administrator export data from the MySQL data base in one of three formats. By default, the export files will include all the case entered by respondents, except cases entered using the test accounts. The System Administrator may change this setting by editing the WHERE clause for data export functions on the Default Project Settings page.

Function Comment
Fixed format file (.dat) Data file format for use with QPL-generated SPSS and SAS programs.
Tab-delimited file (.prn) General data file format for use many data analysis packages, such as Microsoft Excel.
askSam import file (.txt) Special data file format for importing into the askSam free-form text data base system.
Export content analysis tab-delimited file (.prn) General data file format .

Content Analysis

The content analysis functions let the administrators analyze comments that respondents have entered in STRING and OPENEND questions. Administrators do not have access to functions that would allow them to create or change topic tag definitions, or see how other administrators have coded responses.

Function Comment
Delegate tasks Delegate project leader tasks: defining and updating tag definitions and reviewing coder reconciliation reports. Only Data and System Administrators may use this function to delegate tasks to an Administrator. This function is not listed on this page for Administrators.
Define topic tags Create a topic tag and definition, and specify which questions tag applies to. Only Data and System Administrators may define topic tags. This function is renamed "View topic tags" for Administrators and lets them see the list of topic tags.
Assign topic tags This function is used by the coders to select and code responses.
Reconciliation report This function is used by Data and System Administrators to monitor the coding process, viewing response the tags that were applied to those responses by selected coders.
Summary report This function is used by Data and System Administrators to list responses and the tags that were applied, using either the intersection or union of tags that were applied by selected interviewers.
Tabulation report Show how often each tag was applied for each question that was analyzed.
Inter-rater reliability report Show how reliably the coders are tagging responses. In addition to a simple percent agreement statistic, this report also computes the Cohen's Kappa and Krippendorff's Alpha Reliability statistics which attempt to eliminate the effect of consistent coding by chance.
Word count report This report lists the words that were used by respondents in their answers to selected OPENEND and STRING questions.