Joomla account creation fields not appearing on profile forms I have exactly the problem listed in this forum post:

https://forum.civicrm.org/index.php?topic=11260.0

I'm not able to create any Joomla user via a CiviCRM profile form, because the Joomla user registration fields do not appear on the profile.

the "Allow User Registration" option in User Manager is set to "yes"
I've tried setting profiles to both "Give option" and "Require" Joomla account creation
I've tried custom and simple out-of-the-box profiles
Permissions all seem to be correct (anonymous users are allowed to create profiles, see all custom data fields, etc.)

I do also have Community Builder installed, but as far as I could discover that shouldn't cause any problems with the fields appearing.

Any ideas what else to check, or how to troubleshoot this further?

Community builder has a plugin called Community Builder System plugin that can be set to redirect or rewrite Joomla user component URLs. Perhaps this interferes and as a result keeps the field set of user registration URLs inaccessible and so out of view in the profile form.

I thank you for your check-list of steps to get the account creation fields to show themselves. It rescued me when I did not know how and why they kept not appearing in a new profile I was trying to get working.
So: well formulated question that answered me in my quest.


Scheduled Reminders problem in V 4.7.16 Has anyone experienced problems with running scheduled reminders under civicrm 4.7.16?  After upgrading to that version on 8th Feb and running scheduled reminders for the next issue on 11th February, I got the following error message in the scheduled jobs log:

"Finished execution of Send Scheduled Reminders with result: Failure, Error message: Error: Cannot use action tokens unless context defines mailingJobId and mailingActionTarget"

Scheduled reminders had been running fine until then so I have to assume that there was no problem until v 4.7.16 was installed.
The action tokens used in the relevant reminder were {contact.first_name}, {membership.type}, {membership.end_date}, a personalised checksum, {domain.address} and {action.optOutUrl}.

I'm not running any civi extensions.

I'm using an up to date version of Wordpress 4.7.2

Any help would be greatly appreciated.

As a quick-fix, remove the {action.optOutUrl} token.

To pursue a more general fix, there should be an issue in JIRA. One needs to determine whether:

The {action.optOutUrl} worked in a meaningful way in previous releases. (In this case, we need to define what that was and figure a patch to restore it.)
Or the {action.optOutUrl} never worked -- and merely became symptomatic in 4.7.16. (In this case, we need to manage the symptom better -- e.g. present a alert to encourage admins to fix their scheduled reminders.)

(If you don't have a JIRA account but can describe the expected behavior, then post a comment here, and I'll try to file it.)


Address field order on Contact's "edit" page How can I change the order of the address' fields on the page where I can edit the conatct's details?

Now I see the fields city, than postal code, than country, but I'd like to have postal code first, than city, and than country.

In the Address.tpl file is only so much:

{foreach item=addressElement from=$addressSequence}
     {include file=CRM/Contact/Form/Edit/Address/$addressElement.tpl}

How can I edit $addressSequence?

Thanks.

I think you will have a significantly easier time just reordering the fields with a little jQuery in a custom version of the template you referenced above.

For completeness... You can see the sequence function here: https://github.com/civicrm/civicrm-core/blob/5dde2c09c10513a22464e8c4abcb6b4ca17fc1cb/CRM/Utils/Address.php#L288


Profile add-to-group feature doesn't work with petitions In both the Contact Profile and Activity Profile, I've set the "Add new contacts to a Group" drop down to the desired group, but when contacts sign the petition they are added only to the Petition Contacts group.

Is there a way to automatically assign petition signers to a specific group?

This is probably a bug (or, perhaps more appropriately, an incomplete feature).  There have been a number of features that apply everywhere but in petitions--it's newer than some other features, and it doesn't have as many users as contribution pages or event registrations.

