The problem may have had to do with SSL certificates. Callback was using a HTTPS POST callback URL but no SSL certificate was in place. After switching the callback URL to HTTP POST, we are now receiving inbound texts. We are still getting Schema Validation Required responses. Will post again if having an SSL cert makes those go away.


This seems to be the same as upgrade of civicrm fails with parse error. You need to have php 7.x on the server not php 5.x.


Missing Custom Activity Field Data When the Activity is Filed on a Case.

First check the log files (Where are the "ConfigAndLog" and "templates_c" directories?) and see if there's anything obvious happening there.

Otherwise if you can debug in CRM/Activity/BAO/Activity.php in the copyExtendedActivityData() function that should help track it down. That's the function that gets called from _convertToCaseActivity() in CRM/Case/Page/AJAX.php to copy the custom data and attachments.


CiviRule Error on Event as Linked Trigger

Thanks for reporting this CiviRulesbug, we appreciate it!

CiviRules, as you might know, has been developed by CiviCooP to suit the needs of some of our clients who meanly deal with fundraising. So the conditions and actions on Contributions are fairly well tested and stable.
Althought we developed CiviRules initially, it is a community extension and we do not feel we are the owners. We do not fix all issues with CiviRules, much like the CiviCRM core team does not fix all issues with CiviCRM. It is a community effort, of which we will take our part.

