What is the best way forward to conduct surveys on an iPad?

If the iPads are connected to the internet, then you can create a profile form (or Webform if your site uses Drupal) and they can submit it directly.

I'm not aware of an offline app but others may know of one.


This alternate theme for wordpress is available: https://lab.civicrm.org/extensions/haystacktheme

You can also add your own css by writing a little extension that adds your own css file: https://docs.civicrm.org/dev/en/latest/framework/resources/#css-stylesheets


Consider installing CiviCRM 5.13.1 and enabling multiple MySQL locks. See https://github.com/civicrm/civicrm-core/pull/13854 for details.


API usage: How to change the 'participant_note' field in the Participant entry for an event

i figured it out:

  entity=Participant
  action=create
  json={
       "sequential":1,
       "id":"", THIS IS PARTICIPANT ID
       "participant_note":""
       }


Why does CiviCRM keep logging me out of the website admin?

Check that the URL configured for your WordPress site matches the URL in your CiviCRM civicrm.settings.php

If these have different URLs, you will appear to be logged out when you move "between sites". This sounds like it could match what you're describing.

The URLs must match for all of protocol (http vs HTTPS), domain (example.org vs example.com) and hostname (www.example.com vs example.com).


You may be right that this is a bug in 4.7.16. Fortunately it has been solved in 4.7.17.

This release includes a redesigned tag management screen with numerous improvements.

Update: 4.7.17 has been released.


I've just had a similar problem with a Joomla installation. It was a problem with the civicrm_uf_match table that (in Joomla) links CMS users to Civi contacts. Somehow the CMS user ID in that table was not the current user ID. Civi created a new contact because it could not match the Civi contact back to the user. I don't know how that matching happens in WordPress but it might be worth a look.

To solve in Joomla, I manually changed the CMS ID in the records in the uf_match table to the correct, current CMS ID.


Upgrading a server that's hosting CiviCRM to get to PHP 7

This looks like a collection of issues, not just a single one, even if they all originated from the OS upgrade.

The CiviCRM status page (assuming it loads) does a pretty good job of checking the usual suspects. I don't think your db would be corrupted.
The CiviSTMP error sounds like the crypto issue. I'd guess that your mailouts are being triggered by a cron running a different php (different version, or different packages).
CiviMail drafts issue + civi running slowly, but only sometimes, both sound like mysql issues. My guess is that your upgrade involved some other changes in the network or mysql settings. For erratic issues, I would definitely finger your provider, not CiviCRM.
Unknown db error - you'll need to look at the detailed error log (sure, install my log viewer!).


Inconsistencies in the Contribution Detail report

You could try Extended Reports extension ;-)


Should participant custom fields be available under events on webform

Thank you for asking. This should work - and I just double checked and it is working on one of our live projects:

Webform CiviCRM config:

And the CiviCRM config [On-line and Custom Fields are on the Participants entity].

Is it perhaps possible that you've (accidentally) restricted these Custom fields to certain Events only?


Does the CiviCRM API comply with the OpenAPI Specification?

No the CiviCRM api does not comply with the open api specification. Is there any reason why you are asking this?


com_civicrm/civicrm/CRM/Core/BAO/SchemaHandler.php on line 730

Have you tried clearing cache? And clearing Expired Cache? I had the same error, cleared cache/expired cache and the message went away.
Also have you done the indices fix?

I found this to be useful
https://issues.civicrm.org/jira/browse/CRM-21203


Why can I no longer Merge Contact records in 5.7.3?

So I looked at the civicrm email records of the two contacts that produce such an error and they look fine.

Alan figured out that this is a bug: during the merge process when data is being gathered about both contacts, code is verifying that the value is valid, but it does so after converting it to an option value (i.e. email is "2").

A quick workaround for those struggling with the same issue - remove Preferred Method Email from Contacts. For this client this field is no longer used so we could just:

update civicrm_contact set preferred_communication_method=NULL where preferred_communication_method=2;

Merges are working again - phew!


How do I determine how many active members there were on a date in the past?

I think you can do this via Find Members since to be an Active Member on that date you need

a start date before that date AND
an end date after that date


How to sort a varchar numerically using the api

I see if we try to modify the sort col with any sql defined functions, it gets returned with the Error Message. For Eg - ['sort' => 'CAST(value AS decimal) DESC'] returns

  Unknown field specified for sort. Cannot order by 'CAST(value AS decimal) DESC'.

Maybe, there should be some modification in CRM_Utils_Rule::mysqlOrderBy() to either handle such cases.

Or we can simply use get instead of getsingle and then order the returned result values using array functions.


If you are using Drupal, you could set up a webform that allows people to change their membership status. This would not require any custom code, the functionality is all there in the Webform-CiviCRM module. You'd just want to carefully select which membership statuses you want to allow people to give themselves by editing that field and deselecting inappropriate options after adding it to the form.


Why is my Menu and dashboards not working on clean installation on Wordpress?

I had a similar situation on a new installation of CiviCRM on WordPress, but the hostname had changed from when it was first installed, and https had been enforced.

Updating wp-content/uploads/civicrm/civicrm.settings.php and changing all relevant URL's to the new https URL then reloading the page was enough to get the menus to show.


How can I get webforms to show household and household members?

Prefilling a webform value depends on other values already being there. If the individual is not selected at the time the webform loads, then there's no way for it to populate the household. So you are correct, selecting a different contact 1 on the form will not cause contact 2 to be changed.

One workaround would be to create 2 webforms - the fist one being an incredibly simple form that allows you to autocomplete the individual's name and a submit button that redirects you to form 2 with cid in the url. Not perfect but it would work.


Community centre crm: courses, attendance, reporting

There are a number of approaches that could be taken for some of your questions, and without doing a detail 'spec' it would be hard to give a definitive answer. Also some CiviCRM concepts and terminology may not quite fit with your descriptions.

In general, having built civicrm implementations for a number of clients in the educational sphere with needs for both 'attendance' and 'achievements' I would expect CiviCRM to be able to cover the vast majority of your requirements without needing significant additional development work.

In saying the above there is a presumption on my part that the CMS is going to be Drupal, as the combination of CiviCRM and Drupal Views and Webforms give you tools that CiviCRM by itself struggles to deliver.

Your concept of 'group' may not necessarily match with Civi Groups, in that you may be able to do what you want without setting up a group for each situation you may be thinking of. But yes, setting up Groups is easy, as is adding folk to groups, or making the groups 'smart' so folk get added based on some characteristic (saved search)

Sessions could either be mapped to Events or may in some cases make sense to use just Activities. Tracking the number of sessions can be done using custom fields on Participant records or on Activities

Notes, and user details are all out of the box.

Key Objectives, may be something to re-purpose Campaigns for.


Even as CiviCRM is a key tool for many roles at an organization, it's often an afterthought in choosing the best person for the job.  Selecting someone who knows CiviCRM will certainly help, but it's also good to hire someone with the capacity to learn the way your organization applies CiviCRM to its work.

Stuart Gaston did a fabulous session at the 2014 CiviCRM User Summit called Hiring and Training for Success.  He highlighted ways to think about individuals' patterns when they encounter technical problems and interview questions (like "What is your favorite Excel trick?") that help in highlighting those.  Even just reading the slides is a good place to start thinking.

It's good to list CiviCRM as an element of the job and a bit of experience that would be valued, but you probably don't need to make CiviCRM experience an absolute requirement.

However, you can maximize your chances at finding experienced CiviCRM users by posting on CiviCareers, the CiviCRM job board.  Posting is free, and you'll maximize the chances of finding someone who can quickly understand your CRM and maybe even share tips from past work.

