texts: Api doesn't update record vu creates new

texts:
I have a civicrm-application that gets updates trough an external rest-api call. But there's something odd happening.

Request:
```
api_key=76d9f1d3h4c87c2465a8a305b6fe&key=487e30c9219952143657f779&json={"first_name":"Sebastian","last_name":"Vyaene","birth_date":"01-01-1992","gender_id":2,"custom_5":"B380-A003-G164-W878","custom_6":null,"custom_7":null,"preferred_language":"nl_NL","phone":"0477745678","custom_8":{},"custom_18":[],"contact_type":"Individual","sequential":1,"custom_14":0,"id":420564,"custom_10":0,"api.Address.create":{"contact_id":"$value.id","street_address":" ","postal_code":"9000","city":null,"location_type_id":1,"id":396363},"api.Email.create":{"contact_id":"$value.id","email":"sebastian@marlon.be","id":426290},"api.Phone.create":{"contact_id":"$value.id","phone":"0477745678","id":101260},"api.Membership.create":{"contact_id":"$value.id","membership_type_id":1,"join_date":"2017-10-16","start_date":"2017-10-16","end_date":"2018-10-16","source":{},"custom_17":"B380-A003-G164-W878","id":362337}}&entity=Contact&action=create

```
this is an create action, but there's already an id present, so there should be an update. But as you can see in the response, the id is ignored and another contact is created, what is not the behaviour we want.

Response:

```

{"is_error":0,"version":3,"count":1,"id":481202,"values":[{"id":"481202","contact_type":"Individual","contact_sub_type":"","do_not_email":"0","do_not_phone":"0","do_not_mail":"0","do_not_sms":"0","do_not_trade":"0","is_opt_out":"0","legal_identifier":"","external_identifier":"","sort_name":"Vyaene, Sebastian","display_name":"Sebastian Vyaene","nick_name":"","legal_name":"","image_URL":"","preferred_communication_method":"","preferred_language":"nl_NL","preferred_mail_format":"Both","hash":"0326647eddd86831d8e1454926e8a2c5","api_key":"","first_name":"Sebastian","middle_name":"","last_name":"Vyaene","prefix_id":"","suffix_id":"","formal_title":"","communication_style_id":"","email_greeting_id":"1","email_greeting_custom":"","email_greeting_display":"","postal_greeting_id":"1","postal_greeting_custom":"","postal_greeting_display":"","addressee_id":"1","addressee_custom":"","addressee_display":"","job_title":"","gender_id":"2","birth_date":"1992-01-01","is_deceased":"0","deceased_date":"","household_name":"","primary_contact_id":"","organization_name":"","sic_code":"","user_unique_id":"","created_date":"2018-08-20 10:04:48","modified_date":"2018-08-20 10:04:48","api.Address.create":{"is_error":0,"version":3,"count":1,"id":396363,"values":[{"id":"396363","contact_id":"481202","location_type_id":"1","is_primary":"1","is_billing":"0","street_address":" ","postal_code":"9000","manual_geo_code":"0"}]},"api.Email.create":{"is_error":0,"version":3,"count":1,"id":426290,"values":[{"id":"426290","contact_id":"481202","location_type_id":"","email":"sebastian@marlon.be","is_primary":"","is_billing":"","on_hold":"","is_bulkmail":"","hold_date":"","reset_date":"","signature_text":"","signature_html":""}]},"api.Phone.create":{"is_error":0,"version":3,"count":1,"id":101260,"values":[{"id":"101260","contact_id":"481202","location_type_id":"","is_primary":"","is_billing":"","mobile_provider_id":"","phone":"0477745678","phone_ext":"","phone_numeric":"","phone_type_id":""}]},"api.Membership.create":{"is_error":0,"version":3,"count":1,"id":362337,"values":[{"id":"362337","contact_id":"481202","membership_type_id":"1","join_date":"2017-10-16","start_date":"2017-10-16","end_date":"2018-10-16","source":"Array","status_id":"2","is_override":"","owner_membership_id":"","max_related":"","is_test":"0","is_pay_later":"0","contribution_recur_id":"","campaign_id":""}]}}]}

```

Request Id:  420564
Response Id: 481202

I've looked at the call for hours and i can't find the problem. Anyone else who can help?

I'm currently on 4.6.36 and drupal 7.59. But as a test i upgraded to 5.2.1 and the same problem occures.


texts: Allow only 1 selection in a price set with multiple price fields

texts: We offer individual and joint membership with a couple of different rates for each type. I have created a price set that has 2 price fields and each price field has a couple of options. I want to set the price set so that only one option can be ticked across both price fields. There isn't an option for this and but I hope someone has a solution. I can put all types of membership into 1 price field but it reduces the system options and makes laying out the contribution page harder. Any help appreciated.


texts: Reasons for restricting changing contribution statusses?

texts:
When we try to handle backend contributions sometimes we need manually change contribution statuses. Unfortunately some contribution status changes are restricted. From 'pending refund' we cannot change back to 'pending' or to 'in progress'. But even a more basic change like from 'pending' to 'in progress'.

I checked the wiki at http://wiki.civicrm.org/confluence/display/CRM/CiviAccounts+Data+Flow#CiviAccountsDataFlow-Otherchangestocontributionstatus but that does not seem totally up to date (pending refund / progress status)

Is there further documentation on an underlying reasoning and workflow logic of these restrictions? What would go wrong if this wasn't restricted? Could the check be a little too harsh?

BTW. They are handled by checkStatusValidation in CRM/Contribute/BAO/contribute.php


texts: Missing indices status after upgrading to CiviCRM 4.7.21 on WordPress 4.8

texts:
I successfully upgraded to CiviCRM 4.7.21 (from 4.7.17), and everything seems to be working properly. However, I got a critical status error, "Performance warning: Missing indices". After reading How to find and/or fix missing indices? I tried bringing up the status screen to correct the error, but the status screen comes up empty. However, I continue to see "System Status Critical" highlighted in pink near the top of the screen.  (See screenshot below.)

I downloaded the latest log from /wp-content/uploads/civicrm/ConfigAndLog, but I don't see anything relating to indices in it. (Log included below.)

Any ideas where to go from here?

Jul 09 15:58:28  [info] Running task: Cleanup old files

Jul 09 15:58:29  [info] Running task: Begin Upgrade to 4.7.18

Jul 09 15:58:30  [info] Running task: Upgrade DB to 4.7.18

Jul 09 15:58:31  [info] Running task: Update Kenyan Provinces

Jul 09 15:58:31  [info] Running task: Upgrade DB to 4.7.18: SQL

Jul 09 15:58:32  [info] Running task: Finish Upgrade DB to 4.7.18

Jul 09 15:58:33  [info] Running task: Begin Upgrade to 4.7.19

Jul 09 15:58:34  [info] Running task: Upgrade DB to 4.7.19

Jul 09 15:58:34  [info] Running task: Drop Column current_period_opening_balance From civicrm_financial_account table.

Jul 09 15:58:35  [info] Running task: Drop Column opening_balance From civicrm_financial_account table.

Jul 09 15:58:36  [info] Running task: CRM-19961 - Add domain_id column to civicrm_sms_provider

Jul 09 15:58:37  [info] Running task: CRM-19961 - Populate domain id table and perhaps add foreign key

Jul 09 15:58:37  [info] Running task: Upgrade DB to 4.7.19: SQL

Jul 09 15:58:38  [info] Running task: CRM-16633 - Add "Change Case Subject" activity

Jul 09 15:58:39  [info] Running task: Add is_public column to civicrm_custom_group

Jul 09 15:58:40  [info] Running task: Finish Upgrade DB to 4.7.19

Jul 09 15:58:41  [info] Running task: Begin Upgrade to 4.7.20

Jul 09 15:58:41  [info] Running task: Upgrade DB to 4.7.20

Jul 09 15:58:42  [info] Running task: Fix Schema on civicrm_action_schedule

Jul 09 15:58:43  [info] Running task: Upgrade DB to 4.7.20: SQL

Jul 09 15:58:44  [info] Running task: Add activity_status column to civicrm_mail_settings

Jul 09 15:58:44  [info] Running task: Finish Upgrade DB to 4.7.20

Jul 09 15:58:45  [info] Running task: Begin Upgrade to 4.7.21

Jul 09 15:58:46  [info] Running task: Upgrade DB to 4.7.21

Jul 09 15:58:47  [info] Running task: Finish Upgrade DB to 4.7.21


texts: How can I set up a BCC option for automated messages?

texts:
Our administrator wants to receive a copy of the expiration email Civi sends when an event registration has automatically expires (Message templates -> System workflow messages -> Events - Pending Registration Expiration Notice).

I am trying to figure out how to do this as a Civi user - not as a developer! I came across this discussion but can't quite understand what the status of this feature is at the moment:

http://forum.civicrm.org/index.php?topic=17872.0

Could someone help? (We are running CiviCRM 4.5.3 on Joomla! 3.3.3)


texts: At what line in a file should I add a new variable

texts: I want to add a new variable to the variables.php file.  Should I add it at the bottom of the file, or where it logically sits in the order of the variables, ie  under the variable that will be above it on the form?


texts: Can "Find Activity" automatically shows result with set parameters without going into selection every time?

texts:
For my volunteers I want to create an activity search based on set parameters, i.e. Phone, email. & scheduled. So they do not need to select parameters everytime.

If I enter &force=1 in the url the search automatically executes search function. Is there any shortcut like this for above criteria?


texts: cv error: "Call to undefined function Civi\Cv\Command\posix_getuid()"

texts:
When I run cv on a server, I get the following error:

[Symfony\Component\Debug\Exception\FatalThrowableError]
Call to undefined function Civi\Cv\Command\posix_getuid()

Furthermore, I noticed that usually when I run cv --help the output is in color - on this server the output is in black and white.


texts: Mailchimp Extension and Changes Announced by Mailchimp

texts:
You can read it here: https://mailchimp.com/resources/introducing-your-new-audience-dashboard/

Reasoning for posting: we just received notice of this change and may receive a large bill unless we fix it today. So, we're manually archiving unsubscribed contacts via MailChimp in the interim - perhaps this affects others.

The largest change I see is that Mailchimp will now offer CRM like features and also bill customers based on their "Total Audience" vs the "# of people who are subscribed" - which means if the MailChimp extension unsubscribes someone they will still be billable.

A list with 15,000 subscribers is billed approx $150/m as I currently see it.

Is anyone aware of plans to update this extension with consideration of the new change (for instance, to "archive" unsubscribed contacts so they are not billed?)

Thank you.