Based on this, would you be able to dive into this issue, debug it and solve it? The technical documentation on the wiki (http://wiki.civicrm.org/confluence/display/CRMDOC/CiviRules+-+how+to+make+your+own) should give you an idea how the engine works. I would start with testing the condition with other actions to find out if the problem is in the condition or in the action. As you already done part of this, it is probably best to start debugging in the condition and more specifically the isConditionValid function.

If not, would you have the funds to pay someone to fix the error? Or are you just reporting it and happy to wait for someone else with the expertise or funds to fix it?


You can create your own event registration pages using HTML and profiles. You can use the APIs if you want to create different administration pages


How to find CiviCRM version in SQL from a database backup

You could use phpmyadmin and look in table 'civicrm_domain' at field 'version' - the version is stored there.


How to make a membership renewal form pre-filled with last year's values?

I am not commenting on the key part of your question (too late at night) but just want to be sure that you are aware of ability to send out 'checksum' in your reminder emails, so when the link is clicked by the renewing member they arrive at a Contribution/membership page and the user is temporarily logged in so the form pre-fills. That way the system knows who they are and will treat them as an existing member who is trying to renew. It won't, afaik, show how much they paid last time, but it will default to their existing Membership Type - which might be the same thing depending on how you set up your Price Set and Membership Types. Good luck


I figured it out on my own.
To print
 on different pages, it needs to be positioned relative.

So, I ended up putting all the existing
 with position absolute into a
 with position relative.

However, that is not sufficient enough, I also needed to fill in a simple
 tag as well.

This worked:


HTTP ERROR 500 for New Mailing after SendGrid SMTP Relay setup

More often than not, I find 500 errors to be server errors where I need my host's help with it. It could be that a php setting is not high enough, such as memory allocated or execution time on a script. I also get it when I am running into a security issue on the server. Usually tech support has me try the process while they are working with me so they can see the server logs in real time. They just need your IP address first so that they can follow along.

What CMS are you using? If it's Drupal, I can tell you real quick how to find your PHP settings. Not sure if it is in the same place in the other systems.


The width for Select2 fields is set as an inline style to the element itself.  So, to override the inline width, you'd have to use !important in your CSS.

For reference: https://stackoverflow.com/q/16813220


Not sure that I have Contribution Tracker configured correctly

It looks like you're not using the jQuery snippet mentioned here to populate your hidden values.

Also, there's a Google Summer of Code 2015 project that will hopefully make this question obsolete: Also, this may not be ready in time for you, but some of what you want is coming to core: forum.civicrm.org/index.php?topic=36091.0


John

My immediate thinking is that you will probably need to do some form of iframing on the block. The reason for that is that i don't think i can think of a way to have proper session keys and static html copied across. The session key is generated when the first step of the form is loaded. You may also need to look at a drupal module like themekey if you need to switch themes to make the iframe look nicer in the block

Seamus


Participant Status vs. Participant Status ID

I don't think anything has changed.  Every participant status has both a label/name as well as an assigned ID (integer) value.  The search builder lets you construct a search using either construct.

I do see on the 4.6 sandbox, that when I select to search on Participant Status ID that its possible option values are the names rather than the ID's.... however the result set still came back correctly and displayed the ID's.

I suspect this behaviour goes back to v3 days.


Non-admin user can't reserve survey respondents without getting error "Missing Interviewer contact."

I believe you also need the "CiviCRM: access contact reference field" permission, based on what you're reporting.


How to add Each Contact Membership fee using webform civicrm in drupal7

The first problem I see in your screenshot is that you've set up Contact 1 as an organization. Really, contact 1 needs to represent the person who is filling out the webform and paying for the membership. An organization, generally, cannot operate a keyboard & mouse. Fix that and the rest ought to make more sense.


Site broken. How do I fix Couldn't repair table: civicrm.log_civicrm_status_pref?

Found the problem. Corrupt log tables. Causes MEGA-chaos for poor mysql. It's crash-a-roo anytime a CiviCRM table is used.

To resolve,

Find where the civicrm databases are stored. If on a typical *nix distribution and using mysql, likely /var/lib/mysql/civicrm

Shutdown mysql (service mysql stop)

Create a new directory (mkdir logtables), now move all the log tables into that directory (mv civicrm.log_* logtables)

Clear out the error.log files so you can see what is happening each time you start mysql. To do that cat /dev/null >/var/log/mysql/error.log (this assumes the mysql server log file is located at /var/log/mysql, which you'd check before issuing that command)

Start mysql (service mysql start)

If you do not have root privileges the OS will freak out when you attempt to move the log tables. Suggest elevating your privileges to root either using sudo (e.g. sudo mv civicrm.log_*) or su root, then go crazy but not too crazy. Remember, there's no undo in Unix/Linux. After starting mysql, check the mysql server's log file to see if it's happy again.


How do I get CiviXero to process contributions missed in the first run?

How do I get CiviXero to add a specific contribution to it's account_invoice table for consideration?

I think if you just edit and save the contribution, it should be added to this table (provided it does not end up with any error).

  How do I get CiviXero to process a specific contribution. I've tried invoice push job with contribution_id as the argument. Without the item being in account_invoice it doesn't consider it as needing being pushed.

Only the rows present in "civicrm_account_invoice" is considered by the civixero extension to push to xero. So if the contribution id is not present in this table, you need to make sure it does.

After a record is added to 'civicrm_account_invoice' table, you can use contribution_id param to push a single payment to xero.


I see this line in CRM_Contribute_BAO_Contribution:

//update pledge and pledge payment, CRM-3961
CRM_Pledge_BAO_PledgePayment::resetPledgePayment($id);

Looking at CRM_Pledge_BAO_PledgePayment::resetPledgePayment(), I see it calls the DAO method, not the BAO - which is why the hooks (which ARE present) are bypassed.

I think this would be a good enhancement for core CiviCRM.  CRM_Pledge_BAO_PledgePayment::resetPledgePayment() is a very short function, which could be easily refactored to instantiate the PledgePayment BAO instead of DAO, and call the add() or create() method instead of commit().  This would cause your hooks to fire.


What's the right way override the default source on a contribution page?

One of our clients has done something similar to this answer:

How can I pass in the contribution amount via URL?

but using a campaign selector or a custom field on the contribution page. Not sure from memory whether they did it with JS or Smarty, but the end result was an invisible field which tracked this.


Paypal Interruptus - Wordpress w/ CiviCRM 4.7.1

It probably means that paypal doesn't ping back properly your civi to let it know if it processed properly the card. Unfortunately, they are a lot of reasons to get that call not working, either because paypal try to IPN elsewhere, with a different format than expected or that something is wrong on how we process it (given it broke after an upgrade, the most likely option)

Can you check on the log if you have any error that might clarify what is the issue?


Trying to create a custom field that works similar to "Contact is Deceased" function

Some thoughts.

Since 'is_deceased' is a field on the contact table i wondered what would be the effect of assigning a '1' to an Org.

The record does now show with DECEASED in red after the Display Name

The contact does show up if i search for is_deceased via Adv Search

I then also set an Individual to Deceased.

Neither of them showed email as On Hold nor Comm Pref as Do Not Mail.

When I went to print a PDF records for the Deceased (both Org and Ind) were printed

I got a whitescreen when I tried to do an export using " Exclude contacts with "do not mail" privacy, no street address, or who are deceased."

Some of the above does not gel with my Answer at What is effect of marking contact as deceased? but I haven't compared with dmaster.

I suspect an extension could make the is_deceased field show for an Organisation and based on above I sense that it would then operate similarly for both Ind and Org (though clearly my testing above didn't give me the outcome i expected for Ind in some cases)

Above was all done on 5.10.3 (ish)


The base code for it is located at navigation.js.tpl where all the menus have been listed with their search inputs.

Adding source as a search field seems to just add another line with a value as source.

Note: Changing core file may not be recommended as you may lose them after upgradation.


Bugreport: Impossible to create more than 25 events

I would recommend you apply the patch here https://github.com/civicrm/civicrm-core/pull/10325 There is a default limit on API calls to 25 records which is what your probably hitting here

Seamus


CiviEvent sends an invoice copy to every guest

You could have a slightly different profile for the 'lead' person to register vs subsequent participant registrations, in order to identify who should receive the invoice, and then use Civi Rules to send the email /PDF?

This is either instead of the usual receipt email, or as well but that doesn't include the invoice and serves only to confirm the booking for that individual.


The calendar is not part of core CiviCRM, so I can't be 100% sure without looking at it, but the first issue may be that you didn't mark the event as "public".  If I were setting up a calendar like that, I'd want to limit it to events marked "public" in case I wanted to record other events that shouldn't go on the calendar.

Your other two issues could be so many different things that it isn't worth hazarding a guess without more information or access to your site.  If you are in touch with the company who built your site, you should contact them, or you might contact a CiviCRM Partner.


What should be best practice when creating custom fields?

If you find yourself wanting to give really long custom field names, think about whether you really should have a fairly short label and then provide help text that goes along with the field.

Besides causing database problems (though CiviCRM largely handles that on its own by just cutting off the field name), you'll have trouble displaying a super-long field name on forms and in reports.

For values, are you actually experiencing this problem?  If multiple choices are allowed in a field (let's say all those numbers are available as checkboxes), they're separated by a delimiter character in the database.  Searching for 2 won't pull a contact with 12, and searching for 12 won't show results that have both 1 and 2.

In the field itself, the storage is like (not with an asterisk but an unprintable character) "*1*2*6*" for having 1, 2, and 6 checked.  It's stored like "*11*12*" for having 11 and 12 checked.  They're easily distinguished.


How do I filter out memberships (by relationship)?

You can use 'Membership Owner ID' filter under filters tab of report.

When you set 'Membership Owner ID' as 'is empty(NULL)' it will show all the primary membership owners that is membership not created by relationship

When you set 'Membership Owner ID' as 'is not empty(NULL)' it will show all the secondary membership owners that is membership created by relationship membership

PS: Don't miss to filter Membership type ;)

HTH

Pradeep


Random 9002 Errors from iATS when making donations

Intermittent issues can be difficult to diagnose. A couple of notes that may help:

What you really need to do is to get TLS 1.2 and switch back to the www server. The www2 server is only needed for those not at the TLS 1.2 standard yet and is going to go away. Your lack of TLS 1.2 is probably a symptom of a system that is not up to date or maintained, that could well be the key issue.

Avoid any special characters in your iATS 80 account password; If you're using another than 80 account w/ iATS then confirm with customer services that you can deposit monies into that account via WebServices. If you're using more than one iATS subaccount 80, 81, 82 etc confirm all are able to accept monies via WebServices.


How to show the City (Location) of Events in Event Lists using Drupal Views

The location of an event is stored as a CiviCRM Address field, not as a field on the event. As such, it won't show up if you are filtering fields for CiviCRM Event in the Add fields dialog. Remove the filter, or filter on CiviCRM Address instead, and relevant fields should show up. Here is a screenshot for adding a field in CiviCRM 4.7 on Drupal 7 on one of our sites:

Similarly, any custom event fields you have will appear under the field grouping under CiviCRM Custom.

Note that not every address field is populated when you add an event address, but the city should certainly be one of them.


Turns out clicking Save when you change permissions really helps.

Craig


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!!!


Edit the Workflow Message for the event receipt template to include a ticket at the bottom. You can style it with html/css to look like you want. In order to have the ticket always be at the bottom of the page, you can use nested tables.

Here is a similar question (How) can I add a footer fixed to the page of a message template for printing a pdf?


The extension is configured correctly per your screenshot, so it must be an issue with the sync queue.

You can reset this queue by accessing your database (command line mysql or phpMyAdmin) and issuing the command: TRUNCATE cividesk_sync_googleapps;

The queue will be repopulated when the next sync happens.


Yes the civicrm extern/rest.php will merge GET and POST parameters.

Regarding security, while yes it is better to send private data in POST, it's not necessarily that much more secure since POST data can be logged too, just you're right not usually by default. See also https://security.stackexchange.com/questions/30754/is-there-a-difference-between-get-and-post-for-web-application-security. For real privacy it would need to be encrypted, and then have some way to decrypt it at the civicrm end.


Agree with Jon. I would also guess that there are contacts in your database who have more than one membership. Membership reports are based on the object membership, so they count these rather than only the contacts attached to them. But screenshots would be helpful.


Sounds like a combination of a slow-ish server/network, too many images and possibly some configuration bits.

The KCfinder runs in a little popup window that makes it extra difficult to diagnose, and tries to load thumbnails of all your existing images so you can select one. All that work is overloading both your network and your server (and maybe even your browser, though unlikely).

You may be able to customize kcfinder so that it's not generating quite so many thumbnails, and/or fix your server so that it doesn't have to do it each time (i.e. with some caching, though that's a bit tricky, e.g. ensure you have mod_expires enabled with apache).

You're right that you're somewhat painted into a corner, and a more powerful server might be the easiest solution.

Alternatively, you could set up a separate directory for old images and move over ones that are more than a month old.

Going forward, you may also want to make sure you're not uploading really large images, i.e. scale them on your own machine before uploading them.


When importing activities can you use an external id?

At first, I thought you meant importing activities and joining them to contacts with the contacts' external IDs.  This is the most common way I do activity imports.

However, reading closer, it sounds like you want to have an external ID field for the activity.  You'll need to create a custom field for this.  Also, you should remember that your custom field will not do the same magic as the contact external ID field: nothing will enforce that the value is unique, and nothing will automatically match activities based upon this field.

It still might be useful for cross-referencing your imported activities with the source, but you'll have to apply your own logic to the field.


Undefined index: maxlength after update to 5.2.0

Jim,

This is a php notice, you can ignore. However this has been fixed in latest version of Civi. To fix this you can either

Apply fix from https://github.com/civicrm/civicrm-core/pull/12090 or wait for next release.
Turn off php notices by navigating to Configurations >> Logging and errors. Set 'Error messages to display' to None.

HTH

Pradeep


How can we hide the CiviCRM System Status page?

This can be fixed by removing the permission 'CiviCRM: administer CiviCRM' from these users.  You called them non-admin so they shouldn't need this menu?  If they don't have this permission they won't get the messages.


We have provided a fix for this at https://github.com/civicrm/civicrm-core/pull/10677


So CLI's memory limit was set to -1 like this:

memory_limit = -1 // no memory limit

Setting the limit to other than no limit solved the issue.

I'm not sure why this happened as CLI's memory limit was always set to -1 from the very first day I configured this server 2 years ago.


Upgrade CiviCRM 4.6.20 to 4.7.10 on Drupal - db error

I may have found a solution elsewhere - which is ugly and requires editing the upgrade scripts. Database Error When Upgrading 4.6 to 4.7 on Drupal 7
So it's not really a solution for me - but maybe it will be  a  solution for others, as once I got past that issue the 4.6.20 to 4.7.0alpha3 portion failed with the following. Have not found that many google matches for this error - but hopefully I can get past this next hurdle. Hopefully others won't also run into this issue.

[Error: undefined]
Exception: "A fatal error was triggered: Could not find valid value
for qrid"
0 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Utils/Request.php(92):
CRM_Core_Error::fatal("Could not find valid value for qrid")
1 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(47):
CRM_Utils_Request::retrieve("qrid", "String", NULL, TRUE, NULL,
"POST")
2 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php(106):
CRM_Queue_Page_AJAX::{closure}()
3 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php(54):
CRM_Queue_ErrorPolicy->call(Object(Closure))
4 internal function: CRM_Queue_Page_AJAX::runNext()
5 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php(278):
call_user_func((Array:2))
6 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php(86):
CRM_Core_Invoke::runItem((Array:13))
7 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/CRM/Core/Invoke.php(54):
CRM_Core_Invoke::_invoke((Array:5))
8 /home/kialis/zootownarts.org/drupal7/sites/all/modules/civicrm/drupal/civicrm.module(454):
CRM_Core_Invoke::invoke((Array:5))
9 internal function: civicrm_invoke("upgrade", "queue", "ajax", "runNext")
10 /home/kialis/zootownarts.org/drupal7/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:4))
11 /home/kialis/zootownarts.org/drupal7/index.php(21): menu_execute_active_handler()
12 {main}


There may be a smarter way to do this in Views, but the short version is: I would create a View that shows memberships, then create another view that shows contacts and in the latter pull in the former using Views Field Views (ie you can say, show me the results of the first view based on a match for the contact id in the second view. and set it to show only a single result per contact sorted by oldest first, and that 'should' get you what you want. Hopefully I haven't missed out too many critical steps.


I have had a similar problem with a WordPress install. In my case the Anonymous role of WordPress missing.
The Wordpress roles can be checked with
wp role list

I created the new role with
wp role create anonymous_user 'Anonymous User'


How many different tax rates are involved?

It there aren't too many, a no-tech solution would be to create a different price set for each different tax rate and have province-based links on your call to action page.

Added later:

I don't know a lot about the tax feature but I put down what I think might work. (This is all untested so could be totally wrong.) Assuming you have already ticked enable  tax and invoicing at Administer > CiviContribute > CiviContribute Component setttings, I would have thought you might need to:

create three different financial account with the different tax rates say tax2, tax3, tax4.
create three different financial types member_dues2, member_dues3, member_dues4
edit the three different financial types  to link each to the appropriate sales tax account
edit the three different financial accounts you will now have, to set the account code to the same value for each so that that membership revenue can totalled across aall the provinces using a line item report  (if this is a what you need.)
-Create a price set for each province lined to the correct financial type.

If this doesn't work, my apologies, but it may help you on your way somehow.


How do I make tag sets searchable in Find Contacts?

Matthew, welcome to the CiviCRM community.

Have a look at http://book.civicrm.org/user/organising-your-data/groups-and-tags/ - there's a section on using Tag Sets.

It does say "adding them creates an additional search field in the Basic Criteria section of the Advanced Search" indicating that they are not available in the Find Contacts search.


Why are email replies not being forwarded properly?

do you see them as activities for these contacts? if you track replies, they come back to civi and get stored as activities


Error for token.php related to greeting tokens

I'm surprised you were able to get the "Update Greetings" scheduled job to run in cron; the UI specifically disallows enabling that job.  Did you turn it directly using SQL?  You may want to consider whether you really want that job enabled.

That aside - I'd put this line just above line 1470:

print_r(CRM_Utils_Array::value($key, $greetingToken), TRUE)

And see what you get when you run the cli command manually.


create an Drupal core account when using a webform

You can use Drupal Rules to create the Drupal User for a contact when they get a Membership status of 'x'.

Here is one that KarinG has shared before Using CiviMember to automatically create a Drupal user

Thank you Karin


Problem solved.   After installing the civi upgrade, I needed to flush the cache by going to Administrater/System Settings/Clean up Caches and Update Paths  then click the Clean Up caches button.  The issue was resolved immediately after doing that.


How do I test Online Contribution Receipts?

I would recommend you only TEST LIVE; Just delete the contribution that you have created afterwards; a $1 LIVE transaction that you can follow all the way though into your Payment Processor - will guarantee you that things are working as expected.

Added: You'll have tokens for total_amount etc, right? This is how you test it. You can also plug in TEST credentials for your payment Processor in LIVE payment processor config. Then you can test LIVE CiviCRM pathways with fake VISA cards.


Are you referring to the "Summary" tab when viewing a contact?  If so, you can do so by installing the Contact Layout Editor extension.

Note also that many (not all) fields can be disabled from Administer menu » Customize Data and Screens » Display Preferences.


Confusing CiviMail unsubscription confirmation screen

Most of the code for the actual unsubscribe process is located here:

CRM/Mailing/Form/Unsubscribe.php

Would be good to:

a. Create a site wide CiviMail setting so an admin can disable the email confirmation process.

b. Use this site wide setting to determine the behavior of the code, the new behavior or the 4.4 and prior behavior. The 4.4 code is here:

CRM/Mailing/Page/Unsubscribe.php


How to dynamically add datafields/profiles in form?

There's no way to dynamically add fields without custom code to a profile - and that code sounds onerous.  There's a better way, though: I'd recommend creating a CiviEvent and enabling "register multiple participants" from there.

You've tagged this "Wordpress", which rules out using Drupal Webform with CiviCRM integration.  That's another alternative for anyone else with a similar issue using Drupal.


I'd wager that the template you're looking at calls hook_civicrm_searchColumns.  Despite the name referring to "search", it's designed to let you change the values of the columns in tables like the one you display.

I just pushed a simple extension that demonstrates how it's used: https://github.com/PalanteJon/org.takethestreets.campaignincontributiontab/blob/master/campaignincontributiontab.php


How can I tell if the logged in user has a certain permission?

I believe what you're looking for is:

CRM_Core_Permission::check('edit all contacts')


ACL permissions still broken after 4.6.8 upgrade

The ACL bugs fixed in the most recent point releases wouldn't affect a full administrator.  I believe it's unrelated to your current problem.

Your symptoms sound like you're logging in over HTTP, but with HTTPS forced to on.  Try logging in over HTTPS and see if your problem goes away.


Whether or not civivolunteer is misbehaving, I've got a pending patch to the views integration that fixes the issue, here: https://issues.civicrm.org/jira/browse/CRM-18776


Mailing to contacts in a group - deleted contacts were included to the list of recipients

It seems that the bugfix which fixed this for smart groups also did it for the groups. Our last mailing sending after upgrading to CiviCRM 5.30.1 resolved this issue. No mails have been sent to contacts in trash.


CiviCRM edit history for different users

If you have logging switched on you should be able to find this in the log tables. If you do not have logging switched on I do not think you can find this.

You can check your logging at Adminster>System Setting>Misc (Undelete..........


list of all participations for a contact

Ouch - you're doing it the hard way!

Getting a list of participant records by contact ID is pretty simple using the API.  It sounds like maybe you haven't discovered the API Explorer.  Without knowing your Civi version (and CMS software/version) I can't tell you exactly where to find it.  If you're on Civi 4.5 or 4.6, then in the Help menu (renamed to Support menu in 4.6.5+), go to Developer > API Explorer.  If you're on an earlier version, in Drupal it's example.org/civicrm/api/explorer - I can't speak to other CMSes.

Below I've copy/pasted my API Explorer results for finding all the participant records for contact ID 247.  Note that some of the syntax for Javascript may not work in Civi earlier than 4.6, so run API Explorer yourself to double-check!

Rest

/sites/all/modules/civicrm/extern/rest.php?entity=Participant&action=get&api_key=yourkey&key=sitekey&json={"sequential":1,"contact_id":247}

Smarty

{crmAPI var='result' entity='Participant' action='get' contact_id=247}
{foreach from=$result.values item=participant}
  {$participant.some_field}
{/foreach}

Php

$result = civicrm_api3('Participant', 'get', array(
  'sequential' => 1,
  'contact_id' => 247,
));

Javascript

CRM.api3('Participant', 'get', {
  "sequential": 1,
  "contact_id": 247
}).done(function(result) {
  // do something
});


CSV file import problem with file from Mac MS Office

Try using Libre Office. It is a Free and Open Source Office (MS Office compatible) application. Libreoffice.org - You can open the xls file with it and save as csv. I have used it numerous times, it comes pre-installed in ubuntu (which reminds me I should make a donation to the project)

Let us know how you get on.


How do I manually update External Identifier

If you don't have 'External Identifier' for everyone yet - do a Contact import first!

Contact import:
Include the data fields used for contact "matching" based on your configured Duplicate Matching rules. For the default duplicate matching rules, you would include 3 columns in each row with the contributors' First Name, Last Name and Email Address.

Your main Goal here is to find the Contacts in your Database and add an 'External Identifier' for them (and these come from your Go CardLess)

Contribution import:
Very straightforward now that everyone has an 'External Identifier' - you can even now dump the name fields; all you need is 'External Identifier' and the contribution data columns.


The data for importing options needs to be in a single cell. So if your field is COLOUR, then you need a single column for that data in your import file, and you need data such as

red,blue,orange
red,orange
etc

If you need to concatenate your data you may end up with examples like below, but they should also import fine

red,blue,orange
red,,orange
,blue,orange
,,orange
red,,


Can we do quick search on non primary details?

There has been discussion going on to implement this in CiviCRM core code, developed a small extension to do that for time being until its been implemented in core.


Detect price group term period on CRM_Member_Form_MembershipRenewal or CRM_Member_Form_Membership

Use this function:

There is a field price_ which contains the ID of the price set selected

Iterate through price sets to find this ID, and if membership matches, use this number of terms

Be sure to set membership type ID as $membership_type_id

                $membership_num_terms = 1;

                if (isset($form->_values['fee'])) {

                    foreach ($form->_values['fee'] as $index => $values) {

                        if (isset($form->_params['price_' . $index])) {
                            $id = intval($form->_params['price_' . $index]);
                        } else {
                            $id = null;
                        }

                        foreach ($values['options'] as $option_index => $option_values) {
                            if (($option_index == $id) && ($option_values['membership_type_id'] == $membership_type_id)) {
                                $membership_num_terms = $option_values['membership_num_terms'];
                            }
                        }
                    }
                }


It does not harm to install extensions manually. Actually that is the way I am using the most.

The auto install requires that an extension developer has submitted his/her extension through a review process and for most extensions developer (like me) that is too much of a hassle and also puts me in the maintainer and supplier role.


Recurring contributions cancelled in Civi NOT cancelled in Authorize.net

Turns out that this was an issue caused by the iATS extension - strange as that may sound - you will find details at the following link: https://github.com/iATSPayments/com.iatspayments.civicrm/issues/188

Whether or not the cancel recurring for PayPal ever worked is a separate question altogether (for us it never has).


What contribution dates does the default iATS recur job process?

The recurring contributions job will process all recurring series that have a status in progress and that are due or are past due (i.e. have a next scheduled contribution date either today or in the past).


Charts using data from CiviCRM to show on Drupal website

How about pulling your grant data into a Drupal View and then using Charts and Google Charts module to display them?


Batch Update the current relationship in CiviCRM

I used contact_id_a and contact_id_b and relationship_type id and set the is_active to 0 in csv file. But this extension gives me an error "Error with entity "create"! (Duplicate Relationship)".

Seems like you have relationship_type_id but not relationship id in the CSV file? If yes, I think you just need to add Relationship id to the columns.

The id is used by civicrm to update the records in the database instead of creating a new one.

Hence, try adding a new column in CSV and then proceed with the import.


When viewing the report, click on the Title and Format tab to rename it, from the actions drop down menu you have an option to delete –

Further documentation on reporting can be found here -
https://docs.civicrm.org/user/en/latest/reporting/set-up/


Receipting for multiple event registrations via webform

This needed a fix in core. Have raised a JIRA for it at https://issues.civicrm.org/jira/browse/CRM-20657. Hopefully it should be merged in 4.7.21 version.

Fix submitted at https://github.com/civicrm/civicrm-core/pull/10439


Outbound mail fails after upgrading to 4.7.1

From what I understand, this can be because the server you contact has a self-signed certificate (see this question for a workaround), or because the PEAR SMTP package version used by CiviCRM does not support TLS. Civi uses 1.6.1, but support was added in 1.7.1.

In our case (php7, CiviCRM 4.7), we are able to work around this by forcing SSL connection rather than TLS. In the Outbound mail settings
1) put ssl:// in front of the mail server name
2) change the port to something appropriate. Usually to 465**


Shortlisting contacts with complete address

You can use the search builder to search for empty fields, e.g. Steet-Address or ZIP Code. From the result, you could create a (smart) group and then exclude contacts in that group from the mailing.


How to fix 'New mailing' that only has 'Initializing' and edit boxes that wait forever

This problem turns out to be a mis-configuration on the shared server. We were also getting Internal Error 500 messages just on signing in today, but the hosting company (vidahost.com) fixed the problem & Civi is working fine now.  So not a problem with Civi, but a problem on the shared server, now fixed.  No wonder I couldn't find anything wrong with Civi..


Syntax for drush command civicrm-sql-dump

If you run drush civicrm-sql-dump --help the output is:

Prints the whole CiviCRM database to STDOUT or save to a file.

Examples:
 drush civicrm-sql-dump        Save SQL dump to the directory above Drupal root.
 --result-file=../CiviCRM.sql

Options:
 --data-only                               Dump data without statements to create any of the schema.
 --gzip                                    Compress the dump using the gzip program which must be in your $PATH.
 --result-file                             Save to a file.
 --tables-list                             comma-separated list of tables to transfer.

So since you want it in a file rather than on your screen, use the --result-file option and tell it what file you want to write to.


In terms of an aggregation of actual contributions - in the contribution search (version 4.5+) it's possible to use recurring contribution dates in your criteria. The contribution search results page includes a total & count.

That doesn't really answer your 'one membership should only be counted once' though. I'm not sure I understand that requirement. It seems like you only want to count one payment per person? If you only searched within a particular time period perhaps you would exclude the others?


As Tomek suggested, try running this task, usually referred to as a Job.

Administer > System Settings > Scheduled Jobs > Send Scheduled Mailings > More > Execute Now


Limit the groups exposed in Group profile field

One way is to change the visibility of the groups to User and User Admin Only to hide the group display from all the public pages or profile.

If you don't want to do that, you might want a developer to add a js file on the profile rendering page and hide extra group values using javascript.


Group Type is set to empty while updating Group

This isn't a question, it's a bug report ;)

For bug reports, could you use jira, ideally with a patch to fix the behaviour.


I use Xero with the CiviXero integration extension


Way to sync CiviCRM memberships to Drupal group

This question gives an answer to a very similar question that you can apply to your situation: Reverse sync CiviCRM groups to Drupal organic groups

However, even with a couple dozen membership types, I still think it might be better to use regular CiviMember-Role sync and use a "limit content access by role" module.  I think Content Access is the popular one.

Try both approaches and see what works for you!


The steps for creating a Mailing List are

create a Group of contacts (from a Search or other method)
set that Group to be used as a Mailing List

It is unclear what you mean by 'choose a new mailing list option'. It may help if you add some screenshots after (re)reading https://docs.civicrm.org/user/en/latest/organising-your-data/groups-and-tags/#group-settings-and-functionality to ensure we are all on the same page about what you are trying to do. Thanks


Is this a bug? "Paypal IPNS not handled other than recurring_payments" appears when txn_type is recurring_payment_profile_created

This is a bit of a red herring. The message "Paypal IPNS not handled other than recurring_payments" is legitimate in this case. What's happening is that PayPal sends a single confirmation message upon receipt of the recurring payment request, and then later it will send "recurring" IPN messages for each recurring payment, including the first one. This single confirmation message is rightly ignored, because soon after it will come the IPN message for the first recurring payment.


Drupal Views Exposed Filter (operators) and CiviCRM Multiple Tags

Indeed, civicrm_handler_filter_pseudo_constant.inc should be altered and

class civicrm_handler_filter_pseudo_constant extends views_handler_filter_in_operator

should be replaced by

class civicrm_handler_filter_pseudo_constant extends views_handler_filter_many_to_one

Funny, I made a pull request in May 2016 (against wrong branch though so it was closed) and made it again in October. Hope this time it will pass.


Recurring Contributions consistently stuck in Pending Status

First place to look is to ensure your cron is running properly. The verification is managed by two scheduled jobs: one to pull in the journal from iATSpayments.com and one to the verify (checks the journal entries to see if any of your contributions have been completed).


Your issue has a related bug report: https://issues.civicrm.org/jira/browse/CRM-19353. You may have to wait until it gets merged and released or you start to test with the proposed PRs.
Connections seems to be unrelated to this.


Joomla - Embedding youtube video in CIVI mailing

You probably won't have much luck embedding the actual video into a mailing due to restrictions in email clients. One workaround could be embedding a screenshot of the video which is then linked to the webpage where the video can be played (so when the screenshot is clicked, they are sent to the website to view).


Hide profile icon when using Profile in listing mode

Yes, there are at least two ways to disable this icon that I can think of.

The first is not very authentic, but requires less work and code modification. You use CSS to avoid the display of the icon. You'd need to include in your CSS file something like:

.crm-profile-name-<your-profile-name> .Individual-icon {
display: none;  }

Also, you'd need to repeat the CSS selector to Organization-icon and others types of contacts if that's your case. Mind that one can make the icon show up in the browser changing the CSS on the fly and so, would access the overlay information if it is still there. So, this method is not good to secure the data, you should first be sure that data is correctly protected, not showing up publicly in the overlay box.

The second method is much more gentile, but requires you to change the Listing template code. It's referenced by Dave Greenberg in this thread and the code stills work nice, I just tested it.

If you have never customized templates, I would say you should first read this page, as I'd be too long to explain every step to do this here.

Once you are good to go, copy the file civicrm/templates/CRM/Profile/Page/Listings.tpl to your custom templates directory, keeping the folders structure. Edit the file from line 59 to look like this:

      {foreach from=$columnHeaders item=header name=headers}
        {if $smarty.foreach.headers.iteration GT 1}

        {if $header.sort}
          {assign var='key' value=$header.sort}
          {$sort->_response.$key.link}
        {else}
          {$header.name}
        {/if}

        {/if}
      {/foreach}

      {counter start=0 skip=1 print=false}
      {foreach from=$rows item=row name=listings}

      {foreach from=$row key=index item=value name=cells}
        {if $smarty.foreach.cells.iteration GT 1}
        {if $columnHeaders.$index.field_name}
          {$value}
        {else}
          {$value}
        {/if}
        {/if}

      {/foreach}

      {/foreach}

    {/strip}
    {include file="CRM/common/pager.tpl" location="bottom"}

{elseif ! $isReset}
    {include file="CRM/Contact/Form/Search/EmptyResults.tpl" context="Profile"}
{/if}

This would make the column of profile overlay icon to go away.

Also, in an that old Forum thread there were a word from Dave Greenberg saying that setting all Summary Overlay profile fields visibility to 'User and User Admin' would disable the overlay, but in the actual CiviCRM version, this profile is reserved, so you can't change the visibility of the field. Hence, the above methods looks necessary to me.


Creating a custom search to produce contributions as results

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).


While the Google API has an unauthenticated limit of 2,500 requests per day per IP, using an API key currently gives free a quota of 100,000 requests per day, with additional requests by payment.

You'll need a recent-ish (4.7.9, 4.6.23 or greater) version of CiviCRM to use the API key for geocoding: CRM-18830: Google Geocoding - use SSL, restore API key.

With this you should be able to geocode a larger number of addresses.

Your API key should be configured with the following permissions:

Google Maps Geocoding API (for geocoding)
Google Maps JavaScript API (for displaying / mapping)


Buildkit - amp test failed - /root/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that '/root/' is executable'

I was performing all actions as a root. That was probably the reason no .conf file was generated in /root/.amp/apache.d/. I switched to a non-root user with sudo privileges and it worked smoothly.


Multiple Contacts and Memberships Later Merged to One Membership

There is an option to merge contacts and seems to be what you are looking for. Search for them in Find Contacts and then select to merge the two.


Found that the menu should also be edited in Administer -> Customize... -> Navigation Menu then Delete or Disable the inactive menu items
Sorry for that but documentation should be clearer ;-)


