texts:
I'm looking to script the standup of a development environment...specifically, a dev environment that I can allow devs to work in without them seeing personal or sensitive information about our clients.

Partly this is because some of our devs are also our clients and I don't want them to see their fellow clients' information.
Partly it is because some of our devs are all over the world and I feel I owe it to our users who share their very personal details to protect that information.

My thinking on how to achieve this goes something like this:

System Stuff

Use docker with buildkit to jumpstart a Drupal / Civi environment
Pull latest code / themes / modules from our prod site and push it into docker
Dump latest prod database for Drupal and Civi and push that into docker
Make changes to configuration.  e.g. stripe keys, SMTP, etc.

Privacy Stuff - CiviCRM

Replace all first and last names with random words
Replace all street addresses with random words.  Leave postal codes and states.
Replace all phone numbers with random numbers.
Delete all sensitive activities (e.g. our custom ones where we collect personal information), or replace the activities' data with random data
Replace all email addresses with test addresses

Privacy Stuff - Drupal

Replace all webform submissions with random information, at least for those with private info

I fully expected there to be something already out there in our community that I could use for the CiviCRM privacy stuff, but it doesn't seem to be the case.

Do any of you have suggestions for existing tools or scripts?
What do you do for allowing 3rd party developers to work with your CiviCRM instance?

Thanks

PS: Why do this instead of just put in some test users?  We categorize our users in various ways so creating, say, 5 test users of each type is becoming increasingly cumbersome.  Also, it is helpful to be able to test against real data such as our set of historical events, user event registrations, and so on.  I figured writing one anonymization script would be easier than writing and maintaining a script that creates realistic test data.  But tell me if you think I'm going about this wrong!


texts: CiviBanking: Can we create a donor + donation in one step?

texts:
We receive some money from donors we simply can't find in our civicrm (their account is a different name than how their are known on civi)

We would like to offer a simple step "create the donor", almost like the existing rule manual matching rule:

Right now, the easiest workflow we found is to open a new tab, create the contact, copy the id, add contact ID to list and select that contact.

It would save time to have a modal popup to directly create the contact. Is this already possible or is this waiting for a PR?

Is there a better workflow we missed?


texts: I am having an issue with setting what theme/layout is being used on contribution pages. I assume it is using the defualt layout but that ends up allowing sidebars and a slider to display. how do i set the layout for civicrm pages and profiles?


texts: Cannot update Smart Groups after upgrade to 5.6.1

texts:
After upgrading to 5.6.1, I've discovered that the option to edit the smart group search is missing.

Steps:

Contacts->Manage Groups
Click on Settings beside a group
At bottom of screen in 5.6.0 there were the options:

Contacts in this group
Edit Smart Group Criteria

As shown below:

But in 5.6.1 the option isn't displayed:

Is this a bug introduced in 5.6.1?


texts: Membership Fixed period, wrong start date

texts:
i am doing fixed period. membership start date is May 1, 2019 membership end date is April 30, 2020.
Early bird registration starts March 1, 2019.
I have set the Fixed Period Start Day to be May 01, anticipating May 1, 2019
I have set the Fixed Period Rollover Day to be March 01, anticipating March 1, 2019.
I anticipate membership end date to be April 30, 2020, which it is.
I anticipate membership start date to be May 1, 2019 which it is not, it gives me May 1, 2018.


texts: Is it possible to use Webform CiviCRM Drupal module to create Stand Alone Forms for gifting a membership to a third party?


texts: Event Waitlists Showing Credit Card Fields and no Price Sets

texts: I am testing the events waitlist functionality for CiviEvents. I have followed the steps in the document and I can see the waitlist feature is successfully enabled on an event. However, when we go to register as a person for the waitlist it is not showing the price set of the tickets options and also showing a mandatory credit card details. Does a person have to input their card details when adding to a waitlist. Where do these card details go as they do not show in the payments and seem to simply disappear. Also is there a way to disable the requirement for a card. Thanks. Any clarifications would be great.


texts: Upgraded to 5.4, Donor Report fails with bad sql. Status_id is missing

texts:
Upgraded from 4.6.38 to 5.4.0 in a test env.  The Donor Report (Summary) and (Detail) both fail on this piece of sql

 SELECT id, title
 FROM civicrm_batch
 WHERE item_count >= 1
 AND status_id !=
 ORDER BY title

Clearly the status_id is missing.

I then upgraded to 5.5.0 hoping maybe that would fix it, nope.

civicrm_batch has no rows so I'm guessing it queries it for some batch id gets back null and sticks that into the query.

I tried to create some batches both open and closed for all the possibilities I think there are.  That didn't help.


texts: Trouble connecting to SparkPost - Joomla 2.5.28 / Civicrm 4.6.14

texts: I installed the SparkPost/CiviCRM extension and followed the README and all seems correct but I can not connect to SparkPost SMTP server.  Is anyone else seeing a problem?


texts: CiviDiscount Not working with 4.7.1 upgrade

texts:
I recently upgraded to version 4.7.1  and when I click on Admin-> CiviDiscount  and it goes directly to the CiviCRM Home page.

Any help????


texts: Drop down labels on front end CiviCRM forms not accessible (With solution!)

texts:
Front end CiviCRM (5.21 and older) forms have drop down select list labels which are not accessible. When using a screenreader such as jaws, the reader reads the selected value of the control instead of the label.

This is counter to the way that the rest of the input controls work. The value should be read when clicking the control. Tabbing to it should read the label.

WARNING: latest version of select2 (4.0.2) breaks admin toolbar. Patch the one included with CiviCRM


texts:
Using Joomla! 3.5.1/CiviCRM 4.7.7./Debug Enabled. Accessing online contribution page reports permissions error. Both Apache and Civicrm logs  reports fatal permissions error. Civicrm/Joomla ACL backend administration page will NOT update change to allow public view of contribution page. Followed various suggestions in forum and here which points to prefix_asset table with no change.

While going thru apache logs also noticed 404 error messages generated from GETs similar to /components/com_civicrm/civicrm/bower_components. Problems with these GETs: bower_components is in /administrator/component/com_civicrm/cvicrm NOT /components/com_civicrm/civicrm. Need to know where to change settings to direct calls to administrator.

Snippet from log

May 13 14:20:58  [info] $backTrace = #0 /var/www/html/hydra/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(371): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /var/www/html/hydra/administrator/components/com_civicrm/civicrm/CRM/Utils/System/Joomla.php(464): CRM_Core_Error::fatal("You do not have permission to access this page.")
#2 [internal function](): CRM_Utils_System_Joomla->permissionDenied()
#3 /var/www/html/hydra/administrator/components/com_civicrm/civicrm/CRM/Utils/System.php(74): call_user_func_array((Array:2), (Array:0))
#4 /var/www/html/hydra/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(232): CRM_Utils_System::__callStatic("permissionDenied", (Array:0))
#5 /var/www/html/hydra/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(232): CRM_Utils_System::permissionDenied()
#6 /var/www/html/hydra/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(86): CRM_Core_Invoke::runItem((Array:15))
#7 /var/www/html/hydra/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(54): CRM_Core_Invoke::_invoke((Array:3))
#8 /var/www/html/hydra/components/com_civicrm/civicrm.php(90): CRM_Core_Invoke::invoke((Array:3))
#9 /var/www/html/hydra/components/com_civicrm/civicrm.php(11): civicrm_invoke()
#10 /var/www/html/hydra/libraries/cms/component/helper.php(405): require_once("/var/www/html/hydra/components/com_civicrm/civicrm.php")
#11 /var/www/html/hydra/libraries/cms/component/helper.php(380): JComponentHelper::executeComponent("/var/www/html/hydra/components/com_civicrm/civicrm.php")
#12 /var/www/html/hydra/libraries/cms/application/site.php(191): JComponentHelper::renderComponent("com_civicrm")
#13 /var/www/html/hydra/libraries/cms/application/site.php(230): JApplicationSite->dispatch()
#14 /var/www/html/hydra/libraries/cms/application/cms.php(257): JApplicationSite->doExecute()
#15 /var/www/html/hydra/index.php(49): JApplicationCms->execute()
#16 {main}


texts: Credit Card Payment after Editing Event Registration with more Choices

texts:
Drupal 7 Civi 4.6.15

How do we manage this workflow?

Participant registers for event using discount code, pays $0.
Calls, wants to add non-free items to registration, we edit the
Registration and add them.
Registration now says $250 with status payment pending

How do we apply a new credit card charge to this changed registration? On the backend it lets us enter credit card payment details, but doesn't let us charge it, AFAIK.

We are also having similar issue seen here: Having issues with recording new payments for registrations paid with credit cards

If we mark the registration as 'Partially Paid', then try to record payment, Civi error spits out in log

Notice: Undefined variable: paymentVal in CRM_Core_BAO_FinancialTrxn::getPartialPaymentWithType()


texts: Manually adjusting a contribution in the database

texts:
I need to manually change a one-time Failed contribution in the database to a Completed contribution.  (See How do I change an incorrect contribution status to Completed? for context).  What tables and fields in the database do I need to adjust in order to make the change successfully?

Drupal 7, Civi 4.6


texts: configuring SMTP on windows 7 for Civicrm

texts:
I am running CiviCRM 4.7.20 on Windows 7, Wordpress. CiviCRM will be accessible only in our LAN network. Want to use the mail functionalities. Got stuck with the email configuration. Bit confused with the steps. I need to send emails to my contacts from 1. Gmail 2. My institute's email addresses.

Is SMTP necessary? If yes how to proceed? If no, what other options?

New to Web technology. Any help would be appreciated. Little better explanation than help docs is needed

Thanks,
Partha


texts:
When you open a Group and select Group members, you can run a "Map Contacts" Action (which, I suppose, would locate those members on a map).

But when I try, I get a message which tells me that the Contact Address does not contain Latitude/Longitude of the Contact.

I have tried to activate the "Geocode and Parse Address" CRON Job, but I get errors (last one : "A fatal error was triggered: Aborting batch geocoding. Hit the over query limit on geocoder.")

I did not find any detailed documentation about that.

Any help is welcome


texts: Data Processor Source: how to add more options to "Additional filter criteria"

texts:
I'm trying to use Dataprocessor extension. It is fantastic!
I'd like to search by total amount of contribution, but the only options allowed in additional filter are "Is empty" and "It is not empty".

Is it possible to extend adding "greater than" and "less than"? These operators are not even included in the "filter settings" of "Field filter".
You should probably add "Number filter" in addition to "Date filter" and "Field filter".
Updated on September 1
It was a bug that has been fixed since version 1.14. See this commit


