texts:
I apologize if I am asking this in the wrong place, but I've hit something I cannot figure out..

I have remote drupal and civicrm databases that I want to use for multiple developers.  My question concerns the civicrm.settings.php file.  I can successfully connect to the remote drupal (CMS) database using the settings.php config, but my civicrm settings do not seem to be pinging the server db at all.  This code (no matter which credentials/IP/DB I try) is not doing what I think it should be doing...

define( 'CIVICRM_DSN'         , 'mysql://civicrm:YOUR_PASSWORD@localhost/civicrm?new_link=true');

The error:

Initialization Error

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

[code] => -26
[message] => DB Error: insufficient permissions
[mode] => 16
[debug_info] =>  [nativecode=1044 ** Access denied for user 'db_user'@'12.12.12.12' to database 'db']
[type] => DB_Error
[user_info] =>  [nativecode=1044 ** Access denied for user 'db_user'@'12.12.12.12' to database 'db']
[to_string] => [db_error: message="DB Error: insufficient permissions" code=-26 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info=" [nativecode=1044 ** Access denied for user 'db_user'@'12.12.12.12' to database 'db']"]

)

The error duplicates, which I find puzzling.  Mainly, I am wondering if there is an example of somebody doing such a thing as remote setup with CiviCRM db.


texts: Find Contacts - checkboxes not staying ticked in CiviCRM 5.15.1

texts:
CiviCRM 5.15.1
Joomla 3.9.8
PHP 7.2

When selecting contacts in the Find Contacts results page, if you tick a few of them, then go into one of them to edit it, then come out again, back to the search results, the ticks have disappeared. It used to remember the selection.

Has anyone else noticed this? It seems to have changed since upgrading to 5.15.1. Thanks.


texts: Splitting Contributions between Accounts

texts: From time to time, we have contributions that come in which need to be credited to two accounts. How do I split a contribution?


texts: How to send email report FROM other than default email address?

texts:
I have a report that is sending successfully every week. Only issue is I was not able to set FROM email address for the report. It’s always sent from default email address, but I need to send from different email. Can anyone suggest how to solve this issue please? Or whether it’s even possible at all? Thanks

parameters for API call is currently like this

instanceId=50
format=print
sendmail=1


texts: I work with homeless and their phone numbers change.  We need to keep all their numbers but add small notes to them.  Like busy signal, no voicemail, Old/Wrong Number... stuff like that.  Because we deal with so many phone numbers when I was importing the csv list I had to create new fields to accommodate this or it would wind up on the same line. If there was a way to add notes on the contact summary page to quickly reference what's going on with the phone numbers next to the phone number?


texts: How to create a multiple-record custom field set for a Membership?

texts:
Short version: Using the standard New Custom Field Set form, it is currently not possible to create a multiple-record field set for memberships. Is there some other way to achieve this?

Long version: I work for a membership-based society comprised of, among other things, a number of choral music organizations. As part of their being members, we would like them to tell us the names of the choirs that are part of their organization, and the number of singers in each choir. Given that a single organization can run multiple choirs, a multiple-record field set would be perfect for this information...if only I could create one. Using CiviCRM's built-in facilities, the only options I can see available to me are:

a) creating a finite series of separate fields for the membership type based on some reasonably safe assumptions about the maximum number of choirs a single organization is likely to have, or

b) creating a new contact type specific to these members, creating a multiple-record field set to associate with it, and then forcing someone in the office to update the information manually.

At present I'm leaning toward the first option, but I'd love to hear if anyone has any other ideas, especially ones that would allow me to use the correct (for the situation) field set type associated with the membership scope.

Thanks!


texts: How do I record a group donation in CiviContribute?

texts: Our agency received a $867 donation from a group of unnamed individuals at an event (not connected with our agency). How do we record this donation without a contact (an individual or organization).


texts: Error when processing Pay later contribution

texts:
Using Drupal 7.44 and CiviCRM 4.7.8.

When using CiviCRM 4.6.18 a Pending (Pay Later) contribution can be completed by editing the Membership that it relates to, checking the box 'Update Payment Status' and completing the payment. When this is done in a copy of the (upgraded) database in version 4.7.8 an error is displayed 'Please enter the financial type'.

This is almost certainly an error of the database upgrade or the application itself.


texts:
wondering if someone could assist with this naggging issue (small thing that we've spent 4 hours attempting to figure out).

In civi, there are options for phone types, website types etc, and similar the quetion asked in Website Display in Directory listing

we are wondering : how the heck do we disable (work) the label for the web site 'type" in parentheses??

Know we've done this before but can;t for the life of us remember how (?)

Going to profile > then the field > as suggested by the ticket above does not give is that option.

Any assistance appreciated!!

D


texts: Tokens not entered when using default Drupal CKEditor (with module Wysiwyg)

texts:
This question was already in the old forum. But no answers and I have the problem.

Set up details:
Drupal 7.latest and civicrm 4.6.2 series
Drupal CKEditor is installed in a 'libraries' subdirectory of sites > all.
the Drupal module Wysiwyg is installed to make the link to the CKEditor installed in the libraries directory.(This is done so that CKEditor doesn't have to be re-installed every time there is a Drupal update.)
'Use default Drupal' in the site preferences field that selects the Wysiwyg editor

Problem:

It is not possible to select CiviCRM tokens in the rich text editor
You can enter them by hand, or enter them into the plain text area then copy and paste them.
With CiviCRM's own CKEditor you can also select tokens as expected.

Presumably the problem is in the Wysiwyg module - it needs a plugin for CiviCRM in the same way that it needs a plugin for IMCE.

Temporary work-arounds for admins pulling their hair out...
1) use civirm's own CKEditor installation (sites settings)
2) tell users to use the plain text editor to find the token, then cut and paste into the rich text editor.

Request

Can anyone
a) confirm this is the case (that a plugin is needed) - or is there a simpler solution?
b) has anyone made such a plugin, or
c) have a really good handle on how to make one?

Regards,
HashKey


texts:
When changing a campaign name it updates in civicrm but not in views anyone have any suggestions how to get it to update in drupal views?

where is civicampaign name stored?


texts: How to add a radio button with the help of buildQuickForm()

texts:
Showing data in the form of radio buttons.

  Data

$data[$count++] = array(dao->id,dao->names);

Above code return an array of id and names which is retrieved from database.
I want to put this data as radio button.
How to do that using buildQuickForm();


texts: Civi 4.7.11 Update on Joomla 3.62 with receipts

texts:
In addition to some CkEditor issues - I am having issues when trying to print receipts  - Thoughts ?
   @import url(/administrator/components/com_civicrm/civicrm/css/civicrm.css); @import url(/administrator/components/com_civicrm/civicrm/bower_components/font-awesome/css/font-awesome.min.css);    Sorry but we are not able to provide this at the moment.  is not of type String


texts: CiviMail: Email marked as 'Draft and Unscheduled' but outgoing mail log says it's been sent

texts:
Civi 5.13.5, Drupal 7.67.

Hey everyone,

A colleague tried to send out a mailing through CiviMail to a smart group that we have been using for a few months now.

