texts: Creating other relationships for memberships on behalf of an organization

texts:
Having trouble with memberships created on behalf of an organization that need a different relationship type than Employee of/Employer. I have a suspicion I'm simply approaching it the wrong way.

We have Individual and Institutional membership types. For Institutional memberships, there is a relationship type set of Designate of/Designator. The contribution form for purchasing Institutional memberships uses its own price set and price options set correctly to create that membership.

Included in this contribution form are the 'On Behalf of Organization' profile and the WordPress user account form.

When a new user purchases an Institutional membership the following get created:

New Individual contact (Contact A).
New Organization contact (Contact B).
A new Institutional membership for the Organization.
A relationship of Employee of/Employer between Contact A and Contact B.

Missing from these is the Designate relationship so that Contact A also inherits the membership. I'm not sure why this relationship isn't created despite the membership type requiring it.

The solution I'm pursuing now relies on implementing hook_civicrm_post in a plugin and doing some lookups with the API based on the membership object to create this relationship after the fact.

However it seems to be that nothing about Contact A (individual) who made the contribution on behalf of Contact B is available beyond the employee/employer relationship - which might exist for any number of other employees that are not the designate. I especially want to avoid this potential issue.

My expectation would be to find this in that particular Contribution object but no dice. Right now I'm thinking either getting Contact A's contact_id from the pre hook or from the form submission itself.

Is this behaviour a bug or am I missing an obvious setting? If not, surely there is a better way via the API?


texts:
Please can someone remind me how to create a CMS-safe URL in Smarty Templates?

Thanks


texts: Why are you allowed to set DB field length on Text fields?

texts:
I know the documentation says you should leave it the same, but suppose I know I want the text field to be only 3 characters every time?

I can set it fine in custom fields, but when I go to enter data, and a user mistakenly puts in more than 3 characters, it throws a database error. Is there somewhere else besides the custom field specification where I can set up CiviCRM to validate user input?

(note: this can be reproduced on the civicrm demo server)


texts: Guidance Needed on using CiviCRM API + PayPal to Complete Membership Contribution Payment

texts:
I'm at a total loss on how to make this work.

I am using the CiviCRM API to create a contact, create a membership for that contact, and even create a contribution if that person selects check, marking it to be paid later.

However, I cannot figure out how to pass a credit card through the API, using the PayPal integration to process the card payment and create the resulting contribution marking the membership as paid and active. None of the API resources have a parameter for card details that I could find, and I couldn't find anything on using the API to actually process payments.

Any tips? Thanks!


texts: Can I use a CIviCRM Webform URL in place of the required action.unsubscribeUrl?

texts:
I created a nice un/subscrube form using the excellent CiviCRM Webform module for Drupal. Now I would like to send mailings with CiviMail and include a link to my webform as the unsubscribe option.

However, CiviMail refuses to send my mailing unless I include the token action.unsubscribeUrl or action.optOutUrl in the content of my mailing.

What is the proper way to set my webform URL as my action.unsubscribeUrl?

Background discussion here. I realize there is a change that will be committed soon that will allow a token to exempt a mailing from this requirement. https://issues.civicrm.org/jira/browse/CRM-16062


texts: Could not create database trigger (AWS, RDS)

texts: How can I fix this issue about database trigger. I attached the screenshot for the info. Thanks so much for the help]1


texts: After Upgrade to 5.10 unable to close Case

texts: I get yellow screen with message as One of parameters (value: 2019-02-13 00:25:00) is not of the type Timestamp when i close the ongoing case. This use to work on 5.9.0 but recent upgrade to 5.10 stopped working. Any clue?


texts: How can I keep track of a "role" in an organisation (eg. secretary) over time (1980-1995)

texts:
Under individual contacts, I want to keep track of roles over time within my organisation's executive committee. So, every couple of years the Secretary, Treasurer, Chair, London Rep, Wales Rep etc etc. are newly elected.

I want to be able to record on a contact that they were the secretary from 1999-2001 for example, and then they were the chair from 2001-2004. I expect a full date will be used, but for simplicity we would usually just include the year, as most elections will take place at the AGM and therefore the same month every year. There are of course exceptions, where people resign mid-term.

I would also like to be able to record that they were the "X" role from 2016-present, and be able to display/view all the "Current" roles, based on them being "X" month/year to "present".


texts:
We are using CiviCRM 4.7 on Wordpress 4.4 in German Language and have switched the standard language to German. I have noticed that the country names are still in English.

Is there a specific reason for this?
What would be the correct steps to translate?
Do we need to translate manually all country names in the civicrm_country table?


texts:
Is there any way to group cases, other than using tags?
We currently need this for an implementation where case management is used to fulfill wishes for children with chronic diseases. The organization has cases where they need to organize events on a high level for a whole group of children (booking hotels, travel planning etc.) and do some of the planning individually per child with a very different set of activities (communication with parents, getting authorizations etc.). I feel that tags are not sufficient in this case and I would prefer to have a parent case with child cases assigned to it - or at least a group so we would have better selection options in the system. But groups are only available for contacts (?)


texts: Clean install on WordPress and blank dashboard

texts: After install on WordPress I am getting a blank dashboard and the "configure dashboard" button doesn't do anything. I tried deactivating all plugins except CiviCRM, that made no different. Any ideas what I should look at? All the settings seem to be correct.


texts: Using Wordpress Event Registration forms on Multisite

texts:
Thought this would help someone else.

I have one CiviCRM on a multi site installation and was obtaining "You do not have permission to access this page" when displaying a form on a second multi site.

This appears the second site doesn't have the anonymous role setup per:
https://civicrm.org/blogs/haystack/working-civicrm-46-wordpress

I will post the next post as the solution.


texts: Is it possible to integrate CiviCRM with a hosted VOIP solution?

texts: My company may be moving to a hosted VOIP solution.  I've been looking for a solution to integrate a VOIP system with CiviCRM but it appears that this is still under development and no solution is in place at this time.  Is it possible to integrate a VOIP system with CiviCRM?  I'm looking to automate creation of an activity and update fields with call data.  I assume a browser plugin could handle the click to dial portion but Im unsure.  Any help is appreciated.


texts:
I am trying to import multiple participants from a CSV file into Civi as event participants. I am running into an issue when I go to match the required fields. I keep receiving an error because the Participant Status ID doesn't match.

This is a historic event I am trying to enter from another database, so I don't believe we have a match for this field. Is there a way to get around this?

Most of the constituents are already in Civi and have an external identifier from the past database. I now just to update their record to note that they attended the event.


texts: Is there a way to integrate CiviCRM with Ticketspice.com and other Event ticketing platforms like Eventbrite?

texts:
We're on Civi 4.6.17 and Drupal.

We're using ticketspice.com for an Event ticketing page, mostly because I have not figured out a way to create an Event registration page in Civi using the Discount codes extension. Our Ticketspice event registration page is here.

Has anyone created an integration between Ticketspice event pages and CiviCRM, or Eventbrite event pages? I have not had a chance to check out either the Ticketspice or Eventbrite APIs or webhooks.

UPDATE: We're using Authorize.net to process payments for tickets purchased on the Ticketspice event page, and it seems like there should be a way to pull in that data from Authorize to Civi. We also use the same Authorize account to process contributions, event fees/tickets made through Civi pages and price fields.


texts: CiviMail link to view in browser gets error on mobile

texts:
End users received a mailing today, our first one on 4.6.3.

Desktop and laptop clients can follow the link, but tablets and cells get errors that the link can't be opened.

Link appears to add email or inbox before the url on those clients.

Worked up until the current version.  No changes to header template.

When you click on the link on Android devices they get:

Webpage not available
The webpage at email://18975 might be temporarily down or it may have moved permanently to a new web address.
Suggestions:
•   Make sure you have a data connection
•   Reload this webpage later
•   Check the address you entered

On IPhone, the link acts as if nothing's been clicked.

When you click on the link on Windows phone you get:
This link can't be open from an email message.
Link looks like: inbox:"correct url" (with quotes)

Links not in the header template work appropriately.


texts: State/Province display for a contact shows a number instead of the name for Vietnam contacts

texts:
Most of my contacts have Vietnamese addresses. When I enter the name (organization or individual), I see the correct name for the Vietnamese provinces in the list and choose one. When I view the contact details, the name of the province displays as a number (the id, I presume) instead of the name.

I have reported this several times on the old forum but never got a solution to the problem.


texts: System status notice about option value 0 in number field

texts:
I'm getting this System Status notice:

The Following Option Values contain value fields that do not match the Data Type of the Option Group

It references an option group with 0 as one of the values. The group is used for a custom field of type Number. I went into the mysql database and saw that the option group had type String, so I changed that to Integer, also tried Float - nothing got rid of the error.

Is it a spurious error due to a bug or am I not understanding something about how option groups and values work?


texts: Replacement for deprecated CRM_Core_OptionGroup::getValue

texts:
I noticed that CRM_Core_OptionGroup::getValue is deprecated - though still used fairly extensively in the codebase. It is noted that values are not cached.

Presumably the preferred function is CRM_Core_PseudoConstant::getKey, but this function actually seems to be slower? What are the advantages of this over the deprecated function?


texts: Can Drupal be used to send an email if an existing contact's name is changed

texts: I'm wondering if it is possible to use the Drupal Rules module with CiviCRM Entity to send me an email when, for example, someone has taken an action (like made a donation) that updated the contact record and (for example) changed their first name. I can see a trigger "Before updating a civicrm contact" that then offer "Changed" and "Unchanged" values which could be compared (Condition: data comparison) but, that trigger does not seem to work? Any ideas?


texts: Contribution Error: "failed to update contribution in database"

texts:
UPDATE. I'm not posting this as an answer since it provides none. When 5.34 became available, I tried an update on this site and the problem went away. I guess there was an issue with 5.33.2. I'll likely never know.
Weird situation. I have just upgraded to CiviCRM 5.33.2 and Stripe 6.5.6 on Wordpress 5.6.
When I test a Contribution after the upgrade, I get an on screen error saying "Failed to update contribution in database".
I reviewed the logs for clues and found nothing very useful. The Apache error log is clean and the Civi log (even with debugging on) reports only
Jan 21 14:59:56  [info] Contribution record updated successfully
Reviewing Stripe directly shows a successful (test) payment and CiviCRM shows the same.
I have tested a single live payment just to see if there is any difference. It behaves the same way as the test payments (as it should).
The only additional clue I am receiving is that no email is received either. However, testing the outbound SMTP settings returns success and the test email is received.
Any thoughts on where to look for clues?


