How to print selected/multiple Contact Profile "Print Summary"? I have around 1000 contacts and I want to print selected profile summary.
I found a "Print Summary" in Actions of the Contact profile page, but can only seem to print one summary at a time.
Is there a way to print multiple profile summaries at one time in the format the "Print Summary" prints or is a custom report going to be needed to print these summaries? And how to do it?

Thanks in advanced.

CiviCRM Version: 4.7.19
Wordpress Version: 4.7.5

This might be quicker/fewer clicks than totally manual printing when you are dealing with dozens or hundreds of contacts. Still not a great option, though.

Get a list of all the ContactIDs that you want to print.
Merge each CID into the appropriate "Print Summary" URL for your CMS. For Joomla, it is [domain]/administrator/?option=com_civicrm&task=civicrm/contact/view/print&reset=1&print=1&cid=xxxx
Put the list of merged URLs into your favorite text editor that creates automatic links, and click on each one.

Not really an answer to how to print multiple at once, but it might be a useful workflow for a non-programmer until a proper solution is devised.


Warning: count(): Parameter must be an array or an object that implements Countable I am not a php/SQL programmer. I upgraded our Wordpress site to WP 5.6.1 and now get this error:
Warning: Cannot modify header information - headers already sent by (output started at /home/rembrand/public_html/wordpress/wp-content/plugins/civicrm/civicrm/packages/DB.php:793) in /home/rembrand/public_html/wordpress/wp-admin/admin-header.php on line 9
if (!count($dsn)) {
return $parsed;
}
Warning appears at top of screen when I enter Wordpress admin dashboard for our website and edit any page.
How do I fix this?

It sounds like you're running PHP 7.2 or greater with a version of CiviCRM that doesn't support PHP 7.2+.  If you edit your question to include your CiviCRM version, that could help folks troubleshoot.  However, it sounds like you may need to upgrade your CiviCRM to a version that supports 7.2.


What's the recommended way to handle redirection after quickform submissions? I often find myself writing calls to CRM_Utils_Redirect in my postProcess methods.

But in core code I don't see this. I see the use of methods like $session->replaceUserContext and postProcess functions that end seemingly without telling me where to go next.

I feel like CiviCRM is often clever enough to go to load different pages on form submission based on where you came from. I have no solid proof of that but lets give Civi the benefit of the doubt on that one :)

I'm guessing there is a structure somewhere that is telling CiviCRM what page to load next but I have failed to spot what that is.

I'm interested in the canonical way that CiviCRM does this (if there is a canoncial way) and knowing how legacy that is, and also what I should be doing.

If anyone could enlighten me, I'd be grateful :)

PS. I am not so interested in "you should write that in angular" enlightenment, at least not in the answer to this question.

Here is what I do in a page:

$session = CRM_Core_Session::singleton();
$session->pushUserContext(CRM_Utils_System::url('civicrm/pumexpenseclaims/page/claimlevel', 'reset=1', true));

Then in the form I do nothing in the postProcess. The only thing I take into consideration is when I press something like delete on the page where I take an action but do not need a form. If that is the case I tend to do this:

$session = CRM_Core_Session::singleton();
CRM_Utils_System::redirect($session->readUserContext());

Mind you, it could well be that this pattern no longer works in 4.7? What are the issues you run in to?


How can I create a copy of my CiviCRM site? Upgrade instructions include:

  Use your backup to create a copy of your site (directories and
  database), and ensure that this copied site works correctly.

How can I create a copy of my CiviCRM site (on Drupal)?
Is there a big difference between making a copy on the same server or another one?

There are some instructions at https://docs.civicrm.org/sysadmin/en/latest/misc/switch-servers.

The wiki page referenced in a couple similar questions is still there but getting out of date, and there's something wrong with the styling at the moment, but it's still legible: https://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location


Can't make new profiles, or edit settings When I try to create a new civicrm profile, or to edit the setting of an existing one, there is just a blank space with no buttons or fields. See the attached screenshots.  I'm using civicrm 4.6.10 and Drupal 7.41

I have tested the same against CiviCRM Version 4.6.10 and it works perfectly. So please try to reinstall CiviCRM or try to install an fresh copy of CiviCRM and do the testing - Thanks


Import multiple options in one field I have a custom field for Individual contacts which can carry multiple values, i.e. 'Languages' can be 'English, German, Spanish, Greek'.

An individual may speak 'English, German', another 'Spanish, Greek, English' and so on.

How can I populate this field with multiple values when importing contacts?

If you are using Multi-value Custom Data, see How to import to multi-record set custom fields and the answer.

But it sounds like you are importing multiple options in a field, in which case you can use comma separated values in a single cell. The import file will look something like this:

First Name,Last Name,Language
Joe,Smith,"English, Spanish"
Frank,Jones,"Dutch, English"

Tip: Try exporting a couple of existing records (with similar data) to see what CiviCRM expects in the import.


Error when entering registration in backend I have an problem, when registering participants manualy over the backend. If I choose an event having a pricelist, it shows the pricelist, but has two problems:

It doesn't show the total sum of the fees!
It doesn't show the form for editing the registration confirmation send by mail!

In the browsers JS-Console, I get errors. This is, what I see in Chrome:

Uncaught SyntaxError: Unexpected identifier
(anonymous function) @ js_DMn29dQVNHfbgcdlcutXpB1hshlW6Su8HFMDl-TYa-A.js:2
m.extend.globalEval @ js_DMn29dQVNHfbgcdlcutXpB1hshlW6Su8HFMDl-TYa-A.js:2
m.fn.extend.domManip @ js_DMn29dQVNHfbgcdlcutXpB1hshlW6Su8HFMDl-TYa-A.js:4
m.fn.extend.append @ js_DMn29dQVNHfbgcdlcutXpB1hshlW6Su8HFMDl-TYa-A.js:4
(anonymous function) @ js_DMn29dQVNHfbgcdlcutXpB1hshlW6Su8HFMDl-TYa-A.js:4
m.access @ js_DMn29dQVNHfbgcdlcutXpB1hshlW6Su8HFMDl-TYa-    A.js:4
m.fn.extend.html @ js_DMn29dQVNHfbgcdlcutXpB1hshlW6Su8HFMDl-TYa-A.js:4
$.ajax.success @ add?reset=1&action=add&context=standalone:468
j @ js_DMn29dQVNHfbgcdlcutXpB1hshlW6Su8HFMDl-TYa-A.js:2
k.fireWith @ js_DMn29dQVNHfbgcdlcutXpB1hshlW6Su8HFMDl-TYa-A.js:2
x @ js_DMn29dQVNHfbgcdlcutXpB1hshlW6Su8HFMDl-TYa-A.js:5
b @ js_DMn29dQVNHfbgcdlcutXpB1hshlW6Su8HFMDl-TYa-A.js:5

Firefox tells me:

SyntaxError: missing ; before statement

Sorry, I'm no use in this JS-things!

Bye

I think, I found it!

I belive, it's a problem with the german translation! IMHO, it's because off the quotes in this code.

cj('form[name=Participant]').on("click", '.validate',
    function(e) {
      var userSubmittedStatus = cj('#status_id').val();
      var statusLabel = cj('#status_id option:selected').text();
      if (userModifiedAmount < feeAmount && userSubmittedStatus != partiallyPaidStatusId) {
        var msg = "Der gezahlte Betrag ist weniger als der erforderliche Betrag. Der erwartete Teilnehmerstatus ist "Teilweise bezahlt". Sind sie sicher den Teilnehmerstatus auf %1 zu setzen? Klicken Sie auf OK für weiter, Abbruch um die Daten zu ändern.";
        var result = confirm(ts(msg, {1: statusLabel}));
        if (result == false) {
          return false;
        }
      }
    }
  );

I belive, there should be no double quotes around "Teilweise bezahlt".

No I have to find the place, where this is defined!


Any way to avoid "deprecated function" messages in the Drupal dblog? I am getting a LOT of entries in the Drupal dblog (watchdog) about a deprecated PHP function, as described here -
 Debug PseudoConstant

I'm trying to debug a different issue and the presence of these (hundreds) of messages is making it very difficult.

Is there a way of turning down the logging level so that deprecated function messages are not shown? It seems odd to include them, because admins cannot even do anything about it, it's just for developers.

(I know I can filter the log by component and by severity; however, the messages I am interested in are also marked "civicrm" and "debug", so that doesn't help. And in any case, the Drupal UI only shows recent messages, so when there are hundreds of irrelevant ones, it doesn't have room for many of the ones I want to see.)

The types of PHP errors and warnings being logged to Drupal Watchdog typically reflect the level of error reporting set for the webserver.  If you can edit your vhost config or .htaccess, you could change the error reporting level. Refer to http://php.net/manual/en/errorfunc.constants.php for the different error levels.

Based on your request, you probably want to disable/exclude error reporting for the following level:

8192     E_DEPRECATED

In .htaccess, you'd add php_admin_value error_reporting 22527 to disable just E_DEPRECATED.

Should you find that you're still getting other deprecated warnings after applying the change (and possibly restarting server if change was made in vhost), you may want to also exclude the following error level/type:

16384 E_USER_DEPRECATED

See https://stackoverflow.com/questions/5628148/disable-e-deprecated-in-php-error-log for more background on how you can get the bitwise value (error level) for a custom combination of error types.


Integration with Campaign Monitor? Is it possible to integrate CiviCRM with Campaign Monitor so as to combine the advantages of both platforms and share information between them?

Thank you!

it is certainly possible to export and import from another system, as long as campaign monitor has some kind of rest api, it should be fairly easy to develop.

however, and no matter the external service you want to integrate to, you would need to clarify better what needs to be pushed and pulled. what constituent details? only the email, the full name...

and then you have the problem of when to synchronise and who has the master data. eg. what happens if the first name changes in civi, what happen if the email changes in campaign monitor? what happen if the email changes in both...

lots of questions and potential conflicts you need to resolve to be able to clarify the behaviour of your system. these are hard problems, and bidirectional sync is potentially really complex. try to simplify as much as you can, eg all data in civi is the master one and considered the most up to date.

please clarify what you want to synchronise and how often, it will help giving a less generic answer


