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) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • civicrm_activities and originating contact
Pages: [1]

Author Topic: civicrm_activities and originating contact  (Read 377 times)

EdP

  • I post frequently
  • ***
  • Posts: 260
  • Karma: 7
  • CiviCRM version: 4.4
  • CMS version: Joomla 2.5.x
civicrm_activities and originating contact
September 27, 2012, 01:52:22 am
Hi, while looking at my database as part of trying track an issue, I noticed that in the civicrm_activities.source_contact_id field it is often NULL. Looking at the records, it is clear that a lot of them are activites created by (a) a cron job or other automated logic and (b) the Email-to-Activity processor.

Is this how it is supposed to work (or is this part of my problem)? Assuming it is, would it not make more sense to have a special user (0?) as the source for these activities so that you can see what the Cron has done? Likewise for the email-2-activity, should the source_contact_id not be the id of the person sending the email (or is it that you cannot always be sure, because email addresses can be shared?)

E

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: civicrm_activities and originating contact
September 27, 2012, 08:25:04 am
No it should have a source contact.
What are you passing in for the user parameter to your cron job? http://wiki.civicrm.org/confluence/display/CRMDOC42/Managing+Scheduled+Jobs

EdP

  • I post frequently
  • ***
  • Posts: 260
  • Karma: 7
  • CiviCRM version: 4.4
  • CMS version: Joomla 2.5.x
Re: civicrm_activities and originating contact
September 27, 2012, 12:15:27 pm
Good point.

I have a valid Joomla user (Mr Website Daemon), whose linked CiviCRM user is the organisation that we're all members of (the Club). That organisation does have a lot (several thousand) activities against its name but looking at them while it does appear to have a lot of the cron-generated membership status changes (moved from "current" to "recently expired" - that kind of stuff) it doesn't have any of the Email2Activity type stuff. That E2A is all happening OK (it's appearing as activities on the records of the people it's sent to, for example) but just has no source user and it doesn't appear on the Club's Activity history.

Thanks. E.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • civicrm_activities and originating contact

This forum was archived on 2017-11-26.