Successful deliveries 178%. Why? Sometimes I have more than 100% successful deliveries in the mailings. For a 2700 intended recipients I can have 4800 successful deliveries. I wonder why this happens!

This group contains around 2700 "individual" and 2500 "organizations".

Any help? Thanks!!!

It sounds like we have an overachiever here!

More seriously, I suspect that you may have found a bug in the count of recipients that occurs when you have the mailing set to email each contact, regardless of whether the email address duplicates another recipient of the mailing.

It wouldn't be surprising if practically all of the organizations had email addresses that were each actually the same as an individual's email address.  If you throw them all into one mailing (by your account and samuelsov's math), you'd have 5200 contacts.  Remove a few because they have no email, a few where the email is on hold, a few that have do not email, and a few that bounce, and voila--that's 4800 successful deliveries.

If that's the case, I suspect that the handy counter in CiviMail is simply assuming that you're using the CiviMail setting that suppresses repeat mailings to the same address per run.

You can confirm all this by clicking on the details in your mailing report and viewing the list of actual successful deliveries.  I suspect that you'll see both contacts and their organizations, many of whom have the same email addresses.


possible to create Joomla user that is not automatically activated? I have set up a profile that includes fields to create a Joomla user. That works -- when the profile is submitted, the user is created. However, that user is created as enabled, so they can log in to the website immediately.

Based on my testing, it seems CiviCRM does not respect the "new users must be approved by admin" setting in Joomla.  Is there a way to set up the system where the Joomla user is automatically created, but in a "disabled" state?  I need for an administrator to approve each new user before they can log in.

If you want this to apply for all the registrations you can do it the following way

Create a new user group and assign public as parent

and then add new users to the above group upon registration

afterwards your admin can go and move the user from public group to a registered group.

I haven't tested this but it should work


Cannot find import in menu I am running 4.7.8 but cannot find the option to Import from CSV for multiple choice options under a custom field - is this possible?.

Any assistance would be appreciated.

Thanks

Steve

For the updated question of how to import custom field multiple choice fields, see How to import to multi-record set custom fields


Is there a way to have conditional fields like in Drupal 7? I use CIVI 5.x and Drupal 7.

I would like to have conditional fields, that display is certain conditions are met, for example:

New Customer, IF group is business, show business address field, IF group is individual, show home address, etc..

Same behavior as Drupal conditional fields basically

Webform with native conditionals fields works great. [SOLVED]


Drupal login destination is ignored when members log in When members log in, they are always redirected to their Drupal user profile page, and the login destination in the URL is ignored.

For instance, when they try to access a members-only page, they are prompted to login, but after they do, instead of returning to the page they were accessing, they are send to their user profile page.  This does not happen to non-members who have a Drupal account, where they are redirected as specified in the URL.

We do have LoginToboggan and LoginDestination modules installed, but they do not seem to have anything to do with this behavior.  Any ideas why this is happening and how to fix it?  Thanks!

I use the r4032login module. I find that it often fixes issues where users hit a login-in CiviCRM page, then redirects them correctly back.


Normal to have API error while saving a Case Type? I'm on CiviCRM 4.6.18 and Drupal. When I save a case type, I keep getting an error on the top right that says "API error: DB Error: already exists." I'm not sure if this is causing another issue I'm having which is when I create a case, the loading keeps hanging.

No, not normal. And not, AFAIK a known error. In order to make sense of something like this devs usually need debugging information. There is error output in the log files in the ConfigAndLog directory - on drupal sites this will usually be in sites/default/files/civicrm/ConfigAndLog


Multiple Entry Custom Values : Find modified ID? Whenever custom data is written to the database you can use the module_custom() hook to determine what most of the parameters written were. However, I've been unable to find the 'id' of the write.

For example lets examine Custom Group Athlete

Athlete

Field 1 Label: SportPlayed

Field 1 Type: AlphaNumeric

Field 2 Label: DateStarted

Field 2 Type: Date

Field 3 Label: Enjoyment Level

Field 3 Type: Alphanumeric

Field 4 Label: Updated

Field 4 Type: Date

Now,

Lets ignore any calls that this Custom Group should really be an activity.

Lets assume there are no checks on uniqueness of data answered.

Using the $params variable from the custom() hook I can see the particulars about every field that was writen EXCEPT the ID of the entry(Not the entity ID).

Therefore, if I had The following Data

Sport Played | Date Started | Enjoyment Level | Updated
-------------------------------------------------------
Baseball     | 1-1-2012     | High            |
Baseball     | 1-1-2012     | Low             |

and I changed the first entries Enjoyment Level from High to Low, how could I also change the Updated entry to today's date? Remember that, as I understand, I don't actually know which entries are changing values from the $param field. All I know are the values submitted. I need some way find the id of the entry which is oddly not included in the $param variable Does anyone have a way to do this? I understand that if values are roughly unique I could run an SQL query to search for all matching parameters and return the ID but that seems overly complicated.

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

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

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

Check this links that posibly can help you:

Setting and getting custom field values from within hooks

Hook pre


Make badges using Event Reports How can I generate badges from an event report I created for conference registrants?

From Find Participants, you should find an option to Print Event Name Badges - you can see this here is you want to check http://d46.demo.civicrm.org/civicrm/event/search?reset=1

I do not think you can do it directly from a Report. If there is a reason why you can't easily select them via Find Participants, in Reports you can add your Participants to a Group, then use Adv Search, and select that Group, and set Display Results As, to Event Participants, then you should have Print Event Name Badge available to you under Actions. HTH


"no such field in civicrm_api3" after Upgrade from 4.6.4 to latest 4.7 I ran the database upgrade script and it showed me an error and didnt get finished..

since then I can't run the /civicrm/upgrade script and it always gives me the error:

CiviCRM_API3_Exception: DB Error: no such field in civicrm_api3() (line 45 of /usr/share/drupal7/modules/civicrm/api/api.php)

please help.. I do NOT have a backup from my old database! Is there any other way to fix this?

thxx

I'm sorry for the troubles you have had (and I guess in the future you will backup before trying an upgrade).

It's very complicated to try to determine what completed, what didn't, and how to move forward from your situation. I'd generally recommend engaging the services of CiviCRM shop that has developer experience at this point.

An approach I would recommend in this situation is to create a new CiviCRM 4.7 site, then import the data from the 4.6 database. But you there is no standard script for doing this; hence the need for a CiviCRM developer.


Form to enable existing member to edit selected value in price set I volunteer for a german NGO and we want to enable our members to easily update their yearly payment. We have the following:

A working installation of CiviCRM (v4.5.6)
A membership type we're interested in
A priceset assigned to this membership type
A custom field for the value of the selected price

I try to build the following:

  A simple form, which allows existing members to update their selected price (the custom field) from the given priceset. This requires a valid login, if there is no active session, a login screen should be displayed. The form will be embedded in an iFrame or similar.

I tried working with profiles and contribution pages but to no avail (as it is not setup as a recurring payment but rather a custom field). I found the Webform module and its CiviCRM integration but I'm not sure if that really is what I'm looking for.

Looking forward to any hints! Thanks so much.

I ended up coding a custom solution (Drupal / CiviCRM API) because I ran into many issues with our specific setup.

But I also discovered and learned about CiviCRM-Webform and can recommend it for similar use cases.


Adding Referenced civicrm_entity contact in node with email, address and phone doesnt work i still building a drupal site with civicrm and civicrm_entity support and get stucked by adding form fields for adding synced contacts.

a single contact is possible, but i need an email, phone and address field in addition. for that i used the civicrm entity reference field in the contact entity to add these references.

but it seems that civicrm_entity cant support the submission of the fields to the civicrm database, because in the time where i send the form, the civicrm id doesnt exist. for that other ref fields cant have the needed civicrmID.

did i miss something, or is this the wrong way to realise a contact submission with reference entitys from a drupal node to civi?

So I've done some development to enable CiviCRM Entity Reference (CER) fields that target CiviCRM Contacts, either via the Drupal contact edit form "/civicrm-contact/add" or via an entityreference field targeting contacts (which form has CER fields attached), that can be on nodes or other entity types, using the Inline Entity Form Single widget.

Its available now on the -dev version of CiviCRM Entity, and will be in the next beta.

Support for the Inline Entity Form Multi widget is not yet included, it will take another small leap to get it working there, although the foundation is now laid.

The functionality for inline entity forms on either reference field type has worked and continues to work for node/entity edits.


Problem with Event Calendar extension after upgrade to 4.7.3 I just upgraded civicrm from 4.6 to 4.7.2. The event calendar extension, which is supposed to be compatible up to Civicrm 4.4, actually worked fine in 4.6. BUT, in 4.7.3 it seems to work in most respects but it does not display color coding for event types. All events show up in blue. When I try to go to the Event Calendar Settings page (in the Administer/Civievents section), I get the following message:

“Sorry but we are not able to provide this at the moment.
Cannot set unrecognized property CRM_Core_Config::$civicrm_events_event_types”

Please let me know how to fix this.

https://github.com/osseed/com.osseed.eventcalendar/issues/21

The author has said he'll look into updating the extension to match 4.7 - clearly it's popular! It might be worth contacting him, particularly if you're able to help contribute to the next release.


Participant's Notes is not available in Reports I use Civi 4.7.27 on Drupal.

In the edit event registration dialog for a participant, there is a field for 'Notes' about this participant.

How can one add this 'Notes' field in a participants report? It does not appear in the 'Columns' tab of the report.

The approach we take in most installs is to add a participant custom field called something like 'registration notes'. This field can also double as a special request field that we use on front end registrations if you like. Then in reports you can have the user's requests and internal notes in the same column.


Can I configure CiviDiscount for additional participants? The CiviDiscount Extension page lists the feature "Option to apply discounts to additional participants" but I am having trouble finding that option.

I am curious if it can be extended (or used out of the box) for a workflow similar to this:

First registration of a multiple person registration is full price
Additional registrations (in the same multi-registration session)
automatically get a discount applied

Has anyone used CiviDiscount with this feature?

(Originally asked in the CiviCRM Forum)

I don't think that you can use CiviDiscount for the work-flow you are describing.

CiviCRM does have another way of registering multiple participants, and that is with the use of price sets.  You could use this to offer a discount.  However, this method would only be useful fo you if you don't need to collect any information about the additional registrants.

If you went down the price set road, you would turn off register multiple participants on the event config, create a price set and and set your event fees to use this price set.

An example price set would look something like this:

First price field: a required check-box set at $100 dollars (this handles the first registration)
Second price field: a text/numeric quantity field set at $80 that increments the registration count by 1 (for all subsequent registrations)

Note: We are not using CiviDiscount at all in the price set example above.

Aside: "Option to apply discounts to additional participants" would probably be better worded as "Discounts can be applied to additional participants" in the documentation.


Is it possible to do geocoding in cronjob only? I'd want to only do the geocoding in batch mode, because otherwise, it's too slow for my use case (petition signatures with dozen of signatures per second).

Is there a way to use the geocoding via the cronjob but disable it from the api call (contact.create)?

I suspect you can pass skip_geocode to the params of 'fixAddress' a number of ways (such as injecting it with tpl override or javascript).

Check CRM/Core/BAO/Address.php line 381-382.

// check if geocode should be skipped (can be forced with an optional parameter through the api)
$skip_geocode = (isset($params['skip_geocode']) && $params['skip_geocode']) ? TRUE : FALSE;

Leave geocoding enabled so the cron process completes it, but it is skipped when accessing via web.


CiviMail *only some* Tracked Click Throughs not Redirecting properly We have a problem with tracked click trough links ending up in a 404 Page not Found but only when the target URL ends in a hyphen.

e.g. we link to something like and end up nowhere:
https://mysite.eu/this-will-not-work-

while this works as intended:
https://mysite.eu/this-will-work-all-right

Is anyone able to reproduce?

We are on Wordpress 4.9.x, PHP 7.0 and Civi 5.3 (and planning to upgrade real soon).

This was reproduced back in 2010: https://issues.civicrm.org/jira/browse/CRM-7192

In short, this is a bug in CiviCRM that someone could fix, but it's very rarely triggered, and those who are affected haven't decided it was worth investing in the fix.


Can I use a CIviCRM Webform URL in place of the required action.unsubscribeUrl? I created a nice un/subscrube form using the excellent CiviCRM Webform module for Drupal. Now I would like to send mailings with CiviMail and include a link to my webform as the unsubscribe option.

However, CiviMail refuses to send my mailing unless I include the token action.unsubscribeUrl or action.optOutUrl in the content of my mailing.

What is the proper way to set my webform URL as my action.unsubscribeUrl?

Background discussion here. I realize there is a change that will be committed soon that will allow a token to exempt a mailing from this requirement. https://issues.civicrm.org/jira/browse/CRM-16062

You can already disable the setting so the tokens aren't mandatory, then use add your url to the webform (with the contact id and token checksum so they are "logged")

It's under Administer>civimail>civimail component setting http://d46.demo.civicrm.org/civicrm/admin/setting/preferences/mailing?reset=1


Where is the $_params field of the CRM_Contribute_Form_ContributionBase class set? I'm trying to debug a contribution page and I see that one of the contribution parameters is not set properly. I would like to see where exactly this parameter is being set so I can understand why it is not getting the proper value.

I've been looking inside the CRM_Contribute_Form_ContributionBase class and trying to figure out where its $_params variable is being set. But I have had no success.

What I've done so far (note: I'm referring to the code for 4.6.8):
1) Determined that one of the parameters in my payment processor (Stripe) is not being correctly set, and this is the cause of the error that I am getting ("Stripe.js token was not passed! Report this message to the site administrator.").
2) Saw that the contribution parameters are being passed to my payment proc.
3) Therefore, go one level up. The class CRM_Contribute_BAO_Contribution_Utils is calling the doDirectPayment() method of my payment proc. And it is passing the parameters. This calling happens in the processConfirm() method. But the processConfirm() method is itself passed the contribution params.
4) So, one level up. Now we find ourselves in CRM_Contribute_Form_Contribution_Confirm->postProcess(). So where does this postProcess() method get the contribution params from? It gets them from $this->_params (line 1037). But the CRM_Contribute_Form_Contribution_Confirm class does not have such a field. Then let's go to its parent.
5) The parent is CRM_Contribute_Form_ContributionBase. It has a $_params field. But I have not been able to ascertain where that field is set. I only saw that later on some parameters are added, however the params that I'm interested in were already set.

