Drupal webform submission, send email to email address in form I'm using Drupal 7 and CiviCRM 4.7.3. I've built a Drupal webform and I want a user to be able to submit the form and get an email based on one of the options selected on the form. So far that part works fine if I send an email to the logged in Drupal user.

I'm having an issue sending an email to an anonymous user based on the value of the email field within the form. I tried using the following token (in the 'To' field in the Drupal rule):

[submission:values:civicrm_1_contact_1_fieldset_fieldset:civicrm_1_contact_1_email_email]

But that didn't work. I also tried to use PHP evaluation by using:

<?php print $form['submitted']['civicrm_1_contact_1_fieldset_fieldset']['civicrm_1_contact_1_email_email']['value'][0]; ?>

But that didn't work either.

I also added the token in the body of the email and changed the 'To' field to send to the logged in user. That email went through but where the token was in the body of the email was blank, this is telling me I have something wrong with the way my token is set up.

Can anyone offer any suggestions as to what I might be able to do?

I always use the Webform -> E-mails tab for this -> and then I can pick any Component to send an Email - in the example below I want to send an Email to the address that a user typed into the Email field.


I have put an wp specific extension in my extension directory but it does not appear in the manager I have uploaded and extracted the CIVIEVENT WIDGET to www/www/wp-content/uploads/civicrm/ext hit refresh on the CiviCRM Extensions administer page but the extension does not appear.  Is there something else I need to do?

Turns out this a WordPress extension (even though I found it on the CiviCRM extension page) and on about page 3 of the readme.txt it tells you to install it into the WordPress extensions directory.


Can I use a catchall address if my mail host doesn't support VERP? Our hosting provider does not seem to be able to support VERP on Exim. Is it possible to use a catchall address instead of relying on VERP for bounce processing and forwarding replies

Yes, you can use a catchall mailbox to capture VERP bounces, and CiviCRM will be able to identify VERP data from this.

CiviCRM has two return paths if you enable Reply Tracking, and unless you somehow used separate domains, you won't have two catchall mailboxes. So using a catchall will probably limit your functionality somewhat here.

You could potentially get CiviCRM to poll first for bounces, move unrecognised emails to a "holding" folder in IMAP, then poll that folder for replies on a second pass ... But it is probably easier to just switch to a mail service which supports VERP, since such mailboxes are widely available ... you'd likely save some effort.

See also How does Civimail reply tracking and forwarding work?

Exim can support VERP routing, even if your mail provider may not be willing to provide this.


Is there a way to find contacts who have multiple active or expired memberships? Due to some import errors over the past few months, we have some members who are showing with multiple memberships.  Some are of the same type and some are not.  The way our memberships work, no individual should ever have more than one active membership (except in very rare circumstances).

I need a search that will help me find contacts with more than one membership.

If you have sql access you can run this query.

SELECT c.display_name,
       count(*)
FROM   civicrm_contact c
JOIN   civicrm_membership m
ON     c.id = m.contact_id
WHERE  m.contact_id = c.id
GROUP BY 1
HAVING count(*) > 1

If you only want active memberships then add the following line between the where line and the group by line

AND now() between start_date and end_date

You didn't ask for this but if you want people with multiples of the same current membership type then you can use this code:

SELECT c.id,
       c.display_name,
       mt.name,
       count(*)
from   civicrm_contact c,
       civicrm_membership_type mt,
       civicrm_membership m
where  m.contact_id = c.id
and    m.membership_type_id = mt.id
and    now() between m.start_date and m.end_date -- current only
group by 1,2,3
having count(*) > 1
order by 3,1


Duplication of multi records on tab I can't reproduce this on the Joomla demo site running 4.6.0, and I didn't have this problem before.  Now on my 4.6.6 site, if I display custom fields with multi records in a tab, the set of records displays multiple times, along with multiple "Edit multi record" buttons.

If I have one record inserted, it shows once.

If I have two records inserted, they each show twice.  (As in example below.)

If I have six records inserted, they each show six times.

I don't have multiple records if I click "Edit multi record", or in "Tab with table" or "Inline" modes.  Only the data display in "Tab" mode.

Is this a bug introduced sometime between 4.6.0 and 4.6.6?

This has been fixed in 4.6.7. Please upgrade to the latest version or patch your site with this PR.


How can you remove or disable some US states from showing up in profile? How can you remove or disable some states from showing up in profile?
We really only want a few showing up - Latest CiviCRM - not using webform - this is for profiles.

If you want to show only few US states across whole CiviCRM form than you can set civicrm_state_province.is_active = 0 for the ones to not show for country_id = 1228


Drupal Views Field: Relationship Type B-to-A? I'm creating blocks to show a Drupal user's relationships on their user page. I've been able to create the views necessary to show the Display Names of the contacts in both the user's A to B relationships and of B to A relationships.  I'd like to display the name of the relationship as well for each contact. There is a Views Field for Relationship Type A-to-B, but I can't find a Relationship Type B-to-A field. Any ideas? If one does not exist or cannot be created by tweaking something in the Views UI, how would I go about creating the field in code?

Drupal 7.41, CiviCRM 4.6.6, CiviCRM_Entity module 2.x

It is correct that not all fields from the CiviCRM RelationshipType entity are available in the the views by default. The socialistic party in the Netherlands had the same problem. And I created a drupal module for them to fix this.

You can find the module at https://github.com/SPnl/nl.sp.drupal-civicrm-views-enhancement

This module adds the name-a-b, label-a-b, name-b-a, label-b-a, contact-type-a, contact-type-b, contact-sub-type-a, contact-sub-type-b, description, is-reserved, is-active to drupal views.


Rebuilding CiviCRM Database Greetings CiviCRM Community,
I am in need of rebuilding our organization CiviCRM DB. We are getting some odd issues when trying to create activities in CiviCRM. When I traced the error I got the following message below. I'm think we need to rebuild our CiviDB Schema since we have done a few upgrades over the last few months. I wanted to know if there is an updated process for rebuilding the CiviCRM schema. When looking at the documentation on the wiki site it states that this documentation have been archived and the new site does not include the process. Please advise on what we should do.

Additional uncaught exception thrown while handling exception.

Original

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] =&gt; rules_get_cacheevent_watchdog ) in lock_may_be_available() (line 167 of /opt/bitnami/apps/civicrm/htdocs/includes/lock.inc).

Additional

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT ff.* FROM {filter_format} ff WHERE (status = :db_condition_placeholder_0) ORDER BY weight ASC; Array ( [:db_condition_placeholder_0] =&gt; 1 ) in filter_formats() (line 434 of /opt/bitnami/apps/civicrm/htdocs/modules/filter/filter.module).

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ); Array ( [:db_condition_placeholder_0] =&gt; YeiL-YkRM2JyCIzmbtEZQP5wCjxN2hpMFaxcVuAQj88 [:db_condition_placeholder_1] =&gt; ) in _drupal_session_write() (line 209 of /opt/bitnami/apps/civicrm/htdocs/includes/session.inc).

Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] =&gt; 15704801665a2824bfaa38b2.28928446 ) in lock_release_all() (line 269 of /opt/bitnami/apps/civicrm/htdocs/includes/lock.inc).

The missing tables are Drupal tables, and the exceptions are thrown from Drupal modules. So the Drupal database is missing (I do not know if you installed CiviCRM is a separate database). Maybe the connect string in the settings.php file is not correct.


Upgrade From 5.16.2 to 5.20.x Wordpress Can I do a straight through upgrade or do I need to do incremental such as 5.16 to 5.17 then 5.18, 5.19, and finally 5.20? I ask as in pre 4.7 I encountered this as I recall when making a larger version jump.

Thanks!

Demerit was correct in his answer posted as a comment and it worked great! I followed this procedure:

  For that particular jump I would just go straight. But of course as always do it on a copy of the site first or make a backup that you can restore.


Mosaico mailings not sending We've updated our CiviCRM to version 5.2.2 and Mosaico to version 2.0 beta 4 and since then we are not able to send any mailing from CiviCRM.

To be clear we can mail to a person individually. Because we are hosting our website on a VPS I was able to check the email log. I noticed that emails (to one person) are going out correctly, but when I try to send a mailing I get something like this "The sender address  is not a valid 553 5.1.2 RFC-5321 address.". Sometimes the from address is empty.

I'm hosting on a Plesk server 17.5.2 with PHP 7.1.

Is there someone who has idea's for a solution?

EDIT:
Jul  6 11:24:11 srv1 postfix/pickup[15216]: B363D8F4B73: uid=10006 from=
Jul  6 11:24:11 srv1 postfix/cleanup[19523]: B363D8F4B73: message-id=<20180706092411.B363D8F4B73@shost.tld>
Jul  6 11:24:11 srv1 postfix/qmgr[15217]: B363D8F4B73: from=, size=89808, nrcpt=1 (queue active)
Jul  6 11:24:11 srv1 postfix/smtp[19542]: B363D8F4B73: to="", relay=aspmx.l.google.com[2a00:1450:4013:c04::1b]:25, delay=0.09, delays=0.01/0/0.07/0.01, dsn=5.1.2, status=bounced (host aspmx.l.google.com[2a00:1450:4013:c04::1b] said: 553-5.1.2 The sender address  is not a valid 553 5.1.2 RFC-5321 address. u42-v6si5509030edm.404 - gsmtp (in reply to MAIL FROM command))

Based on your comments, I believe I see the issue.

CiviMail requires bounce processing to be enabled to work properly.  The documentation might want to emphasize this point - but your error is actually mentioned in the VERP Support section.

VERP is a standard by which you send each email from a different "From" address - so when a server responds that the recipient address is no good, you know exactly which email triggered the problem.  CiviMail determines the VERP address in part by the bounce processing address.  With no bounce processing address, you get the "invalid sender address" either.  You can solve this by configuring a bounce processing address.

EDIT

logs:

