Landing page and events for organisational member We have a number of organisational members and would like to have facility of being able to offer members their own profile page and the ability to create their own events.

The idea is to create a member directory where members can add and update their own information.

Is this possible in CiviCRM?

Thanks
Robert

Profiles can be used to display fields about contacts publicly and can therefore be used to create a Member Directory. There is an explanation of how to do this here. Steps include setting the Profile to "Limit listings to a specific group" so you first create a Group that contains your 'members'. But doing this for the 'organisation' related to the individual who is doing the updating has some limitations iirc.

You can also give your Contacts access to their 'dashboard' provided they have a Permissioned Relationship over that contact. This can give them access to edit more information about their organisation - but from memory the fields available are not easily modified either eg to include a Description, or Logo (hopefully someone points to an easier solution).

Looks like you are not using Drupal, so the following is an answer for for others who might find this question.

In Drupal all of this becomes much easier. Webform-CiviCRM is your friend as it can allow one user update any fields about their related organisation.

Views gives many options for then displaying this info, though another approach entirely is to use the civicrm node reference module to link content (nodes) with the civicrm record of the Organisation, and then use that to not only pull civi data for that Organisation on to 'their' node, but also details about who their Secretary or President etc might be. Example of this can be seen here


How to create a Drupal View with multiple CiviCRM relationships? I would like to create a Drupal View showing an organization and several individuals who are related to the organization in different relationships. The wording on the CiviCRM Drupal relationships options is ambiguous, and I am struggling to find clear documentation describing CiviCRM relationships in Drupal Views.

How do I create a View showing several related entities linked to a common entity by distinct relationship types?

You can use the relationship section of a view for this. A relationship in a view is a relationship between entities don't confuse it with the relationship you have between contacts.

So you could set up a view relationship starting from contact a (the a side of the civicrm relationship), or from contact b (the b side of the civicrm relationship). This a link to the civicrm relationship entity. When you add this relationship to the view you can define which civicrm relationship type.

The next step is to make a view relationship between the civicrm relationship entity and the contact. This relationship is called CiviCRM Contact, the Contact B, or CiviCRM Contact the Contact A.

Then in the fields section of the view you can add fields based on the entity. You can then say for example I want to use display name of Contact B.

If you are familiar with SQL. A view relationship could be described as a join.


Merge known duplicate I have two records for the same person. How do I merge them? I know there is a function to look for possible duplicates but these records are not being picked up because of spelling errors.

Welcome to CiviCRM SE.

You can merge the contacts manually via search results. Here is a link to the specifics:

https://docs.civicrm.org/user/en/latest/common-workflows/deduping-and-merging/#merging-contacts-from-search-results

You should also review the information on merging two contacts manually here:

https://docs.civicrm.org/user/en/latest/common-workflows/deduping-and-merging/#using-rules-and-merging-duplicate-contacts-manually

Hope this helps!


Drupal Views Multiple Field CiviCRM I collect data in case activities, and I'm currently trying to build a Drupal Views of this data. I'm running into a problem with multiple fields. For example: "What colors do you prefer?" The results are showing up like:

Red, Blue, Green
Green, Blue

Is there a way to present each line as a color? My end goal is to create a pivot table to show a count of each color. I have a lot of multiple field questions that have this problem right now. The only solution I can think of is to create a PHP code to output a if statement == "RED" line by line.

Check out Charts, Google Charts module - if not for this purpose you'll be using it for some other data displays soon!

Below is a screenshot of a View - Page of Format: Chart -> aggregating by Grant Type over a certain time period [PS - the Table is an attachment -> Format: table]. For your use case try Aggregate by your custom field containing the Colors.


Why does CiviMail stop sending after the first 1,000 messages? We have about 30k recipients in our lists and every time we send a mailing (New Mailing - Submit Mailing - Schedule Jobs - Execute Process Mailing) it stops after 1000 messages. We usually have to refresh the page and continue until it completes. How can we work around this? Thanks for your kind help.

Did you setup the cronjob?

http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs

It's the usual behavior of civicrm to send 1000 mails per cronjob. After that it waits x Minutes and sends the next batch of mails at the next cron run.


Reorder Report Columns I'm creating a basic custom report using constituent details. I'm hoping to find a way to reorder the columns in the report. For instance, I have a custom field that I'd like to go first, and then put the address second - to match a previous report format we used.

Is there a non coding option for doing this? If I have to code, where can I go to learn how to build it?

welcome to the community!

First up, I would not recommend learning to code by editing CiviCRM Reports.

The thing to exhaust before reaching for your Dial-a-Coder is the CiviCRM Profile option for an Advanced Search. You can get the information that you need from Civi 99% of the time using cleverly created Profiles, and then using them as a "Search View" on an Advanced Search.

If (and Only If!) you've exhausted that, then it may be best to ask a CiviCRM Partner organisation to help you. They can be found here: https://civicrm.org/partners-contributors.

Good luck!

JohnFF


How do I fix the "Incorrect Resource URL" alert? I've just a done a clean install by the book of CiviCRM 5.24 on Drupal 7. The installation went smoothly. Now I'm seeing an alert about the Resource URL being incorrect (it isn't). I seem to recall that this was an issue a year or so ago. Is this a regression that has crept in to the latest version, or am I doing something wrong? I have other D7/Civi installs on the same server, all with earlier versions of CiviCRM, and none of them are exhibiting this behaviour.

The Resource URL lookup uses the PHP setting curl.cainfo to look up a certificate file, e.g. CACert.pem to validate the server certificate.  I found the problem went away when I added the server certificate to that file.

See Installing drupal 8 using civicrm-setup leads to "incorrect resource url" system status check errors


What Permission to view a user's own Profile/Dashboard What permission must I grant to a user so that he can view his dashboard (/civicrm/user?reset=1) ?
(Currently running Civi 4.7.27 / Drupal 7.59)

Dashboard & Permissions

If you want to give the user ability to see information on themself, the permission seems to be CiviCRM: access Contact Dashboard. (I expected CiviCRM: view my contact to be a requirement also, but it doesn't seem to be necessary for a contact to view their own dashboard.)

If you also want to give the ability to edit the logged in user via the contact dashboard, the permission is CiviCRM: edit my contact.

Permission to access to other CiviCRM components may dictate which Dashboard elements appear on the user's dashboard.

Here's CiviCRM's documentation on permissions.


Why are custom field's multiple choice options all unchecked on contribution page? Today I installed 5.25.0 (running with Drupal 7.69). I have a profile that includes a couple of custom fields that are multiple-choice (e.g. professional interests - check all the apply). The choices that are checked appear on the member's profile page and when they edit the profile with those fields directly. So that all looks fine.

Not so much on the contribution page that includes that profile and fields. Every option is unchecked on the contribution page. They used to appear checked on the contribution page, but no more.

Even curiouser...one of the fields is required and the contribution page cannot be submitted unless EVERY option is checked. Normally with this field required, only one option needs to be checked.

So I am wondering if this is a new bug? Anyone else seen this? Suggestions?

Thanks, as always to the community :-)

Try applying patch from below PR

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

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

HTH

Pradeep


Re: CiviCRM contribs/extensions - any scripting language limitation? Not an issue or bug, but a question for admins of CiviCRM - is it acceptable to use Python for part of a new extension (instead of PHP) or is that expecting too much, since that means asking users to install Python in addition to their stack of PHP, MySQL, Apache and whatever OS?

I know that Python install isn't the only issue here but so - it seems that CiviCRM doesn't (yet) have any kind of ETL extension (and I mean a contributed extension like CiviDiscount, not 'native', one that would be an optional add-on, like modules in Drupal). I am looking at some way to avoid Kettle/Talend (Kettle 'works' but sucks by comparison w/SSIS which is not open-source).

At first I thought well, people could just contribute Kettle scripts that other people could take and modify but that is pretty clumsy. So...looking at writing simple MapReduce in Python.

So, it would not necessarily be part of the interactive CiviCRM user functionality, using RESTful Api to do transactions, but totally backend functionality to do data transformation from MySQL or whatever database. I hope the transform could also be used to produce reports in some other way than hacking w/those templates. Using Apache Hadoop could also be a showstopper...just exploring now.

It depends.

If it's an extension that does something that I need, I would use python (well, it's already installed on all my servers, but would have installed it).

It will however limit the distribution to those that have root access to their servers and can install whatever they want on it, so probably make more sense for "big install" civi.

By the way, by extension, you mean "additional features", not "civicrm native extension", right?

If it's the former, I feel ok with python interfacing with civi (eg. via the rest interface), cleanclothes has for instance a complete frontend developed in python that only uses civi as a backend (and for the most advanced features if I recall)

If it were the latter, I would be concerned having php calling somehow python, mostly because I'm not even sure how it could work cleanly.

You need to tell us more about what your extension does.


A Smart Group of Contacts We made around 100 contacts at a recent conference. How can I set up a smart group of these contacts that are not currently in our database?

I would assign a tag to the contact when you import them, then do a search for that tag and create the smart group from the search results.


What would cause civicrm_invoke to submit a large number of server requests? Earlier today, the civicrm_invoke process submitted a large number of requests to our server – so many requests that it took our site down. An agent at our host (Pantheon) had to restart our application instance to get our site back on-line.

My goal is to prevent this from happening again. To do that, I need to better understand why this happened, so I'm turning to y'all for some guidance:

What is civicrm_invoke?
What causes it to instantiate?
If there are obvious possible causes for a (seemingly) spontaneous "burst" of civicrm_invoke requests, what are they?

We're on a virtual server on Pantheon, running CiviCRM 4.7.8, Drupal 7.44, PHP 5.5.24. Our database is: 5.5.5-10.0.23-MariaDB-log. No extensions are installed. Cron has not run since April 18th (Yes, that's a problem. No, I don't know how I managed to get it to run in April. If anyone can point me at a way to manually force Civi's Cron to run, that'd be keen.).

Thanks!

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


Is there an easy way to provide a link to an online event after user has registered? To start, I am looking for a purely civicrm solution.
I simply want to include a link to the webinar, livestream, etc. When the user registers, in their confirmation email, a link to the online location of the event will be included in the body of the email, and hopefully in eventics.
Any suggestions?

