Using CiviCRM for Library Management Is there a CiviCRM extension for managing a book and video library - or  some other library management system which integrates with CiviCRM so it can see the membership status out of CiviCRM (only current members are allowed to borrow from the library). Thanks in advance for your answers.

if you are using Drupal - and you aren't needing to use clever "enter the book number and have all the details pulled in from external software" when adding a new item to your library, then i could see a relatively easy path of making each item a node, using unlimited group of fields to track 'out date, in date, person'- and use civicrm entity 'contact reference field' to track which civi contact has the item

and do the rest with views and webforms

there is also https://www.drupal.org/project/library but it may be as much effort as building from scratch imo


Do compiled templates (in templates_c) contain URL data, or get corrupted? I use price-sets with events, where users enter the number of seats/tickets wanted. Lately, and randomly, users get tickets added that they didn't order (e.g., they enter '1' at price_1 and after confirmation, they have '10' at price_2 in addition to '1' at price_1. Since it is random (and I haven't been able to reproduce it myself) I thought it was a browser/memory sort of problem. And, I understand that if BASEURL is not set correctly throught the session (Controller) can error out.
I don't know if this is due to session timeouts. I have cleared cache, checked configuration of paths, directories and all that. If a template were 'corrupted' could that cause it? And can I safely clear/refresh all the compiled templates under templates_c?
Civicrm 4.5 (will be updating soon ISA)

To answer the last part, yes you can safely delete the contents of /sites/default/files/civicrm/templates_c/.  That is a recommended step in the upgrade process


Using CiviEvent Shopping Cart with Wordpress Is it possible to navigate to the View Cart page in Wordpress?

It's Ok, it's early. I worked it out.

http://locahost:8080/civicrm/?page=CiviCRM&q=civicrm/event/view_cart


I got this error after I override the civicrm.settings.php I got this error after I add this line $civicrm_setting['Directory Preferences']['customFileUploadDir'] = '/var/www/testing/sites/default/files/civicrm/upload'; on civicrm.settings.php

Make sure the path has required permission for apache to write a file in it. This errors are usually occur due to permission issues.


How do I add a custom Name Badge? Civi offers four default Event Name Badges, but we need something different (same size as an Avery L4727 label).
Can anyone direct me to how to add a custom name badge? We're using Civi 4.6.15.

Thanks

It's not very strait forward, but here are the steps needs, (credit to Kasia Wakarecy) as commented in the old CiviCRM forum (https://forum.civicrm.org/index.php?topic=35420.0):

The new badge templates can be added through Administer > System Settings > Option Groups > Name Badge Format. That interface only allows to enter the new badge name and a description but no info about the layout. To actually tell CiviCRM some details about that badge layout, direct database update is required to add that value:

To know which value to update in the database, run first this query:
SELECT id FROMcivicrm_option_valueWHERE name = "Avery 5392"
where "Avery 5392" is the name of the new badge layout you just added. The result is going to be like id = 847.
Enter the layout details for that badge into the DB using this query:
UPDATE civicrm_option_value
SET value = '{"name":"Avery 5392","paper-size":"letter","metric":"mm","lMargin":2,"tMargin":25.4,"NX":2,"NY":3,"SpaceX":0,"SpaceY":0,"width":101.6,"height":76.2,"font-size":12,"orientation":"portrait","font-name":"helvetica","font-style":"","lPadding":3,"tPadding":3}' WHERE `civicrm_option_value`.`id` = 847;

Update the id = 847 with the id number from the first query.

The fields above mean:

'name' => '5395' // name of label
'paper-size' => 'a4' // paper size
'metric' => 'mm' // units
'lMargin' => 15 // left margin in mm (because metric = mm)
'tMargin' => 26 // top margin in mm (because metric = mm)
'NX' => 2 // number of items in x (left to right) direction
'NY' => 4 // number of items in y (top to bottom) direction
'SpaceX' => 10 // spacing between items in x (left to right) direction in mm (because metric = mm)
'SpaceY' => 5 // spacing between items in y (top to bottom) direction in mm (because metric = mm)
'width' => 83 // width of one item in mm (because metric = mm)
'height' => 57 // height of one item in mm (because metric = mm)
'font-size' => 12 // font size
'lPadding' => 3 // left padding in mm (because metric = mm)
'tPadding => 3 // top padding in mm (because metric = mm)

Now, that new layout/template is available when adding new Event Badge Layouts (civicrm/admin/badgelayout?reset=1&action=browse)


How to create a newsletter sign up block in Drupal What is the best way to create a e-news subscribe block in Drupal with the form to collect information such as first and last name, email address and interests? I have spent some time Googling how to do this but am running into only very outdated information. Can someone point me in the right direction?

Thanks!

Using Drupal 7.50 with CiviCRM 4.7.15

If you are using Drupal 7 I would use Drupal Webform - together with the Webform CiviCRM integration module, since the Webform module let's you set the form to show within a block.

These are pure drupal webform settings. This is done under Adv Settings, which is on the Form settings tab ie at node/xx/webform/configure "Available as block:
If enabled this webform will be available as a block."

There are then controls as to whether you show the whole node in the block or just the form, which probably isn't an issue in your case.

Then set the civicrm settings on the webform to collect the various fields you want and add them to the Group that is used for the newsletter.


CiviMember permission issue on net new Wordpress install I am working with a test installation of CiviCRM 5.33.0 on Wordpress 5.6 on a local Debian 10 install, MariaDB database.  Vanilla Wordpress, no additional plugins other than CiviCRM.  Configuration checklist is clear, showing no errors.  I have successfully imported 4200 sanitized Contacts with no issues.  Now looking at Memberships.  Membership Dashboard shows a blank page with only the title, nothing else.  New Member gives the "You do not have all the permissions needed for this page" error.  There is exactly one user in Wordpress, my admin user login, and I have explicitly enabled the Member permissions.  I have looked through similar cases listed on StackExchange and while I see things that are similar I do not see any particular "fix".  Can anyone point me in the proper direction?  I see there are two minor updates available for CiviCRM but I don't want to complicate things further by applying them unless so instructed.
All other enabled modules appear to be functional, it is only Memberships that is causing me grief.  Any guidance would be appreciated.

It seems I had to add a Price set in Memberships before I could go further.  Doh!  Please excuse my ignorance and ignore the question.


Dedupe Rules to import contacts without email addresses *UPDATE* UPDATED 1/16/2018
See screenshot.  This is an example of what I am trying to import.  This is the same person. The only difference is the notes.  How can I import this without creating 4 duplicates?

****End Update****

I am still unable to resolve this issue. Is there anyone else who has imported contacts who do not have email addresses?

We are using Civi 4.7.29 on WordPress 4.9.1

We have a whole spread sheet of contacts who do not have email addresses and I am trying to import them into Civi.  The names, addresses and postal codes for individual contacts match, but the Notes are different and that is is why I need to import them, so the notes are added to their Civi profiles

I created a new general Dedupe rules with First Name Weight = 10, Last Name weight = 10, Postal Code Weight = 10.   The idea is if the First Name, Last Name and Postal Code don't match, create a new profile.  If they do match, just update the current profile.  However every time I try this, it just continues duplicating every single person for each note they have.  For example if they have 3 notes on their profile, there will be 3 duplicates for that person.

I tried adding the street address and other fields to the dedupe rule, and still got the same exact results.  It appears  that unless they have an email address it will deplicate the record, and will ignore all other dedupe rules. I was able to perform this same task with no problems with our contacts who do have email addresses.

Can anyone suggest a dedupe rule setting I should try for this task of importing people and their notes, when the contact does not have an email address?

Thank you.

UPDATE
I visited the demo site at https://demo.circle-interactive.co.uk/ and ran some tests and got the same results as I described above.   The screenshot shows my dedupe settings.

In my demo I see that there are three reserved rules for individuals. Reserved means that they cannot be deleted.

When I click the question mark I read:

  The 'Unsupervised' rule for each contact type is automatically used when new contacts are created through online registrations including Events, Membership, Contributions and Profile pages. They are also selected by default when you Import contacts.

I tried to set all reserved rules and my own rule too general, but at import it expects at least one Unsupervised rule active. So I changed my custom rule to Unsupervised and also choose it at import.

Then the dudupe seem to work at import. When set import to Update and it did update, but when I tried Fill, it did not do what I expected. My data:

Dedupe rules (all made general except my custom rule):

My custom rule:

With Fill it would import the first but not add the second phone number, with Update it would import the first and update it with the last, leaving it the the last phone number.

When in my project I tried to use the import feature of CiviCRM I concluded that it is too limited to do what you intend to do. I decided to ignore it and make my own import module in Drupal and using the CiviCRM API calls and the Drupal PHPExcel integration module. PHPExcel reads spreadsheets into a PHP variable and then with dedupe check turned off you can apply your own logic and criteria.


I would like to change the membership type I have a member who signed up under the incorrect membership type. Can I change this? What if the member has already made her membership fee?

Yes you can change the membership type by visiting the contact and editing membership under membership tab. If the membership amount you want to change to has higher amount than you can ask the member to do balance payment or take offline payment and update the contribution to correct amount associated with membership.

You may need to take care if the user has purchased a membership that will auto renew automatically, if so than you will also need to update the amount at the payment processor gateway so that next time during renewal it charges the correct amount.


Upgraded to 4.6 Civicrm javascript errors Error can't send email or press some buttons Error: b.indexOf is not a function b@https://www.websiteremoved.com/administrator/components/com_civicrm/civicrm/bower_components/select2/select2.min.js

I can't add receipients or get past step one of generating a draft, firebug reveals a constant error of:

: b.indexOf is not a function b@https://www.websiteremoved.com/administrator/components/com_civicrm/civicrm/bower_components/select2/select2.min.js

It is literally this article from the old forums but I cannot seeem to find any solutions at all Please help! Its Christmas!!!

forum.civicrm.org/index.php?topic=36343.0

issues.civicrm.org is down right now - but I see this issue: CRM-12570 "Javascript error when mootools is loaded in Joomla backend".  I'll also note that everyone reporting this problem is using Joomla.  So my guess is that there's a Joomla plugin that's causing a jQuery conflict or similar.

To troubleshoot this, I would:

Disable all your other Joomla plugins.  I hope you're doing your upgrade on a dev server before doing it on a live server!  If disabling all of them solves the problem, start turning them back on until you can identify which one has the conflict.
Check your Net tab in your browser's developer tools when loading a page on your site vs. on the demo Joomla site.  Are there any errors, or unusual JavaScript files on your live site compared to the demo?  If so, identify their source.


