civicrm_mailing with thunderbird

[TrAshiBa]

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.

Code:

//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.

[Michał Mach]

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

[TrAshiBa]

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:

Code:

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

[Michał Mach]

Uh oh... Not good, this error doesn't look nice. I checked SMF support forums and there is a few potential reasons for this behaviour, need to check all of them.

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

[TrAshiBa]

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 ! ;-)

[Michał Mach]

There is some wierd SMF error showing up when editing a message with attachment. Note, that you should be able to edit any other message without problem.

I tried all the suggestions that I've found on SMF support forum, without success, so I've posted a support request there - lets see what they say.

michau

[Michał Mach]

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

[TrAshiBa]

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

Nice michau

It works fine   ==> post edited :p

[micheas]

Has any thing happened with this extension?

It could be a very nice selling point for civicrm.

[Donald Lobo]

I dont think so, but would be great if someone steps up and ensures it works with CiviCRM 2.x and potentially uses our new "Email2Activity" script (http://civicrm.org/node/406) to attach the email in CiviCRM

lobo

[dflasse]

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.