CiviCRM uses the "system workflow templates" "Events - Registration Confirmation and Receipt (off-line)" and Events - Registration Confirmation and Receipt (on-line)" for its automated event emails.
You would need to edit those to include general information you would like to display for each event. This can be a bit tricky as all kind of process logic is crammed in the template but it should be doable. Be aware that you can use api calls to pull certain parameters in order to use within the template.
Additionally, in every event configuration screen (tab online registration) there should be a little text box that allows you to add some event specific text to the email.
If for some reasons that does not work for you, you may want to get in contcact with us as we are currently developing a coherent "event email extension" that allows users to easily set up event mails with certain trigger rules and provide many additional features. We are still looking for funding to complete the extension and it's documentation.


CiviEvent sends an invoice copy to every guest For a paid event set up in Civi 5.10.3 to allow 'Register multiple participants?', every person registered gets a PDF copy of the invoice with their registration confirmation if an email address is supplied.

I can't think of any good reason for this, particularly as the default, as it usually leads to confusion.

Is there any way to suppress this behaviour?

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

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


Access Denied to CiviMail Opt-Out Form The Unsubscribe link (in mailings) works fine if I am logged in as administrator, but I have "Access Denied" to the opt-out form if not.

(I have defined an Unsubscribe Group, with public visibility)

How can I fix that ?

There is a permission for it. Go to your Drupal -> People -> Permissions and give anonymous (and authenticated) permission to Unsubscribe:

Access CiviMail subscribe/unsubscribe pages


CiviMail not sending emails - Joomla 3.6 or 3.7 & Civi 4.7.18 I can send an email from any other area of Civi.  For example if I select a contact and send an individual email, it works...

BUT CiviMail - IS DRIVING ME CRAZY!!!

I am routing all email to spamexperts (using SMTP setting in Civi Admin) and again, it all works in other areas of the website, and even any other area of Civi itself.

I've check and confirmed the CRON job runs, I am even running it manually again just to be sure.  The CRON job for "send mailings" shows in the log that there is no errors, and everything is "sent" but it doesn't ever send any emails.

If I check the spamexperts delivery logs, I can see all my other emails going through that I send from other areas of Civi, but there is NO record of the civimail mailings even getting to spamexperts.

I am at a total loss, any ideas anyone?  I owe you big time if you can point me in the right direction!

It's not easy to get it working properly indeed.

Sending a "normal" email and civimails follow a different path. The former is simple: you call the "send an email" you configured (usually the mail() function, but can be configured, eg to use smtp directly), wait until it's done and that's it.

This doesn't scale and if you aim, like civimail does, at sending lots of emails, you need to queue these emails, possibly split them in separate batches and have a cronjob that process them in the background to send these emails

And were it becomes even more complicated is that you have a lot of different ways to run that cronjob, because civicrm aims at serving a lot of different configurations.... and each have lots of opportunities to have something not working.

As you are using joomla, the "common solution" we use (drush) isn't an option. You do not detail your system, do you:

have access to the command line (ssh)
can set up cronjobs
have php-cli installed and with the same configuration as the php used for your server?

You haven't described enough how have configured CiviCRM. If this is not how you are using it, could edit your question and add these details and what you get if you run

path/to/php /path/to/civcrm/module/bin/cli.php -s site -u user -p password -e Job -a execute

As described: https://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs


Update Credit Card info Permissions I don't believe that I am accomplishing a task correctly, and I'm afraid that I've opened things up too much.

I have given Subscriber level WordPress users access to CiviCRM: access CiviCRM.  This allows access to the Dashboard:
https://example.org/civicrm/?page=CiviCRM&q=civicrm/user&reset=1

Once there, then they can see and edit their donations, but only after giving access to CiviContribute: edit contributions.

The Dashboard seems to be a very useful feature, but I feel like I'm giving too much access in the ACL's.  With the above scenario, if I have access to the back end of Civi, I can now search for other people and change their contributions also, right?  How should I be doing this?  I feel like I'm missing something in the documentation, but can't seem to hit the right keywords.

Wordpress 4.2.2, CiviCRM 4.7.3

Is it possible to sign up as a subscriber without admin approval? If so remove the access CiviCRM permission right now!!! There is no way that with a publicly available account that I should be able to get any level of access to CiviCRM.

Apologies if I misunderstood and all subscribers need to be approved. Your case may be an instance where you want a custom portal - lots of orgs do this. Even then, they generally (is my understanding) allocate what can and can't be accessed without the access CiviCRM permission.

John


Unit Tests on Single DB My rig has a CMS & Civi combined database. This was to make life easier through drush sql-sync from @prod to @dev.

However, @dev is a vagrant box, with two databases, one for CMS, one for Civi.

When I run unit tests, instead of it cloning from the CMS database it clones from the old civi one.

My question is, how can I get it to clone from the CMS database? I've changed settings in the local test file and the civicrm.settings.php file.

Looks like the new, fledgling, e2e tests are my answer...


Caldera Forms and Smart Groups I want to have a newsletter signup form that has a dropdown field that a non-signed in user can select from. I want their selection to assign them to a smart group for later use in bulk mailings. What's the best way to accomplish this?

Jsgoti, Welcome to CiviCRM SE. You definitely achieve this using Caldera module. All you have to do is

1 - Create a form with First Name, Last Name and Email field and also drop down in Caldera form.

2 - Click on Processor tab.

3 - Add a new processor of type 'CiviCRM Group'.

Then configure the settings to link contact to group

Add condition by clicking condition tab to add to group based on selection.

HTH

Pradeep


Is the GDPR extension compatible with civicrm 4.6? Anyone tried adding the GDPR extension to a 4.6 site?

Cheers

Craig

We've just released a new version, 2.1, which is 4.6 compatible. The only difference is that in 4.6 installs the Forget Me function will not clear out IM messages as the API in CiviCRM crashes out.


Contact id as an URL Argument? I have developped an external php program to generate a customized contact data-sheet (pdf).

This program must be run from a Civi Page via an URL which requires the current Contact_id as an argument, in the following way :

https://www.mysite.com/fpdf/myprogram.php?contact=current contact id

How can I get and must I parameterize this current contact id ?

As an alternative, I could use the Current Drupal User-Id instead of the Civi Contact-Id (the user is supposed to be authenticated, and I know how to convert user to contact)

Another is convert your external program to an extension, then make api calls.


HELP CiviDiscount Auto-Apply feature not working! I'm using cividiscount 3.3 on civicrm 4.7.16 on Joomla 3.6.5. I created a discount code for current members to be applied automatically only it does not apply automatically. I can enter it manually. I've attached the code configuration, can anybody tell me what might be wrong? By the way I reviewed similar posts and some of the older posts are describing a patch but I'm thinking it was resolved in the latest version, 3.3? If not can someone please help?

Thanks]1

I figured it out. Users need to log in to Joomla to get the discount.


When are scheduled reminders for late registrants to events sent or not sent? After a small mess over the weekend with an online event login information not being sent, I'm trying to figure out when scheduled reminders are or are not sent for people who register for an event after the reminder was scheduled to send. If I can get some kind of idea what the behaviour is supposed to be, I will test and add this to the documentation.
So, case A: A contact registers after an event scheduled reminder was sent, but before the event starts. Do they receive the reminder? Does it matter how the reminder was set (at a specific date time versus X hours or days before the event starts)?
Case B: A contact registers after an event scheduled reminder was sent, but while the event is happening. Do they receive the reminder? Does it matter how the event was set up, as above?
Case C: A contact is registered for the event after the event ends. Do they receive the past scheduled reminder? Does it matter how the event was set up, as above?
Opinions on what should or does happen seem to be mixed. See other questions here, here, and here. Is there actually a 24 hour test that will send scheduled reminders from 24 hours before the registration but not before? Are there additional rules?

Good question with several permutations! Here's a partial answer from experience.

Case A: A contact registers after an event scheduled reminder was
sent, but before the event starts.

It is sent. The timing will be whenever your Send Scheduled Reminders scheduled job runs. It occurs when you set x time before and based on this answer specific time it will not.

Case B: A contact registers after an event scheduled reminder was
sent, but while the event is happening.

It is sent.

Case C: A contact is registered for the event after the event ends.

Not sent.
I've not seen a 24 hour test.


Why don't Organisations have Contacts? Please excuse the Newbie question.
When I click New Organiasation, why can't I add a "Lead contact" to the Organisation.
Do I have to set up an individual first, and link them?!

Thanks,

Jeremy

Yes, you have to set up an organization and then an individual. Next step is then to link them with a relationship.  You can either use the relationship tab and add one, or fill in the name of the organization in the "employer" box when you add an individual. The latter will automatically create a relationship of the type "Employee/Employer".

As CiviCRM is targeted at non-profits it does not automatically work with leads :-) In quite a lot of cases the term "lead" would mean absolutely nothing.


Where does Mosaico store my templates? Setting up Mosaico. I have created a new template from one of the existing base templates. I save my new template, which now appears as a 'configured template'. I'd like to tweak the code for this new template, but I can't find the template on my server. Mosaico Settings suggests that it might be in [civicrm.files]/mosaico_tpl, but no such directory exists on my server.

The templates are stored in your CiviCRM database in the table civicrm_mosaico_msg_template. They are not saved as actual files. BTW Im assuming you are using the Mosaico extension?
If you go to CiviCRM->Mailings->Mosiaco Templates you get full options for tweaking existing templates, copying them and so on. See attached image.


payment_instrument_id is not a valid integer | Importing contribution just want to ask quick question.

I'm trying to import contribution from my csv files.
In my csv files, I put the value of column Payment method as : Others, Cheque, Credit Card. (All the value has been set on Option value)

Then when I try to upload the csv files, I got the error reason :

payment_instrument_id is not a valid integer

The error is found at Import_Errors.csv files.

Do you have any clue about what's happening?

If you guys found similar issue with me. Please check whether you've already made some changes to Payment Method option value which is by default you could access it by http://yoursiteurl.com/civicrm/admin/options/payment_instrument?reset=1

Revert the changes you've made to default value, and try to re-upload/re-import the contribution. It solved my problem.


Weight Threshold error when creating a Deduplication Rule This is on CiviCRM 5.36.
I try and create a rule with, say, First Name and Last Name, both having a weight of 10.  If I set any Threshold greater than 10 so as to require both to match, I get the error:
Weight Threshold to Consider Contacts 'Matching':  11  Total weight must be greater than or equal to the Weight Threshold.
I first saw this when trying to change the usage on an existing rule which had worked previously.