CiviRules and bulk email events I'm interested in creating workflow based on bulk email opens and click throughs.  Is this possible with CiviRules?  If no, is support for these events planned?

Yes and no!

Yes, this would certainly be possible within the framework which CiviRules is build on.

No, currently this specific event has not been developed. Conceptually this doesn't seem to be too difficult event to create. You or your developer can try to do it yourself using the new cookbook on CiviRules, or consider funding this work to be done by the first creators of the extension.


Change civicrm combobox value from the code I want to know how to change the value of those awesome civicrm comboboxes from the code (i have google address search, I need to change the country), see the screenshot.
jQuery("#country-1").val(val); document.getElementById('country-1').value = val; don't work

The widget is select2 3.5. But you don't need to interact with it directly. Find a selector for the underlying <select> element in the dom, set it's value, and then fire the change event. E.g.

CRM.$(function($) {
  $("#country-1").val(val).change()
});

Note that you should use CiviCRM's copy of jQuery and not the WP copy. So the above code uses CRM.$ instead of jQuery. Using the wrong copy of jQuery would make things weird as change events would appear to have no effect, etc.


Clean URLs don't work after install in Backdrop I'm intalling civicrm on backdrop cms. Setup returns that installation was succesful.
I see the link in the admin bar, but when clicked, the link gives me 404 error.
If I add "?q=", links works, the page display, but any other link doesn't work.
Clean urls works fine on the site.
I'm performing a migration from Drupal 7, were civicrm was updated and functioning.
System:
Backdrop 1.18.0
MySQL Database MySQL, MariaDB, or equivalent version 5.5.5-10.3.27-MariaDB-0+deb10u1
php Version: 7.3.19-1~deb10u1 (PHP information)
Servidor web Apache/2.4.38 (Debian)
Civicrm 5.33.1
I would appreciate any advice.
Andrés

If Clean URLs are working in Backdrop, but not in Civi under Backdrop, then the problem is almost certainly in civicrm.settings.php.  My Backdrop/Civi sites (and also Drupal 7/Civi sites) have this snippet of code in civicrm.settings.php:
if (!defined('CIVICRM_CLEANURL')) {
  if ( function_exists('variable_get') && variable_get('clean_url', '0') != '0') {
    define('CIVICRM_CLEANURL', 1 );
  }
  else {
    define('CIVICRM_CLEANURL', 0);
  }
}

I suspect you're either missing this code, or perhaps there's something wrong with your "clean_url" variable in Backdrop.
Try replacing that with just this and let us know if it solves the problem?
define('CIVICRM_CLEANURL', 1 );


How to trigger JQuery event when drop down select list is changed in CiviCRM? My JavaScript is triggered correctly, but I cannot attach to the change event for a drop down list in CiviCRM.

The ID of the actual select element is "custom_385_14".

I am trying to attach an event to a drop down list in CiviCRM, which populates the "Subject" field of an Activity with the value from the drop down list.

The actual input element doesn't seem to trigger the change event when the list value is changed. I've tried the following:-

$("#custom_385_14").change(function() {
            alert('test!');
           $("#subject").val($("#custom_385_14").val());
        });

******* UPDATE *********
So thanks to Jon G pointing out Chosen isn't the library used, but Select2. According to their docs: https://select2.org/programmatic-control/events#listening-for-events I should use the following:-

  $('#custom_385_14').on('select2:select', function (e) {
      alert('changed!');
  });

However this is still not triggering the event.

I have searched the developer docs for civi and couldn't find an example of this, just a link to the Select2 docs here: https://docs.civicrm.org/dev/en/latest/framework/quickform/entityref/#select2

HTML Source below for the  containing the select list:-

   standard   tutorial type<input class="select2-focusser select2-offscreen" type="text" aria-haspopup="true" role="button" aria-labelledby="select2-chosen-9" id="s2id_autogen9">
<select class="crm-select2 crm-form-select" data-crm-custom="Tutorial_fee_details:tutorial_type" data-api-entity="Activity" data-api-field="custom_385" data-option-edit-path="civicrm/admin/options/tutorial_type_20180704095928" name="custom_385_14" id="custom_385_14" tabindex="-1" title="tutorial type" style="display: none;">
    <option value="">- none -</option>
    <option value="1" selected="selected">introduction</option>
    <option value="2">standard</option>
    <option value="3">portfolio review</option>
</select>

How can I use Jquery code to watch for when the values change in CiviCRM drop down lists?

You cannot always predict the id or name for custom field for an activity, it is either custom_385_14(incase of saved custom field for activity where 14 is id from custom value table) or custom_385_-1 incase of new one.

I always follow below snippet to work incase of custom field and it does call my change event when i change option from select dropdown. I believe you choosed wrong id to actually call change event.

CRM.$(function($) {
  $("div#customData select[data-api-field='custom_385']").change(function() {
    $("#subject").val($(this).val());
  });
});

Or

  Try after installing the extension
  https://github.com/pradpnayak/org.civicrm.jsoncaseactivity . I have
  added the JS in
  https://github.com/pradpnayak/org.civicrm.jsoncaseactivity/blob/master/templates/CRM/Case/Form/Activity.extra.tpl

HTH

Pradeep


DB Error: no such field On Event Registration We are getting a DB Error: no such field error when registering for a paid event. Here is the debug info which indicated a problem with an unknown column in the contributions table I think. I have looked and that field is in the table. We are using CiviCRM 4.7.30 on Joomla 3.8.7

Database Error Code: Unknown column 'invoice_number' in 'field list', 1054
Additional Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_instrument_id , receive_date , total_amount , fee_amount , net_amount , invoice_id , currency , source , amount_level , is_test , is_pay_later , contribution_status_id , check_number , tax_amount ) VALUES ( 17049 ,  6 ,  1 ,  20180501090413 ,  50 ,  0 ,  50 , '5e4ba6329f63217b6b65a068eafabfe1' , 'USD' , 'Online Event Registration: Childrens Camp (1st - 7th Grades) 2018 Counselor and Staff Application' , 'Application Fee - 1' ,  0 ,  0 ,  2 ,  NULL ,  0 )  [nativecode=1054 ** Unknown column 'invoice_number' in 'field list']
[type] => DB_Error
[user_info] => INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_instrument_id , receive_date , total_amount , fee_amount , net_amount , invoice_id , currency , source , amount_level , is_test , is_pay_later , contribution_status_id , check_number , tax_amount ) VALUES ( 17049 ,  6 ,  1 ,  20180501090413 ,  50 ,  0 ,  50 , '5e4ba6329f63217b6b65a068eafabfe1' , 'USD' , 'Online Event Registration: Childrens Camp (1st - 7th Grades) 2018 Counselor and Staff Application' , 'Application Fee - 1' ,  0 ,  0 ,  2 ,  NULL ,  0 )  [nativecode=1054 ** Unknown column 'invoice_number' in 'field list']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_contribution (contact_id , financial_type_id , payment_instrument_id , receive_date , total_amount , fee_amount , net_amount , invoice_id , currency , source , amount_level , is_test , is_pay_later , contribution_status_id , check_number , tax_amount ) VALUES ( 17049 ,  6 ,  1 ,  20180501090413 ,  50 ,  0 ,  50 , '5e4ba6329f63217b6b65a068eafabfe1' , 'USD' , 'Online Event Registration: Childrens Camp (1st - 7th Grades) 2018 Counselor and Staff Application' , 'Application Fee - 1' ,  0 ,  0 ,  2 ,  NULL ,  0 )  [nativecode=1054 ** Unknown column 'invoice_number' in 'field list']"]

)

This is because of a missing field in the contribution log table. See the following question and answer for next steps:
How can I deal with a missing or corrupt binary ("advanced") log table?

So if you don't care about existing logs, you should just be able to turn logging off then back on, otherwise that post gives some more advice.

For either step, I'd suggest backing up your database first just in case something gets more corrupted.


Status page angular load error I've just upgraded a test site from 4.7.15 to 4.7.21 on Drupal before going live. The System Status page isn't showing as expected and the console has this log:

GET failed for
..../sites/mysite/files/civicrm/persist/contribute/dyn/angular-modules.33b51763aa1098ba_etc_etc.js

This file doesn't exist.  Note the Drupal site is not in sites/default/ but I have set the Civi Resource URLs correctly (hopefully) and cleared the Drupal and Civi caches. Any suggestions?

I've previously (and now) done some messy tweaking of $filesURL in CRM_Utils_System_Base to cope with not being in "default".

TIA Chris

We had one site that had 'lost' all it angular pages, eg CiviMail and System Status.

In our case the angular cache files were returning 404 on the New Mailing page. (and 'inspector' was showing a lot of red angular errors)

It was building the cache files in sites/default/files/civicrm/images, but then searching for them in sites/default/files/civicrm/persist/contribute

The issue here was a mismatch between the resource url setting for Image Upload URL and the directory setting for Image Directory. Strangely (!!) these folders are being used for caching of angular files.


Newsletter signup - add straight to group Hello and excuse me I am having a moment. I usually use HTML snippets (profiles) for newsletter sign up forms but have used webform on this occasion as I read you can't add recaptcha to a snippet.

However now I realise having set up the form and themed it that it doesn't automatically add to a civi group.

Can I add contacts directly to a civi group from a webform sign up form?

Thanks it's probably obvious but I can't see it.

Yes, it is possible to add contacts directly to a group in civicrm using the civi webform integration module, see documentation here https://www.drupal.org/node/1615380 and scroll to the section on Groups and Tags

select civicrm on the webforms tab, and scroll to the section that says Groups and Tags


Can I show a profile on contact summary page I would like to show membership details on the contact summary screen - type, status, start date - using the contact layout editor. I can create a profile for membership, but this isn't available to add, and membership fields can't be added to a block, it seems.  As you can have multiple memberships for a contact I can see why it might be tricky. Is it possible to show membership info on the summary screen using the UI?

If you install the Extended Reports extension (available from in-app download), you can place Extended Reports as a block using Contact Layout Editor.
See the screenshot below - I'm using the "Extended Report - Membership Price Set Report" template to generate this report.  Under the report's Display Options tab, I clicked Make available for contact summary page.


Page Load Slow Due to JS Issues I am using CiviCRM 4.7.3 on Joomla 3.4.8. I have noticed when going to the user dashboard that it is taking 30-45 secs to load that page. All other pages are loading in less than 3 secs. To explore the issue, I used Firefox with FireBug to see the Net loading. I found that nearly 50 items are listed as shown in the picture. These items only show when going to a CiviCRM related page.  Any help would be most appreciated. Thanks!

