Jon G - Megaphone Tech
  • Member for 6 years, 10 months
  • Last seen this week
Get current contact id?
16 votes

The answer davejenx is correct but no longer considered best practice. Instead use: CRM_Core_Session::singleton()->getLoggedInContactID();

View answer
Member since date before 1995
15 votes

For CiviCRM 4.6+ go to Administer menu > Customize Data and Screens > Date Preferences. From there, change the Start Offset of SearchDate. For CiviCRM versions before 4.6, this is part of the ...

View answer
How should I copy a site from production to staging?
13 votes

Many of the steps documented on the "Migrating a site" wiki page are handled automatically now. Here's my recipe, which is far from perfect, but is much closer. Copy the entire filesystem to the ...

View answer
Why do I get "Access denied; you need (at least one of) the SUPER privilege(s) for this operation" when importing a SQL dump to CiviCRM?
Accepted answer
13 votes

CiviCRM defines MySQL triggers for certain tasks. When you use phpMyAdmin, mysqldump or similar to export your database to a text file, it exports your triggers as well. The format is something like ...

View answer
Where are the "ConfigAndLog" and "templates_c" directories?
Accepted answer
11 votes

The two directories are found side-by-side. The location varies by CMS; see below. Note that you'll need access to your server's file system. If you have FTP/SFTP/SSH access, you can use that. If ...

View answer
Webform-civiCRM equivalent for Wordpress?
11 votes

CiviCRM has a built in form builder which are called Profiles. It's not as powerful as Webform integration, but may fit your needs. If not, the equivalent for WordPress would be Caldera Forms with ...

View answer
Is there a way to enable or install the full version of CKEditor in CiviCRM 4.6.x?
11 votes

The difference between the "full" and "standard" CKEditor is one of plugins. You can drop additional plugins into the ckeditor plugins folder at: <civicrmroot>/packages/ckeditor/plugins. ...

View answer
How can I show contacts that DO NOT have an activity of type X in last Y months?
Accepted answer
11 votes

The process is slightly roundabout: Create a smart group that captures all contacts called "All Contacts". Create a second smart group consisting of people who have the activity type "Confirm Contact ...

View answer
How to allow parents to register children but still record their own info
11 votes

If you're using Drupal, Webform-CiviCRM Integration will handle your scenario pretty easily. It allows registering any number of participants for any number of events on a single form. You may also ...

View answer
How Do I Fix Mail Send Stopping at 500 Sends?
11 votes

Check Administer menu > CiviMail > Mailer Settings, and see if the "Mailer Batch Limit" is set to 500.

View answer
how can I change the contact type for one contact (to/from individual/household/organization)?
Accepted answer
10 votes

The Contact Editor extension allows you to change contact types safely. It checks for potential data loss, which isn't possible with the API method or the Merge method.

View answer
Moving from Drupal to Wordpress
Accepted answer
10 votes

Migrating from Drupal/Civi to Wordpress/Civi is relatively painless. You'll need to truncate your civicrm_uf_match database table, which links Civi records to CMS users, and repopulate it - ...

View answer
How to compare CiviCRM to Salesforce?
10 votes

Aside from the general arguments against Salesforce, which are well-detailed elsewhere - it's designed for business-to-business interactions. That results in odd architectural decisions. For ...

View answer
Does CiviCRM have servers in Canada?
9 votes

CiviCRM is unlike other online CRMs in that you can host it yourself, rather than rely on the corporation that writes the software to host it. So you can host it wherever you like. This is a major ...

View answer
Need Legislative District Lookups for CiviCRM/WordPress
8 votes

The Electoral API extension is what you're looking for.

View answer
Is it OK to switch to PHP 7.2 now that Drupal 7.6.1 supports it?
8 votes

The latest versions of CiviCRM run fine with PHP 7.2. However, a) this has only been true a few months, b) Drupal 7 has only very recently become 7.2-compatible, c) most major Linux distributions don'...

View answer
Change address location type for all contacts?
8 votes

I'd use SQL. Take a backup first, of course, and test on a non-production server. Then run: UPDATE civicrm_address ca JOIN civicrm_contact cc ON ca.contact_id = cc.id SET location_type_id = 3 ...

View answer
How is the restful API secured?
8 votes

The REST API requires that you specify the site key and an API key. Details can be found here.

View answer
What's the best way to import memberships and their associated contributions?
8 votes

This is doable using the API, and I've accomplished it using Pentaho Kettle. It has a CiviCRM Input and CiviCRM Output step, which use the REST API. You're right to be concerned about the SQL-based ...

View answer
How to get CiviCRM Views to work in Drupal 8 with separate CiviCRM database
Accepted answer
7 votes

I had the same problem today, so I looked in the source code. In civicrm.install there's a function called _civicrm_get_db_config. It's looking in the $databases array for an element with a key ...

View answer
Am i able to do a search for duplicates in the database?
7 votes

Yes - go to Contacts menu » Find and Merge Duplicate Contacts. There is dedupe documentation available. The tricky question is, "What represents a duplicate contact?". For some organizations, two ...

View answer
Regex search for a list of Contact IDs
7 votes

It's true - looking at the code, I can see that Search Builder expects an integer if you're searching on an integer field. An exception is made for using the IN operator, in which case it validates ...

View answer
How do I add/change columns in CiviReports?
7 votes

The short answer is "You can't unless you're a programmer". This is a feature that was never added to CiviReport. However, you have many alternatives. You can use profiles to create a Search View ...

View answer
CiviCRM (on WordPress) runs too slow to be useful
7 votes

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

View answer
List Parents of Children having certain values
Accepted answer
7 votes

Yes, using Advanced Search (Search menu » Advanced Search). Set up the search the same way you would in order to find the children. Additionally, set the "Display Results As" at the top to "Related ...

View answer
How to reset the menu items to defaults
Accepted answer
7 votes

Inside the CiviCRM root directory is a "sql" folder, and inside that is "civicrm_navigation.mysql". Copy it to "civicrm_navigation_restore.sql" and edit the copy to remove all of the SQL commands ...

View answer
How to change Paypal IPN URL when migrating Civicrm onto a new domain?
7 votes

I ran into this problem today, and found my solution. Folks who are saying that you can change the IPN URL on an existing Paypal recurring payment are incorrect; you can't, you can only change the ...

View answer
Incoporating PCPs in Wordpress
7 votes

PCPs don't have an API currently - but I just wrote one in about 15 minutes. I didn't write unit tests, so I can't submit it upstream - maybe this is something you can help with to make CiviCRM ...

View answer
How can we avoid staff users overwriting emails of utility WordPress accounts when testing CiviContribute pages?
7 votes

Ideally, the day-to-day workflow of entering contributions/memberships for your staff should be to use the back-end forms, not the front-end forms, so you don't experience this. However, to help with ...

View answer
How can I set up an incoming email (or bounce) account on GMail with OAuth?
6 votes

This assumes you've already created a G Suite user and can successfully log into their e-mail manually. On CiviCRM Enable the OAuth extension. Go to Administer menu » System Settings » OAuth. Click ...

View answer
1
2 3 4 5
46