texts: Version 7.x-4.7.24 I need to send letters to contributors that gives them detailed information on each donation they have made for the year

texts: I looked in several places.  One answer said to go to Find Contributions, actions, Thank-you letters for contributors, Group Contributions by contact.  When I follow those instructions I do not find a Thank-you letter in my actions.  Also, someone said that I may need to add an extension.  As I browsed through extensions under administration, system settings, extension, I wasn't sure which to use.


texts: All our admin accounts are blocked accidentally. I have access to remote server as root. How do I reactivate the accounts


texts: (Part solved) Missing line items on event invoice and confirmation email for Event (using Webform CiviCRM)

texts:
Drupal7 / Civi5.12
I have created a webform for event bookings, using webform_civicrm.
The webform uses Participant Fee for the exhibition cost, and a Line Item for an additional booking fee.

Can anyone guide me how to make the line item reflect on the Invoice and in the confirmation email?

UPDATE - the solution from @KarinG below fixes the invoice issue.

STILL NEED HELP WITH CONFIRMATION EMAIL
 - does not print the line item
 - has wrong sales tax amount (shows the percentage not the amount)
 - reflects Amount after tax in the "Amount Before tax' field


texts: Data Mapping for Importing data from external database

texts:
Can someone please guide me to the table/data templates for CiviCRM.  We are in the process of migrating from an existing relational Access database to CiviCRM and want to map related data to organisations, individuals, membership payments etc.  I have not been able to locate this in any documentation.

Thank you in advance for any pointers/help.

Graeme


texts: Rule will not create drupal user record for CiviCRM contact

texts:
Was trying to set up a rule to create drupal user records linked to CiviCRM records that do not have them,
The rule is this:

EVENT
CiviCRM Contact has been created
Contact has been updated

Conditions
 NOT Drupal User Account can be created for user (this condition creates the user)
Parameter: CiviCRM Contact: [civicrm-contact:civi-user..., Activate Account: true, Send account notification email: true, Instant signin: false

Actions
Create or Load Linked Drupal User Account
Parameter: CiviCRM Contact: [civicrm_contact], Activate Account: true, Send account notification email: true
Provides variables: Created or Loaded Drupal User (civicrm_user)

Show a message on the site
Parameter: Message: Drupal User Linked or...

Unfortunately we don't seem to be able to trigger the rule by updating a contact, we just seem to get this error in the watchdog:

MESSAGE Unable to get variable civicrm_contact, it is not defined.

Does anyone know how to get this working? Thanks!


texts:
Please excuse the Newbie question.
When I click New Organiasation, why can't I add a "Lead contact" to the Organisation.
Do I have to set up an individual first, and link them?!

Thanks,

Jeremy


texts:
We use the "image URL" field via profile to allow members to upload their organization logo. We would like to limit the file size a user can upload. Are there any options for us?
Thank you!


texts: How do I investigate "Snippet type is unrecognized" when viewing contact record

texts:
when trying to view the contacts summary page, the error "Snippet type is unrecognized" is displayed in the usual yellow strip accross the screen.

I can't see any differences between this contact and any other contacts (which do display) (apart from the obvious).

ConfigAndLog doesn't provide much of use (for me - sorry):

  _Apr 01 11:12:09  [info] $Fatal Error Details = Array
  (
      [message] => Snippet type  is unrecognized
      [code] =>
  )

  Apr 01 11:12:09  [info] $backTrace = #0
  /var/www/drupal743civi4610/sites/all/modules/civicrm/CRM/Core/Error.php(364):
  CRM_Core_Error::backtrace("backTrace", TRUE)

  1 /var/www/drupal743civi4610/sites/all/modules/civicrm/CRM/Core/Region.php(223):

  CRM_Core_Error::fatal("Snippet type  is unrecognized")

  2 /var/www/drupal743civi4610/sites/all/modules/civicrm/CRM/Core/Smarty/plugins/block.crmRegion.php(26):

  CRM_Core_Region->render("                \n              ...", TRUE)

  3 /var/sites/praxisunico.org.uk/files/civicrm/templates_c/en_US/en_GB/%%12/12B/12B53F83%%Summary.tpl.php(182):

  smarty_block_crmRegion((Array:1), "                \n              ...",
  Object(CRM_Core_Smarty), FALSE)

  4 /var/www/drupal743civi4610/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php(1907):

  include("/var/sites/praxisunico.org.uk/files/civicrm/templates_c/en_US/en_GB/%%12/12B/...")

  5 /var/sites/praxisunico.org.uk/files/civicrm/templates_c/en_US/en_GB/%%0C/0CB/0CBEC124%%default.tpl.php(19):

  Smarty->_smarty_include((Array:2))

  6 /var/www/drupal743civi4610/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php(1907):

  include("/var/sites/praxisunico.org.uk/files/civicrm/templates_c/en_US/en_GB/%%0C/0CB/...")

  7 /var/sites/praxisunico.org.uk/files/civicrm/templates_c/en_US/en_GB/%%06/069/0693F89E%%drupal.tpl.php(64):

  Smarty->_smarty_include((Array:2))

  8 /var/www/drupal743civi4610/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php(1264):

  include("/var/sites/praxisunico.org.uk/files/civicrm/templates_c/en_US/en_GB/%%06/069/...")

  9 /var/www/drupal743civi4610/sites/all/modules/civicrm/CRM/Core/Smarty.php(203):

  Smarty->fetch("CRM/common/drupal.tpl", NULL, NULL, FALSE)

  10 /var/www/drupal743civi4610/sites/all/modules/civicrm/CRM/Core/Page.php(233):

  CRM_Core_Smarty->fetch("CRM/common/drupal.tpl")

  11 /var/www/drupal743civi4610/sites/all/modules/civicrm/CRM/Contact/Page/View/Summary.php(103):

  CRM_Core_Page->run()

  12 /var/www/drupal743civi4610/sites/all/modules/civicrm/CRM/Core/Invoke.php(312):

  CRM_Contact_Page_View_Summary->run((Array:3), NULL)

  13 /var/www/drupal743civi4610/sites/all/modules/civicrm/CRM/Core/Invoke.php(86):

  CRM_Core_Invoke::runItem((Array:14))

  14 /var/www/drupal743civi4610/sites/all/modules/civicrm/CRM/Core/Invoke.php(54):

  CRM_Core_Invoke::_invoke((Array:3))

  15 /var/www/drupal743civi4610/sites/all/modules/civicrm/drupal/civicrm.module(489):

  CRM_Core_Invoke::invoke((Array:3))

  16 internal function: civicrm_invoke("contact", "view")

  17 /var/www/drupal743civi4610/includes/menu.inc(527): call_user_func_array("civicrm_invoke", (Array:2))

  18 /var/www/drupal743civi4610/index.php(21): menu_execute_active_handler()

  19 {main}

  _

Anyone know what this may relate to or where to look for clues?

Thanks.


texts: How do you input Virgin Money Giving Donations into CiviCRM?

texts:
Just a quick question, is there any better way to get donations from outside services like Virgin Money Giving or Facebook that just manual input?

At the moment, I'm just assuming that we add the contact/donation manually into the system with the source being "Facebook Page" or "Virgin Money Giving" or whatever it may be.

Any suggestions on how any other NFPs are doing this with Civi at the moment?

Thanks.


texts: Convert to uppercase all letters in a specific field

texts:
Is it possible to convert every letters in a specific field to uppercase?

I would like to have the addresses of my contacts on Civi written in uppercase (for postal service purposes).

The ideal scenario would be to force that field to be uppercase. But also converting it after the record is created would be sufficient.

Thank you.


texts: Using "Premium (Thank-you gifts)" to enroll in membership

texts:
Is it possible to set up a "Premium (Thank-you gift)" option to sign a donor up for a specific membership level?

I can build a membership sign-up page, and I can put "premiums" on it. The instructions in the Manage Premiums page (/civicrm/admin/contribute/managePremiums?reset=1) say:

  Premiums may be tangible items (i.e. a coffee mug or t-shirt), or they may be a membership or subscription with a pre-determined duration.

However, it appears that there is no built-in way to have a "premium" be an actual membership.

Our model is the current EFF donation page, although in our case all donors will become members, and there are certain member levels that a donor can choose for special access on our website.


texts: CiviMail html format splits images and text

texts: On the preview the email looks as it should, with pictures and formatted text, when i test email all of the pictures will appear above the text completely separated.


texts: "Receipts - print or email" not working from Advanced Search

texts:
I carry out the following steps:

Perform an Advanced Search displaying as contributions
Select one or more contributions
From the actions menu select Receipts - print or email

No matter how many contributions are selected, on the Print Contribution Receipts screen it always says Number of selected contributions: 1 and the receipt that is emailed or displayed as a pdf is always for contribution_id = 101.

If, instead, I access the action Receipts - print or email through the Find Contributions search everything works as it should, ie. I get the appropriate receipt(s) emailed or displayed as a pdf.

All other actions work correctly whether I start from Advanced Search displaying as Contributions or Find Contributions.

I have enabled Debugging on our dev site (same problem exists on both live and dev sites) and compared the assigned template variables for both of the print receipts screens.  There are differences in:

{$action}  - which is to be expected. (It is "512" when I start from Advanced Search and "1" when I start from Find Contribution)
{$single}, {$totalSelectedContributions} and {$taskName} as shown below:

For the process that works the assigned template variables are:

For the process that doesn't work the assigned template variables are:

To me it sort of seems like something has become hard-coded somewhere (but only for the Receipts - print or email action). I thought I could compare the code from our site with the code from the CiviCRM repository but I am not sure what file(s) to look at.  Can anyone point me in the right direction?

(For completeness, our site is CiviCRM 4.7.27 running on Drupal 7.  I have absolutely no idea when this problem started.)

Update: SO far I have found no differences between the code on our site and on the civicrm-core 4.27 branch for:

/CRM/Contact/Form/Search/Advanced.php
/CRM/Contact/Form/Search/Basic.php
/CRM/Contribute/Task.php
/CRM/Contribute/StateMachine/Search.php
/CRM/Contribute/StateMachine/ContributionPage.php
/CRM/Contribute/StateMachine/Contribution.php
/CRM/Contribute/Selector/Search.php
/CRM/Contribute/Form/Search.php


texts: CiviMail is not sending immediate mailing and scheduled mailing is working partially

texts:
In my first CiviMail "real" massive mailing, I tried an immediate mail (500 contacts), but no mail where sent.
Then I force  the "Send Scheduled Mailings" job, in order to start the shipping, but, after some time waiting, I obtain a white page and the mail really sent where 20.
A second forced "Send Scheduled Mailings" sent other 150 mails, after the white page.

What is happening?

Some details:

the maximum mail split number is set to 400
no message in the configAndLog folder
the job log is the following:

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

Full message:
Starting execution of Send Scheduled Mailingss


texts: DB Error: unknown error when accessing any report menu after upgrade to 5.10.0

texts:
I have just updated CiviCRM under Joomla! from 4.7.6 to 5.10.0. The upgrade went well, with no issues. I have following the instructions on the page "Upgrading CiviCRM for Joomla". I can use CiviCRM except whenever i access any report menu i get :

  Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.

  DB Error: unknown error

Items on here say to look in the ConfigAndLog file which i think for Joomla should be at
administrator/components/com_civicrm/civicrm but i do not see it there.

Anyone have any suggestions on how this can be resolved?

thanks
Dave


texts: How to extract field from an array returned from an API3 call

texts:
I am trying to extract a custom field from a contact record. The API returns an array of the following form:

Array (
    [0] => 0
    [1] => 3
    [2] => array (
        [0] => array (
            [value 1] => 123
            [value 2] => 456
            [value 3] => 789
)))

Using php how can I extract value 1, 2 or 3?

Later information

This is the actual array

Array (
[0] => 0
[1] => 3
[2] => 1
[3] => 2911
[4] => Array (
    [0] => Array (
        [contact_id] => 2911
        [civicrm_value_aru_data_1_id] => 2586
        [custom_64] => 2014848
        [id] => 2911

)))

and I want to extract the value of custom_64. I am using:

$rugby_id = $arrayvariable[4][0][custom_64];

which returns nothing and I can't see where I am going wrong.

Even later information

I am still struggling with this issue. In an attempt to simplify things I have changed the CiviCRM API call to 'getsingle' and stored the result as follows:

$results = print_r($result, true);
echo $results;

which leads to the following:

Array (
[contact_id] => 2911
[civicrm_value_aru_data_1_id] => 2586
[custom_64] => 2014848
[id] => 2911
)

If I now try to extract the value of custom_64 using:

$rugby_id = $results['custom_64'];

The value returned is 'A'. I have researched this to death but have not found the cause of the problem.


texts: What should be synced to an accounting package from civicrm?

texts:
My church uses Aplos Accounting. It's a web-based accounting package aimed at non-profits (www.aplos.com). They have recently implemented an api (www.aplos.com/api). I am interested in doing some syncing from Civi to Aplos to automate some things.

Our thoughts were to have an extension that implemented a scheduled job that would run daily and create a Civi accounting batch for the previous day. That batch would include all financial transactions that civiCRM processed that would be deposited into the bank account.

That total would then be posted to Aplos as a Deposit transaction with the Civi Accounting batch ID located in the comments of the transaction. That way if there was ever any question we could cross reference between the two.

Also, if a refund is processed through Civi then that would be posted as a Debit to Aplos with the Payee just being REFUND and in the comments it would notate the details.

What are you thoughts on this and do you have suggestions?


texts: custom fields created but don't show in civicrm_value_constituent_information_1

texts:
I ignored error messages on entering custom fields - Turns out they meant something. Can't import data, as many fields listed under wordpress:civicrm:administer:custom data and fields:custom fields do not exist in table civicrm_value_constituent_information_1

Advice sought.

[edit] Aidan, I put all the new fields into the constituent group. I am trying to import through Civicrm's built-in import contact function.


texts:
I am using Civivolunteer on wordpress. Works good, except on smartphones. The shopping card comes in front of the signup checkbox, so users can't sign up. Anyone having the same problem, or is it because of my wordpress site?

can't scroll right to the checkbox in vertical position


texts: Display Contact Addressee as {prefix} {Initial} {last_name}

texts:
Hopefully self explanitory.

I want to extract the initial from the first name (if there is one) e.g. Mr John Smith appears as Mr J Smith as default.

Would be grateful for any help on this one.


texts:
I'm trying to figure out how to divide people up and group them organizationally.  Adding each person to an organization and creating a relationship is easy.  However, I need to break them down further than one top level organization.  I'll use the word team for generalization.  Most of my searches have ended up back in the '07 discussion on sub-organizations, and to some degree that's what I need.  However, 9 years later, it still seems unclear.  So, what am I missing?

Org has departments.  Departments have teams.  Teams can have sub-teams.  Each level also has roles, which easily fits into a relationship.  (Org has President, Department has VP, Team has Team Leader and team member, etc.) Each level has it's own set of documents, cases, workflows, etc.  (A new team has a Case with a timeline of "New Team", each team has a goal document, each department has a set of protocol documents, the org has overarching protocol documents, etc.)

Without being able to nest Orgs, or a massive amount of manual adjustment with each change, how do I show that Team Member C, on Team D, which is part of Department G, is an employee of Org?  Also, each contact needs to have a membership to the org.

Confused yet?


texts: Howto import CAMT053 XML with CiviBanking

texts:
Is somebody importing CAMT053 XML from ING or another bank?

We want to import bank statements from ING, a Dutch bank.
ING can export to CSV, but that export does not contain postal adresses.
The CAMT053 XML does.


texts: We've recently installed CiviCRM 4.6.6 and we're on WordPress 4.3. I've got a major problem with CiviMail (see HERE. No one has responded in six days. Is there backwards compatibility? Would it be safe to install 4.5.8?? At this point, we're just using the Contact table. I'd rather not import all the data again, since I could only do 600 records at a time (the command line doesn't support groups or dup checking). I've got to get this fixed...someone please help me!! thanks...jim