(Full disclosure: my coworkers and I started CiviCareers after a series of conversations at DC CiviCRM meetups where people laid off from a local organization were looking for jobs where they could apply their CiviCRM experience.  It isn't a commercial venture--it's free and always will be--but it does mention that it's hosted by AGH Strategies.)


How can I change activity duration from minutes to hours?

Try the following modules to collect activity data and convert hours to minutes on the front end.

https://www.drupal.org/project/webform_civicrm
https://www.drupal.org/project/webform_calculator


Insert a table with one row and one column and choose the desired width of the column when creating the table. Paste your plain text into the table - not an image with text, which will not appear correctly in some e-mail programs.


Confusion about theming and version - Shoreditch?

The system requirements are listed at https://github.com/civicrm/org.civicrm.shoreditch#requirements. It's an extension you would need to install.


Where should I place PayPal auto-return parameters?

The auto-return can be setup in your Paypal account.

Login and click on your Profile (upper right), click on Profile and Settings.
In the box on the left, click My Selling Tools.
Under the Selling Online section, update your Website Preferences.
On that page, make sure to turn on Auto Return and then set your return URL per the instructions.


Why I am not able to select more than 500 records (CiviCRM 4.6.10)?

I checked and see the same limit when you select manually. So it seems not a PHP value. If you use the "All 1766 records" button you can exceed this limit.


Is there a simple cron command that I can enter on cPanel to trigger scheduled jobs?

The reason this is a difficult question to answer is that it depends so much on your hosting provider.  If you have a hosting provider, I would ask them for assistance.  If not, you may want to find someone in https://chat.civicrm.org who can assist.  There are also third-party "webcron" services available.


Smart Group searching event participants not saving

You can try to use Search Builder to make your Smart Group as a work around for this problem


Selecting location type or multiple email/phone fields in Reports

Old question but for a CiviCRM only solution, I found that Extended Report has a Report Extended Report - Flexible contact report that does an aggregation of all the phone numbers.
As of version 5.8, you have to use the following PR to make it work : https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport/pull/461
To use this method :

install Extended Report and patch with the PR
in Reports -> All Reports, create a New Report and choose Extended Report - Flexible contact report
choose the column Phone

You should have something like that in the phone column for each contact :


Financial types in contribution is always default and not taken from contribution page

If you are using Price Sets on the contribution pages - i.e. you selected Click here if you want to configure the Regular Fees below as part of a Price Set, with the added flexibility and complexity that entails - then it may be that the financial type is being taken from the price set rather than from the contribution page settings.

Also note the distinction between the financial type of the contribution and the financial type of line items - see discussion at Contribution Page Price Sets Not Recording Different Financial Types.

However in the similar question Why is a contribution given a financial type different from that allocated to the contribution page used?, price sets were not the issue and a solution was not recorded.


Webform created for case activity and multiple case types

Looks like this was a bug in the comparison logic. See if this fix works for you:
https://github.com/colemanw/webform_civicrm/pull/17


Best Practice for CiviEvent using Webform Integration?

I use Webform CiviCRM for many Event and Membership registrations - as the key advantage (unlike in CiviCRM itself) you can expose multiple profiles and store them all with relationship - capturing Primary + Spouse + Children all on one page.

Online payment: yes is possible - generally works for inline Payment Processors such as PayPal Pro and iATS Payments (credit card only at this point - on my ToDo list to get this working w/ ACHEFT via Webform CiviCRM). To get online payment to work - you must set up a Contribution Page even if it's just purely for the purpose of the Webform integration - enable a Payment Processor - Webform CiviCRM will use that info to grab/display the Payment Fields and to submit the payment for processing.

Event: location/date/map -> if you go with Webform Integration - do all that in your Webform - add a Markup Element - and off you go. Once you enable Event Registration in the Webform CiviCRM section you can decide which events and how you'd like to sign people up. How to handle the max participants; if and how to waitlist them - etc.

Don't forget to use Webform Layout - to help make things easy to CSS - and also don't hesitate to use conditionals to pop up e.g. #civicrm contacts fields (kids) you'd like to register.

To add waitlist functionality:

enable Participant Status - on waitlist in your webform -> you need
to visit: /civicrm/admin/participant_status?reset=1 and enable both
On waitlist as well as Pending from waitlist
you need to reconfigure your webform_civicrm (Registration Status)
and/or Participant Fee (perhaps a smaller fee or no fee) if you're at
the point where you want to start waitlisting people


Check Payment processor is not working for CIVIEVENT

If you need the payment through "Cheque" you don't need to enable payment processor -

All you need is to enable "is pay later" option in your event config page - Payment processor are used only when you do online payment using credit or debit cards.

So, disable your payment processor and select "is pay later" option and then give a try - that should work correctly

Refer: https://docs.civicrm.org/user/en/latest/events/creating-an-event/

I guess this helps !!!


Civicrm SagePay takes the primary address as billing address

apparently its something to do with the circle interactive sagepay payment plugin


Can I create a Smart Group programatically?

There's an example of creating a smart-group in v4.6's CRM_Contact_Form_Task::createHiddenGroup() which calls CRM_Contact_BAO_Group::createHiddenSmartGroup(). It should show the relevant fields/data-structures. There are a few details which would need to be adapted if used in another context:

In CRM_Contact_Form_Task::createHiddenGroup(), it just passes through some existing formValues. This data-structure is a big array defining the search parameters. You can inspect example records in civicrm_saved_search to see what this looks like. I believe this corresponds to advanced-search/CRM_Contact_BAO_Query, but you'd need to investigate.
In CRM_Contact_BAO_Group::createHiddenSmartGroup(), the title is hard-coded.
In CRM_Contact_BAO_Group::createHiddenSmartGroup(), the is_hidden field defaults to 1.


Conditional Statement in mailing causes parse error

I fixed this by adding (as @Andrei suggested) config.entities = false; to my config.js file in the ckeditor (/your/path/to/civicrm/civicrm/packages/ckeditor/config.js).

Just don't forget: If you are modifying config.js you should first have configured a Custom PHP Path under Administer > System Settings > Directories, and place your modified version in the custom path.


What broke the contribution thermometer blocks in the CiviCRM 4.7 upgrade? How to resolve the issue?

I experienced the exact same issue you described and used the fix that Marty Wright described in https://issues.civicrm.org/jira/browse/CRM-17965 to resolve on several sites.  Once the file change was made, I did have to clear my Drupal cache for the site to update.  Hope this helps you.


Why doesn't CiviCase API filter by case status when the client is specified?

While I can see this is an older issue I have the same problem in Drupal 7.41 and Civi 4.6.10. I found that this is no longer an issue in Drupal 7 Civi 4.7.27 (I just verified on the demo site!) If we aren't able to upgrade in the near future, I'll get around to looking at the log query (hopefully it doesn't come to that ;)


How can I add my extension API into civicrm API?

If you've added an api in the extension, it will be automatically seen in the API explorer, provided -

The extension is enabled.
The API is created as per https://docs.civicrm.org/dev/en/latest/extensions/civix/#generate-api
The api file need to be under /path/to/extension/api/v3/your_file.php which is auto-created if you've followed the steps in the above documentation


"Unknown path" when viewing a newly generated angular page

I believe you first need to generate a module, à la civix generate:angular-module. Have you already done that?


Is it possible to stop individual users from sending mail?

The 10 years old solution seems to be the best one, have you tried and would it be possible to remove the view all contacts permission to your users that should only use the reports?

Otherwise, it shouldn't be too complicated to alter the UI and remove the send email actions on a custom extension, but that would require some coding


This would be difficult to do in pure SQL in a generic way. I assume this is for some type of reporting system you are connecting to CiviCRM and any scripting is not an option.

For each field where it needs a lookup you'd have to do a join, something like:

SELECT c.id,
cf1.label AS field1_title,
ov1.label AS field1_label,
cf2.label AS field2_title,
ov2.label AS field2_label
FROM civicrm_contact c
LEFT JOIN civicrm_value_XXX cv1 ON cv1.entity_id = c.id
LEFT JOIN civicrm_custom_field cf1 ON cf1.name = 'the field you want #1'
LEFT JOIN civicrm_option_group og1 ON cf1.option_group_id = og1.id
LEFT JOIN civicrm_option_value ov1 ON (ov1.option_group_id = og1.id AND ov1.value = cv1._the_database_field_name)
LEFT JOIN civicrm_value_YYY cv2 ON cv2.entity_id = c.id
LEFT JOIN civicrm_custom_field cf2 ON cf2.name = 'the field you want #2'
LEFT JOIN civicrm_option_group og2 ON cf2.option_group_id = og2.id
LEFT JOIN civicrm_option_value ov2 ON (ov2.option_group_id = og2.id AND ov2.value = cv2._the_database_field_name)
... more joins for each field...

XXX depends on the actual table name where the custom field is stored,
_the_database_field_name is the fieldname as it appears in that table.

I use left joins because depending on how contacts get into the system sometimes they are missing stuff, but you'd still want the contact to be output.


Is it a bad idea to change a Participant's registered event after a payment has been made?

From a bookeeping perspective it wouldn't be too hard to implement. But as it's not a frequent use case it may have not been implemented during the refactoring for CiviAccounts a couple of years ago.

Were we implementing this as a core enhancement I would want to ensure that scheduled emails work properly through this change of events. I wouldn't want to send any ones after the change that pertain to the old event, and I think the user should perhaps be warned about missing any scheduled events as a result of the change. For example, a mail scheduled for 2 days after registration in Event A may not go out if the change to that event is made made more than 2 days after the registration.

I don't foresee any reporting problems, but there would need to be regression testing. Basically, there would be one additional cancelled registration in the original event, and one additional registration in the new event.


Is there a way to find out why an email address is 'on hold'?

Yes - you want the "Bounce Report".  Click on Reports menu » Mailing Reports, select Bounce Report.  In "Columns", check the "Bounce Reason" checkbox, and ideally "Bounce Type" as well.


Adjusting the Contact selection display (e.g. New Contribution)

You can, from the menu:

Administer > Customize Data and Screens > Search Preferences.

The setting to adjust is Autocomplete Contact Search.  There are a number of choices you could include.  This doesn't impact the field in question only though.  The biggest additional impact would be the Quick Search.  Note the help text:

  Selected fields will be displayed in back-office autocomplete dropdown
  search results (Quick Search, etc.). Contact Name is always included.

The next option down on Search Preferences (Contact Reference Options) may come into play for certain fields as well.  Its help text:

  Selected fields will be displayed in autocomplete dropdown search results for 'Contact Reference' custom fields. Contact Name is always included.


What low-cost third-party mailing platforms work well with CiviMail?

SparkPost is great, but the UI is a little lacking, but as far as sending is concerned, it works great. My company also just developed and extension for processing bounces from SparkPosts in Civi.

https://github.com/proexchange/com.pesc.sparkpost


How can I display an info only field in a webform

You could use webform conditional rules to display or hide a message based on the ban.

Add the "is banned" custom field to your webform
Update it from the webform tab to be type "hidden" (but not secure value)
Create a "Markup" field, and enter your warning message
Add a conditional rule to show/hide the markup based on the "is banned" value.


The safest bet is probably 5.5. 5.6 ought to work but hasn't been tested as thoroughly. As a core CiviCRM developer I currently use 5.5.9 in my test environment.

You should also look at which version is recommended for your CMS, often that is more of a limiting factor.


Conditions and Action disappeared from Civirules during upgrade

If there are release notes they will be on Gitlab and in the changelog in the extension, but that was a fairly recent improvement.
I have seen the problem you had, that is why the note is there. And AFAIK it applies for any version earlier than 2.2


Why are all bulk mailings delayed by 5 hours?

I would look at the scheduled_date on the mailings in your database:

SELECT name,scheduled_date FROM civicrm_mailing;

If the scheduled_date is off, then it might be that MySQL has a time mismatch - or that specific users in Joomla have a different timezone setting than the default (not sure if this is possible in Joomla, but it can be done in WordPress/Drupal).

If the scheduled_date is correct, then I'd check to see that your cron user is running in the same time zone.  E.g. if cron is triggered by root and not the web server user, I'd expect this sort of issue to creep in.

EDIT: You mention that you're running cron via the "cli.php" tool.  That means that PHP is using a different php.ini file than when you do web-based PHP, and your timezone might be different.  If you have terminal access, check your timezone with php -i | grep zone.

Since you're using Siteground, I doubt they allow you to control the php.ini timezone.  Since that's the case, I would recommend using the HTTP Method of running cron, which will set the timezone based on the web-based timezone.


To enable Sales tax for an Event.

Enable Enable Tax and Invoicing setting in Administer >> CiviContribute >> CiviContribute Component Settings
Create a Financial Account of type Liability, Is Tax Enabled and Tax Rate > 0.
Link Financial Account with Financial Type using 'Sales tax Account is'.
Use financial type configured for tax at #3 for event, price set, and price fields.


Non-admin role can see CiviCRM links in profile, no privileges selected

You can add visibility to specific roles on Drupal profile so they can contribute information when editing their profile.

The custom fields in Administer > Custom Data and Screens > Profiles has a setting: view/edit Drupal User Account. Select or deselect as desired.


SMTP errors with "Thank You Letters - print or email" -- does this use CiviMail settings?

I think that this is probably a limitation in G Suite. I have certainly not been able to send more than about 100 messages at a time using the G Suite SMTP relay.  I think the section on sending limits is relevant https://support.google.com/a/answer/2956491?hl=en


Civi event links - Event Info-> 404 error

You need to create a Base Page (if it doesn't exist) and enter its slug in CiviCRM by going to "Administer > System Settings > CMS Database Integration".


The problem is that the custom field has been set up to allow Multiple Records, and you did not click on the ? to read the notes about this type of setting - and those notes would have explained that the 'special power' of multiple records impacts on the ability or approach to other functionality including Importing records.


How do I call the Fatal Error Handler for extern/url.php?

When extern/url.php is invoked, the CMS is not bootstrapped and extern/url.php require_once's all the code it needs to run. So if you specify a Fatal Error Handler (CiviCRM > Administer > System settings > Debugging and Error Handling) it won't be found.

To resolve this, edit extern/url.php to add a require_once statement which names the file containing your handler. (Be careful this file doesn't execute code that will impact on extern/url.php - mine only has function definitions.)


Adding another option to the Source drop down box

Since this is tagged as webform civicrm - I am guessing you mean the Source Label that you can find if you go to the CiviCRM tab on the webform and then go to Additional Options


Do mass SMS work in 4.7.11 using Clickatell?

Looks like fix is not present in v4.7.11. But there is a ticket already - https://issues.civicrm.org/jira/browse/CRM-19327. Might be available in v4.7.12.

Anyway seems like a minor patch to apply?


CiviCase css problem (Joomla version) after upgrade to 4.7.14

This problem was fixed in version 4.7.16. More details here. If for some reason you need a quick fix for version 4.7.14, comment out the last 10 lines of css/joomla.css.


How can I create mosaico block with 2 button?

This is not an answer for how to create a new block, but if you need something quick and dirty with two buttons side-by-side, hold your nose for this horrible hack...

Drag over a "Two-Columns Block".
Change to Block Level Style so you don't mess up other blocks.
Change the Paragraph Size to the smallest (or use the instructions in the next section).
Disable "Show Title" and "Show Image".
Remove the text from both columns.

If you want to minimize the blank text areas:

Select one of the text areas.
Choose the Source Code option ("<>").
Substitute a placeholder:
&thinsp;

Repeat for the other text area.

Unfortunately, there are no options for aligning the buttons or making them different colors, but at least you'll have a two button block to butt up against other blocks.

Notes:

I'm assuming you are using the Versafix-1 template.
I found that I had to use something other than an actual space character (or &nbsp;) for the text areas. Otherwise, the source code block wasn't saved the next time I tried to edit it. I could leave some transparent text, but I don't want to impact someone using a screen reader.
You might be able to use "font-size:0" to completely eliminate the text area but I doubt you'll be able to select it again since there is no substance left for the editor to represent.


While researching another issue I stumbled across this on JIRA: https://issues.civicrm.org/jira/browse/CRM-17779 - so as of 4.7.9, it looks as if you will be able to update the pending contribution to completed (haven't tested, but you should test both online and offline contributions to see what happens).

Kind regards,
Tamar


CiviCRM Scheduled Jobs Timezone Confusion

This question is now resolved.  It is not a bug, but a server misconfiguration.  I am adding the resolution here for posterity.

It turns out the issue was caused by the server being set to Europe/Berlin, but PHP-FPM defaulting to UTC.

Setting PHP-FPM to Europe/Berlin through its configuration file solved the issue.


What would cause civicrm_invoke to submit a large number of server requests?

It isn't a process it's a function in the drupal module. It mostly gets called when a web request comes in. Check your apache logs for a large number of requests, maybe your site was hit by a botnet. At least the logs would tell you IPs.


CiviCRM Integration with SMS Gateway custom API

You'll need to write an extension that implements a CRM_SMS_Provider interface.  The Twilio extension is a good example of this.


How to add custom templates (tpls) or php files

Am sure others will provide a more substantive answer but going to start just with a link to this wiki page since I had it handy


Shortcode and permissions for WordPress publicly searchable member directory

This problem turned out to be a Javascript error in the console:

SyntaxError: expected expression, got '<' on civicrm:1

A plugin must have been dumping in Javascript in the header or footer, and once it was deactivated, CiviCRM could render the search results in Javascript.


GitHub repository location for Import scripts via Kettle

check the repo located here,  you might need to search the repo further:
 https://github.com/PalanteJon/civicrm_kettle_transforms


If the donor did not initiate the recurring contribution - then the extension did not tokenize the credit card - so you’ll need the card credentials from the donor to set up the recurring contribution.


Does Drupal 7 "CiviCRM Entity" online event registration generate confirmation email?

Assuming you used the Price Set Entity field to get the registration form.
The confirmation email was never fleshed out totally.
There are also 2 Rules Events you can react to:
"Event Registration" and "Successful CC Transaction"
Which then you could use Drupal's stock "Send email" action ...
We do have a Rules action, "Send Contribution API sendconfirmation" .. which does what it says .. for the contribution created, it runs the Contribution API entity, "sendconfirmation" action ..
Which is ok unless there is no contribution.
We'd also done some things where we implement hook_form_alter() and add a submit handler ..and programmatically send an email on form submission.


Can I search "Added By/Modified By" with a contact ID instead of a name?

Bonjour. I think you are using the field in the Change Log, Modified By (Added by) - ie 'Journal of Change' is your translation of the French version of 'Change Log'.
You are right, currently it is just used as a 'text' field. So Advanced Search is not going to help you.
And the field is not currently available in Search Builder either.
And there is no Custom Search for this.

So, if you have developer/funds is to add the feature to one of the above.

Or create an extension that does the above automatically.

The only other thought is that you could consider another approach, such as, if you are using Drupal you could have your team 'add' contacts through Drupal Webform - and create a Relationship between them. The benefits would be that you could then

search by the Relationship and then create a Smart Group
use the Permissioned Relationship extension so that user 'Jean' could only see contacts that they added.

Hope some of the above is helpful.


Where are you trying to add the script -- in the "Footer" editor window on the Event details page?

If so, you probably need to add it in the Wordpress side (e.g. as an HTML/Text widget) rather than the CiviCRM editor to avoid these security notices. If you only want to have the widget show on CiviCRM pages, or SSL pages, etc. you may find this Q&A on the Wordpress StackExchange site helpful (more than one of the answers may be useful).


How do I set the time zones in order to correct mismatched Timestamps for MySQL and PHP?

The warning is because the timezone of the server does not match with the timezone set in MySQL. We had similar warning and after setting the timezone in both Centos & MySQL, the warning is not displayed anymore.
Additional Info:
This is how we corrected/fixed the timezones, if it helps. The below instructions are for setting timezone to GMT, you need to use your timezone if you want to use the below instructions.
Setting the timezone in CentOS
Check the date and timezone
[root@my-server ~]# date
Mon Nov 24 10:27:14 CET 2014

The above is incorrect. We need to set GMT for Europe/London
Fix the timezone
[root@my-server ~]# rm /etc/localtime
[root@my-server ~]# ln -s /usr/share/zoneinfo/Europe/London /etc/localtime

Now check the date and timezone again
[root@my-server ~]# date
Mon Nov 24 09:30:14 GMT 2014

Setting the timezone in MySQL
Check the timezone in MySQL
mysql> SELECT @@global.time_zone;
+-----------------------------+
| @@global.time_zone          |
+-----------------------------+
| SYSTEM                      |
+-----------------------------+
1 row in set (0.00 sec)

Set timezone '+00:00' for GMT
mysql> SET GLOBAL time_zone = '+00:00';
Query OK, 0 rows affected (0.00 sec)

Now check the timezone again in MysSQL
mysql> SELECT @@global.time_zone;
+-----------------------------+
| @@global.time_zone          |
+-----------------------------+
| +00:00                      |
+-----------------------------+
1 row in set (0.00 sec)


Add a contact to an organization through "profile" public form

I think that in pure CiviCRM all you can do is add the Current Employer field to the profile, which is then a text only field.

If you want that field to be an autocomplete then I think you should try the Public Autocomplete of Organisation Names extension. There is also a blog written about it here


How does the /civicrm/CRM/Mailing/xml/Menu/Mailing.xml file work?

If you are planning on submitting a change to CiviCRM, then modifying this file may be what you want to do to modify the existing behaviour. Clearing CiviCRM's caches (Administer → System Settings → Cleanup Caches and Update Paths) will reload those callbacks as defined in the XML. But: You probably don't want to do this :)

If you're hoping to customise your CiviCRM install and be able to keep your site upgraded in future, stop now. Instead I recommend you look into how to write a custom CiviCRM extension for your site, which packages your changes separately from the main codebase.

By writing an extension using CiviCRM's published interfaces, you can upgrade to the next release more easily. On your current path you'll soon be maintaining a modified version of the CiviCRM codebase, which will introduce more and more upgrade challenges, leaving you / your client in a more difficult position.

CiviCRM hook reference lists your entry points for modifying CiviCRM behaviour
Create a CiviCRM extension shows you how to get up and running
civix is a tool to get you there faster


At the link you referenced it says you can use Civi::log()->debug(); this section, so for example Civi::log()->debug(var_export($my_variable, true));

I'm not sure what you mean by the directory isn't available? This article says how to find it: Where are the "ConfigAndLog" and "templates_c" directories?


Restricting field options in a profile on a contribution page

You can set a field in a profile to be "View-only". So:

(If you haven't done it already) Set your Default Country to United Kingdom on Administer > Localization > Languages, Currency, Location.
In the profile on your membership page set the "Country" field to be "View-only".


You can do this by:

Going to Administer menu >> CiviMember >> Membership Types.
Next to each membership type you'd like this to apply to, click the "Edit" link (see screenshot 1 below).
On the Membership Type screen, set Membership Type Plan to "Fixed", set Fixed Period Start Day to "January 1st", and Fixed Period Rollover Day to "July 1st" (see screenshot 2 below).
Press Save.


There is no strange behaviour, just lack of information ;-) A trainee was using this e-mail address to create 'Activity'


I've had this problem

How to safely restart Scheduled reminders

And got a really clear and succinct answer.


Wordpress: MyISAM Database Engine Error after update

Yes, you can change the engine but they are temporary tables so will disappear soon - and more will appear.

It is a warning rather than an error.  The data integrity message is intended to relate to the permanent tables, not these temporary ones. Since your permanent tables show as InnoDB you can safely ignore this message.

I've logged this here: https://lab.civicrm.org/dev/core/issues/591


Where is the "Allow Other Amounts?" option?

If you look at http://dmaster.demo.civicrm.org/civicrm/admin/contribute/amount?reset=1&action=update&id=1 you will see the field as per the bottom of this screenshot


CiviCRM rebuilding templates_c with permissions

Actually that looks good - your webserver user www-data needs to be able to write to files/ (and anything below it);


Using Civi to manage members' lists of items available for donation to other members

I also received a helpful answer from Rose in the Civi chat (thank you Rose!). Thought I'd post it here just to have it all in one place:

Interesting problem, and there's probably a way somehow. I've also looked at the response in Stack Exchange, which definitely recommends Drupal because then you can use Views and Webforms. A few questions first... 1) Why does it have to be Wordpress? 2) Do the schools need to log in/record their own needs and surplus or will it all be managed by staff in the organisation? 3) Are the items specifically limited (e.g. 3 tables, 100 books)?

