Development issueshttps://lab.civicrm.org/groups/dev/-/issues2022-11-24T05:03:32Zhttps://lab.civicrm.org/dev/core/-/issues/1124Activity export Source Contact fields and Contact ID return same ID for Indiv...2022-11-24T05:03:32ZStoobActivity export Source Contact fields and Contact ID return same ID for IndividualsHow to replicate in 5.15:
1. Create two activities with yourself as Source
* one with another individual contact as Target
* one with another organization contact as Target
2. Find Activities and Export these two activities
3. Choose...How to replicate in 5.15:
1. Create two activities with yourself as Source
* one with another individual contact as Target
* one with another organization contact as Target
2. Find Activities and Export these two activities
3. Choose the following field mapping
![exp](/uploads/8c99dcd5c25fa40bc8f709cac832b247/exp.png)
4. Notice how the Sort Name field and Internal Contact ID field return same ID for Individual but different ID for Organization
Expected behavior: Sort Name and Internal Contact ID should return the Target Contact (not the Source) for all contact types. Cannot think of a reason to do otherwise.
@eileen FYI pursuant to our convo on Mattermosthttps://lab.civicrm.org/dev/core/-/issues/1121Activity Export: Fields with the value of 0 are exported as empty2022-12-01T05:03:38ZReece Activity Export: Fields with the value of 0 are exported as emptyHi all,
When following the below steps, any fields that have the value of zero are exported into the CSV as empty cells.
Steps to reproduce (must have an Activity that has a field with the value of zero in it):
1. Perform an Activity ...Hi all,
When following the below steps, any fields that have the value of zero are exported into the CSV as empty cells.
Steps to reproduce (must have an Activity that has a field with the value of zero in it):
1. Perform an Activity Search
2. Select Activities (that contain either the value being zero or not)
3. Actions -> Export Activities
4. Select fields for Export
5. Fields:
* The field that has the value of zero (or other)
* Can also add the contact name to lookup in the UI easily..
6. Export
[Line 346 of Export.php on Master](https://github.com/civicrm/civicrm-core/blob/master/CRM/Export/BAO/Export.php#L346) is only checking against `empty($value)` whereas it should either check if the value `is_numeric($value)` aswell, or swap the empty function to `CRM_Utils_System::isNull($value)` which I believe would resolve this too.
Cheers,
Reecehttps://lab.civicrm.org/dev/core/-/issues/3651Activity import error output missing the column the error is about2022-06-14T03:15:51ZDaveDActivity import error output missing the column the error is aboute.g. Create an import file with an invalid date, something like this for Activities
```csv
Type,Subject,Contact,Date
2,something,13,2021-02-03 16
```
The error output will correctly flag the date column as invalid, but does not include...e.g. Create an import file with an invalid date, something like this for Activities
```csv
Type,Subject,Contact,Date
2,something,13,2021-02-03 16
```
The error output will correctly flag the date column as invalid, but does not include it in the output:
```csv
"Line Number",Reason,Type,Subject,Contact,Date
1,"Invalid value for field(s) : Activity Date",2,something,13
```5.51.0https://lab.civicrm.org/dev/core/-/issues/2325Activity import ignores time component of activity_date_time if the import fi...2022-06-11T19:27:55ZDaveDActivity import ignores time component of activity_date_time if the import file includes seconds and always ignores time for custom date fieldse.g. for activity_date_tinme 2021-01-02 10:11 imports correctly, but 2021-01-02 10:11:12 imports as 2021-01-02 00:00.
In master but also goes back to at least 5.24.
For custom fields of type date it seems to always ignore time.e.g. for activity_date_tinme 2021-01-02 10:11 imports correctly, but 2021-01-02 10:11:12 imports as 2021-01-02 00:00.
In master but also goes back to at least 5.24.
For custom fields of type date it seems to always ignore time.5.51.0https://lab.civicrm.org/dev/core/-/issues/2799Activity import: allow multivalue custom data2022-06-11T00:07:25ZMichael McAndrewActivity import: allow multivalue custom dataBefore: the current activity import does not allow the import of multi value custom data.
If I have a favourite primary colours field, I could not import a CSV with the a column for this field with the value `Red, Blue`. It would look f...Before: the current activity import does not allow the import of multi value custom data.
If I have a favourite primary colours field, I could not import a CSV with the a column for this field with the value `Red, Blue`. It would look for the entire string `Red, Blue` and complain that `Red, Blue` is not a primary colour.
After: we can now import multi value custom data using the comma as a separator.
The proposed patch explodes any _multi valued_ custom data fields on the `,` character.
Note that this does not stop people from using commas in labels of custom data fields. It just means that if people want to make use of the importer to import multi value custom data, they will need to ensure that their labels don't have any commas in them.
Saying the same thing again using some different words...
We are assuming that if people want to import multi value custom data then they will use a comma seperator to seperate fields and understand that any labels will not contain commas as a result.
This feel fairly reasonable to me.5.51.0https://lab.civicrm.org/dev/core/-/issues/2798activity import: better labels for custom fields2021-09-03T00:15:28ZMichael McAndrewactivity import: better labels for custom fieldsPreviously, in the activity import, the dropdown that allowed you to select the field that you want to map a csv column to did not include the custom group title when listing custom fields. This lead to a usability issue in data models w...Previously, in the activity import, the dropdown that allowed you to select the field that you want to map a csv column to did not include the custom group title when listing custom fields. This lead to a usability issue in data models where custom field titles are repeated across groups and there is no way of distinguishing these fields in the import UI.
With this patch, custom field group titles are prepended to field title like this: `Custom group title :: custom field title`.
This has the nice side effect that custom fields are grouped by custom group.
Also, it brings it inline with the behaviour of the contact import (win!)
See also https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport/issues/37 for a similar issue fixed in the @eileen's csv api import extension.5.43.0https://lab.civicrm.org/dev/core/-/issues/3964Activity import: source_record_id field not importable2022-12-12T16:43:41ZSandor SemseyActivity import: source_record_id field not importableOverview
---
During activity import (**Contacts >> Import Activities**) Source Record ID field cannot be mapped and imported. In my understanding that is because this field is not marked as importable. If I add the `import => TRUE` to th...Overview
---
During activity import (**Contacts >> Import Activities**) Source Record ID field cannot be mapped and imported. In my understanding that is because this field is not marked as importable. If I add the `import => TRUE` to the relevant DAO, `source_record_id` can be mapped and imported successfully.
I haven't found any references except for this unresolved StackExchange question (https://civicrm.stackexchange.com/questions/33639/importing-signatures-into-petition) and a related issue (https://lab.civicrm.org/dev/core/-/issues/1380) where the OP wants to import petition signatures into Civi.
I checked the oldest available version of Civi on GitHub and this field wasn't marked as importable even then. So this seems quite historical.
I wonder, is there any reasons why this field can't be imported?
Example use-case
---
Importing petition signatures from other systems to CiviCRM.
Current behaviour
---
Not possible to import `source_record_id` for activities.
Proposed behaviour
---
Possible to import `source_record_id` for activities.
Comments
---
I'm happy to open a PR if it gets approved.https://lab.civicrm.org/dev/core/-/issues/958Activity name instead of activity label on Type column at activity tab2019-05-15T14:57:46ZscardiniusActivity name instead of activity label on Type column at activity tabHi,
I saw such behavior at 5.13.2 version. For all types of activities there are "names" instead of "labels" on list of activities at activity tab.
Example: Meeting, in Polish translation "Spotkanie". I can filter activities by "Spotka...Hi,
I saw such behavior at 5.13.2 version. For all types of activities there are "names" instead of "labels" on list of activities at activity tab.
Example: Meeting, in Polish translation "Spotkanie". I can filter activities by "Spotkanie" but I receive "Meeting" on the list below.
![activity-type](/uploads/6f8b2919b7e21c30f5f8692ebd6cb303/activity-type.png)5.13.3https://lab.civicrm.org/dev/core/-/issues/1185Activity profile on Update multiple activities action displays duplicate assi...2019-08-16T07:10:06ZscardiniusActivity profile on Update multiple activities action displays duplicate assigneesActivity profile always displays *Added By*, *With Contact* and *Assigned to* fields.
*Assigned to* contains own contact and contacts for previous processed activities.
* 1st -> only own contact(s)
* 2nd -> own contact(s) and previous ...Activity profile always displays *Added By*, *With Contact* and *Assigned to* fields.
*Assigned to* contains own contact and contacts for previous processed activities.
* 1st -> only own contact(s)
* 2nd -> own contact(s) and previous contacts (from 1st)
* 3rd -> own contact(s) and previous contacts (from 1st and 2nd)
* 4th -> ...
I'm preparing PR5.18.0https://lab.civicrm.org/dev/core/-/issues/1832Activity receive_date is incorrectly updated to now when importing historical...2024-01-08T04:07:40ZananelsonActivity receive_date is incorrectly updated to now when importing historical transactionsContribution receive_date is incorrectly updated to now when importing historical transactions, see #1831 for more context.
Adding this line to addActivity() in `CRM/Activity/BAO/Activity.php` seems to fix:
```$date = CRM_Utils_Date::i...Contribution receive_date is incorrectly updated to now when importing historical transactions, see #1831 for more context.
Adding this line to addActivity() in `CRM/Activity/BAO/Activity.php` seems to fix:
```$date = CRM_Utils_Date::isoToMysql($activity->register_date);```
https://github.com/civicrm/civicrm-core/blob/master/CRM/Activity/BAO/Activity.php#L1708https://lab.civicrm.org/dev/core/-/issues/2894Activity redirects to search instead of view2023-10-18T05:03:24Zqwerty1234Activity redirects to search instead of viewSome activities after cliking `view` button redirect to search form instead od view. It happens if activity type is not defined in hardcoced list in `CRM/Activity/Selector/Activity.php` file in method `actionLinks`. Such action type is m...Some activities after cliking `view` button redirect to search form instead od view. It happens if activity type is not defined in hardcoced list in `CRM/Activity/Selector/Activity.php` file in method `actionLinks`. Such action type is managed by `default` case.https://lab.civicrm.org/dev/core/-/issues/1627Activity Report: filtering by "is null" or "is not null" is ignored2020-04-23T14:15:36ZJonGoldActivity Report: filtering by "is null" or "is not null" is ignoredOverview
----------------------------------------
On the Activity Details report, any filter that allows selecting "Is Null" or "Is Not Null" is broken (with the possible exception of the Source/Target/Assignee Contact filters).
Reprodu...Overview
----------------------------------------
On the Activity Details report, any filter that allows selecting "Is Null" or "Is Not Null" is broken (with the possible exception of the Source/Target/Assignee Contact filters).
Reproduction steps
----------------------------------------
* Go to the Activity Details report.
* Remove the "Activity Date is this month" default filter.
* Run the report. Observe the total number of activities in the database.
* Filter a field that allows null/not null (e.g. *Location*) to **Is Null**.
* Run the report again. Observe that the total number of activities is the same (but that could be legitimate).
* Filter the same field to **Is Not Null**.
* Run the report one more time. Observe that the total number of activities is *still* the same.
Current behaviour
----------------------------------------
Filtering by "is null" or "is not null" is ignored.
Expected behaviour
----------------------------------------
Filtering by "is null" or "is not null" should work.
Comments
----------------------------------------
This was broken by the fix to [CRM-18356](https://issues.civicrm.org/jira/browse/CRM-18356). Since my initial attempts at fixing this reintroduced the bug described there, I wrote tests for both scenarios to lock both fixes in.5.24.0JonGoldJonGoldhttps://lab.civicrm.org/dev/core/-/issues/925Activity report: include case activities filter ignored2020-03-05T20:45:12ZMonish DebActivity report: include case activities filter ignoredYou can see in the where clause case-activity filter field is always set to NULL.You can see in the where clause case-activity filter field is always set to NULL.5.12.0Monish DebMonish Debhttps://lab.civicrm.org/dev/core/-/issues/538Activity search (advanced search) by subject - is exact match only2022-11-25T05:03:18ZRayWrightActivity search (advanced search) by subject - is exact match onlySearching activity subject (or details) from the advanced search form is set to an exact match (=). This seems less than ideal as most of the time you won't know the exact subject or details. While you can add the wildcard % characters t...Searching activity subject (or details) from the advanced search form is set to an exact match (=). This seems less than ideal as most of the time you won't know the exact subject or details. While you can add the wildcard % characters to search, the standalone activity search form operates as you'd expect using the LIKE term.
Can the advanced search (activities section) be made to match this behavior?
Here's a detailed breakdown verified on the demo site:
* Run an Advanced search for an activity that contains "Tell a Friend" in the subject line - no results.
* Run a standalone activity search (Search > Find Activities) for an activity that contains "Tell a Friend" in the subject line - returns all the activities that subject line contains the search term, including "Subject for Tell a Friend".
* Same problem when you search details or both.
Here is the on-screen feedback for the search results:
**Advanced Search**
```
No matches found for:
Activity targeted to ...AND...
Activity Text (Subject Only) = 'Tell a Friend' ...AND...
Activity Status In Completed
```
**Find Activies**
```
Activity targeted to ...AND...
Activity Text (Subject Only) Like '%Tell a Friend%' ...AND...
Activity Status In Completed
```https://lab.civicrm.org/dev/core/-/issues/1827Activity Search : Tags are not working2020-12-22T01:26:13ZsamuelsovActivity Search : Tags are not workingIn activity search screen, when filtering by tags, the wrong tag is filtered.
![Peek_18-06-2020_17-13](/uploads/1a03146c6f0f67ea707bd243abde980d/Peek_18-06-2020_17-13.gif)In activity search screen, when filtering by tags, the wrong tag is filtered.
![Peek_18-06-2020_17-13](/uploads/1a03146c6f0f67ea707bd243abde980d/Peek_18-06-2020_17-13.gif)https://lab.civicrm.org/dev/core/-/issues/1103Activity search by date range fails when "to" is empty2019-07-05T09:41:27Zsluc23Activity search by date range fails when "to" is emptySearching by Activity date range, only entering *from* date, and leaving *to* date empty fails.
`Activity Date: Please check that your date range is in correct chronological order.`
![Peek_2019-07-04_10-33](/uploads/900e721bd2d6c4a6...Searching by Activity date range, only entering *from* date, and leaving *to* date empty fails.
`Activity Date: Please check that your date range is in correct chronological order.`
![Peek_2019-07-04_10-33](/uploads/900e721bd2d6c4a6a1888008a32a2998/Peek_2019-07-04_10-33.gif)https://lab.civicrm.org/dev/core/-/issues/342Activity Search does not show any results because the default option "With" i...2018-08-28T11:40:25Zjustinfreeman (Agileware)Activity Search does not show any results because the default option "With" is included in the search criteria despite no "Name or Email" being definedActivity Search does not show any results because the default option "With" is included in the search criteria despite no "Name or Email" being defined.
Applies to CiviCRM 5.4.0.
**Steps to reproduce**
1. Go to Find Activities
2. Selec...Activity Search does not show any results because the default option "With" is included in the search criteria despite no "Name or Email" being defined.
Applies to CiviCRM 5.4.0.
**Steps to reproduce**
1. Go to Find Activities
2. Select an Activity Type for which Activities exist
3. Click Search
4. No Activities are shown in the search results.
5. Scroll down and view the search criteria, you can see that "Activity targeted to ...AND..." has been added to the criteria
6. Click the X next to the "With" criteria
7. Click Search
8. Activities ARE shown in the search results.
**Fix required**
The "With" criteria should be unselected by default.
![Find_Activities_Default](/uploads/8432837978fe0b88a0ced521ca7ddc00/Find_Activities_Default.png)
Our reference SUP-5948https://lab.civicrm.org/dev/core/-/issues/1616Activity Search doesn't display activities with no "With Contact"2023-02-16T15:15:35ZJonGoldActivity Search doesn't display activities with no "With Contact"To replicate:
* Create a new activity without anyone listed as "With Contact".
* Search for the activity from **Find Activities**.
I hadn't considered the use case of an activity with no "With Contact", but apparently my client has - an...To replicate:
* Create a new activity without anyone listed as "With Contact".
* Search for the activity from **Find Activities**.
I hadn't considered the use case of an activity with no "With Contact", but apparently my client has - and it's not a required field. So it seems that these activities should show up in search.https://lab.civicrm.org/dev/core/-/issues/148Activity Separation field changes the default behaviour2022-08-13T05:03:48ZyashodhaActivity Separation field changes the default behaviourSome of the users without realizing might select the first option that is *Create separate activities for each contact* which might confuse them since that's not how it behaved earlier.Some of the users without realizing might select the first option that is *Create separate activities for each contact* which might confuse them since that's not how it behaved earlier.yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/1619Activity Summary civireport gives fatal error when grouping activity date by ...2020-02-27T23:22:50ZDaveDActivity Summary civireport gives fatal error when grouping activity date by quarterNot working since at least 5.20. Haven't checked farther back.
```
INSERT INTO civicrm_tmp_e_dflt_c96bd73d5a616c0a85f8b776fdaf8a13 ( civicrm_contact_id,civicrm_activity_activity_date_time_start,civicrm_activity_activity_date_time_interv...Not working since at least 5.20. Haven't checked farther back.
```
INSERT INTO civicrm_tmp_e_dflt_c96bd73d5a616c0a85f8b776fdaf8a13 ( civicrm_contact_id,civicrm_activity_activity_date_time_start,civicrm_activity_activity_date_time_interval,civicrm_activity_activity_date_time_subtotal,civicrm_activity_activity_type_id,civicrm_activity_duration,civicrm_activity_id_count )
SELECT SQL_CALC_FOUND_ROWS contact_civireport.id as civicrm_contact_id, STR_TO_DATE(CONCAT( 3 * QUARTER( activity_civireport.activity_date_time ) -2 , '/', '1', '/', YEAR( activity_civireport.activity_date_time ) ), '%m/%d/%Y') AS civicrm_activity_activity_date_time_start, QUARTER(activity_civireport.activity_date_time) AS civicrm_activity_activity_date_time_subtotal, QUARTER(activity_civireport.activity_date_time) AS civicrm_activity_activity_date_time_interval, GROUP_CONCAT(DISTINCT activity_civireport.activity_type_id ORDER BY activity_civireport.activity_type_id ) as civicrm_activity_activity_type_id, activity_civireport.duration as civicrm_activity_duration, COUNT(DISTINCT(activity_civireport.id)) as civicrm_activity_id_count
FROM civicrm_activity activity_civireport
LEFT JOIN civicrm_activity_contact target_activity
ON activity_civireport.id = target_activity.activity_id AND
target_activity.record_type_id = 3
LEFT JOIN civicrm_activity_contact assignment_activity
ON activity_civireport.id = assignment_activity.activity_id AND
assignment_activity.record_type_id = 1
LEFT JOIN civicrm_activity_contact source_activity
ON activity_civireport.id = source_activity.activity_id AND
source_activity.record_type_id = 2
LEFT JOIN civicrm_contact contact_civireport
ON target_activity.contact_id = contact_civireport.id
LEFT JOIN civicrm_contact civicrm_contact_assignee
ON assignment_activity.contact_id = civicrm_contact_assignee.id
LEFT JOIN civicrm_contact civicrm_contact_source
ON source_activity.contact_id = civicrm_contact_source.id
LEFT JOIN civicrm_option_value
ON ( activity_civireport.activity_type_id = civicrm_option_value.value )
LEFT JOIN civicrm_option_group
ON civicrm_option_group.id = civicrm_option_value.option_group_id
LEFT JOIN civicrm_case_activity
ON civicrm_case_activity.activity_id = activity_civireport.id
LEFT JOIN civicrm_case
ON civicrm_case_activity.case_id = civicrm_case.id
LEFT JOIN civicrm_case_contact
ON civicrm_case_contact.case_id = civicrm_case.id WHERE civicrm_option_group.name = "activity_type" AND
activity_civireport.is_test = 0 AND
activity_civireport.is_deleted = 0 AND
activity_civireport.is_current_revision = 1 AND ((`activity_civireport`.`activity_type_id` IS NULL OR (`activity_civireport`.`activity_type_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 53, 33, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 54, 55, 56, 58, 60, 62, 64, 66))) OR civicrm_contact_source.is_deleted=0 OR civicrm_contact_assignee.is_deleted=0) GROUP BY YEAR(activity_civireport.activity_date_time), QUARTER(activity_civireport.activity_date_time), contact_civireport.id, STR_TO_DATE(CONCAT( 3 * QUARTER( activity_civireport.activity_date_time ) -2 , '/', '1', '/', YEAR( activity_civireport.activity_date_time ) ), '%m/%d/%Y'), QUARTER(activity_civireport.activity_date_time), activity_civireport.duration ORDER BY activity_civireport.activity_type_id ASC LIMIT 0, 50 [nativecode=1055 ** Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'core16560724hxcivi_syiur.activity_civireport.activity_type_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]
```5.24.0