texts:
I would like to be able to create a smart group of contacts who:
1) are participants for an event in the future
2) have passport expiration dates (a custom Individual Contact date field) that are before the End Date of said event

I'm not finding any way to compare the two date fields. I've looked at CiviRules, but that doesn't seem to get me what I need.

Any suggestions?

(Joomla 3.7.5, Civi 4.7.21)


texts: How to allow a participant to update their registration info (WP with Caldera Forms)

texts:
I know this is able to be done with Drupal/Webform but what about native in WordPress or WordPress with Caldera Forms? I would like to be able to send a tokenized link to participants which sends them to a simple form that, when submitted, changes their registration status.

WordPress 5.2.4,
CiviCRM 5.13.4


texts: How to change the date format for the receipt date in a template

texts:
I'm using the "Thank-you letters - print or email" functionality to generate a receipt for contributions. I created a new template with all the information needed. However we have a problem to display the receipt date at the correct format. Actually, when I chose the token "Receipt date" in the combobox, Civi inserts {contribution.receipt_date} in my template, and when I generate a PDF, it displays the date with the hours : for example, "2019-02-25 16:01:00". We would just like to display the date (without the hours) at this format : dd/mm/YYYY (for example : "25/02/2019"). I tried to add code like "date_format" in the source of the template to change the date format, but it didn't work. Is there an easy way to change it ?

Thanks !


texts: Sparkpost Cividesk integration - processing of bounces

texts:
I have installed the Cividesk Sparkpost extension and am able to send mass mailings with CiviMail via my Sparkpost account (REST API).

However, CiviCRM apparently doesn't process bounces.
Would I have to configure something else, besides the SparkPost extension?

Any Cron Job to run?

Many thanks
Ton


texts:
While cleaning our contacts database, our users claimed that it would be beneficous to have the quick search bar remember the type of field to search in. In many cases it's helpfull to repeatedly search for zip codes or email addresses or stuff like that.

I had no luck finding information about accessing civi's session with js and therefore I wondered how to implement and decided to walk the extension way by feeding drupal with a cookie in my module's js file. What do you think?

CRM.$(document).ready(function () {
    /**
     * Save quick search type on select
     */
    CRM.$('.crm-quickSearchField').click(function() {
        var label = CRM.$(this).text();
        var value = CRM.$('input', this).val();
        jQuery.cookie('quickSearchLabel', label);
        jQuery.cookie('quickSearchType', value);
    });

    /**
     * Set quick search type on load
     */
    var quickSearchType = jQuery.cookie('quickSearchType');
    if (quickSearchType) {
        var quickSearchLabel = jQuery.cookie('quickSearchLabel');
        var label = quickSearchLabel ? quickSearchLabel : "Suche";
        var value = quickSearchType;
        // These fields are not supported by advanced search
        if (value === 'first_name' || value === 'last_name') {
            value = 'sort_name';
        }
        KompiModsLib.radioSelect("input[name=quickSearchField]", value);
        CRM.$('#sort_name_navigation').attr({name: value, placeholder: label}).focus();
    }
});

And: would it be valuable to add it to the core?


texts: Auto-Renew option not displaying membership contribution page

texts:
Anyone know why the checkbox that allows memberships to automatically renew would not appear? Everything in the membership type and the contribution page settings is correct, providing the option to renew. We have one site that this is happening on and can't quite figure out what it could be. First time I'm seeing this, so wanted to see if anyone else had experience this before.

When a membership is selected it the space where the check box should appear expands, but is empty. When inspecting source it shows as follows:

But should be something like this

                 <input id="auto_renew" name="auto_renew" type="checkbox" value="1" class="form-checkbox" readonly="readonly" checked="checked">&nbsp;Please renew my membership automatically.

Any ideas?

This is running on CiviCRM 4.6.9 and WordPress 4.3.1.

Not using a price set,just the membership tab on the contrition page options.


texts:
Wordpress 5.5.3, CiviCRM 5.31.0.
While testing Mass SMS with new Twilio account we've discovered it does not quite work. Searching for a solution here and across lab.civicrm.org haven't helped much. Logs are empty so it is not an error or is not considered as an error by CiviCRM. The most popular related solution ( replace "is_deceased" from NULl to 0 in the database ) hasn't helped. Mass mailing works fine and the number of recipiens counted is correct. Individual SMS sending works also. The only clues we have are:

"Send SMS" action is not visible for individual contacts.
Attempt to create Mass SMS for all contacts in the database ( around 10 000 ) displays only 5  contacts on "Total Recipients: 5" counter.
Probably it is something with data in the database. We were having big updates for both wordpress and civi past weeks on a decent hosting so things might have been a little messy. The question is, where to start with debugging. Perhaps, if we saw which exactly contacts were counted, we would be able to find what all these 5 have in common and figure out the next steps. Any clue will be helpful.


texts: Is there a way to make all Mosaico blocks the same width?

texts: When adding Mosaico blocks each has its own width.  That creates problems if you want a different color for the external background but not have it change its width  depending on the width of each Mosaico block.


texts: All CiviCase Functionality Gone Despite Component Being Enabled

texts:
All the CiviCase functionality has gone in our CiviCRM D7 (version 5.34.0) website even though the component is enabled. All the menu items for CiviCase are not there. I have flushed all caches, reset paths and reset menus. I have disabled and re-enabled the component but this all makes no difference. If I go to /civicrm/civicase it redirects to /civicrm/admin. There don't seem to be any relevant error messages in the CiviCRM log or in the Drupal log. The CiviCase permissions are still present in Drupal.
Can anyone suggest any further troubleshooting I can do?
All other components and everything else is working fine. As far as I know there have been no significant updates to Civi either (no new extensions enabled etc)