She tried to send the email but received this error message (unfortunately she didn't send a screenshot, only this text)

  Error
  Unrecognized value for setting 'flexmailer_traditional'

We do have flexmailer currently installed and enabled as I've been trying to get Mosaico to work for months (no success), but we have previously successfully sent out mass mailings on CiviMail while Flexmailer has been enabled, without receiving this error message.

The email is still listed on Mailings > Draft and Unscheduled Mailings (/civicrm/mailing/browse/unscheduled?reset=1&scheduled=false), with the status marked as 'Unscheduled'.  It is not listed on the Mailings > Scheduled and Sent Mailings page.

Any idea on why this has happened, and how I can fix it and/or ensure that it doesn't happen in the future?

Thanks in advanced!


texts: CiviCRM Event - Event Confirmation EMail

texts:
I am looking for the possibility to translate and modify the Event Confirmation EMail.

Installation:
Wordpress 5.3
CiviCRM 5.19
Thanks Felix


texts: Can't view contact groups page: "DataTables warning"

texts:
We can't view the main groups page -- a popup error appears and no groups are shown. The error is:

DataTables warning: table id=DataTables_Table_0 -
Invalid JSON response. For more information about
this error, please see http://datatables.net/tn/1


texts: Mailing labels with multiple relationships

texts:
Hoping for a little advice on the best way to address the following situation.

We have individuals with relationships to organizations.  Each individual can have multiple relationships to organizations; each organization can have multiple relationships to individuals.
Relationships have custom fields.
Based on a query against the custom fields, the client wants to use tools (exports, mailing labels, etc.) which combine fields from both the individual and the organization.

A concrete example:

We want to generate a mailing to "delegates".  Each individual could be a delegate for many organizations, and each organization could have many delegates.  Whether or not an individual is a delegate is determined by a custom field in the relationship.

We need to generate an exports and mailing labels which include the name and phone number of the individual, and the name and address of the organization.

Thoughts?

Thanks!

        Sam


texts: A tick box "same as home/primary address" when submitting Event/Contribution from Admin using paypal pro. way to fix it?

texts: Although selected contact has an address in his profile (But No Billing address). It would be useful to have a tick box saying "same as home/primary address", admin doesn't need to type in all the info again. Can anyone suggest how to do it in a quick way?


texts: Error when end-users access Contact Dashboard

texts:
I want users to have access to the Contact Dashboard on our CiviCRM site. But I'm currently getting the following error when trying to access.

The following permissions I have set.

Authenticated User:

CiviCRM: access Contact Dashboard

Anonymous:

CiviCRM: profile create
CiviEvent: register for events
CiviEvent: view event info
CiviDonate: make online contributions
CiviCampaign: sign CiviCRM Petition

If I give the permissions "CiviCRM: access CiviCRM backend and API" it fixes the issues but do not probably want to do that.

CiviCRM version 5.22


texts: CiviMail Alternative Outbound Mailbox/From Address

texts:
We are using CiviMail, but I'm a bit confused on the purpose of the FROM field when sending mailings. We have about four different email addresses set up in the CiviMail From Email Addresses screen, all with the same domain for different administrators. However, no matter which FROM address is used, all the sent mail uses the same mailbox for sending. So when we look at our sent items folder, even if we used a different email address in the FROM field, it still uses the default mailbox.

Is it not possible to use the mailbox associated with the FROM address when sending mail using CiviMail? Or will it always use the mailbox that is specified in the Outbound Mail screen, no matter which FROM address is specified?

EDIT:

Just for clarity, in our Outbound Mail Settings we have selected SMTP not mail(). Not sure if this makes any difference.


texts: How to flag all contributors with a specific tag?

texts:
I am wondering if it is possible to flag all the contacts who ever made a contribution in the past with a specific tag.
When I search for the contributors and select all of them, no action is available to set a tag on them.
If this is not available through the GUI, a MySQL statement could be a solution.


texts: utfmb4 conversion gone wrong - Some columns in the databse have utf8mb4_general_ci others utf8mb4_unicode_ci causing and Illegal mix of collations

texts:
I've recently run utf8mb conversion (through API explorer) on civi 5.28. Everything seemed OK, but now whenever I try to access events dashboard I get Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) db error. And indeed when run the sql query to count columns by collations I get:
|2 | utf8mb4_bin|
|159 | utf8mb4_general_ci|
|692 | utf8mb4_unicode_ci|
|24 | utf8_general_ci|
|4 | utf8_unicode_ci|

The following query
show variables like 'collat%';

gives me
collation_connection    utf8mb4_unicode_ci
collation_database  utf8mb4_unicode_ci
collation_server    latin1_swedish_ci

Why are some columns utf8mb4_general_ci and others utf8mb4_unicode_ci? How to I resolve this?


texts: How to create a WP account for an user already in CiviCRM?

texts:
We have contacts in CiviCRM and we want them to create a WP account to access some specific front-end content. We're using a caldera form to let them register themselves.
But if I use a test contact I get This email address is already in use.
How could I proceed? Is this possible?
(CiviCRM 5.35.1 on WP 5.7)


texts: How to remove 'Volunteers' menu option where it's not appropriate?

texts: I want users who have no access to CiviVolunteer functions to not have this menu option available to them.  However the 'Volunteers' menu doesn't appear in the 'Navigation Menu' in the 'Administer' option, so can't be modified.  Is there some other way of achieving this?  Civi 4.7.24 and CiviVolunteer 2.2.2


texts: How can I resolve an issue with [civicrm.files] following an update to 5.29

texts:
Just updated my Civi 5.25 install running with Wordpress on a Cloudron LAMP stack to 5.29. Now Civi is generating lots of alerts about unknown extensions - it looks like it can't find my extension files, and in the Civi log I'm seeing lots of warnings stating "[warning] The system has data from both old+new conventions. Please use civicrm.settings.php to set civicrm.files explicitly."
How do I set civicrm.files explicitly in civicrm.settings.php?
I'm guessing these two issues are linked, and that if I can set civicrm.files explicitly then Civi will be able to find my extension files.


texts:
I'm running civicrm 4.4.19 with Joomla 3.4.4. Sometime back in September my scheduled crons stopped running. Debugging shows that it is throwing an error of:

Fatal error: Class 'Joomla\Uri\Uri' not found in /home/XYZW/public_html/libraries/joomla/uri/uri.php on line 24

I've gotten the same error both by using the cron execution of the php file and by browsing to:

http://sitename.org/administrator/components/com_civicrm/civicrm/bin/cron.php?name=USER&pass=PASSWORD&key=SITEKEY

I get the same error if I type the wrong username or password, but not the key (then I get invalid key error).

It looks like the cron had stopped working when I updated from Joomla 2.5 to 3.4 back in September.

Ideas?


texts:
Last evening I tried to follow along with the amazing work @david-snopek posted but I've been running into some issues with the module finding the civicrm "library".

I'm trying to get this working with a BLT generated project and feel like I'm getting pretty close but don't know enough about CiviCRM to know where to look next.

I created a more in depth question here:
https://drupal.stackexchange.com/questions/247897/error-installing-civicrm-drupal-8-4-blt-composer-civicrm-must-be-downloa

Resources:

https://drupal.stackexchange.com/questions/241716/how-to-install-a-module-which-includes-a-different-version-of-symfony/241738
https://www.mydropwizard.com/blog/how-install-civicrm-drupal-8-and-why-choose-it-over-pure-drupal-crm
https://github.com/civicrm/civicrm-core/pull/10694


texts: How to make an efficient to-do-workflow for back-end staff?

texts:
CiviCRM is very flexible, to be able to be adjusted to the needs of many different use cases. One thing that is not set up by default, but is very helpful, is to set up to-do-lists for staff member.

What is the best practice for setting up a to do workflow?

(On the site I am administering, we have separate reports, showing for scheduled and pending activities last three months, with a certain assignee name. These reports are displayed on the dashboard of each user. At the same time the cron job will send by email daily reports with only the scheduled activities. So, each user can change the activity status from scheduled to pending, to indicate that they are working on it.)


texts:
This is literally the most basic of questions. I am looking for a free donor management software for the nonprofit I work at, and after all my research, CiviCRM looks like the best option! But I have no idea where to begin.

What does it mean when the start up guide refers to "hosting"? We have a Drupal website hosted by someone in Texas. Would he be able to host CiviCRM? Can I host it from my own computer? What does hosting even mean? Am I able to download the program and run it on my computer? Or is it web based and that is why it needs to be hosted? In that case, does it need its own domain name?

I've played around with the demo online and I like what I see, but I'm 100% lost in the world of open source and just looking for a simple step-by-step on how to set this up. Thanks so much!


texts: CiviMail stuck on "Starting execution of Send Scheduled Mailings"

texts:
WordPress installation. Upgraded web hosting to a VPS (Site5) and they said the cron job would work fine. I sent a test of this mailing to a group of 10. It worked fine. I So I sent the mailing to a group of ~4236 recipients and executed the "Send Scheduled Mailings." That was over an hour ago. The job log says:

Entity: Job Action: process_mailing
Summary
Starting execution of Send Scheduled Mailings
Details

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

Full message:
Starting execution of Send Scheduled Mailings

Should I be worried or does this just take a long time?


texts:
I have created a API. In this a simple select query is running and data is displaying as JSON format

But I don't how to handle / pass all the conditions to the select query

Parameter = 1 or
Parameter <= 1 or
Parameter => 1 or
Parameter != 1 or,...

Currently my query is as below

Select col1,col2,col3 from civicrm_table

I want to build my select query as

Select col1,col2,col3 from civicrm_table where condition

Here condition may be any one from the list

Is there a simplest way to handle this in Civi API

My API code

<?php

/**
 * Membershipperiod.Get API specification (optional)
 * This is used for documentation and validation.
 *
 * @param array $spec description of fields supported by this API call
 * @return void
 * @see http://wiki.civicrm.org/confluence/display/CRMDOC/API+Architecture+Standards
 */
function _civicrm_api3_membershipperiod_Get_spec(&$spec) {
//  $spec['magicword2']['api.required'] = 1;
  $spec['membership_id']['api.required'] = 1;
}

/**
 * Membershipperiod.Get API
 *
 * @param array $params
 * @return array API result descriptor
 * @see civicrm_api3_create_success
 * @see civicrm_api3_create_error
 * @throws API_Exception
 */
function civicrm_api3_membershipperiod_Get($params) {

$condition="";
if($params['membership_id'])
{
  if(is_array($params['membership_id']))
    {
    foreach($params['membership_id'] as  $key=>$val)
         $val="p.membership_id $key $val";
    }
else
$val="p.membership_id=".$params['membership_id'];
$condition=" and $val";
}

  $query = "SELECT c1.display_name, m.contact_id, c.total_amount,p.membership_id
FROM civicrm_membership m
RIGHT JOIN civicrm_membership_payment p ON m.id = p.membership_id
INNER JOIN civicrm_contribution c ON c.id = p.contribution_id
INNER JOIN civicrm_contact c1 ON c1.id = m.contact_id $condition";

  $result_array=array();
//    $result_array[]=$params['membership_id'];
  $dao = CRM_Core_DAO::executeQuery($query);
  while ($dao->fetch()) {
    $display_name=$dao->display_name;
    $contact_id=$dao->contact_id;
    $total_amount=$dao->total_amount;
    $membership_id=$dao->membership_id;

    $result_array[]=array("contact_id" => $contact_id,"membership_id" =>$membership_id, "name" => $display_name, "amount_paid" => $total_amount);
   }

$returnValues=$result_array;
    // Spec: civicrm_api3_create_success($values = 1, $params = array(), $entity = NULL, $action = NULL)
    return civicrm_api3_create_success($returnValues, $params, 'NewEntity', 'NewAction');

}
?>

BAO

class CRM_History_BAO_MembershipPeriod extends CRM_History_DAO_MembershipPeriod {

  /**
   * Create a new MembershipPeriod based on array-data
   *
   * @param array $params key-value pairs
   * @return CRM_History_DAO_MembershipPeriod|NULL
   *
  public static function create($params) {
    $className = 'CRM_History_DAO_MembershipPeriod';
    $entityName = 'MembershipPeriod';
    $hook = empty($params['id']) ? 'create' : 'edit';

    CRM_Utils_Hook::pre($hook, $entityName, CRM_Utils_Array::value('id', $params), $params);
    $instance = new $className();
    $instance->copyValues($params);
    $instance->save();
    CRM_Utils_Hook::post($hook, $entityName, $instance->id, $instance);

    return $instance;
  } */

}


texts: How can I bulk update the contact employer based on the employee relationship?

texts:
I want to bulk update the Employer field for the Individual contacts who have an active relationship of "employee of".

Even though we have many active employee relationships for individuals, the Employer field is blank.


texts: When someone opts out via an email, the last updated and modified by do not get changed? Should they?

texts: If you go in and update the contact and make them opt out, there is a log entry and the modified date gets updated on civicdm_contact.  If the contact does it via an email link there is no change to the modified date and no log entry.  Shouldn't it behave the same way no matter how the update is done?


texts: Tab with Table - can I edit the layout or styling of the tab with table vier

texts:
Can I modify the layot of the Tab With Table "view"?
So I have created a form using custom data fields, and selected the Tab with Table view.  This works fine except when I look at a completd form using the "View" function.  It renders in a pretty horrible looking table - see attached image.  I'd like to be able to edit the layout/format of the View to make it a litle more uesr and print friendly.  Is this possible?


texts:
After an upgrade from 5.7.x to 5.13.x, a standard contribution/detail report started failing. In the CiviCRM admin log, we see this sql error:

nativecode=1260 ** Row 60 was cut by GROUP_CONCAT()

Which appears to be getting generated at line 546 of civicrm/CRM/Report/Form/Contribute/Detail.php
i.e. creating a temporary table as part of the post processing.

This is a monthly report for credit card contributions, a similar one for ACH/EFT is not failing, so it appears to be some kind of limit issue.

One solution appears to be to update a mysql setting, as noted here:
https://stackoverflow.com/questions/7208773/mysql-row-30153-was-cut-by-group-concat-error

On this server (mariadb 10.1), the setting is not specifically configured, and has the default setting:
group_concat_max_len = 1024


texts: Batch number missing in version number in civicrm.php

texts:
By default, WordPress uses the version information provided in ../civicrm/civicrm.php. However, the batch number is missing here:

<?php
/*
Plugin Name: CiviCRM
Description: CiviCRM - Growing and Sustaining Relationships
Version: 4.7
Author: CiviCRM LLC
Author URI: http://civicrm.org/
Plugin URI: http://wiki.civicrm.org/confluence/display/CRMDOC/WordPress+Installation+Guide+for+CiviCRM+4.7
License: AGPL3
Text Domain: civicrm
Domain Path: /languages
*/

WordPress uses the following code to extract the version information from a plugin:

$data = get_plugin_data("~/civicrm/civicrm.php");
$version = $data['Version'];

I am using this functionality to automate keeping track of my fixes until CiviCRM and other plugins make the necessary corrections in the next release.

  Would it be possible to update civicrm.php to add the batch number?
  So, it will return 4.7.12 instead of 4.7.


texts: What is the difference between a grey and blue organisation

texts: We have different contact types including individuals and organisation and within the organsiation different types of organisations. But I cannot understand why some organsiation show as a blue building and some as a grey building.


texts: How do use upload function for mail merge with Word

texts:
After many researchs on Internet, I have not found an answer to how to use the upload function, in order to do a mail merge based on an existing Word document.

Print/Merge document has an option to upload a .docx word file. But I have not figured out how to use it.

Is is possible to create a Word document and somehow add the tokens directly in this document? And then do the merge via the upload?
Thanks for your help.
(Drupal 7.67 & Civi 5.7.0)


texts: Accessing fields/data from a lookup field

texts: Does anyone here know about CRM? Accessing lookup field data (composite address field) using JavaScript? Lookup field is on Contact form. Trying to access address of Account entity


texts: How to use webform to register a new user on Drupal 8/9 and link to contact in CiviCRM

texts: I have a need to use Webform (using the Webform CiviCRM module) in Drupal 8 to register a new user and their organisation in Civi and at the same time create the user account in Drupal and link it to the Civi contact. I can't use the standard Drupal register form as I want to include their organisation and other custom fields. How can I do this?


texts: Bogus Error Mandatory fields first name and last name OR email address missing from form

texts:
Event registration form on Civi 4.7.15 (WP 4.7.1) keeps throwing this mandatory fields missing error, even though all fields are filled in with good values.

Happens on empty cache and regardless what values I put in the form fields. I'm stumped.

(See also this thread.)


texts: In Rules Fetch Contact Entity from Tag Creation

texts:
I am trying to fetch the contact entity in a rule which triggers when a specific tag is added to that contact. I seem to be able to load and fetch the Drupal user for the contact but not the actual contact entity itself.

Is there a way for me to fetch the contact entity when a certain tag is added?

I want to fetch the contact entity so I can then delete it, using entity delete action in rules.

Ultimately I am using Webform for this which will add the tag which triggers the rule.

I know this sounds a bit dangerous but I hope to put some safeguards in place to prevent anyone with access to the webform deleting any contacts!

EDIT to Clarify:

I am trying to build the ability to delete a contact in CiviCRM using a webform in Drupal.

The way I wanted to do it, was that a CiviCRM contact with a Drupal user account logs into Drupal where they can see a list of all employees for the same organisation that they are employed by (I have done this part). I then want to give the logged in contact the ability to delete other employees of the organisation that they can see listed.

I have already managed to give logged in users the ability to create new contacts for their organisation with an option to create a Drupal account for the new contact as well.

I added the ability for logged in users to create new contacts, as well as a Drupal account, by following the very clear and helpful steps given in How can I create a Drupal user when someone submits a CiviCRM-Webform?

This method above, involved adding a tag to a contact which then triggers the add Drupal account rule. I was thinking to use the same method of adding a tag to a contact to trigger the delete contact rule. however, I can't seem to fetch the contact as an entity within the rule in order to delete the entity.

I am using Drupal 7.58 with CiviCRM 4.7.28.


texts: The links on our donor dashboards do not open unless you right click and select "Open in a new tab".  I am referring to the "View" "Edit" & "Cancel" links that appear with recurring donations. I am using Wordpress 4.4.2 & Civi 4.6.14 this is a new website and Civi install so this is not something that was working and recently quit, it has never worked for me. Any suggestions so they function normally?


texts: Outgoing Mail Settings, CiviSMTP & PHP 5.6.x Problem

texts:
After upgrading CiviCRM from 4.3.8 to 4.7.15 on Drupal 7, our outgoing mail is giving an error after sending a test email. I'm on a Debian server running PHP 5.6.x and we use CiviSMTP for our outgoing mail.

Error:

authentication failure [SMTP: STARTTLS failed (code: 220, response: Go ahead with TLS)]

Have we decided as a community what the recommended action is to address this issue? I.E. downgrade PHP to 5.5, or this CiviCRM core hack or apply this patch to packages/Net/SMTP.php (below), or something else?

CiviSMTP made an announcement to apply the following patch to disable TLS. There doesn't seem to be another option:

$this->_socket_options = $socket_options;

to

$this->_socket_options = array('ssl' => array('verify_peer'=>false,'verify_peer_name'=>false,'allow_self_signed'=>true));

I prefer not to downgrade PHP or hack core and to apply the least invasive fix possible.

Observations:

This problem is on CiviSMTP (not affiliated with the CiviCRM dev community) and seems to be specific to anyone using that SMTP service.


texts: Aggregate Contributions Reports and fiscal years (and households, too)

texts:
We have a client with a July 1 to June 30 fiscal year. To filter by a timeframe, the CiviReport system for aggregate contributions insists on grouping by a time period, which is NOT a fiscal year (Year, month, week, or day). If I filter by an aggregate amount, it then it does not include those who gave less in a calendar year even if they gave the required amount in a fiscal year. (It also displays them in separate lines.) How can I get true aggregate reporting in the timeframe I require?

ALSO: Any way to get this to work on the HOUSEHOLD level? I really need to group giving by any member of a household together without requiring people to enter gifts only to the household.

Thank you!

P.S. We need to upgrade, so these comments are for version 4.4.6


texts:
In testing CiviCRM/Stripe, we setup a recurring contribution and let it run for two months and then attempted to cancel it via the link in the email sent to the donor.

This resulted in the recurring payment being cancelled in CiviCRM but not in Stripe, so that the user will continue to be billed until someone logs into our Stripe account and manually ends the recurring payments (and no notification was giving to us on the admin side that someone attempted to cancel their 'subscription').

Our previous solution, using a Drupal module to handle recurring payments, allowed for seamless cancellations of recurring payments with Stripe. (We are running D7 and have installed the latest CiviCRM and Stripe extension)

Is this functionality working in Stripe?  I am assuming it is and that we missed something in the setup as it does not seem that Stripe would be a viable option if donors are unable to cancel their recurring contributions.

Thank you for any insight.

Rachel


texts: Select list showing limited contacts, using “CiviCRM Contact” reference in drupal

texts:
I'm having problem while storing values in select list field, for this field i'm using "CiviCRM Contact" reference. I have more than 30,000 contacts, but why in select list showing limited contacts? its showing maximum 10 contacts.

( Note : I have set "Number of values" : "Unlimited" for select list )


texts: How to get contact id of logged-in user in JS API

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

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

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

Cheers


texts:
How can i override or update the coordinates for an address on an event that isn't displaying correctly. Seems like the option in wordpress for Override automatic geocoding is missing in drupal - or maybe its elsewhere?

Thanks!

Drupal 7, Civi 5.12


texts: ARCHIVE not enabled by default on MariaDB 10.1

texts:
The ARCHIVE storage engine is enabled by default on MariaDB 10.0, but no longer from 10.1.

Therefore, you get a DB unknown error when CiviCRM tries to create a logging db table when logging is active (admin=>system=>misc), for instance when creating a new custom field.

From MariaDB 10.1, the plugin needs to be specifically enabled, for example:

INSTALL SONAME 'ha_archive';

More on https://mariadb.com/kb/en/mariadb/archive/


texts: Setting default values for Personal Campaign Pages

texts:
We have a student organization where all students are being asked to help solicit contributions to a campaign.  Was hoping to create personal campaign pages (PCP) for each student.  Rather than having each student create their own individual title, message, etc. for their PCP, I'd like to default values that they can then override if they choose to do so.

Is there any straightforward way to auto-create the PCPs with default values for a list of current users within a group?  Anyone tackled this one before that can point in the best direction?

Using CiviCRM 4.5.4 on Drupal.


texts: Running CiviCRM unit tests with an extension installed

texts:
(Please note - I am not asking how to create unit tests for an extension.)

If I want to see how an extension - or combination of extensions - impacts CiviCRM's functionality, I think it'd be really neat to run the standard UTs (thanks buildkit & vagrant :) with an extension installed.

My understanding at the moment is that Civi Unit Tests initialise a new copy of the DB when they're run, and mess about with it a lot.

Please can anyone tell me where/when I should hook in enabling extension functionality?

John


texts: How do Cividiscount codes work when used with a price set?

texts:
I may be missing something obvious here, but...

I create a contribution page that makes use of a price set. The price set includes  a number of radio button price options.
I create discount code that provides a discount against one of these price options.
When I view the live contribution page, there is no field displayed where I can enter my discount code.
I can recreate this on the demo site at http://dmaster.demo.civicrm.org


texts: How to send organization a list of current Employees?

texts:
I want to send a scheduled email to our organizational contacts to have them review the list of employees we have on record for their organization (employees inherit a membership status with our organization).

Ideally, I'd like to have a private link that the organization's contact can click that will display all contacts who have a relationship of "Is Employee Of" their organization. This way, they can verify whether our records accurately reflect their current employee listing.

I'm using Joomla 3.14 and civi 5.21.1

Is there a way to create a link like this from civi email? If so, how?


texts: Installing CiviCRM - best security practices

texts:
I am new to CiviCRM and want to use it on a Joomla website.

The question I have is how is the best way to make sure, that the CiviCRM user data is secure?

I am thinking about installing CiviCRM in an second Joomla installation on an separate hosted account so that the main website and the CiviCRM data is completely separated and therefore the attack vector is as small as possible. Is this a too big overhead? How do others do that?
Mainly I want to use CiviCRM for global member / participants management.


texts: Why does API get participants return all custom fields together with the specified return field?

texts:
When I do this:

$result = civicrm_api3('Participant', 'get', [
  'sequential' => 1,
  'return' => ["custom_14"],
  'event_id' => 3,
]);

In the results I get the desired custom field, but I also get all the other custom fields. At first I thought it's just the entire custom field set but then I tested it and it returns all the custom fields for participants no matter which field set they belong to.

 "is_error": 0,
    "version": 3,
    "count": 18,
    "values": [
        {
            "contact_id": "181",
            "participant_id": "46",
            "civicrm_value_ew_9_id": "1",
            "custom_14": "dsfa",
            "custom_14_1": "dsfa",
            "custom_15": "d",
            "custom_15_1": "d",
            "custom_16": "AAA",
            "custom_16_1": "AAA",
            "id": "46"
        },

The value I looked for is returned with civicrm_value prefix, but why is the other data displayed as well? Is this a bug or am I missing something?
This seems to be the case for the Participant entity only.

I tested this on CiviCRM 5.9.1 and Michael McAndrew docker image with CiviCRM 5.11.alpha1.


texts:
I'm trying to be able to send as much emails as possible. Beside doing more stuff in parallel (eg run several cronjobs in parallel on separate batch of contacts), I'm trying to find a way to improve civimail

One easy win seems to use the smtp delivery mechanism and keep the smtp connection open for the duration of the batch. The library we use offers this option with keepConnection=true but I don't see it used in civimail

Am I missing something? Is this a path that has been explored?


texts:
We have a situation where staff will be filling in a Drupal webform in order to record an activity on a contact within Civi.
We are looking for a way to pull out some data from Civi into the webform by way of typing the contact into the 'Existing Contact' field. We know how to pull out the standard info about an existing contact (eg. Display Name, Address, Postcode etc.) Which gets displayed in this box on the webform.

But we want to be able to pull out a 'custom field' that we added to the contact in Civi which describes how much VAT that contact is paying. In Civi the field is either populated with '20%' or '0%' and we need it displayed on the form so that the staff member filling in the activity knows how much VAT that contact pays without having to go into the Civi contact to see the amount and then back out to finish the form.
So we are thinking we just need to find a way to get the custom fields to show in the following list so that we can select it for view. Is this right? It doesn't need to be editable in anyway, just a view.


texts: How can I set custom field date field for default date to be today's date?

texts:
The threads I have seen are from 2009...

Is there a solution for this in 2018?

Something that would dynamically set current date as default?


texts:
Before I add a custom field to handle this, I thought I'd make sure I'm not missing something.

When I go to Contact Reports -> Constituent Summary, it appears you can include and filter on all the "Do not" privacy settings EXCEPT "Do not trade."

Is there a way to add the ability to filter on "Do not trade?" Any idea why that one in particular is left out?

Thanks.


texts: How do i get the contribution table entries?

texts:
I want to get all the contribution table entries as a list which are equivalent to a given ID.
My contribution table has 4 entries and the contact ID for all the four contribution is 2.
I'm using the below method to get the details, but which takes the given ID as contactID and return the entries when contactID = contributionID..
foreach ($values as $key => $value){

        $contributionID = $values[$key]; //contribution IDs are 1,2,3,4,5

        // get the details for all selected contacts
        list($contributionDetails) = CRM_Utils_Token::getTokenDetails(array($contributionID),
          $this->_returnProperties,
          NULL, NULL, FALSE,
          $this->_allTokens
        );

Mean this only returns a row where contribution ID = contact ID = 2..but i want to get all the raw where contribution id is equal to 1,2,3,4 and 5.. how should i get it?
Thanks in advance!


texts: Uncaught ReferenceError: CRM is not defined when trying to access mail templates

texts:
When I try to create and new, or edit an existing, message template in 'Mailings' > 'Messsage Templates' I end up at a completely unstyled page. When I look at the console I see the following error:

Uncaught ReferenceError: CRM is not defined
at BtJa0AvQ:153

I then look at the 'file' that is being referenced and at the very last line I see:

})(CRM.$);

I have a Test server which is rendering the mail templates fine, it's simply the Prod server (which figures...) where I'm having this issue.

Any ideas where I can troubleshoot this issue?

I'm using the following:

Drupal 7.56
CiviCRM 4.7.22
PHP 5.5.38
Amazon Linux AMI release 2017.03
Apache 2.4.27

I'm only using one extension but that extension has nothing to do with mailing and was actually added well after this problem surfaced.


texts: Remove Default Profile Fields from Drop Downs

texts:
Ok, when creating new profiles within CiviCRM for events or contribution pages, some of my customers are using fields that do not coincide with the information that the payment processor recognizes, so the "My Billing Address is the Same" doesn't carry over all of the information.

Is there a way to remove some of the "default/standard" Individual/Contact profile fields available in CiviCRM with Drupal?

CiviCRM Version: 4.6.4
Drupal 7

Let me know if you need any further clarification.

I really appreciate any help on this one! :)