Is CiviCRM right for a non-profit medical group?

Without knowing what your organization is trying to do, it is difficult to provide meaningful feedback. You should take a look at CiviCRM's features and see if it fits your need. At the bottom of the site you'll find some useful links, including:

Browse case studies,
Contact an ambassador,
Introductory webinars,
Watch videos,
Try a demo,
Read documentation,
Ask a question,
Find an expert


There is a patch to support the character encoding necessary: https://lab.civicrm.org/dev/core/issues/339.

The issue is whether to support older character sets for folks who can't/won't switch over.  One position is that it's not a big ask for users to upgrade, but difficult for the developers to support both; the other position is that it forces an update that some folks can't make, or that their database is too big to convert without going offline for several hours.

The "support the new encoding only" patch has been written; this will move forward either when a) someone writes a patch that supports both encodings, or b) folks decide it's OK to force folks to switch.


How to remove contact from group using CiviCRM Entity and Drupal Rules

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...


Does anyone know why I have two "Summary" tabs on each contact when I use a custom template?

I've now checked for any changes to the template since v4.7.0 and there are changes. I've now incorporated these into my custom template and this has fixed the problem. Please ignore the question!


How to correct domain in URLs after a change?

I would double check the civicrm.settings.php file to make sure the paths and URL are updated in there. For example:

define( 'CIVICRM_UF_BASEURL'      , 'http://foo.example.com/' );

While you are in there make sure the server paths look right:

$civicrm_root = '/home/path_to_html/sites/all/modules/civicrm';
define( 'CIVICRM_TEMPLATE_COMPILEDIR', '/home/path_to_html/sites/default/files/civicrm/templates_c/' );


preferred language not importing with contact data

It seems that a country designation is required too, even though they are not easily shown in the prefered language interface. So fr is not valid, but fr_FR is.


Create profile not creating contact properly unless logged in on wordpress with civicrm 4.6

The symptoms I thought there were, weren't there, the contact was being created correctly, my method of testing was wrong...

The problem is a bug in civirules, when creating an activity when not logged in, it doesn't have the "source_contact_id" parameter available for the API (when you look at an activity, it's the bit that says "added by"...

My solution (we're on wordpress) was to add
if(!is_user_logged_in()){
$parameters["source_contact_id"]=1;
}
before the API call in the plugin.

I've reported the issue over here https://github.com/CiviCooP/org.civicoop.civirules/issues/152 and will build in the method of being able to set a default contact for activities if the user isn't logged in (which I'll pr on the git repo), my fix is wordpress specific, hacky and needed to be done quickly


Demerit's and Mick's answers are incorrect for the (built-in) reserved rules - though it's definitely confusing!

If a RuleGroup has a value in the name field, and that name corresponds to a filename in CRM/Dedupe/BAO/QueryBuilder, then the customized SQL in those files will be used. The existing entries in civicrm_rule for those RuleGroups are holdovers from before that system existed, and editing them has no effect.

"Standard" dedupe rules with multiple criteria are very inefficient compared to handwritten SQL, which is why this is a valuable technique.  You can create your own handwritten queries with hook_civicrm_dedupe, and the Veda dedupe extension has a number of excellent examples.  Note that this extension doesn't work on modern Civi because of some of its other functions, but the dedupe rules can be ripped out into something else.

Finally - I learned just yesterday that the built-in handwritten dedupe rules seem to execute different SQL when comparing in Unsupervised/Supervised mode (a single contact) vs. General mode (find all dupes).  While I haven't proved it, I suspect that if you're in the rare scenario of needing to optimize your unsupervised/supervised dedupes, creating a new class to extend CRM_Dedupe_BAO_QueryBuilder is the way to go.  I just posted org.agbu.optimizeddedupe to provide an example of this.

UPDATE: More clarification.

To understand how the queries work, it's best to look at an example, eg IndividualUnsupervised.php.

The internal function is used if you go to Contacts » Find and Merge Duplicate Contacts and click Use Rule.  The SQL query is:

            SELECT contact1.id as id1, contact2.id as id2, {$rg->threshold} as weight
            FROM civicrm_contact as contact1
              JOIN civicrm_email as email1 ON email1.contact_id=contact1.id
              JOIN civicrm_contact as contact2 ON
                contact1.first_name = contact2.first_name AND
                contact1.last_name = contact2.last_name
              JOIN civicrm_email as email2 ON
                email2.contact_id=contact2.id AND
                email1.email=email2.email
            WHERE contact1.contact_type = 'Individual'"

First, note that the weight is set to $rg->threshold - that is, the threshold in civicrm_rule_group.  In other words, if this SQL matches, these records automatically meet the threshold for that rule.  Hopefully that answers your main question!  If you remove that field, you can run this SQL as-is in a SQL client and get a complete list of the duplicates it would return.

To further clarify - unlike "regular" rules which are the result of several queries, each with their own weight - this runs a SINGLE query, and sets the weight equal to the rule's threshold.  So it's a straight yes/no answer whether a record is a duplicate, based on whether the SQL finds them.

That's not to say that you can't simulate length/weight, but it's tricky.  My org.agbu.optimizeddedupe rule has a SQL statement you can look at which gives the same results as this rule:

However, it took about 5 seconds to compare even a single submitted contact against the existing 165,000 contacts in this databse with the existing rule.  Now it's almost instantaneous.


Non-administrators unable to tag contacts using Tags tab

I suspect this is because acl permissions is not consistently applied across all aspects of civicrm. In this case the API permission check is a lot more granular.

At this point, I suspect your options are to either live with the status quo and/or (ask your developer if you have one to) take a look at the code to see if you can improve the API to make the permission checking incorporate ACL's also. You can look at the code on the main contact edit page (CRM/Contact/Form/Contact.php) to see how this is done.

You could also consider using the Paid issue queue service offered by the core team if your org has the funding to do so.


There appears to be a recent bug, possibly introduced in 5.8 though I'm not certain, that affects the CKEditor, namely missing Configure CKEditor button and CKEditor itself won't appear. See this issue: https://lab.civicrm.org/dev/core/issues/594#note_11806

If you are comfortable working in the database directly you can work around this by deleting the existing setting for WYSIWYG editor and then avoid saving Display Preferences until this is resolved.

DELETE FROM civicrm_setting WHERE name = 'editor_id';

This bug is now resolved in CiviCRM 5.9. After installing the 5.9 update save the Display Preferences & CKEditor settings as per the post-install notice.


Is there a way to re-send failed transactional emails using SparkPost email extension?

I have two outside ideas that 'might' be helpful:

Is it possible Activities have been made for the emails that should have gone out? Emails from the Contact record will almost certainly have created an activity, and it's a commonly set option for emails sent via Scheduled reminders. If an activity has been made it will probably contain the email.
Do you have email logging turned on? Presumably not or you wouldn't be asking the question! But perhaps worth checking...


This will always be an issue if autocomplete isn't an option and you're dealing with user input... they will never do exactly what you want or expect :).

I think the solution will somewhat depend on the size of your organization. For our operation (events under 3k people), we display a non-editable field of Current Employer in our event registration profile so someone can see what we have on file but cannot touch it.

Just under that, we have a plain text custom field called employer update with some instructions. If they need to update what we have in the database or if it is empty, they should fill it out.

Before each event, our membership manager (or her intern, or a script but this org has lots and lots of 'special snowflakes' so I wouldn't recommend it in that case) goes through the registrants and updates people who have the "employer update" field filled in, and clears out that field as they go.

This prevents a massive number or organization duplicates from being created.


Multiple Mailing Addresses Based on Time of Year

You could also add the two adresses as to different adress types. One is set as primary, and then you need some help on changing what adress is primary, based on time. I do think CiviRules could help you with that, giving a specific time of the year, where you change what adress is set as primary. If you want to go that route, let me know and I could help you with giving tip on specific trigger and condition to use.


CiviCRM upgrade from 4.6 to 5.3 > [warning] Both parameters should have an equal number of elements Relationship.php:2222

This error is displayed when some Names for a relationship type do not match the Labels.

For example in civicrm_relationship_type table you may have something like

name_a_b = Mayor
name_b_a = Mayor
label_a_b = Mayor of
label_b_a = Mayor is

You can correct these either in SQL or via the UI

UPDATE

To identify the rows causing the issue

select name_a_b, label_a_b, name_b_a, label_b_a from civicrm_relationship_type where name_a_b <> label_a_b;
select name_b_a, label_b_a from civicrm_relationship_type where name_b_a <> label_b_a;

To fix we want to set the name = to the label

Make a temporary backup - this will be dropped when you log out of mysql.

create temporary table temp_civicrm_relationship_type as select * from civicrm_relationship_type;
update civicrm_relationship_type set name_b_a = label_b_a where name_b_a <> label_b_a;
update civicrm_relationship_type set name_a_b = label_a_b where name_a_b <> label_a_b;

Confirm that the number of rows updated matches result of the query.

(nb I just grabbed this from a ticket in our own system but hope it is helpful in your case)


I'm not sure if it fits to your necessities but CiviEvent includes iCal for public events.

As you can see on CiviCRM user guide

  Select the Public Event box to include the event in promotional listings such as RSS feeds, iCal files or feeds, and event listing pages.

You can find more related information on how to use this functionality in this  forum topic integration with iCal and/or Google Calendar - private calendars?


You could apply the same techniques for event pages that are described for contribution pages here: Are private contribution pages a thing?.

EDIT: Actually that's only a piece of the puzzle, let me give an example (and make it CMS-agnostic).  Assuming you want to limit access to members of "Newsletter Subscribers"

function hook_civicrm_preProcess($formName, &$form) {

  $redirectPath = 'home';  // set this to the url to redirect to if access is denied

  if ($formName == "CRM_Event_Form_Registration_Register") {
    $contactId = CRM_Core_Session::singleton()->getLoggedInContactID();
    $result = civicrm_api3('Contact', 'get', array(
      'group' => "Newsletter Subscribers",
      'id' => $contactId,
    ));
    if ($result['count'] === 0) {
      CRM_Utils_System::redirect($redirectPath);
    }
  }
}

Note: This will hide ALL event registrations.  You'll have to find a variable in the $form object to use to determine whether this code should run on a particular page and modify the if condition.


I would suggest that you talk to your hosting provider.  It is possible that they may be incorrectly marking this as suspicious activity and hence giving you a 403 error.  Hosting companies are continuously updating their server monitoring rules that seek to prevent malicious activity. Occasionally this creates false positives.  If this is the case they should be able to whitelist your site.


Unable to take Credit Card payment via PayPal after civi update

@andygoodall thanks for posting this, we believe we have a fix for your issue, We are looking to conduct a point release for 5.10 to fix the issue however i would recommend if possible manually applying the change described in this PR


How to expose participant information to the event's trainer?

From my limited knowledge of the module, this sounds like the perfect use case for CiviCRM Entity.

You should be able to add an entity reference field to the Event entity (that CiviCRM Entity would create), the Participants entity (I think that CiviCRM Entity would create) and one to the Trainer Content Type (that you'd create) and link them together.

From there, you should be able to create whatever View you want with logged on user as the contextual filter.


Form to enable existing member to edit selected value in price set

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.


CiviCRM Message Templates link changed, cannot find

CiviCRM 4.6 has a new permission to edit templates separate from "Administer CiviCRM", and I'm almost certain the issue you're having is that you need to add permissions post-upgrade.

From your URL, I'm pretty sure you're running Drupal (and I think I knew that anyway!) so go to http://secularstudents.org/admin/people, select the "Permissions" tab, and locate the permission called "Edit CiviCRM message templates".  Check that off for the appropriate roles and press "Submit" at the bottom of the page, the problem should then be solved.


Looking for Webform Calculator Experience

Coleman is listed as a maintainer for webform_calculator so there is a very strong chance that it works well with CiviCRM :-)


Need to change default text on Credit Card area

Navigate to:
Administer => customize Data and Screens => Word Replacements

This should do the trick.

Also please try the same for "Contribute" it will work but this will replace all the contribute buttons - so please test it

I guess this helps !!!

Thanks


Radio buttons are before the amounts and on a different line

CiviCRM should have those radio elements on the same line by default. My guess then is that the website theme or some other module/extension in place alters this behaviour.

This is really a CSS question, and since you're already not seeing the default appearance of CiviCRM forms (see Drupal, Joomla!, WordPress examples), your question is likely going to be better solved in two steps:

"How do I make my site theme display CiviCRM's form styling as expected?", then
"How do I change the CSS to position the radio buttons to the right of the label?"

To do that, you'll need to either give the URL of your site (so people can see for themselves) or describe enough about the CSS in place to let people give you an informed reply.

One thing you could try is switching to a default theme for your CMS and verify if the CiviCRM forms appear as expected. Then you have a reference point for what works, and you can start addressing the issue.

Hope that helps!


CiviCRM WordPress Member Sync - adding a new role or changing an existing one

The CiviCRM WordPress Member Sync plugin provides basic sync functionality and does not necessarily cover all possible use cases. What I would do in your case is use the civi_wp_member_sync_add_role hook to capture which user is being assigned which role. You can then remove the "Membership pending" role and make sure they only have the "Membership granted" role.


Failure in setting up Sparkpost for outgoing mail

I got Sparkpost support to help me with this. I needed to add a DKIM TXT entry in my DNS for vietfeir.com and generate a new API key.


Vague error in log "You do not have permission to access this page."

Try this extension

https://civicrm.org/extensions/civicrm-error-handler

  Sometimes CiviCRM can be real tough to debug. Especially when you are getting fatal errors, but only by some users, and you can't recreate the problems. This utility will send you a detailed email when a CiviCRM fatal error occurs.


How to automatically select a radio button?

The Profile Conditionals extension is intended to meet this need.  However, it doesn't have a user interface, so it requires some tech-savvy to deploy.


How can I create a user automatically when someone submits a CiviCRM-Webform?

Backdrop
The simplest way would be to use the Webform Registration module, which has been tested to ensure it works with CiviCRM email fields.
Drupal
This conversation came up on the CiviCRM chat. I have done this for a site previously -- following instructions from @petednz's blog post here. (Note that blog post also has some exported Rules that you can download to start with and maybe save some time).
But if you want to start from scratch, here's what you need:

Webform CiviCRM
Rules
CiviCRM Entity

Create a tag within CiviCRM, something like "Create Drupal User".
Set up the form, enable CiviCRM processing, and add a contact in the CiviCRM tab, customizing as you see fit.
On the "Tags and Groups" section for this contact, select the tag you created in #1.
Go to the Rules page (Configuration > Workflow > Rules) and click "Add New Rule"
Name the rule and choose the React on Event as "CiviCRM Entity Tag has been created"
As for Conditions, we first want to make sure there is no existing Drupal user for this contact, so we use the "Drupal User Account exists for Contact" and negate it (data selector value will be something like civicrm-entity-tag:entity-id-contact).
Then we do a data comparison on civicrm-entity-tag:entity-table to make sure that it is "civicrm_contact" (to be sure we are updating the right entity)
And as the final condition, another data comparison to make sure the tag that was created is the correct tag which should result in a Drupal user being created. Using the numeric tag ID from the tag you created in #1 (you can find this in the second column of the CiviCRM "Manage tags" section), we can compare to make sure that civicrm-entity-tag:tag-id equals this numeric ID.
Finally, under Actions, we can use the "Create Linked Drupal User Account" action on the data selector civicrm-entity-tag:entity-id-contact. There are a few other options within here which you can set related to whether to activate/auto-sign in/send notification email as well.


How to solve this error database looks to have been partially upgraded in CiviCRM

You would be able to successfully upgrade following these steps:

Empty the civicrm database
Restore civicrm database from the backup that you had created before performing upgrade
Temporarily remove the paths for custom PHP/template files if you have through: Administer->System settings->Directories
Try upgrading to version 4.7 again
Restore the custom files paths if point 3 was applied

Hope this fixes the issue.


PayPal Security notice, do I need to take action / upgrade Civi?

It seems it is about your ssl connection, so it's on the openssl layer connected to your webserver (apache or nginx).

Test your ssl connection with that site, https://www.ssllabs.com/ssltest/ it will tell you what needs to be improved.

In short, nothing to do with civicrm, but upgrading to the latest version is always a good idea anyway


Display custom contact dashboard only to certain Contact subtypes

Might just be a typo but you need == instead of =.
{if $contact.contact_sub_type == 'Student'}
But contact_sub_type is an array, so you could foreach over it and check if one of the values is Student.


Is it possible to show scheduled meetings in an Outlook calendar?

In Administer -> Customize Data and Screens -> Display Preferences you can enable "Include ICal Invite to Activity Assignees". That add an ICal Invite to the meetings and other activities and they can then be accepted and placed in the Calendar.


How do I eliminate the error "Timestamp Mismatch"?

[UPDATE - IS FIXED]

I fixed this by revisiting WordPress's settings and changing the Timezone setting from "UTC -5" to "Chicago".  Both of these settings reflect the same time zone, so why these two settings are seen as different I can't say, but Civi no longer complains.

So I guess the lesson is: if you want to get rid of this error and you're showing no actual disagreement on timezone between the server, PHP or WordPress, go to WordPress and pick the timezone that is named for the city you're aiming at.

Hope that helps someone.


Activities are not showing under Activities tab in contact record

I suggest you start by upgrading to the latest version of CiviCRM 4.4. That one is quite old and has security issues as well.


Authorize.net TLS Disablement Notice civicrm

See this blog post which has specific instructions.


What's the best way to take a 'snapshot' of membership counts at a point in time?

This is a tricky one - see these questions for a variety of approaches:

Is it possible to get point-in-time membership data?

How can I see the number of memberships at a given date in the past?

Membership Status Report


Error when updating Pending Contribution

I believe this is the same underlying error reported here:
https://issues.civicrm.org/jira/browse/CRM-20297

Specifically, contributions containing line items without a matching priceset can cause problems (because CiviCRM tries to match them up with priceset items and can generate errors when it does that badly).

It seems likely this error can be fixed using the patch provided for that issue, here:

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

Here's a short cut url to to a patch ready version of that pull request:

https://github.com/civicrm/civicrm-core/pull/10012.diff


Where to modify billing information form ≥ 4.6?

Your best option is to do what you were doing previously.

However, you will need to modify your customized template to extract details from the $billingDetailsFields array rather than the hard coded fields. I suspect the names are the same, so the translation should be relatively simple. You can use smarty debug to get more details on the contents of the array.


Philippe, Welcome to CiviCRM SE.

It looks like your server is using older version of php. Can you please check here if your server is using any one of the ones that are incompatible? If so you will need to upgrade your php.

Cheers

Pradeep


Contribution emails not being sent - Direct Deposit/Pay Later

Looks like this bug but it should have been fixed in 4.7.4


How do I change the contribution type for a contribution that was made before 1/1/1996?

Date Preferences at civicrm/admin/setting/preferences/date?reset=1 can be edited so the 'offset' is greater than 20 (years)

SO you can edit Date for activities (including contributions: receive, receipt, cancel. membership: join, start, renew. case: start, end.) and set it to have years going back further than 1996 (ie 20 years)


Particular report about contribution on CiviReport

You may have to use several reports for what you are asking. But the Contribution Summary report has most of what you are asking for.

Look at Contributions > Contribution Reports > Contributions Summary. This report will give you most of what you are asking for. Under Filter you can set your date range, financial type, and other criteria. Under Grouping if you Group by Name or Contact ID you will probably get the results you are wanting, but try other options. You probably want to uncheck Group by Date.  IN the columns tabs you can select what is displayed in the report, Name, state, etc. Check Contribution Amount Stats to see the total # of contributions from each donor, their Contribution $ Aggregate and Average.
In the previous report, you can click on a donors name to see their profile. But you may need to use the Contribution Detail Report to dial into specific donors. This would be to see their last contribution.


How can I emulate a CiviDiscount when using Webform CiviCRM?

This is easy to configure with webform civicrm (a Drupal module) - here are the steps:

A. Create a native webform field - call it Discount Code. Let's put it at the top - where we're going to select the Membership Type:

B. Go to your CiviCRM Tab -> then to Memberships -> and hit the checkbox on Membership Fee; this will expose it to the webform;

C. String it together with Conditionals: in your Webform Tab -> hit Conditionals
Here's mine:

D. Let's test the Form: here are the three scenarios:

Select Professional Membership - we don't have a Discount Code:

Select Student Membership - we don't have a Discount Code:

Select Student Membership - and we have a Discount Code:


Error on contribution details display, recently updated system

I think it would be worth following the lead about disabled or invalid financial types. At /civicrm/admin/financial/financialType?reset=1 , do any of the financial types show as disabled? If so, you could try enabling and seeing if that resolves the error.

If you have SQL access, you could check the financial type of working vs non-working contributions and see if there's a pattern. This is in table civicrm_contribution, field financial_type_id for the contribution itself and table civicrm_line_item, field financial_type_id for the contribution's line items.

The way price sets come into it: suppose a contribution page has a price set called Subscription, with price field Journal, with price field values (options) Print and Electronic. When you set up those price field values, you specify a financial type for each. This is stored in table civicrm_price_field_value, field financial_type_id. If the user selects "Print" and this has a financial type of "Publications", say, then the contribution will include a line item for that subscription, with financial type "Publications".

If the "Publications" financial type subsequently gets disabled or deleted, that could cause issues.

If you have SQL access, this query could shed some light on the message you  received during upgrade:

select pfv.id, pfv.price_field_id, pfv.financial_type_id, ft.name, ft.is_active
from civicrm_price_field_value pfv
left outer join civicrm_financial_type ft on pfv.financial_type_id = ft.id
where pfv.label = 'Contribution Amount'
and pfv.is_active = 1;

Any results where the last two columns are NULL (indicating a missing financial type) or the last column is 0 (indicating a disabled financial type) could have caused the warning you saw.

Some price sets are used behind the scenes, which could account for "Contribution Amount" not being recognised as a field that users have set up.


I found the issue... somebody unchecked the box
Disable CiviCRM css in "ressource urls"... Thanks anyway...


Please follow https://issues.civicrm.org/jira/browse/CRM-18376 for the resolution of this issue.


How to fix "Database In Unexpected Version"

Your database is running on CiviCRM 5.22.0. scheme
Your plugin in /sites/all/modules/civicrm is CiviCRM v5.20.2
You need to download and follow upgrading docs from Civicrm to upgrade your plugin folder to CiviCRM 5.22.0 or above, then do the database upgrade to make Civicrm plugin and the running database scheme run on the same version.


Spanish protection of data obey. Question about a possible Sue against your company

Is this the same as the EU data protection directive?  The good news is that it doesn't go in to force until mid-2018, so you've got a bit of time to figure it out.


I have found why it was not working. I was looking in the user interface whether my tokens showed up in the list with tokens a user can use. But they did not. After digging all the core code I found out that I had to use a combination of hook_tokens and an event listener for evaluate tokens.

I also had to put a require once statement to my token listener class in top of my module file otherwise it would fail with loading the file.

I also found a bug report indicating that token handling is redone and indicating that not all steps are done. See https://issues.civicrm.org/jira/browse/CRM-16553


What could be causing slow mailing from CiviCRM (via SMTP)

There are a couple of points to this.

1 - SMTP is chatty, it is a fairly slow protocol. To combat this, run several mailing jobs in parallel. This can be achieved by calling the process_mailing cron job multiple more frequently. Ensure that the 'cron job limit' is equal to the maximum number mailing jobs you would want to be active at any one time. This is useful if you have a sending limit on your SMTP server of x per second.

2 - The issue with 10 emails sent 'on the same second' and then a delay: MailingJob.php processes 10 emails at once, and then writes the transactions to the database all at once. So it looks like the emails were all sent on the same second. The '10' is defined in BULK_MAIL_INSERT_COUNT in CRM_Mailing_Config. Ideally the actual time of sending would be recorded in the database, rather than the time of writing.

To speed up mailings we now call the process_mailing job independently every 5 minutes, and limit the number of emails that are sent on a cron run. This means we have several cron jobs running sending emails at once for large mailings, which greatly improves our send rate.


UPDATE:  CRM-18526 fixes this issue - it's just been checked in.  To bypass this problem, upgrade to CiviCRM 4.7.8 or higher.

John is correct about this being related to CRM-18345.  There are two problems with the upgrade code - and the SET FOREIGN_KEY_CHECKS=0 others posted only solves one of them.

I've posted my analysis here, and I expect that someone will fix this issue.  However, if you're experiencing this now and want to upgrade, here's what to do.  I'm assuming that folks reading this will feel comfortable editing a file on their server, but aren't generally comfortable playing around with MySQL constraints:

First, restore your database to a state before the backup!

When you upgrade, look at the error.

Problem 1
Does the SQL statement that failed have the words DROP FOREIGN KEY in it?  If so, the problem is that you don't have the foreign keys.  In this case, it's safe to delete the code that tries to remove the foreign key.  Open up the file <civicrmroot>/CRM/Upgrade/Incremental/sql/4.7.5.mysql.tpl.  Find the command ALTER TABLE civicrm_mailing_event_queue DROP FOREIGN KEY FK_civicrm_mailing_event_queue_email_id (or whichever command corresponds to the error you're getting) and delete it.  Reload the page and the upgrade will continue.  It's very likely that if you don't have one foreign key, you don't have all four - so expect to repeat this three times.

Problem 2 Does your SQL statement that failed have the words ADD CONSTRAINT in it?  If so, you've already encountered the problem this code is trying to fix - but the code doesn't work if you've already encountered the issue.  To resolve this, add the line SET FOREIGN KEY CHECKS=0 on the line above the command that's giving you an error, and SET FOREIGN KEY CHECKS=1 on the line directly below it.

Don't forget - these commands are very similar, so if you think that this solution hasn't solved your problem, make sure you're looking at an identical error and not a very similar one!


com.osseed.eventcalendar can be used to display a calendar in the frontend of your Joomla-site by following the instructions in the readme.txt of the extension.

Copy the folder "yourextensiondirectory/com.osseed.eventcalendar/joomla/EventCalendar" to "joomlarootdirectory/components/com_civicrm/views/" which will add the menu item type for Event Calendar.

For frontend display you need to add a menu item of the type "Event calendar" and provide the calendar id (if you have multiple calendars). If you pass an empty ID it will display the global calendar for frontend.


API: Contact get/getcount by primary address country stopped working on upgrade to 4.6.9

This has been fixed at https://github.com/civicrm/civicrm-core/pull/6985 where you can get the Contact using different address fields specifying the names (country, state_province, etc.)


Group, Type, or Membership type - please advise

I would start by reading the "Groups vs. Tags. vs. Custom Fields" wiki page, but most likely you can use any of the approaches you suggested successfully.  I personally don't use tags much when I only need to tag contacts; they can't be mailed to like groups, and they're not as neatly grouped as custom fields are.  So I'd consider groups, custom fields, or membership types.

My main question would be how you intend to keep your data fresh.  Are you syncing in any way with your external system?  If so, importing custom fields or membership types is easier than importing groups.  Memberships are compelling because you can have different statuses, which would mesh well with your "reduced status" grace period.  The format in which you can export your other system's data (or better yet, connect automatically via an API) would be the deciding factor for me in your situation.


Drupal AJAX HTTP Request terminated Abnormally after file upload

Issue was resolved by modifying mod_security configuration


I believe the issue, certainly as per the youtube video, is because the Case Contact is not of type Individual, while the Relationship you are trying to use, Benefits Specialist, is only for Individual to Individual. This unfortunately results in a silent failure. So if there is any 'fix' required here, it would be to provide an error msg saying "this Relationships is not available due to mismatching Contact Types".

We hit a similar 'why can't we reassign a case to a new case manager' and the issue in our case was that Case Manager relationship was set to be Individual to Individual but in this case the Case Client was an organisation.

The reason we were able to create the Case Manager in the first place was because these were added via webform which seemed to create the Relationship despite the Contact Type not being appropriate.


You can find them by going to Mailings > Message Templates OR Administer > Communications > Message Templates in the menu.

Here is the documentation: https://docs.civicrm.org/user/en/latest/email/message-templates/


Why is my MySql DB Connect failing on New Joomla install

Try removing the apostrophes around the password, they are not required.


Is it feasible to use CiviPledge as a microloan management system?

It could work, (but if there is an interest, as Laryn mentioned)

Two other tools you might want to look at:

1) civiCampaign: you could have one campaign per loan (with deadline an financial goal) and record the payments as donations associated to this campaign.

(probably easier than pledge if the frequency of the payments is not very regular)

2) civicase: if you have a lot of other activities around a microloan beside the financial one (eg if there is an approval process before the loan, if there is a set of action in case on delay on payments....)

have a look at civicase, it's a powerful tool that might take you some time to set up, but that will help you enforce consistent workflow to support your work


CiviCRM 5.2.2 System Status gives Incorrect Resource URL (Drupal 7.5)

Go to Administer > System Settings > Resource URLs and check that the first one 'CiviCRM Resource URL' is set - usually [civicrm.root]/

It's worth checking Administer > System Settings > Directories at the same time.


Check:

templates/CRM/Activity/Calendar/ICal.tpl

I just took a quick look there and seems like the duration is not taken into account at all, which is a bug :(

Can you take a look and see if you can fix it. If so, please do submit a PR against the CiviCRM github repo. I'm pretty sure the activity object will be sending in the duration field. You should also file an issue for this on the CiviCRM issue tracker


Is there a bulk method to put emails on hold?

You can add an extra column to your spreadsheet called "On Hold" and assign it 1, another one called "hold date" and then (3 options below, choose 1):

import your sheet (using eileen's csv import extension) as "emails", with appropriate matching rules.

https://civicrm.org/extensions/api-csv-import-gui

If you're brave, you could upload your sheet as it's own table and do an sql "Update" on the civicrm_email table joining your new table via the email addresses.

You might be able to just import your sheet as a regular contact import with your strict matching rule, if your email addresses are unique (I'm not sure whether this would work, but it might be the easiest if it does - the part I'm not sure about is whether the mapping you get would expose the is-on-hold field and on-hold-date field).


Change Payment Method without creating additional transactions

So the answer is that it is not possible to change a payment method in core without creating additional financial transactions.

Background: a decision was made by some with decision powers that every edit should produce such transactions so this is working exactly as designed and the argument given is that this is in order to be compliant with accounting standards. The odd thing is that of all the projects we render IT services for every single CA considers such transactions noise and not helpful at all. I hope at some point we are able to revisit this and be allowed to simply delete payments [possibly with a permission level so a superadmin would need to authorize it] - it's completely reasonable to be able to delete transactions that never happened but were entered accidentally b/c of a default payment method e.g.

Your current options: a) via the GUI the only way to 'fix' this is for staff/admin to delete the entire contribution and re-enter it. b) via the Database: if you have access to mysql like you do - you can remove the extraneous transactions across a number of tables. I did one for a client this morning. Before you do this track a couple of contributions/'refunds' all the way through through all financial_ tables to familiarize yourself with the structure.

Another way to look at this is: admin/staff are allowed to delete all financial transactions - 3 in your case (by deleting the contribution) but are not allowed to delete a subset of the 3 - i.e. 2 in your case; whereas if you have permissions to delete all contacts, you can delete a subset;

PS - in credit card payments when mistakes are made a payment can be voided after it has been authorized but before it has settled. Such payments do not show up on a credit card statement. Perhaps we can adopt that concept and allow payment mistakes to be corrected for a limited time, as most mistakes will be caught (almost) immediately.


how do I turn off access control and allow all users to see all contacts?

There is a permission in the CMS (Drupal, Wordpress, Joomla) called "CiviCRM: View all contacts". Give this permission to any role/user that is supposed to see contacts in CiviCRM.


Events link outside of civicrm admin area does not work in wordpress

I believe that installing CiviCRM with WordPress in a different directory is not fully supported.

See this answer: 404 errors for loading CSS on Event pages (Wordpress)

The list of issues are documented on this page in the Wiki: WordPress installed in its own directory issues

If possible, I would suggest that you install WordPress in the root directory.


Uninstalling CiviCRM doesn't delete its settings which are stored inside wp-content/uploads/civicrm folder. The best option is to delete that folder (it solves this issue in my case).

WARNING! Remember about making backups before deleting anything.


Show the CiviCRM simple donate form on Drupal static page or node.

You can make a use of Webform CiviCRM Integration module which integrates civicrm donation pages with webform and webform can be used as block anywhere in the node, for that you would need Webform blocks module.


Can you post a screenshot of your discount settings? You must make sure that you created a price set for the event (sounds like you did) and that you added the price set as an option for the code to work with in the coupon settings.


Change MailStore from Gmail to Outlook on cloud

See https://docs.civicrm.org/sysadmin/en/latest/setup/civimail/#adding-an-incoming-email-account-for-processing-bounces-andor-email-to-activities. Go to admin - civimail - mail accounts.


At least a couple times a month, I copy our live site over to the dev version, which means different paths. I just make sure I:

delete the templates_c directory and let it recreate itself

change the civicrm.settings.php file

check the directories page in CiviCRM: administer > system settings > directories

check the resource URLs page in CiviCRM: administer > system settings > resource URLs

clear caches and update paths: administer > system settings > cleanup caches and update paths

Running through all these steps always fixes any changes in my installation directory.


What is civisubmit? It looks like contribute has been renamed.


SOLVED - Cron autorun config help please

I'm afraid setting up cron is a bit technical.  Perhaps your hosting company could help you get started?

You can find full instructions here: Managing Scheduled Jobs


How do I create a view to DISPLAY ALL EVENTS

Welcome to StackExchange Daniel. You are probably talking about this view: Events > Dashboard, which indeed only shows upcoming events and recents registrations.
There is another page, Events > Manage Events, that allows you to search and filter for events or show all events including past ones.

You could of course also create a report to list all (relevant) events and/or participants.


Error: Call to undefined function bccomp() in CRM_Financial_BAO_Payment::isPaymentCompletesContribution()

Apparently our PHP installation was missing the bcmath package which bccomp() needs. By installing the package via php7.1-bcmath we were able to then process the refunds accordingly. Did not see it here (https://docs.civicrm.org/sysadmin/en/latest/requirements/) but I could be missing something?


Including discount codes in membership imports

I am not sure why you need to import a discount code. A discount code is needed for online transactions so that civi knows to charge a reduced price yet still create a membership. Here the transaction has already taken place offline.

Import the contributions for the actual amount paid, with a contributions source of, say, Student (or student discounted price if you think you might forget the student price was discounted).  Then import the memberships. There is no link between contributions and memberships when they are both imported, so the membership "won't care" how much money was paid for it.


Is there a way to display the latest mail in CiviMail?

Option 1)

There is CiviCRM extension which seems to do exactly what you need: Public Mailings Archive filterable by date, template, etc. It says is compatible up to Civi 4.5 so you might need to contact the developer or test first if you are using 4.6

Option 2)