texts: CRM_Utils_Array::value how to set value to a hook_buildForm?

texts:
There is a  https://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_buildForm manual page, but not sure I've got it right.

Say, there is a value in a custom function, which should be set as default in a form, built using  hook_buildForm (where form itself opens in a modal frame and outside civicrm/ path).

I've a suspicions CRM_Utils_Array::value might be used to set a custom variable somewhere (anywhere) and get it later on wherever it  might be needed;

Have an attempt to set value outside of hook_buildForm like this:

$myVeryOwnPid = CRM_Utils_Array::value('myveryownpid', $contact['contact_id_b'], $contact['contact_id_b']);

and get it from inside hook_buildForm:

  $myVeryOwnPid = CRM_Utils_Array::value('myveryownpid', $_GET, '0');

..but, of course, nothing works, just because I clearly don't understand, how it should work. As they say, CRM_Utils_Array is the most often used feature in CiviCRM, but digging inside a source code Ive realized there is no forest for the trees (at least, for me). Any advice, please!


texts: Paypal Recurring Transactions Are Broken in 4.7

texts:
When posting a recurring transaction with PayPal (offline and online), we're getting a 'Transaction ID not set' Payment Processor error.  The payment is created in Paypal.

Checking Civi log file, on offline transactions, getting:

[info] Could not find payment processor for contribution record: #######

For the online transaction, the log file has:

[info] contributionRecur could not be loaded
[info] Contribution record updated successfully
[info] Receipt sent
[info] Success: Database updated

This problem seems to have started with the 4.7 upgrade.

Even recurring transactions coming from Paypal are giving the same '[info] Could not find payment processor for contribution record:' error.

Site profile settings


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


texts: Bulk emails created with the APi delivered to 0 recipients

texts:
I'm using the API to send a bulk email each week to all our members.  This is the code:
$currentTime = new DateTime();
$approval_date = $currentTime->format('Y-m-d H:i:s');
$currentTime->add(new DateInterval('PT1H'));
$schedule_date = $currentTime->format('Y-m-d H:i:s');
$params = [
    'scheduled_date' => $schedule_date,
    'approver_id' => 396,
    'approval_date' => $approval_date,
    'from_name'          => "Jack Donohue",
    'from_email'         => "info@crw.org",
    'replyto_email'      => "donohue.jack@gmail.com",
    'subject' => $subject,
    'body_text' => $text,
    'body_html' => $html,
    'name' => 'weekly email',
    'created_id' => 396,
    'header_id' => '',
    'footer_id' => '',
    'groups' => [
        'include' => [
            '0' => 128,     // Current members
        ],
        'exclude' => [
        ],
    ],
    'mailings' => [
        'include' => [],
        'exclude' => [],
    ],
    /*
    'options' => [
        'force_rollback' => 0,
    ],
    */
    'api.MailingRecipients.get' => [
        'mailing_id' => '$value.id',
        'api.contact.getvalue' => [
            'return' => 'display_name',
        ],
        'api.email.getvalue' => [
            'return' => 'email',
        ],
    ],
];

try{
    $result = civicrm_api3('Mailing', 'create', $params);
}
catch (CiviCRM_API3_Exception $e) {
    // Handle error here.
    $errorMessage = $e->getMessage();
    $errorCode = $e->getErrorCode();
    $errorData = $e->getExtraParams();
    log_message( $errorMessage);return;
}

The email is created, scheduled to be sent, and is sent, but the report says it was sent to 0 recipients
Delivery Summary
Intended Recipients 2417
Successful Deliveries   0 (0.00%)
The only thing that looks odd is that the Sent By field in the table of emails is empty despite the fact that I set this in the parameters.
It's supposed to be sent out around 2 am each Thursday, and when it isn't I do reuse and send it manually which works fine.
Can you figure out what I am doing wrong?
Thanks,
Jack Donohue


texts: Can contact images be uploaded other than by editing a contact record?

texts:
If I upload a contact image by editing the contact record it works. I can see the contact image, and it has a URL when viewed from the contact record that looks something like:
https://example.org/civicrm/file?reset=1&filename=image_a46992b081c6ccee3e54abcfdd0ba352.jpg&mime-type=image/jpg
I can click on it and it appears in a pop-up window. Lovely.

If I upload the exact same image file through a webform such that it becomes the contact image for the same contact it doesn't work. It has the URL https://example.com/civicrm/file?reset=1&filename=custom&mime-type=image/
when viewed from the contact record, and instead of seeing the image I just see the word 'custom'. Clicking on the word 'custom' brings up a little error box that reads "The file is either empty or you do not have permission to retrieve the file", neither of which are true. The database has stored the image URL as https://example.com/sites/default/files/webform/pics/image.jpg

This used to work fine on an earlier version of Civi (4.6.x). I also imported contact records with 4.6.x that had external URLs for contact images and they worked fine - i.e. were viewable from the contact record, but again, now that I've upgraded to 4.7.24 all I see is the word 'custom'.

If I reference the field in a Drupal View, it can display the image without issue.


texts: Why is the list of relationships presented when adding an additional role to a case different from those presented when configuring a case?

texts: The list of relationships presented for selection when configuring a case type are B to A Relationships. The list available from which to add roles to cases contains A to B relationships. Is this correct? Why don't these lists present the same perspective of the relationship?


texts: Is there a way to prevent USPS address standardization from making addresses all caps in PDF letters?

texts: We recently linked our CiviCRM database to the USPS address verification system, which saves me time verifying addresses and looking up the Zip+4 codes. However, Civi now makes the addresses all caps, which is a real pain when printing PDF letters which include the name and address of the contact in the letter. I find myself copying the address out to a text editor, converting it to initial caps, then pasting it into my Civi letter. Do you know of a way to automate this in Civi?


texts: How can we increase the number of events displayed when creating Joomla menu link?

texts:
We host 100+ events per year. We create a Joomla menu link to each event, but only 25 events are available to be selected. Which file contains the limiting variable?

We are using CiviCRM 3.4.5 on Joomla 1.5.2.


texts: Why does the Preview as HTML in civimail not apply the html that has been applied to the footer

texts:
Thought I was going round in circles here. Set html eg
 to the Footer including both the Unsub token and the Domain Address token.

Preview mailing as HMTL in CiviMail. The Unsub text shows as intended, but the Domain Address shows as Times New Roman.

When I actually send a test mail, the domain address does show as sans serif. confusing.


texts:
using the rest API, I am able to change 'normal' fields with a single occurence. But I can't figure out what I should do to change the first email addressl.

Civicrm only accepts post requests to do a database change. If I put in the post parameter hash something like

{ :contact_type => 'Individual',
:id => 14330,
:job_title => 'workaholic',
'email[0][email]' => 'testaccount@gmail.com',
:entity => 'Contact' }))

the corresponding record is changed (job title is changed) and the email address is added. But not replaced. Do I miss some required parameter to make this work?

thanks in advance


texts: Can civi pre-authorise funds for events and is only charged the amount if the registered participant is a no-show?

texts:
We have a client who wants to take a deposit fee for events and have it only processed if the participant is a no show. Is there a way to achieve this with Civi? Should we be talking to the payment processor about this?

We run on the latest version of Drupal 7 and the CiviCRM 5.13.x LTS version.

Thanks


texts: API EntityTag-Create, tags not added if one already exists on contact

texts:
We are trying to  mass updating tags via API.

Using API. When trying to add an array of tags Example: ["1","2","3"] to a contact using API : EntityTag-Create.  The set of tags are not added whenever one of the tags is already assigned to contact.

In result shows "not added":"1"

Found in versions 4.6.11-0 thru 4.7.6-0


texts: How can I indicate if our donors prefer to receive Charitable/Political Tax Receipts by Email or Postal Mail?

texts:
using:
CDN Tax Receipts Extension
https://github.com/jake-mw/CDNTaxReceipts


texts: Some problems to add email account in CiviMail CiviCRM

texts:
I am trying to configure the email address to send messages. I am trying to use a Google Workspace user with custom domain.
Some values that I have are the following:
Server: smtp.gmail.com
Username: myemail@apapacheautismo.org
Local part: (empty)
Email domain: apapacheautismo.org
Email return path: (empty)
Protocol: IMAP
Origin: (empty)
Use SSL ?: Yes
Used for: "Bounce Processing"

An error occured while sending or receiving mail. The IMAP server did not accept the username and/or password: A0001 NO [AUTHENTICATIONFAILED] Invalid credentials (Failure). (See log for more details.)
I have already verified username and password and they are correct.


texts: Why is the content of a Receipt for New Memberships different to that for a Renewed Membership

texts:
There is a key data element that is missing from the Renewal receipt. "Financial Type" is present in a receipt for a new Membership but is NOT shown in the receipt for a renewed Membership.

We use Financial Type to differentiate between Member Subscriptions and Annual Donations / Sponsorships. For Tax purposes, the word Donation in the receipt is key for a donor to claim a partial refund.

So the issue is can the Financial Type element be made available for a renewal receipt. Alternatively is there a suggested work around that can be inserted in the HTML code?


texts: extension ACL for activity types error "[] operator not supported for strings"

texts:
WP 5.3 civi 5.19.3 php 7

select contact record - error as follows:

"Fatal error: Uncaught Error: [] operator not supported for strings in /home/leepngo/public_html/wp-content/uploads/civicrm/ext/biz.jmaconsulting.activitytypeacl-master/activitytypeacl.php:278 Stack trace:
#0 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Hook.php(300): activitytypeacl_civicrm_selectWhereClause('Activity', Array)
#1 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/CRM/Utils/Hook/WordPress.php(155): CRM_Utils_Hook->runHooks(Array, 'civicrm_selectW...', 2, 'Activity', Array, NULL, NULL, NULL, NULL)
#2 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/Civi/Core/CiviEventDispatcher.php(90): CRM_Utils_Hook_WordPress->invokeViaUF(2, 'Activity', Array, NULL, NULL, NULL, NULL, 'civicrm_selectW...')
#3 /home/leepngo/public_html/wp-content/plugins/civicrm/civicrm/vendor/symfony/event-dispatcher/EventDispatcher.php(184): Civi\Core\CiviEventDispatcher::delegateToUF(Object(Civi\Core\Event\GenericHookEvent), 'hook_civicrm_se...', Object(Civi\Core\CiviEventDispatcher))
#4 /h in /home/leepngo/public_html/wp-content/uploads/civicrm/ext/biz.jmaconsulting.activitytypeacl-master/activitytypeacl.php on line 278


texts:
I have some questions about structuring our memberships, we have two branch locations, is there a way in the membership reporting to show the reports on each location? or do I have to create types such as "Family Location 1" & "Family Location 2"

