texts:
I have a use case where there are public and non public events. Public events should be seen by everyone and can be registered for. Non public events should only be seen and registerable for a certain group (members.

With ACLs I deactivated the CMS permissions and added the rights to view / edit an event. I got as far as to create a seperate ACL for each event which grants the appropriate right in order to make an event public / non-public. This process however is very tedious since it required the creation of a seperate ACL for each event. Is there a way to make this more "global" so that events of a certain category (custom field) are public while others are non public?


texts: System Status Page Error after 5.3.1 Upgrade

texts:
I was simply updating from 5.3 to 5.3.1 and got the following error on System Status Page -

  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.
  You have requested a non-existent service "civi_flexmailer_required_tokens".

This error replaces the entire System Status page. I resolved it somehow by disabling flexmailer and mosaico and then re-enabling them.  Quite odd.

Update: This error also occurred when updating from 5.3.1 to 5.6


texts: How to import/create multiple events from .csv?

texts:
how do one import/create multiple events from an existing .csv file?
I checked the "API csv Import"-Extension (https://civicrm.org/extensions/api-csv-import-gui). But this only updates existing events.

Does anybody know a different method?

or

I thought of creating multiple "empty" events with only an event-id and then updating it through the api-csv-import-ui. Can somebody give me a hint how to do that? (I am not super experienced with the api). Or even providing me with a code snippet, for create multiple events with event-ids from x-y.

Thanks in advance.
Stefan

I am using

drupal7
CiviCRM 5.30.1.


texts: How can I import custom data contact references as names rather than id numbers

texts: When I try to export custom data from the front-end and export a contact reference I get the name of the contact rather than the id. But when I try to do the reverse and import an organization with some custom data(one of which is a contact reference) the front-end demands an ID. Is there a way to fix this?


texts: Search for people who have NOT registered for an event using a custom search or data processor

texts:
I need to search for all users who have not registered for an event.  Five years ago, I asked the question, and the answer was to create a group of users who did register and then do an include/exclude search.
The thing is that I need to do this on a regular basis, for many events.  Creating a group for every event became too cumbersome.
I am trying to figure out how I can do this search, perhaps using the data processor extension.  Where I am stuck is figuring out how to express my intention: "all users who have not registered".

I tried using a search on Participants.  But if someone has not registered, they are not a participant.  So using a search like "all participants for event X where status is not Registered" only shows me people who did register but whose status is now Attended or Canceled for example. It does not show me people who have not registered.

The data processor extension allows you to join data, but I don't see how it lets you do the opposite of a join.  Essentially to say "select all users" plus "exclude (reverse of join) any person who is a Participant for this event".

I believe this is where I am thinking about the problem wrong.  SQL doesn't have such an exclusion call, instead you are supposed to re-think the question so that it becomes a query where join is possible.
So can anyone help me re-think this so that using "join" function of data processor is possible?


texts: Changing CiviCRM Site Key in the civicrm.settings.php file

texts: We have developed a white label Drupal and CiviCRM installation which we plan to use to launch a new server. When changing over I usually change the settings files to match the new database settings. However, I have noticed that the CiviCRM Site key also need to be changed. How can I go about doing this or is this not possible? THanks.


texts: Why are Activity Imports failing with error message "source contact id not valid"?

texts:
I'm running a monthly activity import into a site (4.4.13) [I realise it's due an upgrade to LTS]

We have a standard csv tempalte, and existing field mapping. And have been using the same method consistently for over 12 months.

Today on running the first batch all were rejected with the error message "source_contact_id is not valid : 2"

The source contact field is not included in the import csv and has previously been automatically picked up from  logged in user id ("2").

User 2 is the site admin account and has full permissions.

The csv includes an External ID field which we use to create the "With Contact"

I've tried including The source contact id as a field- failed with same message

I've tried replacing the External ID for the with contact with the External ID with the source contact.- failed with same message

Does anybody have any ideas what may be causing this?

Update 18 Nov

Found a working solution to the above- not sure of this counts as an answer or an extension of the question.

Ran an activity import against a dummy contact and the first few columns of the import ran fine. Then through a process of trial and error worked out that one column (out of 200) was causing the process to stall.

Still no idea where the source contact invalid error message is coming from- but was consistent across all failed attempts.

Setting the offending column to do not import allows the full file to import.

There are two fields in the activity custom data that share a field name (and multi-choice field labels). Don't know if the import mapping points to the same field twice.


texts: Best platform for a new website with CiviCRM: WordPress or Drupal?

texts:
Which platform - at the present day (but also with an eye for the future) - is recommended to use for a new organization that is setting up a completely new website and want to use CiviCRM?

I'm volunteering for this org. and am helping them decide what platform to use

My thinking so far:

For Drupal, i understand that at the present day integrates better with CiviCRM, with fewer bugs and with slightly more extensions.
Drupal has better security (and the org. will be accepting donations and memberships)
Also the fact that CiviCRM uses Drupals "permissions" and "roles" could be a plus maybe?
For WordPress, i'm thinking that the growth and size is a long-term advantage, for example if the organization needs to find more developers.
Also, future development of CiviCRM could maybe be geared towards prioritizing WordPress because of it's popularity?

Grateful for any help on how to think about all of this!

Respectfully and with kind regards,
Tord

Reference: How is CiviCRM different in Drupal, Joomla, and WordPress?


texts: CiviMail tracking opens stopped working after upgrade to 4.7.x

texts:
CiviMail reports track unique opens and total opens, but after upgrading to 4.7 line, suddenly all mailing register 0 opens. I have testing and opened a test email and CiviMail does not register the open.

Has anyone else noticed this or have an idea why this could be happening?

We are on HostGator shared hosting and have the latest version of Drupal and CiviCRM.

Thanks for any ideas.


texts: Exporting primary addresses exports non-primary addresses for some contacts

texts:
I'm exporting contacts with both home and billing addresses, where the home address is set as primary. Even though I've selected primary as the address type for all address fields in the export fields selection, some of the fields in the export are actually the billing address (which is definitely not set as the primary address).

Has anyone else run into this or does anyone know why this might be happening?

It's hard to tell exactly how many contacts this is happening to, but it does seem to be a significant number. I have not been able to replicate the issue on the demo site.

5.7.6 on Drupal.


texts:
I have  a problem with Search Builder on my CiviCRM.
I just wanted to check how many contacts i have in my db outside of Italy.
It should be a simple search:

Record Type = Contacts
Field type = Country
Operator = ≠
Value = Italy

I get this error: "Sorry but we are not able to provide this at the moment.
DB Error: no such field". If i try with another field type, e.g. city, it works.

I've tried the same search in CiviCRM Beta website, it works.

Is there someone who can help me figuring out what could be the problem here?

Thank you very much
Alessandro


texts: Why was individual membership contribution deleted when their organizational relationship was disabled?

texts:
CiviCRM 5.19.2 on Drupal 7.67

We have a member who until recently was part of an organizational membership (by relationship). This year he moved on and took out an individual membership for the coming year. He paid for that himself and everything looked fine.

Then, today I disabled his relationship to his former organization (unchecked the enabled box while editing the relationship). As soon as I had done that, the contribution he had made for his individual membership disappeared!

I can confirm that it is NOT in the civicrm_contribution table. However, the transaction IS recorded in the log_civicrm_contribution table. I also have the email record of it and it's in Stripe.

Is this a major bug or what?

Thanks.


texts: How do I permanently disable the "Similar Contacts Found" pop up?

texts: Whatever name I enter into the first name field I get a pop up of dozens of "similar contacts found" that takes up half the screen, so I have to hit x to close it so I can continue entering into the fields. Can I disable this feature?


texts: Within an extension how can load a custom `Civi` name-spaced class?

texts:
Within my extension I can load classes from CiviCRM's core codebase like this:

$foo = new \Civi\Core\AssetBuilder();

And I can also load custom classes that I've written in my extension like this:

$foo = new CRM_MyExtension_MyClass();

Cool.

But if I've defined a custom class within my extension using the Civi namespace, the following does not work:

$foo = new \Civi\MyExtension\MyClass();

It fails with this error message:

  Error: Class 'Civi\MyExtension\MyClass' not found in ...

How can I load this custom class from within my extension?


texts: Check Processing - How does your organization do it?

texts:
There are quite a few checks that come into our office even though we have credit cards as an option. My question to other organizations would be "How do you handle a check once your organization receives it?" I am just looking for feedback on the best workflow with civicrm.

Currently my organization has an invoice that is generated and emailed to the person after they submit the contribution page with the pay later option. That person sends a check for the amount due with the invoice and then a staff member goes to that persons contact record and updates the pending payment to completed.

Additionally during the end of the fiscal year we have a lot of payments coming through so we use the import payments page and upload csv files to add payments to users records using their external id. This however creates a new payment and does not update the pending pay later check on that users record.

I would love to hear recommendations and feedback on how other organizations process checks? Is there an easier way?


texts:
Presales Question…

I’m trying to determine which features can be turned on & off with this CRM system, so I have a couple of questions I need to ask based on the scenario that I’m trying to solve for the project I’m working on.

Scenario:

I’m designing a website for a business group that I belong to that “refers” each other clients based upon each of our specialties. The goal of the site will be to help each other know how effective each of these referrals actually end up being.

While there will be no monetization towards each of the members within the group, the concept will be to track that Member A referred Client B to Member C. And that Member C made whatever amount of money from Client B. Then subsequently Client B referred Member C to however many people (call this Tier 2 referrals) and they made additional referrals and so on.

The goal is to show (long term that Member A actually should be credited with the total sales volume that Member C made from the down line of that original referral of Client B.

There are no actual commissions to be paid back to Member A since Member C actually is the one that generated the income from that entire referral chain.

Questions:

So based upon what I see, CiviCRM is a traditional CRM with some added features that could potentially be utilized to achieve this is sort of a referral tracking. How do I allow Member C to keep track of their sales activities with Client B (and their referrals) while at the same time allowing Member A to show a referral accumulation (number of referrals and the money generated from them all) for all of the members within our group as a single item. In this case there are 36 of us that are members of this group.

Are these features able to be visual shown across the dashboard as well for each of the members?

Is CiviCRM able to track a Many-To-Many relationship?  In this case the scenario calls out Member A tracking an associated "credit" for Client B and all of the subordinate tiers of referrals from that original referral to Member C?

And lastly is there a summary report that the admin (me for now) can actually utilize to generate a consolidated report for all of the members to see/have?

Thanks in advance for your response.


texts: How to set correct resource url in civicrm wordpress?

texts: I have installed civicrm version 5.26.2 in wordpress, but I'm getting "The Resource URL is not set correctly" I have set resource url as "civicrm.root" still getting the same error. Is there any other way?


texts: Fatal parse error with address in profile

texts:
I have an update your details profile which has started to throw a fatal error:

Parse error: syntax error, unexpected 'new' (T_NEW) in /usr/local/php73/lib/php/HTTP/Request.php on line 412

When I remove the address fields it works as expected (I focused in on the address fields as it would save a phone number even when reporting the error)
I have checked the ConfigAndLog log but there is nothing recorded.  Looking further it is also happening on contribution pages.  I have tried different profiles but to no avail.
WordPress 5.4.2, CiviCRM 5.27.1, PHP Version 7.3.17
I am at a bit of a loss on what is happening here or how to rectify it - any suggestions would be much appreciated.


texts: Ways for an extension to determine how (by which form/screen/API) a Contribution was created?

texts:
I'm creating an extension. It should:

intervene when a Contribution is created, and make some changes to the data
only intervene if the Contribution was created via a public-facing Contribution Page, or via the Import Contributions UI
not intervene if the contribution was created through the back-office UI, batch data entry, a public-facing event registration form, or any other method.

My plan was to use hook_civicrm_pre or hook_civicrm_post to intercept the Contribution at the time of its creation... but I need to know which context the Contribution is being created/updated in, so I can make sure I'm only modifying the data in the desired contexts.

How can I determine, within my hook implementations, what context the Contribution is being created in?

(Bonus points for determining contexts other than the ones I listed above. For example, CLI or REST API.)


texts: I have defined a custom field of type Integer Select.  How can I import a list of integers into the dropdown options list (rather than enter them manually, one at a time)?


texts: Is there a field limit that can be saved in an Export Members function

texts: CiviCRM 4.7.0 and WP 4.4.1 - When doing an Export Members, selecting fields for export and selecting "Use Save Field Mapping" it won't save... unless we limit the number of fields.  Can someone give me the limit on this please.  THANKS.


texts: Mailing -> New mail results in blank page

texts:
4.6.3 with Joomla 3.4.1 and PHP 5.4.4,
When clicking Mailings -> New Mailing, I get a blank page with frozen CiciCRM menus and a single link back to the CiviCRM home page.

New mailing was working prior to upgrading both CiviCRM (from 4.1 ) and Joomla from 2.5. All other parts of CiviCRM are working.

I tried the Troubleshooting guide including disabling extensions but nothing works.  Any ideas?

javaScript errors appear:

  Uncaught SyntaxError: Unexpected identifier
  ?option=com_civicrm&task=civicrm/ajax/l10n-js/en_US&r=TKdmc:5 Uncaught
  TypeError: Cannot set property 'userFramework' of undefined(anonymous
  function) @
  ?option=com_civicrm&task=civicrm/ajax/l10n-js/en_US&r=TKdmc:5(anonymous
  function) @
  ?option=com_civicrm&task=civicrm/ajax/l10n-js/en_US&r=TKdmc:76
  crmApp.js?r=TKdmc:5 Uncaught TypeError: Cannot read property 'modules'
  of undefined(anonymous function) @ crmApp.js?r=TKdmc:5(anonymous
  function) @ crmApp.js?r=TKdmc:13
  ?option=com_civicrm&task=civicrm/ajax/menujs/2/en_US/1/sG2nikkH:110
  Uncaught TypeError: Cannot read property 'resourceBase' of
  undefined(anonymous function) @
  ?option=com_civicrm&task=civicrm/ajax/menujs/2/en_US/1/sG2nikkH:110(anonymous function) @
  ?option=com_civicrm&task=civicrm/ajax/menujs/2/en_US/1/sG2nikkH:111
  angular.js?r=TKdmc:63 Uncaught Error: [$injector:modulerr] Failed to
  instantiate module crmApp due to: Error: [$injector:nomod] Module
  'crmApp' is not available! You either misspelled the module name or
  forgot to load it. If registering a module ensure that you specify the
  dependencies as the second argument.
  http://errors.angularjs.org/1.3.15/$injector/nomod?p0=crmApp
      at REGEX_STRING_REGEXP (


texts: can a search for the individuals in a group display notes instead of address, etc

texts: I would like to be able to read the notes for a group of individuals when I am looking at the resulting list of contacts from a search.


texts:
First time using civicontribute. We get a transaction error when submitting a donation. (see below)
Our donation form submit button has: onclick="return submitOnce(this,'Main','Processing');"

Other people with similar pages do not have an onclick function.
Is that the cause of our problem?
Should we have it?
If not, how do we get the page to be rendered without it?

Here is the error message we get when clicking submit.

"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
Return to home page.

Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in .../wordpress/wp-content/plugins/civicrm/civicrm/Civi/Core/Transaction/Manager.php on line 107"


texts: What time of day are Scheduled Reminder Event Emails sent?

texts:
The 'Scheduled Reminders' tab for events allows the user to set an exact date for a Scheduled Reminder Email to be sent, but there is no option to specify a particular time on that date.
What time of day are such emails sent by civi? Is it 12:00am on the day? Because this is the first time that it is true that the date matches? Or is there some other default time set?


texts:
When clicking Manage Case # on my contact dashboard, I am met with an error

  Cannot determine default context. CRM_Contact_Form_RelatedContact
  should implement getDefaultContext

Is there a setting I am missing, or is this a bug?


texts: Event participants registrations expires for participants that decide to pay later with cash

texts:
We offer event registration where the participant can register and pay later with cash.
However when participants choose to register and pay later, thus on participant status "Pending payment later", CiviCRM simply expires their registration after 24 hours. We are running version 4.6.20 on Drupal 7. Any ideas why this is happening and how I can solve it?
In the meantime I have set the "waiting list" to zero should in case this is triggering the expiration of the registered participants. This setting was previously set to 24 hours. It will be weird if the Event waiting list is automatically expiring registered participants who are in status "Pending Payment Later. I need your brilliant brains. Thx.


texts: how does Civi determine # of installments left in recurring series? (and when it's complete)

texts:
We have the amount, frequency, installments, and status on the recurring contribution with a next contribution date. What determines or sets that a profile is complete? If the amount is $5, the frequency is weekly, and the installments are 4 - how does it track that the installments are completed? Can someone point me to the desired functionality as well as a code/database reference (pretty please). My guess is I'm missing something, or somewhere it just counts 4 contributions that are linked and some process marks it as completed. Thank you!

backstory - we are trying to fix some funky stuff, so I need the ins-and-outs of how this works. D7/CiviCRM 5


texts: Rules for Inbound Mail Processing (multiple addresses? searches?)

texts:
We'd like to use inbound mail processing with a bit more granularity so we can do a post-processing search that will let us easily tag new or updated constituents as YOUTH or ADULT.

Currently, we bcc: inbound@ourdomain.org and the new or updated records are created. However, we need to inspect each inbound email to understand if the contact should be tagged youth or adult.

I don't think we can have two inbound email addresses...if we can, I'd love to know how.

I thought maybe I could do something like use inbound+1@ourdomain.org (for youth) and inbound+2@ourdomain.org (for adults). This does result in the email and the +1 or +2 flag coming in to Civi!  However, I don't see a way to isolate what we need.  For example:

An advanced search for CONTACTS with an INBOUND EMAIL ACTIVITY has a check box for with/added by/assigned, but does not have a place to provide the address of inbound+1@ourdomain.org. If it did, I think this would give me a list of contacts that I would tag as youth.

Another option is an advanced for CONTACTS with INBOUND EMAIL ACTIVITY that contains "inbound+1@ourdomain.org". But I don't think the address shows in the activity records.

Another work-around I thought of is to include a distinct "code" in the emails we write and bcc to inbound@ourwebsite.org. For example, I could put ++y after my sig file when I know I'm writing to a youth and then do an advanced search for CONTACTS that have INBOUND EMAIL ACTIVITIES containing ++y in the body of the inbound email.  This would work but seems way too complicated.

I'd appreciate any thoughts on this process. Thanks!

We're Wordpress 4.7 and CiviCRM 4.7.17.


texts:
I'm currently setting up CiviCRM for a dance institution. They want to create an event for each lesson (weekly) and use CiviMobile on an iPad or something similar to manage attendance.

Now there's a need to group dance partners together. To this end I've set up an extra relationship called 'Dancepartner of' to tie them together.

An example:

Marie dances with Peter
Kate dances with Micheal
Emma dances with Adam

I would like the event participants view to look like:

Marie
Peter
Kate
Micheal
Emma
Adam

I think an SQL join for the relations and a GROUP_BY would do the trick but I have no idea where to begin coding this.

Can anyone point me in the right direction of am I going about this all wrong and should I perhaps use groups ?

Thanks in advance,


texts: CiviRules not accessing 'Tags' after extension upgrade

texts:
Since the CiviRules extension was upgraded, the extension no longer has access to tags.
I had a dozen rules setup that assigned a specific tag when a condition was met. None of those existing tags are showing up in the drop-downs and therefore the rules are not assigning tags when appropriate (see screenshots)
Advice on how to fix would be appreciated.
CiviRules: 2.21
CiviCRM: 5.25.0
Wordpress: 5.4.4


texts: Does Civi CRM have ISO 27001? And is it compliant with ISO 27002 and ISO 27017?


texts: Search for cancelled Paypal recurring contributions

texts:
We want to see reports on how recurring contributions through Paypal are being lost (e.g. due to cancellation, or card expiry). Using the Search function on civiCRM 4.6.38 I set the parameters as follows:

"Contribution is Recurring" Yes: returns 208 contacts

then search again with:
- "Contributions Status" is "Cancelled": returns 0

then search again with:
- "Contributions Status" is "Failed": returns 0

We receive reports from Paypal which confirm that recurring contributions are failing, so there should be some way to search for people who's Recurring Contributions stop. Any ideas?


texts: Is resource_url from civicrm_settings.php saved in the civicrm_setting table, under what name?

texts: Where in civicrm_settings table is resource_url saved? I cannot use the System Settings/Resource URLs to set it, but can access the database.


texts: In Civicase - reports ignore 'Order' on 'Status' and use status id instead?

texts:
When I run a Civicase report and request it to be sorted by 'Status' the sort order comes out according to the id of the status record (ORDER BY case_civireport.status_id). Whereas I have updated the 'order' field on the case status admin and believe the report should use that 'order', not the row id.

Can anyone confirm this? Might it be classed a bug?

I have tried it on https://dmaster.demo.civicrm.org and can confirm that changing the order in Administer->CiviCase->Case Statuses has no effect on the report ordering.

Thanks.


texts: Twilio Extension: "The selected contacts have no valid phone, or prefer not to receive SMS, or are deceased."

texts:
I am on Drupal 7.51 / CiviCRM 4.7.12

I have just installed Twilio (SMS) Extension, purchased a number (+33... (France) from Twilio), upgraded my account, and configured Twilio Extension accordingly (as per https://wiki.civicrm.org/confluence/display/CRMDOC/Setting+up+a+SMS+Provider+for+CiviSMS) : filling username and password with the LIVE API Credentials specified at https://www.twilio.com/console/account/settings.

When I test it (on a test Group), I get the following Error Message :

The selected contacts have no valid phone, or prefer not to receive SMS, or are deceased.

(I did not configure inbound SMS)

Any suggestion would be welcome


texts: Does Contact Editor Extension work with Version 5.6.1?

texts:
I just upgraded to version 5.6.1 from 5.3.1. I tried using the contact editor extension to change a contact type but when I select "Change Contact Type" it take me to the CiviCRM homepage. I use CiviCRM with WordPress.

Does the Contact Editor extension work with 5.6.1?


texts: Relationship disabled by end date but still enabled?

texts:
Scheduled  Disable expired relationships has run succesfully according to the date/time I see in the Scheduled job table. I see a relationship in the disabled relationship section that has an End date older than today, so that seems to work. What I don't understand is that it is still marked "Enabled" in view and edit.

Also when I do an api call on the relationship mentioned before it returns it as an active relationship even though it is expired:

$result = civicrm_api3('Relationship', 'get', array(
  'sequential' => 1,
  'is_active' => 1,
  'id' => 56276,
));

Response:

    {
    "is_error": 0,
    "version": 3,
    "count": 1,
    "id": 56276,
    "values": [
        {
            "id": "56276",
            "contact_id_a": "24943",
            "contact_id_b": "20992",
            "relationship_type_id": "14",
            "start_date": "1995-01-01",
            "end_date": "2004-01-01",
            "is_active": "1",
            "description": "Support Branch",
            "is_permission_a_b": "0",
            "is_permission_b_a": "0",
            "custom_24": "Res",
            "custom_71": {
                "S": "S"
            },
            "custom_71_26513": {
                "S": "S"
            },
            "custom_24_26513": "Res"
        }
    ]
}

How should I understand this? As a bug or a feature? What does the "Enabled" tick box in fact mean? Should I understand it as separate from the start and end date as kind of "override" function?

CiviCRM version is 4.6.27. In case it was a bug, has it been fixed meanwhile?


texts: What is the difference between Email and Mailing?

texts:
I found that if I want to send mail to an individual, I need to use Email while in order to send mail to a group, I need to use mailing. Is this the main difference? Are there ways to schedule Email like in case of Mailings?

Also I could not find a folder for Email in Civicrm folder. Are there DAO and BAO files for Email?


texts: Activity Processor issue with Caldera Forms

texts:
Using
Wp 4.9.8
Caldera 1.74
Caldera Forms CiviCRM 0.4.4

I'm struggling to work out how to expose the activity fields (core and custom) to the layout area once I've added an Activity processor to the form.

I'm using the template for creating two contacts with a relationship, but I need to collect some info and kick off an activity as well, so how do I add the extra fields?


texts: Extra Decimal Places on Fuzion Token 'Latest Membership Fee'

texts:
Sending a Civimail built with Mosaico utilizing Fuzion Token 1.5 {latestcurrentmembership.allfee}

The amount should be $69.00 on a test record but the email reads:
69.000000000

Any suggestions? Was this the fix? Doesn't seem to be working here? https://lab.civicrm.org/dev/core/commit/8008a9fb36d3bae6bbe077540c7e22fddb3dabef

Update: classical Civimail does it too. Our localization settings are English, USD. Monetary Amount Display: %c %a


texts: PayPal recurring payments delayed by days

texts:
We've been using recurring payments with the 'PayPal - Website Payments Pro' processor for several years now. In the past we'd see an occasional delay between the user's submitting the payment on a CiviContribute page and the transaction being recorded as "Completed" in CiviCRM. The delay would be minutes or hours.
Recently (say, last 2-3 months), we've seen delays as much as several days; two recent examples: the contributions were initiated (and thus the recurring subscriptions were created in PayPal) on 4/1, but PayPal only actually processed the first payment on 4/6.
Found the following, poking around PayPal's knowledge base: https://www.paypal.com/us/smarthelp/article/why-are-some-of-my-initial-payments-delayed-when-i-use-my-recurring-payments-profile-faq3682
Anyone else experiencing this? Any way around it?
(Reason this is important to us is we provide discounts on events for members, and folks often sign up for membership right before registering for an event, and they don't receive their discount if the payment processing is delayed.) Thanks for any tips.


texts: Remove display of location field in Current and Upcoming Events view - Joomla

texts:
We are using CiviCRM  4.6.28 on current Joomla version.
As we are using the training location in the title already we would like to remove the display of the location column as it is irritating if it shows (not available).

Is there any way of removing this without hindering further updates?


texts: Symbunt Report: I need Advanced time period option

texts: I want to track who has donated to our non-profit through a time period (2010-2013) but want to exclude donors who have given since 2014-present.


texts: Is there a way to have a Send Email button on an Activity?

texts:
When an email comes in as an Activity and we view the Activity It would be nice to have a button on the ACtivity to reply to the person and it create a Send Email action for that user.

Has anyone done this with an extension?


texts: How to send a contribution receipt through a text message when receiving a donation

texts: I would like to know if it is possible to send a text confirmation message or a WhatsApp when we receive a contribution from a donor.


texts: Contribution Page-Amount page options now showing

texts:
0
down vote
favorite

Greeting, When I add new Contribution Page then chick on "Amount" option in CiviCRM, In the "Amount" options page all checkboxes and radio buttons except PayPal Standard checkbox will disappear also Minimum Amount and Maximum Amount text boxes not showing .

I open the page in 4 different web browser and I cleared the cash and flash my Drupal website and still these options now showing. I am using Drupal 7.41 and CiviCRM 4.6.10.

Please advice how to fix this problem.

Regards,


texts: Is there a way to automate event feedback using Civi and Drupal webform?

texts:
What we are looking to do is find a neat way to create a process for sending out an automated email from Civi with a link to a form of some type for a feedback or evaluation on the event that a person has booked on. We would ideally like this feedback or survey to be attached to the participant record in Civi (i.e. so its easy to see which event they are feeding back on and to find the feedback easily in Civi). I'm not sure if I can see any simple way to do this at the moment.

So I guess the idea would be to send the email as a scheduled reminder with a checksum token to a webform, and also have in the url the event ID. The event id would then allow the user to update their participant record for that event with some custom fields which are the feedback fields (or we could copy a link to the webform submission into a text field).

But to use 1 webform for all events and to pass the event ID to a field of event ID on the form, there is an issue that this will unsubscribe the contact from any other events that they were previously registered for.

Any one got any thoughts on a solution?


texts:
One of the ways I have set up my system to auto-increment a value (registration number) in a custom table is by using a custom database trigger.  They are quite straight forward - after insert, update with the next value.
I have developed 2 triggers that seems to work well for me, however, I'm not entirely certain why but the triggers are disappearing on me over time.  One trigger is on the civicrm_membership table (updates a civicrm_value table) and a civicrm_value table.  This is one of them:

CREATE TRIGGER `Increment_Dog_Number`
  BEFORE INSERT ON `civicrm_value_registered_dogs_5`
  FOR EACH ROW
    SET NEW.ddog_number_19 > = (
      SELECT MAX(ddog_number_19)+1 FROM civicrm_value_registered_dogs_5
    )

I'm not sure what is causing the triggers to be dropped -- any suggestions on how to work around it?

Thanks
Norm


texts: Activities don't show on the profile page

texts: This child has three activities linked to his profile, however they don't show up. The do show up if we navigate to cases, but we would like to see them from this profile view. Is there any way I can get this working?


texts: I see that Stripe can be used with CiviCRM but is Stripe Checkout ( https://stripe.com/checkout) an option with CiviCRM?


texts: Is it possible to group by a date in a Drupal view?

texts:
I'm building a Drupal 7 View in which I want to aggregate contribution records for the year, grouping by month. But View's native aggregation option happens after the query is generated, so it's not possible to group by MONTH(receive_date). I tried using the Views Date Format SQL module, which in theory should let me apply the group by on the query, but it doesn't seem to handle non-core-Drupal date fields.
I also explored using Views Aggregator Plus module, which does let me render a table with correct grouping. But my end goal is to display a chart (using the Charts module), so I need to be able to build the aggregate query without an alternate display format (you can't use VAP and Charts together -- they are mutually exclusive display format options).
I feel like the ability to use Views to generate aggregate stats on Civi data is probably something people are doing... but I'm getting stuck.


texts: Why does the user not get a "transaction complete" or "success" confirmation message after submitting an online transaction?

texts:
Just updated to CiviCRM 4.6.26 from 4.6.x. Using iATS 1.5.3. Using D7. The user does not experience a completed transaction even though the transaction is complete through iATS and shows complete on user record (and in iATS dashboard in civi). The submit or "make contribution" link appears to hang up. No confirmation is sent to user or administrator. This results in the user attempting to resubmit. Any solutions? Any troubleshooting tips?

BTW: we have changed no configurations on contribution/registration pages. Previously working. But now they all hang up, we get no confirmation or "success" notification on any of our pages.

This has been resolved here: iATS Scheduled job for recurring payments does not "finish" in the logs. How can I fix this or troubleshoot further?


texts: CiviCRM upgrade from 5.12 to 5.29 - failure

texts: Tried to upgrade CiviCRM on Drupal 7 website. Drupal core 7.73. Using PHP 7.1. Upgrade process started well but received this message: You must reload the database with the backup and try the upgrade process again. I do have a good backup of database. What should I do? How do you reload the database?


texts:
Sometime, I think in May, our PayPal IPN communication broke. We haven't had a lot of PayPal use since then, so I haven't discovered it until recently. I'm having a lot of trouble straightening it out.

I've gone back over the troubleshooting ideas here. But still no luck.

That did help me narrow it down. I know this:

PayPal sends the IPN.
Civi logs the IPN in the Civicrm_system_log table, and I can't see anything strange about it, but I'm not sure what it's supposed to be. Here's the text

{"reset":"1","contactID":"4280","contributionID":"8377","module":"event","eventID":"33","participantID":"851","mc_gross":"900.00","invoice":"414ae4f493f47e11619bf7efc10b9f7b","protection_eligibility":"Ineligible","payer_id":"XSJW7PJ3W2WTE","tax":"0.00","payment_date":"16:59:26 Sep 14, 2016 PDT","payment_status":"Completed","charset":"windows-1252","first_name":"Ed","mc_fee":"20.10","notify_version":"3.8","custom":"","payer_status":"unverified","business":"office@MYDOMAIN.org","quantity":"1","verify_sign":"Adbt8gdfutr1Z-T39jfFAojvxDVnASV9dlQzsWCS5U9rO.yPNTzpJ.RF","payer_email":"him@hisDOMAIN.com","contact_phone":"xxxxxxxxx","txn_id":"77F61134Y5474453P","payment_type":"instant","last_name":"xxxx","receiver_email":"xxxxxxxxx","payment_fee":"20.10","receiver_id":"VLKFZ88QB68QL","txn_type":"web_accept","item_name":"4280-8377-Wine for Water","mc_currency":"USD","item_number":"","residence_country":"US","receipt_id":"2531-4793-0283-6721","handling_amount":"0.00","transaction_subject":"","payment_gross":"900.00","shipping":"0.00","ipn_track_id":"d48d1e5a8c3da"}

the IPN doesn't update the payment from Pending to Completed. The really bad thing is that event registrants don't end up getting their proper email confirmation.

What are some next steps to get to the bottom of this?

Joomla 3.6, Civi 4.7.11


texts: Is it possible to create nested multiselect custom field?

texts:
The use-case is a business directory. Businesses sign themselves up and provide info about their operation. There are many types of businesses (NAICS), and the options they need to self-identify as are nested in a multiselect format. Is this re-creatable with CiviCRM?

See image.

Thanks!


texts: Does this view error mean CiviCRM has lost some MySQL DB perms?

texts:
The last CiviCRM upgrade I was running, I received a couple of the same DB errors. Sanitized, minimally, the error was as follows:

#7 /srv/www/sites/d1.orgname.org/www/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /srv/www/sites/d1.orgname.org/www/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("CREATE OR REPLACE VIEW civicrm_domain_view AS SELECT * FROM civicrm_domain")

Does that mean that CiviCRM has lost some of its MySQL DB permissions and I must rebuild the DB (according to these instructions) ?

I went looking for where in the CiviCRM source code that view is mentioned, and found:

$ grep -r civicrm_domain_view *
CRM/Core/DAO.php:      $dao->query('CREATE OR REPLACE VIEW civicrm_domain_view AS SELECT * FROM civicrm_domain');
CRM/Core/DAO.php:          $dao->query('DROP VIEW IF EXISTS civicrm_domain_view');
CRM/Core/DAO.php:          $dao->query('DROP VIEW IF EXISTS civicrm_domain_view');
CRM/Core/DAO.php:      $dao->query('DROP VIEW IF EXISTS civicrm_domain_view');

I tried running this via PHPMyAdmin:

SELECT *
FROM civicrm_domain_view;

And receive an error that the view does not exist.
"#1146 - Table 'd1_civicrm.civicrm_domain_view' doesn't exist"

Next I tried executing:

CREATE OR REPLACE VIEW civicrm_domain_view AS SELECT * FROM civicrm_domain

which told me the MySQL ID did not have permissions to create the view.

So I checked, what do you know that was not a permission I granted to the CiviCRM ID. I provisioned the MySQL account according to these instructions. They do not state that the Create_view_priv perm is required, if this is even the correct perm. (I just saw the word "view" and looked there first.)

Suggestions?

I am thankful,

Michael


texts: Is it possible to use inline css in Mosaico? I tried it, but it was taken out. It works in Civimail. Thanks. I have been trying to get this working for a while.


texts:
I am on civi 5.16.3, drupal 7.X and stripe 5.4.1
and when setting up stripe webhook, keep receiving this message. how can I fix it please? Thanks


texts: My ACL Role is now showing selected contact groups

texts:
I tried digging through other questions before I posed my own. So, I'm asking for a solution here.

What I want to do:
I want to give a group of contacts ability to 1. Create and edit events based on templates 2. See Event participants 3. See a select group of contacts that have custom fields, custom profiles and some with custom activities.

What I have done so far:
I have created a Role in Drupal and given a select number of Civi access including CiviEvents. I turned off See All Civi Contacts.

Then I created an ACL Role, Permission and ACL access
The ACL access includes most view activities related to contacts in the select group I want them to see. I also want them to see custom profiles and custom fields.

Problem
When I log into the website as an end user (member of the group) I can see the CiviCRM Menu, Add and Event, etc. But I am not able to see any contacts even though my ACL Role indicates I should be able to see this set of contacts and it is turned off in Drupal permission.

I also tried turning on the See All Contacts in Drupal and it showed me far more than I should be seeing with this user role.

I checked the ACL Roles against the Drupal ones and I am still running into problems. Any advice?

I am using Drupal 7 and the Civi 4.7.24.


texts: Help on Contribution import - Invalid value for field(s) : Receive Date

texts:
I've recently wanted to add the time to my import of external (non-Civi) transactions. Before this, I just imported the date, which is OK, but the data is there, so why not import it?

I keep getting an "Invalid value for field: Receive Date" error when I try to run the import. Here's the value returned in the Import Error file:

Receive Date: 07/28/18 02:34 AM

I know I select the proper date format mm/dd/yy for the first step of my import. I can't figure out what the problem is.

Receive Date is a datetime in SQL in case that might be relevant.
Civi 5.2.1


texts:
There seems to be a bug in doing searches on date ranges - specifically in Advanced Search and in Find Contributions. We're using Drupal and Civi 4.6.2.

When I type into Adv Search's Member Since date range fields OR Find Contribution's contribution date range fields only 2 digits for the year (1/1/14) I get a nonsensical number of records back. No error msg, just an obviously wrong set of data. I confirm by looking at several records but they do not match the date range in either Member Since or Contrib Date.

However, when I type in all four year digits, then I get the expected results.

I have tested this in the demo Civi and received the same results for both - only 2 digits gets bad results, 4 digits gets correct one.

I used to be able to type in only 2 digits (since we started using Civi in 11/12).

Please add in an error message or change the field instructions.

Thank you.


texts: Has CiviCRM ever undergone formal usability testing?

texts:
Drupal 7 was put through formal usability testing at the University of Minnesota's excellent Usability Services Lab.

Has CiviCRM ever been through such a process? If not, I would be interested in facilitating this, as I work at the University of Minnesota and have access to this lab.


texts:
I'm getting two error messages:
Warning: Invalid argument supplied for foreach() in wf_crm_get_fields() (line 910 of /home3/site/public_html/sites/all/modules/webform_civicrm/includes/utils.inc).
Notice: Undefined index: caseRoles in wf_crm_get_fields() (line 910 of /home3/site/public_html/sites/all/modules/webform_civicrm/includes/utils.inc).
when I try to enter information on Drupal 7 using a webform.
What could be causing this issue? Is there a way that I can work around this issue?
Thanks!


texts:
I have a CiviCRM install on Windows shared server operated by a client. The installation was originally set up on a dedicated Ubuntu Linux virtual server, but was transferred to the Windows server at their request.
Since the transfer from Linux to Windows I am getting frequent MySQL errors when trying to edit or add custom fields.
The following is a typical error in the CiviCRM logs:
ALTER TABLE civicrm_value_mycustomfield_8
  ADD COLUMN `myfield_year_142` double DEFAULT '\x012021\x01',
  ADD INDEX INDEX_myfield_year_142 ( myfield_year_142 )
  [nativecode=1067 ** Invalid default value for 'myfield_year_142']

As you can see, CiviCRM is creating queries that try to insert hexadecimal character codes into numeric fields. The default being set should be '2021'.
The MySQL database on the server being used I note is cp1252 West European (latin1), although I wouldn't usually expect that to cause problems. Table collation (which doesn't affect numeric tables anyway) is utf8_unicode_ci.

CiviCRM version 5.37.2
MySQL 5.7.34
PHP 7.3

I've resorted to manually running MySQL queries to get custom fields established properly, but obviously there are all sorts of reasons why that is not a great idea.
Does anybody know what's going on here, and how to resolve it?


texts: I am getting people added to our database from Contact Source called Get Updates.  I don't know what that is.


texts: How can I collect custom contribution data in an event registration form?

texts:
People register for events. As part of that registration I want to collect some data that will be stored as part of their participant record. No problem.

I'd also like to collect information that will be stored as part of the contribution record linked to the event registration, but there seems to be no way to do this, as I can't access the profile containing the custom contribution fields in the online registration set-up for the event.

Am I missing something, or is the only way to do this by using a Drupal webform.


texts: Custom date field throwing DB constraint error "cannot be null"

texts:
I have a date field associated with a particular case type. When I try to create a new case, it is failing because the dates are empty. However, when I created the custom data, I did not make them required. There is one custom field that seems to work but it submits the empty field as '' (an empty string) as opposed to null.

Why is there a not null constraint on those fields, and ok to fix this by manually setting all those columns to allow null values?

We are using Drupal 7, CiviCRM 4.7.4


texts: API - Create a contact from an external site

texts:
I have the need to create/update a contact from an external site.
If I understand correctly, the only way to do this is to use Rest API. In my test I had no problem to read the database, but when using the "create" action, as in the following PHP code:

  $url='http://.../sites/all/modules/civicrm/extern/rest.php?entity=Contact&action=create&api_key=...&key=...&json={"sequential":1,"first_name":"Gianni","last_name":"Predan"}';

  $responsestr = file_get_contents($url);

I obtain the error "All requests that modify the database must be http POST, not GET."

What should I do?
Thanks


texts: For activities of type Email, how do I get the id for the activity just created during hook_civicrm_postProcess?

texts:
Normally during hook_civicrm_postProcess, you can get the id of the just created activity from $form->_activityId. For activities of type Email, I can't see how to get the activity id. Am I just missing something simple?
I don't think I can use hook_civicrm_post instead because I want to use information in the form that isn't in the activity object, but the form info isn't available in hook_civicrm_post.


texts: Property of non-object notice after submitting CiviCRM Webform with Contributions

texts:
I’m using Webforms for CiviCRM 4.28 for a membership registration and payment form and have Pay Later set as the payment method. When the form is submitted I get the following errors shown on the confirmation screen once the form has been submitted.

Notice: Trying to get property 'tax_amount' of non-object in CRM_Contribute_BAO_Contribution::checkTaxAmount() (line 4272 of /xxxxxxxx/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php).
Notice: Trying to get property 'total_amount' of non-object in CRM_Contribute_BAO_Contribution::checkTaxAmount() (line 4278 of /xxxxxxxx/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php).
Notice: Trying to get property 'total_amount' of non-object in CRM_Contribute_BAO_Contribution::checkTaxAmount() (line 4279 of /xxxxxxxx/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php).
Notice: Trying to get property 'fee_amount' of non-object in CRM_Contribute_BAO_Contribution::checkTaxAmount() (line 4278 of /xxxxxxxx/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php).
Notice: Trying to get property 'fee_amount' of non-object in CRM_Contribute_BAO_Contribution::checkTaxAmount() (line 4279 of /xxxxxxxx/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php).

I have the Membership and Contribution tabs of the CiviCRM Webform panel set up as follows.

The payment screen looks fine and the message shows after the form has been submitted.

I’m running CiviCRM 5.16.2 against Drupal 7.67.

Any ideas what could be causing this and how to resolve?


texts: How can we get Custom data Used For: Relationships to display in a Drupal View?

texts:
Relationship is e.g. Board Member - custom data on that Relationship is e.g. Treasurer (or President).

We can pull the Relationship into a View but even using CiviCRM Relationships as a base table - we can't seem to add the Custom data as Fields.

We double checked that the specific table got copied into the settings.php:
  'civicrm_value_committee_relationship_data_7' => 'civicrm_project_org.',

Curious if anyone has any ideas on how to get this working!

On 4.6 LTS for this project;


texts: Using Export Contacts from Search Builder w/ Field Mapping, mapped field's columns not exported

texts:
Website is running 4.7.25 over Drupal.  I was able to replicate this on this demo site, which is running at version 4.7.28, as well: http://dmaster.demo.civicrm.org/civicrm

Here are the steps to take to replicate the issue:

Selected Search Builder
Set extensive search criteria (like 12 of them)
Set Select Records: to 'all'
Select Export Contacts Action
Search Builder Export Options (Step 2 of 3):
Select Fields to Export checked
Used Saved Field Mapping (note that I get the same problem regardless of my choice here)-- there were 17 fields in my map
All other left at their default
Clicked Continue
Select Fields to Export (Step 3 of 3)
Left at defaults
Clicked Export
Opened resulting downloaded csv.
Columns were NOT as mapped; they seemed to be the fields shown on the search results, rather than what I had in field map.

I have several screen shots, but (sorry) cannot see how to post them here.

My workaround will be to select Primary Fields (80 fields) in the Export dialog,  and just use the 17 columns I want in the resulting .csv.  But, it would be cleaner/simpler for using in any automated processes if this worked correctly, so I thought I'd submit it if it's truly a bug.  Unless someone here can point me to what I'm doing wrong?

Thanks!


texts: CiviMail problem; possible Cron Error: EntityMalformedException: Missing bundle property on entity of type node. in entity_extract_ids()

texts:
After making core updates in Drupal commons, from 7.37 to 7.50, scheduled Civi mails are not being sent. Cron jobs are still set up. Before this update, we've been using it for years with no known issues. Using CiviCRM 4.8.7. Currently trying to upgrade now but there are other roadblocks also.

Watchdog shows the following error for the time of the scheduled mailing:

error    cron     EntityMalformedException: Missing bundle property on entity of type node. in entity_extract_ids() (line 7953 of /var/www/html/example/docroot/includes/common.inc).


texts: Can a price set item be marked "Partially Deductible"?

texts:
Is there a way to add an item and indicate that an item's cost is partly deductible?  For instance, a $500 ticket to a gala dinner that has a $400 deductible component.

I see where to mark financial types as tax-deductible - and I see that there's a field called non_deductible_amount in the civicrm_contribution table.  However, I'm not clear how to populate that value.


texts: How to set a default value for a custom field

texts:
EDIT: this is NOT working, at least in CiviCRM 5.24.2
EDIT: this is done automatically by CiviCRM from 5.18+

I have a custom fieldset on Contributions that uses an option list. The option list has a default value set, but when contributions are created by non-UI processes (e.g. API) they do not have this default value; the field is empty/null/not there.

The fieldset is created by an extension. How could I ensure the default is set for all contributions?

Seems the options might be:

Use hook_civicrm_post then use the API to make a call.
Or could hook_civicrm_pre be used for this? Can you set custom fields in this part of the process?
or a horrible way would be to write an API job to somehow create default entries and run this by cron. Perhaps this might be necessary to set a default for existing contributions though?

Anyone done this? If so, how d'ya do it?


texts: How can I get at the Email address of a Contact Reference? CiviMail and Tokens question!

texts: It's straight forward to insert the Name of a Contact Reference (custom field) in CiviMail using Tokens. Does anyone know of a way to get at the Email address belonging to that Contact Reference?


texts: We currently use "CDN Tax Receipts" to generate our tax receipts. I am wondering if it is possible to also have a cover letter used when this tax receipt is generated?  My hope would be that when I print the PDF tax receipt, it would also generate a letter, with pre-determined information.  Is this possible?


texts: How can I revert a set of bulk changes to the database?

texts: I made a bulk update of addresses that turned out to be incorrect.  I have advanced logging enabled.  I can go into each contact's change log and revert the mistake one by one; how can I do this for all the addresses I altered?


texts:
I am in a process of migrating CiviCRM data to a separate database. I am using the Documenten extension to store some files attached to my contacts and I would like to find the contacts which have documents attached.

The extension page says it should enable this functionality but I cannot find it. Any advice would be greatly appreciated.


texts: CiviCRM Administration areas unreachable even by direct link

texts:
I am setting up and configuring a new CiviCRM/Drupal 7 installation for a local business and have installed the latest of both. I have inserted a very small amount of data and configured the event calendar (views only)
Going through the settings for localisation etc. I encountered an error were CiviCRM warned that the attachment size could not be more than php size. I altered this to the correct value, clicked save and:

I cannot access any admin link, no CiviCRM menu and the direct links are also not doing anything.
Normally okay at debugging these things but I'm at a loss. Can anyone help?

misc?reset=1:1 Refused to execute script from 'https://###/civicrm/ajax/l10n-js/en_US?cid=2&r=Tx80w' because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.

Common.js?q73rge:1517 Error: CRM.url called before initialization
CRM.console @ Common.js?q73rge:1517
CRM.url @ crm.ajax.js?q73rge:19
initialize @ crm.menubar.js?q73rge:18
(anonymous) @ crm.menubar.js?q73rge:491
(anonymous) @ crm.menubar.js?q73rge:493

crm.ajax.js?q73rge:26 Uncaught TypeError: Cannot read property 'back' of undefined
    at Object.CRM.url (crm.ajax.js?q73rge:26)
    at Object.initialize (crm.menubar.js?q73rge:18)
    at crm.menubar.js?q73rge:491
    at crm.menubar.js?q73rge:493
CRM.url @ crm.ajax.js?q73rge:26
initialize @ crm.menubar.js?q73rge:18
(anonymous) @ crm.menubar.js?q73rge:491
(anonymous) @ crm.menubar.js?q73rge:493

misc?reset=1:1 Unchecked runtime.lastError: The message port closed before a response was received.


texts:
I have been trying to implement soft credits for memberships which are paid using a webform. I have created a webform that allows one or two parents and up to four children to create or renew a membership. Everything works just fine except that the soft credits do not contain any value.

https://drive.google.com/file/d/1bsOkwi64jNniQup12caNSxi1AWQx7gQ0/view?usp=sharing

In the webform I have selected all contacts in the soft credit drop down on the CiviCRM contribution page.

https://drive.google.com/file/d/1mnoQe5OB9vuV34Jc48AjiyvDpHUkofB-/view?usp=sharing

Is there something that I need to do to ensure that the soft credits show the relevant amount?

Results after application of the patch

After the patch was applied the image below shows the outcome of the patch. The soft credits now contain the total amount of the payment made by the person completing the webform for all contacts involved in the webform. I doubt that this is the intention.

In the example below the user has made a payment for four separate memberships. Two of them have a zero value and the other two have a value of $150. It is my expectation that only two soft credits should be generated and in this instance they would be for the two junior players and show a value of $150 against each contact. This would then obviously follow through onto their individual accounts.
This particular user has also paid in four instalments and I am not sure how that might affect the patch.

https://drive.google.com/file/d/13c8ghcsQ8BD8CPbdYVSLFUbz8EvRzusc/view?usp=sharing

Cheers
Martin Fuggle


texts:
I just installed drupal 7 and then civiCRM on Linux Mint 17.1 in a VirtualBox

Install went smoothly.

I am only using CiviCASE and CiviReports moduals. Unfortunately, there are still menu items for Mailings and Campaigns.

Mailings and Campaigns are disabled components in my setup. The picture below shows the extra menu items and my list of enabled components.

I tried enabling/save/disabling but nothing got rid of those two menu items. The other component menu items did go away.

[edit] Here's what the drop down menu looks like for the extraneous Mailing menu item, as requested.

Any ideas on how to fix this? Is it a bug, a feature or easily fixed?

Thanks in advance for any help!

John in Oregon


texts: I am working on a nightshelter signin application in CiviCRM, and the suggestion is to use a 10" tablet.  I'm not sure this would work although the menu is much simplified. (I have a 7" tablet and it would be pretty unusable on that). Has anyone used CiviCRM on a 10" tablet?  Was it usable?


texts: Change Drupal username when auto creating using tags

texts:
I'm using Pete's great way of creating Drupal users by adding a tag, but was wondering (as Michael McAndrew did in the comments on that page) how a different username could be auto-created, e.g. email address or even firstnamelastname. (Presumably the Rule would fail if a duplicate username occurred?)

And bonus question: on the same page Coleman mentioned potentially using Rules to remove the tag and clean up, but I can't work out which action this would be under. Any pointers?


texts: Add a contact to an organization through "profile" public form

texts:
For now our public subscription form is handled by a "profile" that create/modify a contact.

I want to add the organization which the contact belongs to but I don't know how to it ?
Is it possible to have a public list the subscriber can have access to ?


texts: Can I remove specific emails/contacts from Scheduled Reminders?

texts: We have scheduled reminders set to send emails to contacts whose membership is set to lapse. There are a few contacts I would prefer to not receive the reminder, however, the only way I see to do this is to stop them from receiving all communications. This would mean adding "Do No Send" to their account preferences, then creating a smart group which does not includes contacts with "Do Not Send" preferences, and sending scheduled reminders to this smart group. The problem is that the contacts in question do need to receive other communications, just not membership reminders. Any ideas?


texts:
I've a fresh install of wordpress with no other plugins activated. Hosting is https://www.blacknight.com/medius-hosting.html

I'm getting the following error when I try to run the installer.

Fatal error: Uncaught exception 'LogicException' with message 'Passed array does not specify an existing static method (class 'HTMLPurifier_Bootstrap' not found)'
in /var/www/vhosts/37/253640/webspace/httpdocs/XXXXXXXXXXXXXXX/wp-content/plugins/civicrm/civicrm/CRM/Core/ClassLoader.php:122

Stack trace: #0 /var/www/vhosts/37/253640/webspace/httpdocs/XXXXXXXXXXXXXXX/wp-content/plugins/civicrm/civicrm/CRM/Core/ClassLoader.php(122): spl_autoload_register(Array, true, false)
#1 /var/www/vhosts/37/253640/webspace/httpdocs/XXXXXXXXXXXXXXX/wp-content/plugins/civicrm/civicrm/CRM/Core/ClassLoader.php(90): CRM_Core_ClassLoader->initHtmlPurifier(false)
#2 /var/www/vhosts/37/253640/webspace/httpdocs/XXXXXXXXXXXXXXX/wp-content/plugins/civicrm/civicrm/install/index.php(76): CRM_Core_ClassLoader->register()
#3 /var/www/vhosts/37/253640/webspace/httpdocs/XXXXXXXXXXXXXXX/wp-content/plugins/civicrm/civicrm.php(777): include('/var/www/vhosts...')
#4 [internal function]: CiviCRM_For_WordPress->run_installer(' in /var/www/vhosts/37/253640/webspace/httpdocs/XXXXXXXXXXXXXXX/wp-content/plugins/civicrm/civicrm/CRM/Core/ClassLoader.php on line 122

Any idea why this error is occurring? Looked for a solution but could not find anything.

Thanks

Alan


texts: Custom Data: Multiple Contact References

texts:
What is the easiest way to add a custom field that contains multiple contact references a la Activity Target Contacts.

I.E.

Custom Data:::::Extends Organizations
Field Set Name: Investment Round

Custom Field 1 Title: Amount Raised
Custom Field 1 Type: Money

Custom Field 2 Title: Raised Date
Custom Field 2 Type: Date

Custom Field 3 Title: Investor(s)
Custom Field 3 Type: Contact References

If this doesn't exist as a quickhack I could consider working on this if there was support for the idea. It seems like it would involve creating a helper table with the following columns.

CREATE TABLE `civicrm_custom_contact`(
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Custom Field ID',
  `custom_field_id` int(10) unsigned NOT NULL COMMENT 'FK to civicrm_custom_group.',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'FK to civicrm_contact.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `field_contact_id` (`custom_field_id`,`entity_id`),
  KEY `FK_civicrm_custom_contact_custom_field_id` (`custom_field_id`),
  KEY `FK_civicrm_custom_contact_contact_id` (`entity_id`),
  CONSTRAINT `FK_civicrm_custom_contact_custom_field_id` FOREIGN KEY (`custom_field_id`) REFERENCES `civicrm_custom_field` (`id`) ON DELETE CASCADE
  CONSTRAINT `FK_civicrm_custom_contact_contact_id` FOREIGN KEY (`entity_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

making a table which looks like

    id| custom_field_id | entity_id
    1 | 12              | 123
    2 | 13              | 4232

id is the primary key,
custom_field_id is the foreign key to the civicrm_custom_field table,
entity id is the foreign key to the civircm_contact table.

In this way we could link multiple contacts to a custom field similar to the way multiple contacts are added to an activity.

So, to recap, is there an existant way to do this, and if not, would anyone be interested in working on this with me?


texts: How to set page title in an angular page?

texts:
I have created an angular page and module and it does exactly what I wanted it to do. However the page title is CiviCRM and I want to change that.
How do I do that?

I have tried to set it in the javascript:

angular.module('myemma').config(function($routeProvider) {
  $routeProvider.when('/my-emma-accounts', {
    controller: 'MyemmaMyEmmaAccounts',
    templateUrl: '~/myemma/MyEmmaAccounts.html',
    title: 'MyEmma accounts',

    // If you need to look up data when opening the page, list it out
    // under "resolve".
    resolve: {
      accounts: function(crmApi) {
        return crmApi('MyEmmaAccount', 'get', {});
      }
    }
  });
});

However the code above does not seem to work.


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


texts: What is the recommended Wordpress equivalent for drupal-views

texts:
CiviCRM manual mentions X-Data Toolkit as a potential substitution to drupal-views. However X-Data Tookit has not been updated in years and its documentation is not available anymore.

What other plugin would you recomend as a replacement? A first Google search revealed :

TablePress - does not support MySQL as data source, ev. one could write a plugin for TablePress
wpDataTables – Not free, but supports MySQL and also has Charts
Wordpress Dynamic Tables - Not free

Are there other alternatives I have not yet seen?


texts: Best practice: Multiple event types or custom data fields?

texts:
I've only been working with Civi for a couple of weeks ...

Say we want to offer three workshops or classes:

Basketweaving 101
Basketweaving 102
Basketweaving 103

And later we want to be able to produce reports to do things like: "Show me everyone who has taken 101 and 102 but not 103."

Would it be better, when creating a new event, to have an Event Type for each of these types of workshops, or alternatively to use the "Workshop" event type and have custom data fields that would allow the registrant to select 101, 102 or 103?

I'm thinking that it may be nice to produce reports that show all workshops just by selecting one workshop type, which would argue for creating custom data fields.

On the other hand, perhaps it's easier doing reporting on standard fields than custom ones, or there may be other "gotchas" with custom fields that I'm not aware of, which would argue for creating multiple Event Types.

Or perhaps it doesn't really matter?

Thanks in advance!


texts: Can distmaker be run off a specific branch

texts:
I was using distmaker.sh (https://github.com/civicrm/civicrm-core/blob/master/distmaker/distmaker.sh) to generate tarballs for testing.

I had my local branches all set to 4.6 (core, drupal, joomla and wordpress) however, distmaker switched to the master branch when building the files.  I had created a buildkit drupal install and then cloned the joomla and wordpress repos into /sites/all/modules/civicrm/

Is there a setting to build the tarballs off a specific branch?


texts: Inserting details of another contact as tokens into an email

texts: I'm trying to set up a template to be sent to one contact. It includes tokens that are specific details of a second contact. How do I specify the contact whose details I am trying to insert through these tokens?


texts: How can I install/manage CiviCRM patches on Drupal 8 (using Composer)?

texts:
I sometimes need to fix a bug in CiviCRM before that bug is fixed in the latest version of CiviCRM.  With non-composer installations, I patch my dev site, commit my changes to git, and push them to a repo, then deploy to test/live sites.

Using composer, CiviCRM isn't in my git repo.  What's a reasonable way to manage patches so they a) persist across upgrades, b) can be managed in git?

Alternately: I'd like to test a patch that someone thinks will fix a bug in my CiviCRM installation.  How can I do that?


texts: System status - disabled/deleted fields on Smart Groups (5.24)

texts: After upgrading to 5.24 I get the above message in system status.  I've disabled and re-enabled all smart groups but the message persists and I can't find any redundant custom fields.  The message shows no smart group name or custom field name so there's no clue what's wrong. There are no error messages in the log. This is a very small Drupal based system.  Here's the message:


texts: PHP is being updated from version 5.5 to 5.6

texts:
My host is upgrading php from version 5.5 to 5.6 next week.  I am running wordpress v 4.5.3 and civicrm v 4.7.10.  Should I be concerned about anything going wrong with the running of my site after the upgrade?  They offer a 'PHP CGI' installer that can be used to install an older version of PHP onto my site if needed.

I'm a bit of a newbie so sorry for my ignorance on this matter.

Pete


texts: Unable to add new payment processor civicrm settings - payment processor

texts:
I am not able to see the "new payment processor" button on CiviCRM settings - payment processor.

I am using working on the integration of CVCRM to word press.

Thanks
Umesh Kumar


texts: When enabling logging/auditing for multisite (multi-domain), does it need to be enabled for each site/domain?

texts:
When enabling "detailed logging" for a multisite (multi-domain) installation, does logging actually need to be enabled for each domain ID? Or is it sufficient to enable logging only on the "master" site (with Civi domain ID 1)?
I've noticed that in the civicrm_setting table, the logging setting is stored with the domain_id. And, in the CiviCRM admin UI, when logging is "enabled" on the site with domain ID 1, it still shows as "disabled" on other sites unless I explicitly "enable" it.
Since logging works via insert/update/delete triggers on each DB table, I cannot see how logging could be "enabled" for one domain ID but not enabled for all other domain IDs. Nonetheless, the fact that the setting appears to be independent for each site (based on both the UI and on the domain_id value in the civicrm_setting table) is confusing, and I have not seen this documented elsewhere.
I'm running WordPress multisite (v.5.4.4) and Civi 5.35.1.

Edit: Out of curiosity, I dug deeper and inspected the database triggers on the civicrm_contact table after first enabling logging on both the main (domain ID 1) site and a child site, and then again after disabling logging on only the child site.
After enabling logging, there was a TRIGGER civicrm_contact_after_insert after insert ON civicrm_contact FOR EACH ROW BEGIN  IF ( @civicrm_disable_logging IS NULL OR @civicrm_disable_logging = 0 ) THEN INSERT INTO ... defined on the civicrm_contact table. And after disabling logging on only the child site, that trigger disappeared from the civicrm_contact table. So this seems to confirm that logging is not specific to a domain ID. But, I don't know whether or how the codebase uses the @civicrm_disable_logging variable. Through that variable, it looks like it would be possible to disable/bypass logging on a per-site basis!
For the record, I enabled and disabled logging via the wp cv CLI rather than the UI using (e.g.):
wp cv api setting.create logging=1 --url=main.mydomain.org
wp cv api setting.create logging=1 --url=childsite1.mydomain.org
wp cv api setting.create logging=0 --url=childsite1.mydomain.org

I did not test to see if changing settings in the UI behaves differently.


texts: CiviRule Error on Event as Linked Trigger

texts:
I created a CiviRule with the following

"Event is Changed" as the linked trigger.
Field value comparison => Event.summary is one of [KEYWORD]
Action (tested this before with others linked trigger and it works)

When I make the change of the summary of an event. I get the following error below.

  Sorry but we are not able to provide this at the moment. One of
  parameters (value: ) is not of the type Integer


texts:
Project for swim club: offering kids' swim lessons in different pools + different time/slots. The program sells out quickly so need maximum number of spots available; recurring contribution - monthly payments.

I'm leaning towards looking at this as Membership (with one Membership Type per Pool/time/slot combination). Has anyone every had to limit the number of memberships (of a specific type) that can be sold? Trying to figure out the path of least resistance :-)


texts: Gift aid uploaded declarations are only showing the first image for each entry

texts:
I have a gift aid issue - basically when you upload scanned declarations against a contact, they don't show each scanned image but only the first one repeadly (for each gift aid declaration entry). The rest of the text data remains the same for each entry.

The uploaded image I have added should make things clear - the red circles indicate a scanned declaration. The issue is that they are all the same image even though in the database I see different images referenced.

Also, when I click on 'Edit Gift Aid Declaration', clicking on the images for each entry shows the different uploaded images properly. So that is a workaround but not good as a HMRC officer won't be happy if someone doesn't know of that workaround!

Any help or guidance would be much appreciated. I had a stab at trying to see where in the codebase this bug is happening but its still a puzzle.

Cheers.


texts: CiviCRM Scheduled Jobs Timezone Confusion

texts:
I am running a CiviCRM deployment in a GNU\Linux environment. When comparing the times reported by https://example.com/civicrm/admin/job (Settings - Scheduled Jobs) with https://example.com/civicrm/admin/joblog (Settings - Scheduled Jobs Log), the times reported are different.

In the first, the jobs overview, times seem to be reported in Drupal's timezone.  In the second, Scheduled Jobs Log, times seem to be reported in the user's timezone.  Is this intentional or a bug?

PHP version 7.3.8
Drupal version 7.67
CiviCRM version 5.18.2

The server's time zone is CEST
The Drupal time zone is Europe/London
My user's time zone is Europe/Berlin

I have tried to reproduce this in demo systems, but the ones I tried, understandably, restrict admin settings.

Any thoughts?


texts: Stripe - Billing section not displaying for events

texts:
CiviCRM: 5.6.1
Drupal: 7.59
Stripe extension: 5.2

For contributions, stripe integration is working fine but for paid events, billing section do not shows up when amount is selected.


texts: How do I allow multiple monetary display formats on the same installation?

texts:
I'm trying to duplicate a donation form in two different languages, Canadian French and English. I have the correct languages installed with i18n Internationalisation and translation is working based on the language inherited from Drupal 7. There is only one currency required, CAD.

Money and date formats differ between Canadian English and French, however. The cheat sheet here outlines the settings I want, but I only need it for a single page.

http://wiki.civicrm.org/confluence/display/CRMDOC41/French+Canadian+localization+settings

As far as I can tell, the localization settings at civicrm/admin/setting/localization?reset=1 apply to the entire site and won't switch with the language. I have made numerous jQuery functions in my Main.tpl, OnBehalfOf.tpl and BillingBlock.tpl override templates to perfect the colloquial wording in various sections, but the money format also needs to change dynamically. This is an example:

$1,000.00 === 1 000,00 $

Is there must be a better way to run a bilingual site? Can you override the localization settings for a single page?


texts: API call setvalue for is_primary does not make other values 'not primary'

texts:
When using the CiviCRM API to make a field primary, other fields in the set do not have the 'is_primary' flag removed. This results in multiple 'primary' fields.

Eg: Address A is primary. The setvalue API call is used to set is_primary on Address B. Now addresses A and B both have 'is_primary'.

Is this the desired behaviour?

I can see that setvalue is intended to be quite a low level function, so you might not expect it to unset is_primary on other fields in the set. But if this is the desired behaviour we should probably document it.


texts: is there a maximum number of memberships?

texts: Is the number of contacts or memberships we can manage for free limited ? I don't see this information on your website.


texts: Weight Threshold error when creating a Deduplication Rule

texts:
This is on CiviCRM 5.36.
I try and create a rule with, say, First Name and Last Name, both having a weight of 10.  If I set any Threshold greater than 10 so as to require both to match, I get the error:
Weight Threshold to Consider Contacts 'Matching':  11  Total weight must be greater than or equal to the Weight Threshold.
I first saw this when trying to change the usage on an existing rule which had worked previously.


texts:
Civi 4.6.4 / Drupal 7.38

Goal: Require users to input an access code in order to register for an event.

Use Case: Athletes are encouraged to sign up for events before the registration end date, however, there are often exceptions.  We currently use access codes to allow for those exceptions.  The athlete must contact the coach, who can then provide the code so the athlete can register.  Similar to the approval process within Civi, however less of a burden on the coach (he can manage simply via email) and also easier on athlete as they do not have to request, wait, then register and pay.

Our current solution (outside of civi) implements these codes at the equivalent of a civi price set.  This seems a logical place, as it can work cohesively with start/end dates (ie. The code is required and shows up only after a "standard" price set expires.

Before I build, has anybody solved (either in a price-set or in another way within Civi?)

Thanks,

--Ken


texts: Label Format does not fit in database - PHP 7.1 json_encode() and serialize_precision

texts:
I am encountering this error when attempting to define a new label format, "Sorry an error occurred", "Label Format does not fit in database.".

This is on CiviCRM 5.8.1 on Joomla 3.9.1. I can't reproduce it on dmaster.

Administer > Communications > Label Formats
Click Add Label Format
button
I used the format settings below:

But if I entered at least some of the measurements as integer numbers only, I am able to save the new label format.

Looking at the civicrm_option_value table in the database, value looks like:

{"paper-size":"a4","orientation":"portrait","font-name":"helvetica","font-size":9,"font-style":"","NX":3,"NY":11,"metric":"in","lMargin":0.25,"tMargin":0.5500000000000000444089209850062616169452667236328125,"SpaceX":0.1000000000000000055511151231257827021181583404541015625,"SpaceY":0,"width":2.520000000000000017763568394002504646778106689453125,"height":0.95999999999999996447286321199499070644378662109375,"lPadding":1,"tPadding":1}

The very long floating-point numbers look like the cause of the problem. The db column is a varchar(512).

To work around this I had to finish entering the last two values directly in the database table after editing the long numbers back to 1 or 2 decimal places.

Has anybody encountered this before?

UPDATE:
This has arisen since PHP 7.1. See this StackExchange question: "According to documentation, PHP 7.1.x started to use serialize_precision instead of precision when encoding double values."

In CRM_Core_BAO_LabelFormat::saveLabelFormat() this line uses json_encode:

$this->value = json_encode($v);

$v is OK, it will contain something like:

array(16) {
  ["paper-size"]=>
  string(2) "a4"
  ["orientation"]=>
  string(8) "portrait"
  ["font-name"]=>
  string(9) "helvetica"
  ["font-size"]=>
  int(10)
  ["font-style"]=>
  string(0) ""
  ["NX"]=>
  int(3)
  ["NY"]=>
  int(11)
  ["metric"]=>
  string(2) "in"
  ["lMargin"]=>
  float(0.25)
  ["tMargin"]=>
  float(0.55)
  ["SpaceX"]=>
  float(0.1)
  ["SpaceY"]=>
  float(0)
  ["width"]=>
  float(2.52)
  ["height"]=>
  float(0.96)
  ["lPadding"]=>
  float(0.12)
  ["tPadding"]=>
  float(0.1)
}

It is only after the json_encode() that the extra-long floats are present:

string(546) "{"paper-size":"a4","orientation":"portrait","font-name":"helvetica","font-size":10,"font-style":"","NX":3,"NY":11,"metric":"in","lMargin":0.25,"tMargin":0.5500000000000000444089209850062616169452667236328125,"SpaceX":0.1000000000000000055511151231257827021181583404541015625,"SpaceY":0,"width":2.520000000000000017763568394002504646778106689453125,"height":0.95999999999999996447286321199499070644378662109375,"lPadding":0.11999999999999999555910790149937383830547332763671875,"tPadding":0.1000000000000000055511151231257827021181583404541015625}"

Inserting ini_set('serialize_precision', -1 ); into CRM_Core_BAO_LabelFormat::saveLabelFormat() before the json_encode() makes it work for me, as does adding it to php.ini but I'm not sure what the proper solution is.

Does this affect CiviCRM elsewhere? Would this be considered a CiviCRM issue? Or something that should at least be documented (the need to set it in php.ini)?


texts: Keeping track of membership history of an organization once a member has been removed?

texts:
I know relationships can be disabled, but it does not seem to preserve the time they were part of the organization.

Has anyone else had a similar use case where historical data of members within an organization has to be preserved and the best way to go about this?


texts:
I work for a small nonprofit. Our funding body previously required reports in csv format. they now want them in xml. Of course they are not providing any funds!
Can this be done via a custom report or would it be an extension?
Would Drupal views combined with the views Data export module work?
any assistance or pointers greatly appreciated


texts: Is there a hook that will be called before each database read?

texts:
I'm trying to get a little more familiar with writing extensions. I am still struggling with finding the correct / most specific hook function for my patches regularly.
As a specific example, I am altering an SQL call in sites/all/modules/civicrm/CRM/Case/BAO/Case.php::getCaseActivity().
So if I want to create an extension for that, I would need a hook function that will be called whenever sth is read from a database table. I checked all the hooks in https://docs.civicrm.org/dev/en/latest/hooks/ but couldn't find a suitable one.
Is there a hook function like that? Is there a more specific alternative to save resources (checking the hook extension each time a database table is called would happen lots of times)?
Can I create custom hook "call points" to determine at which line of code a hook is called?


texts: Civivolunteer won't show link unless logged in as admin

texts:
We are using Civi 4.7.22 on Wordpress 4.8.22.  We recently installed the updated version of civivolunteer 4.7.21-2.2.2

After setting up civivolunteer and adding it to an event, the volunteer link does not show up for anyone who is signing up for the event unless they are logged onto Wordpress as an Administrator role.  Even being logged in as a Subscriber will not show the Volunteer opportunities link, even when I copy and paste the actual link.

Am I missing something or is this a known issue?

Thank you.


texts: How can I create a report that shows contacts with no activities within a certain date range?

texts:
I'm trying to create what my client calls a "Lag Report" that allows them to get a list of contacts with no activities related to them within a certain date range.

"Who are my contacts who we have not been in touch with in a month?"

I assume we'd want to start with a constituent detail report template, but there are no activity filters to add there.

Thanks!


texts:
When attempting to give a user administrative permission I received this message :blocked 444. I can no longer access the site. I tried re-booting my computer - that did not work. How can I fix this?

Many thanks.


texts:
I exported all the civi tables from one database and saved as a sql file, including a droptable statement. I then tried to import the data into a fresh site with brand new civi installation.  The import fails with a foreign key constraint failure.
When that failed I tried to import a sql file with data only, no structure, no drop table. Also failed with

1st SQL query (with structure & data):

-- --------------------------------------------------------
--
-- Table structure for table `civicrm_action_mapping`
--
DROP TABLE IF EXISTS `civicrm_action_mapping` ;

MySQL said: Documentation
#1217 - Cannot delete or update a parent row: a foreign key constraint fails

2nd SQL Query (data only)

-- Dumping data for table `civicrm_acl_entity_role`
--
INSERT INTO `civicrm_acl_entity_role` ( `id` , `acl_role_id` , `entity_table` , `entity_id` , `is_active` )
VALUES ( 1, 3, 'civicrm_group', 1, 1 ) , ( 2, 1, 'civicrm_group', 15, 1 ) , ( 3, 4, 'civicrm_group', 2, 1 ) , ( 4, 2, 'civicrm_group', 2, 1 ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY'

Any help is appreciated.
Kate


texts: We are on Wordpress 4.5 with CiviCRM 4.7.6 but this error also occurred on 4.4 with 4.7.2.  When clicking the CiviCRM shortcode button for a Post or Page, the user is redirected to /wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fshortcode&reset=1 rather than being presented a modal window that allows the user what type of shortcode to put into the page or post.  Has anyone else run into this?


texts: Limit price field of type Text/Numeric to only numbers and with a minimum of 4

texts:
Is it possible to enforce a numbers only input with a numerical minimum on a Text/Numeric price field? I'm guessing it could be done with jQuery, but I would rather have this set up in the Civi Admin UI, since it would be much cleaner.
More details:
I have a price field set up like this:

On the front end, it looks like this: (but I want 4 to be the lowest allowed number, with no letters input)

Basically, I want the HTML equal of <input type="number" min="4"/> in the cleanest and safest way possible. (safe as in not hacking up some jQuery and then moving an element 3 months later and breaking it)


texts: What's the best way to record payments in installments?

texts:
In the setup I currently have, parents can choose to pay tuition in one annual, two bi-annual, or 10 monthly installments. I attempted to set it up as pledges, but payments do not get counted towards the pledges, nor do I seem to be able to go in afterwards and connect the payments to the pledge. (Is there any way to do this?) So as it stands, it's all manually checking whether an individual has paid for the month, there is no easy report to call up. This works at our current scale, but won't for much longer.

How would you set this up if you were to start from scratch?


texts: Displaying Custom Contact Fields In Contact Dashboard

texts:
What would be the best way to display custom contact fields in the contact dashboard (civicrm/user).

We're using custom fields to store waiver/agreement statuses and would like users to be able to get a quick view of all waivers from the dashboard.


texts:
Hello I am trying to add captcha to both my donation page and my membership sign up page. I found the instructions to go to administer>customize data>profiles. I have added captcha to name and address, supporter profile and your resisgration info and it doesnt show up on the acutal form.

Any thoughts?


texts:
Relating to 4.7. It is possible for a contribution to be made up of multiple payments.

A contribution can have a Transaction ID, but individual payments can also have a Transaction ID.

However, individual payments can not be found by searching for 'Transaction ID' in the Contributions > Find Contributions page.

For example: a participant registers for an event, choosing a ticket for £5 and paying online. This creates a contribution with a Transaction ID. We then upgrade the ticket in the back end, to £10. They pay the difference over the phone. We 'Add payment' on the contribution, and record the transaction ID.

Is there any way to search for payments rather than just the parent contributions? If not, perhaps the Find Contributions page should also search (or have an option to search) individual payments too?

For those visually inclined people:


texts: Recent 'git' seems to be missing CRM/Event/DAO folder

texts: First noticed on a Virtual Ubuntu system, now on Windows 7 - I used the 4.6 branch (git checkout upstream/4.6) and no folder was created for CRM/Event/DAO (and no Event.php, Participant.php, ParticipantPayment.php). Other folders (BAO, Form, Page, etc.) are created. Anyone else see this?


texts: How to restrict Profile Edit/Create Visibility?

texts:
I have Profile which I need to provide access to only user who are Active Members, So I have restricted Listings to Active Members only but when I go to the

  civicrm/profile/edit?gid=20&reset=1

  civicrm/profile/create?gid=20&reset=1
  It still displays the profile page.
  How can I make sure edit and create profile is displayed only if its an active member ?

When I login with a member who is not a member and access the url of create/edit profile, it provides me the option to create or edit, how can I prevent that using civicrm settings ?


texts:
I'd like to automate couple of settings in my contact list and I was wondering can these be done without writing special extensions or Drupal modules:

Couple of people qualify to be a Head Coach of the Club, so when the time comes one of them will be selected via Relationships. Can I remove an existing relationship from other person when new person gets selected? So there's only 1 head coach in each club?
There's 2 types of players - Junior and Senior (I have this as a custom select field) - when a player turns 18 or when I create a new one via Webform, the type is automatically selected for the right age?

I tried Drupal Rules, Civirules but I didn't find an easy way to do it so no manual work is necessary...


texts:
I am new to civicrm and want to use civicrm for our NGO. Our donors would be interested in viewing the funding data in urdu. Is there urdu support available? if not please guide me as to how i can work towards changing civicrm to support our urdu data and in the end showing it on the web and/or mobile app.
Thanks


texts: How do I create a custom field that selects a CiviCRM group

texts:
I want to create a custom field that selects a CiviCRM group.

eg, the business logic is "when a person registers for an event and they select 'subscribe me to news of events like this' then add them to group X" where X is a custom field attached to the event.

I could create a custom field that is an integer, look up the Id of the group, and set the custom field to that number. It would be nicer to have a UI for that.

Any pointers? Cheers!


texts: Drupal Rules - Condition "Civicrm Contact has email" appears to not be working

texts:
The desired outcome was to create a drupal user record if and only if an email exists on the contact  - when a membership was created/updated.

To do this I wanted to add the condition "CiviCRM Contact has Email".

Testing this on multiple sites I've come to the conclusion that it doesn't appear to be working as advertised - it's not returning true when the associated contact has an email.

I've tested using these two stripped down rules - (It's not working on civicrm contact is updated either) - pasted below.

The only think I can think off that could be causing this is that the data selector is not correct? I tested this by outputting this using the debug action but perhaps it needs an ID not a "contact" or vice versa? I can't see any errors in the drupal log that would indicate this though. The rule is returning successfully - it's not generating any warnings.

Membership update

{ "rules_test_2" : {
    "LABEL" : "Test 2",
    "PLUGIN" : "reaction rule",
    "OWNER" : "rules",
    "REQUIRES" : [ "civicrm", "rules", "devel" ],
    "ON" : { "civicrm_membership_edit" : [] },
    "IF" : [
      { "civicrm_entity_contact_hasemail" : {
          "contact" : [ "civicrm-membership:contact-id-contact" ],
          "location" : "0"
        }
      }
    ],
    "DO" : [
      { "drupal_message" : { "message" : "Has email" } },
      { "devel_debug" : { "value" : [ "civicrm-membership:contact-id-contact" ] } }
    ]
  }
}

Contact update

{ "rules_test" : {
    "LABEL" : "Test",
    "PLUGIN" : "reaction rule",
    "OWNER" : "rules",
    "REQUIRES" : [ "civicrm", "rules" ],
    "ON" : { "civicrm_contact_edit" : [] },
    "IF" : [
      { "civicrm_entity_contact_hasemail" : { "contact" : [ "civicrm-contact" ], "location" : "0" } }
    ],
    "DO" : [ { "drupal_message" : { "message" : "Has emali" } } ]
  }
}


texts: Has anyone used Emojis in CiviMail subject/body?

texts: I am curious if anyone has used Emojis in CiviMail content. I just tried a test mailing with an Emoji in the subject and message body, which show up fine in the editor but do not appear in the test message in my inbox.


texts: Webform CiviCRM : Do recurring contributions now get allocated to the right event registration

texts:
I have been reading with interest about the new recurring contribution feature for event registrations via Webform CiviCRM (see here and here).  We have a large population of our users who need to do payment plans and this seems like a great option to support that.

My one concern comes from this (older) thread, where the author writes: "CiviCRM Core can't (yet) associate a Recurring series with an Event registration."

The way I interpret this is:

the user registers for an event at (e.g.) $100.
Their first payment is recorded as a contribution record against the event registration.
Their subsequent payments are not recorded as contributions against the event registration.
So their event registration will still show them owing money, even when the contribution series is fully paid.

Is that correct?  And more importantly -- is it still the case today?

Thank you


texts: Network error unable to reach the server when view contract with CiviHR

texts:
I have installed CiviHR (extension) version 1.6.11 on wordpress.
When I view the Job Contract in the Contact Information, I got the error message "Unable to reach the server. Please refresh this page in your browser and try again."
Check the console of the browser, I saw the browser received 500 Server error when request to address

  http://192.168.0.121/wordpress/wp-admin/admin.php?page=CiviCRM&q=civicrm/contact/view/hrjobcontract&cid=205&snippet=json

The detail in the image below:

Please help me to fix this problem. Thanks you very much.


texts: My Configure Your Dashboard stopped working after update

texts:
After updating civicrm from version 4.7.10 to 4.7.11, the configure fucton does not work any more.
There are no buttons any more in the configuration dahsboard:
 and drag and drop does not work anymore.
Meanwhile the Dashboard itself stays robust and in good health and keeps working okay.

I tried flushing all caches in the site, and sometimes this helps, and the dashboard then looks correct again and functions, but minutes later the image changes back to the button-less like the one in the image above.
I checked with Firebug and this reports a javascript error, with a very long text that I do not understand at all.
It is a pity because this has worked all the time in the versions before 4.7.11.

Any advice on what to do?


texts: Aggregate of activity duration in Drupal Views

texts:
I am trying to build a view that displays each CiviCRM contact and the sum of the duration of all their recorded activities.
I would also like to distinguish contacts in the view whom's duration sum is greater than x minute either with an icon or different color or font.

Any thoughts on how I can accomplish this?


texts: How to get a data for a perticular logged in user ( through API)?

texts: I gave an ACL role to users for data segregation. I want to fetch data from database but data must filter i.e. ACL. How to get data. Also I want a userkey and sitekey?


texts:
Are there any tricks to importing contact data if you include a column for 'is_deceased'?

I am asking primarily so I can answer and give others a warning!


texts: Date confusion with relationships - start date can be later than end date

texts:
When adding relationships, I have found that the start date entered can be a later date than the end date of the relationship without any error being indicated.

Is this intentional or can I "fix" it so that a user cannot enter a relationship with this error as displayed below


texts: Permission errors when embedding civi-event on home page

texts:
I've used the shortcode to embed a test event on our home page.

But when the page loads I now get:

  "Sorry but we are not able to provide this at the moment.  You do not
  have permission to access this page. Return to home page."

If I'm logged into the site I have no problem. And if I remove the event code it also works. Can you tell me how I can set permissions for guest users of the site?


texts:
CMS: Drupal 7

CiviCRM: 4.7.31

"CiviCRM: access Contact Dashboard" permission is set for authenticated user and logged in user has "CiviCRM: view my invoices" permission also.

User can access contact dashboard page with buttons to print invoice for contributions but get access denied message unless "CiviContribute: access CiviContribute" permission is also assigned to user role.