P.S. If someone has any tips or resources on how to more efficiently debug situations like these, please let me know. Finding out the above took me hours. I found it quite difficult to follow these parameters that are being passed around mountains of code, and most of all I could not get to the source (i.e. where they are first being set).

I highly recommend setting up an IDE with debugger so you can easily step through the code while it is executing. Yes it's a little bit of work to install and learn to use those tools, but worth it!

My IDE tells me that the $_params variable is an array declared in CRM_Contribute_Form_ContributionBase but mostly populated during CRM_Contribute_Form_Contribution_Confirm::preProcess().


Form Submissions Overwriting Existing Contacts Our form is overwriting existing contacts when a new submission is made.

All of our dedup rules are related to same names and emails; I do not see any dedup rule that would overwrite a (seemingly random) contact record with a new contact's information.

How can I prevent this in the future?

This issue began with my question here.The suggestion was excellent, and helped me get to a better understanding of what happened. But I'm still missing precisely where the overwrite is happening. (To be fair, the full suggestion is to check the logs, but I lack the ability to write a query that pinpoints what I want to understand)

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


Troubleshoot webform contributions I have a webform, which was working, which collected contributions from users using authorize.net. At the end of the form, users would check the contribution amount, the total would show, and the pieces of the form collecting credit card information would appear. But now, the fields for the credit card info are not appearing and users cannot submit the form. They get the error "credit card information needed."

One possible solution is to upgrade to 4.7, which I can do tomorrow morning, but this was working before with our current configuration. Do you have any troubleshooting tips?

Don't update to 4.7! webform_civicrm module is not compatible with 4.7 (yet).

CORRECTION: Looks like the main issue holding that up functionality w/ 4.7 got fixed last month: https://www.drupal.org/node/2661232

Give us some more details - perhaps a URL to the form - so that we can have a look.

Couple of things to check:

is the CiviCRM contribution page still working? Does it have the correct Payment Processor still attached? That's where webform_civicrm gets the Payment fields from.
By default webform_civicrm will put the $amount total and payment fields on the next page - I'm not 100% sure but I think that may be required for it to load the payment fields.
Having different pages (page breaks) in your webform makes for a nice form. I often go: Parents, Children, Waivers, Payment

Example:


Should I use cPanel on my server? If I am using a hosting provider like Bluehost, or a2, should I also use cPanel ? cPanel is an admin interface and what looks like a handy utility for administering my server. Are there advantages and disadvantages to using cPanel?

I've certainly found cPanel very useful to do lots of things and easier that using ssh access (some hosting providers might not provide that). I have found it does everything I need that can't be done in the CiviCRM UI. My hosting provider (Siteground) has moved away from it to its own control panel which covers all the same functionality and has some better functionality, but there was nothing wrong with cPanel. Of course it also depends on the functions provided through cPanel as its a toolkit and they might leave bits out.