texts: I'm trying to set up a system where when a member joins, they can add another member at a reduced rate.  I want the second member to log in and sign up, checking a box for a release for.  I thought the easiest way to do this would to give a discount code of 100% for the second member and the first member would pay for both.  I know I could create a new discount code for each member but I'd rather not fill up the database with one time discounts, so I would like to hook into the code  that the Apply button uses to examine the code entered and then change the amounts if it passes muster.  I thought I could just use hook_civicrm_preProcess and change the amount on the form but this doesn't work.  Is there a simple way to do this?


texts: Report with filter 'yesterday' produces no result

texts:
When I create a report of contributions I can select a filter on 'Receive Date' of yesterday and any transactions with yesterday's Receive Date will be displayed. If I select a filter on 'Transaction Date' of yesterday no transactions are displayed even though there are transactions with a Transaction Date of yesterday.

In looking at the Contribution Table the transaction date is not shown in the table.

Can someone throw some light on this apparent issue?


texts: How do I create a custom entity (component)?

texts:
I'm fairly new to working with Drupal and CiviCRM so I apologize on my lack of knowledge. I was looking into customizing CiviCRM and stripping out a lot of stuff I don't need. Stripping out and hiding things seems fairly easy according to the documentation, but how would I go about creating totally new entities that I can add my own custom fields to? There doesn't seem to be any discussion or examples on this? I'm used to working with Microsoft CRM in the past where you can create your own entities and custom fields and then relate these new entities back to existing ones. I've looked into creating a custom extension via the documentation but this doesn't seem to cover creating a totally new separate entity. Am I missing anything?

*Edit, see this example of Microsoft CRM where you can easily create custom entities to fit your needs. This is the type of functionality I'm looking for. https://www.youtube.com/watch?v=YrwBpRVeMwo. Obviously CiviCRM isn't Microsoft, but I feel that having the ability to create custom entities is highly important to tailoring a fitting solution.


texts: How do I get Retrospective feedback for an event using a Webform (participant Custom Data)?

texts:
Is there a way to get 'retrospective' feedback from participants for an event?

I'm struggling to find any way to access Custom (or any) participant fields without the form becoming one for Registration of an event - at which time they are not going to be avle to give feedback.

Does anyone have any knowledge of how to get Custom Participant fields into webforms when not registering the users?

Any light shed would be much appreciated.

Thanks!


texts:
After CiviCRM upgrading v5.29 to v5.36, when I run the database update get the following error. I googled "CiviCRM Crypto key has unrecognized type" but did not find anything. Any suggestions what to do next?

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

This is what I get with Debugging on:
Civi\Crypto\Exception\CryptoException: Crypto key has unrecognized type in /home/customer/www/%%%%%%.org/public_html/administrator/components/com_civicrm/civicrm/Civi/Crypto/CryptoRegistry.php on line 76

Exception trace
#    Function    Location
0    Civi\Crypto\CryptoRegistry->parseKey('%%%%%%%%%%%%%%%…')    /home/customer/www/%%%%%%.org/public_html/administrator/components/com_civicrm/civicrm/Civi/Crypto/CryptoRegistry.php:76
1    Civi\Crypto\CryptoRegistry::createDefaultRegistry()    /home/customer/www/%%%%%%.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/php/FiveThirtyFour.php:39
2    CRM_Upgrade_Incremental_php_FiveThirtyFour->setPreUpgradeMessage('
The defaul…', '5.34.alpha1', '5.29.0')    /home/customer/www/%%%%%%.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:823
3    CRM_Upgrade_Form->setPreUpgradeMessage('
The defaul…', '5.29.0', '5.36.0')    /home/customer/www/%%%%%%.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php:108
4    CRM_Upgrade_Page_Upgrade->runIntro()    /home/customer/www/%%%%%%.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Page/Upgrade.php:57
5    CRM_Upgrade_Page_Upgrade->run(Array, null)    /home/customer/www/%%%%%%.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:313
6    CRM_Core_Invoke::runItem(Array)    /home/customer/www/%%%%%%.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:69
7    CRM_Core_Invoke::_invoke(Array)    /home/customer/www/%%%%%%.org/public_html/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:36
8    CRM_Core_Invoke::invoke(Array)    /home/customer/www/%%%%%%.org/public_html/administrator/components/com_civicrm/civicrm.php:121
9    civicrm_invoke()    /home/customer/www/%%%%%%.org/public_html/administrator/components/com_civicrm/civicrm.php:40
10    require_once('/home/customer/w…')    /home/customer/www/%%%%%%.org/public_html/libraries/src/Component/ComponentHelper.php:402
11    Joomla\CMS\Component\ComponentHelper::executeComponent('/home/customer/w…')    /home/customer/www/%%%%%%.org/public_html/libraries/src/Component/ComponentHelper.php:377
12    Joomla\CMS\Component\ComponentHelper::renderComponent('com_civicrm')    /home/customer/www/%%%%%%.org/public_html/libraries/src/Application/AdministratorApplication.php:101
13    Joomla\CMS\Application\AdministratorApplication->dispatch()    /home/customer/www/%%%%%%.org/public_html/libraries/src/Application/AdministratorApplication.php:159
14    Joomla\CMS\Application\AdministratorApplication->doExecute()    /home/customer/www/%%%%%%.org/public_html/libraries/src/Application/CMSApplication.php:203
15    Joomla\CMS\Application\CMSApplication->execute()    /home/customer/www/%%%%%%.org/public_html/administrator/index.php:51
16    {main}


texts: CiviMail will not add groups to recipients

texts:
Drupal 6.7
Civicrm 4.7.2
php 5.5.13
mysql 5.6.(sumpin')

I have looked at so many other threads that had this problem.  I checked to make  sure all the contacts in the group are not listed as deceased (we are not) and I've made sure that all the groups are mailing lists.

If I go to "manage groups" and choose the small test group I made, I can select all members of that group and "E-mail - schedule/send via Civimail"  THEN, and only then can I get the recipients to fill in.  BUT if I click on the little wrench to edit options, the dialogue window opens, but the whole screen gets greyed out.  At that point, I have to F5, or reload, or choose another menu option ... something to take me away from that screen.

So, I made a larger group, one that I would normally send our newsletter to.  About 3500.  I selected the members of that group and chose "E-mail - schedule/send via Civimail".  They were all added to the recipient box.  But no matter what I do, after I type in the newsletter contents, it will NOT SAVE.  It also will not preview.  Therefore, it won't go to the next screen.

It does show up in Unscheduled mailings, but without any content in the body.  I still can't add it.

Can anyone help me troublshoot?  I really need to be sending out mailings for our organization, but I can't.


texts: How can you set up CiviCRM multisite with Wordpress multisite?

texts: This question arose from this discussion.


texts: Remove link(s) from an Activity View screen via crmReplace

texts: How should  {$form.source_contact_id.html} from \civicrm\templates\CRM\Activity\Form\Activity.tpl be altered so only text remains/ without an URL? smarty escape doesn't seems to be a good idea, neither crmReplace (which can replace link attributes like class or href, but doesn't seems to be able to remove link entirely). Any advice, please!


texts: CiviCRM Extension: SMS Inbox Requirements

texts:
Does anyone have any prototype/working SMS inbox functionality?

What would you ideally like to see in an SMS inbox?

So far I've:

Mark message as read.
Attach SMS to contact.

Other suggestions welcome!


texts:
I've noticed that all of our mailings seem to have a 100% delivery rate. This seems incredibly unlikely, so I set up some test contacts with non-existent addresses at a domain I control. I tested e-mailing those addresses from a Hotmail account, and they all responded with bounce messages as expected. But when I sent a mailing to those contacts through CiviCRM it still reports 100% delivery.

I'm using G Suite, so our bounces should be coming to a G Suite address bounces@example.net, but when I log into that mailbox, no bounce messages seem to have been received.

I'm sending with mail(). My SPF config looks correct, including the IP of the CiviCRM server, and mailings do successfully get delivered to valid addresses. I've set up a filter as suggested in the CiviMail documentation. All I can think is that perhaps Google disregard without warning bounce messages that appear to be in response to messages they know their mail system didn't send? Does anyone use this configuration, and know whether that's correct? Or know what else might be going on?


texts:
I am new in CiviCRM. I am learning extension development and want to know documents/resources about how to create a contact tab showing certain information via API like Campaign Pages.

I am on Drupal 7 along with CiviCRM 4.7

Thanks


texts: Setting primary email and phone upon contact update

texts:
We want to update a bunch of contacts with e-mail adresses and phone numbers, for which previously these did not exist. The import works fine, as a result the contacts now have a Home (for example) e-mail and phone, but these are not set as the Primary ones. Because of this, the new e-mails and phone numbers do not show up in reports, and cannot be used in contact search. Only when I view one of the updated contacts, click into the Email field and then, without changing anything, press Save, the email is set to Primary.

It appears that when the contact is first created, in case there is no e-mail or phone, the Primary flag is not set. During contact update, the address/phone is updated, but the Primary flag is left missing. Is it possible to set the e-mail and phone to Primary during import if these did not exist previously?

We're currently using CiviCRM 4.7.14.


texts:
iATs in ESR version 5.21.3 for Joomla
Does the latest ESR CiviCRM 5.21.3 for Joomla support the latest iATs 1.7.2 for Joomla?
Thank you!
Jamie


texts: Birthday block in Drupal without deceased and deleted contacts

texts:
I found a piece of code to show a birthday block in Drupal.
Had to modify it a little bit to get it to work with the current versions.
But I noticed that deleted or deceased persons were still showing up in this list.
I don't know the correct code for this. Could someone please fix this code for me and others that are wanting to use this code?
My php / mysql skills are not enough but I think it must be something like:      $sql = "SELECT * FROM civicrm_contact \n"
        . "where is_deceased = false";

    <?php
// Check if CiviCRM is installed here.
if (!module_exists('civicrm')) return false;

// Initialization call is required to use CiviCRM APIs.
civicrm_initialize(true);
require_once('CRM/Core/DAO.php');

$query = "SELECT id, display_name, birth_date, CONCAT(((RIGHT(birth_date,5)
< RIGHT(CURRENT_DATE,5)) + YEAR(CURRENT_DATE)), RIGHT(birth_date,6)) AS bday,
concat(concat(month(birth_date), '/'), day(birth_date)) as displaydate,
(TO_DAYS(CONCAT(((RIGHT(birth_date,5) < RIGHT(CURRENT_DATE,5)) + YEAR(CURRENT_DATE)),
RIGHT(birth_date,6))) - TO_DAYS(CURRENT_DATE)) AS toBday FROM civicrm_contact WHERE
(TO_DAYS(CONCAT(((RIGHT(birth_date,5) < RIGHT(CURRENT_DATE,5)) + YEAR(CURRENT_DATE)),
RIGHT(birth_date,6))) - TO_DAYS(CURRENT_DATE) < 7) ORDER BY bday, RIGHT(birth_date,5);";

