french Installation of civicrm 5.27.2 on drupal 8

If you've already installed civi and you're able to get to the administer - localization - languages page, then the following is probably the simplest at this point:
In civicrm.settings.php (in web/sites/default), add this line to point to the l10n folder:
define('CIVICRM_L10N_BASEDIR', '/full/path/to/l10n');
OR
Move your l10n folder into vendor/civicrm/civicrm-core.
The first is slightly better because you can put l10n somewhere that won't get deleted when you upgrade, so then I'd also move l10n somewhere completely outside civi.


Webform Civi Payment fields not showing up

Presumably you are on 7.x-4.15 of webform_civicrm since you say you just upgraded.  If you switch back to 7.x-4.14, does it work?   If so, it looks like the same issue I logged here: https://www.drupal.org/node/2676752


Best Practise for recording thank you letter.I don't have email addresses

You can add a custom Activity Type and then record such an Activity when you send out a snail mail. You can also use the existing Print/Merge Document activity and generate the PDF via the Activity and hence record it at the same time.


When we just have the month/day for the birthdate we set the year to a generic year like 1900. You still are able to get your birthdate notifications and run all the reports you want. It's just that the calculation of the contact's age will be wrong. We use a year that would make the person VERY old so that we know that the year is not known. It has worked for us without any issues.


Preferably, you'll want to dig into your outgoing mail service logs. How you do that depends on how you've setup civimail. It might be as simple as inspecting a file like /var/log/mail on your server, or it might involve something more complicated if you're using a remote outgoing mail service.

The challenge is to figure out which part of the mailing process is generating multiple mails. Typically this would occur where one server is passing off the mail to another server, and it's being received but not acknowledged, so the first server tries again later. A bad firewall, or misconfigured server along the way, for example. This would show up with the multiple mails having different receive times.

If you don't have access to your maillogs, inspecting the raw mail headers of the received mail may show some clues (e.g. warnings by one or more of the servers that are handling your mail).


How to allow contributions from non-members

Within the Profile settings you want to make sure that you have not set Account creation required which can be found in the advanced settings: Administer > Customize Data & Screens > Profile.

By default, for whatever bizarre reason, the Supporter profile has Account creation required set as default. It took me a good hour to find that one!


Creating Drupal Accounts when a sub-type CiviCRM Contact is created - created by a webform

Most of what you need is here: How can I create a Drupal user when someone submits a CiviCRM-Webform? based on @petednz-fuzion's blog post.   It uses civicrm_entity which has seen a lot of activity since the previous question so there may be some changes but hopefully nothing that prevents you following it.

For limiting action to a specific contact sub-type, add a new Condition using 'Data comparison' with a data selector of civicrm-contact:contact-sub-type


How to set a recurring membership start date to be 1st of the month

Auto-recurring memberships are triggered by the corresponding recurring contribution, so what you need is:

A payment processor that supports future dates for recurring contributions.
A way to restrict which dates are allowable.

For 2., the functionality is built into the iATS Payments extension, and also in my extension here:
https://github.com/adixon/ca.civicrm.contributionrecur

I'm not sure if my implementation in that custom extension will work with Authorize and/or Stripe, but you could try it. Those processors might need a small patch for it to work.


Event Reporting to call out Custom Fields in related Contribution Record

If you have a report that doesn't show the custom fields on an entity, it might be because those fields are not configured as searchable (yes, a very non-obvious thing). If that's the issue, then it's the same as this question/answer: Custom fields in the Report Templates

Alternatively, if it's a problem with the report itself, you can generally hack it with something like the below at the top of the class file:

 protected $_customGroupExtends = array(
    'Contact',
    'Individual',
    'Contribution',
  );

If you're seeing some custom fields but not the ones for Contributions, just adding in the Contribution entry to your current values should work.


Chain API call cascade, pass second value as third call argument, "id is not a valid integer"

so you are trying to fetch the details of contacts that are related to the ones you search for first?
The $value refers to the last call in a nested one.

$result = civicrm_api3('Contact', 'get', array(
  'sequential' => 1,
  'return' => "id",
  'api.Relationship.get'
   => array(
     'contact_id_a' => "\$value.id",
     'api.contact.get' => "\$value.contact_id_b"),
));

If you want to give more params to the inner api.contact.get:

$result = civicrm_api3('Contact', 'get', array(
  'sequential' => 1,
  'return' => "id",
  'api.Relationship.get'
   => array('contact_id_a' => "\$value.id",
     'api.contact.get'
      => array(
        'id' => "\$value.contact_id_b",
        'sequential' => 1,
        'return' => "display_name"
      )
    ),
  )
);


Missing information when Importing Contributions via API

This should work
civicrm_api3('Contribution', 'create', [
    'financial_type_id' => 11,
    'receive_date' => 0201008150000,
    'total_amount' => 11.15,
    'tax_amount' => 0.53,
    'net_amount' => 10.62,
    'contact_id' => $civicrm_id,
    'contribution_status_id' => "Pending",
    'payment_instrument_id' => "Überweisung",
    'is_pay_later' => 1,
    'skipLineItem' => 1,
    'api.line_item.create' => [
        'entity_table' => 'civicrm_contribution',
        'contribution_type_id' => 11,
        'financial_type_id' => 11,
        'price_field_id' => 55,
        'label' => 'article name example 1',
        'tax_amount' => 0.53,
        'unit_price' => 10.62,
        'line_total' => 10.62,
        'non_deductible_amount' => 0.00,
        'qty' => 1.00,
      ]
  ]);


the warning is about how Reminders are managed. In terms of the Scheduled Job - yes you need that enabled if you want to have the Membership Status automatically updating (and it would a rare situation you would not want this happening)


How do I send to Multiple Email Addresses for a contact in CiviMail?

Yes! Go to /civicrm/admin/setting/preferences/mailing and check "Enable multiple bulk email addresses for a contact". Then check the boxes for all of a contact's addresses that should be included in a bulk mailing.

You can also reach this settings page from Administer menu > CiviMail > CiviMail Component Settings.

It's only available on relatively recent versions of CiviCRM (4.5+ if my memory serves me right)

Note that multiple email addresses for a single contact are still useful, even when the 'Enable multiple bulk email addresses for a contact' box is not checked. In this case, the flow is as follows:

CiviMail will attempt to email the primary email or if no email is set as primary, the first email it encounters. If CiviCRM receives a bounce report from this email, it may decide to put the mail on hold (depending on the type and quantity of bounce reports received). Next time CiviCRM sends an email to this contact, it will ignore the on hold email and attempt to send to the next email address for that contact (if any exists).

Multiple email addresses on one contact are also useful to avoid duplicate contacts, e.g. if a contact sometimes uses a home address and other times a work address.


CiviCRM/Drupal site constantly logging user out

One explanation is that, rather than being logged out of the site, your users are being moved from a site they are logged into to one that they aren't logged into. If your site is served via https://www.example.org, you might see users "suddenly be not logged in" when they visit any of the following:

https://example.org, or
http://example.org, or
http://www.example.org

If your CMS site isn't configured to "lock in" a specific canonical URL (including protocol and hostname), CiviCRM may bounce people from another URL which they are logged into over to the URL CiviCRM thinks is "correct" (per CiviCRM's civicrm.settings.php). When this happens, the user experience is that they get logged out (but they will then be mysteriously logged back in if they visit the URL they were logged in on before).

Drupal isn't fussy about having a canonical URL, but CiviCRM is, and it's good practice anyway.

If this is the behaviour you're seeing, your best bet is to configure your CMS / webserver / .htaccess to enforce a canonical URL (single hostname and protocol), so that all visitors to alternate URLs are immediately moved over to the preferred / canonical base URL.


Upgrade from 4.6.3 to 4.6.4 not completed

You can see exactly what queries are being run by this incremental upgrade by opening up the CRM/Upgrade/Incremental/sql/4.6.4.mysql.tpl. In this case it's basically nothing. There is one query in there, which you could copy and paste into e.g. PHPMyAdmin and run it from there (although it honestly doesn't look very important).

Normally I would worry about a hung upgrade and recommend you restore from backups and try again. But in this case I think you lucked out.


Civicrm Activities - Scheduling conflicts

" Is there anything in Civicrm that would notify the activity creator that there is already an activity scheduled for that date / time for that staff member?"

No there is nothing in CiviCRM that can do this currently.

For anyone using Drupal (I realise this user is on Joomla) then you could make a Views Calendar of Events and that could be used to view existing meetings, including filtering by contact.


You need to i think it is enable the justify Plugin that will then give you the align left button. I would also recommend adding in the Font Plugin as well.

Regards

Seamus


If you're ok with it not being tightly integrated (i.e. automatically available in the xml or to the api), then you can do something like below, which adds a field labelled "Boo" to the case type edit screen.

Thanks for asking this question. It's probably helped me more than you, since it's helped clarify for me how this all works. And it occurs to me that customizing an existing form is probably a much more likely task for developers than writing your own angular form from scratch, which is what all the tutorials show.

