Does the webserver support compression? Might be a disabled module (e.g. mod_gzip in apache). The Accept-Encoding suggests only compressed data is accepted.


Not allowed to view the pages after upgrade

Just had the same problem, but found the answer on this page:

WordPress - Problems trying to go back to CiviCRM 4.7.17 from 4.7.19

I had previously installed CiviCRM but wanted to remove it and start from scratch, but I hadn't deleted the civicrm folder in /wp-content/uploads/


CIVI mail - URLs inserted directly into an email template do not direct the user to the correct web page

I have a workaround if you make sure that the URL is not tagged as such then if comes through in the email ok and unchanged, this does not solve the issue if you want to mask the url and provide text to describe the link


Civicrm Unrecognized option in recordGeneratedLetters

I fixed it myself. Navigated to Administer->System Settings->Misc & set "Record generated letters" to "Do not record" from the drop-down.


Pay later for Membership - How does the membership get entered?

The membership is created when the payment is (manually) entered.


Error on CiviCRM Activation. Can't Install CiviCRM

Same happened to me. On installing new test CiviCRM under WordPress. The "CiviCRM Contribution Page Widget" plugin caused same error. Civi 5.27.1, WP 5.4.2,  php 7.2.24 on ubuntu 20.04 LTS


"Error: Please set the API URL" when buying a Free Membership

UPDATE Aug19/2015: The fix is included in 4.6.7

This bug as reported at https://issues.civicrm.org/jira/browse/CRM-14536 seems to be fixed and in QA - if folks can test and report finding that would be great.

The fix is available at: https://github.com/civicrm/civicrm-core/pull/6441

Patch: https://patch-diff.githubusercontent.com/raw/civicrm/civicrm-core/pull/6441.patch

How to do a patch?


This is possible using Update contact using profile. Below are the step to achieve this

Create a Profile with Contact Sub-type field.

Do Contact Search and select contact(s) you want to update and select 'Update multiple contacts' from Actions dropdown.

You will be redirected to Profile selection page. Select the profile you had created at #1 from 'select profile' dropdown and click on continue.

You will be redirected to a page where you wii see fields against each contact. Select the contact subtype for each contact and then click on Update Contacts. You can also click on Copy image (besides column title) to copy the content of 1st field into rest of fields beneath it.

HTH

Pradeep


Changing Display Path to /civicrm on frontend

Welcome to CiviCRM Stackexchange. Ofcourse you change the path to point to your own alias.

You will need to create a blank page in wordpress with member url or update the url alias of default CiviCRM page.

Make sure you use the same alias to define 'WordPress Base Page' in CiviCRM CMS integration(CiviCRM >> Administer >> System Settings >> CMS Database Integration)

Thanks

Pradeep


CiviMail pull-downs not displaying correctly

I suggest you start by going through the steps for troubleshooting javascript in CiviCRM.


We go to the Contribution > Edit Contribution, change Contribution Status to Refunded. It is one of the drop-down options for Contribution Status.


After upgrading to 4.6.7 Civimail fails to send mail

As Francesc pointed out, the symptoms sounds very similar to a contemporaneous question -- Why unexpected attached files are loaded in all mailings by default?

That was patched with https://github.com/civicrm/civicrm-core/pull/6644 and released as part of 4.6.9.


Send metadata to stripe payment processor

You could start a feature request on the Stripe-CiviCRM project page on Github, and ask for guidance there.


My first thought is that maybe your members are jumping straight to paypal-ing your email address rather than going through a civicrm contribution page such that civi could record the interaction. Cuuld that be the issue?

If that isn't it, perhaps you can provide more details as to your setup. What kind of page are your members using? What version of CiviCRM are you using? Are you on Drupal, or Wordpress? Tell us everything you can that might be relevant about your setup and hopefully someone can give you a hand.


After upgrade to 4.7.23., icons do not show (Civicrm on WordPress) (SOLVED)

Following my comment - You need to provide existing path in the resource url and directories page. Click the help icon to see the values of diferent global variables that you can make use of(civicrm.files, etc).

You can override these values in civicrm.setting.php file according to your paths. More info at https://civicrm.stackexchange.com/a/19498/245


You have the value ‘1’ in the minimum amount field of the price set that you are using.

Visit the settings section of the price that’s being used and remove this value. It’s not mandatory.


The answer is bug, but not for the reasons I thought.

In short: the addition of MagicMerge seems to be the culprit, resulting in changed behavior when geocodeMethod is set to NULL.

Long answer:

First, setting the property of a singleton in one function, does result in it persisting even in other functions. The singleton really does act like a global variable. That's how this has worked all the way up to 4.7.

However, in 4.7 MagicMerge was introduced to streamline the configuration object.

This approach added __get and __set functions to handle properties that are not defined.

Now, if a property (like geocodeMethod) is set, it is added to the cache ($this->cache[$name] = $v;). So far so good.

However, when it is retrieved, it only comes from the cache if it is set:

if (isset($this->cache[$k])) {
  return $this->cache[$k];
}

Oops. If we set it to NULL it will never be retrieved from the cache and will always be retrieved using the function CRM_Utils_Geocode::getProviderClass


Prefill webform with civicrm activity data

Below please find some screenshots to illustrate how to do this:

1. This is a View of Activities. Each Activity has an Update button [that's a Global: Custom Text field -> Text Update; Rewrite results: Output this field as a link -> to the webform URL with case-worker-form?cid2=[contact_id]&aid=[id] and bootstrap classes btn to make it a button] -> the URL that is constructed is case-worker-form?cid2=41218&aid=19153

2. The webform case-worker-form -> receives this data. That form is set up such that cid1 = the logged in user (the social worker); cid2 = the client; aid = activity id of the activity to be updated;

3. Let's edit the subject e.g. ->

4. Result:

5. Note the Webform just has Update Existing Activity set to None (as we're matching by aid)

Add on:
I've double checked that this is (still) working on our latest webform civicrm 5.x

root@f4d0afb6c36d:/var/www/html/sites/default/modules/webform_civicrm# git log
commit 76b444bf5192ddf4663a0222540684a230d8e39e
Merge: b54ddfd ef2a518
Author: Karin Gerritsen <KarinG>
Date:   Thu Sep 12 11:24:26 2019 -0600
    Merge pull request #251 from colemanw/rel7
    Use api to retrieve relationship data

Add - on config notes:

ensure your views field is configured such that commas are stripped from cid and aid before passing them into the webform
ensure your webform is configured to allow an activity of the type you want updated -> setting it to -user select- will ensure that


Add Custom Fields to Contact Details data

You create custom fields in custom field sets.  You have the choice of them being displayed inline or tabs, and as initially collapsed or open, but beyond that, you have little control over where they are displayed on the contact summary.

However, with a bit of jQuery they can be moved around.  For an example (although not custom fields) see https://civicrm.org/extensions/group2summary


Issue with permissioned access using state address field

Could it be that the contact is not added to the smart group immediatly? Also a smart group is rebuild in the background with a scheduled job.

The smart group cache timeout is configurable: see http://book.civicrm.org/user/current/organising-your-data/smart-groups under "Smart group caching".


Thanks for taking the time describing the problem.

As it seems to be a bug rather than a question, i think you should create a new issue in the issue tracker rather than using Stack Exchange.


Drupal Webforms: Can I use the Conditions to control how the contacts are filtered?

We ran into the same issue and didn't want to customise the webform module as it is heavily relied on for a lot of data input and needs to be kept secure and easy to maintain.

So we built a Drupal view displaying the Volunteers based on their relationship to the Staff member (I'm assuming they are related in CiviCRM). When the Staff Member visits the page, it can restricted to show only those the have an active relationship to using a contextual filter to the Drupal User.

This post should help if you've not done this before: How to create a Drupal View with multiple CiviCRM relationships?

We then created a link (using the views Global Text field) to the webform to prepopulate the Volutneer as cid2 or contact 2 (assuming the staff member is cid1) which looks something like this:
myorganization.org/node/1?cid2=[id] where [id] is the id of the volunteer.


Indeed, I am not seeing the "Thank you date" field as an option to be included in the built in reports, but you could do a find on contributions - if you export the primary fields, the thank you date ends up around column CC (might depend on what version of Civi you are using), or you can and select the relevant fields for export, the thank you date being one of them.

Hope this helps,
Tamar


CiviCRM Membership form Renewal text not displaying

It should appear if the user is logged in or is using a checksum and has a Membership status which can be renewed, eg New, Current, Grace


How to suppress columns from Manage Group search results

I just learned how to use bVisible = false to suppress columns. I found what I needed at http://legacy.datatables.net/usage/columns, the columns documentation for datatable plugin.


How do I permanently disable the "Similar Contacts Found" pop up?

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.


CiviSEPA turns special characters of generated XML files into ASCII characters or question marks

I do recall having read the specification for sepa (don't judge me, I had to) that says:

the xml file is utf8 encoded
but can only contain ascii-7 characters

Did you try to upload the xml to your bank? I suppose they offer a test mode, you might want to try to check how it looks there


The issue is almost certainly that the "County" field is not enabled by default, which suppresses it in the import dialog.

Go to Administer menu > Localization > Address Settings, and under "Address Editing", see if the "County" box is checked.  If not, check it.  Restart your import and the field should appear.

I also confirmed your report that County appears even if disabled as a field for related contacts.  That's a bug, though a very low priority one!


Problem with CiviCRM registering a new Wordpress user

It might sound obvious, but I'll admit getting caught by this on one occasion because I didn't test as an anonymous user!


It depends what you mean by "all records", but the custom search called full-text search (under Search - Custom Searches) can be made to run via url like so:

https://dmaster.demo.civicrm.org/civicrm/contact/search/custom?csid=15&text=894-1515&table=Contact&force=1&reset=1

That will bring up the contact with phone 894-1515.

If you want to include activities and such, then leave out the "table=Contact" part.


This is more of a Drupal answer than a CiviCRM answer, but I believe you can use Node Clone to copy/duplicate webforms.

  The clone module allows users to make a copy of an existing item of site content (a node) and then edit that copy. The authorship is set to the current user, the menu and url aliases are reset, and the words "Clone of" are inserted into the title to remind you that you are not editing the original content.


Upgrade to version 5.37 - Database error

Run below command before running the upgrade
ALTER TABLE civicrm_group ROW_FORMAT=DYNAMIC;

Include the below config in mysql config file
innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=true


Show Activity Source Contact in a Drupal View

Look at using the 'relationships' feature in drupal views (on right under Advanced) which should allow to add the Activity Contact, specify that you want to filter it to 'Source' and then add a Display Name field and use that Relationship


Wordpress CiviCRM groups, members and permissions

I can answer some of these questions:

CiviCRM doesn't store usernames/passwords on its own.  It integrates with the Wordpress authentication system
You create user roles in Wordpress' User Role Editor.  You can then go into CiviCRM and grant CiviCRM permissions based on Wordpress role.
Because you say you want users to "upload via the frontend" and mention that they have logins - I assume you mean that these are users who have permissioned access to Wordpress, but not CiviCRM.

With CiviCRM, you should:

Enable a user dashboard (to allow contacts to edit their own contacts);
Create a search profile (to enable members to search for other members);
Create ACLs (to allow you to restrict access to contacts based on their committee membership);
Create several document submission profiles, to allow folks to submit/search documents that they're supposed to be able to see.  I imagine I'd create a CiviCRM contact for each committee, then create a profile submission form that allows permissioned users to add activities with attachments to that user.

I could also see a different approach where the documents are stored in Wordpress and permissioned that way, but I don't know enough about Wordpress to know if that's feasible.  I'm thinking of a feature similar to Drupal's Organic Groups.


To this very old but unanswered question, I'll answer that there's now an extension that does exactly what you're asking: Clone Contribution. Quoting from the description:

  This extension provides:

  UI controls to clone a particular contribution, wherever contributions are listed (e.g., a contact's Contributions tab;
  contributions search results).
  Options to omit certain contribution properties from the cloning process (i.e., properties that will not be copied from the source
  contribution to the new contribution).
  An API Contribution.clone for cloning any number of contributions.

  During the cloning process, the following contribution properties can
  be changed so that they're immediately different in the new
  contribution:

  Contribution Status

I'm the developer on this extension.


Replace default Datatables script to most recent [custom buit] one

OK, answering my own question again. So, there are essentially 2 ways to achieve this:

Override  \civicrm\CRM\Core\Resources.php (copy it to your custom php directory first, in order to keep control on changes). It contains (quote) List of core resources we add to every CiviCRM page.
Use hook_civicrm_coreResourceList(&$list, $region) {}

(!! Attention: methods of adding 3rd-party resources, described at that page doesn't always work; we've ended up using drupal_add_js. Datatable initialization script has to be wrapped into drupal.behaviors than).


Export full state name - not abbreviation

The more general issue about state has come up before, e.g. https://lab.civicrm.org/dev/core/-/issues/724 and https://lab.civicrm.org/dev/core/-/issues/1709.
It's not a full solution but you can manually update the abbreviations in the database in the civicrm_state_province table, but you'd have to change the column size in the table definition, and someday an upgrade might wipe out your changes, although unlikely.


Issue getting Email for Bounce Processing

The issue is likely at the server networking level.  If you have access to that server (via SSH or similar), I would try installing the swaks utility to troubleshoot.

swaks might even be premature though.  I would start by ensuring that your server's firewall isn't blocking outgoing access on port 993 and that imap.gmail.com is resolving in DNS.


Upgrade from 4.2.7 to 4.7.13 fails during DB 4.4alpha1 update Joomla

I see where the problem is happening and I have a solution, but from the CSV you're sharing, I can't see why the problem is happening.

Next time, before upgrading, go to your CiviCRM root and then open CRM/Upgrade/Incremental/php/FourFour.php.  Around line 543 will be a function called activityContacts().  CiviCRM changes how activity contacts are stored in version 4.4+, and this function is meant to facilitate that.

The first several lines are meant to look up the option value records labeled "Activity Source", "Activity Assignees" and "Activity Targets" and set them to be "reserved", so they can't be changed.  Based on the SQL in your error, it's not finding "Activity Assignees" - but I don't understand why, your CSV looks fine.

Regardless - you can fix this by ignoring the lookups and manually change the SQL query to use the values that I can see in your CSV file.

Change these lines:

    $query = "
UPDATE civicrm_option_value
SET    is_reserved = 1
WHERE  option_group_id = {$optionGroupID} AND value IN ($ovValues)";

to this:

    $query = "
UPDATE civicrm_option_value
SET    is_reserved = 1
WHERE  option_group_id = {$optionGroupID} AND value IN (1, 2, 3)";

Re-run the upgrade and you should get past that error.


Mailchimp Extension - Webhook URL can't be verified

Check whether 'allow webhook posts' permission is granted to anonymous role (go to CiviCRM's Administer menu » Users and Permissions » Permissions (Access Control), then click on WordPress Access Control).


Cannot access Group admin - missing API key

After putting site into maintenance mode, enabling Debugging and Error handling, it became clear that this was related to the Mailchimp extension. I have disabled the extension and will reconfigure. Manage Groups now fine.
Apologies for wasting anyone's time.


Why isn't our Profile displaying on our Joomla webpage?

This has kind of been stated before, but you need to make sure that what you are exposing to Joomla is viewable by all unless you are requiring people to log in first before they can see the content (such as with a members area). You may want to elaborate on what your end goal is, because a profile search may require higher permissions than a profile view. If you are looking for just a general directory listing, you may not need a search.


Interested in setting up capacity for receiving recurring donations

Civi works with a number of payment processors, some of which do recurring payments.

I think the best list of which do what is here: https://wiki.civicrm.org/confluence/display/CRMDOC/Payment+Processors


Deleted duplicate contact, when try to make login still says the email address is already registered ((Drupal 7.53, CiviCRM 4.6.24)

When you check availability, it's actually not looking at CiviCRM - it's looking in Drupal.  If you're a coder, you can read the code here.  Based on this, it seems like you need to delete the Drupal user, not the CiviCRM contact.

To fix:

Go to CiviCRM menu » Hide menu to view the Drupal menu (see screenshot).

Your Drupal menu may vary based on the installed extension, but you'll likely have a "People" menu:

From here, you can delete the Drupal user.  Instructions can be found here.

Note that if you create a new Drupal contact with the same email address as a CiviCRM contact's primary contact, the link between the two will be regenerated!  So you should never have to delete the CiviCRM contact in this instance.


On Siteground I use the wp-cli method as I find that more reliable:

/usr/bin/wp --user=USERNAME --url=https://EXAMPLE.ORG --path=/home/CPUSER/public_html --timezone="PHPTZ" civicrm api job.execute auth=0

replace CPUSER with the cpanel username , USERNAME with your WP Username, make sure the url is your site's canonical url and set the php timezone (eg America/New_York)

you may have to login via ssh and do a which -a wp to dtermine the path to the wp-cli script.  It's always been /usr/bin/wp for me, but I would double check


CiviRules - cannot assign a tag inside a tag tree

I can imagine that it is a pain. Can you please add this issue to the CiviRules repository at https://github.com/CiviCooP/org.civicoop.civirules/issues?

Are you able to solve this yourself (do you have PHP skills)? There is documentation on how to add your own condition here: https://docs.civicrm.org/civirules/en/latest/create-your-own-condition/. Fixing one will follow the same pattern.

If not, the usual community thing comes up:

if the problem is big for you, it might be worth hiring someone familiar with CiviRules to fix it for you
if the problem is not big for you wait until it is important to someone else and it is fixed


Is 4.7.x end-of-life? Why does my site say that 4.7 has reached the end-of-life?

There is a helpful explanation.  The numbering system changed, this is detailed here

5.0.0 is the next version after 4.7.31 and is not a major update.

In The Q&A section there is an answer to this question which explains why the limitations of the update messaging system in 4.7 led to the decision to use the End of Life message in this instance:

  The in-app messaging in 4.7.x was hard-coded several years ago. For a site running the last 4.7.31, we can only display one of two messages -- either that 4.7.31 is up-to-date or that it 4.7 is end-of-life. Neither message is accurate or desireable -- the truth is that 4.7.x was renamed to 5.x.

  We've updated the notification system so that future messages can be
  more nuanced/accurate, but for sites currently 4.7 we've had to take
  an awkward approach. For April and May, we used the understated
  message; but in June, we switched to the overstated message.


Registration - Thank you page Error - Call to undefined method -Joomla

At administer - system settings - directories, there's one called custom php path that contains a folder path. Go look in that path in the filesystem and you probably have a customized version of CRM/Core/BAO/UFGroup.php. It will need to be updated with some recent changes that were made to the real CRM/Core/BAO/UFGroup.php, in particular the addition of the function getFrontEndTitle().


Award Drupal User points after contribution

To make this work I’m pretty sure you’ll need CiviCRM Entity module. We’ve used that to create Drupal accounts after/when a Contact purchases a Membership.


Mailchimp extension compatibility with CiviCRM 4.7

In general, extensions marked as compatible with 4.6 will usually work with 4.7 as well. It may be that the extension author just hasn't had a chance to test it and tag a new release for 4.7. I recommend you:

Install the extension and try it out
Notice if it works correctly or not. Gather specific details of anything that may be amiss.
File an issue on the extension's github page noting your findings so that the maintainer can either fix the bugs or else tag a release as-is for 4.7.


Why do these characters - Â Ã Â - that were not added appear on Event registration pages created using CKEditor?

That type of thing is normally character encoding problems. The first thing I'd check is what the character encoding on your database tables are, e.g.

SHOW CREATE TABLE civicrm_event;

If it says charset=latin1 or anything instead of utf-8 at the bottom then I'd guess that's your problem. You can see here for ways to fix it: https://stackoverflow.com/questions/2150256/how-to-change-all-the-tables-in-my-database-to-utf8-character-set

Edit: To save anyone reading all the comments, in this particular case it has something to do with ckeditor and character encoding. Workaround is use a different browser like firefox.


Here is an extension that automatically creates a soft credit. I use it with my org and it works great. I'm running 4.7.2 with drupal 7.

https://github.com/PalanteJon/coop.palantetech.module.automaticsoftcredit


Drupal civicrm Contribution Form code into Drupal page content?

Yes, you can install the Webform-CiviCRM module, and this allows you to embed contribution fields in a webform (which is a drupal content type).


And just as I posted that, I found the answer on my own - it is not called Shoreditch in the extension listing. It is called "CiviCRM Bootstrap theme". So I'm keeping the question here and adding the answer for anyone who gets stuck like I did looking for the wrong name.


Yes, You can use the same db of drupal as well as use the separate db, civicrm gives the option to add another db.
If you want to use another db for civicrm then you have to create the db first and enter the name at time of installation , If you are first time installing civicrm use this doc .Civicrm use civicrm.settings.php to use the database connection,you can also check out that.
And as you said you have multisite installation you can placed the civicrm at /sites/all/modules to be accessible to all your drupal sites


Thanks. Please open an issue on http://issues.civicrm.org/
There you can also add a diff file to an issue.

If you're really hardcore you can fork https://github.com/civicrm/civicrm-core, add your changes to the git project and do a pull request.


What determines the suite of Case Roles presented for assignment on the CIVICRM Webform Case Tab?

Come to find out that the role not being available to map was because the relationship name and label in the database did not match (i.e. name_b_a was "Third cousin once removed" but the label_b_a was "Distant cousin").  It seems like when the relationships were originally created we had the ability to set a different name and label - we're guessing this was in an earlier version of CiviCRM as currently the only thing you can add/edit directly in CIvi is the label.

Once the name field was revised to match the label, the role was available for selection in the Cases > case roles section.


Issues with Personal Contribution Pages / Events / Joomla

So thanks to Brian at ICD who helped troubleshoot this - somehow the PCP that was set up for the event was done in a way that while it was a contribution page - it was pointing to the event ID -
This required some updating of the event PCP to point to the correct contribution page instead of the event. I am not sure how it happened - but it is fixed - I check on new event to see if I can select the appropriate contribution page and I can -


Replacing the Contact Dashboard with Views

I think the Views block shared here may be a step in the right direction.


I'm sorry to say that you'll have to revert back to the default 'wp-content' folder name in order to use CiviCRM. I can find at least 5 places in CiviCRM core where this is hard-coded.


Drush error: "Command ... needs the following module(s) enabled to run: civicrm"

For some reason the Drush cache is not up to date (for example, if you've recently upgraded CiviCRM). If you clear the Drush cache as follows, the command should work as expected:

> drush cc drush


It turns out this is actually to do with the base page url - it should not have a trailing slash. @massetto knows this I think, because he created the GitHub issue where this is explained so this answer is really for anyone else looking at this later.
From Matt Wire of Veda:

Check your CiviCRM paths/resource URLs and make sure that you are not overriding them if you don't need to.
In CiviCRM make sure that "Wordpress Base Page" is setup as "civicrm" with no "/" - see civicrm/civicrm-core#18332 so this will be fixed in 5.29.
In Wordpress make sure you have a CiviCRM base page (should be at https://yoursite.com/civicrm).
Important: Go to Settings -> Permalinks and click "Save Changes".
Now Mosaico images should work and navigating to https://yoursite.com/civicrm/mosaico/img should give a 200 OK and a blank page.

v5.29 is available now, so sounds like upgrading to that should resolve the problem.


How can add URL to dropdown items for a profile page

profiles are simply a way to build forms so only a subset of all the gazillion fields that civi have are exposed to the end user.

so the initial question is what is that supporter field you want to add? It has to be already created in civi before you can use it.

that notion of supporter doesn't exist in civi by default, so either you are using an existing field and slightly changing it's meaning, or you need to first create a custom field 'supporter' so it's exactly what you want.

if by link you mean letting the end user putting their website, there is a core field for that- website, that you can simply add to the form


Is there a bug when placing a token inside quotation marks in CiviMail 4.6.2+?

in CiviCRM 4.6.2 you can patch this issue with the following edit:

--- a/a/civicrm-core/CRM/Mailing/BAO/Mailing.php
+++ b/b/civicrm-core/CRM/Mailing/BAO/Mailing.php
@@ -1472,7 +1472,7 @@ ORDER BY   civicrm_email.is_bulkmail DESC
       if ($this->url_tracking) {
         $data = CRM_Mailing_BAO_TrackableURL::getTrackerURL($token, $this->id, $event_queue_id);
         if (!empty($html)) {
-          $data = htmlentities($data);
+          $data = htmlentities($data, ENT_NOQUOTES);
         }
       }
       else {


CiviCRM is not yet compatible with Joomla 3.8. See here. As you will see, there is a patch. The patch resolved all the issues I was aware of, but is not yet approved.


'DB Error: no such field' for all (free) event registrations

Fixed by upgrading to Civi 5.23

However this may also be relevant: SOLVED CiviMobile: DB Error in adding a Participant to an Event


Update user Tags direct from civiMail link

One approach is to create a custom field with check boxes for the subjects you wish to gather info on. Then create a profile that includes the custom field and any other info you might want to have them provide. Then use a link with a checksum token to this profile for editing in the email.

Hope this helps.


CiviCRM Entity, Display tags name in contact

I need to add an option "Tag ID" in the Host Source Column field setting of the CiviCRM Entity Reference module to make this work.

It won't take much to add it.
Look in your code to the matching file, add:

'tag_id' => 'Tag ID (Entity Tag)',

https://github.com/eileenmcnaughton/civicrm_entity/blob/7.x-2.x/modules/civicrm_entity_reference_field/civicrm_entity_reference_field.module#L148

Then you can add another CiviCRM Entity Reference Field to the Entity tag entity type:
admin/structure/civicrm-entity/civicrm_entity_tag/fields
Target Entity: Tag
Target ID: Tag ID
Host source column: Tag ID (Entity Tag)

Set this field to render in a view mode on the entity tag manage display area:

admin/structure/civicrm-entity/civicrm_entity_tag/display

This will render the tag entity, you can configure which fields of the tag entity show by configuring a view mode and configuring to use it on the render

admin/structure/civicrm-entity/civicrm_tag/display

Now back at your Contact, make sure and render the view mode of Entity Tag, that renders the right view mode of the Tag entity, and you'll be rocking.

I will add a PR to CiviCRM Entity to add the one line of code necessary to make it work out of the box, but it may be a couple weeks before the next release goes out.


With upgrade to 4.7.17, I get "invalid price fields" warning

Found a hacky solution.  In phpmyadmin, in the civicrm_price_set table, I changed the "is_reserved" field from 1 to 0.  At that point, the price field could be deleted in the UI, and all seems to be well.


Ok so this may seem like a silly issue to some but after some messing around I figured out cron didn't have access to the path where CV was installed so to fix it the crontab entry had to be changed to:

*/5 * * * * /usr/local/bin/cv api job.execute --user=admin --cwd=/var/www/html/siteroot

There was no error as the mailer deamon was not firing correctly so no error was being sent or logged.

Cron does not generally have access to the path that a shell root user does, which is why running the command cv as root works just fine.


Is there a way to make all Mosaico blocks the same width?

Mosaico template 1.19 solves the problem with transparent background for the Logo block at the top.  Thanks


I need an online registration that contains multiple venues for an event

Making a lot of assumptions here ... you could have a single event configured without enabling the location.  Then use a priceset with each item in the priceset matching a location - set it to required.

e.g.
"Select a Location"
Canberra - $75
Melbourne - $75
Darwin - $75

You'll end up with a master list of all registrants, getting a list of registrants by location requires a price set report, either custom or in the Extended Reports extension.


endless spinner when selecting event location

This got solved on our site on CiviCRM 5.3.1 and Joomla 3.8.10 by creating and entering a Google Geocoding API key


Mattermost is open source messaging software - see https://www.mattermost.org/

References to Mattermost within this CiviCRM StackExchange site generally refer to CiviCRM's online community chat system that uses the Mattermost software and is one of the various support resources for CiviCRM.

StackExchange uses a Question and Answer format which works well for many things but sometimes an interactive chat format is more appropriate.

You can access it at https://chat.civicrm.org/  Follow the links to create an account.

It is organised into various public and private channels.  Take note of the description of each channel and post your question in the most relevant one.
If you're unsure which channel to use, try 'Town Square' or 'User Support'.
Just ask your question. Don't ask if it's ok to ask.
Choose the most appropriate channel and ask.  Don't post the same question in multiple channels.
It is possible to send "Direct Messages" to other users but don't use them, unless you know the person and you are sure they are the only one that can reply.
Be nice!  It is a community of fellow CiviCRM users who are often very helpful, but do remember no-one is obliged to help you.


Can i print or save a pdf of all activities

if there isn't an easy solution in CiviCRM, and if you are on Drupal, then I would recommend doing it with the Views module and the Print module which lets you generate PDFs from Views. Happy to provide more detail if that route is useful for you.


How To View Documents Uploaded Through Custom Profile

we did have some issue with uploading files to custom field since 4.6.5 and above

I did made a quick test against http://wp46.demo.civicrm.org which is running on civicrm version 4.6.18

And the issue got fixed so please try to upgrade to the latest version and then please test the same

thanks


civix civicrm:ping error [Exception] Failed to locate civicrm.settings.php

Cool - in the drupal site root of the site  you should see a folder "sites" and be able to see a file at sites/default/civicrm.settings.php  can you try running the command from the same directory as the civicrm.settings.php file.


Misleading instructions in CiviEvent registration template for multiple participants

This is a great catch Bryan.  The wording changed in CiviCRM 5.25 (May 2020), but they missed this.  I just opened a ticket and wrote a patch to address this.  The fix is in Civi 5.29+ (September 2020).  Thanks again not just for noticing, but for reporting this.


Relationship shows up on contact page but is undefined in reports, searches, and exports

I realized what the issue was.  You must be very careful in defining the relationships - A to B vs B to A.  I had different relationships defined for B to A when the A to B and B to A were the same.  For example: if you have Employer and Employee defined, you don't need to define a separate relationship for Employee to Employer -- the system handles which one is A and which one is B.


Access Instant Messaging in Drupal Views

I added the feature in CiviCRM,
https://issues.civicrm.org/jira/browse/CRM-19274


Add contacts to group using CSV with contact e-mails

You have to select an appropiate Dedupe Rule so that the importer can detect by which criteria you want to treat an existing contact and a imported contact as the same.

Using the predefined Email - Unsupervised Rule should work for this purpose.

If you chose the same location as is defined for the contact email it will just update the existing contact.

However, the option to select the primary e-mail does not seem to be working as expected. It will create a new adress without setting a proper location.

You may want to report this as a bug.


Can't send individual emails from contact record

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()->set('simple_mail_limit', 50);"


Participant quantity passed to Additional Participant pages

I don't know if this can answer your question, but :

If you are based upon Drupal and use Webform Integration, you can, in a webform, register several participants and build conditionnals between any fields of the webform, thus set any field value (e.g. Price) depending upon any other fields values (e.g. participant count).


Filter Mailing List report for unsent mails

Since this is a one time issue (now that you've resolved with MailChimp), I would use that CSV to 're-import' those intended recipients with an Unknown status. The CSV should have email address as a field, so you can use that to match up your contacts.  See Importing Data and Importing Data - CiviCRM Wiki for reference.

When you import the contacts, use the Update or Fill option for "For Duplicate Contacts" option (and they should all match if your dedupe rule uses email address). In one of the last steps of the import, you can add them to a new group. Use that group as the recipients for your re-sent mailing.


Report error: Bad menu record in database

Check after rebuilding the civicrm menu. You will get more details in your civicrm log file. Just enabled the debugging and logging from below link

site-name/civicrm/admin/setting/debug?reset=1

***/files/civicrm/ConfigAndLog


How is membership type best set up for monthly direct debit payments?

Since CiviCRM does not yet allow partial payments/payment plans for annual memberships, you'll have to create a membership type for each level and each payment schedule.

Using your example of levels of memberships, define your membership types as:

Annual membership for over 65 - amount: $1200
Monthly membership for over 65 - amount: $100 (require auto-renew)
Annual membership for under 16 - amount: $60
Monthly membership for under 16 - amount:  $5 (require auto-renew)


It sounds like you may not have a server cron job set up to trigger the Civi cron job.  Are your other Scheduled Jobs executing?

The documentation to reference is here: http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs


CiviMail - Unable to select group, getting error of No recipients

Because you update so frequently, it's easy to track down the potential issues.  I see two relevant changes to CiviMail's recipient list: CRM-20521 and (maybe) CRM-21070.

In non-technical terms: Prior to Civi 4.7.24, all the mailing groups were loaded onto the mailing form when you selected "New Mailing".  For sites with many groups, that made things slow.  In 4.7.24+, the list is loaded after the page is loaded, in a more efficient way.

First, look at the screenshot on CRM-21070: Does your "Recipients" box look like this?  If the box is present, but has no data, the issue is related to CRM-20521.

If this is caused by CRM-20521, then you have a JavaScript problem.  That could be a bug, but more likely means your Resource URLs are incorrect.  Please consult troubleshooting JavaScript in CiviCRM - in particular, check your browser's dev tools Network/XHR tab for errors - and you should find your solution.  If you find an error but you're not sure what to do, please edit this question with the errors you find.


Undefined index: start_time in CRM Volunteer BAO NeedSearch.php

Can you try to apply this PR https://github.com/civicrm/org.civicrm.volunteer/pull/513. I this it should fix the notice error.

Cheers

Pradeep


How to evaluate hosted CiviCrm enviroments

Much could be said on this (and probably will be!) but here's a few starters you might want to consider. What is "best" for you depends on which factors are important for you.

If you use a hosting environment that specifically supports CiviCRM then things like MySQL version, MySQL permissions, php version, php memory will be ok.  Otherwise, you need to check they meet CiviCRM's requirements which are fairly demanding.

Some hosters will upgrade Drupal & Civi for you.  On others, you manage your own upgrades.

Some provide Let's Encrypt automated free SSL certificates.

Some provide ssh access.  If so, do they provide drush, wget, git etc? (Does drush, wget or git matter to you?)

Personally I'd opt for a specialist CiviCRM hoster.  Avoid a hoster that doesn't explicitly mention CiviCRM.


Does iATS payment requires SEPA Direct debit for ACH to work?

We did build UK Direct Debit [with the mandate - the entire workflow] into the iATS Payments Extension but it wasn't used much and we have not actively supported it recently. And SEPA works well and is widely adopted by lots of European CiviCRM Clients. One does not need to be exclusive -> you can processing CC with iATS Payments and use SEPA for DD for the time being.


Check your CIVICRM_UF_BASEURL value in civicrm.settings.php and check also the settings under Administer --> System Settings --> Resource URLs.
In the latter you can force civicrm to load css/js via https.


Any reason why you cannot use a custom set that extends groups? This allows you to add various fields to civicrm_group which appear in the add/edit screen of all groups

You can select "Groups" in the "Used For" selection here:

http://d46.demo.civicrm.org/civicrm/admin/custom/group?action=add&reset=1


how would I send a monthly email automatically

You could use the CiviRules extension to accomplish this in combination with the Email API extension. Both extensions can be found in the extension directory.

In CiviRules the DailyGroupMembership trigger does what you want, it only does it on a daily basis rather than once a month. You might either come up with some CiviRule conditions to make it run only once a month or even better, adapt the DailyGroup trigger to allow a selection of day/week/month.

Some examples of CiviRules can be found here: https://wiki.civicrm.org/confluence/display/CRMDOC/CiviRules+Cookbook


How can I connect my website to CiviCRM on a remote server?

I am not even going to try and answer it all in one go :-) But I am happy to share the configuration that my customers with remote CiviCRM's use.

They all basically have a public website (Drupal 7 or 8 in most cases, Wordpress in some but in theory any CMS would do) on a server and a separate CiviCRM in a "dummy" Drupal 7 on another server. I use the word "dummy" because in this case Drupal 7 on this CiviCRM server really only is the operating system that makes CiviCRM run.

They all use CMRF on their public website to be able to connect to another server. CMRF is a framework that enables a website to connect to one or more CiviCRM instance(s). The core is CMS agnostic, and there are currently implementations for Drupal 7, Drupal 8 and Wordpress. If an organization would want to use another CMS they could develop a CMRF implementation for that specific CMS.

Almost all of our customers that work in that way use CiviProxy as a gatekeeper for their CiviCRM instance(s). CiviProxy is a a kind of policeman that checks if the request you want to send to the CiviCRM server is allowed. So the public website (or other webservices!) sends a request to CiviProxy, CiviProxy checks if the credentials are correct and if the request is allowed and if so, sends it to CiviCRM and returns the result. Documentation on CiviProxy: https://docs.civicrm.org/civiproxy/en/latest/

We use the Form Processor extension (https://civicrm.org/extensions/form-processor) to create webforms on the public website that communicate with CiviCRM. If the website is in Drupal 7, there is a module called CMRF Form Processor that makes it a little easier. Documentation on the Form Processor: https://docs.civicrm.org/formprocessor/en/latest/

We use the Data Processor extension (https://civicrm.org/extensions/data-processor) when we want to show data from CiviCRM on the public website.


Can't save Drupal role permissions for CiviCRM

Will permissions for non-civicrm related permissions "stick"? If not I've seen this problem before when there are too many roles/permissions on the form. Drupal commons installs a lot of modules, so its possible. You should either edit permissions for the roles individually, so for authenticated user for instance goto admin/people/permissions/2

I believe its the php.ini environmental variable max_input_vars and you should increase the number to get the full permissions form to work


What is the timeout period for links in Civimail? Can it be extended?

Yes the checksum lifespan is configurable at this path civicrm/admin/setting/misc?reset=1 which you get to via Admin > System Settings > Misc

Changing the duration will only affect future checksums. It will not affect ones that have already been set out.


How to use CiviCRM Webform to process CiviCRM fields at each step rather than on submit?

I've done this a couple of times now using a custom drupal module and hooks.  You can get data into civicrm using the api.


João: By design WordPress user capabilities are restricted to a single site because many Multisite instances treat sub-sites as entirely separate entities. So in order to achieve what you want, you'll have to:

explicitly propagate users and their capabilities to the sub-site(s)
propagate the Groups plugin sync to the sub-site(s)

Task 1 is fairly straightforward: you'd use the civi_wp_member_sync_add_cap hook to detect when a capability has been added to a user. First add the user to your sub-site(s) with add_user_to_blog(), then switch_to_blog() and add the capability to the user before switching back to the current site.

Task 2 is a little more tricky. The Groups plugin states that "All features are supported independently for each blog in multisite installations". As a result (as you've discovered) the CiviCRM WordPress Member Sync plugin only syncs capabilities to the Groups plugin on the main site. To propagate that sync to the sub-site, you'll need to use the family of civi_wp_member_sync_rule_*_capabilities hooks and sync the capabilities to the Groups plugin instance on the sub-site(s) yourself. If it makes life easier, I can add some do_action calls in the relevant places so that you can guarantee that your code will run when expected.


I forgot to post an answer before, but am prompted to do so as someone has a similar problem.

I needed to set directory 755 and files 644 for wp-content/plugins/civicrm/civicrm/packages/kcfinder because the WP distribution didn't set permissions that worked in my hosting environment.

But since CiviCRM 5.2.2 this wasn't necessary.


Can I search for contacts with activity added by specific person?

In Advanced Search and Activity Search you can filter by 'Added by'.

Also you can use Search Builder form and filter by 'Activity' with 'Source contact' = ...


Recurring contributions frequency label ("every month") is unstyleable - looks bad

You can add some css for the label tag that copies the style of the other text. Some margin or padding css on the link tag will take care of the spacing issue. As to the div.content, just be more specific on your selection so it only styles the labels you want to style. You should be able to select deeper than the div.content for those labels Or you might have to start your selection all the way up at the specific page to keep it from impacting the rest of the site.

There is no way around it, you might have to make adjustments in the future if your theme changes (just like you said).


Just go to http://localhost/drupal/civicrm/clearcache. This does a pretty thorough cache clear, including hooks.


Easy "add to Google Calendar" link in Event confirmation emails

Better late than never, I suppose! I wrote an extension that attaches ics files to event confirmations.

https://lab.civicrm.org/extensions/eventics/


Home page redirecting to event page on Wordpress

Create an empty Wordpress page, name it what you want, for example "civi".
Add that name to the "WordPress Base Page" in
Administer - System Settings - CMS Database Integration.

For more info see:
http://wiki.civicrm.org/confluence/display/CRMDOC/Displaying+Public+Forms+in+WordPress+Frontend+Sites

Does that work?


i think the current approach is via JIRA - you can see the existing list here

https://issues.civicrm.org/jira/browse/CRM-17652?filter=23012

If you add new ones label them drupal-8


Is there a URL that can open a contact search?

You can do this via full text search which gives you slightly different results than contact, but might meet your needs. If you are logged in to the demo server,check:

http://d45.demo.civicrm.org/civicrm/contact/search/custom?csid=15&reset=1&text=joe&table=Contact&force=1


Bookkeeping report that includes grouping by deposit and Line Item Totals

This is not an iATS Payments extension issue. Payment Processors like iATS Payments process the total amount - the details of how the total amount was arrived at - are within CiviCRM.

CiviCRM stores the line items in the the civicrm_line_item table it contains an entity reference to the civicrm_contribution table -> which has the trxn_id (Transaction ID).

So if you want to group by lineItems as opposed to by contributions you'll need to combine these two tables - and sum up the lineItems over a specific receive_date range (and/or for specific trxn_id-s).


Is there a way to connect the civisepa backend to the profiling in wordpress?

Welcome to CiviCRM Stack Exchange alicedd!

Afaik, CiviSEPA mandate information cannot easily be made available in Profiles. CiviSEPA can be made available as a payment processor on CiviCRM Contribution pages though. CiviSEPA would then create a mandate when someone uses the page

If you want to allow constituents updating a mandate you will need to create a custom form / function.


On multi-site CiviCRM, are mailings supposed to be separated per-domain?

This is a bug. Please log an issue on https://issues.civicrm.org.


System Status: Notice 5.1.0 After Upgrade

SOOOO, I am a total idiot forgot to run the upgrade URL.... yep so that happened.

Sorry all


How can I set custom field date field for default date to be today's date?

I am not sure if this is possible through UI configuration. The form only allows you to enter valid date but not now(), CURRENT_DATE() etc. However it is definitely possible by adding a small code in a extension.

Create and enable a new CiviCRM extension
Implement the hook_civicrm_buildForm in your extension

For the appropriate variable do:

function ext_civicrm_buildForm($formName, &$form) {
  if ($formName == 'REPLACE_WITH_FORMNAME') {
    $defaultDate = [];
    CRM_Utils_Date::getAllDefaultValues($defaultDate);
    $defaults['custom_XXX'] = $defaultDate;
    $form->setDefaults($defaults);
  }
}


Installing extensions with civicrm-buildkit

As a bit of background, it may help to check out "What's a build?" and "What are the basic build techniques?".

There are a few directions one can take on that topic:

Install an extension once, locally, for a single build.
Modify the build-document of an existing build-type so that the extension will always be installed in the future. (For example, if you modify the build-document for wp-demo, then the extension would be installed on wp45.demo.civicrm.org, wp46.demo.civicrm.org, etc. every night when the demo sites are rebuilt.)
Create a custom build-type with a custom build-document using your own curated list of extensions/modules.

Installing once is easiest -- you can use basically any extension-management practice that you'd use normally (with or without civibuild). The web-based manager or drush cvapi will be fine.

To modify a build-document, you would create or edit files in app/config -- you'll need to create steps for download and install. For example, in drupal-demo:

The file drush.make.tmpl defines all the download steps
The file install.sh defines the installation steps.

Digging into those files, you can see how it handles the CiviVolunteer extension. (Search for "volunteer".)

To create a new build-document, you should copy one of the existing build-types. The best starting points are (IMHO) drupal-demo (which uses drush with drush-make), wp-demo (which uses wp-cli and git), and wmff (which uses git submodules).

When editing a build-document, the development-feedback-loop (edit=>run=>validate=>repeat) can be a bit slow. To mitigate that, buildkit includes caches and nuanced rebuild commands.


Change Reply-To for System Workflow Messages?

This is similar but slightly different from How to send email report FROM other than default email address?

So a similar workaround would be to use hook_civicrm_alterMailParams.


CiviContribute: transaction rate limiting

Jim,

This is a very common scam, the best way is to add recaptcha; it's worked for all of our clients with this issue.  The new recaptcha "I am not a robot" is very user friendly.  This can be set up from the CiviCRM admin menu.

If your coming to the CiviCRM User summit today, please speak with Steven from iATS, he is very knowledgeable in this space and is giving a talk on security that will include this topic.


How to show CiviCase activities in client Actions dropdown?

If I understand right I think this is just a config change. You just need to mark those activity types as being for Contact instead of Case, and then they appear available for use in the normal activity menu, and you can still use them for case if they are listed in the case-type config.


You can add this to the top of your .sql file, then try loading it again.

SET FOREIGN_KEY_CHECKS = 0;

This will permit MySQL to load the data while ignoring the foreign key checks.

Since CiviCRM uses foreign key checks, this is a good idea only if the checks throw errors when loading the DB but not when using CiviCRM afterwards.

Alternatively, to ensure foreign key integrity and handle existing tables not wanting to be deleted, prefix your .sql with

DROP DATABASE nameofdb;
CREATE DATABASE nameofdb;

(where nameofdb is your actual DB name of course).


There's actually a way to specifically run a "First Time Donors" report, though it's a little hidden.

Go to Reports menu » Contribution Reports.
Select "Contribution Details Report".
Under the "Filters" tab, set "Contribution Ordinality" to "First by Contributor" to only show first-time donors.


Yes this was changed recently. I preferred it the old way too, but there was a feeling that it was duplication.
See https://github.com/civicrm/civicrm-core/pull/12620


Letter Templates Pre Populate with Membership Fields

you need to write an Extension for the membership tokens to be available in the contact summary  - please use the below link to know more

http://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension

if you need more help please let me know - thanks


Does anyone use CiviCRM behind a Web Application Firewall?

we have a slightly different approach for an enhanced security architecture using a proxy-server plus vpn. If you are interested, please sind more information plus code on GitHub, there was also a session on last year's CiviCon.

Let me know if you have any questions regarding CiviProxy.

Kind Regards
Fabian


Custom Top Donors (Contributions) report with the name of Relationship Managers

Ok here's what I do when faced with situtations like this: check how Eileen does it:

https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport

At times I'll extend one of her extended reports; it's a very well written extension.


Paypal Standard not working in embeded civi form

Yes, it's a security measure of paypal, you can't use it in an iframe.

I would suggest that instead of embedding the donation form, you simply put a link to your civicrm contribution page.

You might have another payment processor that is willing to work from within a frame (try stripe if you want), but you might get blocked in the future, because trying to "hide" what is the real domain of the form asking for money is something scammers would do when trying to trick victims to send them money when they think they are paying someone else


How to add a custom extension on navigation?

See the documentation for hook_civicrm_navigationMenu including the civix helper functions.


ARCHIVE not enabled by default on MariaDB 10.1

My strong advice to you would be to change the tables to be anything but ARCHIVE. Even InnoDB would be fine and preferred over ARHCIVE. We've had a number of sites have their entire audit schema's become corrupt and its been down to the storage engine being ARCHIVE.

Also you'll probably want to add indexes into the audit schema otherwise you cant access the change log without waiting for minutes.

I think later versions of CiviCRM do not use ARCHIVE storage format by default


Can I create a dynamic graduate student dashboard with CiviCRM?

See if civigrant suits your needs: https://docs.civicrm.org/user/en/latest/grants/what-is-civigrant/


I'm assuming you're asking how to add the contact image field to a CiviCRM profile?

As that field exists for all contact type, you need to select "Contact" first. The field is then called "Image Url"

This will upload an image onto the contact's record.


How to send receipt for previous event sign ups?

You might want to test the following:

Navigate to Administer Communications > Message Templates, select System Messages, then beside Events - Receipt only. Leave this window open and open another to Administer Communications > Message Templates, and click New template. Copy the subject, html body and text body from system receipt message into you new user one, give it a name and save it.
Navigate to Find Participants, select a registration of your own user for testing (you may need to create one first), then for action select Send email to participants. On the next page, select your new template and send the message. If the receipt looks good in your inbox, repeat this step but sending to unreceipted participant.


How to change the date format for the receipt date in a template

If you want 28 February 2019
{foreach from=$contributions item=contribution} {assign
    var="date" value=$contribution.receive_date|date_format:"%d %B %Y"}

If you want 28 02 2019
{foreach from=$contributions item=contribution} {assign
    var="date" value=$contribution.receive_date|date_format:"%d %m %Y"}

If you want it to look better (28/02/2019) you can add slashes value=$contribution.receive_date|date_format:"%d/%m/%Y"}


Invalid geocoding settings were the problem.


changing or removing the Headers and Footers from mailing templates

Possibly I don't follow the question, but using CiviMail you can avoid the need for using Headers or Footers by ensuring that you include all the required tokens in the template itself. You can also 'edit' the existing default Header and Footer and set them to not be default, hence when you then use your template in CiviMail, no header or footer will be automatically included, and none will be required.


Can we control what contact name links to on reports?

This is not configurable out of the box - but I really don't like when clicking on a name in a report doesn't bring you to the contact record.  For that reason, I've written an extension called "No Drill Down", which modifies any report that would normally bring you to a Contact Detail or Contribution Detail, and instead brings you to the contact record.  You can find it here.


How to delete an address, phone, email, or website in a profile?

I recall this coming up a number of times on the old Forum and the answer was 'can't be done'. And I thought this was going to be an unhelpful answer but Post 1 took me to Post 2 which took me to this Include ID when editing 'block' fields (+ allow deletion of block values via Profiles) which is flagged as Fixed for 4.7.

What version are you on? Want to go test on master


How to overwrite template file using php?

Hardcoding cusomised templates into extensions is in breach of extension development standards and can break on upgrades. Prevention of errors is an important priority to most developers to take pride in their craft and care about their clients.

The answer in your extension is to include the modified file in the path form template/CRM/path/to/template.tpl.php - but please find a better way. Civi users deserve great products that they get from other services, not this.


How can I make External ID a searchable field?

when you click in the QuickSearch (white search box very top left) you should see a drop down of 'what do i want to search for' and External ID is in there. So you can select that and then just enter the Ext ID that you are looking for.
You can also add the Ext ID field to a Profile which you have set up for Search or Listing if you want this more public eg I set this up on demo.

This link for a user to 'edit' their own (which you wouldn't want I guess ;-) but you may need to check if that url is available and set the field to View Only
http://d46.demo.civicrm.org/civicrm/profile/edit?gid=16&reset=1

This to 'view' it
http://d46.demo.civicrm.org/civicrm/profile/edit?gid=16&reset=1

This to 'search' for it
http://d46.demo.civicrm.org/civicrm/profile?gid=16&reset=1

And this (or may be another url for this) to View the listing
http://d46.demo.civicrm.org/civicrm/profile?_qf_Search_display=true

External ID is also available from Advanced Search and Search Builder like most other fields.


CiviCRM cron job not processing scheduled jobs

Are you on drupal for the CMS? in that case, using the drush option is easier to set up than the cli.php in my experience (you don't have to give credentials, and in general, deals better with the authentication of the cron user)


Custom form input field missing from &$values when hooking into tokenValues

Most likely you are not adding order_id when the form is being posted back to the server

the quickform package basically filters out all variables that have not been added to the form. The buildForm hook is called even when the form is posted, so you might want to ensure that order_id is also added there. In most cases this happens automatically, however if we are using ajax for build parts of the form, it gets a bit trickier

$_GET['pid'] is available only during the first GET request. The POST request sends a very minimal set of GET variables. Try using this variation:`

function invoicetoken_civicrm_buildForm($formName, &$form) {
  //add order_id to our form
  if($formName == 'CRM_Contact_Form_Task_Email') {
    $order_id = CRM_Utils_Request::retrieve('order_id', 'String', $form);
    $form->addElement('hidden','order_id', $order_id);
  }
}`


Permissions help with using action.forward token in an email

Make sure you have 'access CiviMail subscribe/unsubscribe pages' permission set for anonymous user.


From the administer dashboard, you can modify the option groups:

civicrm/admin/options?reset=1

and the activity status is one of them (/civicrm/admin/options?gid=26&reset=1 in my case).

However, there is a big

 WARNING: Many option groups are used programatically and values should be added or modified with caution.

Left Message
Unreachable
Available
No-show

Are not reserved (ie. we can delete them)

Is this safe to do so? can I add new statues without issue?


You should be able to navigate to /civicrm/tag?reset=1 select a tag and click on the label on the right side (see screenshot).


It looks like from your backtrace, its a bug in GDPR extension because its not possible to replicate in CiviCRM. Your system has many custom group for activity, and the extension code breaks when trying to retrieve results, Mysql supports max 61 joins in a query.

Possible solution:

Disable custom group for activity which is not required.
Restructure your custom group by moving custom fields into new/existing custom group and delete the ones not required. This is bit risky and will take lots of effort since UI may not allow you to move custom field if its defined for subtype. And if you have already used this field in webforms than probably you may need to retain the custom field ID.
Apply the fix from here.

Thanks

Pradeep


If you are using shoreditch then this might be the problem as currently it's not guaranteed to work on drupal 8.
It is a requirement for the CiviCase extension - but you can use CiviCase component without the extension.


Sync CiviCRM Events with WordPress custom post type

I haven't put it on the WordPress repo yet, but there's CiviCRM Event Organiser. Repeat events only sync properly when the event is created in Event Organiser, but most of the other elements sync as you would expect. Event registration sync, however, is not yet completed.


Can Civi/WordPress an Civi/Drupal (same versions) share a database?

Most of the database table can be shared between the two sites. However, there will/might be an issue with the WP user table and the drupal user table with the civicrm_uf_match table. One potential option might be to ensure that the user ids across wordpress and drupal dont conflict, i.e. choose a high starting point for the WP user table (which is a manual process in mysql)


How do I get my iCal feed to show past events?

Simply add the param &start=YYYYMMDD

On the html side use civicrm/?page=CiviCRM&q=civicrm/event/ical&reset=1&list=1&start=20070101&html=1

on the ical side use /civicrm?page=CiviCRM&q=civicrm/event/ical&reset=1&list=1&start=20070101

In that example 20070101 is January 1st 2007 - you can change the date to whatever you would like.


It might be easier to make the memberships expensive and give discounts for "early" payments.
I'm not sure without looking into it, but you may be able to do this with CiviDiscount?


Webform civicrm integration not respecting permissions

Figured it out thanks to @Colemanw.

The relationship permissions are only for dashboard access and do not act as ACL permissions.

I installed this extension which transforms relationship permissions into ACL permissions.
Now it is simple, I simply enable the 'Enforce Permission' option in the'Existing User' field and the drop down only shows the intended contacts.

Yosef


Display events by categories for current year, and past 3 years

I can't think of an existing way to "auto-thing" this, unfortunately. I think you may need to contract a CiviCRM partner to develop some custom code for you, or perhaps reach out to the maintainer of the CiviEvent Widget and see if they're willing to take feature requests. (I suspect they'll want to be compensated for that.)


There is a little piece of javascript that kicks in on the contribution page to warn a visitor if they try to leave before submitting the form. It sounds like you want to have something like that for the confirmation page? I think that would be a useful feature. Forcing the user to do anything is going to be a non-starter of course ...

Alternatively you could also configure your contribution to skip the confirmation page.


Checksum profile links not opening on mobile

Do you have http:// or https:// before the link in the email? If not, try adding it.


Can't find a »Back to search results« link on contact pages

I totally agree.

Once good way to do this would be to add a breadcrumb link here:

It was fairly simple so I just created a pull-request to add this to the upcoming 4.7 release.

https://github.com/civicrm/civicrm-core/pull/7555


There are likely more tables involved that just that table so I would not go directly into the database. There is an api for creating financial accounts so you could try using the csvimporter extension to import them. I believe it is available as a downloadable extension from your manage extensions page.

I would suggest just importing one and then looking to make sure it looks correct before doing more. Not that there are at least 3 entities involved - financial types, financial accounts & the one that links them.

Financial accounts have the cost code information and financial types are what the user selects. Each Financial type should have a number of related financial accounts for different purposes (income, expense etc) - so just look to make sure they look the same through the UI before you go for 100 imports


Multilingual text not copied when using an event template to create an event

Sounds like a bug.  If you have an event template with English and French and you create a new event using that template, I'd expect the new event to have English and French content identical to the template.
I'd suggest opening an issue at https://lab.civicrm.org/groups/dev/-/issues


How do I create recurring events in 4.6?

Combining the question's comments into an answer:

The Repeat tab isn't available until the event has been saved. Create the event and save it, and you'll see the tab.


How can I search in CIviCRM for people who have got a "Full" membership less than 5 months after their "Student" membership expired?

How we did this in the end was to create some custom code that when a new membership was added it would check if there was a membership of the previous membership type. ie if they were purchasing a Full membership if they had a current or expired Student membership.

If there was then it would calculate the number of days between the end date of the previous membership and the start date of the new membership and store this value in a custom field. We also added a feature that if the previous membership had not yet expired we would end it because in our case you were not allow to hold more than one membership at a time.

We can now run all the searches and views we like off this value.


How do I remove previous event details from new event?

It looks like someone has created a custom field set for events. I gather from you desciption of "previous event" the event that related to is in the past.

If you go to Administer > Customize Data and Screens > Custom Fields you should see a field set named Kodaly workshop.  Click on more on the far right and disable the field set.


Email-to-activity processing – create Activity at future date

You could use the CiviRules extension (https://civicrm.org/extensions/civirules) for this. Every time an incoming email activity is created in CiviCRM civirules could create a follow up activity in the future.

You need to configure CiviRules in such a way that the trigger is "activity is added", and that you have a condition on the incoming email activity type. And the the action is "create an activity" which is the "follow up activity".

Also note that civiRules triggers for each contact involved in an activity. The latter could be filtered out by a condition provided by civirules.

Documentation of civirules could be found at: https://docs.civicrm.org/civirules/en/latest/


Any elegant way to 'override' a No Bulk Mail setting for a single mailing?

Ignoring the no bulk email flag isn't, and shouldn't be an easy process, so what you describe seems to be the "less cumbersome" possible way indeed.

However, it seems to point out to a related issue: these 400 people shouldn't have opted out, but rather it seems should have been unsubscribed from the "regular" newsletter group and kept into the "VIP statutory meeting announcement only" group.

In theory, you can't really reach out to people that have opted out -by definition- but given your specific situation, I would contact them to tell them that you need to be able to mail them, and explain the new "statutory meeting" vs. "newsletter" situation.


Changing from TinyMCE for template editing to CKEditor solved this problem. Verified that switching back to TinyMCE causes style tags to be stripped.


Is Iframe based payment gateway integration with civicrm possible?

I don't think it's easy. I have tried without success a couple years ago.
The return page will go to the iframe rather than the parent page and i didn't find a way to close the iframe and having the Thank you page on the parent page.

I know that there is a lot of work that is being done lately regarding payment refactoring but i don't know if it tackle this kind of problem.


How to retrieve all contacts belonging to a smart group

As of version 4.6, you can use the API Explorer (top menu: Support > Developer > API Explorer) to get code, examples and docs.  You can use the entities and actions to find the right combination to get the info you're looking for. (You can use any number of actions, but it is a live API tool so if you e.g. update an entity, it will change values in the database).

In this case, go to the Explorer then click the tab for Examples.  Choose the entity: Contact and then example: GroupFilterUsingContactAPI.  That generates this code (taken from the Drupal Demo at dmaster.demo.civicrm.org, but the API explorer is not CMS dependent):

<?php
/**
 * Test Generated example demonstrating the Contact.get API.
 *
 * Get all from group and display contacts.
 *
 * @return array
 *   API result array
 */
function contact_get_example() {
  $params = array(
    'filter.group_id' => array(
      '0' => 1,
      '1' => 26,
    ),
    'contact_type' => 'Individual',
  );

  try{
    $result = civicrm_api3('Contact', 'get', $params);
  }
  catch (CiviCRM_API3_Exception $e) {
    // Handle error here.
    $errorMessage = $e->getMessage();
    $errorCode = $e->getErrorCode();
    $errorData = $e->getExtraParams();
    return array(
      'error' => $errorMessage,
      'error_code' => $errorCode,
      'error_data' => $errorData,
    );
  }

  return $result;
}

/**
 * Function returns array of result expected from previous function.
 *
 * @return array
 *   API result array
 */
function contact_get_expectedresult() {

  $expectedResult = array(
    'is_error' => 0,
    'version' => 3,
    'count' => 1,
    'id' => 1,
    'values' => array(
      '1' => array(
        'contact_id' => '1',
        'contact_type' => 'Individual',
        'contact_sub_type' => '',
        'sort_name' => 'man2@yahoo.com',
        'display_name' => 'man2@yahoo.com',
        'do_not_email' => 0,
        'do_not_phone' => 0,
        'do_not_mail' => 0,
        'do_not_sms' => 0,
        'do_not_trade' => 0,
        'is_opt_out' => 0,
        'legal_identifier' => '',
        'external_identifier' => '',
        'nick_name' => '',
        'legal_name' => '',
        'image_URL' => '',
        'preferred_communication_method' => '',
        'preferred_language' => 'en_US',
        'preferred_mail_format' => 'Both',
        'first_name' => '',
        'middle_name' => '',
        'last_name' => '',
        'prefix_id' => '',
        'suffix_id' => '',
        'formal_title' => '',
        'communication_style_id' => '',
        'job_title' => '',
        'gender_id' => '',
        'birth_date' => '',
        'is_deceased' => 0,
        'deceased_date' => '',
        'household_name' => '',
        'organization_name' => '',
        'sic_code' => '',
        'contact_is_deleted' => 0,
        'current_employer' => '',
        'address_id' => '2',
        'street_address' => '1 my road',
        'supplemental_address_1' => '',
        'supplemental_address_2' => '',
        'city' => '',
        'postal_code_suffix' => '',
        'postal_code' => '',
        'geo_code_1' => '',
        'geo_code_2' => '',
        'state_province_id' => '',
        'country_id' => '',
        'phone_id' => '',
        'phone_type_id' => '',
        'phone' => '',
        'email_id' => '1',
        'email' => 'man2@yahoo.com',
        'on_hold' => 0,
        'im_id' => '',
        'provider_id' => '',
        'im' => '',
        'worldregion_id' => '',
        'world_region' => '',
        'individual_prefix' => '',
        'individual_suffix' => '',
        'communication_style' => '',
        'gender' => '',
        'state_province_name' => '',
        'state_province' => '',
        'country' => '',
        'id' => '1',
      ),
    ),
  );

  return $expectedResult;
}

/*
* This example has been generated from the API test suite.
* The test that created it is called "testGetGroupIDFromContact"
* and can be found at:
* https://github.com/civicrm/civicrm-core/blob/master/tests/phpunit/api/v3/ContactTest.php
*
* You can see the outcome of the API tests at
* https://test.civicrm.org/job/CiviCRM-master-git/
*
* To Learn about the API read
* http://wiki.civicrm.org/confluence/display/CRMDOC/Using+the+API
*
* Browse the api on your own site with the api explorer
* http://MYSITE.ORG/path/to/civicrm/api
*
* Read more about testing here
* http://wiki.civicrm.org/confluence/display/CRM/Testing
*
* API Standards documentation:
* http://wiki.civicrm.org/confluence/display/CRM/API+Architecture+Standards
*/


Parent group isn't counting contact in child groups

This is a limitation of current implementation, "Parent Group" contact count does not include "Child Group" contact count. So I would call this a missing feature :)


Wordpress plugin configuration will not launch

After activating CiviCRM, did you run the installer?
See instructions here at http://wiki.civicrm.org/confluence/display/CRMDOC/Installing+CiviCRM+for+WordPress


How do I prevent CiviSMS from converting my URLs to longer clickthrough-aware URLs?

You can install this extension: https://github.com/PalanteJon/coop.palantetech.nosmsurltracking.  This will automatically turn off click-through tracking on all mass SMS messages.  There's no checkbox (unless someone codes one in), so it turns tracking off on ALL messages - but if you need tracking on a single message, you can disable the extension temporarily.


Can inherited members receive scheduled reminders?

Confirm that they have ALL of following conditions met:

current employee relationship that is also permissioned
inherited membership


Custom field default values at database level, not form level?

A possible downside, although unlikely, is an upgrade might do some kind of batch modify on all custom fields that would wipe your default value.

What are you trying to do that can't be done with a hook or trigger?


Displaying Custom Field When Using the New Organization In Contact Menu

As you noted. the New Organisation is a civi Profile - and at Administer > Customise > Profiles (http://d46.demo.civicrm.org/civicrm/admin/uf/group?reset=1) you will see it on the Reserved Profiles and can therefore add your new field here and it would show assuming the 'field' is set either for organisations or 'all contact types'.


All you need is to create a custom field against membership

Please follow the below link

https://docs.civicrm.org/user/en/latest/organising-your-data/creating-custom-fields/

I guess this helps !!!


Why would the activity date for a contribution differ from the contribution date?

Is possible that you first entered wrong date while creating contribution and then updated receive date by editing the Contribution?
There is no form to update the Contribution activity. But you do this using api explorer screen.

First retrieve the Activity ID using Contribution Id(source record id)

(here 689 is Activity ID and 128 is Contribution Id)

Update the Activity date.

HTH
Pradeep


If CiviDiscount is enabled, you should see the discount box at the top of the membership page even if you don't have any discounts configured.  The position isn't great and can be missed if someone is expecting to see it near the amount.

You don't need to use price sets.

If you're quick, you can see an example at https://dmaster.demo.civicrm.org/civicrm/cividiscount but it is regularly reset.

I noticed though that the discount is not being applied correctly, so I have created a ticket for that.


premium gift reports not showing size ordered

There are a couple of extensions that give more detailed reporting on line items

Line Item Report
Extended Report

One of these may be helpful


Are others experiencing problems with PayPal

What version of CiviCRM do you use? In at least two of the latest versions released recently there is some Paypal bugs that has been fixed. You should first of all make sure you have the latest version installed.
You can see it in release notes for:

5.31.1
5.32.0


I re-ran the import with skip for duplicates and it worked perfectly.  For my case this fixed the problem.

-Josh


I had a client with a similar issue.  They resolved it by not adding a facilitator to any events they didn't facilitate.

Assuming that's not a workable workaround for you - it IS possible to generate reports like you're describing, but you'd need to either a) code it (or find someone to code it), or b) use an (often pricey) third-party reporting tool.  Come join us at https://chat.civicrm.org if you'd like to discuss custom reporting options - either doing it yourself or finding someone to do them.


Is civicrm-buildkit safe to use in production?

Buildkit is not designed for production use but I can't think of any reason it can't be used that way. As your second question suggests, the upgrade procedure will indeed be different. Steps for upgrading on a buildkit install would be:

Backup your database
Do a git checkout tagname && git pull for all 3 git repos (civicrm-core, civicrm-packages & civicrm-yourcms).
Run setup.sh with the correct arguments to regenerate code and download dependencies.
Run the upgrader (can do this from the command line as well)

You'll probably want to create a little script to do this for you.


Having a Problem Installing CiviCRM 4.7.25 on WordPress

The CiviCRM "plugin" for Wordpress CMS is not installed like a conventional Wordpress plugin.  There are many more things to be considered and you would be advised to read and follow all the stages described in the following Wordpress Installatin Guide for CiviCRM at https://docs.civicrm.org/sysadmin/en/master/install/wordpress/

Hope this helps.


What should be synced to an accounting package from civicrm?

Tommy,

I think an extension is a good idea, but a quick glance at the aplos API and it looks like aplos wants each transaction mapped to an aplos contact id.  This seems like a lot of work that is not necessary.  My advice is to see if you can upload a batch at a time through CiviCRM export (maybe a custom search or report) and see how that works first. the effort level will be a lot less.

I don't know aplos, but many of the small accounting packages assume that they are the transaction system of record and need the contact id passed with each transaction - this appears to the case with aplos.  What you are asking is for a batch transfer with CiviCRM as the sub ledger and using Aplos as the general ledger.  This works fine with larger systems like Dynamics.  I don't see any aplos documentation on JE imports and my guess is that they have not implemented it yet.

it would be a great extension and many we get aplos to fund it (seems like a biz dev opportunity for Josh of the core team)


custom fields become unavailable after a period of time

Ultimately, the answer was simply to enable "CiviCRM: access all custom data" for all users in Administer->Users & Permissions->Permissions->WordPress Access Control.
I am unclear whether this presents a data risk. The wording of the permission makes it feel a bit like this, but I guess if a user only has limited access by context then it isn't an issue. I am fervently hoping this is so.
The reason it appeared to work at first was related to browser and server caching. As soon as the caches cleared it failed.


How to find users that have taken more than one action?

This may not be a comprehensive answer, but do you have this extension installed? https://github.com/progressivetech/net.ourpowerbase.sumfields

Some of these calculated fields used with advanced search could answer some of your questions.

  The benefit of making these items available as calculated fields is
  that they can be searched in Advanced Search and used as a basis for a
  smart group as well as for tokens in email and print communications.

Sumfields that are available:

Total Lifetime Contributions
Total Contributions this Year
Total Contributions last Year
Amount of Last Contribution
Date of Last Contribution
Date of First Contribution
Largest Contribution
Count of Contributions
Average Annual (Calendar Year) Contribution
Date of Last Membership Payment
Amount of Last Membership Payment
Name of the last attended event
Date of the last attended event
Total Number of events
Number of events attended
Events attended as percent of total
Number of no-show events
No-shows as percent of total events
Number of turnout attempts
Number attended from turnout attempts
Number noshow from turnout attempts
Attended as percent of turn out attempts
No-shows as percent of turn out attempts


Does CiviCRM VERP work with a mailbox on Microsoft Small Business Server 2011?

No version of Exchange supports subaddressing.


DB Error: unknown error when accessing any report menu after upgrade to 5.10.0

On the Finish page of the CiviCRM 5.10.1 and 5.10.4 component installation, there is a little link called "Utility for Updating the Database structure" or something similar. Up til running that little link, we received the "DB Error: Field missing" error when running some reports.


you can create a new report, go to Reports->Event Reports, click on New Event Report, Select  Income Count Summary Report, you can customize the report and if the featured field is searchable you will find it here. Hope this helps


It will depend on how the contributions were created and whether payments were associated with it.

The best ERD I know of is this one doc.symbiotic.coop/dev/civicrm/latest/schema/index.html

At a minimum you will probably need to check the civicrm_line_item table as well as civicrm_contribution.


Totals Row for Tab with Table Custom Data

Personally I'd do it by adding some javascript code to the page, and just use jQuery to add the totals row.

A super-quick way to do this would be to place the code inside {literal}<script> tags in a .tpl.extra file.


Update custom field from other custom data

SO I was able to figure this out, turns out I wasn't able to reference the custom data directly from the activity object but had to use the api to grab the custom data related to that activity object.

function checkActivityMakeRelationship_civicrm_post($op, $objectName, $objectId, &$objectRef) {
/* This function checks if a specific activity was created and if so makes a related relationship
*/

if(($op == 'create' || $op == 'edit') && $objectName == 'Activity') {
    $params = array(
        'sequential' => 1,
        'id' => $objectId,
        'return' => "custom_50,custom_51",//replace with your specific custom
    );
    $activity = civicrm_api3('Activity', 'get', $params);
    $contact_a_id = (int)$activity[values][0]['custom_50_id'];//note the appended _id
    $contact_b_id = (int)$activity[values][0]['custom_51_id'];// appended _id
    $result = civicrm_api3('Relationship', 'create', array(
    'sequential' => 1,
    'contact_id_a' => $contact_a_id,
    'contact_id_b' => $contact_b_id,
    'relationship_type_id' => 11,//your specific relationship id
    ));
}

}


Updating Repeated CiviEvents in 4.7 and 5.0

I can assure you that custom fields never carried over to repeating events in Civi 4.6 - I had to write a lot of custom code to deal with the fact!

The issue you're describing is CRM-16902.  It's marked as closed, but that's incorrect - a related issue, CRM-20787 was recently fixed.

Before CRM-20787 was merged, it WAS possible to change a single price on a repeating event.  This might be the changed behavior your client is noticing.  If selecting "this event only" isn't possible now, that's a regression and should be reported.

That said - dealing with price changes and price sets is very thorny.  If I change event 3 (only) to have a different price, then I change a different event's price and say "change all events" - does event 3 have the new price?  Or just the unchanged events?

In short - it's not a quick fix.  It needs code to be written.


Further investigation on my site, which was exhibiting the same issue as that noted by Keith Sorbo, showed that there was no 'user 0' record in the Drupal users table.

This page - https://www.drupal.org/node/1029506 - offers various options about how to reinstate a 'user 0' record in the Drupal database.

Once I had a 'user 0' record the CiviCRM contribution page worked as expected.


Event Registration on Behalf of a Contact is Broken

This error usually occurs when the option values for Custom data type are disabled or deleted. Make sure you have all the options values required for event are enabled for Custom data type option group. Here are the options

If a option value is missing then you will need to add the option value either through UI or api. However for some option values its not possible to add same options with same machine name so it is always better to add such options through API Explorer.

Navigate to CiviCRM >> Support >> Developer >> API Explore. And use the options shown in the image below once you are done with selection then click on execute button for api to process the params you selected.

HTH

Pradeep


How to disable email notifications when confirming a donation in CiviCRM admin view?

You mean the receipt?

There is a checkbox "Send Receipt?" when you modify an individual contributione. If you uncheck it, it shouldn't send the email.


Does Webform CiviCRM event registration respect the "Registration End Date" setting?

No, it does not. Those checkboxes apply to the event end date, not the registration end date.


When will 4.4 LTS end, and what will replace it?

4.6 will be the next LTS version. The switch from 4.4 to 4.6 will probably occur at the end of 2015, since the 4.6 branch will be quite stable by then.


CiviCRM 4.7.25 - No such field - unknown column a.weight in field list on Activity

Comparing a fresh CiviCRM DB with my own revealed the differences between existing and expected.

I added the weight field to the civicrm_activity table in the right place and things were resolved.

This installation has been through years and years of updates and there have been several occasions over the years where half-baked upgrade scripts have left the DB in similarly half-baked corners.

Gladly, this only caused some UI issues and is now resolved.


Unable to amend membership if it previously was related to an organisation record

It turned out that I needed to delete the membership on the Ogranisation record:
I made a copy of the membership and contribution on the owner record (so we've still got the historical data), then deleted the faulty membership from the owner record and this removed it from the individual contact record. Bit messy but did the trick.


Install Error DB Error: extension not found

Have you installed php-mysql?

sudo apt-get install php-mysql

To me, it sounds like PHP doesn't have the MySQL extension installed.

Meanwhile, at this point, CiviCRM doesn't support PHP 7, so if you do get this working, you'll run into that problem next.


exporting data with custom field nantionality exports country id instead of country name

The same thing happens to us. I just create an issue and proposed a patch as a provisional workaround.

https://issues.civicrm.org/jira/browse/CRM-17822

[Edited]

Seems that the issue is fixed for 4.6.12 version.


Sorry I thought I'd answered previously but I'm 99% this is down to the fact that once a membership status becomes ended the automated rules then wont touch it. So the first status of type ended in theory would be the one that gets applied and any subsequent ones wouldn't be something that automatically gets moved on. I'm 99% thats the issue your facing, a previous question asked if CiviRules could be used to change membership statuses (which it cant yet), your case is probably one that fits a CiviRules status change I think. Let me know if you prove the theory!


how to write PHP Unit test for an entity using hooks

An example is in tests/phpunit/CRM/Contribute/Form/Task/PDFLetterCommonTest.php, testing that hook_civicrm_tokenValues works correctly on PDF letters.

You write a function using the hook, but you can name it whatever you want.  Then you call $this->hookClass->setHook, specifying the function name.


Sometimes when unexplainable things like this happen, it helps to just clear all the caches. Administer > System Settings > Cleanup Caches

If you use drush, drush cc civicrm. If that doesn't work, you could delete everything inside of the templates_c folder.

rm -r /[path/to/drupal_root]/sites/default/files/templates_c/*


How to Include Supplement address line 1 to billing block on Civicrm 4.6.10?

As far as I know this can't be done without modifying core code. The list of fields in billingBlock.tpl is hard-coded.


Credit Card swiping from mobile devices for event registrations and contributions

Yes there is! iATS Payments has an encrypted USB card reader that works with its CiviCRM iATS extension as well as a mobile phone card reader that works with their App.

For the mobile option: we're actively working on code required to be pushing them into your CiviCRM as well.

Organizations use it during checkout at fundraising events and in the office to swipe card / walk-ins.


You should use the custom search "Include / Exclude Search" that does exactly what you want

civicrm/contact/search/custom?csid=4&reset=1 on my install, likely the same custom search id on your install


Importing membership custom field keeps failing

Try using the machine name instead of Label or Value. I believe for some cases it uses machine names rather value or label. You can find the machine name either using sql stmt or through api explorer.

Here is an example of some cases where value or label didn't work during import.


Potential fix to long term issue with IDS errors on Event Confirmation emails through ActivityProcessor

Despite getting a Tumbleweed award for this, I have submitted a fix

See https://issues.civicrm.org/jira/browse/CRM-17030
and https://github.com/civicrm/civicrm-core/pull/6508


Multiple Entry Custom Values : Find modified ID?

Don't know if this will help, but at least you can try it. :)

The custom() hook is called after the db write on a custom table, so when the field is writen, you can't know which was the change, so you can't have the id (or at least I think so).

Instead of custom() you can try the pre() hook. Check if the Enjoyment Level has changed (use api to read the field in the db and compare with the $param), and if it had, update the Updated field.

Check this links that posibly can help you:

Setting and getting custom field values from within hooks

Hook pre


Event Fees not loading when registering in back-end

This is a core bug, I have created issue for this bug at https://lab.civicrm.org/dev/core/issues/189

I have submitted a fix for this at https://github.com/civicrm/civicrm-core/pull/12333 . Can you please QA by applying the patch manually to your instance?

Please comment your QA result on PR so that it will helpful to get merge quickly.

Thanks

Pradeep


Issues with Migration - Cannot add foreign key constraint

It looks like your error message is truncated, which makes this a little hard to troubleshoot, so if you can find a way to generate a non-truncated version of this message, I think the solution should be clearer.

That said - I'm looking at a CiviCRM database dump.  The first two tables to be created are civicrm_acl and civicrm_acl_cache.  Your error references civicrm_acl - but civicrm_acl doesn't have any foreign key constraints defined, so it makes no sense that you'd get this error on the line in your question.

However, civicrm_acl_cache DOES have a foreign key constraint - on civicrm_acl.  So I would assume that one of the following is true:

Your PHPMyAdmin user doesn't have the permission to create civicrm_acl, or perhaps to insert data into it.
Your database dump you're loading is missing data from civicrm_acl.

Please check the following:

Does civicrm_acl exist after you've imported it? If not, check permissions.
Does civicrm_acl exist but contain no data?  If yes, open your database dump in a text file and ensure that there's a line starting with INSERT INTO `civicrm_acl` VALUES.  That line should be between the lines starting with CREATE TABLE `civicrm_acl` and CREATE TABLE `civicrm_acl_cache` - somewhere right near the top of the file.
If that line DOES exist, you might not have INSERT permissions.
If that line doesn't exist, you should try getting a dump that does.


Totals without showing each contact in Contact related reports

one way to do this would be to use the Aggregation feature in Drupal Views. This can be set to give you a 'count' for any of the fields in the row, so you could have your postcode in one column and a 'count' of the 'contact IDs' in the next. You would then be able to make the 'postcode' function as a link so that you could then click through to see all the contacts in that postcode.

Of course it really depends what you want to 'do' with that data after you see it. But if reporting the numbers is the primary goal, this may work for you.

Expect others to provide a 'how to' using Reports directly.


There is an extension available for adding offline recurring contributions but unfortunately the tag says it works till 4.4. Might be worth contacting maintainer if they have any plans to upgrade.

Pradeep


Relationships Calendar is in Russian - How do I fix?

I've tracked down what caused the - duplicate calendar icons . It was an outdated version of the CiviCRM Shoreditch extension that was installed. I've disabled, uninstalled and deleted it. The duplicate icons are gone, the Russian text still remains though.

I have posted a ticket on the Shoreditch extension github site with the details. Hopefully they can resolve the issue. In the meantime, i've disabled the extension.