Why are Civi Events and Activities in Drupal Views Calendar showing incorrect times Titles says it all. There are issues with how CiviCRM handles timezones which means they get displayed on calendars incorrectly.

According to Eileen "the meta fix for CiviCRM for timezone issues is to change the type of appropriate fields to mysql timestamps (which we actually do sometimes) but views calendar should just assume it's getting the data in whatever timezone it is in".

We found this post by SGladstone (thanks Sarah) which gave us a new direction to explore, and Chris has now done a PR for a fix based on that approach.


How to access multiple CiviCRM website fields for a contact in Drupal Views? I have two website fields for my contacts, a work website and a personal website.  I am creating user profile pages (NOT CiviCRM profiles) for each of our members and want to display both website links, but, when I try to add a website field to the view, there is just one option to choose from and it is labelled generically, rather than as either personal or work.

How do I access both website fields?

When I add fields to the view for email or physical address, in the 'Configure field' dialogue in Views, there is a select box to choose which 'location type' you want for your email.

However, I don't get that option with websites.

Thanks,
Lewis

in your CiviCRM tab -> you can set the Number of Email fields to 2 -
and then set one to Email Location: home and one to Email Location:
work (and decide which one is primary). Save Settings.
next: in your Webform Tab -> go ahead and hit Edit on the Elements
you've just created -> change the Label to anything you want -> so
that the user knows which Email address to plug in - in which field.
in Views -> to create a Member listing. First of all make sure you
have CMS database integration enabled -> check:
civicrm/admin/setting/uf?reset=1 - and follow the Views integration
settings instructions
then into Views -> make a View to display e.g. Contacts -> then add
Fields for Email -> once you have added the field you can hit Edit
and specify which one you'd like -> make that Primary or Work or
Home. Add another Field for Email -> select another Location Type.
That way you'll have multiple Email columns of different Location
Type.

PS - just realized you said website -> but the recipe should be identical;

EDIT: - ah it's not - I just checked and it looks like Views integration is not quite working for that specific field yet (or it's a bug). Your workaround would be to store these fields yourself - in custom fields. Then you have complete control over them in both webform_civicrm as well as in views listings. I'll file an issue on JIRA

EDIT: reported: https://issues.civicrm.org/jira/browse/CRM-19258


Is it possible to not have a default country? I'm working on a Civi implementation for a client who deals with contacts around the world. It makes no real sense for them to have a default country, yet it looks like I have no option but to set one. Is there a way to not have a default country for address records?

CiviCRM allows you to over-ride the settings through php. You can over-ride default value for Contact Country.

Add the below snippet in your sites civicrm.settings.php file

global $civicrm_setting;
$civicrm_setting['Localization Preferences']['defaultContactCountry'] = '';

Ref: Override CiviCRM Settings

HTH

Pradeep


Contacts I created wont come up on search I have installed Drupal and CiviCRM. I have created a new Drupal role and given the following permission

CiviCRM: add contacts
CiviCRM: view my contact
CiviCRM: edit my contact
CiviCRM: access CiviCRM (This permission gave me access to use search
and advanced search)

I can create contacts. But when I search I don't see the contacts I created.
My requirement is, I should be able to see the contacts that I created(not other contacts) when I search.

Is this possible  ?

"View my contact" grants the ability to see your own contact record, not other contacts you have created. So as currently constructed, you're able to create new contacts but not view them. You have two options -- grant the View all contacts permission (which would allow the user to see all contacts, not only those they have created), or explore using the advanced ACL features to determine what records can be viewed by the contact (see: https://docs.civicrm.org/user/en/latest/initial-set-up/permissions-and-access-control/#native-civicrm-acls). That may require some additional work to segment contacts into groups based on who created them.


Problem connecting to payment processor The CiviCRM (4.7.14) membership sign-up page for our website will not always connect to Paypal (standard), our payment processor.  Sometimes it works, mostly not.  In Firefox, the error message is: "The page isn’t redirecting properly Firefox has detected that the server is redirecting the request for this address in a way that will never complete. This problem can sometimes be caused by disabling or refusing to accept cookies."  I have checked settings in CiviCRM and with Paypal, and everything looks OK as far as I can tell. Looking for help to get this issue fixed.

Our site is on Joomla 2.5.20 and appears to be up to date. To the best of my knowledge, the connect to Paypal worked fine until about 6 months ago. Since then, CiviCRM was updated to 4.7.14. The problem is not unique to Firefox; complaints also come from people using Edge, Chrome, Safari in different countries all around the world. Doesn't seem to be a difference for a logged-in user or non-logged-in visitor.

This seems like it might be your CiviCRM not having a single canonical URL.

CiviCRM form processing requires a canonical URL to be set. If your site is configured to use http://example.org and the visitor lands on http://www.example.org, CiviCRM's form processing will redirect them to the configured base URL part way through the contribution flow and fail (because the user's cookies no longer are supplied).

I can't load the URL you've linked to, but if I start the Join process at the first URL below, I am able to get to PayPal. If I start at the second URL below, I see the "too many redirects" notice you describe.

http://isebiogeochemistry.com/index.php/iseb-membership
http://www.isebiogeochemistry.com/index.php/iseb-membership

Finding your site via Google ("ise biogeo chemistry") leads me to the latter hostname.

To prevent this (mis) behaviour, both the protocol (http vs https) and the hostname (example.org vs www.example.org) must be consistent (ideally, enforced with a redirect from ANY wrong URL to the single "correct" one).

How to configure canonical URLs varies between webserver and CMS, so I won't document that here. You'll find plenty of good existing docs with a search for eg "(your CMS) + canonical URL plugin", or "(your webserver) canonical URL".

Some similar questions on CiviCRM Stack Exchange:

**Network Error - Unable to reach the server
Network Error due to Cross-Origin Request Blocked
Payment options do not display when https used only when http used
"Could not find a valid session key." Unable to save any admin forms


How to get contact id of logged-in user in JS API Sorry if I'm being thick here, but I've looked and looked. Is there an API call to get the contact id of the logged-in user?

What I need to do is check whether an activity has been authored by the logged in user (in order to show or hide an edit button, in an angular extension).

If there is a way of restricting people from editing (but not from viewing) CiviCase activities that weren't created by them, that would be even better, but I fear it will be easier to do the above.

Cheers

In case of an angular page use something like

function myext_civicrm_angularModules(&$angularModule) {
  [...]
  $session =& CRM_Core_Session::singleton();
  drupal_add_js(array('CurrentCiviUid' => $session->get('userID')), 'setting');
  [...]
}

and access it in JS:

var uid = Drupal.settings.CurrentCiviUid;


CiviMail Track Click Throughs directed to Page Not Found Since upgrading to CiviCRM 4.6.9 on Drupal 6.37, when using track click throughs in CiviMail, links send to Page Not Found.

What is the url to track that generates the page not found?

One common problem is that your apache/nginx rules are wrongly redirecting the url used to track the clicks to be handled by drupal

Is this a "real" 404 page (coming from your webserver) or is this drupal handling that page and generating a page not found?


Can Twilio 'from' number be a text field with the organisation name? With Clickatell it's easy to have the 'from' number of an SMS set to your organisation name - such as 'ABC NFP' rather than '01332 46000'. Several people have asked whether this can be the case for Twilio as well?  (I'm asking this question because I know the answer! - see below)

Yes, it's easy. You have to ask Twilio customer support to enable 'Alphanumeric Sender ID' in your project.  Here's the link for that.  Once that's done then all you need to do is to set the 'From=' in Administer/Settings/SMS Providers to whatever you want.  Of course, users cannot then reply or 'STOP' etc.  But it works and there's nothing to enter or change in your Twilio account once the alphanumeric send ID is enabled, just update Civi with your chosen text.


Token information not pulling through to Mailing Template Really hoping you can help with this.

We had a security update on Civi yesterday which appears to have caused an issue with how one of our tokens is pulling through to a mailing template.

We used a token of {membership.start_date} which pulls through a groups membership start date onto the mailing template. The dae itself is held at the following location:

Unfortunately I was not at this company when this was setup so I am unsure how the link between the token and the membership start date has setup and why it has suddenly broken down.

If you could please provide some advise or point me at which settings to look at it would be really great.

Thank you all, Terry

.......................

Update - Error being received below when trying to install the "Fuzion Tokens" extention.

..............................

Further to the above it appears that the tokens are pulled via the Scheduled reminder templates, E.g:

{membership.end_date}
{membership.start_date}
{membership.join_date}

However when testing these via scheduled reminders and mailing templates the fields are all not pulling through from the membership details now.
I have looked though out modules on Drupal and and their is a tokens module present, however I am unsure how to access the details of this / the GUI to view or edit any tokens that have been created for example.

All other tokens continue to work, such as contact tokens, presume that these are Core Civi tokens however.

Really starting to pull my hair out with this now as to why all of a sudden just the membership tokens have stopped working.

Any help would be greatly appreciated.

{membership.start_date} was never supported in token list for sending mailings unless you have any custom extension or module that generates one.

{membership.start_date} token is supported only in Schedule reminders(for memberships) or printing letters for membership.(i believe). The schedule reminder screen allows you to save the template so that it can be used in future. If you using the same message template to send mailings then the tokens other than contacts won't get replaced unless you have custom code that deals with such tokens.

Civitokens extension does allow some additional token like latest current membership which can be used in mailings however you will need to replace the existing token with the new ones.

The error message you posted seems like your server doesn't have permission for apache user to download/extract the extension from UI. Alternate way is to download the extension and extract into extension directory and install it manually.

HTH

Pradeep


File location for new CiviRules Action I have written a new CiviRules Action and added the entry to the database but I don't know where to put the php file. I have read all the documents I can find but I can't find any information about a directory structure for rules addons. I would like to keep it as part of an extension I have written. Any help with the file location would be appreciated.

Thanks

You put it in your own extension, under the CRM folder and subfolders you need to create depending on the class name. See https://docs.civicrm.org/civirules/en/latest/create-your-own-action/#step-2-add-a-class-that-extends-crm_civirule_action

You can include the class file in the Civirules extension if you want,
but you can also include it in your own extension. This class should extend
CRM_Civirules_Action to be able to add your action to the CiviRules Engine