Extension Page: https://github.com/veda-consulting/uk.co.vedaconsulting.mailchimp/
* Thanks Veda for contributing this wonderful extension to our community.

UPDATE 1: Mailchimp support says we can stay on our existing plan for the time being, and we will not be charged according to the rules of the new plans (announced tomorrow).


texts:
If someone selects the auto renew option on the members join / renew form but then they choose to pay by check, what will happen at the renewal date?

Best Wishes
PD


texts: I have a few participants registered for an event that haven't paid.  Is there a way to invoice them from the the event report?


texts:
I'm looking for advice on formatting how my profile and event registration forms are displayed. In particular the positions of labels, pre/post form help etc. Is there a general guide to changing how these are displayed?

Cheers.


texts: Python Civicrm API Keeps Giving 404 Error

texts:
I'm trying to use the Python Civicrm API located here: https://github.com/tallus/python-civicrm . I can connect to the site just fine, but anytime I try to query any of the content I get a 404 Error from the /extern/rest.php.

I am using an Admin account that has an API key.

from pythoncivicrm.pythoncivicrm import CiviCRM

url = 'http://sitename.org'  # works
site_key ='642346924242934720'  # works
api_key ='dbJKbjkse903332'  # works
civicrm = CiviCRM(url, site_key, api_key) # works

search_results = civicrm.get('Contacts') # ERROR

  pythoncivicrm.pythoncivicrm.CivicrmError: request to
  https://sitename.org/extern/rest.php failed with status code 404

If I'm already admin, what other possible reason could it be that I'm still getting blocked?

Thank you!


texts:
Is there an extension to manage Keycloak users?
https://www.keycloak.org/
We are using CiviCRM together with drupal 7.


texts: After upgrade to 4.7.13, I get 500 Internal Server Error when creating new mailing

texts:
After upgrading from 4.7.11 to 4.7.13 (with Drupal 7.51), I get à 500 error (Internal Server Error) on an ajax call when attempting to create a new mailing. The screen stucks at "Initializing..."

The message in the console is :  GET XHR
http://dev.lists.sciences-po.fr/fr/civicrm/ajax/rest    [HTTP/1.1 500
Internal Server Error 381 ms]
Parameters are : action=get&entity=MailingGroup&json={"mailing_id":"6"}
There are some similar ajax call before
and after the faulty one, without any problem.
There are no javascript error except this one.
There are no group in the civicrm_mailing_group table

Have you got an idea of debug tests I could run to understand more about this error ? I know, I definitely need to read the server logs, but I don't have access.

Thanks for your help.

Philippe


texts: Can I have a price set option add a registrant to the waitlist if the event isn't full?

texts:
I have what may be a tricky situation regarding registration and waitlists.

We have an event where we have two potential types of registrants: residents of a jurisdiction and people who live outside of the jurisdiction. People pick if there's a resident or non-resident in price options when they go through event registration.

Those who pick the Resident price option should go through registration and fee payment normally and end up with a "registered" status when they're done.

We want people who pick the Non-Resident price option to not pay anything and be set to a waitlist status once they're done with registration. We would then manually move them to "registered" if there's enough room after a certain date.

Question 1: Is this a normal part of CiviEvent functionality that I'm just not able to find?

Question 2: We had a developer set up a price set like this that does work. We copied it, changed label names, and tried to use the new price set for another event, and the non-registrants are ending up "registered" instead of "waitlist." Any advice on how to successfully replicate that original price set? I just recently got access to cPanel for our site and I'm not sure what to look for here.

I appreciate any advice you may have. Thanks in advance.


texts: 4.7 Upgrade issues: invalid value for State on import, country list reverts to US, contact reports produce warning on htmlspecialchars

texts:
Upgraded to 4.7 from 4.6.11 today.
Importing contacts containing any value for State field results in an error for that field. Tried abbreviations and full values. Entering that info on a contact manually works OK though. I have since figured out how to import States, had to constrain the localization settings to the particular country I am importing, then change it over for each country - it's pretty tedious

Perhaps this has to do with another issue for Country list in localization (Contact Address fields-Selection Values). If I clear this field it populates United States after saving. Would like to include all countries in the list but can't make it stick. For a temporary workaround I have set to a single country (Australia) but that doesn't meet the requirements.

Attempting to run a contact report delivers the following warning message:

Warning:  htmlspecialchars() expects parameter 1 to be string, array given in /wp-content/plugins/civicrm/civicrm/packages/HTML/Common.php on line 144

there are a couple more lines to the error but they all refer back to the same line in common.php


texts: ExtendedReport extension throws fatal error on WordPress Access Control save settings

texts:
With the extension enabled (nz.co.fuzion.extendedreport) the settings in WordPress Access Control cannot be saved.
Disabling this extension allows the settings to be saved.
The error displayed is "API error: is not of type String". This is displayed when enabling the extension or saving WordPress Access Control settings.
This is on Wordpress 5.5.1, with CiviCRM 5.28.1.
This is the trace:
Exception: "API error: is not of type String"

#0 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/ManagedEntities.php(287): CRM_Core_ManagedEntities->onApiError("ReportTemplate", "create", (Array:8), (Array:3))
#1 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/ManagedEntities.php(173): CRM_Core_ManagedEntities->updateExistingEntity(Object(CRM_Core_DAO_Managed), (Array:4))
#2 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/ManagedEntities.php(146): CRM_Core_ManagedEntities->reconcileEnabledModule(Object(CRM_Core_Module), (Array:34))
#3 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/ManagedEntities.php(127): CRM_Core_ManagedEntities->reconcileEnabledModules()
#4 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(398): CRM_Core_ManagedEntities->reconcile()
#5 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/ACL/Form/WordPress/Permissions.php(179): CRM_Core_Invoke::rebuildMenuAndCaches()
#6 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(504): CRM_ACL_Form_WordPress_Permissions->postProcess()
#7 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/StateMachine.php(144): CRM_Core_Form->mainProcess()
#8 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Next.php(45): CRM_Core_StateMachine->perform(Object(CRM_ACL_Form_WordPress_Permissions), "next", "Next")
#9 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_ACL_Form_WordPress_Permissions), "next")
#10 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_ACL_Form_WordPress_Permissions), "next")
#11 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Controller.php(347): HTML_QuickForm_Page->handle("next")
#12 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Utils/Wrapper.php(98): CRM_Core_Controller->run()
#13 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(285): CRM_Utils_Wrapper->run("CRM_ACL_Form_WordPress_Permissions", "WordPress Access Control", (Array:0))
#14 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:14))
#15 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:4))
#16 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-content/plugins/civicrm/civicrm.php(1601): CRM_Core_Invoke::invoke((Array:4))
#17 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-includes/class-wp-hook.php(287): CiviCRM_For_WordPress->invoke("")
#18 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters("", (Array:1))
#19 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-includes/plugin.php(478): WP_Hook->do_action((Array:1))
#20 /Users/cfrost/vhosts/mysite.dev/httpdocs/wp-admin/admin.php(259): do_action("toplevel_page_CiviCRM")
#21 {main}


texts: Why are Relative Date filters missing on install?

texts:
I did a fresh installation of Civi 4.7.14 with Drupal 7, and have realised that for some reason all the relative date filters are missing. I've been able to add the one I need manually at civicrm/admin/options which is good, but it would be very time consuming to do this for all of them. Has anyone else encountered this problem?

Edit:
Here is a screenshot when creating a custom report. In the Activity Date drop down their should be a whole load of preset relative date filters, but you will see there is only the one: 'Last 12 months including today', which is the one that I added manually at civicrm/admin/options.


texts: membership not updated with recurring contribution

texts:
When the iATS scheduler runs a recurring profile which is linked to a membership, the contribution is not being linked to the membership, and thus the membership end date does not increment. Ideas?

Drupal / CiviCRM 5.x / iATS ext 1.6.2

Update; 8/30 looking for ideas here: https://github.com/iATSPayments/com.iatspayments.civicrm/issues/217

In this issue KarinG states: " iATS extension itself just takes care of the monies; we use repeattransaction API in 4.7 -> and the fact that the recurring series is attached to a Membership - that should update it."

I think it might be due to an extension or configuration - will report back. Will check the logs.

Second update: could be that I did not select auto-renew on the webform or the field during data-import: https://github.com/colemanw/webform_civicrm/pull/181

Third Update: After marking auto_renew = TRUE for the recurring profiles, which are linked to memberships, the scheduled job still does not attach the contribution to the membership or update the end date.

Fourth Update: Updated Webform CiviCRM and created a new test webform, test membership, and set up an ongoing contribution for 1 day membership. Will see if it updates tomorrow and compare. Also, in civicrm_line_items the test submission/membership has entity_table = civicrm_membership whereas the former case which did not link to membership shows entity_table = civicrm_contribution

Fifth Update: I made a new webform, test membership, and test record - and the membership does update now! I also have noticed the newly created one creates an activity record for membership renewal whereas the former one, which is not working, does not.


texts:
I'm not sure if it just me, but I am not 100% clear on what each of the CiviMail mailer settings do when combined together?

Mailer Batch Limit: The total number of emails that will go out on each CiviMail run? If multi-threading does this number multiply by the number of threads or does this number get shared out over the number of threads?

Mailer Throttle time: The sleep time in micro seconds between each individual email? If multi-threading does this time multiply by the number of threads or does this number effectively become redundant because multiple jobs are all running at this speed meaning emails are actually sending faster than this value?

Mailer Job Size: The size of smaller lists the entire list of contacts will be split into to create threads. See point about Mailer Batch Limit, does this mean the batch amount will be processed from each job.. or will the batch amount be split over all the jobs?

Mailer CRON job limit: The number of cron jobs fired off.. how is this determined? number of jobs or number of spare processes?

In short, I think it could be clearer what is going on?


texts: Does CiviCRM work with Site Performance Engines in Wordpress such as Falcon?

texts:
I'm using CiviCRM on Wordpress, and recently installed Wordfence, an excellent security plugin to make my installation more secure. It also offers the Faclon Engine, a server-side caching system which promises to speed up the website by 30-50 times.

While my installation of CiviCRM isn't too slow, some more speed would be welcome.  However, due to the sometimes complex php searches and apis that CiviCRM runs, I was wondering if it'll lead to mistakes / crashes when running.

Does anyone have a sense if these kinds of engines are ok with CiviCRM or if they're better avoided?

Thanks.


texts:
In CiviCRM 4.7.5 and 4.7.6 (tested in both) we have a problem exporting event participants.