As you are on WordPress, check out Christian Wach's plugin, it creates a custom post for each public CiviMail mailing. You could link in your mailing to the custom archive page for that post, alternatively you could modify the archives-pages-template.php to output only the last post (ie last newsletter) if you don't want to expose previous newsletters.

Option 3)

Try out the Content Tokens extension and check if it fulfills your needs.

Option 4)

In conjunction with Christian Wach's plugin mentioned above, you could create your own token, as explain in this great post by Coleman.


How do I enable or disable Ajax Deduping?

You can disable/enable Ajax Deduping in Display preference.
Navigate to CiviCRM >> Administer >> Customize Data and Screens >> Display Preferences.

HTH
Pradeep


I ran into a similar problem today.  My solution requires some tech chops, but was very effective:

Install cv on the server if you haven't already.
Create a text file named forcemerge.php on the server anywhere in your webroot with the following contents:

<?php
eval(`cv php:boot`);
// Set the dedupe rule
$rgid = 13;
$return = CRM_Dedupe_Merger::batchMerge($rgid, NULL, 'aggressive', 1, 2, array(), FALSE);

Change the 13 above to the dedupe rule ID you want to use for deduping.  You can also change the NULL to a group ID if you only want to dedupe a particular group.
Set that file as executable and run it!

You should be able to see your progress a number of ways, by periodically doing one of the following:

select count(*) from civicrm_contact WHERE is_deleted = 0; in a SQL client;
Finding duplicates through the CiviCRM UI and then pressing "Refresh Duplicates" to see the number decrease.


Fix For "Incorrect Resource URL" Not Working

We've had basic authentication active on the installation which broke the check. After adding the server IP to the whitelist the error disappeared.


CiviEvent book multiple event at a single checkout

Just so you know, there's two extensions currently under development for CiviCRM, and specifically that integrate with CiviCRM's Event Cart feature, that might meet some of your needs. They're under active development, and you can check them out on CiviCRM's GitLab.

boxoffice: Provides a lighter workflow for the CiviCRM Event Cart. Designed for a ticket box office (ex: where you do not need the names of other participants).

eventpack: Provides a way to bundle events together (at a discounted price) in the CiviCRM Event Cart (and the Boxoffice extension).


Label Format does not fit in database - PHP 7.1 json_encode() and serialize_precision

I confirm that this is a bug in civicrm. I was able to replicate on my local running PHP 7.1.

I've created a Gitlab issue at https://lab.civicrm.org/dev/core/issues/612


If my website in in WP, can i install CiviCRM in drupal?

Welcome! What Masswear says is not right. You can have your website in wordpress and have CiviCRM in a Drupal installation.
You can the connect your wordpress site to civicrm with a plugin called CiviMcRestFace. This plugin creates an api connection to civicrm. So you need an API key (of the civicrm user) and the site key.
When you want to send signup forms to civicrm you can then use Caldera Forms and Integration of CiviCRM Form Processor with Caldera forms. You then also need the Form Processor extension in CiviCRM.
I believe that the Contact Form 7 CiviCRM Integration plugin also works with CiviRestFace. But I am not sure about that what I do know is that it connect to an external CiviCRM
When you want to display data from your drupal CiviCRM installation you can use the wpDataTable plugin and the Data Source CiviCRM api for wpDataTable plugin to display data from a civicrm as a table on your word press pages. Eventually you can use the Data Processor extension in CiviCRM to create custom api's through the user interface.