So let's say your class is CRM_Mynamespace_CivirulesActions_Contact_Subtype, then you'd call the file Subtype.php and put it in your extension in CRM/Mynamespace/CivirulesActions/Contact


How to fix receipt/confirmation attached PDF alignment in email? Civicrm email receipt/confirmation attach PDF files alignment issue.

We facing alignment issue in attached PDF file, Left side margin high and it is creating empty pages.

Which file needs to edit for this issue?

Maybe set up the default PDF form (Administer Communications PDF Format, ?page=CiviCRM&q=civicrm%2Fadmin%2FpdfFormats&reset=1) which allows you to define margins


How can I 'or' 2 conditions using the api? If I want to find all contacts without a birth date, I can do this with the api:

$result = civicrm_api3('Contact', 'get', array(
  'sequential' => 1,
  'birth_date' => array('IS NULL' => 1),
));

If I want to find all contacts with a birth date before a given date, it works like this:

$result = civicrm_api3('Contact', 'get', array(
  'sequential' => 1,
  'birth_date' => array('<=' => "1960-01-01"),
));

Now suppose I want to both the contacts without a birth date and the contacts born before a particular date, can I do that in one API call?

Barring some undocumented feature (which are rife in the API, so someone please correct me), I think you'll have to merge the two.  However, since you're dealing with "get" calls, it's straightforward to merge the two results.

First, you'll want to get rid of the sequential parameter; without it, you'll get arrays of values keyed by ID.  Then, you'll have a pretty simple situation:

$result = civicrm_api3('Contact', 'get', array(
  'birth_date' => array('IS NULL' => 1),
));

$result2 = civicrm_api3('Contact', 'get', array(
  'birth_date' => array('<=' => "1960-01-01"),
));

$combined = array_merge($result['values'], $result2['values']);

The result will have only one row per contact.  Although obviously there's no overlap between people with no birth date and people with birth dates prior to 1960, you could use the same principle for merging potentially overlapping groups since the array key is the ID.


how do I find error log to see what is causing the error I am not the technical person - merely a user so I am very unfamiliar with this tool.  I am trying to find the reason for the error I receive when trying to search the contacts for all individual contacts.  The error I receive is: Sorry. A non-recoverable error has occurred.  DB Error: unknown error.

The links in the comments are helpful, but don't actually give the correct answer for the log in question.

There's two ways to see the logs for your error:

Check the ConfigAndLog directory.  You can find it here: Where are the "ConfigAndLog" and "templates_c" directories?
You can also see the error on-screen:  Go to Administer menu » System Settings » Debugging and Error Handling, and select both "Enable Debugging" and "Display Backtrace".  Then repeat whatever issue led to the error!  Make sure to turn this off when you're done - leaving it turned on can leak information to a potential hacker, which is why they're not on by default.


Mosaico: Packages are missing (Beta 4) Just upgraded to Beta 4 - getting the following error.

  Mosaico: Packages are missing Mosaico requires dependencies in its
  "packages" folder. Please consult the README.md for current
  installation instructions.

Wordpress 4.9.7
Civi 5.3

The "releases" on GitHub don't include the dependencies and aren't supposed to be downloaded directly for "consumption" - the supported workflow is either to use the advanced instructions in the readme file (running install.sh) or to install using the tarball from the CiviCRM extensions directory.

The final build process for mosaico merges GitHub repos to create the tarball.

Extensions Directory page:
https://civicrm.org/extensions/email-template-builder

Chat discussion on the same issue:
https://chat.civicrm.org/civicrm/pl/p7ih3bq36trp5frqnmccy1o3fy


IATS ACH Civi is not recording when a donation has been refunded or returned Civi is not recording when a donation has been refunded or returned. Is there a way for Civi to record returns or would these have to be recorded manually?
IATS EXTENSION:  1.7.4

That’s correct and by design. Refunding for example a donation may have other business consequences like revoking a charitable tax receipt already issued for the original donation so best to have a finance/admin have eyes and hands on refunds and ensure the entire refund procedure for their specific org is followed.


Does Drupal 7 "CiviCRM Entity" online event registration generate confirmation email? I just started using CiviCRM Entity to embed event registration forms in my Drupal 7 web pages.  The event registration works, but people who register through this mechanism do not receive registration confirmation emails.  If I use the standard CiviCRM full-screen event registration form, then I do get a confirmation email.
Does the Drupal 7 CiviCRM Entity module online event registration support sending confirmation emails?
Thank you.

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


Minimum permission set to enable Manage Contribution Pages? What is the minimum set of permissions that I need to grant to a user to allow him to access 'Manage Contribution Pages'? The only permission that seems to grant access to this page is 'administer CiviCRM', but that then enables administration of essentially the entire application.

Thank you.

Administer CiviCRM includes administering Contribution pages. You can create a role for administering the CRM (such as editor) and then actually restrict menu items to that same role so that they don't have easy access to everything else. However, it would be pretty hard to make a contribution page without being able to access nearly all the other settings.

Managing the contribution pages is a higher function.


How do I send a scheduled mailing via CiviMail? I've created and scheduled for immediate delivery an email via CiviCRM. It's in the queue but nothing is happening. Who can I contact or what do I need to do?

Mailings run from a cron job on the server, so submitting immediately does not immediately start the mail sending,  it sends the next time the bulk mail processor task runs.

If the mailing is still not sending in an hour or so...

Go to Scheduled jobs (Administer>System Settings> Schduled Jobs)
And check that the Mailings scheduler job is enabled.

If it is enabled, and your mailing still hasn't gone talk to your admin person to check that cron jobs are enabled on the server.

Details fpor configuring scheduled jobs here: https://docs.civicrm.org/user/en/latest/initial-set-up/scheduled-jobs/

Cheers

Craig


Report for number of events attended by each person I would like a report that lists the number of events attended by (or registered by) each participant.  This seems like something that a lot of organizations would find useful, yet I can't seem to find anything even close to this that I could customize into what I'm looking for.  Am I missing something, or is there no such report in existence.  If not, any suggestions.
Thanks,
Rick

I think you can get what you want with the "Event Participants Report" (under the Events > Event Reports Menu). In the "Sorting" tab, just tick the box for "Section Header / Group By" against "Last Name, First Name". You use the "Filters" tab to restrict to a particular time period, set of events etc.

In general if I can't do something off the shelf in CiviCRM then I export a search result or report to Excel and manipulate it there. A lot easier than writing a new report. In this case I would have used the Subtotal function in Excel if I couldn't have done it within CiviCRM.


One CiviCRM for multiple sites Which approach would you recommend for integrating CiviCRM into an existing ecosystem of 3 Wordpress installations, each residing on its own server with its own domain, where at the moment users, event-registrations and newsletters are being managed separately?

Ideally changes in one of the clients would update the central CiviCRM database (via REST et al.) and vice versa.

I would always recommend to have CiviCRM on a separate server from the public facing website (privacy, security and updates) even thought it is more cumbersome and more expensive.