Jul  6 11:24:11 srv1 postfix/pickup[15216]: B363D8F4B73: uid=10006 from=<b.2999.15367.c7a49eeef87f384f@>
Jul  6 11:24:11 srv1 postfix/cleanup[19523]: B363D8F4B73: message-id=<20180706092411.B363D8F4B73@shost.tld>
Jul  6 11:24:11 srv1 postfix/qmgr[15217]: B363D8F4B73: from=<b.2999.15367.c7a49eeef87f384f@>, size=89808, nrcpt=1 (queue active)
Jul  6 11:24:11 srv1 postfix/smtp[19542]: B363D8F4B73: to="<emailaddress>", relay=aspmx.l.google.com[2a00:1450:4013:c04::1b]:25, delay=0.09, delays=0.01/0/0.07/0.01, dsn=5.1.2, status=bounced (host aspmx.l.google.com[2a00:1450:4013:c04::1b] said: 553-5.1.2 The sender address <b.2999.15367.c7a49eeef87f384f@> is not a valid 553 5.1.2 RFC-5321 address. u42-v6si5509030edm.404 - gsmtp (in reply to MAIL FROM command))


Assign a Folder # to a user I'm looking to set up a membership for a concert band. Each member is assigned a folder number (2 digits plus an instrument name such as Flute 2). I'm too new at this to see how to set this up. Could someone please point me in the right direction?
Cheers, DHDa

I'm assuming that you have already imported all your members into Joomla and Civicrm.

It seems to me that you will need at least 2 new custom fields named say 'folder number' and 'instrument name' into which you will make manual entries, and a new dataset (perhaps called 'Membership Information'). The newly created custom fields would then need to be added to either a new or existing profile.

You would be advised to read the custom fields documentation at https://docs.civicrm.org/user/en/stable/organising-your-data/creating-custom-fields/ and profiles at https://docs.civicrm.org/user/en/stable/organising-your-data/profiles/

Hope this helps.


HOWTO create full list of Contacts in ON HOLD status I may be missing something, but I'm trying to exclude (from a contact export list) all contacts that have a "ON HOLD" status for their primary email, particularly if it's an Opt-Out, but Bounce would be useful as well. Using Advanced Find, I could find those contacts who set an Opt-Out on their own by checking Opt-Out in one of our mailings. Also, I can find some of these under Contacts > Contact Reports > Constituent Detail by filtering that report on "Do not bulk email" or "Do not email". However, it does not seem to pick up folks who have requested me personally to opt them out, which I've done manually. Any help for the COMPLETE list of contacts with "On Hold Opt Out" status, whether set by email response or by a CiviCRM admin, would be appreciated.

Actually, the answer lies in the Export, not the filter to create the list. I just added 3 Individual contact columns to the Export: (i) "No Bulk Emails (User Opt Out)", (ii) "Do Not Email", (ii) "On Hold: Primary". It evidently worked. The "Primary-On Hold" column set to 1 with the other two blank grabs the Bounces. The first 2 columns provide Opt-Out and Privacy settings, no matter whether set via email response or manually by admin. Even though the answer was simple, I hope this helps someone else looking to do the same.


Is there a way to enable or install the full version of CKEditor in CiviCRM 4.6.x? So is there a way to enable or install the full version of the free and open source CKEditor in CiviCRM 4.6.x ?