Thank You!!


texts: How to Parameterize Backup & Migrate to have both DBs saved?

texts:
Moving to Drupal 7.61 / Civi 7.8.2

Using Backup & Migrate, I realize that my Civi DB has never been saved (I can only do it manually via quick Backup) :

Settings give the ability to back-up :

Drupal DB
Civi DB
Public Files
Entire site

... based upon specific pertaining options (mostly exclusions).

But only my Drupal DB is actually saved

How can I have all of them saved, or select which should be ?


texts: How do I trigger a price calculation update on the event registration page?

texts:
The requirement is that if someone picks a complimentary part of the event they have to select a paid part.

I have updated with jquery the rule so that if someone checks a free option the corresponding paid for option is also checked. The price calculation update is not performed. How do I get the prices to update?


texts: How can I re-send an email to a donor using a system workflow message template?

texts: I am using CiviCRM 4.6.3 on D7. A number of users created PCP but lost their automated emails for PCP Supporter Welcome message and their other system generated email for one-time password creation. Need to re-send to them. How can I do this?


texts: Where is 'Payment Method' stored in the database for a Contribution "Payment Details"?

texts:
Simple question! What table is this in, where do I find it? Latest Civi/Drupal

This is on a contribution detail page. I updated the payment_instrument_id in civicrm_contribute but it does not change it here.


