Posted by Cristhian on June 17, 2011 at 6:21am
This is an alternative to Webform MySQL Views to display submitted data into views, for those who MySQL Views simply don't work or when they went very slow.
INSTRUCTIONS:
- Execute the following command on your database administrator, otherwise the view may run very slow.
ALTER TABLE `webform_submitted_data` ADD INDEX `sid_cid` ( `sid` , `cid` ) - Go to admin/build/modules
- Enable "Webform Views Submitted Data"
- Go to admin/build/views/add
- Set your view's name
- Select "Webform submissions" on view type. Notice that Webform already includes this option, so this module doesn't add options here. Click next.
- Now you are in the view UI. On the "Fields" box, click the (+) symbol. Besides the fields that are provided by Webform , you will be able to choose a field for each component you have set up in your webforms.
- If fields are not appearing, just flush your caches. Webform component creation doesn't flush caches like CCK do.
Downloads
Project Information
- Maintenance status: Seeking co-maintainer(s)
- Development status: Under active development
- Module categories: Views
- Reported installs: 142 sites currently report using this module. View usage statistics.
- Downloads: 458
- Last modified: April 2, 2012