I found the solution. I needed to manually set the URL Resources paths. Although it had the variable set during setup, it was not the absolute path.


Using profile for people to submit activities How can I create a data entry profile that creates an activity?

Example: We train peer leaders, who then meet with mentees. We'd like them to submit their meeting information (e.g. duration, # of attendees, brief description) as an activity (e.g. type = 'peer leader meetings with mentees') that would be associated with the peer leader contact.

Similarly, we'd like to have activity types 'gave informational talk', 'served on a panel', 'participated in outreach event', etc.

The reason I'm asking about doing it as a profile is that we wouldn't want them to be able to view contact participation history, etc.- just to complete and submit the activity.

Or is there a different method you'd recommend to do this? Thanks!

If you are using Drupal then you can use webform and webform civicrm module. This modules allows to create front end forms using Civi fields and also provide ability to perform actions  when form is submitted like creating activity, relationships, contribution etc.

For wordpress you can use caldera and civicrm caldera plugins which is similar to drupal webform.

Thanks

Pradeep


Rule to create a Linked Drupal user account for a specific CiviCRM Contact Subtype I’m using Drupal 7.56, the Rules module 7.x-2.11 and CiviCRM 4.6.31.

I'm trying to create a Drupal Rule that checks the subtype of contact to create a Linked Drupal User Account just for a specific subtype of CiviCRM contacts when they submit a Membership Signup form.

I need to trigger that rule when a "CiviCRM Membership has been created", as Drupal needs an email to create the user account. If I include the Event "CiviCRM contact has been created" instead of "CiviCRM Membership has been created" to trigger the rule evaluation, the email for the contact is not available yet on the database, as e-mail address is an independent entity in CiviCRM and created after the contact has been created, so the rule fails when trying to create the Drupal user account.

The condition "CiviCRM Contact is of subtype" only works if I make the CiviCRM contact available from the "CiviCRM contact has been created" Event. So when I have the Event "CiviCRM Membership has been created", required for my rule to work, the CiviCRM Contact accessible from this Entity/Event (CiviCRM Membership) doesn't work with the condition "CiviCRM Contact is of subtype", as the Contact Subtype is an Array:

... (Array, 1 element)

 0 (String, 6 characters) Parent

Is there any way to make CiviCRM Contact Entity accessible from two different Events that trigger the rule evaluation, as "CiviCRM Membership has been created" and "CiviCRM contact has been created", so that the condition "CiviCRM Contact is of subtype" can have the appropriate CiviCRM contact parameter?

Or if it's not possible, how can I access the Array variable? I know I have to use the Rules Condition List contains item, but I'm not able to make "Contact Subtype" Array variable available to evaluate the Condition.

Any help will be very much appreciated.

I'm assuming you are also using the CiviCRM Entity module?

For it to work on membership create, you need to load the contact entity from the membership->contact_id property.

Use the "Fetch entity by id" action.

Because of this, you may need the Rules Conditional module, which let's you put conditionals in the "actions" portion of the Rule.

There you can add an "If" conditional action, and the "CiviCRM Contact is of subtype" condition provided by CiviCRM Entity should work for you there.


Webforms vs Contribution pages - workflow On a clients site, we are using several contribution pages, and some of them are duplicated in webforms. I have a hard time deciding when to use what. I prefer the webforms, but I always end up configuring everything twice. What is the intended workflow ?

For a contribution, a contribution page is needed. But for a dozen similar contributions, I can use webforms pointing to the same contribution page, and configure the payment amounts there. However, since I can't 'hide' the civicrm page from the web, I do need to configure the amounts there, too. I always end up puzzling on how to sync these amounts from the contribution page to the webpage (pricesets - matrix - confusion).

On contribution pages, I can include 'profiles' to get additional information. On the webforms, I can just include the wanted fields from the contacts. since I can't 'hide' the civicrm page from the web, I would have to do both.

Install the redirect module and make the contribution page URL redirect to the webform.


How do i enable click tracking in UI I am using SparkPost for mail delivery of CiviCRM mass mailing.  SparkPost analytics show targeted and bounced emails etc but shows zero for clicks and opens.  How can i enable tracking of clicks and opens?

Go to your sparkpost account(https://app.sparkpost.com) and click on 'Account' and then 'SMTP RELAY' and click on radio button 'Enable Tracking'. This will make sure tracking of clicks and opens.


SMS Message text is incorrect I am using the Twilio extension to send SMS Messages from within CiviCRM. The text above the textbox states 'You can insert up to 460 characters'. This is incorrect and should read 'You can insert up to 160 characters'. I am not sure where to change the text. If someone could point me in the right direction I would be most grateful.

Maximum SMS length is defined by the MAX_SMS_CHAR constant in

../sites/all/modules/civicrm/CRM/SMS/Provider.php.


CiviCRM 5.2.2 System Status gives Incorrect Resource URL (Drupal 7.5) CiviCRM 5.2.2 (drupal 7.59, ubuntu 16.04.01, mysql 5.7.22, php 7.0.30)
  CiviCRM System Status gives:
Incorrect Resource URL
The Resource URL is not set correctly. Please set the CiviCRM Resource URL.
Cause: In sites/all/modules/civicrm/CRM/Utils/Check/Component/Env.php
$arrowUrl = CRM_Core_Config::singleton()->userFrameworkResourceURL . 'packages/jquery/css/images/arrow.png';
$headers = get_headers($arrowUrl);
is returning an empty array.
sites/all/modules/civicrm/packages/jquery/css/images/arrow.png exists
Site seems to be working Ok otherwise.
Thanks for your help.

Go to Administer > System Settings > Resource URLs and check that the first one 'CiviCRM Resource URL' is set - usually [civicrm.root]/

It's worth checking Administer > System Settings > Directories at the same time.


Split Data from Wordpress Database On my initial setup, I had installed CiviCRM onto the same database as the Wordpress installation.
Now I want to split this as I am migrating the website and would rather backup and have a copy of the CiviCRM installation on its own.
Does anyone have any advice on how this could be accomplished?
Can I just backup the existing DB and restore to a new instance and it would all just work?

That's really two operations: splitting the combined db to separate WP and Civi ones, and migrating.  For the migration part see the manual.

To split the db, you could make a duplicate of the original as the Civi db (dump and load), then in the Civi one delete all the non-civi tables and in the original/WP one, delete all the civi tables.  In your civicrm.settings.php file find the setting for CIVICRM_DSN and change it to use the new database name.

Make sure you keep a backup of your original combined db just in case!


Why can't I delete an event? We have an event that will not delete. When trying to delete, the system gives:

"This event cannot be deleted because there are participant records linked to it. If you want to delete this event, you must first find the participants linked to this event and delete them. You can use use CiviEvent >> Find Participants page ."

There are no participants registered for this event. This happens every so often.

Perhaps you have is_test participants?

Events -> Find Participants
Participant is a test? Hit the Yes radio button
Search

If you have any - then select the participants you found - and then in the actions: delete participants.


Display a Block on a specific Civi contribution page using a url alias (How to) Drupal 7.6
Civi 5.4.1
I would like to display a Block on a Civi contribution page but I would also like to have the page have a pretty url rather than the Civi civicrm/contribute/transact?reset=1&id=8
Here I found help to add the block as long as I have the native Civi url. Any ideas on how I can display the block with a url alias in place?

One option is to use the solution you linked to above and then set up a friendlier redirect that forwards them to the correct internal page URL. (So you could use something like example.org/donate and when they click on it the Redirect would send them to example.org/civicrm/contribute/transact?reset=1&id=8) The end result is still the default URL, but you could use the friendlier redirect in emails, campaign materials, etc.

Or, set up a webform (using Webform-CiviCRM) that takes payment/contribution. Then you can set up your own URL as usual (but can't use the default contribution form payment profiles, etc. -- you'd have to set the needed fields up in the webform).


migrating civi database from current hosting to civihosting.com We recently signed up for shared hosting at civihosting.com and want to move our current site there. Both sites are running CiviCRM 4.7.29 and WordPress 4.9.1.

I cannot get into the CiviCRM dashboard on the current site (the biggest reason we're moving to civihosting !), but do have access to the MySQL database.

For the WordPress migration, we have been using the export/import tool in WordPress successfully, so that doesn't seem to be a problem.

Can I simply export the CiviCRM database from the current hosting provider and import it into civihosting? I understand I should drop the current database at civihosting first? As far as I know, I won't be losing anything important (I haven't done much yet in CiviCRM at civihosting).

Also, does anyone know of step-by-step instructions somewhere for doing this?

I'm comfortable with phpMyAdmin, if that comes into the picture.

Thank you!

Steps that i usually follow to migrate CiviCRM from one server to another

Export DB from current site.
Compress files structure of civicrm i.e /wp-content/plugins/files/civicrm or /wp-content/uploads/civicrm
Drop and create the database on CiviHosting.
Import db from #1.
Replace /wp-content/plugins/files/civicrm or /wp-content/uploads/civicrm from #2.
Re-Check civicrm.settings.php.
Log out from wordpress and log in.
Rebuild Menu and Trigger

http://example.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/menu/rebuild&reset=1&triggerRebuild=1
Check and Update path in Administer >> System Settings >> Directories.
Check and Update path in Administer >> System Settings >> Resource URL.
Check and Update path in Administer >> System Settings >> Cleanup and Cache


Search on custom 'Yes or No' fields appears broken in 4.6.6 I've just updated our dev civicrm installation from 4.5.4 to 4.6.6.
Now, searches on custom fields of type 'Yes or No' are producing weird results.

Eg, In a custom dataset for some specific membership types we have a variety of Yes or No fields.
The database appears to have the correct data in it as compared between our updated dev and our live sites.

However, in the dev site, a search of memberships for 'display on website' produces 93 results for Yes, 93 for No and 93 for 'Yes or No'!! There are 861 results in the db according to phpMyAdmin!!! Yikes!

On the live site, the same search yields 892 for Yes, 91 for No and 983 for 'Yes or No'. There are 901 results in the db table according to phpMYAdmin. (The diff here could be some contacts are deleted, also we don't expect the dev site and live to be exactly the same.)

I've done the same membership search on a variety of custom boolean fields and they all show the same very weird results on the dev site; the same number for yes, for no and for 'yes or no'. In the db the field has many, many more results than the membership search.

Any help on this would be much appreciated!

I have replicated this on another site on 4.6.6 & logged https://issues.civicrm.org/jira/browse/CRM-17006


Placeholders instead of labels in contribution forms I created a Contribution page using Drupal webforms. For esthetics, I am only using placeholders and no field labels. I'd like to do the same for the Credit Card fields that are pulled in from Civi. Is there a simple way to use the field names as placeholders rather than field labels?

Ah - no there is not - those fields are grabbed from CiviCRM - as is :-(

So you can't edit them via the Webform tab; If I was heading this way I'd look at a drupal hook_form_alter


Are there any CiviCRM loyalty/rewards extensions available? Has CiviCRM been extended to support a loyalty/rewards program for donors?
I searched the CiviCRM forum and found this question has been asked before, but there has been no response from the community.

This may not be exactly what you were after, but CiviCRM does have the ability to add "premiums" to contribution pages as a reward to donors. For example, "Donate $20 and get a coffee mug".

From the book:

  Premiums

  Configure premiums, such as T-shirts or subscriptions, that you want to offer on your contribution pages:

  1) Navigate to Administer > CiviContribute > Premiums (Thank-You Gifts).

  2) You can edit an existing premium or click Add Premium to add a new one.

  3) Once you edit or add a premium, you can then enter additional information: Name, Description, SKU (an optional product code), Premium Image (an optional image of the item), Minimum Contribution Amount to receive the premium, Market Value of the premium, Actual Cost, and Options (e.g., colors and sizes).

  4) If you're offering a subscription or service, you can also click on the Subscription or Service Settings and define additional information here, such as Period type (e.g., Fixed or Rolling), the Fixed Period Start Day, the Duration, and the Frequency.