texts: Drupal 8 account creation using email in contribution page

texts:
Drupal 8 + CiviCRM.
I am using email registration module to register with email address only, not the username. I have added Drupal account creation form in contribution page from CiviCRM profile settings. But the problem is, in the contribution page the account creation form is showing username and password, not based on the email registration I installed in Drupal.
So my question is how can I make CiviCRM account creation from contribution page based on email registration module?
Thanks in advance.


texts:
What would be the best way of batch Smart Group creation using Relationships data, where Organisation name, taken from Individual Relationship data, should become a Smart Group title and all Individuals, who are in Relationship to the Organisation should become the group members. We've some issues doing this manually due to a large amount of Organisations we have in a database.

There is a similar question asked here Can I create a Smart Group programatically? , which sounds like a half of an answer; it requires pretty high level of civicrm internal logic involvement though. Any chance to get same information in "explain like im five" style, if there are no API methods to crack this?

Thanks!


texts: How does the Sympa integration deal with unsubscribes

texts:
We're looking at the various listserv options, e.g. mailman, sympa, mailchimp that have some sort of integration to civi.

So if someone receives an email via Sympa integrated to civi and wants to unsubscribe, how is it handled?  What is the process?


texts: CiviCRM Contribution Page Recurring is not working after checked RECURRING CONTRIBUTIONS (Stripe payment processor)

texts: I have created a new CiviCRM Contribution Page. Recurring is not working after checked RECURRING CONTRIBUTIONS. I am using the Stripe Payment Processor. When submit the donation form it is working as one time instead of recurring.


texts:
In what table are the online event registration profiles stored? They don't appear to be in civicrm_event where I would expect to find their profile IDs.
Thanks, Karen


texts: I see "Contribution Amounts" in my invoice and Contribution Reports

texts:
I see "Contribution Amounts" in my invoice and the Contribution Reports whereas I dont see it added either in Price Set or in the Contribution Page Amount Section.
I am unsure from where its coming from?How can I debug?
Below is the screenshot which has "Contribution Amount" listed


texts: Is there a way to reorder the fields in an export mapping?

texts: I had a request to reorder the fields in an export mapping that had been created previously. Is there a way to do this via the UI? And if not, is it kosher to manually edit the column_number in the civicrm_mapping_field table, or could that produce unexpected results somehow? (I am assuming that is what determines the sort order, so please correct me if that assumption is wrong!)


texts: Report with household, individuals and contributions

texts:
I am tasked with creating a report on households and the respective members of the households and their contributions.

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


texts:
I have a CiviCRM Webform that creates a contact with some custom fields on submission.
It throws DB Constraint error intermittently

On Webform submission I get this error:
The Druapl Reports Logs shows:

"The CiviCRM "contact create" API function returned the error: "A fatal error was triggered" when called by line 618 of wf_crm_webform_postprocess.inc with the following parameters: "Array ( [contact_sub_type] => Array ( [Invoice_No] => Invoice_No ) [webform_label] => Invoice [id] => -268 [check_permissions] => [version] => 3 ) "

However, if the same user creates a Contact using the civicrm form, there is no error.


texts:
Seems I've got tons of dedupe hits on prefixes with and without periods, ie, "Dr" vs "Dr."

Any advice on how to deal with this? Was this from various schema updates over the years?


texts: Custom fields are not pre-populating on profiles added to events, membership, contributions, etc

texts:
I have some custom contact fields that are not pre-populating the fields on event registrations, memberships, contribution pages, etc. Other fields in the profile pre-populate. When I use the profile in edit mode, the custom fields pre-populate as usual.

