CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.2 Release Testing »
  • activity import: source contact ID no effect
Pages: [1]

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

phani

  • I’m new here
  • *
  • Posts: 28
  • Karma: 3
    • namahatta.org DB
activity import: source contact ID no effect
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.
« Last Edit: February 13, 2009, 11:59:33 am by phani »

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: activity import: source contact ID no effect
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!
Protect your investment in CiviCRM by  becoming a Member!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.2 Release Testing »
  • activity import: source contact ID no effect

This forum was archived on 2017-11-26.