texts: Activity Report does not allow grouping by custom fields

texts:
Using CiviCRM 4.6.4, I am trying to update the activity report to include the custom fields from the contact form.  By using the following code they show up in the list but does not allow sorting on the custom fields.

protected $_customGroupExtends = array(
  'Activity', 'Contact', 'Organization');
protected $_nonDisplayFields = array();
public function __construct() {

 $this->_autoIncludeIndexedFieldsAsOrderBys = 1;

Here is the error
DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'value_client_project_definition_3_civireport.corridor..."

If you open the activity report then go to sorting and select one of the displayed custom fields that is added by adding the following code to the report.
$this->_autoIncludeIndexedFieldsAsOrderBys = 1;

The DB error is generated.

Thanks in advance


texts:
All,

Scheduled reminders worked last year, but are not working this year.

I had made some changes to the Outbound Mail settings, but a) I set these back as they were and b) test emails come through just fine.

To sidestep the issue of 'day before membership end date', I entered today's date. When I manually executed 'Send Scheduled Reminders', the system reported that the job had completed, but no emails were sent and no errors were logged.

I just learned that things are not quite as 'simple' as I had hoped: At least one person received the reminder that I manually sent, but at least one person did not. I am among the 'at least one who did not' and I know that there are absolutely no email filters on the recipient side - so what happened?


texts: Registration Pages for individuals and Organisations

texts: How can I create new registration pages for individuals or organisations using the default CiviCRM forms?


texts: How to pause, cancel or delete a scheduled CiviMail mailing

texts:
I suspect I'm missing something obvious here... but I've just spent 30mins googling without success.

So... if you've scheduled a mailing in Civicrm, how can you pause, delete or cancel it?

On the main search screen for mailings, https://druyoga.com/civicrm/mailing/browse/scheduled?reset=1&scheduled=true, you can search for various mailing statuses, including paused and cancelled.

But I can't see a way to change a mailing's status to cancelled or paused.

Thanks for any ideas.

We're using drupal 7.54 and Civicrm 4.6.24


texts: How do I use cv to run database upgrades from the command line?

texts:
I'd like to run the database upgrades from the command line. I know I can do with with drush civicrm-upgrade-db but I'd like to know a way to do it in a CMS-agnostic way (that will work for Wordpress and Joomla).

I see there is cv ext:upgrade-db which claims to "Apply DB upgrades for any extensions". Is there a corresponding cv command for CiviCRM core?


texts: CiviContribute: change "from" email address for thank-you letters

texts:
I'm using CiviCRM 4.7.27 and am trying to change the "from" address used for thank-you emails generated from CiviContribute. The workflow we are using apparently has no option to choose the email sender and the emails are sent with a "from" address of the current CiviCRM user! NOTE: This workflow is not from the "Mailings" menu. The procedure I am using is:

Search for contributions from the menu: Contributions -> Find Contributions
Select search options (typically: select "No" for the "Thank-you sent?" option to find all contributions that have not been acknowledged with a thank-you letter). Click "Search"
Select all found contributions by clicking the check-box next to each one
Select "Thank-you letters, print or email" from the "Actions" menu. This leads to the "Print/Merge Document" screen
Select "Send emails where possible. Generate PDFs for contacts who cannot receive email" from the "Print and Email Options" selector. Also select the "thank you letter" template and click "Make thank you letters". NOTE: There is NO option to select the email sender from this page!

Result: email is sent, but the "from" address is the email address of the current CiviCRM user!

Is this a bug or am I missing something? I see that from the "Mailings" menu, I can create a mailing and select the "from" email address. However, there doesn't seem to be a Mailings workflow which allows me to send a tailored thank-you to donors who have not been acknowledged.


texts: how can I create an hook when external id change

texts:
I would to ask you , on how can create an event (programatically) when I change the external ID in contact form, how can I t make some kind of process like validation in another module or service I know I can create something like a hook but I dont know how to start working with hooks in civiccrm, is there any document, book ,link, video, note where I
can learn about it? I would really appreciate this, thank you in advance.


texts:
I have a series of different memberships in CiviCRM, currently with yearly billing for each. Each membership is currently set to auto renew.

The client has requested that a client might pay for these memberships monthly, or quarterly or yearly. I've looked to change the membership to a monthly membership, and using pricesets, enable 3 and 12 months as number of terms.

Unfortunately, as the membership is set to auto renew:
"You can include auto-renew membership choices for only one price field in a price set. Another field in this set already contains one or more auto-renew membership options."

The auto renew functionality has been turned on, as the memberships are set to continually renew but not use a payment processor. The records are being exported to another system, which generates the invoices.

Do I need to create monthly, quarterly and yearly options for each membership? Is there a better way to create the one membership, but have flexible pricing options which keep renewing after every period.

Since posting this question I found there is a bug in 4.6 and 4.7 of CiviCRM where you can't create a membership with auto renew in a price set - no matter what - not even one. This should be resolved in 4.7.5 (with about two lines of code). This allows you to keep a single membership and have different renewal periods at the same time.. and keep the reporting simplified, so the membership reporting will continue to show one membership.

https://issues.civicrm.org/jira/browse/CRM-18050
//If price set field is already present with auto-renew option then, it will restrict for adding another price set field with auto-renew option.
if ($dao->N == 0)
{ return 0; }


texts: How to split contribution page into tabs

texts: I would like to divide my contribution page into tabs: intro + priceset, payment information, submit section. How can I do that?


texts: Assign two different emails for two different groups (but only one contact)?

texts:
Is it possible for one contact to subscribe to two different groups with two different emails – or will CiviCRM always send email to the primary email address?

IOW, is this possible?:

Robert Smith has two emails and is subscribed to two groups:
1. Group A sends to robert.smith@work.com
2. Group B sends to bob@home.com


texts: Critical - contributions pages w/o monetary transactions or price sets don't save contributions but show confirmation page

texts:
I have a contribution page that's used to solicit in-kind donations. On the Amounts tab, Execute real-time monetary transactions is disabled, no Price Set is selected, but the Allow other amounts box is checked.

On attempting to submit this form, I get this notice:

messageNotice: Undefined variable: contribution in CRM_Contribute_BAO_Contribution_Utils::processConfirm() (line 378 of /srv/buildkit/build/d46/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution/Utils.php).

