had a couple of cases of client getting confused and deleting an Activity that was created from a Webform (with 150 fields in it!)
so of course we can copy these across - but wondering if you can thinks of any clever way eg via the url to load up a previous submission and 'resubmit' so the activity gets created anew

Comments

colemanw’s picture

colemanw commented

Is this when using the "entire submission in activity details" option?

petednz’s picture

petednz commented

hey coleman - not sure i know of such a setting - can't see it on the 'create activity' section

On the 'update existing Activity' we have it set to 'if in Progress'

can you give me a pointer where i should be looking to answer your question

colemanw’s picture

colemanw commented

That's a feature in 2.4, nevermind. It just pastes the entire submission into the activity details, instead of a simple link. (see the issue about backporting if you want it)
So what's the significance of the 150 fields? Wouldn't the activity details simply contain a link to the submission?
I'm not sure I understand your request.

petednz’s picture

petednz commented

significance of the 150 is it is sh#t load to hand copy over but i see i failed to explain it clearly enough

- person submits webform - it creates an activity with all the fields of data filled in - nice
- all the data is also recorded in the webform submission - nice
- dumbo comes along and thinks the activity belongs to the wrong person and just deletes it - not nice
- we have all the data in the previously submitted webform submission
- we want to find a way to resubmit that submission so it creates a new activity

i hope i am missing something painfully obvious but have tried a few things eg
- i can edit the submission but that doesn't cause it to fire a new civicrm activity
- i tried various options for other settings, but it basically comes down to, if i have civicrm 'on' then it will pull the non-existent data from a no-longer-existent Activity and hence I can't get the 'previous submission' data to prefill the webform fields to fire across to civicrm to create the new replacement activity'

hope that makes it clearer

colemanw’s picture

colemanw commented

Oh, I see. The fields are custom activity fields. That makes more sense to me now.
Try this:

  1. Create a "dummy" activity for that person of the same type and status as the one that was deleted.
  2. Note the id of that new activity, and also the webform submission ID.
  3. Issue this query on your Drupal DB: "UPDATE webform_civicrm_submissions SET activity_id = 123 WHERE sid = 123" substituting the appropriate numbers.
  4. Now edit and re-save the submission.
petednz’s picture

petednz commented

thanks so much - will report back

petednz’s picture

petednz commented

Yes it did - thanks for the hand-holding ;-)

colemanw’s picture

colemanw commented
Status: Active » Closed (fixed)

Glad to help.