In addition to this we also have tier memberships based on normal incomes and low income in each location.

Here is a screen shot of what we currently have, we are in development so this is not live yet.

Any help would be much appreciated

Zeak


texts:
I am quite new to CiviCRM.

My question is:  when I create a new Event via Manage Events and then go to add a discount to that event,  CiviDiscount does not show the new event.

Any help would be greatly appreciated


texts: Report filters: How can I sorts date field ascending so blank fields are shown last

texts: I have created a custom field to capture grant deadlines in dd-mm-yyyy format. How can I sort this date field ascending so blank fields are shown last


texts:
I am new to civicrm.

I have created a module; say com.ex.myextention. and created a page its working fine.

But in my module where I have to write a hook and how to ensure the defined hook is working.


texts: backup and migrate Cannot delete or update a parent row: a foreign key constraint fails

texts:
I have tried to use backup and migrate from an existing system into a fresh Bitnami Drupal 7.4.1 Civicrm 4.6.9 install on another machine. Win10
BandM 7.x-3.1
I received the following error:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1217 Cannot delete or update a parent row: a foreign key constraint fails in backup_migrate_source_db_mysql->_restore_db_from_file() (line 199 of C:\Bitnami\civicrm-4.6.9-1\apps\civicrm\htdocs\sites\all\modules\backup_migrate\includes\sources.db.mysql.inc)
I looked at the existing answers and am unable to get it to work.
Please help.


texts: Sync new clients added in civiCRM to mailchimp

texts:
I have started to use civiCRM on wordpress recently.
I have been using mailchimp for sending newsletter.
If I add new client in civiCRM, I want them to be added to mailchimp client newsletter list automatically. One way traffic only at the moment - from civiCRM to mailchimp when I add a client.
And second, if someone unsubscribes from newsletter list, how can I automatically (?) update in civiCRM this newsletter list?
how can I do this automatically?

Many Thanks


texts: Oops! Incorrect CiviCRM version. This installer can only be used for the Drupal version of CiviCRM

texts: I get this message after (successfully) installing 5.4.0 into Backdrop 1.10.1. The download file is civicrm-5.4.0-backdrop.tar.gz and when I start to install it shows the correct version (it says Backdrop) in the upper right of the installer. The install completes okay. Any ideas?


texts: access civimail images from Drupal media browser

texts:
If we wish to reuse images in a node on the main Drupal site uploaded for a CiviMail email newsletter, we can not access with the media browser widget for a field from: sites/default/files/civicrm/persist/contribute/images/image

Is there a way to change this? (More of a Drupal question than a CiviCRM question.)
Currently everything has to be uploaded twice if first used in CiviMail.


texts: Have any scripts been developed for migrating GiftWorks to CiviCRM

texts:
Apparently GiftWorks has been bought by Frontstream and we have had our first enquiry from someone wanting to explore shifting to CiviCRM. They have been told their old system will be shut down in July 2019. They have the option of being migrated to Frontstream but want to consider other options.

I can't find any public references yet to any migration scripts for this.


texts: Text that doesn't appear on the contribution page

texts: For my contribution page: https://crm.teatronecessariogenova.org/civicrm/?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=1  - I checked the option: "Pay later"; in the editor I put the "Pay instructions later", but what I wrote in the editor doesn't appear on the "contribution" page. Thanks


texts:
I need to create a new report, an italian postal bulletin for donation or subscription, as in the below image.

Do you have any suggestions on where to start?
I mean:

I must create an extensions?
What's the tool (the best one) to write reports in CiviCRM?
....

Thanks for your attention

Marcello


texts: Migrating Drupal to wordpress redirect existing links

texts: After migrating from Drupal to wordpress links to event info pages for example no longer work - as these have been shared already is there a way to redirect these?


texts:
Is there any built in way to tell when the data in a custom data set was last updated?  If not, what would be the best way to proceed to build that in for one specific group?

As usual, the data can be edited by the administrative user logged in to civicrm OR it could be edited via a profile.  In my case I know the profiles in advance, so could rely on the profile ids.  These are always 'on behalf' profiles.  Not sure if that's important.

I'm thinking I could create a custom "last updated" field in the data set, and then update it through a hook, but not sure if that's the best way.  Thanks for any guidance.


texts:
When I send out a bulk sms with an URL, the URL is changed before it is sent out.

Original message in template:

Hi John! Check out this link: wikipedia.org/somethingfunny

Received message on phone:

Hi John! Check out this link: https://mysite.com/sites/all/modules/civicrm/extern/url.php?u=43&qid=70242

How to make CiviCRM not change this?


texts: Is CiviCRM PCI compliant when it works with Authorize.net?

texts:
Is CiviCRM PCI compliant when it works with Authorize.net ?
Or more precise, has an installation (using civi/auth.net) you know of ever reached PCI compliance by a PCI Assessor, or do you think it could ?
And, or, what additional setup requirements, like HTTPS, are there for the server configuration to get it compliant ?


texts: Moving contribution page to a new campaign - consequences?

texts:
quick question: Having a contribution page under campaign A.. We're creating a new campaign ("B") now but wish to use the same old contribution page.

How are the past records (donations+pcps) affected?


texts: How can I use existing tokens to send out a single Scheduled Reminder to both the Org and the Employee

texts:
Scenario is:
Acme has a membership which is inherited by employees.
John is a permissioned employee - and hence should be able to renew 'on behalf of' and hence goal is that he should be sent Scheduled Reminders pertaining to the membership (in 4.6)

To be able to use a single reminder that makes sense whether it is sent to the Org or the Employee I need something like:

Regarding membership of {contact.organization_name}{contact.current_employer}

That way the Reminder that goes to the Org, shows its name, and for the one going to the employee it grabs the employers name, and the unsuccessful token will just not show in both cases.

Currently afaik there is no such token for {contact.organization_name}.


texts: Membership Set Up - Renewal Reminders - Inherited Memberships

texts:
I am looking for some references on how renewal reminders are set up and whom they are sent to.

What I understand is:

Membership WITHOUT Inherited Membership Set Up

If an organization membership (“Membership Types” under CiviMember) is set up without a “Relationship Type” the main email (or primary email) of that organization is used by the system to send renewal reminders to.

Membership WITH Inherited Membership Set Up

If an organization membership is set up with a relationship type, the membership is automatically granted to the related contact as well. The membership will show up as inherited membership in the related contacts profile. In this case, the auto renewal reminder will be send to the organization primary email and the related contacts primary email.

Is my understanding of this correct? Do we need to consider anything when selecting the “location types” (main, billing, home, work) for the email address? Or will the auto renewal reminders always be sent to the “primary” email?


texts: Database error "Unknown field" when trying to add contacts to a group from a report

texts:
Created a report with some custom fields in it.
The report show up correctly with the custom field used
When I click on "Add Contacts to Group" and choose a group I see a blank page stating an error appeared. The error is "Unknown column 'civicrm_value_kandidaturen__11_custom_134' in 'field list'"

I do not know why this report causes this trouble as this function (adding contacts to a group from a report) as this funtion works with other reports properly even if this custom field is added to the report. It is not clear for me when the query runs which causes this issue (it is an select query starting with SELECT DISTINCT contact_civireport.id AS addtogroup_contact_id and is quite large so I am not sure if I should paste it in here). Can someone give me a hint?


texts:
I'm using the command line import, following info provided here:

How do I import contacts through the command line?

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

But getting the following error message:  Invalid file format for filepath/filename.csv. It must be a valid csv with separator ',' or ';'

My file is a valide csv, downloaded using Google Docs to csv, which has been an acceptable way to create clean csv files.  Not sure why the import.php won't accept this file.


texts: CiviCRM on Backdrop - Oops incorrect Drupal version

texts:
Oracle VM
Linux Mint 20.1 Ulyssa
LAMP through Mint
Backdrop v1.18.1
CiviCRM 5.35.1 for Backdrop
I go to http://localhost and get Backdrop just fine.
I go to http://localhost/modules/civicrm/install/index.php and get "Oops! Incorrect CiviCRM version ... can only be used for Drupal version of CiviCRM".
I downloaded CiviCRM 5.35.1 for Backdrop three times, extracted, placed folder into modules and get that same message.
Clearly it is installed correctly or I wouldn't be getting that message. Perhaps the Backdropcms version and the CiviCRM version are not compatible?
/module/civicrm/README.md says it is good for Drupal, Wordpress and Joomla.
but
/module/civicrm/install/index.php line 67 says acceptable are "drupal, wordpress, backdrop"
Any help would be appreciated. Thanks in advance.
John in Medford, Oregon


texts: Certain data is not displaying on records

texts:
I just created a custom field for a multi-select list using tab with table. When I add data, the tab correctly shows that there are four items saved to this field, but the actual items are not displaying. See image attached.

Having another similar problem, not sure if they are related.  We have employer-employee relationships.  The employer properly displays on the employee summary.  Both employer and employee show a relationship, but when you go to the Relationship tab, nothing is displayed.

I did work in a staging environment, and this worked.  What could be causing this problem on this instance?


texts: Getting Custom field values via API using chaining

texts:
I am trying to use the API to get membership data, including some custom fields.  I have the general idea, I think.  I can successfully retrieve the memberships, chained in the contact data, and now I need to include some data in custom fields.  The table the custom data is stored in is called "college_data_1" and one of the custom fields is called "enrollment_3".  So I believe I want entity 1 and field 3. I didn't find documentation that confirms how to find these IDs.  So what I current have in API explorer is:

rest.php?entity=Membership&action=get&api_key=userkey&key=sitekey&json={"sequential":1,"membership_type_id":"Membership Name","api.Contact.get":{},"api.CustomValue.get":{"id":3,"entity_id":1}}

however this doesn't work.  Help?

I will need to include website data too, next.


texts: Error When Expanding Relationship Section on Advanced Search

texts:
I'm on CiviCRM 5.6.0 on WordPress 4.9.8, and I have created some custom relationships, all with contact type A of individual, and contact type B of organization.

When I go to Search -> Advanced Search and expand the Relationships section, I get this notice:
Network Error
Unable to reach the server. Please refresh this page in your browser and try again.

When I check the logs, this is the full error message that occurs when I expand the Relationships section:

[Wed Oct 24 15:42:05.499499 2018] [proxy_fcgi:error] [pid 32638:tid 140566905980672] [client X.X.X.X:56697] AH01071: Got error 'PHP message: PHP Warning:  array_key_exists(): The first argument should be either a string or an integer in /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Search.php on line 301\nPHP message: PHP Warning:  array_key_exists(): The first argument should be either a string or an integer in /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Search.php on line 301\n', referer: https://XXXX/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fsearch%2Fadvanced&reset=1