And no contribution is saved. This behavior is replicable on the 4.6 sandbox (http://d46.demo.civicrm.org).

Regarding the error message, $contribution is not set because $form->_contributeMode is null.


texts:
I am trying to limit access to reports using acl/groups as mentioned in the userguide :

https://docs.civicrm.org/user/en/4.7/reporting/set-up/#define-report-settings

However, the field to set this does not appear.

Is there something i have to configure to make this appear? Or does this functionality no longer exist?

If relevant I am already using acl for controlling access to custom data sets.

Running civicrm 4.7.17 on wordpress 4.7.3 using php 7.0.15

UPDATE 1:

looking through the code it seems that the following code (found in /wp-content/plugins/civicrm/civicrm/CRM/Report/Form/instance.php) is causing it not to appear:

if (function_exists('user_roles')) {
        $user_roles_array = user_roles();
        foreach ($user_roles_array as $key => $value) {
          $user_roles[$value] = $value;
        }
        $grouprole = &$form->addElement('advmultiselect',
          'grouprole',
          ts('ACL Group/Role'),
          $user_roles,
          array(
            'size' => 5,
            'style' => 'width:240px',
            'class' => 'advmultiselect',
          )
        );
        $grouprole->setButtonAttributes('add', array('value' => ts('Add >>')));
        $grouprole->setButtonAttributes('remove', array('value' => ts('<< Remove')));
      }

For some reason the 'user_roles' function does not exist.

So when the below code is run (found in /wp-content/uploads/civicrm/templates_c/en_US/%%48/48E/48E22AAC%%Instance.tpl.php) the php returns nothing:

        <?php echo $this->_tpl_vars['form']['grouprole']['label']; ?>

        <?php echo ((is_array($_tmp=$this->_tpl_vars['form']['grouprole']['html'])) ? $this->_run_mod_handler('crmAddClass', true, $_tmp, 'huge') : smarty_modifier_crmAddClass($_tmp, 'huge')); ?>

UPDATE 2:

looking a little higher in instance.php it looks like this might not be for wordpress even though this section still runs:

if ($config->userFramework != 'Joomla' ||
      $config->userFramework != 'WordPress'
    )

still unsure of why 'grouprole' doesnt exist for the other code though:

        <?php echo $this->_tpl_vars['form']['grouprole']['label']; ?>

        <?php echo ((is_array($_tmp=$this->_tpl_vars['form']['grouprole']['html'])) ? $this->_run_mod_handler('crmAddClass', true, $_tmp, 'huge') : smarty_modifier_crmAddClass($_tmp, 'huge')); ?>


texts: User access to own contact record, forwarding upon login

texts:
Is there a document that describes how best to setup the security in CiviCRM on WordPress so that a user can login and access their own record? I have read much of the documentation that is in the forum and in the help but nothing that seems consistently in one place from step to step.

The part that seems to be missing is how to forward the person logging in to their own record, rather than to a page where they have to search or find their record. I'm not a programmer so I am assuming this must require some code that I can't find reference to. Any links anyone can share?


texts: Detail instructions on manually updating message templates (5.9.0 to 5.10.4)

texts:
We just updated our CiviCRM (Wordpress) from 5.9.0 to 5.10.4. Prior to the associated database upgrade, I got this message about having to upgrade our customized message templates. I screen copied the text but don't have the link to the "detailed instructions."

Any idea on where I would find those instructions?


texts:
I want to insert a contact image into a message template. This will be used to print PDF "info sheets" about contacts to include their photo.

Simply inserting the token {contact.image_URL} of course only displays the image URL in the PDF.

If I use something like  <img src="{contact.image_URL}" width="100" height="100"> I get a missing image icon. I have tested with contacts that do have contact images.

How can I go about this?


texts: Receiving an error when synching CiviCRMmember role and Drupal role

texts:
I'm running into an issue where I receive an error message when attempting to setup and manually sync CiviCRM Membership with Drupal Roles. I receive the following error message:

Error message
There was an error. CiviMember Memberships and Drupal Roles could not be synchronized.

When I attempt to import the syc rule in Drupal I receive the following error message:

Error message
Integrity check for the imported configuration failed. Error message: Unknown action civicrm_entity_action_create_user..

Any insight to what I may be missing would be greatly appreciated.


texts:
I am trying to extend the MembershipView.tpl which look like the image below. I have created an extension and added a MembershipView.extra.tpl file to my extension folder and placed it in Template>CRM>Membership>Form but the contents I have placed inside wont show in the membership view template.

Contents of my MembershipView.extra.tpl

{literal}
<script type='text/javascript'>
alert(5);
</script>
{/literal}
testing this text here

Thanking you

Imran


texts: How to hide configuration tabs of a report with the "print to pdf" action remaining active?

texts:
I want a category of users can access some reports, view the results on the screen and print them to PDF.
And to prevent any modification of the criteria, I want all the report configuration tabs to be hidden.

This is done by this users role having the permission “access CiviReport” enabled but the “access Report Criteria” one disabled.

But when disabling the “access Report Criteria” permission, the "Print report" and "Print to PDF" actions become inactive.

Is there any way to get what I want ?

Thanks for help.


texts: What is the best way to add a contact to existing membership using relationships?

texts:
I'm having trouble with adding additional contacts to memberships (CiviMember). The goal is to add spouse, partner, sibling, etc. to an existing membership. The membership type is our own custom type, Household (not the contact type), and I guess I should have set a relationship type when I created it. I can't change the relationship type now; the UI blocks this since the type is in use.

The book's description for this is extremely terse and I can't understand how relationship type works, I have no idea what to expect, it's all cut-and-try. A working example would be great if one exists somewhere.


texts:
On a Drupal 7.72 / CiviCRM 5.25.0 / Webform CiviCRM 5.23 / Webform GDPR 5.XX (fork fromhttps://github.com/veda-consulting-company/uk.co.vedaconsulting.gdpr), I'm getting this message in log:
Error : Class 'CRM_Gdpr_SLA_Utils' not found dans WebformGdpr::getDefaultUrls() (ligne 157 dans /var/www/drupal/web/sites/all/modules/webform_gdpr-5.x/includes/webform_gdpr.inc).

I compared with a clone site and even if everything seems set exactly the same way, I don't get this error.
I understand that it is looking for an URL for the Data Policy which is also set in the plug-in.
Has anybody already been confronted to this issue?


texts: Reason column missing from contact import error list

texts:
After importing a CSV file of contacts, the rows with errors can be downloaded and fixed. Today I noticed that the "Reason" column is missing from this error list. For example the Import_errors.csv file might contain this:
    "Line Number","Reason","First Name","Last Name","Email - Home"
    "1","Joe","Blow","joe@example.com"

So in this example there are 5 column headers but only 4 data elements. That is consistently how these files appear, one column is missing. This is Civicrm 5.35.1 on Wordpress 5.7.1. Any ideas?


texts: Error "Select at least one membership option" when adding a membership with a price set

texts:
I'm new to CiviCRM. my version is 4.6.8

The problem happen when I try to add a New Membership.
I have the following:
Membership Organization and Type    "Organizzation-NAME" - "select" OR "chose price set"

Select Membership Organization and then Membership Type. Alternatively, you can use a price set.

Well When I did not select a Membership type but I chose the price set and add one or more types I can't save because I receive the following message:

Please correct the following errors in the form fields below:
Select at least one membership option.

Please help
Thanks


texts: How to search for emails "on hold opt out" and not "on hold bounce"

texts:
We experienced a severe network problem across many ISP's this week that resulted in a bunch of email non deliveries. I now have many email addresses marked as on hold, I think because of the unusual network problems. I want to unhold these addresses, but do not want to unhold emails where addressees opted out.

Is there a way to search for emails that are on hold because of bounces, and not because they opted out. (alternatively can I search for emails that are on hold because of an opt out, and not because of bounce processing).

Thanks
Davy


texts: Drupal views integration ContactID inserts commas into number

texts: Within Drupal Views integrations creating a view of contacts, the Replacement Pattern "[id] == CiviCRM Contacts: Contact ID" inserts commas when a contact_id is greater than 999 - surely this is incorrect behaviour? Does anyone have a work around for this?


texts: How to Add Menu Item to Parent Using Civix

texts:
I'm trying to add a menu item for my extension to the existing "Memberships" menu. The documentation suggests the following:

  Use the Civix implementation

  Civix comes with helper functions
  _EXTENSION_NAME_civix_insert_navigation_menu and _EXTENSION_NAME_civix_navigation_menu that simplify the process of inserting menu items. Consider using these functions rather than using
  the examples below or writing your own implementation of this hook.

What it doesn't do is give you any clue how to do this. I found an example here: https://github.com/totten/civix/blob/master/UPGRADE.md.

Regardless, there is no info on how to actually add a menu item to an existing menu using this method.

Could someone please enlighten me on how to use the civix method to add a menu item as a child to an existing menu?


texts: create webform that allows user to create either 1, 2 or 3 activities depending on user selection

texts:
I've created a drupal web-form that creates a household and 3 activities (each an activity type "referral" assigned to different department).  I've also created conditional formatting to only show the activity details activity details for referrals to the departments that have been selected.  So far so good.

The problem i'm facing is that there are always 3 activities created.
If, for example the user selects only that a new household should only have a referral only to departments 2 & 3 (ie. not to dept 1), i only want to create 2 activities, but 3 activities are created.

I think this is because in the webform-civicrm tab i've created three activities with the household members assigned.  Is there a way to have a variable number of activities created?


texts: Uploading from CSV with first and last name in the came column

texts:
I am uploading lots of CSV files and using addressee and addressee custom it will skip the first and last name and leave me to do it manually.

edit: while renaming i realized I derped and addressee is something else.

Is there anyway to get first and last names separated from one column


texts:
I'm setting up CiviCRM for an animal charity organisation. Beside some problems to set up animal master data derived from an individual (e.g. animals usually don't have last names, etc.), I'm stuck with certain events which are related to both an individual and an animal (e.g. adoption or handover):

I wanted to create relations for such events, but I need to add further data to such relations, e.g. for the event "handover" the contract date, date of handover, reason for handover, and other.

Is there a way of storing such data assigned to an event, and assigning this event to both an individual and an animal? Relation doesn't seem to fit such a need ...

Regards

Bernhard


texts: Troubleshooting SELECT Privileges Issue with Drupal 9 Views Integration

texts:
I'm having an almost identical problem to this person (https://www.drupal.org/project/civicrm_entity/issues/3198146) so I'm hoping to get an answer for both of us.
It looks like this may also be the same issue.
I have a Drupal 9/CiviCRM install set up on a shared hosting account on A2Hosting. Everything has gone smoothly so far, and I was able to follow the Views integration instructions exactly.  However, when I try to set up a simple View to test, I get the following error:
SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user '<USER>'@'localhost' for table 'civicrm_contact': SELECT "civicrm_contact"."id" AS "id" FROM {civicrm_contact} "civicrm_contact" LIMIT 11 OFFSET 0; Array ( )

The error seems pretty self-explanatory - I need to assign SELECT privileges to the  in question - but I've tried everything I can think of, namely:

I've given the USER in question ALL PRIVILEGES on the CiviCRM database in cPanel. I can't access the User list via phpMyAdmin, which I guess is common on shared hosting.

I've tried to use the command line to check the status of the USER's privileges, but I apparently need root access, which is not possible on the shared hosting plan.

I've contacted A2Hosting directly to see if they can help check (or correctly assign) the
privileges for the USER in question. They say they can't.

So, I have a few questions that I'd love help answering (I'm a relative beginner at all of this):

Is this a known issue? There are at least two of us now who've been stumped by it. Is there a quick fix I'm not seeing?

Are the USER in cPanel and USER@localhost different entities? Is it possible that they would have different privileges?

If Views integration is somehow not possible in a shared hosting environment, what is the preferred set up?  Am I on the wrong hosting service?


texts:
I have a search result of activities tagged with a certain activity-tag.

How do I untag them, without updating each single activity?

CiviCRM version 4.4


texts: Can't create new mailing. Gets stuck on "Initializing..."

texts:
I am using civiCRM on Wordpress.
I have configured my SMTP settings correctly as far as I'm aware. The test email sent fine.
But when I got to 'Mailings' > 'New Mailing' it says 'initializing...' and stops there.
Any ideas on how I can create a new mailing?

When I look at 'Draft and Unscheduled Mailings' I see a bunch of unscheduled mailings that haven't worked.

N.B: I commented out this block after following the advice of this thread: http://forum.civicrm.org/index.php/topic,24242.0.html

I am using Bluehost hosting and  mail services. CiviCRM 4.6.2

I have tried everything in this post: http://forum.civicrm.org/index.php/topic,35850

Here's the error I get in the console:

TypeError: CRM.addStrings is not a function        angular.js?r=NBb6p:11655
    at all.js?r=NBb6p:44
    at Object.forEach (angular.js?r=NBb6p:331)
    at httpSuccess (all.js?r=NBb6p:39)
    at angular.js?r=NBb6p:9408
    at processQueue (angular.js?r=NBb6p:13248)
    at angular.js?r=NBb6p:13264
    at Scope.$get.Scope.$eval (angular.js?r=NBb6p:14466)
    at Scope.$get.Scope.$digest (angular.js?r=NBb6p:14282)
    at Scope.$get.Scope.$apply (angular.js?r=NBb6p:14571)
    at done (angular.js?r=NBb6p:9698)

Thanks for your help


texts:
Does anyone know how I can turn off this improvement?
https://issues.civicrm.org/jira/browse/CRM-11761

Save user preferences for filtering Activities tab listings
The requirement is to persist the last used values for the two activity type filters on the contact Activities tab => "Filter by Activity Type" form (activity_type_filter_id and activity_type_exclude_filter_id) for the logged in user.
The filter values would need to be saved onChange since there is no search form POST, and loaded from the DB when that tab is accessed.

It's causing a lot of problems for users


texts: CiviCRM Entities module makes error 500 to site

texts:
I'm doing a drupal installation 7.56 with CiviCRM. When I install the CIVICrm Entity module the site starts getting error 500.
DOes anyone knows what to do?

best regards
Eduardo Catarino


texts: How can I customize the default gear icon on a custom tab set?