This is a preference you can set, but it's not exposed in the web interface.  There's a section of civicrm.settings.php that documents it.  In case you've upgraded from an older version of CiviCRM that doesn't have it, I'm including it here:

 // Opt-out of announcements by the CiviCRM core team for releases, paid services, events, etc. Separate each preferred optout category with a comma:
 //   "offers": paid service offers
 //   "asks": requests for donations or membership signup/renewal to CiviCRM
 //   "releases": major release announcements
 //   "events": announcements of local/national upcoming events
 $civicrm_setting['CiviCRM Preferences']['communityMessagesUrl'] = 'https://alert.civicrm.org/alert?prot=1&ver={ver}&uf={uf}&sid={sid}&lang={lang}&co={co}&optout=offers,asks';

More documentation is available at in the CiviCRM Administration Guide, see page Customization > Override Settings.


In order to see Activities fields in Views - do I need to add/install CiviCRM Entity?

The answer is No, you do not, at least for Drupal 7. What I was missing was to first, add a new View, selecting CiviCRM Activities, not CiviCRM Contacts. I discovered clues starting on page 169 of The CiviCRM Cookbook by Tony Horrocks.


How can I collect custom contribution data in an event registration form?

IMHO you cannot achieve this using a default event registration page. As you have mentioned, Drupal Webforms may be an option as well as using CiviRules or another extension/custom function that does some "magic".