A really simple method would be to just use custom fields to record what items are in surplus and then use Reports to pull off which items are needed, and use customised Activities to record any transactions between schools. Drupal is probably key if you do want the schools to log in and record their surplus or needs. You could use Memberships and Donations (of a sort) to record items donated but it's not as simple to record how the items are transferred to the under-funded schools. Possibly Grants but it's not a very sophisticated tool.

And Drupal is probably key if you want to display the info online (using Views) although you may be able to use the API to display some information but you can't interact with the information using the API. For example, people with some log in access can view information and then submit a request for it if you're using Drupal.

Sorry -  discount my second question because you have already answered that! I asked the third question because if 'yes' then the answer in Stack Exchange is probably a better answer than mine, but if they're happy with using custom fields to just record categories of items (plus a free text field to provide a bit of detail, including condition), this would be sufficient for schools to see what's available.


Civicontribute radiobuttons without "none", where the "Other" contribution field deselects radiobuttons

This code worked for me:

CRM.$(function($) {
  $('input[type=text]', '#priceset').on('keyup', function() {
    if ($(this).val()) {
      $('input[type=radio]:checked', '#priceset').prop('checked', false).each(function() {
        calculateRadioLineItemValue(this);
      });
      calculateText(this);
    }
  });
  $('input[type=radio]', '#priceset').on('change', function() {
    if ($(this).is(':checked')) {
      $('input[type=text]', '#priceset').val('').each(function() {
        calculateText(this);
      });
    }
  });
});


