Last updated May 24, 2010. Created by tomhung on May 21, 2010.
Log in to edit this page.

Webform Import
Upload of webform submission results from a delimited file.
(comma, tab, semicolon, pipe, period, and space) For simplicity I will refer to this as CSV.

Screenshot

Installing

Manually

* download latest tarball from http://drupal.org/project/webform_import
* untar in your sites /sites/modules/ directory
* go to admin/build/modules
* Check "webform import"
* Save

Drush

* drush dl webform_import
* drush en webform_import

Usage

Getting Started

* create a webform
* create webform components to match your CSV data

Prepare to Upload the CSV file (gotchas!)

* NOTICE: usually disable the "required" field requirement. If its left on, the upload will not take if a required field is missing.
* NOTICE: Insure your Selection Component's "Key|Value" pair reflects the "Key" in your CSV file
* NOTICE: webform file component will not be added
* edit your CSV files header to match either the "Field Names" or "Field Form Keys"
* you can download a template from the "Instructions" fieldset on the "Upload" tab.

Component specific help

* Date: must be in a format parsable by the php function strtotime() Any time data will be discarded.
* Grid: option keys must be separated by commas and in the order of the questions in the webform. (e.g., "red,male,car" for the questions "Favorite color, Gender, Type of automobile you drive" respectively.)
* File: currently unable to handle this component.
* Select: for multiselect answer keys must be separated by commas. (e.g., "1,2,3")
* Time: must be in a format parsable by the php function strtotime() Any date data will be discarded.

Uploading the CSV file

* go to the "Webform"
* go to "Results" tab
* go to "Upload" sub-tab
* choose CSV file from local filessystem
* choose delimter
* choose header match criteria "Field Names" or "Field Form Keys"
* UPLOAD
* check results count & errors

Editing submissions results via Export / Upload

Webform Export will output a CSV file that is compatible with Webform Import. If the SID column is present the Import will UPDATE the record. You can use this feature to do significant updates to submission results.

Uninstalling

* just disable & remove module
* drush dis webform_import
* NOTICE: no database tables are added

Looking for support? Visit the Drupal.org forums, or join #drupal-support in IRC.

Comments

Im having a bit of difficulty importing my csv files. Could someone maybe provide me with an example of how this should look? I downloaded the template, then inserted the relevant new info to import and my screen just goes blank. Any help with this would be greatly appriciated.

Webform Import doesn't seem to send out the emails that are configured for a given form is there a way to enable that function or batch resend to a set of SID values?