texts:
Now that there are icons on all the tab sets (awesome, btw) - I'd like to change the standard gear icon that appears on any custom contact field sets that are set to display as a tab. I didn't see anywhere in the interface that I could select a fa icon to use.

I know the hook_civicrm_tabset can be used if you've added a tab as part of an extension, you can just include the 'icon' => 'crm-i fa-yourchoicehere' line in your array. But I'm wondering how to apply that to an existing tab set.


texts: How do I fix error with the new (4.6.0) Drupal views image handler for CiviCRM contact images

texts:
Just upgraded to 4.6.0 and now I see that the CiviCRM Contact Image field in Drupal views now uses the views image handler! Awesome! Prior to 4.6 it was just a string containing a URL to the image. Thanks to @Shawn Duncan for his efforts and contribution.
However, I can't get it to work. The image URL it produces gives a 404
Example URL that returns 404:
http://example.com/sites/example.com/files/example.com/civicrm/contact/imagefile%3Fphoto%3Dmbd_logo_01cf3f5560578c6554b9ba009f6b42b7.png
But the actual working URL to the file is:
http://example.com/sites/example.com/files/civicrm/custom/mbd_logo_01cf3f5560578c6554b9ba009f6b42b7.png
So it's inserting an extra example.com after the /files/ and it's using this /contact/imagefile%3Fphoto%3D instead of the actual path to my custom uploads.

[Edit]
Using Drupal image presets is broken in 4.6 since at least 4.6.6; if you select an image style in Views, it mangles the URL to something like
<img typeof="foaf:Image" src="http://styles/medium/http/example.org/civicrm/contact/imagefile?photo=bsglogo_49524b829beb4448767ee75a42f2dcc0.jpg&amp;itok=dGLXdcig" width="220" height="220" alt="" title="">
Is there a suitable workaround?


texts: Parent group isn't counting contact in child groups

texts:
In the WordPress demo site I just create a group called parent_01 and a child group inside this one called child_01.
I create a contact called test1 and added to child_01 gruop, but in the Manage Groups screen the parent group has 0 in the count field
Is this a correct behaviour?


texts: Is there integration for CiviContribute Partial Payments

texts:
I like using pending transactions and then recording partial payments under the contribution instead of using pledges and payments the reasons are as follows:
1. civi contribute is much more used and therefore better developed and has better integration with drupal views etc.
2. I am dealing with many dedications that are set amounts and many people pay them in installments and many pay the full amount in once. I would like to go to one place to see data on both (I can create a pledge for every donation even if its paid all in once, and look at pledge data but that's annoying. and does not work well with views)

the problems with partial payments are as follows:
1. Most of the contribution reports don't deal with the actual partial payments but just with the main contribution
2. thank you letters only look at the entire contribution and not the partial payments
3.any reports don't look at the dates of the actual payments but just look at the "date received" of the main contribution contribution
4. if you make a mistake in a partial payment and record the wrong amount or the full amount due there is no way to delete a partial payment

if anyone has any advice please let me know


texts: "Unknown path" when viewing a newly generated angular page

texts:
I'm trying to get started learning how to make Angular pages within a CiviCRM extension so I ran civix help generate:angular-page and read some help text about an example. Cool.

Then I ran civix generate:angular-page EditCtrl about/me to follow the example in the help text.

I browsed to /civicrm/a/#/about/me and expected to see some of the content shown in my newly generated EditCtrl.html file.

Instead I saw a page with an error message "Unknown path".

How can I view the angular page that civix generated?


texts: I get a WSOD when I use the search function on CiviCRM

texts:
CiviCRM was working fine until I downloaded an extension called CiviRules. I looked into the API for field UFMatch, clicked around in there, and pressed execute (got no warning that it was going to change anything in the database, so I just assumed that it was running a test) and it resulted in no errors supposedly.

I also can't delete the extension, it sends me to an HTTP 500 error. Whenever I input a string search, it gives me a drop menu of contacts with matching strings but when I want to get a list of all the contacts in the database, it takes me to the WSOD!

What can I do to try and fix this?

Edit: it looks like any time I search for something (e.g. contributions, events, participants, contacts etc.), it takes me to the WSOD.

Edit 2: I'm using CiviCRM 4.6.37 and Drupal 7.59. And I'm not sure if it was actually CiviRules or clicking something in the API Explorer... I downloaded CiviRules extension first before I played around with API Explorer. My reasoning for poking around API was to see if there was some way to link/unlink user IDs with CiviCRM contacts and reuse a general username/account for changing members. Hopefully that makes sense! :-/

Edit 3: Problem is fixed. IT support at my organization’s end conquered the WSOD. Lesson learned: don’t mess with API if you don’t know what you’re doing.  ¯_(ツ)_/¯

Thank you all for your responses!


texts: why is the message templates permission removed on the Drupal demo site?

texts: I am trying to check the message templates(system workflow messages) on the Drupal demo site but i get access denied. Has it been disabled on purpose?


texts:
This is super strange. We've tried the latest CiviCRM 4.7.10 clean installed on BOTH the latest Wordpress AND Drupal 7.50 and in both installations, going to Administer > CiviCase > Case Types results in a BLANK page titled simply "CiviCRM" (not "Case Types" as you'd expect) with the surrounding CiviCRM blocks, header and menu. This Case Types page seems to be the only one affected.

The issue produces no network or console errors in either Chrome dev tools or Firebug. Turning on all the debug & backtrace options of CiviCRM and Drupal devel also results in zero reported errors, but the Case Types page refuses to work. I've also tried disabling all browser extensions in case one was injecting HTML and screwing things up.

I've found a few reports of something like this but none were relevant or provided solutions that worked in my particular cases.

AJAX problem in CiviCase - Administer Case Types

EDIT: When I install exactly the same codebase on my local dev environment then the Civi Case Type page works as expected, so it's possibly an incompatibility with the remote server software but still very strange that I'm not seeing any error messages anywhere.

EDIT 2: PHP and MySQL are newer on the remote server than on my local. Also, the only difference I can see in the installations between my local and the remote server are that in my local I used a single database for both civi and drupal, whereas on the remote I used separate databases. But I'm not sure how that would make any difference.

EDIT 3: Compared network activity between non-working remote and working local and discovered this difference - the remote server is responding with 302 instead of 200 for the query rest?entity=CaseType& ...:


texts:
On Drupal 7 / CiviCRM 5.36.1 I have a smart group that I export with a special mapping mixing data coming from relationships for each contact.
I can use the url : https://domain.net/civicrm/group/search?force=1&context=smog&gid=20&component_mode=1 to access the results and export them but there is no action to send a kind of report.
I would like to get an email once per day with a .csv file.
Is this possible? How would you do this?


texts: Can you create an event with Webform-CiviCRM integration?

texts:
I know you can register for an event - but can you create an event?

In my use case, there are users whose job is to coordinate an event series who don't otherwise need to interact with CiviCRM.  It would be great to allow them to create events without interacting with the Civi UI.


texts: Copying the CiviCRM installation in a different machine

texts:
I am trying to make a copy of my CiviCRM installation on WordPress in a different machine. I ma mainly trying this just as a practice for future upgrading of CiviCRM versions and also as a backup.
I am caught up in a deadlock. both these options are failing. I don't which of the two options I should proceed with and how.
In machine 2,

I installed wordpress. created a database for Civicrm through PHPMyAdmin. copied the data from original database to new one. Activiating CiviCRM fails.

I installed wordpress. created a database for Civicrm through PHPMyAdmin. Activated CiviCRM. Tried copying the data alone from original database to new one. It fails with below error " Duplicate entry '1' for key 'PRIMARY'"

INSERT INTO civicrm_acl (id, name, deny, entity_table, entity_id, operation, object_table, object_id, acl_table, acl_id, is_active) VALUES
(1, 'Edit All Contacts', 0, 'civicrm_acl_role', 1, 'Edit', 'civicrm_saved_search', 0, NULL, NULL, 1),
(2, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'access CiviMail subscribe/unsubscribe pages', NULL, NULL, NULL, 1),
(3, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'access all custom data', NULL, NULL, NULL, 1),
(4, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'make online contributions', NULL, NULL, NULL, 1),
(5, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'make online pledges', NULL, NULL, NULL, 1),
(6, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'profile listings and forms', NULL, NULL, NULL, 1),
(7, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'view event info', NULL, NULL, NULL, 1),
(8, 'Core ACL', 0, 'civicrm_acl_role', 0, 'All', 'register for events', NULL, NULL, NULL, 1),
(9, 'Core ACL', 0, 'civicrm_acl_[...]
MySQL said: Documentation
1062 - Duplicate entry '1' for key 'PRIMARY'


texts: Hyperlink not working within CiviCRM emails

texts: When I send an email on CiviCRM, and want to add a hyperlink (to a webpage for example), I've had responses from those I sent it to that the link doesn't work. I've followed the hyperlink button on the formatting tab above on emails so would like to know if there is anything else I should be doing. Thanks


texts: Who is 'backup_Mk047aB'@'%' from the error 'The user specified as a definer ('backup_Mk047aB'@'%') does not exist'

texts:
While the back-end is working - e.g. I can add fields to profiles, etc. -, I see form data perfectly fine when calling pages, I cannot modify or add contacts resulting in

Sorry but we are not able to provide this at the moment. DB Error: unknown error

The log shows the following:

#6 /*/wordpress/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(895): DB_common->raiseError(-1, NULL, NULL, NULL, "1449 ** The user specified as a definer ('backup_Mk047aB'@'%') does not exist")

Searching the CiviCRM database - I cannot find a reference to a user called "backup_Mk047aB" (not anywhere in Wordpress databases either).

A previous post notes that

  You will get more details in civicrm log file (*/file/civicrm/ConfigAndLog). Also the main reason of this type error is, we are using few fields that are disabled. check custom fields status that are using for contact. see here

I then tried using my webpage form and populated all available fields of all profiles and then get

Database Error Code: The user specified as a definer ('backup_Mk047aB'@'%') does not exist, 1449

Additional details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )
[code] => -1
[message] => DB Error: unknown error
[mode] => 16
[debug_info] => INSERT INTO civicrm_value_eda_individual_characteristic_2  ( name_of_affiliation_10,address_line_1_11,address_line_2_12,entity_id ) VALUES ( '','Henriette','',2 ) ON DUPLICATE KEY UPDATE name_of_affiliation_10 = '',address_line_1_11 = 'Henriette',address_line_2_12 = '' [nativecode=1449 ** The user specified as a definer ('backup_Mk047aB'@'%') does not exist]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_value_eda_individual_characteristic_2  ( name_of_affiliation_10,address_line_1_11,address_line_2_12,entity_id ) VALUES ( '','Henriette','',2 ) ON DUPLICATE KEY UPDATE name_of_affiliation_10 = '',address_line_1_11 = 'Henriette',address_line_2_12 = '' [nativecode=1449 ** The user specified as a definer ('backup_Mk047aB'@'%') does not exist]
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_value_eda_individual_characteristic_2  ( name_of_affiliation_10,address_line_1_11,address_line_2_12,entity_id ) VALUES ( '','Henriette','',2 ) ON DUPLICATE KEY UPDATE name_of_affiliation_10 = '',address_line_1_11 = 'Henriette',address_line_2_12 = '' [nativecode=1449 ** The user specified as a definer ('backup_Mk047aB'@'%') does not exist]"]
)