$params = array( );

$dao =& CRM_Core_DAO::executeQuery( $query, $params );

echo "

\n";
while ( $dao->fetch( ) ) {

echo "
id . "\">" . $dao->display_name .
", " . $dao->displaydate;

echo "
\n";

}
echo "

\n";

?>


texts: Including Member Login to a CiviCRM Site

texts:
I am just starting to configure a CiviCRM/Wordpress implementation for my organization. As well as a tool for the club's administrators to keep track of membership, I also want the members themselves to be able to keep track of their own membership.

CiviCRM seems incredibly powerful for administrators, board members, and other roles within the club to manage members, payments, events, etc. However, I would like members to be able to login and maintain their contact information, pay their dues, be able to make donations, sign up for events, etc. I'm having a hard time finding anything built into CiviCRM to allow this functionality. A nice login widget/plugin/feature with the option to sign up would be ideal. From there the user could manage their account.

As a stretch objective CiviCRM would know if a user has donated or participated before creating their account, and recall all that information for the member.

I see this question how the members can login to civicrm alludes to a plugin. A single plugin doesn't seem too hard to manage, but I don't want to have to install 20 different tools just to facilitate this functionality. Is that the only way?

Finally, could CiviCRM keep all user interaction on the front-end site? Or because I'm using Wordpress, would all member interaction happen in the Wordpress back-end? If that is the case, I'd hope some functionality would be hidden to members without sufficient permission. A confusing interface for the club members would render CiviCRM ineffective for my organization.


texts:
I'm customising the CSS on my profile page - I've learned a lot doing this! I've got it almost how I want it. The last thing I'd like to change is the position of the pre-form help text on some custom fields - they currently float above the text box and label, and I would like them to appear immediately below the field label, to the left of the text box. I've googled and searched StackExchange and not found an answer - any ideas?

Thanks,
Andrew


texts: Custom field set - how to move Delete button (or prevent deletes)?

texts: Users are 'accidentally' deleting custom field sets because (so they claim) the 'Edit' button and the 'Delete' button are too close together after clicking the custom field set tab.  So is it possible to move the delete button to the right?  One solution is to disable the ability to delete custom field sets but that doesn't see possible - we are using ACLs that only allow 'Edit'.  Any other ideas?


texts: Should civicrm_post hook receive populated Relationship object following relationship enable/disable in UI?

texts:
I'm porting some code using Civi hooks from Civi 4.4 to 4.6 . The code needs to know when a relationship becomes active or inactive, regardless of how that happens, including via the enable/disable links on the Relationships tab.

My implementation for 4.4 used both hook_civicrm_post and hook_civicrm_enableDisable. In Civi 4.6, hook_civicrm_enableDisable has been removed. I've found that hook_civicrm_post gets called when the enable/disable links are used but the CRM_Contact_DAO_Relationship object passed in only has the id field populated, all the other fields are blank.

Is this a bug and so should be addressed in core, or intended behaviour and so something I have to work around in my hook implementation?

I'm using CiviCRM 4.6.4 with Drupal 7.


texts:
I have spent the last two weeks trying to get Cron Jobs with cPanel run Scheduled Jobs in CiviCRM. Literally everything I have tried does not work as a command in Cron Jobs but when using SSH I have been able to get this to trigger the job to run:

wget -q -O - "http://website.com/wp-content/plugins/civicrm/civicrm/bin/cron.php?name=websiteAdmin&pass=websiteAdminPassword&key=1234567912345678912345678912345"

But when I take this exact command that works via SSH and put it into Cron Jobs I get an email stating:

/bin/sh: -c: line 0: unexpected EOF while looking for matching `"'
/bin/sh: -c: line 1: syntax error: unexpected end of file

My next idea was to remove the quotation marks before and after the link, which then failed due to invalid token, the password has symbols in it, so I escaped them using \ before each special character. Then I get:

ERROR: You need to send a valid key to execute this file. More info at:http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs

At this point, I know for a fact the key is correct since this command runs via SSH and the key never changed every time so far. The escaped characters are only within the password.

I have tried many other things but I figured a log file explanation might be overkill, anyone have any ideas?

Using:
cPanel version 11.52.3 (build 1)
CiviCRM version 4.6
WordPress 4.4.2


texts: building an extension: how can I create a multiple-step form?

texts:
If I just had .php files I would do the following:
step1.php's submit button goes to step2.php. step2.php's submit button goes to step3.php, etc.

The problem is that I need data that the user entered in step1 in order to display step2. For step3 I need data from step2, etc.

I tried creating multiple forms with civix generate:form, but how can I get data entered in previous steps?


texts:
I have events that often include downloadable materials. Whether or not there are downloads, what exactly they are, and the number of downloads related to a particular event is variable and unique to each event. Right now I have to add download links to the body of the event description.

This is a situation that would be perfectly handled by a multi-value custom dataset attached to the event, but alas, as far as I can tell you can't yet add multi-value datasets to events. Anyone know of a plugin, work-around, patch, or even a plan to change the functionality in the near future?


texts:
I recently upgraded from 4.4 to 4.6 using Drupal 7 and since then I have had some major performance problems (Search Builder responds to everything with a Timeout now.) Even simple queries for users in a group will often timeout.  Before the upgrade I had no problems. Has anyone else run into performance problems with 4.6.10? Any suggestions?

Updates

Searches were fine before the update
I am using smart groups


texts: Contribution form issue: cannot submit donation

texts:
It's Giving Tuesday and this donation form on my client's website won't allow credit card donors to submit their donations :o

https://apprenticelearning.org/civicrm/?page=CiviCRM&q=civicrm%2Fcontribute%2Ftransact&reset=1&id=3

When I've filled out all the information and try to submit a donation, this shows up (once Inspected):

VM625:1 Uncaught TypeError: Cannot read property 'id' of undefined
    at v (eval at  (jquery.min.js?r=Z0KlZ:2), :1:694)
    at w (eval at  (jquery.min.js?r=Z0KlZ:2), :1:1555)
    at Object.eval (eval at  (jquery.min.js?r=Z0KlZ:2), :1:1450)
    at Object. (jquery.min.js?r=Z0KlZ:2)
    at i (jquery.min.js?r=Z0KlZ:2)
    at Object.fireWith [as resolveWith] (jquery.min.js?r=Z0KlZ:2)
    at x (jquery.min.js?r=Z0KlZ:4)
    at XMLHttpRequest.c (jquery.min.js?r=Z0KlZ:4)

Any help would be so appreciated!


texts: Backdrop authentication function missing

texts:
I am using Backdrop CMS 1.10.1 with CiviCRM 5.2.2 and I am having trouble with the kcfinder, when uploading and inserting images, both into CiviMail and CiviContribute.

The initial problem was a 500 error.  Based on this bit of the log,

[Thu Jul 05 16:53:47.624995 2018] [fcgid:warn] [pid 6591] [client ] mod_fcgid: stderr: PHP Fatal error:  Uncaught Error: Function name must be a string in [site]/public_html/modules/civicrm/packages/kcfinder/integration/civicrm.php:67

I traced it down to this switch statement in /kcfinder/integration/civicrm.php

switch ($config->userFramework) {
    case 'Drupal':
    case 'Drupal6':
      $auth_function = 'authenticate_drupal';
      break;
    case 'Joomla':
      $auth_function = 'authenticate_joomla';
      break;
    case 'WordPress':
      $auth_function = 'authenticate_wordpress';
      break;
    }

This is missing the case for Backdrop, so $authfunction never got assigned to a string.  I tried to add a case for Backdrop, as well as the authenticate_backdrop function, but I don't know how to make it work.  First, I tried making the authenticate_backdrop function the same as authenticate_drupal, but it gives me the error:

You must be logged in with proper permissions to edit, add, or delete uploaded images.

I removed everything except the permission check from the function, so that it just looks like this:

function authenticate_backdrop($config) {
  // check if user has access permission...
  if (CRM_Core_Permission::check('access CiviCRM')) {
    error_log("There is permission.")
    return true;
  }
}

It gives me permission, and allows me to upload an image and insert it. Here is the original file with the authenticate functions for drupal, joomla and wordpress.  https://github.com/civicrm/civicrm-packages/blob/master/kcfinder/integration/civicrm.php

What is the correct way to implement authenticate_backdrop?  It is okay to just have the CRM_Core_Permission::check?


texts: Is there a setting to automatically Refresh Dashboard Data on a user login, or when returning to CiviCRM Home?

texts:
We're on Civi 4.6.17 and Drupal 7.

I'm looking for a way for users to be able to select an option to be able to automatically Refresh Dashboard Data on login, or when returning to their  CiviCRM Home page, without having to click on Refresh Dashboard Data.

Better, is there a way to have this be the default action with an admin setting.

Is/are there such a setting(s)?


texts: Problem upgrading CiviCRM on Joomla with Flexmailer + Mosaico installed

texts:
Today I've been trying to get all of my known CiviCRM on Joomla probelms documented as issues to help improve the CiviCRM Joomla experience. One glitch that I'm trying to investigate is that on my production site since installing Mosaico (and Flexmailer) I've had a problem with each CiviCRM version upgrade. The CiviCRM Database Upgrade Utility fails unless I disable Flexmailer (and Mosaico) first.

Most recently, going from 5.16.1 to 5.16.3, after installing 5.16.3 I didn't click on the CiviCRM Database Upgrade Utility link this time but instead went to Administer > Administration Console > System Status, then clicked on the alert for "Database update required". That gave me the following error:

Class 'Civi\FlexMailer\Services' not found

After disabling Mosaico and Flexmailer I was able to proceed with the database upgrade and it completed successfully.

On other occasions I have usually clicked the CiviCRM Database Upgrade Utility link. I don't know if that was the difference, but previously the database upgrade started but then stalled part way through. I didn't manage to reproduce it this time and couldn't find anything in the log.

This comment is I think regarding the same problem.

Because I can't reproduce this on a clean installation I haven't raised an issue yet. Can anybody else confirm if this is a problem for them currently?

I have Flexmailer 1.1.0 and Mosaico 2.1.1559427853 installed and Joomla 3.9.11.


texts: I need an online registration that contains multiple venues for an event

texts: We are a not for profit organisation that runs masterclasses & Seminars across Australia. I need an event online registration page that the member selects the venue they want to attend from a list that states Venue, Day, Date, Time


texts: I need a customized invoice generation. So I thought that would be pretty straightforward: I use the civicrm_post hook on Contribution when the invoice ID is updated. Unfortunately the contribution post hook is not called when the invoice_id is updated. Any suggestion on how I tackle this now for this specific instance (and yes, I will also add a PR for a core change to call the post hook when the invoice id is updated in the contribution)?


texts:
I've been attempting a data import for households and contacts on a new civi install, and cannot for the life of me figure out how to import the data and keep civi from creating duplicate records of contacts and/or households along the way.

I've followed the instructions provided here: http://wiki.civicrm.org/confluence/display/CRMDOC/Importing+Households+and+Household+Members

And about any number of combinations of data uploads, but am having no luck.

Does anyone have tips or instructions they like to follow for importing of contacts initially, when contacts need to be associated with households?

Thank you!


texts: Early Bird Registration by Membership Type

texts:
How can we give early access to registration forms to certain members, based on their membership status/role?

For instance,

Premium Members can access 2 weeks early and register.
Regular 1 weeks early.
Non-members on regular timing.

CiviCRM 4.7 / Drupal


texts: How to install civiCRM buidkit in WAMP server localhost with Drupal 7

texts:
I am new to civiCRM. I would like to install CiviCRM buildkit on my local environment. I am using WAMP server. I have followed this link: https://docs.civicrm.org/dev/en/latest/tools/buildkit/ but cannot find any useful notes for Windows installation.

Please help and thanks in advance.


texts: How to connect to Attentive.ly (Social Media Service)?

texts:
I have a Wordpress CiviCRM site and want to try using the Attentive.ly Social Media Service.  There is an Extension to connect to this service.  I have installed the Civi Extension and all seems good.  I created an account on the Attentive.ly site.  I am in the process of connecting Civi to the Attentive.ly account and it asks for 3 items of information:

1) URL you use for your CiviCRM access - I have no problem
2) Site Key you use for your CiviCRM access - I have no problem
3) API Key you use for your CiviCRM access - I do not know how to find this?

How do I find or create the API Key?

If anyone has experience with Attentive.ly and can give some feedback that would be great.


texts: CiviCRM Entity Tags does not appear in Rules

texts:
I am trying to follow the procedure outlined in How can I create a Drupal user when someone submits a CiviCRM-Webform?... but when I try to add the Event to the Rule described, 'CiviCRM Entity Tag' does not appear in the list of possible triggers.
I must be missing some module or configuration option, but can't see it.
Any help welcome,
Thanks, Tony


texts: API v3 get multiple results for one field

texts:
I have a custom field that can be inserted multiple times in a contact. I'm trying to get the right syntax for the API to display an array with the different results.

Here what I'm trying: civicrm/extern/rest.php?entity=Contact&action=get&api_key=userkey&key=sitekey&json={"sequential":1,"return":"custom_40","id":900}

I thought that "sequential" would give multiple results but it's showing only one

{

"is_error": 0,
"version": 3,
"count": 1,
"id": 900,
"values": [
    {
        "contact_id": "900",
        "civicrm_value_fellowships_3_id": "305",
        "custom_40": "2007-06-30 00:00:00",
        "id": "900"
    }
]

}


texts:
I have set up an event and everything works fine, but no confirmation emails are being sent. we are only getting the emails from Paypal informing us of payment. I have tested the mail settings and left it at the default "mail" and the site is on a linux server. I do receive an email when I test the settings. I have made sure the email addresses entered are correct. I have added email addresses to make sure it's not just one server not receiving them.

The emails were working correctly for an event last year. Since then I have updated to 4.7.1.

Joomla 3.4.8

I don't know what else to do.

Thank you for any help.
Patti


texts:
In my extension, I can now import some data (contact and membership) from a csv file through a specific download form.

I need now to create a scheduled import, that search, once a day, a folder for the csv presence. The php with the internal routed URL is now ready but I don't know how to periodically call it:

calling the routed page URL, ask me for credentials before executing
create a scheduled job, needs, from what I understand, a specific API

How can I do?

Thanks


texts: Is there an easy way to increase the width of the list of options for a custom field in the pull down?

texts: We have a custom field that has a number of options.  The descriptions of a few of them are long and wrap funny in the pull down, which, sigh, apparently is confusing to some people.  Is there an easy change the width of this pull down?


texts: Error when Installing Mailchimp Extension

texts:
While the Mailchimp extension does appear in my list of "Manage Extensions", when I  click Install, I get an error stating:

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

There is no other entry in my extensions for Mailchimp, so I can only assume it refers to itself. I've tried going in to wordpress\wp-content\uploads\civicrm\ext and deleting the uk.co.vedaconsulting.mailchimp folder. While this does remove it from my "Manage Extensions" list, if I add it as a new extension and install it, the same error occurs.

CiviCRM 5.19.2 (will be updating to 5.21.0 in Feb)

Wordpress 5.3.2

EDIT:

I've ran the same process with Debugging and Traceback enabled and get the following errors. Should be worth noting I'm running Civi on a local WAMP server, might have nothing to do with that but that explains the directory paths.

CiviCRM_API3_Exception: "DB Error: already exists"

#0 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\CRM\Admin\Form\Extensions.php(189): civicrm_api3("Extension", "install", (Array:2))
#1 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\CRM\Core\Form.php(495): CRM_Admin_Form_Extensions->postProcess()
#2 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\CRM\Core\StateMachine.php(160): CRM_Core_Form->mainProcess()
#3 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\CRM\Core\QuickForm\Action\Next.php(61): CRM_Core_StateMachine->perform(Object(CRM_Admin_Form_Extensions), "next", "Next")
#4 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\packages\HTML\QuickForm\Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Admin_Form_Extensions), "next")
#5 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\packages\HTML\QuickForm\Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Admin_Form_Extensions), "next")
#6 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\CRM\Core\Controller.php(351): HTML_QuickForm_Page->handle("next")
#7 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\CRM\Core\Page\Basic.php(411): CRM_Core_Controller->run()
#8 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\CRM\Core\Page\Basic.php(156): CRM_Core_Page_Basic->edit(1, NULL)
#9 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\CRM\Admin\Page\Extensions.php(121): CRM_Core_Page_Basic->run()
#10 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\CRM\Core\Invoke.php(290): CRM_Admin_Page_Extensions->run((Array:3), NULL)
#11 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\CRM\Core\Invoke.php(84): CRM_Core_Invoke::runItem((Array:16))
#12 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm\CRM\Core\Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#13 C:\wamp64\www\wordpress\wp-content\plugins\civicrm\civicrm.php(1441): CRM_Core_Invoke::invoke((Array:3))
#14 C:\wamp64\www\wordpress\wp-includes\class-wp-hook.php(288): CiviCRM_For_WordPress->invoke("")
#15 C:\wamp64\www\wordpress\wp-includes\class-wp-hook.php(312): WP_Hook->apply_filters("", (Array:1))
#16 C:\wamp64\www\wordpress\wp-includes\plugin.php(478): WP_Hook->do_action((Array:1))
#17 C:\wamp64\www\wordpress\wp-admin\admin.php(254): do_action("toplevel_page_CiviCRM")
#18 {main}
 Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: already exists
Return to home page.


texts: Leaflet map + Drupal Views + 400 CiviCRM contacts data = performance?

texts:
We try to pull CiviCRM  contacts data incl. multiply custom fields and display on map. There are around 400 contacts to display, yet map page loads a bit slower, than expected (5 to 10 seconds). It has been worse initially even at quite powerful server, but we've got significant improvements using combination of:

Redis
nginx ngx_http_gzip_module
fine-tuned MySQL (via mysqltuner.pl)
Drupal caching and  Views Accelerator module

Any advice on how to make it loads as fast as possible (up to, say 2-3 seconds) please?

Drupal 7x and CiviCRM 4.6x

UPD Views query

  SELECT civicrm_address.geo_code_1 AS civicrm_address_geo_code_1,
  civicrm_address.geo_code_2 AS civicrm_address_geo_code_2,
  civicrm_contact.organization_name AS
  civicrm_contact_organization_name,  civicrm_website.url AS
  civicrm_website_url,
  civicrm_value_society_chairman_10.public_contact_for_society_988 AS
  civicrm_value_society_chairman_10_public_contact_for_society,
  civicrm_address.street_address AS civicrm_address_street_address,
  civicrm_contact_civicrm_relationship.id AS
  civicrm_contact_civicrm_relationship_id,
  civicrm_value_society_chairman_10.subs_rate_single__38 AS
  civicrm_value_society_chairman_10_subs_rate_single__38,
  civicrm_value_society_chairman_10.meeting_day_time_1_531 AS
  civicrm_value_society_chairman_10_meeting_day_time_1_531,
  civicrm_value_society_chairman_10.meeting_day_time_2_532 AS
  civicrm_value_society_chairman_10_meeting_day_time_2_532,
  civicrm_contact.id AS id FROM  {civicrm_contact} civicrm_contact INNER
  JOIN {civicrm_relationship} civicrm_relationship_civicrm_contact ON
  civicrm_contact.id = civicrm_relationship_civicrm_contact.contact_id_a
  AND (civicrm_relationship_civicrm_contact.relationship_type_id = '59'
  AND civicrm_relationship_civicrm_contact.is_active = '1') LEFT JOIN
  {civicrm_relationship} civicrm_relationship ON civicrm_contact.id =
  civicrm_relationship.contact_id_a INNER JOIN {civicrm_contact}
  civicrm_contact_civicrm_relationship ON
  civicrm_relationship.contact_id_b =
  civicrm_contact_civicrm_relationship.id LEFT JOIN {civicrm_address}
  civicrm_address ON civicrm_contact.id = civicrm_address.contact_id
  LEFT JOIN {civicrm_website} civicrm_website ON civicrm_contact.id =
  civicrm_website.contact_id LEFT JOIN
  {civicrm_value_society_chairman_10} civicrm_value_society_chairman_10
  ON civicrm_contact.id = civicrm_value_society_chairman_10.entity_id
  WHERE (( (civicrm_address.geo_code_1 IS NOT NULL ) AND
  (civicrm_address.geo_code_2 IS NOT NULL ) AND
  (civicrm_contact.contact_type IN  ('Organization')) AND
  (civicrm_contact.contact_sub_type IN  ('Society')) )) LIMIT 1000
  OFFSET 0


texts: Modify the Tags (Categories) Administration page

texts:
I'm using CiviCRM 4.7.9 in a Drupal 7 environment. CiviCRM does an amazing amount of stuff remarkably well. Unfortunately, its Tags (Categories) Administration page (http:///civicrm/admin/tag) page is not one of them. I have a rather extensive set of tags organized into tag sets.

When I attempt to manage my tags, the Description column is so wide that it forces everything else off the page. You have to scroll way over to get to the incredibly important Parent ID, Tag set? and actions columns. When you scroll over, you loose all ability to see which tag you're actually dealing with. The whole thing is a terribly clumsy, difficult mess.

If I could just get rid of the totally unnecessary Description column in the display, it would not only make managing the tags (and tag sets) much easier, it would also make it possible. Is there any way of getting the offending Description column disappear?


texts: Need to make changes to Paypal website pro templete, Where is it located?

texts: I am trying to find out the template for Paypal website pro payment page that i see in contribution page. I am not abale to locate it!! Can anyone help me to locate this file please?


texts: Multiple Entry Custom Values : Find modified ID?

texts:
Whenever custom data is written to the database you can use the module_custom() hook to determine what most of the parameters written were. However, I've been unable to find the 'id' of the write.

For example lets examine Custom Group Athlete

Athlete

Field 1 Label: SportPlayed

Field 1 Type: AlphaNumeric

Field 2 Label: DateStarted

Field 2 Type: Date

Field 3 Label: Enjoyment Level

Field 3 Type: Alphanumeric

Field 4 Label: Updated

Field 4 Type: Date

Now,

Lets ignore any calls that this Custom Group should really be an activity.

Lets assume there are no checks on uniqueness of data answered.

Using the $params variable from the custom() hook I can see the particulars about every field that was writen EXCEPT the ID of the entry(Not the entity ID).

Therefore, if I had The following Data

Sport Played | Date Started | Enjoyment Level | Updated
-------------------------------------------------------
Baseball     | 1-1-2012     | High            |
Baseball     | 1-1-2012     | Low             |

and I changed the first entries Enjoyment Level from High to Low, how could I also change the Updated entry to today's date? Remember that, as I understand, I don't actually know which entries are changing values from the $param field. All I know are the values submitted. I need some way find the id of the entry which is oddly not included in the $param variable Does anyone have a way to do this? I understand that if values are roughly unique I could run an SQL query to search for all matching parameters and return the ID but that seems overly complicated.


texts: Integrating iATS forms through CiviCRM (Drupal) onto website Wordpress

texts:
We have installed the iATS plugin to our CiviCRM (on Drupal) and we would like to create an embedded donation form onto our Wordpress website. We don't want to use the CiviCRM public pages because moving donors away from our website will mean fewer people go through with their donations.

I'd like to know if anyone else has encountered this problem, and if they'd be able to share some insight into how best to move forward?

Thank you!


texts: How do I implement actions for a custom activity?

texts:
I want to create a custom activity with actions (ie one that does something rather than just record information). The actions are API calls using data from the activity.

One option would be to create the custom activities (as managed entities), and use a post hook to implement the actions.  Is that the preferred way or is there something better?

CiviRules is possible but is essentially the same using a post hook.

CiviCRM 4.7.x Drupal 7


texts: how to copy data from one custom field to another (text to textarea)

texts:
I created a custom data field of type text (alphanumeric) for use in a profile, but now realize it should have been a textarea (primarily to support line/paragraph breaks). A number of the these text fields already have data in them. I have created a new textarea custom data field and need to get the data from the each text field into the textarea for the same contact. I'm thinking a can do it using SQL, something like this:

UPDATE table_name
SET column1 = column2

However, poking around in phpMyAdmin, I can't find the relevant table.

Any help will be appreciated.

Wordpress 4.7.5 CiviCRM 4.7.17


texts: cron jobs process_membership, send_reminder and process_membership_reminder_date

texts:
I want to send out membership reminders 6 weeks, 3 weeks, etcetera before membership lapses. To send them out, i see multiple cron jobs:

process_membership, named Update Membership Statuses and Send Renewal
Reminders
send_reminder, named Send Scheduled Reminders, and
process_membership_reminder_date, named Set Renewal Reminder Dates

The first one should be on, I guess, like daily or so ?
It may depend on the second one - not sure ?
The 3rd one comes with a warning that it should be off:

WARNING: Membership renewal reminders have been migrated to the Schedule Reminders functionality

indicating that perhaps the first one doesnt have to be on at all.

I'm all confused :-) How do I set this up ?


texts: Can you change your default 'Activity Status' for adding a new activity? We use completed far more than scheduled...


texts: Not sure that I have Contribution Tracker configured correctly

texts:
Drupal 7.37, CiviCRM 4.4.15

Principles outlined in this page to embed a variable in the URL that gets stored in a hidden field on the contribution page.

Do I need to make the custom fields required or read-only? I made them searchable.  For each contribution I am getting a row inserted into the database table "civicrm_value_campaign_1", but the three fields are all blank.

URL: www.domain.org/civicrm/contribute/transact?reset=1&id=8&custom_1=sponsorship&custom_2=15&custom_3=child&amount=35.00

<?php

function pptsponsorship_civicrm_buildForm($formName, &$form)
{
// enable tracking feature
if (($formName == 'CRM_Contribute_Form_Contribution_Main' ||
        $formName == 'CRM_Contribute_Form_Contribution_Confirm' ||
        $formName == 'CRM_Contribute_Form_Contribution_ThankYou') &&
    $form->getVar('_id') == 8 ) { // use  CONTRIBUTION PAGE ID here

    // use the custom field ID and custom field label here
    $trackingFields = array('custom_1' => 'Campaign',
        'custom_2' => 'Appeal',
        'custom_3' => 'Fund');
    $form->assign('trackingFields', $trackingFields);

    if ($_GET['amount']) {
        $defaults['price_3'] = $_GET['amount']; //set the other value
        $defaults['frequency_interval'] = 1;
    }
    $form->setDefaults($defaults);
}
}

changed the code to the following:

function pptsponsorship_civicrm_buildForm($formName, &$form)
{
    // enable tracking feature
    if (($formName == 'CRM_Contribute_Form_Contribution_Main' ||
            $formName == 'CRM_Contribute_Form_Contribution_Confirm' ||
            $formName == 'CRM_Contribute_Form_Contribution_ThankYou') &&
        $form->getVar('_id') == 8 ) { // use  CONTRIBUTION PAGE ID here

    if (!$_GET['custom_1']) {
        require_once 'CRM/Core/BAO/CustomGroup.php';
        $defaults = CRM_Core_BAO_CustomGroup::extractGetParams( $this, "'Contact', 'Individual', 'Contribution'" );
    } else {
        $defaults['custom_1'] = $_GET['custom_1'];
        $defaults['custom_2'] = $_GET['custom_2'];
        $defaults['custom_3'] = $_GET['custom_3'];
    }

    // use the custom field ID and custom field label here
    $trackingFields = array('custom_1' => 'Campaign:Campaign',
        'custom_2' => 'Campaign:Appeal',
        'custom_3' => 'Campaign:Fund');
    $form->assign('trackingFields', $trackingFields);

    if ($_GET['amount']) {
        $defaults['price_3'] = $_GET['amount'];
        $defaults['frequency_interval'] = 1;
    }
    $form->setDefaults($defaults);
}

}

It is now working.


texts: CiviReport 'insufficient permission' error running financial report after update to 4.7.29

texts:
Only since upgrading CiviCRM to 4.7.29 from 4.7.11 (on Drupal), one of my users with 'editor' role is unable to run a financial report. The error she sees is:

"API permission check failed for FinancialAccount/get call;
insufficient permission: require administer CiviCRM"

I can't believe she should need full admin rights just to run this report. On 4.7.11 it wasn't necessary.

Is there a recommended way to investigate the error and see whether assigning a lesser permission to the 'editor' role would restore normal service? The upgrade process warned of a new permission 'manage tags' but nothing to do with Financial Accounts or CiviContribute.


texts: How to fetch CiViCRM events externally [ Drupal 7]

texts:
I'm new to CiViCRM. I want to fetch events which are created in CiViCRM which is hosted on another server. So basically I want to fetch CiViCRM data from one individual site to my site. I don't know that which are the ways to do it and which is the best one. But I think Rest option would be good if I'm not wrong. I'm not able to find any similar example which is near to my task. All I don't understand that how should I use my rest url with code:

1) Option 1:

$api = new civicrm_api3(array ('server' => 'http://localhost/abc',

'api_key'=>'123456789',
  'key'=>'123xyzABC'));

2) Option 2:

 $contactxml =       simplexml_load_file("http://localhost/abc/sites/all/modules/civicrm/extern /rest.php?entity=contact&action=get&key=<site    key>&api_key=$apikey&last_name=Koot");
  foreach ($contactxml->children() as $contact) {
    $display = $contact->display_name;
  }

Is there any other options. I want to go for option 1 if that is possible. How to get response in JSON?

Any help would be appreciated.

Thanks


texts: Civimail strips html when switching from source to wysiwyg editor

texts:
I use a separate email editor to code emails before copying and pasting into civicrm to send.

I have noticed that if I copy and paste into source and press send without looking at it in the wysiwyg editor the code works as expected.

If I look at it first the following code is stripped out. I am not a proficient email coder - this is what the programme I use puts in.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional //EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"><head>

The editor is CKeditor. Can I stop it doing this? I have a work around but if I could stop it (or understand if there's a good reason why it is doing it) that would be better!

Thanks
Caroline

New information: I think part of the answer is here. How do I override the default CKEditor configuration?
If that's right I'm not still not sure what I need to do! If anyone can help that woudl be great :)


texts: Where in the database is the Date Added for Group records?

texts: I'm trying to help a friend. A slew of his contact records got added to groups that they don't belong in. It happened on July 19th. I thought the civicrm_group_contact table would have a timestamp column, but I don't see one. Where is this Date Added stored (see below)? Is there a way to select these group records and delete them? Thanks...


texts: Anonymous users can't View details of a Contact in a public directory Listing

texts:
Currently on CiviCRM 5.1.2 / WordPress 4.9.6 in my dev site and on my Live site on CiviCRM 5.0.2 / WordPress 4.9.6.  The reason for the CiviCRM difference was it was my last attempt to see the cause of a behavior I'm seeing:

Problem:  Anonymous users are not able to View the details of a contact that is in our public directory listing.
Scenarios:

When an anonymous user clicks 'View' they are redirected to the home page.
For ANY logged in user it will show the details of the contact selected.

Expectation:  We are wanting even anonymous users to be able to see the details of the directory.

Things that have been checked:

I have looked for any errors during the timeframe in the Log files located in:

  wp-content/uploads/civicrm/ConfigAndLog

and

  ../wp-content/error.log

Checked the permission of the Profile that is being used for the directory Listing and detail View.

Used For option has    Standalone Form or Directory  and Search Views checked
The group, Hub Directory of Organizations, is selected as the Limit listing group.
No account creation option,  Issue warning and do not save selected, No Proximity search and Enable mapping for
this profile is selected
All fields are set to either Expose Publicly or Expose Publicly and for Listings
As one test I had all fields set to View Only to no avail

Changed the permission on the limit listing group, Hub Directory of Organizations, and its parent group from User and User Admin Only to Expose Publicly to see if it made a difference.  No avail.
Checked WordPress / CiviCRM permission access to make sure the following were checked:  Access_all_custom_data, access_contact_reference_fields, access_uploaded_files, profile_listings, profile_listings_and_forms and profile_view.  At one point I tried view_all_contacts, but to no avail.
Disabled any new extensions and the one that wrote for special formatting of my directory to see if it was affecting the permissions or access.  Did not fix.

What else should I check for?  A combination of things to be checked together?


texts: Issue with sending html email from civicrm with Smarty

texts:
I am testing some templates with smarty and I don't succeed to send them when the email is - apparently - encoded in html.
I could send them as normal text message. I could also send html templates that I have. But I can't send messages using both HTML template and Smarty.

I am sending from within Civicrm and it runs endlessly, when other types of messages are immediately sent (and well received).

Is this due to a limitation, a bug or should I set some parameters somewhere?


texts: Form Processor on WordPress - undefined offset: 1

texts:
I have a Form Processor set up to take newsletter signups on a WordPress.com website. The CiviCRM site is hosted separately.
It was working until recently and I've tried twice to retrace my steps but I've still not got it working.
When I test the Form Processor on the CiviCRM Site, it works as expected (matches to existing contact if present, adds group, adds Data Policy Acceptance Activity, updates one custom field).
I've checked the settings for the Contact Form in WordPress.
When I fill in the form on the WordPress site:

It just hangs, and nothing is stored in CiviCRM
The debug file says

[10-Oct-2020 12:59:14 UTC] PHP Notice:  Undefined offset: 1 in /srv/htdocs/wp-content/plugins/contact-form-7-civicrm-integration/contact-form-7-civi.php on line 59

This is lines 57-63 in the file mentioned:
  foreach($parameters as $param) {
    list($key, $val) = explode("=", $param);
    if (!empty($key)) {
      $data[$key] = $val;
    }
  }

Any ideas what I need to change/what I've missed?


texts: Is there a way to separate audit activities from "real" actvitites in a case?

texts:
In the "Activities" section of case management, real to-do items are mixed with the audit activities that are recorded for documentation purposes. This is irritating to some users.

Has anybody found a way to separate these audit activities from the "real" activities of the case (i.e. the ones originating from user entry , a sequence or a standard timeline)? In my opinion, the ideal solution would be to separate the audit trail and show it in a separate tab or different section of the screen, since you usually only need to look into these activities, if anything goes wrong during the processing of the case.
Completely deactivating the activities is not a sensible solution either, because the audit trail might be needed and very helpful in managing critical or disputable cases.


texts: How can I include pay-later contributions in a widget thermometer?

texts:
I have a contribution page which is collecting live donations and pay-later contributions.

I'm using the contribution page widget to display a thermometer with the total raised by this contribution page.

The thermometer includes donations, but not pay-later contributions.

What can I do to include pay-later contributions in the thermometer, too?


texts: Installing CiviCRM 4.7 in Drupal 7 can't match requirements

texts:
I'm trying to install CiviCRM 4.7.12 in Drupal7 but I'm unable to proceed with the CiviCrm Installer. Right at the top of the page (outside of the Installer box) I have this error:

Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in ...\docroot\sites\all\modules\civicrm\install\index.php on line 1256

Which is this line: $query = sprintf("CREATE DATABASE %s", mysqli_real_escape_string($conn, $database));
After that I can't make the requeriments match, and because of this, I can't procced with the installation. Apart from the error: Your database settings don't appear to be correct, which seems to be default, according to the Installation guide documentation, I have this list of errors:
CiviCRM Database Details

Are the access credentials correct? -> That username/password doesn't work: Access denied for user 'civicrm'@'localhost' (using password: NO)
Can I access/create the database? -> I can't create new databases and the database 'civicrm' doesn't exist. (user 'civicrm' doesn't have CREATE DATABASE permissions.)
Can I access/create InnoDB tables in the database? -> Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server. Could not determine if MySQL has InnoDB support. Assuming no.
Can I create temporary tables in the database? -> Could not login to the database.
Can I create lock tables in the database? -> Could not connect to the database server.
Can I create triggers in the database? -> Could not login to the database.

Drupal Database Details

Are the access credentials correct? -> That username/password doesn't work: Access denied for user 'drupal'@'localhost' (using password: NO)
Can I access/create the database? -> The database: 'drupal' does not exist.

I just started a blank Drupal instance and the only thing I'm trying to install is CiviCRM, I'm also following these steps, the only one o got a little confused was step 2.
Am I supposed to replace my settings.php with that line of code? Because mine just have this $databases = array(); while the one on the guide is filled with information.
What am I doing wrong?


texts: Changing background and button colours on public facing pages (like contribution) in drupal

texts:
Is there and easy way to change the colours on contribution pages, the background shouldn't be blue?
Also the buttons are all white with white text till you wave your courser over them.
Is there a simple way I'm missing that doesn't require any knowledge of code?


texts: Clicking a tokenized link for another contact leads to your activities being recorded as belonging to that user

texts:
This seems like a weird case that probably doesn't come up much, but it does seem to indicate something odd is happening.
If you are logged and click on a link for a Drupal webform with contact and hash tokens that are for another contact (for instance to test that link), then any activities you do in CiviCRM will be attached to that contact. So, if you create a group, it will say that other contact created the group or if you merge two contacts, it will say that other contact merged the contacts, etc.
This is fixed by logging out and back in again (and of course could be avoided by testing the link in an incognito window). Note that this does not require you to submit the webform, merely to load the webform page with the tokenized link.
I'm guessing this isn't something that is worth trying to track down, but thought I should put it here just in case.


texts: Creating thank you letters redirects to a contribution page

texts:
I just had a report of someone who was trying to generate PDF thank you letters for recent contributions, and when they click "Make Thank-you Letters", instead of downloading a PDF they were redirected to a Contribution page on the front end.

That sounded bizarre, so I tested and it did the same for me. I can't think of any recent change on the site that could cause this. I just upgraded to the latest release (from 4.7.27 to 4.7.29) and cleared caches, but it didn't solve it.

Has anybody else seen this type of behaviour before? Where to start looking to figure out what's happening?


texts: CiviMail tracked links in WordPress site are marked down by Mail Tester

texts:
I have CiviCRM (5.21.2) installed on WordPress site. When testing our CiviMail messages on https://www.mail-tester.com/ we are marked down by 1.7 when we use tracked links. If we turn off tracking, we get full marks. Mail Tester marks us down for the following reason:

URI_WP_HACKED_2 URI for compromised WordPress site, possible malware

Has anyone else experienced this issue?

Googling the error, some people report that "SpamAssassin treats any email with a common WP path in a link URL as suspicious. If enough other points are added, it can flag the message as likely-SPAM."

Because URLs are rewritten when tracking, it sounds like this would be a problem for anyone using tracking in WordPress since the URLs are rewritten like /wp-content/plugins/civicrm/civicrm/extern/url.php?u=1&qid=2

Has anyone found a solution for this?


texts: Easy "add to Google Calendar" link in Event confirmation emails

texts:
Are there recommended practices for adding a link in Event email confirmations so that users can easily add the event to their Google Calendar? By default, CiviCRM offers that users download the .ical file, which they can then add to their calendar.

I would like to offer a direct "add to google" link. While not everyone uses Google (I'm one of those who do not), a few of my users have requested this feature.

For web pages, this library seems like a pretty good solution:
https://github.com/carlsednaoui/add-to-calendar-buttons

However, we cannot embed javascript code in emails, so it needs to be simpler. It seems like we can use an URL of the following form, which can be included in message templates:

Add to Google Calendar

NB: I did not test all of the above event variable names. The above probably does not work as-is.

I was wondering: has anyone else already implemented this? any suggestions? should I worry about timezones?


texts:
I'm making a Views Plugin, a 'format type', and when I use CiviCRM Contact Gender as a field, it returns a Gender ID. That's to be expected. But when I use the other Views formats (HTML, grid, etc) it shows the actual gender.

Does anyone know why it is changing it to male, female etc on the standard ones, but leaving it as an ID on my new format?

Thanks,

Update - to be clear I understand that this is stored in the contact table as an ID that is looked up elsewhere. My question is - does anyone know how it's being looked up in the options table by standard views plugins, but not by mine?


texts: Contact Summary Layout Extension - Screen display problem

texts:
I have tried to install the Contact Layout extension and get the following issue shown in the attached screen shot. I am using

Drupal 7.72
CiviCRM 5.24.3
Contact Summary Layout 1.7.1
Angular Profiles 4.6-1.0.2

I wonder if someone might point me in the right direction to get this resolved.


texts: Default header and footer is not being recognized

texts:
CiviCRM 4.6.0

Default headers and footers are not being recognized so, unless I included the required tokens in the body of the email, Civimail will not send a test or schedule the email.

There was a typo in my original post. Version has now been corrected.


texts: Date fields are hidden in civiCRM donation form v4.5.1

texts: I can't seem to get the date fields to show up, they fill in and the donation form works, but you can't physically see the month and year which is an issue for anyone donating.


texts:
My organization uses CiviCRM and we are contemplating moving away from it, but before we make that decision I wanted to canvass this site for some information. I'm not incredibly familiar with the inner-workings of the software, so bear with me.

Currently, we have lots of users (around 400) who have access to Civi via specific groups with specific permissions. One complaint that we get is that it's cumbersome to run reports. Most run only membership reports, but in order to do that they have to enter their search criteria every time (Associated chapter, date range, membership types, Current Members, etc.). Is there a way to format the UI so that when those users log in that they have button that says "Run Membership Report" or "Run Contributions Report" that has pre-filled parameters based on their specific permissions? Or are stuck with the dropdown menu search and cumbersome process?

Is there a Civi addon that formats search results into graphic reports or graphs/charts?

Also, is it possible to auto-run reports at a set period (say monthly) and have them emailed to a particular contact associated with a particular chapter/org?

Thanks!


texts:
In Joomla, I've created a membership sign-up page under contribution pages. If I click "Test-drive" I can see the form and everything seems ok, but If I click "live page" or the corresponding menu entry (Associati) I receive error 0. I've noticed that the URL seems wrong, because the item ID is 1, not 1035 and if I correct it, I get the site interface, but no form anyway. Can someone help me? Even paying! maybe you need only to access administrator panel and give a fast look.... It's very important...

Thank you

http://www.lamuccapazza.org/


texts: CiviCRM webform event booking - mutliple free events with a one-off booking fee, and allowing edits

texts:
I was wondering whether it was possible to use CiviCRM webform to create a booking form that would allow someone to:

register for multiple upcoming events
pay a single 'booking fee'
edit their booking, without having to pay the 'booking fee' again

So far I've managed to:
It's possible to allow them to select from multiple upcoming events, using the 'Event registration' tab in CiviCRM webform.
I can enforce a single 'fee' for the registration using the 'Contribution' tab > 'Contribution amount' field > with a default set to 10 and disabling the field.
I can enable the Stripe payment processor.
I can use simple logic in hook_form_alter to reduce the 'contribution amount' to 0 if the same contact ID already has a completed contribution against the contribution page associated with the event.
However now the form does not submit because the total cost is '0' - and it seems to require there to be some sort of payment.
So what's left:

Is there a simpler way to achieve this?
Is there a way to configure the webform to still submit, and skip the payment processing, if the total cost is 0? Is this issue specific to the Stripe payment processor?


texts: Membership renewal forms - am I handling this correctly?

texts:
I just wanted to clarify if what I'm doing is best practice.

When a user signs up as a member for the first time we ask the standard core info and payment information (we give the option of using GoCardless or Stripe) we also ask a few personal optional questions about the user.

It's an annual membership so one year on, when they renew, they are directed to another page which basically is basically a clone of the sign up page with core info, payment, but doesn't include the questions we asked the first time around.

Is this the best way to do this?


texts: Conference Registration with Housing Requirements

texts:
I am looking for a way to run registration for a conference next summer. In addition to meetings, interest groups and general sign-up, I need to be able to assign housing and coordinate special needs.

The group that I am working with has/had a registration program that broke. It was proprietary and apparently not fixable. I need to show them a program that works, will be long lasting, and not too expensive. Mainly I am looking for help to setup the program and occasional ongoing support when problems occur.

CiviCRM seems like a good choice, but I am just starting to read through the documentation and try it out. While it mostly makes sense, I know that I need a really simple demo to convince others to use this software.

Thanks for any suggestions and pointers to simple examples.


texts: CiviMail - delivered and opened are always the same

texts:
For the report for a mailing from CiviMail, delviered and opened counts are always the same. Our client reports that for a number of mailings, the number opened always equals the number delivered. They don't think this is very realistic ...

I sent a test mailing to two different email addresses (both mine), viewed only one of them, but both showed as delivered and as opened.

CiviCRM 4.5.4 on Drupal.


texts:
I have been struggling for weeks now trying to figure out the best way to prepare a form where :

user selects province, apply a tax based on the province
user selects the membership priceset
total updated with the new membership price and tax according to the province selected.

is there any reference of key of achieving this? is this possible or not possible? I have been trying to use civitax but that's not the way to use it, and I tried adding mulitple tax field or trying to find conditional methods but that is not populating.

I am thinking of setting up the form in drupal custom form, then after that populate it via custom submit where when it submits, it manually db insert the transactions and all of that? but is that possible, as I search no clue of programmatically inserting/creating new user with membership info and so on.

thank you


texts: Integrating QR codes for event attendance

texts: Would like to check-in event participants using a QR code that will also update the attendance status of the participant. Is there an extension available for this feature? Any help is appreciated...thanks


texts: Rule to create a Linked Drupal user account for a specific CiviCRM Contact Subtype

texts:
I’m using Drupal 7.56, the Rules module 7.x-2.11 and CiviCRM 4.6.31.

I'm trying to create a Drupal Rule that checks the subtype of contact to create a Linked Drupal User Account just for a specific subtype of CiviCRM contacts when they submit a Membership Signup form.

I need to trigger that rule when a "CiviCRM Membership has been created", as Drupal needs an email to create the user account. If I include the Event "CiviCRM contact has been created" instead of "CiviCRM Membership has been created" to trigger the rule evaluation, the email for the contact is not available yet on the database, as e-mail address is an independent entity in CiviCRM and created after the contact has been created, so the rule fails when trying to create the Drupal user account.

The condition "CiviCRM Contact is of subtype" only works if I make the CiviCRM contact available from the "CiviCRM contact has been created" Event. So when I have the Event "CiviCRM Membership has been created", required for my rule to work, the CiviCRM Contact accessible from this Entity/Event (CiviCRM Membership) doesn't work with the condition "CiviCRM Contact is of subtype", as the Contact Subtype is an Array:

... (Array, 1 element)

 0 (String, 6 characters) Parent

Is there any way to make CiviCRM Contact Entity accessible from two different Events that trigger the rule evaluation, as "CiviCRM Membership has been created" and "CiviCRM contact has been created", so that the condition "CiviCRM Contact is of subtype" can have the appropriate CiviCRM contact parameter?

Or if it's not possible, how can I access the Array variable? I know I have to use the Rules Condition List contains item, but I'm not able to make "Contact Subtype" Array variable available to evaluate the Condition.

Any help will be very much appreciated.


texts: What replaced the "access CiviCRM" permissions?

texts:
There used to be a CiviCRM permission in the CMS for "access CiviCRM" - and most of the resources mention this.  But its gone now (CiviCRM v 5.33, Drupal 7.78) and I need to give some users contact, event, activity, contribution creation & edit permissions but not "administer CiviCRM" permission.
The result is that the CMS role "CiviCRM user" (different from "CiviCRM Administrator") cannot access CiviCRM unless I give full CiviCRM administration privileges.
What is the current best practice for giving this set of permissions?


texts: Why does A/B testing cause 'dedupe by email' to fail when sending CiviMail to contacts with same email address

texts:
Client is asking why 4 emails have been delivered to 4 contacts who all have same address.

Test1: tested with 2 contacts and didn't use A/B testing.

Outcome: was told would be delivered to ~1 address and was only 1 delivered - GOOD

Test2: tested with same 2 contacts with A/B - 50% to A and 50% to B (so no FINAL mailing)

Outcome: was told would be delivered to ~1 address and was only 1 delivered (to A mailing) - GOOD

Test3: tested with 4 contacts sharing same email with A/B - 25% to A and 25% to B and 50% to FINAL

Outcome: was told would be delivered to ~1 address. Had 1 delivered (to A mailing), 1 delivered to B mailing, and 1 delivered to Final mailing - BAD

So I think A/B testing is causing 'dedupe by email' to break


texts: Redirection to Organization Dashboard in Employer of Relationship

texts:
When you create an Employer of relationship in Civicrm and the person who signs up on behalf of the Organization logs in he is usually redirected to his own dashboard. How do you redirect civicrm such that when he logs in he is redirected to the dashboard of the Organization?
Any help will be appreciated. I know that a redirect wil be implemented but what is the url of the organization dashboard?
Am using Civicrm 4.6.8 with wordpress 4.4.2


texts: Contact Layout Editor menu item not available

texts:
I installed the new Contact Layout Editor extension, but I am not finding the new menu item, which should be at Administer / Customize Data and Screens.

Joomla 3.8.12
Civi 5.5.1

(Aside: in this process, I discovered that the extension created a new SQL table as MyISAM, which threw a warning in Civi. Easy enough to change the table to InnoDB, but it seems like a new extension should be using InnoDB by default. See https://github.com/civicrm/org.civicrm.contactlayout/issues/14. Fixing the engine did not solve the problem of the missing menu.)


texts: How to select multiple values in select2 control by jquery?

texts:
I want to select multiple options in a select2 multivalue control, when clicking a button.
This is useful specially for searches where the user needs to select many option to one of the filters

any idea how to achieve it..?
I found how to select an option in select2 single option dropdown, but not in a multiselect control for several options at the same time


texts:
I want to develop a very simple Extension which :

searches the current contact_id
then verifies if he is recorded for a given event (event_id as a parameter)
then, depending on the result, echoes a message or opens an URL.

I read that, to develop an extension, I first had to :

install Civix,
which requires installing first git and composer
... which seems very complicated to me for such a simple program.

Is there a way to write and upload directly the code in the Extension directory, whithout all these prerequisites ?


texts: Sending PDFs on event notifications and reciepts - disabling

texts:
Why is it when you go to:
civicrm/admin/setting/misc?reset=1
Admin->System Settings->Misc

And set "Attach PDF copy to receipts" to "no" that PDFs are still being attached to receipts?

This appears to impact both events and contributions.


texts: report to show all my outstanding activity

texts:
I want to be able to pull a report that shows all the activity that i have recorded, for scheduled, completed and ongoing.
How do i do this please?


texts:
Trying to install the summary fields extension, however I keep getting this odd error that I've been unable to figure out. Looks like this:

An error has occurred.
 CiviCRM-001   @import url(/administrator/components/com_civicrm/civicrm/css/civicrm.css); @import url(/administrator/components/com_civicrm/civicrm/bower_components/jquery-ui/themes/smoothness/jquery-ui.min.css);    Sorry but we are not able to provide this at the moment. Unknown extension: net.ourpowerbase.sumfields Return to home page.    function toggle( element ) { var className = element.className; if ( className == 'crm-accordion-wrapper collapsed crm-fatal-error-details-block') { element.className = 'crm-accordion-wrapper crm-fatal-error-details-block'; } else { element.className = 'crm-accordion-wrapper collapsed crm-fatal-error-details-block'; } }

I've tried to install on multiple occasions, however I get this same error. And, actually, I receive this error for any extension I attempt to install. Any ideas?


texts: How can I include the number of relationships in a household in exported data for that household

texts:
I need to mail multiple copies of our Client and Family Newsletter to households shared by individual clients.

How can I access the 'number of relationships' for each household (visible in the top ribbon), so that I could include that number in the info I give to the mail house, so that they can put the right number of copies in the envelope for each household?

Or is there a better way to achieve the same outcome?


texts: Event Management - notify participant on receiption of payment or on cancellation

texts:
I am setting up an event using CiviEvent.

People can register and have to transfer the event fee.

What do I need to to that people get a one time notification if the payment is received (manual status change to "transfer received") or if their registration is canceled (for example to modify it).

I am aware of the automatic reminders but I did not found how to configure them that the message is sent just at the day of the status change and only at that day.

I am using CiviCRM 5.2.0 on Wordpress 4.9.6.

Thanks,

Andreas


texts: CiviCRM 5.20 corrupts Memberships if created by Relationship

texts:
I have a configuration using Household Contacts, and Individuals who are linked to Households by 'Member of'/'Household of' Relationships.  The Household holds a Membership which flows down to the Individuals.  A Membership sign-up or renewal is done by a logged-in Individual and generates a Contribution attached to this Individual, though the associated master Membership is attached to the Household.  This is all set up using a Webform.

Since installing CiviCRM 5.20.0, whenever a Membership is updated one or other of the Memberships in this structure vanishes.  Previously on CiviCRM 5.19.3 it worked correctly.

If one of the dates on the Household Membership is changed through the CiviCRM Administrative Interface then:
- The Household Membership vanishes.
- The associated Individual Membership IS updated with the new date, and appears now to be freestanding belonging to the Member.

If the Membership is renewed through the Webform:
- The Household Membership is updated correctly and remains.
- The Membership attached to the Individual Contact vanishes.
- The Contribution which created the Household's Membership remains.

This renders 5.20 unusable as far as we are concerned.  I have also raised this as an Issue at https://lab.civicrm.org/dev/membership/issues/21.

Tony


texts: Unable to use ckeditor after upgrade to 5.3.1

texts:
After an upgrade from 4.7.28 to 5.3.1:

Text areas (e.g. editing an event description) have a blank part of the screen in place of the normal editing box.
The configure page of the ckeditor is also broken.
Both of those pages show a console error:

Uncaught TypeError: Cannot read property '17' of undefined
    at Object.keystrokeToArray (ckeditor.js:36)
    at Object.keystrokeToString (ckeditor.js:35)
    at CKEDITOR.ui.button.render (ckeditor.js:636)
    at G (ckeditor.js:647)
    at a. (ckeditor.js:649)
    at a.h (ckeditor.js:10)
    at a. (ckeditor.js:11)
    at a.window.CKEDITOR.window.CKEDITOR.dom.CKEDITOR.editor.CKEDITOR.editor.fire (ckeditor.js:13)
    at b (ckeditor.js:326)
    at a. (ckeditor.js:325)

They also show console errors of missing css files, which appear to be missing from the monoo-lisa skin directory of the ckeditor directory of my drupal libraries, i.e. not the one civicrm has bundled or should use. I presume this is just a side effect of the above error.

I have a very similar site that went through the same upgrade that does not have this issue (and both sites use Drupal's ckeditor via the wysiwyg module). This site notably has a very large CRM variable defined in javascript, but it doesn't show any other errors.


texts:
When I run e2e unit tests, it doesn't seem to recognise that I'm telling it to only use group e2e. This is possibly due to the default include/exclude filters in the phunit.xml file.

When I add the group e2e to the phunit.xml file, I get

CRM_BedResourceManager_BedResourceManagere2eTest
exception RuntimeException with message \Civi\Test::e2e() requires a real CMS. Found CIVICRM_UF=UnitTests.

When I hack the tools/scripts/phpunit to contain CIVICRM_UF='Drupal', not 'UnitTets' it then goes on to say

packages/DB/DataObject.php: "No database name / dsn found anywhere",

I tried popping some entries from civicrm_settings in there, but it didn't work.

a) Does anyone have a working e2e unit test config?

b) What are the settings I need to put in my tools/scripts/phpunit to make it work properly? My Civi and Drupes are in the same database.


texts: What is the best approach for displaying / modifying behavior of Activity Subject & Custom Field?

texts:
I have several custom fields in for a CiviCRM Activity ("Client Need"). Which of the following scenarios would be the best approach for me to sort and view Activity Summaries? And how would I go about doing that?

When data is collected into the "Client Need" custom field, dump that data into the CiviCRM "subject" field as well. In other words, these two fields essentially would need to mirror each other at all times.
Edit the default "Activity Subject" field so that it is a drop-down with a list of options when someone is entering a new Activity into the database. If that's possible, then I can just completely remove the secondary "Client Need" field.
Collect the data in the Client Need field, don't collect data in the Activity Subject field, and modify CiviCRM's default behavior for displaying the Activities, so that it displays the custom field instead of the activity subject field (so in the below screenshot, display Client Need field, and don't display Subject field):


texts: Can I add a timeline to a Case programatically?

texts: Is it possible to Add a predefined Timeline to a Case from a hook, via API or otherwise?  That is, duplicate the effect of a user clicking the "Add Timeline" button in a case?


texts: Why do i have to reenter the 'new organization' name when I have already entered it in the 'current employer' field

texts:
At some point the way 'new organisation' was created from the 'current employer' field on New Individual was changed/improved/updated.

If no match is found now (4.6/4.7) you can use a 'new organisation' link to create one. But having typed the name in to the 'current employer' field, the pop up then appears with the Organization Name field empty and it has to be retyped.

Seems like a functional regression since in the past you would type in the name only once.


texts: How can I add additional clients to a case?

texts: I want to be able to add additional clients to some cases. The ability to do this used to be configurable via the case settings XML file before the configuration got moved into the UI. What's the current approach (version 4.6.x)?


texts: Is is possible to hide GiftAid details if someone selects 'no'?

texts:
We're using the GiftAid plugin which is great.
However, if someone declines to use GiftAid the fields are still present and compulsory to fill in.
Is there any way to make them conditional on selecting Yes, or Yes in the past 4 years?
I appreciate they will still need to give the billing details on the card payment, but it's a little confusing to have to fill in data when you've deselected an option.
Thanks in advance,
John
Wordpress 5.5.1 / CiviCRM 5.30.0 / PHP version 7.3.23 / UK Gift Aid (uk.co.compucorp.civicrm.giftaid) version 3.4.5


texts: I don't have batch entry of contributions - why?

texts: I don't seem to have the "batch entry" feature in our Civi database.  When I go to the Contributions drop down where it should appear, it's not there.  Does this mean I'm running a downlevel version of Civi and if so, how do I find out what version I have?  Thank you.


texts:
I'm developing an upgrade to an extension and when this version is installed it's going to need to update the database.

The module extension has been made with civix and I notice there's a CRM_XXX_Upgrader_Base class that looks useful but I can't figure out where I'd put the code I need to run.

Are there any good examples of extension upgrade hooks that I could learn from?

I've looked at a couple of popular extensions, but they don't seem to have used/needed them, so I'm stabbing in the dark a bit.


texts: Could not find a valid session key when submitting opt out and unsubscribe forms

texts:
Using Drupal 7.39 and Civicrm 4.6.9 -

When submitting or cancelling the opt out and unsubscribe forms for anonymous users, I'm getting a 'could not find a valid session key message'. This does work however for authenticated users.

My site is fully SSL running off cloudflare. I have checked the following:

Resource urls are correct.
Base url is correct.
Cleared caches.
0 user id in the database.

Can you help?


texts: Clearing A Report - Contribution Summary

texts:
I clicked on 'Contribution Details' report and it had a general list of names from my last time playing with it. I clicked on a specific name I wanted to do a report for and tweaked the settings to me needs. Now, I want to change just the contact ID for this report with the same settings. However, there does not appear to be a way to change the contact ID or go back to the original list of names. I want to know how I can clear the settings entirely and/or at least change the contact ID. I already checked the filters section and the contact ID is not listed here to change.

Basically, I am trying to print of the donation history for each of our board members, but I cannot seem to do this from their contact page so trying from this report.


texts: Restricted access to the WordPress page but still getting errors: 'Sorry, due to an error, we are unable to fulfill your request at the moment.'

texts:
I am setting up some member self-service pages, restricting access using the 'Members' plugin, to show (on separate pages):

a profile to allow members to update their details via [civicrm component="profile" mode="edit" gid="1"] (different errors depending on view or edit modes)
Dashboard so that invoices and event bookings are visible via [civicrm component="user-dashboard"]

But still getting the following error:

Error with anonymous / not logged in user and viewing profile (if the
mode="edit" then redirects to homepage)

Error with anonymous / not logged in user and viewing Dashboard

'Members' plugin is working as expected and I can successfully set it up to restrict content and show custom messages. CiviCRM permissions appear to be correct / default.

I was not expecting to get any CiviCRM error messages as the content was restricted and not showing, though something is triggering the error messages / redirection.

I have checked with a clean install of both WordPress (5.4.1) and CiviCRM (5.25.0 and 5.26.0), and even used other plugins that do similar content restriction but all to the same end.

I am pretty new to CiviCRM so any suggestions as to fix this / or where to look would be much appreciated.

The back trace posted below for the view profile states 'Could not find the required contact id parameter (id=) for viewing a contact ...' which is understandable, though why it is trying to find contact id when the content is restricted is puzzling me.

backTrace

#0 [...]/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(337): CRM_Core_Error::backtrace()
#1 [...]/wp-content/plugins/civicrm/civicrm/CRM/Profile/Page/View.php(52): CRM_Core_Error::fatal("Could not find the required contact id parameter (id=) for viewing a contact ...")
#2 [...]/wp-content/plugins/civicrm/civicrm/CRM/Profile/Page/View.php(152): CRM_Profile_Page_View->preProcess()
#3 [...]/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(311): CRM_Profile_Page_View->run((Array:3), NULL)
#4 [...]/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:13))
#5 [...]/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:3))
#6 [...]/wp-content/plugins/civicrm/civicrm.php(1479): CRM_Core_Invoke::invoke((Array:3))
#7 [...]/wp-content/plugins/civicrm/includes/civicrm.shortcodes.php(328): CiviCRM_For_WordPress->invoke()
#8 [...]/wp-includes/shortcodes.php(343): CiviCRM_For_WordPress_Shortcodes->render_single((Array:3), "", "civicrm")
#9 [internal function](): do_shortcode_tag((Array:7))
#10 [...]/wp-includes/shortcodes.php(218): preg_replace_callback("/\[(\[?)(civicrm)(?![\w-])([^\]\/]*(?:\/(?!\])[^\]\/]*)*?)(?:(\/)\]|\](?:([^\...", "do_shortcode_tag", "[civicrm component=\"profile\" mode=\"view\" gid=\"1\"]")
#11 [...]/wp-content/plugins/civicrm/includes/civicrm.shortcodes.php(214): do_shortcode("[civicrm component=\"profile\" mode=\"view\" gid=\"1\"]")
#12 [...]/wp-includes/class-wp-hook.php(287): CiviCRM_For_WordPress_Shortcodes->prerender(Object(WP))
#13 [...]/wp-includes/class-wp-hook.php(311): WP_Hook->apply_filters("", (Array:1))
#14 [...]/wp-includes/plugin.php(544): WP_Hook->do_action((Array:1))
#15 [...]/wp-includes/class-wp.php(748): do_action_ref_array("wp", (Array:1))
#16 [...]/wp-includes/functions.php(1274): WP->main("")
#17 [...]/wp-blog-header.php(16): wp()
#18 [...]/index.php(17): require("[...]/wp-blog-header.php")
#19 {main}