So I assume you will have 3 WP websites, and one central CiviCRM (in a dummy Drupal or WP). I would use CiviProxy to ensure only whitelisted API calls are accepted (check https://github.com/systopia/CiviProxy for a little more info) and then there are a few options I think:

Ensure your WP sites can process the data and prepare an API call to CiviCRM using the core API's
Use the work done on Gravity Forms with CiviCRM although I am not sure that will work with REST
Just throw all the data on a Wordpress form to CiviCRM and create a customized extension that provides specific API calls to process the data. We have done this with the CiviCRM Contact Form 7 plugin and specific API's.


Upgrade to CiviCRM 4.3 failing on DROP FOREIGN KEY I have successfully upgraded many other CiviCRM installations over the years, but I've been unable to work my  way through this issue so far.

Ubuntu 14.04
MySQL 5.7.23
Apache/2.4.7
PHP Version 5.6.37
Drupal 7.59
CiviCRM 4.2.20

I am trying to upgrade CiviCRM 4.2.20 to 4.3.11. Ultimately the goal is to get to 4.6 LTS. I have tried repairing the CiviCRM schema (this database has only 2 custom fields), and I've also tried the SET foreign_key_checks = 0; work around on importing the db, but I've still been unsuccessful at upgrading. I always hit this error at the stage of:

  [Error: Upgrade DB to 4.3.alpha1]

  ALTER TABLE civicrm_membership_type DROP FOREIGN KEY
  FK_civicrm_membership_autorenewal_msg_id [nativecode=1091 ** Can't
  DROP 'FK_civicrm_membership_autorenewal_msg_id'; check that column/key
  exists]

I found a helpful thread somewhere that suggesting that MySQL 5.5 may have been the culprit, so I upgraded to MySQL 5.7, and still get the exact same error regardless of MySQL version. I have a fresh export and backups, so every time I try something it is with a fresh working version of the database on 4.2.20. Any help is greatly appreciated!

Thank you,
--Tony

Update
Based on Jon G's suggestion I tried commenting out the offending lines in CRM/Upgrade/Incremental/php/FourThree.php, reloaded a fresh database for upgrading, but still continued to receive the exact same error.  The only difference this time being, after I hit refresh to try and force the upgrade to continue, then another message occurred:

  ALTER TABLE civicrm_premiums ADD COLUMN
  premiums_nothankyou_position int(10) unsigned DEFAULT '1'
  [nativecode=1060 ** Duplicate column name
  'premiums_nothankyou_position']

I couldn't grep any more lines to comment out of the FourThree.php upgrade file, and wasn't sure how this would affect database integrity. The suggested threads (CRM-12458, CRM-11260)  seem to relate, but I was ultimately unable to use the information to solve this issue, admittedly due to the lack in my technical understanding.

This appears to be identical to CRM-12458.  Which is unusual - most cases where you'd get this error were solved in CRM-11260 but there are still edge cases that can cause this.

I would read those links in full - but my guess is you should edit CRM/Upgrade/Incremental/php/FourThree.php.  Remove the four highlighted lined at this link - that is, lines 883-886.

Since you're dropping a foreign key constraint that doesn't exist, there should be no difference as a result of removing these lines.  Note that you may have to remove some of the following lines if you get similar errors.


Having error in contribution page after upgrade to 4.7.29 I'm a civicrm user, and I have problrm with contribution page after upgrade to 4.7.29, My civicrm installed on Joomla 3.8.3, this error show when I open the contribution form from frontsite.

the error message is :
Warning: require_once(CRM/Core/.php): failed to open stream: No such file or directory in /home/ablecomm/public_html/administrator/components/com_civicrm/civicrm/Civi/Payment/System.php on line 59

I have been trying to fix this but no have idea where is the problem.

is Anybody can help me?
thankyou

This is a known bug and is documented and fixed at CRM-21595.  You will need to apply the patch to fix the problem or will need to wait for 4.7.30 release.


How do i add an custom activity field to an email in civimail? When i send an email to someone i need it to include activity tokens in the email. All you can use currently is contact fields. Any thoughts?

This doesn't solve anything, but a note for future development: contributions have the same situation where it's ambiguous which contribution you're talking about if you're emailing a contact.  However, there's a nice feature for sending thank-you letters (PDF or email) that has the contribution and contact tokens.  The difference is that this is accessed from the contribution search, so you're explicitly picking the contribution.

Something similar could be done for activities: if you do an activity search, it would be nice if emails generated from there allowed for including tokens referring to the activity.  Likewise, it would be nice to have a button from the activity saying "send an email regarding this activity".


Geocoding: Can you only use it for contacts? I want to use Geocoding on Cases. My cases have specific locations and I would like to input an address and then use Geocoding. Can this be done?
Thanks

If this is a situation where the Case is related to a house/building site and hence you want to be able to map 'all cases' then getting Address fields and Lat/Long fields would take significant coding I think.

Workarounds? If you already have an Organisation Contact sub-type to represent the dwelling then you can get the Lat/Long for that and hence create the map filtering on those which have current Cases.


Sales Tax not added to total when memberships include donations that are separate transactions We are having a problem with sales tax calculations when letting the user add an optional donation to a membership purchase or renewal. We need to separate the membership and donation into two transactions (selecting "Separate Membership Payment" on the membership tab of the contribution page) so that the the charitable donation receipt will be generated.  If we don't separate the payment, the sales tax is computed properly -- but then we can't generate a charitable donation receipt.
When we separate the transactions, the sales tax is not added to the membership purchase, but it does appear on the receipt but is not added or charged.
On the contribution page:

Financial type is set to Donation - that type will generate a charity receipt, but no sales tax
"Contribution Amount section enabled" is selected to let the user enter a donation with membership, with "allow other amounts" selected so that they can enter what they want
"Separate Membership Payment" is selected, as described above

For example, if we select a $90 membership that needs $11.70 sales tax with an $100 extra donation:
Receipt 1 (for membership), shows sales tax but it is not added to the total:

Receipt 2 (for donation) shows no sales tax and is correct:

I have tried the patch but that didn't make a difference.
I am using WordPress 5.5.1 and CiviCRM 5.29.1 with CiviMember and CDN Tax Receipts extension.

Looks a bug - can you log an issue in gitlab - https://lab.civicrm.org/groups/dev/-/boards


Export all data for Contact i'm new on civicrm and try to export specific contacts. I found the search menu to select the data and i made an export with " Export PRIMARY contact fields" but some fields are not in the export. How i could select all the fields of my contacts create on the civicrm database. Thanks for your Help. Marilyn

Welcome to stack exchange. There are some other questions that may provide you with some answers. Before asking a question you should always do a search. Try searching for "export all data". Also it would be worth saying why you want to do this export. It seems an odd thing to do with a new site.

But to help you, "Export PRIMARY contact fields" is a particular set of fields chosen by someone else and rather general. If you choose "select fields for export, you can chose whatever you want. A bit tedious for all fields, but you can save the selection for later use.

Be aware that you can't export multi-value custom fields this way (though you can get a report to do this.


Issues with Civi Member Sync and Groups Plugin I have the latest CiviCRM and Wordpress installed. I've got the latest Groups plugin for Wordpress (https://wordpress.org/plugins/groups/), and the CiviCRM Wordpress Member Sync plugin (https://wordpress.org/plugins/civicrm-wp-member-sync/).
I am having the exact same problem as detailed by the user in this post. The issue being users seem to be only being placed in the default group and not in the group created and connected to the capability as defined in CWMS.
My desired flow is:
CiviCRM Contribute form -> Adds membership to Civi -> User is synced -> User is placed into Member Group 1.
Currently, all seems to be working except for the last step. The users seem to be only be placed in the default group.
Thanks so much for any help.
Screenshots

As far as I can tell from your screenshots, Groups is either (1) not installed or (2) not configured. Here's what you should see:

Note the extra column which shows the Groups groups.


Duplicate Contact Problem The new individual record is created, written phone number.
When registration opened again with a new phone number can be the same individual.
Telephone number of systems with the same record, I want to prevent the creation of new personal record.
I do not want this to happen Duplicate Contacts
How can I make this setting.

Joomla! 3.6.4
CiviCRM Ver: 4.7.12

You need to set the deduplication rule to match what you need. Not sure I completely understood your use case, but it seems that you have included the phone number on your default unsupervised dedupe rule?

Check this chapter in the book if the dedupe rules are not clear for you yet, it's powerful, but takes a while to use them properly and a common source of duplicates being created.

https://docs.civicrm.org/user/en/4.6/common-workflows/deduping-and-merging/


CiviCRM + Drupal + Office 365 Integration We are working on the project with CiviCRM with drupal CMS. In some case we need office 365 mail in the dashboard with the inbox,draft, sent items etc. i would like to know the possible option to explore this? Is any plugin / module available for integrating office 365 with civi?  Also i would like to know any other better option apart from office 365 for mail/message system in CIVI.

Thanks

The usual way of email integration is a bit different.

CiviCRM can read a POP/IMAP account, this can be the full account or a subfolder in it.

Then you have your own mailreader, be it outlook, thunderbird, gmail, office 365 mail or any other system.

What I often do for customers is the subfolder option.
When any email is worthy to be stored in the CRM it can be copied to the subfolder. CiviCRM then stores it as an activity. The activity is connected to both the sender and the recievers of the email.

If email address exists in the CRM then activity is connected to that contact. If email address does not exist a new contact is created.

Much more information can be found http://wiki.civicrm.org/confluence/display/CRMDOC/Autofiling+email+activities+via+EmailProcessor

When you see a much better solution with a different kind of integration with Office 365 mail, you can consider helping the whole community with an extension for it.


Activity iCal : Start time = End time I work with CiviCRM 4.6 and Drupal 4.7
When I create an activity in CiviCRM, a iCal file is also created and sent. But in this iCal file, Start time = End time. So when I import the file in my calendar the activity doesn't have the right duration. Any idea ? Maybe I can modify a template, but how ?
Regards,
Hashkey

Check:

templates/CRM/Activity/Calendar/ICal.tpl

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

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


CiviMail error due to a word in the mailing - why? I was contacted by someone who was having trouble saving a mailing, get this error in CiviMail:

I ended up comparing the version that saved with the version she had pasted in (which had some content additions) and then line by line (word by word) deleting the newly added text to try to identify a problem. It turns out it was the word "Reunion". I would delete the word and drafts would save, test emails could be sent... I would type the word back and the error would recur.

I've tried this on another install and had no problem using the word reunion so I am totally stumped as to how this could possibly occur. Any ideas?

I recently had a similar problem (with Moodle, not CiviCRM, on a shared host) giving errors when a particular word was in the content that was being submitted by the user. It turned out to be triggering a mod_security rule, resulting in a 403 error. Whitelisting that rule resolved the problem.

Edit (by Laryn): Here's the mod_security rule (#300016, "Generic SQL injection protection") that was triggered in this case:


Remove CiviCRM logo from Invoice pdf? I am on Wordpress 4.9.5 and Civi 5.0.1.
Please see the screen shot of a downloaded pdf invoice. I would really like to remove that CiviCRM logo or replace it with my own.  Is there a configuration somewhere I can do that?

Thank you

The invoice is generated based on the template "Contributions - Invoice". It contains a line to the logo ({$resourceBase}/i/civi99.png" height = "34px" width = "99px") that you would need to replace.

You can find teh message templates by Navigating to >>Administer >>CiviMail >>Message Templates in the tab "System Workflow Messages"


Using the LIKE operator with a wildcard using API v3's REST interface I am trying to do a simple GET request using a LIKE operator with a wildcard. It's easy to set up the explorer and works as expected. I'm using a demo civi environment using the example data included on install. There are two Heidis in the database.
The rest URL generated in the explorer is:
https://civi.site.com/wp-content/plugins/civicrm/civicrm/extern/rest.php ?entity=Contact &action=get&api_key=userkey&key=sitekey&json={"sequential":1,"first_name":{"LIKE":"Heid%"}}
As is, I know that the URL will generate the error: Unable to decode supplied JSON.
I have reformatted it to:
https://civi.site.com/wp-content/plugins/civicrm/civicrm/extern/rest.php?key=sitekey&api_key=userkey&entity=Contact&sequential=1&json=1&action=get&first_name=Heidi
That works as expected using the exact match on Heidi. I tried using the LIKE operator using array syntax:
https://civi.site.com/wp-content/plugins/civicrm/civicrm/extern/rest.php?key=sitekey&api_key=userkey&entity=Contact&sequential=1&json=1&action=get&first_name[like]=Heidi
I get the expected response, but this uses the exact value and no wildcard characters.
I've tried three different options for wildcards:

Like array no wildcard:
https://civi.site.com/wp-content/plugins/civicrm/civicrm/extern/rest.php?key=sitekey&api_key=userkey&entity=Contact&sequential=1&json=1&action=get&first_name[like]=Heid
Like array with wildcard:
https://civi.site.com/wp-content/plugins/civicrm/civicrm/extern/rest.php?key=sitekey&api_key=userkey&entity=Contact&sequential=1&json=1&action=get&first_name[like]=Heid%
Like array with encoded wildcard:
https://civi.site.com/wp-content/plugins/civicrm/civicrm/extern/rest.php?key=sitekey&api_key=userkey&entity=Contact&sequential=1&json=1&action=get&first_name[like]=Heid%25

None of the three wildcard attempts produce an error, but they return 0 results. I've looked through the docs and have done multiple Google searches but I can't find a workable solution. Any help would be greatly appreciated.

the correct syntax is the one at the top:
"first_name": {"LIKE":"hei%"}
to work around the encoding issues (that might be tricky indeed), don't try to put all the params in the url (as http get) but use a http post (the api works with both)


What is the Membership type 'domain' in the api? The API explorer shows something promising:

Apparently, each membership type can be connected to a 'domain' which is a contact ?

What exactly is it, and how could I assign these domains to a membership type ? The backend interface does not seem to mention it.

[EDIT] anything to do with https://docs.civicrm.org/sysadmin/en/latest/install/multi-site/ ?

On multisite you tie each membership type to a domain id. You can find what the domain ID's by looking at the civicrm_domain id table (or in the civicrm.setting.php file).

If you create the memberships on the correct domain they will be correct I believe, but if you don't then just adjust the domain_id in the civicrm_membership_type table.

Then only the memberships tied to a certain domain will be available for selection on a given domain.


GDPR Data Privacy Policy In the framework of setting up our Data Processing Register, could you kindly provide us with your Data Privacy Policy, please ?
Thank you

CiviCRM -as the software- doesn't have a privacy policy, because it doesn't hold any personal data.

Your specific instance of that software, as installed on your server or hosted by one of your provider does store personal data. Check with your provider if they have a privacy policy.

However, the privacy policy depends on what personal data you collect and what your organisation does with it, so you are likely to have to adjust based on your own unique way of using CiviCRM.

While you detail that, may I suggest you to look at how your CiviCRM might be connected to other providers, for instance to process the credit card donations or to send your emails? you will need to check what personal data of your contacts you share with them to let them perform the service, and clearly explain that in your privacy policy.

And lastly, we found the easiest way to be GDPR compliant is to be enforce data minimisation, eg only collect the data you need and know/explain why you collect it (and get consent!). For instance, are you really calling your contacts? if not, it's probably simplier and safer to remove the phone field.

Good luck!


Ignoring a hidden field on event registration form I have a custom event template on which I hide some fields based on whether someone is registering themselves or an additional participant. There are 2 different price options, one for the main registrant and one for the additional participant. The price set needs to have required fields for each situation. How can I get civi to ignore the required fields if they are hidden?

AFAIK this cannot be controlled in CiviCRM ATM. However there is an extension(from Allen Shaw) for conditional filtering on profile but I guess this will not work in your case.

I would suggest you to create an extension and use combination of buildForm or ValidateForm hook to achieve.

Cheers

Pradeep


How can I use Drupal Rules to remove a contact from a group Webform_CiviCRM integration enables me to add contacts who submit a form to a Civi group. What I'd like to do is to remove them from another group at the same time, as part of a pipeline process. Drupal Rules module offers 'Remove contact from CiviCRM group' as an action, but I can't work out how to "select data of the type Contact" which seems to be what Rules is looking for in order to enable this action. How can I create a rule that removes a contact form a group based on the matched Drupal user submitting a webform (or perhaps based on the fact that the webform adds the contact to a group)?

Graham, you can do this with CiviRules? Trigger should be when contact is added to group, condition specifies what group and the related action is to remove contact from group.


Monitoring other's activities As an admin is there a way to see what other people have been doing on their accounts on the same civicrm database?

Most actions are saved as an Activity in CiviCRM. You can get all Activities through the Advanced Search:

Menu: Search > Advanced Search
For the search field Display Results As select Activities

Using all the other search criteria you can filter the kinds of activities you are interested in (e.g. Activities of a specific user).

Does this help? Or what kind of things are you looking for?


non technical approach to associate contributions with memberships Does anyone know of an extension / not technical approach that allows users to manually associate contributions with a membership when they have not been properly associated.
I've seen this happen for various reasons including user and system error. We sometimes write short scripts to fix this by creating entries in the civicrm_membership_payment table when it is easy to know what should be linked with what but it would be nice if users could do this on a one to one basis, 1) so they don't have to ask a developer and 2) for those times when it is not obvious what should happen (multiple memberships, contribution types, etc.)

org.civicoop.membershippayment does this and only this.


Automatic filing of pdf letter activity within civicase I am experimenting with "create printable letter" from within a civicase case as a mechanism for writing a letter to that particular client. However the resulting letter does not get automatically filed as a case activity, and there is no "file on case" button on the popup. It is possible to subsequently locate the activity and then file it on case but this is time consuming.

Is there a way to have the letter automatically filed within civicase in a similar manner to which e-mails are automatically filed?

Thanks in advance.

NB We are still using civicrm 4.5.5

Go to Administer > CiviCase > Case Types and add "Print PDF Letter" as an allowed activity to your case type. You will then be able to create a PDF directly from the "Manage Case" screen.


Anyone building or built - an API Call into Zoom to Add A Meeting Registrant I have CIVI Events installed on my site and I am looking to integrate with Zoom /Meetings. With an Event Registration i want to take the Participant record. Post the information to Zoom API call  Meetings Registrants - then write the response back into the Civi Events Calendar object for that user, the unique registration URL. Is there a civiextension for this, or anyone available to help us with this piece of work?

https://github.com/veda-consulting-company/ncn-civi-zoom
We have forked the original extension, I would use ours as we have fixes/changes to make it configurable and the original developer hasn't yet accepted them.
At the moment it works with webinars but we can adapt it to work with meetings too.
Let us know if you need anything else or you can raise issues on the repo for anything you need.
Thanks


How do I get more than 25 records from the API? I'm making a normal api call such as:

$params = array(
  'version' => 3,
  'sequential' => 1,
  'membership_type' => 1
);
$result = civicrm_api('Membership', 'get', $params);

But I only get 25 results back.

How do I get more than that, and how do I ensure I can retrieve all results, if say there was 5,000?

To return more than 25 results you need to add options.limit to your api call:

$params = array(
  'version' => 3,
  'sequential' => 1,
  'membership_type' => 1,
    'options' => array(
    'limit' => 100,
   ),
);
$result = civicrm_api('Membership', 'get', $params);

For the second part, we want to be able to retrieve say 5,000 records. We can't really set rowCount to 5,000 because depending on the size of data, we run the risk of timing out.

The solution here is to page the results using a parameter 'options.offset':

$params = array(
  'version' => 3,
  'sequential' => 1,
  'membership_type' => 1,
  'options' => array(
    'limit' => 100,
    'offset' => 100 // offset value is equal to the number of results to skip
  ),
);

For this to work, we decide on what our ideal page size is let's say 100. We set options.limit to 100, and then we increment offset by our page size (100) on each call, until we no longer get results.

How do we know when we're done? Check the value of count in the returned result. When the returned count is less than the page size, stop.

  $memberships = array();
  // Initialise our pagesize and offset
  $page_size = 100;
  $offset = 0;
  // Start out loop
  do {
    // Call the api
    $results = civicrm_api(
      'Membership',
      'get',
      array(
        'version'         => 3,
        'sequential'      => 1,
        'membership_type' => $membership_type,
        'options'         => array(
          'limit'  => $page_size,
          'offset' => $offset
        )
      )
    );

    // do something with the results if we didn't error
    if ($results['is_error'] == 0) {
      foreach ($results['values'] as $value) {
        $memberships[] = $value;
      }
    }

    // Increment the offset by the page size
    $offset = $offset + $page_size;

  } while ($results['count'] >= $page_size); // Check if we still need to fetch results


Descrepancies in search result counts I'm migrating to a new Drupal 9 install, and after a decade of using CiviCRM, I want to pare down the number of records. If I do a simple find contacts search with no criteria, I get 74144 results. I've also searched for everyone who has given us contributions as well as everyone who opted in to our email list and put them in a separate group. This group, "2021_keep" has 6046 contacts.
Next I go to Search Builder and put in the query
Group(s) Not In 2021_keep ...AND... Group Status 'Added'
Actually, just the first part is my query, the second part gets added after I click to search.
Result is 71858 contacts. I would expect the result to be 74144 - 6046 = 68098 contacts.
This is kind of important, as I want to delete all of these contacts, who are people that at some point signed a petition we hosted but didn't sign up for the email list, or later opted out of it, etc.

When you search for Group(s) Not In 2021_keep, Search Builder may be interpreting it as "contacts who are in some group that's not 2021_keep". That's not what you want.
Here are two three options for finding all the contacts who are not in the group "2021_keep".
Include/Exclude Search
Go to Search > Custom Searches and click on Include/Exclude Search. Set "2021_keep" as the value for "Exclude Group(s)". Click on either one of the radio buttons next to "AND/OR" (it doesn't matter which you choose, since you're not using tags in your search.)
You should be able to delete contacts directly from the search results, or perform various other actions on them.
API v4
If for some reason the Include/Exclude search doesn't satisfy, and you are on a recent version of Civi, you can do your search using API4. You should have access to the API explorer at the url civicrm/api4.
Configure your search as follows:

Entity: Contact
Action: get
Select: id
Join: GroupContact
On: group_contact.contact_id = id
On: group_contact.group_id =
On: group_contact.status = "Added" (note the quotes)
Where: group_contact.id IS NULL
You can pre-fill these values by deleting everything in your URL bar to the right of the word "explorer", and replacing it with:
/Contact/get?join=[["GroupContact AS group_contact",false,null,["group_contact.contact_id","%3D","id"],["group_contact.group_id","%3D","1"],["group_contact.status","%3D","\"Added\""]]]&where=[["group_contact.id","IS NULL"]]&select=["id"]&debug=0&checkPermissions=0
Remember to change the Group ID to the id of your "2021_keep" group. When you're finished you can use the "Save" button at the top to save the results as a Smart Group.
Group subtraction (remove from group)

Use the basic "Find Contacts" search with empty search criteria to find all your contacts.
Above the result table, click "All 74144 records", then select the "Group - add contacts" action. On the following screen, create a new group called "NOT in 2021_keep" and click "Add to Group".
Do another "Find Contacts" search. This time, set the groups field to "2021_keep".
Above the result table, click "All 6046 records", then select the "Group - remove contacts" action. On the following screen, select the "NOT in 2021_keep" group you just created. Click "Remove From Group".

Now your "NOT in 2021_keep" group should have 74144 - 6046 = 68098 contacts in it.


Associate a tag with a contact where drupal tables have a prefix using civicrm 5.32.2 - drupal table prefix missing CiviCRM 5.32.2 is missing the drupal 7.77 prefix when trying to access drupal tables that should have the drupal table prefix applied. How can I fix this?  I am using Shoreditch theme, running with PHP 7.3.25, and MySQL server version 5.7.26
This is the error I get when trying to update an individual's record:
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: no such table
Error Details
Database Error Code: Table 'jandbweb_jandb78.taxonomy_vocabulary' doesn't exist, 1146
Additional Details:
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -18
[message] => DB Error: no such table
[mode] => 16
[debug_info] => SELECT  t.tid as category_id, concat( v.name , '-', t.name)  as category_term_name
             FROM jandbweb_jandb78.taxonomy_term_data t
             JOIN jandbweb_jandb78.taxonomy_vocabulary v ON t.vid = v.vid
         GROUP BY t.tid [nativecode=1146 ** Table 'jandbweb_jandb78.taxonomy_vocabulary' doesn't exist]
[type] => DB_Error
[user_info] => SELECT  t.tid as category_id, concat( v.name , '-', t.name)  as category_term_name
             FROM jandbweb_jandb78.taxonomy_term_data t
             JOIN jandbweb_jandb78.taxonomy_vocabulary v ON t.vid = v.vid
         GROUP BY t.tid [nativecode=1146 ** Table 'jandbweb_jandb78.taxonomy_vocabulary' doesn't exist]
[to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  t.tid as category_id, concat( v.name , '-', t.name)  as category_term_name
             FROM jandbweb_jandb78.taxonomy_term_data t
             JOIN jandbweb_jandb78.taxonomy_vocabulary v ON t.vid = v.vid
         GROUP BY t.tid [nativecode=1146 ** Table 'jandbweb_jandb78.taxonomy_vocabulary' doesn't exist]"]

)
Return to home page.
Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /home/customer/www/jandbweb.jandbwebsite.com/public_html/sites/all/modules/civicrm/Civi/Core/Transaction/Manager.php on line 93
The table being accessed should be 'jandbweb_jandb78.Jbwtaxonomy_vocabulary' and not 'jandbweb_jandb78.taxonomy_vocabulary'.

It looks like you're using the contenttokens extension? It doesn't look like it's been updated in a while but you'll need to file an issue with them. These lines need updating to include the prefix:
https://github.com/sgladstone/com.pogstone.contenttokens/blob/0a949241068afe9b34f49ecacfa0a5bf6a13facc/contenttokens.php#L575-L576


How to change WordPress permalink settings without killing CiviCRM I'm not 100% sure if I'm framing this question correctly but here goes...

When first setting up Civi and WP, I remember setting permalinks as /post-name so that /civicrm pages worked correctly.

We've been redesigning the WP front-end and for content structure purposes we'd like to move permalinks to /category/post-name instead.

Is it possible to do this without killing CiviCRM page links?

Thanks!

My current permalink settings are just that (though it might have been set to that before we installed civi but I do not think so).
I do not think it would brake the site since civicrm is a page and not a post but I may be wrong.


simple way to import membership and contributions together What is the simplest way to import Membership information and corresponding contribution information together from .CSV files?

You cannot do this in one import. You have to update one table per import.

You will likely need the API csv Import extension.

First step will be to create your csv files.
1. If they do not have it already, give each member a unique id number.
2. If your contact info and contribution are all on the same report, divide those into two csv files. You will need to assign the unique contact id # to each contribution.

After you have your csv files ready, you can import the contact files and then the contribution files. I recommend that your first import only have 2-3 contacts and then another with 2-3 related contributions. This way you can test it without making a mess of all 300 contacts.

You may need the API csv Import extension to import the Contributions. It depends on your setup and which fields you are importing.

https://wiki.civicrm.org/confluence/display/CRM/Import+Contacts+from+Other+Sources

https://wiki.civicrm.org/confluence/display/CRMDOC/Import+Contributions


REST API call & endpoint Our organisation has an ios/android app and would like to receive donation thru the app. Developer requires details of REST webserver endpoint of our civicrm to receive & post contact/contribution data. We are using drupal and civi 5.13. How do I get started? any help would be much appreciated. Thanks

CiviCRM provides api for each entity. Each entity has its own parameter. You can use API explorer to find how params are build and need to send through rest api. The API explorer screen provides detailed information about using various method of using api to perform CRUD operation on CiviCRM.

While using rest api you will need to pass Site key (stored in civicrm.settings.php) and User contact's api key (You can either set this in civicrm_contact table or use API Key extension to set and see the api key) as part of authentication.

Cheers

Pradeep


Logging functionnality disabled I used to have Logging functionnality activated on one of my civicrm instance but when i look at log_civicrm_address, nothing seems to be logged since quite a while.

When i look at the config screen Administer -> System settings -> Misc (Undelete, PDFs, Limits, Logging, Captcha, etc.), the logging functionnality is disabled and neither set to Yes or No.

How can i re-enable this (and any idea why it's like that) ?

EDIT

CiviCRM is in version 4.6.5 and logging was activated in 4.2 (or maybe before).

I don't have an idea why it got turned off; perhaps an upgrade cleared it?

At any rate, a fresh install does not set a default selection on these radio buttons. You should be able to simply select Yes and then save.


How do you change the default status message that shows when one submits a profile form? At the moment it says 'Thank you. Your information has been saved' after one submits a form. I can't work out where to change this.

Any ideas?

This message is hardcoded in CRM/Profile/Form/Edit.php, so you would need to modify that.


What browser does Mosaico work in? Currently on:

CiviCRM - 5.3.1
Mosaico - 2.0-beta3.1512698300
CiviCRM Bootstrap theme - 0.1-alpha14
Flexmailer - 0.2-alpha5

In Firefox 'Quantum' - when hitting Continue on a mailing created this morning civicrm/a#/mailing/59 (with another browser) -> it's stuck "Loading" (see top right) when I hit Edit on the Mosaico Mailing

The current version produces a "Update your browser!" message - which is not helpful since I already have the latest, and that is not the problem.

Mosaico itself (not just the CiviCRM integration) is picky about the plugins you have installed in your browser.

See https://github.com/voidlabs/mosaico/issues/383#issuecomment-428911320 and https://github.com/voidlabs/mosaico/issues/312#issuecomment-295278878

  You have the RightToClick extension installed and this extension
  manipulates HTML content. Doing so it would break the email template
  generation. That's why we give that alert.

  Any extension that alters html for every iframe in the page is an
  incompatible extension: AFAIK apart RTC extension, the only other
  extensions doing that are spam stuff.

So paraphrasing, if they don't like the look of your plugins you are blocked.

Go through your plugins and disable them until you find which one is causing the problem.

In my case, it was the Google Analytics Opt-out Add-on - disable that and it passes the compatibility test.


Wordpress: MyISAM Database Engine Error after update After update to Civicrm 5.8.0 I got a:

MyISAM Database Engine
Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to InnoDB. Using MyISAM tables will result in data integrity issues.

Had a look into the db, found out it's just about three tables:

Is it save to do ALTER TABLE tablename ENGINE=InnoDB;?

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

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

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


"Error while sending QUERY packet. PID=975356 in wp-db.php on line 1877" for new install I am (trying to be) a new CiviCRM user.  I've tried installing both 4.7.16 and 4.6.26 on clean installs of WordPress 4.7.2.

I end up with the following error when installing the plugin.

"Error while sending QUERY packet. PID=975356 in wp-db.php on line 1877"

I can then Activate the plugin, and then I Configure CiviCRM.

"Database version and connection settings have been verified and look correct!"
as follows:

CiviCRM Database Details

Does the server exist?  OK (localhost)
Are the access credentials correct? OK
MySQL version at least 5.1  OK (MySQL 5.6.33-log)
Is auto_increment_increment set to 1    OK
Is the provided database name valid?    OK
Does MySQL thread_stack meet minimum (192k) OK
Can I access/create the database?   OK (Database 'jointe6_wp278' exists)
Can I access/create InnoDB tables in the database?  OK
Can I create temporary tables in the database?  OK
Can I create lock tables in the database?   OK
Can I create triggers in the database?  OK

Requirements

PHP Configuration

PHP5 installed  OK (PHP version 5.5.38)
MySQL support   OK
JSON support    OK
Memory allocated (PHP config option 'memory_limit') OK (512M)
File permissions

Does the webserver know where files are stored? OK ({location}/wp-admin/)
Does the CiviCRM path contain PATH_SEPARATOR?   OK ({location}/wp-admin/)
Folder 'CRM' exists?    OK
Folder 'packages' exists?   OK
Folder 'templates' exists?  OK
Folder 'js' exists? OK
Folder 'api' exists?    OK
Folder 'i' exists?  OK
Folder 'sql' exists?    OK
Is the {location}/wp-content/uploads/civicrm folder writeable?  OK

I click Check and Install
It reports that it was successfully installed

But the page refreshes and I get the following error:

CiviCRM Home

System Status: Error
Cron Not Running
Timestamp Mismatch
Configure Default Mailbox
Complete Setup

At this point, anything I try to do only shows "System Status:Error"

Any suggestions?

TIA!

Problem solved.  There was an installation of WordPress left in the public_html directory from a prior install. Removing this WP installation allowed the CiviCRM plugin installed in addon domain folders to work properly.


How to access the APIv3 from wordpress plugin files I'm developing a little wordpress plugin which creates a custom post type with a custom field where I would like to store an ID of one of the active contribution page of CiviCRM in order to associate this content with the contribution page information.

This very same code works in theme files but fails when is used in plugin files, breaking the site.

   function get_contribution_info($f_type){
   $params = array(
       'version'    =>  3,
        'financial_type_id' => $f_type,
        'is_active' => '1'
    );
    try{
       $result = civicrm_api3('contribution_page', 'get', $params);
    } catch (CiviCRM_API3_Exception $e) {
        // handle error here
        $errorMessage = $e->getMessage();
        $errorCode = $e->getErrorCode();
        $errorData = $e->getExtraParams();
        return array('error' => $errorMessage, 'error_code' => $errorCode, 'error_data' => $errorData);
    }
    return $result[values];
    }

    $get_contrib = get_contribution_data( '1' );
    $contributions = array();
    $i = 0;
    foreach($get_contrib as $c) {
        $contributions[$i]['label'] = $c['title'];
        $contributions[$i]['value'] = $c['id'];
        $i++;
    }

I've tried to add a require_once the class.api.php without positive results.

Thanks in advance for your help!

Try prefixing your API call with:

civicrm_initialize();

The "class.api.php" is for when you want to use the REST API from an external site.


Is it possible to automatically email individuals once I manually add them to a group? I'm with a small non-profit, and we'd like new additions to our general mailing list to automatically receive a "welcome" email when we manually add them to the list (a group in Civi). Is this possible?

I read that we could set up an "automated message," but my impression is that this will only work if we have a subscribe button on our site that the individual must click on.

My preference would be to continue inputting new contacts manually then have an automatic email go out when I add them to the mailing list group, but I am open to new suggestions if this is not possible.

Could you provide insights on this or point me in the right direction? I am very new here; please let me know if I need to include more info and apologies for my ignorance. Looking forward to your input.

You are able to use Scheduled Reminders (Administer > Communication > Scheduled Reminders) to automate messages and set when they go out. For your goal, you could limit the messages to go out only to a specified group/mailing list and you can based the automation on something such as when the contact record was initially created.

Click "Add Reminder", give it a title, choose entity type "contact" and "created date". Under "limit or add recipients" choose your mailing list. Then set up various messages and times based on creation date.


Saving a contribution adds a line with negative the tax amount, when using an event price set I replicated this issue in the demo wordpress account. If one creates a paid event with a financial type that includes taxes, enters a price (without using price sets) and books a person, then opening the contribution and clicking the 'save' button behaves correctly.

The problem appears when the event price is a price set. Each time one opens the corresponding contribution and clicks 'save', a new accounting line is created with negative the amount of taxes.

Example after opening and saving several times:
(the total amount should be 400 SEK, but now it say 14 SEK)

This happens when the price set is used with an event, but also (at times) when directly creating a contribution with the same price set as above, but without registering to an event.

This is a bug. I'm unsure if price set config for events was previously tested. I've created an issue in JIRA for this https://issues.civicrm.org/jira/browse/CRM-20676 and we'll work on fixing pro bono (though contributions to help fund fix would be very welcome!).


Do manually added contacts stay in a smart group forever? If a contact is manually added to a smart group (so has the status of 'Added') do they stay there for ever (until manually removed)? I am about 99.9% certain that this is the case. I've had some questions about contacts that shouldn't have been in a group (and so got an email in error) - and the reason is that they were manually added to the smart group.  If true this makes manually adding contacts to a smart group a very bad idea - which I hadn't quite appreciated before.  It makes the case for this feature to be optional so it could be turned off.

It is answered here: https://docs.civicrm.org/user/en/latest/organising-your-data/smart-groups/#adding-and-removing-smart-group-members-manually
"You can override the criteria by manually adding or removing contacts from the group". So, unless the group is deleted or you remove them, my assumption is yes they will stay 'forever'.


Batch create relationships We have 2 relationship types : A and B. We have about 500 contacts with A-relationships already set, and for each we need to create a B-relationship with the same contact. For example :

We already have :

Bob -> A -> Alice

We need to have :

Bob -> A -> Alice

Bob -> B -> Alice

It could be done manually but I thought I could write a custom cron job which does this :

loop over contacts in a particular group (we already have this group)
for each contact with a B-relationship and without a A-relationship :

grab the A-relationship target contact (let's call him C)

create a B-relationship with C

end for each

How can I write a custom cron job for CiviCRM ? Is this a good idea ? Is there a better way to achieve this ?

Thanks

Here's a trick.  Use the API to get relationships with one relationship type and chain an API call to create a relationship with the other relationship type.  You have to explicitly say that the new relationship has "0" as the ID, or else it'll just change the relationships you find.

The following example creates a relationship of type 8 for each relationship of type 7.

CRM.api3('Relationship', 'get', {
  "relationship_type_id": 7,
  "api.Relationship.create":{
    "id":0,
    "relationship_type_id":8,
    "contact_id_a":"$value.contact_id_a",
    "contact_id_b":"$value.contact_id_b",
    "is_active":"$value.is_active"
  }
})

You could add parameters to the Relationship/Get call to just pick certain relationships.  Theoretically, you could also chain all of this to another API call, perhaps to get the members of a group.


CiviCase - how to use for tracking grants we are applying for? I've been asked to use CiviCase for tracking grants that my organisation is applying for but am unsure where to start.
I'm trying it out with sample data, so I've created a contact called "Dummy Grant Body". I have also created a 'Case type' called 'Grant application'. So, under the "Dummy Grant Body" contact, I want to add activities like "initial grant enquiry", "grant application", "grant awarded/denied" etc. I have also been asked to do this in a way that shows grant deadlines/our activities in a timeline. I really don't know where to start and wonder if I need the help of a developer or is this something people have managed to do by themselves? Thank you! Lara

Have you had a look at CiviGrant? Although the workflow is not very detailed it does help to track what you have. You could set up a case type for the Grant process. This is something people have done by themselves. If you find you are stuck I would recommend you get functional support for a couple of hours. You might even need a developer (depending on what you want to achieve) but I would certainly NOT start there if you are not clear on where you need to go.


Paypal standard on contribution forms Getting this error when clicking on the paypal button on the contribution form:

Payment Processor Error message
10471: Transaction refused because of an invalid argument. See additional error messages for details. ReturnURL is invalid.

I tried deleting the paypal standard as a payment processor to see what would happen but clicking the button gives the same error.

You've probably done this, but the CiviCRM wiki provides instructions on how to set up the return URL for paypal.


What are some best practices for inbound email handling with CiviCRM? Our organization has grown past the point where one person can handle the inbound e-mail from our members.  I'm looking for best practices from the community on how to handle this.

We don't want to give all of our staff access directly to the e-mail account.  As staff come and go, we would have to connstantly change the password to that account.  Also, giving everyone direct access to the account would require a tagging system to know who is handling what message.  This seems less than ideal.

We could adopt a ticketing system, either something like osTicket or something like Zendesk.  But I think it would be nice to have all of our interactions with our members in one clear place.  After all, isn't that what a CRM is supposed to do for you?

I looked at CiviCase and at first glance it appears to be exactly right.  But for some reason out of the box CiviCRM does not create a new case for each new inbound e-mail.  Discovering this got me thinking that perhaps opening a case for each inbound e-mail is not the right approach?

So I'm looking for input from the community: for those of you who have grown past the point of 1 or 2 staff to handle inbound email, what do you do to capture the email and respond to it?

Thank you

EDIT:
I looked at CiviRules, but unfortunately it lacks some conditions and some actions to make this possible:

I could say "Take an action when an activity of type Inbound Email is received"
But I could not say that the action should be to create a case.
Presumably I also could not say to assign the activity to the case.
I also could not say "Only take this action if the activity is not already associated with a case" (e.g. if the email subject has a case ID)

Another option to explore is if CiviRules has a 'create case' capability that could be triggered from creating an Activity, which itself had been created by inbound email


How to send conditional mail confirmation after completing payment using webform We have a contribution webform that allows to choose between deferred payment and online payment processor.

We want to send a confirmation mail depending on the payment method choosed. If deferred, mail must contain instructions to complete the payment. If online, mail must contain a thank-you message if the payment is completed satisfactorily.

What is the best approach to achieve this? If we use email webform built in feature, the emails are sent at the time of submiting the form that is  good if deferred payment method is choosed but is wrong if online method is choosed because mail is sent before payment process starts instead of when payment is complete.

You could use the CiviRules extension (https://civicrm.org/extensions/civirules) and the E-mail api extension (https://civicrm.org/extensions/e-mail-api).

You could setup a rule which is triggered when a contribution is added and add a condition the payment instrument (and probably also the financial type). You could then add an action which is send e-mail (this action is provided by the e-mail api extension).

Documentation of CiviRules is at: https://docs.civicrm.org/civirules/en/latest


How to exclude a specific link from a Mailing's statistics I send a newsletter via CiviMail and in it there is a style link to load a Google font.
This link gets many hits in the Mailing report, but has no relevance for me.
Is there a way to exclude this specific link from the Mailing statistics report?

I didn't know you could use webfonts remotely in emails (or, it hadn't occurred to me). Here are some ways you could approach this - pick one! (Or more.)

Modify the recorded data

The "visit" records are stored in DB table civicrm_mailing_event_trackable_url_open and the URLs themselves are in civicrm_mailing_trackable_url. By removing matching entries from civicrm_mailing_event_trackable_url_open you'll zero those numbers off the top of your report.

Don't remove the entries in civicrm_mailing_trackable_url or the redirects to webfonts will stop working, breaking the font in future views.

Modify the recorded data (automated)

Once you have the query for the above, you could add a "cleanup" job to remove clicks where the URL matches (say) /.*(css|woff)$/. This would mean your reports stay clean - but cleanup jobs are a "code smell" IMO, so it's not a great solution.

Change the email - embed the font

You could potentially base64 encode the webfont into the email (this should increase the number of people seeing it in the correct font). That would remove the remote request entirely, but it won't work for an email that has flown!

Change the email - don't use a font

It's an option ... obviously you went to some effort to put a font in, but I'll include this for completeness :)

Exclude .(woff|css) URLs from your reports

You could add an extension which excludes these types of URLs from display in the reports. This feels like a bad approach (you still end up tracking those URLs, slowing down the email, and filling your DB with data you don't need - but then hide the data from your report). But it's possible and might be less work than getting a fix into core, so again ... for completeness.

Modify CiviCRM - only track clickable URLs

It seems like CiviCRM is tracking any URL pattern, which suggests civicrm looked for something like /['"]https?://(.*)['"]/ - but could perhaps only be looking for links. You could gather some data on this to file a feature request.

Does CiviCRM add link tracking to all URLs in emails, or just some?
Does CiviCRM add link tracking to <link href="style.css" rel="http://example.org/style.css"> but not <style type="text/css">@import http://example.org/style.css</style>? (Maybe it's the href= that confuses Civi?)
... ask lots of questions, propose an improvement, consider other use cases, help make it happen!


How to restrict access to CiviMail's reports, e.g. click rates If one sends out a mailing using CiviCRM, one can access an overview of the mailing's result from the mailings menu (see screenshot). From this summary you will also be able to access more detailed information, including the unique opens (see screenshot).

As this information can be considered quite sensitive in regard to data protection, I would like to restrict access to it to certain users/roles. I tried editing the permissions of all relevant mailing reports I could find.

However, it turns out that this information does not seem to be based on CiviCRM'S report function. Even If restrict user's access to any report functions, the detailed mailing information can still be viewed.

Hence my questions are:

Which permission is actually relevant for opening pages such as
civicrm/mailing/report/event?reset=1&event=opened&mid=XYZ&distinct=1
?
Is there any way to restrict access to this information without
denying users to use CiviMail at all?

Tested on CiviCRM 4.7.18 and Drupal 7.54.

I think you can bypass using permission_check hook.


Can I use a custom style sheet (CSS) for user modifications? I have noticed that the content of CiviCRM pages contain selectors such as:

Type selectors elementname,
Class selectors .classname, and
ID selectors #idname.

I know these can be used to modify the style rules to alter a specific element (or elements) of a page.

What stylesheet do you use to alter page content?

Usually I add a section to the theme's CSS rather than editing any core files in CiviCRM.

Note that there is also a "Custom CSS URL" that you can add, and you can also disable the core CiviCRM CSS if you want to. (Administer > System Settings > Resource URLs)


My membership fee changes year to year My organization revise membership fees for every 3 years,

eg: gold membership - 2010 - $100, 2013 -  $105,  2016 - $120, 2019 - $130

Silver membership - 2010 -  $75, 2013 -   $80,  2016 -  $85, 2019 - $100

if Gold member in arreas from 2015 = $105(2015)+ $120*3(2016-2018) + $130 (2019)

then how can I assign membership types and caculate arreas ?
how can I change the membership fee year to year in CiVi
(can assign 'member price sets' according to membership types and calculate arreas?)

You can change the membership price whenever you want - you don't even need to charge everyone the same amount.

When you record a membership from the back end, you can enter any price you want - simply select Record Membership Payment on the New Membership screen and enter the amount.  If you set Contribution Status to Pending, it will show the contribution as owed rather than paid.

On a public-facing page, yes, you can use price sets to set the cost every year.

Because each contribution is stored separately, it's OK that they're different from year to year.  You can see which payments have been made and which haven't.

This will meet your needs going forward.  However, if you start using CiviCRM in 2020, and you have current members in arrears from 2015, that's not going to be calculated.  I would recommend importing pending calculations for each missing payment.  You could use your spreadsheet software to calculate owed amounts if necessary.

Consider installing the Membership Extras extension.  Without it, a member who pays for 2020 but has not paid previous years is considered a current member; with the extension, a member who has paid the current year but is still in arrears can be considered non-current if you like.


Is there an autorespond email function for profile form sign ups (wordpress)? I have a sign up form that adds users to a group- essentially a mailing list which also saves other information about the subscriber. It's a civiCRM 'profile' form.

This all works OK. A user adds their information to the form and their information is saved in a group called members. Now my client would like to automatically email them when a new user signs up. There doesn't seem to be any way to do this 'out of the box'. Someone has raised this issue with regards to Joomla before HERE. But, being reasonably new to web development and civiCRM and don't know how to do this with my WORDPRESS installation.

I think you have to do something with hooks and create a wordpress plugin? http://wiki.civicrm.org/confluence/display/CRMDOC/Hook+Reference

I guess I'm wondering whether someone has already done this? OR they can point me to instructions that a newbie may be able to understand?

I'm using wordpress 4.1.5 and civiCRM 4.6.2

Third option is to use the CiviCRM extension CiviRules. It allows you to set up a rule (in this case when contact is added to group), a condition (group is xxxx) and an action (send email). You will have to add the send email to a specific address option (or wait for someone else to sponsor this action development as there is already a GitHub issue for it).
More information on http://redmine.civicoop.org/projects/civirules/wiki and you can get the extension from https://github.com/CiviCooP/org.civicoop.civirules

The CiviRules extension is now live at MAF Norge and will be tested by Amnesty International Flanders.


Can Civirules differentiate between 'pending' and 'added' group status? I'm using Civirules to assign tags to members who add themselves to a group via public webform using the Linked Trigger 'Contact is added to group,' but the group requires double opt-in. Civirules doesn't seem to differentiate between group status types, so the tag is immediately applied to all 'pending' members even before the member has confirmed via the link in their email. Is there a way for Civirules to recognize the difference between 'pending' and 'added,' and only apply an action when one's group status is 'added'?

You should add a Field Value Comparison condition.  This lets you only fire the rule if a field has a certain value.
For Condition Parameters set the following values:
Entity: GroupContact
Field: Group Contact Status
Operator: is equal to
Compare value:Added


Is there a Notification Setting associated with "potential" Duplicates New to CiviCRM and learning the ropes. I know how to search for duplicates and merge them but wondering if when CiviCRM finds a potential duplicate on its own is there a setting where I can be notified by email or within CiviCRM when I log in to the Dashboard where a "cache" of potential dups is waiting for me to inspect?

Currently, there no setting that will email or notify you about duplicates in your system. The only way is searching duplicates and merging them as mentioned by you.


CiviCRM, Ubercart, and donations through the shopping cart I know that UC CiviCRM creates a "purchases" tab in the CiviCRM contact view that links purchases made through an Ubercart store. Is it possible to set the Financial Type per product in the Ubercart store? For example, rather than requiring a shopping cart checkout and then a completely separate donation process, it makes sense from a usability standpoint to allow a supporter to add a donation to an Ubercart checkout process (using a UC Variable Price product, for example). It would be nice to be able to do this and have the donation push into CiviCRM automatically, but I have a feeling it is not so easy. Am I right, and if so, what would be the best way to implement this?

we have found that using CiviEntities opens the door for using Rules directly to control what gets pushed in to CiviCRM and how (in our case with Commerce not Ubercart). I can't really flesh out more on this as Eileen did the work  and she is probably en route back from the Sprint in Denver. Perhaps the above is enough to give you something to look in to if no one else comes back with a more succinct solution.


Is there a way to customize the Contact Dashboard? Is there a way to customize the Contact Dashboard?

Thank you for your help.

Laryn covers basic customization of the main dashboard (assuming that's the dashboard you're referring to).  You can also customize further:

If you're running Drupal, Views in Dashlets is a great way to get highly-customized dashlets with no coding.
If you ARE looking for coding suggestions, hook_civicrm_dashboard is the place to look.  Also check out hook_civicrm_dashboard_defaults to handle setting the default dashlets for your users.


Missing more menu options three dots/vertical ellipsis (⋮) within administration interfaces I've created some custom data and fields that I now need to delete, but I don't see any options for deletion- only the option to add. Also, I'm unable to edit a custom data group once it's created.
I've also noticed additional administration options are also missing in other CiviCRM administration interfaces e.g. membership renewal, delete, auto-renewal and billing detail options.

If you have CiviCRM shoreditch extension enabled on your site than try adding below line in your theme css file
.crm-container span.btn-slide {
    display: unset !important;
}

Thanks
Pradeep


Token for {$totalAmount|crmMoney}? I want to use in a Mosaico template a token for the contribution and I found in a system template this string: {$totalAmount|crmMoney}.

I tried to use it in my new template but it doesn't show in the email. I have the civitoken extension but {latestcurrentmembership.allfee} doesn't show because it's a "pay later" option and I guess this token works only when the membership is already paid.

Any idea?

There are multiple "token" systems in CiviCRM depending on your context.

{$totalAmount|crmMoney} is a Smarty token, which only works in Smarty emails.  System Workflow messages are Smarty, traditional templates don't handle Smarty by default, but can; Mosaico templates don't support Smarty (by design).

None of the approaches suggested above are without issues, but let's discuss them in turn.

{latestcurrentmembership.allfee} in Civitoken does NOT return the membership fee paid.  It returns the "minimum fee" for the membership type (see screenshot):

If all of your memberships of a particular type are always the same cost, you can set the "minimum fee" and use this token to solve your problem.

Even if you were using Smarty with your mailing, {$totalAmount|crmMoney} wouldn't be available as an option to you.  Mosaico mailings are sent to contacts, not to contributions; the "total amount" token wouldn't know which payment you were referring to.  Consider if instead you can use Thank-you emails or Scheduled Reminders or CiviRules instead of CiviMail.  There's the mosaicomsgtpl extension that copies a Mosaico template to a traditional one for use with non-CiviMail mailings.
When sending as a contact, you CAN use a token for "Total amount of latest completed contribution".  It's available in CiviToken, and depending on your situation, may solve your issue - but only considers completed contributions.  To change this, open the civitoken folder, go to tokens/latestcontribs.inc, and remove the line that reads AND civicrm_contribution.contribution_status_id = 1 to consider all contributions, complete or not.

Finally, some solutions that don't (yet) exist:

The "Latest Membership Fee" token in CiviToken CAN return the actual amount - the author just didn't need to in her case, so she wrote a shortcut.  One could create such a token.
I've got a task on my plate (probably for this month) to write tokens for contributions that can be filtered on financial type.  So instead of "Total amount of latest completed contribution" you can specify "Total amount of latest completed contribution with Financial Type of 'X'".  If this would solve your problem, let me know on https://chat.civicrm.org and I'll let you know when I get to it.


My Configure Your Dashboard stopped working after update After updating civicrm from version 4.7.10 to 4.7.11, the configure fucton does not work any more.
There are no buttons any more in the configuration dahsboard:
 and drag and drop does not work anymore.
Meanwhile the Dashboard itself stays robust and in good health and keeps working okay.

I tried flushing all caches in the site, and sometimes this helps, and the dashboard then looks correct again and functions, but minutes later the image changes back to the button-less like the one in the image above.
I checked with Firebug and this reports a javascript error, with a very long text that I do not understand at all.
It is a pity because this has worked all the time in the versions before 4.7.11.

Any advice on what to do?

In CiviCRM 4.7.11 the issue could be solved by closing all widgets before configuring them.
In version 4.7.12 the issue does not present itself anymore: solved.


My custom reports work fine, but mail_report fails All of my custom report mail_report jobs give this error, both through cron and when triggered manually:

  "Did not find valid instance to execute"

The report is defined as

class com_foo_bar extends CRM_Report_Form {

It is stored as an extension in

[civicrm.files]/ext/custom

For example, report 70 works fine in a webbrowser .. it is at

https://mydomain.com/bla/civicrm/report/instance/70

But the mail_report job log says

  Entity: Job Action: mail_report Summary Finished execution of yyy with result: Failure, Error message: Report Mail
  Triggered... Did not find valid instance to execute Details

  Parameters raw (from db settings):  instanceId=70 format=csv

  Parameters parsed (and passed to API method):
  a:3:{s:7:"version";i:3;s:10:"instanceId";s:2:"70";s:6:"format";s:3:"csv";}

  Full message:  Finished execution of yyy with
  result: Failure, Error message: Report Mail Triggered... Did not find
  valid instance to execute

The same happens when called from the command line. If job.mail_report is called on a regular report, it returns results. But if it is called on my custom reports, it returns

$ drush -u cron civicrm-api job.mail_report instanceId=70 format=csv sendmail=0
Report Mail Triggered...                                                                                [error]
Did not find valid instance to execute
Array
(
    [is_error] => 1
    [error_message] => Report Mail Triggered...
Did not find valid instance to execute
)

or

$ php bin/cli.php -s mydomain.com -u cron -p XXXXXX -e Job -a mail_report --instanceId=70 --format=csv --sendmail=0
Report Mail Triggered...
Did not find valid instance to execute
Died during callApi

Any ideas ?

What doesn't help, is that the code for Report.php:402

https://github.com/civicrm/civicrm-core/blob/master/CRM/Report/Utils/Report.php#L402

requires

if (strstr(CRM_Utils_Array::value('name', $templateInfo), '_Form')) {

and otherwise

  $is_error = 1;
  // ...
  $messages[] = 'Did not find valid instance to execute';

The 'name' reported for my custom report is more like

com.foo.bar

.. is that a bug, or some requirement I missed ?


What is deleting my Tag? I've run into this twice this month and scratching my head. Read this image upside down: We hit post create Address hook -> my regex extension creates a Tag - all good; happy dance; then something in Core deletes my Tag :-( why?

That looks like your extension is deleting the entity tag?


Is webform_civicrm 7.x-5.1 compatible with Drupal 7.67 and CiviCRM 5.19? In the module update page in Drupal, it is shown as not compatible.
If so, what is the minimal configuration for webform_civicrm 7.x-5.1?
(I will update Drupal soon, but in the meantime, I prefer to update the module, if possible)

I dont see any thing on module page that it says not compatible with 7.67 and Civi 5.19. The minimum requirement for 5x is CiviCRM 5.12+ and you are on 5.19. So i dont see any reason why it wont support.


CiviCRM Upgrade from 4.5beta6 to 4.6.8 - CiviCRM Menu is not displaying/functioning Stepped upgrade from 4.5beta6 to 4.50 stable to 4.60 to 4.68. Was as beautiful and eventless an upgrade process as I've experienced. Congrats and thank you team.

My only QA issue is with the civicrm admin menu. It is busted.

I can confirm menujs script is loading.
I can confirm html for the menu is present.
I can confirm there are no js errors.
I can confirm resource urls are fine.
I have cleared the caches like a maniac.

So all I can think of is some crazy css conflict, but I can't even...

Clicking on a link causes it to expand its LI's but incredibly broken-like.

Any ideas would be incredibly appreciated.

Thank You!

Its a core issue, civicrm/css/navigation.css doesn't gets loaded if drupal already has navigation.css loaded.
Check if your custom theme has navigation.css included, this would cause the error for menu not getting displayed

Fix includes in https://issues.civicrm.org/jira/browse/CRM-17234

HTH
Pradeep


What could be causing Wordpress to create user accounts for members? We are running CiviCRM 5.13.4 on the lastest version of Wordpress.  We have just moved over to Wordpress, so by rights there shouldn't be many Wordpress users registered.

We have CiviCRM Wordpress Member Sync installed.  We have two types of membership - Full, and Associate. Wordpress Member Sync is setup to change the role on any matching user to either 'Full Member' or 'Associate Member'.

It is not set to "Create WordPress Users - Create a WordPress User for each Membership when one does not already exist."

However, bit by bit the number of users in our Wordpress system is climbing - and it's only members who are having accounts mysteriously auto-created. Yesterday there were 180 members with user accounts, today 227.

We can't think of anything we're doing that would trigger these accounts to be created, and as every account has some sort of membership attached to it we can only think that the culprit is something buggy in CiviCRM Wordpress Member Sync, but could it be anything else?

This has been answered in comments above


CiviRules Trigger:Contribution is Added not working for Online Payments I've created several rules that assign a contact subtype to contacts depending on their level of donation.

The trigger I am using is "Contribution is added".

The rules function correctly if a contribution is added via the backend, but not when people make online payments through a donation page.

Is there a setting that would affect this? Is there a way to set up rules that will trigger by online payments?

I did a test with a completely new rule, and online payment correctly triggered the rule.


Notification of new membership sign up I would like to be able to send a notification email to the office manager when a member joins through an online form.  The office manager should be notified for each new member.

How can I do this?

The membership form is set up as a contribution page.

I'm using CiviCRM 4.6.10 on Drupal 7.41.

You can use the advanced setting in a profile to email someone each time it it used. See "Notify when profile form is submitted?" in screenshot.


How to create a Drupal menu link to a civicrm contact profile I would like to create a drupal menu link for a logged in user. I have added civicrm/contact/view, which seems to only work when the contact profile was viewed once.  Otherwise keep getting message We could not find a contact id. Can anyone have a quick solution please?

You can use Menu token module and Civicrm token module to create link in drupal module.

civicrm/contact/view?cid=[civi:contact_ID]&reset=1

Thanks

Pradeep


API Get Contacts which are members of a certain group While trying this request

$result = civicrm_api3('Contact', 'get', array(
'return' => "id",
'group' => "Administrators", ));

we've got

{
    "error_code": "no such field",
    "sql": "SELECT contact_a.id as contact_id, contact_a.is_deleted  as `contact_is_deleted`, `civicrm_group_contact-Administrators`.id as group_contact_id, `civicrm_group_contact-Administrators`.status as status  FROM civicrm_contact contact_a  LEFT JOIN civicrm_group_contact `civicrm_group_contact-Administrators` ON (contact_a.id = `civicrm_group_contact-Administrators`.contact_id AND `civicrm_group_contact-Administrators`.status IN (\"Added\"))   LEFT JOIN civicrm_group_contact_cache `civicrm_group_contact_cache_Administrators` ON contact_a.id = `civicrm_group_contact_cache_Administrators`.contact_id   WHERE  ( contact_a.is_deleted = '0' AND ( ( `civicrm_group_contact-Administrators`.group_id IN ( Administrators ) ) OR ( `civicrm_group_contact_cache_Administrators`.group_id IN (\"Administrators\") ) ) )  AND  ( 1 )  AND  ( 1 )   GROUP BY contact_a.id LIMIT 0, 25  [nativecode=1054 ** Unknown column 'Administrators' in 'where clause']",

whatever operator ( "=" , "Like", "In" ) is being used.

All we wanted is Contact IDs, which should be passed to another API call. Of course, we can get data by Search in Group in browser and export all values, when read csv file and extract IDs, but it would be much prettier with pure API calls.

You should then use another entity; GroupContact. Remember to add the Status=Added


My dashlets have stopped working after my host moved my domain to another server My host moved my site to another server and Drupal/CiviCRM are mainly working fine. However, the dashlets on the dashboard are no longer working. Each dashlet comes up as follows:

  Not Found The requested URL /civicrm/report/instance/42 was not found
  on this server. Apache/2.2.16 (Debian) Server at
  XXXXXXXXXXXXXXX Port 80

I've tried clearing the caches, upgrading Civi to 4.6.10 and restarting the VPS, but it's not fixed it.

If I look in the Apache error log, it comes up with a version of this error for each dashlet:

  File does not exist: /etc/apache2/htdocs/civicrm/report/instance/42

Does anyone have any idea what might have changed?

Please check your civicrm.settings.php and after that

Administer - System Settings - Directories
Administer - System Settings - Resource URLs
Administer - System Settings - Cleanup Caches and Update Paths

And then Clear Cache again


Programatically obtaining a Profile's HTML Snippet Using the administrative dashboard I can obtain an HTML Form Snippet for any profile which I can use to embed in any webpage or context. This is an extremely useful feature.

Is there any way to obtain it programatically, for example using the API or using Drush or some other command or URI foo, so that administrators can change the Profile and the embedded forms will always be updated?

Take a look at CRM_UF_Page_Group::profile().

You want to do that except instead of passing gid (the profile id) through the url you'd make it a function parameter, and then what you want is the value of the $profile variable.


Civi AJAX API Search by "AND"ing 2 Tags I would like to search the Civi API for Contacts that have both of two tags. I'm at a loss as to how to do this.  Right now if you provide multiple tags, the default is to use an OR operation.  For example:

CRM.api3('Contact', 'get', {
  "sequential": 1,
  "tag": [5,7]
  "return": ["tag","first_name"]
}).done(function(result) {
  // do something
});

This currently returns all contacts that have either tag 5 OR tag 7.  I want to return all contacts that have both tag 5 AND tag 7.  Is there any way to achieve this functionality?

I don't think you can do this with one api call.

Not optimal but you could do a postprocess in place of the // do something when the result comes.

Better, you could create your own api call in a custom extension - see https://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension#CreateaModuleExtension-AddanAPIfunction