Activity Permission - Prevent User to View Other User Activity - CiviCRM

I think this will require a custom extension to extend the ACLs such that the only folk who can see an Activity are those who are an Activity Contact (or who have View all Activities permission).

AFAIK this sort of permissioning is currently only provided through CiviCase but you have already indicated you want this as a new feature for Activities.

Search existing Extensions in case someone already developed this.

If you want assistance to build such an extension I suggest you try one (but only one) of the following so no one growls about cross-posting

https://chat.civicrm.org/civicrm/channels/dev
https://chat.civicrm.org/civicrm/channels/dev-newcomers
https://chat.civicrm.org/civicrm/channels/extensions

or if you want professional support you can find Partners such as Fuzion listed here.

Another approach, if you were using Drupal, and were interested in keeping most folk outside civicrm and have them interact mostly through Views and Webforms would be to build a View which would limit the Activities displayed to the Current User to those where they are a 'contact' on the Activity.

We do this quite a lot for clients who have lots of users but few who really need to get deep inside civicrm and bounce folk between using Views to find info and then Webforms to add/update.

Hope that helps.


Cron Wordpress 4.7.14 - will not send scheduled emails

Is there any output from the cron job?  (On Civihosting, you can configure the cron job to mail you the output.)  If it is starting but not completing, it could be running out of memory.


Strength testing password used to create user account

Seems like CiviCRM might not be calling the right functions within Drupal (which trigger hook invocation that modules like password_strength or password_policy implement.

Would be good if we can adapt Civi's code to do the right thing. The user/password creation for drupal is isolated to the file:

CRM/Utils/System/Drupal.php

Check the functions createUser and checkUserNameEmailExists


Check that you have the Drupal Views module enabled.  If it is not enabled then the settings are not shown on the CMS Database Integration page.


How do I process a refund for a credit card payment via iATS?

You will need to initiate refund at iATS gateway and then change the contribution status to refunded in CiviCRM.

HTH

Pradeep


I get a WSOD when I use the search function on CiviCRM

I don't have any experience with CiviRules specifically, but the two things that usually clear up WSOD for me (on WordPress at any rate -- what CMS are you using?) are to clear out wp-content/uploads/civicrm/templates_c, or you can also try going to Administer -> System Settings -> Cleanup Caches and Update Paths, then click the Cleanup Caches button.

Depending on what version of everything you're on there's also the possibility that the CiviRules extension isn't compatible with your version of CiviCRM, although a quick glance at their releases seems to indicate they keep very on top of things.

It'd also be helpful to see the log details about the 500 error if trying the things above doesn't resolve the issue.

Hope that gives you some things to go on.