On another instance of CiviCRM 5.5.2, also on WordPress, on which I have not created any custom relationship types, I do not get this error. I tried disabling all the custom relationships I created in the instance on which I'm having issues but the error still occurs.

Anyone have any ideas on what might be going on? Thanks.


texts: Email addresses being set to on-hold bounce due to Away responses

texts: We just discovered that we have several hundred contacts whose email addresses have been set to on-hold bounce due to Away responses.  Apparently the 3 bounce maximum is also being applies to emails with Away responses.  How do we change this?  Also, is there a time maximum interval for the 3 bounces, after which old bounce history is discarded?  Thanks for any light that can be shed on this.


texts: I have installed and unzipped Civi in WordPress plugins directory, CiviCRM installer page is blank?

texts:
I have installed and unzipped Civi in wordpress/wp-content/plugins directory via these directions:

http://wiki.civicrm.org/confluence/display/CRMDOC/WordPress+Installation+Guide+for+CiviCRM+4.5.

When I get to step 5, however, and visit the Civi Install page on settings - CiviCRM installer, the page content is blank.

Also, there is nothing in the error logs.

Any thoughts on what could be going wrong?

Thank you!

AK


texts: Too nervous to upgrade CiviCRM from 4.1.1

texts:
I currently have CiviCRM 4.1.1 running on Drupal 7.16 at Siteground. When I try to make mirror versions (sandbox), things fail due to PHP versions on the host, conflicts, etc. I was told to upgrade the existing module within the CMS and upgrade the CMS in their locations, but I don't want to waste time when problems arise.

Could someone point me to the right person/group that could upgrade these for me to the latest of each that are currently stable?

I've asked some individuals for help, but can't seem to get confirmation.


texts:
When creating multi-day events, I'd like to display a more detailed schedule than what's shown by the "When" field. The "When" field essentially shows the duration of the event, but I'd also like to have a "Schedule" field to show the days and times of the week. Is something this possible?

When      March 1st, 2016 7:00 PM   through   May 26th, 2016 9:30 PM
Schedule  Mondays 7:00 - 9:30 PM
          Wednesdays 7:00 - 9:00 PM
Location  ...


texts: Send rejected participants to wait list?

texts:
I would like to configure CiviEvent so that rejected participants are sent to the waiting list - is this possible?

Or is the easiest thing just to rename the Rejected status to something that sounds less final?


texts:
I'm not sure if this is a bug or a problem that I need to fix - one of my sites doesn't display the City on the Summary and only shows 'contact.city', e.g.

It's a multi-site running v5.10.4


texts: Why is the receipient count in CiviMail less than the number in the group? No, I mean, specifically!

texts:
I have a group of 18495 contacts but when I send them a civimail, it shows only 9560 recipients. I get that it's going to be less due to opt outs, etc., but how can I find out more specifically why?
It seems like others have asked this question as well:
https://lab.civicrm.org/dev/mail/-/issues/51


texts: Import and Export failing and returning no error message

texts:
I recently moved my CiviCRM install from a local in-house server to a cloud server hosted by Siteground. Everything is working beautifully except for the import and export.

My database is around 60,000 names.

When I try to import a list of 5000 names to update their addresses, it gets through about 600 records (exactly 3 minutes) and then reverts back to the initial import page. Sometimes it has failed in 2 minutes, but no longer than 3. I can't find in Drupal logs showing a failure. I contacted Siteground and asked them to increase my max_execution_time, memory_limit, and max_input_time. They showed me how to do it myself and I tried it. Still no change. I disabled geocoding and it got to 3 minutes and 15 seconds.

So I tried exporting 45,000 contacts (a process I run about 4 times a year) and it lasted 3 minutes as well and then reverted back to the Search Builder page (where I started the export).

What setting is causing this issue? Siteground fixes things pretty well so I just need to know what to tell them.

Thanks,
Paul


texts: Sending one copy of each CiviMail campaign to a specific email address?

texts:
I have been asked to generate one copy of each mailing sent to go to a specific mailbox (say emails@example.org) that they will check for validation of emails sent (with content comparison) versus emails requested to be sent (with content requests).

I have proposed a group with just "emails@example.org" in it which gets put into the recipients for each civiMail we send out for lack of a better solution in my mind, but have been told that is unacceptable and it must be automatic.

I don't believe I can simply put "emails@" in every mailing group either because I will have no way of necessarily knowing if a new mailing group is created to add this email address to.

We are using civiCRM 4.6.4 and Drupal 7.43 and using Sparkpost as our mail service. I have thought a bit about forwarding in Sparkpost but I haven't thought of a way not to forward a number of copies of each email equal to the number of targets to our verifying inbox.

Has anyone set something like this up using civiMail? Or have any ideas how I might go about this?


texts:
When I try uploading a svg file into a mosaico mailing, I get a message that this file type is not allowed.
Is there a way to change settings, that allows inserting svg files, and maybe other file types?


texts: Providing Smart-Group Specific Price Sets

texts:
I see there is an extension that indicates it will allow group-specific price sets:
https://github.com/zengenuity/civicrm_groupprice

I'm running civi 5.20 on Joomla, and when I activate this extension and edit a Price set, I don't see the option to limit a Price Set to a group.

Is anyone using this extension successfully? I see is is built for civiCRM v4.4, so I'll hazard a guess it doesn't work with 5.20 .. but I wonder, what are people doing instead, to provide group-specific pricing?

My requirement is that I need to provide Member and Non-Member pricing for an event with several options (like Opening Night + Conf and Conference Only), and Members and non-members pay different amounts... How can I do this?


texts: CiviMail scheduling problem due to timezone issues

texts: i have a mailing that looks like it has been caught out due to timezone issues. The person who set it up was in NZ, but moved to Europe but didn't change their timezone. Looks like the Mailing got the scheduled time using NZ timezone, but civi sees it as happening in the future so is not sending it. Am i okay to change scheduled_date in civicrm_mailing table directly?


texts: Changes in display of batch data entry form in 4.6.x

texts:
In 4.3.x and 4.4.x, it was possible to see the name and email of the donor when entering a contribution: http://screencast.com/t/vH0CG33LDPU

In 4.6.x, only the name is now displayed: http://screencast.com/t/65HG1fBZ7ZH

For some of our clients, this is extremely problematic because they either need to see whether a particular donor has an email address in the system (so they can exclude them from the email receipt) or because they have multiple contacts with similar names in Civi and use the email address to distinguish among them.  My developer colleague tells me this change was made in core.  My question is, is there a straightforward way to change what is displayed in the contact name field or will it be necessary to resort to code changes?

Thanks,
Lesley


texts: Fetch membership type along with the contact details with civicrm_api

texts:
I am trying to create a lists of contact along with the membership type associated with each contact. Below is the code I have:

$result = civicrm_api3('Contact', 'get', array(
    'sequential' => 1,
    'return' => "tag,display_name,id,image_URL",
    'contact_type' => "Organization",
    'options' => array('limit' => 300),
  ));

I am not sure how to do join api call to both contact and membership, so that I can get all detail in one single api call.

so I am wondering if anyone can help.

So, far I have created another api call to each contact list returned form the above api call, like this:

foreach($result['values'] as $member){
    $ufmatch = civicrm_api3('Membership', 'get', array(
      'sequential' => 1,
      'contact_id' => $member['id'],
    ));
    $member['member_type'] = $ufmatch['values'][0]['membership_name'];

    $nodes[] = array(
      'node' => $member,
    );
  }

$members = array(
    'nodes' => $nodes,
  );

  return drupal_json_output($members);

But there are hundreds of contact list. So, it takes almost 2-3 mins load all data.

Can anyone please guide me in a right direction. Thanks in advance.


texts: Should accessing addresses via the API always require the 'view all contacts' permission?

texts:
To get contact data via the API you only need the 'access CiviCRM' permission, as long as you have access to the contact in question somehow (via an ACL or whatever). But to get address data for the same contact you need the 'view all contacts' permission. Is there a reason address data is more locked down? Can I override it?

Our use case is: a third-party website is accessing Civi via the REST API. This website is managed by a third-party, so I don't want to use an API key that gives them full database access. So I've set up a user who only has access to the relevant contacts. I can get the basic contact data fine, but I can't get their addresses without altering this global api permission requirement.

I'm just a bit nervous about changing this in case it's going to open any security holes elsewhere...

Here's the code in question, in CRM/Core/DAO/permissions.php :

  // Contact permissions
  $permissions['contact'] = array(
    'create' => array(
      'access CiviCRM',
      'add contacts',
    ),
    'delete' => array(
      'access CiviCRM',
      'delete contacts',
    ),
    // managed by query object
    'get' => array(),
    'update' => array(
      'access CiviCRM',
      'edit all contacts',
    ),
    'getquick' => array(
      array('access CiviCRM', 'access AJAX API'),
    ),
  );

  // Contact-related data permissions.
  // CRM-14094 - Users can edit and delete contact-related objects using inline edit with 'edit all contacts' permission
  $permissions['address'] = array(
    'get' => array(
      'access CiviCRM',
      'view all contacts',
    ),
    'default' => array(
      'access CiviCRM',
      'edit all contacts',
    ),
  );

Emails, phone numbers, websites, instant messaging etc. all use the same 'view all contacts' requirement.


texts: How to display a frontend CiviMember page?

texts:
I have a profile set up with standard membership fields which I want to display as a front-end page in WordPress.  The profile is enabled and set up as a standalone for.

Problem: on the WordPress page when I try to embed the form the profile is not listed. Are there any dependencies for CiviMember?
I'm on Civi 4.6.7


texts:
What HTML-code snippet must be included so when you create a PDF in CiviCRM, you would create a two-paged PDF?

One contact, one PDF, two pages, and the desired page break at a position of my own choice.

Any help is much appreciated.


texts:
I'm looking to hear from users of Eileen's excellent CiviXero extension!

1) Do you have any active bugs with CiviXero? Instances of data not being updated in Xero or Civi when they should be?

2) Is there anything that you need CiviXero to do which it currently can't?

3) Any problems associated with high volumes of transactions?

4) Does anyone know 100% for sure that it works with Membership purchases and renewals?

5) Does this work on a "batch" system for insertion and retrieval? (I see nz.co.fuzion.civixero/CRM/Civixero/Job/job.mgd.php, usually for scheduled jobs right?). If so, are there throttling settings (I can't see any in nz.co.fuzion.civixero/settings/Civixero.setting.php)?

Thanks - I really do appreciate all responses!


texts: Event Custom Fields not Looking Right with 4.6.27 Upgrade

texts:
I'm trying to upgrade our site from 4.4.21 to 4.6.27 (latest LTS).  The upgrade process, following the guide, worked as expected and everything looked ok initially.  However, when I try to create a new Event, several custom fields don't work and don't look right.

The contact reference autocomplete-select fields don't auto-complete (nor do they load the little icon next to the field, the js isn't loading).  And the date fields look really off, with two fields and the calendar icon doesn't pop up a calendar.

