texts: How to allow anonymous profile editing on Wordpress

texts:
We have a Wordpress site with CiviCRM. Only a few administrative users are allowed to login. We need to be able to let anonymous users modify their contact information. Below is info I copied from the wiki. Is it possible to do this with a Wordpress installation? Is the information current? How would the link be created in the email? The scenario is that when a user renews their membership using the online form, they get a confirmation email. The email must have the appropriate link to the secure form used to edit the contact info.

http://wiki.civicrm.org/confluence/display/CRMDOC/Linking+Profiles

  Allow Anonymous (not-logged-in) Users to Edit Their Profile
  A great feature is to "invite" your non-logged in users the ability to view and edit their contact info via a profile using CiviMail. To do this, insert the following link with appropriate tokens as shown into a CiviMail message:
  http:///civicrm/profile/edit?reset=1&gid=N&id={contact.contact_id}&{contact.checksum}
  ... where N is the ID of the Profile you want them to use for editing. The contact checksum token generates a special link that gives a user access to edit their information in that profile for 7 days from the day you send them the mailing.


texts: CiviMail error due to a word in the mailing - why?

texts:
I was contacted by someone who was having trouble saving a mailing, get this error in CiviMail:

I ended up comparing the version that saved with the version she had pasted in (which had some content additions) and then line by line (word by word) deleting the newly added text to try to identify a problem. It turns out it was the word "Reunion". I would delete the word and drafts would save, test emails could be sent... I would type the word back and the error would recur.

I've tried this on another install and had no problem using the word reunion so I am totally stumped as to how this could possibly occur. Any ideas?


texts:
I have a list of some 700 email addresses that currently have a membership status of Current.  I'd like to change to a new Membership status I've created in Membership Status Rules called Bouncing Cancelled.

I've tried exporting doing it via an import:

"Email","Membership ID","Membership Start Date","Membership Type","Status Override","Status Override End Date","Membership Status"
"xxxx@yyyy.com","19201","2018-10-01","Member","1",,"Bouncing Cancelled"

And variations of that (like setting the just the status to just Cancelled), but regardless of what I do the import always fails with: Invalid value for field(s) : Membership Status.

Can suggest a different way?


texts: CiviMail recipient count stuck on Estimating

texts:
I'm unable to send and/or produce test emails for large mailings. This seems to be a result of CiviMail not completing the recipient estimation process. Attempting a test email while it's stuck on "estimating" gives this error:

Error in call to Mailing_send_test : Error in call to MailingJob_create : DB Constraint Violation - possibly mailing_id should possibly be marked as mandatory for this API. If so, please raise a bug report

This appears to happen in the neighborhood of 4500 recipients and above.

[I have seen reports that similar issues were resolved in version 4.6.3, but this error occurred in 4.6.9]


texts: Database scheme corrupt - foreign key relationships are missing in mysql

texts:
At a client of us we have a problem with the database scheme. CiviCRM is working normally except that when you want to merge contacts the Activities/Groups/Relationships etc.. are missing in the merge screen.

After some investigation it turns out the merge functionality use the mysql databasescheme for fin ding out which tables are linked to a contact.

It does so with the query below:

SELECT table_name, column_name
FROM information_schema.key_column_usage
WHERE referenced_table_schema = database()
AND referenced_table_name = 'civicrm_contact'
AND referenced_column_name = 'id';

The problem at this specific installation is that the information_scheme.key_column_usage is empty for this specific database.

So I assume that the foreign key relationships are missing in mysql. In the past this civicrm site has moved databases from one to another and there has been an update from 4.5.x to 4.6.x

Does anyone know how to fix the database scheme?

Thanks


texts: Order of membership types on contribution page not correct