Fatal Error after upgrading to 4.7.13 from 4.7.11 Just upgraded Civi from 4.7.11 to 4.7.13

The upgraded installed successfully, but rendered Civi functionally unusuable. Attempting to click on any tab within Civi (such as navigating to Contributions, Mailing, Memberships, etc.) results in the following fatal error in the web browser.

Any assistance is appreciated! Thank you!

Fatal error: require_once(): Failed opening required 'CRM/Core/Payment/EPayUCM.php'
(include_path='/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm/drupal/modules/civicrm_engage/:
/home/WEBSITE/public_html/drupal/sites/default/files/civicrm/extensions/uk.co.vedaconsulting.gotowebinar/:
/home/WEBSITE/public_html/drupal/sites/default/files/civicrm/extensions/org.civicrm.module.cividiscount-2.5/:
/home/WEBSITE/public_html/drupal/sites/default/files/civicrm/extensions/civicrm_stripe-4.5-dev/packages/:
/home/WEBSITE/public_html/drupal/sites/default/files/civicrm/extensions/civicrm_stripe-4.5-dev/:
.:
/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm:
/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm/packages:
.:
/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm:
/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm/packages:
/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm/vendor/tecnickcom:
/home/WEBSITE/public_html/drupal/sites/all/modules/civicrm/vendor/phpseclib/phpseclib/
 in /home/WEBSITE/public_html/drupal/sites/all/modules/civicrm/Civi/Payment/System.php on line 59

This error is saying, "Hi, there's a missing payment processor file."  The payment processor file in question isn't part of core CiviCRM; it's probably provided by a plugin.  Is this site associated with UC Merced?  It seems like maybe there's a custom payment processor plugin written for their e-pay system.

Since this broke on an upgrade, I wonder if it wasn't a plugin, but they inserted the file directly into core CiviCRM?  It's hard to troubleshoot without seeing it.  For now, check Administer menu > System Settings > Payment Processors and disable your payment processor to see if that gets your system working.  Then track down whomever wrote this custom code for you.


Using CiviRules to send email when setting up a Direct Debit We noticed there was a delay of about 6 days when a new member signs up using GoCardless before their membership is current and they receive the usual 'Thank you' email so we've only set up a Rule to send an email to let them know that there will be a delay while the Direct Debit is set up

So currently, it's based on:

When membership is added
And membership status is pending
Contact has recurring payments

However, we have existing members who are just now taking advantage of the Direct Debits function and their membership is not 'added' and their status is still 'current' if they're renewing before the end date.

Is there a way that I can trigger an email for these people?

The only thing possibly to include would be the contribution status (Pending incomplete transaction) but this is still likely to pick up incorrect people since it's used for a variety of scenarios.

If your existing members are getting a new recurring contribution you could potentially check for a new recurring contribution instead of a new membership? I think that would solve the issue.

If you try and it does not you might try something like:

a first rule to check for relevant new memberships and add them to a group
a second rule that adds them to a group when the contact gets a new recurring contribution AND is not already member of the group
send the email when a contact is added to the group (and potentially remove them from the group if you think that would make sense).


Custom permission through UI Is there any extension that allow user to create permission through UI so that they can be used for defining permission for menu items or reports or form(eg form builder extension)

Pushed Custom permission extension, where you can create your own permission through UI by navigating to CiviCRM >> Administrator >> Customize Data and Screens >> Custom Permissions


How to remove an activity from a case or file an activity on several cases I have an Email activity that I sent to several contacts.  Each of those contacts has an active case open.  My intention was to file that email on each contact's case so that I see it when I review the case history.  When I open the email activity, I see one email with 7 recipients.

After filing the e-mail on the first contact's case, it has disappeared from the activity view of all the other contacts.

My first inclination was to try to "un-file" it from the first contact's case.  But I don't see an un-file button when looking at the case.

So...questions:

Is it possible to un-file an activity from a case?  How?
Is it possible to file the same activity record against multiple cases?

Thank you!

You USED to be able to do this but the system was changed a little over a year ago so that it now removes the original from the non-case side - see Items not showing up on activity log.

There is the copy-to-case action for most activities on a case but it's not available for Emails/Inbound Emails. The reason might be that historically the "spirit" of CiviCase was to prevent something that might be challenged legally, i.e. if someone sends you an email it shouldn't be altered, to preserve the record, and that got applied broadly since internally it's similar code to other actions. You could try temporarily removing this line in CRM/Case/BAO/Case.php and see what breaks: https://github.com/civicrm/civicrm-core/blob/5.18.3/CRM/Case/BAO/Case.php#L2621. You might also need to grant the "edit inbound email basic information" permission in your CMS's permissions to see the action link if you aren't the admin user, but I don't think it's needed.

If you're comfortable with editing the database directly, find the internal activity id (hover over the view link on manage case and it's the number after the aid=), and then you can do DELETE FROM civicrm_case_activity WHERE case_id=1 AND activity_id=2, where you replace 1 and 2 with the actual case_id and activity_id. That should unfile it.


Implementations Basics (Costs, Timescales, etc) We're looking for indicative figures with regards to migrating across an Access Database to CiviCRM. Early stages (but we need to migrate soon as our Access config is grinding to a halt) so any ideas of the likely costs, timescales, other resource requirements, etc would be very much appreciated.

Kind regards,

Greg

Honestly without a significant amount of detail regarding your current database, how you're going to use CiviCRM, what kind of site it is being connected to, etc, no one can give you anything but a huge range - I've seen it done for as cheap as $3,000 and as high as $30,000.

Some things to consider:

How clean is your data? Is there going to be a significant amount of data cleaning needing to be done by the person who works on your Civi install? I've done some where folks did not follow any sort of best practices with their data and you had state abbreviations mixed with state names, email addresses in phone fields, etc.

What is your list of fields needed? If a field is something other than a textfield, what are the options? Is it a single choice or multiple choice? Is it required?

What are you going to use CiviCRM for? What are you going to be doing with it? Membership? Donations? Paid events? Free event? Etc. You need a good list of how you as an organization plan to interact with Civi.

How is the public going to interact with it? What actions will they be able to take?

What kind of site is it going to be attached to (Drupal, Wordpress, etc)? Is it built already or will the developer need to do that as well?

Look - do you have an idea how you want your public facing Civi pages to look?

Your timescale is really going to depend on what all needs to be done, how responsive you guys can be regarding feedback, and the like.

Resources - obviously your database. There would need to be a development area to work on that isn't your live site. Most developers have their own if you don't have one available. That will allow the site to be worked on and developed, but blocked from view from the public. I've only ever used a Linux server for Civi setups. And they can quickly use up a lot of space because of the size of the database as well as a good amount of memory. As such, regular shared hosting is not recommended. There are hosts, though, who have configured a dedicated server specifically for Civi and then divide it into "shared" hosting. That gives you more resources than the typical shared hosting account.

Hopefully this at least gives you some idea of what to consider and look for. Please let me know if you have any questions. :)


User registration creating duplicate contact in CiviCRM I have a CiviCRM database with lots of contacts some of whom are now going to start creating Drupal accounts.  I'm testing the process and have discovered that when I create Drupal user with an email address matching a Civi contact, it creates duplicate contacts instead of merging.

The Unsupervised Individual Email rule didn't seem to be working and, because it's 'reserved', I couldn't see its settings, so I created my own 'email only' Unsupervised rule with Email set to weight 10 and threshold set to 10.  Still creating duplicate contacts.

The process of creating the user doesn't seem to affect the issue.  That is, I can 'add user' as an admin or create a user as anonymous and Civi reacts the same way.  No deduping.

Any thoughts?

Thanks,
Lewis

That doesn't seem to reflect experience i have had with this. Creating a Drupal User should create a row in UF Match table with the civi contact with that email, and if there are multiple civi contacts with same email i thought it opted for the one with lowest cid.

If you can't figure what is mis-firing (and have a look at your civicrm_uf_match table if you haven't already just to confirm what is in there) there are possible workarounds to try, eg use a webform, confirm that you can ensure that a match on email, or first+last+email is working in that context, and then you can use civicrm_entities and drupal rules to trigger the drupal user creation - old-ish blog here about process


authentication failure [SMTP: STARTTLS failed (code: 220, response: 2.0.0 Start TLS)] authentication failure [SMTP: STARTTLS failed (code: 220, response: 2.0.0 Start TLS)]

Hi

I am getting the above error message when trying to setup my outbound email. I'm using mailgun and have the drupal smtp module setup and working using identical details.

Any ideas where to start troubleshooting this?

Thanks

This question appears to be the same as Outbound mail fails after upgrading to 4.7.1 tl/dr i suspect your probably running on php5.6 or similar version and the ssl certificate for smtp.mailgun.org is not valid or is a CACert or similar and PHP5.6 is saying i can't validate certificate.