This is a fairly new thing, a few months ago, this was not an issue.

Latest Civi/WP


texts: I have imported memberships, need memberships to count as contributions

texts:
I have imported memberships tied to households via CSV, but have just realized that despite the fact I uploaded the membership type and payment amounts are saved for each membership type, no associated contribution record has been created. In other words, the membership appears in a  contact's record with the correct start and end date, etc., but when I pull by contributions or look at a contact's contribution record, there is nothing.

How might I go about fixing this? I need contributions to inherit membership purchases.

Thank you!

Ahna K


texts:
I'm having some problems with the CiviCRM Resource URL setting that I can't get my head around. Set as [civicrm.root]/ the System Status screen displays the error 'The Resource URL is not set correctly'. Set as [cms.root]/sites/all/modules/civicrm/ everything seems to work fine (until I try to upgrade). But surely both should resolve to the same place?

In the File System Paths section of civicrm.settings.php I have the following:

$civicrm_root = '/var/sites/c/beta.example.net/public_html/sites/all/modules/civicrm';
if (!defined('CIVICRM_TEMPLATE_COMPILEDIR')) {
  define( 'CIVICRM_TEMPLATE_COMPILEDIR', '/var/sites/c/beta.example.net/public_html/sites/default/files/civicrm/templates_c/');
}

And in the Site URLs section I have:

if (!defined('CIVICRM_UF_BASEURL')) {
  define( 'CIVICRM_UF_BASEURL'      , 'https://example.net/');
}

Trying to load the with the [civicrm.root]/ setting results in a load of javascript errors, of which the following is an example:

[Error] Failed to load resource: The request timed out. (logo_sm.png, line 0) https://var/sites/c/beta.example.net/public_html/sites/all/modules/civicrm/i/logo_sm.png

That looks as though $civicrm_root is set incorrectly, but it seems to be right in accordance with the examples given in the comments. What am I missing?

Edit: If I go to the CiviCRM Resources URLs page and click on ? I see the variables listed as:

[cms.root]  https://example.net/
[civicrm.root]  https://example.net//var/sites/c/beta.example.net/public_html/sites/all/modules/civicrm/
[civicrm.files] https://example.net/sites/default/files/civicrm/

But if I got to the Directories page and do the same, I see

[cms.root]  /var/sites/j/example.net/public_html
[civicrm.root]  /var/sites/c/beta.example.net/public_html/sites/all/modules/civicrm
[civicrm.files] /var/sites/c/beta.example.net/public_html/sites/default/files/civicrm

Where are these getting calculated from that means they're producing different results? Particularly that random one with the /j/ in the middle, which I've never seen before anywhere!


texts: Suggested Approach for Cart style donations (Donation Pages) for Crowdfunding P2P site

texts:
My Question is: For the current 4.6.4 CiviCRM are there any suggested solutions / recipies to create a crowdfunding / P2P site with shopping cart style options ?  Also, please comment if this is something you are interested in building/funding/etc.

Goal: Build a P2P Crowdsourcing Application that integrates with CiviCRM
Crowdfunding / Peer2Peer social campaings have been very popular and effective.  Civi has critical pieces to running a crowdsorucing platform but an important part is to select multiple causes and add to a cart.
Some great sites out there are:

Razoo
CauseVox
Indiegogo
Fundly
Classy
FirstGiving
Justgive
And many many more of all shapes/sizes (I have some lists if anyone needs one.)

I found some 3rd party services that (claim) to integrate with CiviCRM (I'm open to using a 3rd party but these seem to provide data and not workflow integration.):

justgiving.com
flipcause.com

CiviCRM is really well suited to provide many "causes" and integrate back-end workflow.  For example, each of the causes being a donation page and leverage the p2p are personal campaign pages.

I'm working with an organization that wants to integrate Civi workflow and allow the following:

1. Create a Grant Application (ie. A Cause)
2. When Grant is approved generate a donation page
3. Populate the donation page with a story and info from the Grant
4. Display pages in CMS
5. Checkout / payment via donation page in CiviCRM.

Most of this is nicely built-in to CiviCRM but there are a couple of issues:

Checkout is for a single donation page, but want the opportunity to "Shop" for multiple in one checkout. (major)
We could be looking at 100s of donation pages which may get tricky to manage without some hierarchy in the backend(minor)
Custom relationship between grant and donation page (minor)

There are several solutions for Civicrm Events with built-in shopping cart logic and a new Order API.  There are other modules / extensions that require a shopping cart:

https://www.drupal.org/project/uc_civicrm    Druplal Ubercart has a shaky future - Commerce has the limelight
https://www.drupal.org/project/commerce_civicrm  Not maintained - older version support
Webform Civicrm is another option, but it only supports one static donation page.

More discussions here:

http://forum.civicrm.org/index.php?topic=32376.0
http://forum.civicrm.org/index.php?topic=29879.0
What is the most integrated Drupal 7 shopping cart for CiviCRM?


texts: Example of adding multi-record custom fields to a contact via API

texts: When I attach a multi-record custom field group to a profile for contribution pages, Civi only allows visitors to enter the fields once. I've read through jira a bit and see that the capability isn't there currently. Is there a simplified example showing how to use API v3 (preferably PHP, but any method is fine) in a way that adds a multi-record custom field group at the end of a contribution (i.e. after payment processing is complete)?


texts: Cron Jobs stopped working after upgrade to civi version 4.6.33

texts: I was happily running civi 4.6.30 on Joomla 3.8.3. (which was also upgraded automagically this week) with everything working fine when up came that security warning this week. I upgraded to 4.6.33 yesterday night without any errors, but after that cron jobs stopped working. I am running the wget method because everything else was simply not working the way it was described in cron docs.


texts: Will recurring contributions be recorded for memberships not hosted by CiviCRM?

texts:
I'm in the process of moving our legacy memberships over to our new Civi install. We needed to get our membership drive going so we just used vanilla PayPal recurring donation buttons. I've set up Stripe on this new install since they offer $15k of free transactions.

I created membership types to correspond to what we had set up on PayPal. For example,

Foo Membership

Financial Type: Member Dues
Minimum Fee: $5
Auto-renew Option: Auto-renew Required
Membership Type Duration Unit: 1 Month
Membership Type Plan: Rolling

I've entered all the dues paying members with accurate start dates and even imported their dues history as a contribution import.

Will Civi keep recording contributions for these individuals even though the payments are all being done offsite? Or will I need to import/record them each month or get all the legacy members switched over to Stripe?


texts:
I would like to programatically renew memberships when a transaction has been completed in Woocommerce.
I want my members to have a more consistent experience and since I do a lot through the woocommerce store already, I wanted to do renewals and new memberships.

I need some confirmation to see if I'm doing this correctly though -
For a new membership, I think it is straight forward to simply do:

--confirm no membership entries exist already for this contact_id

$result = civicrm_api3('Membership', 'get', [
  'sequential' => 1,
  'contact_id' => 15947,
]);

--Create a new membership entry

$result = civicrm_api3('Membership', 'create', [
  'membership_type_id' => "Registered Participant",
  'contact_id' => 15947,
  'start_date' => 20200513,
  'end_date' => 20210513,
  'source' => "Payment",
]);

But for a renewal, I don't want to keep adding additional lines of membership entries so I am thinking same above except if an entry is found, issue a create with the ID and it should renew it correctly?

--confirm no membership entries exist already for this contact_id

$result = civicrm_api3('Membership', 'get', [
  'sequential' => 1,
  'contact_id' => 15947,
]);

-- Entry found so renew

$result = civicrm_api3('Membership', 'create', [
  'membership_type_id' => "Registered Participant",
  'contact_id' => 15947,
  'start_date' => 20200513,
  'end_date' => 20210513,
  'source' => "Payment",
  'status_id' => "Current",
  'id' => 8746,
]);

So the only difference between a new membership and a renewal is the 'id' and 'status_id' ?


texts:
When an activity is assigned to a user and an email is sent to the assignee with the calendar appointment, the ical is attached. However, when I open the file in Outlook 2013, it says "Meeting cannot be found in the calendar." I'm unable to save/add the meeting date into my calendar. Is there a way to resolve this?

I've also tried the activity iCal module, and I haven't been able to find a solution to add activities to Outlook effectively.


texts: Price Set Option still publically visible when visibility set to 'Admin'

texts:
Civi 5.26.1/Drupal 7.72
When I added an option 'Complimentary' to a pre-existing price set with an amount of '0.00' and set visibility to 'Admin', the option was still visible to anonymous users. Testing, I find that setting the 'Admin' option makes no difference to the existing options either.
The 'edit event participants' permission is switched off for anonymous users.
Could this be because the price set is already in use? Any similar experiences or hints for a work around?


texts: Pay Later status on imported contributions

texts: I am trying to do a bulk import of transactions that are all being invoiced now. By indicating the Contribution Status as "Pending," the transactions all import as "Pending (Incomplete Transaction)" Is there any way to get them to import as "Pending (Pay Later)"? I've tried several different variations of the text in the Contribution Status column, but all seem to fail.


texts: Creating Invoices for Membership Renewals that are coming due

texts: How do we go about creating invoices for future contributions? As far as I can tell the workflow only seems to support sending an invoice for current ones.


texts: Did you know - WordPress plugin SEO Ultimate's open Graph Integrator causes a warning?

texts:
This took a while to find so I thought I'd post it here...

If you are using CiviCRM in wordpress, and have the "SEO Ultimate" plugin, and its "Open Graph Integrator" module enabled, you may see the following error:

Warning: Missing argument 2 for CiviCRM_For_WordPress::single_page_title() in /home/civicthe/public_html/wp-content/plugins/civicrm/civicrm.php on line 1273

I'm not sure if this causes problems in the backend, but I'm hoping its the cause of some of mine.

Fix:
Disable the "Open Graph Integrator" module
Install the similar "WordPress SEO by Yoast" plugin instead - it's open graph module does the same functionality but WITHOUT the error.

I hope this helps someone.


texts:
Maybe I didn't know, but I didn't know.
I need to add a sub-option to private recipients. I can explain this with an example.

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

Apple

White Apple
Green apple
Red Apple

Pear

White Pear
Green Pear
Red Pear

Joomla 3.9.3
CiviCRM 5.10.2


texts: GDPR and CiviCRM for a small but internationally operating and serving organisation

texts:
In our relatively small UK based charity, our CiviCRM database holds personal data of members, donors, event attendees and volunteers from around the UK, Europe, USA and other countries around the world.

Our trained volunteers manage our CRM database by logging on to CiviCRM in the UK, India, USA and other countries around the world.

Could you point me to any suitable resources to determine how an internationally serving and operating organisation that holds personal data on people from multiple countries and operates in multiple countries can get ready for the General Data Protection Regulation (GDPR) which is coming into effect on 25 May 2018?


texts: How can I create branching scripts that a caller can use as part of a membership signup workflow, etc?

texts:
We're on Drupal and Civi 4.6.16.

I want to create forms with branching scripts for staff to use when doing membership signup calls, fundraising asks, etc.

I've created a webform using webform-civicrm that a caller signs into, with the contact and donor history info for the "target" contact, a "script" for the caller to use (using textarea fields), info on Activities to be created as appropriate based on the target's responses (like non-membership contribution ask - a one-on-one follow up meeting if the target agrees to meet).

But rather than have one long webform with various script options, I want to have the answers to questions asked in the script take the caller to a next step in that "workflow"- so if the target wants to contribute but does not want to schedule a follow up one-on-one meeting, then the script skips right to a page for the caller to get the target's contribution info while on the phone with the target.

However, if the target does agree to a one-on-one, then the script skips/branches to a page to create a non-membership ask activity/one-on-one meeting.

So have you done this? Are there public pages with examples?

Thanks for any info.


texts: I need to cancel for tomorrow, Jan. 30. I am registered at tee 1B, along with Gary Alphin, Rick Maier, & Austin Troy.  I am unable to play.


texts: old bug has returned, Participant Role on Event's Schedule Reminder form does not populate

texts:
this bug has returned in the latest 4.7.x (verified on 4.7.17 and .16) https://issues.civicrm.org/jira/browse/CRM-13309

if you have a scheduled reminder for an event you can not select to restrict by participant role because the options don't show up

for now I'm working around this by editing the event templates directly in the db


texts: wrong currency on contribution pages - how to correct?

texts:
I have set default currency to GBP, created memberships with GBP amounts, and set GBP as the currency within my contribution page.

But membership fee displays in USD on the contribution page and when sending payees to paypal (my only payment processor) attempts to charge of a USD amount.

What am I doing wrong please?

thank you:)


