Not sure where exactly I should post this to, but here it goes:
I am trying to find a way to include webform submissions in ubercart order information. I am using UC Webform Pane to add extra form fields during an ubercart checkout. This all seems to be working correctly, but the problem I am running into is when I want to download order data (to a csv file), it does not include the webform data that gets submitted with the form during checkout. I'm wondering if there is something already available that can allow me to do this, but if not I am open to suggestions on what the best approach would be to create this feature. Ideally, I would love to be able to use views data export to display all the fields within a given order, but I am unable to link webform data with uc orders. I've looked at the webform submissions data module and it is close to what I'm looking for but not close enough. with webform submissions data module, there are multiple results for each order depending on how many webform fields I want to display with the order. I only want to have one distinct order as a views result that includes all the fields (uc_order and webform pane) that are attached to the order. Any help would be appreciated.
Comments
Comment #1
robdubparker commentedOk I think I found a good answer here: http://archive.org/details/DisplayWebformSubmissionDataInViews
Comment #2
samgreco commentedDid this work for you? I am trying to accomplish the exact same thing, but having issues with this method.
Comment #3
robdubparker commentedI've had to revisit this recently... looks like it isn't completely working for me yet either. I'm able to pull the webform fields and combine them with my order fields within a view, except the webform fields are all appearing blank... I'll look into this some more today. What's the issue you're running into?
Comment #4
samgreco commentedI can't even get the webform fields to show up, so I am obviously doing something wrong.
Comment #5
robdubparker commentedJust upgraded Ubercart Webform Checkout Pane module to the latest version (3.8) and everything now seems to be working correctly. Let me know if you're still stuck on this issue.
Comment #6
samgreco commentedI have been on 3.8 for quite some time.
Comment #7
quicksketchThis should be in the UC Webform Checkout Pane queue. Maintainers of Webform don't use this module, so we can't provide much help here.
Comment #8
arski commentedHi guys,
As you'll see here #680386: Views integration for the webform_submitted_data table Views support is not really ready yet for Webform itself, and hence it's not easy to achieve the Webform submodules either. If you manage to do it, I'd be happy if you could provide the code for future reference when I'm implementing Views support (after Webform supports Views that is).
Otherwise, take a look at the .tpl file inside the module - it shows how to load webform submission data for an order object and you can use that to add the webform submitted data to your csv.
I'm marking this as duplicate of #939850: Views integration of checkout webform pane submissions - and reopening that issue. Will take a look when Webform supports Views.