If you 'find participants' > search results screen > select all records, and then click 'export participants' no matter what options you select on the next screen (primary fields vs selected fields), only one record is exported.

The same behaviour happens if you use the advanced search tool to export any list of contacts - eg a list of members, so I think there may be a bug in the search results screen, as this is used by both of the above routes.

Using Event Reports > Event Participant List > Export to CSV will export a full list of participants, but doesn't have our custom fields.

Is anyone else seeing this behaviour / bug?


texts: How to supply user input to custom visualizations with Civisualize

texts: I'd like to make a custom visualization with Civisualize but the visualization requires the user to first provide some input through several form elements. None of the visualizations that I see within Civisualize allow for any user input. Is this possible with Civisualize?


texts:
I'm getting the MyISAM Database Engine error:

  Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to InnoDB. Using MyISAM tables will result in data integrity issues.

However I'm using CiviCRM Hosting so I'm sure the MySQL database is configured correctly.

When I list my database using phpMyAdmin (see image) I see three tables that are MyISAM.  These are a log and two temporary tables.  Is this a problem?  Should I try to fix this?  Should I delete these tables?


texts:
Anyone seen this particular error before when trying to sync Civi contacts to Mailchimp?

API call to lists/batch-unsubscribe failed: SSL certificate problem: unable to get local issuer certificate

Googling this didn't turn up much that was helpful; I've inquired of Mailchimp but have yet to hear back.

CiviCRM 4.4.14/Mailchimp extension v 1.7

Thanks in advance,
Lesley


texts: I love the new Civi mail enhancements in 4.6 but just wondering what happened to the "upload content" button. Is it still possible to upload mailing content from a file?


texts: Contribution Report - Grouped by Custom Field

texts:
I am looking to be able to build a report that essentially has aggregate donations grouped by a custom field.  For example - every donor is asked: How did you hear about us (Referral Source), which is answered via a contribution custom field set of options.  Essentially we want to create a report that says:

Referral Source - Number of Donations - Total Donations - Average Donations

Is there a report that can let me do that - is there an extension that provides such a capability?


texts:
I am having a "Error in call to Mailing_send_test : job_id is not valid : 14" when I send test email in Mosaico (to one email or to a group) whereas email settings are working perfectly.

My mailing id seems to be 16, 14 have been deleted weeks ago. Why the test functions are stuck with job_id 14 ? How to release it ?

Any idea ?

Civicrm : 5.5.1 - Wordpress 4.9.8
Mosaico : 2.0-beta4.1528762072
FlexMailer : 0.2-alpha5

EDIT :
If I don't use mosaico, test mails and mailing are working perfectly.

This is the log related to the error :

[info] $Fatal Error Details = Array
(
[callback] => Array
    (
        [0] => CRM_Core_Error
        [1] => exceptionHandler
    )

[code] => -3
[message] => DB Error: constraint violation
[mode] => 16
[debug_info] => INSERT INTO civicrm_mailing_event_queue (job_id , email_id , contact_id , hash ) VALUES ( 14 ,  97 ,  97 , 'beba286cbb5ec019' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`database`.`civicrm_mailing_event_queue`, CONSTRAINT `FK_civicrm_mailing_event_queue_job_id` FOREIGN KEY (`job_id`) REFERENCES `civicrm_mailing_job` (`id`) ON DELETE CASCADE)]
[type] => DB_Error
[user_info] => INSERT INTO civicrm_mailing_event_queue (job_id , email_id , contact_id , hash ) VALUES ( 14 ,  97 ,  97 , 'beba286cbb5ec019' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`database`.`civicrm_mailing_event_queue`, CONSTRAINT `FK_civicrm_mailing_event_queue_job_id` FOREIGN KEY (`job_id`) REFERENCES `civicrm_mailing_job` (`id`) ON DELETE CASCADE)]
[to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="INSERT INTO civicrm_mailing_event_queue (job_id , email_id , contact_id , hash ) VALUES ( 14 ,  97 ,  97 , 'beba286cbb5ec019' )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`database`.`civicrm_mailing_event_queue`, CONSTRAINT `FK_civicrm_mailing_event_queue_job_id` FOREIGN KEY (`job_id`) REFERENCES `civicrm_mailing_job` (`id`) ON DELETE CASCADE)]"]
)


texts: Different Membership fee for each member

texts:
Our organization have different membership fee (monthly) for each member which can be decided while signup or setup manually.
How can i achieve this ?
Is it possible to create a user dashboard item to display pending membership overdue ?

Jaisal


texts: Is there a URL that can open a contact search?

texts:
I'd like to know if it's possible to craft a URL that performs a Contacts search – Something akin to typing a name into the search box in the navigation menu.  For a non-functional example of what I mean, to search for "joe":

http://www.mysite.org/drupal/civicrm/?search=joe

The goal would be to have this URL result in the same page that results when I manually type "joe" into the search box in the navigation menu, and hit "enter".

I'm trying to develop a script in my operating system (at our organization, Mac OS and we all use apple iphones that I can use Workflow to make scripts for) that allows me to select text, like "joe", right-click it to open a menu, select the script that I've titled "CiviCRM Lookup", and then a browser window opens, and enters a url that includes "joe".  I can do all the above, except figure out what kind of URL would execute such a search in CiviCRM!

I'm using Civi 4.6.2 and Drupal 7.


texts: First CiviCRM API call is slower, are unnecessary resources loaded?

texts:
We're looking at importing a lot of data via the API call. But we've noticed that on a page load the first API call is significantly slower than following ones. Eg:

$result = civicrm_api3('Contact', 'get', array()); // Slow
$result = civicrm_api3('Contact', 'get', array()); // 10x faster
$result = civicrm_api3('Contact', 'get', array()); // 10x faster

I thought this might be because CiviCRM has to autoload a number of classes the first time it is called. However, the same classes (inspected using get_declared_classes()) seem to be called when using lower-level and faster functions, which don't have a slow first query like:

$dao = CRM_Core_DAO::executeQuery($query); // Fast
$dao = CRM_Core_DAO::executeQuery($query); // Fast

Obviously the raw SQL will always be faster, but does anyone know what could be causing this initial slowness on first API calls, or have any tips on how to debug it?

It would be great if we could optimise this since REST calls are all single page requests it can be quite slow.


texts: What is the best way to override changes to CRM_Core_Config?

texts:
What is the best way to override changes to CRM_Core_Config without modifying the original. Have tried through inheritance, but generates the following code:

  Fatal error: Cannot redeclare class CRM_Core_Config ....../code/sites/all/civiphp/CRM/Core/Config.php on line 854

It isn't possible to dynamically load and unload the class, so I was thinking of writing a module which modifies the object after it has loaded via a hook. At least this would survive upgrades.

• http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_config


texts: Activity Permission - Prevent User to View Other User Activity - CiviCRM

texts:
I'm asking about activity permission in CiviCRM. I've tried to search by default functionality to prevent user to view other user activity but i guess there is no feature to do this.

This is the case that I want. Example : There are 5 users in CiviCRM : Barnie, JohnDoe, Michelle, Danielle & Felix. User JohnDoe create new activity type "Phone Call" with contact user Danielle and assign to user Barnie.

What I want is : While user Felix login into system, while he find activities, that phone call activities above will not showed to him.

Can you show me where is the code to execute query to prevent current user to view activity(s) that's not related to him/her?


texts: How do I make one hyperlink which shows its target page as a modal dialog when clicked?

texts:
There are lots of links in CiviCRM which will: (a) open an overlaid modal dialog when clicked, and (b) open the same content in a new page when Ctrl+clicked or middle-clicked. This is cool and I want to make one link which does this.

I see here that pages can enable this behavior for all links within the page by extending CRM_Core_Page and setting public $useLivePageJS = FALSE;. Neat, but not quite what I want.

I'm building an extension where I want to achieve the same result, but for one link which would live at the top level of the CiviCRM menu. Is there a class I can add somewhere, or a javascript function I can call somehow that will enable this "modal" functionality for one link?


texts: Assign large numbers of activities at once - Wordpress

texts: Is there any way of doing this from the interface. I have lots of activities that need to be assigned to a small group of individuals. I want to assign these (currently unassigned ) activities to the corresponding contact. Can't do it through batch update or import, the assigned field isn't exposed.


texts: CiviRules: Is there a trigger that can be used if a groupcontact is deleted?

texts: The trigger "Contact is removed from Group" doesn't fire if the groupcontact is deleted (and not removed). Is there a trigger, that can be used to react on the deletion of a groupcontact?


texts: Why does the sender not receive a bulk emailing they originate?

texts:
To test out CiviMail, I sent a message to the "administrators" mailing group, which has three members, including me. Only two emails were sent out, however. Even though I'm in the group,
the mailing report only reports the two mailings to the other administrators and I did not received the message.
I do not have the "do not email" or any similar box checked in my profile.
Shouldn't bulk mailings go out to all group members, including the mailing originator?
Follow up:
This may be related: Here's an experiment.
I select my own contact and start a CiviMail mailing just to me:

