6

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://github.com/civicrm/civicrm-core/blob/5.20.2/api/v3/Contact.php#L1275


6

Do a search that finds all contacts (for example, Find Contacts and then search without entering anything), then select "All nnn contacts" and choose Export from the drop down menu. You can select all primary fields or specific fields to export.


5

This sounded like a useful feature, so I added Age tokens to Eileen's CiviTokens extension, which seems to be the most widely used extension of its kind. Until a new release comes out, you'll have to pull from the master branch of the git repo.


5

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/Contact/BAO/Contact.php#L2677-L2684 if ($contact->birth_date) { $birthDate = CRM_Utils_Date::customFormat($contact->birth_date, '%Y%m%d'); ...


5

Option 3 is the clear winner, because neither option 1 nor option 2 have a clear way of indicating which organization they're the primary contact of. As soon as someone is affiliated with two organizations, that means trouble. The unfortunate part of this is that you can't assign a profile via a relationship. You can do so via Webform-CiviCRM, or via ...


4

It is little difficult to provide sql for contact export as it is has many tables joins. The basic query to fetch all primary details is pasted below. The output may not be same as what you get in exported file because some of the options are converted from value to label using php and also the query is not joined with the custom data table as the table name ...


4

I purchased the extension, and can confirm that it work with latest release of civiCRM.


4

As people have pointed out there is a very comprehensive answer to the question of anonymising data, however this questions was about simply clearing data. The correct answer from Pete and Demerit was that I had missed the sort_name column from the civicrm_contact table. So the full SQL is now:- delete from civicrm_email; delete from civicrm_address; ...


3

You can use Menu token module and Civicrm token module to create link in drupal module. civicrm/contact/view?cid=[civi:contact_ID]&reset=1 Thanks Pradeep


3

This can be done via the search function, doing a search for the e-mail domain will yield all contact results matching that domain, which you can then bulk select and from the Actions menu add a relationship to an organisation.


3

In general there is a risk of having a CMS user deleted when the CRM contact is deleted, since the CMS user can (in theory) be the author of pages, comments etc Therefore Civicrm does not offer this directly and I think you would need to find/make a customisation/extension or see if there is a tool in WP that you could use that would make it easy to find ...


3

There is a patch to support the character encoding necessary: https://lab.civicrm.org/dev/core/issues/339. The issue is whether to support older character sets for folks who can't/won't switch over. One position is that it's not a big ask for users to upgrade, but difficult for the developers to support both; the other position is that it forces an update ...


3

We had a similar problem importing from an old (non CiviCRM system) and I wanted to make the old membership numbers the Contact ids on the new CiviCRM system. Fortunately membership numbers 1 & 2 were not in use so no clash with the initial admin and organisation contact records. There were some gaps in the old membership numbers and I was also quite ...


3

You should always use the API and only if there is no other route grab the SQL table. You do not need to connect to any CiviCRM database when using the API. You can find more information on the API in the Developer Guide: https://docs.civicrm.org/dev/en/latest/api/ Do I understand correctly that you want to send data to your other application when a ...


3

You could use inbound email processing to activities and then a smart group based on that activity in the last 3 months.


3

You can turn it off totally if you need although you probably want to tweak the rules as Pete has highlighted. If you did want to turn it off you can get to display settings and turn off the display (by setting to never) of possible matching contacts.


2

During installation the CiviCRM are generated from xml files, and those will not always correspond 1-1 with the tables AFAIK. You can find the xm definitions in the civicrm folder: civicrm/xml/schema. Alternative is to use the API Explorer (Support/API Explorer in your CiviCRM menu) and do a getfields action for the entity? I would recommend using the API ...


2

Also, depends on your setup, but if the message is going external, then the img src url would need to refer to an externally web hosted image file. Apologies if I'm stating the obvious.


2

The Contact Layout Editor extension, first released in 2018, allows you to do quite a bit of hiding and rearranging on the Contact Summary screen.


2

you can get both Phone and Mobile in a single API call as below $result = civicrm_api3('Phone', 'get', [ 'sequential' => 1, 'contact_id' => 203, 'phone_type_id' => ['IN' => ["Phone", "Mobile"]], ]); I have created the test example against https://dmaster.demo.civicrm.org I guess this helps !!! Thanks


2

Mostly when working with complex form requirements in Drupal, folk are opting to use webform_civicrm as the flexibility it provides opens up many new options. For example in your case you could use Webform Conditionals to determine which fields show based on the choice of Membership Type (or type an existing user has if they are logged in or using a ...


2

I was able to figure this out using the following code: $getSessionArray = CRM_Core_Session::singleton()->get('CRM_Utils_Recent'); $thisContactID = $getSessionArray[0]['id'];


2

Welcome to civicrm stackexchange. Couple of options here. One option is to split your file into smaller chunks. If you have the ability to alter the php settings on the server you can change these to increase the time over which the import can run the option you probably want to look at is max_execution_time - in your php ini file. Depending on your ...


2

The 10 years old solution seems to be the best one, have you tried and would it be possible to remove the view all contacts permission to your users that should only use the reports? Otherwise, it shouldn't be too complicated to alter the UI and remove the send email actions on a custom extension, but that would require some coding


2

My experience is that 'Employer' field does get populated after adding the relationship directly. However the Job Title field is not related to the relationship and that wouldn't get populated, as it's a field on the contact record only.


2

In case you only want to allow one primary contact at maximum you can go for a contact reference field within the organisation. The drawback would be, that you will not be able the view that information coming from the side of the employee.


2

We use the Form Processor at a few of our clients for scenario' s like yours. In most cases we use this in a configuration with CiviCRM on another server and outside traffic (including the Form Processor API request) coming in through CiviProxy (https://docs.civicrm.org/civiproxy/en/latest/). For this we use the CiviMRF framework (https://github.com/...


2

Afaik, there is connection between the "Current Employer" field and the "Job Title" field. If you select a contact in the "Current Employer" Field it will also create a relationship AND disable an existing "employer relationship" which is marked as "current employer". If you create a "employer relationship" you will have a little checkbox that says "...


2

You have to have this permission (access CiviCRM backend and API) for anyone to access anything CiviCRM related, it's the minimum permission required for anyone to do anything. You can have a look at some information regarding this here - https://lab.civicrm.org/dev/drupal/issues/45 There are a lot of other pages that say similar things as well, it sounds ...


2

You can use find contact search or Advance search or find membership search. Perform search and then select the contact you want to export and from task drop down select export, and select 'Export PRIMARY fields' or 'Select fields for export' if you don't want all fields. Ref: https://docs.civicrm.org/user/en/4.6/common-workflows/exporting-your-contacts/


Only top voted, non community-wiki answers of a minimum length are eligible