This is only on custom fields for events.  Standard date fields are fine, it seems.

The only error I could find was in the Console, with this message right as it's loading the custom fields.  I don't see any errors in the apache logs nor on screen (I have debugging turned on).  So I'm at a bit of a loss on how to debug this.

  Error: cannot call methods on autocomplete prior to initialization;
  attempted to call method
  '/civicrm/ajax/contactref?context=customfield&id=129'

I thought it might be some custom module I have, but I've disabled everything and still get these odd custom fields.  Would appreciate help in figuring this out.


texts:
How can I change to the Spanish language?
I want to know if it is necessary to download a package of Spanish language, where to get it and how to install it so that the whole program runs in the Spanish language.


texts:
may I know where to report an issue with "CiviCRM Community Forums" (forum.civicrm.org) pls?
I have been able to create an account and start a thread but one day later, impossible to log in again: wrong password they say.
The strange thing is my id/pwd is still ok on civicrm.org.
Is there a kind a miscommunication betwen the sub domain and the domain?
Thank you.


texts: Changing information displayed for Pay Later feature on contribution pages

texts:
Does anyone know where to go in Civicrm to change the I will send payment by check option on contribution pages?

I want to replace it with something like I will pay by cash or Bank Transfer


texts: CiviCRM 5.4.0 Install "You do not have permission to access this page"

texts:
I am stuck on this step:

  Then go to Settings > CiviCRM Installer:
  http://example.org/wp-admin/options-general.php?page=civicrm-install

In version 4.7 and above you will see a link on the wp-admin page to the Installer screen

There is not link on the wp-admin page like it says and if I manually use http://example.org/wp-admin/options-general.php?page=civicrm-install with my domain it gives me a "You do not have permission to access this page" error.

I basically cannot access the installer at all.


texts:
Turning the normal progression of development on it's head, what I am looking to do is take a copy of a production site and put it on a sandbox.

I am currently using D 7.36 and Civi 4.4.14

My intention is to take a copy of the working site from the live server and place on a local XAMPP so that I can experiment with ideas and test things such as how to implement Eileen's Permissions as ACLs 1.2 branch - specifically I am not sure how to install Entity Settings as it talks about registrations and PHP ... I would rather not do that on a live server.

I am not too fussed about taking the live contact and organisation data because I would create a large number of test contacts to do all that.

The problem is that our developer also included a custom member management module, so I want to ensure that all the right things are copied across so that it will work.

I did search through the usual sources, but I can to the conclusion that lots of them require disabling CiviCRM, I was of the opinion that I am likely to break it by doing that!


texts: confirmation undefined offset bug in BAO/FinancialAccount.php

texts:
while dealing with a white screen, I found a suspicious message in php_errorlog. In debugging that, I think I hit a bug. The documentation says that instead of directly reporting it, I should ask here if it is actually a bug.

civicrm 5.26.2
wordpress

In the logging, I see this line:
[22-Jun-2020 16:58:39 Europe/Amsterdam] PHP Notice:  Undefined offset: 0 in /home/user/public_html/civicrm-nw/wp-content/plugins/civicrm/civicrm/CRM/Financial/BAO/FinancialAccount.php on line 255

This is in function getFinancialAccountForFinancialTypeByRelationship; I put in some print statements and found out that it gets value 'Income Account is' in parameter $relationshipType. The line of the message uses the hard coded value instead:
$incomeAccountRelationshipID = array_search('Income Account is', $accountRelationships);

which is suspicious in itself. But the array $accountRelationships does not contain that value, which causes the message. The array appears to contain the dutch equivalents of the relationships:
LOC103 Array
(
    [1] => Inkomsten rekening is
    [2] => Credit/Contra Revenue Account is
....more
}

I am no php programmer, so I fixed it for my site by changing the hard code value to 'Inkomsten rekening is', making the message disappear.
I think the code should be changed to somethink like
$incomeAccountRelationshipID = array_search(translation_of ($relationshipType), $accountRelationships);

Is it OK to file a bug report on this?
Ruud


texts:
I am attempting to add a photo to an event we have and every time I try to upload the photo into the system I get a 403 error. Please let me know how I can fix this problem.

Thanks!


texts: Paypal Pro update billing details for recurring payments link is broken after upgrading to 4.6. How to fix it?

texts:
Since I have upgraded to 4.6.4, the link to update the billing details from recurring payment receipts is broken. I get the following message from log. How to fix it please?

2015/07/08 13:34:52 [error] 23640#0: *14724 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Cannot use object of type CRM_Core_Payment_PayPalImpl as array in /srv/www/sites/all/modules/civicrm/CRM/Core/Payment/Form.php on line 220" while reading response header from upstream, client: 185.59.126.253, server: abc.com, request: "GET /index.php?q=civicrm/contribute/updatebilling&reset=1&coid=17747&cs=0bf9ca34f74268e1ff962830b2162a05_1436189654_inf HTTP/1.1", upstream: "fastcgi://unix:/var/run/php-fpm/adb.sock:", host: "rldb.info"


texts: Authorize.net TLS Disablement Notice civicrm

texts:
what are the changes I need to make to make sure authorize.net works perfectly after authorize.net has sent this message as given below

  Your Payment Gateway ID:
  Dear Authorize.Net Merchant:
  As you may be aware, new PCI DSS requirements state that all payment systems must disable early TLS by 2018.
  TLS FAQs
  Merchant Interface
  Transport Layer Security (TLS), is a technology used to encrypt sensitive information sent via the Internet. TLS is the replacement for Secure Sockets Layer (SSL).
  In preparation for this requirement, Authorize.Net plans to disable TLS 1.0 and TLS 1.1 on the following dates:

  Sandbox: COMPLETE Production: September 18, 2017

  We have disabled the sandbox in advance of production to allow you and
  your developer time to test your website or payment solution and
  ensure you are no longer using TLS 1.0 or 1.1 prior to September 18th.

  Please contact your web developer or payment solution provider, as
  well as your web hosting company, to confirm that they can support TLS
  1.2 for your API connections.


texts: I have entered about 5000 contacts and i want to add some of these contacts to a smart group. This smart group is a list of our paying members. How to add individuals from the list of contacts to a smart group? i ihave done Contacts>Manage Groups. Then i select the particular Group (which is called BI Members). This gives me a list of contact who are already members (with the help of a co-worker who left the organization). Then i select "add contacts to BI Members". i enter a name of a contact and it appears in the list. i select and hit add. but the contact is not added to this smart group.


texts: Error on contribution details display, recently updated system

texts:
Current CiviCRM is 5.6.1 running on Drupal 7.60. This system was very recently updated from 4.4.4 running on Drupal 7.36 or something. The updates were done cyclically, one right after the other, to bring it all up to date, and nothing seemed to have gone wrong.

Problem I'm having is when viewing Contact Contributions tab. The main list displays fine, but if I click on the Amount, to get an expanded details view, the expanded area often says Sorry but we are not able to provide this at the moment, and there is at the same time a pop-up notification bubble that says One of parameters (value: ) is not of the type Integer. This does not happen for every contribution, just for many or most of them. Some of them display correctly.

