Author Topic: activity import: source contact ID no effect (Read 1989 times)

phani · February 13, 2009, 11:55:12 am

when importing activity history via csv the activity gets mapped to the correct contact, but i didn't want my own user ID to show up as source_contact, so i supplied the same (internal) contact ID to which the activity gets originally mapped as "source contact ID" (available in the mapping drow-down).

stilll, my own user, who executed the import, gets listed as source_contact. i can remedy that fairly easily by running the following SQL query

Code: [Select]

update nh_civic2.civicrm_activity as act
left join nh_civic2.civicrm_activity_target as at
on act.id = at.activity_id
set act.source_contact_id = at.target_contact_id
where act.id > 1 /* or whatever the last record is that shouldn't get changed */

but it would be easier if another contact could be specified during the import, or rather if specifying one would have an effect...

or do i misunderstand something, mixing up source_contact and source_record (civicrm_activity table)? source_record remains empty, btw.

thanks, phani.

Dave Greenberg · February 13, 2009, 12:15:19 pm

The mapping option which is labeled "Source Contact" is mapped to civicrm_activity.source_contact_id which should be the "creator" of the activity. If you are mapping valid contact ID's to that field - it SHOULD write those value to that column in the DB. If it's not doing that, it's a bug. If you've recreated this in 2.2 - please file an issue in Jira with a small sample import file and steps to replicate. thx!

CiviCRM Community Forums (archive)

News:

Author Topic: activity import: source contact ID no effect (Read 1989 times)

phani

activity import: source contact ID no effect

Dave Greenberg

Re: activity import: source contact ID no effect