To double-check, visit a demo site (found via https://civicrm.org/demo) and confirm that the same thing happens.  Double-check (on your site and the demo) that you haven't checked the "Enable Double Opt-in for Profiles which use the 'Add to Group' setting" in Administer - CiviMail - CiviMail Component Settings, as that may indicate a problem with the opt-in emails going out (though you'd see problems with contributions and events too in that case).

Finally, assuming the problem's on the demo too, submit a bug report at issues.civicrm.org.


System Status: Error "Cron Not Running" after update to 4.7.4 So going through CiviCRM, this error keeps popping up:

Cron Not Running
No cron runs have been recorded.

Unfortunately, I have contacted my hosting provider and asked what cron isn't running related to CiviCRM, and they could not help me unless they knew the name of the cron. I tried seeing what it could be but I cannot find any information on this. I never had this error prior to updating to 4.7.4 from 4.6.10. I tried running a cron in the backend, like system update check, to see if it would fix it but it did not. What can I do to solve this issue?
Thank you.

A similar-sounding bug report has been filed here:

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

There are scattered reports of cron-related issues in 4.7 but people have been not giving detailed enough information to really pin the problem down. Can you say exactly how you have your Civi cron jobs configured to run? From your question it is not clear that you ever had cron set up correctly... the warning message about that is a new feature in 4.7 - it may simply be telling you about a problem that's been there all along.


Message template option missing in send SMS activity in CiviCRM 4.5.8 After upgrading a site to CiviCRM 4.5.8 the drop down template selector is missing in the Send SMS activity.

Has anyone else had this problem?

I've upgraded the CiviSMS Extension from 1.0 to 2.0, but this doesn't seem to have made any difference.

The character limit for the message has also jumped from 160 characters to 460 characters, I know I can amend the SMS API settings to allow extended messages. How can I return the character limit in the activity to 160?

Cheers

Craig

I just wrote a fix for this - https://github.com/PalanteJon/civicrm-core/commit/a7ea8fd5e8f74ea415d9ac026da4607e5a4da0fd

I'll submit it upstream as soon as I have a minute to write a webtest for it.


WiX Front End support First, is it even possible to have WIX as Front end CMS with CiviCRM back end. For example, I have event page on WIX, and registration goes through APIs to CiviCRM. I understand that CiviCRM supports it... but does WIX?

Second, can anybody share the good/bad/ugly experience? There is some new "code" functionality https://www.wix.com/code/home but it doesn't look very promising.

We have awesome web designer who is an expert in WIX. And since it is hosted service, it scares me how much will it take to integrate with CiviCRM (I am most familiar with Drupal version of CiviCRM; but I doubt that it will make any difference).

CiviCRM will need to be installed in Drupal, WordPress or Joomla so you can't install in on a Wix site.  However if you want to make event registrations available on your Wix site it looks like you should be able to do that - see here. That suggests you can embed external forms in iFrames or access 3rd party web services using Wix Code.  Not tried it, but looks like it should be possible.  Would make a good blog post if you do it!


Any happy IE8 users with civicrm image display issues? We've discovered an issue while trying to display civicrm contact image via Drupal Views in Internet Explorer 8,  it shows famous red cross instead of image; interesting thing happens when direct image url is being loaded, here is it:

We're aware that currently (CiviCRM 4.6)  ImageCache presets don't play nice with Civicrm image (there are civicrm forum discussions here: https://forum.civicrm.org/index.php?topic=34929.0 and here: https://forum.civicrm.org/index.php?topic=32232.0 ) but no clear resolution so far.
We realize it's quite historical and rare case nowadays, however, have hope someone out here might be able to shed some light on this.

Not exactly a fix, but rather a workaround: https://www.drupal.org/project/imagecache_external module has been used for an additional image pre-processing. Images processed by drupal imagecache module work just fine in IE8.


Finding the status of a recurring contribution I am setting up a website using CiviContribute whereby recurring donations can be set up.  Everything seems to be working - I can see the contributions when I go to Contributions -> Find Contribution:

and in the report:

However, when I cancel the subscription in PayPal that information isn't reflected when viewing the Contribution.  The only way I can see this information is by going to Contributions -> Contribution Reports -> Recurring Contributions.

but the contribution screen doesn't change

This doesn't seem to be very intuative, so I was wondering if I had missed something?

Thanks

If you look at someones Contribution Tab (rather the Contribution itself) then down at the bottom, below the list of any Contributions, there should be rows showing any Recurring Contribution. This should show you the status of the Recurring payment.


What is the difference between Tag or Group Liebes Civi-Team,

was ist der Unterschied zwischen den Tags und den Gruppen? Wie wäre es ratsam, diese einzusetzen?

Viele Grüße

Kerstin Krupp

Dear Civi-Team,

what is the differencer between tags and groups?

Best, Kerstin Krupp

both tags and groups are ways to segment contacts. There are a few differences:

Tags
 - can be used for contacts, activities, cases and attachments
 - quick to add, easy to use and find
 - you can not extends tags with custom fields AFAIK
 - easy to spot on the contact summary (if you do not use too many)
 - can not be used to create a segment of contacts for a bulk mailing

Groups

can be used to segment contacts only
can be extended with custom fields
can be used for Bulk Mailing and ACL's (fine grained permissions), scheduled reminders and subscribe/unsubscribe
you can also create smart groups (check https://docs.civicrm.org/user/en/latest/organising-your-data/smart-groups/)

You can read a little more on https://docs.civicrm.org/user/en/latest/organising-your-data/groups-and-tags/ and I would recommend you play a little with both to discover what would be the best alternative for your specific need.

And a little remark at the end: although there is a CiviCRM Core Team most of the posts on this forum are answered by community members :-) I get the impression from the "Civi-Team" you are expecting a big team of people employed by CiviCRM answering these questions :-)


Link Drupal Node Content to a CiviCRM user and add user to a group? I am trying to add the current user logged in to the Drupal 7 site to a CiviCRM group when they add content. For example we have a business directory and the signed in user can submit their listing. I want the user who submits the listing to be added a CiviCRM group called business directory which can then be used to email them in the future.

I tried using the contact reference field but this allows me to select the user. We want it to automatically select the signed in user.

Further, I am trying to get the rule to add the user to the group.

Has anyone achieved this with Drupal 7 & CiviCRM 4.7X.

Thanks.

You can use rules module where you set condition upon node submit to perform to add user to CiviCRM group.

Module: Rules/ CiviRules


How can I setup only contribution page in dual language I want to setup only a contribution page in two languages: English and Spanish. However, civicrm default language should be English. User should be able to select their preferred language to see the contribution page.

Is this achievable, any help greatly appreciated.

This is doable. First. Is your website multilingual, have you got it for two languages? What CMS platform are you on?


Civicrm upgrade from 4.2.9 to 4.7.23 I am upgrading 4.2.9 to 4.7.23. But while database upgrade i got error as "Found installation canary. This suggests that something went wrong with tracking installation process. Please post to forum or JIRA". As I researched, I deleted the table "civicrm_install_canary" but again the table creating dynamically. I didn't get any solution.  Please help me.

Thanks in advance.

If you're getting an installation canary error, that means you tried upgrading once and it failed - and then when you upgraded a second time, you got the installation canary error.  The original error is the "true" error.  You can probably ffind it in your ConfigAndLog logs.  However, you should restore your pre-upgrade backup before attempting another upgrade.  Fixing a broken upgrade is a very advanced topic.


webform participants extension - maximum of 9 tickets until error I'm using this extension for invoicing tickets bought via a webform.
https://github.com/fuzionnz/nz.co.fuzion.webformparticipants

When buying 9 or less tickets it works as required. Once 10 or more tickets are bought and the user submits payment its takes a long to load the next page which is white.

The payment is taken via eWay and the participants are entered into Civi. No confirmation emails are sent.

Without the extension enabled the payment goes through. I would like to use the extension, otherwise only 1 ticket is included on the invoice.

CMS/modules/Civi are on the latest version. Does anyone have any advice how to fix this issue? Cheers

You could raise an issue if you can identify the actual issue but we have this working on webforms with up to 30 tickets afaik

Pls dig in to your logs and see if you can find more information


Correct database collation recommendation I now get the following warning under CiviCRM Status:

  Future versions of CiviCRM may require MySQL utf8mb4 support. It is
  recommended, though not yet required, to configure your MySQL server
  for utf8mb4 support...

Currently our database uses the collation utf8_unicode_ci for all CiviCRM tables. I can change the collation easily in phpMyAdmin. There are a number of utf8mb4... collations available. I was thinking of just switching to utf8mb4_unicode_ci. Is that the correct thing to do? Will it make the system status warning go away? Should I put our website in maintenance mode for the switch? Thanks for any advice. I don't do much with MySQL details like this and any hand-holding is appreciated ;)

Good question. There's some discussion here about utf8mb4_unicode_520_ci or utf8mb4_0900_ai_ci, but there's maybe some issues with that since at the moment in the associated changes it seems to be staying at utf8_unicode_ci. But it might change.

But the warning might be due to your global settings. In order to support this you need barracuda format available and some innodb settings. Most likely this one is not the default in your install: innodb_large_prefix=true.

Also need:

innodb_file_format=barracuda

innodb_file_per_table=true


How to create a group from CSV file? I have a CSV file with email addresses. Part of these addresses are in CiviCRM.
How can I create a CiviCRM group that includes contacts with emails matching those in CSV file?

(EDIT - read Lars' suggestion first)
Seems clumsy but this might work.
Run the import with SKIP and at the final step of the import there is an option to either add the contacts to a New Group (A) for the same.
This should give you a group of those who did not exist in db before import
Then re-run the import without SKIP and create new group (B) so that should give you all the list.
then use Custom Search called Include/Exclude and


CiviCRM on Wamp server over lan network I want to access civiCRM in my organization's LAN network. Can anyone give a link or simplify the process to me? googling gives me many options, don't know which to try . using wamp server. Apache version 2.4.23 ; wamp server 3.0.6

This looks like a fairly comprehensive guide to allowing network access to your Wamp sites over a LAN.


If a contact is in Trash (because they were merged) but the person with matching details fills in Membership what is a good outcome Scenario was Contact A had email mydomain.co.nz

Contact A then filled out a Join/Renew (not using checksum) and used mydomain.nz

Result was Contact B was created.

Those contacts were later identified and merged while keeping Contact A with their original .co.nz email. Contact B was hence in Trash with the .nz email.

Contact then again renewed by using the .nz email - and hence the dedupe rules matched with the contact in Trash and added the membership to that record ie Contact B.

Seems like this is a fuzzy area, if a Contact is in Trash, but meets the required 'matching rules' what should happen to eg Contributions and Memberships or any other data.

I'd expect the Contact in Trash to be ignored by the dedupe rules, so if the dedupe rules don't match a (non-Trash) contact then a new one would be created.

If you add the Contact B .nz address as an extra email on Contact A then with the right dedupe rule you could avoid repeated new contacts.


Updating Civicrm Activities with Drupal Webforms We've been using Drupal webforms to create and update activities for contacts in Civicrm.
Ever since we updated to civicrm 4.6.18 (from 4.6.10), When the webform is submitted which is supposed to update a civicrm activity, it creates a new activity instead with a random date and a random contact as the "added by" name.
I've tested this on another site running 4.6.18 and the error only happens on my current site. I've disabled all the extensions and the error remains...

I enabled the date field in the Webform and set it to "now". When I enable "Update Existing Activity" It sets the date for may 23 2016. If I leave it disabled, the date field is set for today.

I'm at a lost where to look... any ideas?

Looks like this is an error that appeared with the Webform_Civicrm Module once updated Civicrm 4.6.18.
The reason I wasn't able to reproduce this error on my second site is because I didn't have the data needed to produce the error.
Issue was opened here: https://www.drupal.org/node/2759099


CiviRules opens strange window after disabling rule I'm experiencing strange behavior of CiviRules v1.12 (CiviCRM 4.7.14.)

If I disable a rule, an unrelated window pops-up. In this case, Fundraising call report. Why should it open a report, if I disable a rule? (screenshot added)

I think this is due to a bad user context somewhere in CiviRules. And probably related to this issue: https://github.com/CiviCooP/org.civicoop.civirules/issues/78.

The obvious next question is when will it be fixed? There are a few answers to that:

as soon as someone with programming skills feels the need to contribute a fix, which will earn him or her eternal fame.
when one of the CiviRules customers pays me (or another CiviCRM partner) to fix it.
When I get to my monthly community time and it is on top of my to do list.

The latter one is possibly in december, the earlier ones are unpredictable for me :-)


civicrmHooks.php no longer invoked under Joomla and CiviCRM 4.7.20 This is related to Invoking hook_custom_tokens and hook_custom_tokenValues in Joomla which used to work.  It has now appeared to have stopped working which means that the custom tokens handled by civicrmHooks.php are no longer available.  It looks as though civicrmHooks.php is no longer being invoked, as deliberately introducing an error does not result in CiviCRM crashing.

What has changed recently.  How can we solve this?

I've spot-checked the current 4.7.21-rc and as well as an older version 4.7.15 -- the problem reproduces in both. The problem arises with web-based requests in which these two operations are performed in the wrong order: (a) updating the include_path and (b) loading the civicrmHooks.php from the include_path.

(Doing a proper audit of Joomla regressions is painful, but I'd wager the problem originates in the 4.7 alpha/beta cycle.)

Searching JIRA for civicrmHooks.php turns up a nearly identical issue CRM-19914, which was fixed in WordPress -- but it was incorrectly described/triaged as a "Windows" issue. (The bug actually would have applied to Joomla+WordPress, regardless of OS.)

I'll submit a similar patch for Joomla under CRM-19914.


After 4.7 Upgrade Contact Pages Throwing Error The following error's are throwing at the top of each personal contact pages. It does not show these errors on an orgs contact page. I would appreciate any feedback.

Thank you!

Erin

detects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: array_keys() expects parameter 1 to be array, null given in /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php on line 1037

Warning: Cannot modify header information - headers already sent by (output started at /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php:1037) in /home/connectionsvol/public_html/civicrm/wp-includes/option.php on line 820

Warning: Cannot modify header information - headers already sent by (output started at /home/connectionsvol/public_html/civicrm/wp-content/plugins/civicrm/civicrm/CRM/Utils/Array.php:1037) in /home/connectionsvol/public_html/civicrm/wp-includes/option.php on line 821

I got this error in Drupal after upgrading 4.6.9 to 4.7.3. Exact text (repeating several times):

Warning: array_keys() expects parameter 1 to be array, null given in CRM_Utils_Array::formatArrayKeys() (line 1037 of /home/mysitename/public_html/sites/all/modules/civicrm/CRM/Utils/Array.php)

I was able to fix one record by editing & saving. But doing that for thousands of records wasn't an option.

So comparing custom fields of fixed records to broken records in phpMyAdmin, I found that the fixed records had blank entries whereas broken records were NULL, and that the number of fields that were checkboxes matched the number of error messages. I disabled my custom field sets and the errors went away.

After disabling my fields, I updated the custom field to set the value to blank where value is null. The SQL was similar to this:

update `civicrm_value_custom_table_1` set `custom_field_123`="" where `custom_field_123` IS NULL;

I repeated that for all problematic fields, enabled my custom fields and all was well.

tl;dr: Cause is NULL values in custom checkbox fields. Fix is to update NULL values to blank values


CVV is being required in backoffice, even when it shouldn't be Using CiviCRM 5.7.6 w/ Drupal, I'm getting an issue with my backoffice contribution forms. Specifically, even though the configuration says not to require CVV, and the form itself does not have a (*) to indicate it's required, I'm still getting an error if I submit the form without a CVV, and the error tells me that I require the CVV.

When I look at the code, the key seems to this piece of code, around line 278 in CRM/Core/Payment/Form.php:

  public static function validatePaymentInstrument($payment_processor_id, $values, &$errors, $billing_profile_id) {
$payment = Civi\Payment\System::singleton()->getById($payment_processor_id);
$payment->setBillingProfile($billing_profile_id);
$payment->validatePaymentInstrument($values, $errors);

}

Specifically, the validatePaymentInstrument call of the payment object triggers the error because the payment object itself doesn't have the isBackOffice property set. It's not clear to me why it should have that isBackOffice property set unless that object had been created earlier in the code flow and the backoffice property set there.

It also seems to me that this form is the backoffice form, so we could put in a setBackOffice call just before the validate call, but I'm curious why this code seems to have worked in the past.

I'll note also that the error is relatively recent, and it's not clear to me whether it might be code version and/or php version dependent.

This isn't a full answer, but we (Karin actually) discovered that by removing the redis caching configuration from the civicrm settings file, the problem went away.

This is a bit weird, since the problem I was looking at was the static code cache, but it sort of makes sense if the api call that pulls in the payment object could potentially be reading from the more permanent (usually mysql table) cache.

So, my best guess to this issue is that there is some code somewhere that is accessing the CiviCRM cache without using or knowing about the use of Redis.

On it's own, this just means we can't use the Redis cache for CiviCRM, but it suggests that there might be a bigger problem hiding in here.


How do you input Virgin Money Giving Donations into CiviCRM? Just a quick question, is there any better way to get donations from outside services like Virgin Money Giving or Facebook that just manual input?

At the moment, I'm just assuming that we add the contact/donation manually into the system with the source being "Facebook Page" or "Virgin Money Giving" or whatever it may be.

Any suggestions on how any other NFPs are doing this with Civi at the moment?

Thanks.

If you can export the donations out of those systems in a CSV then you could import the contributions to Civi.

There is fairly old extension for importing Just Giving donations.  Don't know whether it still works but would be a base for developing an automated import.  Once it is working you could add a Scheduled Job to do the import regularly.  Obviously you need to be careful to avoid importing the same donation in multiple batches.


How can I search in the greeting fields? I would like to do a search in the greeting field for all contacts with the greeting 'Dear%'. Neither with the search builder nor the contact search I was successfull. Can anyone help? Thanks!

Use the search builder again, select contacts from the include where, pick up Email Greeting and the operator is LIKE dear%

Just tested this on the drupal demo site, and it works.


How can I change what data gets exported using the Accounting Batches feature? I want to use the accounting batch feature to group together and export transactions data so that I can them import that data into my accounting system (Xero). But Xero has a strictly defined structure for the CSV file it will accept, and there doesn't seem to be any way to edit the order of fields, or to add in any custom fields, to the data that CivicRM exports.

I did find this useful blog post https://civicrm.org/blogs/pogstonesarahgladstone/creating-accounting-batch-export-format-accountedge which gives some pointers about how to hack the core files to make changes.

Surely there has to be an easier way?

Have  you seen Eileen's extension for integration with Xero?
CiviXero


Can you use civicrm for inbound marketing instead of HubSpot? We are considering using HubSpot with our Drupal 6 website to help with lead generation. Is anyone using civicrm for his purpose? Can civicrm create workflows once someone opts in via a form?

Specifically, we want to create landing pages with opt-in forms to capture web visitors' first name, last name and emails. Once we have that lead information, we want to be able to send them auto responder emails with messages that link to or contain content like white papers, video, text attachments etc. on a specific schedule. For example, we want an automated workflow that would send a lead something right after they submit info, then send another piece of content 2 days later, then a week later, and 2 weeks later. This automated workflow, landing page, and all the data about visitor behavior with this content is what HubSpot provides.

You can create webforms with CiviCRM to capture the data you're requesting.  With the CiviRules extension, you can easily send automated email on a schedule like you describe.  In fact, CiviRules was originally created to do almost exactly this.


How to make a report with each Financial Type as a column? I need a report of contributions which has a row for each contribution, and then analysis by showing a column for each financial type, and the total amount of the contribution in the right financial type column. Is there any way of doing this without programming an extension?
I include a screenshot of the kind of thing I need. The columns to right of VAT are financial types, so each payment is broken down into VAT (if applicable) and one or more financial types.

I am not sure you would get the exact requirement you looking for but you can use contribution pivot reports to group the records based on financial type via

Extended report

or

Report plus


Upgraded to 4.6.2 - 'New Mailing' brings up 'Unknown Extension' error Just upgraded CiviCRM from 4.5.3 to 4.6.2 on Wordpress. All seems to be working apart from when I select 'New Mailing' option under 'Mailings' - it takes me to a screen showing the message below:

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

Unknown extension: .

Return to home page.*

Any suggestions?

You'll get a more complete error message if you turn on debug + backtrace in CiviCRM. Also, since the message is coming from the extensions system, can you try disabling your CiviCRM extensions?


Quick explanation of 'hidden smart groups' and why they're included in my mailing uninvited? I haven't been able to find information on these hidden smart groups anywhere using google or this forum. Perhaps because they are hidden on purpose?

I'm wondering what these groups are, and why, when I schedule a mass mailing using civiMail targeting search results rather than a group with an unsubscribe group, the last step says something like:

"Include: Search Results (####)

Include: Hidden Smart Group (84)

Exclude: A group I need to exclude (###)"

Are those 84 people in my initial search? I'm hoping that we are not emailing folks that have not subscribed to this mailing list.

84 does not match the number of people in the unsubscribe group we are using.

Thanks for any explanation available!

The search needs to persist through your whole mailing process, so it gets treated as a "hidden smart group".  It's silly of CiviCRM not to explain better, but that's the deal.  No mystery hidden people getting added without your knowledge.


What is effect of marking contact as deceased? What is the effect of marking a contact as deceased?  Does this automatically stop email traffic to the contact's email address

Deceased should have the following outcomes (iirc):

Contact Record shows (deceased) in red after their name
CONTACT IS DECEASED shows in demographic fields
contact is excluded from mailings and PDF prints
contact is excluded from exports unless overwritten
the status of memberships will be changed to "deceased"


Why would my CiviCRM CSS file not load correctly? I'm having trouble with my CiviCRM CSS file not loading correctly -- the admin bar becomes a bulleted list of plain text.

Any suggestions?

I would guess it is likely an issue with domain name and/or HTTPS conflicts. In your civicrm.settings.php file you define a CIVICRM_UF_BASEURL which may or may not include the www or https:// on the domain name. For example, it could be:

http://yourdomain.org/
https://yourdomain.org/
http://www.yourdomain.org/
https://www.yourdomain.org/

So my recommendation is to make sure that you forward the other 3 versions to the version you would like to use throughout the site. Then you may want to double check that the URLs set up in the CiviCRM Resource URLs page match (Administer > System Settings > Resource URLs).


Mass editing contact's birthdays Due to problem on our end we have about 13 000 contacts with "01.01.1970" as their birthday. I'd like to remove that from all those contacts, and tried doing that by using "Batch Update via Profile". I made a simple profile with only birth date, but it doesn't seem to work.

Firstly I have to manually type in the birth date (calender drop down doesn't work), and using the copy button doesn't work. Changes are not saved either.

Does anyone know of another way to mass edit birth dates, or does anyone know how to fix this bug? I'm quite new at CiviCRM so I might have done something wrong.

With that many contacts whose records all need changing, I think I'd be inclined to let them do it themselves.  You could send them each an email with an editable profile including date of birth (required).  You could include a checksum to save them having to login and the profile form would then be pre-filled.  This could be a good time to keep their profiles up to date.

You dont say which CMS you are using but a useful link to token checksums is at https://wiki.civicrm.org/confluence/display/CRMDOC/Tokens.

Checksum for standard Profiles (edit mode): To send people to a profile use this path where N is the ID of the Profile you want to send them to:

Drupal: http://www.myorganization.org/civicrm/profile/edit?reset=1&gid=N&{contact.checksum}&id={contact.contact_id}
Joomla!: http://www.myorganization.org/index.php?option=com_civicrm&task=civicrm/profile/edit&reset=1&gid=N&{contact.checksum}&id={contact.contact_id}
WordPress: http://www.myorganization.org/?page=CiviCRM&q=civicrm/profile/edit&reset=1&gid=N&{contact.checksum}&id={contact.contact_id}

Hope this helps.


How to adjust the column width of an item on a contribution receipt? As it can be seen from screenshot below, the "QTY" column is too close to the "Donation amount" and often times it can be mistaken as "1081" instead of "108". Is there a way to adjust the column width of QTY on a contribution receipt? I have tried add style="min-width:20%" but doesnt work. Any tips would be much appreciated. Thanks

would be nice to have border for tables to avoid confusion. you can add css in your message template, either it can be inline or using  tag

{literal}
  <style>
    .button-group {
      display: block;
      margin-top: 5px !important;
      margin-bottom: 5px !important;
   }
  </style>
{/literal}

Thanks
Pradeep


Word replacement not working in some areas I'm in Canada, and instead of County, we use "Province". I've set up a Word Replacement for "County" to change it to "Province", but when I edit a Contact, the label on the form still reads "County".

I'm running civiCRM 4.6.9 under Joomla 3.4.5

A short video walkthrough: http://www.youtube.com/watch?v=ok02KLEpYKM

Can anyone explain why this Word Replacement isn't working?

Word replacement for County works on the demo - I renamed it to County/rename.

http://joomla.demo.civicrm.org/administrator/?option=com_civicrm&task=civicrm/contact/add&reset=1&ct=Individual

State/Province is a default field, I'm not sure why you're not using that, instead of renaming. Look at your address settings, link on demo: http://joomla.demo.civicrm.org/administrator/?option=com_civicrm&task=civicrm/admin/setting/preferences/address&reset=1


I just fixed this issue on a site I was working on.  Hopefully it helps you as well.  My issue was directory permissions.  You need to make sure that all of your directories have permissions set to 755.  My contribute folder was set to 750, which did not allow the directory structure to be loaded beyond that point.  Because of that, it's not able to load the angular-modules.2513685c7e9bf04c4c187f640cffc720.js file.

An easy way to do this is to use FileZilla and navigate to somewhere you know is ok, maybe your /var/www/html/drupal/sites/default/ directory.  Then you can right-click on the files folder and choose File Attributes or File Permissions depending on which pane you use, and make sure permissions are set to 755.  Now choose Recurese into subdirectories and MAKE SURE you select Apply to directories only, you don't want to apply it to files.  Click OK and once it completes, try going to your system status page again and hopefully it works now!


Can I get a list of contacts without created case? I'm wondering if it's possible to get a list of contacts without a created case (even if the case is closed).
We have a workflow when some beneficiaries "apply" to be "active beneficiaries" to receive companion from volunteers. Then, after an evaluation, the CiviCRM users open a case to that beneficiary to follow up their activities. How ever, we need to know how much and which contacts in that "active beneficiaries" doesn't have a case created, to don't lose any contact that could be unattended.
I tried with advanced search, but this is a negative criteria with an "empty" field. I mean, this should be "Contacts in X group AND Not in a case?
Thanks for your feedback,

This might do it for you or point you in a direction
Create a Group of All Contacts (A)
Create a Group of All Contacts who have ever had a Case (B)
Use the Custom Search: Include/Exclude Groups and set it to A-B


Database error when using CiviCRM admin UI: "Row size too large" I'm helping on a site that is on a different server than usual and see this error regularly in the back end when trying to complete various tasks (e.g. clear caches, run database updates, etc.)

[debug_info] => TRUNCATE TABLE civicrm_menu [nativecode=1118 ** Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.]

The site is mostly working, but as mentioned many tasks error out and the above shows in the debug log. What could cause this?

Also see https://civicrm.stackexchange.com/a/31644/225 where the suggested fix is:

 ALTER TABLE civicrm_menu ROW_FORMAT=DYNAMIC

Then rebuild the menus


Reporting Drupal 8 Bugs Are we at a stage where we can be reporting Drupal 8 bugs?

If so, where should they go? Should they go on the Jira somewhere, or maybe a mailing list?

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

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

If you add new ones label them drupal-8


Is there a CiviCRM User Actions Log Feature? I need a log of user actions due to a security breach (theft of User Information). However, according to my knowledge and research, CiviCRM does not have such a feature.
How can I access a user's User Actions Log data in CiviCRM. The information I want is as follows. Whenever the user logged into the system, opened a new individual and activity record, and made a search, what is the IP address of my site. Like. There is a feature like this in Joomla but I can't use it either. I wrote the reason in the Joomla form. I think he should keep a diary like this for security breaches and similar issues. The system below is used by Joomlan. Is it possible to adapt this for CiviCRM? Can you help me with this.

The short answer would be "no" since CiviCRM is not responsible for authentication, the CMS is.
CiviCRM can be configured with various levels of logging, but as a general strategy, you'll want to make use of multiple tools when investigating security issues, which will depend on your individual setup.
For the specific issue of 'theft of user information', there is an extension that prevents administrators from downloading contact data unless given explicit permission, you might want your organization to use that going forward.
Other than that, if it's a bunch of data that was downloaded, then I'd comb the webserver logs for large downloads, find the originating ip and then look for matching login urls with the same ip.


Possible bug? "Enable Double Opt-in for Profile Group(s) field" displays twice Seems that Enable Double Opt-in for Profile Group(s) field option has two identical copies in CiviMail Component Settings.

Also present on test server. https://demo.circle-interactive.co.uk/

Yes this happened since 5.8.  I have submitted a PR for this issue. You can either apply patch or wait for 5.18 release.

  Note: Since this change involves update to settings file, you will
  need to clear civicrm cache after applying patch.

Cheers

Pradeep


What Civicrm Theme(s) are better than Garland? I've been using Garland for a long time, but our staff complain that it's drab. Anyone have a suggestion for something brighter but also very clean (ie. good workflow, low rendering overhead)?

Bright and clean: I use Seven (ships with Drupal 7 Core - so well supported) as CiviCRM Administration theme - for nearly all of our projects. Easy to subtheme as well - making it a MySeven - if/when required.


How to avoid a duplicate membership for same contact When I connect a contact to same membership type, the system displays a warning message that it is a duplicate membership for the same contact, but still allows to to perform the action. Then I get two active records for the contact with same membership. How can I avoid it in such way that the system will block the ability to create more that one active record for same membership type?

I suspect the OP needs to avoid the creation of double backend membership with the same type. Something which would look like -

This could be a bug(not sure) as this doesn't happen when registered through contribution pages. I don't think there is any setting in civi UI which would avoid this, but it is possible with a small extension(learn here) where you need to check for double membership type registering for a single contact id.


Can I deactivate my CiviCRM WordPress plugin without losing all my data? We haven't used our CiviCRM plugin for quite some time, but it has acquired data I don't want to lose. I think it's slowing our site down and I'd like to disable it in anticipation of increased web traffic for an upcoming event. If I deactivate it, will I lose all my data?

Welcome to SE! If you deactivate the CiviCRM plugin the data will still all be in the database and not changed. However, I'd be surprised if CiviCRM slowed anything down if its not being used, so I think you'll have to look elsewhere for your problem.


Why does a Smart Group disappear when assigned a Parent I'm running CiviCRM 4.7.6, and in attempt to associate an ACL with a Smart Group, I assigned my Smart Group a parent which is a static group. This seems to have worked, in that when I list the members of the static group, the members of the Smart Group are in the list, however now the Smart Group has disappeared from the list of groups.

To summarize:

Created Smart Group called "Current Members" that selects contacts based on their membership status
Created static Group "Members"
Assigned "Members" as the parent group for "Current Members"

Now, Static Group "Members" includes all the contacts from Smart Group "Current Members" has disappeared from the list of Groups.

Did I break some rule mixing Smart Groups and Static Groups, or is there some list of child groups I don't see?

On the manage groups screen is there a triangle to the left of the word 'Members' that expands to show the child groups when you click on it?  There should be.


ACL setup to deny export rights is there any way to set an ACL (or any other permission) that denies some groups the right to export contacts during Advanced Search, while still allowing the search to take place...

I'm aware that I'd need to accomplish this by permitting specific groups to do this (if the feature exists), thereby denying others the permission.

I couldn't see this option in the ACL setup process, /civicrm/acl?reset=1.

Thanks!

(Civi 4.6.14, Drupal 7.43)

There is not. In CiviCRM, ACL and permissions in general are contact-based: if you have permission to see a contact, then you see all related data about this contact. And if you see some data on screen, there is no reason you would not be able to export it.

The solution to your issue is to customize the export code to check the logged-in user and eventually display an error message if you want to deny this user the export.

Such a change would be in file CRM\Core\Report\Export\Excel.php as this file is responsible for generating all export files.


CiviCRM_API3_Exception: "API error: DB Error: already exists" CiviCRM_API3_Exception: "DB Error: constraint violation" I have fixed these problem by updating one by one from 5.14.1 to 5.19.1 but now I have got new problem :) In the new version I cant install/uninstall and update any extention. I got the following error on screen:

But I realised when I click back than is the update or install/uninstall is done. But everytime when I try I get the same error. Anybody who knows the reason of the error showing ?

Following on from the comments:

Sorry I don't speak Turkish but I put your comment into Bing translate and the short answer is "yes". The error happens when you have changed a relationship type (which happens automatically if you change the language) and you're using CiviCase in non-english. So the temporary options are:

Disable civicase or only use english. (Not the best option.)
Put the relationship type back to the english version. (Also not good.)
If you don't have many relationships entered yet you can delete all the relationships, delete the relationship type and recreate a new one, then update your case types, then add your relationships again.
Wait until 5.20.


Is there an update to AuthorizeNet.php with SHA-512 to replace MD5 check? Is there an SHA-512 replacement for the AuthorizeNet.php module yet? If not I can work on it

Lesley, CiviCRM 5.11.0 doesn't use anymore MD5 check on authorize.net. This PR removes the check. However there is still not PR submitted by anyone to support SHA-512 check.

If you can submit a PR to support this would be very useful to the community.

Cheers

Pradeep


Is CiviCRM thread safe My system administrator asked me if CiviCRM is thread safe. He could not really explain what he meant by that but he explained me that civicrm should be thread safe because he wants to use Apache Event module as a webserver.

And I don't really know if CiviCRM is thread safe. I have read this topic https://stackoverflow.com/a/5978844/3853493
and it looks like PHP is the problem but not really an application written in PHP.

The question really is, could we use Apache Event module in conjuction with CiviCRM.

I would say no:

As you've said PHP is not thread safe
CiviCRM does not focus on preventing race conditions in a few cases. Event registration and max participant count was one case (it might be fixed by a contrib in recent versions)


Scheduled job execution time is creeping I have a scheduled job that runs at 10am each day. It just sends a report.
I'm noticing over time that the job is executing later and later. Now it is executing at 10.15am. Anyone else noticed this and it there a way of fixing it without having to go back into the scheduled job and reset the time?

This is a problem that's popped up and been squashed a few times - it's a little trickier to fix than it seems.

The current conversation about it is on Gitlab but CRM-17671 provides some historical perspective.

Your best short-term solution is probably Xavier's answer on a very similar question.


Where is the file civicrm.settings.php in WP? Wordpress 4.9.6 and CiviCRM
Where is file civicrm.settings.php?
It is not in  /wp-content/plugins/civicrm/civicrm
It is not in  /wp-content/uploads/civicrm

thanks

That sounds weird. The /wp-content/plugins/civicrm/ path is for CiviCRM versions older than 4.7. For a new install you should find it under /wp-content/uploads/civicrm. I hope you are looking in right directory.


What should be entered in the campaign field when importing a CSV file? I'm trying to import a CSV file with donations that need to be linked with a certain campaign. I tried putting the campaign name, then the external id, and even just "matching" but all of them are generating an error. Any advice?

I am running CiviCRM 4.6.19 on Drupal. The error message is:

  'xyz' is not a valid option for field campaign_id

I was able to successfully import the campaign on a contribution by importing the campaign's CiviCRM ID.

I agree that it seems odd that campaigns have an "External ID" field, but it can't be used for imports, though!

You can find your campaign IDs by going to Campaigns menu » Dashboard » Campaigns.  In CiviCRM 4.7+, they'll be in the first column of the list.  See screenshot 1 below.  If you're using CiviCRM 4.6 or lower, you can find the ID by hovering your mouse over the "Edit" button next to a campaign and reading the ID that appears in the URL at the bottom of your web browser.  See screenshot 2 below.


How do I create conditional forms? The charity I work for has two specific scenarios where I need to create conditional activities based on form input.

1) We run a food bank and referring organisations fill in an online form. However, after six food parcels within a three month period, we expect those being referred to book an appointment with one of our client advisors. How can I set the form submission to check how many times a person has been referred and, if they have reached the limit, change the form to book an appointment.

2) We host a dinner, with a limit of 60 places, where volunteers are expected to bring along someone who isn't linked with the charity. How do I set a condition on the form to check if the registrant is bringing someone who isn't linked to the charity and, if not, place them on a waiting list.

If you're running CiviCRM in Drupal you can use the Webform CiviCRM module to provide conditionality to Civi activities


Howto hide/disable fields not needed My company does not make use of many of the fields provided by civicrm. Our users told me the sheer mass of empty fields is overwhelming them.

I know I could walk the hide-by-jquery-to-death way, but:

Is there a designated or recommended way to disable or hide civi core fields like "nickname" or "legal_name"?

You can hide some of them via the UI at Administer > Customize Data and Screens > Display Preferences

e.g. http://d46.demo.civicrm.org/civicrm/admin/setting/preferences/display?reset=1


CiviCRM & Joomla Username Check Availability I am trying to get CiviCRM (5.3.0) and Joomla (3.8.10) working with the Username Check Availability link. I have checked the code and found the following:

Check Availability

I cannot figure out if I turned something off or is there a problem with the Joomla integation? The accounts are being created in Joomla when registering by using a Profile.

Any suggestions would be appreciated.

Thanks.

It appears that the CiviCRM 5.12.3 and Joomla 3.9.5 combination, the issue is fixed.


Twilio Inbound SMS: 404/502 Responses CiviCRM: WordPress V5.6.2, hosted on CiviHosting
We can successfully send outbound SMS messages but cannot receive replies back through the webhook in Twilio. We either get HTTP 404 Not Found, 502 Bad Gateway (both encountered on version 5.X), or Schema Validation required responses (encountered on version 4.7).
Twilio Error example:
We followed the CiviCRM setup documentation here, including using the example callback URL.
I have noticed other posts on Stack Exchange highlighting similar issues with different suggestions for callback URLs but all of those different URL configurations have failed, and none of the posts seem to define a clear answer/solution.

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.


Incoming Grants: CiviGrant or CiviCase? A new non-profit is asking which component is best for tracking incoming grants, and tracking them at a more detailed level (with activities, maybe even tying the final incoming contribution to the grant).

I saw the older blog post about CiviGrant vs CiviCase, and understand the concepts there.  But I'd like to get a feel for what most folks use these days for this type of incoming grant tracking.

It seems to me that CiviGrant is rather basic in design. It just tracks the most basic parts of a grant: its status, type, amounts, etc. It doesn't necessarily track ongoing activities at the grant level (each time there is communication or meetings about the grant, and so on). It also doesn't tie to a contribution, it seems.

CiviCase, on the other hand, is rather complex in its structure as it has workflows. It almost does more than what one might want for grant tracking. But it seems to allow for activities and maybe even contributions tied to the grant.

So it's a toss up between simplicity vs deeper tracking. What do people find most useful for incoming grant tracking?  Do you all use CiviGrant and add activity types (but not sure how it would link to the grant itself)? Or do you use CiviCase and create a more basic workflow?

Appreciate any thoughts you all might have!

I find that this is really dependent on the client's needs.  If all they need is a list of grants they applied for, I might use neither - and just use activities.  If they need to track upcoming deadlines for applications, deliverables, statuses, etc., then CiviCase is a better fit.


What is the price of CiviCRM? Can i know the price for this CRM? I'm planning to get a CRM application for our organization and this look like a perfect match. Appreciate if you can let me know the cost for the full implementation

CiviCRM is open source, so the software itself is free to download. So depending on your skills and availability of hosting it could be free.

In practice, hosting costs (a bit of) money. It will cost your organisation time to learn to use CiviCRM. And if you would want extra help you would pay it to one of the CiviCRM Partners you could hire. (The Partner list can be found here: https://civicrm.org/partners-contributors.)

If your organisation starts using CiviCRM you could help support the CiviCRM community by a (yearly) donation or by becoming a CiviCRM member (https://civicrm.org/become-a-member).

But all that is voluntary and completely under your own control.

When you like CiviCRM at first sight you can get more hands on experience by looking at http://demo.civicrm.org.

After that you could try to download and install it (https://civicrm.org/become-a-member).

Let us know if you need more information.


how to resend a mailing to corrected bounce addresses? so i did a mailing, a handful of bounces on a vip group, so we took the time to find why the email addresses were invalid and fixed them.

How can we resent this email to the corrected emails? I did try to clone the mailing and exclude the ones that received the previous one, but civi is removing all the contacts, even those that didn't receive it.

In Adv Search you can select the 'bounced' contacts for that specific mailing and then add them to a new group (or not) and fire a new Mailing off to them


How to search contacts with certain prefix say, "Dr"? I want to search contacts with prefix "Dr." and if possible make it as a smart group. How to achieve these?

This is job for the Search Builder that you can find in the Search menu

Select Individual
Select Individual Prefix
Complete with = and the desired title.

When the results are shown you can create a Smart Group for this search.


How to disable nickname field I'm trying to add an option to disable the display of nickname in the setting preferences.
The checkbox is appearing but it doesn't work, when the option is not checked the nickname field shouldn't appear in the contact.
I added the option value with Apiv4.
btw Surnom = Nickname

You might also need to use hook_civicrm_buildForm in an extension to override what's happening in CRM/Contact/Form/Edit/Individual.php, e.g. check the value of your setting something like this but less goofy, and then remove the nick_name field from the form.


how to add a Pledge to contact Hi,
 How do I  add a Pledge to contact so that he may view & pay pledges thru the  self-service payments page?

Did you read the manual before asking this question?

As per my reply here

CiviPledges can be set up so that

a logged in contact can see their upcoming Pledges on their dashboard
a contribution page can be set up as a self-service payments page

Setting up a pledge is here

The contacts Dashboard is here

The self-service payment is here but will only show if 'demo' contact has a pledge set up

If you need to add a Pledge to contact called 'demo' you can do so here

Hope that helps you.


How to enable components? hello I currently use CiviCRM 4.7.29 with Drupal

I activated the CiviCase, CiviCampaign and CiviGrant components but I do not see the associated menus in the bar.

did I forget to do something?

sorry in advance if the question has been asked, I have not found an answer

Regards,

Are you logged in using super admin user(i.e user id = 1)?

Here are some advice to solve the issue:

Recheck visiting component page if the components are enabled.
Please check Drupal permission.
Clear Drupal and CiviCRM cache.
Check Navigation links for Grants, Case etc by navigating to Administer >> Customize Data and Screens >> Navigation menu
Do menu rebuild /civicrm/menu/rebuild?reset=1

HTH

Pradeep


Can't complete install CiviCRM in Drupal 7 Trying to complete Step 4 "Run the Installer" where I go to the index.php page.
Here is my page, I get no install screen -- LINK REMOVED --

Any help is greatly appreciated.

Firstly, you shouldn't post a link to an install screen directly. Please edit your post to remove the link.

Secondly, I saw the install page just fine. It has fields for your civicrm and drupal database settings. Do you mean that filling out this information and then clicking "install civicrm" took you to a blank screen?

If you can't see the screen with the fields that need to be filled in I would recommend clearing your browser's cache.

John


Can't pay for Civi Event using Stripe I am trying to configure CiviEvent, but have a problem and don't know where to look.

I have two test sites, as far as I can see both configured the same.  CiviCRM 5.29.1, Stripe 6.5.1. Simple test Event set up.
On One site I can configure Events that work OK if not paid for or paid for using credit card with Stripe (with a test card only so far).  On the other it works if not paid for, but Stripe fails.
When failing it flashes up the 'Wait while Pre-authorising' message, but then returns to the registration page asking to have the card number put in again.
When failing the Stripe log shows an Authorised but Uncaptured payment.
There are no errors in the Drupal log.

Can anyone suggest anywhere to look that might help find this problem?
Thanks.

It looks like this is a side-effect of a custom Module we have installed for something else (still related to Events).  Consider this question closed.


Path problem in civicrm under wordpress Using .htaccess to put Wordpress in its own directory.  Problem is that civicrm was installed using the subdirectory after the domain name.  I try to update the path and wordpress logs out.  Anything I try to do with Civicrm logs me out of Wordpress.  I can't seem to get around this problem.  If I edit my settings file, civicrm will not work.

To the best of my knowledge, CiviCRM does not work if WordPress is installed in its own directory rather than the default location.  I have not tested this recently, but

I know it did not work in the initial versions of CiviCRM for WordPress,
I haven't heard about any change to this, and
I haven't had any reason to have WordPress in its own directory.

Notes in CRM-16421 also indicate that it's still an issue as of 4.6.

My advice is to get WordPress back out of its own directory and try again.  It may not be your preference, but it's what works.


Set Billing Address to be Not Required in Contribution Page Authorize.net does not require a billing address. How can I configure my CiviCRM to also not require that on a Contribution page?

I am surprised that Authorize.net does not require a billing address!  I don't recall ever seeing that.

With that said, I would recommend you still require billing addresses.  Right now the volume of fraudulent credit card transactions on non-profit sites seems to be skyrocketing and anything you can do to protect yourself would be prudent. The last thing you want is to have Authorize turn off your account due to fraud and you won't get any contributions then!


Custom Field Groups with File fields cannot be edited as a Tab I have a site with several custom field sets that use the "Tab" style for displaying information about a contact. Included in one field set is a "File" field that is used to store a profile image for the contact.

After upgrading to 4.7.0, attempting to view this tab for a contact with a profile image results in an error message that says the value (the filename of the image) is not an Integer. For contacts that don't have an image, the tab is shown, but the file cannot be changed. The edit popover closes when I click "Save" but the file is not updated.

I replicated this issue using the CiviCRM demo site. The steps to reproduce are:

Go to Administer > Custom Data and Screens > Custom Fields in CiviCRM
Create a new set of Custom Fields or edit an existing one to use the style "Tab" and apply to Contacts (I used "Individual")
Place as many fields as you want in the Custom Field Set, including at least one File field
Find a Contact
Open the Tab of the Custom Field Set you created
Click the "Edit ..." button to change the values
Make changes to any (or several) field and click "Save"
You will be taken back to the Contact but your changes will not appear

Update Feb. 8 -
I applied the diff from CRM-17949 and while it does allow changing other fields in a Tab, images still cannot be changed. Also, the error message on existing images still appears. I attempted to replicate this on the demo site, which is currently running CiviCRM 4.7.2, but it appears to have file system permission issues that prevent uploading files.

Update Feb. 10 -
Here is how to reproduce this issues in 4.7.2:

Follow steps 1 through 6 in the previous numbered list
Upload an file (I used an image) into the file field and click "Save"
You will be taken back to the contact but the file will not be saved
Return to the Custom Fields, and click "more" > "Settings"
Change the Display Type to Inline
Return to the contact and scroll down to the group. Click "Edit"
Choose a file for the file field, and click "Save"
The image will be shown in the group
Return to Custom Fields again, and change the Display Type back to Tab
Return to the same contact and click on the tab for your custom group
You will be shown a popover message "One of parameters (value: filename.jpg) is not of the type Integer" and the tab body will display "Sorry but we are not able to provide this at the moment."

A work around is to create the record without the upload and then edit. The upload works fine after that.

4.7.13 and Drupal


Can I set permissions to see one type of contribution, but not another? We have a number of staff who should have access to see event payment information, but who should not see donation information.  Is there a way to set permissions via ACL or otherwise based on Financial Type of the contribution?

Civi 4.6.6 -- soon to be 4.7; Drupal 7.41

A few years after the question was asked ... the answer is yes!

Financial ACL's were added a while back but the docs have not been updated yet.

Go to Administer > CiviContribute > CiviContribute Component Settings, and tick Enable Access Control by Financial Type.
Go to your CMS permissions to grant access to each financial type by role.

See this blog post for details.


Importing Memberships and Contributions but can't seem to link the two together I'm using the latest CiviCRM Wordpress version and have imported thousands of contacts and their memberships.  The problem is when I attempt to import the associated contributions they seems to be no way to linked the contributions to their memberships.  Jon G has answered a similar question (below) but I'm not sure I can use his advise as I have already imported the memberships.  Any an all advise welcome.

Bulk Import of Membership Dues  - Jon G's Answer

It sounds like your process of importing memberships via CSV and contributions via CSV works - except that your contributions and memberships aren't linked.

If that's correct, I've resolved this when doing migrations as follows:

  Create a custom field for contributions called "external serial" or
  similar. Create a custom field for memberships also called "external
  serial". Add a serial number column to your CSV (if one doesn't
  already exist) before importing it as contributions/memberships. The
  only important part is that each row have a unique identifier. After
  import, you can use the shared identifier to create a new CSV with
  just two columns - membership_id and contribution_id (as CiviCRM
  assigned them). I typically would do this via SQL. Something like
  this: SELECT cc.id AS contribution_id, cm.id AS membership_id FROM
  civicrm_contribution cc  JOIN civicrm_value_importfieldcc_1 cvi1 ON
  cc.id = cvi1.entity_id JOIN civicrm_value_importfieldcm_2 cvi2 ON
  cvi1.external_serial_1 = cvi2.external_serial_2 JOIN
  civicrm_membership cm ON cvi2.entity_id = cm.id Create membership
  payments using this new CSV to link the memberships/contributions. You
  can do that with the API CSV Import GUI extension or the command-line
  tool that ships with CiviCRM.

The key to my instructions are that there is some unique identifier in both your memberships and contributions.  If you don't have one, then you're correct, there's no way to link the two.

That said - you can use some trickery to create a unique identifier after the fact.  For instance, if your import data has a contact ID and a transaction date, and you know that one contact never signs up for two memberships in a day, you can create a unique ID based on the data you've already imported to the memberships.


Subscribe to mailing list through the API I am trying to subscribe a user to a mailing list through the REST API.
I understand that I need to create a Contact first, then subscribe it to a given mailing list. While I can create the contact, I can't subscribe it to the list using parameters:

entity: 'MailingEventSubscribe'
action: 'create'
email: [the-contact-email-here]
group_id: [the-mailing-list-group-id-here]

This will result in
{"is_error":1,"error_message":"Subscription failed"}

The CiviVRM version here is 4.2.0
I could't find documentation for the API on this specific version, so I'm playing the guessing game here :). I've been also told that the API requests can be chained somehow in order to do just 1 instead of 2, is there a documentation for this?

Can someone point me into the right direction? Thanks.

The mailing list is actually a group in CiviCRM. The functionality of a group is bit more than just mailing list, but fine if you only want to use it for that.

It means that all you have to do is add the contact to the relevant group using the GroupContact API AFAIK.


CiviCRM Webform membership Payments I have multiple contacts in a webform (a family). Each contact can have a membership type with an associated fee. I want each contact to be have their membership renewed and the fee associated with their contact record and membership. What's happening at the moment is that the sum of membership fees is being charged to the primary contact (the one submitting the form). All individual memberships are being correctly renewed but without the associated membership fee attached to the membership record. I have soft credit set to none.

I have been unable to see where I am going wrong.

I think Webform is behaving correctly. The memberships are being renewed and a single payment is being recorded - that accurately reflects what happened when the form was submitted (it was one payment by one person, not several).


Public CiviEvents Showing as Private Using CiviCRM 4.6.8 and Wordpress 4.3.2, all of my Event Info pages and Registration pages show as being private even though I've selected public and the Manage Events interface lists them as public. Regardless, visitors to the site are unable to access these pages.

I'm really not sure what I could be missing here. Any suggestions?

Have you checked that users have the right permission in the CMS?

'CiviEvent: view event info'


Can't add addresses when geocoding is enabled Steps to reproduce

On the CiviCRM 4.7 / Drupal 7 demo site (demo.civihosting.com):

Go to "Administer -> System Settings -> Mapping and Geocoding"
Set "Mapping Provider" and "Geocoding Provider" to "Google"
Go to "Create New -> Individual"
Set "First Name" and "Last Name" to "Test"
Open "Address"
Set "Country" to "Italy"
Click "Save"

Expected behavior

A new contact should be created, and I should see the summary page for it.

Actual behavior

I see an error page, reading:

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

Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /home/galleryr/www/demo/sites/all/modules/civicrm/Civi/Core/Transaction/Manager.php on line 107

Analysis

After reading the logs in ConfigAndLog, I found the problem had to do with the empty state/province field. I tracked it down to lines 1060 to 1068 ofCRM/Core/DAO.php:

1060     if (
1061       empty($searchValue) ||
1062       trim(strtolower($searchValue)) == 'null'
1063     ) {
1064       // adding this year since developers forget to check for an id
1065       // or for the 'null' (which is a bad DAO kludge)
1066       // and hence we get the first value in the db
1067       CRM_Core_Error::fatal();
1068     }

Simply deleting these lines seems to resolve the issue. From the comment about "we get the first value in the db", I expected the newly created contact to have an address with state/province id 1, but actually it worked as it should: I gave no state/province, and no state/province is what came out.

Hope that helps. Cheers!

Similar to the above seems to be fixed recently. Can you please try https://github.com/civicrm/civicrm-core/pull/10192 and check if that fixes for you?

Note: The PR is merged in 4.7.20, so it should work without error on this version.


Blank Admin Screen WordPress Install When I try to install the WordPress plugin 4.4.15LTS onto our site it says the install is successful but when you navigate to the admin screen it comes up blank. Any help is greatly appreciated. Thank you.

The following errors are presented in developer tools:

Uncaught TypeError: CRM.url is not a function                  admin.php:56

Uncaught TypeError: Cannot read property 'fn' of undefined     load-scripts.php1

I've have checked and tried and following:

Reinstalled CiviCRM

Uninstalled/Disabled All Plugins

Confirmed Read/Write/Execute Permissions 0777

Configured PHP RAM to 128MB

Created New MySQL Database

Server Settings

WordPress 4.2.2

PHP 5.6

MySQL 5.6.25

This WordPress site was created using a Microsoft Azure webapp. I imagine that it was a compatibility issue. After creating a designated IIS server with MySql the problem resolved itself.


Searchkit Buttons not working Using beta version of SearchKit. Buttons for Add, Compose Search and AND,OR,Not options are not working/unresponsive.

Problem a result of using Shoreditch as Civi theme.     Same problem exhibited when using API Explorer UI.
SearchKit and API Explorer both use bootstrap theme which seems to have conflict with Shoreditch.
Only solution found was to uninstall Shoreditch.    (Disabling shoreditch was not sufficient)


civiReport with financial type and line item financial types Is there a report that displays both the overarching financial type and the individual line item financial types for contributions?

civiCRM Contribution and paid event pages require a financial type to be set. We often use complex pricing options with price sets with multiple financial types.

I am looking for a report or search that shows both the overarching financial type (from the page) and the individual line items (from the price set). Find Contributions and Contribution Detail report only display the overarching financial type. Bookkeeping transaction report displays only the line item.

Does a report/search exist that displays both?

There is no such report provided by CiviCRM by default. But there is an extension called 'Extended Report' which provides report with additional columns and filters.

The report 'Extended Report - Contributions with Price Set data' or 'Extended Report - Price Set Line Items' from the extension may be the one you looking for.

Cheers

Pradeep


Accessing Event details not possible anymore (Frontend) Joomla 3.8.2 and CiviCRM 4.7.27

I got recently some user reply's that the event details con not be accessed anymore, thus no event regi, stration is possible.The event list is visible in the frontend, but clicking the "Event Name" or "read more" results in:

CiviCRM-001
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
API permission check failed for Event/get call; insufficient permission: require access CiviCRM and access CiviEvent and view event info

This error may be related to an update, however I can not determine which one as the feedback was not immediate. I checked the access rights for civiEvent listing and registration, they are still set to public, nothing changed there.

May be a bug... Anybody who has a suggestion where to start?

Currently I cant find the error report ... sorry

Thanks for your input

Joomla shows in debug mode:
Call stack

Function    Location

1   ()  JROOT/libraries/legacy/error/error.php:200
2   JError::raise()     JROOT/libraries/legacy/error/error.php:277
3   JError::raiseError()    JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php:468
4   CRM_Core_Error::handleUnhandledException()  JROOT/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:55
5   CRM_Core_Invoke::invoke()   JROOT/components/com_civicrm/civicrm.php:96
6   civicrm_invoke()    JROOT/components/com_civicrm/civicrm.php:11
7   require_once()  JROOT/libraries/src/Component/ComponentHelper.php:381
8   Joomla\CMS\Component\ComponentHelper::executeComponent()    JROOT/libraries/src/Component/ComponentHelper.php:356
9   Joomla\CMS\Component\ComponentHelper::renderComponent()     JROOT/libraries/src/Application/SiteApplication.php:194
10  Joomla\CMS\Application\SiteApplication->dispatch()  JROOT/libraries/src/Application/SiteApplication.php:233
11  Joomla\CMS\Application\SiteApplication->doExecute()     JROOT/libraries/src/Application/CMSApplication.php:267
12  Joomla\CMS\Application\CMSApplication->execute()    JROOT/index.php:49

In  CiviCRM Configuration, Access rights: CiviCRM: access CiviCRM  was set to "inherited" needet to be "allowed". Now it works!


Drupal 8/9 Compilation Install Error I'm getting thiis error, when I try to install civicrm on Drupal 8 and 9
The following packages have new compilation tasks:

civicrm/composer-compile-lib has 1 task
civicrm/civicrm-core has 1 task

Allow these packages to compile? ([y]es, [a]lways, [n]o, [l]ist, [h]elp) y
Compiling additional files (For full details, use verbose "-v" mode.)
Compile: Generate CCL wrapper functions
Compile: Greenwich CSS (dist/bootstrap3.css)

@php -r 'require_once '''/home/bvivaccinate/public_html/vendor/autoload.php'''; Civi\CompilePlugin\TaskTransfer::import(); \CCL::copy('''../../bower_components/select2/select2-bootstrap.css''', '''extern/select2/select2-bootstrap.scss''');'
@php -r 'require_once '''/home/bvivaccinate/public_html/vendor/autoload.php'''; Civi\CompilePlugin\TaskTransfer::import(); \CCL\Tasks::scss($GLOBALS["COMPOSER_COMPILE_TASK"]);'
Script @php -r 'require_once '''/home/bvivaccinate/public_html/vendor/autoload.php'''; Civi\CompilePlugin\TaskTransfer::import(); \CCL\Tasks::scss($GLOBALS["COMPOSER_COMPILE_TASK"]);' handling the shell-runner event returned with error code 255
Subcommand @composer compile  returned with error code 255

Installation failed, reverting ./composer.json and ./composer.lock to their original content.
[RuntimeException]
Subcommand @composer compile  returned with error code 255
These are the commands I ran to install it for drupal 9
php composer.phar create-project drupal/recommended-project
php composer.phar require pear/validate_finance_creditcard:dev-master
php composer.phar config extra.enable-patching true
php composer.phar require civicrm/civicrm-asset-plugin:'~1.1'
php composer.phar require    civicrm/civicrm-{core,packages,drupal-8}:'~5.37.2'
Composer version 2.0.13
PHP 7.3.28
Can someone please assist

In the meantime until this is fixed you can install this patch: https://patch-diff.githubusercontent.com/raw/civicrm/composer-compile-lib/pull/1.patch
Then run composer compile.
May also need to then run composer civicrm:publish.


Is it possible to view multiple payments on a registration as separate Contributions? I need to export data regularly for the bookkeeping end of our operations, and when there are participants have have multiple payments on their event registration, their payments show up as follows (in both the Contribution list and in the exported file):

Total Amount = the price of their selection regardless of how much they actually paid

Fees = $0, regardless of if there were fees associated with their transaction

Net Amount = the price of their selection

What I would like is to have the individual transactions associated with their registration show up as individual contributions. As it is, it is very confusing.

Does this need to be a feature request? Is it a bug? Is there a work around for this?

Here are some screenshots of a specific case:

This is the detail of an event registration, with two payments totaling $725.

This, of course, is the payment details.

Here is how this shows up in the list of contributions. It may (or may not) make sense from an accounting perspective to list $785 as the total amount put into an Accounts Payable, but I don't want that level of accounting in my civi installation. I just want to be able to see in the contribution list that this person made two payments, on these dates, in these amounts, not that they promised to make this one payment when they first signed up.

I can understand what you are trying to do - yes this is the way Civi works

For Accountant Point of View
I guess they will be more interested in the CSV from batch export which will make more sense to them

where you can see Credit account type clearly says

INC (Invoice)        - 1000
AR  (Amount received)- 10 + 990 => 1000

with different nominal codes

If you are not happy with this output then you need to create an extension for each changes - I guess this helps


Contribution Report Section Headers no longer list subtotal amounts Previously, if you used a section header on a contribution detail report, the section header would show the number of contributions and the subtotal of that section in parentheses. So for example, if you were using Financial Type as the section header, it would show "Financial Type Name (# of gifts, subtotal of gifts). Now it only lists the number if gifts and the NOT the subtotal. is this expected behavior? Anyone know why the change?

Using Civi5.3.1 under WordPress.

I would recommend that you test one wpmaster or dmaster to see if it is still an issue and if it is not then upgrade your site to the latest release.


How do I add a currently unsupported field to Views? For example, the email_greeting_display field of the civicrm_contact table is not available as a field in Views.  How do I add that to a View?

See also How to include a token in a view?

You will need to add the field manually to:

drupal/modules/views/components/civicrm.core.inc

and then submit a PR to civicrm-drupal repository, so the fix gets merged into the main code base.

In D8, the situation is a lot better, as torrance has automated the process and the fields and their definition get picked up automatically. So a lot cleaner and easier on everyone.

But for now, the above is your best bet and will help views intergration for D7 and prior


Manage the image gallery in mosaico As you upload images into Mosaico mailings they get stored in a Mosaico "Gallery".

We're now beginning to find duplicate images in the gallery as different users have uploaded the same image at different times (or people using Mosaico hadn't spotted the gallery function and have re-used the same image several times).

Does anyone know which directory the gallery is saved in? Is there a way to give access to local users to allow them to manage the images there and remove the duplicates?

Cheers!

The answer is to the first of your two questions is: the images are stored in a subdirectory of the CiviCRM "Image Directory", which by default looks like [civicrm.files]/persist/contribute/.

The specific subdirectory it stores it in is: images/upload

You can see the code on line 153-ish of this file:
https://github.com/veda-consulting/uk.co.vedaconsulting.mosaico/blob/2.x/CRM/Mosaico/Utils.php

The answer to the second of your two questions is: yes. If you create a new traditional mailing, you'll see a button in the wysiwyg window that lets you add/remove images. That tool will manage the same directory that Mosaico uses.

The answer to a question you didn't ask "how can a new mosaico mailing make use of existing images" is: along the top bar in the mosaico interface there's the same button (i.e. a picture of a mountain) which let's you reuse existing images in your "gallery". So you could also manually put a bunch of images into the images/upload directory for your civimailers to re-use.


What tables are used for civicrm reports? I need to know what tables and fields are used for the CiviCRM reports, I've been dealing for several weeks trying to see why an updated site from CiviCRM 4.2 to 4.7.16 on Joomla is not showing any reports, I need to see if several tables changed or fields and where to look into why they are not showing up as they don't show any errors, they only show no result at all. Thank you.

4.2->4.7 is a huge upgrade. Swathes of tables - including Activities and Settings - have changed. If you have any custom reports or extensions these definitely will need to be upgraded without a doubt.

This could be caused by a number of things.

Is this all reports, or just some? What are the names of the failing reports?
Please could you provide a screenshot?
Have you looked in the CiviCRM error logs and the Joomla! logs?


Newbie question: Will "Pending" change to "Current" when Status Override reaches the selected date? I have a member who has paid for a new membership and asked it to start when his current membership expires. At the moment, both read as "Current." If I use "Status Override" until a select date and change his status to pending, will that "pending" automatically change to "current" on that selected date?
Tony

Ideally you should set up your membership status rules and live by them, and not use "status override" :-) Documentation on the membership status rules can be found here: https://docs.civicrm.org/user/en/latest/membership/defining-memberships/#membership-status-rules


Can webform-civicrm cause an Activity of type Email to actually send the email from CiviCRM Scenario is users who are not accessing civi but are doing it all via Views and Webforms.

I created a webform

contact 1 is logged in user
contact 2 is 'target'
Activity is of type Email

Outcome I want is that civi actually sends the email.

My testing shows this does not happen. If i 'assign' the ticket to someone else (or eg the Sender) then a 'you have been assigned' does get sent.

Is this meant to not be possible? Or is it a missing feature?

Note: seems like the reverse of this where coleman explains that 'not' sending the email is possible.

It's not really the opposite of the answer I gave in the other question. The webform-civicrm module does not treat the "send email" activity type as special. Just like the "print pdf" activity type, it dutifully creates the activity, but does not do any extra civi-workflow stuff with it. To actually send an email, I suggest doing this via the webform.


What's the optimal method to archive a lot of mailings? I look after a Civi install which has hundreds of completed mailings. I'd like to tidy things up a bit by archiving a lot of the older mailings, but there's no way that I can see to achieve this using the user interface.

Would it be OK simply to set the is_archived field in the civicrm_mailing table to '1'? I know for a lot of stuff tinkering directly with the database isn't a good idea, but in this case?

Ideally the mailing search results pages would work in the same way as contact search results pages and have checkboxes and an action menu, but that's not evident in the version currently running here (4.7.29 I think).

We have done some recent work on an Extension through which you can nominate a 'before' date and it then cleans out the Mailings along with the abundance of Activities, Activity Contacts etc.

So this is not 'Archiving' as per the OP, this is deletion and does not answer your question but am hoping it proves a useful answer for others who might stumble on this. We will be writing up a blog shortly. On the big databases we are testing this on it is clearing out millions of rows of data and speeding up other queries particularly related to Actvities.

Extension is at https://github.com/jitendrapurohit/nz.co.fuzion.deleteoldbulkmailings

NOTE: Usual warnings apply. Turn off logging before running this.


Is there a direct way to clean the Civi Cache? Cleaning the civi cache updates the Smart Groups immediately (instead of waiting 5 minutes).

Is there a way to clean the civi cache directly (instead of Menu>Administer>SystemSettings>Cleanupcache&updatepaths>Cleanup Caches)

(I am not a programmer, but I may be able to include it in a small php program, if I am told how to do it).

You will find different ways of clearing cache (as Jon mentions) documented HERE, but I agree with Tony that perhaps the UI would be easier - maybe it's just a question of adding a top menu item on the navigation menu or a button that will trigger /civicrm/clearcache?

Hope this helps!
Tamar


What's the best way to update ambiguous relationship types? On some older sites we are now getting warnings relating to ambiguities in relationship set ups.

What is the best way to change the relationship settings without affecting existing relationships?

The relationship in the image is specified as the case manager in some case types, and I think that this is causing problems with the cases. (Clients are showing as their own case manager after the role has been assigned). But I have editted relationship settings before and broken cases.

Is there a way to update settings for a relationship type that won't break existing relationship of that type, or any related cases?

D7.69 C20.2

Some general information is at https://docs.civicrm.org/user/en/latest/case-management/what-you-need-to-know/#system-status-warnings but in an established install like yours you might need to poke around a bit and it will be specific to that install.

First, make a backup and do any fixing on a copy first just in case.

Then for your install it sounds like this should work:

In the database do UPDATE civicrm_relationship_type SET name_a_b = 'csw1a' WHERE id=78;. The string is arbitrary just needs to be different from the other one.

Then it depends whether you're using xml files or database storage.

If xml files, make sure the case type has csw1 in the CaseRoles section for the role (without the "a"). It's probably ok already.

If database storage, edit the case type in the admin screens and you might see a blank row in the roles section. If so then delete that row and re-add it again, checking the case manager box if that was checked before. You want the "Case support worker is" choice.

Then, if you have any customizations or extensions that reference it you may need to update those.

If you have any relationships of that type that actually are backwards, i.e. in civicrm_relationship the contact_id_a and contact_id_b are reversed, then you'll need to reverse those.

For anyone else seeing these warnings note that there are multiple variations and the above is specific to what was reported in the question. It's not the right solution for every situation. Also for astute readers you'll note that what you put in the xml is backwards from what you choose on the admin screens, and this is also true of what gets stored for the case type xml in the database even when using the admin screens.


Hook to stop a contact's email from being deleted We have a new requirement to stop an admin from deleting a contact's email if that email is found in one of our other systems.  I am trying to do this through a validateForm hook.  I can figure out the logic of finding the email in another system.  But how can I check:
1. That the form is trying to delete or update an email (vs adding an email)?
2. Identify which email is being deleted?

I can't tell where to find the action being taken, nor which email is being deleted.  Also, if I set an error (as a test), the error shows correctly, but the deleted email is gone from the view of the form (I would like for it to stay there).

Is there another hook I should be using for this?

My other option would be to use the buildForm or similar hook to make that field readonly prior to the form showing up.  But I feel it's safer to block a delete.

Would love some pointers on either method.  Thanks!

You can use ValidateForm to check all form level action. Also you can use pre hook to check if email is being deleted or updated and then throw fatal error or exception.

HTH

Pradeep


Contribution - Wrong VAT amount showing We collect a number of monthly direct debit payments of £30 using SmartDebit. The breakdown is £25 fee + £5 VAT.

Although the SmartDebit report shows that we collected £30, in civi (under contributions) the total amount is showing as £36 (£30 + £6 VAT).

Is there a way of changing this so that the correct amounts appear. I am using civi 5.10.3 and SmartDebit version 1.30

user6930, Welcome to SE world.

Unfortunately this is a know issue in CiviCRM when subsequent recurring payment is recorded in CiviCRM which has tax. It would be good if you add some resource so that it gets fixed in core.

Alternate method is to turn off sales tax or do a contribution(batch) update to update the amount from $36 to 30

HTH

Pradeep


Is 4.7.x end-of-life? Why does my site say that 4.7 has reached the end-of-life? The CiviCRM Status Screen is reporting for any version that is 4.7.x that it is End of Life.

What does this mean?   Is there something wrong with version 4.7?  Do I need to panic?

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

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

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

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

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


How do you print a single envelope for a contact? How does one print off a single envelope for a contact?

Create a new envelope PDF format that corresponds to your printer's settings at Administer CiviCRM » Communications » Print Page (PDF) Formats
Create a new mailing template from Mailings menu » Message Templates.  Fill in the template with the appropriate tokens you'd like - and also a return address if applicable.  Select the envelope PDF Format that you just created.
When viewing a contact, press the "Actions" button below their name and select "New PDF Letter", and select the envelope template and print.

This video tutorial covers a similar workflow, but for sending envelopes to a larger group of folks: https://www.youtube.com/watch?v=i00269Y7pB4


CSS shows at top of mosaico emails Any ideas why I'm seeing a big block of CSS at top of the HTML preview, and email test of mailing from Mosaico?  Everything is updated to latest versions (Civi, Flexmailer and Mosico)  I've tried completely removing and reinstalling and the issue is still there.  Also verified happens from multiple browsers and computers.

This does only happen with the template versafix-1.

That's your mosaico css being displayed as content instead of interpreted as css, - i.e. it's probably not inside a <style> tag.

The word "test" at the top suggests you might have some kind of test code mangling your output, or else that someone was hacking around with your template.


CiviCRM Converting HTML tag to Entity we're having an issue with newsletters being sent out with broken images due to the opening and closing tags being converted to HTML entities.

e.g.
<img src="foo.jpg" /> is sent out as: &lt; img src="foo.jpg" /&gt;

We don't have control over the CiviCRM install however it's running on Drupal 7.

I'm wondering if this is a simple fix I could instruct a client on doing themselves or if it will require more work.

Any insights would be greatly appreciated, thanks!

I'm assuming you're using the default mailing Ux, not mosaico

The default editor is wysiwyg, if you want to put html tags, click on the view source icon, and paste the html code you want.

You can switch back to wysiwyg to see the result.

As for the images, be aware that quite a few recipients aren't going to display the image (for privacy reasons), so you should consider putting an alt text and dimensions (width and height) on your img tag


Where can I find information about CiviCRM? Hello my name is Joel and I have a series of questions about CiviCRM.

Who can implement CiviCRM? Is the developer, the supplier
(local?) or regional partner? Do you have a technical service?
Which companies have implemented CiviCRM?
Advantages and disadvantages of CiviCRM.
Your product in what type of sector? In the specific business / industrial sector (vertical) or is it a multisector product?

I hope an answer soon, that is well elaborated since I am interested in this product. Thank you!

Thanks for your interest in CiviCRM.

As Peter says, a good place to start is to read the documentation.  I would also suggest that you look at the CiviCRM website if you haven't already done so.

To answer your specific questions:

Anyone can implement a CiviCRM system.  The software is open source and feely available to download.  However, it does require a reasonable degree of technical knowledge to do so.  For this reason many organisations choose a partner to do this for them.  You will see that there are partners around the world.  But, if you want to do it yourself read the Installation guide.
CiviCRM is used by more than 10,800 organisations including the Wikimedia Foundation, Amnesty International and the UK Green Party. Take a look at the many case studies to see some examples.
I would suggest that you try a web search for comparisons with other CRM systems.  Whether it is suitable for your organisation depends on how you would use it.  It is difficult to comment on this without more detail about the needs of your organisation.
CiviCRM is specifically designed for the needs of non-profit organisations.  But there is nothing to stop it being used in other sectors and much of the core functionality would be appropriate for any organisation that is looking to manage contacts.

I hope that helps, but please post again if you have more questions.


Webform/civicrm contribution page eror Using a webfrom civi contribution page and when submitting I get an error that a recurring interval must be selected, even though i have it set to user selects.

The Error message does not say none is selected. It says the option selected is not one of those options.