This has been fixed and will be part of next 5.36 release this week.
You can either wait for the never version release or apply patch from here.
HTH
Pradeep


PayPal Pro Button not working - returns to blank event form We use PayPal Pro for our event pages. This is what is currently happening:
Person fills in the event registration profile.
Person clicks PayPal checkout button, enters their PayPal information.
When the person clicks Continue, they are returned to our registration form. All of the profile information they had entered is gone. If they reenter all the info and click continue, they get an error message saying they didn't fill in the credit card information.

If people enter their credit card information on our registration form (instead of using the PayPal check out button), everything works.

How do we fix the PayPal button? Or can we remove it?

We are using CiviCRM 5.12.0 with WordPress and PayPal Pro.

I encountered this bug myself last week and fixed it; I forgot about this post until @herb posted a comment on it.

The fix will be in CiviCRM 5.25+, but the bug is logged as https://lab.civicrm.org/dev/financial/issues/119, and the fix is incredibly simple to apply.


"lost" main & secondary menu (drupal) I have stupidly unticked both the main and secondary menu in the Bootstrap settings options (too many windows open!). I have lost both the Drupal and Civi menus and basically all administrator ability to access/edit anything via the frontend.. :(

I can get back to the Bootstrap settings page via the browser back button but now just get and now get "access denied" if i try to re-enable the menus. Any pointers where to go on the backend to restore? Many thanks.

First, it's possible it's just your login session got ended, so if you haven't already tried I'd try just logging in again.

Otherwise there might also be more going on that's not related to the main/secondary menu because it looks like you have something customized, but you can try this directly in the database to reset. Assuming drupal 7.

update variable SET value = 'a:15:{s:11:"toggle_logo";i:1;s:11:"toggle_name";i:1;s:13:"toggle_slogan";i:1;s:24:"toggle_node_user_picture";i:1;s:27:"toggle_comment_user_picture";i:1;s:32:"toggle_comment_user_verification";i:1;s:14:"toggle_favicon";i:1;s:16:"toggle_main_menu";i:1;s:21:"toggle_secondary_menu";i:1;s:12:"default_logo";i:1;s:9:"logo_path";s:0:"";s:11:"logo_upload";s:0:"";s:15:"default_favicon";i:1;s:12:"favicon_path";s:0:"";s:14:"favicon_upload";s:0:"";}' where name='theme_seven_settings';

You might have a custom theme so the name= part might need adjusting. You can do

SELECT * FROM variable WHERE name like '%_settings'; to see what you have.


Paths are inconsistent We are having an issue where the /bower_components and /packages paths are being rendered differently than other paths. This is causing the JQuery and other components to not load correctly. I've tried setting this in civicrm.settings.php, but can not see to get them to use the correct URL
CiviCRM 5.25.0, Drupal 7.72, Panheon is the host (thus the path weirdness)
<link type="text/css" rel="stylesheet" href="https://carolinaclimbers.org//srv/bindings/e138c004c7534c17a7b6a73b59bc743dsites/all/modules/civicrm/bower_components/select2/select2.min.css" media="all" />
<link type="text/css" rel="stylesheet" href="https://carolinaclimbers.org/sites/default/files/css/css_QSUBb92PTdLEfkMP9h64X2An1s-ea4NW9lWznW1IB3U.css" media="all" />
<link type="text/css" rel="stylesheet" href="https://carolinaclimbers.org/sites/default/files/css/css_k0Qak2KC5ckGFoWNds-UCkJ19u5TyvmyprcB27dAxHw.css" media="all" />
<link type="text/css" rel="stylesheet" href="https://carolinaclimbers.org/sites/default/files/css/css_KLevn940KsaVS6iNiCt9sY13XTqU54F_5IOxYTblXpA.css" media="all" />
    <script type="text/javascript" src="https://carolinaclimbers.org/sites/default/files/js/js_h8Od-FAGkhR_7A30HaaMaTrO_5Hale-5uw8QHV7ogq0.js"></script>
<script type="text/javascript" src="https://carolinaclimbers.org//srv/bindings/e138c004c7534c17a7b6a73b59bc743dsites/all/modules/civicrm/bower_components/jquery/dist/jquery.min.js"></script>
<script type="text/javascript" src="https://carolinaclimbers.org//srv/bindings/e138c004c7534c17a7b6a73b59bc743dsites/all/modules/civicrm/bower_components/jquery-ui/jquery-ui.min.js"></script>
<script type="text/javascript" src="https://carolinaclimbers.org//srv/bindings/e138c004c7534c17a7b6a73b59bc743dsites/all/modules/civicrm/bower_components/lodash-compat/lodash.min.js"></script>
<script type="text/javascript" src="https://carolinaclimbers.org//srv/bindings/e138c004c7534c17a7b6a73b59bc743dsites/all/modules/civicrm/packages/jquery/plugins/jquery.mousewheel.min.js"></script>

the l-10n-js script has these lines:

CRM.config.resourceBase = "https:\/\/carolinaclimbers.org\/sites\/all\/modules\/civicrm\/"; CRM.config.packagesBase = "https:\/\/carolinaclimbers.org\/\/srv\/bindings\/e138c004c7534c17a7b6a73b59bc743dsites\/all\/modules\/civicrm\/packages\/"; – Brian Payst 1 min ago     Edit

This ended up being a Pantheon environment variables and path change, I fixed if following the suggestions here, edited for my non-starter kit environment: github.com/herbdool/civicrm-starterkit-drops-7/pull/17/commits/


Setting up non-Admin user account in Drupal / CiviCRM - Menu bar not visible When I create a user account with authenticated user permissions + some additional create/edit permissions, the Drupal Menu-bar or the CiviCRM menu-bar doesn't show. Only when I add the admin privileges to the user account, do I see the menu bar. So how is a non-admin person supposed to navigate between the various modules (contact/ membership/ event/ contribution etc.) without having full admin rights? Am I missing something? Thank you for your help.

One option would be to create a Menu Block or just a Block with some links and set it in to a region with settings so it only shows for Authenticated

But also, am unclear if you really want a non-admin person getting to those 'modules'.

If a non-admin person is making donations, registering for events they do not need access to CiviCRM itself.

Perhaps update your Q with more detail about what the non-admin person needs to access perhaps by providing the paths you want them to get to so you avoid saying 'member page' which could be construed in many ways. HTH


Switch template in extension Extension loads and I added the following hook to switch demographics template:

function myext_civicrm_alterTemplateFile( $formName, &$form, $context, &$tplName) {
switch($tplName) {
    case "CRM/Contact/Form/Edit/Demographics.tpl":
      $mytpl='../templates/CRMContactFormEditDemographics.tpl';
        $template = CRM_Core_Smarty::singleton();
        if ($template->template_exists($mytpl)){
          $tplName=$mytpl;
        }
    break;
  }

}

I think this worked before. What did I wrong? I put a breakpoint with my debugger or let it run to cursor position, but it never even gets there, so I can't figure out what's wrong.

I use alter template file in 4.7.2. It has been working great for me.

I needed to switch out the contact editor form based on contact subtype. One important thing I found if doing this programically was the clear the template cache.

function customcomponent_civicrm_alterTemplateFile($formName, &$form, $context, &$tplName) {

    // swith contact template based on contact type
    switch ($formName) {
        case 'CRM_Contact_Form_Contact':

            $clear = true;

            if ($form->_contactType!='Individual'||empty($form->_contactSubType)) break;

            // there are some weird non printable chars on contact sub type
            $contactSubType = preg_replace('/\W/i','',$form->_contactSubType);

            // switch out the form based on contact type
            $newTpl = 'CRM/Contact_'.$form->_contactSubType.'/Form/Contact.tpl';
            $newDir = __DIR__ .'/templatesconditional/ContactSubType_'.$contactSubType;

            break;
    }

    // clear out old templates -- found CRM_Admin_Form_Setting_UpdateConfigBackend::postProcess -> CRM_Core_Config::cleanup
    if (!empty($clear)) {
        $config = CRM_Core_Config::singleton();
        CRM_Utils_File::cleanDir($config->templateCompileDir, false);
        CRM_Utils_File::createDir($config->templateCompileDir);
    }

    // switch out the templates
    $template = CRM_Core_Smarty::singleton();
    if (!empty($newTpl)&&$template->template_exists($newTpl)) $tplName = $newTpl;
    if (!empty($newDir)&&is_dir($newDir)) $template->addTemplateDir($newDir);
}


Datepicker not visible I am unable to use datepicker with popup forms enabled - calendar does not appear active on top of the form but underneath (discovered after reducing and moving the form around). It works with popup forms disabled. Help, please!

.

Using WP 4.7.3, CiviCRM 4.7.17

Candidate theme comes with 'Indeed Social Share & Locker Pro' plugin which seems to be conflicting with CiviCRM


How can we increase the number of events displayed when creating Joomla menu link? We host 100+ events per year. We create a Joomla menu link to each event, but only 25 events are available to be selected. Which file contains the limiting variable?

We are using CiviCRM 3.4.5 on Joomla 1.5.2.

Wow, blast from the past!  I actually remember this bug:
https://issues.civicrm.org/jira/browse/CRM-8620

It should, by default, show only the upcoming events.  This may not solve your entire problem, since you may have dozens of upcoming events, but at least the past events shouldn't clutter you up: upgrading to 3.4.8 should help you.

Now, for a thousand reasons, you really should migrate to a current Joomla version and upgrade to CiviCRM 4.6.1.  That's a tall order at this point, since you've got years of deferred maintenance, but you should at the very least get yourself up to Joomla 1.5.26 and CiviCRM 3.4.8 as soon as possible.  The Joomla code is so old that it's on a "legacy" download page.  CiviCRM 3.4.8 can be downloaded from SourceForge.

It's vital to keep your system up-to-date.  Regardless of what you do about this issue or doing a point-release upgrade of CiviCRM and Joomla, you should make plans now for migrating to a new website (there's no direct upgrade path from Joomla 1.5.x) and moving and upgrading your CiviCRM database there.


Update to 5.29.0 get frozen When updating civicrm/civicrm-core (5.28.3 => 5.29.0), the process get frozen while
[Executed: Upgrade DB to 5.29.alpha1: Fill civicrm_relationship_cache (1 => 5000)]

