CiviCRM Community Forums (archive)

Hello everybody,

I made a thunderbird extension and It is interesting to share what I have developed.

This extension uses 2 civiCRM API "crm_get_groups" and "crm_get_group_contacts".

First, it will search all the groups and smart groups existing in the Data Base.
And then for each selected groups/smart groups, it displays members' email address in CC or BCC.
There are custom "toolbarbutton" and "menuitem"

You have to configure the URL to the php file which makes a request. ( Mailing > Change URL ) and add the code below in the end of the SoapServer.php file ( ../civicrm/CRM/Utils/ )

Edit: You can modify the "civicrm_mailing.js" file in the "preferences" directory too.

//public function search_group_contacts_tb($key, $param){
public function search_group_contacts_tb($param){
//$this->verify($key);

$params = array( 'title' => $param );

//$return_properties = array('id', 'title' );
$return_properties = array('title' );
$myGroups =& crm_get_groups($params, $return_properties);

foreach($myGroups as $group) {
$return_properties = array( 'email' );
$sort = array("email" => "ASC");

        $myContacts =& crm_get_group_contacts(&$group, $return_properties ,'Added',$sort, $offset = 0, $row_count = 25 );

foreach ($myContacts as $contact) {
            $display .= $contact->email . ", ";
        }
}
return $display;
}
The package are available here : ZIP format or XPI format

Note that the authentication is disabled and a "bug" is known.

Email addresses are duplicate or 3 times, it is not for all the email addresses but it is very strange.
I don't think it was in my JS code.

I joined a screen shot too

Any feedback and suggestions are welcome.

Yay, that's pretty cool. :-)
 
I'm going to install the extension and check it out sometimes in next two weeks, will come back with remarks.

Thanks for making your work available to others!

Thx,
michau

I am looking forward for your remarks


PS:

I got a problem when I want to edit my first post.
It returns the error message:

Database Error: Lost connection to MySQL server during query
File: /home/civicrm.org/forum/Sources/Post.php
Line: 1423
I just want to correct my bad english  ( I saw 3 faults ) and add that the server's URL can be changed in the "civicrm_mailing.js" file in the "preferences" directory.

best regards

Can you please see if it happens again and let me know if it persists?

Do you change some thing ?

The same error message is displayed.  And the 'preview' before 'post' works fine ! ;-)

Aha! While waiting for SMF forum registration email, I investigated a little bit more and it worked this time! :-)

Some SQL queries in SMF didn't have proper quotes in them - some say it's a mysql bug, some say it's mysql feature, I say - it was breaking post editing. :-)

It should be fixed now.

michau

Has any thing happened with this extension?

It could be a very nice selling point for civicrm.

It doesn't work with version 2.0. The CiviCRM APIs have changed and we don't have the resources (no developer) to fix it. We found a workaround using a mailing list server (sympa.org). Emails meant to be distributed are sent to the sympa server who looks into the civicrm db to who the mail needs to be sent (each distribution list match a query). This allows us to use any mail client and we don't need the plugin anymore. Furthermore, it's easier to perform a change in the queries (in case of a DB structure change) than to modify the plugin's code.