CiviCRM Core issueshttps://lab.civicrm.org/dev/core/-/issues2022-12-24T14:42:08Zhttps://lab.civicrm.org/dev/core/-/issues/3936Import contributions (update existing) extremely slow2022-12-24T14:42:08ZDetlev SieberImport contributions (update existing) extremely slowOverview
----------------------------------------
On a large database, importing updates of existing contributions is extremely slow (about 10 times slower than inserting new contributions).
This is new with 5.53 or 5.54.
Reproduction ...Overview
----------------------------------------
On a large database, importing updates of existing contributions is extremely slow (about 10 times slower than inserting new contributions).
This is new with 5.53 or 5.54.
Reproduction steps
----------------------------------------
Reproducing requires large database with many contributions. Therefore not yet reproducible on sandbox.
Current behaviour
----------------------------------------
Inserting new contributions works on this specific production environment at a rate of 140 contributions per minute.
Updating existing contributions is at an average of only 13 contributions per minute.
Expected behaviour
----------------------------------------
Previously, updating existing contributions was slightly faster than inserting new contributions.
Environment information
----------------------------------------
<!-- Some of the items below may not be relevant for every bug - if in doubt please include more information than you think is neccessary. -->
* __Browser:__ _Firefox 105.0.3
* __CiviCRM:__ _5.54.0 (was working well with 5.52.x)
* __PHP:__ _7.4
* __CMS:__ _Drupal 7.52
* __Database:__ _MariaDB 10.5.15_
Comments
----------------------------------------
_none_https://lab.civicrm.org/dev/core/-/issues/3935PHP Notice: Undefined offset in _civicrm_member_roles_sync()2022-12-01T02:47:03ZAndrew WassonPHP Notice: Undefined offset in _civicrm_member_roles_sync()Overview
----------------------------------------
This is an issue that I have noticed in several Drupal 7 / CiviCRM websites. When the CiviCRM Member Roles Synch activity takes place, my recent log messages get inundated with PHP Notice...Overview
----------------------------------------
This is an issue that I have noticed in several Drupal 7 / CiviCRM websites. When the CiviCRM Member Roles Synch activity takes place, my recent log messages get inundated with PHP Notices:
> Notice: Undefined offset: x in _civicrm_member_roles_sync() (line 607 of /civicrm/drupal/modules/civicrm_member_roles/civicrm_member_roles.module).
Reproduction steps
----------------------------------------
1. Enable civicrm member roles sync.
1. Add a rule to synch some member type to a role.
1. Configure to run at Drupal Cron
1. Run Cron and observe as Reports -> Recent Log Messages get filled with notices.
Steps to Resolve
----------------------------------------
line 607 of /civicrm/drupal/modules/civicrm_member_roles/civicrm_member_roles.module contains the following statement:
`if (is_array($memberroles[$membership['membership_type_id']])) {`
If the array is not set then the notice will be raised so if we check it first as follows, the notice goes away:
`if (isset($memberroles[$membership['membership_type_id']]) && is_array($memberroles[$membership['membership_type_id']])) {`
Environment information
----------------------------------------
* __CiviCRM:__ _5.54.0_
* __PHP:__ _7.4/8.1__
* __CMS:__ _Drupal 7.92_
* __Database:__ _MySQL 5.7.4_
* __Web Server:__ _Apache 2.x_5.57.0https://lab.civicrm.org/dev/core/-/issues/3933Subscription history is not set when GroupContact is deleted via API42022-11-07T01:41:44ZlarsssandergreenSubscription history is not set when GroupContact is deleted via API4If a contact is deleted from a group via API4 (by deleting the GroupContact), no subscription history is recorded. I think it should be, as it is recorded if done via the UI or API3.
Tested on dmaster.
Edit: Removed some discussion abo...If a contact is deleted from a group via API4 (by deleting the GroupContact), no subscription history is recorded. I think it should be, as it is recorded if done via the UI or API3.
Tested on dmaster.
Edit: Removed some discussion about API3 that turned out to be a red herring.https://lab.civicrm.org/dev/core/-/issues/3931Blank Invoice.pdf appearing when doing Offline contributions2023-05-18T23:35:49ZshaneonabikeBlank Invoice.pdf appearing when doing Offline contributionsHi there,
Recently, my client noticed that Offline contributions made via ```Submit a Credit Card Membership``` were sending out blank Invoice pdfs. I don't think that this was happening previously.
## How to reproduce
1. Go to new me...Hi there,
Recently, my client noticed that Offline contributions made via ```Submit a Credit Card Membership``` were sending out blank Invoice pdfs. I don't think that this was happening previously.
## How to reproduce
1. Go to new member contact record and select "Membership" tab
1. Choose "Submit credit card membership"
1. Enter membership details and select "Save"
1. Receipt is automatically sent to member
## CiviCRM details
+ CiviCRM 5.49.4
+ Drupal 7
## Log Error message
```
2022/10/21 09:48:39 [error] 25282#25282: *7533568 FastCGI sent in stderr: "emplate.php).PHP message: [notice] [php] [209.169.169.221] [uid:1] [https://test.org/civicrm/contact/view/membership] [https://test.org/civicrm/contact/view/membership?reset=1&action=add&cid=107793&context=membership&mode=test] Notice: Undefined variable: html in CRM_Contribute_Form_Task_Invoice::printPDF() (line 516 of /sites/all/modules/civicrm/CRM/Contribute/Form/Task/Invoice.php).
PHP message: [notice] [php] [209.169.169.221] [uid:1] [https://test.org/civicrm/contact/view/membership] [https://test.org/civicrm/contact/view/membership?reset=1&action=add&cid=107793&context=membership&mode=test] Notice: Only variable references should be returned by reference in CRM_Mailing_Event_BAO_Delivered::create() (line 34 of /sites/all/modules/civicrm/CRM/Mailing/Event/BAO/Delivered.php)" while reading response header from upstream, client: 209.169.169.221, server: test.org, request: "POST /civicrm/contact/view/membership HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php7.3-fpm.sock:", host: "test.org", referrer: "https://test.org/civicrm/contact/view/membership?reset=1&action=add&cid=107793&context=membership&mode=test"
```https://lab.civicrm.org/dev/core/-/issues/3926Need to increase data size for 'url' column on 'civicrm_website' table2022-10-28T15:46:49ZyashodhaNeed to increase data size for 'url' column on 'civicrm_website' tableOverview
----------------------------------------
Currently _url_ column of the _civicrm_website_ table is of maxlength 124. This is not sufficient for some website in which case it truncates and renders them useless.
Proposed behavio...Overview
----------------------------------------
Currently _url_ column of the _civicrm_website_ table is of maxlength 124. This is not sufficient for some website in which case it truncates and renders them useless.
Proposed behaviour
----------------------------------------
The Proposal is to change the maxlength of the _url_ column of the _civicrm_website_ table to 255 instead of 124.5.56.0yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/3923Search Kit does not populate Tag Name(s) when the condition is set to "Is One...2023-02-11T18:39:59ZbrienneSearch Kit does not populate Tag Name(s) when the condition is set to "Is One Of"Overview
----------------------------------------
When creating a search in Search Kit, the list of tag names to select does not populate when the Contact Tag entity is chosen and a condition of Tag Name "Is One Of"
Reproduction steps
-...Overview
----------------------------------------
When creating a search in Search Kit, the list of tag names to select does not populate when the Contact Tag entity is chosen and a condition of Tag Name "Is One Of"
Reproduction steps
----------------------------------------
1. Make sure that you have a Contact Tag with which to test (which can be set up via **Contacts >> Manage Tags >> Add Tag).
1. Go to **Search Kit** and click **New Search**
2. Make sure that the primary entity is *Contact*, then click **+Entity** and select **Contact Tags**
3. Under the *Contact Tags* entity, click **Add Condition** and select **Tag Name** and **Is One Of**
4. When you click in the select box to select the tag names, however, there are no drop down options nor auto-complete selects as you start typing.
Current behaviour
----------------------------------------
When you add a Contact Tag entity in Search Kit, and include a condition that uses "Is One Of" to limit the tag names, a list of those available tag names does not appear. While the features does still work if you type the full and exact name of the tag into the list, that shouldn't be necessary.
![Selection_076](/uploads/96c85e6ba9db93533b726f7bfa414c20/Selection_076.png)
*Note that in this photo, I am searching for a tag named "contact tag 1" that does not appear when typed into the text box, nor do any other options show before typing*
Expected behaviour
----------------------------------------
A drop down list of available tag names should appear when `Tag Name Is One Of` is set as the condition, and as you type in the text box the drop down list should filter accordingly.
Environment information
----------------------------------------
* __CiviCRM:__ _Master/5.55alpha1https://lab.civicrm.org/dev/core/-/issues/3908Permission to view Subscription History in SearchKit2022-11-22T09:40:51ZwmortadaPermission to view Subscription History in SearchKitOverview
----------------------------------------
I've created a saved search using SearchKit to show contacts that have recently signed up to a mailing list. This search works fine for users with full administer permissions to CiviCRM ...Overview
----------------------------------------
I've created a saved search using SearchKit to show contacts that have recently signed up to a mailing list. This search works fine for users with full administer permissions to CiviCRM but doesn't show any results for users with more limited permissions to CiviCRM.
Reproduction steps
----------------------------------------
1. Create a search using SearchKit that uses the Contact Subscription Histories entity - see below
2. View the search as a user with access to CiviCRM but not the 'administer CiviCRM' permission
![image](/uploads/7ec66c8b8ae197ebb4c6d0c5a847cb36/image.png)
Current behaviour
----------------------------------------
The results don't load for the user with limited permissions. Note that the column headings are also missing.
![image](/uploads/aa2eadeac7872d9ff9432d0c6fcb0d4f/image.png)
Expected behaviour
----------------------------------------
The results should load
![image](/uploads/6a430f08519863c1cf05fb8f19b06bf8/image.png)
Environment information
----------------------------------------
CiviCRM 5.56.alpha1https://lab.civicrm.org/dev/core/-/issues/3905Need to increase data size for 'data' column on 'civicrm_job_log' table2022-10-12T13:27:08ZyashodhaNeed to increase data size for 'data' column on 'civicrm_job_log' tableOverview
----------------------------------------
Currently _data_ column of the _civicrm_job_log_ table is of data type TEXT. This is sufficient for running most jobs. However we have a some comprehensive log for mailchimp sync extensio...Overview
----------------------------------------
Currently _data_ column of the _civicrm_job_log_ table is of data type TEXT. This is sufficient for running most jobs. However we have a some comprehensive log for mailchimp sync extension and it would throw errors when running the job.
`INSERT INTO civicrm_job_log (domain_id , job_id , name , command , ...", "1406 ** Data too long for column 'data' at row 1`
Proposed behaviour
----------------------------------------
The Proposal is to change the data type of the _data_ column of the _civicrm_job_log_ table to LONGTEXT instead of TEXT.5.56.0yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/3904SearchKit: Active Relationship filter doesn't work in Form Builder2024-02-01T11:35:21ZGhost UserSearchKit: Active Relationship filter doesn't work in Form BuilderOverview
----------------------------------------
When you create a report with Search Kit and Form Builder to view the current Active Relationships, when you filter by "Is Active: Yes" it messes up and shows you the inactive Relationsh...Overview
----------------------------------------
When you create a report with Search Kit and Form Builder to view the current Active Relationships, when you filter by "Is Active: Yes" it messes up and shows you the inactive Relationships.
Reproduction steps
----------------------------------------
1. Create a Search Kit with Related Contacts such as Below
![image](/uploads/76051b5efdcbe35c7ae8f8d0f06ef021/image.png)
2. In the Form Builder add the "Relationship is Active" Field to be able to filter by it.
![image](/uploads/973c5d23ca11fece04f5eb86e957bbbe/image.png)
3. In the Report just filter by active Relationhsips. It will show you the inactive relationships.
![image](/uploads/bca81addc8e401ebf691152bfe62b44f/image.png)
Current behaviour
----------------------------------------
When you filter in the Search Kit Form it filters correctly.
![image](/uploads/089efa35f6f7bbb42836608e7e9e6ad2/image.png)
But when you filter in the Form, it shows you the inactive relationships, as showed above.
When you filter by Inactive relationships they are showed correctly.
![image](/uploads/226ea4dd88937432a00b3db138d5ff69/image.png)
But when you filter by both, it shows only Inactive Relationships.
![image](/uploads/e06ba811de15c17b6db2439a6243727d/image.png)
When you leave the filtering empy it works fine. It shows Active and Inactive Relationships.
Expected behaviour
----------------------------------------
Filter by Active relationships when you input "Yes".
Filter by Inactive relationships when you input "No".
Environment information
----------------------------------------
* __CiviCRM:__ dmaster v.5.56https://lab.civicrm.org/dev/core/-/issues/3893Searchkit: Change Rewrite field to textarea2023-11-15T14:51:59ZshaneonabikeSearchkit: Change Rewrite field to textareaHey there,
After realizing that we can use SMARTY conditions in Searchkit this really took one of our clients systems to an entire new level. Thanks so much for all the hard work on Searchkit!
## Problem
Presently, the Searchkit Rewri...Hey there,
After realizing that we can use SMARTY conditions in Searchkit this really took one of our clients systems to an entire new level. Thanks so much for all the hard work on Searchkit!
## Problem
Presently, the Searchkit Rewrite field is a textfield, which is fine if you want to append a few characters to the end or before a value. It gets extremely hard to read and also modify (I have to use a texteditor beside) to modify if you start using SMARTY attributes.
In the situation below, we are generating one column that contains one of two values using a SMARTY ```if```.
![Selection_001](/uploads/57432093e023009c9b311a77f1fe00eb/Selection_001.png)
to generate
![Selection_002](/uploads/1a87132c9a0e9ce080c8e9bd2418c5ea/Selection_002.png)
## Proposed solution
Would it be difficult to modify this field to a textarea instead? It would make it much easier to modify and read. I really don't know if this would be a massive change but I think it would really help. Also, we could provide a help icon to inform people that they can use SMARTY in these fields as long as they put quotes around the different values being retrieved (this was the element I was missing when I first tried and didn't get it working.
![Selection_003](/uploads/10973172b4588429613fbc87616ea879/Selection_003.png)5.56.0https://lab.civicrm.org/dev/core/-/issues/3866API - CustomGroup - extends_entity_column_value2022-09-26T23:06:37ZtschuettlerAPI - CustomGroup - extends_entity_column_valueOverview
----------------------------------------
Filtering custom field groupy by `extends_entity_column_value` is not possible via API. It is also not possible to create a custom field group via API explorer when trying to limit it by ...Overview
----------------------------------------
Filtering custom field groupy by `extends_entity_column_value` is not possible via API. It is also not possible to create a custom field group via API explorer when trying to limit it by `extends_entity_column_value`, because you have no option value to select.
Reproduction steps
----------------------------------------
1. Create a new Custom Field Group via UI.
* Let it extend `Activity` and limit it to `Phone Call`
1. Try to retrieve that Custom Field Group via APIv3 or APIv4 by adding a filter on `extends_entity_column_value`
1. The field for the Option list will remain empty with a loading gif in the API Explorer
Current behaviour
----------------------------------------
``` php
\Civi\Api4\CustomGroup::get()
->addWhere('extends', '=', 'Activity')
->addWhere('extends_entity_column_value:name', '=', 'Phone Call')
->execute();
```
Returns an empty result. The value for `extends_entity_column_value` seems to get dropped in the process of executing the query.
Creating the Custom Group via API works via code or browser, by creating the request manually.
https://dmaster.demo.civicrm.org/civicrm/api4#/explorer/CustomGroup/create?values=%5B%5B%22title%22,%22Phone%20Call%20Fields%22%5D,%5B%22extends%22,%22Activity%22%5D,%5B%22extends_entity_column_value:name%22,%22Phone%20Call%22%5D%5D
There is no drop down option in the API Explorer.
``` php
\Civi\Api4\CustomGroup::create()
->addValue('title', 'Phone Call Fields')
->addValue('extends', 'Activity')
->addValue('extends_entity_column_value:name', 'Phone Call')
->execute();
```
Expected behaviour
----------------------------------------
Existing custom field groups should be filterable by `extends_entity_column_value` via API.
Environment information
----------------------------------------
* __Browser:__ _Firefox 102.2.0
* https://dmaster.demo.civicrm.org
Comments
----------------------------------------
This seems to fail both with APIv3 and APIv4.https://lab.civicrm.org/dev/core/-/issues/3844Dummy payment processor should be flagged as such on LIVE page2023-01-31T09:53:32ZyashodhaDummy payment processor should be flagged as such on LIVE pageWhen dummy payment processor is configured for contribution pages/ event, there is no indication that is NOT a real transaction. This could be confusing and we should flag any LIVE page that is configured with dummy processor.
![dummy](...When dummy payment processor is configured for contribution pages/ event, there is no indication that is NOT a real transaction. This could be confusing and we should flag any LIVE page that is configured with dummy processor.
![dummy](/uploads/7cbf8624f40a97ab1c89d123ab4b4941/dummy.png)
![con_page](/uploads/1ea201d5b3c96e90e5385b5f82596996/con_page.png)
No indication that this is a Dummy payment processor
![contr+page](/uploads/456a92cbdafa407721c1ac4545cbb22e/contr+page.png)
This would similar to what we already do for TEST transactions.5.59.0yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/3802Symfony 6 can't find the EventDispatcher when adding hooks that are defined i...2022-08-15T02:11:04ZDaveDSymfony 6 can't find the EventDispatcher when adding hooks that are defined in getSubscribedEventsThey did this, and also a little higher up you can see they removed the constructor: https://github.com/symfony/event-dispatcher/commit/0bc2e0d8ba8a6eb353a42d19890f57a3dee410a5#diff-f3f413e17bbd20e345b3721f9c4556ed5e319d133c32bf7492dffd5...They did this, and also a little higher up you can see they removed the constructor: https://github.com/symfony/event-dispatcher/commit/0bc2e0d8ba8a6eb353a42d19890f57a3dee410a5#diff-f3f413e17bbd20e345b3721f9c4556ed5e319d133c32bf7492dffd55a024d0efR57
So what happens is this https://github.com/civicrm/civicrm-core/blob/da21dc84950b013a03d3fe5e72e12e7d652cce7f/Civi/Core/Container.php#L93 is expecting it to be called `dispatcher`, but this https://github.com/symfony/event-dispatcher/commit/0bc2e0d8ba8a6eb353a42d19890f57a3dee410a5#diff-f3f413e17bbd20e345b3721f9c4556ed5e319d133c32bf7492dffd55a024d0efR57 is expecting it to be called `event_dispatcher`, so that returns early and never calls `$container->findTaggedServiceIds('kernel.event_listener'`, so doesn't pick up any of the getSubscribedEvents hooks, e.g. civi.token.eval and others.
The naive fix of calling `$container->setAlias('event_dispatcher', 'dispatcher')` doesn't seem to be enough and causes a crash later which I haven't tracked down yet.5.54.0https://lab.civicrm.org/dev/core/-/issues/3634When using a smart group as a mailing list, users who unsubscribe from the sm...2022-06-11T14:57:45Ztom.mWhen using a smart group as a mailing list, users who unsubscribe from the smart group are still included in the mailing.It looks like in CRM/MailingBAO/Mailing.php, is not taking into account those who have been removed from the smart group. Civi version 5.3.
```
if (count($includeSmartGroupIDs)) {
$query = CRM_Utils_SQL_Select::from($contact)
...It looks like in CRM/MailingBAO/Mailing.php, is not taking into account those who have been removed from the smart group. Civi version 5.3.
```
if (count($includeSmartGroupIDs)) {
$query = CRM_Utils_SQL_Select::from($contact)
->select("$contact.id as contact_id, $entityTable.id as $entityColumn")
->join($entityTable, " INNER JOIN $entityTable ON $entityTable.contact_id = $contact.id ")
->join('gc', " INNER JOIN civicrm_group_contact_cache gc ON $contact.id = gc.contact_id ")
->join('mg', " INNER JOIN civicrm_mailing_group mg ON gc.group_id = mg.entity_id AND mg.search_id IS NULL ")
->join('temp', " LEFT JOIN $excludeTempTablename temp ON $contact.id = temp.contact_id ")
->where('gc.group_id IN (#groups)')
->merge($criteria)
->replaceInto($includedTempTablename, array('contact_id', $entityColumn))
->param('#groups', $includeSmartGroupIDs)
->param('#mailingID', $mailingID)
->execute();
}
```https://lab.civicrm.org/dev/core/-/issues/3632Mass SMS not sent to contacts whose mobile phone is not their Primary phone2022-06-12T21:25:03ZkenMass SMS not sent to contacts whose mobile phone is not their Primary phoneI have just upgraded to CiviCRM 5.3.2 and have found that Mass SMS are not being delivered to contacts where the mobile phone is not the Primary phone.
The change was made in this commit https://github.com/civicrm/civicrm-core/commit/6f...I have just upgraded to CiviCRM 5.3.2 and have found that Mass SMS are not being delivered to contacts where the mobile phone is not the Primary phone.
The change was made in this commit https://github.com/civicrm/civicrm-core/commit/6f3a35e0986bc21ffbf730c7d3f20f2894c1bb58#diff-8c026e80a2f25f46826dd9568bc301b0 in this PR https://github.com/civicrm/civicrm-core/pull/11558 as a result of this refactoring https://issues.civicrm.org/jira/browse/CRM-21316.
It seems from the unit test case that the code handles the case where a contact has multiple Mobile phones and chooses the Primary phone over the non-Primary phone.
But the code fails if the Primary phone is not the Mobile one.
What is needed is something similar to the Mass Email case. For emails, CRM_Mailing_BAO_Mailing::getLocationFilterAndOrderBy() generates a WHERE clause and an ORDER BY clause that ensures the right emails are selected and preferred.https://lab.civicrm.org/dev/core/-/issues/3628Add pre/post hook for CRM_Mailing_BAO_MailingJob2022-06-15T11:19:25ZMonish DebAdd pre/post hook for CRM_Mailing_BAO_MailingJobThis ticket is about adding pre, post hook to MailingJob and it involve:
1. Call the pre/post hook inside `CRM_Mailing_BAO_MailingJob::create()`
2. Add `CRM_Mailing_BAO_MailingJob::deleteMailingJob` to delete Mailing Jobs and add pre/pos...This ticket is about adding pre, post hook to MailingJob and it involve:
1. Call the pre/post hook inside `CRM_Mailing_BAO_MailingJob::create()`
2. Add `CRM_Mailing_BAO_MailingJob::deleteMailingJob` to delete Mailing Jobs and add pre/post delete hook
3. Replace all the DAO call with corresponding create and delete fn in the codebase.Monish DebMonish Debhttps://lab.civicrm.org/dev/core/-/issues/3599Test mailings create new contacts even when "Add Contacts" permission is not ...2022-06-11T14:55:17ZJonGoldTest mailings create new contacts even when "Add Contacts" permission is not present.### Overview
When sending a test mail, CiviCRM will check if the email matches an existing contact in the database. If it does, it uses that contact ID; if not, it creates a contact. However, it creates a contact without regard for wh...### Overview
When sending a test mail, CiviCRM will check if the email matches an existing contact in the database. If it does, it uses that contact ID; if not, it creates a contact. However, it creates a contact without regard for whether a user has permission to add contacts.
### Steps to replicate
* Create a user that does not have the "Add Contacts" permission.
* With that user, create a new mailing (traditional or Mosaico, doesn't matter).
* Send a test ("draft") mail to an email address that doesn't exist in the database.
### Expected behavior
No new contact is created.
### Actual behavior
A new contact is created.5.29.0JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/3581Email to activity processing: New feature to skip emails which do not have a ...2022-06-11T14:54:48ZJamie Novick - CompucoEmail to activity processing: New feature to skip emails which do not have a Case ID or Case token- As a CiviCRM administrator
- I would like to configure whether CiviCRM will process emails without a case ID (or case “token”) in the subject line
- so that I can ensure that emails which do not have a case ID are not filed on the con...- As a CiviCRM administrator
- I would like to configure whether CiviCRM will process emails without a case ID (or case “token”) in the subject line
- so that I can ensure that emails which do not have a case ID are not filed on the contact record outside the case by accident.
**How it works currently**
For those a little less familiar with email to activity processing:
CiviCRM will connect to a users MS exchange mailbox and create the following folder structure:
- Inbox
- /CiviCRM
- //CiviMail
- ///ignored
- ///processed
Notes:
- Users simply copy or move emails into the /civicrm folder in their inbox. CiviCRM has a scheduled job that can be configured to run periodically (say every hour) and poll the mailbox folder (Civimail) by IMAP in order to read and process the emails.
- By default CiviCRM will match any email from, to, cc fields to contacts in the CRM and file the email as an activity against those contacts (including recording any attachments as files).
- If however there is a case ID in the subject line (or a case ID "token"*) then CiviCRM will instead file the email straight onto the case itself. The format is: [case #1234] (see: https://issues.civicrm.org/jira/browse/CRM-21446)
- If the email is processed successfully it will be moved to the processed folder.
- If for any reason CiviCRM cannot file the email it will be moved to the ignored folder. This normally happens if the email address is invalid for some reason (please note: emails that are sent internally between staff on exchange server can sometimes have this problem as exchange doesn't always use the external email address but instead uses some local username/domain combination - this maybe something to test and see if it maybe a problem for NEU).
- Note: *When sending out emails from CiviCRM from CiviCase it appends a case ID token - which is a string of characters and not the exact Case ID. This is done to obscure the case ID number in the email. In effect you can have either this token or the case id in the subject line and CiviCRM will file the email correctly.
- More background: https://docs.civicrm.org/sysadmin/en/latest/setup/civimail/inbound/#autofiling-email-activities-via-emailprocessor
**Problem**
For multiple clients they want to use email to activity processing for their casework teams. However sometimes they forget to add the case ID to the subject line of the email and the system incorrectly files the email outside the case - which is a "security" risk as the emails can be sensitive.
As such they would like to be able to specify that the emails being filed from the casework team inbox will only be filed if there is a valid Case ID in the subject line and are skipped if not, and hence there is no risk of the email being filed outside of the case.
**Proposed improvement**
Approach:
When "Used For?" = Email to activity processing
Show an additional option:
- Skip emails which do not have a Case ID or Case token:
- Checkbox
- Help text:
- CiviCRM has functionality to file emails which contain the Case ID or Case Hash in the subject line in the format [case #1234] against a case record.
- Where the Case ID or Case Hash is not included CiviCRM will file the email against the contact record, by matching the email addresses on the email with any email addresses of Contact records in CiviCRM.
- Enabling this option will have CiviCRM skip any emails that do not have the Case ID or Case Hash so that the system will only process emails that can be placed on case records.
- Any emails that are not processed will be moved the ignored folder.
- Default null
- If checked:
- Emails which do not have a valid case ID or case token should be moved into the “ignored” folder. (See folders above) after processing and no Activity should be created.
Would be great to know if we can get the magical "concept approved" flag.
We need to work on this quite urgently so if there are no great concerns that would be much appreciated...5.31.0https://lab.civicrm.org/dev/core/-/issues/3579Add pause/resume functionality to civicrm bulk mailing.2022-06-11T14:54:43ZjitendraAdd pause/resume functionality to civicrm bulk mailing.Scenario
Site admin is sending out a big blast but want to send out a press release without waiting for first job to end.Scenario
Site admin is sending out a big blast but want to send out a press release without waiting for first job to end.5.4.0https://lab.civicrm.org/dev/core/-/issues/3566Public View link does not show from Scheduled and Sent screen2022-06-11T14:54:15ZseamusleePublic View link does not show from Scheduled and Sent screenWhen you view a list of scheduled and sent mailings you cannot access the Public View url link even tho the code suggests it should be availableWhen you view a list of scheduled and sent mailings you cannot access the Public View url link even tho the code suggests it should be available5.10