After reinstallation of a backup and removal of all caches, still the update gives a same frozen installation.
===========
Here's what I found in the Civi logs:
465 Sep 07 20:44:40 [info] $CRM_Queue_Page_AJAX_runNext_error = PEAR_Exception: "DB Error: constraint violation"

421 Sep 07 20:44:40 [debug] $backTrace = #0 /PATH/vendor/civicrm/civicrm-core/CRM/Core/Error.php(937): CRM_Core_Error::backtrace("backTrace", TRUE)

385 Sep 07 20:44:40 [error] $Fatal Error Details = Array

383 Sep 07 20:44:39 [info] Running task: Upgrade DB to 5.29.alpha1: Fill civicrm_relationship_cache (5001 => 10000)

381 Sep 07 20:44:37 [info] Running task: Upgrade DB to 5.29.alpha1: Fill civicrm_relationship_cache (1 => 5000)

379 Sep 07 20:44:37 [info] Running task: Install eventcart extension

377 Sep 07 20:44:36 [info] Running task: Upgrade DB to 5.29.alpha1: SQL

375 Sep 07 20:44:36 [info] Running task: Upgrade DB to 5.29.alpha1

373 Sep 07 20:44:35 [info] Running task: Begin Upgrade to 5.29.alpha1

371 Sep 07 20:44:35 [info] Running task: Checking extensions

369 Sep 07 20:44:34 [info] Running task: Cleanup old files

=========
In Drupal's logs :
Message Warning: Declaration of CRM_Volunteer_BAO_Project::copyValues(&$params, $serializeArrays = false) should be compatible with CRM_Core_DAO::copyValues($params) in require_once() (line 36 of /PATH/web/sites/default/files/civicrm/ext/org.civicrm.volunteer/CRM/Volunteer/BAO/Project.php)

We got this on one of the db upgrades. For us, it was due to few entries in civicrm_relationship table which were attached to permanently deleted contact ids. You can follow the below steps to complete the upgrade process.

Take a separate back up for civicrm_relationship table.

Check invalid entries using -
select id
from civicrm_relationship
where contact_id_a not in (select id from civicrm_contact) OR contact_id_b  not in (select id from civicrm_contact)

Delete these rows
delete from civicrm_relationship
where contact_id_a not in (select id from civicrm_contact) OR contact_id_b  not in (select id from civicrm_contact)

Complete the upgrade process. Hope that works.


CiviCRM API with Custom Data mixed with Standard Entities I'm using CiviCRM 4.6 with the new API editor.

I'm attempting to chain a bunch of queries together, which provide cases for a client within a period, along with the linked contact, along with custom data from the case entity, and the contact entity.

I'm wondering the best way to chain this query together?
The new case Entity allows retrieval of cases, by case type. If I chain the Contact entity to it via {"cid":"cid"} I obtain a list of client details... However both return just standard fields.

If I enter return fields and select the custom fields, these do not appear in the final result.

So what is the best way to query certain custom field values, which are specific to the case and client? i.e. A custom field ID#370 in Custom Field Group ID#55 for the client, which is a custom field attached to the case.

I also noticed that  querying the API for custom fields does not  return  them  unless they are specified in the  return fields.  But the field that is  listed in the API explorer in not the actual field name,  I could not get the  fields  to return using their "title names"  but they do when using the custom_xx  field name.


back-end checkboxes not displaying after switch to Shoreditch After switching to the shoreditch theme, the checkboxes on our back-end site are not displaying appropriately in all situations.

When listing Contacts from a search, the checkboxes that should be in the left column only show up if you click in that column within a few seconds after the page loads. If you wait a bit, they do not show up at all.

When merging contacts, the checkboxes to select what data to merge do not show up at all.

I haven't exhaustively looked at every instance, but Checkboxes display appropriately when listing a Contribution search.

I can replicate this behavior on both Chrome and Safari. CSS shows the following in /media/civicrm/custom_ext/org.civicrm.shoreditch-master/css/custom-civicrm.css?r=65LNz:

.crm-container input[type=checkbox], .crm-container input[type=radio] {
    display: none;}

This css file is so large that I'm cautious about just unsetting the display property, not knowing exactly what cascade that might cause. Anyone have a clue about this?

Further, as part of the extension, I assume any edits to this file will be overwritten on the next update.

Is there a location where I can set up my own custom css file for Civi (other than my global CSS.) while still using the Shoreditch theme? (We've been using a custom civi css file up to now, but that's not an option with Shoreditch.)

I've discovered that the Shoreditch README states that "At the moment the theme is being developed to work only in Drupal." The CiviCRM extension page for Shoreditch, however, states, "CMS Compatibility:
CMS Independent (CiviCRM-native)". Shoreditch, however, is still required for Mosaico, which does work correctly with Joomla.

So, apparently, my expectations that Shoreditch will work correctly as the Civi theme with my Joomla installation are incorrect, and I'll move back to my custom css.

It would be helpful if the extension page would clarify what Shoreditch is expected to do and not do for non-drupal users.


Contributions with Frozen Financial Type Field I'm finding that some contributions do not allow financial types to be changed. Normally there is a dropdown that allows a user to select a different financial type, but sometimes the field is frozen (see screenshot). Can someone explain this, or provide a solution?

Are they related to membership or event fees? Maybe coming from here:

https://github.com/civicrm/civicrm-core/blob/5.15.1/CRM/Contribute/Form/Contribution.php#L825


CiviRules - When does the 'Membership Payment Added' trigger fire? I am using CiviCRM 5.13.4 and CiviRules 2.9.

I am using CiviRules to send an email to Contacts when they sign up for a Membership, but do so using 'Pay Later', to remind them how to pay etc.  The sign-up is via a Webform, but I'm not sure that matters.

The rule is set up to fire on 'Contribution Added', tests for the 'Pending' status and sends the Email - which all works OK.  The email uses a Template which contains (custom) tokens which fill in the Membership Type and Price into the text to be sent.

If I test this Template in a static environment, i.e. some time after the payment was made it works correctly, but when triggered by the Rule those Tokens just return empty.  I strongly suspect that this is because when the rule fires the Contribution record has been added to the database, but the Line Items which connect it to the Membership information have not yet been created.

When does the 'Membership Payment Added' trigger fire, and would it solve my problem?  Or is there another way?

Thank You.

I had this issue too with event registrations, I added a five minute delay to the civirule and it seemed to clear up that issue.


Setting up PayPal Pro in CiviCRM Currently trying to set up PayPal Pro as a Payment Processor in Civi 4.6.7, following the instructions here:

http://wiki.civicrm.org/confluence/display/CRMDOC/PayPal+Website+Payments+Pro+and+Express+Configuration

Am I right in thinking that this requires the PayPal Classic API instead of the PayPal REST API? The instructions seem to differ quite a lot from what is presented on PayPal Dev.

Thanks

Hopefully someone else more knowledgeable chimes in, but in short: yes.  The PayPal payment processor uses the older PayPal APIs.  My understanding is that the new APIs are actually the PayFlow APIs, and thus are compatible with the PayFlow processor plugin.  Each time this has come up for me, we were able to get the older API from PayPal, but you need to speak on the phone to a person.


Error "Cannot unset string offsets" exporting using custom field mapping I'm running civiCRM  5.17.5 under Joomla 3.9.12

When I select a specific smart group with a saved field mapping for export, and select "Exclude contacts with "do not mail" privacy, no street address, or who are deceased.",

I get the error (note the error doesn't appear if I don't select Exclude contacts...):

Error#8247
message => string(27) "Cannot unset string offsets"string => string(0) ""
code => 0
file => string(102) "/home/fcwm/public_html/administrator/components/com_civicrm/civicrm/CRM/Export/BAO/ExportProcessor.php"
line => 176
trace => array (20)
previous => NULL

Cannot unset string offsets
.../administrator/components/com_civicrm/civicrm/CRM/Export/BAO/ExportProcessor.php:176
171   public function setAdditionalFieldsForPostalExport() {
172     if ($this->getRequestedFields() && $this->isPostalableOnly()) {
173       $fields = ['is_deceased', 'do_not_mail', 'street_address', 'supplemental_address_1'];
174       foreach ($fields as $index => $field) {
175         if (!empty($this->getReturnProperties()[$field])) {
176           unset($field[$index]);
177         }
178       }
179       $this->additionalFieldsForPostalExport = array_fill_keys($fields, 1);
180     }
181   }

This error wasn't occurring prior to upgrading to 5.17.5

It doesn't happen with all my Saved field mappings, just one of them (but one I've been using for a few years without issue).

This was fixed in today's release (5.18.1)


How to setup email verification for newsletter signup using webforms? I am creating a webform for newsletter signup. Form elements are First & Last name & Email address. Once they signup, a confirmation email is sent.

Now, I would like to include a link within the email to verify the email address they have provided and then create the contact. Is it something possible to do?

If you're looking for technical validation try this:

Create a webform field type Email
Install Webform validation module (if you don't already have it) and implement rule "Equal Values".
Apply validation rule to emails for webform and CiviCRM by using the checkbox.


Problem with membership on behalf of orgnization We accept registrations on behalf of organizations.  We have been requiring users to provide organization level data when purchasing a membership.  However, after filling out the membership contribution page and clicking Next to confirm the data, the organization level data does not show on the confirmation screen.  Additionally, after clicking the button to finalize the payment, we receive error messages that all organization level data is missing and must be provided even though we have filled in the data.  We have noticed that if we make the organization level information optional, rather than required, and the user chooses to register on behalf of an organization, the process works fine.

We are running 4.7.3 with WordPress 4.4.2.

Error screenshot:


Log filled with CRM_Utils_System::permissionDenied My CiviCRM-logs are filling up with entries like this:

Aug 20 22:03:29  [info] $Fatal Error Details = Array
(
  [message] => Du har inte tillrÃ¤cklig behÃ¶righet fÃ¶r att se denna sida.
  [code] =>
)

Aug 20 22:03:29  [info] $backTrace = #0 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(364): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Utils/System/Joomla.php(455): CRM_Core_Error::fatal("Du har inte tillrÃ¤cklig behÃ¶righet fÃ¶r att se denna sida.")
#2 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Utils/System.php(277): CRM_Utils_System_Joomla->permissionDenied()
#3 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(232): CRM_Utils_System::permissionDenied()
#4 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:15))
#5 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#6 /var/www/events/components/com_civicrm/civicrm.php(86): CRM_Core_Invoke::invoke((Array:3))
#7 /var/www/events/components/com_civicrm/civicrm.php(11): civicrm_invoke()
#8 /var/www/events/libraries/cms/component/helper.php(392): require_once("/var/www/events/components/com_civicrm/civicrm.php")
#9 /var/www/events/libraries/cms/component/helper.php(372): JComponentHelper::executeComponent("/var/www/events/components/com_civicrm/civicrm.php")
#10 /var/www/events/libraries/cms/application/site.php(191): JComponentHelper::renderComponent("com_civicrm")
#11 /var/www/events/libraries/cms/application/site.php(230): JApplicationSite->dispatch()
#12 /var/www/events/libraries/cms/application/cms.php(252): JApplicationSite->doExecute()
#13 /var/www/events/index.php(45): JApplicationCms->execute()
#14 {main}

Time interval between entries range from a minute to a couple of hours, but many entries during a day.

Does anyone have any idea why this might be? Or where to start hunting it down.

It appears that the error simply is reporting that someone is trying to access a CiviCRM page and they do not have sufficient permission to access it.

This is either due to an authorized person trying to access the page, but not having sufficient permission set, or to some unauthorized person (robot?) attempting to access the page.

I would probably try to contrast the error messages with the web server access log to try to identify what page is being attempted to be accessed, and its IP address.  If it's a robot you may be able to detect that as well. (It could simply be a search engine robot that knows of the page and is regularly attempting to access it without the proper credentials.)


New 'Contact Exported' and 'Activity Exported' activity One of our clients has noticed that every time they export a contact (Adv Search or via a Report) an activity is created against each contact of type 'Contact Exported' with the date and the staff member who ran the export. They do a lot of exports and its causing a problem.
Has anyone seen this before?
I'm pretty sure its not a core function (or if it is its new). I think someone may have installed an extension then removed it but its left this function in place.
Olly

The latest version of the GDPR extension does this. It records when contacts have been exported for audit purposes.


How to create latitude and longitude automatically for civirm contact I want to generate latitude and longitude automatically for CiviCRM contact when the address is present.

How to achieve this?

You need to enable Mapping and Geocoding from civicrm/admin/setting/mapping?reset=1

Enter your API Key or Application ID. An API Key is required for the Google Maps API. Refer to developers.google.com for the latest information.
Save the form and you should be able to see latitude and longitude based on your contact's address. Note that it displays when you click on inline edit and load the address form as shown below.

Also see https://docs.civicrm.org/user/en/latest/initial-set-up/mapping/


Automated Messages - Welcome message not working I've had one of my colleagues request an email to be sent when users sign up to one of our mailing list, I've got a profile set up for the sign up process and the users are added to a specific group. Upon testing I realise that no automated welcome are being sent when users sign up for any of the mailing lists. Is there a way to disable this function (other than disabling it on the Headers, Footers, and Automated Messages listings?) or is there settings that need to be set before it will send.

Out bound email is working fine and opt out messages are working fine!

To clarify, there are a few features you are mentioning that work as follows:

Notification of a profile form submission is managed in the Advanced Settings of the profile (reached by clicking on the Settings hyperlink to the right-hand side of the profile) - typically this would be the email of someone on staff/responsible for follow up:

You ask how to disable the option of automated emails being sent in conjunction with the headers and footers of mass email - but I think you meant to ask whether it is possible to send an automated message after profile submission to the person who is submitting the profile (please correct me if I'm wrong), but if I'm right, there are two ways to go about this:

Enable the double opt-in process feature that sends a very generic email asking the contact to confirm their subscription. You can read more about it HERE.
If you want to send a warm and fuzzy welcome message, then you could accomplish this with the use of a handy extension called CiviRules - if you don't have this extension, have your system admin install it - once it is enabled, you would first create your welcome message template(s), then configure the rule as follows:

Trigger = "Contact is Added to Group"
Condition = "Contact (not) in group" > Save
On the next screen of the Condition, leave the default of "In one of selected" and click to highlight the group(s) of interest (these would be your mailing groups as configured in the profile - if you want to send a different email to each group, then you'll need to create a separate rule for each group)
Action = "Send email" > Save
On the next screen of the email, there are detailed instructions at the top of the screen - the default behavior is that the email is sent to the primary email address of the contact who is submitting the profile (which is what you want), so don't toggle the "Send to Alternative Email Address" option
Test the rule(s) out by submitting the profile and confirming that you receive a welcome message

Note:
You often have to save to get to the next step of the configuration in CiviRules, so when in doubt, click the Save button and see what's on the next screen :-)

Hope this helps!


ProPublica Congressional API CiviCRM Module Until 2014 there was active development on the Sunlight Congress API and there was and is a CiviCRM module that uses the Sunlight Congress API to make Congress data available to CiviCRM.

ProPublica has taken over development of the Sunlight Congress API and merged it with it's own Congress API

Is anyone planning to update the CiviCRM Sunlight Congress API module to work with the ProPublica Congress API module so that CiviCRM maintains the ability to link to information about the activities of Congress?

The successor to the Sunlight API Dupal module is the Civi-native Electoral API extension.  I wrote documentation back when I was collaborating on the project, but it seems to have been taken down.  I will investigate finding a copy and getting it online.

You may also be interested in the CiviCRM for e-advocacy page.


Unable to manage CiviCase cases I've installed CiviCRM, and made sure my Drupal 8 role settings give Admins full permissions for CiviCRM.
I am able to create cases for constituents, but cannot do anything else such as add Activities, Timelines, sort/filter by status, or see whatever is behind the hamburger menu beside the status, access the settings on the Activities tab, etc.
On the Summary tab there is a "Tasks" section but from the documentatio, I don't know what that's for and I don't see any option to add a task.

If you are using shoreditch then this might be the problem as currently it's not guaranteed to work on drupal 8.
It is a requirement for the CiviCase extension - but you can use CiviCase component without the extension.


Are there Realease Notes when a new Release is published? There is a new Civi release about every fortnight (or even less) (currently 5.18.1).

Updating one's configuration at every release is painful and risky (you may have regressions) ; but it can also be very useful (bug fixes, ans enhancements).

So, it would be very useful to know what changes are brought by a new release.

... which is the usual purpose of Release Notes.

I could not find such assciated release notes. Are there any ? If yes, where can we find them ?

You should find release notes for all versions linked from https://civicrm.org/blog/tags/release (this page is linked from the download page). Maybe they haven't added in the latest yet: 5.18.0 not there either

https://lab.civicrm.org/dev/core/blob/master/release-notes.md links to all the release notes including 5.18.0 and 5.18.1


How can I make a filter to exclude someone who has a certain tag assigned to them? (or custom data field yes/no type) I'm trying to set up a view (kind of an admin report view) which shows a list of members based on certain filters set up in the view. This is for a large homeschool coop.

membership type (exposed - user select which type)
membership status (current, new, grace)
filtering out those with Do Not Email option checked since this leaves us mostly with those attending our coop days (primary member and kids)
contact sub type (exposed - user can select adult and/or child)

I have two issues.

The first is that instead of checking for the Do Not Email option, I would much rather be showing Primary Membership Member. But then I have trouble showing the kids as well. I haven't yet learned enough about Views to figure this one out, but I'm getting there slowly but surely. Pretty sure I can figure this out eventually. I can live with current solution for now.

My main problem is that I need one more filter. Some kids in an otherwise active family no longer attend coop (gone off to college, whatever), so I have a Custom Data field to indicate that they are inactive. I have also tried a tag called Inactive Child.

I can't filter on either of these though. I set up a filter and set it to show all records that DON'T have the tag or the custom data field option checked and I get incorrect results for tags (shows people who have any tag at all, not just the one I chose and doesn't show anyone with 0 tags), or NO results (when I use the custom data field). If I set the filter to SHOW those contacts with those option(s) checked, it works. But I can't seem to EXCLUDE them from my results.

Pretty sure I am missing something with how to set this up correctly, but after about 7 hours of trying, I haven't figured it out.

Thank you!

Drupal 7.41
CiviCRM 4.6.11

For the filter part: different types of custom data result in different filter operators being shown in the filter configuration screen.  You can experiment with adding different custom types to see the effect on the available operators.

For your purposes, you could add an "Inactive" field of type Alphanumeric, Text.  In the view configuration for the filter you should then have the "Is empty (NULL)" operator option.  Configuring the filter with that will remove from your view any records that have something in the Inactive field (yes, moved, gone to college etc).

(NB 'text' is not necessarily the best choice from a pure Civi perspective but it will do what you need with Views.  If the "Is empty" operator becomes available on more types in future you might prefer one of those.)


How to print variable/debug data from your extension.php? I am trying to add a menu entry in the navigation, but this is causing the navigation menu to disappear, I am trying to debug the code but could not find any particular file.

I have checked the following:

Browser's Javascript Console
CiviCRM logs from ConfigAndLog folder
Apache2 log

Is there anything else I should check? Is there any way I can print the data in the extension_civicrm_navigationMenu(&$params) function?

(Update) As of v4.7.0, the approaches below still work, but there's a better way to write to the log file using a PSR-3 logger, e.g.:

Civi::log()->info('Hello, log!');
Civi::log()->error('I'm sorry, {name}. I'm afraid I can't do that.', array(
  'name' => 'Stanley Kubrick',
));

See also:
https://civicrm.org/blog/totten/the-static-is-dead-long-live-the-static

To write out to CiviCRM's ConfigAndLog folder, one can use either:

CRM_Core_Error::debug_log_message('hello log');
CRM_Core_Error::debug_var('name', $var);

There's also an experimental PSR-3 logger (CRM_Utils_SystemLogger) which writes out to the database (table civicrm_system_log), e.g.

$log = new CRM_Utils_SystemLogger();
$log->info("hello log");
$log->error("I'm sorry, {name}. I'm afraid I can't do that.", array(
  'name' => 'Stanley Kubrick',
));

If the debug statement is temporary (won't be committed/redistributed), then you can usually use CMS-specific functions (like Drupal devel's dpm() or Joomla's JLog).


Can't Add Profile To Contribution Page I get this error when I try to attach a profile for the SignUp Form.
I noticed also that in the Profile Tab of the Contribution the Civicrm Profiles are not displayed in a drop down. Instead what you have is a text form.

I am using Civicrm 4.6.8 with Wordpress4.4.2.

Profiles that have fields from things other than contacts (and subtypes) and contributions can't be used on Contribution pages. Check to make sure you haven't included a core or custom field for a different type of object like an event registration, memebership, activity, etc. on the profile(s) you want to display on the contribution page.


Adding Sub-Options of Custom Data Maybe I didn't know, but I didn't know.
I need to add a sub-option to private recipients. I can explain this with an example.

Suppose you have an option. When I make a choice here, there must be sub-options that are optional in this option.

Apple

White Apple
Green apple
Red Apple

Pear

White Pear
Green Pear
Red Pear

Joomla 3.9.3
CiviCRM 5.10.2

As far as I know you can not create (sub)options depending on the value of a (top) option in core CiviCRM. So that would mean you would have to develop a little extension that does this?

As far as the county stuff goes, is that an unrelated question? If so can you please make it separate as it will be impossible to find if others experience the same issue.


Get a view of upcoming activites for cases I am using the lastest version of CiviCRM in the latest version of Joomla

I am trying to use CiviCase to manage workflows but I find the interface counter intuitive

I want to see a list of my upcoming activities for all my cases and filter them by today, this week, etc.

The case dashboard shows mycases with upcoming activities and groups all the activities under each case

This is hard to get an overview of your activities for a certain time period

Is there a way to search case activities by scheduled date and show only the activities themselves or is there an extension that shows all your upcoming activities in one widget, stream or calendar

Thanks in advance for helping out a newbie

You can use the data processor extension for creating views/reports in CiviCRM.

You can find documentation on how to install extension here

There is not much documentation (yet) but there is an example documentation on how to create a search/report: https://lab.civicrm.org/extensions/dataprocessor/blob/master/docs/how_to_create_search.md


Can't add dashlets on dashboard on Drupal 7.67 + CiviCRM 5.32.2 I do can see the dashlets but I lost ability to add and suppress them, so I guess Ajax doesn't work any more. It stopped working with the upgrade to 5.32.2 before it was functioning.
Clicking on the cross also has no impact but I can move them once added on the dashboard.
Changing the jquery version in theme settings doesn't help (I've tried various versions from 1.4 to 3.1).
Is there a special setting in CiviCRM or is it a bug in 5.32.2?

These are the message in the javascript console:
Uncaught SyntaxError: expected expression, got '}' js_tirzwVKQe_kXpvFPxNVA-vmv7H54qthEMinEoehf1m8.js:12:51
else this._+='L'+(this._x1=t)+','+(this._y1=n);else},arc:function(t,n,e,r,i,a){t=+t,n=+n;var l=(e=+e)*Math.cos(r),f=e*Math.sin(r),u=t+l,c=n+f,s=1^a,o=a?r-i:i-r;if(e<0)throw new Error('negative radius: '+e);null===this._x1?this._+='M'+u+','+c:(Math.abs(this._x1-u)>1e-6||Math.abs(this._y1-c)>1e-6)&&(this._+='L'+u+','+c),e&&(o<0&&(o=o%Ua+Ua),o>Dp?this._+='A'+e+','+e+',0,1,'+s+','+(t-l)+','+(n-f)+'A'+e+','+e+',0,1,'+s+','+(this._x1=u)+','+(this._y1=c):o>1e-6&&(this._+='A'+e+','+e+',0,'+ +(o>=Fa)+','+s+','+(this._x1=t+e*Math.cos(i))+','+(this._y1=n+e*Math.sin(i))))},rect:function(t,n,e,r){this._+='M'+(this._x0=this._x1=+t)+','+(this._y0=this._y1=+n)+'h'+ +e+'v'+ +r+'h'+-e+'Z'},toString:function(){return this._}};function ri(){};function gt(t,n){var r=new ri;if(t instanceof ri)t.each(function(t,n){r.set(n,t)});else if(Array.isArray(t)){var a,e=-1,o=t.length;if(null==n)for(;++e<o;)r.set(e,t[e]);else for(;++e<o;)r.set(n(a=t[e],e,t),a)}

Most likely there is a js code error somewhere on your site (could be from any module). Keep debugging it by clicking the error message in the console.
But FYI, CiviCRM v5.33 comes with completely rewritten dashboard code. So upgrading may solve your problem too.


Problem with loading (jqery / css) CiviCRM files in Joomla 3.4.8 Jqery / css etc. CiviCRM files from the folder: components/com_civicrm are not loaded.

In another site they are loaded well, see links below.

Both sites are in Joomla 3.4.8 with CiviCRM 4.7.3.
Both sites use the latest version of admin tools to protect the site.

Thank you for your help!

http://www.cecsweden.org/cms/registration-festival-sweden-2016
http://tools.pingdom.com/fpt/#!/gP8gq/http://www.cecsweden.org/cms/registration-festival-sweden-2016

https://www.srivast.org/en/register
http://tools.pingdom.com/fpt/#!/eaOYc7/https://www.srivast.org/en/register

You need to ensure that your paths are set correctly. In the menu go to Administer > System Settings > Resource URLs and correct the CiviCRM Resource URL. (if the menu isn't working, type directly the path civicrm/admin/setting/url&reset=1 to get there) In 4.7 in most cases it should simply be [civicrm.root]/.

If you're unclear what the correct url should be, try doing "view source" in your browser and check what urls are being prepended to Civi's js/css files - what about it is incorrect? That should give a hint of what needs fixing.


Deduping organizations Dedupe rules are cool, and works well for Individuals, primarily because you have multiple fields to combine.

When it comes to organisations it is more difficult. We focus on individuals but want to register the organisations they work for, so in the profile we use for most on-line registrations (events, subscriptions, ...) we ask for organisation name.

This often leads to multiple organisation records with almost the same name. Typical name variations are

Somecompany Inc.
Somecompany International
Somecompany

Dedupe rules are of limited help here since the best I can do AFAIK is the length of the match.

In Sweden a very common pattern is

Ericsson
Ericsson AB

I would be extremely happy if there was a way to match the full length except for the last three characters... Or if the match was true if the shorter is a true substring of the longer. Documentation is kind of flakey here, it doesn't say anything about what happens when fields are of different lengths.

Another alternative would be to match to either to the organisation name or the legal name. This would handle most of the above cases and allow me to use the names as (I suppose) they where ment to be used, causal name vs. official/legal/full name.

Actually I have a hard time figuring out how to make the best use the 'length' part of dedupe rules. (I'm a regex guy, so I'm longing for a LIKE-like option, is there one?)

Any suggestions?

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


Changing page layout for Contribution pages in Joomla I have a need to remove certain Joomla styling from a specific Contributions page generated by CiviCRM, such as the main banner at the top.

I have investigated such things as editing the templates in Joomla, but that would change pages other than this particular Contributions page.

In Joomla, it's actually not too difficult to override the CSS of any particular page. You can give your page a custom CSS class, then append the CSS to the end of your template CSS file, or a custom CSS file that is pulled into the page.

If you don't already have one, create a menu item for the particular Contributions pages you want to override. You can create a hidden or links menu in Joomla that doesn't have an associated module. Select the CiviCRM - Contribution page type, then the page. You'll need to do this separately for each page.
Under Page Display Options for the menu item, add the new class into the Page Class box.

A few notes: When I create CSS overrides for individual pages, I usually define the page class, then use Firebug (or something similar) to test the overrides prior to uploading them. Depending on how and when the CSS of your template loads, you may need to make use of the !important declaration.

Also, the use of display:none usually works for me in the case of having to hide certain elements, but there is some debate about when you should and shouldn't use that.

Another option that's a little more work than creating a template override is to create an entirely new template. One of the features that Joomla has over certain other CMSes is the ease with which you can assign different templates to individual pages via the template manager. This would completely avoid having to hide certain elements, because you would simply leave them out of your new template. You could start with your current template, and just remove the pieces that you don't need. Install it via the Extension manager, and assign it to your Contribution pages. Note that you will still need to create a menu item for each Contribution page in question.


List activity for all members (whether they have contributed or not) Our treasurer has asked for a report to show the payment history for each contact, even if that contact has never paid anything.
'Contribution Aggregate by Relationship' report is perfect, we select all the relevant years and it presents the data beautifully but the problem is that it's only showing contacts who have made a contribution in one of the years selected. We need it to show a line of data for each member, regardless if they have paid or not.
'Contribution and Membership Detail' report also has the information needed albiet in a different format, but again, it only shows contacts who have made a contribution.
If there is a built-in report for the data we need, apologies, I'm struggling to find it.  Does anyone know if any of the civi extensions might do this?
Thanks for your time!

How comfortable are you with Excel? If you do your contribution aggregate and check the box for Contact ID as a column and then export the results, and then also do an export of all your members and also include contact id, then you can use excel to merge the two lists based on contact id.

Also unless you need the relationship you can also look at Search - Custom Searches - Contribution Aggregate which should be the same thing just in a less spread out format which would make it easier to work with in excel.


How to deal with problem data when importing CSV My first time trying to import CSV data into CiviCRM.  The data looks something like the below (changed to not reveal actual names etc).  The lines in bold are not importing.

I am guessing that in first failure (Allan Nori) the city (Boise /Hiroshima) and the country (United States / Japan) are causing the problem. In the second, probably the state/province (British Columbia (BC)). And in the third, the state/province (Maryland & District of Columbia (DC)).

For the middle one, I guess I can just eliminate the part in parenthesis ((BC)), although it might be nice if the contact would also come up on searches for BC.

I'm not sure about the best way to handle the other two. In the first case, the person lives part of the year in Boise, Idaho, and part of the year in Hiroshima, Japan. In the other, Chevy Chase is actually in Maryland, but the person also wants to come up on searches for District of Columbia (or DC).

Any advice on the best way to handle such situations would be appreciated.

(By the way, these are not all the columns.  I do have email and other data in other columns, but I don't think those are important for this issue.)

You should note the exceptions for the contacts with dual residences and manually remove their secondary residence, and only keep their primary residence in the sheet. You can always create their secondary residence address within CiviCRM after the import wizard finishes as a non-primary address.

For State/Province names and Country name mismatches, you can create a simple MySQL query for each country that has an issue to get the exact spelling that CiviCRM expects in the import process

use my_civicrm_db_name_here;
select c.id, c.name as country , sp.id as state_province_id, sp.name as state_province_name from civicrm_country as c left join civicrm_state_province as sp on c.id = sp.country_id where c.name = "Canada"

For the list of country names you can simply query the civicrm_country table like so:

use my_civicrm_db_name_here;
select id, name, iso_code from civicrm_country


Membership report showing different status than membership dashboard We customised the names of the membership status rules to better suit our needs.  For example in the membership status rules screen, 'New' was changed to 'New Members' and 'Current' was changed to 'Paid Up.

On the membership dashboard, the revised names for membership status rules show up correctly.  However, when I run membership reports, it's still showing the original names of 'New' and 'Current' in the Membership Status column.  I've run Update Membership Statuses but no change in any of the membership reports.  Am I missing something here?

Thanking you for your time.

You've found a bug! I've confirmed it and reported it here: https://issues.civicrm.org/jira/browse/CRM-19855

Most folks don't change the names of the CiviCRM membership statuses, so this has slipped under the radar for a while.  Internally, membership statuses have both a "Name" and a "Label".  The vast majority of the time, they're the same.  In your case, they're different.

The fix for NEW reports is easy - you literally need to change a single word in the report file.  I'll put instructions below.

Since this was so quick, I had intended to write a patch pro-bono to submit to the CiviCRM core team so this could be fixed for everyone - but in testing I found that this change causes the "Membership Status" field to fall off of existing saved reports.  Fixing this properly means writing an upgrade script, which I unfortunately don't have pro-bono time for.

You can fix this on your own copy of CiviCRM, but until this is fixed in the "upstream" software, you'll have to fix it every time you upgrade.

To fix this:

Find CiviCRM on your web server.
From your CiviCRM root, go to the CRM/Report/Form/Member folder.
In that folder are the files that control the reports.  Open the file that corresponds to the report you want to change with a text editor.
in the $fields array, you'll find an entry for Membership Status.  It will look something like this:

'civicrm_membership_status' => array(
  'dao' => 'CRM_Member_DAO_MembershipStatus',
  'alias' => 'mem_status',
  'fields' => array(
    'name' => array(
      'title' => ts('Status'),
      'default' => TRUE,
    ),
  ),
  'filters' => array(
    'sid' => array(
      'name' => 'id',
      'title' => ts('Status'),
      'type' => CRM_Utils_Type::T_INT,
      'operatorType' => CRM_Report_Form::OP_MULTISELECT,
      'options' => CRM_Member_PseudoConstant::membershipStatus(NULL, NULL, 'label'),
    ),
  ),
  'grouping' => 'member-fields',
),

Take this line:

'name' => array(

Change "name" to read "label":

'label => array(

This will fix your reports!  Don't forget to re-add the "Status" field to existing saved reports, and don't forget to make this fix on every upgrade until someone steps forward with time or money to fix this.
UPDATE: For the Membership Contribution report, find this section:

  'civicrm_membership_status' => array(
    'dao' => 'CRM_Member_DAO_MembershipStatus',
    'alias' => 'mem_status',
    'fields' => array(
      'membership_status_name' => array(
        'name' => 'name',
        'title' => ts('Membership Status'),
        'default' => TRUE,
      ),
    ),

change:

'name' => 'name',

to

'name' => 'label',


How can I export a zip code with the suffix in the same field? I send my addresses to a mailing house for a bulk magazine mailing.  They require my zip+4 in one field.  I can fix this in LibreOffice or Excel, but I have to be careful that my spreadsheet app doesn't eat the zip codes' leading zeroes.  Is there a better solution?

I wrote this little snippet of code in a larger extension, which will automatically append the postal code suffix to postal codes when exporting postal codes:

/**
 * On export, append the postal_code_suffix to the postal_code.
 */
function tweaks_civicrm_export(&$exportTempTable, &$headerRows, &$sqlColumns, &$exportMode, &$componentTable, &$ids) {
  // Primary postal code will have a sqlColumns['postal_code'] = 'postal_code'.
  // Non-primary will have the location type appended - e.g. work_postal_code.
  foreach ($sqlColumns as $key => $column) {
    if (substr($key, -11) == 'postal_code') {
      // Primary postal_code.
      if ($key == 'postal_code') {
        // Update the primary postal code.
        $sql = "UPDATE $exportTempTable " .
        "LEFT JOIN civicrm_address ca ON $exportTempTable.civicrm_primary_id = ca.contact_id AND ca.is_primary = 1 " .
        "SET $exportTempTable.postal_code = IF(ca.postal_code_suffix, CONCAT(ca.postal_code,'-',ca.postal_code_suffix), ca.postal_code)";
        CRM_Core_DAO::singleValueQuery($sql);
      }
      // Non-primary postal code
      else {
        $locationType = str_replace('_', ' ', substr($key, 0, -12));
        $sql = "UPDATE $exportTempTable " .
        "LEFT JOIN civicrm_address ca ON $exportTempTable.civicrm_primary_id = ca.contact_id " .
        "JOIN civicrm_location_type clt ON ca.location_type_id = clt.id AND clt.name = '$locationType' " .
        "SET $exportTempTable.$key = IF(ca.postal_code_suffix, CONCAT(ca.postal_code,'-',ca.postal_code_suffix), ca.postal_code)";
        CRM_Core_DAO::singleValueQuery($sql);
      }
    }
  }
}


Multiple error messages upon upgrade to CiviCRM 4.2.20 I am trying to upgrade from 4.1.5 to the latest CiviCRM but need to go through some intermediate releases to get there. I have installed 4.2.20 but get the following error dozens of times on each screen.

  Strict warning: Non-static method CRM_Core_Block::setTemplateValues()
  should not be called statically in CRM_Core_Block::setTemplateValues()
  (line 587 of

Is there any way to get rid of it?

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

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


Undefined index in civicrm_member_roles_sync I'm using drupal 7 with CiviCRM 4.4.6.

I'm using CiviMember Roles Sync with below Association Rules:

Rule ID: 3
"CiviMember Membership Type" --> "Drupal Role": Member (PG) --> member
Current Codes: New, Current
Expired Codes: Grace, Expired, Pending, Cancelled, Deceased

Rule ID: 4
"CiviMember Membership Type" --> "Drupal Role": Member (KK) --> member
Current Codes: New, Current
Expired Codes: Grace, Expired, Pending, Cancelled, Deceased

In setting "Automatic Synchronization Method", I select "Synchronize whenever a user logs in or logs out."

When user login, error appear as below:

  Notice: Undefined index: 4 in _civicrm_member_roles_sync() (line 541
  of
  /home/warrior/www/beta/sites/all/modules/civicrm/drupal/modules/civicrm_member_roles/civicrm_member_roles.module).

Here are drupal user roles available on my site:

ID 3: Web Developer
ID 4: Content & Membership
ID 5: member
ID 6: Membership Admin

I tried to change "Automatic Synchronization Method", but the error still appears.
When I change to "Synchronize when membership is updated", error appears after payment made (membership updated).
When I change to "Synchronize when Drupal cron is ran", error appears when I run cron.

Any idea how to solve this error?

What you've found is that the error appears whenever your sync runsTwo things:

This is a PHP notice, which is a very low-importance message to receive.  Nothing is breaking; this is just something to say that something mildly improper is going on in the code.  Notices like this are actually something you should suppress on a production site: in the Drupal menu, go to Configuration, then under Development click Logging and Errors.  Select none under Error messages to display.  That will make the error quit appearing on screen, but it will still probably appear in your log, so it's worth getting to the bottom of it.
It does reflect an actual bug (albeit small) in CiviCRM's code.  Basically, this line of code asks whether the item in the $memberroles array for a contact's membership's membership type is an array.  Well, it's possible that the $memberroles array doesn't have an item for that membership type: it's only populated with the membership types for which you've got sync rules set up.  Apparently, in your case, at least someone has a membership of a type that doesn't sync with a Drupal role.  This is normal and okay; the code just doesn't consider this situation.

Apparently, the problem still exists in the development version of the code.  Please log in at issues.civicrm.org and log an issue for this.  The fix will take no time, but it's good to have a record of the bug there.


How do I replace the "From" address from my mailings? I setup a default adress in CiviMail -> From Email Adresses , like this :

"Example" <example@example.org>

but the problem is that when I send mails, the "From adress" change and become :

"Example" <xxxx@gmail.com>

(I specify that I use a gmail account in the SMTP sending settings)

Is it possible to force that mailing adress so it become "example@example.org" ?

At the begining, I was using a private adress (in my own domain) for civiCRM SMTP's settings (and it worked fine), but lately we need to migrate these mails to Office365 / Exchange mails and I have never been able to get CiviCRM mailings to work with the new Office365/Outlook/Exchange settings, that's why I opted for an SMTP account that uses gmail.

So I am assuming that the only thing that changed between "it worked" and "it doesn't" is to switch from your own smtp to your gmail one.

Beside the problem you mention, using smtp from gmail will not work to send mass emails, they have a lot of limits and as soon as your list has more than a handful of emails, you will have problems.

There as several providers (sendgrid, mailjet...) that are integrated with civi, and I'd recommend you switching to one of them

And it should solve out your gmail.com problem too


How to disable email notifications when confirming a donation in CiviCRM admin view? When a admin user sets a contributors record on civicrm/contribute?reset=1 from pending to completed an email is sent out.

Is it possible to turn off this email function for this email only.

You mean the receipt?

There is a checkbox "Send Receipt?" when you modify an individual contributione. If you uncheck it, it shouldn't send the email.


How to safely restart Scheduled reminders Recently scheduled reminders stopped working on a site.

on investigation of error logs I found that one reminder out of several was incrrectly configured. I deleted the reminder. The next time the scheduled reminder job ran, all went well but a backlog of 3 months of event reminders sent at the same time.

I've found a similar error on another site, and have disabled scheduled reminder task while investigating and deleting the incorrectly configured reminder.

before I turn the scheduled reminder task back on, how can I stop the backlog of old reminders from sending?

I have made the same mistake myself, more than once - ugh! To avoid emails being sent when a scheduled job needs to catch up on backlog:

Switch from production to staging mode
Manually execute the schedule reminders job - this will result in an activity being recorded on the participant's contact record, but will not send the email (the desired impact)
Switch back to production - the activities recorded on the participant's contact record will prevent schedule reminders being sent for the same events

Hope this helps!
Tamar


How to send one email to multiple contacts with separate individual follow-up activities If I send an email to forty contacts, I can opt to generate a follow-up activity (eg phone call). That's great, except that it creates one single follow-up activity for all the contacts. I would like to generate separate follow-up activities, one for each contact, so that I can record the different sequences of activities which follow on the from the initial mailing. Is there any way of doing this?

Alternatively would it be difficult to duplicate the one follow-up activity (with forty contacts) into forty activities, each with one contact?

Thanks.

(converting comment to answer)

If you choose to create an Activity from the search results then you can specify that there should be a single Activity per contact, not one for all the contacts selected. At that point, if you specify there should be a 'follow up' then the follow up should also be 'one per contact'


Why does the profile field contact subtype only display individual subtypes but not organisation subtypes? If you visit here on the CiviCRM Demo site http://d46.demo.civicrm.org/civicrm/admin/uf/group/field?reset=1&action=browse&gid=16 (What I did to create this was create a new profile, for the purpose of batch updating via profile, called Subtype and add the field "Contact" "Contact Subtype". )
Looking at the preview of this field
the only options that are available are subtypes of Individual. Subtypes of Organisation do not show.

How I can get the Contact Subtype field to display organisation subtypes?

I just tested this & it seems like as soon as you add a field like 'organisation name' to the profile it switches to an org. Civi doesn't really like you doing 2 different contact types off one form - because it doesn't know what to save them as


How would I configure an Event with varying inputs and free registrations based on contribution level? I have a golf Tournament with a semi-complicated event contribution structure.

We have sponsor levels - Gold (10K), silver (5K), bronze (1K) and people give donations not just at those levels, but also in between - say $2,500.

For each donation level, I need to collect company info and participant info

For instance, Gold Level would get Main Event Signage (need Logo & Display Name), T/Hole-signs (Display name), and every $1,000 in contributions provides one participant (named with handicap) - but they do not have to use all spots.

How do you recommend it best to do this in Civi?  Should I set up a separate contribution page from participant registration and send registered sponsors 'discount codes' to use to register players?  Can I do it all through the event registration page?

I've been using civi for a while for simple needs - this is far more complicated than I've done in the past.

Thanks for any recommendations!

Edit -

I am using Wordpress with Civi 4.6

I assumed I could have a company & company contact responsible for payment with forms available for the other items based on sponsorship level.  (They would choose silver level and then be asked for 5 golfers & the signage text)  But it doesn't require this...

I think the discount codes is a good approach.  To do this all on one page would require either webform_civicrm for Drupal, which you don't have, or to write an extension.

If you write an extension, I'd use hook_validateForm to make the Logo/Display Name optional/required, based on their level.  The same hook would also allow you to set a maximum number of additional participants to register.  You can also add a jQuery script with hook_buildForm for niceties like adding/removing an asterisk as fields become required/optional, but you still need server-side validation for security purposes.


Joomla Cron not finding setting files Running Joomla 3.9.0
Civicrm 5.7.0
PHP 7.0.2

Recently update Civicrm to 5.7.0 - Prior version and my cron job was working fine. Now it hasn't run since November 7th

Run cli.php

php /var/www/clients/client1/web2/web/administrator/components/com_civicrm/civicrm/bin/cli.php -s domain_name.com -u user -p password -e Job -a execute

Output is

PHP Warning:  include_once(/var/www/clients/client1/web2/web/administrator/components/com_civicrm/civicrm/../..//default/civicrm.settings.php): failed to open stream: No such file or directory in /var/www/clients/client1/web2/web/administrator/components/com_civicrm/civicrm/civicrm.config.php on line 118
PHP Warning:  include_once(): Failed opening '/var/www/clients/client1/web2/web/administrator/components/com_civicrm/civicrm/../..//default/civicrm.settings.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/clients/client1/web2/web/administrator/components/com_civicrm/civicrm/civicrm.config.php on line 118
Could not load the settings file at: /var/www/clients/client1/web2/web/administrator/components/com_civicrm/civicrm/../..//default/civicrm.settings.php

I have looked at some of the patches. But the patches are older than the version I have.

Any help would be greatly appreciated.
Thank you

Check your administrator/components/com_civicrm/civicrm/civicrm.config.php file. It should be only 12 lines long and look like the following:

<?php
define('CIVICRM_SETTINGS_PATH', '<www root>/administrator/components/com_civicrm/civicrm.settings.php');
$error = @include_once( '<www root>/administrator/components/com_civicrm/civicrm.settings.php' );
if ( $error == false ) {
    echo "Could not load the settings file at: <www root>/administrator/components/com_civicrm/civicrm.settings.php
";
    exit( );
}

// Load class loader
require_once $civicrm_root . '/CRM/Core/ClassLoader.php';
CRM_Core_ClassLoader::singleton()->register();

The 3 paths to civicrm.settings.php within civicrm.config.php should all be absolute. Your PHP warnings show that /../..//default/ is in the path, which is incorrect for Joomla. I can't explain how it (or code that is generating it) ended up in your civicrm.config.php; this forum post might give a clue. If your civicrm.config.php is not as per the above, replace it with this, substituting  with the correct path.


How to Mark CiviCRM checkbox field not required programmatically? add_filter('civicrm_buildForm','contact_mark_t_fields_optional',10,2);
function contact_mark_t_fields_optional($formName, &$form){
    if($formName == 'CRM_Contact_Form_Contact'){

        $user = wp_get_current_user();
        $is_admin = FALSE;
        foreach($user->roles as $k =>$v){
            if($v == 'administrator'){
                $is_admin = TRUE;
            }
        }
        if ($is_admin){
            //Array ( [0] => custom_2_-1 [1] => custom_3_-1 [2] => custom_4_-1 [3] => custom_5_-1 [4] => custom_6_-1 [5] => custom_7_-1 [6] => custom_8_-1 [7] => custom_11_-1 [8] => custom_12_-1 [9] => custom_13_-1 [10] => custom_14_-1 [11] => custom_15_-1 )//
            $optional = array(
                'custom_2_-1','custom_3_-1','custom_4_-1','custom_5_-1','custom_6_-1','custom_7_-1',
                'custom_8_-1','custom_11_-1','custom_12_-1','custom_13_-1','custom_14_-1','custom_15_-1','custom_41_-1'
            );
            foreach($form->_required as $k => $v){
                if (in_array($v, $optional)){
                    unset($form->_required[$k]);
                }

            }
        }

    }

}

I am trying to mark a checkbox field as optional programmatically when an admin views from the admin side, but while trying to save it, it gives a "Field Required Error"

You can use validateForm hook to empty the errors on the input field. Eg

function hook_civicrm_validateForm($formName, &$fields, &$files, &$form, &$errors) {
  if (your_condition_statement) {
    $form->setElementError('field_id', NULL);
  }
}

Also note that as this looks like a custom field, civi also provides a UI setting to disable the required attribute. Screenshot from Add/Edit custom field form.


Integrating iATS forms through CiviCRM (Drupal) onto website Wordpress We have installed the iATS plugin to our CiviCRM (on Drupal) and we would like to create an embedded donation form onto our Wordpress website. We don't want to use the CiviCRM public pages because moving donors away from our website will mean fewer people go through with their donations.

I'd like to know if anyone else has encountered this problem, and if they'd be able to share some insight into how best to move forward?

Thank you!

You can embed the Drupal site's form (any form, whether from Civi or Drupal) into your wordpress site using an iframe.

Here's an example of exactly that:
https://patientscanada.ca/donate/

There are three steps to make this work:

Create an alternative theme on the Drupal site that is suitable for embedding in an iframe. There's a Drupal theme here: https://www.drupal.org/project/entity_iframe_theme that will take you most of the way. I can share what I've used if you want.
Use theme_key or similar module to display the appropriate path using that theme.
Configure your settings.php to allow the wp site to iframe your drupal pages (by default, Drupal will not allow itself to be used in an iframe, as a security precaution).


Trouble with Mattermost verification email I know there were several questions about this already, but I couldn't find any steps to resolve it myself. I'm trying to create a Mattermost account via chat.civicrm.org for the first time, and it's not sending the verification emails even though it says it has. Any help is appreciated!

There were problems with the email notifications and the issue should now be resolved. If the problem persists, you can email me at: mathieu at civicrm.org.


How to add email while trying to create a Household contact using civicrm api v3? I want to add email address to create a contact of type Household , how I can achieve it as while checking in API explorer I don't see it.

$result = civicrm_api3('Contact', 'create', [
  'contact_type' => "Household",
  'household_name' => "Test",
  'email' => 'abc@gmail.com
]];

I was trying to convert civicrm API v2 to civicrm API v3.
In civicrm API v2, I saw this, so I thought we may have some way to add email directly in API v3 (also not sure if api v2 below is correct)

$householdParams = array(
                    'household_name' => $familyName,
                    'contact_type'   => 'Household',
                    'email'          => $form_state['storage']['contactInfoValues']['emailAddress']
                    );
$householdContact =&civicrm_contact_add($householdParams);

You will have to use the Email API with the contact_id of the just created contact. You can do this in a chained API call if you want to.


CiviMail: "DB error" alert pop-up During creation of a mailing with 10k contacts, frequently, getting black pop-up alerting "DB error" with no other information. Please advise.

mysql> SHOW VARIABLES LIKE 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 200   |
+-----------------+-------+
1 row in set (0.00 sec)

PHP Built On:   Linux host.alcoholjustice.org 2.6.32-042stab094.8 #1 SMP   Tue Dec 16 20:36:56 MSK 2014 i686
Database Version:   5.5.42-cll
Database Collation:     latin1_swedish_ci
PHP Version:    5.3.27
Web Server:     LiteSpeed
WebServer to PHP Interface:     litespeed
Joomla! Version:    Joomla! 3.4.1 Stable [ Ember ] 21-March-2015 20:30 GMT
Joomla! Platform Version:   Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Looks like this could be the same as or related to issue CRM-16277, which has been fixed for 4.6.3.


Name order on CMS's add user block How can I change the sequence of first and last name field in the block, witch comes up on Drupal's "Add new user" page's bottom. Now the sequence is first_name then last_name, but I should have last_name than first_name.

Thank you.

You can update the profile that is being used for registration by changing the weight of the field or using top/bottom arrows to change the order how they appear.

Navigate to Administer >> Customize Data and screens >> Profiles

Check the profile used for Drupal Registration and then click on the fields link besides it

Use the arrow button to change the order of the field.

You can also change the weight of the field by clicking on edit link of the field and then changing the order.

HTH

Pradeep