Although I've been back-upping my site - this error just came along...

I'm lost und would love to meet user:backup_Mk047aB - any ideas!?


texts:
Background

We're a membership association for music groups, and are in the process of building our new website, using Civi as both the CRM and for some of the functionality, events etc., of the website (along with Drupal).

Challenge

We would like to try to find a way (in the future) to offer group management tools (e.g. simple contact lists, civicontribute for fees and events etc.) to our members themselves.

I don't think that this is currently possible with Civi, as it would need two levels of data structure, i.e...

Our CiviCRM/website interface: organisations with contacts, payment processes and membership management etc.
Members' CiviCRM/website interface: THEIR own contacts database, THEIR own payment processes for THEIR own membership subscriptions etc.

..but I wondered if anyone has ever tried or thoguht about trying something similar?

Apologies if this is a stupid question, but I'm relatively new to Civi, so not sure what whizzy-amazing functionality might be possible.


texts:
Up until recently, the cron job I had set up was running correctly and the Scheduled Jobs were being run. However, since I upgraded (currently running 4.7.21) I am now getting an error message that the cron job isn't running. I made no changes to the cron job. BUT when I check the log, it says the job has been run although it doesn't appear that the task was done. I have Joomla 3.7.4.

The Error message is
System Status: Warning
    Performance warning: Missing indices
    Cron Not Running
    Remote Profiles Enabled

The log says
Entity: Job Action: process_membership
Summary
Finished execution of Update Membership Statuses with result: Success (Processed 159 membership records. Updated 0 records.)

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

Full message:
Finished execution of Update Membership Statuses with result: Success (Processed 159 membership records. Updated 0 records.)

The cron is -

curl -s 'https://ashguild.ca/home/administrator/components/com_civicrm/civicrm/bin/cron.php?name=weaverfran&pass=#####&key=#####’


texts:
How can I import contacts to a group in CiviCRM from an excel file?

Kind regards,

Alexia


texts: Participant Status vs. Participant Status ID

texts:
Did I miss something or has there been a architectural change with these parameters? The search builder gives a list of the status options for both of these parameters, but for the Participant Status ID is throws an error: is not of the type Int

In which release has there been recent changes to this part of civicrm? And which Github or JIRA issues document that change?


texts: How to capture verbal contribution commitments: invoice, contribution pending or pledge?

texts:
If a constituent makes a verbal commitment (ie. at event or via phone campaign) to make a one-time donation (ie. pledge) and we want to track + invoice them to fulfill that pledge, what is the best way to process via online self-service?

It looks like Pledges are designed for this, however:

They require an installment period.  We only have a commitment for a
one-time donation.
We need to ensure the payment matches / fulfills the pledge.  Is there a special link for a pledge fulfillment/payment online?  If not, the system will consider the pledge unpaid and continue to send reminders.

Alternatively, we can create a contribution with payment pending (or create a Pledged status type)

How do you send an email invoice and ensure that the payment matches the pending contribution?
Is there a way to construct the URL so the payment marks the contribution as complete?

I'd be open to using webforms - This seems like a common use-case.


texts: How can I hide non-mailing list groups in receipts?

texts:
At the moment, when someone signs up for a membership or makes a contribution, the receipt returns a list of their newsletter subscription groups AND non-mailing lists group assignments.

How can I hide the non-mailing lists group assignments from the receipt?


texts: Does CiviCRM have a recommended setting for zend.multibyte?

texts:
When running CiviCRM test suites, I see

  PHP Warning:  declare(encoding=...) ignored because Zend multibyte feature is turned off by settings in /path/to/sites/all/modules/civicrm/vendor/zetacomponents/mail/src/transports/variable/var_set.php on line 2

Line 2 of civicrm/vendor/zetacomponents/mail/src/transports/variable/var_set.php is,

declare(encoding='latin1');

Since this generates warning output from the test run, I wonder what the expected configuration is.

Is it accepted that we see these warnings from test output?
Should we set zend.multibyte=1 locally, which feels like it might introduce internal conversions that don't happen in most hosting environments per default?
Should we remove the declare statements from CiviCRM, reflecting what happened upstream in zetacomponents/Mail?
Or is it just me that sees it?

Environment: Debian 8, PHP 5.6, Buildkit, CiviCRM drupal-demo/master, running ./scripts/phpunit api_v3_AllTests.

PHP Warning:  declare(encoding=...) ignored because Zend multibyte feature is turned off by settings in /opt/buildkit/build/crm19757.fudev.co.nz/sites/all/modules/civicrm/vendor/zetacomponents/mail/src/transports/variable/var_set.php on line 2
PHP Stack trace:
PHP   1. {main}() /opt/buildkit/bin/phpunit4:0
PHP   2. PHPUnit_TextUI_Command::main() /opt/buildkit/bin/phpunit4:545
PHP   3. PHPUnit_TextUI_Command->run() phar:///opt/buildkit/bin/phpunit4/phpunit/TextUI/Command.php:100
PHP   4. PHPUnit_TextUI_TestRunner->doRun() phar:///opt/buildkit/bin/phpunit4/phpunit/TextUI/Command.php:149
PHP   5. PHPUnit_Framework_TestSuite->run() phar:///opt/buildkit/bin/phpunit4/phpunit/TextUI/TestRunner.php:440
PHP   6. PHPUnit_Framework_TestCase->run() phar:///opt/buildkit/bin/phpunit4/phpunit/Framework/TestSuite.php:747
PHP   7. PHPUnit_Framework_TestResult->run() phar:///opt/buildkit/bin/phpunit4/phpunit/Framework/TestCase.php:724
PHP   8. PHPUnit_Framework_TestCase->runBare() phar:///opt/buildkit/bin/phpunit4/phpunit/Framework/TestResult.php:612
PHP   9. CiviUnitTestCase->runTest() phar:///opt/buildkit/bin/phpunit4/phpunit/Framework/TestCase.php:768
PHP  10. PHPUnit_Framework_TestCase->runTest() /opt/buildkit/build/crm19757.fudev.co.nz/sites/all/modules/civicrm/tests/phpunit/CiviTest/CiviUnitTestCase.php:184
PHP  11. ReflectionMethod->invokeArgs() phar:///opt/buildkit/bin/phpunit4/phpunit/Framework/TestCase.php:909
PHP  12. api_v3_JobProcessMailingTest->testBasic() phar:///opt/buildkit/bin/phpunit4/phpunit/Framework/TestCase.php:909
PHP  13. CiviMailUtils->assertRecipients() /opt/buildkit/build/crm19757.fudev.co.nz/sites/all/modules/civicrm/tests/phpunit/api/v3/JobProcessMailingTest.php:107
PHP  14. CiviMailUtils->getAllMessages() /opt/buildkit/build/crm19757.fudev.co.nz/sites/all/modules/civicrm/tests/phpunit/CiviTest/CiviMailUtils.php:291
PHP  15. CiviMailUtils->convertToEzc() /opt/buildkit/build/crm19757.fudev.co.nz/sites/all/modules/civicrm/tests/phpunit/CiviTest/CiviMailUtils.php:211
PHP  16. spl_autoload_call() /opt/buildkit/build/crm19757.fudev.co.nz/sites/all/modules/civicrm/tests/phpunit/CiviTest/CiviMailUtils.php:352
PHP  17. Composer\Autoload\ClassLoader->loadClass() /opt/buildkit/build/crm19757.fudev.co.nz/sites/all/modules/civicrm/tests/phpunit/CiviTest/CiviMailUtils.php:352
PHP  18. Composer\Autoload\includeFile() /opt/buildkit/build/crm19757.fudev.co.nz/sites/all/modules/civicrm/vendor/composer/ClassLoader.php:301


texts:
Kind of related to my last question earlier today, I'd like to send a link to someone who has completed a webform but does not have a user account, and ask them to make changes/improve their responses on the webform. On the webform, there are two contacts (both individuals, with a relationship between the two) and one Case.

If I'm logged in and use the url: https://mysite.org/individual-grant/?cid2=2&cid1=27&caseid=12 this populates the webform with the correct information, so I know the syntax here is OK.

My issue is trying to get it working with a checksum token. I can't tell if it's the webform/url that's the problem, or the checksum itself.


texts:
I am trying to write an extension that monthly will send a series of CiviMai emails. Basically, it would be the same if a user went to the Sent mailings and clicked Re-Use and sent the email again without any changes to the email at all.

Obviously, I need the email to be sent the first time but after that, I am not sure how I would use the API to duplicate the email and then schedule it to send.

Any help is greatly appreciated. I am using Drupal 7 and CiviCRM 5.11.

Thanks,
Josh


texts: Wrong Group counter showing on Contact tab

texts:
It can be reproduced in dmaster following the next steps:

Go into dmaster
Create a Smart Group
Add "Manually" a Contact in the Smart Group
Go to the Contact (the counter in the Group Tab shows a number, p.ex. 0)
Access to the Group Tab
Now the counter has been updated into 1 because the contact is in a Group

It's a normal behaviour? Or can it be considered as a bug?


texts: Can a Drupal webform be used to create a waitlist registration?

texts:
I have a CiviCRM Event which allows waitlist registrations and handles them correctly within Civi - including sending emails when there is a cancellation.

However, a Drupal webform used to enter registrations does not seem to allow/create waitlist registrations.

Is it possible to use the Drupal webform for waitlist registrations?


texts: When viewing a contribution the Line Items do not display