I checked the Troubleshooting help page, which suggests turning on debugging including backtraces, so I did that. Sadly, nothing at all seems to have been added to the log file after reproducing errors with this setup (I don't have shell access to the server, but log files exist and I can ftp them down).

However one interesting thing did happen when I turned on debugging. Now the error message changes. The expanded space in the list is now empty, and the notification bubble says Network Error Unable to reach the server. Please refresh this page in your browser and try again. I tried flipping the debug setting on and off a couple times and this was replicable (i.e., with debugging off, the original message about not of type Integer came back).

I suppose I should mention, because you never know, that after the upgrades, I get a yellow warning in the System Status saying the following Price Set Fields use disabled or invalid financial types and need to be fixed if they are to still be used It refers to a field called Contribution Amount that has a type of Text / Numeric Quantity, but none of our users know what this field is, whether it is custom added here, or whether it is being actively used. It is not at all clear to me if this could be related to my main problem.

Any clues about how I can debug this are much appreciated, esp. given the situation that nothing seems to end up in the log even with full debugging traces turned on.


texts: How to fix it? By pressing “Print Summary”, there are 2 extra blank pages printed

texts: By pressing "Print Summary", there are 2 extra blank pages printed. One of them is before the content and the other is after. How can I make them disappear? I'm using CiviCRM version 5.10.4. Thanks.


texts:
Is there a bug in Follow-up activity search?

I open Advanced search > Activities
Choose: Has a Followup Activity? = Yes
Click Search
Result = Error

Also tested in CiviCRM Drupal sandbox.

Option Is a Followup Activity? seems to work OK.


texts: Upgraded CiviCRM 4.4.6 to 4.5.4; Case is adding but its not showing?

texts:
Upgraded civicrm 4.4.6 to 4.5.4. Case is adding but its not showing?
I am using drupal-7.22.


texts: Civicm change UFID to ContactID relationship programatically

texts:
How can I programatically change the ufid and contact id of CIVICRM?

I know the table civicrm_uf_match  holds the matching ids but even if I change that it doesn't matter.  It seems like the ids are put into session but even if I try to change the session variables via:

$session =& CRM_Core_Session::singleton( );
$session->set( 'userID' , $myjoomauserid);
$session->set( 'ufID' $mycivicid);

everytime I click renew member its the same member.  I need to be able to change it all on the fly for my custom user interface.  It allows a user to view all civicrm contacts and memberships associated with one email address.  Then the user can edit renew whichever ones they want -- I created this to allow families to be able to edit there kids and for clubs to edit their members.  Any help with how this works would be geatly appretiated.  I used to set the ids in the civicrm_uf_match programatically then log the user out of joomla and log them back in but that doesnt seem to work anymore since the civicrm uprade to 4.6

I am not sure if synchronizeUFMatch as seen in some of the ecode is the route i neeed to look into such as

$ufmatch = self::synchronizeUFMatch($user, $userSystemID, $uniqId, $uf, NULL, $ctype, $isLogin);


texts: Configuring cron using PHP cli method results in Permission denied

texts:
Centos 7 with selinux set to permissive. Using apache as the user and confirmed apache has execute permissions to the folder and file in plugins/civicrm/civicrm/bin/cli.php

The crontab entry -

1 * * * * apache /etc/php.ini var/www/domainfolder/public_html/wp-content/plugins/civicrm/civicrm/bin/cli.php -s domain.com -u wpuser-cron -p wordpresspasswordhere -e Job -a execute

The error generated is -

X-Cron-Env: <SHELL=/bin/bash>
X-Cron-Env: <PATH=/sbin:/bin:/usr/sbin:/usr/bin>
X-Cron-Env: <MAILTO=root>
X-Cron-Env: <HOME=/usr/share/httpd>
X-Cron-Env: <LOGNAME=apache>
X-Cron-Env: <USER=apache>
Date: Fri, 12 Aug 2016 15:01:01 -0400 (EDT)
Status: RO

/bin/bash: /etc/php.ini: Permission denied

Running it as the user apache definitely seems wrong. I did so just to see that I could get the cron job running properly; then revisit selinux settings to deal with creating a group with the correct permissions and a cron user for this job.


texts:
I am running 4.7.8 but cannot find the option to Import from CSV for multiple choice options under a custom field - is this possible?.

Any assistance would be appreciated.

Thanks

Steve


texts: Getting error when using civix generate:module or civix generate:entity curly braces no longer supported in phar

texts:
Getting this error when using civix to generate a module or an entity:
Fatal error: Array and string offset access syntax with curly braces is no longer supported in phar:///usr/local/bin/civix/vendor/civicrm/cv/src/BuildkitReader.php on line 38

Can anyone explain what could be causing this and what I could do?


texts: I'm considering using CiviMember and CiviDiscount to offer discounts to members... but when I try to create a new discount code, there is no member option.  How can I enable this feature?


texts:
I am in complete disagreement with Coleman that this is off-topic and should be shoved out to the General Unix and Linux StackExchange.  As I seem to be unable to communicate with Coleman through StackExchange, I am reposting this question.

CentOS has their listed repo's at:  https://wiki.centos.org/AdditionalResources/Repositories  I'd prefer not to get unnecessarily toasted over generally available information.

As one can see, there are many different ones.  However, what are the dev's using?  What's being tested against?  CentOS 6 is still a supported product, yet CiviCRM 4.7 pushes the PHP recommendations past what is default PHP install is for any CentOS/RHEL/Scientific packaging.  CentOS 7.2, the newest general release is paired with the PHP 5.4 branch, yet the recommended PHP for CiviCRM is the 5.6 branch.

This is CiviCRM specific.  What are the dev's expecting when I install CiviCRM?  I can choose a million different ways to install PHP, but only a few of them may work as expected.

Is there any kind of "official" repo for upgrading PHP beyond the stock PHP 5.3.3 found in CentOS 6.7? I'm trying to utilize the SCL repo's, but finding all sorts of peculiarities that seem to point back to this dual PHP install method.


texts:
I'm using the API to create Contacts start Memberships through a signup form. We are offering 1-year memberships at various price points, and I have those set up in CiviMember. My code successfully creates Memberships.

What I'm trying to figure out are the API options for payments. There are API options for creating both a Contribution or a Payment.

Do I need to create both in my API call?

What I found was that a Payment requires a contribution_id, so it seems like they're connected. In another question I saw it's possible to associate multiple Payments with one Contribution. It just seems these two concepts duplicate a lot. Is it correct then that a Contribution just records that a Membership price was agreed to, so it's like an itemized bill at a restaurant? And then that a Payment can be $20 in cash and the rest on a card (one or multiple Payments)?

Also, we accept checks, so I noticed that a Contribution can be marked with is_pay_later to capture that. Would that flow for a person registering with a check be that I create a Contribution with the API at first-signup to record their agreed-upon "bill," and upon receiving the check later a person manually enters the Payment in the backend?


texts:
Working on a site running civicrm 4.4.11

Using Find Contacts to find contacts of type "organisation"

Returns 1206 contacts paged over 25 pages.

We can use forward and back to navigate between results pages, but when using the option go to page x/25. Sometimes the search results disappear and it returns to the find contacts page with the error message

  No matches found for:
  Contact Type - 'Organization'

  Suggestions:

  check your spelling
     try a different spelling or use fewer letters
     if you are searching within a Group or for Tagged contacts, try 'any >group' or 'any tag'
     add a New Individual, Organisation or Household
     make sure you have enough privileges in the access control system

I've tried flushing the drupal and civicrm caches, and still get the error.

Anyone got any suggestions?

Cheers

Craig


texts: Membership/Contribution does not get updated

texts:
I’ve been using CiviCRM for half a year now and I think it’s great. There is just one thing that does not work quite right: When I add a membership/contribution to a user, both get recorded in the database but they don’t show up immediately. I have to wait a day or so for them to display correctly.
I attached 3 screenshots: When I click on Summary, the „Contributions“ and „Memberships“ registers show that Contributions/Memberships have been added. But as soon as I click on them, they get greyed out and don’t show anything. Interesting enough, if I change other member details (name, address, etc.), the changes are shown immediately.
I already tried clearing Joomla’s and CiviCRM’s caches but no success.

Does anybody know why this is happening?

Thank you very much in advance!

cejavila

PS: I was on 4.7.29 and am now on 5.1.2 (thought the update might help, but nope)


texts: Civicrm not working after install locallhost

texts: After install civicrm and drupal in localhost,


texts: Currency formatting incorrectly on Membership Renewal Reminders

texts:
Since the upgrade to civiCRM 5.1.3 our email Membership Renewal reminders have been coming out with membership_fee formatting incorrectly i.e. $80.00 is displaying as $80.000000000
I've tried changing the parameters in the Localization settings but nothing seems to make any difference. Could this be a Drupal problem instead?
Anyone seen this before and got ideas or suggestions? thanks.


texts: Duplicates being created by Webform Submissions

texts:
We are seeing issues when users submit a Drupal Webform and accidentally click the submit button twice, duplicate records are being recorded in CiviCRM. This goes for creating 2 of the same contact or assigning 2 event registration to the same contact.

This was never an issue before but seems to have crept in after we upgraded to CiviCRM 5.0.2. We are now on CiviCRM 5.5.3

Using webform_civicrm 7.x-4.21

Any guidance would be appreciated


texts:
we downloaded and installed civicrm a few years ago, and have a recollection of being able to manage multiple organizations through one installation... is that still "a thing"? We are envisioning creating a central arts database in our community and collaborating more closely on fundraising among all the arts organizations who would like to participate.

we would, of course, want to be able to keep the contacts (and donations) for each organization separated, and track which org referred which donor to who...

please advise if i am completely delusional :)


texts:
I want to create custom field set for my custom entity.

I have Lead.xml

and there:

  < class >Lead< /class >
  < name >civicrm_lead< /name >

inside cg_extend_objects I put title:Lead, value:Lead

But I'm not able to create custom field set for Lead now.

I've tried to debug it.
to CRM_Core_BAO_SchemaHandler::createTable
this array is passed:

Array
(
    [name] => civicrm_value_cccc1_16
    [is_multiple] => 0
    [attributes] => ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
    [fields] => Array
        (
            [0] => Array
                (
                    [name] => id
                    [type] => int unsigned
                    [primary] => 1
                    [required] => 1
                    [attributes] => AUTO_INCREMENT
                    [comment] => Default MySQL primary key
                )

        [1] => Array
            (
                [name] => entity_id
                [type] => int unsigned
                [required] => 1
                [comment] => Table that this extends
                [fk_table_name] => Lead
                [fk_field_name] => id
                [fk_attributes] => ON DELETE CASCADE
            )

    )

[indexes] => Array
    (
        [0] => Array
            (
                [unique] => 1
                [field_name_1] => entity_id
            )

    )

)

and this SQL is generated:
CREATE TABLE civicrm_value_cccc4_18 ( id int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Default MySQL primary key', entity_id int unsigned NOT NULL COMMENT 'Table that this extends', PRIMARY KEY ( id ), UNIQUE INDEX unique_entity_id ( entity_id ), CONSTRAINT FK_civicrm_value_cccc4_18_entity_id FOREIGN KEY ( entity_id ) REFERENCES Lead ( id ) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

It doesn't take table for Lead entity. Is there any extra coding needed for this?


texts:
I'm trying to add a custom field to the Event form programmatically.

So far, I've created a new extension and enabled it, with hook_civicrm_buildForm function in a PHP file. The function's being executed as I can get it stop at a breakpoint. I'm using the addEntityRef method to add a new field.

/**
 * Implements hook_civicrm_buildForm()
 *
 * Adds a field for linking a parent event
 *
 * @param string $formName
 * @param CRM_Event_Form_ManageEvent_EventInfo $form
 * @return void
 */
function myExtension_civicrm_buildForm($formName, &$form) {

  if ($formName == 'CRM_Event_Form_ManageEvent_EventInfo') {

    $form->addEntityRef('my_field', ts('My Field'), [
      'entity' => 'Event',
      'placeholder' => ts('- any -'),
      'select' => ['minimumInputLength' => 0],
    ]);

    $form->buildQuickForm();
  }
}

I've followed other posts by adding a template file named my_field.tpl in my extension's templates directory with the contents:

  Parent Event:
  {$form.my_field.html}

{* Reposition the above block after the Event Type field *}

But I am struggling to get the field to appear.
TIA


texts: Is this Wordpress Critical Error after Upgrade to 5.24.1 serious?

texts:
Upgrading from 5.23.3 to 5.24.1 - I got a critical error after the upgrade. this is what I can find from the wordpress log around the time I ran the upgrade. (wordpress 5.3) The upgrade was successful - not sure if I need to respond to these errors.

[06-Apr-2020 18:42:36 America/New_York] PHP Notice:  Undefined index: CRM_Upgrade in /home/tarabnyc/www/www/wp-content/plugins/civicrm/civicrm/CRM/Queue/Service.php on line 120
[06-Apr-2020 18:43:33 America/New_York] PHP Fatal error:  Uncaught Error: Class 'CRM_Civirules_Utils_Upgrader' not found in /home/tarabnyc/www/www/wp-content/uploads/civicrm/ext/org.civicoop.civirules/civirules.php:106
Stack trace:
#0 /home/tarabnyc/www/www/wp-content/plugins/civicrm/civicrm/CRM/Utils/Hook.php(286): civirules_civicrm_managed(Array)
#1 /home/tarabnyc/www/www/wp-content/plugins/civicrm/civicrm/CRM/Utils/Hook/WordPress.php(139): CRM_Utils_Hook->runHooks(Array, 'civicrm_managed', 1, Array, NULL, NULL, NULL, NULL, NULL)
#2 /home/tarabnyc/www/www/wp-content/plugins/civicrm/civicrm/Civi/Core/CiviEventDispatcher.php(86): CRM_Utils_Hook_WordPress->invokeViaUF(1, Array, NULL, NULL, NULL, NULL, NULL, 'civicrm_managed')
#3 /home/tarabnyc/www/www/wp-content/plugins/civicrm/civicrm/vendor/symfony/event-dispatcher/EventDispatcher.php(184): Civi\Core\CiviEventDispatcher::delegateToUF(Object(Civi\Core\Event\GenericHookEvent), 'hook_civicrm_ma...', Object(Civi\Core\CiviEventDispatcher))
#4 /home/tarabnyc/www/www/wp-content/plugins/civicrm/civicrm/vendor/symfony/event in /home/tarabnyc/www/www/wp-content/uploads/civicrm/ext/org.civicoop.civirules/civirules.php on line 106


texts:
Hi this is our first season with CiviCRM. Our data is uploaded and getting to grips with updating processes.

Our process is annual membership collected in cash and banked in tranches.

The user front end is not really appropriate for the bulk process, manually looking up a member, renewing the membership with a contribution - which is slow enough - but then we need to go to the contribution to record a custom field ( banking id ) for later reconciliation.

A lot faster process would be to work off a downloaded spreadsheet, removing non paid members, and then uploading the contributions & membership.

But, as far as I can see, simply uploading the contributions through import process does not renew that membership - and bulk uploading memberships do not link to contributions.

I guess many orgs bulk upload contribution / memberships - how is this best achieved?


texts:
A member completed the event registration process.  I need to adjust the registration dollar amount from $110 to $0.  I thought I would be able to do that from the financial record page but am having no success.  I also tried to do the credit from the event registration page but no luck.  How do I credit the amount to show the correct financials?  Thank you for any help you can give.
Sheryl Bacon
Ohio Society of Radiologic Technologists


texts:
Hello I am getting the below error when going to certain pages in my civicrm install notably after transfering from one server to a new server....the source server does not have this error.....

CiviCRM_API3_Exception: "DB Error: no such table"

#0 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/CRM/Mailing/Info.php(124): civicrm_api3("Mailing", "gettokens", (Array:3))
#1 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/Civi/Angular/Manager.php(100): CRM_Mailing_Info->getAngularModules()
#2 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/Civi/Angular/Manager.php(178): Civi\Angular\Manager->getModules()
#3 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/Civi/Angular/AngularLoader.php(216): Civi\Angular\Manager->resolveDefaultModules("civicrm/a")
#4 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/Civi/Angular/AngularLoader.php(108): Civi\Angular\AngularLoader->findActiveModules()
#5 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/Civi/Angular/Page/Main.php(83): Civi\Angular\AngularLoader->load()
#6 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/Civi/Angular/Page/Main.php(69): Civi\Angular\Page\Main->registerResources()
#7 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(311): Civi\Angular\Page\Main->run((Array:2), NULL)
#8 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:12))
#9 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#10 /data/www/vhosts/....org.jm/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:2))
#11 /data/www/vhosts/jta.org.jm/httpdocs/includes/menu.inc(527): civicrm_invoke("a")
#12 /data/www/vhosts/jta.org.jm/httpdocs/index.php(21): menu_execute_active_handler()
#13 {main}


texts: How to transfer an event participation from one contact to another in the back end?

texts:
I've been trying to move some event registrations from one contact to another. Noting form the admin screen that there is a 'Cancel or Transfer' link available when viewing event registrations from the contact's 'Events' tab, I gave it a try. Sure enough I got a pop-up asking for the name and email address of the contact to transfer to, and on submitting that it seemed to work, although I then got taken to the event registration form oddly.

Trying the same trick again for another contact record, and all I get now is a message saying "Sorry, You cannot transfer or cancel your registration for  as you are not currently registered for this event." which seems pretty weird given that a) I'm logged in as an administrator and b) that I'd just done exactly this with another contact record.

