CiviCRM Community Forums (archive)

Hi Xavier,

What is missing in the search_count?

CiviSync was developed for version 2.2 and that's why we couldn't use the search_count at that time. I am sure it will be useful for the latest version of CiviSync.

What do you mean by DistList ?

A distribution list/mailing list is created by CiviSync in Outlook for the tags and groups in CiviCRM.

What about writing a post hook on contacts that flags the groups/tags to be synced ? Would be easy and more scalable.

I think it'd be easy to use the log table (probably with an extra field), to store info about groups/tags adding or removing, so you know exactly what you have to sync, no ?

We would like to keep CiviSync to not to touch the code of CiviCRM and hence if the log table can be updated to store the information about groups/tags adding/removing; it will be the best solution for us.

Also, what we would like to see in CiviCRM is Email API, this should allow attaching HTML Emails sent by Outlook to CiviCRM. Do you know if this is in pipeline?

Thanks
Rohit

My only concern is query optimization, I can compare the queries and show you the difference. I don't think we need any thing related to search at all. Sync, is pretty flat.

Get me the count to synced (Initially, It would be just a simple), following are the queries that we use to fetch the count)

if time stamp is not passed

Select count(1) NumberOfRows from civicrm_contact

if time stamp is passed

Select count(distinct `entity_id`) NumberOfRows
from civicrm_log
where entity_table =\'civicrm_contact\'
and `modified_date`>=%1

same thing while getting the contacts. join only on "civicrm_address" "civicrm_email" "civicrm_phone". It would be great if you can have a look at the 2 files that we added for sync. Let me know if you want those files. I can email you those files.

Regards
Mohit Thakral