texts: Whenever a contribution is displayed it is now possible to click on the total amount of the contribution and it should display further details of the line item(s). Where there is a single line item the details are correctly displayed. However where a contribution consists of two or more line items only a single line is displayed with the total amount but under the heading Financial Type there are as many Financial Type descriptions displayed as there are line items. You can see this in the attached screen shot. There are three line items that make up the $550 and there are three Financial Type labels under the heading  Type.


texts: How to change or transfer mailing list groups properly?

texts:
Right now - we have a smart group with all individuals tagged, in this example "Email List" and of type "Individual" as our main email list.  This has worked fine for us - as we rarely sent emails.  Now we are moving forward and investing more in email communications. We want to fork this list into two regular groups. (stop using the tag system and smart group)

Group 1: Events and Invitations
Group 2: Monthly E-Newsletter

The base for both groups will be our current smart group as they all indicated they want to receive updates - but I also want to make sure we honor unsubscribes.
We are splitting the two groups up as we suspect that we will get more unsubscribes from the Monthly E-Newsletter group than from Events and Invitations (as people like coming to our events).  Also we find its easier to add people to groups via profiles, instead of tags.  (there is no add new contacts to a tag in the settings of profiles.)


texts: Should we install CiviCRM again and import cleaned up data?

texts:
I have recently joined the International Voluntary Service as Director and I am trying to understand the database - CIVI

the system was installed several years ago and has not been updated consistently. it is in quite a big mess.

I am trying to work through how to solve this. My query is this - can we set up an entirely new account with CIVI? effectively start all over again? Then merge the clean data from the old system into a new account?


texts: How to search for contacts by date added or date range added. Alternately: list contacts by date added


texts: I'm working on migrating our Wordpress site to WPEngine, and I don't know how to get the civi database onto WPEngine. WPEngine doesn't allow the creation of a new database for civi. Has anyone done this before? I have found other topics regarding WPEingine here, but for now I just want to get the database onto WPEngine.


texts: Drupal not loading Civi's CSS and jQuery

texts:
Drupal 7 is not loading Civi 4.4's resources: CSS & jQuery.  Clearing Drupal cache solves the problem, for a few hours, then it happens again.  I've tried the following:

custom theme? nope, it's happening in Seven or Garland
resource URLs in CiviCRM are correct
disabled and re-enabled Civi as a module, no permanent solution.
disabled other modules like jQuery Update or Admin Menu
Turning off Drupal cache, CSS and jQuery aggregation.  It has no effect, even though clearing Drupal's cache solves the problem.

Note it's not a conflict between js, the Civi resources simply aren't loading.

This started happening after an upgrade from 4.2 to 4.4.  Any ideas for help?


texts:
I have setup a webform using the Civi/Drupal webform module, which allows people to submit payments they intend to make and keep it as Pending before they make it.

What is happening is the contribution goes in as Pending but when you change the amount and go to record a payment the amount stays as the original amount. This is because a payment was recorded.

How do i stop contribution page from recording a payment and i just want the contribution to be Pending in CiviCRM Contribution Page on that users account.

Thanks


texts: How to obtain user input from an API call

texts: This may be a stupid question - sorry if so. I am writing an API function to create a new case, and I want it to pre-fill the New Case form with field contents based the case source contact and two or three parameters obtained from the user. Of course I could create a new form in order to collect the user input before displaying the New Case form, but I wondered if there is a way that the API function can interrogate the user in real time to obtain the input parameters? Thanks.


texts: Create new contact sub-type when extension is installed

texts: I'm building a new extension using civix and buildkit.  I need to create a new ContactType (sub-type of individual) on install (if it doesn't already exist).  I know how I would do it, but I'd prefer to do it in accordance with CiviCRM's standards.  What's the correct way to do this?


texts: Any experiencing errors upgrading to 4.7.9, related to 'CRM-16189 Financial account relationship'

texts:
My upgrade simply hangs (20+ minutes) and then crashes a 2GB VPS trying to execute the MySQL related to 4.7.9.

My guess is that line 26 and beyond in 4.7.9.mysql.tpl is writing checks that my server cannot cash, given over 100,000 contributions already in Civi.

Can this query be optimized or can I see a less smarty-ized version of it I can run?  What are the consequences of not running these queries, if we do not use Accounting integration or Financial Accounts?


texts: Moving a membership from one contact type to another

texts: We have a database where some memberships were attached to Households and some to Individuals. We'd like to normalize this -- what is the best way to move the membership from one to another? (e.g. take a Household's membership and move it to an Individual)


texts:
I've just upgraded a test system running under Joomla to 5.5.0.  Looking at certain reports gives this error:

Notice: unserialize(): Error at offset 166 of 1907 bytes in ...\administrator\components\com_civicrm\civicrm\CRM\Report\Form.php on line 611


texts: Can I disable syncing when WordPress users create accounts?

texts: I have a CiviCRM database on my WordPress site. When new members sign up for our organization they create a CiviCRM account via the profile. Later they create accounts in WordPress to access certain members-only sections of the site. I do not want these WordPress accounts to sync. How can I disable that feature? I am now getting many duplicate records (and I need to allow duplicates as we have individual records -- children -- with same email -- parent).


texts: How do I disable civicrm.css on public pages in Drupal?

texts:
I have the following in my template.php file, in my custom theme:

function shriver_css_alter(&$css) {
    unset($css[drupal_get_path('module','civicrm').'/css/civicrm.css']);
}

It doesn't work, though. I can disable other stylesheets this way, but not this one. I know I can disable this stylesheet in civicrm settings, but then it is disabled on the back end as well. I only want it to be disabled on the public pages. Since I use a different admin theme than my public one, I thought it made sense to disable it for my public theme only.

Can someone help me to get this to work? Or, if you know a different method, that would be good, too. Thank you.


texts: VBO (Views Bulk Operations) - Bulk Operations field not showing in field list

texts:
Trying to use VBO in a view of CiviCRM contributions, but when I try to add the Bulk Operations field, it is not listed in the pop-up field list so can't be added.

The rest of the view works (ie can access contribution data), and VBO works if the view is based on eg Users.

What else is needed?

(Drupal 7)


texts: Correct means to update Drupal Node after user submits a donation

texts:
Drupal 7.37, CiviCRM 4.4.15

We are collecting tracking information when a user makes a contribution associated with child sponsorship (using URL parameters, custom fields, and a profile assigned to the contribution form). The tracking information included the id of the Drupal Node that needs to updated.  We need to change the Sponsored field, Boolean value, to true after the payment has been processed successfully (credit card or ACH).

Would we use something like this:

myhooks_civicrm_post($op, $objectName, $objectId, &$objectRef) {

if ($op == 'create' && $objectName == 'Contribution') {
   //retrieve contribution from civicrm database
   //retrieve tracker information from civicrm database
   //if tracker.appeal > 0
   //   retrieve node from drupal database
   //   update node in drupal database
}


texts: Is there a way to edit tag colours through the UI?

texts:
Having created a number of tags I've decided it would be useful to have them colour-coded.
It is straightforward to specify a colour when creating a tag, but I can't work out how to apply a colour to an already created tag, and have it stick. The UI lets me specify a colour, but there seems to be no way to save the change?


texts:
Is there a built-in way to check to see if a DB table exists via PHP? I'd like to add that to my API call and create the table if necessary.

Thanks!


texts: How can I display the participations of events in the user profile?

texts:
How can I display on Joomla 3.6.4 with CiviCRM 4.7.13 the tickets purchased by a user on his user profile?

Thank you in advance


texts: Using .htaccess to put Wordpress in its own directory.  Problem is that civicrm was installed using the subdirectory after the domain name.  I try to update the path and wordpress logs out.  Anything I try to do with Civicrm logs me out of Wordpress.  I can't seem to get around this problem.  If I edit my settings file, civicrm will not work.


texts:
new to civiCRM;-)

is there a jobboard in civiCRM

or to ask it in other words: does civiCRM  has a board constructed more in the realm of an Applicant Tracking System OR does it allow to function as a jobboard:

It might help if i describe a user scenario as well eg

User A want to list a job. They need to specify the Salary, Location, Skills required etc.

User B wants to find a job. They want to be able to search by Skilll, Location, Salary, etc

does civiCRM accomplish this?


texts: Register Multiple People for Multiple Paid Events With Webform

texts:
I am trying to create a CiviCRM Webform where the user can select multiple events to come to for multiple people in the same form.  I have it working great that the user fills out the information and clicks the events that they want to attend and their guests.

Each event costs $10.  I am trying to add up all of the events selected on the Webform and then have the user checkout with the correct price. For example someone may select 5 total events to attend so they should be charged $50.

Is this something that can be done with Webform without custom development?

Thanks,
Steve


texts: UK Counties list not complete - can this be amended by user or does it need to be amended in the core program?

texts: The drop down list of UK Counties does not seem to include Middlesex.  Can the drop down list be amended?


texts: any ideas why my emails are not being recieved, but are not bouncing?

texts:
I have been trying CiviMail to send emails with CiviCRM 4.6.9. and drupal 7.
When I send mails using the mail system not many of them reach the destination mailbox. They are marked as delivered by the mail reports, but only a few are marked as opened.
When I check with the individual users they are not getting my emails, I am also not receiving bounces.
I have checked and our domain has not been blacklisted.
If I send emails from my own email program they generally all get through.

Any suggestions as to why my emails are not getting through when sent from Civimail?


texts: Find and remove contacts based on no activity, contributions, memberships and events

texts: At some time our CiviCRM/Drupal installation has had lots of spam accounts created. As these are over a period of time I can't isolate by date. One tell-tail sign that the accounts are spam is their Civi contact summary has no recorded touch points (activity, contributions, memberships and events). Is there a way to search for contacts that meet this criteria and delete? I've looked at the Find Contacts - Advanced Search but there doesn't appear to be an option for null values. I've also looked at modifying one of the Contact Report Templates which does allow null matches but haven't been able to find a setting that gives the spam accounts.


texts: CiviCRM Extension not grabbing latest release

texts:
Submitted a new release and matched the info.xml file to the release number but Civi Extensions directory still hasn't picked up the new release yet. Any ideas why?

https://civicrm.org/extensions/authorizenet-echecknet


texts: Why am I getting no values when using REST api?

texts:
I've mainly used the php apis in the past but I would like to use the REST API. I added an api key to the contact record, and I attempted to use the really simple example in the documentation.  Yet I just keep getting