How to report on repeating custom fields My client wants a report on a set of 10 repeating custom fields, each one of which has a date and one of a set of outcomes. e.g there is an 'Accommodation' custom field which has 2 fields - a date and a choice of various outcomes like 'homeless to hostel'. A  person can of course have more than one 'Accommodation' outcome (it's a repeating custom field). The problem is the limitation of this type of field.  Advanced search can find the data correctly (by using 'OR') but then they can't be exported as export doesn't support these fields.  So over in Reports - which can export them ('Export to CSV') - they can't be reported on because if I select all 10 sets of fields it uses 'AND' (see the SQL that's generated) which isn't correct. I can't think of a way round this using the UI. Can anyone suggest a solution, or is this simply something that can't be done at the moment?

I think you can do this either by

Creating a report and controlling the whereClause().
Use hook and alter the sql to use OR/AND.

HTH

Pradeep


Creating a custom search to produce contributions as results I've followed the documentation to create a custom search and I find this capability to be quite powerful for finding and displaying information about contacts.

Now I would like to create a custom search to show a specific set of contributions and then (most importantly) allow me to perform actions on those specific contributions (e.g. "export contributions", "send thank-you letters").

Is this possible? If so, how?

Start with the code for Find Contributions (https://github.com/civicrm/civicrm-core/blob/master/CRM/Contribute/Form/SearchContribution.php) and customize it as necessary to get the results you want, eg by hardcoding some values.

Next, choose a task similar to what you want to do from the list at https://github.com/civicrm/civicrm-core/tree/master/CRM/Contribute/Form/Task, and copy and modify it as necessary. Next, after reviewing  https://github.com/civicrm/civicrm-core/blob/master/CRM/Contribute/Task.php, find a hook like buildForm to modify the search form so it includes your new task(s).


I want to Coordinate civiCRM mailing list and SimpleNews Mailing list I send mailings two ways: via civiCRM newsletters and via SimpleNews newsletters. The problem is that I then have two different email lists, one in civiCRM and one in Drupal for SimpleNews. If users want to stop receiving emails, they have to unsubscribe twice. I would like people to be able to unsubscribe from either list, and be removed from both. So there are two parts to this: (1) on unsubscribe from SimpleNews, remove from civiCRM mailing list, and (2) on unsubscribe from civiCRM mailing list, remove from SimpleNews mailing list.

For (1), I was trying to create this rule: When an email is unsubscribed from SimpleNews (Action), then the email is also removed from civicrm group (Event). But I receive an error message: Data selector site:current-user:roles: for parameter contact is invalid. What should the data selector be? The only one that comes up as an option is "site:current-user:roles"

For (2), I have no idea how to do this. Any suggestions would be appreciated.

Final Note: What I am trying to do may not be possible without using some third party such as MailChimp to coordinate email lists.

There are a couple of workarounds that may help you.

Civimail offers a 'public' page version of the mailing. not the same thing but not sure if you knew that or not. When you set up a Mailing you have the option of setting its visibility to public, and then there are Drupal permissions to determine what roles can access this.

Also there is an extension developed by Fuzion here that lets you put a Views token in a mailing, so you can

create your newsletter stuff in drupal
create a views display for this content
put token in civimail


Undefined index: auto-renew Upon opening contribution page, we get the following PhP errors showing ABOVE the contribution pages.
See JGSNY Contribution Page
Notice: Undefined index: auto_renew in /home/jgsny/public_html/administrator/components/com_civicrm/civicrm/CRM/Contribute/Form/ContributionBase.php on line 1244
ALSO:
Notice: Undefined index: auto_renew in /home/jgsny/public_html/administrator/components/com_civicrm/civicrm/CRM/Price/BAO/PriceSet.php on line 847
Auto-renewal options are off for all contribution pages; database tables have indexes on all relevant pages. Civicrm status shows OK.
Quick answers appreciated - this is membership renewal time and must have membership renewal form working.
Thanks,
Kate

For a quick fix, change $memType['auto_renew'] to ($memType['auto_renew'] ?? 0) for the first one, and
change $membershiptTypeValue['auto_renew'] to !empty($membershiptTypeValue['auto_renew']) for the second one.


how to set permissions on individual CiviReports (permission options not shown!)? I wanted to create several reports that are limited to specific CiviCRM ACL roles.  But I can't, because when I view the "Access" tab for the report settings, there are no permission fields shown.

According to the docs (https://docs.civicrm.org/user/en/latest/reporting/set-up/#define-report-settings), I should see two fields "Permission" and "ACL Group/Role", but I do not have those on my screen. All other fields are present as shown in the docs.

Have I missed a configuration setting somewhere?

I'm using Joomla 3.9.13 and CiviCRM 5.18.2.

So after doing some research, checking on the Drupal, Wordpress, and Joomla demos, it appears that Permissioning for individual reports indeed does NOT exist in the Joomla implementation.  Very disappointing.


Can I use CiviCRM group as mailing list - or sync with Mailman? Currently I use CiviCRM as basically a "pure" CRM, and then I use an external Mailman provider to maintain two smallish discussion group lists (one with about 8 people, the other with about 50).  I have to copy & paste names from CiviCRM into the Mailman interface & make sure they don't get out of sync.

Is it possible to let CiviCRM listen to an address (like leadership@example.com) and forward all such messages to the members of the "leadership" CRM group?  If so, I could get rid of my Mailman setup entirely.

Failing that, is there a way to automatically sync between Mailman and CiviCRM so they don't get out of sync?  I can set up my own Mailman instance if I need to (currently I outsource that because my web provider, Dreamhost, has pretty bad marks on spam blacklists, apparently).

Check that extension https://github.com/fuzionnz/mailman_sync that does sync a group and a mailing list

If you were to prefer sympa than mailman, there is another extension that does the same there https://github.com/civicrm/org.civicrm.sympasync


How do I get the genuine error message I am trying to reinstall the volunteers extension and am getting an error that isn't clear. Is this my version of PHP or missing PEAR packages that is causing the lack of clarity?

Use of undefined constant PEAR_ERROR_CALLBACK
- assumed \'PEAR_ERROR_CALLBACK\'\";s:9:\"%function\";s:38:\"CRM_Core_TemporaryErrorScope::create()

CiviCRM 4.7.25
PHP 5.5.38

A look at the only code which references PEAR_ERROR_CALLBACK in CiviCRM core is telling - the file comment starts with This is an evil, evil workaround ....

So you've probably uncovered a legit unexpected bug or misbehaviour here. Something about the site setup or the volunteers extension seems to be upsetting things, but in a way that might not be experienced by the majority of sites.

Your PHP version is OK if not great, and your installed PEAR libraries should not interact with CiviCRM (which bundles its own copies of PEAR libs). So I don't think those should be your problem.

In your situation, I'd first check the Debugging and Error Handling settings (see civicrm/admin/setting/debug in your CiviCRM install) and make sure there aren't any unexpected "error callback" settings. Also check out what other extensions (especially debug related) are present in your install; try disabling those if present.

Next steps to debug would be to find backtraces in the CiviCRM debug log, and understand what code path is leading to this error.

More thoughts ... Assuming CRM_Core_TemporaryErrorScope::create() works the rest of the time, then we know PEAR_ERROR_CALLBACK is defined the rest of the time. This means that when you hit this error, you're hitting that method when PEAR hasn't been loaded at all.

The constant ought to be defined when PEAR is loaded during CiviCRM bootstrap; CiviCRM isn't going to get much done without PEAR, since it relies on that for essentials like DB access. This suggests CiviCRM has not been fully bootstrapped - we see similar issues also when the CMS is not  bootstrapped, so Drupal / Joomla / whatever functions or constants are not available.

The above could mean that the means of installing CiviVolunteer is being incorrectly applied, or that CiviVolunteer installation is broken. I don't know which; if you expand your question to describe the steps you're taking to install CiviVolunteer, that could improve the quality of answer you can get.


CiviEvent registration with pay later prevented with "missing fields" error We're running 4.6.8 on WordPress 4.2.4. I'm not finding guidance on this searching the web. Here's the CiviEvent registration page link:

http://civicrm.jrpc.org/?page=CiviCRM&q=civicrm/event/register&page_id=111

We have an event that when registering by PayPal - it all works. But if "pay later" is chosen - it's complaining about missing fields that have already been filled out (address), or for the first and last name- it complains about the Country and Billing Name & Address that are not in our requested profile. Full error below:

Please correct the following errors in the form fields below:

Billing First Name is a required field.
Billing Last Name is a required field.
Street Address is a required field.
City is a required field.
State/Province is a required field.
Postal Code is a required field.
Country is a required field.

Any ideas? Our last event (before a few civievent upgrades), this feature worked fine.

You may want to have a look at this issue.


How to include "Same as Billing/Home address" in a payment processing page? I know This can be easily done by webform. But Civicrm webform does not allow the price set to be included. So its a limitation...

We use paypal website pro service. A profile is included to the payment page to include donors home address. Is there a way to include a check box to state "Same as Billing/Home address" in the profile?

I believe the checkbox should appear automatically on a core Contribution page as long as the profile with the home address is at the top of the page, not the bottom.


How can we modify the default event badge barcode? We have a 3rd party event manager who scans bar codes, so it is great that civiCRM renders barcodes on events.

Our problem is that the 3rd party cannot process a barcode that contains a hyphen. For the event badge, we see that the barcode contains the contactID-registrationID

How can we remove the hyphen from the barcode?

We running version 4.7.16 on Joomla 3.6.5

A better approach would probably to use the Barcode hook and alter the value in there instead of overriding the core file.

https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_alterBarcode/


What of these CiviCRM features comes 'out of the box'? On the CiviCRM demo -- there are lots of great features / fields etc.  What comes standard?

I'd caution that 'standard' is a slippery word. Since CiviCRM is of the 'community' style of open source, there's no 'pro' version with extra features, so Ramesh has the right answer to that question.

On the other hand, even after you put aside the financial hurdles, there's still the complexity hurdles of additional 'features'. So another answer is that you actually get more than the demo, and still for free, as you climb these hills:

Understanding how CiviCRM can be configured 'out of the box', beyond
what you see in the demo (see ramesh's documentation link)
Understanding how extensions can be downloaded/enabled and finding
ones that match your needs.
Understanding the open sourceness and
'plugability' of the code to extend CiviCRM in ways that are
specific to your organization and no one else has (yet), by writing
your own extension and or contributing to core.

For someone coming from the WordPress community, you'll find that there are a lot more free but still high-quality extensions and not the same kind of 'market' that Wordpress world is used to.


Fetch data over the web: curl, file_get_contents or something else? I've written quite a few extensions that need a way to fetch data from the web. Sometimes I've used file_get_contents sometimes cURL, other times I've sucked in (geddit!) Guzzle. Each of those has it's own requirements.

Just want to check that CiviCRM does not offer a service/wrapper for this that knows what is available? What's recommended?

I'm unsure what's recommended, but there are several patterns (at least) through the codebase:

CRM_Utils_HttpClient, used in core functionality like system checks. This has test coverage!
PHP curl, common in the payment processors.
PEAR HTTP_Request, in older code like geocoders.
Occasionally file_get_contents() to switch things up for fun?

I like using Guzzle in extensions - but I'm uncertain what would happen if CiviCRM core now decided to bundle a different version of Guzzle to the one used in my extensions?


How to include price field data in a Contribution Thank You letter We have a need to display price field information in a contribution Thank You letter.  As the token system can't handle the price set data, I've pulled the relevant Smarty code from the receipt template, which very nicely presents all of the price fields that were selected for the contribution.

Of course when I make PDFs, its not working : )

I have Smarty enabled for email in the settings.php, and I can use Smarty logic to display content in the Thank You - so Smarty is actually working. But the beginning loop "{foreach from=$lineItem item=value key=priceset}" seems to return nothing and thus no price fields are added to the letter.

Is this possible to do?  What is needed to activate processing of price fields in a letter?

It doesn't work because $lineItem is not set in the template, you'll have to loop thorough $contribtuions and use the API:

{foreach from=$contributions item=contribution}
{crmAPI var='result' entity='LineItem' action='get' contribution_id=$contribution.id}
  {foreach from=$result.values item=lineitem}
    {$lineitem.label} // Price field label
  {/foreach}
{/foreach}

Please note: this works fine generating ThankYou's with one contribution per individual.

Related topics for more details:

How can I use custom tokens when grouping Thank You letters
Contribution Note Smarty Variable

Let me know if that helps.


How to add additional custom translation for a payment processor? I have installed a payment processor extension and it is only in english by default. The vendor delivered a .po and a .mo file with a german translation of the extension. What is the best way to implement the translation of the extension? As I'm new to CiviCRM and following what i have read in the documentation i need to do it via a team on the Transifex project?

Is this the only way? Or can i do it manually as well? It is connected to a drupal CMS and i know how to translate custom modules in drupal.

Any hint appreciated!

Just after starting the bounty i have found what i was looking for:

To merge two .po files you'll need to use some shell magic. I did the following:

extract the original civicrm.mo file to a .po file with this gettext-command: msgunfmt civicrm.mo -o civicrm.po to an empty folder
paste the .po file of the extension to the same folder
merge the two .po files with this command: msgcat --use-first *.po | msgfmt -o civicrm.mo -
replace the original civicrm.mo file on the server with the newly created one
clear cache

This is working for me. The extension is translated.


Auto-renew option not appearing for membership In Civi 4.6.12 I am testing recurring PayPal Pro payments for a membership.

A simple recurring contribution works OK once CRM-16698 in place.

However when testing with a new membership, no option for auto-renew appears. CRM-17197 fixed a similar issue when a price-set is used. Any suggestions for fixing this without a price-set?

Thanks, Chris

Chris,

I just tested this on my site, and you're right.

If you have the "Pay Later" option selected, the auto-renewal checkbox does not appear.

The checkbox should always appear, and then when the page goes through verification if 'Pay Later' is selected, and the 'auto-renew' box is selected, that should throw an error to the user.

I've created an issue report on this:

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


how to manage documentation of past events (add files, links, summary, etc) so we are using civicrm for events, webinars etc. we want to move the documentation of the events also to civicrm (photos, presentations, attendees, summary, links etc.)
for contacts its easy with the activities tabs. is there a way to link activities to (past) events. or do you know a way how to do documentation for events in civicrm?
thanks a lot in advance

You can create custom data/fields for Events and can attached the documentation.

Custom fields for events

Attach the files when you configure events

Download documentation from Event info page


Does civiCRM support RequiredIf validation for Profile fields I have dropdown with option1, option2 ... Other. I want if user selects "Other" another text field appears (slideDown) underneath the dropdown AND this text field is Required. Is it possible with civiCRM?

This was proposed as a feature for CiviCRM, but it never really got any funding: 'Other' option for custom fields

As Ben says, if you are (or have access to) a developer, it's not too hard to write this extension.  Add both the dropdown and the "Other" field to your profile, then use jQuery to hide the "Other" field.  Toggle whether it's hidden based on the value of the dropdown.

Use hook_civicrm_validateForm to set "Other" as required if the dropdown value matches the "Other" option.  By default it should not be required.


scheduled mailings dont send - civicrm4.1 If we schedule a mailing, they only ever say running in the status column but never get sent. The only way they send is if we hit "execute now", so at least we know they are no email config/password issues.

I have little experience with Drupal, CiviCRM and Linux, so don't even know where to look for logs.

CiviCRM is running off Drupal on a Linux Ubuntu vm, I've found version number for CiviCRM is 4.1, Drupal is 7.34, php is 5.59 and MySQL 5.541.

I have checked under the scheduled jobs (administer > system settings >schedules jobs) and found

I don't know where to look for the cronjob and which user it uses though. I checked the drupal user permissions and all authenticated users can view etc anythng civimail related.

I have no civicrm experience (i didnt install this), no drupal and little linux, I would appreciate some help.  I have tried following instructions on the civi site but they are not clear enough.

Thanks

Generally I have found that, if a mailing is stuck as "running", but does correctly run when "execute now" is clicked, that you have a permissions problem.

When you "execute now" the mailing is executed using the permissions of the currently logged in user.

The cron job however usually runs as a different user. This user needs minimally to have a few permissions set: view all contacts, access CiviCRM, access CiviMail.

I would first track down your cronjob to find out what user is referenced in it.  Without more details on your hosting platform its a little difficult to help you with that.  If you have SSH access, try issuing a command line: crontab -l.  If your hosting provided gives you cpanel or similar, you may be able to view the cron jobs with that.


Set defaults values and attributes to membership form fields with PHP Its possible to set default values of a membership custom fields through a civiCRM hook?
I have seen that the values are generated by ajax when membership type is changed but i dont see any hook for this.

thanks!

you should be able to do this with the buildForm hook that is described here: https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_buildForm/.
Keep in mind that the custom fields are actually posted on a different form, so I usually first dump the form names to the log with Civi::log()->debug so I can check what the name I need is.


Q: Import Field Separator bug? After trying to import event participants for many hours I discovered a confusing bug with Import Field Separator.

During import it is possible to specify which character delimits fields - comma, semicolon, pipe or even tab. In fact semicolon does not work and neither does tab. They just break the data.

It is particularly confusing because MS Excel by default exports semicolon separated files. Which I did not see the need to convert to comma-separated as CiviCRM was seemingly offering an option to specify semicolon as Import Field Separator.

Tested on CiviCRM v4.7.9. on Wordpress.
Also does not work in CiviCRM Sandbox.

This is CRM-19192: CSV values must be comma separated


How to view SearchKit's API and SQL I was following along the 1st video of the SearchKit playlist on Youtube. And approximately 38 min in, the presenter shows how one can see the underlying API code or SQL code for a given search. It looks like he simply expanded on a tab, Query Info. However this is not available for me on my Buildkit site and I'm wondered how to enable this.

I'm pretty sure you need "CiviCRM: view debug output" permission in the CMS.
Also if it's not obvious, you have to run the search first before it appears.


Can hook_civicrm_links create links beside rows of a contact's Events tab? I've looked at CRM/Event/Selector/Search.php to see it creating the View/Edit/Delete links, but am just unsure how to make this work. Can someone advise what the appropriate $objectName and $op should be? I'd like to do something like this:

function testmodule_civicrm_links( $op, $objectName, $objectId, &$links, &$mask, &$values ) {

  switch ($objectName) {
    case ???:  //Event or Contact perhaps?

      switch ($op) {
        case ???:  //a participant selector perhaps?

            $links[] = array(
                'name' => ts('Send Invoice'),
                'title' => ts('Send Invoice'),
                'url' => 'civicrm/activity/email/add',
                'qs' => 'action=add&reset=1&cid=%%cid%%&selectedChild=activity&atype=3&pid=%%id%%'
              );
          break;
      }
  }
}

Where %%id%% comes in from the context of that row in the grid. If I can't get there with a hook, would it be prudent to extend CRM_Event_Selector_Search and override the links function with my own?

$op = 'participant.selector.row';
$objectName = 'Participant';

The hook is called from CRM_Core_Action::formLink

search for the above string in CRM/Event/Selector/Search.php, and the last couple of arguments gives the needed values which is then passed on to the hook


Error during event registration linked to GDPR extension As per title, after a user registers for an event and goes through the confirmation screen, they are treated to the following error:

  Notice: Undefined index: comm_pref_in_thankyou in
  /opt/bitnami/apps/wordpress/htdocs/wp-content/uploads/civicrm/ext/uk.co.vedaconsulting.gdpr/CRM/Gdpr/CommunicationsPreferences/Utils.php
  on line 507

  Notice: Undefined index: comm_pref_in_thankyou in
  /opt/bitnami/apps/wordpress/htdocs/wp-content/uploads/civicrm/ext/uk.co.vedaconsulting.gdpr/CRM/Gdpr/CommunicationsPreferences/Utils.php on line 508

As you can see in the screenshot, their details are registered and it goes through fine in Civi's backend, we are just getting this error as well which is seemingly linked to the GDPR extension.

Due to running a hosted system, I am unable to check the PHP file but I am speaking to our host regarding this as well. I am asking here in the hopes someone has seen this before and knows what the error is expecting.

Running on Wordpress 5.3.2 with CiviCRM 5.21.1
The GDPR extension is version 2.8

Its just the warning (Notice), either you can turn off php warnings for wordpress or update the GDPR Communications Preferences settings(http://domain.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/gdpr/comms-prefs/settings&reset=1) and choose something (eg Do Nothing) for 'Add to Event and Contribution Thank-you pages' option under 'Event & Contribution thank you page' section.

HTH

Pradeep


CiviVolunteer stopped working after upgrading to 4.7-2.2.2 I'm running CiviCRM 4.7.20 and upgraded to the latest version of CiviVolunteer from the extensions directory, and now it doesn't work.

The latest version of CiviVolunteer (4.7-2.2.2) is not compatible with versions of CiviCRM before 4.7.21. You should upgrade CiviCRM to at least this version, if possible. Full details are available in the announcement.

If you are not able to upgrade CiviCRM, there are no changes to the database schema in 4.7-2.2.2, so it is possible to downgrade CiviVolunteer to 4.6-2.2.1. Download the code and replace version 4.7-2.2.2 in your extensions directory.


Upgrade Civi 4.0 to secure version What is the easiest way to get a 4.0 version of CiviCRM up to date or at least to a secure version?
Is it possible to import a MySQL dump from 4.0 version into a new clean 4.7 version?

Easiest thing to do is upgrade in stages, go from 4.0 to 4.1, then to 4.2 then you can try straight up to 4.6

This approach should mean you dont hit too many issues


Embedding Google Analytics code on CiviMail message I'm guessing this isn't possible, but it never hurts to ask...

We publish our newsletter using CiviMail and have the mailings publicly visible, then add links to the published version for people to access via our website and from social media. However, when people visit this web-based version of the newsletter, it doesn't show up in Google Analytics. Most of the other pages we make public through CiviCRM do show up because they load the full frame of our website, which includes the tracking script.

I know how to add tokens to links to have them be tracked, but is there a way to add the tracking code that is embedded in website pages to the web-based version of the message? I imagine that adding the Google Analytics tracking script to the message itself would trigger spam filters. Is there a way to have code just in the web-based version of the messages, but not in the emailed version?

This doesn't seem to be supported yet, but thanks for asking - giving voice to needs is how these things start!

Currently CiviMail generates a URL like  http://dmaster.demo.civicrm.org/civicrm/mailing/view?reset=1&id=10 which renders the mail as sent out (without site theme).

First thought: look at using your existing site theme to include your tracking codes, and display your newsletter content wrapped in the default site theme. This might be possible by commenting out the CRM_Utils_System ::civiExit() line mentioned in @diegov's answer below, or by (eg) creating a Drupal View which displays the rendered Mailing content at a similar path but without skipping the site theme.

Alternatively, a quick CiviCRM extension could detect the mail when viewed over the web and include your tracking codes?

Both of these would require some work, so consider contributing the end result back to the community if you do take it from here! And if you can't, maybe post it as a feature request on issues.civicrm.org?


How to extend Database Log Report from Contact I would like to extend standard functionality of Database Log Report generated from contact.

For now there is list of standard colums, but there is no information about what changes was made in fields. Only interactions are tracked.
I would like to have report, which will show me changes on fields, eg changes in email address.

Is there any solution for that?

See https://book.civicrm.org/user/current/advanced-configuration/logging/

But oddly that page just explains it and doesn't say how to turn it on. You go to Administer - System Settings - Misc and then turn on logging.


Cannot install extension Trying to add an extension, I get the following error:

Database Error Code: Column 'entity_id' cannot be null, 1048
Additional Details:
Array
(
    [callback] => Array
    (
        [0] => CRM_Core_Error
        [1] => handle
    )

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('ca.civicrm.moneris','Moneris','PaymentProcessorType',(SELECT id FROM civicrm_payment_processor_type where name = 'Moneris')) [nativecode=1048 ** Column 'entity_id' cannot be null]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('ca.civicrm.moneris','Moneris','PaymentProcessorType',(SELECT id FROM civicrm_payment_processor_type where name = 'Moneris')) [nativecode=1048 ** Column 'entity_id' cannot be null]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_managed (module, name, entity_type, entity_id) VALUES ('ca.civicrm.moneris','Moneris','PaymentProcessorType',(SELECT id FROM civicrm_payment_processor_type where name = 'Moneris')) [nativecode=1048 ** Column 'entity_id' cannot be null]"]
)

Is my extension out of date, or is this fixable?

~ross

The issue is -

you don't have a payment processor type - Moneris

value missing in this SQL : SELECT id FROM civicrm_payment_processor_type where name = 'Moneris'

try to setup a payment processor type first - that should fix the issue

which mean you need to install the payment processor "Moneris" first to fix the issue

thanks - I guess this helps !!!


Contribution page with cookies blocked just reloads on submission - is this expected behaviour? We recently had a donor call our office who was having trouble donating online (https://secure.wildsight.ca/civicrm/contribute/transact?reset=1&id=1).

It turned out they had blocked cookies in general and when trying to use the contribution page, the site just reloaded blank after submission (nothing was processed). We are not using a confirmation page.

Is this the expected behaviour? Should users be able to make a contribution without cookies? Should they receive an error message that tells them to enable cookies?

5.19.4 on Drupal 7.69

Yes, that's the expected behaviour.

I'm intrigued that anyone would try and make a contribution with cookies disabled - presumably they are (justifiably) concerned about privacy on the internet, but there aren't going to be many donation forms that work without cookies.

The reason you need cookies enabled (with civicrm) is because some of the form state gets saved in your session which is tied to you via your cookie(s).

Here's an equivalent issue in Drupal from 16 years ago that's still going. The proposed solution is to provide some notice to users that don't have cookies enabled.

https://www.drupal.org/project/drupal/issues/2946

Options going forward are:

Build yourself an extension which pops up a warning when a visitor to civicrm has cookies disabled.
Create a PR for core to do this.
Use an existing drupal module to do the same thing.

I'd recommend you start with an existing Drupal module and see how it works. There will be a few different ways to do this, some more invasive than others. For a core patch, I'd only recommend that it pop up after an attempted submission because otherwise you're generated some extra load and risk messing something up.


How Do I Import 75+ Groups What's the best way to batch import a list of groups? The list contains 75+ entries, so having a team member manually enter each group is not the best use of time.

CiviCRM by default does not have an option to import groups. However, there is a third-party extension that provides a user interface to import anything through the more powerful CiviCRM API.

First, install the API CSV GUI extension:
https://civicrm.org/extensions/api-csv-import-gui

Then click the new menu item that appears and select Entity to Import: Group.

Version 1.1 includes the wrong alias path, so remember to type "civicrm/" before "csvimporter/import" or else a Page Not Found error will be thrown.

mywebsite.com/csvimporter/import

should really be...

mywebsite.com/civicrm/csvimporter/import

Alternatively, install from git: https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport


Problem with register_rest_route call since 5.28.0: missing the required permission_callback argument Ever since we upgraded to CiviCRM 5.28.0, one of our sites is getting several error messages like this:

Notice: register_rest_route was called incorrectly. The REST API route
definition for civicrm/v3/url is missing the required
permission_callback argument. For REST API routes that are intended to
be public, use __return_true as the permission callback. Please see
Debugging in WordPress for more information. (This message was added
in version 5.5.0.) in [site path]/wp-includes/functions.php on line
5225

There are eight error messages in total, all identical other than naming other civicrm/v3/* route names.
This is on WordPress. The core files and all plugins are at the latest versions, and the errors persist
after we just updated to CiviCRM 5.28.3.
So far, Google has not revealed anything useful.
What might cause this problem?
Thanks!

Don't panic, the issue you are seeing is only a notice, not an error and won't stop CiviCRM working.
In WordPress 5.5, a change was made to how REST routes are registered and now required a permission_callback. For the moment, the plugin will continue to work and once the plugin author releases an update that adds the permission_callback, the notice will disappear.
The reason you may see it the notice on one site and not all is that notices only appear when WordPress is run in DEBUG mode, confirm by checking the value of
wp-config.php for
define( 'WP_DEBUG', true );

If the site showing the notices should not be in debug mode, simply change the value of WP_DEBUG to false.


CiviReport - Can Report Titles be sorted? I've created about 20 reports under Event Reports but Civi seems to sort the report titles in order of creation. Is there way to have the report titles sorted alphabetically?

I don't think there is.

I would get around this by creating a new top level menu item called "XYZ reports" (assuming you work for company XYZ).

Then you can add major categories so that you can group reports as you want. (I have finance, membership, fundraising,training and marketing  as my categories/parents for the reports.) Once you have assigned a report to the appropriate parent menu you have complete control over the order of the reports via Administer > Customize Data and Screens > Navigaiton Menu.


How to debug a recurring subscription that is not updating membership I've got a recurring membership that's not updating. I'm trying to figure out where/how to debug.

I can see that PayPal sent an IPN and got a 200 response from extern/ipn.php by looking in PayPal.
When I look at the recurring contribution in civi, I see the last updated date was Sept 3. (This IPN was a monthly recurring subscription for Oct 3). So it seems to not be registering it.
"Membership status processor (Hourly)" is enabled ("Process Offline Recurring Payments (Daily)" is not - but this isn't offline, right?)

How can I start to debug this?

civicrm_system_log contains records of all the IPNs that Civi gets.  See if it's present there.
PayPal IPNs log quite a bit of data in the CiviCRM log (in the ConfigAndLog directory), even on success.  Find the log entry and look for errors.
You can replay IPNs on CiviCRM 4.5+ using the "notificationlog" extension: Is it possible to do an IPN replay?
In some edge cases, it's worth checking your web server logs to correlate the call to extern/ipn.php with PayPal - I've seen a case where PayPal reported success on delivering the IPN - but it was to the wrong site.
You can resend IPNs from PayPal for a certain number of days after the original: https://hq.palantetech.coop/projects/commons/wiki/PayPal#Resending-an-IPN


Possible to import Contacts and Activities at the same time? Currently we are pulling multiple new contact lists from different sources daily.  They have to be imported and assigned activities in order for staff to process them as necessary.

Our process now is to import the contacts without activities then exporting them to get the Contact ID then importing activities with the Contact ID that was assigned in the initial contact import.  Is it possible to import new contacts with activities so that we can avoid the export and second import step?

I'm trying to save time and possibly automate this process.
We have to do the whole import, export, import thing a few times as different groups and activities are specific to each source we pull from.

Any tips or tricks are greatly appreciated.

Thanks

You can cut down one step by assigning the to be imported contacts an external ID; then also use that external ID to import the Activities.

Other than that - we end up writing mysql queries to import on an going basis from other data systems -  once these queries work well they can then be bundled into an extension - so admin staff can initiate/run the import at will.


Unable to get CiviCRM running on Drupal 8/Ubuntu server 18.04 LTS/Linode I have tried following the Roundearth instructions twice to get CiviCRM up and running on a clean install of Drupal 8, on Ubuntu server 18.0.4. First time through, the installer failed with a permissions error but CiviCRM reported as installed—if there's a way of reverting from this situation, I couldn't figure it out, and I ended up having to start over.

Second time through, it all looked good, but going to any CiviCRM page came up blank. Checking PHP errors, it was maxing out memory. So I increased it to 256, 512, and unlimited—each time, it maxed out on memory (3.2 gigs in the case of unlimited, whereas the server has 4), and I gave up and went home. Only to discover when I got there that the pages now loaded, and continued to load with sane memory restrictions. (???) However, there's no CiviCRM menu (it appears to be there, but empty), and when I go to handpasted admin URLs, things that are supposed to be there according to the docs are blank.

Both of these were with the Roundearth instructions—I found a different set here that I'm trying out, but I don't feel good about it.

I have to deploy a staged site by Friday, and if I can't get CiviCRM to work, I'll plow on without it—but I gather that it really wants to be installed before I start piling on other modules. Any help greatly appreciated.

EDIT: Occurs to me that I have not tried installing Drupal from apt-get (if it's there), because the Roundearth composer script had it included. Could try that next before moving on to the linked instructions. Or not, as apparently it's not in apt.

This ended up being a combination of adding the settings listed at https://hq.megaphonetech.com/projects/commons/wiki/CiviCRM_for_Drupal_8_installation_notes to  civicrm.settings.php and the file system permissions.


Walklist Splitting by Street and Odd/Even In the configuration for CiviEngage, I have selected options to have a group break between each street and between evens and odds, and then for there to be a page break between groups.

How do I generate a walk list that follows these rules? When I go to Campaigns > Campaign Reports and then print a report from the Survey I want, it gives me a list that's organized properly - by street alphabetically and then by odds/evens - but with no page breaks. The page breaks are critical, of course, to organizing the walk list in a way that makes geographic sense.

Ok, I worked it out for myself! Posting the answers here in case someone else runs into the same issue. The fundamental problem is that the location of Create Templates From Reports has changed from when the CiviCRM User Guide was created.

So now it's Administer > CiviReport > Create New Report From Template

Once there, you go to Survey Report (Detail) which should be at the bottom.

Then, select the columns you want displayed, and then in sorting select how you want it sorted -- Street Name, Ascending and Odd/Even Street Number, Ascending.

Then, on that same screen, check the Section Heading/Group By and Page Break boxes to the right of Street Name but NOT for Odd/Even (at least for me, grouping by odd/even did weird things).

The last bit of setup is under Filters, set "Survey" to the specific Survey you've set up, and "Respondent Status" is equal to Reserved.

The final step is you have to export to PDF if you want it broken up by page, as Print Report just gives you a single run of text. Ultimately it looks like the CiviEngage settings I mentioned int he OP don't do much for you.

Hope this is helpful to anyone else who's been perplexed by the User Guide not matching up to what you're seeing in your CiviCRM! If anyone else more experienced has anything to add, I'd love to hear it!


CiviContribute: transaction rate limiting Recently we've had some bots testing (stolen?) CC numbers against our CiviContribute form.  Our payment processor declines them all, but it sometimes results in our account getting suspended for 30 minutes.

Has anyone implemented per-IP-address transaction rate limiting?  As a module, or some other way?

Jim,

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

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


Is there a work around for the limit (10) of soft credits that can be added to a contribution? We need a way to work around the limit of soft credits that can be added to a contribution.  I understand the limit is 10 but that is insufficient for our needs.
Please advise.

There is technically no limit in the soft credit : it's only a limitation in the public form.

If it's a rare case i would propose to simply add the missing soft credit using the API explorer :

go to menu Support -> Developer -> API Explorer v3 (or v4 but my screenshot is in v3)
choose entity ContributionSoft, Action create and set value for Contribution, Soft Credit Amount and Contact ID
Then use Execute button

Like so :

Otherwise, you will have to create an extension to somehow overwrite the CRM_Contribute_Form_Contribution::$_softCreditItemCount value and it should do the trick :

  /**
   * @var int
   *
   * Max row count for soft credits. The value here is +1 the actual number of
   * rows displayed.
   */
  public $_softCreditItemCount = 11;


Gift Aid Declarations with overlapping dates I work in the IT department, CiviCrm isn't my forté. I have been tasked with helping the marketing department with a few issues with Civi.
One issue that I keep scratching my head about is Gift Aid Declaration. When I try to edit a declaration / add a new one, it won't allow me to submit the form as dates overlap.

x Start Date This declaration overlaps with the one from 11/05/2013
to 07/22/2014
x Start Date This declaration overlaps with the one from
12/31/1999 to 07/23/2014

Is there a setting I can change via Custom fields to allow dates to overlap?

The short answer is 'No' there aren't any settings to allow this. Gift Aid declarations don't have to have an end date, when you sign up to Gift Aid to an organisation you can effectively sign up for ever (unless you specify an end date). Bearing this mind, I suggest that you change the end date of the previous declaration to avoid the overlap.


constraint violation during event registration Getting constraint violation error during event registration. I found that, this error happening when it's saving the custom field value after saving participant info. There is a post hook in my custom module, in that i have code(civicrm_api("Relationship", "create",$params)) to create relationship for contact, if i comment that line it's working fine.
Current version am using is CiviCRM 4.6.2. This issue was not there with my previous version 4.3.5.

Can we not use create-api in post hook?

Please suggest.

If your hook relies on $objectRef being populated, check whether it actually is - they aren't always. See Should civicrm_post hook receive populated Relationship object following relationship enable/disable in UI?


How can you provide a volume discount on event tickets? I have a paid event and I am allowing users to register multiple participants. If they register more that 8 people then I want to provide a discount. In the way you might allow someone to purchase a table of 8 which costs less than 8 individual tickets to encourage them to bring friends. I want them to register 8 participants rather than using a price set to purchase a "table" because I want to collect information about each contact that is participating.

Is there a way to do this directly in CiviCRM?

I am aware I could probably make it work through webform_civicrm but would rather do it directly if possible so we do not have to build webforms for each event as well.

CiviCRM version 4.7.27 and using Drupal

The hook hook_civicrm_eventDiscount runs at the right place where you could apply discounts based on the number of people in the booking ... but there is a caution in the documentation: "This hook is outdated - notable, CiviDiscount does not make use of it."  Maybe because of that there is no guidance on how to use it.

You probably want to investigate the implications of it being 'outdated' before you choose to use this and it would be useful if someone could weigh in with some background on the comment - and ideally update the dev docs too!


Is it okay to have simultaneous data import? Is it okay to have more than one user import data at the same time another user is importing data?

We have a bunch of segmented data to import split amongst multiple employees - is it okay if two employees are uploading at the same time?

It should be okay if multiple users are not updating/uploaded same record type's same item at the same time.

Like for example if multiple users are importing a same contact record, that might cause an DB error possibly.


Increase the import limit (3MB) for Contact import I have a great quantity of Contact to import in CiviCRM and I absolutely need to increase the actual 3MB limit to, at least, 150 MB, with a view to fit my needs.

Many thanks for the help!

Regards

The size limit that is an issue is on your webserver php configuration, usually under /etc/php5 on linux

However and by experience, importing a lot of contacts via the web interface is painful. it will time out, you will need to restart and do the mapping of columns->fields, go through the wizard, wonder where it got stuck, see that civi expects "GB" and not "UK" or whatever...

It's much better to write a simple cli script that uses the api to import them, it's going to be easier to run again if needed and way faster.

importing 1.5 million organisations is definitely something you want to do from the cli if you value your time, and care about your mental health.

check out the api explorer, it will generate you the code needed to import a contact

$result = civicrm_api3('Contact', 'create', array(
  'sequential' => 1,
  'contact_type' => "Organization",
  'organization_name' => "bla",
  'api.Address.create' => array('country' => "FR", 'city' => "Paris"),
));

wrap that with your loop reading your csv and you're good to go ;)


Recurring contributions with Webform-CiviCRM? Does Webform-CiviCRM support recurring contributions for donations or memberships?

Yes, thanks to generous contributions from the community, this feature has now been added.

See this issue for details.


No New Extensions showing In the section Administer -> System Settings -> Extensions, when I click on the Add New for the list of 'native' extensions there are none there. I get the message

  There are no extensions to display. Please click "Refresh" to update information about available extensions.

Even after clicking Refresh I still get a blank page. It might be sometime similar to this bug, but it is marked as fixed:

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

If it's relevant, I also have a completely blank newsfeed on my main CiviCRM login page. It says:

  Sorry but we are not able to provide this at the moment.

My directory settings all seem to be correct, and I am using the CiviMobile extension without any problems.

I am using CiviCRM 4.7.12 on Wordpress.

===

Update: it started working again properly. No idea why...! Case closed.

I have tested the same against civicrm 4.7.12 against Drupal and wordpress  - I do get the extension list - so I dont think this is to do with civicrm 4.7.12 -

May be please check if you have dropped the extension in the correct location also make sure your directory path is point to the correct location-

If nothing works try to clear your cache and try again

I guess this helps!!!


Why are contacts not receiving emails when do not email not checked? I have a group of elected officials that I regularly email with updates. When I try to contact them, I get the error "Email will NOT be sent to 4 contacts - (no email address on file, or communication preferences specify DO NOT EMAIL, or contact is deceased)." However, when I search for contacts matching one or more of those flags + belong to the group I get no results. I figured out which four contacts it is, and there is an email on their profile, the email is not being held, the DO NOT EMAIL box is not checked, and the contact is not marked deceased.
Is there something else I may be missing? It's pretty important to us to get our messaging to these officials as they hold serious sway over our operations.

This is occurring when viewing the group and clicking "send email to contacts," I have not checked the mass mailing tool.

I'm using civi 4.6.9 on Wordpress 4.1

You may have zombies. I use this term not because it's almost Halloween, but because imports can leave you with undead contacts, and this may be a variation of that.

Boolean (yes/no) fields in CiviCRM have the value 1 or 0, but it's possible in the database for the field to have a null value.  When you create a contact manually, the Is Deceased, Do Not Mail, etc. fields are set to 0, but if you run an import with one of those fields and only mark the dead or no-mail people with 1s, the rest will have the value as null.

When viewing a contact, it will only display deceased or do not mail if those values are 1. When sending email, it will only send if those values are 0.  Hence, you have this mysterious issue.

I suspect you may have imported elected officials, included Do Not Email, but neglected to fill the zeroes where it's okay to email.  Xavier's solution should work: by editing and re-editing the field, you can reset the value.  It gets tedious for a bunch of contacts, though.

In the database you can execute the following query to fix this:

UPDATE civicrm_contact SET do_not_email = 0 WHERE do_not_email IS NULL;

Repeat for is_deceased and any others like that you want.  You can also find these contacts in the Search Builder and use Batch Update Via Profile on the results, using a profile with Do Not Email in it.


CiviCRM Resourse URL incorrectly configured in the CiviCRM Admin page Unfortunately, I configured the CiviCRM Resource URL incorrectly in the Admin Page, instead of writing civicrm.root, I typed "civicrm_root.url" and although $civicrm_root is correctly configured in civicrm.settings.php it is not possible now to access CiviCRM as it throws:
RuntimeException: Cannot resolve path using "civicrm_root.url" in Civi\Core\Paths->getVariable() (line 140 of C:\Apache24\htdocs\drupal\sites\all\modules\civicrm\Civi\Core\Paths.php).
How can I change now CiviCRM Resource URL without accessing the admin user interface?
Any help will be very much appreciated!

Try accessing directly using /civicrm/admin/setting/url?reset=1

That setting is written to the database.  You can edit it (or delete it) by looking in the civicrm_setting table, with the variable name="userFrameworkResourceURL".


Online registration - fill-in boxes both above and below text Is there any way on the online registration page for an event to include the fill-in boxes for name, email etc. both above and below several paragraphs of text?  Right now it is only appearing below the introductory text.

The idea is to handle two scenarios: 1) Someone comes to the page ready to register and can do so right away without having to scroll down through the introductory text, 2) Someone comes to the site, scrolls through the introductory text and can register without having to go back up to the top to register.

So, two identical sets of fill-in boxes, one set before the introductory text and one after.

WordPress 4.7.4 CiviCRM 4.7.17

There are a few options to accomplish this depending on your needs.

If you are using a WP shortcode on a page you can have text above and below the registration block. This option allows specific intro text or text after registration form but does not insert text in specific areas of the form.

If you use multiple profiles on the page You can use the pre & post form help entries in the profile settings to add specific text.

Finally in the individual fields there is also the options to add pre & post help. In these fields you can use html tags to format text the way you wish.

Some custom CSS may be necessary to get things the way you like. Hope these options help out.


Label printing: how can I only combine people with relationship There is an option to combine people at one address to get just one printed label, but this is no good for us as we have congregation members living in the same old person's home who should all get an individual mailing. What we really want is only to get combined labels when the members are linked by a relationship. Is there any way of adjusting the mailing label printer to do this without artificially messing around with the mailing addresses to avoid duplicates for the old person's home?

If you use households and have the spouses, children also have a relationship of member of household or head of household, then the check box "Merge labels for contacts belonging to the same household" will do what you want.


How to retrieve custom field image files? How can I retrieve images uploaded in custom field sets for contacts? Could you get a URL for them the same way you can for the contact "image_url" in the API?

When I look up the custom field for the file in the API, it just returns a number. I looked at the code docs for the Attachment entity in the API, but this seems to be more suited for non-image files, unless I'm mistaken. I am looking to call the API and display these images on a web page.

I'd appreciate any help I can get, thanks.

Without more context about what the API call you're making is, I can't say why it just returns a number.  Here's what happens when I call the API from my command line to get the results of the attachment with an ID of 1:

» cv api attachment.get id=1
{
    "is_error": 0,
    "version": 3,
    "count": 1,
    "id": 1,
    "values": {
        "1": {
            "id": "1",
            "name": "Project_Properties_dmaster_677.png",
            "mime_type": "image/png",
            "description": "",
            "upload_date": "2018-11-27 22:19:47",
            "entity_table": "civicrm_activity",
            "entity_id": "628",
            "icon": "fa-file-image-o",
            "created_id": "",
            "url": "http://dmaster.localhost/civicrm/file?reset=1&id=1&eid=628",
            "path": "/home/jon/local/civicrm-buildkit/build/dmaster/sites/default/files/civicrm/custom//Project_Properties_dmaster_677_ab277eebda5f50aeb9910018ab356f34.png"
        }
    }
}

It returns the URL property which I can output in an HTML file within an <img> tag to display the image on a web page.


Is PHP 7.4 fully supported? We've just updated to PHP7.4 and it seems to be working ok, but without extensive testing it is hard to know.

PHP 7.4 is not even listed on the requirements and compatibility page.

Not yet officially. If you want to track progress you can subscribe to the ticket at https://lab.civicrm.org/dev/core/issues/1496 and its subtickets.

If you find some issue feel free to report it in a ticket there.

The money_format issue might be something you could look at. If you're testing I'd look closely at how money amounts are formatted on the screen and in receipts - that kind of thing.


Civicase Dashboard - reordering case types Running Wordpress 4.3 , and Civi 4.6.8.

My organisation currently has around a dozen Case types, and we will soon have more.
In the CiviCase Dashboard, these are listed under "Summary of Involvement" Table.
We would like to re-order the table to make it more logical for users to find the right one. The same issue applies to the Case Type Drop down when creating a new case.

My primary issue is - Can anyone suggest the best method for reordering these case-types?

Currently I cannot understand any logic to the order the they are listed - not by the order they were created, nor alphabetically, and not as i tried, by changing the 'weight' field as found in the db. (What even is this used for?)

Thanks

The Comment from Demerit is correct.
Rewriting the order of 'weight' in  civicrm_case_type - then flushing civi and browser cache - correctly reordered the lists.
(I'm not exactly sure why this didn't seem to work the first time)
Thanks


Drush cannot disable civicrm debug The drush command drush civicrm-disable-debug returns error The drush command 'civicrm-disable-debug' could not be found.  Run 'drush cache-clear drush' to clear the commandfile cache if you have installed new extensions.

When entering drushto get the list of all commands, the disable command is not displayed, but the enable command is. The enable command works, and both are declared in the same way in ~/sites/all/modules/civicrm/drupal/drush/civicrm.drush.inc:

/**
 * Implementation of drush_hook_COMMAND_validate for command 'civicrm-enable-debug'
 */
function drush_civicrm_enable_debug_validate() {
  return _civicrm_init();
}

function drush_civicrm_enable_debug() {
  $settings = array(
    'debug_enabled' => 1,
    'backtrace' => 1,
  );

  foreach ($settings as $key => $val) {
    $result = civicrm_api('Setting', 'create', array('version' => 3, $key => $val));

    if ($result['is_error']) {
      drush_log(dt('An error occurred: !message', array('!message' => $result['error_message'])), 'error');
      return;
    }
  }

  drush_log(dt('CiviCRM debug setting enabled.'), 'ok');
}

/**
 * Implementation of drush_hook_COMMAND_validate for command 'civicrm-disable-debug'
 */
function drush_civicrm_disable_debug_validate() {
  return _civicrm_init();
}

function drush_civicrm_disable_debug() {
  $settings = array(
    'debug_enabled' => 0,
    'backtrace' => 0,
  );

  foreach ($settings as $key => $val) {
    $result = civicrm_api('Setting', 'create', array('version' => 3, $key => $val));

    if ($result['is_error']) {
      drush_log(dt('An error occurred: !message', array('!message' => $result['error_message'])), 'error');
      return;
    }
  }

  drush_log(dt('CiviCRM debug setting disabled.'), 'ok');
}

What to do to "enable" the "disable" command? Meanwhile, i use phpmyadmin to change the value of the field "debug_enabled" in the table "civicrm_setting" to "i:0;" (without the ").

Config: Drupal 7.53; CiviCRM 4.7.14

The civicrm-disable-debug command isn't defined in civicrm_drush_command().  See line 155:

$items['civicrm-enable-debug'] = array(
  'description' => "Enable CiviCRM Debugging.",
);

To solve this problem, you can add this below that:

$items['civicrm-disable-debug'] = array(
  'description' => "Disable CiviCRM Debugging.",
);

This would be an easy item to submit as a pull request so everyone could benefit.


Wordpress install fails : Fatal Error: Uncaught I'm having an issue installing civicrm against a WordPress install.  Plugin is installed.  wp-content>uploads>civicrm is present, writable, and empty.  I have specified a separate database to use.  However, I was encountering the same issue when I tried to install against the WP database.  This is the error I am receiving:

Fatal error: Uncaught Civi\Setup\Exception\SqlException: Cannot execute CREATE TABLE civicrm_extension ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Local Extension ID', type varchar(8) NOT NULL , full_name varchar(255) NOT NULL COMMENT 'Fully qualified extension name', name varchar(255) COMMENT 'Short name', label varchar(255) COMMENT 'Short, printable name', file varchar(255) COMMENT 'Primary PHP file', schema_version varchar(63) COMMENT 'Revision code of the database schema; the format is module-defined', is_active tinyint DEFAULT 1 COMMENT 'Is this extension active?' , PRIMARY KEY (id) , UNIQUE INDEX UI_extension_full_name( full_name ) , INDEX UI_extension_name( name ) ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC: Specified key was too long; max key length is 767 bytes in /var/www/vhosts/.org/httpdocs/wp-content/plugins/ in /var/www/vhosts/.org/httpdocs/wp-content/plugins/civicrm/civicrm/setup/src/Setup/DbUtil.php on line 204
Any thoughts on where to start? Happy to provide any info needed to help troubleshoot.  Thanks in advance.

Welcome to SE CiviCRM
You will need the following MySQL server configuration:
innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=true

add above configuration in your my.cnf file.
See mysql requirement for CiviCRM


CiviMail - Sender appearing as "Info #NAME?" When emails we send from Civi are viewed on phone devices, the sender in the preview appears as 'Info #NAME?'. On desktop, it works fine.

Can anyone identify the problem/suggest solution?

Thank you

Holly

The first place to check is here:
/civicrm/admin/domain?action=update&reset=1

FROM Name
FROM Email Address


Report on deleted contributions When contacts are soft deleted, their contributions diseappers from the basic contribution reports.

What is the best solution to be able to display reports of contributions both from active and deleted contacts?

The only way i can think of is to create a custom report where you could use the criteria you want in the sql queries. i.e. remove the civicrm_contact.is_deleted = 0 in the WHERE clause.

But as mentionned by JoAnne, you may not use the delete appropriately. The soft delete only exist to avoid an entry error. Deletion (even soft delete) should only be used when the contact is a wrongly created contact (duplicate, error while importing, spam).

Anyone with valid contribution, that you want to keep track of, should not be deleted. If it's a duplicate, the contribution will be attached to the other version of the contact so it won't be lost.


How do I get csv file of Gmail contacts to import? I am trying to import a Google Apps Contacts list in csv file format. I go through the steps; it goes through the motions of importing the file, but no contacts are added.
We're running CiviCrm 4.7.8. It's a trial run on a friend's Wordpress account. We get a System Status:Error message that everything's not configured yet e.g. No Cron Running.
Any ideas?

That cron is not running is not affecting the import process.

Ideas - in no particular order:

Perhaps your csv needs some formatting? Do you have columns for First Name; Last Name; Email adress and are they all in expect format? Email address should just be email address only (so separate columns):

Mary (in column 1)
Smith (in column 2)
Mary.Smith@example.com (in column 3)

I find that MS Excel does not always give me a correctly formatted importable CSV file... so I always use Open Office instead - just look and save
is the upload directory writable by the user the webserver runs as? Not sure where that lives in Wordpress; in Drupal it's files/civicrm/upload


How do I add in a new Activity Type for CiviCampaign? How do I add in a new Activity Type for CiviCampaign?

I can see how to do this via  CiviCRM » Administer CiviCRM » Option Groups  » Activity Type Options for Contacts only.

Any help would be great!

You cannot do that anymore through the user interface. In previous versions of CiviCRM you could define the activity for contacts and cases, or cases.

As Erik said, any activity could be linked to a campaign, there is no restriction on that. So there is no need to to define whether you want use an activity only in campaigns.


How can I send a different Scheduled Reminder to recurring memberships? We want to set up a scheduled reminder for memberships that are about to expire, but we don't want to send it to people who have selected the automatic renewal option. How do we do it?

If your membership type allows recurring contributions (auto renewal), when creating the scheduled reminder you will see additional options to specify whether this reminder is for non-recurring, recurring, or both:


I am trying to insert custom tab into Activity tab but it is not working I am creating new extension.
I am adding a new custom field into Activity tab but it's not working

//Creating a custom group for survey

function custom_group_create_survey(){
$survey_custom_group = array(
    "id" => "10",
    "name" => "API_survey",
    "title" => "API survey",
    "extends" => "Activity",
    "extends_entity_column_value" => [
        "1"
    ],
    "style" => "Inline",
    "collapse_display" => "1",
    "weight" => "   3",
    "is_active" => "1",
    "table_name" => "civicrm_value_API_sur__5",
    "is_multiple" => "0",
    "collapse_adv_display" => "0",
    "created_id" => "2",
    "created_date" => "",
    "is_reserved" => "0",
    "is_public" => "1"
);

try{
    $result = civicrm_api3('CustomGroup', 'create', $survey_custom_group);
}
catch (CiviCRM_API3_Exception $e) {
    // Handle error here.
    $errorMessage = $e->getMessage();
    $errorCode = $e->getErrorCode();
    $errorData = $e->getExtraParams();
    return array(
        'is_error' => 1,
        'error_message' => $errorMessage,
        'error_code' => $errorCode,
        'error_data' => $errorData,
    );
}

return $result;

}

function custom_field_create_survey() {
$params = array(
    'custom_group_id' => 10,
    'name' => 'test_textfield2',
    'label' => 'Name1',
    'html_type' => 'Text',
    'data_type' => 'String',
    'default_value' => 'abc',
    'weight' => 4,
    'is_required' => 1,
    'is_searchable' => 0,
    'is_active' => 1,
);

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

return $result;

} ##

I am calling these functions into following hook

function surveytab_civicrm_install() {
custom_group_create_survey();
custom_field_create_survey();

_surveytab_civix_civicrm_install();
}
 ##

I have an example of how I deal with creating custom groups and fields in an extension here: https://lab.civicrm.org/partners/civicoop/dmgeneriek/tree/master/CRM/Dmgeneriek/ConfigItems

The definition of the custom groups and fields are in the resources folder in json files
The ConfigItems class is initiated in the Upgrader (see https://docs.civicrm.org/dev/en/latest/extensions/civix/#generate-upgrader)

I recommend avoiding using hard coded custom group id's in your code.


CiviCRM Entities module makes error 500 to site I'm doing a drupal installation 7.56 with CiviCRM. When I install the CIVICrm Entity module the site starts getting error 500.
DOes anyone knows what to do?

best regards
Eduardo Catarino

Hi to all and thanks for the ones that gave some clues that helped me to solve the problem.

I was using the drupal and CIVICRM with 2 diferent databases. For that reason after installing the CIVICrm entity module everithing seem not to work.

I checked the civicrm bitnami installation and realized that it was working only with one comon database.

I'm able advance with the project.

Best regards
Eduardo


How to fix stripe webhook settings? I am on civi 5.16.3, drupal 7.X and stripe 5.4.1
and when setting up stripe webhook, keep receiving this message. how can I fix it please? Thanks

I would follow the instructions on screen:

Log in to your Stripe account, go to the Webhooks section
Delete the existing webhook (on live and testing sides)
Come back to CiviCRM and use the "Update/Create Webhook" button


How to restore the colour button in Ckeditor When I upgraded a site from 4.6 to 4.7 Ckeditor lost several buttons - Font, Size, Foreground Colour and Background Colour.  I figured out how to restore Font and Size but cannot see how to get the 2 colour buttons back.  I went to display preferences and set colorButtonbackStyle(Object) and  colorButtonforeStyle(Object) to true, saved and cleared caches, but no buttons showed up.  Am I wrong to use this GUI and so should I be updating a config file somewhere?

If you go to civicrm/admin/ckeditor?reset=1 you should be able to activate the plugin "Colorbutton".


Notification for failed payment transaction is there a way to get a notification of some kind for when a recurring payment hasn't gone through? Maybe with membership rules?
We've had it a couple of times now that payments haven't gone through for insufficient funds for example and we only find out about it by chance a few days later.

Thanks again for the help

The answer depends on the Payment Processor you’re using. We have that option in the iATS Payments Extension and we can do that because its recurring payments are initiated/controled from within CiviCRM.

If you’re using another payment processing that processes a recurring contribution off-site and then notifies CiviCRM you will likely have to get into that Payment Processor’s admin/config and look for such a notification option.


Need to show profile on event for someone logged in I am trying to set up an event registration form. The guests are asked to bring a food item to share, and the committee wants to know who is bringing what, so they want the user to enter a description of what they are bringing.  From what I have read, I set up a profile with an added field. The problem I have is that when a person has logged in to Wordpress, the profile does not show up rather the page shows their name and asks if that is for whom they are registering.  Is there a way for the added fields in a profile to always be displayed? Is there a better way for me to try to do this?

If your profile includes some custom fields, check your permissions to ensure that those logged-in users have permissions to access the custom fields.  (And if users don't have to log in to register, make sure anonymous users have that access too.)


Simplenews vs civiMail I'm considering using Drupal's simplenews module for sending (most of) my email newsletters, rather than civiMail. Are there any disadvantages to doing this?

The background is:

Drupal 8 and civi 4.7 (when I go live later this year)
Mandrill to power the actual email sending
All newsletters will contain a single news item, not a collection of
multiple items
I want email to be sent when the news is available, not weekly or monthly
I want my news creators to be able to have the simplicity of just
creating an article and giving it a tag, without having to worry
about enews complexities.
I want my news items to appear prominently on the website
I want various other bits of content to automatically appear in the
email  (coming events etc).

Given this, it seems to me that what I'm doing is basically automating the emailing of a Drupal content item (rather than creating a bespoke newsletter), and so it's better to use simplenews for this.

The only disadvantages I can see are:

if I want to show, edit or automate the subscriptions in Civi,
I'll have to create groups and use Drupal Rules to sync the civi
groups to the simplenews subscription preferences.
If I want civi and simplenews to update each other with knowledge about changed email addresses etc., I may have to use Rules for that also.
I
probably won't be able to personalise emails with tokens based on
civi information about the contact. (which I don't mind)

Are there any other disadvantages to using a simplenews & Mandrill setup in this way? Any reasons to prefer civiMail? Do I seem to be thinking about this right?

thanks for your thoughts,

Jonathan

It's technically possible to use either CiviMail or Simplenews, but the real questions in my opinion, are:

What else are you using CiviCRM for?  Donations, memberships, etc?
If you're using Civi for lots of things, wouldn't it be nice to run reports on Donations vs. Mailings and keep your data in a single place: CiviCRM?


How to remove contact from group using CiviCRM Entity and Drupal Rules It seems like it should be possible to use Civicrm Entity and Rules to remove a contact from a group, but I don't know how to fetch and change the status of the contact in the CiviCRM Group. The best I've managed is setting the "is_active" flag on the group, which isn't helpful.

I've seen this question: How can I use Drupal Rules to remove a contact from a group, and I realise doing this is possible using the CiviRules extension, but it is not working (probably because I have civirules 1.3 and can't upgrade because the server runs PHP5.3).

Just added a rules action "Unassign contact from group" to the dev release of CiviCRM 2 days ago, along with "Assign contact to group"

This will be in beta7 when it gets released in a couple of weeks, after some new PRs get tested and merged in.

If you have the user object you can use the "Load or Create CiviCRM Contact" action, then use the "Assign Contact to Group" action, to assign the contact one or more groups

This issue had some basic instructions:
https://www.drupal.org/node/2854256

Get the dev version here: https://www.drupal.org/project/civicrm_entity/releases/7.x-2.x-dev

or beta7 or above when it comes out...


Recommended CMS for CiviCRM The CiviCRM download page shows that it is available for Drupal, WP & Joomla
I came across CiviCRM via the Joomla Extensions directory, but it seems not everything is equal among the CiviCRM installs; in particular no sample data for Joomla.  I also had problems with the 4.7.6 build and not until I tried the 4.7.7 did I get anything up and running under Joomla - but the dashboard doesnt load (I'm using WAMP for a dev environment).

What is the most supported CMS from the 3x available as far as CiviCRM is concerned.

We use Drupal exclusively for all our projects. Many advantages such as drush; views integration; webform_civicrm module!

CiviCRM is CMS agnostic - and the community will support all three CMS-es. Most are on Drupal and Wordpress though so to get help - that's your best bet.


Where does the content of a bulk sms get stored? Emails, pdf's, and single sms get their content stored in the field "Details" in the activity.

That is evidently not happening with bulk sms. Where do CiviCRM store the content of a bulk sms that has been sent out?

I figured it out.

It is stored in the table civicrm_mailing as body_text or body_html