Upgrading from 4.7.18 to 4.7.19 breaks soap I recently upgraded from 4.7.18 to 4.7.19 (under Drupal 7.54) and now CiviSMTP (as well as my browser) gets Drupal's "Page not found" page when trying to get to my soap.php file.

Page not found
The requested page "/sites/all/modules/civicrm/extern/soap.php" could not be found.

I've confirmed the file is in place, I'm using the default Drupal .htaccess file, file permissions seem to be at their defaults (AFAIK), and I'm out of ideas. My cron jobs are also not running, but I figure there's a common cause.

It turns out it was civicrm file permissions (in sites/all) conflicting with my server's PHP access settings.

My server dictates that if any part of a path is group writable, php file access will be denied. So I (well, my hired support person because I got desperate) went and set the directories involved to permission 755, and the file to permission 644 (civicrm/extern/soap.php).

My secondary problems with cron (civicrm/bin/cron.php) and not being able to browse for images in civimail (civicrm/packages/kcfinder/*) were fixed by following the same logic.

I'm still not sure why this was triggered by an upgrade from 4.7.18 to 4.7.19. I must have made a misstep during file copying.


How did my import result in the State for a different country to the one intended How could a CiviCRM database have 2 Marylands with 2 different state_province_codes but both be identified with the same country_code?

1019 = Maryland
3497 = Maryland
1228 = United States

I only was alerted to this when my newly inherited client created a Smart Group to display all records with postal_code between 20601 and 21930.

Is my CiviCRM instance corrupt or has a bad import caused this? Can I manually adjust the offending records without cascading problems? How would you suggest a fix for this?

I may not have quite understood you but if you have access to your database you can look in civicrm_state_province where you will see there is a Maryland MY in Liberia (1122) as well as a Maryland MD in the USA (1228)

When importing contacts with State/Province you may be better off if you either import the abbreviation (though even that might not be unique) or also import Country.


Under what circumstances is API joining available? If I go to the API explorer and select ContributionSoft as the entity, I see options to enable joining. But I don't see any joining options available for other entities like Contribution and Participation. Why? I would expect expect that a join automatically becomes possible any time a foreign key exists, and also becomes possible in some other special circumstances (e.g. option value).

Is it really the case that joining is only available on some entities?

If so, what is the logic behind which entities offer joining?
If not, I would like to understand, as an example, how I can execute an API call on Participation which joins Event.

The API is largely metadata-driven, and whether an API field is joinable is usually determined by the data returned by that entity's getfields API action.  If you look in <civiroot>/templates/CRM/Admin/Page/APIExplorer.js at the renderJoinSelector() function you'll see the logic.

However, right at the top of that function there's a reference to the const NO_JOINS.  Right up at the top of that file, you'll see:

// The following apis do not use Api3SelectQuery so do not support advanced features like joins or OR
NO_JOINS = ['Contact', 'Contribution', 'Pledge', 'Participant'],

These sorts of quirky APIs are exactly the sort of thing that APIv4 is intended to eliminate.  It's no coincidence that the Participant entity is the first one slated to be released under APIv4.  It's quirky and it shouldn't be, but changing the behavior would break the API contract not to change on some extension author.


Send civicrm email receipt immediately for recurring contributions - Authorize.net I am using drupal, civicrm version 4.7.27.  I would like email receipts from CiviCRM to be sent immediately for recurring contribution, rather than waiting for Authorize.net to process the credit card overnight.  In previous versions, there was code in the file CRM\Contribute\BAO\Contribution\Utils.php that I could comment out, to override the default behavior for receipt.  This was the code I commented out:
//Do not send an email if Recurring contribution is done via Direct Mode
//We will send email once the IPN is received.
//if (!empty($paymentParams['is_recur']) && $form->_contributeMode == 'direct'){
//  return TRUE;
//}

This code no longer exists.  Can anyone tell me if there is a way in version 4.7.27 to force CiviCRM to send a receipt immediately for a recurring contribution, even if it has not yet been processed by Authorize.net?

Thanks!

You could probably achieve this with the CiviRules extension? The extension can be found here: https://civicrm.org/extensions/civirules/version-113 and the documentation here: https://docs.civicrm.org/civirules/en/latest/


Is there any civicrm api for android? Please share the link for civicrm android API for android.
Any git site.
And also send some tutorial regarding to API.

You can just interact with the CiviCRM API from your android app.

https://docs.civicrm.org/dev/en/latest/api/

Android documentation is very good has all the information you need for the Android side of things.


CKEditor / wysiwyg for public profile I have a custom data field that is a profile that I'm sharing via the frontend of my web site (to Registered users).

I'm using Joomla 3.8.x and civiCRM 5.10.0 -- I've set the custom field as "Note Rich Text Editor" but when include the field in a profile to allow registered users to complete the field, the editor doesn't appear -- just a text box.

Any ideas why this would be?

[civicrm.root] wrongly evaluated on Joomla. See: https://lab.civicrm.org/dev/joomla/issues/5

A fix for your particular issue is:
Create an override file in your Custom PHP Directory for CRM/Core/Resources.php

On Line: 738
CHANGE:

'wysisygScriptLocation' => Civi::paths()->getUrl("[civicrm.root]/js/wysiwyg/crm.ckeditor.js"),

TO:

'wysisygScriptLocation' => Civi::paths()->getUrl(Civi::settings()->get('userFrameworkResourceURL')."/js/wysiwyg/crm.ckeditor.js"),


Null values -where do they come from I have a number of custom fields. Quite a lot of them are yes select option answers. However a number of contacts have what I think is a null value in them.

So if I search give me everyone who has a yes in the field answer I get the answer 579 for example. If I search is not null I get a much higher value eg 1179.

Does anyone know where his data comes from and what it is? If I get rid of it will it just come back?

The reason I am asking is that I am building a chart in Views where I want to display multiple custom fields in a bar chart. As I am trying to display multiple values I can't filter the data for each custom field rather I am relying on the fact that there is data in the field at all to act as the filter and to ensure an accurate count.

I hope I have explained myself properly!

Thank you!

Assuming you're using Views - [noticed the tag]! You're definitively on the right track! Drupal Views integration is an extremely powerful way to get more out of your CiviCRM (literally!).

So to handle this add a Filter in Views to not display such NULL results. Here's an example where I want to make sure that addresses without a Latitude or Longitude do NOT get plotted on a Map:


Which contacts in a mailing group are NOT recipients of a mass mailing? I have a mailing group with 1396 contacts in it, 8 of whom don't have email addresses and 21 of whom have opted out of bulk email. Therefore there should be 1367 contacts emailed.

However, when I select the group for a mailing, it says "Total recipients: 1,348" which leaves 19 contacts unaccounted for. How do I find out either

Which contacts are recipients of the mailing, or
Which contacts are NOT recipients despite (a) being in the group, (b)
having an email address, (c) not having opted out of bulk email?

Any help would be appreciated.

Thanks!

The following are all different:

No bulk emails (User opt out): This is what happens when someone opts out using the link in a bulk mailing. This means they won't be included in any bulk mailing. It doesn't affect sending single messages to that contact.
Do not email: This means we can't/shouldn't email them at all, even singly. Actions > Send an Email won't be available.
Deceased: AFAIK works similar to "Do not email".
On hold: Set by the CiviMail bounce processing. Probably means a bulk mail to them bounced. This means the address is invalid/inaccessible, not necessarily that they don't want us contacting them.
Unsubscribe: This is a different meaning and a different link to "Opt out". This is not a flag that is visible from the contact summary, but from the groups tab. Bulk emails are sent to groups; unsubscribe causes the contact to be set as 'removed' from the group that caused them to get that email. It does not opt them out of all mail or even all bulk email.
(One of) their email address(es) should be marked as primary. This should happen automatically but if they don't have a primary email address this might cause issues.


Send or print membership invoices I'm helping a nonprofit set up membership invoicing. They want to create invoices for the current members. They do not want to use automatic reminders -- they want to choose who they send the invoices to, and when. Additionally, they'll want to send individual reminders to those members who haven't paid.

We've created a Message Template and included personalization tokens for name, organization, etc... but don't see any way to include the due date, membership name and amount due. We know we can include checksum links to a contribution page, but many of their members are brick-and-mortar companies, and they need to print a page and carry it to their accounting departments...

Isn't there some way to generate a simple invoice? Something like "Dear Joe, your membership will end soon. To renew, please remit payment of $150.00 by January 31, 2016."

Thanks in advance, and apologies for noobiness.

I see 2 ways:

Do Use Scheduled Reminders (Administer - Communication - Scheduled Reminders), If you choose Memberships as Entity you can use Membership tokens in the email being sent. You can limit the recipients per group. So if you want to send it one-time, just search for the people you want to send it to, place them in a group and create a reminder with just that group. Let the reminder be sent and remove the reminder.
Use PDF invoices (enable via Administer - CiviContribute -> CiviContribute Component Settings). You can then search Contributions and send individual pdf invoices per email to the results of your searches.


How to send "thank you" emails to donors? We want to send emails to our donors of the previous week. This email needs to be customised, as it's an opportunity to tell them what has happen in the week or what's the plan to the week ahead.

I tried to use the thank you letter feature, but I haven't been able to customise much of the email (eg. the subject line) easily for each mailing.

If I do a "normal" mailing from an advanced search on donors, I haven't found an easy way to set the "thank you" date on the contribution, and only filtering on the contribution date isn't robust enough, and I'd like to use that field to know as well when the donor has received the thank you email.

Although it will not be a completely clear-cut solution without any work, you could try to use CiviRules? It allows you to specify sending a email to the donor 1 week after the actual receipt of the contribution. You can specify the template, which will probably require some work to do exactly what you want it to do, but it might be worth a try?


How to change the default license selection in `civix generate:module`? By default civix generate:module will create an extension licensed with AGPL-3.0. How would one go about changing that default to something else, say, GPL-3.0?

Edit: I'm aware of the --license argument, but to clarify, I'm looking to change the default license permanently, so that I would have e.g. GPL-3.0 on all future invocations of civix generate:module, without additional arguments.

I believe you can use any of the licenses in https://github.com/totten/license-data/blob/master/index.csv, which is used by civix.

In your case, just add --license=GPL-3.0 to the command.

It looks like you may be able to set a value in ~/.civix/civix.ini to provide a local default: https://github.com/totten/civix/blob/v16.03.2/src/CRM/CivixBundle/Command/InitCommand.php#L118


Membership start date and "member since" date not set with online contributions I've noticed that ever since we started taking online contributions (last summer) new members have been getting created with null start date and "member since" date. Offline memberships (created via the backend) work fine, and the membership statuses all seem to work correctly otherwise. The end date is also set correctly. I'm using both GoCardless and Stripe payment processors and the problem appears with both of them.

The practical upshot of this is that these members are not being counted in the membership summary dashboard - this is probably also a bug - either the schema should enforce these values not being null, or the dates shouldn't be used to calculate a "current" member.
In case it's relevant, here are the membership status rules:

Some other details:

the memberships are rolling
hosted on Drupal 7 and MySQL
running CiviCRM 5.34.0, but problem dates back to at least 5.28.1, the version running when the earliest membership of this type was created.
Detailed logging is enabled, and there's no evidence of the dates being set and cleared.

There are similar issues described at Start/member since dates not being set since upgrade to 5.3.2 and Member Since and Start Date aren't being recorded in membership details but there is no resolution of either of those and they're both a few years old, so I figured a fresh report would not be a bad thing.
Edit to add screenshots of the contribution page (membership and profile sections):

Edit to add:
Some experiments I tried to rule out various causes

The same thing happens with a dummy provider or a free membership.
Pay later puts the membership into pending state, with no dates at all (based on comments this also seems unexpected
The same thing happens on a clone of the live site with all extensions disabled
The same test installation with a completely fresh install and the demo contribution form works as expected, populating all the dates correctly.

So have pinned it down to something in our live database at least, rather than anything basic with the environment or code deployment, but I've pored over the differences in settings and contribution forms from database dumps and found nothing promising.

This problem was seen on one of our sites and the issue was in the status rule page where Pending is selected as Member = Yes.
Pending is a reserved status that defaults to Current Member = No. Civi doesn't allow you to edit this status via UI but i see inline edit still works on these statuses. This is clearly a bug in core.

So i think it was unintentionally updated to Yes on your site since i see the same case on your attached screenshot.
Reverting this value back to No fixes the problem with the dates.


WYSIWYG Editor Permissions In the online contribution section when we enable Tell A friend as a option we noticed that the option for an anonymous user only shows in a WYSIWYG Editor format. This is high risk and we would like to avoid it by only allowing admins to use the WYSIWYG Editor. However, I only see one option in the Customise Data section whichs says use the WYSIWYG Editor or not i.e. CKeditor, TinyMCE and Text area.

Is there a way to control access based on a users role.

Please refer the below link

Is there a way to disable the wysiwyg editor when editing mail templates?

you need to disable the Editor before user access the editor page


Add "sender/from" line to postal mailing labels I like to add a "from" line at the mailing label so we can use cheaper blank envelopes and am looking for the location and filename of the stylesheet of the labels. If I do it in Administer - Localization - Address Settings the font for the sender is to big.

Like:

consigner/sender | xystreet 12 | zip town

recipient Name

Street

ZIP town

I have checked documentation but could only found how to add physical formats so far. Thank you for your tipps!

SECOND is there a way to define a start position, having a sheet that is patially used? e.g. start at label 5 or start at row2, label 2

My solution for Question 1:

I create labels with the recipients in CiviCRM and save it. Than i create a label-sheet with the same format in libre-office only with the "from"-line and safe it as pdf. then i use "pdf chain" (for linux) to merge this two files together. in "pdf chain" it called "backround/stamp". so it "stamps the "from"-pdf as often as needed in to the pdf from CiviCRM.


Unable to load registration pages or save registrations I have a WordPress 4.2.1 site with CiviCRM 4.6.2, this is a fresh install. I have one event with registration and the default registration
page:

?page=CiviCRM&q=civicrm/event/register&reset=1&id=1

shows no registration fields. If I visit

aaaaa/?page=CiviCRM&q=civicrm/event/register&reset=1&id=1

then I see the registration fields or if I visit

event/?page=CiviCRM&q=civicrm/event/register&reset=1&id=1

or

bbbbb/?page=CiviCRM&q=civicrm/event/register&reset=1&id=1

where aaaaa and bbbbb are indeed valid slugs on my site. If I visit

ccccc/?page=CiviCRM&q=civicrm/event/register&reset=1&id=1

where ccccc is not a slug, then I get a 404 Error page.

I have no "WordPress Base Page" set at

civicrm/admin/setting/uf&reset=1

and the wp_users is set correctly as Users Table Name. I have " Your latest posts" set for the "Front page displays" in WordPress so that seems OK.

Something also odd is that the above URL is actually

civicrm%2Fadmin%2Fsetting%2Fuf&reset=1

in my browser. Not sure why...

Also when I visit

admin.php?page=CiviCRM&q=civicrm%2Fevent%2Fmanage&reset=1

it's fine but if I visit

admin.php?page=CiviCRM&q=civicrm%2Fevent%2Fmanage%2Fsettings&reset=1&action=update&id=1

then I get the dreaded

We can't load the requested web page. This page requires cookies to be
enabled in your browser settings. Please check this setting and enable
cookies (if they are not enabled). Then try again. If this error
persists, contact the site adminstrator for assistance.

Site Administrators: This error may indicate ....

Error type: Could not find a valid session key.

error.

All pages I am testing have www before the myurl.org so that's not the problem.

Any ideas what is going on here?

It sounds like you may be having a problem with SSL pages.  I suggest checking that you're not switching between HTTP and HTTPS.  If you are, try going to Administer menu > System Settings > Resource URLs and changing "Force Secure URLs" to "No" until you have your SSL certificate straightened out.


Using the link to Set up a Personal Campaign Page gives 404 page error Sorry, I'm a newbee at CiviCRM, and frankly, I find the instructions aren't so clear. I'm trying to set up Personal Campaign pages for a fundraiser we are doing. I enabled the Personal Campaign Page settings on my contribution page, but when I click on the link it provides, it goes to a 404 page error. So I figured that maybe I needed to add short code to a new Wordpress page. The CiviCRM component isn't giving me the option for Personal Campaign page. What is the short code I should be using?

I was able to figure it out. I had deleted the CiviCRM page so that's why it wasn't working.

Thank you!


Disable Automatic Receipts on Existing Recurring Donations I'm on CiviCRM 5.8.1 on WordPress using the latest version of the Stripe extension, and I'm wondering if there's a way to disabled the automated receipts for existing recurring donations.

We'd like to change to a model where we're doing thank yous manually as needed when recurring donations come in, and while we can tell it not to send a receipt when we first enter a donation, I don't see anywhere that I can tell it to stop sending automated receipts if it's already doing it.

I do not have the "send receipt" box checked in the contribution page configuration for what that's worth.

Thanks for any ideas folks have.

In the Recurring Contribution series itself you can set Email Receipt to Off; if you have access to mysql you can stop sending CiviCRM Contribution receipts for all your existing Recurring series by setting is_email_receipt = 0 ( in civicrm_contribution_recur )

For the iATS extension we have added an additional setting that will override (a global setting) all individual recurring series.


A report for monthly newsletter subscription rates? (need advice) I've been trying to think of a way to create a report to see the total number of subscribers to our newsletter on a monthly basis.

Any ideas? I've hit the wall.

If you are using Views you might be able to use Aggregation on a field that has the 'month' and then 'count' the subscribers for that 'month' field. Aggregation is in the Advanced section of the View.


Email processor silently truncating anything after an emoji in inbound emails A related question is Has anyone used Emojis in CiviMail subject/body? and the answer is to change the database to use utf8mb4 which is going to be standard in CiviCRM in upcoming versions, but using utf8 currently I'm seeing that depending on the database (e.g. mysql vs. mariadb) and version (e.g. mysql 5.5 vs 5.7) it can fail noisily or can fail silently and just truncates anything after the emoji. So this is partly a PSA in case others haven't noticed silent fails.

I was able to run this grep on the sites/default/files/civicrm/custom/CiviMail.processed folder (drupal - adjust as needed) to locate at least some candidates that have been truncated, but I doubt there's a way to then automate updating the activities in civi. If I find one will post back here.

grep -r "=F[0-7]=[0-9A-F][0-9A-F]=[0-9A-F][0-9A-F]=[0-9A-F][0-9A-F]" sites/default/files/civicrm/custom/CiviMail.processed

For those looking for a workaround for this issue, we created a tiny extension called Multibite which replaces unsupported multi-byte characters with the Unicode replacement character (or any other character, depending on configuration). We did not want to pollute core with this code as the goal should be to support utf8mb4, after which the extension becomes obsolete.

I should note that we aren't running this in production yet, so it hasn't seen much real-world testing.


Multiple Contact Registration for events I'm sure I'm off in my configuration but not sure what.  I've set up an event where a registrant can register multiple participants under the same address. For this event, a parent would sign up and then each of  their children coming to the event would have to be registered

In the set-up, I have the following profiles for On-line Registration:

"Include Profile Top of Page"   Parents Profile
"Profile for Additional Participants"  Youth Profile

I do have the option for "Same e-mail address" selected

Here is the problem...when a user sign's up and uses the same e-mail address, only the first contact is used so I'm seeing that first user registering each time.

Here is the actual scenario.  Parent 1 and Parent 2 have to separate e-mails. Parent 1 registers three children under his e-mail.

Parent 1: parent1@email
Parent 2: parent2@email
Child 1: parent1@email
Child 2: parent1@email
Child 3: parent1@email

When registered in this manner, Parent 1, Parent 2, and Child 1 get confirmation e-mails. Child 2 and 3 get a confirmation e-mail addressed to Child 1.

When I view the participants for the event, I see:

Parent1
Parent2
Child1
Child1
Child1

How can I correct this issue as it's important to have the name of each participant that is joining us.

This situation is why there's the ability to pick a specific dedupe rule for your event's online registration.  The information you get in certain cases is quite different than online donations or other events.

First, unless you are using a dedupe rule where email alone is not enough points to match, you should uncheck the Same email address? box.  The default unsupervised rule says individuals with matching email addresses are the same person, so that's probably causing your problem.

Second, you should consider whether you expect any children to have real, independent email addresses (and whether you'd want those addresses anyway).  If not, make a profile lacking the email address field and use it for additional attendees.

Finally, you'll want a strategy for dealing with duplicates.  If you are just collecting first and last names for additional registrants, you don't have much to go by in matching them to contacts.  (There was another Andrew Hunt at my high school.)  Instead of trying to match blindly at the point of registration, it is probably more efficient to let the form create duplicates and then manage the duplicates later.  Here's how:

Have your profile for additional attendees add contacts to a group for you to review later
You can create a General dedupe rule that matches on first and last name.  It won't be good to use on a front-facing form, but you can use it to find duplicates later.
From the Find and Merge Duplicate Contacts screen, use that rule from step 2 to find duplicates, selecting the group from step 1.  You'll get a few false positives, but you can mark them as "not a duplicate".  Those pairs won't be suggested ever again.
Repeat step 3 every few weeks while your events are getting frequent registrations, and do it at least every couple of months through the rest of the year.


How to select multiple values in select2 control by jquery? I want to select multiple options in a select2 multivalue control, when clicking a button.
This is useful specially for searches where the user needs to select many option to one of the filters

any idea how to achieve it..?
I found how to select an option in select2 single option dropdown, but not in a multiselect control for several options at the same time

Ok, I found the way. It's just passing an array of option values to 'val' argument:

$('#my_select2').select2('val', ["value1", "value2", "value3"]);


(Stripe) CRM_Core_Payment_Manual::setAPIParams() Fatal Error CiviCRM 5.24.4/Wordpress 5.4

Getting hourly alerts from Cron, pertaining to some kind of API failure with Stripe. I suspect it has to do with the version-setting, but I'm unclear on how to address this.

In fact, (as originally posted here), I'm getting really strange behavior from Stripe payment processing; in addition to returning an error 100% of the time ("This PaymentIntent's amount could not be updated because it has a status of requires_capture. You may only update the amount of a PaymentIntent with one of the following statuses: requires_payment_method, requires_confirmation, requires_action." -- there's another thread here about that already), the Stripe dashboard shows a consistent $200 addition to all payments (these are in steps of $25, $50, $100, & $500 . . . and whatever I choose has exactly $200 extra tacked on).

Seems a little nuts. Anyone have any idea?

Gonna mark this as answered, for now, as I've logged it as an extension issue.

The core of the problem, just FYI, seems to be that the auto-webhook process is failing (it appears to work, and a webhook does indeed appear on the Stripe dashboard, but the errors persist and I'm hoping that the real weirdness (the additional $200) is at least related to this.


search database to identify addresess we have about 1400 people in our database. All have email addresses and some have physical addresses. How can I sort/search so I can produce a list of those who have physical addresses? Once we have this list, is there a way to export that list to create mailing labels? Thanks in advance!

Welcome to this stack community. There are multiple ways you could get what you want.
I would use the Search Builder functionality. You can find it in the main menu Search-> Search Builder.

You can search the contacts where the address fields (such as city, street adress, or other address fields) are not empty.
You can then select actions (what to do with the list). You can export it and deal with it externally or you can select Mailing Labels - print to directly create mailing labels. You would probably want to configure Label format before doing so. You can do that by going to the Administer->Communication->Label Formats in the main menu.


Performance Bug in Trigger Causing ~1000x Slowdown While looking for the root cause of a performance issue for a client, I tracked it down to a couple of triggers performing an inefficient UPDATE statement:
civicrm_activity_before_update
civicrm_activity_before_delete
Original SQL (~4 seconds):
UPDATE civicrm_case SET modified_date = CURRENT_TIMESTAMP WHERE id IN (SELECT ca.case_id FROM civicrm_case_activity ca WHERE ca.activity_id = OLD.id);

~1000x faster SQL to do the same thing:
UPDATE civicrm_case, civicrm_case_activity SET civicrm_case.modified_date = CURRENT_TIMESTAMP WHERE civicrm_case.id = civicrm_case_activity.case_id AND civicrm_case_activity.activity_id = OLD.id;

I tracked this down to the following PHP file:
sites/all/modules/civicrm/Civi/Core/Container.php
The patch to fix the SQL payload in the file:
--- Container.php.orig  2021-04-12 11:30:35.039270421 +0100
+++ Container.php   2021-04-12 11:32:00.485650901 +0100
@@ -286,7 +286,7 @@
             'table' => 'civicrm_activity',
             'when' => 'BEFORE',
             'event' => ['UPDATE', 'DELETE'],
-            'sql' => "\nUPDATE civicrm_case SET modified_date = CURRENT_TIMESTAMP WHERE id IN (SELECT ca.case_id FROM civicrm_case_activity ca WHERE ca.activity_id = OLD.id);\n",
+            'sql' => "\nUPDATE civicrm_case, civicrm_case_activity SET civicrm_case.modified_date = CURRENT_TIMESTAMP WHERE civicrm_case.id = civicrm_case_activity.case_id AND civicrm_case_activity.activity_id = OLD.id;\n",
           ],
         ],
       ]

The bug doesn't manifest if you rewrite the UPDATE as a SELECT, but in the UPDATE form it takes an absurdly long time when a sub-select is used. Tested on MariaDB 10.4 and 10.5.
Any thoughts on this? Functionally the two queries are identical. What does it take to get this merged upstream?

Nice find. Thanks for posting. Yes the inner join is generally better than a subquery.
To answer your secondary question, to get it merged you need to create a ticket at https://lab.civicrm.org/dev/core/-/issues/new and then if you're able to also make an associated pull request at https://github.com/civicrm/civicrm-core against master. See also https://docs.civicrm.org/dev/en/latest/tools/git/#contributing. Then someone needs to confirm and test it.
When you do post your ticket, it would help to also describe the parameters (e.g. # of activities in the database, any other relevant variables...) so that others can reproduce/evaluate.


How to create a campaign I've been using CiviCRM for a few days now, and it's become pretty apparent that campaigns are a big part of how the system works. However, I'm unable to figure out how to create a campaign. Can anybody help me out?

After enabling the Campaign module and adding your Campaign Type, Statuses, and Engagement Index (if relevant), you can add a new campaign from either the Campaign dashboard (using the Add Campaign button) or from the Campaign menu > New Campaign.  From the docs:


Is CiviCRM 4.6 Bootstrap Compatible On a 4.5 site running the most recent Drupal, I have to use the themekey module to make CiviCRM public facing pages use a different theme from the site default because of Bootstrap compatibility problems. (For admin stuff I'm using a non-bootstrap admin theme.)

The client really wants the public-facing part of the site to use the same bootstrap theme for all pages.

Is 4.6 have any better Bootstrap compatibility than 4.5?

4.7 should be, but not 4.6 as is. There was a GSoC student who worked on making CiviCRM more Bootstrap-friendly, unfortunately the patches were not merged in for 4.6.

I've started working on it again, based on Amilineni's work, but I'm slowly moving forward. If anyone beats me to it, I will be more than happy :)

So far, I've been trying to add a few classes to core forms (CRM/Core/Form.php), and try to see if we can override the CSS on buttons using Saas/Less, and perhaps moving a bit of CSS out of civicrm.css so that we can make it optional (to avoid loading extra CSS rules if we are using Bootstrap).


How does the API deal with the addition of an existing contact? If you add a contact via the API is it passed through any of the de-duplication rules? I.e. if I add a contact that matches an existing record will it create a new record or merge with the existing record?

If the contact is passed through the de-duplication rules how can you control which rule applies?

I am wondering if I need to create the necessary logic in my code to test if a new contact is a duplicate or if I can rely on the de-duplication process to take care of this.

you can either set a check_duplicate=>true extra param... but to be honest, I always done the duplicate checking on the code side before calling the contact create api, because it's way more versatile and it's easier to match your exact need


Why Membership and Other Amount doubles receipt amount Weirdness I can't find answer to. I hope I can articulate this well enough. If not, I'll make a screencast. And is not the same as Contribution page "other amount" option causes weird behavior - possible bug?

Steps:

Create Contribution Page
Set contributions for only "Other Amount". No other entries for contributions.
Set for Membership signup
Tick "Separate Membership Payment"
Test Drive choosing a membership level (type) and leaving "Other Amount" blank is successful through end of workflow with correct amount for Membership showing only.
PROBLEM: (Test) Receipt sent by email shows correct amount for Membership but also includes same for 'Other Amount' doubling the total.

Then if I untick "Separate Membership Payment" then the correct amount appears through the workflow but then two receipts are sent; one for Contribution and one for Membership. But, the Membership receipt continues to fill in the "Other Amount" section with the Membership amount and doubles the total amount.

That definitely sounds like a bug.  It's not really replicable on the demo server, because you can't get emailed receipts, but if you can replicate this on a site built with buildkit, you can file this at https://issues.civicrm.org.

To start tracking the bug down, I'd insert the {debug} Smarty token into your receipt.  Hopefully there's an obviously wrong variable.


Cannot separate CiviCRM database tables from Wordpress tables on installation I just installed CiviCRM for the first time on a test Wordpress installation for checking out CiviCRM. I followed the instructions at https://wiki.civicrm.org/confluence/display/CRMDOC/Installing+CiviCRM+for+WordPress and used civicrm-4.7.10-wordpress.zip. For some reason, when running: http://{wordpress install directory}/wp-admin/options-general.php?page=civicrm-install, the database part of the form is populated with the Wordpress database. I created a clean, empty MySQL database and tried to enter it. When I pressed the Check Requirements button, it replaced the database name with my Wordpress database name. Everything works, but I really wanted to have the Wordpress tables and CiviCRM tables in separate databases for future site management. Is there a way, after the fact, to point to the database I want? I can easily export the CiviCRM tables and import them into the clean database.

Thanks for any help here and sorry if this is simple - this is my first day working with CiviCRM.

OK. I was able to fix it by

Directly editing wp-content/uploads/civicrm/civicrm.settings.php to point to the new clean civicrm-only DB.
Exporting the civicrm tables only from my original wordpress DB.
Importing the exported civicrm tables into the new, blank civicrm-only DB.
Dropping the civicrm tables from the original wordpress DB so it is wp-only.

All seems to be working, but it seems like I should have been able to easily set this up with the install script, which seemed to override anything that I put in for the CiviCRM DB by the WordPress DB.

All looks OK. For the more experienced CiviCRM folks, can there be any gotchas here?


Drupal Domain Access vs Multi-Site in Civi What is the best way to implement CiviCRM for multiple sites?
I'm a little familiar with Domain Access and less with Multi-Site in Civi.

I'd like to have two front-end sites share one CiviCRM database, with a user from site A having access to the complete database and a user from site B having only access to site B contacts and contributions.

Multi-Site is the way to go http://wiki.civicrm.org/confluence/display/CRMDOC/Multi+Site+Installation

With Domain Access you can get into trouble because CiviCRM would expect one domain per "civicrm.settings.php".


How do I use the joins feature of the new API 4.7 lists the ability to use joins for API queries, but I can't find anything in the docs or in the API Explorer.  Can someone point me to documentation or examples?

The JIRA Issue for this feature https://issues.civicrm.org/jira/browse/CRM-17795 reads

  This adds support for joins in api.get operations to fetch information
  from more than one table.

  It also adds ACL enforcement to the Contact and related (email,
  address, phone, etc) apis for get, create & delete actions.

The JIRA issue links to a couple of pull requests; pull request 7565 includes a comment that has screen shots and descriptions (and one join example).


Can you change Pending (Incomplete Transaction) to Pending (Pay Later)? Is it possible to change pending transactions from incomplete to pay later?
Without editing db?

Using api explorer you can do it or exporting the record and re importing it with status as pending and pay later as 1 or yes.


How to create public and front end form through extension? I need to create a public and front-end form through an extension which is native extension that need to compatible with all CMSs like civicrm.com/civicrm/form civicrm.com/form.

Creating a form in an extension is mostly a matter of typing civix generate:form. It is documented here.


CiviCRM integration with Eventbrite I would like to create/update events in CiviEvent by using Eventbrite webhooks. One of the requirements is having an endpoint page that will receive data sent by Eventbrite API.

How can I create that endpoint page within CiviCRM?

You will need to create extension to have Eventbrite sync with CiviEvents. Here is some guideline on how to approach this

Create extension.
Add page using civix
In run() use CiviCRM api to create entries in civicrm table.

Reference :

Mandrill extension uses same approach i.e to create entries in various civicrm table upon webhook call. This might find you helpful to develop your extension
https://github.com/JMAConsulting/biz.jmaconsulting.mte/blob/master/CRM/Mte/Page/callback.php


Activity Duration in Hours extension NOT working for CiviCase Currently using CiviCRM Version 5.31 (Wordpress Version 5.5.3)
Installed the extension to change Activities Duration from Minutes to Hours
https://lab.civicrm.org/extensions/activityhours
The extension works for Contact Activities but not Case Activities.

Does anyone know what needs to be done to make the changes in Case Activities ?
===========================================================================
Hi Demerit, thank you for the prompt response.
I changed the lines in both activityhours.php and activityhours.js but the duration for case activities are still in 'minutes'.
Please advise

You could try changing this line in activityhours.php from:
if ($formName == 'CRM_Activity_Form_Activity' && !CRM_Utils_Request::retrieveValue('snippet', 'String')) {
to
if (($formName == 'CRM_Activity_Form_Activity' || $formName == 'CRM_Case_Form_Activity') && !CRM_Utils_Request::retrieveValue('snippet', 'String')) {
You'd probably also have to add some selectors in the .js file, e.g. whereever it says .crm-activity-form-block-duration also add .crm-case-activity-form-block-duration
You could post a feature request at https://lab.civicrm.org/extensions/activityhours/-/issues, but if you're able to also post a merge request with some tested code changes that would be best.


How can we make Event custom fields available as tokens for scheduled reminders? We've done some investigation and found two places we could intervene to make this possible:

Intervene here: CRM_Core_BAO_ActionSchedule::sendMailings(), but to make tokens available we'd have to collect all custom field info for a specific event. This would possibly be very database heavy, and further, it can't be optimised for when only a (small) specific subset of tokens are used in the scheduled reminder.
Or we could intervene here: hook_civicrm_tokenValues()
But at this point we no longer know for which event we need to get the additional custom field data from.

So, what to do? Any ideas? Thanks for your help!

How about modifying the core event code to also suck in the event custom fields before sending it to the templates. In general, especially for specific events (and contributions etc), including custom fields seems a good thing (and potentially not very expensive from a query perspective)


does anyone have a recipe for a Drupal 8 Views Calendar to show civi events or civi activities Title pretty much says it. want a View Calendar for Civi Event and also for Civi Activity using drupal 8

Was following the second recipe at https://evolvingweb.ca/blog/creating-events-calendar-drupal-8 but get to part for Contextual Filters and don't have the CiviEvent date fields available to me

Somebody who is searching for this answer can use the following civcrm extensions.

  https://civicrm.org/extensions/event-calendar-extension and

  https://civicrm.org/blog/totten/experimenting-activity-calendars

I have not tested "Activity Calendars" though.


Whats the procedure to update a Group using a Smart group I'm just wondering how can I update a group in CiviCRM using a smart group. Would it be possible to do this via a scheduled job.

Any thoughts would be highly appreciated

The only time I had to replace a smart group by a "normal" group was for performance reason when we started to have more than a million contacts.

Otherwise, I'd suggest to use the smart groups as you would use a normal group, and if you have performances issues, start by increasing the smart cache duration and enable the cronjob that automatically re-build them


Does CivicCRM let you manage members as companies rather than individuals? I run a Brewers Guild and the companies are the members, not the employees. I need to have the Brewery as the member and then have different employees listed as different positions (marketing, primary, accounting, etc.) and associated with that brewery.  So I can send an e-mail to everyone at a specific brewery or all "marketing" employees across all brewery members. Is this possible out of the box with CiviCRM?

Yes, this is very possible out of the box. Civi has 3 contact types, Individual, Household, and Organization. You can Use Organization Type for Breweries and Individual Type for Employees. Then with Contacts > Relationships you can list the the Employee Contact as an employee of the Brewery Contact. You can use Contact >Tags to give employees Job Titles such as "Marketing" so you can sort by all marketing employees for a Brewery or all Breweries.


Issues with the Default Email address for bounces - authentication CiviCRM 4.7.19 / Drupal 7.54

I am stuggeling with the setup of the default mail account in CiviCRM
(... /civicrm/admin/mailSettings?reset=1)

I have setup a IMAP mail account for processing bounced email. Receiving email in this mail account works using my mail client using information below.

Mail account info:

Email address:   bounces@mydomain.org

Username:        bounces@mydomain.org (ISP requires that the full email
address be used for the username)

Password:        mypass

Server:          mail.mydomain.org

Protocol:        IMAP

SSL:         is activated

.

CiviCRM (CiviMAIL) settings:

Name:        Bounce processing

Server:      mail.mydomain.org

Username:    bounces     <<<<--- should be full email addres:
bounces@mydomain.org

Password:    mypass

Local part:

Email domain:    mydomain.org

Return address:

Protocol:    IMAP

Source:

Use SSL: checked

Used for:    processing bounces

.

Results Cron Job -

Entiteit: job Actie: fetch_bounces
Summary
Finished execution of Fetch Bounces with result: Mislukt, Error message: A fatal error was triggered: Kan geen verbinding maken met Mailstore voor bounces@mail.mydomain.org
Foutmelding:

An error occured while sending or re (...)
Details

Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}

Full message:
Finished execution of Fetch Bounces with result: Mislukt, Error message: A fatal error was triggered: Kan geen verbinding maken met Mailstore voor bounces@mail.mydomain.org
Foutmelding:

An error occured while sending or receiving mail. Failed to connect to the server: mail.mbrainingcentrum.com:993.

.

When I use the full email adress as username I get errors referring to: bounces@mydomain.org@mail.mydomain.org

Looks to me that CiviCRM(CiviMAIL) has a bug regarding concatenatig proper parts.

Any solution?

Many thanks in advance !

Best regards,
Ton

CiviMail doesn't concatenate the username to the servername, it just takes whatever you provide and tries to connect using those credentials.

But my guess is that the issue is unrelated to the username, since your error message is:

Failed to connect to the server: mail.mbrainingcentrum.com:993.

I'd guess that you've more likely got a firewall issue, or an SSL issue on your server.

You can test by manually trying to connect to your mail server, using e.g.  the instructions here:
https://technet.microsoft.com/en-us/library/aa995718(v=exchg.65).aspx

[As per comment below - another thing to check is that the server is connecting to the correct machine, e.g. if it has a local dns setting that is wrong.]


Can I create my own CRM company reselling our version of CivicCRM? I am looking to create a CRM that I can license to non-profits, that is built on CiviCRM. Is this possible?

I think the answer is probably no, but it depends on what the question was.
My reading of section 5 and 6 in the licence as linked by @demerit https://www.gnu.org/licenses/agpl-3.0.en.html
means that you can't "license" the code itself, even if you modify it, except by using the Affero license, i.e. you can't charge money for it.
What you can do and what others do is to earn money by providing additional value over and above the code base in some way, typically some version of hosting and/or support.
Conclusion: earning money by selling/renting the code is not allowed, even if you modify it.


Is there a way to accept inbound SMS from contacts not in your database? I have a client who has a service they'd like to merge into CiviSMS.  Strangers (i.e. not in the database) can send a text with a keyword; ideally it should create a contact with their phone number.  Using reports/Views, staff will review new incoming messages and respond to the contacts accordingly.

Is that possible with CiviSMS?

Jaap Jansma at CiviCoop has developed two extensions that do this for us. It is connected to a Norwegian sms provider, but the code is available on github.

He used a trick... To automatically create a contact with no name, but only email(as Civi requirements for creating a contact). A contact with cell phone number 123456789 would then get an email like this: 123456789@mobile.sms

This is again easy to search for or make a report for back office staff to go through. (Email adresses containing @mobile.sms)

Norwegian sms provider PSWincom

Sms autoreply


Tokens in greetings not replaced I implemented miscellaneous custom tokens and have been using them successfully in mailings and pdf generation.

But in context of greetings I came across some weird misbehaviour. I tested by changing email greeting and running api job.update_greeting w/ force=1.

When extending the token array's "contact" key with a custom token, the {contact.tokenname} markup get's interpreted but not replaced. Result is '{contact.tokenname}'.
When using custom key the markup {keyname.tokenname} is not recognized and even doesn't get into the hook function's token parameter. Result is '' and Smarty reports »unrecognized tag«.

Both tokens run fine in pdf generation.

I'm running latest Drupal 7 and CiviCRM.

Any ideas?

Thanks in advance

It sounds like the hook isn't being called (or not called correctly) when processing the update_greeting job. I think that qualifies as a bug and you could file it in issues.civicrm.org. But due to the high volume of issues, a core team member may not be available to jump on it anytime soon. I'd suggest you keep on with your debugging and compare the code that runs during that scheduled job to the code that correctly uses the hook and see how they differ. If you are able to come up with a patch that even partially addresses the problem it would help the issue get a lot more attention (issues with patches get bumped up in priority).


How to allow contributions from non-members This has got to be easy, but I am stumped.

I have set up several contribution pages. They work just fine as long as the donor is logged in to civi.

However, if the donor is not logged in, the system takes their credit card information on the form but when you press the contribute button, it blanks the form and does not continue on with the contribution process.

I assume that Civi allows unregistered users to contribute.

I am using Civi 4.6.9 on Drupal

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!


For new Contributions entered manually, how do I add an "InMemoriam" section to the manual data entry form? We occasionally receive donation cheques in memory of someone.  For the public Contribution Page I've created a profile which asks for the particulars (name, rank, other info)of the deceased but I can't figure out how to display that profile when our volunteers are entering information manually.
CiviCRM 5.35.0. on WordPress 5.7.1 | PHP 7.3.27 | Apache | MySQL 5.7.23-23

If I understood your question correctly... Profiles that are assigned to Contributions display on the New Contribution input page but they are collapsed by default. We have a custom Profile "Other Details". My first screenshot shows it collapsed and the second one shows it opened.
If you do not see it there, then go into your Profile setting and make sure it is assigned to Contributions.


Older dates for CiviEvent We're importing participant data from all our old events. However, I've run into the issue that it only allows me to pick dates back to 1999 when creating the old events. I need to go back as far as 1970. Where do I go to change that setting? I found it for activities and such, but nothing that has affected the listing for events.

As you have discovered Jenni, changing any of the start offset and end offset values in the date preferences settings do not reflect participant and event dates.

/civicrm/admin/setting/preferences/date?reset=1

So unfortunately, there is no option to make these amendments via the UI.

However, CiviCRM does allow you to manually input dates/years well before 1999/2009 which are accepted, and the records do get saved without an error –

The same method also works when importing participants.

This is a sample CSV I’ve used which had a registered date of 1966 which imported successfully –


How to generate a report on VAT collected (HST in my case) I'm sure I'm missing something obvious since I'm not an accountant or bookkeeper. I think I have everything set up to collect HST using the information at https://docs.civicrm.org/user/en/latest/contributions/sales-tax-and-vat/

The correct rate is charged and the receipt the constituent gets all look good. However the bookkeeping transaction report shows everything except the HST part of the transaction. I've tried playing with filters and columns to no avail.

Any thoughts?

Keith, Welcome to SE. Did you try extended report extension? It provides additional reports with useful columns example

Extended Report - Bookkeeping with extra fields

HTH

Pradeep


"Access denied" after IP address change (WAMP; Drupal) I wasted hours of searching Google back and forth, and found no solution:
CiviCRM is set up as an internal only CRM system for an organisation (i.e. IP address 192.168.178.36) - so far, so good. Now I took the server with me to work on CiviCRM, so I changed the IP address to 192.168.2.36 accordingly.

I've changed Apaches httpd.conf, and Apache runs without issues. Drupal seems to come up fine, but whenever I want to access CiviCRM via
http://192.168.2.36/q=civicrm/dashboard
the website answers with

a) the former IP address (192.168.178.36) in the header of the result page,

b) "Access denied - you are not authorized to access this page."

I deleted the content of all drupal cache tables, I deleted the content of the "templates_c" directory - no success :-(

Please, can someone point me into the right direction?

Regards

Bernhard

Setting up a new database isn't necessary.  For folks who encounter similar issues in the future:  after checking your BASE_URL setting in civicrm.settings.php, delete your templates_c folder (found here), clear all CiviCRM caches, and rebuild your menus.  Details on the latter two items are available here.


Is content accessed through a click-through link cacheable by Varnish or similar? I have a client whose site grinds to a halt every time they send out a mailing because of incoming traffic.  We're using Varnish without SSL endpoint termination, so right now, we're not caching those pages at all.

However, even if we install SSL endpoint termination (or use HTTP links), the click-through links are unique, even though they return identical content.  Is that content cacheable by Varnish?  Or does using unique click-through links completely break caching?

So, only the civicrm click-through requests are grinding the VM/Server?

I am not seeiing how to cache those without breaking the counter functionality.

Is site OK when not using the click-through functionality? To make 100% sure that those are the cause, and not some other Varnish config (like not caching when certain session cookies are available).

If it is really the CiviCRM counter functionality and not the pages it forwards to and you need that functionality then I only see 2 options:

upgrade the server/VM
send the mailing in batches (maybe even spread over a few days)


Conversion tracking with Google Ads on Thank-you pages My organisation got accepted for the Google Ads Grant. There are several benefits that we can only unlock if we are able to set up conversion tracking. I am trying to get my head around how this would work with civicrm and have not had much luck with an online search.

I'm trying to understand how one would set up the tracking code on the thank you pages since civicrm's thank you pages are automatically and dynamically generated. I'm therefore not sure where one would place the conversion tracking code.

Has anyone here worked out how to achieve conversion tracking with Civicrm?

Ideally the solution would allow us to easily change the tracking code so we can have the conversion of the specific thank you pages match the specific ad. Is there a way to put the tracking code into the Introductory Text or the Footer Text of the Thank-you screen within civicrm events for example?

sorry for the many questions. Just slowly chipping away at features on our wishlist and coming across questions as we tackle them.

Thanks for help here, it has been really appreciated.

We are doing this exact thing at the moment. I was kindly given some code that sends events to GA and Facebook pixel on the Thank You page by @jtwyman on Mattermost. A Civi developer worked with us on it to build an extension - and evolved it slightly to respect DO NOT TRACK.

We haven't got it working 100% yet. We have an issue that completed donation £values are not being sent back to GA (membership values are being sent correctly). It's in our Github repo but private at the moment until the issue is fixed, but happy to make public and share when it's working correctly.

I'm not sure how others are handling this.

EDIT: After Googling, I found that Matt Wire released an extension at the same time we had ours developed:

https://civicrm.org/extensions/google-analytics-event-and-e-commerce-tracking

I've raised an issue asking to have our Facebook Pixel and DNT features added so that we can just star using that rather than maintaing our own:

https://lab.civicrm.org/extensions/webtracking/issues/2


How do I bulk delete contacts? Is there a way to bulk delete contacts? I don't see a way out of the box of civicrm to select contacts individually form a report or search result, the way that views bulk operations does in drupal (with the checkboxes in front of contacts.

Yuri. You can do this from ANY search option. Delete Contacts or Delete Permanently are options under ACTIONS. You can verify this on the demo site. If you do not see same options on your system I would start by looking at the Permissions


Can I add fields to the "New Individual" popup window? When adding a new contribution we have the option of a quick entry popup for "New Individual" when associating it with a contact, which shows up as follows:

Is there a way to add additional fields here? For example, address fields and/or phone number?

Yes you can.

This form is actually a configurable profile. To edit it:

Go to Administer > Customize Data & Screens > Profiles
Click on the "Reserved Profiles" tab.
Find the "New Individual" profile and click "Fields" to add or modify the list of fields:


Navigation Menu Lost I received an update alert in the "Summary Fields" plugin. The Admin Navigation Menu has disappeared after updating. Now I get an error when I tell you to disable the plugin. The problem is that it disables other plugins. But he's giving error to Summary Fields.
There was no improvement in the problem I did with the cache and bus clearance. I'm using CiviCRM 5.9.1 when I do. I upgraded to 5.10.0, but the problem still has not improved.
Joomla 3.9.2
CiviCRM 5.10.0

https://lab.civicrm.org/dev/joomla/issues/8

It's hard to tell which version of the summary fields you are having issues with but I'm guessing it's 4.0.1 which was suppose to fix the exact same issue with 4.0.0.  It obviously doesn't. I filed another issue on github for the newest problem.

https://github.com/progressivetech/net.ourpowerbase.sumfields/issues/45

I think the fix is to change line 4 in sumfields.php

From:  use CRM_Myextension_ExtensionUtil as E;

To:    use CRM_Sumfields_ExtensionUtil as E;


Permissions, ACL and Groups I would like to confirm this statements regarding permissions, ACL and groups (Wordpress 4.7.1, civicrm 4.7.15)

Permission to edit contacts (ACL or general), allows user to
assign contacts to ANY group
As 1 is true, user can add himself to another group and thus
obtain its ACL related permissions

This is a serious issue for us as it hinders the flexible security management ACL provides. I would like to evaluate viability of a feature to solve this problem. I see two approaches:

A general permission (not ACL related, in wordpress related to
wordpress user role) which would control assignment to control
access groups (this will be enough for our organization)
As 1, combined with ACL permissions (p.e. denied general permission but
allowed assignment to certain control access groups through ACL)

I would be capable to work in any of this approaches (1 in first phase, then 2) but I am not yet very familiar with civicrm code structure. Can you point out the possible problems and difficulties of implementation of these features? Is there any related isssue in Jira?

Thank you

Permissions control is not related to Civi groups. It is controlled by WordPress user roles as you suggest for #1 fix. You should have no trouble from a security management stand point to set it up so staff cannot assign themselves to other roles.

You might want to add this plugin for better control. https://www.role-editor.com/


Sorry but we are not able I have tried to append a new contact
Contact saved
When I tried to search
this is the answer

You have experienced what is called, a CiviCRM fatal error, or as I like to say, yellow banner of death.

Please update your question with Civi version and CMS info too. Then Start here: https://docs.civicrm.org/sysadmin/en/latest/troubleshooting/

Then share whats in the logs.


Exporting Drupal user account ID's through Civi search I'm trying to export the Drupal User ID's for a particular Civi group, in preparation for GDPR and as a general clear out. I am able to search for all users in Civi which are a CMS user (and therefore have a Drupal account) but when I go to export and download this information none of the available fields will provide the Drupal User ID, the columns are just blank.

Is this my Civi getting confused and refusing to provide information (which it does do sometimes) or do I need to download this information in a different way.

Hope that makes sense and thanks for any help!!

We needed to do something similar, though not GDPR related. Because the Export does not access the Drupal user fields, we created a simple View (page display) to give us this data, based on CiviCRM Contact.

We also used the Views Export Data module and 'attached' the csv to the Page above. Note the page is not required, you can simply use the csv display via the URL you configure for it.


When switching to CiviCRM from another system, what do I need to consider? We are currently using a different software for managing members, fees and donations and now considering to move to CiviCRM because it is easier to for multiple people to work on the data.

What are general things we should consider before switching to CiviCRM?

What are important steps or best practices for a migration from a different system to CiviCRM?

Migrating Existing Data

Migrating data (and processes) from a previously used (CRM) system is not a routine task. It will probably involve discussions, how existing workflows can be represented in CiviCRM - or what might even be changed.

Data can be imported into CiviCRM in the csv format. There is a field for "External Identifier" in the CiviCRM database that can save the connection to the identifiers of records in the old system.

General Aspects to Consider

There are a number of different aspects to consider. The CiviCRM User Guide actual provides a lot of good information about this.

Cost

see What is the price of CiviCRM?

CiviCRM is open-source and therefore itself available for free but you will need to pay hosting it on a server. Also, if you're not a techie you may need to pay for an expert for installation and support.

Hosting

see CiviCRM User Guide: Hosting

If you take care of administering the system yourself on a webserver it will be cheap. If you lack the technical expertise and need a stable system, consider getting a complete hosted CiviCRM system from a provider.

Change Management

see CiviCRM User Guide: Transitioning to CiviCRM

Don't forget to get the people from your organisation on board with your plans.


Unable to download CiviCRM Unable to download from site http://www.civicrmfr.org/

"The requested URL /civicrm-{{stable}}-joomla.tar.gz was not found on this server."

But OK on Sourceforge.
Cheers.

I would suggest that you download CiviCRM from the official download page:

https://civicrm.org/download


Copying the CiviCRM installation in a different machine I am trying to make a copy of my CiviCRM installation on WordPress in a different machine. I ma mainly trying this just as a practice for future upgrading of CiviCRM versions and also as a backup.
I am caught up in a deadlock. both these options are failing. I don't which of the two options I should proceed with and how.
In machine 2,

I installed wordpress. created a database for Civicrm through PHPMyAdmin. copied the data from original database to new one. Activiating CiviCRM fails.

I installed wordpress. created a database for Civicrm through PHPMyAdmin. Activated CiviCRM. Tried copying the data alone from original database to new one. It fails with below error " Duplicate entry '1' for key 'PRIMARY'"

INSERT INTO civicrm_acl (id, name, deny, entity_table, entity_id, operation, object_table, object_id, acl_table, acl_id, is_active) VALUES
(1, 'Edit All Contacts', 0, 'civicrm_acl_role', 1, 'Edit', 'civicrm_saved_search', 0, NULL, NULL, 1),
(2, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'access CiviMail subscribe/unsubscribe pages', NULL, NULL, NULL, 1),
(3, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'access all custom data', NULL, NULL, NULL, 1),
(4, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'make online contributions', NULL, NULL, NULL, 1),
(5, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'make online pledges', NULL, NULL, NULL, 1),
(6, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'profile listings and forms', NULL, NULL, NULL, 1),
(7, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'view event info', NULL, NULL, NULL, 1),
(8, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'register for events', NULL, NULL, NULL, 1),
(9, 'Core ACL', 0, 'civicrm_acl_[...]
MySQL said: Documentation
1062 - Duplicate entry '1' for key 'PRIMARY'

See documentation on moving an existing installation to a new server or location on this link: https://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location


What payment processors will be supported in core for 4.7? For a new client install, we need to pick a supported payment processor. Many questions about payment processors support appear in this forum, in the civicrm forums and elsewhere.  The Wiki lists many and there are several extensions, with various levels of support and capabilities.

There is a general extension to support omnipay but that does not support the latest (4.6.5) version and has not had much traction.  Also, 4.7 will substantially refactor payment processing.

I would normally turn to paypal as that is in core and likely dominant, but the wiki notes say it is migrating to payflow and recurring payments require an additional fee, so I'm skeptical that this may pose risk in future versions.

Would appreciate suggestions on how to select a payment processor that will be well supported.

Omnipay should work with the latest version - but is only relevant if a processor you wish to use is currently offered through it.

If you want recurring in the US you should probably consider
IATS
Paypal
Authorize.net

in that order.

IATS is most actively developed & IATS has been investing in Civi development itself & the other 2 have the most traction - although Authorize.net has some real technical gaps - ie. they don't retry IPNS.

If you do go with IATS you should use their customer referral programme as your customer will save $100 that way. IATS will also either give you $100 or donate it to CiviCRM if you (like us) prefer not that in order to maintain neutrality http://home.iatspayments.com/civicrm-referral


Event fees not showing on info page or registration page Have set up an event with fees and pay later option (no payment processor installed yet)

The fee list does not show on the event info page,

And when following the register now link no fee option is given there either...

But if you complete the registration and billing contact details, you get an error message...

Please correct the following errors in the form fields below:
Select at least one option from Event Fee(s).

Running D7, and Civi 5.13.4

Checked on dmaster- can't replicate

Checked on another site running 5.13.4 and got the same error

Anyone else seen this?

Are there permissions I've not checked?

This was an issue with the CiviCalendar extension https://civicrm.org/extensions/civicalendar/330. Disabled the extension and it works. New update to CiviCalendar 3.30 fixes the issue.


Multi-value fields in profiles - how to? When I add a multi-value custom fields to a profile, Civi only allows visitors to enter the fields once - as a simple fields.

How to configure custom fields and profile to get form with multi-field table described in "Multi-value fields in profiles" section on http://book.civicrm.org/user/current/organising-your-data/profiles/

This table with 'new record' in form is also described there http://wiki.civicrm.org/confluence/display/CRM/Multiple-record+Custom+Data+Sets+in+Profiles

I don't think you can add multiple values in multi-value field in create mode (out of the box) at the moment.

You could have the user fill in one value and have them add more later. If you don't want the user to have to login you could send them a checksum token.


Relationships and Dashboard are broken with https I recently tried forcing https in the htaccess file and noticed that the relationships in the main contact screen disappeared.  They show up if I access them through a listing on the dashboard, but if I access the record through search they are simply not listed.  Also the dashboard doesn't display properly and can't be configured.  I haven't noticed other effects of https but they may exist too.

The first thing I'd check is whether your CIVICRM_UF_BASEURL in civicrm.settings.php is set without the https and if so, change that. Then flush caches and test again.


CiviCRM Navigation Menu is not displayed After some time working with CiviCRM, the Navigation Menu is not displaying.
I've been researching different solutions, but neither of them seem to be the issue.
Could someone guide me what I should be looking at or give me some tips to lead me to the cause of the problem?
I'm working with CiviCRM 5.32.1, mySQL 5.7.27 and php 7.3.14 on Drupal 7.69.
Many thanks in advance!

I've seen a number of causes including perhaps gremlins

Permissions on the directories used by the asset builder plug in
The URL (including either http or https) in the civicrm.settings file
Cache in both Drupal and Civi
Reset directories in Civi


Creating a relationship when filling in a Profile I love the way the "Employee of" relationship can be created simply by adding the "Current Employer" field to a profile.  Is there a corollary for other relationships?  I need to be able to track if an event registrant is connected to another external partnering organization.  However, I don't retain the membership information for the partnering organizations.

Quick example:  Create a "Church Member of" relationship to an Organization/Church while signing up for a training.

(If I missed this in the docs, oops!, please forgive me.)  It seems that most are using Drupal WebForms, which is, um, difficult? on WordPress.

It's not currently possible to create a relationship on a CiviCRM profile form similar to the Employer one when using WordPress or Joomla.

However, if you create an auto-reference field you can use that to create a link between a participant and another contact.

You can create the field on all contacts, or a contact subtype that covers all those filling in the event registration for trainingeven, or potentially registrants or just the registrants for that event. My guess is that a registrant auto-reference field is less likely to be convenient or what you want.

Don't forget that 1) the auto-reference contacts can be limited to a particular group of contacts, and 2) there are security issues in exposing contact data when using contact reference fields on public forms.


php putenv restrictions on server environment, how does this affect civicrm I've got the email below from my hosting provider "wpengine". Is it going to affect civicrm, does civicrm rely much on putenv?

On July 20, 2016, we will be hardening the PHP function putenv based on industry best practices for all PHP applications.

You are receiving this message because we have detected the use of putenv on your WordPress install(s) and plugins listed below:

Plugin: civicrm

How this affects you

After Wednesday, July 20, 2016, you will no longer be able to set system-level environment variables using putenv. Any environment variables you set with putenv will be available in your WordPress site's code as it normally would.

It might if you use something other than US english, or whatever your host has set for the system-level.

See https://github.com/civicrm/civicrm-core/blob/master/CRM/Core/I18n.php

But it will probably still work anyway because CiviCRM sets other variables too that have higher priority. See
https://www.gnu.org/software/gettext/manual/html_node/Locale-Environment-Variables.html


CiviVolunteer: Find Volunteer Opportunities would love to be able to enable/disable search options. Currently there is:
Between (date ranges), Role, With, Search by Location.
Would like to disable "Search by Location" and replace with "Project".
Also the ability to change the order.

Karen-Ann,

Thanks for your question. StackExchange is not really the best place for feature requests. In case you wish to pursue this further, I have created an issue for you in the GitHub project for CiviVolunteer.

To provide the level of configurability you describe would require a significant investment of developer hours (though some of the fruit hang lower than others). These enhancements are not currently on the roadmap for CiviVolunteer, but you may be able to hire a developer to implement them for you.

If you're really pressed to hide the "Search by Location" field, an easy way to do this is via your site's theme; the following CSS should do the trick:

.crm-vol-opp-search .crm-vol-proximity {
  display: none;
}

Note that the elements will still be rendered in the HTML, but they will be hidden from view.


Joomla timezone mismatch For some reason Civi is using UTC and not the Joomla time. The system, and php and mysql times are reporting correctly (Brisbane)
.
For Mysql I have run the following to get its time;

SELECT NOW() AS 'NOW';

For PHP I ran this

echo 'PHP date: ' . date('Y-m-d H:i:s');

Both report correct time.
I also set the time zone in a local php.ini file and php is picking this up and reporting this correctly.

The error that Civi displays shows PHP as having the wrong time.

I see a timezone table in the database which is empty. Can I hardcode it in there? What else might be going on?

It turns out joomla on the cpanel install in question linux reads the php.ini file from the /administrator directory not site root. I had put one in the root dierctory and had checked if php was reporting it correctly and it was. So now fixed.


Trouble authorizing agileware.civiquickbooks I have been trying to connect CiviCRM and QuickBooks Online using the extension from Agilware. I have followed the instructions (I think) but can't get past the authorization. I have entered the production keys on the settings page, but when I click AUTHORIZE, I get the error message (from QuickBooks) "We're sorry! We're experiencing some problems. Please try again later."

Has anyone else encountered this issue? I found other people getting this message (while connecting other apps) and I wonder if my issue is the redirect URI, but it doesn't say anything about this in the instructions from Agilware. Any help is greatly appreciated.

Steve

I see Steve did open an issue on their github at https://github.com/agileware/au.com.agileware.civiquickbooks/issues/3 which is now set as Closed with the response from the developers

  (AgileWare) have tested this using Australian QBO users - it works fine. This extension uses the QBO API to connect to the QBO services, I'm not aware of any specific reason as to why it "would not work in the US" - it should work


Reminder for Incomplete Registration (and continue...) Is it possible to track incomplete registrations in CiviEvent and send someone a reminder email, that would allow them to finish their registration?

I recently saw this on another Event Registration Platform. It was multistep, so Step 1 was entering an email address to continue. This would facilitate the system.

If you don't complete the form/pay, you are sent a follow up email with link that lets you complete your registration.

In a Drupal/CiviCRM environment, would this be possible somehow if CiviCRM could not cover the use case?

You could implement this with Webform-CiviCRM integration, assuming your registration page is a webform.  If it's not, it's still doable, but would take a bit of custom code.

First, set up a "Step 1" webform that just collects email.  On submit, redirect to your "step 2" webform (where registration actually happens), passing the email address in the submit URL.  Also add the person to an "incomplete registration" group in CiviCRM.

If event registration is a webform:

Next, grab the email from the URL on the step 2 webform. See here for detailed instructions.

On submit, use the Rules module to remove the person from the "incomplete registration" group.

If event registration is a CiviEvent form

Write a small custom module to pull in the email address on to your CiviEvent form.  Details on the technique are here.  Alternatively, skip the custom code, but then the email address won't be prepopulated.

Use CiviRules to remove the person from the "incomplete registration" group.


How do I change the address on system workflow messages? Hi "I need to change the address that is sent out on our invoices. These are in the system workflow messages and although I didn't write the code for them, I believe they may have been written in as domain address. How do I update that address please?

As far as I know:

Your default organization address can be found in Administer/Communication/Organization Address and Contact Info. That should be your $domain.address.

You can also update the sytem template Contribution Invoice Receipt and replace the default domain address with your desired address settings if you for whatever reason do not want to update your domain address.


Best Approach to Series of Events - Sold as a Package We have a 5 week series of classes - we wanted one purchase to register the attendee for all 5 weeks with one purchase.  We created a repeating event, but we were unable to turn off registration for events 2-5. What we ended up doing was creating the first event as the main event then created a duplicate repeating events with registration off, linking them all to the main event in the description.

While it has been suggested to just list the dates in the description and have the event span the weeks that the event takes place. That does not meet our needs. We want to be able to track attendees per event. For now, we will just upload the registrants to the other events and mark the attendees.

Wordpress and CiviCRM Latest

As I understand the price of the event is the same, regardless the classes the participant wants to attend. You can extend the participation with a custom field that registers to register the classes.


Is there any benefit to running CiviCRM on a non-profts website server rather than its own server? When I have implemented CiviCRM for various clients I have always set it up on its own server.  One of my clients saw some benefits in having it run on their website server - partly economics - and so it was moved.  And then the problems started...one problem was conflicts with the many Drupal modules on the website which broke various bits of Civi.  So my conclusion is that it's better to run Civi on a dedicate server where the environment can be controlled & suited to Civi.  What do others think? What are the pros and cons?

I have worked with many clients that maintain their website (usually Drupal, but WordPress and Joomla as well) and CiviCRM running on the same server, usually in the same domain instance.  I seldom have seen issues.

Now, of course, with a mis-sized or misconfigured server, you will have problems.  And if the website gets a huge amount of traffic, you will have problems.  And if your CiviCRM database has many hundreds of thousands of contacts, you will have problems. But these type of installs are few and far between.

There are definite benefits running a Drupal website and CiviCRM together.  You are easily able to embed contribution pages and event registration pages into a Drupal site. With Views Integration to CiviCRM you can pull information out of CiviCRM for display on the Drupal site.  With Webform Integration with CiviCRM you can build robust webforms in Drupal updating CiviCRM.

Ultimately, the key is properly sizing and configuring the LAMP stack, Drupal, and CiviCRM. (Additionally, try to install on a VM rather than a VPS. You want full access (ala root/ssh) to tune things up.)


Database Syntax Error when attempting upgrade I  have a website that is on Drupal 7 and I am attempting to upgrade the version of Civi from 5.10 to 5.13 but when I attempt to upgrade it, I'm receiving the following error:

Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-b_before_insert' at line 1, 1064

I have tried doing the upgrade through drush and also through the /civicrm/upgrade URL with the same error.

It's a bit of a long shot but I was hoping that someone has seen the error before and knows of a fix or how I can determine exactly what is going on.

Taking a look at the debugging information, I can see it has something to do with triggers:

DROP TRIGGER IF EXISTS civicrm_saved_search-b_before_insert [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-b_before_insert' at line 1]

After a lot of digging, I realised what was happening. For some reason, there was a second civicrm_saved_search table in the database named civicrm_saved_search-b .

That hyphen - is an 'illegal' character unless you escape it.

To resolve the issue, all I did was change the - to a _ which cleared everything up and enabled me to upgrade my site within minutes.

Hopefully, this will help someone else one day who has a similar issue!


Can members sign-up for two memberships from same organization? Is it possible to use price sets to require members to sign up to 2 membership (ideally both autorenewed)? One is an annual insurance fee, the other a monthly membership fee. I'm getting error messages at the moment when testing that states that signing up to 2 memberships from one organization is not doable.

is making a 2nd, separate organisation for the insurance the way to go?

Thank you very much for your help,
David

Yes, introducing a second "dummy" organisation is the way to go. This is described in more detail in the user documentation:

  Some organisations may want people to have two or more memberships of the same organisation that run concurrently. For example, an organisation focused on child health might want to offer a membership for parents that includes a parenting magazine and a membership for health professionals that includes a peer-reviewed journal and discounts at training events. Parents who are health professionals may want both memberships. A challenge to supporting this use case is that CiviCRM's Membership Up-Sell feature expects a contact to have only one active membership with a single organization at any given time. A 'workaround' for this is to create 'dummy' organisations for each of the possible concurrent memberships. For the situation just described, we would need to create an extra organisation for health professionals. Note that you don't have to expose the dummy organisation to your members on the website; it is for administrative purposes only.


GDPR , opt in webforms I want to send out an email to all customers currently sitting in our ‘newsletter ‘  group asking them to opt in / subscribe to being in new 'Event & training group / Updates & information group...etc. We are getting ready for GDPR / 25th May.

What would be the easiest way to do this? Has anyone got any examples of how they have done this were customers have just clicked on a links and they have then automatically ended up in a group?

Thanks
Anna

Mmm... Unless I'm mistaking your intention, this should be very easy to do with a webform, if you are using Drupal with Civicrm and the Civicrm webform integration module.

As far as I know, if your email asks them to go to your webform by clicking a link that contains the 'contact hash' token, then when they get to the webform it will be prefilled with their details.

In the Civicrm section of the webform config screens you can choose which Civicrm info to include, and also whether to add the user to a Civicrm group when the form is submitted. (You'd need to make your group in Civi before configuring this part of the webform.)

Then the user simply clicks 'submit' and they will be added to your group.

Hope I've got the right end of the stick here and that this is helpful.


Profile only works for logged in users I Have created a membership directory and it works fine when I am logged in but as soon as i log out I get this message -

The requested Profile (gid=1) 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.

i am using Wordpress

Can someone advise me of a fix :(

Thanks ... I am new to CiviCRM

https://docs.civicrm.org/user/en/latest/organising-your-data/profiles/ has all the details you should need:

  Visibility: If the Profile is being used for a searchable directory, set the Visibility of any fields you want to include on the search form to Public Pages or Public Pages and Listings. For fields that will be used on sign-up forms, set Visibility to User and User Admin only. This ensures that other visitors to the form can't view any data from the database. To use fields for Search Views, you must set Visibility to Public Pages or Public Pages and Listings. Choosing either of the Public Page options pops up two additional settings:


CiviVisualize and permissions We are using CiviCRM 4.6 with Drupal 7.  We have CiviVisualize 1.42 installed and think it's pretty great.  We just found a wrinkle though and wondered if the issue is with the extension or our (lack of) setup.

We have a few Drupal roles that do not have access to CiviContribute.  Yet when those users navigate to the CiviVisualize section (oursite.org/civicrm/dataviz) they are able to see the CiviContribute section at /civicrm/dataviz/contribute and the Donor Trends (with specific donor names!) at /civicrm/dataviz/donortrends.

I don't see any CiviVisualize permissions in our Drupal permission list and I can't think of how Civi permissions (ACLs) would/could impact the extension's permissions.  I also don't see a CiviVisualize setup page within Civi that might have settings for permissions.

Any ideas?  Does CiviVisualize follow permissions from the CMS and I'm just not seeing how to set it up, or would we need to do something different to get CiviVisualize to respect our permissions?  Thanks for the help!

I've taken a look in the code, and it looks like CiviVisualise/Civisualise/Civivisualise the missing CiviCRM visualisation extension (:P :P :P) uses direct SQL commands, meaning that certain CRM features such as ACL checks would be bypassed.

This would need changing at a code level, I'm sure Xavier would love to hear from you.

JohnFF