{"is_error":0,"version":3,"count":0,"values":[]}"

I'm using really simple examples like

entity=Contact&action=get
(of course with the base url and rest.php? and then the keys at the end). I'm pretty sure the url is right since it says there is no error (and if I change things I definitely get an error response). If I use the php api I get data, so it's not that there is no data.

Update 2

Actually I think I was wrong about at least where the problem is because clearly the checking for a valid CMS user record is happening.  If I use a url like this:

http://example.com/administrator/components/com_civicrm/civicrm/extern/rest.php?entity=Contact&action=get&group_id=6&options[limit]=25&options[offset]=50&json=1&key=4d0b3527f437210aa4479ca8fa4936eb&api_key=654321'

I get (along with a good apache response)
{"is_error":0,"version":3,"count":0,"values":[]}

However if I add a var_dump($apiResponse); right before the return in run()  in Civi\API\kernel.php I definitely get the data  and count is not 0. And that array comes through just fine to \api\api.php. So whatever is going wrong is happening somewhere after that.


texts: How do I add a transaction to a reopened batch?  The batch is expecting 20 transactions and only has 19


texts:
Platform: Wordpress 4.5.2 |
PHP version: 5.5.9 |
Mysql: 5.6.30 |
Running: Ubuntu 14.04.4

Yesterday I successfully upgraded to CiviCRM 4.6.16, no errors during upgrade, everything went smoothly, except the cron job is failing with the next error:

PHP Fatal error:
  Allowed memory size of 262144 bytes exhausted (tried to allocate 1920 bytes) in
  /var/www/site/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.class.php
  on line 226

PHP memory limit is set to 512M

line 226 at civicrm/bin/cli.class.php

The cron job runs every 5 minutes and looks like this:

php /var/www/site/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.php -s site -u user -p password -e Job -a execute

If I run the job from the API explorer, it runs successfully with no errors, it also runs successfully if I execute a job with Execute now in the Scheduled jobs page.

Any input is highly appreciated.


texts: When saved to activities, tokens inside emails are not evaluated

texts:
Is it normal that when a reminder email goes out and is saved as an activity that tokens are not evaluated and saved in the activity?

If that is normal, where is the best place to make a feature request? The value of the activities feature is significantly reduced when tokens are not evaluated when stored in activities.

If that is not normal behavior, any ideas on how I can troubleshoot this?


texts: How to make a report with each Financial Type as a column?

texts:
I need a report of contributions which has a row for each contribution, and then analysis by showing a column for each financial type, and the total amount of the contribution in the right financial type column. Is there any way of doing this without programming an extension?
I include a screenshot of the kind of thing I need. The columns to right of VAT are financial types, so each payment is broken down into VAT (if applicable) and one or more financial types.


texts: How to search by 'Added (by email)' va 'Added (by Admin)' for group membership

texts: I am trying to find the best way to confirm users are double opted in to a group.  A method I'd like to use is to see who has added themselves versus who was added by an administrator.  I see this in the groups tab on a contact; how can I search by how someone was added to a group?


texts: CiviMember - Adding a premium when recording a membership payment

texts:
Our organization wants to be able provide gifts to members who sign up for a magazine subscription. We are using CiviMember to record those contacts who sign up for such a subscription. When we click on Add Membership in the contact record's "Memberships" tab and then select the "Record Membership Payment" checkbox, we would like to have the ability to select a premium through the administrative interface like the way this is available on a front-facing donation page.

For qualifying members, we want to present them with gifts based on the subscription amount and also record this for future reference. This type of recording of a subscription is done offline by our staff. Is this somehow possible via an extension or is there some coding/hook required to make this functionality work?


texts: I have a custom field for storing educational data. A person's degree is stored as either Btech or B.Tech or B.Tech.  so what should I give in search option so that I can get all 3 in my result in a single search?


texts:
civicrm 4.6.8/joomla 3.4.1/php 5.6.11

moved civi to new server

everything seems ok EXCEPT the civi home page which hangs trying to display the dashboard

here's the log dump from the error

http://pastebin.com/JY0xM3A6

so civi is losing connection to mysql ???

