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) »
  • Developer Discussion »
  • APIs and Hooks (Moderator: Donald Lobo) »
  • 'With' Column in activity history not creating links... [ Resolved ]
Pages: [1]

Author Topic: 'With' Column in activity history not creating links... [ Resolved ]  (Read 1228 times)

DLBaker

  • Guest
'With' Column in activity history not creating links... [ Resolved ]
September 01, 2010, 02:05:00 pm
Greetings.

A few months ago we migrated from 1.9 to 3.1 going through all the iterations. However we ran aground the activity type bug in the migration from 1.9 to 2.0 and didn't realize it until after we went back into production.

I have been tasked with restoring the activity history, which I have done for the most part. What's missing now is the information required to make links in the 'with' column in the screen shot that's attached.

What tables, or what is the query that populates these links?

Can anyone offer some insight on this?

Thanks in Advance.
- Dan.

Keywords for searches: Import 1.9 to 2.0 upgrade migration missing activity history
« Last Edit: September 10, 2010, 06:37:56 am by DLBaker »

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: 'With' Column in activity history not creating links...
September 01, 2010, 02:25:40 pm

the activity tables are:

civicrm_activity
civicrm_activity_assignee
civicrm_activity_target

what i would do is to create a new activity with all three and then check and see how the old activity matches with the new

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

DLBaker

  • Guest
Re: 'With' Column in activity history not creating links...
September 01, 2010, 02:36:23 pm
Hey Lobo.

I appreciate the response.

I got all those. Are you saying the "With" Column is populated here also? Which field is it and where does it look to?

I am pulling directly from the 1.9 "Activity_History" table.

Thanks in advance.
- Dan.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: 'With' Column in activity history not creating links...
September 01, 2010, 03:18:45 pm
the with is populated with contacts from the civicrm_activity_target table

note that the activity structure changed significantly between 1.9 and 2.0

lobo
« Last Edit: September 01, 2010, 03:21:21 pm by Donald Lobo »
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

DLBaker

  • Guest
Re: 'With' Column in activity history not creating links...
September 02, 2010, 06:47:57 am
Quote from: Donald Lobo on September 01, 2010, 03:18:45 pm

note that the activity structure changed significantly between 1.9 and 2.0


Oh yea, Trust me, we Noticed!!

Thanks for your help Lobo.
- Dan

DLBaker

  • Guest
Re: 'With' Column in activity history not creating links...
September 10, 2010, 06:36:51 am
So I found the location of the link but it wasn't in civicrm_activity_target, it's in civicrm_activity.

It turned out the value in civicrm_activity.source_record_id is actually the value found in civicrm_mailing.id.

Once I had that inserted in with my script the links began showing up like they were supposed to. Everyone is happy here now.

Thanks for the input lobo.

Regards.
- Dan.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion »
  • APIs and Hooks (Moderator: Donald Lobo) »
  • 'With' Column in activity history not creating links... [ Resolved ]

This forum was archived on 2017-11-26.