texts:
Evening Everyone;

I have found an issue with CiviCRM 4.4.14 (Drupal 7.39) which I can not fathom. I have checked everything that I can think of and nothing obvious springs out.

I have a non-Smart Group of 369 contacts (361 with e-mails- so technically 361). When I go to CiviMail and generate a mailing it will only send to 311 (with duplicates filtered 308) which I can not get to rise. I have checked the following:

That they have a primary e-mail address
That they are not flagged as do not e-mail/no bulk e-mails
They are not dead (something from the old forums) suggested null deceased
They are not on any stop flags
They are not on hold
The organisations they are members of are "current" memberships

Everything says they should receive the mail.

Oddly, the previous mailing reports reported much more; at 354, but as far as I am aware there were no unsubscribes since that mailing.

has anyone else experienced this?

edit Having made a copy of the group and removed all the contacts without an e-mail address; it appears that having a blank e-mail address does not cause the issue. In that case it would only send to 311 of 361.

I have also searched the old forums and have found similar issues Missing contact in mass-mailing Warning : Undefined offset and  missing group members in mailout list et. al. but it does not appear that there were many ideas beyond what I have already tried.

Analysing the group, there is nothing obvious that would explain the missing 50, like a type of contact, or the like.

edit 11 Sept
I have now had a change to go through the mailing and the relevant group to work out what is going on and I am no further.

Just a few quick stats which may prompt someones thought process:

There were 54 contacts in the group (of 362) which the CiviMail did not go to - 7 additional members of the group did not have e-mail addresses
50 of those 54 contacts had a surname starting with S however 1 contact starting with S did have the mailing sent to them.
There is a mixture of current and grace memberships; other contacts with those memberships received the mailing.
There is a one organisation and the rest are individuals with a variety of sub-types; other contacts with those sub-types received the mailing.
None are pending/on hold/etc

Something of note though which may be significant.

I went to the original group, to pick out and create a new group of those that did not receive the mailing. When it came to the letter S (and 50 of the 51 needed selecting) I clicked the checkbox to select all the members of the group so that I could then de-select the one who did.... it would not let me.

On the select records option it still showed 0 selected records and it errored when I tried to add it to the new group I created. I had to manually select all 50 records for it to work.

I also tried to send a CiviMail to the group of 54. It would only estimate that I would be sending it to 4 recipients. This would suggest to me that I am looking at the 50 contacts with surnames starting S.....

edit 25 Sept
This issue continues for us and I am still running into dead ends in terms of leads.

Of the 54 contacts, 4 have been discounted as they are duplicates within the mailing group
Of the 50 that remain, I have them additionally in a separate group that I can select all and send an e-mail to and they will appear on the e-mail screen. This suggests that the actual e-mails are valid without any stray spaces.
This affects the same contacts across all the groups. We know that there was not an issue on 26th August when a civiMail was sent out which contained many of the group, but then fell over between then and 4th September.

Obviously I will be trying to send the monthly mailing to all the recipients on the list manually to see if anything bounces back; but that probably won't explain why this specific list of people, surname starting S, can not be sent anything via CiviMail.


texts: CiviRules - cannot assign a tag inside a tag tree

texts: When I try to add an action to Add a tag that is within a tag tree, none of those "sub-tags" show up. If I have to move all sub-tags that I have up to the top level in order to make this work, this will be a real pain to administer.


texts: Should CiviMail report show bounces when using the Mandrill extension?

texts:
Drupal 7.36 - CiviCRM 4.5.8 - Mandrill Transactional Emails 1.5

The system is correctly putting a hard bounce contact on hold, the soft bounce is not yet on hold. But I am not seeing the bounces reported by Mandrill on the report bounces.

Is this the expected behaviour?


texts: Customize contacts screen to remove some fields

texts:
I am looking to remove some of the fields from the main contacts form - example Nickname, source etc. etc. - I am having a tough time finding the relevant information in Civicrm documentation and the only thing I find is display preferences which doesn't give me an option to disable fields

Any help will be appreciated

Thanks


texts: Does CiviMail have an upper limit for total recipients in an email blast?

texts: I have a client that would like to create an email blast to 50,000 or so constituents, and we are currently evaluating CiviCRM to handle this. I've noticed the documentation says that CiviMail is good for email blasts sent to over 50 constituents, but I can't find any mention of whether or not there is an upper limit.


texts: How to deal with problem data when importing CSV

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

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

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

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

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

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


texts: CiviCRM is exporting disabled groups, how can I specify that I want enabled groups only?

texts: I have done several exports with "Groups" as one of the fields. In each case, it exports both enabled and disabled groups. Is there any way to specify that I would like to see enabled groups only?


texts: Any issues known when installing via docker image?

texts:
I have installed Bitnami CiviCRM Stack 5.5.3-0, containing CiviCRM, Drupal, MySQL, Apache ...
It works like a charm, at least the are no obvious issues for me - ok, im a complete beginner regarding Civicrm.
Are the any drawbacks known (e.g. updating single components) doing the installation in that way?


texts: Why is it important to define new Entities for new types of data?

texts:
The Developer Guide includes detailed instructions on declaring a new entity which begins with this:

  If you want your extension to store data in the database, then you will need to create a new entity.

The steps include:

create XML schema
create DAO
create BAO
create SQL to create/drop your table
create Api

I must confess that I have stowed new data in a more lightweight way on several extensions - e.g. I've created an API Entity that handles the SQL itself, skipping the creation of XML, DAO and BAO.

I am sure there are good reasons for the detailed set of steps but it's not clear to me what benefits they bring?

In black-box thinking, an extension that needs to use a new table needs to be able to create the table, provide an Api for using it, delete the table on uninstall. Are there cases, e.g. a table for a very extension-specific use case, when it is sensible to avoid the overhead of all the extra boilerplate code (schema, DAO, BAO)?


texts:
I'm having trouble updating custom fields in CiviCRM 5.15.1/Drupal.

UPDATE: I believe this is occurring because I have too many custom fields in a custom group_id. I was able to reproduce this error twice: created a custom group, added custom fields to it. Once the number of custom fields reaches 93, I can no longer edit new or existing fields. When editing custom fields, I get the error:

DB Constraint Violation - custom_group_id should possibly be marked as mandatory for CustomField,create API. If so, please raise a bug report.

I cannot delete the custom field through civicrm (only phpmyadmin). When trying to edit the custom field, the logo spins forever. Also, when I try to access certain cases, I get an error "case_id is not valid : 1."

I know the issue is related to the custom fields/custom group because if I disable the custom group, I no longer have the case_id issue. Any ideas what is going on?


texts:
I've been pulling my hair out trying to get this working. There is a file in core that throws up errors using the SagePay extension from Circle. I can edit the core .php file and fix the problem. Obviously each time I update it is overwritten. So I have created the same directory structure under civicrm_custom_php and added the edited file. Directory paths are correct, but the file in custom isn't being picked up. Any hints or tips really appreciated on getting this working. I am running CiviCRM 5.6.0 on Drupal 7.

Thanks


texts:
This error is really frustrating and annoying. It only happens on the live server but works fine on the local server. I have  drupal 7 site with civicrm installed. One of the key I am passing on the $params array is
$params['contribution_page_id'] = 3. The data type that this paramer expects is an integer and I have tried casting it as an integer but does not work.

I am trying to create a contribution record but it throws the error while

$contribution = civicrm_api3('Contribution', 'create', $params);

Here it throws the error and I don't  know why.
The full error goes like this
CiviCRM_API3_Exception: '3' is not a valid option for field contribution_page_id in civicrm_api3() (line 45 of /home/mysite/public_html/v2/sites/all/modules/civicrm/api/api.php).