if i enter civi via another url
(eg  http://..../administrator/?option=com_civicrm&task=civicrm/event/manage&reset=1)

all is well.  and i can navigate to every other civi screen and function without a problem.  in place editing works fine.

but obviously hanging on the home page is a real problem for users.

my php environments are very similar (new host is slightly newer version).

http://yea.org/tmp/ChangeDetection%20-%20Comparison%20of_%20phpinfo().html

yellow stuff is new host

tried trunc'ing dashboard_contacts

php error_reporting is the same as on the old site

any ideas to try?


texts:
I'm trying to get a report with the name of the Payment Processor that was used for each online Payment. I'm not able to get this to work. Been though the API trying to track the data but not that familiar where that is stored.

It looks like this data is shown on the Contribution view. "PayPal" on the image is the name of the Processor and other Contributions have the name of my other Payment processor. Any ideas?


texts:
In WP 5.5/CiviCRM 5.29 I have only one membership type at the organization level and 2 groups of beneficiaries depending on some criteria. I have all the needed extensions from Christian Wach.
I need to synchronize the groups into WP Roles and not groups in order to let them access to personalized content defined with Elementor.
It seems that this is not yet possible but maybe I'm wrong.
Does anyone know about this setting?


texts: Is there a way to create a two part profile?

texts: I am trying to make a profile that based on a previous selected it would either lead you to another part of a profile. Like if you select an option on the first part of the profile and then you could hit another button to take you to the second part of the profile.


texts: What are best practices around newsletter signup on contribution page, profiles and contact seeing their donation history?

texts:
I have a question about what the best way to set something up.  I am using Drupal 7 and CiviCRM 4.6.

I have a contribution page, where I want to add people to a newsletter group when they make a donation. I know that there are urls in emails that go out that allow someone to come back and remove themselves from groups, but I would also like to have these users be able to find and edit their profile, see previous donations, etc.

Is there a way to do this just in CiviCRM? Do I have to create Drupal Users? I am currently trying to do everything with CiviCRM profiles, but would it be better to use Drupal webforms? What is your experience and what do you recommend as best practices?

Thanks in advance.


texts: Where do I find Webform CiviCRM module for D8?

texts:
I don't see a release under Downloads on the Drupal Project page:
https://www.drupal.org/project/webform_civicrm


texts: How can I search in the greeting fields?

texts: I would like to do a search in the greeting field for all contacts with the greeting 'Dear%'. Neither with the search builder nor the contact search I was successfull. Can anyone help? Thanks!


texts: How to link preexisting fundraising pages to 'contributions' when setting up CiviCRM

texts: My NGO is thinking about setting up CiviCRM primarily to coordinate donations but we're totally new to all of this. We have various preexisting fundraising pages and profiles on other websites through which people can donate. Is it possible to link all of these diverse sources through to the CiviCRM Contributions section so they're coordinated? How is this done?


texts: Multi-value Custom fields not showing up for export

texts: I have created custom fields for individuals. When I am trying to export data, those which are single value custom fields, I am able to export. While Multi-value Custom fields are not showing up for export


texts: Can multiple mailings have deduplicated email addresses, so each address will not receive multiple emails?

texts:
We'd like to send a mailing in a few slightly different versions to different groups. What we'd like to avoid is having two contacts, who share the same email address and are in different groups, receive two different versions of the email.

Deduping happens before a specific mailing is sent and I can exclude previous contacts who were recipients of the first mailing from the next mailing, but what I am trying to do is exclude previously emailed addresses from the next mailing, not just previously emailed contacts.

Is there any way to either exclude previously emailed addresses directly or to search for contacts who share a primary email with contacts in a previous mailing or group?


texts: Email report via cron gets moved every time it runs!

texts:
I have scheduled job (daily) to email a report to myself. I would like to receive it on a specific time everyday. Although I have set the time when it should run, every time it runs on a different time and keep getting moved forward 20-30 min ahead of when it ran yesterday.
Is it an issue can be fixed easily? Thanks in advance.


texts: joomla privileges: can't grant allow to add contacts

texts:
Operating CiviCRM 4.5.6 on current Joomla  3.5.1.

I have set up three groups which should have different access levels to view, edit and add contacts.
Have configured them to be in group special as suggested elsewhere and allowed them access to Access Administration Interface in global permissions.

When I try to add allow to the add contacts group this automatically resets to "Not Allowed" after I press save..

It went OK with the other privileges but not with add contacts.

Dumbfounded.
Can somebody help?
P.S. where are these privileges stored in Joomla anyway?
Checked all the tables and found nothing which represented the privileges in any way..


texts:
We are looking to add the hours (a custom field) to the popup when locations are mapped. I am looking at the template here: templates/CRM/Contact/Form/Task/Map. I'd like to replace the location type with the hours. I can remove the location type but cannot determine what to use to bring in the custom data. May not be possible without a bunch of customization. Any thoughts?

CiviCRM 4.7.27 & WordPress

Below is a screen shot. It is the page that comes up when you have search results from a profile search (public directory) and you click the link "map these contacts".


texts: How should I configure CiviMember so both individuals and organizations can hold memberships?

texts:
I've got CiviCRM installed for a non-profit client whose membership base is small organizations (theater ensembles) and individuals. I am now considering that I may have fundamentally engineered this wrong and that if I got it right there would be better solutions to problems that arrise.

How should CiviCRM be implemented so that there is the most logical and flexible architecture when both individuals and organizations can hold memberships?

Some details about what I mean about organizations and individuals both holding memberships:

Organizations can hold memberships.
Organizations have staff and associates.
Organizations often have no email address of their own, only the address of an associate. This maybe be the achilles heel.
Individuals can hold personal memberships.
Some of these members are affiliated with member organizations.
Some stand alone.
There are also many non-member contacts such as donors, newsletter subscribers, potential members, event participants... you get the idea.
We'd like to keep track of all these folks so that we can (easily) see activity for an individual, an organization, and an aggregate of activity for an organization with its associates.
We'd like members to be able to manage their membership profiles, manage their associates' profiles (if they are organizations), pay for new/renewing membership.
We'd like members to have privileged use of the website based on the type and status of their memberships.
We'd like to send bulk emails based on profile information and past activity. We'd like to send renewal notices and other personalized emails.
We'd like to be able to pose questions like: Which organizations had more than one associate who attend an event last year?

There's so much more of course but it is predicated on getting the architecture right. Any guidance will be most appreciated. Thanks.


texts: Is there a function that will execute multiple SQL statements?

texts: I'm writing an extension that needs to make a bunch of temporary tables and copy data around. I think CRM_Core_DAO::executeQuery() only executes one semicolon-delimited statement at a time. Is there a function somewhere that'll let me run them all in one go?


texts:
We are a having an issue where we are unable to access the CiviCRM feature outside of the server. When we try to access CiviCRM as a domain user on another machine, we are only able to access WordPress features such as Dashboard and Posts but not CiviCRM. When we click on CiviCRM, we get a blank page with some error message stating "System Status: Error". We are currently running CiviCRM version 4.7.10. The operating system is Window Server 2012 R2. We are running WordPress 4.5.3. IIS has been configured to run WordPress and CiviCRM. Any suggestion?

Konechi Tagawa


texts: is there an easy local install method for civics and all dependent software

texts:
I'm investigating civicrm for a work use at the ngo where I work.

We don't have in-house It team who can help install it. So I'm trying to do so myself.

I have some experience using Ubuntu and basic command line things, but this is proving to complicated for me.
The problem is I need to install apache and php and mysql before I can install drupal, and only then can I install civicrm. Each element can have its own issues, which I have to research separately. I'm stuck on about step 2 and know I have at least 8 moresteps to follow. I've spent about 20 hours on it.

I guess this is quite a common situation and maybe there is a simple way to do it. Are all the necessary software elements in a package somewhere so that I can download it one go.?


texts:
My company does not make use of many of the fields provided by civicrm. Our users told me the sheer mass of empty fields is overwhelming them.

I know I could walk the hide-by-jquery-to-death way, but:

Is there a designated or recommended way to disable or hide civi core fields like "nickname" or "legal_name"?


texts: Error Running Contributions Summary Report

texts:
When trying to run the Contributions Summary report I get the following message:

DateTime::__construct(): Failed to parse time string (2010401) at position 6 (1): Unexpected character

Tried standards tricks, checking file permissions, clearing caches unable to resolve the issue.

$Fatal Error Details = Array
(
    [message] =&gt; DateTime::__construct(): Failed to parse time string (2010401) at position 6 (1): Unexpected character
    [code] =&gt;
    [exception] =&gt; Exception Object
        (
            [message:protected] =&gt; DateTime::__construct(): Failed to parse time string (2010401) at position 6 (1): Unexpected character
            [string:Exception:private] =&gt;
            [code:protected] =&gt; 0
            [file:protected] =&gt; /var/www/example.com/sites/all/modules/civicrm/CRM/Report/Form/Contribute/Summary.php
            [line:protected] =&gt; 745
            [trace:Exception:private] =&gt; Array


texts: Correct method for API calls on contact summary page? (slow!)

texts:
I pull out some important at-a-glance information on contact summary pages - membership info, relationships via related cases, etc.

At the moment i override contentsummary.tpl and do my API calls with javascript - page loads, my things fire, then for some, returned values are used in a second API call.

This is slow and feels embarrassingly cludgy!

What should i be using for this?


texts: How to copy a Custom Field in a related Contact's Custom Field?

texts:
I use a Webform to register both Parent and related Children to an Event.

I would like them to share a common Participant Custom Field information : this does not seem possible, since each Participant has his own.

I think of different options, but I don't know if they are possible :

Option 1 : in the Webform : set Child field i to Parent field j Value : but, as far as I know, this is not possible with the standard Webform Conditionals ; is there any Webform extension to do that ?

Option 2 : independantly from Webform : create a Rule (?) (and a CRON Job ?) to copy Parent field j Value to his related Children's fields i. But I don't know wether this is possible, nor how to do that.

Any help or suggestion is welcome (I am not a developper)


texts: Correct location of civicrm.settings.php in CiviCRM 4.7 for WordPress

texts:
I've got a WordPress site here (CiviCRM 4.7.17, upgraded recently from 4.7.15) which has two different civicrm.settings.php files:

wp-content/plugins/civicrm/civicrm.settings.php
wp-content/uploads/civicrm/civicrm.settings.php

File #1 contains the correct settings, and files #2 appears to have outdated settings.

Questions:

Which is the correct path in CiviCRM 4.7?
Can I just delete the one with the wrong path (after I ensure the correct one is in the right place)?
Is the whole directory wp-content/{uploads,plugins}/civicrm in the same boat -- that is, is just one of them needed, and if so, what's the correct path for that directory?


texts: How do I call the Fatal Error Handler for extern/url.php?

texts:
I noticed my Fatal Error Handler wasn't being called when CiviCRM had problems processing trackable URLs in a CiviMail.

My answer will tell you how to do this.


texts: Membership import - is there any column heading that will automatically match internal identifier?

texts:
I've tried all sorts of things and can't find any column heading for the cvs that will automatically match internal identifier.  One would think that if you use what comes up when you manually match that it would automatically match to that, but not really.

I've figured out that the following will match:
join matches with membership since.
start matches with membership start date
end matches with membership expiration date

Funny Gender matches to membership start date


texts: Can I set a premium for a $20 minimum on a recurring contribution, but $80 for a one-time contribution?

texts: It seems like premiums only work on the minimum amount, without regard for other settings.  Is there a way to get around this?  I see the EFF has this option, but their contribution page seems not to be generated by CiviCRM anymore.


texts: How do you allow a user to add their bulk email address?

texts:
Trying to find a way to allow users to indicate which of their email addresses should be used for bulk mailings.

Not seeing an option in profile creation.


texts: Need confirmation: Membership scheduled reminders do not sent to any email on bounce lists?

texts:
We ran our membership renewal reminder for the first time on our live data and found as expected that contacts whose email address is in the 'on-hold' category are skipped when sending out membership reminders.

But we also have additional skipped contacts, and we found some of them were on bounce lists but haven't triggered the 'on-hold' threshold yet.

Can someone please verify/falsify that even contacts  on 'temporary bounce', are skipped when sending out membership renewal reminders?

Or alternatively point me to the tables/module handling this part of the feature.

I will report back to this thread.


texts: Stop Webforms loading memberships in the messages section for 'existing contacts'?

texts:
We have a Webform that creates a single membership. We've set it to use the 'existing contact' which very helpfully pre-fills the webform with the existing user's details - or with the details corresponding to the contact's checksum from a CiviMail. This is all brilliant so far!

However, when the page loads it also shows all the contact's existing memberships. And it shows them in the page's system 'messages' block.

In our use case we don't want to see existing memberships. And even if we did we'd want to see them in a webform component that we can control the behaviour of. When they appear in the system messages block it looks like an extra communication to the user and is rather confusing.

So, is it possible to prevent them from loading at all? Or at least have them load as a component of the webform rather than displaying in the messages block?

We are on Drupal 7.58, Civi 5.0.0


texts:
When I try to edit a Mosaico template in FireFox or in Chrome, it acts as if I am trying to print a "Welcome to your Home Dashboard" page. The URL looks like this:
https://yobc.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/mosaico/editor&snippet=2&ip-geo-block-auth-nonce=5234197d0a#ivfia57 .
If I cancel that "print," I get a Configure Your Dashboard message. The URL looks like this:
https://yobc.org/wp-admin/admin.php?page=CiviCRM&q=civicrm/mosaico/editor&snippet=2&ip-geo-block-auth-nonce=5234197d0a#ivfia57

It appears that this plugin is up-to-date, and we have used it for some time. Updated CiviCrm last week with the security update.

Pictures attached.


texts: Can I get a list of contacts without created case?

texts:
I'm wondering if it's possible to get a list of contacts without a created case (even if the case is closed).
We have a workflow when some beneficiaries "apply" to be "active beneficiaries" to receive companion from volunteers. Then, after an evaluation, the CiviCRM users open a case to that beneficiary to follow up their activities. How ever, we need to know how much and which contacts in that "active beneficiaries" doesn't have a case created, to don't lose any contact that could be unattended.
I tried with advanced search, but this is a negative criteria with an "empty" field. I mean, this should be "Contacts in X group AND Not in a case?
Thanks for your feedback,


texts: Report for user and assigned contacts (ACL)

texts:
I have a set of users that have been assigned access to specific contacts (ACL based off a smart group for each user) - for each contact I have added a set of custom fields that a user needs to fill out (example call status) - The workflow is: the user signs in, has access to the contacts that has been assigned to him, calls up the contact and marks the contact custom fields appropriately

I am now looking to generate a report that shows all users and their corresponding contacts - I can't see any option to do so since I am unable to connect the user to assigned contacts

Is this possible to do through civiReports or would it need to be a database query?


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

If I have one record inserted, it shows once.

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

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

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

Is this a bug introduced sometime between 4.6.0 and 4.6.6?


texts:
I'm running CiviCRM on WPEngine. It works real fast and seems to be working well otherwise. No error logs occur on production side. The staging environment does not work, I get a 500 error when I try to access Civi there.

I also tried to clone the install and create a testing area but that also gives the same issue.

I am getting this error.

Does anyone know how this would be resolved? Thanks!

[Thu Jul 27 14:02:29.745288 2017] [:error] [pid 26200] [client 88.87.189.26:25979] PHP Fatal error: require_once(): Failed opening required 'CRM/Core/ClassLoader.php' (include_path='.:/nas/content/live/lpiacrm/wp-content/plugins/civicrm/civicrm/:/nas/content/live/lpiacrm/wp-content/plugins/civicrm/civicrm//packages:.:/usr/share/php') in /nas/content/live/lpiacrmtest/wp-content/uploads/civicrm/civicrm.settings.php on line 467, referer: https://lpiacrmtest.wpengine.com/wp-admin/


texts: Is it okay to have simultaneous data import?

texts:
Is it okay to have more than one user import data at the same time another user is importing data?

We have a bunch of segmented data to import split amongst multiple employees - is it okay if two employees are uploading at the same time?


texts: How to disable cache refresh on Manage Groups page

texts:
The Manage Groups page in Civi 4.5+ displays counts of contacts in each group, and in the process refreshes the smart group contact cache. We've turned off this cache elsewhere as it takes 10mins to complete (we have a lot of groups) - but the Manage Groups page seems to force a refresh. Is there a way to disable this refresh?

I can't see a setting, so am assuming it'd involve commenting out some code. I found the code in Contact/BAO/Group.php that I think disables the count of the contacts, but can't figure out where the cache-refresh itself takes place.