Adding contributions doesn't work for certain currencies I noticed importing or adding contributions in Serbian dinars (RSD) doesn't work. I tried using API Explorer to create a contribution that way but I get the same error I get when I try to import contributions.

{"sequential":1,"financial_type_id":"Donation","total_amount":100,"contact_id":2,"currency":"RSD"}

  "error_message": "Currency not a valid code: "

I then tried to find out are there other currencies that don't work and I tried importing a file with donations in all currencies in the civicrm_currency table. It turns out that there three more currencies which don't work.

The currencies affected are:

Serbian Dinar (RSD)
Venezuela Bolivar (VEF)
Azerbaijanian Manat (AZN)
Mozambique Metical (MZN)

When I try to add a contribution manually through the form using these currencies, CiviCRM disregards my selection and uses the default currency.

There is a workaround. You can set any of these affected currencies as default, and then leave the field for currencies blank for that currency when importing (or leave default when adding a contribution manually). CiviCRM will then assume you are using a default currency and import or add it correctly. Still there's a problem if you want to use other currency for default (USD for example) and add contributions in affected currencies.

What could be causing this?

I'm using the current version of CiviCRM (4.7.29)

This was curious, so I tracked it down.

Apparently the list of valid currencies predates the civicrm_currency table.  So right now the valid currencies are hardcoded - you can see that in <civiroot>/CRM/Core/Pseudoconstant.php around line 1077 - the currencyCode() function.

As a quick workaround, you could add your currency to the list.  However, the correct solution would be to modify this function to return the result of SELECT name FROM civicrm_currency.


CiviCRM Wordpress Installer Database Instructions incorrect? Instructions were here: https://docs.civicrm.org/sysadmin/en/latest/install/wordpress/

I downloaded the zip to my local computer, then ftp uploaded it to my web server. I created the /wp-content/plugins/files/ directory and ensured it is writable.

I'm not using Localization so I skipped that section.

I then enabled the CiviCRM plugin and ran the installer. I filled in the database settings, and it continued on with the Check Requirements and Install CiviCRM which completed successfully.

The part I don't understand is that the installer assigns a database administrator name and password, however the password is starred out ***** so I do not know what it is. I don't get the point of this, how can I possibly maintain or recover the database if I don't have the password credentials???

I thought that after the install it would email me those credentials but it appears to be top secret so that even me, the administrator, cannot know it. How do I obtain this password?

This is the MySQL password and not the WordPress administrator password.  If you used the same MySQL database for WordPress and CiviCRM, check wp-config.php in the root of your WordPress installation to find the password.