Looking at https://issues.civicrm.org/jira/browse/CRM-20879 the impression there, albeit an old issue, is that enabling admins to do this is not yet built.

What's the current state of play on this? (running 5.10.4 at the time of writing)


texts:
I have a client with a new In-Kind Payment Instrument and we want it to to go to their In-Kin Financial Account. This is not one of the options how/can we do this?

Thanks!


texts:
TL;DR: Does anyone know why forcing https would break CiviCRM's cron jobs?

A few days ago, I edited my .htaccess file to rewrite URLs to always use https, using the following code:

RewriteEngine On
RewriteCond %{HTTP_HOST} ^example\.com [NC]
RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://www.example.com/$1 [R,L]

That change stopped CiviCRM from running its scheduled jobs (nothing being logged, emails not triggering, etc.). Running them manually still works.

The day this problem came to light, I changed the corresponding cron job URL to https instead of http. No change.

Subdomains with separate databases that don't force https are unaffected. "Force secure URLs" was on without incident before this problem started so I don't think that's a factor.

I'm running CivCRM 4.7.14 on Drupal 7.53.

Edits prompted by answers:

My OS is CentOS 6.9
Certificate has a clean bill of health
I configure my cronjobs via cPanel. The entry for this job, anonymized, is:

GET 'https://example.com/sites/all/modules/civicrm/bin/cron.php?name=actualname&pass=actualpassword&key=longhexidecimalkey'


texts: How do I show in a Contribution report (if I can) the other particpants payment sttaus if they were paid for by another attendee

texts: My finance person wants a contribution report that doesn't just show the contributions for the initial person signing up, but lists individuals that were paid for as additional attendees signed up for and paid for as well. Is that possible?


texts: In CiviHR, is it possible to display the open vacancies on the frontend?

texts:
Using CiviHR 1.4, is it possible to create some open vacancies and display them on the frontend, so that people interested in those positions can apply for them?

If it is possible, I couldn't figure out how to do it.

If it is not possible, do you know when this feature is planned for? I looked at this wiki page and I see that self-service is planned for version 1.5. However, from the descriptions there it wasn't really clear to me whether this would allow people to apply for open vacancies from the frontend.


texts:
I'm using Civi CRM as a local Healthwatch.
I can't see an overview of cases - when I click the button, or try to enact a search, the page below shows.
Any idea how to fix it?

TIA!


texts:
I have a created a custom group and a custom field within that group.

One of the Custom fields is Date.

Is there any way to autoload 'current date' (today) in the default value field Using a hook or something?

I have been googling but i am not getting any results.

Thanks


texts: Negative searches: volunteers WITHOUT relationship to supervisor

texts: I need to get a list of Volunteers (contacts) who DON'T have a supervisor (relationship) ...I've tried Advanced Search and looking for relationships, and I've just tried Search Builder. I can put the ones who DO in a smart group, but can't find a way of putting the ones who don't...Help!


texts: Can I customise the columns on the 'Find Participants' page?

texts:
I'd like to customise the columns on the 'Find Participants' page. I want to swap 'fee level' and 'amount' for 'employer' and 'job title'. Have I missed something obvious in Civi's customisation options? I feel like I've looked everywhere!

(We need to know this info to approve people for our events, and our current process is to export all in a spreadsheet, view the relevant info there, choose who gets approved, then load that info back into civicrm. It would be great if we could just do this all on one screen, without a separate spreadsheet.)

Details: Wordpress 4.9.8; Civicrm 5.4.0

Caveat: I'm not a (fluent/confident) coder or techie person...!


texts: How do I write unit tests that verify a hook is being fired?

texts:
I found this example but it doesn't look like it would generalise to all hooks.

The use case is for API4 - basically whenever any action is called I think we should be able to verify that particular hooks (and only those hooks) are called.


texts: Which payment processor to use for the new 'Paypal checkout'?

texts:
A while ago there was a announcement that CiviCRM now offers "PayPal Checkout".

Which payment processor should we be using to utilise Paypal checkout?

In the list of Paypal payment processors on the latest version of CiviCRM the options provided are:

Paypal express
Paypal Website payments pro
Paypal Website payments standard

Ideally i'm looking for the simplest setup to remove PCI compliance responsibility.


texts: I'm new to CiviCRM and am trying to make it very streamlined for my team. They mentioned that having the Notes (adding ability and listng previous notes) on the Contact Profile's Summary tab would be best for quick access. I'm wondering if this is possible?


texts: Only in WORDPRESS: REST.php ---> Unable to decode supplied JSON

texts:
This is my first post for CiviCRM.

Hi to all.

I have seen others post related and nowadays the problem remain.

Different from this post:
REST API: Unable to decode supplied JSON
 - with wordpress I got always the same response "Unable to decode supplied JSON".

I tried clear installation with Joomla and also Backdrop, and both works correctly.

I am not a good programmer but I tried to do some stuff myself, here you what I prepared on my little server:

WordPress+CiviCRM with the problem: link clear installation

WordPress+CiviCRM fixed myself: custom

Here you what I modified to the file REST.php...

after line 326

    if (array_key_exists('json', $requestParams) && $requestParams['json'][0] == "{") {
      $params = json_decode($requestParams['json'], TRUE);

my modification start here

      $new_requestParams= $requestParams['json'];

      $new_requestParams= str_replace("\\", "", $new_requestParams);
      $new_requestParams= str_replace("\\", "", $new_requestParams);

      $params = json_decode($new_requestParams, TRUE);

I practically saw a lot of "\" before the JSON DECODE.

So removing this "\" now works regularly.

If you wish can check directly on both sites:
Clear ----> http://144.91.105.68/cms/wordpress

Custom ---> http://144.91.105.68/cms/cust/wordpress

The user and password are both same:   admin / admin

And also siteKey and api_key are always:  a42bfc2b33cf13184711bff14fe1fb19

Regards Roberto T.


texts: I need to upload the recent security update to CiviCrm 4.6.15, but I do not know how to or where to go to do same.  I tried under extensions update but it did not work.


texts:
If you have a large number of contacts managed by one 'volunteer rep' as a relationship, when that rep leaves then there is a lot of cumbersome manual data entry.

I have looked and I can't find any built in reassigment function.

All I have worked out is as potential approaches
1.  user heavy  - run the relationship report - download a csv, change something and import
2. do it in the database directly

both not really satisfactory

Any ideas / approaches / am I missing something?


texts: Number of zero after colon in Price field

texts:
Is there a way to reduce the number of 0 after colon in a simple price field in the backend?

For example, this is what I see in Price Fields Window.

I read this post and JonG's answer but I'm not working on a simple donation.

I use CiviCRM 5.19.3 on Drupal 7.67 and currency is euro.

Regards,

Guillaume


texts:
If Jane Doe donates $1000 by the efforts of John Q. Public, I can soft credit John.  However, if Jane pledges $1000 in 10 monthly installments, there's no built-in way to credit John automatically as those pledges are made.  Has anyone encountered this solution and solved it?

Note: I'm the author of the Automatic Soft Credits extension, this is not the correct answer :)


texts: Does CiviCRM have servers in Canada and is it possible to only store your information on them?


texts: how to create a report based on date subscription to a group?

texts:
I need to have a report that shows members according to their date of being part of a chosen group. I can select by group but not by date of being in this group.

Is this possible?

(I have a special process for membership that includes a control step to fully validate the membership. We have to check some documents so there can be a delay between "civicrm membership" and our membership.)

thanks for your ideas

G