So here is my full code

    $params['contact_id'] = $attendee;
    $params['event_id'] = $event_id;
    $params['register_date'] = date('YmdHis');
    $params['register_date_time'] =date('h:i A');
    $params['role_id'] =1;
    $params['status_id'] = 1;
    $params['status_id'] = 1;
    $params['fee_level'] = '';
    $params['is_pay_later'] = 1;
    $params['fee_amount'] = calculate_total();
    $params['fee_currency'] = 'GBP';
    $bao =  new CRM_Event_BAO_Participant();
    $participnt = $bao->create($params);

    //add Contribution
    $non_deductible_amount = round(calculate_total(),2);
    $total_amount = round(calculate_total(),2);
    $tax_amount = round(calculate_total_vat(),2);

    if($non_deductible_amount == 0) {
        $non_deductible_amount = 0;
    }
    if($total_amount == 0) {
        $total_amount = 0;
    }
    if($tax_amount == 0) {
        $tax_amount = 0;
    }

    $bao =  new CRM_Contribute_BAO_Contribution();
    $params = array();
    $params['contact_id'] = $attendee;
    $params['financial_type_id'] = 4;
    $params['contribution_page_id'] = 3;
    $params['currency'] = $params['currencyID'] = 'GBP'; /**/
    $params['non_deductible_amount'] = $non_deductible_amount; /**/
    $params['total_amount'] = $total_amount; /**/
    $params['Source'] = 'Event Registration';
    //$params['is_pay_later'] = 1;
    $params['tax_amount'] = $tax_amount;
    $params['contribution_status_id'] = 'Pending';
    $params['skipLineItem'] =1;
    //$contribution = $bao->create($params);

    $params['invoice_id'] = md5(uniqid(rand(), TRUE));

    $params['payment_processor'] = 1;

    $params['is_test'] = 0;

    $params['description'] = 'Event Registration payment';

    $params['qfKey'] =  md5(uniqid(rand(), TRUE));

    $params['email'] = 'sanjok@hotmail.com';

    //This is where it fails.
    $contribution = civicrm_api3('Contribution', 'create', $params);

That is where if fails and spits out the error.


texts: Is there a way to connect the civisepa backend to the profiling in wordpress?

texts:
I'm trying to connect the payment attributes of my wordpress/civi profiles with civisepa, so that mandates will automatically be updated if a user changes his IBAN, etc. Is there any way to achieve this?

Thanks in advance!


texts: How to sort a varchar numerically using the api

texts:
I'm trying to find the activity_type with the highest value, so I can ++ that value and insert a new activity type. I thought this would be easy.

I cannot sort on the "value" column of the option_value table because it is a varchar column containing (in this case) numbers.  Take the following api call:

civicrm_api3('OptionValue', 'getsingle', [
  'option_group_id' => 'activity_type',
  'options' => ['sort' => 'value DESC', 'limit' => 1]
]);

This ought to return the activity type with the highest value. However, it returns "9" because I guess mysql thinks the string "9" > "62" (which is the actual max in my sandbox).

Anyone have a good approach to suggest?


texts: Civi webform: change error message for unique entry

texts:
Civi webform where I have a field 'existing contact' as an autocomplete. It needs to be unique i.e. one per contact (in this case contact = Constituency), so I have checked 'Unique' in the field settings.

When you submit the form with a non-unique value you get the error message:

  The value 106320 has already been submitted once for the Constituency
  field. You may have already submitted this form, or you need to use a
  different value.

Is there anyway to show the contact Display name instead of the ID in this error message?

Thanks


texts: How do I hide or re-size the Event Calendar in a CiviCRM Dashboard?

texts:
I'm using CiviCRM 5.25 and Drupal 7.

I've created two Views in Drupal and added them as Dashlets to my CiviCRM Dashboard.

After adding those, I now see an Event Calendar at the bottom of my Dashboard - which I did not add or enable.

If I remove the two added Dashlets, the Event Calendar goes away.

The Event Calendar is the entire screen width, and more, and it makes the two Dashboard columns much narrower and forced to the left of the Dashboard, leaving a large amount of whitespace on the right. Screenshot below.

So - how do I disable the Event Calendar from appearing on my Dashboard, and/or re-size it to not create undesired whitespace on the right? I have looked in the docs and elsewhere here and don't find any explanation of how this could happen, or how to change it.

Thanks!

Before:

After:


texts: Upgrade from 5.9 to 5.16 in Drupal - upgrade script won't run

texts:
I have Drupal 7 on Krystal Hosting, with CiviCRM v5.9 and trying to upgrade to v5.16. I've followed the upgrade steps on the docs.civicrm.org site and got to the step where it says,

"Or, point your web browser to the following URL and follow the on-screen instructions.

http://example.org/civicrm/upgrade?reset=1"

I've tried replacing "example.org" with my site address but just getting page not found.

I've checked I'm logged into Drupal as an admin. Only difference in address bar is text after site is ?=civicrm/upgrade?reset=1 instead of just /civicrm/upgrade?reset=1. When I click to go into Civicrm after extracting/installing 5.16, I get "Website encountered unexpected error" so I can't get to CiviCRM >> Admin >> System Status. Are there error logs anywhere with anything more helpful than "unexpected error" ?

Any help would be appreciated.


texts:
I changed the domain in Joomla, in connection with which errors began to appear in crm.
She believes that this domain is invalid. Tell me how to fix these errors?


texts:
I'm trying out CiviCRM and searching the internet I found you guys.

Using Wordpress and installed CiviCRM, but want it in Portuguese. I've read many doc's and found nothing. I have pt_BR.mo and SQL file, already put in appropriate places and nothing works.

They could give me a hand? Indicate a doc/manual, anything so that I can analyze the CiviCRM and put him in Portuguese.

thanks
kklo


texts: creating a custom group and and field using extension

texts:
I am trying to create a custom group and custom field using extension.
I created seperate funtion

function custom_group_create_example() {
$params = array(
    'title' => 'Test_Group_1',
    'name' => 'test_group_1',
    'extends' => array(
        '0' => 'Individual',
    ),
    'weight' => 4,
    'collapse_display' => 1,
    'style' => 'Inline',
    'help_pre' => 'This is Pre Help For Test Group 1',
    'help_post' => 'This is Post Help For Test Group 1',
    'is_active' => 1,
);

try{
    $result = civicrm_api3('CustomGroup', 'create', $params);
}
catch (CiviCRM_API3_Exception $e) {
    // Handle error here.
    $errorMessage = $e->getMessage();
    $errorCode = $e->getErrorCode();
    $errorData = $e->getExtraParams();
    return array(
        'is_error' => 1,
        'error_message' => $errorMessage,
        'error_code' => $errorCode,
        'error_data' => $errorData,
    );
}

return $result;

}

I call this funtion into

  function contact_civicrm_install()

this funtion(hook).
But problem is that it is not creating any custom group.
How to resolve this problem.


texts: WordPress Redirect Loop with CiviContribute

texts:
I introduced 3rd party payment processor for our client. After successful payment user is redirected to notify-url, that causes now an infinite redirect loop in WordPress 4.3 (CiviCRM 4.6.8). Our membership payment form is embedded with the shortcode [civicrm component="contribution" id="2" mode="live"] in a WP page (/members/pay-fees/). Payments are registered correctly in CiviCRM.

Redirects are done in following order:

 1. /wp-content/plugins/civicrm/civicrm/extern/PaytrailNotify.php?A_QUERY_STRING
 2. /?page=CiviCRM&q=civicrm/contribute/transact&qfKey=4b1eea15240ba2ec1e48d4111f9dca79_6652&_qf_ThankYou_display=1
 3. /members/pay-fees/?page=CiviCRM&q=civicrm/contribute/transact&
 4. /members/pay-fees/?page=CiviCRM&q=civicrm/contribute/transact&
 5. ...

I debugged the problem with PhpStorm Debugger and it seems, that redirect no. 2 returns correctly content for the thank you page, but after that WP launches do_action('template_redirect') in template-loader.php causing the redirect_canonical function to be run (in canonical.php). Because of the url in form of /?page=? redirect_canonical concludes, that user is needed to redirect to the front page with identical parameters, which leads to the erroneous redirect loop. After this rest of the loop seems to be related to the missing qfKey in CiviCRM.

So my question is how the user should be redirected to the correct WP page (/members/pay-fees/) after payment instead of redirecting user to the site root (/?page=CiviCRM...) or should the redirect_canonical be prevented?

Now in the PaytrailIPN (I modified a bit original 3rd party code) the redirect is done in following way:

$finalUrlAction = ($component == 'event') ? 'civicrm/event/register' : 'civicrm/contribute/transact';
$finalUrlParams = array(
    'qfKey' => $privateData['qfKey']
);
// Redirect our users to the correct url.
if ($success) {
  // Success. Process the transaction.
  if ($duplicateTransaction == 0) {
    $ipn = self::singleton($mode, $component, $paymentProcessor);
    $amount = (float) $privateData['amount'];
    $transactionId = $_GET["ORDER_NUMBER"];
    $ipn->newOrderNotify($success, $privateData, $component, $amount, $transactionId);
  }
  $finalUrlParams['_qf_ThankYou_display'] = 1;

} else {
  $finalUrlParams[($component == 'event') ? '_qf_Register_display'   : '_qf_Main_display'] = 1;
  $finalUrlParams['cancel'] = 1;
}
CRM_Utils_System::redirect(CRM_Utils_System::url($finalUrlAction, $finalUrlParams, true, null, false, true));


texts: Can't make an account on civicrm.org to use with gitlab

texts: I want to log an issue on gitlab and it says to create an account. So I go to https://civicrm.org/user/register and fill in various details but there is nowhere to create a password. The form submits without error but when I go to "forgot password" tells me the account does not exist. If I try to create the same account again however, it tells me that the name and email address are already registered.


texts: Can I override core classes or PHP files with custom versions?

texts: Can I override core behavior of CRM/SMS/Providers.php by creating the file with the changes in my civicrm_custom_php directory?


texts: Impossible to add a relationship between contacts / organisations

texts:
When I add a Relationship to a Contact or an Organisation, the list of Relationship Types is displayed in background and I cannot select one of them. See screenshot:

Any idea ?
I use CiviCRM 15.7.0 under WP (last version)


texts:
I need help in mapping/organizing data.

For our organization we need to capture some details of 3 categories of people. an individual can fall under all 3 or even one of them.

Professors / Scientists
visitors
donors

Apart from regular contact details, we want to capture their

educational degrees from which university,
Areas of interests,
Thesis/ dissertations submitted,
skill sets, and
medium of intro to our institute ( like web visitor, stall visitor, direct visit to organization, through some outreach events (want to capture every event specifically), etc)
also some gradation level how much they are interested in contributing to our org

We will be needing reports based on any of the above data.

