New answers tagged

1

You can change the hold_threshold in civicrm_mailing_bounce_type table for Away to your own choice. By default it is set to 30. Not sure why your system is set to 3. I dont think if there is any way to discard old bounces unless you delete from civicrm_mailing_event_bounce table. Probably good idea to write a script that runs on cron job to delete the ...


1

You could use CiviRules for this. Additional info: Consider setting a small delay (when you configure your CiviRule) to ensure all CiviCRM data are saved before you Email your message out. PS in additional to CivRules - you will also need to add the Extension: https://civicrm.org/extensions/e-mail-api


1

Receiving mail servers use a variety of different metrics to give your mail a 'spaminess' score to decide whether it is spam or not. Is there a process difference when mail is triggered by CiviRules or CiviMail rather then directly from the contact record? There are small differences in the email headers generated via different routes. These may be ...


3

I've had an excellent experience using this extension: https://github.com/jitendrapurohit/nz.co.fuzion.deleteoldbulkmailings I needed a few small fixes for my purposes (include a limit parameter and removal of code that assumed extended logging is on), which you can see in my fork here: https://github.com/adixon/nz.co.fuzion.deleteoldbulkmailings As I ...


4

One small gotcha with large deletions: MySQL may not free-up the space in the way you expect. The exact mechanics and numbers probably depend on the variant of MySQL and its configuration options, but just for a general sense: if the goal is to reduce the disk-usage of those tables on the active system by 75% (8gb to 2gb), then you might try to DELETE the ...


4

we have a custom overnight routine that copies data from civicrm_mailing_x and civicrm_mailing_event_x tables to duplicate tables with a archive namespace and then deletes the appropriate rows from the main tables. The biggest things is making sure that you adequately understand the relationships between the tables so you don't accidentally delete data that ...


1

Fatith, As per your requirement this is not straight forward and needs some custom coding or need good knowledge about using smarty api since the created id is stored as source contact id for an activity and data of source contact id is directly not available in smarty or as a token. Here is possible solution for this Create token and token values using ...


1

You can edit the message template at admin - Civimail- message templates on the system workflow tab and use the api to look up the current user's info, as described at https://docs.civicrm.org/dev/en/latest/api/interfaces/#smarty-api-interface e.g. {crmAPI entity='contact' action="get" ...


Top 50 recent answers are included