2

I am bringing old data into CiviCRM and we have a number of old petitions in a variety of formats (paper, YAWPP) and I didn't see a way to import the old names & emails into a petition. Did I miss something?

Improve this question

1 Answer 1

Reset to default
4

So I figured out how to do this, for the future.

You need to import an Activity for each contact. Match as per any other import

Key import details:

  • source_record_id = petition id (you may have to look into the db to find this)
  • activity type = 32 (or the activity type id listed for Petition Signature in Administer > Customize Data and Screens > Activity Types)
  • subject = by default, this is the title of petition
  • data = date signed
Improve this answer
4
  • @Corery during import with which option did you associate the source_record_ID?
    – Alessandro Letizia
    Nov 12, 2019 at 15:28
  • Afaict, the source_record_id is the numeric value of the survey/petition id in the appropriate database table (I run it on Wordpress, so the table is called civicrm_survey)
    – Corey Burger
    Nov 12, 2019 at 22:15
  • I know, but during a petition impot with which option/label do you associate the source_record_ID? If we associate it with "activity ID" it doesn't work. :(
    – Alessandro Letizia
    Nov 12, 2019 at 22:45
  • Sorry, yes. Activity ID I think is the campaign id, but I wasn't using it for this upload
    – Corey Burger
    Nov 13, 2019 at 6:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.