CiviCRM 5.4.0 Install "You do not have permission to access this page"

Sometimes even i face similar problem when i try to install CiviCRM. But i make it work by commenting the line that throws this error.

You can find quick solution here.


You can save the result of an advanced Search as a Smart Group. If you want a link to that smart group in the menu, you can add a menu option for it with Administer > Customize Data and Screens > Navigation Menu.


How to enter an activity ID in the API Explorer?

To answer your different questions:

  I don't see what I would type in to locate it any other way?

You would locate it by typing in the activity subject. Admittedly, this isn't perfect because some activities might have no subject, and therefore can't be located via autocomplete.

  Is there a way to override those new GUI elements

Update: now the answer is yes :)
As of CiviCRM 4.6.9 an EntityRef in the Api Explorer will accept any integer.


What is the correct way to work with custom data in the API?

As of CiviCRM 4.6, the api explorer is like 1-stop-shopping for browsing, building and testing api calls.

You can start on the "Examples" tab to see how custom values are generally done:

If you want more detailed explanation of how it works, try the "Code Docs" tab:

And finally, the Explorer tab lets you browse available params and will write the php/javascript/rest/cli code for you:


How to get the sharing icons to display in mosaico?

It sounds like the same issue as here perhaps: https://github.com/veda-consulting/uk.co.vedaconsulting.mosaico/issues/160

If you read the detail, the problem has been fixed for new templates, but old templates created before the fix will still fail most likely


Try this steps :

1) Rebuild the menu by hitting this url <your_site_name>/civicrm/menu/rebuild

2) Clear Drupal cache using drush cc all

3) Clear browser cache -- mostly done with Ctrl+Shift+Del.


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

I set one up on the Drupal demo site so it should be there for a few hours before it flushes.

Dashboard is here

Setting up a pledge 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 setup Civicrm for using FPO addresses

The list of states isn't editable by the end user, so it will require filing a bug to get APO, FPO (and whatever the third one is) added as state. In the meantime, I recommend using APO as the city, and not filling in the state or country (per USPS recommendations).


How do I override the default date range of JQuery date widget?

Have you tried adjusting the settings at Administer > Customize Data and Screens > Date Preferences.  to achieve what you want?


Transactions with fee amount don't show up properly in batches

The current batch total in CiviCRM is confusing as it is summing the amounts for all of the bookkeeping entries in the batch, NOT the total payments received for the contributions included or the total expected revenue from them.

To see this clearly, if you edit a contribution and change most fields this results in reversing and reposting a corrected copy of the transaction. Putting all of the relevant bookkeeping transactions into a batch results in a 'batch total' significantly larger than the contribution, even if you haven't changed the contribution amount.

We're finalizing (Sep 2017) some new functionality in core and extensions that will allow some batches to be used to more easily track batches of payments, and other ones to deal with non-payment bookkeeping entries.


trouble with CiviCRM Installer on wordpress

CiviCRM is a very different beast than other plugins - it has more code than WordPress itself!  Unfortunately the "normal" WordPress installation doesn't work.  You can find detailed instructions here: https://wiki.civicrm.org/confluence/display/CRMDOC/Installing+CiviCRM+for+WordPress.  Also feel free to ask both here and on https://chat.civicrm.org for help!


Relationship disabled by end date but still enabled?

The "Disable expired relationships" scheduled job should set the is_active field to 0 for relationships with a past end date.

  A bit of history: Civi has always treated both past and disabled
  relationships as "inactive" however there were inconsistencies in some
  of the code (reports maybe) that were not doing so. I believe Fuzion
  contributed the scheduled job to remedy this

(From a comment on issue CRM-18561. See also this forum post for some discussion.)

So it looks to me as though the scheduled job has failed in this case. If you view the job log for this job, are any errors shown? Or anything at the relevant time in the CiviCRM log file in files/civicrm/ConfigAndLog/ ?

Could you test whether the problem occurs on the 4.6 demo site?


Why is the CiviCRM installer unable to connect to the MySQL server?