function myextension_civicrm_alterAngular(\Civi\Angular\Manager $angular) {
  $changeSet = \Civi\Angular\ChangeSet::create('add_casetype_custom_field')
    ->alterHtml('~/crmCaseType/caseTypeDetails.html',
      function (phpQueryObject $doc) {
        $doc->find('div.crm-group')->append('
          <fieldset class="crm-collapsible">
            <legend class="collapsible-title">{{ ts(\'My Custom Fields\') }}</legend>

                <input crm-ui-id="mycustomfield" class="crm-form-text" name="mycustomfield" ng-model="mymodel.cusfield">

          </fieldset>
        ');
      });
  $angular->add($changeSet);

  CRM_Core_Resources::singleton()->addScriptFile('my.extension.name', 'js/angCustomField.js');
}

Reference: https://docs.civicrm.org/dev/en/latest/framework/angular/changeset/

And here is the contents of js/angCustomField.js:

(function(angular, $) {
  var crmCaseType = angular.module('crmCaseType');
  crmCaseType.controller('CustomFieldCtrl', function($scope) {
    // Need to replace this with an ajax call right here to look up the value from the db.
    $scope.mymodel = { cusfield: 'value looked up from db' };

    // just show that this is executing and we have the right id
    console.log($scope.caseType.id);

    // alias the real save() function so that we can do our stuff too
    var proxiedSave = $scope.$parent.$parent.save;
    $scope.$parent.$parent.save = function() {
      console.log($scope.caseType.id);
      console.log($scope.mymodel.cusfield);

      //
      // Do ajax api or whatever here to save the value to db
      //
      // IMPORTANT: Always validate the input server-side before using it even if you have javascript validation client-side since that can be easily bypassed. This isn't specific to angular it just seems to be ignored in all the angular tutorials. Even a plain html form with e.g. a select list can still submit values not in the select list - always need to validate server-side.

      // Now call the original save
      return proxiedSave.apply(this);
    }
  });
})(angular, CRM.$);

Some notes:

Note we're adding our own nested child controller in the line that has ng-controller="CustomFieldCtrl". This matches up to the controller in our js file.
The ng-model="mymodel.cusfield" value HAS TO HAVE A DOT IN IT. It just doesn't work if it doesn't. This matches up to the $scope.mymodel = ... line in our js file.


I think there is nothing that allow to hide base templates for now.

Personally, I would like to see a functionality that allows hide selectively the usable templates from a list of available templates. Perhaps a new featured request could be opened on https://github.com/veda-consulting/uk.co.vedaconsulting.mosaico on this direction.


Contact Form 7 WP PLugin Shows Error when Info is submitted in form. The error is not present when Civi CRM is disabled

This is really digging back into the cobwebs for me but... I had a very similar problem that I think popped up when we set up SSL. I think that in the Form settings, under the Mail tab, I had to remove the To & From mail-tag and just use my actual email address. I may have ended up deleting the current form and creating a new one.


Drupal views recipe for displaying Civievent Participants using a jump menu selector

Add an Exposed Filter in your view -> and if you also have Better Exposed Filter module installed - then you have some more configuration options like bypassing the Apply button.


CRM procurement: Presenting the case for CiviCRM

Take a look at the recent Idealware report comparing 'donor management systems' and CRMs. I do not believe it is totally accurate or fair to CiviCRM, but it is something like what you want.

CiviCRM members are working on a side-by-side comparison of CiviCRM to 'competitor' platforms, which we hope to publish soon at the CiviCRM.org website.


How to register a unknown company for an known event participant?

It sounds to me like using a Price Set that allows the user to enter the number of people coming as an integer. Set the Price Set field to count each as a participant, then you will get your total number.


User account fields missing from create user account profile

You will need to check few things

Check if the profile has create user account option enabled.
Check drupal settings if Anonymous user is allowed to create account(Configuration >> Account Settings).
Make sure your profile has email field and is primary or uses default location type


Event registration email comes from number@servername address

There was a problem with that: https://lab.civicrm.org/dev/core/issues/713 which was fixed by https://lab.civicrm.org/dev/core/issues/644 which is marked as fixed in 5.11  Upgrading should fix your issue.


Might be worth checking if your page uses a Price Set and then investigating the issue there. Otherwise it might be a field in a Profile, and that text may either be in the field 'pre help' or in the Profile 'pre or post help'


Contribution receipt not being sent after paying with Paypal

Check the logs at /media/civicrm/ConfigAndLog shortly after a payment has been made but no confirmation sent.

You should see the payment Mar 15 19:13:18 [info] Contribution record updated successfully

Then you should see the contribution receipt. There may be an issue here e.g.

Mar 15 19:13:18 [info] $Fatal Error Details = Array ( [message] => The requested Profile (gid=XXXXX) is disabled OR it is not configured to be used for 'Profile' listings in its Settings OR there is no Profile with that ID OR you do not have permission to access this profile. Please contact the site administrator if you need assistance. [code] => )

If you see something like the above, the issue is that Civi cannot access the information that was entered in the profile.


New D8 / Civi install. First d8 then added Civi. Civi Menus not showig up

This problem was (I think) related to a permission problem with the plug-in not having permissions to copy the libraries from a parent directory to the doc-root directory.
Solved for me.  Hope this helps someone else.


Upgrade from 4.6 to 4.72 DB error - no such field

I just did an Upgrade from Civicrm 4.6.11 to 4.7.2 - (plan copy) which went without any error - so please try the below and update the result

Just TEST This First
I guess you had Payment processor enabled in your previous version and which has extra column for the payment processor type

So please try to Roll back to your previous version of CiviCRM 4.6 first

Then try to delete the payment processor or Disable the payment processor and try to Upgrade to Civicrm 4.7.2

Also if possible try to disable all the extension too.


Civisualize extension doesn't show up as available when uploaded to extension directory

You may also need to check the uploaded extension's file permissions and user settings.

Also, clear cache.


"Site can't be reached" error during CiviCRM Joomla install

It turns out that I needed more privaleges on my MySQL account, ones that my host did not give me the option of enabling. Here is the list of requirements: https://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+MySQL+Permission+Requirements

My host wouldn't let me do Triggers or create routines, so I had to switch hosts and it now works.
In case anyone is reading this with the same problem, I looked for hosts on CiviCRM.org to find one that was compatible, and they were able to transfer me over and assist with the install for free with a new registration.


email bounce processing not working. site on AWS, using Zoho email

Is your bounce address set up properly in Administer menu > System Settings > Mail Accounts?  Documentation is available here.

If you're good there, make sure you can log into the bounce processing account with the credentials you've stored.  Also, what protocol have you set on that page?  Is IMAP an option for you to use?  If so, CiviCRM will store emails that it's processed in a subfolder on the server.  It makes it easy to look and see whether Civi is doing what you expect.

Finally, if you aren't committed to Zoho, there are many third-party mailers, some of which offer as many as 100,000 messages free/month.  Many have an extension for CiviCRM, much easier to set up than traditional bounce processing.  Check out this blog post that includes a link to a CiviMail calculator.


I think I have seen this before when the volunteer opportunity has no end date. When creating the opportunity, did you select "Open-Ended" for the "Schedule Type?"


changed the base URL in civicrm.settings.php . now works fine .

if (!defined('CIVICRM_UF_BASEURL')) {
  define( 'CIVICRM_UF_BASEURL'      , 'http://localhost/site/');
}

is changed to

if (!defined('CIVICRM_UF_BASEURL')) {
  define( 'CIVICRM_UF_BASEURL'      , 'http://myipaddress/site');
}


How do I correct mismatched Timestamps for MySQL and PHP without access to server?

With WordPress, 90% of the time it's just the WordPress timezone that needs to be reset.  Make sure that's set right as a first step.


Is it possible to set the list of CiviCRM components from the command line using drush

Thanks to passing JSON objects to drush cvapi I found a solution:

echo '{"enable_components" :["CiviContribute","CiviMember","CiviMail","CiviReport","CiviEvent"] }' | drush cvapi Setting.create --in=json


The action Remove contact from group not working in Civirules

Updating the latest version of CiviRules will fix this. This bug has been fixed two weeks ago.


Is it possible to have an updateable log for an event?

What about using activities and a contact for the shelter?
Each activity would be an entry, you can use activity types, so it might make it easier to get some analysis on the log.

There isn't any direct link between the log and the event, but you can filter by date and get the activities linked to a specific event (night).

you could write an extension to change the layout of the event backoffice and provide a filtered view.


Posting photos on our DONATE/ contribution page through Civi

In my experience the best option is to give the image a width of 100% or at least use media queries to set the width at 100% for mobile


civiCase emails don't use case tokens?? Print/merge does? What am I doing wrong?

When sending email via email activity only contact tokens are supported. If you have Civicase token extension installed and enabled than you can pass caseid=34 (where 34 is case id) in activity email url

eg http://example.org/civicrm/activity/email/add?atype=3&action=add&reset=1&context=standalone&caseid=34


Newsletters only display plain text, not HTML

We believe it was a problem with file permissions in sites/default/files/civicrm/templates_c applied after the last security update.


Customers Recieving Error Code on Renewal

It sounds like an Auth.net password issue. Check this out from their support page on the 103 error:

  This error is generated when your Authorize.Net account is in
  Password-Required Mode and you are not sending a valid Transaction Key
  or hash fingerprint with your transaction request.

https://support.authorize.net/authkb/index%3Fpage%3Dcontent%26id%3DA852


Group not displayed in "Recipients" field in a mailing after selecting it

our awesome developer resolved this as described here: https://issues.civicrm.org/jira/browse/CRM-21780


Civcrm Refund - why are amount and fin. type are based on (priceset) rather than line_item?

Your modification is almost certainly correct.

Line items are an area of the code that was traditionally weak, but have come a long way in the last year.  My recommendation is to submit a bug report on issues.civicrm.org, and your patch on Github.  The review process means that this question will be answered by the financial experts. Financial improvements are generally reviewed pretty quickly.


You missed a param to that function. The 4th param is attributes, which you can pass as an empty array, and the 5th param is required, which you can pass TRUE.


How can I set up registration and payment for an ongoing event that happens every saturday

This question has a lot of aspects. I will focus on the fact that the fee is based on the household. Does it mean that the household is your actual customer and that you are not interested in the details of the participant? And you only want to prevent that the event is overbooked? If this is the case you can use Price Fields.

Create as part of a Price Set a Price Field set a Text/Numeric Quantity field (in my example Seats).
Enter the participant count, make this 1 (see (1)).
Set the price on 0.00 (this field is only used to track participants see (2)).
Uncheck the Display Amount option.

Now in the online registration form you can enter a number in the Seats field and this will add up to the total number of participants.


Where is the 'Recent Items' block in Drupal 8

Oops.
I have just found out how to insert a Block in D8 - you have to click a button to get the list, rather than scrolling down as on D7.  The CiviCRM stuff is there OK.


Bonjour!

CiviCRM en Francais:

https://civicrm.org/partners-contributors?country_1=All&services=All&language=fr&cms=All
https://www.civicrmfr.org/


How do I create a new Webform in Drupal 8?

Right! In D8 -> look under Structure -> Webforms

/admin/structure/webform


Sorry for the too terse explanation you received on the other answer, using a shortform that experts are used to. If you are running a Drupal site, example.com, then to rebuild your triggers navigate in your browser (by pasting in the url) to http://example.com/civicrm/menu/rebuild?reset=1&triggerRebuild=1 , for WordPress it is http://example.com/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fmenu%2Frebuild%3Freset%3D1&triggerRebuild=1 , and for Joomla it is https://example.com/administrator/?option=com_civicrm&task=civicrm/menu/rebuild?reset=1&triggerRebuild=1.

Without a reference to your earlier question, I'm not sure which version of CiviCRM you are running. FWIW, I think this fixup may have changed in recent versions.

Make sure you have admin CiviCRM permissions.


Change order of custom profile fields on Drupal register page

You need to use a hook_form_alter function in Drupal to accomplish this. In doing so, you can modify the weight of the items to appear below the existing form items.

function yourmod_form_alter(&$form, &$form_state, $formID) {
  if (($formID == 'user_register_form')) {
    $form['civicrm-profile-register']['#weight'] = somevalue;
  }
}


CiviCRM URL issue: CiviCRM theme is not loading after CiviCRM update to 5.26.1 version

can you add below lines in your civicrm.settings.php?
global $civicrm_paths;
$civicrm_paths['civicrm.root']['url'] = CIVICRM_UF_BASEURL . '/sites/all/modules/civicrm';


Point 1 is probably not the part, that just reads from the array $rows. I think you have to go to CRM/Case/Form/CaseView.tpl and change the 10 in here to 100:

  oTable = cj('#activities-selector').dataTable({
    "bFilter"    : false,
    "bAutoWidth" : false,
    "aaSorting"  : [],
    "aoColumns"  : columns,
    "bProcessing": true,
    "bJQueryUI": true,
    "asStripClasses" : [ "odd-row", "even-row" ],
    "sPaginationType": "full_numbers",
    "sDom"       : '<"crm-datatable-pager-top"lfp>rt<"crm-datatable-pager-bottom"ip>',
    "bServerSide": true,
    "sAjaxSource": sourceUrl,
    "iDisplayLength": 10,
    "fnDrawCallback": function() { setSelectorClass(); },
    "fnServerData": function ( sSource, aoData, fnCallback ) {

      if ( filterSearch ) {
        var activity_deleted = 0;
        if ( cj("#activity_deleted:checked").val() == 1 ) {
          activity_deleted = 1;
        }
        aoData.push(
          {name:'status_id', value: cj("select#status_id").val()},
          {name:'activity_type_id', value: cj("select#activity_type_filter_id").val()},
          {name:'activity_date_low', value: cj("#activity_date_low").val()},
          {name:'activity_date_high', value: cj("#activity_date_high").val() },
          {name:'activity_deleted', value: activity_deleted }
        );
      }
      cj.ajax( {
        "dataType": 'json',
        "type": "POST",
        "url": sSource,
        "data": aoData,
        "success": fnCallback
      } );

But try! And it is best to modify this in an extension. The same for number two, identify the button and hiding it in a specific template which you add with a combination of buildForm or pageRun hook and CRM_Core_Region like so:

CRM_Core_Region::instance('page-body')->add(array(
    'template' => 'yourtemplate.tpl'


Yes, it's a know limitation. The language used is the language of the cron job. If you manually launch the scheduled task with the proper language, you should be able to send in the proper language.

The way we intend to solve it is to add some option to tell in which language we want the mailing to be send - cf. https://issues.civicrm.org/jira/browse/CRM-16352


Allow only existing CiviCRM contacts to create own Drupal account

A couple of thoughts.

If you want this to be a response to an action - eg you folk send out a mailing - then you can do this via a webform - send out a link with checksum to a webform and upon submitting the webform you can trigger Drupal Rules (we usually do this by giving them a civicrm Tag) and this can also instantly log them in

If you want to do this as a self-service then I would probably be adding a wee form for folk to say 'send me a login link', they enter their email, it sends them a checksum and then you do the above approach of another webform.


I like CiviHoneypot myself, especially on contribution pages.


Is there a way to prevent USPS address standardization from making addresses all caps in PDF letters?

The problem is that the standard is to have addresses all-caps, without punctuation, and with various standard abbreviations.  Some clients have asked us if we could "fix" them in bulk to be mixed case, but I point out that the standardization will simply restore the all-caps the next time someone saves the address.

Two options:

You can use Smarty to modify your addresses.  You'll first need to enable Smarty processing of mail templates.  Then you'll need to assign your token(s) to a variable and then output the variable with proper capitalization:

{capture assign=address}{contact.street_address}{/capture}{capture assign=city}{contact.city}{/capture}
{$address|capitalize:true:true}
{$city|capitalize:true:true}, {contact.state_province} {contact.postal_code}

This will work, though have fun training your coworkers on how to use Smarty.  Also, words with internal capital letters ("MacArthur Blvd") will come out wrong ("Macarthur Blvd").

You still will be missing periods on your abbreviations no matter what, however.
You can use a different address standardization tool.  Most are paid, though at least one client has had luck with SmartyStreets giving them a free account because they're a charitable nonprofit.

With SmartyStreets, you can use the extension that my coworker Tyrell built to auto-suggest standard addresses as you type.  We haven't confirmed it works perfectly for 4.6 yet (it definitely supports 4.4 and 4.5, though), but I don't know of any problem spots.  If you encounter problems, please let us know.


If you're on Drupal - I recommend you use Webform CiviCRM module - https://www.drupal.org/project/webform_civicrm - It will let you built a cart (multiple Events, fee-options, discount codes, etc) and leverage all native Drupal Webform options (like Conditionals) to build your fees without requiring any code.

If your CiviCRM is not attached to Drupal - then your options are to either help fund improvements [contact the Core Team - they have a paid Issue queue https://civicrm.org/paid-issue-queue ] or get on Mattermost chat.civicrm.org - to see if you can team up with developers/other orgs that are interested in improving the native CiviCRM Cart Checkout.


First check the default collation. If it's different it may be causing implicit conversion:

show variables like 'collat%';

If that's not it then note that individual columns can have their own collation. It seems unlikely to be the problem here given that particular reports query, but check the individual column definitions, e.g.

show create table civicrm_report_instance;


It appears that you're using CiviCRM in a multisite configuration.  You may want to update this question and future questions to reflect that.  Relatively few folks use it, and it affects the answer to this question.

In short - you don't normally need a parent group, but with multisite, you do.  There's details on why here.


On a contribution page, it is possible to set the 'recurring' to 'offer installments: "Give the user a choice of installments (e.g. donate every month for 6 months)? If not, recurring donations will continue indefinitely." That may be one place you could look at doing a minor customisation so that rather than 'offering' the number, you specify it and hide it.


What else is needed to create new tab for content in extension?

As the example says, "you would create a url which would return an html snippet".

Since this is in the context of a CiviCRM extension, please see the Civix documentation for how to create a basic page.

The url of your tab should be whatever you decide the url of that page should be.


Donors are receiving multiple receipts with ACH contributions

I dug into the code:

Firstly, in my humble view, it could use splitting into separate functions. One function is almost 400 lines long, making investigation hard.

I think I've seen the problem though. If your version of civicrm is less than 4.7.12, it won't activate a lot of the logic for recurring contributions.

https://github.com/iATSPayments/com.iatspayments.civicrm/blob/a92dd620a8975469e65372b3e34c812e5130faa1/iats.php#L244

function _iats_civicrm_use_repeattransaction() {
  $version = CRM_Utils_System::version();
  return (version_compare($version, '4.7.12') < 0) ? FALSE : TRUE;
}

For example, line 1425, which decides if to use line 1448, which currently reads:

$complete['is_email_receipt'] = empty($options['is_email_receipt']) ? 0 : 1;
try {
  $contributionResult = civicrm_api3('contribution', 'completetransaction', $complete);
}

Update
Oh, and there are also two unmerged patches from solid contributors:
https://github.com/iATSPayments/com.iatspayments.civicrm/pulls


You can find the civicrm database listed in the civicrm.settings.php

 <wordpress>/wp-content/uploads/civicrm/civicrm.settings.php

Apart from that , you have two possibilities

1)Wordpress and Civicrm both use same database

2) Civicrm has    separate database

If wordpress and civicrm has same database , you can search in wordpress database tables which have prefix civicrm_*


Can you use Mosaico to create message templates

You can try the Mosaico Message Template Synchronisation extension.
From the README:

This extension enables you to use CiviCRM-Mosaico templates with scheduled reminders, personal messages, etc. It does this by automatically copying each template from Mosaico to a CiviCRM "Message Template".
When you install the extension, all existing MosaicoTemplates will be automatically copied to MessageTemplates.
When you create or update a MosaicoTemplate, the corresponding MessageTemplate will be updated.

There's a few gotchas/caveats to look out for - see README on branch issue/6 for fuller explanation about what happens with things like unsusbscribe links which don't apply to a log of message templates.


Unable to edit existing contributions after CiviCRM upgrade

Thanks to a couple of members, there is a patch in circulation to define decimals in place of the currency symbol that's causing the problem.
https://github.com/civicrm/civicrm-core/pull/19680/files


Why can't I see custom profile fields when I edit an event participant record

I figured it out. It was showing but the fields were collapsed.


error http 500 when clicking Contribute button

I don't believe that the error shown in the question is likely to be the one that triggers the error 500 for your registrants. Note that the backtrace shown starts with a CLI entry point civicrm_cli->callApi(), suggesting this has been triggered from system cron on the commandline, while your issue is reported as occurring via the web.

First, find the relevant error log.

If you are seeing error 500s, you need to understand what the fatal error was. This probably involves inspecting your webserver error logfiles. You can find these via the webserver (eg Apache / Nginx / ...) configuration, and you may also find there are separate logfiles for a separate PHP process.

The PHP error logs may be identified via phpinfo() (look for "error_log" setting). Webserver logs you'll need to ask your sysadmin or hosting provider. Bear in mind that a shared hosting provider may be reluctant to give access to logfiles which contain information from other sites, but you will need that information to resolve this issue without guesswork.

There should be a log entry made at the specific time you see the error in the browser. Don't accept any red herrings until you find out what this is, because it's essential to you finding the source of the problem.

If your hosting provider cannot help you track down CiviCRM errors, consider finding one who does: https://civicrm.org/partners


Relationships not available on household imports

We are having the same problem with relationship imports that have custom subtypes.  Our subtypes are Individual - Student and Organization - School.  The relationship is Student of (Student) - Student for (School).

The relationship does not show up for mapping during import.  My testing shows that it's the first part (a) that causes it not to show up.  If the (a) is changed to Individual it will show up, all other combinations do not.

I have also verified that this relationship does show up in 4.5.4.  This is the only 4.5.x version I could readily test with.  I have verified on the demo test as well.

I have created an issue: https://issues.civicrm.org/jira/browse/CRM-17544


How can I send a cc: of an Activity assignment e-mail to another user, as an FYI?

Functionally I am always confused about FYI mail. What is it supposed to do? As a receiver I am not supposed to do anything but I am supposed to read it just in case? I tend to just delete them if I can not identify any action, and I also tend to say so.

I assume you want to send the FYI email to a certain relationship contact (manager or something like that) and you have set up the relations in such a way?

If that is the case you might have a play with the CiviRules extension (read the blog at https://civicrm.org/blogs/erikhommel/extension-civirules-now-avaible-download-live-showcase-maf-norge for some background).

CiviRules allows you to setup specific actions (like sending a mail) based on a trigger (activity changed for example) checked against certain conditions (activity type is send email).

You will also need the Send Email API extension, can be found here https://civicrm.org/extensions/e-mail-api. I think this can help you to set up what you want, although you might have to develop (or get someone to develop for you) an additional condition.


DB Error: no such field afer civicrm_domain truncate

Try restore that one table from a mysql backup.

If you don't have a backup - then try populate the id, name, description, version, contact_id. Set config_backend, locales and locale_custom_strings to NULL (i.e. their default) - these will be regenerated - as you reconfigure your CiviCRM (settings, components, countries, currencies, etc). This is for a 4.6.x site


Is there a way to search for organizations that have no active relationships?

Search for organisation contact using advance search who have relationship. Add those contact into a smart group.
Now find contact using Include/Exclude custom search or search builder, with contacts not in above created smart group.


What you're asking for isn't possible without coding, unfortunately.  It's a major focus of CiviCRM 5.0 to be able to have user-definable forms in this way.

If you're a coder, or you can hire/borrow one, you can use hook_civicrm_searchColumns to change which fields show on the Contributions tab.  There's an example in this blog post.  Finally, I just uploaded an extension I wrote to Github, which replaces the Premium column on the contributions tab with info on soft credits: https://github.com/PalanteJon/coop.palantetech.showsoftcreditsinsummary


How can I make a Custom Search do an initial search?

Even i wanted an easy way of doing this as well but the current architecture of CiviCRM doesn't allow it automatically. I could achieve this by copying few functions(see below) from CRM_Core_Form_Search into my custom search file

  /**
   * @return array
   */
  public function getSearchFieldMetadata() {
    $searchFieldMetadata['contact'] = [
      'sort_name' => [
        'title' => ts('Sort Name'),
        'type' => CRM_Utils_Type::T_STRING,
      ]
    ];
    return $searchFieldMetadata;
  }

  /**
   * Get the validation rule to apply to a function.
   *
   * Alphanumeric is designed to always be safe & for now we just return
   * that but in future we can use tighter rules for types like int, bool etc.
   *
   * @param string $entity
   * @param string $fieldName
   *
   * @return string
   */
  protected function getValidationTypeForField($entity, $fieldName) {
    switch ($this->getSearchFieldMetadata()[$entity][$fieldName]['type']) {
      case CRM_Utils_Type::T_BOOLEAN:
        return 'Boolean';

      case CRM_Utils_Type::T_INT:
        return 'CommaSeparatedIntegers';

      case CRM_Utils_Type::T_DATE:
      case CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME:
        return 'Timestamp';

      default:
        return 'Alphanumeric';
    }
  }

  /**
   * Get the defaults for the entity for any fields described in metadata.
   *
   * @param string $entity
   *
   * @return array
   *
   * @throws \CRM_Core_Exception
   */
  protected function getEntityDefaults($entity) {
    $defaults = [];
    foreach (CRM_Utils_Array::value($entity, $this->getSearchFieldMetadata(), []) as $fieldName => $fieldSpec) {
      if (empty($_POST[$fieldName])) {
        $value = CRM_Utils_Request::retrieveValue($fieldName, $this->getValidationTypeForField($entity, $fieldName), NULL, NULL, 'GET');
        if ($value !== NULL) {
          $defaults[$fieldName] = $value;
        }
        if ($fieldSpec['type'] === CRM_Utils_Type::T_DATE || ($fieldSpec['type'] === CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME)) {
          $low = CRM_Utils_Request::retrieveValue($fieldName . '_low', 'Timestamp', NULL, NULL, 'GET');
          $high = CRM_Utils_Request::retrieveValue($fieldName . '_high', 'Timestamp', NULL, NULL, 'GET');
          if ($low !== NULL || $high !== NULL) {
            $defaults[$fieldName . '_relative'] = 0;
            $defaults[$fieldName . '_low'] = $low ? date('Y-m-d H:i:s', strtotime($low)) : NULL;
            $defaults[$fieldName . '_high'] = $high ? date('Y-m-d H:i:s', strtotime($high)) : NULL;
          }
          else {
            $relative = CRM_Utils_Request::retrieveValue($fieldName . '_relative', 'String', NULL, NULL, 'GET');
            if (!empty($relative) && isset(CRM_Core_OptionGroup::values('relative_date_filters')[$relative])) {
              $defaults[$fieldName . '_relative'] = $relative;
            }
          }
        }
      }
    }
    return $defaults;
  }

and added below snippet in my custom search file __construct() function(at the beginning)

    $this->_force = CRM_Utils_Request::retrieve('force', 'Boolean');
    if ($this->_force) {
      foreach (array_keys($this->getSearchFieldMetadata()) as $entity) {
        $formValues = array_merge($this->getEntityDefaults($entity), $formValues);
      }
    }

HTH

Pradeep


set standard recurring unit on contribution site

The recurring configuration is present on contribution page under amount tab. There you can select the units that you want user to select when doing donation or payment.
The units supported by Civi are Year, Month, Week and Day
Doc: https://docs.civicrm.org/user/en/latest/contributions/online-contributions/#amounts-tab


Is there a problem with the REST interface on CiviCRM API?

In the end, I was only able to make it work by using array notation. Some examples below. All these worked in the array notation on the right, but not in the object notation on the left:
"options": {"limit":"100","offset":"100"}  --->  "options[limit]": "1","options[offset]": "100""custom_1": {"IS NOT NULL":"1"}  --->  "custom_1[IS NOT NULL]": "1""custom_1": {"LIKE": "%stringtosearch%}  --->  "custom_1[LIKE]":"%stringtosearch%"So in my case my json payload looked like this:

json = {
      "return": "id,custom_116,custom_16",
      "custom_16[IS NOT NULL]": "1",
      "custom_15[<>]": "",
      "options[limit]": "50",
      "options[offset]": "50",
      "options[sort]": "id"
    }

Next task is to work out how to convert the OR option into array notation:"options":{"or":[["custom_15","custom_16"]]}  ---> ???


No, it is planned for 4.8, but could use some help (with funding or investigating issues).

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


Clearing A Report - Contribution Summary

What you have written doesn't make sense to me as when I click on a name in the contribution detail report I am taken through to the contact's record not to a somewhere I can tweak report settings.

You also haven't stated what verion of CiviCRM you are using. The report UI changed dramatically in 4.6 so if you are using a version early than that these instruction won't apply.

Those aside, go to Administer > Civireport > Create new Report from template and select the contribution details report. Filter on the name of one of the board members and tweak the settings to show what you want.

Once you are happy with report, open the title and format tab to give you new report a name and then go to the Access tab to choose where to put in the navigation menu and control access if needed. Then click on the  Create Report button.

You now have a new report instance where changing the name filter will give you an individual report for each board member.

Aside: CiviCRM likes to use names rather than contact ids to identify contacts, perhaps this was a conscious decision not to reduce people to numbers.


ContactReference custom field saves contact id, and that field has max 16 numbers.
But when CiviCRM prepares Contact to export, that contact id(max 16 numbers)
transforms to contact's display name(more than 16 chars).
When CiviCRM tries to insert(to temporary table) more than 16 chars to field(with max length 16 chars)
then it slices that field.

This issue can be hot fixed in CiviCRM Core.
1. Find civicrm/CRM/Export/BAO/ExportProcessor.php file;
2. Find getSqlColumnDefinition method;
3. Replace varchar(16) to varchar(255).

CiviCRM Core need to add new condition: if is Custom Field with type ContactReference then use varchar(255) instead of  varchar(16).


Change Household contact to Organization contact

It turns out that exporting the problem household contacts and then importing them as organization contacts, using the appropriate field mappings, is the fastest way to do this. After import just delete the household contacts.


It is an error to do with the menu configuration. It should definitely not be there it will not stop CiviRules from executing your action. So the error lies somewhere else.


I first cleared out the cache (templates_c directory) without success. I then went into the control panel and removed the mapping and geocoding providers (I was using OpenStreet maps and Yahoo). This seems to have fixed the problem.

I think the problem is with the Yahoo api being deprecated. Yahoo has taken down http://local.yahooapis.com/MapsService/V1/geocode


Inline editing of website field deletes it

Michael,

Have logged an issue for this here and have also provided a fix for this issue. Can you please apply patch from here and test if it solves your problem? Also please try to comment on PR if the patch works for you. This will fasten process of merging PR into core so that it can be available in next release.

HTH

Pradeep


CiviRules Action to add tags not working

Welcome to SE. I think this may be a bug with Civirules 2.21, where something has obviously changed as I now see the action "Add Tag to entity" rather than "Add Tag to contact which was in 2.20. I also don't get offered any tags to select. I'm guessing you may have an older version on your Drupal site. Nothing in the release notes (https://lab.civicrm.org/extensions/civirules/-/releases) suggests this change so I suggest that you contact the email addresses in the documentation (https://docs.civicrm.org/civirules/en/latest/)
I'm on an older version of WordPress 2.26.2 but I don't think that will make any difference.


List activity for all members (whether they have contributed or not)

How comfortable are you with Excel? If you do your contribution aggregate and check the box for Contact ID as a column and then export the results, and then also do an export of all your members and also include contact id, then you can use excel to merge the two lists based on contact id.

Also unless you need the relationship you can also look at Search - Custom Searches - Contribution Aggregate which should be the same thing just in a less spread out format which would make it easier to work with in excel.


API csv Import GUI with Formprocessor fails with smarty errors

CSV Import and Form Processor IS a powerful combo!  Check out the advimportformprocessor extension.
Note that this combines the "advimport" extension rather than the CSV API GUI extension with Form Processor.  It's overall better, but some work on advimport's rough edges would improve the UX.
Also note that Form Processor is pretty slow, so imports using this technique should account for that.


There is the current situation with CiviMobile app and WordPress:

New CiviMobileAPI extension(https://civicrm.org/extensions/civimobileapi) is platform independent and works for all CMS Drupal/Joomla/WP.
But, there is an issue in standard CiviCRM API for WP. This issue prevents our extension to use API properly.
We proposed a quick fix for this problem. Our fix was rejected by the Core Team. And they started wider discussion in few threads. Please start reading here https://github.com/civicrm/civicrm-core/pull/12813#issuecomment-428152827

As now, we are still working on quick API patch for WP. I hope it will be available in the next few days. I will let you know as soon as it is ready.

As a long-term solution, we need a permanent fix which will be approved by the Core Team and included into standard CiviCRM code (see the issue above).

Thank you,
 Sergiy


check out this very detailed answer on a different SE site by Chris:

https://drupal.stackexchange.com/questions/136722/drupal-7-cron-does-not-run-civicrm-scheduled-jobs


Thanks for reporting this.

From the error message it seems that some CiviCRM core changes made from 4.6 to 4.7 needs to be reflected in the extension code.

We will start looking into this. Please post the ticket in our extension Github: https://github.com/compucorp/civibooking and we will post responses regarding any update.

Best


Disable automatic activity email to assignee

Go to Administer -> Customize Data and Screens -> Display Preferences

Uncheck the "Notify Activity Assignees" box


Reproduce CiviCRM configuration: best practice

That's a good question that should have a canonical answer but doesn't.
Here's a recent similar question and answer: method for versioning configuration of civicrm?
I suspect there are other good references out there, please add them here.
Part of the challenge, which is not unique to CiviCRM, is that the definition of "configuration" can be grey in some areas.
Here is a list of tools and techniques that can capture and copy some parts of commonly considered "configuration":
1: The civicrm_domain and civicrm_setting tables.
You can back up these two tables and then restore them to a different site. This is a hack and could get you in trouble, but worth trying. Between the two of them, you've got most of the core "settings" type values.
2: Build your own extension to save your custom fields.
The instructions for building your own extension using civix show you how to generate an extension that saves the configuration of your custom fields.
3: civicrm_report_instance table
This can be backed up and restored on it's own, it's fairly safe.
4: civicrm_extension table
This is the list of installed extensions with configuration. You'll need to also have the matching extension directory.
5.1: Extension: org.civicoop.configitems

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

This extension allows you to export some site configuration to JSON, which you can package as a related custom extension for your site. (See also Jaap's answer on this question.)
5.2: Extension: CiviConfigure (eu.tttp.setting)
There's an extension which appears to be designed to solve this problem for settings (may not handle eg Contribution Pages which are entities?), but it's out of date, here:

https://civicrm.org/extensions/civiconfigure
https://github.com/eileenmcnaughton/eu.tttp.setting

5.3: CiviCRM Config Export (nz.co.fuzion.configexport)
Imports/exports config & entities to YML.

https://github.com/fuzionnz/civicrm-configexport

6 bin/csv/export.php
A script you can use to export option values and tags and such. Assembly requied.
7: API
You can use the api to retrieve and set various entities, e.g. using the cv tool.
8: CiviCase specific
For CiviCase, one of the original arguments for using external files was for versioning and managing dev/production. You can still use xml files for its config.
...
I've left this as an open community wiki and encourage others to add to this list.


Error in CiviCRM for Drupal7 after Migrate from "Backup and Migrate" module on New Contact Form

I figured out what happened. When I did the backup and migrate, Drupal set civicrm_tag.used_for to NULL. I set the field for all my tags to 'civicrm_contact' and it fixed the problem. No more errors. I just ran this query:
UPDATE civicrm_tag SET used_for='civicrm_contact';


I believe that the "fetchmail" approach outlined by Chris Burgess on this answer is a good troubleshooting step.


Event Registration - Empty Session object when not logged in

After debugging and debugging and searching and searching I called Bluehost.  We are on a VPS customized for Wordpress sites that has a "feature" called Varnish Cache.  The first thing the guy did was disable this "feature" and voila, my sessions were no longer being destroyed.

Hope this helps someone!


Yes, you need to use the Search builder : Menu search -> Search builder.

Then you can choose the record type, the field and most important the operator : you have empty or is null (not defined) which should work for your need.


This seems to have been worked on, here
https://issues.civicrm.org/jira/browse/CRM-18027


How to fix it? By pressing "Print Summary", there are extra 2 blank pages printed

I have added some pictures to show the problem.


How to Integrate Web form with Wordpress?

the Drupal page you screenshot is a Profile as you can see in the URL. To find out how to display a Profile as a public form on a WordPress site I recommend you refer to this Chapter and read the section called "Standalone forms with Profiles"


Strange behaviour with activity type in search builder

I was able to reproduce the behavior; it seems like a bug, can you post a bug report here:  https://issues.civicrm.org/jira/browse/CRM/?selectedTab=com.atlassian.jira.jira-projects-plugin:summary-panel


Impossible to Run Cron after civicrm-4.7.14-wordpress update

When updating civicrm, I've always found the need to update the permissions in root/wp-content/plugins/civicrm/civicrm/bin/cron.php (or cli.php) to be executable.  Hope this solves your problem.


How can I include the number of relationships in a household in exported data for that household

Pete's answer is the only solution I can think of that doesn't require coding, but it's only an option for Drupal users.

If you're on Joomla/Wordpress, you'll need to code a solution, or hire someone to do so.  Create a custom field on the contact "number of relationships".  Create an extension with civix and use hook_civicrm_post on any relationship being created/updated/deleted; use an API call to getcount for relationships, and populate the number of relationships to your custom field.

If you know SQL but not PHP, an easier solution is to set up a cron job to fill in the custom field with a SQL statement that runs over the whole database.  I'm not sure if you can use an UPDATE statement with a GROUP BY though - so you might need to use a subselect, which is expensive.

The other SQL-centric option is to create a trigger to handle this.  You can be quick and dirty and drop it right into the database, or you can wrap it in a CiviCRM extension.  If you go the latter route, consider coding it into the "Summary Fields" extension: https://civicrm.org/extensions/summary-fields


How do I find individuals that are participants in multiple (two) events?

You could do it in multiple steps:

search for Event 1 participants then create a group
use advanced search, enter the new group in the group box, and in the events section select Event 2 participants

You could create both of those as smart groups if you want to check progress as registrations come in.

But hopefully someone has a more streamlined method!


Statement violates GTID consistency error when creatng new user account in Drupal

This came up before at https://lab.civicrm.org/dev/cloud-native/issues/9. You might want to ask in there.


Couldnot create an event in civicrm 4.7.20

As Jitendra says, this could be a bug that has already been resolved. If not, you may need to dig in to your ConfigAndLog to see more errors.


Using CiviCRM shortcode (wordpress) for a profile in a popup

I have had success with Popup Builder - the preview never works, but the embed on the page always works.  This is a popup overlay - which I assume is what you are looking for. The free version is great if you just want a popup on a page of your choosing - the paid version is great if you want the popup to come up on any page a first time visitor first sees.


Start with civix generate:page. Optionally assign some smarty variables in run() in the autogenerated php class and edit the autogenerated .tpl with your html.

Then you need to insert an entry in civicrm_dashboard that links the url you chose in generate:page. See the function addGettingStartedDashlet() in CRM/Upgrade/Incremental/php/FourSeven.php, just note the columns have changed slightly if you're on a later version.


How do I record a group donation in CiviContribute?

It's a good question, but every contribution must be tied to a contact.  The solution is to create a generic contact called "Group donations", and add the contribution to that contact.


How to hide configuration tabs of a report with the "print to pdf" action remaining active?

This seems to be a bug in CiviCRM. Below patch will allow anonymous user to Print report or Print PDF.

diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php
index 75a614c836..9acd75c584 100644
--- a/CRM/Report/Form.php
+++ b/CRM/Report/Form.php
@@ -2580,7 +2571,7 @@ WHERE cg.extends IN ('" . implode("','", $this->_customGroupExtends) . "') AND
     if (empty($this->_params) &&
       $this->_force
     ) {
-      $this->setParams($this->_formValues);
+      $this->setParams($this->_submitValues);
     }

     // hack to fix params when submitted from dashboard, CRM-8532
@@ -2588,7 +2579,7 @@ WHERE cg.extends IN ('" . implode("','", $this->_customGroupExtends) . "') AND
     // in dashboard mode for report
     //@todo - this could be done in the dashboard no we have a setter
     if (empty($this->_params['fields']) && !$this->_noFields) {
-      $this->setParams($this->_formValues);
+      $this->setParams($this->_submitValues);
     }

Not sure what is the difference between formvalues and submitvalues even though params are considered from submit values for processing.

HTH

Pradeep


Display: is it possible yet to collapse a set of non-custom data?

The easiest one would be with css. But that would not be collapsing them, that would be hiding them. You just get the id's of the fields and hide them. If they are not required that just works.
The 2nd easiest one would be with creating .extra.tpl files and doing it with jquery: https://civicrm.org/blogs/dave-greenberg/now-its-easier-add-custom-behaviors-templates. With jquery you should be able to make a collapsible fieldset.
The most robust one would be with a custom extension and share with all of us on github http://wiki.civicrm.org/confluence/display/CRMDOC/Create+an+Extension


You will not be able to do that with the GUI since it lists the matched pairs but does not allow to export it in a configurable way.

Your best bet will be to use the API (that means programming in PHP), and specifically the entity Contact, action duplicatecheck. Here is a sample code:

$result = civicrm_api3('Contact', 'duplicatecheck', array(
  'sequential' => 1,
  'dedupe_rule_id' => 4,
));

This will return a list of matched contact pairs with the dedupe rule 4.


Since you have a different participant limit, its really a distinct event and you should treat it that way by creating a second event.  Yes your participants have to register twice but then you'll have a much nicer record of which day they attended (and all the benefits of automated reminders as well).

With the two-event configuration you can offer registrants of the first event a special discount for the second - just include the discount code in the confirmation email. You'll need to configure your discount codes carefully to activate and de-activate at the correct time. As a bonus, include a checksum link to the registration page, then the registrant won't have to re-enter all their information.


Path problem for webhooks and other internal resources

This Question is related.
Extensions will read the path and URL so going through the steps in taht question should help.
You will need to update the stripe webhook as well.


Any way to limit geocoding to city or zip?

Sorry no, You will need to create a custom geocoder.

Creating a custom geocoder should be as easy as copying the current one you want to imitate, renaming it (to avoid confusion and keeping things clear for your successors) and dropping it in your custom php directory in CRM/Utils/Geocode/ (since u dont want to modify the core directories)


Is it correct that saving an address with only Country should fail to save data?

if you have a default country and that you save an address with only that country, it assumes it's not that the user chose this country, but just that the default was left selected.

So it's normal behaviour, but might not be what you want indeed.


CiviCRM API and checking if a custom field is empty rather than not null

The answer depends on how you call the API: is this from php or via the ajax or rest interface?

in php, both null and empty string are seen as a boolean false, so

if (!$custom_42)
   echo "it's either null or empty string"

As for why custom fields behave this way: each custom field belong to a custom group that is stored in a table. if you don't have any of the custom fields in that group, the row isn't created, so all the fields are null, but as soon as you set one of the fields, it creates a row, and the default value of each of the other empty fields depends of their type.

That custom fields that are string become "" instead of null is arguable and it would seem more coherent they stay the same, but as both are seen as false in php (and other languages have the same conversion rules) probably not a big issue.


List all Profiles in a group when using "Profile Search Form" as a Joomla menu item

It looks like force=1 url searching works for profiles too, so just provide a menu link to the page with force=1 on the end of the url, e.g. https://your.site/civicrm/profile?gid=1&reset=1&force=1
See https://docs.civicrm.org/user/en/latest/the-user-interface/searching-url-support/


How do I configure the new recurring contribution feature in Webform CiviCRM module?

Example 1: Give user option to pay for Event Registration either right now - or in monthly installments

Scenario: Parent (Primary Contact) signs up Child for Swim Club. Give the Parent the option to pay all Fees right now - or in Installments.

1a) set up the fields in the new Recurring Contribution section in the CiviCRM tab. In order for webform_civicrm module to set up a Recurring Contribution two elements are required: Number of Installments and their Frequency.

1b) configure the webform fields: I've added a select / checkbox so the User can indicate if they wish to pay all now - or in 10 installments. There is a Conditional that if checked Yes -> shows the Number of Installments field; That field is disabled and hidden.

1c) Event registration for Child: Child is registered as a Participant we see the first Payment.

1d) the Primary Contact's record contains the first Contribution in this Series

1e) the Primary Contact's record contains the Recurring Contribution Series - details.

Note
even though the monthly contributions will process as specified, subsequent installments don't (yet) get associated with/credited to the Event registration. CiviCRM Core can't (yet) associate a Recurring series with an Event registration.


How do I add additional information to a contribution page? PROFILE OPTION NOT WORKING

I had this problem last month and also posted my question on Stack Exchange - though I realize that most people who looked at my question and yours wouldn't think they were the same!  Check it out: Backbone isn't loading on Civi 4.6.11/WP 4.4.1

If you pull up your Developer Console (press F12 in your web browser when viewing this page, then check the "Console" tab, you should see the same errors I reference in my question.  If so, the answer is the same.

In less-technical terms - CiviCRM uses a pre-built package called "Backbone" to build the profiles on the page you're viewing.  Some Wordpress themes also use Backbone, and sometimes they conflict, which causes what you're seeing.  If you switch to a theme without this problem (for instance, the twentyfifteen theme), you should see the problem go away.

To fix my problem, you can use a different theme, or you can try to hack your theme.  I took the latter route; I created a child theme (there's lots of Wordpress documentation on that), and I overrode the objectionable code with my own code.


Is it OK to switch to PHP 7.2 now that Drupal 7.6.1 supports it?

The latest versions of CiviCRM run fine with PHP 7.2.  However, a) this has only been true a few months, b) Drupal 7 has only very recently become 7.2-compatible, c) most major Linux distributions don't ship with 7.2 by default.  I'd say those three factors account for few sites running it.

Note that as of CiviCRM 5.8.0, known PHP 7.2 import issues have been fixed.  CiviCRM 5.9.0 will handle the other known PHP 7.2 issue, which only occurs on certain types of reports.


This is an interesting use case!  I can see the advantages over the approval workflow.

If I were asked to do this, I'd probably:

Create a custom field "approval code" on the event;
Use hook_civicrm_buildForm and jQuery to hide the page except for an approval code submission field;
When the entered code matches the stored value, show the page.

This isn't completely foolproof if you rely too much on client-side jQuery though.

If you decide to go the price-set route, you might want to use CiviDiscount instead.  The "discount" code can be the approval code.


Like CiviCRM, its extensions are currently without any upfront or ongoing licensing fees. People are free to offer paid extensions, but I am not aware of them.

You are free to use, modify and share the code. If you benefit from Free and Open Source Software (FOSS), you are encouraged to contribute back to the community.


DB Error: IP address hard-wired with MySQL user?

Try SHOW TRIGGERS; Also when you say you searched the database, are you searching a mysqldump? Triggers would be in a dump by default so you should see them there. How are you are mirroring the database?


A warning like Cannot redeclare class CRM_Core_ClassLoader can indicate that all is not good in the civicrm.settings.php file, such as incorrect paths. not quite the same warning you have but may be a useful pointer


Received the following error after creating contibution in backend

One or more of the required field for contribution or a custom field related to contribution which is a required field value maybe missing. I would look in there first.


Form Submissions Overwriting Existing Contacts

Thanks for everyone's input. It was a very odd matching rule, one that matched on last name with length = 1, weight = 1. I will see when this was added to the site.


How to set the main email account to send emails?

it seems that there's a kind of delay for scheduled reminders because now all emails are sent from the right smtp account.


How to remove "Report URL" from emailed PDF reports header?

It seems to be hardcoded (https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Form.php#L3405), but you could use hook_civicrm_alterMailParams and do something like (untested - you might have to adjust the regex):

if ($params['groupName'] == 'Report Email Sender') {
  $params['html'] = preg_replace('/^Report URL.*$/', '', $params['html']);
}

Another option which is maybe simpler is just completely replace the html in the hook, if you don't really need the other text either:

if ($params['groupName'] == 'Report Email Sender') {
  $params['html'] = 'Insert your own html';
}


Navigate to CiviCRM -> Administer -> System Settings -> CMS Database Integration:

Copy all of that... into the Drupal settings.php file for your site!


Since I'm not allowed to comment (what's up with that?), I'll ask for clarification here.

What results are you expecting for each type?
What do you mean by the 'Bio' field? Can you post a link?


l10n Translations does not show in settings

Can you check:

Go to Administer > System Settings > Option Groups
Then search for "Languages" and click on its "Options" link.
Double-check that the language is enabled.

Otherwise, it might be a file permission issue: can you check to make sure that the web server has permission to read the l10n directory and files?


How to get contact id of logged-in user in JS API

In case of an angular page use something like

function myext_civicrm_angularModules(&$angularModule) {
  [...]
  $session =& CRM_Core_Session::singleton();
  drupal_add_js(array('CurrentCiviUid' => $session->get('userID')), 'setting');
  [...]
}

and access it in JS:

var uid = Drupal.settings.CurrentCiviUid;


can't sort search result table by column when the column shows a custom field

For 5.15.1 you can add these lines just before line 6373 in CRM/Contact/BAO/Query.php.

if (empty($fieldSpec['bao'])) {
  continue;
}

There will also be a similar workaround put into 5.18.2 when it is released. https://github.com/civicrm/civicrm-core/pull/15454


Who can develop payment processor for Bank of America Merchant Services

You can commission an extension, using the Core-Team or a Partner/Contributor. I suggest you set up a issue in the issue tracker first to see if the Core Team can give you an estimate.

You should also look at the other payment processor extensions, the folks who wrote them are most likely to be able do another, they should also be rewarded for their previously contributed code, by getting new work.

Resource on how to create a Payment Processor Extension


Membership form that also allows for just a donation to be made

Do the following :

menu Contribution -> Manage Contributions Pages
configure -> Memberships Settings
at the bottom, there should be a checkbox "Separate Membership Payment".

Confirm that it is checked or not.
In doubt, don't check this box because i think not all gateway support it. You can at least give it a try.


How to enable email sending in CiviRules

You should try to clear CiviCRM's cache as mentioned in CiviRules' documentation :

  If you add your action as a a managed entity (which we think is a good idea) you will obviously have to do a {yoursite}/civicrm/clearcache to make sure the new managed entity is available.

Cheers,
Olivier;


Anonymous users cannot register for a civievent

When you create an Event you specify what Profiles should show eg at http://d46.demo.civicrm.org/civicrm/event/manage/registration?reset=1&action=update&id=3 you can see it has Include Profile = Your Registration Info.

In this case it sounds like you have some other Profiles in use (instead or as well)

And either those Profiles are "not configured to be used for 'Profile' listings in its Settings" - which is what your error says - or the Profile might have incompatible fields included in it.


What is the best place to update Wordpress user on Contact change

I believe you are looking for something like this:

CiviCRM WordPress Profile Sync

  The CiviCRM WordPress Profile Sync plugin keeps the "First Name", "Last Name", "Email Address" and "Website" fields of a WordPress (and BuddyPress) user profile in sync with the corresponding fields of a CiviCRM contact. The synchronisation takes place regardless of whether the changes are made in WordPress, BuddyPress or CiviCRM.

I guess you could extend that plugin if you want to include CiviCRM custom fileds.

Hope that helps.


Importing without changing primary address

I don't know if there's a way to handle this through the User Interface. I added a function into a custom extension, which seems to solve the issue:

function myext_civicrm_pre($op, $objectName, $objectId, &$params) {
  if ($objectName == 'Address' && ($op == 'create' || $op == 'edit')) {
    if ($_SERVER['REQUEST_URI'] == '/civicrm/import/contact') {
      unset($params['is_primary']);
    }
  }
}


How to exclude a specific link from a Mailing's statistics

I didn't know you could use webfonts remotely in emails (or, it hadn't occurred to me). Here are some ways you could approach this - pick one! (Or more.)

Modify the recorded data

The "visit" records are stored in DB table civicrm_mailing_event_trackable_url_open and the URLs themselves are in civicrm_mailing_trackable_url. By removing matching entries from civicrm_mailing_event_trackable_url_open you'll zero those numbers off the top of your report.

Don't remove the entries in civicrm_mailing_trackable_url or the redirects to webfonts will stop working, breaking the font in future views.

Modify the recorded data (automated)

Once you have the query for the above, you could add a "cleanup" job to remove clicks where the URL matches (say) /.*(css|woff)$/. This would mean your reports stay clean - but cleanup jobs are a "code smell" IMO, so it's not a great solution.

Change the email - embed the font

You could potentially base64 encode the webfont into the email (this should increase the number of people seeing it in the correct font). That would remove the remote request entirely, but it won't work for an email that has flown!

Change the email - don't use a font

It's an option ... obviously you went to some effort to put a font in, but I'll include this for completeness :)

Exclude .(woff|css) URLs from your reports

You could add an extension which excludes these types of URLs from display in the reports. This feels like a bad approach (you still end up tracking those URLs, slowing down the email, and filling your DB with data you don't need - but then hide the data from your report). But it's possible and might be less work than getting a fix into core, so again ... for completeness.

Modify CiviCRM - only track clickable URLs

It seems like CiviCRM is tracking any URL pattern, which suggests civicrm looked for something like /['"]https?://(.*)['"]/ - but could perhaps only be looking for links. You could gather some data on this to file a feature request.

Does CiviCRM add link tracking to all URLs in emails, or just some?
Does CiviCRM add link tracking to <link href="style.css" rel="http://example.org/style.css"> but not <style type="text/css">@import http://example.org/style.css</style>? (Maybe it's the href= that confuses Civi?)
... ask lots of questions, propose an improvement, consider other use cases, help make it happen!


How to allow a user 'edit' on activities?

I fixed this problem by changing ACLs.  Originally the user was in role 'A' and the contact where they could create but not edit an activity was in group 'B' - and role 'A' had edit access to group 'B'. By changing the target contact to be in the same group as the 'A' role and giving that role 'edit' access to itself (its group) then they get edit access to activities.  As it happened, putting the target contact into this group is OK but this might not always be the case.  Seems like 'edit activities' should be a permission - this has been discussed before.


The fix to the file CRM/Utils/System/Joomla.php suggested in the link
https://github.com/civicrm/civicrm-core/pull/11062/files?diff=unified
made the cron jobs run again for CiviCRM 4.7.25 and Joomla 3.8.1.


CiviMail adding ?civiwp=CiviCRM to all links - causing links to be bad

You are correct.  That is a bug.  here is the report - https://lab.civicrm.org/dev/core/-/issues/1865
It's been fixed https://github.com/civicrm/civicrm-core/commit/bcbfa93e255ee15d9bd9e0f812b2a5a617458d73  and is planned for the next 5.27 release


How do I redirect back to the same tab after submitting a form?

I figured it out.

When creating the array for the tab, add "ajaxForm" to the "class" index.

$newTab = array(
  'title' => 'New Tab',
  'link' => 'url',
  'class' => 'ajaxForm', //<---- The important part
  //etc
);


Will Installing Updates in Civi and Drupal mess up my website?

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


On the demo, I'm able to get the automatic discount to work. But also see the Automatic Discount as empty. See attached.


Volunteer Report does not report on 'Role'

It looks like you've found a bug in CiviVolunteer, which I've been able to reproduce, but it's not with the report -- it's with the assignment.

If you assign the volunteer by dragging them from "Available Volunteers" to a volunteer opportunity, the role is erroneously not populated. You can see this by opening up the contact's record and inspecting the activity on the activity tab.

If you assign the volunteer using the magnifying class in the top right corner of the volunteer opportunity, the role is populated as when you use the API. You can validate this by opening up the contact's record and inspecting the activity on the activity tab.


Welcome to stack exchange. There are some other questions that may provide you with some answers. Before asking a question you should always do a search. Try searching for "export all data". Also it would be worth saying why you want to do this export. It seems an odd thing to do with a new site.

But to help you, "Export PRIMARY contact fields" is a particular set of fields chosen by someone else and rather general. If you choose "select fields for export, you can chose whatever you want. A bit tedious for all fields, but you can save the selection for later use.

Be aware that you can't export multi-value custom fields this way (though you can get a report to do this.


What table and column contain the date a contact was added?

You can use date_created on the civicrm_contact table.


Services from core contrib modules missing!!!! "The service xxxx has a dependency on a non-existent service xxx. " (with solution)

A contractor had added a directory called "webform" to modules/custom to add some custom configurations to webform. Which worked fine after updating webform module, until you cleared cache. Then Drupal blew up with the above error (similar from drush side) and I got puzzled silence on the call with them.

Turns out Drupal looks in custom first, for module directories, and ignores directories of the same name in contrib. When other stuff tried to reference services in the contrib module, drupal stopped looking for stuff in "webform" at the custom directory of the same name and died.

Hopefully this saves someone some time. Learn from our folly!

Changing the name custom/webform to custom/SITE_NAME_webform (with .info.yml etc name changes) fixed issue.

They're killing me.


You can install the Activity Type ACL extension to do this.


This is a problem, and your analysis seems to be correct

As this article suggest, another (more robust) option would be to track who clicks on all links, including hidden ones, and automatically remove the clicks from this user.

https://wordtothewise.com/2013/07/barracuda-filters-clicking-all-links/

X+


Our CMS is Expression Engine. Does this mean we can't use CiviCRM?

You would not be able to have direct interaction between Expression Engine and CiviCRM like Drupal, WordPress or Joomla allows, but you could certainly install CiviCRM on a subdomain of your current website along with one of those three and use it on the subdomain. See https://civicrm.stackexchange.com/a/9385/105 for some great thoughts regarding this.

If you had developer support (your own or hired) you could use CiviCRM's API to have certain information from CiviCRM available on your current website.


Payment Processor Error 9003, and logging

Answering (2) only here.

CiviCRM's payment processor logs vary in their location based on the CMS in use. These logfiles include a unique string per site, as the logfiles are  located within the webroot and a hard to guess filename offers some defense against attackers viewing debug output.

This is documented @ -

https://wiki.civicrm.org/confluence/display/CRMDOC/Debugging+for+developers#Debuggingfordevelopers-Logfiles
https://wiki.civicrm.org/confluence/display/CRMDOC/CMS+Standard+Directories+and+File+locations

WordPress

4.6 and below: wp-content/plugins/files/civicrm/ConfigAndLog/CiviCRM.HARDTOGUESS.log
4.7 and above: wp-content/uploads/civicrm/ConfigAndLog/CiviCRM.HARDTOGUESS.log

Joomla

media/com_civicrm/ConfigAndLog/CiviCRM.HARDTOGUESS.log (1) or
media/civicrm/ConfigAndLog/CiviCRM.HARDTOGUESS.log (2)

Drupal

sites/<sitedir>/files/civicrm/ConfigAndLog/CiviCRM.HARDTOGUESS.log


CiviRules Identify how many times a donor contributed in a given time period

This did work. I was thinking it was 10 or more times in the last 12 months, but it only works if there is exactly 10 contributions.


Is there a way to set up PCPs without the user having a login?

I've encountered this issue before - and found it easiest to go with allowing user registration.  I agree it'd be better if this wasn't necessary, but haven't found anyone willing to fund that improvement.

You haven't specified your CiviCRM version or CMS, which makes it a little more difficult to answer, but the general approach is to create a profile that you intend to use for PCP signup, go into Advanced Settings for that profile, and enable user registration there.  This will enable signup directly on the PCP page.

Note that if you're using Drupal, and you've disabled user registration altogether within Drupal, the user registration block won't appear on the profile.  I assume it's the same for Joomla/WP.

However, since you're enabling user registration, that also means that the default user registration page will also be enabled.  I like to use theming to break the normal user registration page - that will drastically cut down on the number of spam user registrations you'll see.


Since Drupal 7.4x I am unable to upload/browse images in civicrm

It turned out that our was a permission issue. I'm on Pantheon so I want able to change the permissions on the directory I was using, so I changed directories for uploads and it worked


Membership PayPal Renewal Redirect Too Many Times

It sounds like you've got a misconfiguration in your web server (Apache/nginx/etc.) configuration in your "rewrite rules".  You'll need to involve your web server administrator.

The easiest way to spot this is:

Go to the affected page.
Press "F12" to bring up Developer tools.
Select the "Network" tab.
Submit the form that causes the problem.

At this point, your Network tab should fill up with URLs it's trying to access.  My guess is it looks something like:

http://mysite.org/something/contribute
http://mysite.org/something/something/contribute
http://mysite.org/something/something/something/contribute
http://mysite.org/something/something/something/something/contribute

etc.

Compare that to your rewrite rules (if using Apache, be sure to check .htaccess files), looking for the "something" in your configuration.  That's the rule that's causing the issue.


Reality check: Can CiviCRM be implemented by a nondeveloper with limited time?

Good question.

In broad terms I'd agree with the answer from William, with some reservations. To answer your question: "Can CiviCRM be implemented by a nondeveloper with limited time?" I would say yes, and to do so will take some learning and a good deal of trial and error, so if time is limited, don't expect to be able to get up and running in a few hours.

I'd say that your skill set is really helpful, but you would need to plan to build on that.

You have a number of challenges there: not least getting the data you need out of your old system and into a new one.

You current hosting with GoDaddy is unlikely to be friendly to CiviCRM, so you need to plan to move to a better specified hosting platform that will give you fewer (and ideally no) issues.

And of course you'll need to get CiviCRM suitably configured and customised to meet the specific needs of your organisation.

Realistically, unless you are willing and able to put in a good chunk of time above and beyond what you have available, to learn  how to do all this and then do it for real, you are not going to get a result.

Your board president needs to get real - a project like this in any context demands substantial dedicated time and resources, and it sounds from what you've written that they have not considered this.

My advice would be to get some expertise in to do the following tasks:

Assess whether CiviCRM is the right product given your organisation's needs.
Assuming that it is, to sort out suitable hosting and get Civi installed.
Work with you to configure and customise Civi so that it works for your organisation.
Ensure that you, and ideally at least one other person within the organisation, know how to use CiviCRM, so that you can cascade that learning to others.

These are one-off tasks that it makes sense to outsource unless you've got a pile of time on your hands (which you don't). If your organisation doesn't have the resources to fund this work, then it needs to find those resources, otherwise I would say you have a recipe for disaster.

Hope this helps.


After upgrade to 5.0.1 - anonymous users can't see any events

I think I figured this out, but it still looks like a bug (sorry I won't probably won't be able to confirm right away and submit a JIRA issues). The Drupal "CiviEvent: Access CiviEvent" seems to need anonymous turned off or anonymous can't view. I had this set because I thought it was necessary, but it isn't for anonymous to view specific events, I think it means to view a listing of events. This still seems like a bug, but I'm glad it's at least working again.

This may also have been the cause for the API permission check failed: CiviEvents Fails after update to 4.7.19 and 4.7.20


Is there a report to export the transfers from CiviCRM to my bank account?

Amy, Welcome to SE world.

You can use contribution report or contribution search to list all the contribution recorded in CiviCRM based on Payment method used in one of your payment processor. For example if you are using PayPal and have payment method set to Credit card for the paypal payment processor then you can search on payment method in 'Credit card' and then export the results in a csv.

To get the list of payments associated with the contribution(s) you can use Find Payments extension to find the payments for payment method in 'Credit Card' and  then export the result into CSV.

HTH

Pradeep


not of type Boolean error message when testing Stripe in Test Mode

This issue has a ticket in Gitlab so you can follow updates there:
https://lab.civicrm.org/extensions/stripe/issues/53


after upgrade, can't edit Contact Details fields (Custom Addressee and de-selected subtypes errors)

I feel this issue is documented  and fixed at CRM-21180. You can try by applying patch or wait for 4.7.30 release.


symlink at sites/all/modules/civicrm doesn't work

It's how I do it, it works fine.

So you have (outside of the drupal folder) several folders civicrm-4.5.4 civicrm-4.6.2 ...

and (within the sites/all/modules create a single symlink civicrm -> the later civicrm-4.6.2)

The name doesn't matter, but as you will have urls that use it, I recommend keeping civicrm as the name of the symlink, and only keep a single one that you symlink with the civicrm version you want

then you upgrade normally using civicrm/upgrade and voila


Quick and dirty decoupled CiviCRM with cron and export/import?

I think I have a partial answer—or at least, a tool that's looking good.

Answering Demerit's comment: both the Backdrop/CiviCRM and D8/Open Social sites are going to have public pages. My original assumption was that D8 would be primary site, with CiviCRM information fed into it—but the last few days of deeper dives into CiviCRM indicates that so much functionality is available there "for free" that I'm likely to make that the primary site, with a secondary community.mydomain.org domain for the social networking aspects. There's just a ton of stuff I thought I would have to custom-build which someone has already included in core.

Still the case that I need a new user/CiviCRM account to create its equivalent on D8, and that single sign-on would be nice. Both domains are subdomains of mydomain.org, so I can tackle that with cookies, but since I have to do account creation anyway, a more elegant approach that allows new domains to be used would be nice (we currently own four). This YouTube video on data integration led me to Pentaho, which looks excellent both for its abstraction capabilities handling any dataset, as well as its scripting interface. Not seeing much point in going through the trouble of learning and implementing SAML if I can do it all in one package. (And for the initial release, there are few methods I could use to avoid all of this—i.e., creating a hash on the primary site that someone has to use to create an account on the second manually, and suggesting they log into both with the "remember me" checkbox turned on.)


What is the best way to change the intro on a Contribution page based on URL?

One way (if I understand correctly what you are after) would be to create a view that displays the node (or node's fields -- image, first_name, description) as you want it using a Block display for the view. Set up a contextual argument for the node's nid which provides a default value using PHP code and pull the appeal variable from the URL, something like this:

check_plain($_GET['appeal');

Then simply display this block at the top of the content region in your default theme for the civicrm/contribute/transact path.


Hi @Vijailakshmi AFAIK you can not set a default for an activity type subject without coding. If you do have some PHP skills it is fairly easy though :-) Let us know and we will detail what needs to be done.


You might check the mailing list itself, as we have seen mailings get stuck due to an improperly formatted/invalid email address on the list.  Another idea might be to split your list in half and send the mailing in two groups, in case the mailing size is an issue with your server.

Good luck,
Lesley


How can I automatically add a Capability or additional Role in WordPress based on the data stored in CiviCRM?

I'm not sure what "Groups Role Sync" is (I suspect it's a Drupal module) but you can use CiviCRM WordPress Member Sync to sync Contacts with Memberships to WordPress Users with Roles or Capabilities. FWIW, the plugin doesn't support Smart Groups either.


The group_name in <=v4.6 was deceptive -- in some circumstances, it provided namespacing, but it in others it didn't, so the safe play has always been to use some kind of name-prefixing.

If the setting names are prefixed, then do something like:

DELETE FROM civicrm_setting WHERE name LIKE "phonenumbervalidator_%"


Donations Made with False Name and Address using Paypal WPP

I am not certain what can be done to stop people 'testing' if stolen credit card details if that is what is happening. There is a blog about it and an old forum topic you might glean something from

And this SE question is where the conversation moved to.


I've seen this happen when there's a permission issue on the version-info-cache.json file that prevents the upgrader from properly deleting it.  The file can be found in your CiviCRM "Temporary Files Directory".

If you're not sure where to find your Temporary Files Directory, you can check at Administer menu » System Settings » Directories.  If there's a token (e.g. [civicrm.files]/upload), you can see the value of the token by pressing the "help" icon (see screenshot below).

Try deleting version-info-cache.json manually (e.g. via FTP or CPanel File Manager).  Then visit the Civi System Status Page (Administer menu » Administration Console » System Status) and the issue should clear up.

This file is also auto-deleted every three days - so if this seems like a lot, simply ignore it!


CiviVolunteer enabled but not showing in navigation

When a new Extension or Component is added you may find there are Permissions that need to be enabled, and that might be why you don't see it in the menu.

Alternatively go to Administer > Customise > Navigation Menu, check if it is in that list, if it is, but not showing, right click on it and 'save' and then you should see a new option on the screen that says "Click here to reload the page and see your changes in the menu bar above. " and that might be enough of a nudge.


Should new Scheduled Reminders (based on Activity Type = Email) send out to Emails created in the past?

I've run into this issue before -- setup a scheduled reminder to follow up after events, and had it sent for all past events.

Personally I think this is a bug, and that we should define a window of time that the reminder is restricted to, in order to limit how far into the past it processes records.


Here is the possible solution for this. Try running the sql queries through shell or phpmyadmin and than re-run the update indices.

Looking at the db error i can see civirm_entity_financial_account have duplicate rows. Please get rid of one row or all with entity_id = 0 as it doesn't make sense and then re-run update indices.

Delete civicrm_entity_financial_account where entity_id = 0 and entity_table = 'civicrm_financial_type';


Custom participant fields not showing for anonymous users on event registration page

I solved this by granting the Drupal permission "CiviCRM access all custom data" to the anonymous user role as per the documentation at the bottom of this page: http://book.civicrm.org/user/current/events/creating-an-event/

Note: this is a really freaky label on this permission. I find it very difficult to tick a box for anonymous users to "Access all custom data". What?


If this is a one off thing, you can run the Send Scheduled Mailings as a one off directly from the user interface from Administer >> System Settings >> Scheduled Jobs. Select More and then Execute Now against Send Scheduled Mailings.
I don't think that tinkering with the cron jobs to do this is a sensible way to do this, though it would work. Some environments (externally hosted) will not want cron jobs to run too frequently as it wastes resources. Personally, I would try and set the time for emails to fit the cron schedule.
I agree with Lars SG about the 11:48 entry. If you look back at the Log for the Send Scheduled Mailings job you will also see 09:48 (and I expect 10:48 at least depending on the frequency.


Fixed it by adding the token into a hyperlink

Edit: < a href="{contact.url}">{contact.url}< /a >

Surprisingly worked


How about prioritized locations in export

When you specify the address fields to export, if you specify the location "Primary" you'll get the address that's marked as the primary in the contact record. There's also an address location field you can export so you can tell which location was exported.

If you need something specific (use work if it exists, otherwise use home), I'd export both locations and use spreadsheet formulas to select one or the other.


How to split contribution page into tabs

With the standard CiviCRM contribution page I don't know if this is possible.
You can do this easily with Webform (on Drupal). Haven't tried yet but maybe Caldera forms (on WordPress) does the job.


Questions About Mailer Settings - Suggested G Suite settings?

Mailer Batch Limit: If I set this to 250 - Everytime the cron is run - up to 250 emails should be sent until entire mailing list is emailed - correct?

Yes

  Mailer Throttle Time: If I set this to 10,000,000 - an email will be sent every 10 seconds correct? That also means the mailer will be working until all the emails are sent.

No. It will carry on sending until the Mailer Batch limit is reached, or if no Mailer Batch limit is set, all emails have been delivered.

  Mailer Job Size: I have no clue what this means but since our list is under 1000 - I take it it does not apply to us.

This allows you to split the mail into smaller chunks that can be run in parallel.

  Mailer Cron Job Limit: If I have it set to 2 jobs, and a third job is scheduled to run while the other two are running, will it just queue that third job until one of the other jobs ends?

Yes, though that isn't really the point in this setting. You commonly see it used in conjunction with MailerJob size. Lets say you have a mailing that is to be sent to 100,000 addresses. You could split it into 100 Jobs of 1,000 and run 2 or more jobs in parallel if you like. Depending on what the limiting factor is, this may increase the rate at which you can send out mail. Which may or may not be a good thing for you :)

  Also - Is there any reason why I shouldn't use GSuite as my CiviMail provider?

Given the volume of email you mentioned, I am guessing you will be ok. There is nothing in the terms or service that would suggest you shouldn't be using it for your use case: https://support.google.com/a/answer/2956491?hl=en. As long as it can pass back bounce messages to CiviCRM (important if you do not want to be labelled as a spammer) you will probably be fine. Worth trying it out and reporting back at least.


They are custom fields, You should see them under Administer >> Customize Data and Screens >> Custom Fields


WordPress "Billing Name and Address" fields block not displaying

This site was hacked prior to me working on it. I ended up restoring a backed up version of the plugin folder and the "files" folder. Now everything is working fine.


Is there a way to hide certain transactions from general viewing?

There are a number of ways you could do your latter option.

A/  set up Groups of Contact for each Employee - then add the Contacts who they should see be able to see - then set up CiviCRM ACLs and remove the permission to View All Contacts - then they will only see those in their Group

B/ use the Permissioned Relationships extension and use this to supply the Access Control via civicrm Relationships


This has been fixed in 4.6.7. Please upgrade to the latest version or patch your site with this PR.