(For privacy, I've omitted information here, but the email address is correct.)

I select "Email - schedule/send via CiviMail" from the pulldown.

But as you can see, CiviMail creates a "hidden smart group" that contains "No Recipients". There's nothing in my contact DB entry to prevent receipt of email.
What am I missing?


texts: Volunteer Signup - Display quantity/quantity_needed

texts:
I've been modifying the sign up page to better suit our needs. I've figured out how to add Quantity but how would I go about counting the remaining need?

In other words, I'd like to show the total needed and the remaining needed after someone signs up.


texts: set minimum or maximum number of tickets a person can buy

texts:
New to civiCRM so this might be an obvious one but I haven't found he answer as yet

I need to do 2 things with events:

cap the number of tickets one given person can buy for an event. For example, set a limit of 2 tickets per transation, even though the event can be attended by 1500 persons.
Set a minimum number of tickets to be bought. For example, you can buy group tickets if you're in a group of 10 or more. So the minimum number of tickets must be 10 but it can be 11, 12, 13, etc...

Thanks for your help!

Luke


texts: Where is the file civicrm.settings.php in WP?

texts:
Wordpress 4.9.6 and CiviCRM
Where is file civicrm.settings.php?
It is not in  /wp-content/plugins/civicrm/civicrm
It is not in  /wp-content/uploads/civicrm

thanks


texts:
Using Joomla 3.8.6, CiviCRM 4.7.31, php 7.0.28, mysql 5.6.39

What should the database collation be for the CiviCRM tables?
Mine are all utf8_general_ci. None of the tables in the database are utf8_unicode_ci, but I'm getting the illegal mix error below. Not sure when it started (may have been after upgrade to 4.7.31), but clicking on "Reports listing" or one of the report collections like "Contribution Reports" generates the following error:

"1267 ** Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='"

The error seems to come from CRM/Report/Page/InstanceList.php.
See traceback below.

Edit: I now realise that the whole Report menu is not as it should be. It looks like this:

whereas it should look more like this:

Could this be related to the upgrade issue CRM-12136?

If so, how can I correct the Report menu? Thanks.

[debug_info] =>
    SELECT inst.id, inst.title, inst.report_id, inst.description,  inst.owner_id, v.label, v.grouping, v.name as class_name,
    CASE
      WHEN comp.name IS NOT NULL THEN SUBSTRING(comp.name, 5)
      WHEN v.grouping IS NOT NULL THEN v.grouping
      ELSE 'Contact'
      END as compName
      FROM civicrm_option_group g
      LEFT JOIN civicrm_option_value v
             ON v.option_group_id = g.id AND
                g.name  = 'report_template'
      LEFT JOIN civicrm_report_instance inst
             ON v.value = inst.report_id
      LEFT JOIN civicrm_component comp
             ON v.component_id = comp.id

      WHERE v.is_active = 1  AND v.component_id = 2
            AND inst.domain_id = 1
      ORDER BY  v.weight ASC, inst.title ASC [nativecode=1267 ** Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=']
[type] => DB_Error
[user_info] =>
    SELECT inst.id, inst.title, inst.report_id, inst.description,  inst.owner_id, v.label, v.grouping, v.name as class_name,
    CASE
      WHEN comp.name IS NOT NULL THEN SUBSTRING(comp.name, 5)
      WHEN v.grouping IS NOT NULL THEN v.grouping
      ELSE 'Contact'
      END as compName
      FROM civicrm_option_group g
      LEFT JOIN civicrm_option_value v
             ON v.option_group_id = g.id AND
                g.name  = 'report_template'
      LEFT JOIN civicrm_report_instance inst
             ON v.value = inst.report_id
      LEFT JOIN civicrm_component comp
             ON v.component_id = comp.id

      WHERE v.is_active = 1  AND v.component_id = 2
            AND inst.domain_id = 1
      ORDER BY  v.weight ASC, inst.title ASC [nativecode=1267 ** Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=']
[to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="
    SELECT inst.id, inst.title, inst.report_id, inst.description,  inst.owner_id, v.label, v.grouping, v.name as class_name,
    CASE
      WHEN comp.name IS NOT NULL THEN SUBSTRING(comp.name, 5)
      WHEN v.grouping IS NOT NULL THEN v.grouping
      ELSE 'Contact'
      END as compName
      FROM civicrm_option_group g
      LEFT JOIN civicrm_option_value v
             ON v.option_group_id = g.id AND
                g.name  = 'report_template'
      LEFT JOIN civicrm_report_instance inst
             ON v.value = inst.report_id
      LEFT JOIN civicrm_component comp
             ON v.component_id = comp.id

      WHERE v.is_active = 1  AND v.component_id = 2
            AND inst.domain_id = 1
      ORDER BY  v.weight ASC, inst.title ASC [nativecode=1267 ** Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=']"]


texts: Problem with membership contribution page

texts:
In civimember, I'm setting up a contribution page. The help for the "display membership fee" field says:
"If the page 'Separate Membership Payment' is NOT enabled AND the Contribution Amount is enabled so that user's can opt to give more than the minimum membership fee - then the display looks like this:

General Membership (contribute at least $100.00 to be eligible for this membership)"

When I try this I only get the minimum membership fee with an additional form for people to list an amount. What am I missing? I'd like to have the (contribute at least... line with a form where the person can list the total they'd like to pledge rather than adding the amount to the minimum membership fee.


texts:
I need to know when the EOL of 5.33-ESR is. I'm a subscriber and I checked here and other places but couldn't find it.
Thx.


texts:
*****UPDATE ADDED 1/22/18-Additonal Settings from Civicrm.settings.php

// Additional settings generated by installer:

$civicrm_paths['wp.frontend.base']['url'] = 'https://secure.blank.org/';
$civicrm_paths['wp.backend.base']['url'] = 'https://secure.blank.org/wp-admin/';
$civicrm_setting['URL Preferences']['userFrameworkResourceURL'] = 'https://secure.blank.org/wp-content/plugins/civicrm/civicrm';

*****UPDATE ADDED 1/22/18-
Please see the screenshot below.  Could this be the problem? There is not a /secure/ subdirectory.
The paths should be:
https://secure.blank.org/wp-content/plugins/civicrm/civicrm/
not
https://secure.blank.org/secure/wp-content/plugins/civicrm/civicrm/
and
https://secure.blank.org/wp-content/uploads/civicrm/
not
https://secure.blank.org/secure/wp-content/uploads/civicrm/

I am not seeing where to change this in civicrm.settings.php. Is there another file where this is set?

****END UPDATE****

We are using Civi 4.7.29 on WordPress 4.9.1

When creating a new mailing in CiviMail, I will select the template and it will be displayed differently in the HTML editor than it should be.  The preview show it correctly. Please see the screen shots below.  I am thinking it is either a paths issue or a permissions issue.  Has this happened to anyone else?  Does anyone have any idea where I can start with resolving it?

These are the ERRORs being shown
Failed to load resource: the server responded with a status of 404 (Not Found)
/wp-content/plugins/civicrm/civicrm/extern/open.php?q=
/secure/wp-content/uploads/civicrm/persist/crm-ckeditor-default.js?t=G87D Failed to load resource: the server responded with a status of 404 (Not Found)

What should the permissions be for these two files?
My open.php is 664
My crm-ckeditor-default.js is 644.


texts: email bounce processing not working. site on AWS, using Zoho email

texts:
I have created a test user group of 10 users, with 3 users having bogus email addresses that I know will bounce. I send bulk email to this group, and the mailing report shows 10 successful deliveries and 0 bounces.

I am using civi 4.6.16. I go to Administrator/system settings/Scheduled Jobs/Execute Now, and then view the job log. It is showing "Finished execution of Fetch Bounces with result: Success (a:0:{})"

Unsubscribe requests are working fine. The site is hosted on AWS. Email is hosted on Zoho. Zoho email alias is bounce@website.com.

Any ideas?


texts: Receiving the following error on joomla install

texts: The server encountered an internal error or misconfiguration and was unable to complete your request


texts: possible to create Joomla user that is not automatically activated?

texts:
I have set up a profile that includes fields to create a Joomla user. That works -- when the profile is submitted, the user is created. However, that user is created as enabled, so they can log in to the website immediately.

Based on my testing, it seems CiviCRM does not respect the "new users must be approved by admin" setting in Joomla.  Is there a way to set up the system where the Joomla user is automatically created, but in a "disabled" state?  I need for an administrator to approve each new user before they can log in.


texts: How are spam bots making submissions to civiCRM?

texts:
I ALREADY had reCaptcha enabled in civi and on my Profile type, but it seems that spam bots were still making submissions to civiCRM and creating contacts (and got assigned to a group).

I only recently caught it because I turned on role synching between civi and drupal and saw spam accounts popping up assigned a role other than "authenticated".

After going back through the particular group in question (in civi), I noticed that there were contacts that had civi IDs but not Drupal (I'm assuming submissions before I turned on role syncing. I didn't load sample data when I installed civi)

I'm not even sure what the URL would be for the form where bots could create a contact record...


texts: How to prevent CiviCRM contact from receiving emails for Scheduled Reminders

texts:
When a contact (dashboard) is edited, I see Communication Preferences as the option where I can tick NO BULK EMAILS or under Privacy "Do not mail"
Will that stop the emails from being sent during scheduled reminders(ran through CRON)
Where is the code for the same located in the CiviCRM core? Can I add event subscriber to it ?
I am using sendgrid as Mailer


texts: How to distinguish "Contacts with the same name" when assigning an activity?

texts:
A couple of people have exactly the same name in CiviCRM: John Smith.
When assigning an activity you select a person by starting to type its name.
However in case that people have exactly the same name, Civi shows both names.
How can i distinguish between the two?
Showing an emailaddress behind the name, or showing a nickname would be very helpful but I don't see any way to configure this field.

Any ideas of tips?

We're working in CiviCRM 4.4.8


texts: Why does selecting one (or more) tag options in a form created using webform-civicrm add *all* tag options to the user record?

texts:
We are on CiviCRM 4.6.19.0 and Drupal 7.50.

I've created a webform using the excellent webform-civicrm. The form is a draft of a data entry/update form for use by staff and volunteers.

I've added tags as a field for contact 2 (the new person whose info is being added, or updated by searching for an Existing Contact) that gets added by contact 1 (the logged-in staff person or volunteer).

I have checkboxes next to each of the 27 tags options, with the multiple selection option checked in settings ("Multiple values will let users select multiple items in this list.").

However, on the webform, when I select the checkbox for any one, or more, of the tags options, and then submit the form, the contact 2 record in CiviCRM shows all 27 of the tags as having been added to the record.

I added the tag options manually using key-value pairs in the Options settings. In CiviCRM, I removed the parent ID for the issue tags at Administer -> Customize Data and Screens -> Tags (Categories) . Removing the parent ID for the tag did not make a difference.

Any thoughts appreciated. I do not want to add 27 separate Tags lines in the webform settings for each of the tags. The multiple values option for the single tags field should do the trick.

Thanks!


texts:
I have a contribution page that has stopped working for me.  Actually from the end user perspective the contribution page work perfectly.  The correct forms are displayed, and they can complete the contribution, which is one of several free memberships.

The issue is that none of the input on the contribution page are being saved in the backend.  Nothing at all is recorded in contributions or memberships.  It is like the transaction never happened.

It took us a bit to realize that there was an issue, and the extent of the issue.  The last successful use of the contribution page was April 8th.  Something obviously changed after that to cause the issue, but I can't figure out what.  There wasn't an upgrade that caused the issue, either to CiviCRM or Joomla or the hosting account (that I am aware of).

Anyone ever have issues with a contribution page doing this?  Any ideas at all what I can do to resolve this?

Thanks for any help and ideas.

CiviCRM 4.7.6
Joomla 3.5.1
PHP 5.5.31


texts: I have tagged a group of contacts and am exporting them to a CSV file. When I do this, of the 30 contacts only about 25 show the current employer in the CSV file. I checked the remaining five and they have a current employer listed in the contact record, but it does not export. How can I fix this? Thank you.


texts: Why am I getting mangled menus and why can't CiviCRM find its own /ext directory?

texts: My composer build D8/CiviCRM instance looks great on my local server where I built it - but then when I add it all to git and push it to a production server -> it looks like this: menus are messed up and CiviCRM is not able to find its own extension directory that it ships with.


texts: How can we access only one of multiple financial types in a single contribution?

texts:
For some of our contributions, we have two different financial types, and that money needs to be treated differently. For instance, donors can make a donation and choose to add 3% to cover the processing fees. The donation is a "Donation" type, and the fee is a non-deductible "Processor Fees" type. The default Financial Type of the Contribution is "Donation". See image.

So, I can see the two different financial types within the Contribution, but when we are printing donor letters or running reports or searching for Contributions, we can only treat it as a "Donation" type (the default type of the Price Set).

We want to be able to print thank you letters with only the donation portion of the contribution ("Thank you for your $10 gift" in this case, not "$10.30"). And, we want to be able to run reports showing how much people have contributed through paying their own processing fees (or whatever the secondary type is).

How is this information stored in the database?
Is there (could there be) a token available to get only the "Donation" amount?
Why doesn't the Processor Fee amount (which is configured as "Not Deductible") show up in the "non-deductible amount" field for the Contribution?
Has anyone else come up with a solution or work-around for this issue?


texts:
I've added CSS to a Summary.extra.tpl file to change reports. But the CSS does not apply.

Adding the CSS by itself crashes the report (character encoding issue) so adding the {literal} tag is what I have.

{literal}
#s2id_groups {display:none;}
{/literal}

I am trying to remove the add contacts to group dropdown.


texts: Accessing CiviCRM contact data from external page

texts:
I have a civi instance installed on WP and would like to access and display a contact's data on a different (non WP) site.

Tried to embed the whole civi page and pass the contact ID using this url format but since cross origin framing is not allowed it didn't work:

http://myserver/wordpress/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fview&cid=**XXX**

How can I fetch and display a contact's details on an external page?


texts: Intermittent instances of duplicate participant rows created - is this a MySQL issue?

texts: CiviCRM 4.4 install that has been running for ~ 2 years now, no update to code - in the past week I have seen 3 instances of duplicated participant rows (same contact_id, same event_id, fee, but register timestamp shows difference of 7 minutes to 1 hour).  The participant_id is different of course. Has anyone seen this or have suggestions how to debug this - MySQL server is hosted so I cannot get logs.


texts: Paste from Text and Paste from Word in WYSIWYG Editor Throws Error

texts:
On CiviCRM 5.5.1 and Drupal 7.

When creating a Civimail, if you click "Paste from Text" or "Paste from Word" buttons in Google Chrome 70 (64 bit) you receive an error:

"Press Ctrl+Shift+V to paste. Your browser doesn‘t support pasting with the toolbar button or context menu option."

How can we fix this or remove the buttons?


texts: CiviCRM Multi-day Events + Drupal Calendar + Views

texts:
How can I show CiviCRM Multi-day events on drupal calendar module (Not fullcalendar), civicrm Entity module and views in drupal 7 ?

I am trying to achieve something like this: https://www.drupal.org/files/images/civicrm_events_calendar.png

Thanks in advance!!


texts: Mailchimp Sync- Groups not available in Sync form

texts: I've successfully set up the Mailchimp account, but when I go to "Add new subscription sync" only one CiviCRM group is available in the dropdown, and it's not a Mailing List group. My Mailing List groups do not show.


texts: what is a "unique open" in a mailing report?

texts: Included in a mailings report is data on "unique opens" and "total opens". What is the difference between "unique opens" and "total opens"?


texts:
I want civi to send an email when our users renew their membership. I have setup the reminder as follows. but I have tested this couple of times by renewing my own membership offline but nothing gets sent.

What is it that im doing wrong

I have set the time to 0 hours after activity date assuming that it will send the email as soon as the renewal.

Any help would be highly appreciated


texts: CiviCRM on Joomla or WordPress? Any recommendations?

texts:
Does anyone have a recommendation for choosing Joomla or WordPress as the framework to run CiviCRM? Or some high-level pros and cons for a CiviCRM newbie? I'm less experienced with Drupal so I'd prefer not to go that route.

Any help would be much appreciated.

Thanks!


texts: Can I export full database and import it in a fresh newer CiviCRM version?

texts:
I am experiencing difficulties during CiviCRM upgrade from 4.7.14 to 4.7.31 or 5.1, namely, fields like contact.birth_date get broken. (More: DB Error after upgrading 4.7.x to 5.1 (Drupal))

I have noticed that during CiviCRM version update, there is a process of sequential updates that seem to also include database updates.

I wonder, if it is possible to export full database and re-import it in a newer version fresh CiviCRM installation?


texts: CiviCRM menu not displaying properly or useably in wordpress

texts:
!(https://imgur.com/a/Q1PCgMe)
This is standard install of wordpress with the default theme, I've tried changing the theme and the settings in the Civicrm Admin Utilities plugin but to no avail. The menu appaers fully displayed below the dash board but is fully obscured by the wp menu, and only visible when that is collapsed. I'm aware this is a formatting issue, but I wondered if anybody had seen it before in a fresh wordpress install


texts: CustomGroup Create API Not Passing Param extends_entity_column_id

texts:
I am using the API to create a custom group that extends "Participant". I want to set it to be based on Participant (Event Type).

I set the "extends_entity_column_value" and "extends_entity_column_id".
However, it does not seem to pass the "extends_entity_column_id" parameter on the call.

Here is the call I am making:

$result = civicrm_api3('CustomGroup', 'create', array(
  'debug' => 1,
  'sequential' => 1,
  'title' => "Membership Bible Training",
  'extends' => "Participant",
  'collapse_adv_display' => 1,
  'extends_entity_column_id' => 3,
  'extends_entity_column_value' => 19,
));

Here is the result of the call:

{

"is_error": 0,
"undefined_fields": [
    "style",
    "is_active",
    "title",
    "collapse_adv_display",
    "extends_entity_column_id",
    "extends_entity_column_value",
    "extends"
],
"version": 3,
"count": 1,
"id": 79,
"values": [
    {
        "id": "79",
        "name": "Membership_Bible_Training",
        "title": "Membership Bible Training",
        "extends": "Participant",
        "extends_entity_column_id": "",
        "extends_entity_column_value": [
            "19"
        ],
        "style": "Inline",
        "collapse_display": "",
        "help_pre": "",
        "help_post": "",
        "weight": "1",
        "is_active": "1",
        "table_name": "civicrm_value_membership_bible_training_79",
        "is_multiple": "",
        "min_multiple": "",
        "max_multiple": "",
        "collapse_adv_display": "1",
        "created_id": "",
        "created_date": "",
        "is_reserved": ""
    }
]

}

Notice how "extends_entity_column_id" is empty. Why is this?


texts: Override 'isRedirectSupported' in HttpClient.php?

texts:
I've run into the issue of not being able to download extensions because my server fails the test in isRedirectionSupported(). This appears to be a long standing issue. I followed totten's advice here and hacked CRM_Utils_HttpClient::isRedirectionSupported() to force it to always return true. The downloads then worked without issue.
My question is, is there a way to override CRM_Utils_HttpClient::isRedirectionSupported() so that I don't have to apply this hack every time I upgrade civicrm? Is there an existing extension that will do this? Is there some admin setting that will do the override so that isRedirectionSupported() always returns true?


texts: Wordpress page title only fixed in 4.6.4?

texts:
Can I assume that the fix mentioned in this post is for 4.6.4 NOT 4.6.3, the current stable version?

http://forum.civicrm.org/index.php/topic,36339.msg154556.html#msg154556

Any idea how long until 4.6.4 is the stable version or what magic happens in that version to allow Wordpress to use the title of the PCP for the page title (instead of the site title)?


texts: Is this expected that civiHR removes lots of features (eg activities and cases)?

texts:
So I'm trying to use civiHR. I understand that some features are still beta and some new custom screen don't work so well and I'm prepared to live with that

What I don't understand is that civiHR disable existing features, eg:
- list of the cases "recruitement" isn't displayed n the case tab
- activity tab removed

Is this on purpose or a bug? I don't see the point of removing features that would still have a sense because HR introduces different workflows too.

Is there a way to let the existing features of CiviCRM enabled, even when using civihr?


texts: I am having a devil of a time with CiviCRM email

texts:
I've validated that my email settings work using SMTP.

Validated using the Contact / Send Email as well as from the Joomla Global Configuration as well as the joomla K2 article print button.

Its just down to testing a sample newsletter mailing. At the bottom is a single email address to send to. I send to an email address for my site (internal to the hosting service) and it works. I try to any other external email address and it fails.

Error msg: Error in call to Mailing_send_test : mail() returned a failure. If I changed the email setting to SMTP, I get a long error, a 'failure to connect to  , Invalid SMTP response code received.

Need Help :-(


texts: Scheduled reminders triggered by new relationship

texts:
The Objective:

We'd like to set up a template email that will send (one time only) to individuals who have a specific relationship type added to their contact record.

E.g.

(Individual) A is a member of (organisation) X. Both A and X are in Civi as contacts.
A has a new relationship to X (e.g. of type 'Chairman of') added to their contact record
This triggers an automated email to be sent to A (with helpful content specific to that relationship type)

What we tried

I thought I might be able to do this through:

setting up a Smart Group (for all contacts with relationship type 'Chairman of')
setting up a scheduled reminder with recipients limited to the Smart Group so that every time a new contact is added to the Smart Group they would be sent the scheduled reminder.

However, this doesn't seem to be enough, as there's no 'entity' (of 'contact in group' or 'relationship type') or similar to trigger the scheduled reminder.

Any ideas if/how we might be able to get this going?


texts: CSV GUI Import to api -- Set 'Last update date'?

texts:
I'm importing with "CSV GUI Import to api" extension about 6500 contacts. Is it possible to set 'Last update' date during the import from an in the original database existing data field's value? I can't find the proper entity for it.

Thank You.


texts: Pay later for Membership - How does the membership get entered?

texts: Civi v4.6.2 When entering a membership via the online contribution and using the Pay Later option I notice the membership does not get created.  Does an admin type person have to manually enter the membership?


texts:
I need to develop an extension to extend the CiviCRM membership component so that when a membership is created or renewed a record for the membership “period” is recorded.
The membership period should be connected to a contribution record if a payment is taken for this membership or renewal.
i.e. If a membership commenced on 1 Jan 2014 and each term was 12 months in length, by 1 Jan 2016 the member would be renewing for their 3rd term. The terms would be:

Term/Period 1: 1 Jan 2014 - 31 Dec 2015
Term/Period 2: 1 Jan 2015 - 31 Dec 2016
Term/Period 3: 1 Jan 2016 - 31 Dec 2017

Currently, when a membership is renewed in CiviCRM the “end date” field on the membership itself is extended by the length of the membership as defined in CiviCRM membership type configuration but no record of the actual length of any one period or term is recorded. As such it is not possible to see how many “terms” or “periods” of membership a contact may have had.

Appreciate the help, please. Thank you.


texts: Volunteer Report Error: Expression #2 of SELECT list is not in GROUP BY clause

texts:
I'm trying to run a volunteer report on CiviCRM 5.5.2 on WordPress, and if I go to Reports -> Contact Reports -> Volunteer Reports, then click "Refresh Results" (no matter what criteria I seem to choose), I get the following error:

[nativecode=1055 ** Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bitnami_wordpress.civicrm_contact_assignee_civireport.sort_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]

The full log entry is pretty long but here's the group by clause (through to the end of the query, right before the error above appears in the log):

GROUP BY activity_civireport.id  ORDER BY civicrm_contact_assignee_civireport.sort_name ASC  LIMIT 0, 50

In case this sheds any light on things, I'm pretty new to CiviCRM and I set up a project, then starting logging hours, but the people for whom I'm logging hours are NOT on the volunteer roster for the project. Not sure if that matters or not but thought I'd mention it since maybe that's not how you're supposed to do things.

I can provide more details or the full error as needed. Thanks for any ideas anyone has.


texts: Emails templates in the language of the receiver

texts: I am working on a project in Belgium, where they speak French and Dutch. Now I want to send an email in the language of the receiver, using a standard template. Does CiviCRM offer options to support this (other than coding this with smarty if then else)?


texts: Is there a way to do bullet lists in Mosaico?

texts:
One of my clients pointed out that he can't see an option to do bullet lists in
Mosaico:

Only option is to go into Source and add <ul><li> etc tags

Is there any other way?


texts: How can I limit the participant role choice?

texts:
I've been using CiviCRM for a few years now, mostly for basic functions (small NPO organizing events).

I'm trying to use a function that seems common to me but I feel that I'm missing something because I can't find any information about it.

I've tried almost everything within the interface. I have no knowledge or experience in coding script or stuff like this. But I can try following instructions.

Here is my case:

Our NPO set up LARP events for everybody.
-Anyone can register and choose a participant role.
-We mostly have these possibilities: Player, NPC, Volunteers, Artist, Organizers.
-Every participant might have custom field related to his (participant) role
-We'd like to let people choose their role properly instead of batch changing it based on the selected price in the set.

BUT:
As we also organize other types of event like conferences, where participant roles are not the same.

We would to like to be able to allow registering participants to select a role within a limited list which does not include every role set in CiviEvent
(How) can we do this?

PS I can give you any details you might find useful.


texts: How do I manually update External Identifier

texts:
I want to do a contributions import using a spreadsheet exported from Go Cardless.

When matching this info to contacts in Civi, 'External Identifier' is a mandatory field. I want to override what exists there as not everyone currently has an External Identifier, using data from Go Cardless.

How do I do that?

Thanks!


texts: Edit 'Welcome Mr xyz' message on Contribution Form

texts:
My Contribution Pages have a message at the top saying, roughly, 'Welcome Mr so and so.  To complete this form on behalf of someone else Click Here.'

A few weeks ago I edited this massage, but now I want to do so again and CAN'T FIND IT ANYWHERE.

Can anyone please direct me to where I can edit this message?

Thank you.


texts: Can I mock the CiviCRM API for unit tests?

texts:
Suppose I want to mock the API in unit tests for my extension, can I do that? Or should I implement an interface myself that is just a wrapper around civicrm_api3, and create mocks of that interface?

Thank you!

johan

update: I think a part of the answer is here in the source: https://github.com/civicrm/civicrm-core/tree/master/Civi/API/Provider


texts:
When I was editing a custom field I got this pop-up:

'Obsolete widget
The old "Advance Multi-Select" widget is being phased out and will be removed in a future version of CiviCRM. "Multi-Select" is the recommended substitute.'

Our user find it quite nice to be able to move items between the two lists rather than remember to hold down the Ctrl key or else they lose all their previous selections.

Can anyone shed any light on why this field type is going obsolete and if there is any way of continuing to use something similar?

Had a search around and couldn't find any info.

Thanks,

Dave


texts: How to empty the trash? (permanently delete)

texts:
I know you can permanently delete a deleted contact from the contact's screen, but how can you en-masse delete all the deleted contacts or "Empty Trash"?

Ideally delete all things trashed over 30 days ago would be fab.

It's especially needed for my client because deleted contacts still show up in Constituent Summary and other reports


texts: CiviCRM Status/Connection Show 404 Not Found

texts:
Site running on PHP 7.2.18, FPM applicated server by nginx.

I have been having an issue with my Status & Connections page loading, i can't seem to figure it out.

My Error Logs show the following:

2019/05/21 11:11:11 [error] 16655#0: *8187 "/var/www/vhosts/test.co.uk/httpdocs/civicrm/a/index.html" is not found (2: No such file or directory), client: 69.323.48.14, server: test.co.uk, request: "GET /civicrm/a/ HTTP/2.0", host: "test.co.uk", referrer: "https://test.co.uk/civicrm/admin/extensions?reset=1"

All the other pages load correctly what i don't understand is why its looking for a index.html?

Thanks,


texts: in-house civicrm install - but remote email install?

texts:
I've got a decent sized database (170,000 contacts) and I've been thinking lately of ways I could speed it up. Right now I'm on a VPS host with 4GB of ram and it runs... pretty good actually. But there are a handful of things that do take a while. So, I'm looking at upgrading the server to 8GB, but that increases our monthly costs of course.

So, I started thinking about running civicrm locally in my office. I have a spare computer laying around the office the office that would run a LAMP stack REALLY well and would run this civicrm install really well. I could probably put 16GB of ram in it for pretty cheap. This would work really well for us as we only use it as a private constituent management. We don't use contributions or events so people from the outside world don't really need to touch it. We do import contributions and events when needed and that works really well.

The one thing people do from the outside world is click on our emails. We send out approx 250,000 emails a month from this server and that click/read/unsubscribe data is super valuable to us.

So my question is: how could I go about running my local database but still use my cloud host to track and I guess sync back to my local database for click events and email opens events? Is this even possible? Even if I switch to using a 3rd party smtp, the click events are still based on the CMS civicrm install, right?

Thanks for your help!


texts: Outgoing links in civimail getting changed to civi site address

texts:
I setup a mailing in civi and in the email there are links to web pages not on the civi site. When I send the test message the link is changed to the civi site and not the actual link.

example
good link

http://www.google.com

link that shows up

http://civi.mysite.com/


texts: How can I search for all employees of several (a limited set of) employers

texts:
Can someone tell me how I can easily search for all employees of several employers, ideally using a single search string - i.e. something like:

employee of: 'employer A' OR 'employer B'? Ideally the results are displayed as a list from which I can select some or all for action.

Thanks!


texts: Confusing CiviMail unsubscription confirmation screen

texts:
This is picking up on a topic from the old forum having to do with unsubscribe confirmation.  (This feature is present in CiviCRM 4.6.2 as well as 4.5.8.)  I agree that having to enter one's email address is an additional annoyance to someone who is probably already annoyed.

What happens next in the process is also confusing.  Once the unsubscribing user enters their email address and clicks "unsubscribe" a highlighted confirmation message appears near the top of the screen, but the original highlighted "are you sure?" message and confirmation entry form still appear just below, as if the user is being asked to confirm again.  As a workaround, I'm using only {action.unsubscribe} and avoiding {action.unsubscribeURL}.

I understand that at present there is no way to override the "enter your email address to confirm" process.  But is there any way to show the now-confirmed user a simple "you've been removed" message without repeating the original confirmation template contents?  Perhaps a second template displayed at the end of the process?

If someone could give me a hint about where to start looking in the code, I'd be willing to have a go at displaying a simple post-confirmation message and submitting a patch.


texts:
I added a multi-record field set to individual contacts:

  Field set name = Organizational Affiliations

  Field 1 = Organization Name
  Field 2 = Position or Title

...and see I can now add multiple affiliates to an individual via site/civicrm/contact/add?reset=1&ct=Individual.

How do add that field set to a profile?  It seems I can only add individual fields, not a set of fields, to a profile?

I intended to put this field set in a profile because the profile can be embedded in the contribution page for membership signup forms.  If there's another way new members can enter this data without using a profile that would be fine too.


texts:
Since upgrading to 4.6.4 I get this error whenever trying to schedule a mailing:

  A fatal error was triggered: is not of the type Int

And this error when trying to send a test mailing:

  Error in call to Mailing_send_test : Error in call to
  MailingJob_create : A fatal error was triggered: is not of the type
  Int

This is on WordPress 4.2.4


texts: Use case: management of planning / volunteers for a music festival

texts:
I'm taking care of the management of volunteers (about 800 people) for a 10-days music festival.
I've been using drupal+civicrm for this for about 5 years now. There were some complaints that the way it works is not user friendly (but had to be implemented quickly). We've been looking to replace cicicrm by a commercial product but found out this product can't beat civicrm ;-)

So now I'm looking how I can improve the civicrm setup so everybody is happy! I hope to get some tips ...

I'll try to describe the way we are organised now and how I've set this up in civicrm.

At the festival there are about 50 different workplaces: bars, stage, backstage, toilets, foodstands, ... Each workplace has one or more responsibles. Volunteers can work on multiple workplaces. The workplace responsible must be able to manage the data of people working for him / her only. (So not of the other people)
Currently this is setup using groups and giving access rights on groups. Disadvantage of this is that when a responsible adds a new volunteer but forgets to assign a group (or assigns the wrong group) he cannot acces the data anymore.

One of the most important parts is creating a planning of who will work in which place on a certain day and creating reports / lists. I've done this now using custom fields for the contacts and creating many reports using drupal views but this is a lot of manual work each year.
I was wondering if using civievents would be more appropriate?

Ideally each volunteer would also be able to manage his/her own data (such as address, indicate when he/she's able to work, ...)

Any suggestions on the optimal way to implement this?


texts:
civicrm 5.14.1

I have a large number of contacts to dedupe and would like to do it in the background. Is there any way to do this using the cv cli? I am a complete newbie to the API.

Also, what are the environment variables used with cv?


texts: Are there any extensions which allow for Prospect Management & Tracking? I came across a planned extension called "INTEGRATION WITH DONORSEARCH" but it doesn't look like it has been completed yet, though target date was February 15, 2017.


texts: Configure CiviMember / CiviContribute for livery company quarterage fees

texts:
Can anyone advise me on the best way to manage CiviCRM payments for a City of London livery company? I have tried various permutations using CiviMember and CiviContribute, but I haven't cracked it yet.

This is the basic scenario:

Livery company members are effectively members for life.
They don't renew their membership annually as such, but they pay annual 'quarterage' fees.
There are other payments, such as one-off 'fines' when they become Freemen or Liverymen.
Even if they are late to pay their quarterage, they remain fully functional members.
There are 3 or 4 quarterage price points, including gratis. The actual rate varies from year to year.
Invoices for the coming year (from July 1) need to be bulk emailed to all members in June, customised to show the correct amount owed.
Payments may be full or partial and they are recorded manually by the administrator.
There is also a rollover date in the middle of the year.
The administrator needs to get quarterage reports showing individual records with amounts paid and amounts outstanding.  Potentially a member could still owe one amount for the period just ended and another for the new period.


texts: Is there any simple way to replicate sections in CiviMail message templates?

texts:
Is there any simple way to replicate sections of email templates (for example, a section corresponding to one story) without having to copy and paste and guard to catch all the tables and other elements in the section?

MailChimp solves it with a property repeatable http://templates.mailchimp.com/getting-started/template-language/


texts: Civi Upgrade fail - "Could not delete Payment Processor Type"

texts:
I'm on Drupal 7.67 and using IATS extension 1.7.0, While attempting to upgrade Civi from 15.17.4 to 5.21.0 the upgrade script gave me "API error: Could not delete payment processor type"
My search of Stack Exchange questions found two that seemed similar to my difficulty. However, corrective actions seemed to go in a couple of different directions and involved the Civicrm tables "civicrm_payment_processor_type" and "civicrm_managed".
In the Civicrm_managed table I found three "payment processor types. I'm wondering if I deleted those three payment processor types and than ran the upgrade process again, would this result in a clean upgrade. (I exported the entire "civicrm_managed" table so I could reconstruct those deleted entities if needed.)
However, I have one other possible option. Can I disable the IATS integration module, then run upgrade and renable the module when (and if the upgrade suceeds)?


texts: Found typo causing error in CRM_Utils_System_DrupalBase->formatResourceUrl()

texts:
On CiviCRM System Status page I get a permanent error message on the top of the page.

Warning: file_exists(): open_basedir restriction in effect. File(/var/www/clients/client5/web16/websites/default/files/civicrm/persist/contribute/dyn/angular-modules.aa49fb2433945dcf4a451bb96fb1a0e9.js) is not within the allowed path(s): (/var/www/clients/client5/web16/web:/var/www/clients/client5/web16/private:/var/www/clients/client5/web16/tmp:/usr/share/php5:/usr/share/php:/tmp:/usr/share/phpmyadmin:/etc/phpmyadmin:/var/lib/phpmyadmin) in CRM_Utils_System_DrupalBase->formatResourceUrl() function (/var/www/clients/client5/web16/web/sites/all/modules/civicrm/CRM/Utils/System/DrupalBase.php line 126.).

In CRM_Utils_System_DrupalBase->formatResourceUrl() function, in line 126, I think there is a typo: if I use if (file_exists(DRUPAL_ROOT .'/'. $file)) {
the error message disappears. In the original text the '/' is missing: if (file_exists(DRUPAL_ROOT . $file)) {

Is it a bug, or I made some mistake?


texts:
I made the mistake of importing work addresses before home addresses.
How can I update home addresses to all be primary?


texts:
I'm trying to get Report data about a Sent email through the API. I can see the report at:

www.example.com/civicrm/mailing/report?mid=388&reset=1

And I can get data corresponding to the email from the API explorer as follows:

But I can't seem to access the civiMail report with the API. I have tried a few options but can't seem to find it. Any tips?


texts: Rest API for Reserve and Interview Respondents

texts: Is there a way to Reserve and Interview Respondents using the Rest API? Couldn't find a way to do it using the 'Survey' Entity.


texts:
I am a volunteer at a non-profit.  The organization does lots of stuff with Civi, but I do only one very specific thing.  Each time I log on, I spend a couple minutes setting p my screen to do that thing...Components>Advanced Search>>Search Panel>>>Search Parameters, Keywords, etc.

Is there a way to set Preferences so that each time I log in I am automatically taken to the screen I want to see to begin my search?

Much obliged!
Phil


texts: Is there an extension for adding a custom field type calculated field?

texts:
Civi 4.6.9
Drupal 7.44

On many occasions it would be very handy to calculate the values of custom field sets and store that calculated value within Civi.

I'll use a survey for example.

I'd like to create a scored survey activity type tied to a custom field set. The field set would include multiple fields, each with select options. The final field within the set would be "Score." I'd like this field to add the values of all answers. Once we calculate the survey score we can do all kinds of fancy stuff.

I've done my due diligence but didn't find anything out there.

If there isn't one, is the extension route the most efficient method?

Ideally, I'd love to have "Calculated Field" be an option for data type when creating custom fields but that may be a pipe dream.

Thanks.


texts:
We are using REST urls to pull data direct from Civi reports into Excel for analysis purposes. Within Civi the users are restricted via granular ACLs to specific groups of contacts.

WP role permission  "Edit all contacts" is off for users.

WP role permission  "CiviCRM:access AJAX API" -  is on for users and the user has their own API key generated.

However when we extract the data via the rest url, it gives the error
"API permission check failed for ReportTemplate/getrows call; insufficient permission: requires administer CiviCRM"

REST url looks as follows:

XXXXX/wp-content/plugins/civicrm/civicrm/extern/rest.php?entity=ReportTemplate&action=getrows&instance_id=94&options[limit]=500&api_key=PXXXXXXXXXXX3X&key=074cXXXXXXXXXXX259&json=1

We can get around the "requires administer CiviCRM" by adding a block to civicrm/CRM/Core/DAO/permissions.php as follows:

$permissions['report_template'] = array(
    'getrows' => array(
      'access CiviCRM',
      'access AJAX API',
    ),
  );

But that doesn’t respect the ACL group permissions – is there any way to limit it to just the data the user should normally be able to see?  We are stuck with all records or no records.


texts: How to setup CiviCRM for multiple simultaneous telefundraisers?

texts:
We are using CiviCRM for telefundraising. Basically, we have a list of contacts to call (smart group). After each call, the fundraiser registers a phone call activity in CiviCRM. When the activity is registered, the contact is temporarily removed from the group (using include/exclude search).

How can we setup the system so that different fundraisers are not messing with each other and avoid simultaneously calling the same contacts? Preferably, in long term we would like the same fundraisers to call the same contacts.


texts: why does dashboard membership number not match list of members?

texts:
my membership dashboard shows 901 current members.

when i click the clickable '901'  I get a list of 902 members!

i cannot figure out why :/

what is the difference please between the query that generates the total membership number in the dashboard and the query that runs when you click on the number?!


texts: What is the best way to change the intro on a Contribution page based on URL?

texts:
I have a contribution page that uses values passed via URL to track specific information about the source of the contribution.

www.domain.org/civicrm/contribute/transact?reset=1&id=8&campaign=sponsorship&appeal=11&fund=child&amount=35.00

The appeal variable in the URL contains the nid (node id) for Drupal content. I would like to display image, first_name, and description of the child, pulled from this node.

Would a profile be used here or use the code extension created for tracking the source?


texts: How to Mark CiviCRM checkbox field not required programmatically?

texts:
add_filter('civicrm_buildForm','contact_mark_t_fields_optional',10,2);
function contact_mark_t_fields_optional($formName, &$form){
    if($formName == 'CRM_Contact_Form_Contact'){

        $user = wp_get_current_user();
        $is_admin = FALSE;
        foreach($user->roles as $k =>$v){
            if($v == 'administrator'){
                $is_admin = TRUE;
            }
        }
        if ($is_admin){
            //Array ( [0] => custom_2_-1 [1] => custom_3_-1 [2] => custom_4_-1 [3] => custom_5_-1 [4] => custom_6_-1 [5] => custom_7_-1 [6] => custom_8_-1 [7] => custom_11_-1 [8] => custom_12_-1 [9] => custom_13_-1 [10] => custom_14_-1 [11] => custom_15_-1 )//
            $optional = array(
                'custom_2_-1','custom_3_-1','custom_4_-1','custom_5_-1','custom_6_-1','custom_7_-1',
                'custom_8_-1','custom_11_-1','custom_12_-1','custom_13_-1','custom_14_-1','custom_15_-1','custom_41_-1'
            );
            foreach($form->_required as $k => $v){
                if (in_array($v, $optional)){
                    unset($form->_required[$k]);
                }

            }
        }

    }

}

I am trying to mark a checkbox field as optional programmatically when an admin views from the admin side, but while trying to save it, it gives a "Field Required Error"


texts:
We have a few membership types that are "semi-automatic".  They are honorary memberships that we don't charge for, but we want them to renew manually because it's an opportunity for them to update their data and donate to the society.  So, officially, it's an annual membership that they have to renew themselves.

However not all of them do, and for those that don't we want to make sure they stay members.  In this sense it's a lifetime membership.

So what I need to do is find a nice way of doing a mass renewal of all those members of these types sometime after our regular renewal period is over. Which is now.

My best idea so far is to do a search for all expired members of each type, export them, and then use that exported data to import new memberships for those people.

It should work, but is there a better way?


texts: Example: Recommended way to hide entry fields in new contact view

texts:
I just got CiviCRM installed and I also did some customizing, but now I am not sure how to proceed.
AFAICS using extensions and hooks is the recommended way of customizing civicrm, but there no examples for hiding/removing fields, although many people seem to need that.
Could someone post an example of hiding unwanted fields like nickname/pseudonym or something from the new contact entry page?
Let me explain: I want to set up Civicrm for a non profit club and they are quite conservative. Nicknames and messenger entries are not wanted, so I want to hide them in a way that survives Security Updates.

Thanks


texts: script cli code for importing contacts in civicrm

texts: Can some one give a code to how to import contacts in civicrm by using script line command. I a have a 45000 contacts and importing from civicrm interface i am getting gateway timeout error. I need help in importing contacts from CLI.


texts:
I need to automatically send MT SMS message as a response to forwarded MO SMS message.
For that purpose, I created a new send_mt() function, but I cannot access Provider object to pick up parameters like provider URL for sending, username/password, etc.
When I do var_dump, it shows that _providerInfo member is an empty array.
Thank you for your help.


texts: What is the best approach for using CiviCRM as an app on mobile?

texts:
What extension is by now the most succesful in displaying CiviCRM content in a mobile app?

(If you have any personal experiences, please tell about them...)


texts: Custom fields in tabs are not editable since upgrade to 4.7.1

texts:
After upgrading to 4.7.1, when trying to edit custom fields in tabs, the edit popup opens and you can enter data (and it does client-side validation) but the data is not saved.

Moving the set of custom fields to inline rather than tab is a successful workaround.

I couldn't reproduce it on demo, but I could on my dev site which has no extensions in common so I think it is unlikely to be due to an extension. I noticed demo is running 4.7.2 ... is this issue known to be fixed in 4.7.2? If so I'll just wait for the release and work around in the meantime.


texts:
When I merge two contact together and each contact has a membership, I need to tick the 'add new' box to keep both memberships. Otherwise one of the memberships is deleted.

However one membership reads Member since 01/01/2000. Membership Ends 01/01/2016.

The other membership reads Member Since 01/01/2016. Membership Ends 01/01/2017.

Now clearly its a renewal so I want just one membership that reads Member since 01/01/2000. Membership Ends 01/01/2017.

How can I do this without manually changing one membership and manually deleting the other.

The merge membership deletes one membership but does not amend the membership to the new dates.

Many thanks,

Andy
CIVICRM 4.5.8
Drupal


texts: How can I manage the drop down field lists in Search Builder?

texts:
I upgraded a site from 4.2 to 4.4.

They use Search Builder to run specific searches against custom data, and build quarterly reports.

Previously the field list in search builder was grouped by data set so related fields were listed next to each other. There now seems to be no underlying order to the listing and site users are finding it difficult to build their searches.

Does anyone know what governs the field listing? is there somewhere I can go to re-order the list in a way that makes sense to the end user?


texts: FAIL : first and fresh install of CiviCRM 5.36.1 on BACKDROP 1.83

texts:
my first test of Backdrop 1.83 with CiviCRM 5.36.1 via MAMP 6.3 PHP 7.4.12) failed

backdrop installed correctly
civicrm installed correctly, no error
but
when i try to reach the civicrm dashboard: empty page

just the admin menu is displayed, but no link can be opened ..
tested on SAFARI and EPIC (chrome-like) on macos 10.14.6

PAGE ERROR MESSAGE (in french)
réponse du site (exemple) :
"
Page non trouvée
Ajouter une redirection d'URL de cette page vers un autre emplacement
Vous êtes ici : Accueil
La page demandée "/backdrop183/backdrop183/civicrm/a/" n'a pas pu être trouvée.
"
what's YOUR experience?


texts: Update Donation Amounts for Monthly Recurring option

texts:
We are in the process of building out a contribution form (not webform) with the One-Time and Monthly option buttons at the top of the donation form.

We are trying to figure out the best option to update the Monthly amounts when someone toggles from One-Time to Monthly.

Has anyone done this? If so, what do you recommend?


texts:
CiviCRM 5.35.1
WordPress 5.7
We noticed last week that our members who set up recurring payments via Credit Card with the iATS processor are being double charged or even triple charged in some cases. All of sudden 100s of recurring transactions are being triggered at the same time when they should not be triggered.  For instance, someone who should only be recurring once a year, was charged twice We have no idea what is going on. This just recently started happening.  Please see screenshot below for example.  As you can see, all these transactions are happening at the same time on the same day.  This is not normal and people are being double charged.

This screenshot shows contributions for an ANNUAL membership that is not due to be renewed until January 30th 2022, but it was renewed on March 30th.  This is just one example.  We have hundreds of instances of this happening over the last 5 or 6 days.


texts: Events -> Find Participants results in Warning: Cannot modify header information - headers already sent

texts:
I've running CiviCRM 4.7.31 on Wordpress 4.9.6.
When selecting Events -> Find Participants, I get the following warnings and a blank screen:

Strict Standards: Static function CRM_Core_Task::permissionedTaskTitles() should not be abstract in .../wp-content/plugins/civicrm/civicrm/CRM/Core/Task.php on line 132
Warning: Cannot modify header information - headers already sent by (output started at .../wp-content/plugins/civicrm/civicrm/CRM/Core/Task.php:132) in .../wp-content/plugins/civicrm/civicrm/CRM/Utils/System/Base.php on line 926

Furthermore, when I go into the Events Dashboard, I get the following each time:

Standards: Static function CRM_Core_Task::permissionedTaskTitles() should not be abstract in .../wp-content/plugins/civicrm/civicrm/CRM/Core/Task.php on line 132

Is this a bug or an issue with my setup possibly?


texts:
I have a French Drupal 7.67 /Civicrm 5.19.3 site with the right settings for the localization. Every strings that are translated in transifex appear translated. In the admin, the months are translated to French:

but in any email send, they still show in English:

Do I have to configure something else outside of civicrm/admin/setting/date?action=reset=1?

regards
Guillaume


texts: How to remove the link 'do this for different person?' on a contribution / membership renewal page

texts:
I'm obviously missing something...

Wordpress / civicrm 5.4

I have a contribution / membership renewal page to allow members to renew.   They need to log in before veiwing the page  It presents them with their contact info via a profile and allows them to change any incorrect info and then asks them to select their membership type and pay.  All seems to work  great!

Except for the link that says 'want to do this for someone else?'  If they click on this and happen to know the email address of another member seems they can rewrite all their contact info?!

I don't seem to be able remove this link.

The above is obviously bonkers.  But what am i doing wrong please?
Is the 'do for different person' link removable?
Is it not possible to limit the ability of members to update info to their own records? Is there a permission I need to set somewhere?  Or do I just need to separate out the processes for making contribution from the process for maintaining contact info?

thank you:)


texts: How to display Contact Summary address in an Activity Form?

texts: I would like to display the address fields found in the contact summary tab (I'm thinking this is the inline location) in the new activities screen.  Would also like for the fields to be editable as well.  The reason for wanting it to display in both locations is because users are reading off a script in the new activity.  Address is the one of the pieces of information gathered/confirmed.  Is this possible?  All help appreciated.  We prefer to have one location for the demographic information so it will be easier to use.  We are using Drupal-7.41 and CiviCRM-4.6.6  Thanks for the help.


texts:
Importing the date works correctly, but the time shown is always 12:00 am even though the import field is, for example  02/07/2018 11:31 am. I tried various formats like the previously mentioned 02/07/2018 11:31 am  or 03/04/2018 14:22.

How can I import the time and the date into a CiviCRM date field. I am importing the dates into a custom date field.


texts: Is there a way to alternate between different outbound mail servers?

texts:
I would like to be able to use different mail servers to send different emails, for instance:

all transactional emails (contribution receipt, event registration...) sent by our mail server, all mass mailing sent using mandrill
all the emails sent by media@example.org are pushed through mandrill, but those sent by member@example.org via our own mail server
do A/B testing between two different mail providers to see if mailjet or mailchimps provide better deliverability

I do think it would need some coding, either as extension or to modify civicrm core, but would love to be proven wrong.

Assuming we need to add this feature, would it be useful for you too?


texts: "Your postal code is incomplete" on Spark signup page

texts:
I'm trying to sign up for Spark, using the link found here: https://civicrm.org/spark
I've entered all my information and keep getting an error that says "Your postal code is incomplete".  There are two places to put in your zip code on this form, I have filled them both in.  I have tried the zip format and the zip+4 format.  Getting the error each time.  I get the error whether I let my browser do the autofill settings or not.  Ready and willing subscriber here, being kept from becoming your customer by this frustrating problem.  Not a great start, this does not exactly inspire confidence that I want to use this (will my subscribers have the same problem?).


texts: How can I search in CIviCRM for people who have got a "Full" membership less than 5 months after their "Student" membership expired?

texts:
We are looking at membership progression. So we want to find out who has a current "Full" membership who started their full membership less than 5 months after their "Student" membership expired.
Anyone know how I could create a search in CiviCRM that would provide this information?
Our CiviCRM is also connected to Drupal so happy to build this in Drupal views is that easier.


texts: Webform and multiple memberships with same Member Organisation

texts:
When we create several membership types, with the same "Membership Organisation", it looks as if the previous membership has been replaced by the latest one. Assume we have two, MEM1 with 1 year membership at £30 and MEM2 with 2 year membership at £70.

1)Contact signs up for MEM1 fist, membership period is 1 year (June 2015 to May 2016 ), gets charged £30
2)Then signs up for MEM2, the membership period gets extended to 2 years (June 2015 to May 2017), gets charged £70

So what actually happens is, it does not track the memberships separately, and the contact seems to have lost the MEM1 membership.

Even if we were to consider "renewal with upsell" for this scenario, the contact should be charged only the difference in price and not the full price of MEM2, since the duration only gets extended.

Previously webform handled the membership types separately, so what will happen if we were to upgrade to the new version?

Also in civicrm we are still able to add more than one membership type for the same organisation.

Thank You!


texts: How do i delete country from my mailing label format

texts:
How do i delete country (United States) from my mailing label format.
I can't seem to print mailing labels without United States on the last line and the USPS doesn't want that.


texts: How to troubleshoot the wordpress issue when the site is migrated from one host to another?

texts: My original website name was www.xxx.com. However, I am not using that anymore. I am now using raspberry pi as a web server. After migrating to new database and domain - www.xxx.blogsite.xyz, I see that my website is not getting launched. I don't even see the dashboard for myself. How can I debug or troubleshoot this. I see that my apache is running fine. Also, I have tried restarting it. I can't access myphpadmin using public address or hostname. However, I can use myphpadmin using local IP address. Is something wrong with my dynamic dns setting?


texts: Has anyone done anything integrating Facebook Donations?

texts: We have a potential customer who is interested in using the Facebook Donate API to integrate with CiviCRM. Any work been done on this already?


texts: CiviCase not strictly adhering to permissions?

texts:
I have a use case where 'volunteers' deal with casework on an area basis, with a 'supervisor' for each area.  Volunteers can add contacts, and view their own cases. Supervisors can view all cases.

Both roles' access to their area's contacts is limited by Civi's own ACL through each service user being assigned to an area group.

This works up to a point, in that neither group has permission to view cases outside their area, but supervisors' dashboards and dashlets show all cases, regardless of whether those contacts are visible.

Is this expected behaviour, or have I went wrong somewhere?

Drupal permission:

  CiviCase: access all cases and activities View and edit all cases (for visible contacts)