texts:
Does anyone have any ideas why the order of membership types wouldn't be correct on a contribution page? The order in the contribution page settings matches the order defined in Administration - Membership Types, but the display of the membership types is in a different order on the public facing page. I can make the order change by changing the order of membership types or unselecting some of the membership types on the contribution page, but not so that they are actually in the right order. I also note that trying to change the order in the membership types doesn't work right (sometimes membership types don't move at all, sometimes they move in unpredictable ways).
Any thoughts on why this might be? I cannot reproduce this on the demo site. 5.35 on Drupal 7, here is the contribution page. No default membership type set on the contribution page and we do have some old disabled membership types as well.


texts: How do I run PHP Unit Tests w/ XDEBUG from within PHPStorm [on Mac]?

texts:
My tools:

Instance generated with buildkit - civibuild: $ civibuild create
dmaster --url http://d47.localhost --admin-pass mypass
Mac OS + PHPStorm 8.0.4 + MAMP (/Applications/MAMP/bin/php/php5.6.10/bin/php)

I've been close to getting this to work a number of times - but still coming up short. I've looked at Eileen's: https://wiki.civicrm.org/confluence/display/CRMDOC/Tests+in+phpstorm and at Tim's How can I use Xdebug with CiviCRM unit tests? - but something is always slightly different.
UPDATE - after buildkit and phpstorm updates -> I’ve posted new slides in the answer below!


texts: Rule to Cancel Membership After Certain Number of Events Attended

texts: I'm new to CiviRules. I have a membership type that I want to be an event based membership in that I want users to users to be able to attend 5 events and then their membership is cancelled. I guess the rule would be: When active member on 'event membership' type attends 5 events their membership is cancelled and a renewal reminder email is sent. Can anyone help me with how to set this up?


texts: Shouldn't duplicate group titles be possible?

texts:
I'm wondering why duplicates in group titles are forbidden. Unique names should satisfy all bao and dao needs, don't they?

We need a repeated structure like

o project a
  o customers
  o services
  o orders
o project b
  o customers
  o services
  o orders

and it seems, civi is prohibiting this.

Any help would be appreciated, thx in advance // nielo


texts: Update of pending contribution leads to double transactions when working with localized version

texts:
I think I found a bug with Contribute module (tested against 4.7.30 and 4.7.31 / Drupal 7):

The following leads to double transactions, when using a localized version of CiviCRM:

create a new contribution with status "pending"
Record New Payment for that contribution
Looking to the details of the contribution, you will find 2 associated transactions (1 partially paid, and 1 completed).

I think that at least part of the problem can be traced back to line 3497 of file BAO/Contribution.php :

$currentContributionStatus = CRM_Core_PseudoConstant::getLabel('CRM_Contribute_BAO_Contribution', 'contribution_status_id', $params['contribution']->contribution_status_id);

returns the localized label of the status, which leads to problem.
by changing this to the following, the problem seems to disappear.

$currentContributionStatus = CRM_Contribute_PseudoConstant::contributionStatus($params['contribution']->contribution_status_id, 'name');

Can you confirm? (I must confess I am rookie at CiviCRM code).

Best regards
David


texts: How could I restrict view access to message templates

texts: Wordpress. I know I can restrict edit access but I would like to restrict "use". So I can allow some users to send an email but not select a template. (otherwise they can use for instance CEO signature)


texts: CiviCRM Architecture - CiviCRM directory structure

texts: Can anybody help me understand the architecture and directory structure of the civicrm. I found this post written in 2006 which doesn't seems to be valid for newer version.


texts: I see references in the CiviCRM wiki to "L2" and "L3" multi-site configurations - but no documentation on how to do L3 multi-site.  Can anyone explain the correct configuration for 3-level multisite?


texts: Looking for recommendations on Learning Management Systems (LMS) that work with drupal/CiviCRM. Thanks.


texts: civix civicrm:ping not printing any output

texts:
I am running CiviCRM on Mac OSX 10.11.3, using the latest Bitnami CiviCRM/Drupal stack (bitnami-civicrm-4.6.11-0-osx-x86_64).
I have civix-15.04.1 installed as instructed (under $HOME/civix), and have it added to the path. Likewise I have updated the PATH to use the version of PHP provided by the stack.

While I can use civix successfully to run commands like:

$ civix generate:module

when I try and run the following command (as a pre-req to generating custom-xml):

$ civix civicrm:ping

I get no output whatsoever (ie silent failure).

I am running the command from within the web root.

Anyone experienced this before? Any pointers greatly appreciated.


texts: How do I set a "Case Type Category" in the Compucorp CiviCase extension

texts: I see that the Compucorp CiviCase module adds a new "Case Type Category" field to the database.  However, I can see no way through the user interface to change it.  This means, e.g, that I can't add multiple workflows for the Prospecting extension.  Am I missing something?  Or is this only available via direct edits to the database?


texts: How can I set a custom field based on membership in a smart group?

texts:
I want to generate membership cards based on a person's geographical region.  The region logic is fairly complex (e.g. "Anyone in NY, plus New Jersey north of Trenton and Connecticut west of Stamford").  I have smart groups that accurately place someone by region.

Before we used smart groups, we manually added folks to static groups based on region. An extension called civicrm_post on the GroupContact to set the custom field.  However, civicrm_post isn't called on smart groups.

Does anyone have any ideas?  I don't mind using SQL in a cron job, but I'm not sure that civicrm_group_contact_cache is reliably filled with the correct data - in older versions of Civi at least, I often found it empty.

This is Civi 4.6.10, Wordpress.


texts: Why is "Billing" location type marked "reserved"?

texts:
What I was trying to do was disable the Billing location type, but I see in the database it's marked is_reserved=1, so it won't let you do it through the UI. But on a fresh install it's not even the default location type, so why is it marked reserved?

I was able to set is_reserved=0 in the database and then disable it, but wondering if this is going to break anything.

Thanks


texts: How to create a Wordpress User Profile when creating a Membership with Civi?

texts:
I am using WP 4.8.1 and CiviCRM 4.7.22

I would like to know what steps I need to take to ensure that when someone contributes through a civiCRM contribution page a Wordpress user profile with access to restricted pages is created?

Does this require an extension?

Thank you


texts:
The auto-save feature when constructing a CiviMail mailing is a nice feature, but has some issues. We've had a few problems where two users have been in the same mailing at the same time, which creates a race condition -- one person makes an edit, which triggers the auto-save; the second person makes an edit, which triggers an auto-save and overwrites the first user's edits. It's very easy to trigger an auto-save -- simply adding or deleting a space will do so.

I suggest we make auto-save optional (have a config option in the CiviMail component settings) and also add a locking mechanism so that a user cannot edit a mailing if someone else is already in it.


texts: Credit card fields do not show after updating

texts: I upgraded to CiviCRM 5.0.0 on Friday and our contribution pages do not show the credit card fields any more. I have attempted to re-save the contribution pages and payment processor information. When I try to edit the payment processor, I get the following page. I am not sure what else to try, thank you.


texts:
I have a webform where our users can add new contacts to CiviCRM.  This form creates an activity record.  And this form should create a membership for these contacts. The membership has some custom fields; let's say field Reason and has values "Good, Bad, Audit" and a Referral field that contains the name of a person.

So far, this is standard CiviCRM Webform.  I can create the new contact record, create their membership, and populate the membership custom field with the option that the user selects.

Now, this webform allows users to select existing contacts.  Those existing contacts already have a membership, and already have a value in that Reason field.

My goal is that for existing contacts, IF the user selects "Audit" for the reason field, then the membership does not update.  So the membership record, membership type, membership dates, Referral custom field and Reason custom field should stay the same as what they were previously.  But this only happens if the Reason custom field is selected as "Audit".  For any other reason field value, the membership should update as normal.

What I have tried:

I can't figure out how to do this using webform conditionals.  Is there a way?  I would need to somehow capture the contact's membership field values before the user submits the contact.
Could I do this with a webform hook?  In that case, which hook should I be looking at so that it processes before the webform/civicrm integration?
I looked at using CiviRules, with the Webform CiviRules integration, but this seems to fire after the webform is submitted.

Thank you


texts: Awaiting approval participant status message template

texts:
When requiring participant approval, it sends this email message. I would have thought it would have been in the system workflow messages under message templates. It is not. So where do I find this in core?

Also while configuring the online registration, it let's you customize the approval message, but I do not see where this is actually showing to end users.


texts: I am trying to customize a report (Contribute/Summary) to compute LAST YEAR "to date" totals (so I can compare them with how we are doing so far this year).  I have created the new template/php files but am at a loss where to "subtract the one year" from the "current year-to-date field" before the query is done.  Any pointers would be greatly appreciated.  Thanks!


texts: How can I link contacts & activities in a report or export?

texts: My client would like to report or export certain activities for contacts that meet a certain criteria.  This doesn't seem possible, which is surprising.  Activity search only allows a search of activity data - not contact data so contacts can't be filtered there although contact data can be exported from there.  Advanced search allows you search on contact and activity data, but then only allows an export of contact data - so no activity data.  It doesn't seem possible to have both contact AND activity data exported after filtering on both.  Or have I missed something?


texts:
When I attempt to save changes to an event that is part of a series (repeating), I am unable to save those changes to a single event, event onward or the entire series. Looking at the logs - I get the following error:

[warning] Deprecated function, use CRM_Core_PseudoConstant::getKey
Array
(
    [civi.tag] => deprecated
)


texts: Anyone want to try programming an extension for the world's easiest sms provider?

texts:
I would really like to have an extension for the NowSMS provider, and I've been through the documentation and creating an extension with civix, but there is just too much of it that is over my head. Would someone please consider creating one?

In my opinion, NowSMS has the easiest API of all the providers since there is no security or encryption of any kind. It's literally just http in and out with 3 variables, the two phone numbers and the message body.

You don't even need a working NowSMS installation to test it. You can use a browser and a small .htm file and a php script that can receive http get variables. As long as it uses http get and supports the three variables, it will work.

Ideally it would support a customizable url, and the attributes block would include the phone number, like any of the other providers.

For a bit of background, NowSMS runs through a cellphone instead of over the internet, so your only bill is to pay the phone bill. At $30 USD for the phone, the tipping point is 4000 texts per month, where NowSMS becomes more cost effective than Twilio.

Another cool feature is that NowSMS runs an app on Android phone, meaning you can use the cell phone as a cell phone, and then you can log into civicrm and send a bulk message, and you'll see it in the phone's text message app. When people reply, the message will be received by the phone's message app as normal, and it will also be copied and received by civicrm. Someone can be using the phone while someone else is using civicrm to send through the phone in the background.

So how about it, anyone interested in releasing a really easy extension?


texts: Civicrm fields in Views, present with editable fields?

texts:
is it do able to be able to present an editable fields with civicrm custom field? as I tested using it was not available for select?

update:
Rephrasing my questions, I am trying to setup a views with the profile contact details, but some of the contact details/fields are going to be a direct editable in the views fields options, like the module we used : drupal editable fields, but its not available for civicrm fields, are we able to do something out of the box?

thank you


texts: CiviCRM database issue with views and the definer

texts:
We have a website using CiviCRM that was recently switched from Drupal to WordPress as well as to a new server.

Everything on the website is working properly and they have had no issues with CiviCRM.

The problem: The websites and databases are backed up every night and the old backups are deleted upon completion of the backups. The CiviCRM database backup is failing because the database has 2 views (civicrm_view_case_activity_recent and civicrm_view_case_activity_upcoming) which have a "definer" which was carried over from the last server and does not exist on the new server.

The question(s): Is there a way to redefine the definer without recreating those views?

If not, is there code available to recreate those views?

Thanks!


texts: Adding a contact profile to a contribution page (user registration)

texts:
I have been searching the database for this kind of error but was unbale to get it solved thus far.

I am trying to add a contribution page for users to sign up. I have defined two main user groups: members and administrators.
Contact types as in the picture:

And I want to add a profile "basic profile" to the sign-up including some custom set of fields, which I have defined as follows:

If I want to add it to the contribution page, not even the drop down is visible, and it seems like a display error, but I have tried it on multiple browsers and the problem persists.
I reckon it must be some sort of definition error which makes no profile pop up in my contribution page. But where is the faulty definition?

Thank you very much for your help, appreciate it! I am using wordpress 4.12.1

Best regards
Joël


texts: For gift memberships, send email receipt to the giver

texts:
When Alice is creating and paying for a gift membership for Bob, she enters Bob's contact info and email address on the Membership Contribution form, so the emailed receipt goes to Bob (with a copy also going to the back office via the cc settings on the form) and Bob's email address becomes part of the contact record.

We have an optional custom field on the form where Alice can enter her own (different) email address and, ideally, receive a copy of the receipt as well.

in CiviCRM 4.6 we could make this happen by patching into postProcessMembership(), pulling the email address out of the form parameters, and tacking it onto the cc_receipt field that was passed to the sendMail function. However, in 4.7, the form handling is different enough that this method no longer works.

Is there a clean way to add a recipient to the emailed contribution receipt based on a value entered on the contribution form in CiviCRM 4.7?

thanks,


texts: Tags used for Cases, Activities or Attachments in Drupal Views?

texts:
We are trying to achieve a hierarchical approach to some of our case types by using case tags.

It works great on the back-end, but if I try to filter a view by the case tag, I get no results.

In the View UI, I add a filter of CiviCRM tags, see the case tags in the list, but if I select any of them, I get no results.

I've tried with tags attached to contacts, cases, attachments and activities.  The only one that appears to work is when the tag is attached to a contact.

Since Smart Groups don't appear to function correctly in Views either, this functionality would be very useful.

Tables look good, view appears to be set up correctly.  Tags is available as a field and I can see the correct Case Tags in the list of available tags.

I brought this issue up before, but have no resolution yet.

Here is a link to the old issue:
Case Tags in View


texts: I have a contribution page here https://flbc.edu/donate/flbc-donation/, but when I click on confirm it just brings me back to the same initial page. It was working before and I just upgraded to the newest Civi and now it is not working. Any ideas why this might be happening?


texts: How to detect/handle card failure from Payment Provider's callback URL

texts:
I have implemented a payment gateway for SwipeHQ's 1-off payment mechanism. It's similar to PayPal's mechanism in that there's an LPN that notifies CiviCRM of the success/failure of the transaction, and also a callback URL.

SwipeHQ adds a couple of URL parameters to the callback URL to notify of success/failure. These are in addition to the mechanisms in the LPN.

e.g. &user_data=619%2C7%2C5a00dbadde859a90b262eb532f863d98%2C%2C%2C2%2C%2C&response_message=INVALID%20CARD%20NUMBER&response_code=14&result=declined

My issue is that the standard Thankyou page in Civi has no way of picking up this important info and using it to instruct the user to try again. The message there is "Thank you for your payment" or whatever is set up as the thank you message.

So what's the best/right way to handle this?

is there a hook that could be used on the Thank you page to change the message?
or might it be easiest to just override the Thank you php and tpl files in order to display appropriate messages? I'd rather that this could be integrated into the payment plugin rather than having to mess with overrides though.
perhaps just some jQuery added to the page to do some dynamic HTML rewriting based on URL params?
or as suggested in another question/answer, use the LPN trigger URL to give to the payment provider as the callback, and integrate the checking into that file. It would end with a redirect back to the thank you page on success.

The latter seems like a possibility, but may have some issues:

How would you handle HTML display in the case that it's not "success"? Just spit stuff out directly from the LPN? But this wouldn't have any other templating etc from the CMS. What other pages could be used to redirect to?

Thanks in advance for any advice.


texts: Undefined Index error whenI run SYBUNT report

texts:
I am getting the following error when I try to run the SYBUNT report:

  Notice: Undefined index: yid_value in
  CRM_Report_Form_Contribute_Sybunt->where() (line 286 of
  /srv/bindings/23131a86a5da4d9d91a43fa1623b947f/code/sites/all/modules/contrib/civicrm/CRM/Report/Form/Contribute/Sybunt.php).


texts:
examples

Individual 1: Thomas Hess, work address bank of switzerland, 8050
Zürich
Individual 2: Steven Müller, work address bank of switzerland,
8010 Zürich

So I have 10 individuals of this kind and each works in another office of this bank.

It is confusing to add 10 new organisation only to have a work address. And to
add a Work address I need a field for the companie's name but there are only supplemental 1 and 2 field.

How can I add an work address?


texts: Allow list subscribers to update their email addresses?

texts: We have a list of people who work at many different companies with company email addresses. When someone moves to a new job at a new company their email address changes. How can we make it simple for someone who changes jobs to come to a CiviCRM Webform and change the email address we have for them? This would relieve our tiny staff of a major burden!


texts: How to modify a custom field DataTable (sorting and appearance) from an extension?

texts:
I am having difficulty customising the display of a DataTable for a contact custom field group (multiple-record tab). I am trying to write an extension that would use a bit of JavaScript to interact with the DataTable to do the following:

Order the table on one of its columns (date descending) when the page
is first opened
Conditionally change the colour of rows based on
rules and cell data values

I use multiple-record custom field group tabs extensively for contacts (a very useful feature that initially attracted me to CiviCRM). Although reports could be used to present data with more control, users are looking at the contact's tabs a lot more than they are reports and have asked for the above.

I have attempted to add some script in a hook. The form hooks such as buildForm don't fire so I found that I needed to use alterTemplateFile. (If it worked it would need extra conditions to apply it to certain tables only and sort on different columns for each.)

function customtablemods_civicrm_alterTemplateFile($formName, &$form, $context, &$tplName) {
  if ($tplName == "CRM/Contact/Page/View/CustomData.tpl") {
    $script = " CRM.$('#records-2').dataTable().fnSort([1, 'desc']); ";
    CRM_Core_Resources::singleton()->addScript($script);
  }
}

This gives an error pop-up in the browser: DataTables warning: table id=records-2 - Cannot reinitialise DataTable. For more information about this error, please see http://datatables.net/tn/3

I guess that this means that my script is being executed before the DataTable is fully initialised by CiviCRM. I went digging to see how CiviCRM creates the DataTable. There is inline script that comes from templates/CRM/common/jsortable.tpl but I found that for these tables it doesn't seem to do anything--modifying the JS in this template had no effect. It seems that it is actually js/jquery/jquery.crmAjaxTable.js that creates the datatable. Modifying jquery.crmAjaxTable.js looks difficult and am hoping to avoid modifying core files due to maintainability.

I then tried using the crmLoad event:

function customtablemods_civicrm_alterTemplateFile($formName, &$form, $context, &$tplName) {
  if ($tplName == "CRM/Contact/Page/View/CustomData.tpl") {
    $script = "
    CRM.$(function($) {
      $('#crm-main-content-wrapper').crmSnippet().on('crmLoad', function(e, data) {
        $('#records-2').dataTable().fnSort([1, 'desc']);
      } );
    } );
    ";

    CRM_Core_Resources::singleton()->addScript($script);
  }
}

It gives a "too much recursion" error in the browser console. The table is never sorted although the correct indication of sorting is given in the column heading. It looks like the sort causes the data to be re-loaded by Ajax which fires the crmLoad event again.

I also tried the DataTables API version in both of the above and it gives the same errors:
CRM.$('#records-2').DataTable().order([1, 'desc']).draw();

For the row conditional formatting, the DataTables documentation gives an example using the rowCallback option. (I would use addClass more like in this example.)

$('#example').dataTable( {
  "rowCallback": function( row, data, index ) {
    if ( data.grade == "A" ) {
      $('td:eq(4)', row).html( '<b>A</b>' );
    }
  }
} );

However I can't see a feasible approach for an extension to include such an option for the DataTable at the time that it is first created by CiviCRM, and DataTable options generally can't be modified later.


texts:
How can we ensure members renew as the same membership type?  At initial sign-up, they can choose their type but after that, renewals should be as the same type - they should not be able to renew as a different type.

One option is to create separate contribution pages for each membership type, then have a join page that links to each of those.  And then setup scheduled reminders for each type with links to the contribution page for renewal. With 13 membership types, that's a lot of setup.

So we're looker for a smarter way to do that.  Any ideas or useful extensions?  Drupal system so webforms are an option.


texts: How do I get PCPs to look 'right' when shared on Facebook?

texts:
We are using Wordpress 4.2.2 & CiviCRM 4.6.1. We have a couple of fundraising events in which participants have the option of creating a Personal Fundraising Page.

When participants share their PCP URL on Facebook the link preview doesn't share any info from their PCP—Page Title, Description or Photo—and doesn't link to their page, it links to the Base page that has been set for CiviCRM in Wordpress.

Is there a way to add Open Graph tags to each PCP? I did see that Mathieu created a Drupal module that adds Open Graph tags on PCP pages for Facebook a few years back: https://github.com/mlutfy/civicrmogp. Does anyone had any ideas for Wordpress?

I do know that there are plugins for Wordpress that allow you to add Open Graph Meta tag info to your website. These allow you to set that info for individual Pages or Posts, however the PCPs are generated dynamically through CiviCRM using the base Wordpress page that I configured, so setting Open Graph info on that page would cause all the PCPs to share the same info on FB—unless I don't know what I talking about (which is totally possible).

Here are some screenshots to help show what I am talking about:


texts:
4.6.2: Wordpress 4.1

If I save a new mailing as draft by clicking the Save Draft button, the mailing appears in both the scheduled and unscheduled lists. Seems to me it should not appear anywhere in the scheduled list.


texts: Connecting existing contribution to pledge WITHOUT Development

texts:
When someone makes a pledge, they may use a different contribution page to fullfil that pledge.

I see an API question about assigning an existing contribution to a pledge here: Connecting existing contribution to pledge.

Is it necessary to create an extension to assign an existing contribution to fulfill a pledge?  Perhaps this is a feature request to add an "assign to pledge" section on the contribution edit form.


texts: Recommended set up for Individuals -> Member of Organisation -> State Governing Body

texts:
This may not be the best forum to ask the following - so let me know if I have this wrong and let me know how best to proceed.  (FYI I'm in Australia and using Joomla 3.5.1)

I have been looking around for ages for a tool to manage our member bands individual membership records and history and have tried to get my head around how CiviCRM can help solve the issues with our current MS Access DB (i use that term very loosely) to record details about each band's members and the bands' financial status with the state governing body.  Best thing that attracted me to CiviCRM was the auditing of changes :)

our organisation, at a state level, consists of a governing body for the state with member 'bands'.  Bands can be 1 of 4 types and an individual can be a member of only one band for each of the types (most members are a member of only 1 or 2 of the band types).

Qu 1:  Should I be using 'Organisations' for each of the Bands or should I use Groups.

Qu 2:  Memberships are paid (manually) by bands on a yearly basis.  Individuals of a band are regarded as 'paid and active' if the band to which they are associated has paid the fee - their are no 'individual' membership fees payable.  How would I go about setting up the CiviMembership extension to do this?
I have gone so far as creating one Band and an individual who has a relationship to that band - but not sure where to go to next.

Qu 3:  We also have several awards for bands and individuals which we wish to track.  Should I be using tags, groups or custom field to record this information.  We want to be able to record the type of award and the date it was given.


texts: How to generate thumbnails of PDFs for files uploaded to civicrm file fields

texts:
Title says it. There are a number of Drupal modules which take care of this if the field is on a drupal entity but we are using civicrm fields (via a webform but pretty sure that is beside the point)

https://www.drupal.org/project/pdfthumb
https://www.drupal.org/project/pdfpreview

The actual Goal - in case someone has another route entirely is:
- folk submit a webform including uploading various files eg Passports
- markers are then given a webform that loads the Activity via aid in the url
- above the webform we pull in a Drupal View Block that loads the files related to the Activity (again by checking the aid in the url)

So it is via that View that we are hoping to show a thumbnails of the PDF rather than showing just a link to the file.


texts:
I am running into two separate issues that I need to address with logging.

I am having trouble with the MailChimp extension and turned on logging and I do not know the best way to get the logs.

I am having an upgrade fail and I need to know where the logging for this.

Thanks,
Josh


texts: Participant Get API pulls no records first time, correct number after

texts:
I'm using the v3 API to pull a list of participants for an event record. The call I'm making is:

$result = civicrm_api3( 'participant', 'get', array(
    'event_id' => $event_id,
    'options' => array(
        'limit' => 100,
    ),
) );

Usually, this works fine and pulls the participant information that I need. However, sometimes it will pull zero results (which is incorrect) but, on refreshing the theme page that displays the data, it will show the participants. It's like the first time through gets no results but primes the second try to be correct. It does not show zero records after the refresh, at least for a while.
I cannot regularly recreate this error. As soon as I start pulling down participant records over and over, I don't see the problem show up.

I know this is not a lot to go on but I'm not sure what else to check or how to reliably reproduce this in a way to show off the issue.

Is there a different way to pull participants? Or is this potentially something amiss with CiviCRM?

Thanks!


texts:
I have begun working on structuring a franchise type educational site and we are going with CiviCRM and Drupal.  However, we wanted to go with drupal 8 since we are starting fresh with a complete overhaul.

The reason I am writing, is I came across the civicrm Entity module, and from descriptions looks very promising to connect the needs of civi and our Drupal aspects of the project.  I wanted to ask though, how far along is that 8.x version? And is it ok to use?.... we are having some issue currently....

I did install the dev module that is up on https://www.drupal.org/project/civicrm_entity , however, I think something isn’t working as while I can place a civi field in a content type as entity reference, and I can add content and the reference loads in the form and can be selected, once saved however, all it shows is a “restricted access” text with (id) in the field, and when viewing published version that content item that field/reference does not show.

Also, I do not see the CiviCRM Entity types under the Drupal STRUCTURE admin area, but from some of the screen shots in blog documentation I saw this should be there for management options too….

We currently have all other modules and civi working with drupal 8, and this is our last critical piece of the puzzle.  Unfortunately, while I am comfortable working with drupal, I do not have a code background so couldn’t dig into this.

Is there more to activating this module than doing through main drupal admin panel, or maybe it should have been done via composer? Any insight anyone can provide would be MUCH appreciated on helping me getting civi Entity going & connected!


texts: I am working on CIVI CRM on wordpress. I need to make HR module in CIVI CRM. Can anyone tell me how to integrate CIVIHR extension in CIVI CRM.?


texts: How can I save Search results with preserving Views For Display Contacts (defined in Profile)?

texts:
I have a smart group which I would like to display with specific info in custom columns.

I can do Advanced search, select this group and choose predefined Profile in Views For Display Contacts. Then I get the group displayed with relevant custom columns.

How can I retrieve this view via link (to put it in Navigation menu)?


texts:
Ran into what might be a bug in the calculation of membership rollovers. Anyone else? Here are our details:

fixed length memberships that expire on 1 December
rollover date of 30 June (i.e. if you become a new member after 30 June, you expire at December 1st +1 year
members renewing and new members joining before 1 December get expiration of 2021
new members joining in December get expiration of 2022
new members joining in January get expiration of 2021
It looks like the system might be calculating the rollover based on 1 January and ignoring the fixed membership date of 1 December?

cheers ... :) gn


texts: Remove Contact Actions links (hook_civicrm_summaryActions or CRM/Contact/Page/View/Summary.tpl)

texts:
What is a correct way of whole Contact Actions menu ( this ones: http://awesomescreenshot.com/0cb5hmnb6e ) disable ?

hook_civicrm_summaryActions ( http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_summaryActions  ) doesn't remove whole thing;
altering templates/CRM/Contact/Page/View/Summary.tpl seems to be a
bit overwhelming;
hiding it via CSS doesn't seems like a good idea either.


texts: Is CiviCRM compatible with Postgres and Wordpress?

texts: Is there a version of CiviCRM that's compatible with Postgres and Wordpress?


texts: The "cmsBaseUrl" is not set according to the information in civicrm.settings.php

texts:
Error:
When I check the installation requirements (cv core:check-req) I get an error message that says:

The "cmsBaseUrl" (http://localhost/usr/local/bin/usr/local/bin/) is
unavailable or malformed. Consider setting it explicitly.

Despite this message, there have never been any errors related to the base url when operating the site. I only noticed it when I ran the above check.
Setup:
I installed CiviCRM on Drupal8 with the following cv command:
cv core:install --cms-base-url="https://example.org" --lang="de_DE" -m loadGenerated=1 -v

And looking in civicrm.settings.php I can see that the base url is set with:
if (!defined('CIVICRM_UF_BASEURL')) {
  define( 'CIVICRM_UF_BASEURL'      , 'https://example.org');
}

Troubleshooting attempts:
In civicrm.settings.php it says:

IMPORTANT: Trailing slashes should be used on all URL settings.

Accordingly, I changed https://example.org to https://example.org/ in that file.
I then cleaned up the Drupal and CiviCRM cashes via the admin interface. The error message remains.


texts: If a donor makes a credit card donation that is later reversed/refunded, what is the best way to record this? Just delete the gift?  Can you record a negative gift amount to offset the refund?


texts: Why are custom tabs not displayed correctly in contact summary?

texts: My users have reported seeing custom tabs not displaying correctly in the contact summary screen. Instead of wrapping, the tabs display as below. I can't reproduce the problem, although I have seen it in the past.  This is Civi 4.7.19  running with Drupal. Theme is 'Seven'


texts:
I have a front end directory which lists websites. When the results are displayed we get the website type (i.e. work, main, etc.) displaying in parenthesis. We want to take that out. For example:

Current display: http://www.website.org (main)

We are looking for it to look like this: http://www.website.org

running CiviCRM 4.6.10 in WordPress.


texts:
I just installed CiviCRM.
Now I wanted to input a Dashlet into the Dashboard.

But when i click on Configure Your Dashboard  it shows nothing.
I also created a report with the option make available in dashboard.
Am I doing something wrong?


texts: CiviMail Mailing - Unable to select group, getting error of No recipients

texts:
I'm using CiviCRM 4.6.4 on Joomla 2.5.17.  I'm new to Mailings so there may be something I am doing wrong, but there are several things that don't seem to work, including selecting a Group, sending an email to an address as well as to a Group.  But, let me first ask about selecting a Group.

I created the Group "test" with two contacts with valid email addresses and marked the group for Mailing.  The group appears in the Recipients drop down, but when I select the group, I receive an indication of "No recipients" and then the Recipients field label is highlighted in Red.  What could I be doing wrong?  Is this a known issue?

I primarily use Chrome, but I have tried in Firefox and Safari and get the same result, so I'm thinking that there is something  misconfigured in a database setting, Javascript file or PHP file, but I wouldn't know where to look to debug.  I have noticed there have been several postings regarding CiviMail and 4.6.x especially from Joomla or Wordpress users, so I don't know if someone has diagnosed this particular issue or if I am simply doing something wrong on my end.

I should also mention that I have upgraded from 4.4.x to 4.5.x over time and then recently to 4.6.2 and now 4.6.4, so I don't know if any of those upgrades broke my CiviMail configuration somehow.

Drupal 6


texts: Creating event with address and fee details with event create API(single request)

texts: Am want to use civicrm event create API to create an event with address and fee information but it's adding event data(to civicrm_event table) only, address and fee data not created. Is it possible add all info with single event-create api request?


texts: SOLVED: Can't run Upgrade script 4.7.21 (Drupal6) due to unknown column = civicrm_custom_group.is_public

texts:
After installing the 4.7.21 upgrade my D6 site shows as upgraded and Civi appears to run correctly. However when I run the upgrade script I get error: Sorry but we are not able to provide this at the moment. DB Error: no such field""

If I delve into the error I find:
[nativecode=1054 ** Unknown column 'civicrm_custom_group.is_public' in 'field list']&quot;]

Can anyone guide me how to fix this?


texts: Change logo for specific contribution pages

texts:
I have several contribution pages on CiviCRM and I would like to set a different logo for specific contribution pages only. Is this possible at all?
Thank you.


texts:
I'm struggling to get the CKeditor to work on civimail - there is a blank space above the text box space. I've made sure CKEditor is selected in Administer > Customise data and screens > Display preferences.

Has anyone got anything similar or a solution?

Edit: We are using version 5.4.1, on wordpress 4.7.5


texts:
Today i had to migrate my civicrm installation from an old server to a new server

On the new server i found an existing drupal and civicrm ready. So i tried to proceed as in this guide

https://wiki.civicrm.org/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location

What i did is after copying my drupal and civi project after that i took the existing drupal Civi installation and started editing the civicrm.setting and setting.php based on the credentials they gived to me. After that i imported the databases from my old installation and removed the mentionned cache files. I stopped at step 13 cause i wasn't able to access any url related to Civicrm (drupal is working). Each time i get a screen similar to this.


texts: Email segmentation with thousands of groups

texts: I am curious if there are any usability concerns with having thousands of regular mailing groups (not smart groups) to segment by county (3,142) in the US? Is there any guidelines or instances of Civi successfully running large scale numbers of groups?


texts:
I recently created some custom fields and some new event types for events.  Now I need to edit each event to change the event type, as well as populate those custom fields, for 5 years worth of events.  I just need to edit 3 fields: the event type and 2 new custom event fields.

I tried making a custom profile so I could do an export/import, but I guess custom profiles are not supported for events.

A search of stackexchange suggests there is really no way to bulk edit event information.

Would it be horrifying if I made the edits manually in the database?  Any other suggestions on options to edit event data in bulk?

Thank you!


texts: Why is CiviCRM not seeing the timezone correctly?

texts:
I have been unable to get the CiviCRM warning about timezone settings corrected after this just past daylight savings transition. Usually I would correct it by changing the timezone setting of the Drupal user ID's. In the past, the user's timezone setting would be an hour off to the real time, so adjusting the timezone setting in Drupal back to current time always corrected the issue. However this time the user timezone setting already was correct.

I have written up the following PHP tester:

<?php

$db = new mysqli('localhost', 'dbuserid', 'blablablapassword', 'db');

if($db->connect_errno > 0){
  die('Unable to connect to database [' . $db->connect_error . ']');
}

$sql = <<<SQL
    SELECT NOW() AS `NOW`
SQL;

if(!$result = $db->query($sql)){
  die('There was an error running the query [' . $db->error . ']');
}

while($row = $result->fetch_assoc()){
  echo 'MySQLi date: ' . $row['NOW'] . '<br />';
}

$result->free();

echo 'PHP date: ' . date('Y-m-d H:i:s');

?>

Which outputs:

MySQLi date: 2015-05-26 21:32:56
PHP date: 2015-05-26 21:32:56

Looks like they match to me.

I have also hard coded set the timezone into the Apache virtual site's configuration by adding to the site's .htaccess file:

  #Added PHP Timezone information to match Linux configuration
  php_value date.timezone "America/New_York"

Where else could be causing CiviCRM to complain thusly:

Environment Settings
Timestamps reported by MySQL (eg "2015-05-26 21:28") and PHP (eg "2015-05-26 20:28" ) are mismatched.
Read more about this warning

I am thankful,
Michael


texts: Deleted duplicate contact, when try to make login still says the email address is already registered ((Drupal 7.53, CiviCRM 4.6.24)

texts: Someone who signed up on our website was having trouble logging into her account (made via joining membership). I went to manually reset a login for her, and found out that her email address was already being used for a different contact account we had on file (made from joining a mailing list). To fix this, I deleted the latter contact account, so that only her membership one would exist. I then tried to create a login for this account, but every time I do so it says her email address is already registered still, even though I deleted the previous contact file linked to that email address and can no longer find it. Whenever I search for another contact under her name nothing shows up except for the membership one, which is the one I am trying to edit, so I don't know how to access (and DELETE!) this supposed second account that keeps on interfering with her membership one.


texts: Different payment processors for different price fields?

texts:
Is it possible to specify different payment processors for different price fields in a price set on a single contribution page?

I have a contribution page with two prices: £A for EFT, and £B for Direct Debit. £A is more expensive than £B to incentivize Direct Debit.

Direct Debit is chosen by the user selecting the Direct Debit price field, £B, selecting the pay later option, and then the user is directed to the DD form which they fill in and send.

However, a user can select price field £B and then select Credit/Debit Cards, thus paying the cheaper £B price.

I've found the extension 'Direct Debit for Membership Extras' (https://civicrm.org/extensions/direct-debit-for-membership-extras), but after testing with it, it still doesn't solve the issue of a user being able to choose the price field without limiting the choice of payment processor. Is this possible? The only workaround I can think of is to have two separate contribution pages, one for EFT price and one for DD price.

I've found some old posts (Fee based on payment processor, Adding a dynamic “cover processing fees” checkbox to CiviCRM contribution form, and https://forum.civicrm.org/index.php?topic=33098.0) but I'm hoping there exists a more recent extension to solve this issue.


texts: Contributions with Frozen Financial Type Field

texts: I'm finding that some contributions do not allow financial types to be changed. Normally there is a dropdown that allows a user to select a different financial type, but sometimes the field is frozen (see screenshot). Can someone explain this, or provide a solution?


texts: How to chain api calls i.e. GETFIELD contact for fieldID after doing GET profile on profileID?

texts:
I want to join the below api calls-
API 1
http://ec2-3-6-40-236.ap-south-1.compute.amazonaws.com/civicrm/sites/all/modules/civicrm/extern/rest.php?entity=Profile&action=get&api_key=userkey&key=sitekey&json={"sequential":1,"profile_id":22}

RESULT 1
{

"is_error": 0,
"version": 3,
"count": 1,
"values": {
    "custom_64": "",
    "custom_65": "",
    "custom_66": "",
    "custom_46": "",
    "custom_47": "",
    "custom_48": "",
    "custom_62": "",
    "custom_50": "",
    "custom_51": "",
    "custom_63": "",
    "custom_53": "",
    "custom_54": "",
    "custom_55": "",
    "custom_56": "",
    "custom_57": ""
  }
}

API 2
http://ec2-3-6-40-236.ap-south-1.compute.amazonaws.com/civicrm/sites/all/modules/civicrm/extern/rest.php?entity=Contact&action=getfield&api_key=userkey&key=sitekey&json={"name":"custom_62","action":"get"}

RESULT 2
    {

    "is_error": 0,
    "version": 3,
    "count": 31,
    "values": {
        "id": "62",
        "label": "Relationship with Guardian",
        "headerPattern": "//",
        "title": "Relationship with Guardian",
        "custom_field_id": "62",
        "groupTitle": "Voter Details",
        "data_type": "String",
        "name": "custom_62",
        "type": 2,
        "html_type": "Radio",
        "default_value": null,
        "text_length": "255",
        "options_per_line": "2",
        "custom_group_id": "28",
        "extends": "Individual",
        "is_search_range": "0",
        "extends_entity_column_value": [
            "Voter"
        ],
        "extends_entity_column_id": null,
        "is_view": null,
        "is_multiple": "0",
        "option_group_id": "121",
        "date_format": null,
        "time_format": null,
        "is_required": null,
        "table_name": "civicrm_value_voter_details_28",
        "column_name": "relationship_with_guardian_62",
        "serialize": null,
        "where": "civicrm_value_voter_details_28.relationship_with_guardian_62",
        "extends_table": "civicrm_contact",
        "search_table": "contact_a",
        "pseudoconstant": {
            "optionGroupName": "relationship_with_guardian_20201110084841",
            "optionEditPath": "civicrm/admin/options/relationship_with_guardian_20201110084841"
        }
    }
}

I have tried with this api call-
http://ec2-3-6-40-236.ap-south-1.compute.amazonaws.com/civicrm/sites/all/modules/civicrm/extern/rest.php?entity=Profile&action=get&api_key=userkey&key=sitekey&json={"sequential":1,"profile_id":22,"api.Contact.getfield":{"name":"$value","action":"get"}}

But I got this error :(
    {

    "fields": [
        "name"
    ],
    "error_code": "mandatory_missing",
    "entity": "Profile",
    "action": "get",
    "is_error": 1,
    "error_message": "Error in call to Contact_getfield : Mandatory key(s) missing from params array: name"
}

Please help.


texts: How to display location of many events on one map

texts:
I want to display a map showing many events location.
I use Civicrm with Drupal 7.
I think that it's possible to get events location in Views, but I don't know how to do this.

Regards.


texts: How to go about making a Core Tab on the Contact Summary screen view Inline instead?

texts:
Specifically -> I'd like to see what's in the Membership Tab -> Inline instead. I'd like that table with Active Memberships printed right at the top underneath the Display Name on civicrm/contact/view?reset=1&cid=xxx

When you add a Custom Data Set/Field you get a choice between Tab and Inline. Which is very cool. But how to go about switching a Core Tab -> Inline?

It's not as simple as finding the tpl - and then injecting that into the CRM/Contact/Page/View/Summary.tpl - as the $ variables aren't known. I don't really want to be copying phps bit over - I think?


texts:
When a staff or admin goes to manage tags, the page doesn't seem to load anything. I have checked in Drupal permissions that both admins and staff have permissions to administer tags and tag sets (in https://www.fosterclub.com/civicrm/tag?reset=1 or Contacts > Manage Tags).

I checked the following logs and can't seem to find anything related:

CiviCRM sites/default/files/civicrm/ConfigAndLog latest log
Apache
MySQL
Drupal (I use Drupal syslog in /var/log/drupal instead of watchdog)

I have checked in my development environment and the issue doesn't exist, and no code changes have been made or tracked through git.

Has anyone heard of this issue or know what I should try or look for? Thanks!

Edit: Other pages that seem to be affected:

New Tag
New Activity
Payment Processor settings


texts: Is it possible to customize the automatic date ranges in Advanced Search?

texts:
I was trying to help a group make a simple smart group of all memberships set to expire within the next 2 months and the dropdown for "End date" in the Membership section of Advanced Search only had "prior", "past", and "previous" options. Then, before posting here, I realized they were running on 4.5.x so I tested on 4.6.6 and saw that there were some noted improvements to this list (including some future dates):

We may be able to get by with these new options (thank you, whomever made them!) but I was curious if there was an easy way to hook into that date widget somehow in a module or extension and define a new option (e.g. "Upcoming 60 days"), or if that is a much bigger issue and best not to mess with. Does anyone know?


texts: Why is isFrontend set differently for Profile in create mode vs HTML snippet?

texts:
I had trouble with ajax Country / State dropdowns in a profile used as an HTML snippet embedded in a Joomla page.  The dropdowns worked fine in the profile in create mode.  I realized that the HTML snippet defines isFrontend as "false", whereas the create mode defines it as 1.

When set to "false", the query for a list of states upon a country change tries to access the administrator area, which fails because of authentication problems.  Changing the HTML snippet code to set isFrontend to 1 fixes that problem.

Is there a reason it's set to "false"?  Am I in danger of breaking something else?  Is this a bug in the generated HTML snippet?


texts:
I am trying to use the CiviCRM APIs from my React application. Which API methods would be the one recommended or easy to do with React application ? The easiest would be REST but since my page and civicrm will be hosted on the same machine, I prefer not to go down the REST route.

I read that CiviMobile uses react but didn't get too much information on its implementation.

Any recommendation and also examples or tutorials that I can reference ?

thanks.


texts: When are scheduled reminders for late registrants to events sent or not sent?

texts:
After a small mess over the weekend with an online event login information not being sent, I'm trying to figure out when scheduled reminders are or are not sent for people who register for an event after the reminder was scheduled to send. If I can get some kind of idea what the behaviour is supposed to be, I will test and add this to the documentation.
So, case A: A contact registers after an event scheduled reminder was sent, but before the event starts. Do they receive the reminder? Does it matter how the reminder was set (at a specific date time versus X hours or days before the event starts)?
Case B: A contact registers after an event scheduled reminder was sent, but while the event is happening. Do they receive the reminder? Does it matter how the event was set up, as above?
Case C: A contact is registered for the event after the event ends. Do they receive the past scheduled reminder? Does it matter how the event was set up, as above?
Opinions on what should or does happen seem to be mixed. See other questions here, here, and here. Is there actually a 24 hour test that will send scheduled reminders from 24 hours before the registration but not before? Are there additional rules?


texts:
I installed CiviVolunteer extension 4.6-2.1.1 on Civicrm 4.7.8 drupal7.  From the volunteer menu, clicked link to add new volunteer project. After filling the form and submitting (save and done or continue), a black pop up shows saved.  After that the screen grays out with spinning triangle logo and does not move.

Navigating away by clicking on CRM main menu and returning to Manage project gives a blank screen after heading Civi Volunteer.

Tried with backtrace on, but nothing showed up. Have cleared caches, reset menu, etc, and tried again, no help.

MySQL db lookup shows entry created in civicrm_volunteer_project, civicrm_volunteer_project_contact and civicrm_volunteer_need table.

Any help in pointing how to troubleshoot further and resolve issue will be greatly appreciated.

Thanks


texts: CiviCRM Recurring Contributions Report with Campaign

texts:
I'm trying to find a way to get a report on all the Recurring Contributions and what campaign they are attached too. Has anyone else done this? The Recurring Contributions report can give me the donations but there is no Campaign column.

Thanks


texts:
We've got about 100 tags we use to mark a contact's vertical market across thousands of contacts.

We've been asked to rename some of the tags for consistency, but I can't seem to find any way to do that.

We also tried creating a new tag set with the new tags, but as not all tags need to be renamed, I am not allowed to create  a duplicate tag, even if it is in a different tag set.

Is tags a Civi dead-end in this respect, or am I missing something?

Cheers!


texts:
I've mostly successfully migrated CiviCRM and Drupal to a new host and updated the software. I'm now running CiviCRM 5.24.5 under Drupal 7.70.  I am logged in as an administrator, and I can access pretty much everything except I'm having an issue with CiviMail. If I select "New Mailing" from the Mailings menu, I get an Access Denied message. I also get it if I try to reuse a previously sent mailing (these were all sent before the migration and upgrades).

I've looked at the user permissions in Drupal for CiviCRM and don't see any that seem specifically relevant to the mailings, and I have enabled permissions for everything for administrators anyway. I do not appear to be denied access to any other administrative function in CiviCRM - just this one in CiviMail.

How to I specifically enable permission to access the CiviMail New Mailings page?

Thanks in advance.


texts:
I need to use an organization's legal name for invoicing. I have already customized the invoice template for many other fields, but cannot see how to insert Legal Name as a token.

I note this 10 year old forum posting saying that the Legal Name field was not exposed to the token system:
https://forum.civicrm.org/index.php?topic=832.0
Is this still the latest answer?

I know I could add this to my custom field set for organization financial info, but I would rather not duplicate existing field names.

Likewise I can put the Legal Name in the Organization name field, but that renders the Legal Name field redundant (and gives me long, unwieldy org names)

We're running 4.6.24


texts: What to do about "Operation failed: Update Indices DB Error: unknown error Debug" after upgrading to 4.7.25

texts:
This is related to a question I posted yesterday (How does one delete "key indices"?), which was considered a duplicate of another question (Performance Warning: Missing Indices. Mismatched Index Key). I am posting this new question because it seems to be a somewhat different issue and because adding a comment to one of those other posts didn't quite seem to fit with this.

It was suggested that installing 4.7.25 would resolve that issue. However, it seems to have produced a new one.

With 4.7.25 installed under Drupal 7, I now get this warning:

  Performance warning: Missing indices

  The following tables have missing indices. Click 'Update Indices'
  button to create them.

  Table Name    Key Name    Expected Indices
  civicrm_option_value  index_option_group_id_name  name(128),
  option_group_id civicrm_case_contact  UI_case_contact_id  case_id,
  contact_id

But when I click the Update Indices button, I get this error:

  Operation failed: Update Indices DB Error: unknown error Debug
  information: DROP INDEX index_option_group_id_name ON
  civicrm_option_value [nativecode=1553 ** Cannot drop index
  'index_option_group_id_name': needed in a foreign key constraint]

Any help on what I can do about this would be appreciated. Please spell it out for me though; I'm not an expert at this stuff. Thanks.

Thanks.


texts:
I am sure I am just confused about profiles and was hoping someone could clarify a few things for me. We run a non-profit that assists foster children in our community. I am attempting to set up profiles for:

Foster Parent:
First name
Last name
etc

Foster Child:
First name
Last name
etc.

These should be 2 different contacts with a relationship between the 2.

I thought I did it correctly, however, I am now setting up an event where the foster parent would register the child.  I am using both profiles on the form but the form (and added contact) use the first and last name of the foster parent and list it as the same name as the child.  It's as if both profiles are combining to make one person when they should be separate.  What am I doing incorrectly?


texts:
IDs that previously were able to use CiviCRM now get 'Access denied - You are not authorized to access this page.'.  (i.e. /civicrm/dashboard) These Ids can log in to Drupal. I may have caused this with some Role permission changes.  I've fiddled with many of the Role permissions to no avail.  We use ACLs to limit access to contact records.

What's the necessary subset of Drupal Role permissions to gain access to CiviCRM?

Drupal 7.61
CiviCRM 5.9.0


texts:
I am trying to use the Drupal 8 Project on GitLab and I am having an issue with a downstream CiviCRM requirement. I am not sure where to post this issue, so I hope it is okay if I post it here.

The Composer files download civicrm/civicrm-asset-plugin. This asset includes pear/net_smtp. There is also a patch CiviCRM custom error message for CRM-8744.

When Composer attempts to apply the patch, I get the error " Cannot apply patch Add in CiviCRM custom error message for CRM-8744 (https://raw.githubusercontent.com/civicrm/civicrm-core/a6a0ff13d2a155ad962529595dceaef728116f
  96/tools/scripts/composer/patches/net-smtp-patch.patch)!".

I am not sure how to change what files are included in civicrm/civicrm-asset-plugin if there should be another patch or how to try and skip the patch in Composer.

Any help is greatly appreciated.

Thanks,
Steve


texts: I am using 4.7.13 on two different sites. On one site, when I update the class and refresh my custom report, all of the changes are visible. On the other site when I do the same thing, the changes are not visible. Even stranger, when I delete the class (i.e., the PHP file), the report is still visible in its old form. I have tried 'flush all cache' and searching for any other cached versions without success. Since this works on one site but not the other I suspect there is some configuration setting that I am missing somewhere.


texts: How can I adjust the fonts and layout of PDF reports?

texts: I have managed to clean up the display of membership lists (civireport) to the satisfaction of our users by linking a CSS file to the report header, but I do not find how to adjust the font and layout of generated PDF (is that even possible?)


texts: What are the advantages of a multi-site installation?

texts:
I am working with an organisation that is already using CiviCRM in English. It is developing with teams in a number of countries each of which is recruiting supporters, running training events and working in a different language. We now have Spanish, French, German and Finnish speaking teams. What advantages would we gain from a multisite installation?

The current English installation of CiviCRM is in a Joomla environment.


texts: Fuzion tokens for membership start and end date

texts:
I want to use Fuzion tokens in an attachment letter (an insurance certificate) and I need to show up start and end date for this certificate.

It's easy for name and everything related to contact or custom fields but I don't find for the start and end dates.

Is it something like {contact.membership_start_date} & {contact.membership_end_date}?

Will these customs fields work?
Is there a way to find them (documentation, ...)?

EDIT : 18/06/2019

I tried the Fuzion tokens found with Jon's help but unfortunately the {membership._} fields didn't work in my document. Others worked well. I thought at first, it didn't work out because the test user used had no contribution date, but actually even with one I can't get the token working.

Has anybody already succeeded in using those fields ?


texts: Create API not updating database in new extension - what have I missed?

texts:
Help, built new extension, form displays, accepts input, but never updates the database

The returns I get from all functions do not show errors.

What the heck am I doing wrong????

It's going to be flipping obvious when its pointed out, but I've been pulling my hair out with this.

So this:

W:\bluline\drupal\sites\all\modules\civicrm\ext\net.ssl-uk.sslext\CRM\Sslext\Form\System.php

<?php
use CRM_sslext_ExtensionUtil as E;

/** Form controller class */
class CRM_sslext_Form_System extends CRM_Core_Form {

public function postProcess()
{
    $result = civicrm_api3('Sslsystem', 'create', [ 'id' => 1,  'sysKey' => "abc", 'sysValue' => '123']);
}
}

Calls this:

W:\bluline\drupal\sites\all\modules\civicrm\ext\net.ssl-uk.sslext\api\v3\Sslsystem\Create.php

<?php
use CRM_sslext_ExtensionUtil as E;

function civicrm_api3_sslsystem_create($params) {
    $result = _civicrm_api3_basic_create(_civicrm_api3_get_BAO(__FUNCTION__), $params);
    return $result;
}

Which calls this:

W:\bluline\drupal\sites\all\modules\civicrm\ext\net.ssl-uk.sslext\api\v3\Sslsystem\Create.php

<?php
use CRM_sslext_ExtensionUtil as E;

class CRM_sslext_BAO_sslsystem extends CRM_sslext_DAO_sslsystem {
  public static function create($params) {
    $className = 'CRM_sslext_DAO_sslsystem';
    $entityName = 'Sslsystem';
    $hook = empty($params['id']) ? 'create' : 'edit';

    CRM_Utils_Hook::pre($hook, $entityName, CRM_Utils_Array::value('id', $params), $params);
    $instance = new $className();
    $instance->copyValues($params);
    $instance->save();
    CRM_Utils_Hook::post($hook, $entityName, $instance->id, $instance);
    return $instance;
  }
}


texts: Importing without changing primary address

texts:
Is there a way to tell CiviCRM not to set newly-imported addresses as primary addresses?

For example, let's say I have a database where everyone has nicely-curated "Home" addresses. I make a new location type "Voter" to import voter file addresses. The import process will make "Voter" the primary, but I want "Home" to remain primary.

The only way I know of is to backup the civicrm_address table and revert them using SQL, but it would be nice to skip that step.


texts: Render a previously submitted event registration

texts:
I would like to display to the user their existing event registrations in a format similar to what they see on the "Thank-you" screen &/or receive in the confirmation email. There are multiple event registrations that have different profiles and all use Price Sets.

Ideally, I'd like to create a function that takes the id of a Participant record and returns the formatted HTML that we see on the Thank-you screen; then I'd call this for each of the user's Participant records.

Any suggestions on how to do this efficiently would be most appreciated.


texts: Control Access to CiviCRM functions/actions available to Contacts

texts:
We have Drupal-CiviCrm setup with the sample data + Webform and WebForm_CiviCRM and have successfully created a webform which displays a form that allows you to filter the list by Org or Contact name

Now not having much experience with Drupal or CiviCRM I am trying to work out how I can allow a CiviCRM Contact to Manage contacts she has access to
eg take the Deforest Family where Ms. Alida Deforest can view and update information about Deforest family.

How do I allow Alida to do this when she comes to the website.
Further once this is set up how can you restrict Alida from changing (eg) relationships

Please be specific as the documentation around Drupal Roles - CiviCRM ACls doesnt seem to provide an end-to-end example.


texts: Can you please let me know how can I add photos on the member's profiles? I can not find it in the database.


texts: How can we do bulk renewals of memberships in Civi 5.13.3?

texts:
We have upgraded a CiviCRM system from 4.6 to 5.13.3 and now when clicking "Memberships"/"Find Memberships", entering criteria of Status = Grace, then selecting multiple records and clicking "Actions"/"Renew Memberships", we see a message in the top right with two fields for Activity "Description" and "Date".

If we enter values into those fields, or not, when clicking the button "Renew Membership(s)" we receive an error:

"Please correct the following errors in the form fields below:
Description is a required field.
Activity Date is a required field."

Any advice on how to resolve this issue would be appreciated.


texts: visiting this page https://forum.civicrm.org/index.php?topic=34814.0 Coleman said "PayPal standard feature is being added to Webform-CiviCRM right now, should be ready sometime next week." It was on November 14, 2014. Any news/update on this subject?


texts: "The CiviCRM public extensions directory at could not be contacted" -- why is my repo URL empty in the browser but not in `cv`?

texts:
Question: What could be causing the ext_repo_url setting value to be empty when running in the browser, though it appears to be correct when running in cv?
Under civicrm 5.35.2, if I visit the Extensions page, I see this message:

Extension download error
The CiviCRM public extensions directory at could not be contacted - please check your webserver can make external HTTP requests or contact CiviCRM team on CiviCRM forum.

Notice that it says "extensions directory at could not", implying an empty value for the repo URL.
Things seem to work normally using cv:

At the command line I run cv api Extension.getremote, I get a full json array of remote extensions.
From the command line, the setting has what appears to be a correct value.

cv api setting.get | grep -i ext_repo_url
"ext_repo_url": "https://civicrm.org/extdir/ver={ver}|cms={uf}",

I also tried a script with cv scr, and get what looks like correct output, like so:

$ cat /tmp/a.php
<?php
$a = CRM_Extension_System::singleton()->getBrowser()->getRepositoryUrl();
var_dump($a);
$ cv scr /tmp/a.php
string(51) "https://civicrm.org/extdir/ver=5.35.2|cms=WordPress"

But for content called from the browser, the repo setting appears to be empty. To test, I added this code to an existing extension:
function activityical_civicrm_pageRun(&$page) {
  $page_name = $page->getVar('_name');
$repo = CRM_Extension_System::singleton()->getBrowser()->getRepositoryUrl();
echo "<!-- page_name: $page_name -->\n";
echo "<!-- repo_url: $repo  -->\n";

And then I view the page source at https://REDACTED.example.org/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2Fextensions&reset=1 , which says:
<!-- page_name: CRM_Admin_Page_Extensions -->
<!-- repo_url:  -->
<!DOCTYPE html>

Also tried:

cv flush and wp cache flush do not make any change in the above findings.


texts: All seems fine but I still get this: You are not currently subscribed to any Groups

texts:
Can't get customers to show up on "My contacts Dashboard" URL.

Using CIVE CRM 5.x and Drupal 7

I checked all settings, created a group,assigned customers to group, but still not showing up...on the My Contacts link :

http://localhost/crm/civicrm/user?reset=1


texts: CiviEvent online registration not working with Stripe payment processor

texts:
I've just recently started working with CiviCRM so please bear with me.
I'm organising an event with CiviEvent. I have an online registration form which works great until I enable Stripe as a payment processor. As soon as I do that, when I enter in all the form details, payment details, and hit continue, the page just reloads without the form submitting or the payment going through. For testing purposes I tried using PayPal and I have the same issue. What am I doing wrong? Please, I would like to fix the Stripe issue over the PayPal issue. Any help would be greatly appreciated!

Stripe extension version 5.4.1
Wordpress version 5.2.2
Theme X version 6.5.5

UPDATE:
OK, so I was getting so frustrated by all of this that I decided to create a subdomain with a clean install of WordPress, civicrm, and not use a fancy theme, just in case.

Errors now via Chrome:
Failed to load resource: the server responded with a status of 404 () civicrm_stripe.js:1

and upon page reload:
GET https://example.org/register/wp-content/uploads/civicrm/ext/com.drastikbydesign.stripe/js/civicrm_stripe.js?r=auxgf net::ERR_ABORTED 404 (index):1083

GET https://example.org/register/wp-content/uploads/civicrm/ext/com.drastikbydesign.stripe/js/civicrm_stripe.js?r=auxgf net::ERR_ABORTED 404

Errors now via Firefox:
The script from “https://example.org/register/wp-content/uplo…/ext/com.drastikbydesign.stripe/js/civicrm_stripe.js?r=rOabd” was loaded even though its MIME type (“text/html”) is not a valid JavaScript MIME type.

Loading failed for the  with source “https://example.org/register/wp-content/uplo…/ext/com.drastikbydesign.stripe/js/civicrm_stripe.js?r=rOabd”. example.org:1051:1

My new setup:
CiviCRM 5.16.1
WordPress 5.2.2


texts: preferred language not importing with contact data

texts:
I have tried this several ways, but can't seem to get the preferred language to come in with the contact import. The initial values I had were basic (English, French, etc.) and didn't match the labels in Civi. I changed them to match the Civi labels, with no luck and finally, have tried simply using the assigned values: en, es, etc.  Still no luck.

Any thoughts?


texts:
When I send a bulk mailing I use the {contact.url} token, when the email comes through though the url is not a hyperlink.

Is there a way to amend this?


texts: Error on recurring payment with one installment

texts:
I recently launched a new donation page that allows recurring payments via PayPal Standard. I noticed a couple of recurring contributions had a status of "Pending (Incomplete Transaction)". It turns out both donors had entered "1" in the Installments field. I expect that would either be considered an input error or perhaps it would simply process it like a single payment. I tried it myself and found that the donation page will submit, but PayPal then displays an error:

  The link you have used to enter the PayPal system is invalid. Please
  review the link and try again

I assume the donors simply gave up at that point. I've reached out to both to find out. I suspect they thought the option for a recurring payment was actually a directive, and they entered "1" to ensure they were making a one-time donation.

Is there an option to force the Installments field to accept only values greater than 1?

While I was at it, I decided to try entering a zero in the Installments field. This makes no sense, but you never know what people will try. It actually processed the transaction with a payment. When I look at the transaction on "Find Contributions", it shows it as "Installments: (ongoing)". When I follow the link that is provided in the receipt to update the recurring contribution, it shows "Number of Installments 0".


texts: How to combine event registration fee and sponsorship donation in one price set?

texts:
I want to have a price set for an event which offers two mutually exclusive options: (1) registration fee for the event (2) a sponsorship fee. Option 1 should register the person as an attendee. Option 2 should not. In other words, the visitor either registers for an event, or makes a donation.
I thought that by putting 0 (zero) into the 'participant count' field for the second option, that it would not increment the participant count for someone who pays the sponsorship fee. But it DOES register the person for the event when all they are doing is making a donation. Am I missing something or can Civi not handle this use case without programming?


texts:
Recently created an event and started adding registrants. When I add a new registrant these errors appear:

Notice: Undefined index: is_show_location in CRM_Event_Form_Participant->postProcess() (line 1516 of /home/*****/www/www/sites/all/modules/civicrm/CRM/Event/Form/Participant.php).
Notice: Undefined index: metric in CRM_Core_BAO_PdfFormat::retrieve() (line 309 of /home/*****/www/www/sites/all/modules/civicrm/CRM/Core/BAO/PdfFormat.php).
Notice: Undefined index: metric in CRM_Core_BAO_PdfFormat::retrieve() (line 309 of /home/*****/www/www/sites/all/modules/civicrm/CRM/Core/BAO/PdfFormat.php).

I recently updated to 4.6.3 but it all seems to be working otherwise. Suggestions?


texts: Is there a way to search for organizations that have no active relationships?

texts: We're working on cleaning up database records, and while it's easy to pull individual records with no activity, I'm not sure how to find organizational records that are not tied to any current individuals. Is there a way to do this through Advanced Search?


texts:
I work for a NP that organizes performing arts and visual arts tours for our members.  We handle the booking, contracting etc for our members.  We are making the move to civicrm. Tours can have up to 30 dates/entries
I feel confident I will be able to move contacts over, but am starting to strategize on how to recreate or reimagine our tour management process. We do not manage the registration or selling of tickets for our members.  That is all handled locally.
Currently the flow is( This is currently in access in a tabbed form view)
Tour details(Tour name, Program, Description, image url, Agent, etc.)

Bookings ( Presenter, Date, time, location, fee, contact person, ticket link, commission, etc)
Artist payments ( summary of artist fees from bookings tab, payment, type, date, cheque payable to, amount)
Evaluation (submitted dates, attendance, capacity, gross receipts, comments)

I have reviewed some videos on the Events and on the Bookings extension.  neither seem to replicate this flow.  I will likely have to either change the flow or create/alter an extension to recreate this flow.  Has anyone replicated this scenario or have any suggestion on how this may be accomplished.  I am what I would call a shade tree mechanic when it comes to php.  I can handle the basics, and edit existing code pretty well, but building from the ground up would be a challenge.


texts:
We are trying to implement (recurring) SEPA payments. The OOFF payments seem to be OK (need to bring them to the bank still to be sure) but when someone makes a recurring contribution all we find in the SEPA dashboard is a OOFF payment. In the database tables we find the following payments. So I have three questions actually:

is there anyway we can test these xml's?
Is the behavior with recurring payments expected and will the next payments just appear at the right time after running cron job for recurring payments?
in contribution details we see as payment method SEPA DD One-off transaction but payment details mentions Credit card as payment method... Is this expected?
Thank you for your help. I know it is better practice to split up these questions but I have the feeling they could be answered pretty quickly by someone who has a bit more experience with this extension ;-)


texts: Unable to register for events with hyphenated email address

texts:
Someone tried to register for an event with a hyphenated last name.  Her email address is first.last-hyphenated@domain.com.  CiviCRM says "Please enter a valid email address" and will not allow her to register.

How can I allow hyphens to be passed through Event Registration and mailing list signups?

I am running CiviCRM 5.23.3 with MySQL 8.0.18 and PHP 7.3.14.

Thank you for your assistance!


texts:
Help! I just upgraded Civi from 4.7.3 to 4.7.7, but my host timed out during the DB upgrade and it was unable to complete. So I restored a backup of the database and was going to try again, but now every time I do anything with Civi, it gives me a DB Error: constraint violation.

I can't access any of Civi's backend now; it all gives me the same error. And when I try to run the upgrade script, it gives me the error after I click upgrade.

Is there anything I can do? Is my entire Database and my backup worthless now??


texts:
I edited the report for our needs, which is a primarily a list of attendees.  We only require the following for our reporting needs:

Name
Organization
Event
Status
Start Date
End Date

I cannot get anything when I preview the report.

I input in filter:

Participant Status: Attended

Participant Role:  Attendee

Event Type:  I clicked on all the events I would need attendee info for

then I input a start and end date

I get no names at all - blank

Under columns I checked off what I needed as well

?????

I am not a programmer.


texts: Can I use CiviCRM to print mailing labels etc?

texts:
I'm using MS Access now, which works admirably for our simple purposes: keeping track of 140 or so members, creating the odd phone list, and printing mailing labels quarterly and sending a personalized (merged) letter once a year. It's a standalone database, not connected to a website at this point.

Is CiviCRM suitable for this sort of activity? What would be the advantages?

It looks to me as if this app is meant to be used in conjunction with a website, which I suppose might be useful in our future.

Thanks.

Doug


texts: Recurring donations are receiving recurring email receipts after update

texts: I updated to 4.6.27, and recurring donations started re-sending out email receipts each month. The old behaviour was to send an email receipt when they made their contribution but not a monthly email.  I'm using the Stripe payment processor.


texts:
I get this message whenever I edit a contact:

Notice: Undefined index: is_deceased in CRM_Contact_Form_Contact->preProcess() (line 216 of C:\Bitnami\civicrm-4.6.9-1\apps\civicrm\htdocs\sites\all\modules\civicrm\CRM\Contact\Form\Contact.php).

Is this something I should be concerned about?

Thanks, Ian


texts: In many case, when visitors register to a public event, they use either capital case for or small case for their last name. Therefore, the deduplication engine considers both to be different. Can it be circumvent?


texts: Merge all duplicate contacts (running version 3.4.6)

texts:
I'm helping out a nonprofit with their CiviCRM.  They have thousands upon thousands of duplicate contacts.  These contacts are being pulled from an email service, that is sending the same email, sometimes 12+ times, to the same address.

Is there any way to merge all duplicate contacts automatically?  Or a way to export all contacts, sort them in, say, Excel, and re-import?

Merging each contact one-by-one using the rules would take weeks.

Thanks!


texts: How to set a custom country field using the API

texts:
Some fields that are stored as id references to other tables can be set by simply passing the value as an id, e.g. setting gender_id=Male works.

I have a custom fieldset attached to contacts that includes a country (of origin - it's different to of residence!) field, known affectionately as custom_77.

But I've noticed that the API doesn't like me to pass custom_77=Uganda - it complains that Uganda is not an integer. Can't fault it there :-)

My answer to the setting gender question provides a working solution: you can get it from getIdForLabel('contact', 'custom_77', 'Uganda'), or from any other country field, e.g. getIdForLabel('address', 'country_id', 'Uganda'), but as that turned out to be a very long winded solution when it was actually very simple, I thought I might, once again, be wrong! Hence this question.


texts: System Status Notice about Timestamps and Timezones

texts:
I've update my CiviCRM from 4.7.24 to 4.7.29 (my CiviCRM system on WordPress), everything seems ok but I have System Status Notice:

Timestamps and Timezones

This MySQL database stores certain fields with data-type "DATETIME". To improve timezone support, you may want to change these from "DATETIME" to "TIMESTAMP".

civicrm_subscription_history.date (New sites default to TIMESTAMP in v4.7.27+) [CRM-21157] (https://issues.civicrm.org/jira/browse/CRM-21157)

Changing should improve data-quality for organizations working in multiple timezones. However, if you do change, then you may need to re-test any customizations or processes that reference these fields. Changing is suggested but not required.

For further discussion, please visit https://github.com/civicrm/org.civicrm.doctorwhen

How can I do to pass this notice?


texts:
For reasons too stupid to relate here, I am trying to Export my entire Contacts file from the operating, on-line Drupal/Civi setup as a CSV to my desktop -- no problem. When I try to Import this CSV file into a development version on my desktop, I am able to browse and specify the downloaded file in the Import screen (name shows up in the proper field), but when I hit "Continue" at the bottom of the screen, I get a pink error message saying "Import data file is a required field" and the file specification in that field has disappeared. Any idea why?
Could it be that the Contact Name identifier is not the first field in the upload template (or the CSV, for that matter). Any help much appreciated as I try to recover from the aforementioned stupidity.


texts:
Le règlement no 2016/679, dit règlement général sur la protection des données (RGPD, ou GDPR, de l'anglais General Data Protection Regulation) est applicable en France depuis le 25 Mai 2018 (normalement).

Nous avons des clients qui nous demandent la confirmation que CIVICRM respecte les règles de la RGPD.

1) Savez vous si c'est OK ou pas pour CIVICRM ?

2) Y a t'il un document qui en parle ?

Merci pour votre aide

Bonne journée

bien cordialement

Pierre COCHAT
Makoa

English translation:

Regulation No. 2016/679, known as the General Data Protection Regulation (GDPR, or GDPR, from the English General Data Protection Regulation) has been applicable in France since May 25, 2018 (normally).

We have customers who ask us for confirmation that CIVICRM respects the rules of the GDPR.

1) Do you know if it's OK or not for CIVICRM?

2) Is there a document that talks about it?

Thanks for your help

Have a good day

Best regards

Pierre COCHAT Makoa


texts: Can the Xero accounting package be integrated with CiviCRM?

texts: What degree of integration is there between Xero and CiviCRM?


texts: How can I include a custom template file in an email template using smarty?

texts:
Details

We would like to create a standard header and footer for our email templates. Rather than pasting the custom HTML in the top of each system email template we want to override, it would be better to define a header template, and a footer template, and then use smarty to {include} these templates.

Is this possible with CiviCRM?

Is there a reason CiviCRM doesn't have a single header/footer template by default? If not would this make a reasonable feature request?


texts:
Apparently I am not allowed to ask for clarification in the post, so can someone please elaborate on this?

Sounds good. To be sure, please execute ///civicrm/menu/rebuild?reset=1&triggerRebuild=1 which fixes the trigger and function definitions in the database."

It looks like I need to do this, but where/how? I asked my hosting provider and they referred me back here.  :/


texts: Re-run iATS recurring contributions that failed due to bad iATS account credentials?

texts:
iATS credentials were messed up for a couple of days in December, and now I have lots of recurring contributions that failed, with source="iATS Payments Recurring Contribution (id=N) Agent code has not been set up on the authorization system. Please call iATS at 1-888-955-5455."

Is there a way to re-run those recurring contributions?


texts: How to change the date format for a mailing token for a custom date field

texts:
We have a date field, custom, set to be dd-mm-yyyy but when we add a token for that custom field in a mailing it comes out as yyyy-mm-dd hh:mm:ss

How do we change this


texts: Mosaico mail template URL's don't function properly

texts: I'm using Mosaico to create a mail template. I have 4 different tokens in the email (2 web links and 2 Mailto: addresses).  When the test email comes through everything looks good but the live segments all open the same webpage for some reason. Any ideas?


texts: Multiple discounts or admin only pricing?

texts: I'm creating an event that has a surcharge for registering at the door. I'm thinking of using CiviDiscount to create an automatic discount on the registration price set, then expiring the discount after normal online registration expires. However, I also have another automatic discount for a membership type. Can I combine the discounts this way? Will I be better served by creating an admin only option for registering attendees at the door instead of having only one price set that has the discounts applied to it?


texts: Smart Group relative date criteria not saving

texts:
There is a history of a bug in which Smart Groups do not store the proper relative date ("Next 60 days") criteria, but rather convert the relative date into a hard date ("3 Jan 2018" to "4 Mar 2018"). This bug was noticed starting with v. 4.7.x and was. supposedly fixed in 4.7.13 I'm still having this issue in 4.7.27 (Joomla 3.8.2).

Anyone else notice this recurring? Any advice?


texts: How can I (on page 2) show First Name of an Existing Contact - static (on page 1) without dragging it to page 2?

texts:
The First Name must also show on page 1 (and page 3/4/5/6 etc). If I'd just have two pages I could show Existing Contact on page 1 (display name) and then show First Name on page 2 but I've got 3/4/5/6/7/8 pages

First Name is an input[readonly] field - just a handrail to remind the parents which child's info they are updating to e.g. get the allergies and the busing filled out correctly.

Only easy 'option' I can see thus far is to put First Name (of Student 1) in a Fieldset Student 1 (on page 1). Then add a Fieldset Student 1 (on page 2) - and move the custom fields from Student 1 that need to go to page 2 (healthcare / allergy fields in this case) into that. Same for page 3 (selecting busing options). Etc. But then the parents have to remember who Student 1 (2/3/4) is all the way through.

Any ideas on how one could re-show Existing Contact fields on a next page? I've been thinking about perhaps creating a Student Name field in each of the custom data sets for contact type Student - and then PHP populate that with = First Name (or Display name) - make them readonly etc - pull these into the Webform - and they'd always 'travel' to any page with the rest of the fields in their dataset. But that would look a bit odd on the Student's CiviCRM Contact summary page.


texts:
We are using the Payflow Pro Processor, including for recurring donations.

Until recently there weren't any issues. But now, when a donor selects for recurring payments the processor always throws following error: Payment Processor Error message :9013: Error – from payment processor: [7 Field format error: Invalid or missing START/NEXTPAYMENTDATE field].

This is independent of whether I enabled selecting a period and installments or not.

We use the standard class for this civicrm/CRM/Core/Payment/PayflowPro.php. We had also developed our own class, which included NEXTPAYMENT as an option to be passed to PayPal.

Do we need to fiddle with your standard class, or is there a setting we miss?


texts: Direct Debit ACH/EFT Contribution: Asking for Banking Info Twice

texts:
When trying to complete a contribution using ACH/EFT our donation page (http://www.thewellspringfoundation.org/donate) is asking donors to enter their banking information twice.

The form is asking for the Name of the Account Holder, Account Number, Bank Number + Transit Number, and Bank Name in the Direct Debit Information section before the Billing Name and Address section AND then after the Billing Name and Address section it is asking for Transit Number, Bank Number, and Account Type. After filling in all the info, the Contribute button is greyed out. I believe this is because the Bank Account Number field is not displayed in the lower section, which I believe is generated by the iATS extension. See screenshot:

I have also noticed that the 'cheque' image is not found, as it it looking in the wrong place, the absolute path to the file, which could be due to something in my directories settings(?!?).

I upgraded to CiviCRM 4.7.28 earlier today. I am using CiviCRM in Wordpress 4.9.1. I have the following Extensions active in CiviCRM:

iATS Payments 1.6.1
Summary Fields v. 3.1.1
Extended Report v. 3.0
Displays relationships in the contact summary v. 1.2
Mailchimp v.
2.0.1


texts:
I'm running the latest version on WordPress. When I tried several times to add a grant, the following error showed:

CRM_Core_Exception: Invalid Entity Filter in /public_html/wp-content/plugins/civicrm/civicrm/CRM/Core/BAO/CustomGroup.php on line 485

I did add a few grant types and disabled the originally installed ones. Could that be the issue?

Thanks!


texts: Is it possible to record a copy of sent system workflow message emails as activities?

texts:
Is there a way to do this, or an extension that offers it?
We want to be able to see what was sent to people when one of these was used.


texts: Membership Type change from Fixed to Rolling

texts:
I'm working with an organization that decided to change their membership types from fixed to rolling. The member data was imported from an outside source. I set up a membership type "Regular-F" to attach to those members who were imported.
To change to rolling memberships for NEW members, I set up a second membership type "Regular" that is a rolling membership based with a start-date of when the membership was taken and an end date 12 months later.
Here's the problem: when a member has a membership of Regular-F and renews using the online form, the membership type of Regular-F is retained. I can manually change to Regular by editing the membership record, but I'd like to have a Regular-F membership automatically change to Regular upon renewal.
Is it possible? What happens if I disable the membership type Regular-F?
Is a batch change feasible?
thanks,
Kate


texts: CiviDiscount Automatic Discounts Not Working on Events

texts:
Using CiviDiscount 3.3, CiviCRM 4.7.1.9 and Wordpress 4.7.5.

When attempting to create an automatic discount for members of type, with status new, current, and grace period or even any current status, I am unable to get a discount to automatically appear on any membership or event pages. The code I created works, but won't automatically apply for members. This also means anyone with the code, even non-members can use it. What am I doing wrong?


texts: Ckeditor Subscript and Superscript buttons

texts:
I have manually edited the ckeditor config file: packages/ckeditor/config.js to enable the Subscript and Superscript buttons by commenting out this line //config.removeButtons = 'Underline,Subscript,Superscript

this is working correctly in my local environment but when i deploy it on production, the Subscript and Superscript buttons  are not available.

clearing cache (drush cc all, /civicrm/clearcache, browser cache) doesn't help, the only difference between my local and production is https.

How can i solve this issue?


texts: Contrbution Summary report on Average Contribution?

texts:
I am looking for a report that list all contacts who have donated an average between 100 and 200 in a time frame. So if a contact has donated 3 times in the period, one donation of 100 and two donations of 150 I would expect to see that contact.

I have played with the Contribution Summary report as it has a filter 'Contribution Average' and the option to add the donor name. It does not do what I hoped though? The donor name is just confusing on that report I guess.

Any suggestions or someone who has achieved this?

I need this on CiviCRM 4.4 but have also tried on 4.6 with the same results.


texts: IDS causing site to fail for lots of visitors

texts:
We are getting IDS errors left and right. We would get complaints here and there that our site isn't working and after reviewing our logs, IDS errors everywhere.

Mostly getting the error: There is a validation error with your HTML input. Your activity is a bit suspicious, hence aborting

We also seem to get this warning [warning] Deprecated Path: There is a setting (generate_schema_and_data) not correctly defined. You may see unpredictability due to this. CRM_Core_Setting::setItems
Array
(
    [civi.tag] => deprecated
)

Not sure if they are related - but sharing in case it is.

D7 5.24.3 (but this has existed for some time now.)