Looks like the CKEditor Standard editor (see http://ckeditor.com/demo#standard ) is installed with Civi (see http://d46.demo.civicrm.org/civicrm/a/#/mailing/37 ), but the "full featured" version ( see http://ckeditor.com/demo#full ) has more useful stuff, particularly aligning and centering text.

I've used the full version on the CKEditor demo site just to center text for a CiviMail mailing. That works, but having the full featured version right in CiviMail would be handy.

The difference between the "full" and "standard" CKEditor is one of plugins.  You can drop additional plugins into the ckeditor plugins folder at: <civicrmroot>/packages/ckeditor/plugins.  Depending on the plugin, you may also need to edit the config at <civicrmroot>/packages/ckeditor/config.js.  Detailed instructions are available here.

I've had perfectly good success simply dropping in the latest version of CKEditor (https://issues.civicrm.org/jira/browse/CRM-16053).

UPDATE: I found that newer versions of CKEditor strip out the "meta" tags from the templates unless you edit config.js.  Also, be sure to clear all caches (including browser caches) or you may find that your CKEditor toolbar button icons are messed up (because of the wrong offset)


Event doesn't display location on info page After creating an event with an address the info page will not display the location nor the map.

If you are experiencing this it is most likely due to an old event template or you copied an older event. More recent versions of CiviCRM have an option on recurring events to display the location. It is on by default but older events were not retroactively set to On.

To fix this you can create a completely new event or in the mysql database on the civicrm_event table set your event to is_show_location = 1.


Setting up rule to link CiviCRM contact (created when webform is submitted) with Drupal 7 account I have configured the rules same as in Setting up rule to link CiviCRM contact with Drupal 7 account it creates a drupal user if contact is created or updated in CiviCRM. But it doesn't get fired if the contact is created in CIviCRM through webform submission. It ends up with an error-"Cannot create user, email: invalid!!".Any help would be really appreciated.Thanks in advance!

You may need to add your rule here. The one by Christia is specifically about "updating a contact record in the CiviCRM" not about creating.

The only way we have made rules work for creation from webform is to add eg a Tag to the contact and then run the trigger off that. You need civicrm_entity.

This is cross-posted from the Drupal SE. Here is an example Rule you may be able to glean things from. It also auto logs in the contact.

{ "rules_self_create_user_account_and_login" : {
    "LABEL" : "Create User Account",
    "PLUGIN" : "reaction rule",
    "OWNER" : "rules",
    "REQUIRES" : [ "civicrm", "rules" ],
    "ON" : { "civicrm_entity_tag_create" : [] },
    "IF" : [
      { "NOT civicrm_entity_user_exists" : { "civicrm_contact" : [ "civicrm-entity-tag:entity-id-contact" ] } },
      { "data_is" : {
          "data" : [ "civicrm-entity-tag:entity-table" ],
          "value" : "civicrm_contact"
        }
      },
      { "data_is" : { "data" : [ "civicrm-entity-tag:tag-id" ], "value" : "525" } }
    ],
    "DO" : [
      { "civicrm_entity_action_create_user" : {
          "USING" : {
            "civicrm_contact" : [ "civicrm-entity-tag:entity-id-contact" ],
            "is_active" : "1",
            "notify" : "1",
            "signin" : "1",
            "username_format" : "email"
          },
          "PROVIDE" : { "civicrm_user" : { "civicrm_user" : "Created Drupal User" } }
        }
      },
      { "redirect" : { "url" : "civicrm\/user?reset=1" } }
    ]
  }
}

You need to Add a new Tag - note the ID of that tag - change the exported Rule to the Tag you created for this purpose. Then also alter your webform so it adds that Tag automatically to the contact upon form submission


finding members without e-mail addresses I'm trying to create a report of members who are expired who have not provided an e-mail address so I can mail them a form.

In search builder I am using "membership status"=expired, contacts->email->is empty and it is not working. Any ideas??

Rather than is empty try using is null in your search.


printing event confirmations I'm in the process of trying to move people from paper to online, but we have to make a gentle transition and know that there are some important members who so not have email. We'd like to make the offline registration process as much like the email process as we can.

If its just one person booking by post and they do have an email, then there is an option to confirm by email and that works nicely.

If they don't have an email then it sensibly doesn't offer the email confirmation option. I can't see any way of sending a confirmation letter that includes the details of the event. If you use a PDF letter then it doesn't have any tokens for the event booking. I looked at using the Name Badges but they can't look like tickets (local politics) and that would mean a fiddle to get it out as one per page and there is no way of getting other text (like joining info) in.

I would also like something that recorded when people book multiple tickets (themselves and others) like with the online bookings but can't see any way to do that. But I will deal with that in a separate question as I have other issues with multiple bookings and there is enough in this one already.

I'm using CiviCRM 4.7.22 and WordPress 4.9

I was going to say, "Do a search for participants (not contacts), then select PDF letter" ... but then I tried it - and there are still no event tokens.

Some work was done to add participant tokens in CRM-16734.  Although the Fix Version is 4.7.15 the related PR (PR-9038) was closed without merging.

So unfortunately I don't have a solution for you but confirming this is a known gap in functionality. It would be great if you can do anything to help progress the issue.


Front End Name List/Search Gives DB Error All of a sudden my front end name listing/search gives a DB Error.  Any ideas on why this would start now??   This is occuring on the public and the registered access search profiles.

Here's what I found in the Log >>

Using Joomla 3.6.2 and CiviCRM 4.7.20, with MySQL 5.6.35

Jun 20 17:18:51  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => SELECT count(id) FROM civicrm_uf_field WHERE uf_group_id =  AND visibility IN ('Public Pages', 'Public Pages and Listings')  [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND visibility IN ('Public Pages', 'Public Pages and Listings')' at line 1]
[type] => DB_Error
[user_info] => SELECT count(id) FROM civicrm_uf_field WHERE uf_group_id =  AND visibility IN ('Public Pages', 'Public Pages and Listings')  [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND visibility IN ('Public Pages', 'Public Pages and Listings')' at line 1]
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT count(id) FROM civicrm_uf_field WHERE uf_group_id =  AND visibility IN ('Public Pages', 'Public Pages and Listings')  [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND visibility IN ('Public Pages', 'Public Pages and Listings')' at line 1]"]

)

Looks like you don't have summary_overlay profile in your civicrm_uf_group table. This is a reserved profile which we cannot delete or disable from UI.

So its possible if the name is edited or the profile is deleted from your db due to some reason. To check-

Open civicrm_uf_group table.
Check for the entry for Summary Overlay profile. This is with id 7 on demo site of civicrm.
If you don't find this profile -  error is due to this reason.
If you find it - check the name column of this profile and change if it is anything other than summary_overlay.


Allow user to manage mail templates I can't find out how to allow a CiviCRM user to manage the mail templates, i.e access

/civicrm/admin/messageTemplates

...without giving the "Administer CiviCRM" permission. How can I do that ?

I'm using Drupal 7 and CiviCRM 4.5.8.

Thanks

"edit message templates" is a separate permission in CiviCRM 4.6 (see screenshot below), so you'll get this functionality by upgrading.

Upgrading is also a good idea, since version 4.5 isn't a "Long Term Support" version of CiviCRM and thus doesn't receive security updates.


CiviEvent Confirmation Emails: Cutting off content We've recently started using CiviCRM and CiviEvent but have found that the confirmation PDFs attached to confirmation emails are cutting off text and not appearing properly.

This is what they look like when I download the confirmation PDF that CiviEvent automatically generates.

Can anyone please advise how we can fix this?

Cheers

I've often found good luck by switching to wkhtmltopdf.  It's written in a coding language that makes it tough to distribute directly with CiviCRM, but takes a few minutes for someone who knows what they're doing to install.  Someone posted wkhtmltopdf instructions here.


process_mailing processing addresses when called in UI but not CRON CiviMail scheduled e-mails are not being triggered automatically through CRON.  Using the same user with the same permissions, I get the following in the log when triggered through the Scheduled Jobs user interface:

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

Full message:
Finished execution of Send Scheduled Mailings with result: Success (a:1:
{s:9:"processed";i:1;})

But when the same is triggered on CRON using CURL

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

Full message:
Finished execution of Send Scheduled Mailings with result: Success (a:1:
{s:9:"processed";i:0;}

I'm not getting any errors when I call the CRON page from the browser.  On the CiviCRM status page it shows that CRON is running.  In conclusion, the scheduled task processes address only from the user interface and not from CRON.

I am using the latest CiviCRM build (5.3.1).

Had the same problem, on Ubuntu change the system time zone with "sudo dpkg-reconfigure tzdata". Restart the mysql service with "sudo service mysql restart".

Can confirm that this gets the cron running and processing the mailing.


Enable recpatcha on all CiviCRM Contribution pages which does not include profiles I need to include recaptcha on all donation pages in CiviCRM.

CiviCRM: 4.7.13

Drupal: 7.5.0

I know we can enable the "Include recaptcha" in profile settings. But few donation pages does not have profiles configured and I am bit worried how to add recaptcha for those donation pages.

Any help would be greatly apppreciated.

Thank you

You can add a profile that only captures email address.  Since that's already captured on a contribution page, it doesn't change what appears, but it lets you add a CAPTCHA.


Use single profile on checkout from cart I'm trying to use the cart checkout to simplify checkouts for parents registering their children in multiple classes over the summer. Many sign up for 8 classes, and when they get to checkout, they have to enter all their information for all 8 classes.
Does anyone have experience altering the checkout to check if the same profile is being used on the multiple events to just use one?

Edit: Alternatively, is there a way to assign a profile to the overall cart checkout, so the profiles used for the individual events could be shortened?

Just so you know, there's two extensions currently under development for CiviCRM, and specifically that integrate with CiviCRM's Event Cart feature, that might meet some of your needs. They're under active development, and you can check them out on CiviCRM's GitLab.

boxoffice: Provides a lighter workflow for the CiviCRM Event Cart. Designed for a ticket box office (ex: where you do not need the names of other participants).

eventpack: Provides a way to bundle events together (at a discounted price) in the CiviCRM Event Cart (and the Boxoffice extension).


I have no CiviCRM menu when using Shoreditch CiviCRM 4.7.25 with Drupal 7: I have no CiviCRM menu when I use the Shoreditch Bootstrap theme in CiviCRM. Anyone else had this problem and fixed it?

I would guess it is related to https://github.com/civicrm/org.civicrm.shoreditch/pull/90#issuecomment-343347028 and the PR seems to solve that.


Number repeat events We have set it up so we use a drupal form to register for events.
We have repeating events, and the form lets you sign up for all of them in one go.

When we go to set up the events form, our dropdown just shows the title of the event ie "after school football" six times. this is confusing as we may not select all of these or select one more than once.
I am looking for some way to have it so the repeating events are numbered, or have their dates beside them.

Here is a picture to try and illustrate what I am meaning:

I'm afraid there is no code that I know off. It's certainly possible we can add an id (or date or something) to the Event listing in the admin-config page. End-user org can become an official Webform CiviCRM sponsor as of $300; send me a direct message if you're interested in learning more.

I would also be happy to review a PR if you (and/or your developer) would like to submit one - I'm a co-maintainer on https://www.drupal.org/project/webform_civicrm


Why can't all admins see all components? I have Civicampiagn installed and activated, and I can see it, but I have added a second admin and that account cannot see the link, nor can they see the campaign option on the add activity page.

What am I missing?  Kind regards~

When you enable CiviCampaign you may need to visit your Permissions and give the CiviCampaign permission to the required roles.


After turning on Send Scheduled Reminders and setting up a Membership Renewal Reminder, why am I getting all zeros in my Scheduled Reminders log? I am using CiviCRM 4.5.8 on Drupal 7. I get the feeling my scheduled renewal reminders are not going out. These are my settings:

Are there some other parameters or settings I need?

You say you get the feeling...have you gone into Search > Find Activities > Activity Type of "Membership Renewal Reminder" to see what it lists?  I always check to see if it has recorded the activity.  That doesnt mean it has been emailed only that it was scheduled against that account.  Additionally my reminders show up in the Recent Items on the left side of CiviCRM.


Why do I get security warning & how to remove? User just got 3 security warnings about access to sites/default/files/civicrm/custom & sites/default/files/civicrm/upload & sites/default/files/civicrm/ConfigAndLog.

I changed the access of all to 555 but still get the message for the last one (ConfigAndLog). In this folder there is an .htaccess file - below.
Release is 4.6.29, Drupal 7.  I'm puzzled why this has happened today - 4.6.29 has been there for months. So-

Why have these messages popped up now? I guess this is something timed to appear today as I also get it on a 4.7 system
How do I fix the ConfigAndLog message which is still appearing?

So as he why you get security warnings: because civi has found your configuration insecure, ie. you have files that shouldn't be accessible on the web but are.

As how you fix it (and get rid of the warnings), it depends on the web server you use and how it's configured.

The .htaccess rules only work for apache, and only if it's configured to read them. If you use nginx or another webserver, you will need to implement the rules denying access to these forbidden folders differently.


Can a contact have more than 5 websites? Apologies if I'm missing something simple...

I want to add about 10 websites to a contact, but after I add five, I no longer get an "Add" button, and can't figure out how to add more.

Any suggestions?

A quick workaround which I can see is you can easily add n number of websites for a contact from the Contact Edit Form (Click Edit on the Contact Summary Page).
<site_name>/civicrm/contact/add?reset=1&action=update&cid=<contact_id>.

This is restricted to a count of 5 (may be a bug) in Inline Edit mode according to the code written here.


Donor with only email address shows no display name If a NEW donor makes a donation and only supplies their email address*, the displayed name is blank in WordPress civi 4.6.4 and above. (*This can happen when someone donates directly through PayPal, civi only retains the email, or sometimes in a "pay later" situation when only an email is required.)

In my old civi (4.2.7, yes I know very old) it always defaulted to the email address if no name was supplied. Now that I'm upgraded to 4.6.4 the email address does not show in the contribution dashboard, contribution searches or the soft credit section on the donation tab for a contact.

I tested in the Demo site. If a donor already exists with just a email, then it's peachy it shows the email name. But if you make a new donation with a new email address there's no displayed name. (See below). You can go into the contact, press 'add or edit email' and then immediately press save and civi will then start displaying the email properly.

Any idea why it won't do this to begin with?

EDIT: Reported as CRM-16936

This sounds like a bug in recent CiviCRM, especially given that you've confirmed the behavior change on demo site.

Why this happened isn't so important I expect as what to do to get it fixed, and whether this change in behavior is intended - I'd guess not.

To get it fixed, the next step would be to open an issue in the bug tracker at http://issues.CiviCRM.org - your details here are perfect for that.

You or your organization could contribute further towards the fix, but a thorough bug report like you've provided is a great contribution already.


Webform Submission URL Access Control I use CiviCRM Webform to manage complex Event registrations.

At the end of registration, an email is sent to the registrant, which contains a submission URL, in the form of :
https://www..../?q=node/xx/submission/yy

But this URL is refused except for the Administrator

How must I manage Access Control, so that the registrant can access AND edit this submission ?

I think you need to grant the Webform: Edit own content permission. This may still not give access to view the submission (haven't tried) but it would give the user access to edit their submission, which is probably more important (tweak the link you email out to edit rather than view the submission).

If all you want is to allow the user to see their submitted values, I second Karin's suggestion that you put them in the body of the email. This way the user can see them immediately without needing to click on a link.


Formatting tags shown in activity view It seems that any activity created in 4.7.1 (not sure about earlier 4.7 versions) sometimes shows all formatting tags when viewed.

I reproduced this both in Wordpress and Drupal demos by creating a new case. When viewing the "Open case" activity, the < p> tag was shown, as were tags for strike-through, italics and bold, as well as h2 heading. Same happened when adding and then viewing a single activity added to a contact.

What is strange is that adding or editing an activity to an existing case went fine, no tags were shown in the subsequent view.

As I was able to reproduce this on the demo, I believe it is a bug in CiviCRM. It can be rather big issue, since it can render activities with more formatting nearly impossible to read. I'd report this as a bug to jira directly, but instructions say first post here, so here I post.

edit: The affected activities also show all tags on their print versions (of the single activity).

edit2: I would even try to somehow fix this myself with my limited php/html knowledge, but I can't even find the file responsible for this. :(

edit3: Just a small update, issue is still present in 4.7.2, possible related/same issue on Jira

This sounds like a duplicate, or at least new variation in 4.7.1 of, Formatting of formatted text in print case and activiy audit


how can I filter the list for address > "country" field in "new individual" I want to filter the option list of the "country" field on the address tab.. I found out that the country field is getting the list of country field in "civicrm_country" table and I want to add a new column "is_active" on the table for the filtering but I can't find the function that generates the list.. does someone know where I can find the function generating the option list so I can add the filter? thanks a lot

Welcome to CiviCRM SE, Could you please tell why you want to add 'is_active' field to country table? Can't you just disable the countries from appearing in drop down(or include only countries that you need in your system) from CiviCRM >> Administer >> Localization >> Languages, Currency, Locations?


Getting problem while installing of my extension I was trying to install my created extension. First time it worked. After I was trying to install then it shows me the following error.[I am working on windows and Linux platform. But this problem occurred on Linux platform].

  Error
   Field: name must be unique. An conflicting entity already exists - id: 96

Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
Field: name must be unique. An conflicting entity already exists - id: 96

To debug this problem, it helps to turn on debugging and backtrace (Administer menu » System Settings » Debugging and Error Handling).  This will give more detailed errors.  You can also check the log in the ConfigAndLog folder.

It also helps if you can post your code on Github with a link so folks can see problems.  In your comments you say that you're using the API to create your records.  However, you must also remove those records on uninstall.  Using hook_civicrm_managed instead of the API will handle this for you.

To resolve this problem for now, manually delete the records your extension creates, then add an uninstall routine and you should be good.


Autocomplete Contact Search - Add Contact ID possible? I'm working with a direct mail company on a donation campaign. They plan on including the contact ID on the top of the donation tear off. Then when we manually enter the donation we're be able to search by contact ID, avoiding possible duplicates. This is the way they always do it for efficiency.
There's several you can already add under "Search Preferences" but not the contact ID.
Is it possible to just manually add it to the database?
morekidsonbikes

I needed to do something similar. There were two things to work on: getting the Contact ID in the search suggestion in the quick search and getting CiviCRM to search the Contact Id by default when placing a number in the quick/regular search and hitting enter.

Note: I just adapted my code to work with contact ID, didn't test it.

I used a CiviCRM extension with the queryObjects hook:

[myext]/myext.php

// Get the Contact ID to display in the suggestions
function extname_civicrm_apiWrappers(&$wrappers, $apiRequest) {
   if ($apiRequest['entity'] == 'Contact') {
      if ($apiRequest['action'] == 'getquick') {
          $wrappers[] = new CRM_Extname_APIWrapper_GetQuick();
      }
  }
}

function emulate_civicrm_api3_contact_getList($params) {

    $res = civicrm_api3('Contact','get', $params);

    // reformat the output to look like getquick
    foreach ($res['values'] as $idx => &$value) {
        $value['data'] = $value['id'].' :: '.$value['sort_name'] . ( empty($value['nick_name']) ? '' : ' ('.$value['nick_name'].')' );
        foreach (['street_address','city','state_province_name','postal_code','phone','email'] as $col) {
            if (!empty($value[$col])) $value['data'] .= ' :: '.$value[$col];
        }
    }

    return $res;
}

// Get the id to be part of the default search
function extname_civicrm_queryObjects (&$queryObjects, $type = 'Contact') {
    if ($type == 'Contact') {
        $queryObjects[] = new CRM_Extname_BAO_Query();
    }
}

[myext]/CRM/Extname/APIWrapper/GetQuick.php
clas

s CRM_Extname_APIWrapper_GetQuick implements API_Wrapper {

  public function fromApiInput($apiRequest) {

        if (!empty($apiRequest['params']['field_name'])) return $apiRequest;

        $apiRequest['entity'] = 'Contact';
        $apiRequest['action'] = 'getlist';
        $apiRequest['function'] = 'emulate_civicrm_api3_contact_getList';

        $apiRequest['params']['sequential'] = '1';
        $apiRequest['params']['nick_name'] = $apiRequest['params']['id'] = $apiRequest['params']['name'];

        unset($apiRequest['params']['name']);
        unset($apiRequest['params']['option']);
        unset($apiRequest['params']['task']);
        unset($apiRequest['params']['field_name']);
        unset($apiRequest['params']['table_name']);

        return $apiRequest;
  }

  // this never seems called
  public function toApiOutput($apiRequest, $result) {

      return $result;
  }

}

[myext]/CRM/Extname/BAO/Query.php

class CRM_Extname_BAO_Query extends CRM_Contact_BAO_Query_Interface {

    function &getFields() {
        return ['id'];
    }

    function from($name, $mode, $side) {
        return '';
    }

    function where(&$query) {

        $grouping = NULL;
        foreach (array_keys($query->_params) as $id) {
            if (empty($query->_params[$id][0])) {
                continue;
            }

            $this->whereClauseSingle($query->_params[$id], $query);
        }

    }

    function whereClauseSingle(&$values, &$query) {
        list($name, $op, $value, $grouping, $wildcard) = $values;

        $fields = $this->getFields();
        if (!empty($value) && !is_array($value)) {
          $quoteValue = "\"$value\"";
        }

        // Look in CRM_Contact_BAO_Query:2025 for how this is all gatherered into or's and ands

        switch ($name) {
          case 'sort_name':
            // the default search is grouping=0; this is pretty hard coded into CRM_Contact_BAO_Query
            if ($grouping==0) {
                foreach ($query->_where[$grouping] as $key => $val) {
                    if (strpos($query->_where[$grouping][$key],'sort_name')===false) continue;
                    // search id if numeric
                    if (is_numeric($value)) {
                        $query->_qill[$grouping][$key] .= ' Or '.($value ? ts('Contact ID is '.$quoteValue) : ts('Contact ID is not '.$quoteValue));
                        $query->_where[$grouping][$key] .= ' OR '.CRM_Contact_BAO_Query::buildClause("contact_a.id", "=", (int)$value, "Int");
                    }
                    break;
                }
            }
            return;
        }

    }

    public function getPanesMapper(&$panes) {

        return $panes;
    }

}


Request login on edit mode profile form I'm using CiviCRM 4.7.31 on WordPress with the Members plugin. I created a new profile, then embedded that form in edit mode within a WordPress page:

[civicrm component="profile" gid="35" mode="edit" hijack="0"]

As expected, the WordPress page generates an error if a user is not logged in:

  "No user/contact ID was specified, so the Profile cannot be used in
  edit mode."

This error persists even when I set the page's Content Permissions to limit access to users in selected roles.

The error disappears when I wrap the civicrm shortcode within the members_logged_in shortcode:

[members_logged_in]
[civicrm component="profile" gid="35" mode="edit" hijack="0"]
[/members_logged_in]

But then the profile form loses its formatting; it seems like some Javascript/CSS is not loaded on the page when the shortcode is nested.

Is there a way to make this work correctly? Do I need to switch to Caldera Forms with the Caldera Forms CiviCRM plugin?

Thanks for your help.

The solution was to make sure the Civi scripts loaded on the page. This answer provides guidance on how to do that.


Unable to upgrade to 4.7.6 Wordpress 4.5
CiviCRM 4.7.6

I have installed the CiviCRM 4.7.6 plugin and get a message that I need to upgrade the database. When I try the upgrade, get a white screen displayed with the single word "error" in the upper left. Then I cannot access any Wordpress functions and have to reload the datbase again.

Ran into something similar. There are some database table alteration between 4.7.5 and 4.7.6 (specifically relating to foreign keys). These edited CiviMail tables. If you have used CiviMail extensively, these tables could be quite large. The ALTER TABLE commands can take a very long time causing time outs.

The quickest option is to backup these tables, trucate them, run the CiviCRM 4.7.5 to 4.7.6 upgrade comands, and, finally, reimport the data.

Affected tables:

civicrm_mailing_event_queue
civicrm_mailing_recipients


How to perform searches with groups of OR statements joined by AND statements Search Builder in CiviCRM allows groups of AND statements to be connected by OR statements, but not the other way around.

That is, I can perform a search like:

(X AND Y AND Z) OR (A AND B AND C)

but not:

(X OR Y OR Z) AND A AND B AND (C OR D).

If I want to do the latter, I have to rewrite the entire query for each of the elements in the OR statements.  That gets pretty tedious pretty quickly.

My questions are:

Why is it like this?
Is there some way to search (within CiviCRM with all the benefits and options for search results) as per my second example?

Thanks,
Lewis

The best way to do what you want is to :

create a smart group for (X OR Y OR Z) using search builder
create a smart group for (C OR D) using search builder
use search builder to combine all the criteria using Contact -> Group -> '=' -> (the group you have created)

I agree it's pretty tedious... but someone will have to re-work the search builder to allow the logic you want. It's not a simple task.


How to create a view to display all the files in an extension? I want to create a view to show all the created templates and provide the user option to edit and delete the already uploaded file..For example a view like Mailings>>Message Templates.
I have seen to implement this i want to create a tpl file and tpl.php file for it. I don't get how should i implement this in my extension.mean i don't get how to generate a tpl.php file and create route for it.
Hope you understand the question. Thanks in advance

Take a look at the documentation for civix. To create a page like the mailing templates you could use civix generate:form, as described at https://docs.civicrm.org/dev/en/latest/extensions/civix/#generate-form
If you prefer to create an angular page, you can also use civix to generate the basic code: https://docs.civicrm.org/dev/en/latest/framework/angular/quickstart/#create-an-angular-module


Problem submitting payment on webform gift membership I have set up a webform to receive gift memberships so that one individual  can purchase a membership for another. Although the instructions seem relatively straightforward (see here and here), the payment page/form does not display an area to actually submit credit card information.

Any insight would be appreciated.

Some details:
The problem is not specific to gift memberships, but webforms. The webforms on our site integrate fine with civiCRM, EXCEPT for accepting payment. So for example, I use webforms for non-paying memberships and everything works fine. I have tried setting up just a webform that links to a contribution page and it does not work.

So, per the civiCRM webform documentation, "Using Webforms, you can accept online payments for contributions, events and memberships or any combination of these on a single form."

THe documentation then states that "When creating a contribution, event or membership webform that includes payments, first set up a dedicated contribution page for the sole purpose of embedding it on one or more webforms. Most of the contribution page settings will be ignored by the webform. Only the following need to be configured:
Title: This will be displayed on the webform
Financial type
Currency
Payment processor
Email receipt - if enabled, these will be sent from the webform just as they would be from the real contribution page"

On the backend, all of this makes sense. I have set up a dedicated contribution page and configured each of the items listed above (title, etc). I have tested the dedicated contribution page, and it works fine. The problem seems to  be in how the page connects to the webform. But I do not see anything wrong on the backend, nor have I found someone discussing a similar problem.

I've included three images:
(1)Purchase gift membership contact info screen: this is the initial webform that takes an individual's information. Everything appears ok here.

(2)Purchase gift membership payment screen: note that there is not a way to fill in a credit card, nor is membership amount listed.

(3)Finally, the edit screen for the webform. This is where the webform is instructed to connect to a contribution page.

1: https://i.stack.imgur.com/lKSWu.png


Getting CORS error from CiviCRM dashboard dashlets I've been having problems with a new install of CiviCRM 5.3 in Multisite on Wordpress.

It seems to be working properly in the main site.

My intent is to have one CiviCRM database that works across all the subsites, sharing the contact data.

On the subsites, when I go to the CiviCRM dashboard, I get the dreaded Network Error pop up. IN the Web Developer console it shows this error:

Access to Font at 'https://dev.domain.nz/wp-content/plugins/civicrm/civicrm/bower_components/font-awesome/fonts/fontawesome-webfont.woff2?v=4.7.0' from origin 'https://crew.dev.domain.nz' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'https://crew.dev.domain.nz' is therefore not allowed access.

And the default and the Activities dashlets just spin with the CiviCRM logos.

If I remove those dashlets from the dashboard, then the problem goes away.

I would of course like to keep them.

I have added

Header set Access-Control-Allow-Origin "*"

to my .htaccess file for Wordpress. This did not help.

I'm sure that this isn't 100% a CiviCRM problem, but I'm not sure where else to ask...

Thanks,
Norm

OK. So I've found what I think is a pretty serious problem with the current Civi CRM setup and multisites...

There's an entire section up the top of civicrm.settings.php that has these lines:

$civicrm_paths['wp.frontend.base']['url'] = (URL path)
$civicrm_paths['wp.backend.base']['url'] = (URL path to admin)
$civicrm_setting['URL Preferences']['userFrameworkResourceURL'] =(URL path) to civicrm

The paths are hardcoded to the main site URL.

This seems to be what's causing these problems I'm having. Because if I change it using the code below, then it appears to work again.

=======================

if(function_exists('is_multisite') && function_exists('home_url')) {
  $url = home_url();
}
else {
  $protocol = strstr('HTTPS', $_SERVER['SERVER_PROTOCOL']) ? 'https://' : 'http://';
  $url = $protocol . $_SERVER['SERVER_NAME'];
}

// Additional settings generated by installer:
$civicrm_paths['wp.frontend.base']['url'] = $url.'/';
$civicrm_paths['wp.backend.base']['url'] = $url.'/wp-admin/';
$civicrm_setting['URL Preferences']['userFrameworkResourceURL'] = $url.'/wp-content/plugins/civicrm/civicrm';

===================

But is this a good idea? I don't know...

Norm


Disabled contribution page and recurring transactions Can recurring contributions originally set up with "Contribution Page A" still occur if Page A is subsequently disabled?

Civi 4.6 LTS with iATS payments

Yes - absolutely - the recurring series only stops if its status is switch to: cancelled or the number of installments have been completed (both are native CiviCRM behaviour).


How do I email a report automatically oh the 1st day of each month? I want to sent multiple reports (group membership lists) to different individuals (the co-ordinator of each group) on the 1st day of each month.  Scheduled jobs only allows hourly or daily mailing (not monthly) so I believe I may have to use CiviRules, but can I trigger a rule for a specific day of the month?  We use Civi with Drupal.

Ramesh's comment is correct.  The best overall solution is most likely to upgrade to CiviCRM 4.7, which adds a "Monthly" option.

If upgrading is not an option and you're on CiviCRM 4.6, you can install the Flexible Jobs extension to get this functionality.


Export CSV of an smart group's contacts via REST API? How can I make a REST API call to Civi that creates a CSV file with all the Contacts details (name, email, telephone...) from an specified Smart Group?
Thanks.

You can't create a csv directly from an API call. But it would be a very simple task to make an API call and then format the results as a csv. One simple option might be to use Google Apps Script to call the API then put the results into a spreadsheet, if you don't want to run this as a standalone script. Or any scripting language you might want to use will have plenty of Google results for creating a csv from an array, which is what the API will return.


How to take payment in Civi event Is it possible to process card payment for an event direct in Civi event without completing a form on the website?

About 2/3rds of the way down the page under "register a participant manually". http://book.civicrm.org/user/current/events/everyday-tasks/


How do I update the text seen on a membership payment page when the autorenwal option is provided? Running on Drupal 7.69 and Civi 5.18.x.

We would like to update the text that gets displayed when the auto-renewal option is active for membership types. Is there a way of doing using the admin interface or does it have to be done with code?

Image of current text is below:

You could use the word replacement function to do so. It is described in the CiviCRM documentation here.

Sometimes a text is composed of more than one string which means that you would have to do more that one word replacement.


Push Custom Report to Multiple Sites via API, Programming, or SQL I oversee dozens of CiviCRM sites running on the same server (each with its own DB) and want to push out custom reports to all of them. I would like to be able to register the report and create a new report template.

Is there a way to automate this without having to use the UI?

Thanks!

Wrap this custom report up into an extension -> then make that extension available in all your sites.


How to update changes in a custom base Mosaico template? We've developed our own Mosaico base template for use in CiviCRM. We've made some changes to the base template and updated the template file on our site, however, when trying to use the modified base both new and existing templates aren't updated with our new style tweaks.

Is there a way to flush Mosaico so it re-reads and uses the updated base template?

When i was building custom templates, clearing browser cache mostly worked. My favorite is to use Ctrl+Shift+R.

And in the UI - I would try creating new template from the base.

An already saved template may not reflect your changes, because saved blocks also store css information and may not use the new one. However any new blocks or deleting a save block and re-creating might work.

Also keep an eye on console for any JS errors before and after your changes. Sometimes even simple css changes break the knockout js, and may not reflect.

Hopefully that helps.


Deactivating Events - Registration Cancellation Notice every time i delete a participant in an event, a registration cancellation notice is sent to them. I would like to deactivate that function - I system workflow messages I can only change the content, but not deactivate this. I may have to change civievent code. Any hints where and how?
Best wishes, Michael

This could either already solve your question and if not give a very good idea of where to look: https://civicrm.org/extensions/prevent-sending-event-registration-confirmation-back-office


Best way to add "Check Date" to a contribution? My org would like to add "check date" to contributions made by check.

What's the best way to accomplish this? A custom profile will make an additional "date" field available to all contributions, but I'd prefer to limit it by payment type so it only shows up for payment type= check.

I've always just added it as a custom field.  While I agree that it'd be preferable to not have it appear for non-check payments, I've never been asked to implement that.  That could be accomplished with one line of jQuery though, which you could drop in an extension.  If you don't have experience building extensions, you can also use an .extra.tpl file, which is less work.


Custom Search with No Input Parameters just Results I'd like to create a custom search that goes directly to the results page, without asking the user for input parameters (the WHERE clause is hard-coded, no need for inputs). How can I do this?

Save the result of the custom search as a smart group, then the user can just search using that smart group name.


Downloads at civicrm.org/download/list stopped working Today I tried to download the latest 4.7 version of Civicrm,
at the download page:
https://civicrm.org/download/list

I get this as message after clicking the download button:

"Not Found
The requested URL /civicrm--joomla.zip was not found on this server."

at this url None of the download links seem to work at this moment.

Did I miss something or is this a temporary error/bug?

Thank you.

Greetins,
Paul

I just tested and they seem to work now - please try again?


Group contact cache deadlocks I have tried to activate the job specified in an entry in Eileen's blog but get the following error.

Check the new release, I think it has a fix included for this issue: https://civicrm.org/blog/yashodha/announcing-civicrm-4619-and-479-release


Is Parent Group required? When I edit a group, it will not allow me to save unless I select a Parent group. Is Parent Group required? If a Parent Group was accidentally assigned, how do you remove it without assigning a new Parent?

CiviCRM 4.7.9 and WP

This image shows an example of a Group that does not have a Parent Group. When I edit the Group the settings, the Parent pull-down list is automatically populated with a group called "Not Used (Smart Group)". It is not possible to deselect or select "none". Also, there is an asterisk next to the parent group indicating that it is required.

The second image shows a Group that has a Parent, and I would like to remove this relationship. But it is not possible. When I try to remove the Parent and save I receive an error message that Parent Group is required.

It appears that you're using CiviCRM in a multisite configuration.  You may want to update this question and future questions to reflect that.  Relatively few folks use it, and it affects the answer to this question.

In short - you don't normally need a parent group, but with multisite, you do.  There's details on why here.


outbound email settings failure to send test message Failed to connect to smtp.tipping.org.au:25 [SMTP: Failed to connect
  socket: Connection timed out (code: -1, response: )].

WE have an internal mail server. Can resolve externally. Requires username and password authentication.

Tried most things we can think of to set up outbound email but get the above error message after sending test message

Have tried using mail(), appears to send test message successfully, but never received.

Grateful for advice on how we might correct outbound email settings.

Perhaps your internal mail server uses a different port for smtp? You can see that it's trying to connect to port 25, you might have it configured at a different port?

Alternatively, if you have some kind of command line interface to the machine running the civicrm code, you could try a direct connection using, for example, telnet (details here https://www.port25.com/how-to-check-an-smtp-connection-with-a-manual-telnet-session-2/).

And finally, you might also look at the dns on the civicrm code machine to make sure your domain for the smtp server is resolving like you expect, and/or trying putting in the ip of the mail server instead of its name.


How do I hire a good CiviCRM user? Looking for someone who will use CiviCRM day-to-day (as opposed to a CiviCRM developer or consultant), how do I maximize the chance that they'll succeed in their job and in using CiviCRM?

Even as CiviCRM is a key tool for many roles at an organization, it's often an afterthought in choosing the best person for the job.  Selecting someone who knows CiviCRM will certainly help, but it's also good to hire someone with the capacity to learn the way your organization applies CiviCRM to its work.

Stuart Gaston did a fabulous session at the 2014 CiviCRM User Summit called Hiring and Training for Success.  He highlighted ways to think about individuals' patterns when they encounter technical problems and interview questions (like "What is your favorite Excel trick?") that help in highlighting those.  Even just reading the slides is a good place to start thinking.

It's good to list CiviCRM as an element of the job and a bit of experience that would be valued, but you probably don't need to make CiviCRM experience an absolute requirement.

However, you can maximize your chances at finding experienced CiviCRM users by posting on CiviCareers, the CiviCRM job board.  Posting is free, and you'll maximize the chances of finding someone who can quickly understand your CRM and maybe even share tips from past work.

(Full disclosure: my coworkers and I started CiviCareers after a series of conversations at DC CiviCRM meetups where people laid off from a local organization were looking for jobs where they could apply their CiviCRM experience.  It isn't a commercial venture--it's free and always will be--but it does mention that it's hosted by AGH Strategies.)


Default value in custom field cannot be searched i am working on CiviCRM 4.6.10 and came across this problem which doesn't seemed to be asked on the web:

I created a custom field with radio button of 3 options
I defaulted the field to one of the value and made it a required field
When a new contact is created through a event registration, the field does not show any value when the contact is viewed through in "View Contact".
Searching or reporting that use the field as a column shows nothing in the field
However, upon clicking the field in View Contact, it shows the defaulted value
After saving the field without changing anything, the field now shows the defaulted value
Searching and reporting using the field as a column now shows the default value as expected

I suppose this would be a bug ?  Thanks for your time and advice.

Perhaps this is your answer. There are two processes involved in getting a field on an event

add a Custom Set of Fields and then create the field
display the field in the Profile

so if you want a default value showing on the Event you need to set it when you add the Field to the Profile (ie 2.), you do not need to make the field itself.


Modify emailed reports content I'd like to get users more in tune with their data by sending them notifications of certain high-value reports. I really don't want them with the data attached in a PDF or worse, a CSV. I'd rather just have the report link by itself (it already does this).

How can I remove the attachment option altogether?

Perhaps more importantly, how can I modify the email template so I can add some message content directly into the report email itself (not in the PDF attachment). What template is this using? I'd just want to hard-code some text that would apply to all reports.

The email body content starts here for csv: https://github.com/civicrm/civicrm-core/blob/5.18.4/CRM/Report/Form.php#L3413, and a bit lower down for pdf.

Note also the attachments are hardcoded in, a couple lines lower down.

Note that in the report itself on the Title and Format tab you can add some text/html at the end of the header which will get included in the email.

The code seems to be after hook_civicrm_alterReportVar so I don't think you can use that to remove the attachments, but you should be able to use hook_civicrm_alterMailParams to remove the attachments.


Buildkit - amp test recieved incorrect response while connecting to a test application I had successfully ran the buildkit till got this error while running amp test. It created the test application, created data directory, set up few ports

Create data directory:/home/***/.amp/canary/data/FivN1DBNa4c05mUoshFCNDn2dHMDc01I
AMP_URL='http://localhost:7979'
AMP_ROOT='/home/***/.amp/canary'
AMP_DB_DSN='mysql://canary_zcz0m:AfLQGc9SAf9Y8zno@127.0.0.1:3306/canary_zcz0m?new_link=true'
AMP_DB_USER='canary_zcz0m'
AMP_DB_PASS='AfLQGc9SAf9Y8zno'
AMP_DB_HOST='127.0.0.1'
AMP_DB_PORT='3306'
AMP_DB_NAME='canary_zcz0m'
AMP_DB_ARGS='-h 127.0.0.1 -u canary_zcz0m -pAfLQGc9SAf9Y8zno -P 3306 canary_zcz0m'

Connect to test application
Expect response: "response-code-8UnKuVzEwx"

and while connecting to test application it showed :

Received incorrect response: "Error: Failed to write /home/***/.amp/canary/data/FivN1DBNa4c05mUoshFCNDn2dHMDc01I/example.txt
Error: Failed to remove /home/***/.amp/canary/data/FivN1DBNa4c05mUoshFCNDn2dHMDc01I/example.txt"

I have followed the commands given here : https://buildkit.civicrm.org/#/tutorials.

And restarted the server many times.

The error was due to the permission issue but I used another method for solving this.
At the time of amp config I chose [1] for the option perm_type, which sets the appropriate permissions according to linux.

Option: perm_type
Description: How to set permissions on data directories [none,custom,linuxAcl,osxAcl,worldWritable]. See https://github.com/totten/amp/blob/master/doc/perm.md

Default: none

Enter perm_type

[0] "none": Do not set any special permissions for the web user
[1] "linuxAcl": Set tight, inheritable permissions with Linux ACLs
[setfacl] (recommended)
         In some distros+filesystems, this requires extra configuration.
         eg For Debian-based distros: https://help.ubuntu.com/community/FilePermissionsACLs
[2]"osxAcl": Set tight, inheritable permissions with OS X ACLs [chmod
+a] (recommended)
[3] "custom": Set permissions with a custom command
[4] "worldWritable": Set loose, generic permissions [chmod
1777] (discouraged)


By mistake manually entered a recurring donation under the wrong account By mistake manually entered a recurring donation under the wrong account. Basically I have two users same name. So By confusion add recurring on wrong account. SO Now i want to move it from one account transaction to another account. I know i can disable the recurring on one account and enabled on another account. But i am founding the  way to move recurring transaction one account to another account. Stripe payment processor is working.

Did any monies get processed when you added the recurring Donation? If it did (or did not) will depend on your Payment processor and what pathway you used in CiviCRM to add the Contribution.

If Monies were transacted -> then you'll not just want to Delete the Contribution and re-enter or you'll charge the Credit Card (or Bank Account) again. If you can add some more details to your original question then we can help you find a solution that will work for you.


CiviMail - How do I force crmMailing.$invalid to be false? No luck getting Mailing to work with Civi 4.7.10 on Drupal despite all testing that says it should work. I think I've set every variable, token, requirement, etc there is. Even smartyDebug fails to show me an error. The Send test and Next are disabled (greyed out). Poking through the code in /var/www/drupal/sites/all/modules/civicrm/ang/crmMailing/BlockPreview.html I find

<button crm-icon="fa-paper-plane" title="{{crmMailing.$invalid || !testContact.email ? ts('Complete all required fields first') : ts('Send test message to %1', {1: testContact.email})}}" ng-disabled="crmMailing.$invalid || !testContact.email" ng-click="doSend({email: testContact.email})">{{ts('Send test')}}</button>

Although I've never used php before it seems || is a conditional whereby if crmMailing.$invalid is true 'Complete all required fields first' will be printed and if its false then the 'Send test' button is active and it will run doSend. The question is how can I force crmMailing.$invalid to always be false and trick the form into allowing me to proceed. While I could just trample over the code and not even bother with a test, I always hold out hope that somehow I'll figure out why the code won't work in my case and want to keep mods to minimum.

Well, it looks like I need glasses because there is no PHP in that bit of code. I was unaware you could do a conditional in HTML  . . . until I tried it and found out you can. Anyway, this may be one hell of a crude hack so use at your own risk.

Make a copy of sites/all/modules/civicrm/ang/crmMailing/BlockPreview.html
Track down the line starting with

  button crm-icon="fa-paper-plane" title="{{crmMailing.$invalid ||

Get rid of crmMailing.$invalid ||  . You'll be left with !testContact.email  . . .rest of line . . . crmMailing.$invalid appears twice in that line at ng-disabled. So set that to

  ng-disabled="!testContact.email"

Getting rid of crmMailing.$invalid. I'd still like to know why this is set incorrectly. Where/How is it set?


How do I restore a deleted tag? In attempting to remove a tag from a contact, i succeeded in deleting the whole tag for everyone. Is there a simple way to restore it?

Unfortunately not.  Hopefully you have a backup of your database, and ideally a test site?  If you load the backup on your test site, you should be able to search for people with the tag, select Export, and export only the Contact ID.  Import the Contact ID list to your live site, and on the last page of the import, select Create a New Tag.  You can enter the tag's name there.  The import won't do anything other than create the tag, since it's only contact IDs.


Is it possible to show CiviMails within our Drupal CMS system? When CiviMail gives a permanent link to a public mailing it simply creates a raw html page for the email. Eg, on a link like this: civicrm/mailing/view?id=1528, we see the mailing exactly as it was sent out, and the html code of this page is exactly what was sent out in the mailing.

Thus the public view of the email is outside of our CMS, and doesn't benefit from our website's navigation menus, branding or any of the features our CMS provides.

We're using Civi 5.13 and Drupal 7.68... and it would be great if it were possible to put the public view of the mailings inside of Drupal's page construction, rather than outside it.

I can see how this would be possible using Views... but is there a more obvious way that I'm somehow missing?

Thanks for your help.

As you say in the question, you can build a View based on the CiviCRM Mailings tables so eg Body - HTML etc.

Alternatively you could build your mailing body in Drupal, then use a View based on that to drop a 'views token' in to your mailing.


Is there a bug when placing a token inside quotation marks in CiviMail 4.6.2+? I have a mailing template with this snippet:

Trouble seeing this email? Read in your browser.

In previous versions of CiviCRM, the token would render correctly.

In 4.6.2 and 4.6.3, the token renders, but elements of it are HTML-escaped.  More importantly, the quotation marks surrounding the token are HTML-escaped:

Trouble seeing this email? Read in your browser.

My workaround has been to add a space between the quotation mark and token, which renders correctly:

Trouble seeing this email? Read in your browser.

Has anyone else seen this behavior?  I can't send mailings from the demo server, and setting up my dev environment to send e-mails would be a serious pain, so I wanted to check in with the community before reporting it on issues.civicrm.org.  My guess is that some of you have already got e-mails sitting in your inbox that you can test by clicking a link.

in CiviCRM 4.6.2 you can patch this issue with the following edit:

--- a/a/civicrm-core/CRM/Mailing/BAO/Mailing.php
+++ b/b/civicrm-core/CRM/Mailing/BAO/Mailing.php
@@ -1472,7 +1472,7 @@ ORDER BY   civicrm_email.is_bulkmail DESC
       if ($this->url_tracking) {
         $data = CRM_Mailing_BAO_TrackableURL::getTrackerURL($token, $this->id, $event_queue_id);
         if (!empty($html)) {
-          $data = htmlentities($data);
+          $data = htmlentities($data, ENT_NOQUOTES);
         }
       }
       else {


Adding a comment to an event during registration Created an event with a profile for registration information.  One of the fields added to the profile was the Note field, associated with a contact.  However, when the confirmation e-mail was sent, the e-mail included the last note connected to the contact, yet the current note was created in the primary contact record without any link to event registration.  It also does not show up when you view the registration.  Additionally, the note did not attach to the secondary contact that was registered in the same registration.

Said a different way.  Contact1 created an event registration and included a note in the contact note field that was part of the profile.  Rather than attaching that note to the confirmation e-mail, the note that was attached was the newest note linked to each Contact.  For Contact1, that was an e-mail from a month ago.  For Contact2, whom Contact1 was registering, it was an e-mail from a year ago.  Afterwards, the system then created the note from the registration form, attaching it to Contact1's contact record, but did not attach the note to Contact2 or the registration.

What's the proper way to create a comment field on an event registration?

You could setup a custom field for participants of the event (not contacts, nor the event, but the registration itself; Civi differentiates between contacts and participants; the registration entity is called 'Participants').

When creating the Custom Field Set, the "Used For" field would be for Participants (again, this is different from Contact).  Then when you add the field to the Profile you are going to use, the first dropdown for Field Name would be Participants; the second dropdown would be the custom field you just created.

Done this way, the Notes custom field you created only appears in the registration information (if you View the registration under a contact's Event tab), not in the Contact's Notes tab.

More details here: http://book.civicrm.org/user/events/setup/

Regarding the token for the confirmation email, because the custom field is for the registration/participant entity and not the contact entity, I think you will have to create a custom Token to access that data in the email template.


How to set up recurring contributions on Webform using Stripe I'm a little confused from other questions here as to whether setting up recurring contributions on a webform using Stripe works.  They work just fine using a regular contribution page. But using a webform that points to the same contribution page the payment goes through as a one-off, even though the 'Frequency of installments' is set to 'month'. If I add either of the other 2 fields 'Number of installments' and 'Interval of installments' fields to the webform I get the message 'Mandatory key(s) missing from params array: total_amount'.  So - recurring contributions can be set up through Stripe, but does/should this work in a webform? If so, any clues as to how you get this to work?

As webform_civicrm only uses the contribution page to get the basic details (ie. payment processor) you'd need to configure the rest using the webform_civicrm integration itself.

On the "Contributions" section you have the following options:

I think you will need to enable these, and also configure a "total amount" by activating the "contribution amount" parameter:

You can configure all those fields as "hidden" via the webform config once you have enabled them so they are not shown to the user.


Issue with CK editor  tag appearing in Token In the CK editor, when I add a token and look at the source code, the wbr/> tags appear in the token breaking the token. I have a feeling this crept in after I enabled Smarty for email. Does anyone know what might be causing this and how it can be fixed?

Thanks

Try configuring your ck editor as provided here.

Thanks

Pradeep


Self-Service Payments for Contribution (Tuition) CiviCRM 4.7.x and Drupal 7

Requirement:

Staff creates "Pending" or "Partially Paid" contribution in CiviCRM
backend.
User can log on to a page, and make payments against that Contribution until it is paid in full.

Is there any way to do this with CiviCRM or Webform CiviCRM? Would 'Pledges' work?

Alternatively - could we create a Webform-CiviCRM that creates the contribution, and lets someone come back and apply payments to it, displaying the remaining balance? Thanks!

You can certainly achieve this

Create a Contribution Page by enabling Other amount and payment processor.
Navigate to Administer >> CiviContribute >> CiviContribute Component Settings and select contribution page create at #1 for Default invoice payment page
Create a contribution for a contact with pending status.
On User Dashboard of contact (/civicrm/user?cid=[contact_id]) under contribution section you will see pay now button against the pending contribution. When clicked on pay now it will redirect to online contribution page where one can pay pending contribution online using credit card.

You can also generate the link to pay pending contribution online http://domainname.com/civicrm/contribute/transact?reset=1&id=[contribution_page_id]&ccid=[contribution_id]

where contribution_page_id(id) is contribution page id created at #1 and contribution_id(ccid) is contribution id created at #3.


User Dashboard and Edit Profile for Organization We have set up a User dashboard for individuals, and a profile so individuals can update their address, phone, email, etc. It looks like this:

We would like to set up something similar for an Organization, so permissioned users can see the organization's membership expiration date, and update the contact info for the organization.
I understand that the way to do this is to set a permissioned relationship, so the individual can view and edit the Organization. However, if I click the Organization, it doesn't take me to a user dashboard for the Organization, but a contact view as if an administrator were logged in. Membership information is not visible. The edit function is not a profile with limited fields, but all the fields an administrator could edit (see below photos):

Am I missing something? Is there a way to see a user dashboard for an organization, like there is for an individual? Can I limit the organizational fields that can be edited?
I am using CiviCRM 5.31.0 with WordPress.
Access control:  Subscriber (the user) can:  view my contact, edit my contact, access contact dashboard
Relationship permission:  set to view and update
EDIT pd added image showing what dmaster shows for comparison

We have used contact layout editor extension to show only necessary fields on view contact section. Using contact layout editor you can customize the view contact page. You can include profiles with limited fields and hide or remove the edit option via css or JS.
Or other option is write extension to redirect Org contact to /civicrm/contact/dashboard?cid=123&reset=1
AFAIK having Relationship permission: set to view and update will only allow user to updated the related contact details but not Payments or Membership. Try giving 'Access civi membership' permission to user role


How to display events on a map? In the project I am working on a user can create an event with also a postal code information and address. I want to create a page where these events are all shown on a map, how can I do this with Civicrm or another wordpress plugin? The events are in Civicrm db.

I don't think there's anything out of the box that does this. But if you're comfortable with PHP/JavaScript then it's not too tricky.

I'd create a WordPress template for that particular page, grab the event data using the API, and manually populate a google map. Untested code based on a similar thing we did recently:

<?php

/*
Template Name: Your Template
*/

get_header();

?>

<?php

//initialising CiviCRM Plugin
if (!civicrm_wp_initialize()) {
        return '';
    }

require_once 'api/api.php';

//Grab data from API
$result = api call

//print json-encoded version
echo "var events = " . json_encode($result);

?>

<?php the_title(); ?>

            <?php wp_reset_query(); ?>

            <?php the_content(); ?>

<?php get_footer(); ?>

Regarding the API calls, it looks like you'd need a few:

This'll get you the event title and its 'location block id':

$resultEvent = civicrm_api3('Event', 'get', array(
  'sequential' => 1,
  'return' => "loc_block_id,title",
));

you'd then need to look up the location block id for each event:

$resultLocBlock = civicrm_api3('LocBlock', 'get', array(
  'sequential' => 1,
  'id' => id from first query,
));

this'll then return an address ID, which you can look up with:

$resultAddress = civicrm_api3('Address', 'get', array(
  'sequential' => 1,
  'id' => address id from second query,
));

and the resulting array will contain the latitude and longitude.

It might be possible to do all the above in one go using chaining.


Is CiviCRM HIPPA compliant? We are a non-profit mental health organization and require our records to be secure.

There was quite a discussion about this here which is worth your perusing. It suggests that the question won't be 'is civicrm HIPPA compliant' but 'is my configuration and usage of civicrm HIPPA compliant'.


How to build a Drupal webform for individual/organization contributors Is there any recipe to build a Drupal webform with the possibility to choose to contribute as an individual or as an organization?

I have tried enabling contact 1 as individual, contact 2 as organization and enabling a contribution page.

But if I fill contact 1 data, contribution is recorded successfully. And if I fill contact 2 data no contribution is recorded. Seems that webform contribution is only associated to first contact.

There is some way or some trick to achieve this?

Yes: you can use Webform CiviCRM to make a Contribution of behalf of an Organization -> make Contact 1: the Organization; and make Contact 2: the Individual;

No: you can not present this as a choice on the same webform - as the Contribution will be assigned to Contact 1; So: make a screen/page ahead of the webforms - with two nice buttons: "Contribute as Individual" "Contribute as Organization" -> and then link these to two different webforms;


Adding a menu entry from an extension I'm writing an extension to provide a dashboard of membership numbers specific to our organisation. I have created the extension using civix and edited the navigationMenu function to create a menu entry. I have also created the xxxx.xml file in xml/menu to map the url to the page_callback. Is there another step I need to do?

The menu entry appears ok with the correct url but, when clicked, only displays the civicrm "home page" rather than my function. Is there a way to check if the xml file is being parsed correctly and the mapping stored? I checked civicrm_api3('Navigation', 'get'.. but I can't find entries for other extension menus so maybe this is the wrong place to look.

Any help appreciated.

You need to either clear caches or menu rebuild: https://docs.civicrm.org/sysadmin/en/latest/troubleshooting/#rebuild-civicrm-menus


Using CiviMember to automatically create a Drupal user I am relatively new to Drupal (I using version 7) and CiviCRM.  I have set up a website in which members will be entered manually, rather than using an online signup form.

I am envisaging the workflow to be:

Admin user logs on to Drupal website and goes to CiviCRM
They create a Membership for a Household
For each member of that Household, they create a related Contact

At this point, I want a new Drupal user to be created for each Contact, so that they can log in to certain restricted parts of the website.

All the documentation I have seen so far shows it working the other way around - creating a Drupal user causes the creation of a CiviCRM contact.

So, is what I am asking to do possible and does it make sense in the Drupal/CiviCRM context.

Thanks,

Carl

This can work -> when on the Contact Summary View -> under Actions -> an Admin can create a user account for that Contact;

And then to Automate this workflow: you can use CiviCRM Entity module + Drupal Rules configured to create a Drupal user account when a Membership (of specific id) has been added;

Working example:


AJAX issues with CiviCRM 4.7 We seem to be having intermittent AJAX issues with our 4.7 installation.  I've seen the following post:

https://forum.civicrm.org/index.php?topic=35850.0

And done a bit of troubleshooting. I can see from the console that I'm receiving a 500 error from Apache, however, when I look in the logs, there's no additional information beyond the 500 and an empty message. I've got every piece of debugging I know of turned on - does anybody have ideas about how to get additional information about the problem?

In case it helps, the specific call that is failing is when trying to edit the navigation menu. Most of the other AJAX calls seem to be working fine. I can manage ACLs, etc. Is it possible that I've missed a permission somewhere that is causing this to fail? I'm logged in as an administrator trying to make this change.

For our specific implementation, we ran into an issue with a permissions module we had previously written. We're still not entirely sure what the conflict was, but disabling the module enabled us to edit the navigation menu again.


Is it possible to set up to search name of attached document or better yet, contents of attach doc? We're still trying to figure out if CiviCRM will work for our organization. Our users would like to have the functionality to search the name of a document that has been attached to a case. Ideally (though I realize it's probably not possible), they would like to be able to search the contents of an attached document.

As an example, a client might call in and request a publication on apple orchards. Say we send them a publication called "apple orchard management 101" and document that in the case and possibly attach a pdf to the case. Going forward they might like to search to find all the cases where that publication was sent to a client. Or they would like to search for all cases where they were sent a publication (pdf) which included the text "organic apple production".

I know I'm reaching here, but would love to know if anyone has accomplished anything like this.

Thanks in advance.

If you are on WordPress, there are at least of couple of plugins that do full-text search on files:

https://searchwp.com/
https://wordpress.org/plugins/opensearchserver-search/

Since the files uploaded with CiviCRM are stored in the same folder hierarchy as the other WordPress uploads those plugins should be able to index and locate these files.

However, they will not be able to link the document back to the CiviCRM contact they are attached to. This feature could be achieved with a custom development.


Using CiviCRM for Fundraising Pipeline Have you found an easy way to manage a fundraising pipeline using CiviCRM?

If so, can you please share how you set it up?

Thank you.

Thanks everyone for your responses!  To clarify, this is for tracking foundations, not individual donors. We would like to be able to see where we are in the process with a particular funder. Initial Inquiry, Proposal Sent, Under Consideration, Accepted, Denied

That's a huge question- but the answer is "yes", it's all there, but you need to do your homework. A combination of rules (check out the civi rules extension) tags and smart groups can automate just about anything you'd find in a donor pipeline.


mailing labels for contributors AND their spouses/families i want to create mailing labels for everyone who donated at X event. Alice, Barbara and Carol all contributed. I want to also make sure that their spouses (Xander, Yancy and Zelda) are also included on the labels so they don't feel left out. When I search for contributors and make the PDF labels, only A,B,C show up. How can I make sure that spouses are included? Fingers crossed I don't have to go in and update all 1300 contact files. Thanks in advance!

This is not possible with the standard functionality.

However it is possible to develop custom tokens which will print the name of the spouse. I don't know if you have any experience with developing customisations for Civicrm


How to register participant for all repeating/recurring events - CiviCRM 4.6 I've been looking at the docs but can't find an obvious way to register someone onto all occurrences of a repeating/recurring event.

e.g. On a ten week course, I want to register them on one page, and not have to register them 10 times

At the moment recurring events don't support registering a participant onto all/some occurrences through the registration process. Its a feature thats been requested a few times and we're looking for funding to make it happen. Please get in touch if your interested.


Unable to drop mydashlets on my Dashboard Can't drop my dashlet in the civicrm dashoard.
I can drag it out but it wont drop anywhere.

Here is an image of me dragging it but the dashboard isn't opening up to drop it.

I fixed it by pasting the file where it was looking for it. However, it is disconcerting that it is looking for the file in the wrong place.


Hide contacts from search results ,added to specific group I am looking for hiding contacts in CiviCRM from search results,added to specific group and also Drupal user should be blocked in automatically soon after adding them to a group.Soft delete using civirules is one option.But I don't want the user to get trashed.Any help?

This is directly not available through UI, but you can do this by creating your own extension and using hooks like post and queryobject.

HTH

Pradeep


Import from CSV and dedupe using Email (match to contact) with PRIMARY email? Is there a way to use "Email (match to contact)" field mapping against the Primary email address? Or are we forced to use a location type?

In my testing, for the deduping, it actual matches against any email address no matter what the location type is.  The location type you select for email is for new contacts and what location type their email address will be imported into.


Is there a specific Exception for the API4 like CiviCRM_API3_Exception? There is a specific Exception for the CiviCRM API3 called CiviCRM_API3_Exception. Is there a similar specific Exception for API4 or do I just catch the standard Exception?

I believe api4 throws API_Exception and sometimes Exception.


New Project/Campaign set up in CiviCRM I've set up a number of projects/campaigns on CiviCRM so we can record donations against them and clearly see how much has been raised against each project.  However, I need to set up a new project and the look of the system has changed since I last did it so I can't work out how to do it. I'd be so grateful for some advice!

Best wishes

1/ you might need to add a screenshot to your Question so folk can see what you are seeing

2/ you could visit https://dmaster.demo.civicrm.org/civicrm/dashboard and compare what you are seeing with what the Demo site shows

3/ you could visit https://dmaster.demo.civicrm.org/civicrm/admin/menu?reset=1 and compare what the Navigation Menu looks like there compared to yours


Problem with civicrm tab in webform Hello everyone i've a very weird problem. All tutorials show webform civicrm integration installation normaly and easyly done. I've done installation but in webform i do not see the civicrm tab displayed. Do anybody know what happened ?
I only have these tabs

Is the webform_civicrm module enabled as well as being installed?  Go to your Modules page in Drupal (/admin/modules) and check it is enabled.

Also trying flushing the Drupal caches (/admin/config/development/performance)


Civi 4.4.6 forms not working with WordPress 4.3.1 After upgrading WordPress from 4.2.5 to 4.3.1, Civi Contribution forms return a blank page after submitting (clicking Confirm Contribution).

I would rather not downgrade WP but will if I have to. I don't have the resources to upgrade Civi at this time.

I've seen some similar issues reported here but don't have a solid lead yet. I will keep looking. Any help would be greatly appreciated.

Turns out it was the Jetpack plugin causing the problem and not the WP upgrade. I had installed Jetpack just after upgrading in an attempt to solve a different problem (unrelated to Civi). I should have tried disabling plugins before doing the downgrade, but previously no plugins were causing problems and I'd forgotten about the addition of Jetpack.


How do I generate sql/civicrm_generated.mysql using bin/regen.sh file? I am working on CRM-11369 bug. However, I was facing problems in generating sql/civicrm_generated.mysql using bin/regen.sh file. The fifth line of bin/regen.sh file is 'source dirname $0/setup.conf'. But there is no setup.conf file in this folder. So I made a copy of bin/setup.conf.txt as bin/setup.conf and filled in the values for CIVISOURCEDIR, DBNAME, DBUSER and DBPASS. I'm still runnning into errors.

I get the following error:

bower angular-jquery-dialog-service#civicrm resolve https://github.com/totten/angular-jquery-dialog-service.git#civicrm

bower retry Request to https://bower.herokuapp.com/packages/angular failed with ECONNRESET, retrying in 1.0s

It would be great if someone could help me with this.

Try:

cp bin/setup.conf.txt bin/setup.conf

Then edit and fill in appropriate values in the setup.conf file before trying to run regen.sh.


How to implement nested repeating fields? Please could I have some suggestions on how to meet this requirement:

I need to be able to add a support plan to a contact. The support plan has an indeterminate number of goals. Each goal has a type, a description and also an indeterminate number of objectives, each of which has a type, a description and some dates. The whole support plan must be visible on the screen at one time, not just while viewing but also while editing.

Civicase (mapping cases to goals) was my original thought but it does not fulfil the requirement of having it all on one screen. EDIT Also, I am not sure how I would record this data in CiviCase because a goal has to have an indeterminate number of objectives and it is not possible to create a repeating set of custom fields against a case. /EDIT

Custom fields, as they stand, do not provide what we need because although you can have repeating sets of fields, you cannot have repeating sets of fields within them.

I am an experienced PHP coder and Drupal dev so taking a custom-code approach is within reach, however the project does not have a huge timescale so I would like to keep it to a minimum or avoid if at all possible.

Here's what I've thought of so far:

Submit a pull request to core, allowing for nested sets of custom fields (I think this would take a long time, both the coding and the administrative process).
Use a Drupal page, so that I can utilise field collections. The problem with this though is that we would not be able to use CiviCRM reporting tools to report on the data. There would also be questions about how to link the drupal page to the contact (logically and visually).

Any ideas? Thanks!

Case seems like the good fit for the model, I'd suggest to keep it and create a civicrm extension that provides the UI you need. The integration with angular is fairly complete so loading/saving the activities from your UI should work fine.

If you want to dig into angular for civi, Tim session might help you getting started.


Editor Log-In Through WordPress Rookie here. Installed CiviCRM WordPress plug-in, and it works great. We've given permissions to several people for entering contact data, events, etc., however, I would prefer they not go in through the WP dashboard, to keep them from accidentally messing up the website from poking around.
Is there a way to create a WP log-in page for them so they can get into CiviCRM without going through the WP dashboard? If it's in the setup, I'm afraid I didn't find it.

WordPress allows you to specify a redirect in the URL.  So if you make this their "Log In" link:

https://example.org/wp-login.php?redirect_to=https%3A%2F%2Ftest.9to5.org%2Fwp-admin%2Fadmin.php%3Fpage%3DCiviCRM&reauth=1

They'll drop into the CiviCRM dashboard upon successful login.  Replace example.org with your own URL, of course.