As a first time civiCRM user, cannot determine which would be an ideal way to map/organize my data. Can you help me to use which civiCRM feature (groups,tags,custom fields) to use for my requirements?


texts: finding members without e-mail addresses

texts:
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??


texts: How can I change the 'Postcode' field to work with UK postcodes?

texts:
I am currently running tests with CiviCRM 4.6.14 and have custom functionality working as we require.  During testing by the end user, an issue has come to light with the 'Postcode' field.

Despite having the UK localization installed, the report filters are still treating the postcode field as an integer.  UK postcodes are a mixture of letter and numbers and I need to be able to query the database using these.
Have I missed something in the localization?  Is there something I can alter so the postcode field is interrogated as an alphanumeric rather than integer?

Any help would be appreciated.
Many thanks
Russell


texts:
I would like to prepopulate a set of custom fields (on an activity) with data about the contact it pertains to. (The data I want to pull in is in a set of custom fields on the contact).

My idea was to use hook_civicrm_buildForm and look up the data by contact id, retrieve it from the API and place it into the form. But the $form array for the custom fields form does not contain the contact id.

Then I thought of using tokens to set default values in the custom fields (either for them all, or even just to set one to the contact id in order to solve the above issue) but I tried {contact.contact_id} and it came out just like that as a literal. Can tokens be used in custom fields on activities? If not, can you suggest another way of getting my hands on the contact id during the form building process?


texts: Letter Templates Pre Populate with Membership Fields

texts:
I have email and letter templates that has the following

{contact.first_name} {contact.last_name}

{contact.contact_id}

{membership.end_date}

Now all these only show when you search for memberships and print from the search.  The membership end date does not show when the 'print pdf' option is selected from the contact.

Is there anyway they can all show when you go to print from pdf on the contact.

thanks,
andy


texts: Event signup - email address verification?

texts: Is there a way - with CiviCRM on WordPress - when an unauthenticated user registers for an event, it'll send an email with a link they need to click on to confirm their registratin?


texts: What contribution dates does the default iATS recur job process?

texts:
Does it only run recurring transactions from the current day the job is run (by default) based on the 'next contribution date' field, or does it attempt to run scheduled transactions from past dates as well?

We ran a limited trial and experienced it running a few contributions from days prior to the current date.


texts: Donors who gave the same amount in X and Y year

texts: Is there a report in the Current version of CiviCRM that can tell us this? https://civicrm.org/extensions/advanced-fundraising-reports seems to have reports that will show if the giving is increased or decreased year to year, but not if it's exactly the same. Thanks!


texts: Migrate Wordpress installation to new server

texts:
I am having crazy trouble moving my CiviCRM/Wordpress installation from one server to another.

I don't have many customizations, and we are a young organization, so I am OK with whatever solution gets my contacts and contributions to the new server, whether it's a complete copy or a fresh install and some sort of import. I think I would even be fine migrating to Drupal if it makes things easier (I have experience with Drupal sites as well), since that seems to be the most popular setup.

I have followed the instructions on the wiki, and read a few dozen other articles and threads, but everything I find relates to Drupal and the steps don't seem to line up to Wordpress...something always goes wrong.

I am able to get a new working copy of CiviCRM going but when I import my DB it breaks, and I get errors like this:

  Sorry but we are not able to provide this at the moment. DB
  Constraint Violation - dashboard_id should possibly be marked as
  mandatory for DashboardContact,get API. If so, please raise a bug
  report.

I tried exporting using phpMyAdmin, including "disable foreign key constraint checks" and "Add drop table" and other combinations of options...nothing seems to work.

I'm not sure what I'm doing wrong, and would appreciate a little hand.

Some details:
 - My current install is at 4.7.7
 - CiviCRM shares a database with Wordpress


texts: What does the error mean when enable honoree in contribute I get an error CiviCRM 4.6.8

texts:
CiviCRM 4.6.8: When I enable honoree in contribute (even with the default setting: Honor type: "In honor of", "in memory of " and Honoree profile: "Honoree Individual " ) I get a warning:
"warning the selected profile is using a custom field which is not assigned to the 'Contribution' being configured"

What does that mean?

Oddly I can use the test-drive link but not the live link.
I can disable the honoree section and it works too.

What do I do wrong?

I tried it on the demo site http://d45.demo.civicrm.org but it seem to work there. (different version)


texts:
I'm totally new to civicrm, so I'd appreciate the simplest answer possible :)
Here's my goal: to send mass emails through civicrm, to certain mailing list groups.
Here's the problem: I can't even send test emails to myself!
Here's what I did:
1.Admin> System Settings> outbound mail> SMTP: I tried three different configurations with three different email systems. CiviCRM insisted that all the settings I tried were incorrect. I confirmed with the email providers that the information I was using was correct.
2. Admin> Civi Mail> Email Accounts: I don't seem to be able to modify or delete any account I added to that list. I have absolutely no idea if it's required for sending email, or for just reading bounce emails. I'm not sure if it should be the same account used for outbound mail.
3. From Email addresses: I added the address I used for Outbound Mail, but it didn't work.
My questions is, what's the simplest way to configure civicrm for mass emailing?
Thanks.


texts: Send an email to all contacts that can manage an organization's membership

texts:
Scenario:
Membership by organization - each organization has at least one contact person that is an individual that has contact permissions.

I want to send an email to each member organization's email and each individual that has edit privileges for those member organizations.


texts: How to use a different theme for a contribution page using Drupal

texts: The ability to use a mobile friendly theme for a contribution page is vital these days.  I used 'Themekey CiviCRM' along with Themekey which worked for a while but doesn't anymore. Fixing that would be good but it seems a bit of a cludge. Isn't there a better solution for this common requirement? Or should I be using a webform rather than the contribution page?  I'm using 'Seven' as the normal theme for the back office functions, and don't want to use a different theme for ALL public pages as then CiviVolunteer pages are themed differently. On 4.7.24 and Drupal.


texts: Is there a way to email a link inviting people to sign up for an event that will be connect to their contact ID?

texts:
I have a list of people who I want to encourage to sign up for an event. I can send a link that allows them to update their contact information, using the contact hash. What I would like to do is send them a similar link that would create a new event registration for their contact ID. This would solve a couple problems:

Avoid duplicate contact entries from being created.
Auto-populate contact fields make the user experience more pleasant.

Am I missing a way to do this, or is there a way to implement it short of a new core feature?


texts: How to create a free Membership sign-up?

texts:
Can someone tell me the correct setup for a FREE Membership?
Cannot figure out what to check to get rid of the error "One of parameters (value: ) is not of the type Integer", which occurs after the second page.

Doesn't seem to be a way to do this with the word "contribution" everywhere and trying to set a price to $0 didn't work like some other posts listed.

Just want a clean membership page where joining is free and no hint of needing to contribute.


texts: I'm using the dummy payment processor for configuration development and demonstration purposes. I'm not doing any development of the actual payment process so find the fact that I have to put in all the details of billing name an address rather a nuisance. Is there an easy way to get rid of this? Has anyone done this and can point me at the code I need to comment out?


texts: Relationship type id stored in the wrong custom group column?

texts:
I made a custom group in a Relationship type. When I look back in MySQL table civicrm_custom_group I see that civicrm_relationship_type.id is stored in column civicrm_custom_group.extends_entity_column_value .

I am trying to write query that lists all custom groups in order to write an initialisation script. When doing a JOIN ON involving civicrm_custom_group.extends_entity_column_value, I discovered that is of type VARCHAR. I did not know that even with the MySQL CAST function it is impossible to use mixed types in a ON comparison.

Could it be bug that the id is stored in the wrong column? May be it should have been stored in column civicrm_custom_group.extends_entity_column_id ? That column is correctly of type UNSIGNED INT(10)


texts: WordPress - user record URL doesn't show for one user. Can't see why?

texts:
In the user detail view for a member with a WordPress account there's usually a link to the WordPress user record like so:

Contact ID / User ID   :   1354  / 1561

For one member the user ID doesn't appear and I'm stumped.

I've deleted and recreated both the Civi and WP records several times.
dumping the WP user record and toggling membership off/on does recreate the WP record (but doesn't show the link to it)
We use the profile sync plugin and this is working fine (i.e. name changes sync to wordpress profile and vice versa)

Digging through the template code shows the {$userRecordUrl} variable as the trigger for showing it or not, so I assume this isn't set somehow.

Has anyone seen this behaviour?

The user for whom it does work was created some time ago -- perhaps its functionality that is no longer present in 4.7? I can't find any documentation to support that though.

thanks!
- Chris


texts: Memberships ending a day early before auto-renew

texts:
I have an issue where all monthly auto-renew members expire on the day that they will be charged.  The payprocessor charges on the same day of the month that the membership was created. eg.  01/08/16, 02/08/16, 03/08/16 etc. but it may happen at 11pm....it's never the same time of day per customer.  This leaves the members in an expired state since Civicrm api job process_membership expires the membership on that same day, the "end_date".  I'd say that's clearly unwanted behavior for an auto-renew member!  Civi calculates the end_date by incrementing the month by 1. But the end_date should be padded by a day if a member is to get a whole month of uninterrupted membership.

Is there a way to define a month, or otherwise work around this within the UI?

end_date seems like an unfortunate choice for field name, since it falls within the date range of membership but apparently is definitely not being treated like the other days in that range.  IMHO, valid_through makes a lot more sense since it's more clear as to how it should be treated.

It seems like there are two options. 1) redefine the monthly membership period as month++ day++ or 2) reconceptualize end_date as valid_through and expire when that day is over.   Even though I think #2 makes more sense, I think #1 may be easier.  I've tested the daily member and it doesn't expire on the "end_date",...I'm thinking there's a check to see if the end_date is equal to the current date or start_date.


texts: Install CiviCRM alone or as Wordpress plugin?

texts:
I need your advice. What is the best ? Install CiviCRM alone or as Wordpress plugin ?

I have a wordpres website for a NPO, and I want to manage members with CiviCRM.

We are not big, and will manage approximately 100 members.

I would like to take registration for new members and cotisation (Paypal or Stripe).

There will also be fee-paying events, so I would like to make forms so that members can register for events and pay for them.

I'm afraid about integrate CiviCRM with Wordpress.I don't know if from a management point of view it wouldn't be better to have it separately.

What is your opinion on that?

Thanks a lot !