Create buttons on action from ResultTasks I´m trying create buttons in ResultTasks.tpl for "show on map" and "export". This actions are in dropdown list with select named "task". I first tried duplicate the select, but it worked only last select, the first select redirect only to print page. Is possible to make separate buttons for these actions?

By "buttons", I assume you mean the buttons referenced in the screenshot below.

It's not recommended to edit the .tpl files directly - it's hard to maintain, and will be overwritten any time you upgrade.  Instead, it's preferable to use an extension with hook_civicrm_links, which allows you to inject your own links.

My Fast Action Links extension also provides a framework for adding links; you can either use it directly if it makes sense, or use it as an example of how to inject links to search results.


How to amend CiviCRM Event URL I have CiviCRM installed on Drupal. I am using CiviEvents, when i click a link to view the event the url is displayed as:

info%3Fid%3D8%26reset%3D1

Is there anyway i can clean this up? Would prefer if i can have it like:

info/id/8 or info?reset=1&id=8

I have installed the module "Query Parameters To URL" for Drupal and have tried setting Path Aliases but no luck...

Any Ideas?

Thanks,

Moe

This is a known issue for a quiet a long time and has been no progress on it. Alternate way of doing this would be to use global text (or use the event title field) and rewrite the output as a link and generate the link as civicrm/event/info?reset=1&id=[id].

HTH

Pradeep


This page requires cookies to be enabled Event registration issues, reports from users make it seem to be with some regularity.

Message mentions cookies but I am having trouble tracking this down, does anyone have any pointers about where to look?

CiviCRM log has following:

    Aug 13 19:48:17  [info] $Fatal Error Details = Array
(
    [message] => We can't load the requested web page. This page requires cookies to be enabled in your browser settings. Please check this setting and enable cookies (if they are not enabled). Then try again. If this error persists, contact the site administrator for assistance.&lt;br /&gt;&lt;br /&gt;Site Administrators: This error may indicate that users are accessing this page using a domain or URL other than the configured Base URL. EXAMPLE: Base URL is http://example.org, but some users are accessing the page via http://www.example.org or a domain alias like http://myotherexample.org.&lt;br /&gt;&lt;br /&gt;Error type: Could not find a valid session key.
    [code] =>
)

Aug 13 19:48:17  [info] $backTrace = #0 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(371): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(833): CRM_Core_Error::fatal("We can't load the requested web page. This page requires cookies to be enable...")
#2 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(853): CRM_Core_Controller->invalidKeyCommon()
#3 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Event/Controller/Registration.php(66): CRM_Core_Controller->invalidKeyRedirect()
#4 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(312): CRM_Event_Controller_Registration->invalidKey()
#5 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(204): CRM_Core_Controller->key("CRM_Event_Controller_Registration", TRUE, FALSE)
#6 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Event/Controller/Registration.php(45): CRM_Core_Controller->__construct("Event Registration", "null")
#7 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(307): CRM_Event_Controller_Registration->__construct("Event Registration", TRUE, "null", NULL, "false")
#8 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:15))
#9 /var/www/html/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#10 /var/www/html/wp-content/plugins/civicrm/civicrm.php(1227): CRM_Core_Invoke::invoke((Array:3))
#11 [internal function](): CiviCRM_For_WordPress->invoke(Object(WP))
#12 /var/www/html/wp-includes/plugin.php(601): call_user_func_array((Array:2), (Array:1))
#13 /var/www/html/wp-includes/class-wp.php(737): do_action_ref_array("wp", (Array:1))
#14 /var/www/html/wp-includes/functions.php(952): WP->main("")
#15 /var/www/html/wp-blog-header.php(16): wp()
#16 /var/www/html/index.php(17): require("/var/www/html/wp-blog-header.php")
#17 {main}

Environment:

.htaccess ssl redirect
RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]

CiviCRM Force SSL true

civicrm.settings.php
define( 'CIVICRM_UF_BASEURL'      , 'https://www.domain.com/' );

Wordpress settings
WordPress Address (URL) https://www.domain.com

Site Address (URL) https://www.domain.com

PHP 5.6.19
CiviCRM 4.7.9
Wordpress 4.5.3
Eway Single Currency
w3 Total Cache Version 0.9.4.1

Suspect this issue is happening when the site is accessed via https://example.com instead of https://www.example.com, or when moving from one domain to another midway through a form submission.

See also this similar SE question. This text is in the error message you've pasted:

  Site Administrators: This error may indicate that users are accessing this page using a domain or URL other than the configured Base URL. EXAMPLE: Base URL is http://example.org, but some users are accessing the page via http://www.example.org or a domain alias like http://myotherexample.org

Make sure both WordPress and CiviCRM have a matching URL configured - CiviCRM in civicrm.settings.php, WordPress in Settings ⇒ General admin page (ref WP Codex: Changing the Site URL). Ideally, make sure that anyone landing on alternate URLs is redirected immediately to the canonical hostname and protocol.

The .htaccess snippet in this question addresses consistent protocol but not hostname.


Renamed Contact type does not show on reports I have changed the built in contact type from Individual to Member. This shows on the contact screen as Member but in the contact reports it still shows Individual.  tried to create a new type but it was "based on" Individual" and I had te same outcome.

Another option, and one that will probably make your life a lot easier, would be to use the CiviCRM word replacements feature and simply get the system to translate 'Individual' into 'Member'. Would save any core changes and word replacements wont affect upgrade paths etc.

As per Erik's comments, I wouldn't change the core type.


Ajax pop-ups are not interactable and sized improperly Before reporting a bug, I just wanted to double check if it's anything obvious or localized.

The mailing preview pop-up and the "add activity" pop-up from the contact page are two examples of broken functionality on our site. They just don't work. The frame does, you can move it around and close it, but actual interactions with the content don't. It's like it's locked or there was a div over it blocking event dispatch.

Eg. that internal scrollbar doesn't work. If I zoom out enough in firefox for the scrollbar to disappear, that doesn't help anything. Can't click or input. I also don't see any problematic elements in the DOM nor are there any javascript errors logged.

Am I the only one with such problems? Is the port of the theme incomplete? I couldn't find any related bug reports. CiviCRM 5.24 on Drupal 8.8.

What theme are you using in drupal 8. Some things look weird in bartik but I haven't noticed this problem. In the meantime, you can go to Administer - Customize - Display Preferences and turn off popups. It's a checkbox near the bottom underneath WYSIWYG editor: "Enable Popup Forms".


Scheduled Reminder are Blank Civi 5.14 on WordPress 5.2.3

A large chunk of our membership scheduled renewal reminders are arriving to the member's inbox completely blank. It is apparently not all of them, as I ran a test membership and I received my reminder email with no problems, but more than 500 of our members have received blank scheduled reminder emails this year and their memberships are now expired as a result to this.
This problem makes no sense to me and I do not know where to look for a solution.
Has anyone else experienced this?  Did you find a solution?

Are you using both the HTML and plain text formats? Some email clients or user preference will pick the plain text version and if you don't have the content there, it will be blank for these people.


How do I use custom fields in Drupal views? [EDIT] Totally editing this question. Custom fields do not work in my Drupal views, at all:

The interface to add the custom field worked just fine. It's only the generated sql thats wrong. Its refering to civicrm_contact.custom_3, but the value is actually stored in a related table called civicrm_value_[PRIVATE_PARTS_HIDDEN]_1.

What could be causing this ? I need a solution pretty urgent :-|

PS. I did map the values in settings.php, and this in general seems to work. One of the entries is 'civicrm_value_[PRIVATE_PARTS_HIDDEN]_1'  => '[MY_CIVIDB_NAME_HERE].',

PPS. The checkbox used to add the field to the list, in the html source, reads

<input type="checkbox" id="edit-name-civicrm-contactcustom-3"
name="name[civicrm_contact.custom_3]"
value="civicrm_contact.custom_3"
class="form-checkbox viewsImplicitFormSubmission-processed">

Saw the same issue here.

We noticed that the field appeared twice in the list of fields. We'd selected it as CiviCRM Contact: My Field - but it also appeared as CiviCRM Custom: My Field.

When we selected it as CiviCRM Custom: My Field, it worked.


Reporting on Premium Fulfillment Membership in our organization currently includes a T-Shirt which is implemented as a "Premium" on the contribution page.  Members must pick up their T-Shirt in person, so I'm looking for a way to report (create a list) on the fulfillment status of all current members.

There is a field for fulfillment date on the Contribution Detail page, but I can't seem to find this as a field in any of the available reports.

Any suggestions would be appreciated.

UPDATE: As of version 4.6.4, the code below is merged into core.  Use the Contribution and Membership Details report.

This was such a good question I decided to dig into the code.

I used grep to search the Reports folder for the word "Premium" - and found that the only report that includes premium info right now is the Contribution and Membership Details report (found in the "Membership Reports" section).  That report shows the Premium and Premium Option, but not the fulfilled date.  However, it's only three lines of code to add if you use this report as your base.

Create a PHP override directory - there's documentation that shows you how - and copy the ContributionDetail.php file into the appropriate place in the folder.  Then find the section that reads:

  'civicrm_contribution_product' => array(
    'dao' => 'CRM_Contribute_DAO_ContributionProduct',
    'fields' => array(
      'product_id' => array(
        'no_display' => TRUE,
      ),
      'product_option' => array(
        'title' => ts('Premium Option'),
      ),
      'contribution_id' => array(
        'no_display' => TRUE,
      ),
    ),
  ),

Change it to read:

  'civicrm_contribution_product' => array(
    'dao' => 'CRM_Contribute_DAO_ContributionProduct',
    'fields' => array(
      'product_id' => array(
        'no_display' => TRUE,
      ),
      'product_option' => array(
        'title' => ts('Premium Option'),
      ),
      'fulfilled_date' => array(
        'title' => ts('Premium Fulfilled Date'),
      ),
      'contribution_id' => array(
        'no_display' => TRUE,
      ),
    ),
  ),


CiviVisualize example graphs and visuals are not showing up I have a question about CiviVisualize. So, I cloned the CiviVisualize repo from github in my C:\wamp64\www\drupal\custom_ext\CiviCRM Extensions Directory and then reran drupal. CiviVisualize comes up but the demo visuals are no where to be found. I'd love some help]1

This is likely a problem in how you have incorrectly set up the extension url in civicrm.

To work, this (and many other) extension need to be able to load additional resources, javascript or images, and you need to configure civicrm to tell which url to use. (under /civicrm/admin/setting/url )

