Demerit
  • Member for 6 years, 10 months
  • Last seen this week
How to search for contacts by date added or date range added. Alternately: list contacts by date added
8 votes

Under Search - Custom Searches - Date Added to CiviCRM. Also a variation is under Search - Advanced Search, and expand the Change Log tab.

View answer
How to make status always 'Completed' for activities added to a case?
8 votes

Might be easiest to update the database is_default field. Works for me on a 4.6 site: update civicrm_option_value set is_default=0 where option_group_id=26 and name='Scheduled'; update ...

View answer
Unique custom field - contact creation
7 votes

The "external identifier" field on contact records is available so you don't need a custom field. It won't allow duplicates.

View answer
When will MySQL utf8mb4 support be mandatory?
7 votes

It seems like it's still under discussion as of last week. See e.g. https://lab.civicrm.org/dev/core/issues/979

View answer
create a group of contacts NOT matching search criteria
6 votes

Create a group that DOES match the criteria. Go to Search - Custom Search - Include/Exclude search. Search for contacts excluding your group from (1).

View answer
How to try out new 'Search Builder'?
Accepted answer
6 votes

Note if you install from a tar file the extension is not available until 5.30. Git/composer/buildkit installs have it in 5.29. Also the styling on the search page is messy until 5.31, and before then ...

View answer
Where does CiviCRM store Merge 'history'?
Accepted answer
6 votes

An activity gets recorded when you merge and it looks up the target contact via that. Use $winnerContact = civicrm_api3('Contact', 'getmergedto', ['contact_id' => $contactId]). See also https://...

View answer
Can not find Civicrm.settings.php
Accepted answer
6 votes

Normally you don't install from github you would get it from https://civicrm.org/download and then follow the instructions at https://docs.civicrm.org/sysadmin/en/latest/install/drupal7 If you are ...

View answer
SMARTY error with template
Accepted answer
6 votes

The styling needs to be wrapped in {literal}...{/literal} in the message template.

View answer
Event Attendance tracking
6 votes

Participant records have a status field, and one of the standard statuses is Attended, so yes. And you can search for participants with a certain status and reports can include the status. See also ...

View answer
How to modify System workflow message with a modern look Header?
Accepted answer
6 votes

Put your css inside {literal}{/literal} tags to prevent smarty from processing them.

View answer
How to change the encoding in pdf documents?
Accepted answer
6 votes

I don't think it's the encoding it seems that none of the included fonts in dompdf support it. See also https://stackoverflow.com/questions/16384517/dompdf-character-encoding-utf-8. If you look in the ...

View answer
Is automatic new Drupal user to existing CiviCRM contact linking a possible security vulnterability?
Accepted answer
6 votes

It is but isn't specific to civicrm - the problem in that scenario is allowing anonymous signup without either administrator approval or email verification. Set at least the setting in drupal user ...

View answer
unexpected extensions listed in system status
Accepted answer
5 votes

A couple versions ago the concept of "hidden" extensions was introduced. The theory was it would allow for moving bits of code out of core and into extensions without anyone noticing any ...

View answer
Drupal 8: How do I shift a project/site from using the roundearth installation method to the CiviCRM official composer asset plugin
5 votes

Depending on how your initial site set up was created you might need to take a more extreme option detailed below but hopefully the following will work: If you want you can copy composer.json , ...

View answer
Will Installing Updates in Civi and Drupal mess up my website?
Accepted answer
5 votes

It's always recommended to test the upgrade on a copy of your site first. A guide how to make a copy is at https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers/

View answer
Civirules send email
5 votes

You need to also install another extension which is mentioned lower down on the introduction page: https://docs.civicrm.org/civirules/en/latest/#other-useful-extensions-and-modules You need the Email ...

View answer
Why should I use an ~/extensions directory rather than the default ~/ext for new extensions?
5 votes

The ext dir that ships in the tarball is for extensions bundled directly with core like IATS. If you put other extensions in there they will get wiped when you upgrade, so it's common to put them ...

View answer
Do any token extensions provide a token for "age" rather than just DOB?
5 votes

I don't see any either, but the code to use in such an extension (as either a token or even a smarty modifier) seems pretty straightforward: https://github.com/civicrm/civicrm-core/blob/5.19.2/CRM/...

View answer
How can I disable a reserved profile?
5 votes

You can actually still edit it and uncheck the active box you just have to hack the url to use the id, e.g. https://site-url/civicrm/admin/uf/group/update?action=update&id=22&context=group ...

View answer
Insert and Get New ID in Extension
Accepted answer
5 votes

You could do something like CRM_Core_DAO::executeQuery("SELECT LAST_INSERT_ID()");. If your needs are simple that seems like the easiest. Probably to do it "right", you would use civix generate:...

View answer
Is it possible to install CiviCase without all the sample data?
5 votes

The short answer is no. But it's a good point. I think this is mostly just left over from the original implementation when setting up civicase was difficult, and it was hard to know what it would look ...

View answer
What is the largest number of customer records that civicrm supports?
5 votes

There's a difference between how many records a database can hold and how many users need to access the system simultaneously on a regular basis. For the latter it's a much harder question because it ...

View answer
Multi-Factor Authentification?
4 votes

CiviCRM doesn't because it doesn't control logins. Whatever CMS you're using will have something for it (e.g. Drupal/Wordpress/Joomla).

View answer
Tax Receipt report Generation from CiviCRM
4 votes

Under administer - system settings - extensions, go to the add new tab. Then install CDN Tax Receipts. Then there'll be a configure page under administer - civicontribute. Then there'll be a button on ...

View answer
Is there a way to insert Case Type definitions?
Accepted answer
4 votes

When stored in files the definition field is null. See also What are the pros and cons of using external xml files for CiviCase configuration? But if you just want to consolidate all under one type, ...

View answer
Performance Bug in Trigger Causing ~1000x Slowdown
Accepted answer
4 votes

Nice find. Thanks for posting. Yes the inner join is generally better than a subquery. To answer your secondary question, to get it merged you need to create a ticket at https://lab.civicrm.org/dev/...

View answer
QR code inclusion in Mass-mailings
4 votes

It sounds like you would want to create a custom token. See https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_tokens/ So for the value of the token you would need to do the Swish api call and ...

View answer
Civicase add timeline but activities not shown
Accepted answer
4 votes

This looks like another casualty from the button UI changes. Have added https://lab.civicrm.org/dev/core/-/issues/2292. Can you try this small patch? https://github.com/civicrm/civicrm-core/pull/19356/...

View answer
Can't send individual emails from contact record
Accepted answer
4 votes

Take a look at https://lab.civicrm.org/dev/core/-/issues/2220 - we never figured out why on some sites it doesn't load the defaults. But you can manually set it with e.g. cv ev "Civi::settings()-&...

View answer
1
2 3 4 5
27