Problem with imported case activities not appearing in the case record

[Hugh Daniel]

I'm using MySQL Workbench to create cases and activities as a test  preliminary to importing a larger number of cases/activities into CiviCRM. However, the added activity records are not showing up in the contact's case record, even though the added activity will show up in a Drupal view with all the correct information.

I've checked and double checked all the keys and foreign keys and activity types to make sure they are correct for each test. Here is what I'm doing:
1) Make note of the Contact ID
2) Add a record in the civicrm_case table
3) Add a linking record to civicrm_case_contact table
4) Create a new record in the civicrm_activity table
5) Add a linking record in the civicrm_case_activity table
6) Add a linking record in the civicrm_activity_contact table

The reason for using MySQL Workbench for imports is because the activities are related to a case and the Activities Import option in CiviCRM does not seem to allow linking the activity to specific cases (please correct me if I'm mistaken on this). I am also not comfortable in using an import script as per Tony Horrocks' CiviCRM Cookbook, so have not explored that option.

I've also posted this on the LinkedIn CiviCRM group and received suggestions that I carefully check that the records that I am manually adding are consistent with CiviCRM generated records (yes they are) and that the is_current_revision field is set to "1" (yes it is).

Am I missing a table in this process (or adding one too many)? Any tips or insights would be appreciated.

[Donald Lobo]

easiest way to debug this might be to trap the set of queries civicrm issues to generate the list of actvities for a contacts case record and see why the new activities are not showing up.

i suspect its a bunch of queries, so i'd do it for a contact with just a couple of activity records

lobo