what is the right url to put there depends on where you have put the extensions folder, but on the good news, you will need to adjust your setting ones and it will work for every extension


How do I set access control so I can get Batch entry? It's not showing up Batch Entry is not showing up for us.  I've been told it might be something with access control however, I need help figuring out who I look at access control to turn this feature on.  I do have a version of Civi that has the feature (CiviCRM 4.2.7.) so I know it's available.  Can anyone help me figure this out so I can use the feature for recording donations?  Thank you.

So Civicrm has two main ways to grant or restrict access:

permission: it's more "high level" and it's about granting access to big features, eg to administer events or view anything about financial contributions
Access Control (ACL): it's mostly so a group of user see only a subset of your contacts, for instance the media people only see the journalists

In your case, it's most probably a permission issue, not access control one. Where you set these permissions depends on your CMS, because it's related to the users and their roles.

There is a rather long list of permissions you can grant, including a few about batch (eg. "CiviCRM: create manual batch, Create an accounting batch", check what applies to your case for this user.

If you don't see a change in the menu when you grant extra access, you might need to logout/login so the new rights are taken into account


Event Error - no price set found! In the middle of entering registrants for an event and suddenly:

No active price fields found for this event!

This follows an update to 4.6.3 which has coughed up some DB errors. But up until this morning the event worked fine!

I have already tried flushing the cache to no avail. Any suggestions?

Doh!

The end date for the Price Set was set to today.


Changing the activity dashlet CiviCRM 4.5.6. (trouble updating at this time)
Drupal 7.34

I am just beginning to explore customizing CiviCRM. I have a lot of questions. Any answers to the following question will give me a better foundation upon which to explore my other questions.

On the dashboard, the activity dashlet shows the date but not the time of day.

What php or template file do I change to make the time part show? The time does show when I do a search for activities.

Also, what do I change to make the time the first column in the report?

I have spent hours studying the documentation but failed to make some kind of connection between that information and my needs.

Thanks in advance for any help you can provide.

An excellent question - the Advanced Date Settings don't seem to affect the report.

You can try to make it a type of "timestamp" in civiroot/CRM/Report/Form/Activity.php.  You might also want to build your report in Views. If you choose this approach, you'll want to install the Drupal Views in CiviCRM Dashlets module


CiviContibute View Customization I am using CiviCRM on Joomla. I wanted to know if there is a way to customize how I view the contributions on the admin side (in the back-end). I honestly have no need to see time of donation or premiums (we don't use any right now). Are there any ways to hide these fields to clean up the view?

What you're asking for isn't possible without coding, unfortunately.  It's a major focus of CiviCRM 5.0 to be able to have user-definable forms in this way.

If you're a coder, or you can hire/borrow one, you can use hook_civicrm_searchColumns to change which fields show on the Contributions tab.  There's an example in this blog post.  Finally, I just uploaded an extension I wrote to Github, which replaces the Premium column on the contributions tab with info on soft credits: https://github.com/PalanteJon/coop.palantetech.showsoftcreditsinsummary


CiviEvent with Sub-events and Conference Slots - how to....? I cannot find any good instructions on how to create sub-events.  Basically I want to create a master/parent event that has 1 or 2 sub-events.  I have found a few links about Conference Slots and have spent a day trying to work out how to use hem with no luck - any hints?
Can it only be used with paid events because it is a shopping cart thing?
Does it only work with online registrations?
Can a staff member register a participant manually or does it only work with the online registration page?

Note that I'm using WordPress so the web-forms thing with Drupal is not an option.

thanks!

Creating Parent Event and Sub Event - using conference Slot

Create an Event and consider that as an parent Event - you need to enable  online registration for parent event
create another event consider this as a sub-event - In conference slot link the parent event and also create a slot and add to the slot - you don't need online registration for sub-event
repeat the above step to create one more sub-event

Now you can use event info page from parent event and try to book the event - It should create all the three event against the register contact

Regarding Paid Event

I am not sure about booking an un-paid event - I will give a quick test and will let you know

Regarding Off-line Registration

To my knowledge - Conference Slot works can only be used for online registration screen

I guess this helps!!!


Unable to do a search using tag When doing a contact search using tags from search builder Civi throws DB syntax error, this was working before until Civi upgraded to 5.35.1

Error:
SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name\n
               FROM civicrm_contact contact_a    LEFT JOIN civicrm_entity_tag `civicrm_entity_tag-60788273efd52` ON ( `civicrm_entity_tag-60788273efd52`.entity_id = contact_a.id  AND `civicrm_entity_tag-60788273efd52`.entity_table = &#039;civicrm_contact&#039;)  \n
              WHERE  (  ( `civicrm_entity_tag-60788273efd52`.tag_id IN (  ) )  )  AND ( 1 ) AND (contact_a.is_deleted = 0) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near &#039;) )  )  AND ( 1 ) AND (contact_a.is_deleted = 0)&#039; at line 3]
        &quot;&quot;&quot;

Can you check if the tag you selected is a parent tag and has child tags? If yes than this is a known bug on 5.35.1 when doing a search on parent tag and is logged at https://lab.civicrm.org/dev/core/-/issues/2502 and is fixed as part of 5.38 release.
Solution(one of the below):

Use 'IN' operator instead of '='.
Apply patch from here.
Wait for 5.38.0 release


Missing CKEditor & config button I've looked at several previous posts, but it's not clear to me if they relate to the issue I'm experiencing. Just updated to CiviCRM 5.8.1 on Joomla 3.9.1. Currently the HTML editor is missing on mailings and events, it's just a box with the straight HTML. The error console is giving the error id.split is not a function from the angular.js file.

Also missing is the Configure CKEditor button. When I check the demo, I see it there, but it never shows up on our site when CKEditor is selected. I also tried installing and selecting the TinyMCE plugin as the editor, but again that makes no difference in the edit window. I'm getting this error in the Display Preferences page: Empty string passed to getElementById().

I've cleaned the caches and checked that the Resource URLs are correct. Unsure what to troubleshoot next.

There appears to be a recent bug, possibly introduced in 5.8 though I'm not certain, that affects the CKEditor, namely missing Configure CKEditor button and CKEditor itself won't appear. See this issue: https://lab.civicrm.org/dev/core/issues/594#note_11806

If you are comfortable working in the database directly you can work around this by deleting the existing setting for WYSIWYG editor and then avoid saving Display Preferences until this is resolved.

DELETE FROM civicrm_setting WHERE name = 'editor_id';

This bug is now resolved in CiviCRM 5.9. After installing the 5.9 update save the Display Preferences & CKEditor settings as per the post-install notice.


How do I access drush commands specific to CiviCRM? I have installed CiviCRM 5.31 on Drupal 8 with the following set of commands according to the official Drupal and CiviCRM documentation:
cd /var/www
composer create-project drupal/recommended-project:8.9.8 d8.example.org
cd d8.example.org
composer require drush/drush
vendor/bin/drush site:install
composer config extra.enable-patching true
composer require civicrm/civicrm-asset-plugin:'~1.1'
composer require civicrm/civicrm-{core,packages,drupal-8}:'~5.31'
# now enable CiviCRM module in web UI

Now I want to setup scheduled jobs as outlined in CiviCRM's documentation. Running vendor/bin/drush civicrm-api, however, leads to the following error:
Command "civicrm-api" is not defined.
As of November 2020, cv is untested for Drupal 8, so I would like to use drush. What's the "official" way to do this?

Software versions

PHP 7.3.24
mysql 8.0.22
Composer 2.0.6
Drush Commandline Tool 10.3.5
Drupal 8.9.8
CiviCRM 5.31.0

The readme for cv needs updating. It's now tested pretty well with drupal 8. I would use cv instead.
See also https://lab.civicrm.org/dev/drupal/-/issues/76


Why won't civicrm/greeter load? I'm starting to learn extensions with http://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension . I already need trouble-shooting advice. I can't figure out how to get civicrm/greeter to load. If I try to browse to it, I get the main civicrm page instead. Can anyone help me find the step I've missed.

I found my problem. civicrm/greeter didn't load because I had a typo (extentions as opposed to extensions) in my Extension Resource URL. Once I fixed that, it all fell into place.


How do I recover CiviGrant Component? I disabled, and re-enabled CiviGrant and now I can no longer access it.  I tried to rebuild the menus and actually reproduced this on the demo site: Its not just the Grant and Grant Admin menus.  if i try to use a link I get access denied.  The grant component is working at the API level.
Any suggestions on how to recover the component?

Go into your CMS permissions and check that your role has all the CiviGrant permissions. They are not automatically granted when you enable the component (though it is a little surprising that they would be revoked upon disabling it).

You also might try logging out and then in again.


Event receipts for paid events contains extraneous information Currently using CiviCRM 5.3.2 and drupal 7.60

Receipts for events paid via PayPal have extra information related to contribution.

To reproduce issue:

Add custom fields of your choice for Contributions
Create a paid event and assign PayPal Standard payment processor.
Enable online registration for the event and set Send Confirmation Email to Yes.
Register a participant for the event.
Check the receipt received and see if you get Contribution related custom fields in the email.

Anyone is facing this issue? May be with other payment processor?

After debugging I found that the code which generated the message values for contribution was also getting executed for Events. We just added a condition to check if its Contribution in CRM/Contribute/BAO/Contribution.php.

if ($this->_component == 'contribute') {
      $groupTree = CRM_Core_BAO_CustomGroup::getTree('Contribution', NULL, $this->id);

  $customGroup = array();
  foreach ($groupTree as $key => $group) {
    if ($key === 'info') {
      continue;
    }

    foreach ($group['fields'] as $k => $customField) {
      $groupLabel = $group['title'];
      if (!empty($customField['customValue'])) {
        foreach ($customField['customValue'] as $customFieldValues) {
          $customGroup[$groupLabel][$customField['label']] = CRM_Utils_Array::value('data', $customFieldValues);
        }
      }
    }
  }
  $values['customGroup'] = $customGroup;
}

Do we need to clean up this code? or anyone have any thoughts so we can add issues on Lab and raise PR for same


Where/How does CiviCRM track sent reminder notices? CiviCRM can send reminders for memberships, activities, etc.  I noticed that if I create an activity and send a reminder email (by forcing the scheduled job to run) that the activity won't generate another email even if the parameters (within 0 hours of completion) are still valid.

Where/How does CiviCRM track a sent reminder so it doesn't send another?

Info on sent reminders is stored in civicrm_action_log table.

https://issues.civicrm.org/jira/browse/CRM-15728 may help you understand how it works.


Joomla! log in error on http vs http://www I've got a client with a bizarre Joomla/CiviCRM issue.

When the client is logged in at http://www.site.com, when they perform certain CiviCRM actions, they are redirected to http://site.com, which they are not logged in at. However, when they log in a second time at http://site.com they are able to function normally. However, if they log out at http://site.com, they are still logged in at http://www.site.com

Confused? The kicker is that I updated the CiviCRM baseurl to be http://www.site.com. But even clearing caches hasn't helped that bleed through.

What is happening here?

Is the http://www vs http:// login distinction a Joomla! only one?
Is there anything else I need to do to clear CiviCRM's caches regarding stored http://site.com addresses?
I deleted civicrm_cache session entries, but they seemingly aren't being regenerated. Any ideas why?

Consider picking either www.site.com or site.com as the canonical domain. Then:

Setup an httpd redirect (in Apache or nginx) from one domain to the other domain.
Ensure that the configuration files (e.g. both of Joomla's civicrm.settings.php files) and "Resource URLs" consistently point to the same domain.

(Alternatively, you could dig further into how the URL settings work, but usually, when you consider SEO and marketing consistency, it's higher-value to use the same domain consistently.)


Adding dynamic data in CiviMail angular template I have developed an extension which adds the possibility to add attachments to a message template. When a user select the template in CiviMail the linked attachments are also sent. This is working well.

But now I want to show which attachments are linked to a template when a user selects a template in the CiviMail UI.

In the old way I would add jQuery and an event listener to the drop down with templates and then fetch with Ajax the linked attachments and inject them somewhere in the screen. However CiviMail is now working with Angular and my understanding is that this should be much and much easier in Angular. However I have played around and can't get it working.

My question is how do I use angular to listen for a template change and then inject some data into the angular template?

I've been recently digging into Angularjs, as I'm trying to make some customization, and this is what I figured out after a reading loads of blog posts covering the subject. I'm not an angular expert so I don't know how this affects performance.

The following script is from an extension using hook_civicrm_angularModules and Angular's $provide service in conjunction with the decorator function to intercept a CiviCRM directive and 'decorate' it to add/replace/extend behaviour, more info here.

Demonstration:

// myModule.js
  (function(angular, $, _) {
      // declare your module
      angular.module('myModule', []);

      // Hook into crmMailing module
      angular.module('crmMailing').config(function($provide){
         // intercept crmMailingBlockMailing directive, note the 'Directive' suffix
         $provide.decorator('crmMailingBlockMailingDirective', function($delegate){
              var directive = $delegate[0];

              // Original compile function
              var compile = directive.compile;
              // New compile function
              directive.compile = function(Element, Attrs){
                  var link = compile.apply(this, arguments);
                  // Append your custom directive
                  Element.append('

');
                  return function(scope, elem, attrs){
                      link.apply(this, arguments);
                  };
              };
              return $delegate;
         });
      });

      /*
      * Extending crmMailing
      */

      // Your simple custom directive
      angular.module('crmMailing').directive('crmMyDirective', function(){
         return {templateUrl: CRM.resourceUrls['uk.co.myextension'] + '/ang/directives/crmMyDirective.html',
                controller: 'ExampleCtrl',
         };
      });

      // Your controller
      angular.module('crmMailing').controller('ExampleCtrl', function($scope, crmMsgTemplates){
        $scope.$watchCollection('mailing', function(mailing){
            crmMsgTemplates.get(mailing.msg_template_id)
            .then(function(value){
                 mailing.msg_template_title = value.msg_title;
            });
        });
      });

    })(angular, CRM.$, CRM._);

Custom directive template

Template Id: {{mailing.msg_template_id}} | Template Title: {{mailing.msg_template_title}}

You can pretty much create your own services/factories, directives, etc or change the behavior of existing ones and hook it into the Mailing app.

Hope it helps.


Multi statement queries in Civireport I am building a custom report that, due to its complexity, requires multiple SQL statements including the creation of temporary tables.  I have developed the queries in MySQL workbench and they work as intended.

However, when embedding these statements in the postProcess() function of a subclass of CRM_REPORT_FORM and passing the query to $this->buildRows the query fails with "DB Error: syntax error".  Can anyone point me to an example of a report that uses multiple SQL statements or advise how to properly construct such a report?

If it helps, the rough outline of the SQL I need to handle is as follows:

CREATE TEMPORARY TABLE all_grades AS (SELECT ......

CREATE TEMPORARY TABLE all_grades_copy SELECT * FROM all_grades;

CREATE TEMPORARY TABLE most_recent_sequence SELECT .....

SELECT.....FROM all_grades, INNER JOIN most_recent_sequence ON ....JOIN all_grades_copy ON .... GROUP BY .....

@Dino62 - I dont think you can execute multiple SQL at the same time

But still you can split the SQL in to different task and create a temp table and input all the values which you want to display in the report

Use the below to run the SQL against Database separately

CRM_Core_DAO::executeQuery( $query, $sqlParams );

If the above is not helping then try to use

function alterRow( &$row ) {
    $row['sort_name'] .= ' ( altered )';
}

where you can handle each row individually

I guess this helps !!!


CiviMail opt out language I have the latest version 5.1.1 of civicrm.
A problem that kind of slipped past our organization in the past is that the page for opting out has been always in English.  Mostly people opted out still without a problem, because I guess most Slovaks know enough English to handle that sort of thing, but there would be occasional emails from people asking to unsubscribe that my boss/wife would get complaining about the opt-out process.
I though I had fixed it through setting CiviCRM to follow the Drupal language, which defaulted to Slovak unless I was logged in. Now I realize that just fixed everything but the text of the opt-out page.  So I've just changed default language of civicrm to be only Slovak and never change, and for good measure, set Drupal to just be in Slovak. (I can handle it after 8 years of living in Slovakia and learning the language!).
But still, my testing shows me the page for opt out is always in English:

The link for optout sent was:
https://info.cbreurope.sk/sk/civicrm/mailing/optout?reset=1&jid=somenumber&qid=somenumber&h=somenumber
What am I missing?  BTW, we are using the Mosaico plug in for sending emails. Could that be a problem?  Drush is running the cron jobs.

The Slovak translation of CiviCRM is only 16% complete - so it's not surprising that some pages wouldn't be translated.  This template (templates/CRM/Mailing/Form/Optout.tpl) is correctly configured to be translated, so it seems that this is simply a case of untranslated strings.

If you or someone you know would like to improve the state of the Slovak translation, consider registering for a Transifex account.  You'll have the opportunity to enter translations for various English text, which will automatically be added to the Slovak translation files, which you can then download to your site.  You'll also be helping other Slovak-speaking organizations with your efforts!


Forms generation with CivicRM Profiles under Wordpress When trying to use a profile for form input on a page, one of my profiles is available but the others are not.  Any ideas on what I may be missing?

I'm not sure what you're wanting to do is possible, see a solution here, which is to create one new profile with all the fields: https://forum.civicrm.org/index.php?topic=32718.0

That said - CiviCRM 4.6 with Wordpress has the ability to render multiple profiles, but I'm still not sure if you can have multiple profile forms: https://civicrm.org/blogs/haystack/working-civicrm-46-wordpress


Are others experiencing problems with PayPal We're recently having problems with PayPal payments leaving transactions in a Pending state even though the PayPal payment goes thru.

What version of CiviCRM do you use? In at least two of the latest versions released recently there is some Paypal bugs that has been fixed. You should first of all make sure you have the latest version installed.
You can see it in release notes for:

5.31.1
5.32.0


Report with household, individuals and contributions I am tasked with creating a report on households and the respective members of the households and their contributions.

Can anyone please direct me to any reports that are already available in CiviCRM or an SQL statement that does this?

There is a Contributions by Household report available under Reports > Contribution Reports by default in CiviCRM.  This should provide at least the basics of what you need.  You may need to edit the filter criteria to set "Household Member is" as the Relationship Type rather than "Head of Household is".


What's best practice in terms of handling Gift Aid within CiviCRM I'm just setting up the 3.0 beta Gift aid extension (https://github.com/compucorp/uk.co.compucorp.civicrm.giftaid and https://civicrm.org/extensions/gift-aid-extension-uk), as provided by Compucorp (and for which many thanks) for CiviCRM 4.6.

However I'm a tad confused, because there's also the Gift Aid Online Submission extension from Veda Consulting (https://civicrm.org/extensions/uk-hmrc-online-gift-aid-submission). Studying the available documentation, neither extension appears to reference or make mention in any way of the other. I've a vague memory from CiviCon London a few years back that the online submission extension builds on the Compucorp extension by enabling straightforward submission direct to HMRC, but I'm not clear. Can anyone cast any light?

If I can get some clarity, through my own experience and that of other folks that have gone through this I'll be happy to write it up in a way that might be helpful to other users.

You are correct - the Veda extension is for submitting the Gift Aid application to HMRC and the Compucorp one does the rest. It's a shame this isn't better documented. Be careful of the version of the Compucorp one though, as I don't believe the one of the Civi extensions page works with 4.6 - get a working version from Git here


Not allowed to view the pages after upgrade I have a website where the civicrm plugin stopped working and developed an error. I have since copied the site onto another hosting account I have and have been following these upgrade steps (https://wiki.civicrm.org/confluence/display/CRMDOC/Upgrading+CiviCRM+for+WordPress#UpgradingCiviCRMforWordPress-verify_settings) to upgrade the plugin (as it's been a year and a half anyways). I've gotten to step 4 but when visiting the link it says

  Sorry, you are not allowed to access this page.

I saw in the upgrade steps it mentioned if you have issues to activate the plugin in wp-admin/plugins.php but I've never done it that way. Is there a chance anyone can let me know if "activating" it via plugins.php file may work and how might I do that? If it isn't that (as I didn't deactivate the plugin before upgrade) why my Administrator account wouldn't have access to this page? of the civi crm dashboard in wordpress?

I had tried deactivating all the plugins via the wordpress backend but then I was shut out of my site (os there a way with this plugins.php file to activate them all again or do I have to delete and re-do all the steps again of getting another backup and upgrading civi crm?).

Thanks for your help!

Just had the same problem, but found the answer on this page:

WordPress - Problems trying to go back to CiviCRM 4.7.17 from 4.7.19

I had previously installed CiviCRM but wanted to remove it and start from scratch, but I hadn't deleted the civicrm folder in /wp-content/uploads/


How can I synchronize civimail and my microsoft outlook mail program? As response mails arrive in my "normal" outlook account, I'd like to see them automatically on civicrm in order to have a better overview. Is there a possibility to create a folder in outlook that updates mails in civicrm?

thanks a lot for your help!

One way would be to create a special response email address and then use CiviCRM's email-to-activity functionality to attach them to your CiviCRM contact records. You could also make a folder in your IMAP account and let that folder be imported into CiviCRM.
http://book.civicrm.org/user/advanced-configuration/email-system-configuration/
From the book:

Email-to-Activity processing
CiviCRM can automatically retrieve email from a specified inbox and file it as an email activity against contacts corresponding to sender and recipients of the email. New contacts are created for emails not already in the database.
There are two ways to do this (either or both ways can be setup at same time):

Special email address: Set up a special email address for your organization, e.g. civiemails@example.com. Users can then add this address in the Bcc field for your outbound emails; they will get auto filed in CiviCRM as described above. No one who receives the email will see this special address if the Bcc field is used.

IMAP Folder: Set up a folder in your IMAP Inbox where you can drag emails that you want filed in CiviCRM.Â  This works with both inbound and outbound emails. (this requires that your email be set up using IMAP.)


Civicase activity table default options I would like to change two aspects of the Activities table on the Civicase summary screen.

Change the default number of rows to be shown from 10 -> 100
Also have a filter to automatically hide the actvity 'edit custom data' which is created whenever any custom data relating to the case is updated.  This is especially relevant as i'm using Multiple case clients and this seems to create 3 instances of the activity 'change custom data' (if there are 3 clients) for each single edit of the data.

For number 1,
I've looked into the templates and have so far found the template . /CRM/Case/Page/CaseDetails.tpl is being called.  I think the bit concerned is
{foreach from $rows item row} ,

I've not got to point 2 yet.

Any answers or guidance very much appreciated.

Point 1 is probably not the part, that just reads from the array $rows. I think you have to go to CRM/Case/Form/CaseView.tpl and change the 10 in here to 100:

  oTable = cj('#activities-selector').dataTable({
    "bFilter"    : false,
    "bAutoWidth" : false,
    "aaSorting"  : [],
    "aoColumns"  : columns,
    "bProcessing": true,
    "bJQueryUI": true,
    "asStripClasses" : [ "odd-row", "even-row" ],
    "sPaginationType": "full_numbers",
    "sDom"       : '<"crm-datatable-pager-top"lfp>rt<"crm-datatable-pager-bottom"ip>',
    "bServerSide": true,
    "sAjaxSource": sourceUrl,
    "iDisplayLength": 10,
    "fnDrawCallback": function() { setSelectorClass(); },
    "fnServerData": function ( sSource, aoData, fnCallback ) {

      if ( filterSearch ) {
        var activity_deleted = 0;
        if ( cj("#activity_deleted:checked").val() == 1 ) {
          activity_deleted = 1;
        }
        aoData.push(
          {name:'status_id', value: cj("select#status_id").val()},
          {name:'activity_type_id', value: cj("select#activity_type_filter_id").val()},
          {name:'activity_date_low', value: cj("#activity_date_low").val()},
          {name:'activity_date_high', value: cj("#activity_date_high").val() },
          {name:'activity_deleted', value: activity_deleted }
        );
      }
      cj.ajax( {
        "dataType": 'json',
        "type": "POST",
        "url": sSource,
        "data": aoData,
        "success": fnCallback
      } );

But try! And it is best to modify this in an extension. The same for number two, identify the button and hiding it in a specific template which you add with a combination of buildForm or pageRun hook and CRM_Core_Region like so:

CRM_Core_Region::instance('page-body')->add(array(
    'template' => 'yourtemplate.tpl'


CiviCRM emails not sending with attachments I'm sending post event emails to participants Find Participants> Event Name is> send mail to less than 50). These send fine when just mail body text is included.

When I add an attachment and press submit I get the following error message

I tried the same thing from find contacts- Find Contacts- random search criteria> send to less than 50.

Again, just text works fine, add an attachment and this time I get sent to the advanced search page with this message popping up

Currently Civi 5.19.4 Drup 7.69

Anyone seen anything similar?

Woo-hoo! Just recreated on dmaster.demo

Raised at lab.civicrm.org
https://lab.civicrm.org/dev/core/issues/1604

The attachment size exceeded the site max file upload.

Not a bug in Civi as suspected, but the error message is really unhelpful in this instance.


Is it possible to install CiviCRM offline using WAMP? My company is interested at offline CRM.

I would like to ask.
Can CiviCRM be installed on WAMP server?

Is it easy to customize fields by the needs of company without to be proficient in Programming/Development.

For example my company just wants a database to store their clients/potential clients and each client will have 50 fields of information (name,surname,address etc)

Is this doable with CiviCRM?
Thank you in advance.

So no problem installing it on a WAMP, especially if you "only" want it as an "internal address book".

You have quite a lot of fields by default, and if you need more, you can create custom ones directly from the UI, no need to develop anything for your requirement it seems.

But the easiest is that you try, either on your own install or check our demo sites at http://demo.civicrm.org


CiviCRM Multi-value Custom Data empty My civicrm version 4.6.2.
Drupal version 7.51.
I visited on this URL of the feature to test is /civicrm/import/custom?reset=1
This feature was not working correctly, such that if a custom field set was used for a specific Contact Type "individual".
Here is the screenshot of my custom data screen.

I can't see any custom field in dropdown box. It is fresh installation. How can I get custom data there?

My task is to check import system in civicrm. I have a csv file. I have to import data here through this section just this my task. But here custom data required and I can't see dropdown value here. but I have custom data I checked.

Based on your answer, you don't have any multi-value custom data, which is why the drop-down in question is empty.  To import custom data, please use the normal import screen, found at Contacts menu > Import Contacts.


batch edit organizations I would like to bulk add countries to my organizations via profiles but when adding an organizational field type I can't see the country field, only the official name, SIC code and some custom fields I created. I can only see country at "contact" type  not at "oragnization" tpye.
But bulk editing organizations with this "contact type profile field" doesn't do anything.

You need to add the country field to your profile. Since the country field applies to all Contacts it shows under Contacts.

Make sure you do not have any other conflicting entities in the same profile you are using to batch update orgs.

You should create a profile called 'Batch Update Organization' to be used just to batch update the organization contacts.


Why is there private_html in my [cms.root] directory variable and is it trouble? The Settings - Upload Directories screen (url civicrm/admin/setting/path?reset=1) makes it possible to examine the value of the [cms.root] variable. Just click the first help question mark.

In my case the cms.root path contains the directory private_html. That is a bit strange because I installed CiviCRM in the public_html directory and also added this path to the $civicrm_root variable.

Why is this, and does it harm?

More details: The CiviCRM version is 4.7.27 on Drupal. It runs on a VPS administered with DirectAdmin, and https is enabled.

It starts with a peculiarity of DirectAdmin. Using a subdomain, you have to upload the files for https connection to private_html and the files for not secure http connection to public_html. For the situation these files are the same DirectAdmin offers the option to create a  symbolic link from private_html to public_html. Thus when you ask for https://<domain>/file.html it looks for the file /private_html/file.html and thanks to the link this is the same as public_html/file.html.

The [cms.root] variabele is not set. It is derived from the DRUPAL_ROOT constant, that is calculated with getcwd(). At the moment you use a secure connection this functions returns the private_html directory.

And it causes trouble.

The directory variable  [cms.root] is used to calculate the URL variabele [civicrm.root] so this is also wrong. The effect is that a lot of javascript files are not found, for example ckeditor.js.

My solution is adding the [cms.root] directly to the civicrm.settings.php file with the following line:

$civicrm_paths['cms.root']['path'] = '/home/<user>/domains/<subdomain>/public_html/crm';


What is the proper CiviCRM response when an Authorize.net CC transaction is declined? using WP4.3.1 and Civi 4.6.9.  We got the below message from a member:
  "I renewed online with a credit card but did not get a confirmation of my
  payment. After completing and clicking on ‘make payment’ it took me back
  to the renewal page. If I am confirmed, could you please send me a
  receipt?"

When we checked on our end, it said Transaction Status: Declined (Card
 declined by issuer - Contact card issuer to determine reason.)

We are concerned that the system isn’t letting people know if there
was an issue processing their payment. I was pretty sure that it would
give them some sort of message, but wanted to check.

Usually Civi displays an error message from Authorize, e.g., The card number is invalid.  Perhaps the user missed it?

I assume there are no odd CSS settings in your theme that might be hiding the message.


Multiple CiviHR installation in single Amazon AWS instance I have installed multiple CiviHR on Amazon AWS.

And configured VirtualHost as given below. so I can use the same domain and demo1 and demo 2 as a subdomain of it.

Both CiviHR installation was successful but in domain.com/demo/hr-details I'm not able to see any data that I have added. It displaying blank.

If I click on edit my details button I'm able to see the data I have added.

Highlighted URLs redirecting to root folder of the server (domain.com/dashboard instead of domain.com/demo1/dashboard).

Is this issue with VirtualHost configuration or something else?

It's purely apache/httpd configuration issue. Create 2 subdomain demo1.domain.com and demo2.domain.com and have 2 conf file under sites-available and sites-enabled with following config

demo1.domain.com.conf

<VirtualHost *:80>

  DocumentRoot /var/www/html/demo1

  ServerName demo1.domain.com

  ServerAdmin admin@domain.com

  <Directory "/var/www/html/demo1">

    AllowOverride All

    Require all granted

    Options -Indexes

  </Directory>

  ErrorLog  /var/log/apache2/demo1.domain.com.error.log

  # Possible values include: debug, info, notice, warn, error, crit,

  # alert, emerg.

  LogLevel warn

  CustomLog  /var/log/apache2/demo1.domain.com.access.log  combined

</VirtualHost>

demo2.domain.com.conf

<VirtualHost *:80>

  DocumentRoot /var/www/html/demo2

  ServerName demo2.domain.com

  ServerAdmin admin@domain.com

  <Directory "/var/www/html/demo2">

    AllowOverride All

    Require all granted

    Options -Indexes

  </Directory>

  ErrorLog  /var/log/apache2/demo2.domain.com.error.log

  # Possible values include: debug, info, notice, warn, error, crit,

  # alert, emerg.

  LogLevel warn

  CustomLog  /var/log/apache2/demo2.domain.com.access.log  combined

</VirtualHost>