In my experience if 'localhost' (or your host) was refusing to connect on default port with all credentials/permissions definitely correct, specifying 'localhost:3306' will work (even though you shouldn't have to specify the :3306, and I think it tells you as much).

I will also note that this is something I have only experienced recently, and with this question there are examples on Ubuntu, and in my case MAMP.


I recommend using the wiki page WordPress plugins and themes incompatible with CiviCRM.


"One thing that puts us off a dedicated IP is the extra admin that would be involved in keeping the IP off blacklists. "

That's one of Sparkpost's responsibilities (although you should also monitor, just in case, I particularly like http://multirbl.valli.org/lookup/).

  "If you are on a dedicated IP, how many emails per month are you sending? Has monitoring your dedicated IP for blacklisting been an issue?"

We send around 200k emails per month from ~ 25 domains, all on the same IP. We haven't had issues being blacklisted, but some clients have had issues with their domain appearing on some blacklists, especially if it was their first mailing (with invalid addresses).


Could not find a valid session key when submitting Petition

Have been able to get over the session key error by installing a fresh install of WP and CiviCRM, then restoring Wordpress and CiviCRM DBs, repointing wp_config.php and CiviCRM.settings.php. Also had to rename my table prefixes in wp_config.php to match my restored tables. The caches get created once you start up CiviCRM and do things. Testing so far all functionality is working again. Hopefully this may help someone should you come across this issue which is pretty horrible.


edit contact with ref to address causes fatal error

John guided me to the solution: civicrm is located in Belgium where adresses should be "street number bus" and second line "postalcode city". I used the civicrm (alpha) extension "org.civicoop.streetformatnl" v1.0 to edit civicrm views. Unfortunately it is no longer compatible. If disabled, everything works fine.

Kind regards, Johan.


How can I import a list of contacts from MailChimp to the database all at once?

There is a mailchimp extension which you could install in CiviCRM and which then connects to your mailchimp and imports the contacts from mailchimp into CiviCRM.


CiviEvent: Could not find valid value for id (Drupal 7.6.1)

After doing a lot of trial and error and closely analyzing the complaints we have received, I'm fairly sure that the cause of the problem is: you register one person, then click back on your browser and try to register a second. Your browser doesn't properly refresh the page and somehow the id of the event is lost in the process.

I'm not sure what the best fix is - but I'm fairly certain that is the cause.


CiviRules is not tagging users or adding them to groups

The first thing that strikes me is the trigger is "participant is added". That means it is only done for new participants, not for existing ones. Should it not also do this for changes to participants?
Personally I have not done anything yet with the event participant trigger, so I would focus on testing that one first.

I do regularly use tagging of contacts and adding to group actions, so I know that these actually do work, the problem lies elsewhere. Next week we have planned a small CiviRules sprint, I will have a go with these examples.

Okay, here are my test results.

Test 1:
This is the rule I have entered (and apologies for the Dutch in some places):

If I now register a contact for the event and immediately give them the status "attended" this works like a charm:

Obviously this will NOT work when I register a participant with the status "registered" and then later this is changed to status "attended" as the participant already exists, so the "participant is added" is not triggered. To deal with this I have a second rule on "participant is changed":

Again, this changed rule works like a charm.


alter/remove specific popup notifications

You are in the right path, if you look at the CRM_Core_Session class you'll see the method getStatus which takes a boolean as a parameter, if TRUEthen it will reset the status.

That said, I would create a extension or use an existing one and implement hook_civicrm_postProcess.

You'll need to know what is the class/form name of the form you are targeting, an easy way would be to inspect the source of the form/page from which you want to remove/replace the notification and search for .tpl

Example: CRM/Contact/Form/Task/Email.tpl, its class/form name would be  CRM_Contact_Form_Task_Email

Then in your extension:

function myextension_civicrm_postProcess( $formName, &$form ) {
    if($formName == 'CRM_Contact_Form_Task_Email') {
        $session = CRM_Core_Session::singleton();
        // Reomve status message from form
        $session->getStatus( $reset = TRUE );
        // Set your new message
        $session::setStatus(ts('This is a custom message.'), ts('Custom Message'), 'success');
    }
}


Not quite an answer to the question, but if you didn't know, there is civicrm_extension table and you can at least set it to not active

otherwise if you have cli (and eg are on Drupal) you can use

drush ceui

other such commands are listed here


Part of the job is to try shaping more precisely what your project will be, and discuss it with your mentor and the community.

Have you contacted directly the potential mentors? our irc channel is a good place to hang out and have more interactive discussions

In general, the more active you are in the community (eg trying to ask or answer specific questions, see what issues are left and looking for fix, being on irc...), the easier and faster it's going to be up to speed (and in your specific case, that your candidacy and project is selected)


DB Error: constraint violation on anonymous user contribution/membership registration after 5.8.2 -> 5.9.0 update

This is a core bug and Eileen has send a PR for the fix. Will you be able to try by applying the patch from here?

If the patch works for you than please comment your test result on PR so that it will speed up process of merging into core and having it available in next release.

Cheers

Pradeep


Should online renewals generate a Membership Renewal Activity? and how about when a Pay Later renewal is set to completed?

Seems there was a regression. Jira ticket here (now FIXED) for the lack of Membership Renewal activity creation when you renew online that was fixed for 4.7.15.

Second ticket for No Membership Renewal Activity is created when a Pay Later is set to Completed not yet fixed


Unable to add membership types dropdown field to registration form

the only way membership types can be used is via contribution pages


Can't get action token {action.unsubscribeUrl} to work in Welcome automated message

I expect the token only gets populated with the relevent URL when it is used as part of a CiviMailing.

The automated message you are referring to does not go out via CiviMail, so it is possible that it will not function in that feature.

Since it seems that the checksum doesn't work directly with civicrm/mailing/subscribe?reset=1 you can set up a Profile that includes your public mailing lists, and send them to that. Bit of a pain having to do the extra steps.

Using tokens for Profiles is detailed here: https://wiki.civicrm.org/confluence/display/CRMDOC/Tokens

And using Profiles for Mailing Lists is here: https://docs.civicrm.org/user/en/4.7/email/set-up/#allow-people-to-sign-up-for-your-mailing-lists-online


Thanks to @samuelsolv for his answer to Export contact info from MailChimp
Apparently, the separator for import/export of csv files is a "localization" setting, at this path:
/civicrm/admin/setting/localization?reset=1


CiviCRM (on WordPress) runs too slow to be useful

The problem isn't WordPress, but Hostmonster.  Shared hosting makes its money on sites that don't need any CPU or memory - simple WordPress sites, for instance.

CiviCRM is a much more resource-intensive program than your typical CMS (like WordPress).  If you have good shared hosting - which is hard to come by! - then you can sometimes run a very small CiviCRM instance.  Say, 500 contacts.

Consider a VPS instead.  Hostmonster offers a VPS service, but there are cheaper VPS vendors available.  If you're committed to shared hosting, there's a list of hosting providers available - but if you have the resources to support a VPS, you'll be much happier.


Update particular contribute based on contribute id with civicrm_api3

You can use civicrm api to process CRUD on CiviCRM Database.

To update contribution you can use

$result = civicrm_api3('Contribution', 'create', [
  'id' => $contrib_data[0]->id,
  'contribution_status_id' => $contribution_status_id,
]);

Cheers

Pradeep


Go to https://spires.civisites.com/user and there you can log in.

By the way I would think you actually ARE paying for the hosting. The hosting company is civisites and you can try to contact them (https://www.civisites.com/about-us / http://www.circle-interactive.co.uk/)


database error when finishing update to 5.32

Mysql has a feature called binary logging. You have it turned on, so either:
(a) turn it off, OR
(b) the mysql user needs to have the SUPER privilege, OR
(c) you need to set the mysql configuration variable log_bin_trust_function_creators.
See https://docs.civicrm.org/installation/en/latest/general/requirements/#binary-logging
You may need to ask your hosting provider what they will allow.


to address your primary question "what's the simplest way to configure civicrm for mass emailing?"
That's a difficult question to answer without a lot of context.
In some ways, the simplest is to use sendmail/postfix/php mail(), if that's setup and running on your server. Many smtp relays you might use put limits on how many messages can be sent, that could get in the way of bulk email. But, using the server's local server adds complexity -- you have to set some DNS records and pay close attention to bounces to make sure your messages are getting through and not being marked as spam by some stupid automated system (yes, google, I'm looking at you).
In some cases, I use the local server; in some I use an smtp relay service like CiviSMTP, sendgrid or mandril. Some organizations have services they are paying for already (like google apps) and use that. I've had problems using organizational outlook accounts in the past, I try to avoid having microsoft in the mix, but I think outlook can now handle the verp separator that civi uses for bounce tracking so maybe it's not as annoying now.
So the right answer depends on the resources and skills you have in the organization. Sorry if that is not a complete answer.


CiviContribute - convert amounts into words

No there is no such plugin that I am aware of.


How to Remove Old Events from the Managing Events Tab

The error is likely misleading. You'll find more details in your CiviCRM error log (and/or perhaps your CMS error log). The CiviCRM Log Viewer extension is the simplest way to see those.

It's likely that these old events have some configuration that is blowing up when you resave them with the end date.

Since you just want to hide them, your simplest course of action is to set an end date directly using sql, e.g. with something like:

UPDATE civicrm_event SET end_date = start_date where isnull(end_date) and start_date < '2013-01-01'


Each contribution should have one or more payments.

When you are creating contribution using contribution api with completed status a payment is recorded automatically.

If you creating contribution with pending status eg incase of check payments then when you receive payment from bank you use payment api to record payment for the pending contribution

In your case if you recording membership via code then i would suggest you to use Order api where you can pass membership and contribution params in the api params and it will create all required records in one call. You can refer here on how you can use order api to create membership or participant records with its payment in one call.
Cheers
Pradeep


Can be achieved by GDPR webform https://github.com/tapashdatta/webform_gdpr/tree/5.x


How to style contribution and event registration pages?

One approach in Drupal would be the ThemeKey + ThemeKey CiviCRM modules. There's a Drupal 7 version of ThemeKey CiviCRM. This allows you to use a different theme for specified Civi pages. So you could create a minimal theme and use that for the desired pages.


Having issues updating to civiCRM 5.32.2

You can't use the WordPress plugin update system. You must do it via either ftp or SSH. You will find the full documentation at https://docs.civicrm.org/sysadmin/en/latest/upgrade/wordpress/
While complete and accurate, the comprehensiveness of that doc can be a little overwhelming. I created a checklist for myself to cover the bases on my server. It may be helpful to you. You can see my CiviCRM upgrade on WordPress summary here: https://kapn.net/support/civicrm-upgrade/
Some bits are very specific to me but they should be obvious. If it looks like gobbledygook to you then ignore it and focus on the official docs above.


How can our users request an email with the contact.checksum links?

The create mode should do what you want - have you ticked "Standalone Form or Directory" in the profile settings?
In case that does not work, we are currently developing an extension that probably does what you need. Unfortunately it is still in development and not yet documented but you can find the code here: https://github.com/systopia/de.systopia.selfservice


How to remove a financial type from profile is already created and data is submitted?

I'm not 100% clear on your question but I think it is one of the following:

The [x]CiviContribute option in the screenshot above is automatically checked if you add a profile to a Contribution page. If you remove the profile from all Contribution pages, that option will disappear again.
If you want to remove a particular field from the Profile (e.g. if you added the "Financial Type" field to this profile), click on View or Edit Fields for this Profile in the screenshot above and look for that field to disable or remove it.


Assign all contacts created by a user to one group automatically?

As per Erik's suggestion I created a new condition.
It will be included in the next version of civirules (2.12).
If you would like to get it before the official release of the new version you can always get it from the civirules repo https://lab.civicrm.org/extensions/civirules .

The new condition is called "Contact added by Contact (not) in Group(s)" and it lets you ask if the contact was made by someone in the specified group. My original question was about the specific contact, but the group implementation makes more sense and works better for the ACL functionality which was missing.


How to fetch Profile gid from hook_civicrm_post included in a Contribution Page?

You can use profiles directly to create an Household. When you add a field to a profile you have first select the entity, which could be contact, Individual, subtype of Individual, Household, Organization and others.

So there is no need to program this.


Scheduled reminders based on a custom field on an activity

Unfortunately, the custom date field feature is only for dates on the contact record, not activities. Doing activities would take a change in core--it would be comparable to the work to do the contact date fields. It would be a great feature, though!


This sounds like you want a Lifetime membership type with its minimum fee to level up every "x" years. Similar to purchasing a Gold - you can have it for lifetime but its price just increases with time.

If this is what you want, simply create a membership type from Administer -> CiviMember -> Membership Type with duration set to lifetime and write a custom code in extension/module which increases the minimum fee value of this membership type id with time in year.

Refererence for creating an extension - https://docs.civicrm.org/dev/en/master/extensions/civix/


Fatal error using Paypal in Version 4.7.29

You're experiencing the bug documented at CRM-21595.  You will need to apply the patch or wait for CiviCRM 4.7.30.

Most people won't experience this bug if they disable "Pay Later" as an option.


Can we use a Relationship between 2 contacts, once in either direction?

Doing some research on your find using svn blame and svn log on the old svn repo, this appears to have been implemented as part of https://issues.civicrm.org/jira/browse/CRM-58, and the key comment is

i.e. if there is "Parent" relationship between 2 contacts then you cannot add another relationship "child " between them.

The code for this is also what's stopping adding the second "favourite". So it seems like the checking is too aggressive - makes sense to prevent the parent being a child of their spouse (except in some geographical regions where it might be true (grin)), but not your use-case.


Avery 5160 label definition does not print properly

I've not tried those particular labels, but I had a similar problem with Avery J8160 labels. I started off with a MS Word template downloaded from Avery to get all the spacing values, but had to make some adjustments to the label format, which I did by trial and error to get it printing correctly. I calculated the horizontal spacing as 0.25 cm but had to use 0.45 cm and for vertical spacing@ Calculated 0 cm but had ti use  0.15 cm. Will be different values for your labels buy that gives you the idea. I don't know what wasn't right, but this solved the problem for me.


DB Error: no such field (Joomla - view contact)

Problem Solved!
I had a broken custom profile with broken custom fields.
I was not even able to delte those fields and that profile from the backend.
Had to go into the Database and delete the entire table which is related to that profile.

That fixed the problem.


Customize contacts screen to remove some fields

There was a blog sometime ago by Dalin that had a fairly in depth recipe if you want to take a look and see if that helps you make some progress. There is no option to do this through the UI - though it comes up reasonably often.


Is there a way to have a Send Email button on an Activity?

It's likely that someone has written an extension to do this but if there isn't one in the extension directory (I presume that you've looked) then you have to assume that no-one has taken the time to publish it.

I suppose I could end the answer there, but here's a bit more thought on how you would develop it...

Since this is a fairly reasonable thing to expect to do, would be fairly easy to implement just adding a link to a URL of the format civicrm/activity/email/add?action=add&reset=1&cid=[CID]&selectedChild=activity&atype=[ATYPEID] and an addition that is unlikely to break anything, then it might make sense as an addition to core. (I'm not sure we've worked out exactly how to draw the line on how to add it / this one seems borderline).

Implementing as an extension would be a good first step.

Note: adding the text of the incoming email would be a little harder, and need a bit more thought, though there would be a fairly straight forward way to do that - it's not rocket science.


building a group from a list of email addresses of contacts

If you are not able find a search method that results in the people you want to add to a group. And you have a list of email addresses of the people in the group. You can use the import feature.

The import allows you to add contacts (newly imported or existing matched contacts) in to a group.

Contacts > Import Contacts ("For Duplicate Contacts" use Update)


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


How do I create a new folder for reports?

Go to administer > custom data and screens > navigation menu > add a new menu item.


can't install civicrm on fresh wordpress

This really looks like you're trying to install on a hosting provider, but you downloaded the WordPress package for Windows. I can see how this might have happened given the WP site, but it's not at all what you wanted.
Which hosting provider are you using? Do they offer WHM/cPanel? Or Plesk? These are management frameworks for hosting providers. Inside them you should find something like Softaculous - this will do the WordPress install for you. Once your domain has the minimal WP in place, you'd do the following.

confirm you can reach your VPS using the ssh protocol. You will use ssh for remote management tasks and scp (secure copy) to move files back and forth.

Download the Civi zip file.

scp (using WinSCP or similar) the file to the default location for user root - that's the manager account.

ssh into the system, change to the WP plugins directory, and unpack the Civi zip file. This might vary depending on the system you're on, but here is how we'd do it on the cloud provider I manage:
ssh root@brandnewwpsystem.com

cd ~/wp-content/plugins unzip

/root/civicrm-4.7.19-wordpress.zip

Log into WordPress, you should have a Civi tab at the upper left. Depending on the layout you might have to manually configure the MySQL database.

This is a five minute task for someone who's done it a few times. Do not hesitate to ask more questions if you get stuck.


Yes - this is where you can find the Moneris payment processor extension.


Is it possible to allow people to submit their own events to CiviCRM?

I am not going to be able to discuss a full recipe here :-) But yes, I would think it is feasible and I would certainly use Webform for this. I could imagine a situation where you have one Drupal frontend feeding into more CiviCRM installs, where each organisation would have its own CiviCRM database? If the organisations do not need to share any contacts that might in fact be the easied solution? You keep track of the organizations in either Drupal or a CiviCRM install, with the settings that their CiviCRM installation requires? Interesting project!


Support for distributing benefits in Turkish

you would have to check how complete the turkish translation is. It seems we have achieved 100% translated, but can't judge of the quality of the translation.

https://www.transifex.com/civicrm/civicrm/

They are various hosting providers that can offer you to host. We do host on our own servers, so don't have a first hand experience on what they offer and it is not a question that fits the SE format, but I can mention that a nice community member is fast at replying and has a lot of experience with civi: hershel, you can find more on civihosting

and this page lists other providers, that are all active in the community:
https://civicrm.org/hosting-providers


Credit card fields do not show after updating

I needed to delete everything inside the sites/default/files/civicrm/templates_c/ directory;

rm -R sites/default/files/civicrm/templates_c/*


Multiple error messages upon upgrade to CiviCRM 4.2.20

Those are warnings, not errors. It's simply PHP telling you that CiviCRM 4.2 is a rather old piece of software (which it is!). They will not prevent CiviCRM from working normally, certainly not for the brief time between now and when you get it upgraded further.

I recommend you ignore them and proceed with the upgrade. The latest version of CiviCRM is more up-to-date so will not trigger php warnings.


Drupal View filtered with a custom individual data field

Drupal Views need to know about table updates when they are using separate databases.  When you add a custom field, civicrm  creates a new table.  To expose the new entity, you must edit the settings.php file with the new field.  You can just copy/paste from here: https://example.org/civicrm/admin/setting/uf?reset=1 .  Ref: http://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration


This can be done via the search function, doing a search for the e-mail domain will yield all contact results matching that domain, which you can then bulk select and from the Actions menu add a relationship to an organisation.


I looked quickly into doing this with civiCRM entity and rules integration modules (I would think this would be possible), but that seems difficult or not possible without some further customization to set the event parameters.

If you are comfortable with this type of work, I would imagine writing a short module that engages the civiCRM API to create an event on submission of a specific webform could take in the (validated) data from your simplified webform (submitted by a user, doesn't have to be staff) and create the events for you in civiCRM. Using event templates for your categories as Aidan suggested in comments would cut way down on the parameters you would have to feed in for proper configuration. See the API explorer on the relevant version of demo site as a resource for how that might be put together.

Whether doing that work is actually worth it for your use-case, I can't answer for you, depends on how much better it is to have all user events in civiCRM (but I think it would be pretty cool!).


Is there a way to interface CiviCRM with QuickBooks Online?

Agileware has developed a CiviQuickbooks extension - in this case "Quickbooks" means "Quickbooks online".


How to select multiple values in select2 control by jquery?

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

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


Big part of the "engine" of CiviRules is finished, with the rest being completed this month already. As with many other open source development, the rest is depending on funding.

The extension then needs to be populated with specific events, conditions and actions, just like Drupal Rules. We then hope many more will participate in adding those. @ErikH is the one to talk with.

Check: https://civicrm.org/blogs/erikhommel/civirules-sprint-january-and-march-2015 and/or http://redmine.civicoop.org/projects/civirules/wiki

(CiviRules should not be confused with the CiviCRM Rules extension, which simply syncronizes CiviCRM with Drupal Rules. This is the extension Eileen is referring to: https://www.drupal.org/project/civicrm_entity)


Multiple contact (sub)types for an individual

As long as I know it's a good practice to use multiple subtypes in the same contact.

Doing that you can, for example, create different custom fields for each subtype. So your coaches who are also trainers will have the fields for being coaches and in addition the fields for being trainers.

And if in the future, one of your coaches became a traier, you can add him the subtype and automatically will appear the custom fields for it.

So I will recommend it. :)


Importing checkbox data--error "'1' is not a valid option for field"

Check your custom fields label and value and value must be same as in your .csv file. Label could be anything but value must match csv file value(if value in csv file 1, 2,3 then you option value for custom field must be 1,2,3).


On Administrative Dashboard in WP, how do I make column 1 wide enough to display my whole Activities dash let?

A bit of css will do it.
I would suggest to create a new css file in you custom directory like /wp-content/plugins/files/civicrm/my_css/my_stylesheet.css
Navigate to Administer->System Settings->Resource URLs and put your URL to the css file http://yoursite.com/wp-content/plugins/files/civicrm/my_css/my_stylesheet.css

In your css file:

#crm-container .column-0 {
        width: 50% !important; // set the width of the left column to the percentage needed
}
#crm-container .column-1 {
            width: 50% !important; // set the width of the right column
}

Note that between the two columns the percentage must sum 100%

The next style will set the columns to occupy the entire width of your screen

#crm-container .column {
        float: none !important; // remove floating so the column-0 stays on top of column-1
}

#crm-container .column-0, #crm-container .column-1 {
        width: 100% !important; // set the width of the columns to the cantainer width
        padding: 0 0 25px !important; // reduce bottom padding
}

You might not need to set the weight with !important but it never worked for my without it, also you might need to clear the cache of your browser.


When I go to the "Advanced Search" Screen, I don't see the tab Contributions

You need to enable it in Display Preferences. Navigate to
CiviCRM >> Administer >> Customize Data and Screens >> Display Preferences.
Check the contribution option under 'Contact Search' field.


What's the cause of this "Unexected token" JavaScript error?

This an old thread, but I just encountered the same problem. In case anyone else lands here, here's what I found:

The issue was that I had a typo in the domain for the URL settings, which I'd defined in civicrm.settings.php. My super-helpful ISP redirects the request to http://searchassist.verizon.com/main?a-bunch-of-params-including-my-typoed-domain. That URL contains HTML, of course, not JavaScript. When the browser gets back HTML from a script src, it throws a parse error.


Disable certain address location types depending on Contact type?

The cheapest solution would be to combine "Home" and "Main" into one option that can be used for both individuals and organizations. Just have to come up with a word that has both meanings...


Redirection to Organization Dashboard in Employer of Relationship

No need to redirect.

Make sure that in the employee's Contact > Relationships tab that by Permissions it is checked that the Employee can View and Edit the Employer Contact.
When the Employee logs into their dashboard, scroll all the way to the bottom and you will see a Relationship section showing "employee" as Employee of "Employer". Over to the right you will see Edit Contact Information & Dashboard. This will allow you to access the "Employer" Dashboard.


Render a previously submitted event registration

There is not straight forward solution for this. However you can certainly achieve this by
1. Register URL in xml
2. Create a page and copy template from thank you page of event.
3. Assign all the required variables to smarty template.

HTH

Pradeep


Should deleted Participant contributions appear in the report Event Income Report?

Not deleting financial information when a registration is deleted is by design so that organizations can pass audits. One wouldn't want an employee to delete some registrants and pocket the money if there is no checkin at the event, for example.

If you would like to sponsor an extension to optionally change this behaviour it should be fairly simple to create, depending on how you want to approach things.


Is Civi supposed to redirect after a contribution form submission?

So when filling the form, you submit it (the data is into the post, so you have the feeling it's truncated as you don't see the params in the log/net tab). Once that data is processed, it needs to display something (the confirmation that everything went well).

They are two ways of doing that:
- either the result of the post is the confirmation message
- or you redirect to another page that displays the confirmation message

the second one (the one yo experienced) has several benefits: it's easier to redirect to another page (so you have a completely custom and different thank you page from outside of civi, and as importantly, it allows you to reload the confirmation page without resubmitting the contribution (that's why you have warning from your browser when you reload a page after you submit something)

Now, that design choice made many years ago doesn't make that much sense when you have forms in ajax (eg. with payment providers like stripe), but I don't think it's a problem to do a redirect, it doesn't create a major speed difference.

So in short: it's normal behaviour, nothing to worry about ;)


You can use this SQL if you have access to the database directly. Replace the "5" with the actual id of the relationship type you're interested in. If you don't know the id you can see it if you go to admin - customize - relationship types and hover over the view link then you'll see the id in the url in the browser status bar.

select c.display_name from civicrm_contact c left join civicrm_relationship r on (r.contact_id_a=c.id AND r.relationship_type_id=5) where c.contact_type='Organization' and r.id IS NULL;

Depending on which direction you've defined the relationship you may need to replace contact_id_a with contact_id_b above.

I think there's a bug in the CiviReport - Contact Reports - Relationship Report otherwise you might be able to do it from there, setting contact type A to be Organization and relationship to be "Is Empty", but it doesn't seem to recognize the latter properly.


How can I easily identify recurring contributions that failed to be recorded or failed to occur

Here is a View (well a pair of them actually)


Civisualize can't find JS and CSS resources

You need to change the url where civi looks for extension so it looks at the new url

http://d46.demo.civicrm.org/civicrm/admin/setting/url?reset=1


Memberships ending a day early before auto-renew

We set our memberships to and end date of 30th June then add a Grace period of 1 month to allow for collection of member fees. You can set grace periods and define the length of that period. Maybe this will assist you. Essentially for us our members are current as at 30th June then on 1 July they fall into a status of Grace, then if renewed they are current again or after 31 July they fall into expired member status.


How do I access the JavaScript API via a WordPress theme template?

One way would be to write your own AJAX handler in the usual WordPress way and then grab the event list via the CiviCRM API. Untested pseudocode:

// add AJAX functionality
add_action( 'wp_ajax_my_civi_get_event_data', 'my_civi_get_event_data' );
add_action( 'wp_ajax_nopriv_my_civi_get_event_data', 'my_civi_get_event_data' );

/**
 * Get data from CiviCRM
 */
function my_civi_get_event_data() {
    civicrm_initialize();
    $civi_data = civicrm_api( 'event', etc etc );
    $data = my_process_civi_data( $civi_data );
    echo json_encode( $data );
    exit();
}


Occasionally WordPress plugins can interfere with user account creation. Have you installed any spam prevention plugins recently? If so, try turning it off and seeing if the user creation option shows up on your profile.

The reason this isn't working with WordPress demo site, is that User Creation is turned off on all demo sites. You may want to check that this is enabled on your own site as well.


Limit access to form to authenticated users?

At the bottom of the profile settings page, there's a collapsed advanced section. There you can limit it to a group.


I happen to have written an extension called the "organisation name de-duplicator". It works by doing certain REPLACE()ments on the names and seeing which ones come out the same. It hasn't had much attention for a while but more rules could be added.


Redirect with a QUERYSTRING help - migrating site

Apparently my above code was correct, save for I was putting it in our main directory's htaccess file. Once placed in the subdirectory's file (and "sub_dir" removed) all is right!


CiviCRM_API3_Exception: "API error: DB Error: already exists"

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.


Report containing groups and the key contact details for that group

I presume that your key contacts are linked to the group by a relationship?

If so, I would suggest that you use advanced search to find the related contacts. You can do this by selecting the appropriate Relationship Type in the Relationship section.  This will be something like 'Key contact for' (depending on how you have named this relationship).

You can then export the search results by clicking on Actions > Export contacts.

Read more in the manual: Searching


CiviEvent events partitioned by domain in WordPress multisite

I wanted to post a belated update here, in case it helps someone else or could trigger additional discussion or action. Per Jon G, I emailed CiviDesk and got a prompt response:

  We have developed multisite support for events in CiviCRM, and it has
  been in production for several years now with one of our largest
  customers. The code is public, but not documented or guaranteed and
  delivered as-is, without any support from us.... It is available in
  https://github.com/cividesk/civicrm-core/tree/4.7.31-cividesk-arcs, it
  contains a lot of patches in addition to just the multisite changes.
  We will be migrating this customer to CiviCRM 5.7 ESR in H1 2019, and
  port all to this newer version then.

CiviDesk further clarified that the customization does not currently include 'packaging' for this feature (i.e. setup screens, documentation, test suite, ...). It cannot become part of the official CiviCRM release without these. If there were interest and funding (via a "Make it happen" project or similar), they could move forward on this.

I had hoped to dig into the code to explore further, but haven't yet because of limited time and other priorities. For the short term, we're using a WordPress-only multisite compatible events management solution. For the longer term, a solution integrated with CiviCRM would be preferable. With guidance from more experienced Civi developers, I'd be willing to pitch in.


Integrating CiviMail tracked links with Google Analytics

It's possible to add tokens to a url - I was concerned that the token wouldn't get replaced before CiviCRM sets up the redirect url for tracking links. I've tested this and the token is replaced first, so it's possible to use tokens in a correctly formatted GA campaign url (using https://support.google.com/analytics/answer/1033867?hl=en ) that's still tracked by CiviCRM.

I haven't done this with a 'real' mailout, just test runs - I've various things to sort out on the Google Analytics end, and will update this answer if anything relevant arises.

Obviously there are privacy issues about sending contact info to Google - I'm probably just going to use the CiviCRM ID, but if anyone has any recommendations about which tokens would add value to GA data, do let me know.


Contact type is read only in contact summary

It isn't allowed and with very good reason! People do not morph into organisations (in my experience), therefore a CRM does not allow it. What is the problem you are trying to solve? Bad import?


So this was my solution.  Using Wordpress triggers, its fired off whenever an order is submitted and successfully paid.  If it contains the product to create new/or renew then.  I hope it helps someone.  I still need to add some error traps, otherwise should work fine for my setup.

 # Product ID for the registered participant is noted below
 #error_log("Line items: $item\n");
 if ($item["product_id"] == 33706) {
     $result = civicrm_api3('Membership', 'get', [ 'sequential' => 1, 'contact_id' => $contactid, ]);
     if ($result["count"] == 0) {
         #create new membership entry
         #start date/end date will be today to 1 year out
         $start_date = date("Ymd");
         $end_date = date('Ymd', strtotime($start_date. ' + 1 year'));
         $result = civicrm_api3('Membership', 'create', [ 'membership_type_id' => "Registered Participant", 'contact_id' => $contactid, 'start_date' => $start_date, 'end_date' => $end_date, 'source' => $item["order_id"], ]);
     } else {
         #renew membership
         $current = $result[values][0];
         $current_start_date = $current['start_date'];
         $current_end_date = $current['end_date'];
         $membership_id = $result['id'];
         if ($current_end_date < date()) {
             $new_start_date = date("Ymd");
         } else {
             $new_start_date = $current_end_date;
         }
         $new_end_date = date('Ymd', strtotime($new_start_date. ' + 1 year'));

         $result = civicrm_api3('Membership', 'create', [ 'membership_type_id' => "Registered Participant", 'contact_id' => $contactid, 'start_date' => $new_start_date, 'end_date' => $new_end_date, 'source' => $item["order_id"], 'status_id' => "Current", 'id' => $membership_id, ]);
     }
 }


What is the latest version of CiviVolunteer?

I think there is confusion on release date. Version 4.7.31-2.3.0 was released on March 2018 not March 2017. I guess the maintainer forgot to update the year to 2018 in info.xml file.

HTH

Pradeep


Contribution page validation errors display and confirmation screen switch to default language instead of remaining in the current language

This was a configuration error on our part. Clean URLs was not fully functional - the language prefix was missing from the beginning of non-clean URLs so the final URLs were resolving to only the default language.

Adding $conf['clean_url'] = 1; to the settings file resolves the issue.

Thank you @bgm for helping with the demo site so that we could narrow this down to an issue with our site specifically.


Why are cv php:boot calls failing only when running unit tests and not through direct CLI calls?

I found the answer: I was using a backup: the CiviCRM unit test framework uses files and services not found without doing a git clone (or buildkit equivalent). The folders you need from a git clone are Tests and Tools.
Leaving this here in case it assists someone who encounters the same problem.


Agreed on your suggestion -- the notification post usually does have a link to the fixes.  Here are the issues with a fixed version of 4.6.15:

CiviCRM issues fixed and closed for 4.6.15


I would do this with CSS. For a text element to wrap, it needs to have a width set. Something like:

.crm-event-label {
        width: 500px;
}

(To include Custom CSS, point to a .css file via Administer > System Settings > Resource URLs)


finding members without e-mail addresses

Rather than is empty try using is null in your search.


Query to get a list of contacts not tagged with a tag, but the user has multiple other tags

I don't know how this would translate to Drupal Views, but here is the SQL to do it:

SELECT
  contact.id
FROM civicrm_contact contact
LEFT JOIN civicrm_entity_tag et ON
  et.entity_table = 'civicrm_contact' AND
  et.entity_id = contact.id AND
  et.tag_id = 1 /* ID of the tag you want to exclude */
WHERE et.id IS NULL;

Note that et.tag_id = 1 must be in the ON clause and not in the WHERE clause.


How do i list upcoming events publicly using CiviCRM in Wordpress

I suggest you install the CiviEvent Widget.


How to update changes in a custom base Mosaico template?

When i was building custom templates, clearing browser cache mostly worked. My favorite is to use Ctrl+Shift+R.

And in the UI - I would try creating new template from the base.

An already saved template may not reflect your changes, because saved blocks also store css information and may not use the new one. However any new blocks or deleting a save block and re-creating might work.

Also keep an eye on console for any JS errors before and after your changes. Sometimes even simple css changes break the knockout js, and may not reflect.

Hopefully that helps.


All those strings should be in transifex (and compiled in the .mo files).
Please keep in mind that the string might contains HTML and what you see as one big paragraph on the screen might be in fact be a concatenation of several strings.

For example, your first example is in fact 2 separate strings in transifex (and the second one contains HTML) :

    $statusMessage = ts("It looks like you are already registered for this event. If you want to change your registration, or you feel that you've gotten this message in error, please contact the site administrator.") . ' ' . ts('You can also register another participant.', array(1 => $registerUrl));

You can find those string (for fr_CA) here :

https://www.transifex.com/civicrm/civicrm/translate/#fr_CA/event?q=It looks like you are already registered for this event
https://www.transifex.com/civicrm/civicrm/translate/#fr_CA/event?q=register another participant

If after looking in transifex, you can't find the strings, it might be three different problems :

there is a missing ts (translation function) in the code, meaning there is bug that should be mentioned in the issue tracker (gitlab)
the string is a new one or has been changed and transifex is not yet up-to-date
there is bug with the string extractor

Once you have updated the string in transifex, you need to extract po files and compile them or wait for the automated process to compile them for you (once a day) -> http://download.civicrm.org/civicrm-l10n-core/mo/fr_CA/civicrm.mo (replace fr_CA by your locale)


How to extend Database Log Report from Contact

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

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


Setting Up CiviEvent to Manage Two Side by Side Events with the Option of Registering for Both

Have you tried Webform CiviCRM module? It will let you add multiple CiviEvents as simple checkboxes, set fees, assign discounts based on conditionals, sign up multiple participants, relate them to each other all on one page.


In what circumstances is it safe to automatically de-duplicate contacts?

As soon as you automatically "merge", it will never be 100% safe. If you want to be sure, never dedupe (ie put dedupe rules that are not possible to match) and ask your users to login.

Obviously, it means that you will end up with tons of duplicates, so in practice, you will need to relax the rules and accept that you might have two different persons that end up merged in the same contact. This isn't as bad as it sounds, and it happens with every shared list of items that several people can update, and it doesn't create too much problems.

So your choice is what type of error you want to avoid more: having more duplicates or having more incorrect merges. For what I've experienced, the most relaxed rule is to consider that everyone sharing an address is the same person, and the strictest want the first and last name and email and country.

you might want to add an extra layer of protection if you send emails with the hash token (so your contacts don't have to login and are automatically identified) so they can't change their name by accident with this extension https://civicrm.org/extensions/no-overwrite

And you could enable the detailed logging http://book.civicrm.org/user/advanced-configuration/logging/ so you keep the history of all the changes if you haven't done it already


CiviCRM's authentication is through the CMS - so you wouldn't connect CiviCRM to LDAP, you would use LDAP to authenticate to the CMS.  All CMSes that support CiviCRM support LDAP authentication.

If you would like to use CiviCRM as your LDAP source (e.g. to populate an address book in your email client with CiviCRM contacts) you can use ldapcivi.


this is not something to be worried about. It is a warning that somewhere in the code a syntax rule is not correct, but this does not affect the actual processing. You should be worried if you get a yellow message with 'Error', 'Notice' is irritating but nothing to get worried about.


Lesley,

This is set in php and then assigned to tpl. It's being set from two places CRM/Contribute/Form/Contribution/Main.php and CRM/PCP/BAO/PCP.php. Since its being assigned to tpl through php then its pretty simple and easy to change the text using either preprocess/buildform/postprocess hook by over-riding the tpl variable.

Here are list of lines that uses the variable to print the text

templates//CRM/Contribute/Form/Contribution/Main.tpl:177:    {if $pcpSupporterText}
templates//CRM/Contribute/Form/Contribution/Main.tpl:178:

templates//CRM/Contribute/Form/Contribution/Main.tpl:180:
{$pcpSupporterText}

templates//CRM/Event/Form/Registration/Register.tpl:61:    {if $pcpSupporterText}
templates//CRM/Event/Form/Registration/Register.tpl:62:

templates//CRM/Event/Form/Registration/Register.tpl:63:
{$pcpSupporterText}

If you not familiar with using php then you can JS to replace the text. Here is what i would do

Create a Main.extra.tpl under templates/CRM/Contribute/Form/Contribution/ (custom template directory or extension)
Add below snippet in Main.extra

Snippet:

{if $pcpSupporterText}

    {ts}Text to print{/ts}

{literal}

{/literal}

{/if}

HTH

Pradeep


Database Syntax Error when attempting upgrade

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

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

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

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


I assume you are wanting to require a phone number when some contributes, becomes a member, or registers for an event.

Go to Admin > Custom Data > Profiles

Look for the Profile that you will be using in your Event/Contribution pages and to the right click Fields

You can edit the Phone field and make it Required