Webform MySQL Views

The Webform MySQL Views module builds flattened, read-only MySQL views of Webform
submission data. These views may be useful when you need to access this data
from an external application in an automated fashion without exporting,
importing, or the use of a web-based API.

Requirements

• Webform module (6.x-3.x or 7.x-3.x)
• Elements module (Required only by the 6.x version of Webform MySQL Views)
• MySQL Server 5.0 or later

Usage

• Enable the module
• Visit the Administer > Content Management > Webforms page.
  • Direct URL: http://YOURWEBSITE/admin/content/webform/mysql
• Click the MySQL Views tab.
• Check the boxes next to the names of the Webforms for which you want to create MySQL views
• Submit the form.

Once you have created a MySQL view for a given Webform, the view will be automatically updated whenever you add, remove, or reorder the components for that Webform.

Integration with Data Module & Views Module

Johan Falk (Itangalo) had the idea to use the Data module to expose the MySQL
views created by this module to the Drupal Views module, and Frega provided a
patch that forces the Data and Views modules to recognize the `sid` field of the
MySQL views as the primary key (For more info see #889306: Allow the designation of a primary key for MySQL views).

If you have the Data and Schema modules installed on your site, your Webform
MySQL views should automatically become available for use by the Views module.

(Note: Native Views module support is planned for Webform module - See #680386: Views integration for the webform_submitted_data table.)

Known Issues

• Data/Views module integration does not work if your Drupal database is
  configured to use a table prefix. (See #894074: adopt table doesn't support $db_prefix).
• Does not work with Webform 6.x-2.x (See #1025462: Error: warning: implode() [function.implode]: (Webform 6.x-2.x))