If you used separate databases (or you're not sure), find civicrm.settings.php.  On a new install, this should be in <webroot>/wp-content/uploads/civicrm.  Open it in a text editor and look for a line that looks like:

define('CIVICRM_DSN', 'mysql://<mysql_user>:<mysql_password>@127.0.0.1:3306/<mysql_database>?new_link=true');

The password should be everything after the second colon and before the @ sign.

Note: there's a very similar-looking like that starts with:
define( 'CIVICRM_UF_DSN'.  This contains your WordPress connection info and not your CiviCRM connection info.


how do I best configure this complex event registration scheme? My organization will be hosting a large conference in a couple of months. For this event, we need several kinds of participant roles. Some of these roles will have special conditions. I have laid them out below.

We'll need:

Attendees

We'll need "early bird" and late registrations.

Speakers

No fee for speakers

Staff

No fee for staff

Several vendor tiers

Platinum

Most expensive tier. Comes with 2 free registrations.

Gold

Less expensive tier. Comes with 2 free registrations.

Silver

Less expensive tier. Comes with 1 free registration.

Bronze

Least expensive tier. Comes with 1 free registration.

We're also offering a banquet during this event. Each registrant needs the option to be able to bring +1 to the banquet for an extra fee.

How can I go about creating this registration scheme?

I would approach this roughly as follows:

Early bird registration fees can be handled either through the standard pricing options or using a price set. given that you want to have the additional banquet option using a price set would be the way to go, and simply set the start and end dates for your price fields accordingly.

All of the participant roles that you have defined can be handled in one of two ways: Either register all of these people via the back end so that you have control over whether they pay or not. Or, if you want them to register themselves through the website then set up suitable discount codes (using the CiviDiscount extension) and distribute those codes accordingly.


Creating Event Participation Certificate in PDF I've seen posts with something similar but I am a bit lost. What I am trying to do is to add some automation in creating certificates to participants of an event.  Our events are training sessions and we issue a certificate to those that attend.  Here is what I'm trying to accomplish:
User is registered to attend the event
At the conclusion of the event, we confirm registrations to those who actually attended. We update the records to those as "Attended".
Those that "Attended" would then get a certificate e-mailed to them.
Our certificates have a certain format with a border and a paragraph about the program. There is also a signature image on the certificate.   Is there a way to have this certificate template in CiviCRM and with "Display Name" as a token and have the certificates generated from the "Attended" list and then e-mail them?  It would be similar to PDF receives and PDF letters...just a preformatted certificate.

If you’re on Drupal then you can do this with Views Integration -> here is a tutorial with steps and screenshots on how to create a downloadable Hogwarts Certificate:
How can Members download their own Membership Certificate/Card?
Instead of pulling in Membership data -> pull in Event/Participant data and status.


How do I create multiple records fieldsets for contacts? I think this is a simple question, only i can't work out the answer!
How do I create multiple record fieldsets? Your help is much appreciated,

Cheers,

Kate

When you create the custom field group, you select Contact, and then click anywhere and you should see a field pop in to view re 'multiple

See

And once you have added the Fields too, then you should see something like  on a contact record. (Grabbed before demo gets flushed)


CiviMail mailing sent to an Opt Out email A contact who is marked as Opt Out is still being sent monthly newsletter. They opted out of all emails 3+ months ago but continue to be on sent emails. They have also unsubscribed from the group.

If you are reusing an old email or even just reusing last months which was a copy of the previous month and so on, check to make sure your include list does not have any previous mailings included.

As oppose to "Members of GroupName" it will be listed as "Recipients of OldMailingName"

Recipients of prior emails don't go through the same Opt Out check as a mailing group would. This feature should not be used to major big or regular mailings.


I am to install CiviCRM on Windows 10 with WAMP I have been trying to setup CiviCRM on Windows 10,  But I am not able to install "bin/civi-download-tools" on it. Even I have installed and enabled Linux subsystem tools on windows.

Please guide me as I am to complete my test.

BuildKit does not work on Windows at present - CiviCRM BuildKit makes many assumptions about what tools and environment it has access to and at this time it is not Windows compatible.

It could be made to be so but the ease of setting up a Linux VM in Windows and the ever-improving "Windows Subsystem for Linux" make it unlikely that any explicit efforts are going to be made to make BuildKit natively support running on Windows/WAMP stacks.


How can I track down a script or form that's generating empty contact records? Every 10-15 minutes a new, (almost) blank contact record is being generated in civi. The only clue I have is that the blank record is subscribed to our mailing list. Any ideas?

Is it always exactly the same number of minutes?
If yes: could be cron related

If no:
sounds more like a spammer. I would first look in apache/nginx logs and try to find at the time the user is created what exactly happened, which requests are done. First try to get the IP address of the visitor that entered the webform, then search through logs with that IP address and see what it does exactly. Is it the same IP address doing all the submission or not.
That could lead to clues of what to do.

It definitely makes sense to apply anti-spam techniques to your site.

Mollom (https://www.drupal.org/project/mollom)
Http:bl (https://www.drupal.org/project/httpbl)
Google Recaptcha (https://www.drupal.org/project/recaptcha)

Are all techniques that can be applied to drupal and webforms


Reason for no Views Relationship from CiviCRM Contact to Event Participant I am trying to write a Drupal View (with VBO) to show CiviCRM Contacts with the Event Participant records which they are related to.  But there is no suitable Relationship in the standard list.  I have enabled both Contact and Participant (and Event) entities in Civicrm_Entity, and would presume that this is where the Relationship would be generated as well.
I can use the hook_views_data_alter() to create the Relationship, so there is no fundamental reason why it should not work.
Is there a reason why Civicrm_Entity does not provide this, or is it a bug?

We do have D7 VBO Views like this for clients -> key is to start with a CiviCRM Participant View - so that the base table is civicrm_participant - from there you can add a Relationship to the Contact to get at the Contact fields like Last Name etc.
Note there there is a bug in the API in that after updating participant status. It will change is_test to = NULL and that removes the Participant record from the CiviCRM UI.
One solution that jackrabbithanna pointed out is to expose the is_test field as well and then specifically add 0. I've not tried that yet though!


Event Report missing info I set up an event and asked participants to answer a few questions.  How do I pull a report for my event with the answers to the questions?

If you used custom fields to store answers for the questions than you can use Event Participants List( CiviCRM >> Reports >> Event reports) report to get all the information gathered for the event.
Note: Make sure you have is searchable option turned on for all the custom fields you need to be available on report or search.


Can CiviCRM be integrated with a VoIP system? Who's done it and what advice do you have?

The closest we have in our docs is integration w/ SMS as per:
https://docs.civicrm.org/user/en/latest/sms-text-messaging/set-up/

This documents the integration w/ Twillio and Clickatell.

At the extension level, you'd find a few here: https://civicrm.org/extensions?title=&body_value=phone&field_extension_civi_use_target_id=214&status=All&field_extension_ready_value=All

You probably want to play around with the value in the description field (I've got "phone" in there). There are maybe 6 or so extensions that provide some level of integration w/ external systems.

The best advice is probably to narrow down the scope of your question, and focus on what you are trying to achieve rather than a general question about technology that can be used for various different purposes. "Integration" is primarily a word for sales and in real life can mean many different things.


How many organizations use CiviCRM? This is a minor issue, but the count of organizations using CivCRM that is displayed on my civi home page seems to bounce around quite a bit.  For a time it showed numbers over 10,000.  Just now it says, "Used by over 6,273 organizations ..."  Last week I am pretty sure it was even lower but I did not record the number.
The 2015 blog post on this topic said, "There are close to 9,000 nonprofit or governmental organizations worldwide relying on CiviCRM ..."
The updated widget on the same page reports 11,061 organizations as of June 5, 2017.
Just wondering if actual usage varies that much or if the measurement technique needs work.

I am the maintainer of the statistics for CiviCRM. There are between 10,000 and 11,000 organizations actively using CiviCRM at the moment. We suffered a hardware failure on the stats server hence the little fluctuation. The statistics will soon be back to normal. More information at https://stats.civicrm.org. Thanks.


Setting USPS and recaptcha overrides breaks site I've successfully set several overrides in civicrm.setting.php according to https://docs.civicrm.org/sysadmin/en/latest/customize/settings/. However, both Recatpcha and the USPS Address standardization tool break the site. Setting USPS provider line does work.

I'm doing this on a WP multisite on CiviCRM 5.20.0.

// Set USPS standardization
$civicrm_setting['CiviCRM Preferences']['address_standardization_provider'] = USPS;
$civicrm_setting['CiviCRM Preferences']['address_standardization_userid'] = ***;
$civicrm_setting['CiviCRM Preferences']['address_standardization_url'] = 'http://production.shippingapis.com/shippingapi.dll';

// Misc
$civicrm_setting['CiviCRM Preferences']['recaptchaPublicKey'] = ***;
$civicrm_setting['CiviCRM Preferences']['recaptchaPrivateKey'] =***;

My syntax was wrong I needed to use tick marks around the values.


Upgrade URL not working. Drupal7 I have civicrm on a local server using Drupal7.
I have had the same issue with every recent upgrade.
The SysAdmin manual contains the following url to update the database following an upgrade:
http://example.org/civicrm/upgrade?reset=1

In my case I am using a local fileserver so this becomes:
http://myserver/drupal/civicrm/upgrade?reset=1
This has not worked for me on a number of upgrades which resulted in me finding a different method by mistake. (honesty).
The url I have now used successfully is :
http://myserver/drupal/index.php?q=civicrm/upgrade?reset=1

suggesting the following generic url
http://example.org/index.php?q=civicrm/upgrade?reset=1

So my question is whether there is an error in my original install which is causing the documented url not to work?

Your local server probably isn't configured in a way to allow for "clean urls". See https://www.drupal.org/docs/7/configuring-clean-urls/enable-clean-urls


First colums of Form not translated I've a problem with my fr_FR translation on CiviCRM 5.20.2. for Wordpress.

On forms, the first colums is not translated and some Yes / No in the second column above image).

An idea on the way to slove this issue?

Many thanks by advance!

MG

UPDATE: All the admin forms have now been made available for translation but they aren't all in transifex yet because it only has strings up to version 5.22 as of today and the latest changes will be in 5.23. So it may be a few months before they'll be available in transifex for translation.

A while ago the admin forms settings started to get moved to a different subsystem, and a note appears to have been made that they should take translation into account (the last bullet point here https://lab.civicrm.org/dev/core/issues/495#note_10020), but if you look in the <civicrm_root>/settings you can see that some title strings in the files are wrapped in ts() but some are not. It is of course ironic that the ones in the localization file are not.

Some of the strings on that page are translated, because they are still handled by the previous system, e.g. Monnaies Disponibles, because it's a fancy multiselect widget.

EDIT: After looking closer at https://lab.civicrm.org/dev/translation/blob/master/bin/create-pot-files.sh and the admin screens, it seems like the settings folder isn't included in the files that get scanned. It's just that some strings, like "Recherche de contacts avec autocomplétion" on the search preferences screen, appear to be translated because they are used elsewhere too. So I've posted on the lab ticket to get clarification.


CiviCRM + Webform + Paid Events - no price displayed in table I'm using Webforms for events because I have a parent/carer booking up to three children onto a holiday club.

I am struggling with the price. I have a contribution page set up (I've tried with and without a price set), and I have the Participant fee exposed with the values defined (user select: 1 day, 2 days or 3 days).

When I click 'Next' to display the contribution page/table, it always says 0.00 with no row in the table to display the price of the event registration. I can't see anything similar online and I'm not sure what I'm missing?

Possibly a separate issue: I'm using PayPal Standard as the payment processor but when I 'Submit', it' doesn't go to PayPal's website to take the payment. Is it compatible yet?

If I add a 'Contribution Amount' field, it adds that to the table - in the meantime, I'm using conditionals to populate this field. I wasn't expecting to need that field.

Some thoughts:

ad $0 ->

do you have the Event (in CiviCRM) configured as an is-paid event?
are you already registered perhaps? It is clever enough to know you
do not need to pay again. So you'll be deleting your Participant records lots when you're testing a Webform CiviCRM that has an Event enabled;

ad on building your Participant Fee ->

create regular drupal select and/or checkboxes to gather the data you need to build the Participant Fee Then use Conditionals to say:
if select = full day (example) and category = student -> then Participant Fee is set to: $50;
if select = half day (example) and category = student -> then Participant Fee is set to: $30;
if select = half day (example) and category = regular -> then Participant Fee is set to: $90;

Key is you need to build your own Participant Fee - of course this is also what gives you huge flexibility as to what you can create.

I have some code in testing/review that will check the priceset that is configured on a contribution form in order to create lineItems with the correct price_field_value_id - that's critical financial types (and thus sales taxes to be applied properly), under some conditions. You'll know what I mean when you do encounter it yourself. It's the first bit we actually do with priceset configs in Webform CiviCRM.

What you can (recently) do is add more lineItems to a contribution [purchase calendar + make a donation scenario] - and it will create a contribution with two lineItems - priceset like. But for Event fee you can build the conditionals - and even add in discount codes - as I've illustrated here: How can I emulate a CiviDiscount when using Webform CiviCRM?

I hope that helps you along. If you have any further questions don't hesitate to ask.


How do I set the default font type and font size in ckeditor configuration? I'm trying to configure a site so email messages (Contact>send an email) default to Arial- 12 point.

I can see the CK Editor config options in Display preferences, but am struggling to decipher the linked API documentation.

Anyone give me a clue?

Cheers!

Maybe not quite what you are looking for, but I forced font size in a letter by adding a  tag in a message template. I had it put it into {literal} {/literal} (to escape the smarty processing if I remember correctly).

If you wanted that to apply more generally, maybe you could put it in a header.


Search by radius to postal code or zip I tend to do a lot of roster pages on Drupal + CiviCRM sites (Drupal Views, exposing CiviCRM contact record fields). One of the search filters I'd like to try would be to allow visitors to enter a postal/zip code and then have results from contacts that are located in a radius to the postal code. I know CiviCRM has some ability to geocode contact addresses. Is there any way we can harness the goecoding into a postal/zip filter for this type of search?

I have recently updated the module to allow a map and use your location. More info can be found here - https://civicrm.org/blog/anil/drupal-views-civicrm-contact-distance-search-with-a-map


DB Error: constraint violation when a member renews online In the following from the ConfigandLog, log, the value of group_id is given as 13 when it should be 9. In civicrm_groups there is NO 13 but in civicrm_custom_group there is.

Aug 29 20:25:14  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => exceptionHandler
        )

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_subscription_history (contact_id , group_id , date , method , status ) VALUES ( 4405 ,  13 ,  20160829202514 , 'API' , 'Removed' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`gsv10274_04`.`civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE)]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_subscription_history (contact_id , group_id , date , method , status ) VALUES ( 4405 ,  13 ,  20160829202514 , 'API' , 'Removed' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`gsv10274_04`.`civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE)]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO civicrm_subscription_history (contact_id , group_id , date , method , status ) VALUES ( 4405 ,  13 ,  20160829202514 , 'API' , 'Removed' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`gsv10274_04`.`civicrm_subscription_history`, CONSTRAINT `FK_civicrm_subscription_history_group_id` FOREIGN KEY (`group_id`) REFERENCES `civicrm_group` (`id`) ON DELETE CASCADE)]"]

)

Why is Civi using the wrong group ID?
Is this causing the fatal error?

this looks like some custom code you have setup which is passing through the wrong group id. Its indicated by the API identifier in the failure. I would check what custom code you have and establish where group 13 is being passed in, you could turn on the backtrace recording so that the exact source can be determined.

The other thing to check is that the contribution page is set correctly in the section where contacts are automatically added to groups. Someone may have set it there and subsequently removed the group.

Either may cause this issue.


How to access images on server for CiviMail I added images to the server via CiviMail (KCFinder).  But when trying to use the UI to insert an image and click "Browse Server" I receive an "Unknown Error". None of the images are displayed. I'm unable to locate the images and insert them into a new mailing. Already checked the Resource URL and Directories. See image attached.

CiviCRM 4.7.11 and WordPress 4.6.1

You may want to check Firewall or the settings in WPSecurity (plugin) if you have that installed.  I ran into this problem and it was an option in WPSecurity for "Bad Query Strings" which blocked access to thumbnails in KCFinder.

According to the plugin... Deny Bad Query Strings

  This feature will write rules in your .htaccess file to prevent
  malicious string attacks on your site using XSS. NOTE: Some of these
  strings might be used for plugins or themes and hence this might break
  some functionality. You are therefore strongly advised to take a
  backup of your active .htaccess file before applying this feature.


How to check WHO creates a certain contact I can´t see anywhere who is the creator of a particular contact in CRM. I can see the last update of that contact but not what user created which contact.

How can I do this?

Thank you!

You can find this information in the Change Log for the contact.

It will be the earliest entry in the change log.


Best practice for sending a notice about an upcoming recurring contribution We have a contribution page that creates automated recurring contributions on a yearly basis.
Because 12 months is a long time to remember that you have a recurring contribution set up, we want to send out a courtesy email 2 weeks before to let people know that we are going to take a payment and give them the opportunity to cancel it if they want to.
Is anyone else doing this? How do you do it? A scheduled reminder based on civicrm_contribution_recur.next_sched_contribution_date would be nice but I know that isn't possible at the mo. Are there any other ways people are doing this?
PS. I know that we could use membership end date if they were members but we don't want to go down that route - we want to tie it to the recurring contribution.

CiviRules + emailapi extension. Scheduled reminders is too inflexible as you can't control the criteria - with CiviRules you can build in whatever conditions you like.
Looks like you'd need to add a new "CRON trigger" to CiviRules for recurring contributions but we already have that for activities and for memberships so would be pretty easy to do and will help a lot of people.
With that you can build "reminders" that can target specific paymentprocessors, specific contact types etc.


Forward CiviEvent Registration Confirmation and Receipt Apologies for such a basic question but I can't figure out how to do this. I want to forward the CiviEvent Registration Confirmation and receipt to a different email address than the email of the person who registered. I tried editing the event registration and going through the activities of that person and I'm not seeing where I could do this.

You can include additional email address in the CC or BCC field while configure the event. On the “Online Registration “ tab, at the very bottom, in confirmation email section.


Different Contacts of same child Group in multisite I use a multi-site CiviCRM installation with the CiviCRM Multisite extension installed and tuned : having Multi Site Configuration enabled and each site set with a Domain Group.
I set all the proper user's roles in the Drupal permission page for each domain (use of domain access in Drupal 7).

But I struggle with the use of sub-groups.

Let's consider that for the site A-site, the Domain Group is A-group, and for B-site the Domain is Group B-group. Both A-group and B-group are parent group for a same child group C-group.

In one exemple that I have, a C-group that is shared group between different two sites shows a very different number of contacts : one gives 1488 Contacts and the other only 42 Contacts…

Site A > Domain Group is A-group > is parent of C-group > 1488 contacts

Site B > Domain Group is B-group > is parent of C-group > 42 contacts (The site B has no access to the missing 1446 contacts)

I cannot explain why there is a difference of contacts that belongs to C-group depending on they are on the A-site or the B-site.

The 42 contacts belongs both to B-group and C-group, the missing 1488 Contacts belong only to C-group.

The CiviCRM Multisite doesn't consider a shared sub-group between sites ?
What is the criteria for a contact to belong to a site or another ? Should I understand that to belong to a (same) sub-group is not the condition to belong to a site ?

Is there a way to include in the selection process the use of sub-groups (child groups) ?

We totally gave up on using sub-groups with the CiviCRM Multisite. This is too bad but really this seems to be far too complicated and very risky. That would also damage the work of people using different sites.
We use only the Domain Group S-group for Site S to be sure we have the right contact in the right site.


Can Wordpress handle multi-site CiviCRM the same way Drupal 7 with domain access does? My organization is currently running a multi-site CiviCRM deployment on Drupal 7 using the domain access module.

We set permissions on the contacts by using the state field so that the leadership in a state can only see that state's contacts.

Some states also have home pages with custom content and menus, but use the bulk of the national web site as "background" content.

The above configuration has served us well for several years now, but we keep getting push back from states that Drupal is too hard to use and people aren't posting content for that reason.

Can we replicate this same functionality on the WordPress platform? If not, how close can we get?

Yes - this can be done - you will find instructions on how to integrate Civi with a WordPress Multisite installation HERE.

Hope this helps!


Mailing - "Send Test" button not a button When trying to send a test mailing, the preview and test email box appears to be improperly drawn and the "Send Test" button doesn't appear to work.
I tried upgrading CiviCRM (from 4.6.2 to 4.6.4) but the problem persists.

CiviCRM 4.6.4, Wordpress 4.2.1, Apache 2.4, PHP 5.6.9-1, Mariadb 10.0, Debian Wheezy/Sid hybrid

I notice this was an issue in the beta forums previously
http://forum.civicrm.org/index.php/topic,33598.msg142461.html#msg142461

Any ideas how to fix it?

They are disabled. Notice that the "Next" button is also disabled. This means that you have not completed all required fields for your mailing. Please review that you have:

A subject
Recipients
Content
Required 'opt out' tokens


Report based on country Could anyone tell me how to set up a report based on the country of the member (Northern Ireland, Republic of Ireland, England, Wales, Scotland).

Thanks in advance
Debs

Welcome to CivICRM SE! You can get a report for the Republic of Ireland using the standard reports and filtering on Country, but CiviCRM doesn't have a field for the countries withing the UK by default. I don't think it would make sense to edit the Country field in the postal address unless you will never have any postal addresses outside the UK/ROI.

You will have to create a custom field for this. Obviously you can enter this manually when you set up the contact. You could populate this automatically from the postcode, but this would require some lookup from postcode to UK country (for example https://www.robertsharp.co.uk/2017/08/09/a-table-that-shows-the-uk-region-for-all-postcode-districts/ has the mapping) so would require some coding. There is a postcode lookup extension https://civicrm.org/extensions/uk-postcode-lookup but I think that's for looking up addresses and won't provide the UK country. Also be aware that postcode isn't the same as administrative area. For example Hay-on-Wye is in Wales, but has an English postcode. Hope that helps.


Error on running cron job for mailing process on CivicRM 4.7.8 Running the php cli for the mailing process, got the failure

Entity: job Action: process_mailing
Summary
Finished execution of Send Scheduled Mailings with result: Failure, Error message: API permission check failed for Group/get call; insufficient permission: require access CiviCRM
Details
Parameters parsed (and passed to API method):
a:1:
Unknown macro: {s}
Full message:
Finished execution of Send Scheduled Mailings with result: Failure, Error message: API permission check failed for Group/get call; insufficient permission: require access CiviCRM

Here is my command for the cli

php ../administrator/components/com_civicrm/civicrm/bin/cli.php -u user -p password -e Job -a execute

Running manually from the schedule job, CiviCRM » Administer CiviCRM » Scheduled Jobs,
there is no failure

Similar problem/bugs has been mentioned here CRM-17968 (fixed 4.7.4)

I saw that the fix already patched in the civicrm 4.7.8. but the problem still persisted, and i did not yet found the solution.

Thank you

Check that:

your command line specifies the -s parameter, as it is used by CiviMail (cf. https://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs#ManagingScheduledJobs-PHPclimethod)
the user/password pair on the command line is for a valid Joomla user (log into the website with this exact username and password)
that this user has at least the Access CiviCRM and Administer CiviCRM permissions in Joomla


SMS not working on 4.6.2 Updated to version 2 of the extension.  Messages not being delivered.  Manually executed.  Will clickatell extension work on 4.6.2?
Success is reported but message never sent.  Here is error from the log:

May 19 04:24:40  [info] $Fatal Error Details = Array
(
    [message] => Unknown extension: org.civicoop.smsapi
    [code] =>
    [exception] => CRM_Extension_Exception_MissingException Object
        (
            [errorData:CRM_Core_Exception:private] => Array
                (
                    [error_code] => 0
                )

        [cause:protected] =>
        [_trace:PEAR_Exception:private] =>
        [message:protected] => Unknown extension: org.civicoop.smsapi
        [string:Exception:private] =>
        [code:protected] => 0
        [file:protected] => /home/depot/public_html/drupal/sites/all/modules/civicrm/CRM/Extension/Container/Collection.php
        [line:protected] => 143
        [trace:Exception:private] => Array
            (

have you installed this extension

Could you download and install it manually and report if it works? Its configuration file hasn't been updated to say it's compatible with 4.6, but we will do it once you confirm if works well.


Special search problem I have input around 1000 contacts from a specific country. Most of these are already in groups. I want to create a group for contacts from that country that are not yet in a group. How can I do that? I could not find a way to search for them.

I've done this sort of thing by using the Include / Exclude custom search (Search => Custom Searches => Include/Exclude Contacts in a Group/Tag)

Include a group that has all the contacts that you're looking at.  In your case you may need to create a smart group that has all the people in the country.  Then in the exclude list all the groups that they should be/could be assigned to.  Search.  You'll be left with all the people in the country to don't belong to any of the groups you listed in exclude.


Payment options do not display when https used only when http used I'm using CiviCRM on Joomla.
Under http Membership and Event Registration pages are displayed completely including Payment Options (pay later is enable and Standard Paypal).

Under https the Payment Options section does not display.

Any hints?

My hunch is that CiviCRM is looking for an AJAX callback with an absolute URL.  It'll go with what's in the Administer - System Settings - Resource URLs, which is in turn influenced by the base URL in civicrm.settings.php.  The solution is to have the same URL, with https, be in effect across your entire site.

For a number of reasons, including potential problems with your session ending when you follow an absolute URL to http from https or vice-versa, you should have your site use a single canonical URL, with everything else redirecting to it.  For example, you might decide that https://example.org is the proper URL.  You should set up redirects in Apache/Nginx to have http://example.org, https://www.example.org, and http://www.example.org all send a visitor to https://example.org.

Read more at https://civicrm.stackexchange.com/a/3233/44


How can I add a banner image in the confirmation email for a particular event? I have already customised the system generated email template with organisation banner & logo, but I am not able to figure out how to add a banner for a specific event which would be different than the generic banner? is it possible to do?

If you want it in addition to the default/generic banner you can probably add it in at the top of the "Thank you and receipting" section of the event.

If you want to use it in place of the generic banner, you may need to customize the template with some If/Then logic, checking the event ID in the smarty template somehow. Here's an example for a Contribution page, perhaps you can do something similar in the Event page. (To find the variables you have to work with, try inserting {debug} into the template and then registering for the event to receive the email with the Smarty variables listed)

EDIT: Default message template can be changed like this

{if $event.id == '36'}

{/if}


Name Badge Date Format In CiviCrm 4.7 Drupal I created a new Name Badge Layout which includes Event End Date. The site language is Italian, so I need the date to be printed as "15 Ottobre 2016", but it comes out as "Ottobre 15th", which does not make any sense.

Where can I change this setting? I looked everywhere but it seems to be hardcoded somewhere and I can't it.

Many thanks.

Ok, I found it.

In CRM/Badge/BAO/Badge.php around line 101 it says:

// hack to fix date field display format
if (strpos($element, '_date')) {
  $value = CRM_Utils_Date::customFormat($value, "%B %E%f");
}

So I just re-hacked the hack and replaced "%B %E%f" with "%e %B %Y".


Building an extention in civicrm. i try fetch campaign base on contact nothing displays while i have records function contactcampaign_civicrm_dashboard( $contactID, &$contentPlacement ) {
// REPLACE Activity Listing with custom content
$contentPlacement = 3;
//(int) CRM_Core_DAO::singleValueQuery('SELECT COUNT(*) FROM civicrm_campaign');
$query = "SELECT id, title, parent_id, status_id, goal_general, goal_revenue
              FROM civicrm_campaign
              WHERE created_id = $contactID";
$campaigns = CRM_Core_DAO::executeQuery($query);

$campaignList ='
';
$campaignList .= '
Title	Contribution Page / Event	Status	Target Amount	Amount Raised	Number of Contributors
';

while ($campaigns->fetch()) {

 foreach($campaigns as $campaign){

    $title = $campaign->title;
    $targetAmount = $campaign->goal_general;
    $raisedAmount = $campaign->goal_revenue;
     $status = $campaign->status_id->title;
     $parent = $campaign->parent_id->title;

    $campaignList .=  '
';
    $campaignList .=  ''.$title.'	';
    $campaignList .=  ''.$targetAmount.'	';
    $campaignList .=  ''.$raisedAmount.'	';
     $campaignList .= ''.$status.'	';
     $campaignList .= ''. $parent.'	';
    $campaignList .=  '
';
 }
};
$campaignList .= '
';

return array (
   'Campaign List'=> $campaignList
);

}

pls i dont know what am doin wrong.

I'd recommend looking into using the CiviCRM API as a more robust way to query CiviCRM data.

Using the CiviCRM API

Check out the API explorer
In your CiviCRM instance you can access the API Explorer. It includes tools to visually generate API queries which would deliver what you're doing there.
For the Drupal CiviCRM demo site at http://dmaster.demo.civicrm.org, the API explorer is at http://dmaster.demo.civicrm.org/civicrm/api/explorer. The CiviCRM demo sites permit you to log in and explore CiviCRM, though you've obviously got a local install (which may not be Drupal).
Using the API explorer, you can build a query which matches your code above in SQL, by selecting:

Entity = Campaign
Action = get
Parameter: Campaign created by, (contact)

The API explorer will show you sample code in PHP, Javascript, and for other interfaces.
API query to match the above
The equivalent PHP code for the above generated by the API explorer is,
$result = civicrm_api3('Campaign', 'get', array(
  'sequential' => 1,
  'created_id' => $contact_id,
));

The $result of this is in the CiviCRM API response format (documentation), which you will iterate through the values of.

CiviCRM API request format documentation
CiviCRM API response format documentation

Why use the API over SQL?

If you're not familiar with APIs, you might ask why you would use the API when you could access the core functions (e.g. the BAO files) or the data in the MySQL database directly?
The answer is that the community will ensure that the API will function as expected with every new release. Great effort is made to preserve backwards compatibility of the API for several versions of CiviCRM. If you decide to use other ways to collect data (like your own MySQL statements), you are left to your own devices. Changes in the schema and BAO arguments, etc. will cause you grief.

CiviCRM API docs - Why use the API?


Civi 5.9 - DB Error: no such table / cannot disable logging Drupal 6 / Civi 5.9 / Aegir

I deleted my log_civicrm_... tables and now am getting a "DB Error: no such table" across a range of CiviCRM actions including adding contacts, running cron etc.

Logging is switched on and I cannot disable it via Administer > System Settings >Misc (...) > Logging).

Is there another way? Is there a table or a file I can edit  or a command I can run to to disable logging?

Try disabling the logging functionality using API Explorer. Navigate from the menu link - Support -> Developer -> API Explorer.

Or using Drush(if drupal) -

drush cvapi Setting.create logging=0


Can Civi/WordPress an Civi/Drupal (same versions) share a database? This would make it a lot easier to manage a transition between an existing Drupal site and a new WordPress site. In my case, all core programs and the existing databases are on the same server. It would sure be nice to just configure the new WP Civi to look at the old Drupal Civi database.

Most of the database table can be shared between the two sites. However, there will/might be an issue with the WP user table and the drupal user table with the civicrm_uf_match table. One potential option might be to ensure that the user ids across wordpress and drupal dont conflict, i.e. choose a high starting point for the WP user table (which is a manual process in mysql)


set minimum or maximum number of tickets a person can buy New to civiCRM so this might be an obvious one but I haven't found he answer as yet

I need to do 2 things with events:

cap the number of tickets one given person can buy for an event. For example, set a limit of 2 tickets per transation, even though the event can be attended by 1500 persons.
Set a minimum number of tickets to be bought. For example, you can buy group tickets if you're in a group of 10 or more. So the minimum number of tickets must be 10 but it can be 11, 12, 13, etc...

Thanks for your help!

Luke

Unfortunately, this isn't functionality that CiviCRM offers "out of the box".  If you're a coder (or have access to one, or hire one from https://civicrm.org/providers) then you can add this functionality pretty easily with hook_civicrm_validateForm to create some custom validation rules.


How to trigger a confirmation email when registering participants via API We have a custom module that we use to do event registrations (non - paid), however i was wondering is there anyway through the API of being able to trigger CiviCRM sending a confirmation registration email when we submit the registration via API?

There is a send email API in an extension that should be able to handle that? Not the automatic sending but you can trigger the API in whatever processing you do. Extension can be found here: https://github.com/CiviCooP/org.civicoop.emailapi


Best way to create a new DB table in an extension with logging In an extension, what is the best way to create a DB table that has a matching logging table? Do we just have to literally create a matching new table with triggers?

There must be a better way?

Per Lobo's comment - the logging triggers & tables are automatically created. But, from experience sometimes you have to turn logging off & on to get the tables created. The triggers seem to create & cause lots of errors which stop when you turn logging off & on.

Obviously the function called by turning logging on is more thorough than the enable extension function


Duplicates being created by Webform Submissions We are seeing issues when users submit a Drupal Webform and accidentally click the submit button twice, duplicate records are being recorded in CiviCRM. This goes for creating 2 of the same contact or assigning 2 event registration to the same contact.

This was never an issue before but seems to have crept in after we upgraded to CiviCRM 5.0.2. We are now on CiviCRM 5.5.3

Using webform_civicrm 7.x-4.21

Any guidance would be appreciated

We’ve come across this issue several times in the past and our solution was to use the below Drupal module –

https://www.drupal.org/project/hide_submit


Is there a list of CiviCRM shortcodes for Wordpress? Is there some list of shortcodes and shortcode modifiers for CiviCRM with Wordpress?

I have put a Civi Profile on a WP page, but I am hoping to hide its title and just use the form fields, but I can't find any documentation on whether this is possible or not.

Going by the shortcode function, there are five possible ways to use the shortcode.

Technically there's only one shortcode used ([civicrm]) but it uses the component attribute to switch between different content.

The five possible components are:

Contribution: [civicrm component="contribution" id="x"]

shows a contribution page specified by the id attribute.
Event: [civicrm component="event" action="register" id="x"] and [civicrm component="event" action="info" id="x"]

shows either a registration or information page for the event specified by the id attribute.
User dashboard: [civicrm component="user-dashboard"]

shows the current user's dashboard page
Profile: [civicrm component="profile" mode="y" gid="x"]

shows a page for displaying a user's profile. This can be one of 4 modes - edit, view, create or search. The default is create. The gid attribute selects which profile group is displayed.
Petition: [civicrm component="petition" id="x"]

displays a petition form specified by the id attribute.

In addition, any of these can specify a hijack option and they will replace all other content on that page rather than being display inline. This looks like hijack="1". A force attribute is mentioned in the code but I'm not clear what it does.

force=1 means it will display the table, force=0 means it will display the search box for the table and you will see the results of the search for the table after you search


What should be best practice when creating custom fields? When creating custom fields, and custom field groups, I have fallen into two pit falls.

First, the name of a custom field should not exceed a certain length, causing malfunction in the SQL structure.

Second, values should be unique. Of course, you would say, but look at this example: values: 1,2,3,4,5,6,7,8,9,10,11,12.
When showing the values in a report, the 2 will show for both 2 and 12, and value 1 will show for 1,10,11 and 12.

The question is, what things should be considered when creating custom fields?

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

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

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

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


Network Error when pushing CiviCRM button I’m having the same issue as what appears to be listed here:

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

I get the same "Network Error" message every time I press the CiviCRM button on the WordPress 'new page' screen when using Chome, FF, and Safari. Perhaps it is an admin or setup error on my part, and not a CiviCRM issue.

I took a screen shot that includes the browser console log if it might be helpful.

Your page edit screen shows (I think) a URL of the form 'http://domain.ca/civicrm/wp-admin...' whilst the 404 error is looking for 'http://domain.ca/wp-admin/admin.php'. This suggests to me that you're using WordPress Multisite with CiviCRM active on a site that is not the main site. This is not supported at present - CiviCRM is only functional on the main site of a multisite instance.

Edit: this URL schema could also be the result of installing CiviCRM in a sub-directory. This is also unsupported, though it's an issue that's being addressed.


"Implode" / "Database Deadlock" errors on Civi Webform Using Drupal 7.69 and CiviCRM 5.20.2, with Webform 7.x-4.21 and Webform CiviCRM Integration 7.x-4.28.

I have a Drupal webform node that uses custom fields from CiviCRM. This webform has been working well but recently a member of the public called and said it didn't let them submit their form. I looked into the Drupal error log and found 7 error messages. Did some searching but couldn't find any solutions.

All error messages located here: https://pastebin.com/A5vn0VWN

I made my own submission on the webform and it went through but I still saw the following message in the error log. Key difference between the error log for the public (failed) submission and my submission is that for both submissions the following error was logged -- for my successful submission, it was logged once, but for the failed submission, it was logged twice. So I feel like this might be important.

  Warning: implode(): Invalid arguments passed in
  CRM_Core_BAO_CustomGroup::postProcess() (line 1494 of
  /MYHOME/FOLDER/public_html/sites/all/modules/civicrm/CRM/Core/BAO/CustomGroup.php).

Anyone know how to fix this (or what the problem is in the first place)? Wasn't able to decode anything from the error log...

The error you're looking at is not the real issue.

The real issue (as showing in your pastebin log) is the deadlocks re: group contact cache.

You may need to rebuild some of your smart groups, or disable them.


Wordpress Theme on Contribution pages I am having an issue with setting what theme/layout is being used on contribution pages. I assume it is using the defualt layout but that ends up allowing sidebars and a slider to display. how do i set the layout for civicrm pages and profiles?

Assuming you're adding the Civi content via a WP page (Pages > Add Page, use the CiviCRM button to add your chosen functionality), under Page Attributes there should be the option to select a template.  Depending on the theme you've selected, there may be a Full Width option.  If not, you may be able to add that option to your theme.

~ Lesley


Email Greeting Updater in scheduled jobs failed Running Drupal 7 with CiviCRM 5.6.0. Noticed in BCC'd copies of confirmation emails for an event that some records have a blank "Email Greeting" field since the template is addressing {contact.email_greeting}.

Went into Scheduled Jobs in Settings, and ran "Execute Now" on the email greeting updater and got the following error in the log:

  Settings - Scheduled Jobs Log
  This screen presents the list of most recent 1,000 scheduled jobs log entries. > List of log entries for:
  Greeting updater

  Date  Job Name    Command/Job Status/Additional Information 2018-10-10
  15:19:49  Greeting updater     Entity: Job Action: update_greeting Summary
  Finished execution of Greeting updater with result: Failure, Error
  message: Mandatory key(s) missing from params array: ct, gt Details

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

  Full message:  Finished execution of Greeting updater with result:
  Failure, Error message: Mandatory key(s) missing from params array:
  ct, gt 2018-10-10 15:19:49    Greeting updater     Entity: Job Action:
  update_greeting Summary Starting execution of Greeting updater Details

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

  Full message:  Starting execution of Greeting updater

Any ideas on how I an fix this?

You need to provide the required parameters for this particular job, in this case it's looking for the contact type (ct) and greeting (gt) parameters. The link below has more info on what you're choosing from.

https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/#job_update_greeting


Civimail URLs not working I've just sent a newsletter and had replies telling me the links to content on our website aren't working. I've checked and they're not, they're going to CiviCRM in the Wordpress plugins folder, and then different URLs that look something like: "url.php?u=60&qid=1389" (its different depending on the original URL). When you click one of these links in a draft email they go to a blank page.

Anyone had something similar? Any known fixes?

Thanks

You will need to check the resource URL and directory settings. If the resource url for CiviCRM is not set properly then the url build while mailing is send will be wrong.

When you have mailing with track url enabled than CiviCRM rewrites the url to 'url.php?u=60&qid=1389' so that it can track the click. But when you click on the url from email it gets in CiviCRM and then based on url params it redirects to correct url.

Thanks

Pradeep


Is there a way to see CiviMail logs through the interface (v. 4.6.36.) I am trying to troubleshoot some failed deliveries of emails in CiviMail. I would like to see the error logs. According to the documentation, they are stored in the local file system (well, obviously), but I do not have access to that. I am unable to find a view in the interface, where I could see the logs. Is it possible through the admin panels?
We use version 4.6.36.
Thank you very much in advance for your help!

If you look under Administer - System Settings - Extensions and click on the Add New tab you'll see one called CiviCRM Log Viewer. Install that and then admins will be able to view the logs using the user interface.
Since you're on an old version of Civi you may need to download an older version of the extension from https://civicrm.org/extensions/civicrm-log-viewer, but if you don't have access to the file system then I'm not sure how you'd install it. Tricky.


IATS can retry failed donations 7 days after the failure? Is there a way that IATS can retry failed donations 7 days after the failure happened rather than the following month?

The retry attempt on REJ response is dependent on the type of failure. Card Reported Lost or Stolen e.g. will be bumped to next month - whereas other failures will attempt next day. Note that you can always catchup or hit Process (if using iATS Legacy) after e.g. updating a Lost or Stolen card so you don't need to wait until next month to capture the monies.


Mail account authentication with Oauth2 Exchange Online is retiring basic authentication which means, I think, that CiviMail will no longer be able to process bounced messages in Exchange Online mailboxes.  Are there any plans for CiviMail Mail Accounts to use Oauth2 for authenticating with the mail server?

UPDATE: It's available now for INBOUND emails (bounce processing/email processor) in 5.32 as a hidden extension. See https://docs.civicrm.org/sysadmin/en/latest/setup/oauth/#enable-the-module

It's in progress for google and would likely be the same for outlook/exchange.
See https://lab.civicrm.org/dev/mail/issues/59
It supports using a bearer token already
but we could use some coding help though for someone to write the code to get/store/use the refresh tokens in order to get the bearer token.


How can we pre-populate contacts into Caldera forms via query params Title says it all: How can we pre-populate contacts into Caldera forms via query params

Michael McAndrew shared a WIP at

https://github.com/mecachisenros/caldera-forms-civicrm/pull/85

it does not yet include any ACL
people have to remember to add a hidden contact id to the form
a dedupe rule where contact id triggers a match (contact_id weight = 1, threshold = 1) is required


How to request OK to communicate by email (only)? Without coding In the 'Manage Contribution Payment' screen we want to simply ask the donor if they are happy to be contacted by email - a simple Yes/No option in a profile. It doesn't seem possible to do this using the standard fields - 'Communication Preferences' brings up all the communications options. Is there any way to just expose the email field as a preference? I can do this with a custom field, but it would be better to set the actual email preference field.  I've a feeling this must be possible, and have a strong preference to avoid any coding!

Does the optinfields extension do what you want?


On behalf of one of our customers: is there a publishing company out there that uses CivICRM? Our customer Acquire Publishing is starting on their CiviCRM road with attached websites, memberships, events and all sorts of stuff......They are wondering if there are any other publishing organizations in the CiviCRM community so they can exchange how stuff is done, share success stories and perhaps do some development together?

The New Press uses CiviCRM. There's also a magazine publisher (I forget offhand who) who uses CiviCRM and was exploring development to better handle magazine subscriptions in CiviCRM.


Is CiviCRM compatible with Nginx? If I have PHP installed on nginx, and Wordpress installed too, can I still run CiviCRM as a Wordpress Plugin?

Yes, CiviCRM works fine with WordPress on Nginx. However, since Nginx doesn't use .htaccess you'll want to add any changes to your site-specific configuration.

For example, there are a few upload directories that have .htaccess files denying access to their contents. To do the same thing in Nginx, you'd want to add a location block to your site's configuration.

location ~* ^/wp-content/plugins/files/civicrm/(?:ConfigAndLog|custom|upload|templates_c) {
  access_log off;
  return 404;
}

See more details in my blog post: https://blog.rudeotter.com/install-civicrm-on-wordpress-with-nginx/


Using Civi to manage members' lists of items available for donation to other members I'm helping an organization that connects with wealthy schools to share surplus items (from scissors to books to furniture) with under-funded schools.

I'm looking to set something up so the wealthy schools can create a membership account online, create a list of items they have available, and then those items can be assigned to various under-funded schools, which have also created their own account along with a list of what they need.

These lists are currently being done through spreadsheets, but I'd like a way to integrate the list functionality with the member management functionality. At the very least my hope is that doing that will give more power to the schools to facilitate the donations on their own, and I hope it will make it easier for past donations to be displayed online. Ideally, I'd like the software to automatically assign the items to the schools in need, but that's probably asking too much.

Anyway, my main question is: will Civi be helpful with the management of these donation item lists, or are good old Google spreadsheets the way to go?

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.


Install CiviCRM without installing the database. And install the database without installing CiviCRM What madness is this? Sorry for the daft title. Let me explain.

I'm trying to create a docker image for CiviCRM which separates out the web server, database server, and program data itself. In theory, I believe such a container could be very useful to the community. Yes, we have several docker images which do this. I even built one myself using the CiviCRM buildkit. However, none of them really follow the docker principles:

We can't choose our own web servers in separate containers (i.e. they are not composable)
We can't use standard docker tools for e.g. managing the SQL database (i.e. they do not conform to established principles).
Some of them do not even install programatically!

So the plan here is actually quite simple but my lack of knowledge of the CiviCRM install process is hampering me a bit. First, we define a docker-compose file which sets up sensible defaults for the SQL serverand web server containers, allowing the user to swap out other ones if they so desire. It also defines a data container which grabs CiviCRM program code in the build stage, then installs the database in the run stage, then quits.

Like this:

docker-compose.yml:

server:
    image: richarvey/nginx-fpm (or any other sensible default)
    container-name: "Civi Webserver"
    volumes-from: app
db:
    image: mysql
    container-name: "Civi DB"
    volumes-from: app
app:
    build: app
    container-name: "Civi App"

app/Dockerfile

from debian:jessie
# 1: download the build tool
RUN curl -Ls https://civicrm.org/get-buildkit.sh | bash -s -- --full --dir /buildkit
# OR install drush/composer/some other equivalent tool

# 2: download the CiviCRM program code
RUN /buildkit/bin/civibuild create dmaster --no-init-db /var/www/html
# OR some other equivalent command using drush etc.

# 3: prepare to initialise the db
COPY initialize-civicrm-db.sh

# 4: When the container is run it will initialise the database, then quit.
CMD intialize-civicrm-db.sh

VOLUME /var/www/html

To summarise: I'm looking for a way to install CiviCRM in such a way that the build tool does not also try to install the database. Then I also need a way to install the database without installing the program code.

From the excellent interactive documentation here -- https://buildkit.civicrm.org/#/tutorials (which is almost impossible to find unless you know where to look):

## Download application (with civibuild)
civibuild download "mytestbuild" \
  --civi-ver "master" \
  --type "drupal-clean"

There are a number of interesting gotchas. For example, civibuild download does not download dependencies for civi, it only downloads civi and the CMS. So you may wish to run composer install and npm install between these two stages. Otherwise, both will be run automatically next.

Then install the DB and the rest of the application:

## Install application (with civibuild)
civibuild install "mytestbuild" \
  --url "http://localhost:8000" \
  --admin-pass "n0ts3cr3t"


Where can I find the Release Schedule for CiviCRM? I know there are regular releases of new versions, but when are they?

Releases are generally the first Wednesday of each month.

The testing period for the next release starts when the current release is published.

The release dates and testing periods are recorded in gitlab


Custom fields not displaying properly after 4.7.0 upgrade Since upgrading to 4.7.0 I've noticed a problem with my custom fields (multiple-record, tab with table, and I have 4 multiple-record custom field sets per).

When I click on the custom field tabs for a contact, sometimes the data table does not display correctly. Some of the columns display as "[object Object]" for the entire column (except the heading row) instead of displaying proper data. I have a "Date" column that usually displays correctly, but in one of the custom field sets its data appears in the wrong column.

I also noticed that if I click in the data table's heading row to sort on a column I get an error in Firefox: "DataTables warning: table id=records - Invalid JSON response..."

I run CiviCRM on Joomla 3.4.8 and this issue did not occur for me on 4.6.11 (or earlier versions).

Is anybody else experiencing this issue after upgrading to 4.7.0, or have any ideas?

Edit: this is somewhat intermittent, but happens at least half of the time. Refreshing the page in the browser often fixes it, until next time.

(I tried to reproduce it on the online demo site (Drupal, since the Joomla demo is an older version) but I could not get "tab with table" custom field records to display at all there: after creating a custom field set and some test records, "No records of type '' found." is always displayed.)

PR submitted here resolves the issue encountered https://github.com/civicrm/civicrm-core/pull/7720


How do you allow a user to add their bulk email address? Trying to find a way to allow users to indicate which of their email addresses should be used for bulk mailings.

Not seeing an option in profile creation.

I believe bulk email uses whichever address is set to "Primary" if no specific bulk address is specified, and there is an option for primary email in profile creation.

Hope that helps!


Members still have "new" status, after over a year and a half Member rules dictate that members are "new" from start date to 3 months after start date. Nearly all the members in our database (4000+) are still marked as new. In fact, everyone is considered new unless they were cancelled by us by hand.

I have changed the rule so that members are only new for one month instead of three. What could be causing this issue? Cron is running. How do I fix and update user status?

The biggest problem with this is that we are a non-profit organization, and users aren't renewing their memberships because they are marked as status "new" even if their memberships expired a long time ago.

CiviCRM 4.7.15 Drupal 7.x

In CiviCRM Scheduled Jobs, the job to check and update membership status was not enabled.


API Import extension I need to load about 300 pledges from a spreadsheet. The best solution seems to be the API Loader but it is listed as 4.4 we are on 4.6 going to 4.7. Can we get the extension tested for 4.6 and 4.7

If by get the extension tested you mean someone else doing it for you, unless you have an incentive (eg. budget), unlikely to happen, at least at the speed you'd like.

If it's about you or someone in your team testing: please do so!

If you are familiar with git, I would suggest you to install the extension using it, it will be easier if you have to modify something, but otherwise, you can just download the zip and put it in your extension folder.

https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport.git


What is 'advanced report configuration' and when will it work? I was updating a report when I noticed a link to 'advanced report configuration' (this was on release 5.13.5).  Following that link I got a screen similar to the contact layout editor - but I couldn't make anything work.  After an upgrade to 5.17.4 this link has disappeared.  It looked very useful & interesting, allowing columns to have the title changed plus other stuff.  I guess I stumbled on something that's not ready yet - or is this an extension I've missed?  If not - any ideas when this will be implemented?

This is part of Extended Reports, and appears on some (not all) extended reports.  Notably, it allows you to change the order of columns in your report.  This works for me.


Error "No payment information found for this record" when connecting multiple participants to a single payment via API I've been working on a camp registration page where an adult registers one or more children for one or more events, with a single Pending contribution to tie it all together (per Xavier's advice here). My API calls successfully create the adult, contribution, children, relationships, participants, and participant payments (a connection to my contribution) without error. However the participants still don't seem to be connected to the payment. When I view a participant record, the total paid shows the full amount with a balance of $0, even though the contribution is $0. When I click View Payments from here, there are no payments to display. When I click Record Payment, I get the error "No payment information found for this record".

Here is a Gist showing just the relevant parts of my code. Any advice is greatly appreciated.

when you create the "non main" participants, do you link them with the main participant registration?

As written, try to register multiple participants via the normal web interface and use it as a template, but it seems that you need to set participant_registered_by_id to the id of the first participant (BAO/Participant.php getAdditionalParticipantIds function should give you more hints)


Document merge in CiviCase from scheduled activity in timeline I've created a case type with a timeline that includes document print/merge activity. Where I am running into issues is with doing the document creation from that timeline generated activity.
When I use the 'Add Activity' drop down in the case manangement I can create a document, use a template, all the things I would expect when using the 'Print/Merge Document' action.
However, when I go to the scheduled activity which was created when the case was created and edit it I can't seeem to do any of those things. I don't have the option to use a  document template or create a document the way I can using the drop down 'add activity' option.
Are activities in case standard timelines just notes/reminders and the actual task has to be done using the dropdown or am I missing something? If I'm not missing something and they are just notes/reminders why set up the timeine/sequence instead of just setting the possible activities.

The print/merge activity type is usually a "system" type that gets created when you use the print/merge search results action, or the Export Document button on Manage Case, not an activity you usually create yourself. The fact that it works from the add activity dropdown seems to be because of some sneaky code that was added to make it do the same as the export document button: https://github.com/civicrm/civicrm-core/blob/915e9edd65c7b594372897923734ec52e67f1835/CRM/Case/Form/CaseView.php#L248-L251


CiviCRM and WordPress User Groups and Permissions We are trying to set-up user accounts for use on both our WordPress club website and CiviCRM but just can't figure out how to get the permissions piece to work.

The "CiviCRM WordPress Member Sync" plugin has allowed us to create the user accounts and sync between the two systems for about 80-90% of our members, so that is now working. What we can't figure out is how to set the WordPress permissions to be based off of CiviCRM groups (WordPress uses Roles/Responsibilities).

We acquired a few plugins called "Press Permit Core" and "Capability Manager Enhanced" thinking they would help, but it hasn't. It shouldn't be this difficult to manage user groups and security from CiviCRM to WordPress. Any guidance that you can provide is deeply appreciated.

CiviCRM WordPress Member Sync is compatible with both the Members and Groups plugins. The former grants WordPress users the 'restrict_content' capability when they have a membership, whilst the latter allows capabilities that are generated by CiviCRM WordPress Member Sync to be mapped to user groups. Either that, or you can roll your own functionality by mapping memberships to roles or capabilities.


Why won't the "Employee of" field autocomplete when used as part of a edit profile form in Wordpress I am really new to CiviCRM and so this question may just display my lack of understanding of some basic concepts. I serve a membership driven organization whose members are themselves almost all employees of larger organizations.

I am trying to test out how new contacts can identify themselves as part of an existing organization. I created a simple profile that I embedded in a wordpress page in "create" mode. On it I use the Individual fields First name, last name, email and "Employee of."

When you edit a contact on the back end of the site, the "Employee of" field autocompletes if an existing employer is there. But used as a front end form element, it does no such thing on my installation. Am I missing something? How do I allow new members to enter and select from an existing set of organizations?

It's on purpose, to protect privacy of your contacts. What this autocomplete does is to provide the list of all the organisations that you have in your CRM.

I could easily imagine quite a few organisations that are in the database, for instance of your "opponents" that would look weird, or even embarrassing in the list of suggested organisations.

And even it if weren't the case, it's not us, as the software provider, to decide what contacts in your database can or can't be displayed to anonymous visitors, so the only safe option is to remove that feature

I have written a while ago an extension to let you add an autocomplete, but pretty sure it doesn't work with the latest version of civi (that has switched to a more modern autocomplete jquery module)

If you have dev skills or budget, I could dig it out so it could be used as a basis for the feature (and so you could only provide your members in the autocomplete for instance)


Restricting price option to a group According to this answer Can I offer different pricing for an event based on user group? it is possible to restrict a price option that is set up as a check box, radio button or selection to a group.
However, I don't see the option to limit the option to a specific group?

The answer you're referring to says you need the Group-Based Pricing extension installed.  It also seems that the extension isn't being maintained, and folks have had to tweak it to work with modern versions of CiviCRM.  This fork seems more up-to-date.


Field Source doesn't appear in Import Contributions I'm trying to import contributions. I found all the fields except the "Source" field.

Is there any reason for not appearing? Is there a way to show it?

Thanks in advance. :)

The contribution source field is available during import and export. Its labeled as 'Contribution Source'.


How do I add CiviCRM fields to a layout box / container in a form created using webform-civicrm? I'm on Civi 4.6.17 and Drupal 7. I've created a webform using the Drupal webform-civicrm module. I also have the Drupal webform layout module installed. I've added a new layout box (which seems to mean the same thing as 'layout container' as referred to at the Drupal webform layout module page). How do I now add fields to my new layout box? Do I need to have the Drupal Form Builder module installed as well to add fields to the layout box?

when you're on the Webform tab - you can drag and drop your fields into the Layout Box - here's what it will look like:

And re: the second part of your question - no - you don't need Drupal Form Builder. When you've downloaded and enabled webform_civicrm module - you'll see a CiviCRM tab (on the far right side) and this is where you tell the module to pull in certain Fields from your CiviCRM:


Memberships don't get updated when they elect to auto-renew We are using Wordpress and when a member elects to have their membership auto-renewed and we received payment for this in CiviCRM it doesn't update their end date, it still shows their membership expired.

Also, when it's a new member joining for the first time and they elect auto-renew, it puts their membership into a pending status even though we have received payment.

Any help here would be greatly appreciated as it's causing me to do a lot of manual updating on these records.

just to confirm some basics since your question doesn't specify if membership status update is happening for other situations.

For Membership Status to auto update you need to have the Scheduled Job enabled. You can see this on the demo site here. And you need to have a cron running. Neither of these may be the issue you are facing, but are fundamental to the membership status update working.

Otherwise you should confirm your Membership Status is not 'overridden'. Again this is something you have probably checked but it helps if you can confirm such things.

It may help if you can clarify the Contribution Status of the payment. Is it being set to Completed automatically?


Error reaching public extensions directory I receive this error:  Extension download error
The CiviCRM public extensions directory at https://civicrm.org/extdir/ver=4.7.9|cms=Drupal could not be contacted - please check your webserver can make external HTTP requests or contact CiviCRM team on CiviCRM forum.
However, from the browser I can go to that page and see a listing of extension.xml files. I'm trying to get the twilio sms extension installed.
Drupal 7.5 CiviCRM 4.7.9

In this situation, some possibilities to evaluate:

There is a problem on civicrm.org, but it only occurs on a subpage. For example, in v4.7.x (and maybe 4.6.x), it fetches the subpage /single (e.g. https://civicrm.org/extdir/ver=4.7.9|cms=Drupal/single).
There was a problem on civicrm.org and the failure got somehow cached. You could wait a while and try again -- or clear the caches. (Maybe use the "Support => Developer => API Explorer" to run Extension.refresh or System.flush.)
Something in the web server environment is preventing it from making the request, e.g.

A security system (such as a firewall, suhosin, or php ini setting) interferes with outgoing requests.
The curl/http layer has a broken HTTP/SSL configuration.

In this particular case, I believe there was a change on civicrm.org which prevented it from correctly reading several of the XML files needed for /single, but that issue is now resolved.

(See also: https://issues.civicrm.org/jira/browse/CRM-19090 )


Version 4.7.3: TCPDF package seems to be missing I recently upgraded to vesion 4.7.3 (I'm running under Wordpress), and for some reason the TCPDF package was missing!

This led to the error: "Warning: opendir(/nhldata/631/106631/data/web/predigerforum/htdocs/wordpress/wp-content/plugins/civicrm/civicrm//packages/tcpdf/fonts/): failed to open dir: No such file or directory in /nhldata/631/106631/data/web/predigerforum/htdocs/wordpress/wp-content/plugins/civicrm/civicrm/vendor/tecnickcom/tcpdf/tcpdf.php on line 4148
TCPDF ERROR: Could not include font definition file: helvetica"

...when trying to create labels. I copied the directory "tcpdf" from the previous version into the packages directory and it seems to be OK now.

Perhaps there is a slip up in V 4.7.3, because I did nothing more than the normal upgrade process.

In 4.7.3 the TCPDF package was moved to civicrm/vendor/tecnickcom  from civicrm//packages/tcpdf.

I just tested on a WP 4.5.2 and CiviCRM 4.7.8 install and was able to create mailing labels.

Can you give us the steps to reproduce?  This may be a bug that needs an issue filed at https://issues.civicrm.org

One additional thought - try and empty the caches in WP the url is https://yourdomain.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/setting/updateConfigBackend&reset=1


Unknown DB Error When Trying to Disable the Automatic Wildcard Option We are trying to disable the automatic wildcard option in Civicrm (Wordpress 4.7.2).  However, when we try to disable the option and save we get an error that says “Save Failed: DB Error: Unknown Error”.  I tried to disable the automatic wildcard option in the main 4.7.2 Wordpress demo installation of Civicrm and it saved with no error message. We contacted our hosting provider who enabled "Enable Debugging" and "Display Backtrace", and they stated that they could not determine what the issue is without manually debugging the code. They recommend that I ask the Civicrm Stackexchange team for help.

Thanks

I started experiencing this also, although I was trying to enable the auto wildcard option, which I had previously turned off.

I think it's a bug, but did have success updating it directly in the database as a workaround. In the civicrm_setting table there's a value called includeWildCardinVlaue. s:1:"1" means "yes" it's on, s:1:"0" means "no" it's off.

I'm running Civi 4.7.3 in Wordpress 4.4.2 on civihosting.com.

Looks like it might be happening to Drupal users, too. Why can't I save search preferences? Specifically 'Autocomplete Results'


CiviCRM integration with bespoke custom CMS? Can CiviCRM be integrated into a bespoke custom built cms, I see that you can download it for drupal, wordpress and joomla but our cms was built specifically for our non for profit, if someone could help me with this that would be fantastic

It's possible that you could build an integration component to make it work with your custom cms, but it probably wouldn't be worth the effort.

Your best bet would probably be to use the api to accomplish an integration on the pieces you care about.  The api includes methods for most functions, including inserting, updating, deleting and retrieving data using php, rest, smarty and javascript interfaces.  As well as html/js snippets for forms to be embedded into your cms html.  See:
http://dmaster.demo.civicrm.org/civicrm/api#explorer
log in as demo/demo.


Stripe processor: payment going through but registration is not! "Could not find valid value for id" I'm on Joomla 3.19.13 with CiviCRM 5.18.2 and using the Stripe Payment Processor 6.2.2.

This seems to be a problem popping up on Wordpress sites (https://civicrm.stackexchange.com/search?q=Could+not+find+valid+value+for+id) but I'm on a Joomla system.  My problem seems most similar to this one -- but in my case the registration DOES NOT come through, but the credit card payment DOES go through the Stripe processor, without email, address, name, etc. Nightmare!

Even worse, this seems to be an intermittent problem.  We've just opened this event registration a few days ago, and so far we have 20 successful registrations with payments processed as they should be. But 1 payment has gone through successfully without any registration data or identifying data in Stripe, and 6 or 7 of these "unknown" Stripe payments appear to be stuck in the "Uncaptured" stage in the Stripe system.

I've found multiple instances in the CiviCRM logs like this:

Nov 30 23:13:41  [error] $Fatal Error Details = Array
(
    [message] => Could not find valid value for id
    [code] =>
)

Tail end of backtrace like this:

Nov 30 23:13:41  [debug] $backTrace = #0 /home/fawcoho/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(385): CRM_Core_Error::backtrace("backTrace", TRUE)
-1 /home/fawcoho/public_html/administrator/components/com_civicrm/civicrm/CRM/Utils/Request.php(121): CRM_Core_Error::fatal("Could not find valid value for id")
-2 /home/fawcoho/public_html/administrator/components/com_civicrm/civicrm/CRM/Event/StateMachine/Registration.php(52): CRM_Utils_Request::retrieve("id", "Positive", Object(CRM_Event_Controller_Registration), TRUE)

Any troubleshooting ideas welcome -- Stripe has already confirmed that for these incorrect payments they are receiving the credit card info (number, expiry, CVC) but not any other identifying information.

That looks like a bug in the events component (possibly, specific to Joomla). The error is happening in the constructor of an object that is managing the event registration process (https://github.com/civicrm/civicrm-core/blob/master/CRM/Event/StateMachine/Registration.php), presumably after the payment has occurred. It's failing to get the id of the event, which it normally will pick up from the url or as a hidden post value from a form.

The numbering of the error line suggests that your CiviCRM version is not up to date, and I suspect you're using the event "cart" feature which is not as maintained as the standard event form/flow.

Conclusion: probably not stripe related, but a CiviEvent error.

Also, here's a similar post: CiviEvent: Could not find valid value for id (Drupal 7.6.1)


Integrating QR codes for event attendance Would like to check-in event participants using a QR code that will also update the attendance status of the participant. Is there an extension available for this feature? Any help is appreciated...thanks

We have built such a solution, though no extension is available.

The key is that the QR Code simply needs to contain a URL request, with embedded querystring parameters such as event_id and participant_id. Pretty much any stock QR scanning app will recognize it as a URL, and will simply pass it on to the device's browser.

We wrote a simple PHP program that was called in the URL, that grabbed the querystring parameters (event_id and contact_id in our case), and called the CiviCRM API to change the participant status to 'Attended'.

Our app also returned a screen back to the device browser that reflected add-ons that the participant had purchased (lunches in our case).

This does have a bit of a security risk.  We got around this risk, by having a separate URL the device browser would be directed to that the user could log into and have a cookie dropped onto their device (which was then subsequently interrogated by the main PHP script to validate).


Getting Drupal error messages with Silent User Registration extension Drupal 7.72
Civi 5.28.2
Silent User 1.0
I just installed the extension and setup the CiviRule per the pics on GitHub. My CiviRule trigger is a new contact created with condition of "these" sources (sources are webform civi integration forms that we use for contributions).
When I make a contribution as a new user, I get 2 Drupal error messages
The contribution does process in Civi and it does include a Name and Email. But a user is not created in Drupal.
I added a 3 minute delay in the CiviRule and tested it with and without rechecking the condition. Now it does not show the Drupal errors as above but it still does not create a Drupal user.
In the Civilogs I see this (I assume it is related) [warning] Report Error Extension could not send since no email address was set.
In the Drupal Logs, I had the following
Notice: Undefined index: template_id in CRM_Emailapi_CivirulesAction_Send->userFriendlyConditionParams() (line 122 of /sites/default/files/civicrm/extensions/org.civicoop.emailapi/CRM/Emailapi/CivirulesAction/Send.php).
But I no longer get the log errors since I added the delay.

I got some help from a friend and we got it working. The problem seems to be that the database was not finished writing to the email table when the CiviRule fires. We switched the rule to Trigger on "Email is created".


using cancellation link after event start date? It seems that Civi does not allow people to use the self-service cancellation after the event start. We have some multi-day and longer-term events that it would be very helpful for them to still be able to self-cancel.
Questions:
* Is there setting to let Civi permit cancellations after the event start?

If not...would the event online registration setting "cancellation or transfer time limit (hours)" - could that be made negative somehow (i.e. until 1d after event start)?

Just a user, not a developer here, thanks in advance!

By chance I also recently discovered this limitation, and opened a ticket for it.

I wrote the code to add this feature, but it requires a change to the CiviCRM schema, so I don't recommend patching yourself unless you know what you're doing.  I wrote a patch to clean up checking whether a participant can self-update.  Once that's approved, I'll submit a patch to allow negative values for the "hours until cancellation" field.


Error with site JS for Civicrm 5.8.0 Hi we suddenly started getting a </body>\r\n</html>","help_post":"\r\n\r\n\t error in the event info page and payment contribution page during editing.

not sure why this started happening.

Has this happened to anyone else, seems like a js error as i can see a few reds in the console.

Civicrm 5.8.0 and drupal 7.60

This had to do with the Google Tag Manager module for Drupal. Updating to the latest version resolved this issue.


Paid event but Pricing Options can not be required but they must chose a fee Civi 4.6.4 and WP 4.2.2
I have an Event(3 day Conference) with 6 pricing options.  The first is for the Full conference with different prices for a Member, Certified Member, and Non-Member.  AND there are 5 other price options for daily activities with pricing options again for Member, Certified Member, and Non-Member.  I can't make any of the pricing fields required since they can choose any of the options.  My problem is, though, that they must pick one, but don't know how to make this happen.

My non-code way of (almost) solving this is to include a zero price "no-selection" option such as "I not attending the full event"  or  "I have selected a different workshop" in each price field and make each price field compulsory.

My experience has been that people forget to tick anything, rather than deliberately choose not to make a selection, so forcing people to make a selection for each field has worked for us.

I should point out that I have only done it with 3 sets of price options, and I didn't get any flack about making people tick so many boxes.  I don't know how people would have reacted if they had been forced to make 6 "selections".

The "almost" in the first sentence is because each year we still got one or two out of 1000 people who chose the "no-selection" option in every set. I set up a smart group for people with a registration value of zero and sent them a standard email alerting them to that fact.


Is it possible to trigger e-mail on specific CiviMember transition? I'm trying to figure out if it's possible to trigger an e-mail when a membership changes status, for example when going from New -> Current in memberships.

Is it possible?

You could also use the CiviRules extension in combination with the Email API extension.
That enables you to add a trigger for a membership change, set the condition to status is ...... and then send a mail.

CiviRules can be found here: https://civicrm.org/extensions/civirules and the Email API here: https://civicrm.org/extensions/e-mail-api

Documentation on CiviRules is here: https://docs.civicrm.org/civirules/en/latest/


Auto Renew Membership Brand new to CiviCRM. First thing I am trying to setup is memberships. Our members dues are automatically deducted from paychecks. We receive 26 paychecks per year but only 24 dues payments per year. So no dues are collected from the 3rd paycheck within a calendar month (happens twice a year)  Trying to figure out the best term to use and if there is a way to just allow the payments to be automatically recorded in CiviCRM based on the schedule dates for paychecks or to just simplify it to 2 payments per month... No payments actually need to be processed, just simply recorded in CiviCRM.

Initially it seemed that it might just be easier to not track actual payments and just override the members status and just manually expire the member when they resign but trying to use CiviCRM to its fullest extent.

Welcome to CiviCRM SE.

I think you have quite a complicated membership processing structure there (very frequent payments), but the basic requirement seems to be process membership update structure from an external file (I presume you get the paycheck info as a CSV file) is quite common. If you don't need to record the payments at all I think you can do a membership import to update the membership expiry dates (you would need to do a bit of processing on the file first to indicate the appropriate expiry date.

If you want to record the payments (as I do) then its a bit more difficult and I haven't yet found a good solution (How to bulk renew membership is similar).


Upgrading from 4.1.5 database to 4.6.2 failing with constraint violation Trying to upgrade a 4.1.5 database to 4.2.6. I am getting a constraint violation. See the screenshot.

I recommend you take smaller steps, starting with 4.2. You can download the latest version of 4.2 from sourceforge (the latest in that series is currently 4.2.20).

If that upgrade goes ok, then you could proceed to 4.4 (the current LTS) and then up to 4.6.

Remember to backup your database before upgrading, and if the upgrade fails, restore from the backup before trying again.


checkbox import problems Right now I have a custom data set set up that has 3 custom fields inside of it. Inside each custom field is a list of options that can be checked. (checkbox is the option)

In my spreadsheet that I import I have the correct columns and appropriate values in for the options I need to be checked for each contact.

So lets say here are my 3 custom fields with 3 different options (example):
Custom field A contains blue, red, and white in that exact order on the spreadsheet. Custom field B contains purple, orange, yellow in that order on the spreadsheet. Custom field C contains cow, cat, dog in that order on the spreadsheet.

If Example Contact 1 has blue marked, purple marked, and cow marked it will check those off appropriately.

If Example contact 2 has blue marked, yellow marked, and cat marked only blue will import.

I did multiple tests and have come to the conclusion that only the first value of each custom field will import if it is marked. Anything else marked will not be imported.

Is there something I can do to fix this?

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

red,blue,orange
red,orange
etc

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

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


Webform CiviCRM activity - prevent email notification Is there a way to not send an email when Webform CiviCRM creates an activity?

I want to create an activity for admin purposes but not that the new member receives an email.

I don't see an option to prevent this?

Any ideas?

CiviCRM Core will (by default) send out an E-mail to Contacts who are assigned to an Activity.

You can change this setting to Not send out any E-mail to Contacts who are assigned to an Activity and handle Email notifications on a per webform level. If you need an example of that - let me know.

Here is an example:
On the form: E-mail + a checkbox (without label:   and text: Send E-mail Notification:

Conditionals -> if the checkbox is checked -> show the E-mail field:

In Webform -> E-mails -> send E-mail to Component -> E-mail:

Of course you can make this as complicated as you want (also e.g. by including Activity Status and/or Activity Type in the Conditionals.


Event members only for 3 days then open to the public I have a need to be able to enter a period when an event opens for registration/access to a file to members only for a period of time (normally 3 days).
So the goal, to be clear, is to open an event for registration to members only for 3 days, then open to the general public.
Ideally, if those open dates were also available to civiMail as a token - but that might be asking a bit much.  I'm prepared to write an extension to make this happen but if someone has something similar, then I can build on that too.

There are methods to do members-only events on this Stack Exchange question: Is it possible to restrict event registration to members?

Since you're willing to write an extension, it's probably a good use of your time to start with the Members Only Event extension and add the ability to automatically open the event to the public after a certain date, which would be added to the custom fields that the extension creates.  Please don't forget to submit a pull request with your feature to the author!


State dropdown empty on form with Drupal webform integration We are running Civi 4.7.29. with Drupal.  We have a webform using Drupal webform integration which populates civicrm fields.

we noticed that the state drop down was empty when previously it was working correctly.

Has anyone come accross this issue?

I checked the state province table in civicrm and it is not empty.

Thanks

Yes there is an error on the page.  Please see below.  How do I fix this please?

Usually when a javascript element fails to work on your page, it's caused by a general javascript failure on your website. This can be caused by incompatible plugins or themes, etc. So the problem may have nothing to do with the state/province field or webform-civicrm; if Javascript has crashed, then it can't run. To narrow down the problem, open up the console in your webbrowser (F12) and look for any error messages. If the error message contains the name of a plugin, try disabling it. Or take a screenshot of the error and add it to your question.


Invalid value for field(s) : Individual Prefix I am importing a new database into CiviCRM using the CSV import method in: Contacts > Import Contacts. In the downloaded CSV file with the list of errors, I get next error for a lot of entries:

Invalid value for field(s) : Individual Prefix

I suppose it is related to the list of prefixes I introduced in: Administer > Customize Data and Screens > Dropdown Options > Individual Prefixes

In the CSV file used for importing the contacts, I put the value corresponding to the dropdown option. The error above is caused by a lot of entries with "2" as value, when there is actually an option with value "2" present in the different options available.

I wonder what could be the cause this error.

Try using option label over value, i know its weird but for some options value doesn't work but label does or vice versa.