Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.Problem/Motivation
The Webform module includes the ability to export submissions to a CSV but it does not provide an easy way to import submissions from a CSV.
The Migrate Source CSV module (https://www.drupal.org/project/migrate_source_csv) combined with the Webform Migrate module (https://www.drupal.org/project/webform_migrate) can provide a mechanism to import CSV submissions. Drupal's Migrate module and the Webform Migrate module are still under development.
Proposed Resolution
Provide a straight forward tool for importing submissions from a CSV document.
Notes
- Import must use a standardized CSV format. For example, column names would be each element's key and the row values the submission's raw data.
- Using the Migrate Source CSV module will still be a recommended long term option.
- UUID will be used to merge data. CSV data imported from D7 should use https://www.drupal.org/project/webform_submission_uuid
- Importing files will need be supported.
- Rollbacks will NOT be supported.
| Comment | File | Size | Author |
|---|---|---|---|
| #42 | 2902977-43.patch | 166.71 KB | jrockowitz |
| |||
| #36 | 2902977-36.patch | 164.47 KB | jrockowitz |
| |||
| #18 | 2902977-18.patch | 129.81 KB | jrockowitz |
| |||
| #15 | 2902977-16.patch | 112.26 KB | jrockowitz |
| #6 | webform-examples.zip | 7.56 KB | kclarkson |
Comments
Comment #2
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedComment #3
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedComment #4
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedComment #5
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedComment #6
kclarkson CreditAttribution: kclarkson commented@jrock
Here is the are the webform examples:
- Event Registration
- Submission Application Evaluation
- Funding Appliation
Comment #13
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedComment #15
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedComment #18
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedComment #36
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedThe attached patch allows CSV source columns to be mapped to Submission destination properties and elements. The patch also now includes test coverage.
Comment #42
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedThis final patch integrates a demo video which is also included in the change record.
Please review the attached patch and change record.
Comment #44
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedI committed the patch. Please download the latest dev release to review.
Please open new tickets if you find any issues or bugs.
Comment #45
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedI also tagged a new RC release which contains this feature.
Comment #46
kclarkson CreditAttribution: kclarkson commentedReally excited about this feature. Thanks sir!