texts: CiviCRM Import contacts only adding some to groups

texts:
I have to csv files with organisation contacts in them, when I import a group of contacts it says it has created all the contacts, but will only add 300/350 or 160/240 into the group.

I receive no errors during the process.

Is there something I can do to fix this as soon I may need to add large amounts of contacts this way.


texts: Civi event links - Event Info-> 404 error

texts:
I'm a newby just getting started and trying to learn how to set up events in Civi (5.6.0), using Wordpress (fresh install tester site).

In manage events, if I am looking at one of my events (which are saved, happy, and do show up via shortcodes on the Wordpress site) if I click 'event links' and then 'event info',  I get a 404 error. All the other event links open fine.

The URL it is trying to go to is this:
https://[myURL]/civicrm?page=CiviCRM&q=civicrm/event/info&reset=1&id=4

Any idea how to get it to show the event page? Thanks!


texts: How to change WordPress permalink settings without killing CiviCRM

texts:
I'm not 100% sure if I'm framing this question correctly but here goes...

When first setting up Civi and WP, I remember setting permalinks as /post-name so that /civicrm pages worked correctly.

We've been redesigning the WP front-end and for content structure purposes we'd like to move permalinks to /category/post-name instead.

Is it possible to do this without killing CiviCRM page links?

Thanks!


texts: Redirect back to Event Registration after login fails

texts:
I've implemented user accounts during Event registration by enabling the profile's advanced settings to give the user the option to create a Joomla account.

When a user registers for an event, they are correctly offered the chance to sign-up or login:

  If you would like to create an account on this site, check the box below and enter a Username and a password. If you already have an account please login before completing this form.

The 'login' word above is hotlinked to a page which allows the user to login and then CiviCRM should return the user back to the Event Registration page.  It does not - after logging in, the user just gets a blank page.

The reason seems to be that the redirect page is malformed; it is:

/index.php?option=com_civicrm&amp;task=civicrm/event/register&amp;reset=1&amp;id=60

when it should be:

/index.php?option=com_civicrm&task=civicrm/event/register&reset=1&id=60

The & concatenators in the URL are being incorrectly escaped.  Any ideas how to address this?


texts: Registration forms not submitting - What Permissions needed

texts:
Is there a specific Permissions setting we need to turn on for forms to be submitted by anonymous users registering for event?

Error Message:
Please correct the following errors in the form fields below:
Mandatory fields (first name and last name, OR email address) are missing from this form.

Using CiviCRM 5.70 for WordPress

The form works fine When I am signed into WordPress.


texts: How to permanently delete contact with API?

texts:
I'm creating an automated test script. It creates a test contact, does some stuff, then cleans up after itself by deleting the contact.

However this still leaves the contact in the "Trash".

How can I either just delete the contact fully with one API call?


texts: Scheduled Follow Up activity after creating an event

texts:
We wanted to create 2 reminders after creating events within civicrm.

The first is to automatically create a follow-up activity to a particular contact after an event has been create ie pay invoice etc

The second is to automatically send an email to a particular contact X amount of days before the event date and the email to have event tokens like amount of participants etc.

I'm struggling to find ways to do this within CiviCRM or via extensions or modules like CiviRules or the Civi Rules / Civi Entity modules.

Does anyone have any suggestions?


texts: Any way to avoid "deprecated function" messages in the Drupal dblog?

texts:
I am getting a LOT of entries in the Drupal dblog (watchdog) about a deprecated PHP function, as described here -
 Debug PseudoConstant

I'm trying to debug a different issue and the presence of these (hundreds) of messages is making it very difficult.

Is there a way of turning down the logging level so that deprecated function messages are not shown? It seems odd to include them, because admins cannot even do anything about it, it's just for developers.

(I know I can filter the log by component and by severity; however, the messages I am interested in are also marked "civicrm" and "debug", so that doesn't help. And in any case, the Drupal UI only shows recent messages, so when there are hundreds of irrelevant ones, it doesn't have room for many of the ones I want to see.)


texts: How to change the suffix of my contact to a UK style?

texts: How to change the suffix of my contact with a UK style?


texts: How to fix a blank update my details link in the recurring payments receipt?

texts:
I am providing a recurring payments option through the eway credit card gateway and the agileware recurring payments extension.

eWay_Recurring (au.com.agileware.ewayrecurring) 1.5.2

The template looks like it is loaded from here web/sites/all/modules/civicrm/CRM/Upgrade/4.6.10.msg_template/message_templates/contribution_online_receipt_html.tpl

The %1 link is blank in

You can update billing details for this recurring contribution by visiting this web page

How do we fix this?


texts: noob query : Importing contacts and membership

texts:
I am going to freshly import data from excel into civiCRM. I have some contact related information like addresses, educational info, etc and also membership data like membership date, enrolled by whom, member center etc.

what are all my possibilities and their pros/cons?

Upload contact info in a separate excel and then should I upload membership info in a separate excel with the unique ID mentioned in membership excel?
upload both contact and membership together (if possible)?
Any other methods?


texts:
Editing original post: When I click "Print Report" from a case, the page is not pulling the CSS and activities are not showing. After the page reloads, I receive an error:

  Warning: DOMDocument::loadXML(): Empty string supplied as input in    CRM_Case_Audit_Audit->getActivities() (line 33 of
  C:\xampp\htdocs\sites\all\modules\civicrm\CRM\Case\Audit\Audit.php).

Originally, the conversation on Mattermost lead to a suspicion that this might be a Windows server issue. It's unclear now, but I do see this issue occur in both of my CiviCRM on Xampp windows. In Linux, I don't have this problem.

Has anyone received this error before?


texts:
I'd like to add some columns (eg. details of the address) and remove some columns (eg. State/Prov) to the table shown on a Contact's page, under the Relationships tab (there are tow of this table: one with the Current Relationships and an other with the Inactive Relationships).

How can I do this?

Thanks.


texts: Column deductible_amount not getting filled in on table civicrm_line_item

texts:
We use price fields/line items for all of our contributions.  I noticed that on the line_item table the column deductible_amount is not filling in.  I checked and Price Fields do not seem to have an option for "Is Tax-deductible".  Financial Types do have the check box.

My set up is
Financial Types:

Donation (tax-deductible is checked)
Tuition
Reimbursement

Line Items under Donation:

General Fund
Capital Improvement
Staff Salaries
Other __________________

What do I do to have it fill in the tax-deductible amount in the line item table?


texts: Why Can't I use an Organization Profile type in a Contribution Page?

texts:
I want to create a contribution page for organizations specifically.  So, I create a profile with the "Organization Name" field.  This makes the profile type Organization (as opposed to Individual).  When setting up my contribution page I'm unable to select my Organization Type Profile from the drop-down menu (Individual Type Profiles work fine).

I have modified the "On Behalf Of Organization" profile to include the fields I desire and selected the [Allow individuals to contribute and / or signup for membership on behalf of an organization?] check-box.  Other than the user having to check a box to see Organization fields, this works fine.

The problem now is that I can't setup the form to be a "cid=0" URL form, which gives the user the option to lookup a contact record and have the fields populate upon selection.  The lookup works on the Organization form, but when I click the organization I want CiviCRM doesn't populate the fields and I get this error: "Error Mandatory key(s) missing from params array: profile_id"

The web form I have put together for Individuals works great with a "cid=0" URL for lookup and auto-populate.  Why can't a form with organization fields work the same?


texts:
Activity list is not showing in contacts after upgrade to latest civicrm 5.9.1

I enable SQL debugging and its shows last query:
    SELECT COUNT(DISTINCT(tbl.activity_id)) as count FROM ( SELECT civicrm_activity.id as activity_id from civicrm_activity left join civicrm_option_value on civicrm_activity.activity_type_id = civicrm_option_value.value left join civicrm_option_group on civicrm_option_group.id = civicrm_option_value.option_group_id INNER JOIN civicrm_activity_contact ac ON ac.activity_id = civicrm_activity.id INNER JOIN civicrm_contact contact ON ac.contact_id = contact.id where ac.contact_id = 40023 AND civicrm_option_group.name = 'activity_type' AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 AND civicrm_activity.is_test= 0 AND ( civicrm_option_value.component_id IS NULL OR civicrm_option_value.component_id IN ( 1,2,4,5,6,8,9 ) ) ) as tbl LEFT JOIN civicrm_case_activity ON ( civicrm_case_activity.activity_id = tbl.activity_id ) WHERE civicrm_case_activity.id IS NULL;

Which means it return only count of activity  not the list.


texts: Confirmation receipt sent from strange sender address

texts:
If I send a confirmation receipt (checked 'Send Confirmation and Receipt?' during renewal of a membership), the sender address is wrong if the preferred is chosen. In stead of displaying the address given, it scrambles the address to 'id of the address in civicrm_mail table'@'server host name', e.g. 2@s2.domain.tld.

When I choose another address, the sender address is fine.


texts: What is the best way to record the primary contact for an organisation?

texts:
I'm trying to understand the best way to record that a contact is the primary contact amongst the many related employees of an organisation. Does Civi have an in-built way of handling this?

Option 1 for me was to setup a tag called Primary Contact and provide this tag to the Primary Contact.

Option 2 was to create a custom field with Primary Contact (Yes/No).

Option 3 was to setup a new relationship "Primary contact of".

Which option would be the best to maintain? Any other thoughts?


texts: Anyone else seeing an overlapping admin/civi menu bug with Joomla 3.8.13 and CiviCRM 5.6.0?

texts: After an upgrade to Joomla 3.8.13 and Civi 5.6.0 the Joomla admin menu dropdown is stacking under the Civi menu. I can't reproduce on https://joomla.demo.civicrm.org as even if the versions weren't 3812 and 560, the Joomla admin menu isn't long enough.


texts: Error with Contact Custom Field in Advanced Search

texts:
We had an issue with the addresses of our contacts, so for now we added a temporal custom field that saves the province of that contact, so we can easily filter them. The thing is that when I do an advanced search filtering for that field, it doesn't show any results. What could be the problem?

Thanks in advance!


texts: How can I add columns to the Accounting Batch screen?

texts:
I would like to modify the screen at http://mygroup.org/civicrm/batchtransaction?reset=1&bid=332

Specifically, I would like to add columns to the tables listing the transaction records.   Which CiviCRM file would I need to override?


texts: How is 'contact modified' defined as on CiviCRM reports?

texts: I'm looking to run a report that only shows contacts who we've engaged with (registered for an event, joined our database, updated their details) in the past 12 months. Would the 'contact modified field deliver this report? Thanks all!


texts: Unable to access administration links after upgrade to CiviCRM 4.6.10

texts:
I have upgraded from CiviCRM 2.5 to 4.6.10.

Since the upgrade I cannot go into any of the links in Administer CiviCRM without an error:

   @import
  url(/devjom3update/administrator/components/com_civicrm/civicrm/css/civicrm.css);
  @import
  url(/devjom3update/administrator/components/com_civicrm/civicrm/bower_components/jquery-ui/themes/smoothness/jquery-ui.min.css);
     Sorry but we
  are not able to provide this at the moment. You do not have permission to
  access this page. Return
  to home page.
  function toggle( element ) { var className = element.className; if (
  className == 'crm-accordion-wrapper collapsed
  crm-fatal-error-details-block') { element.className =
  'crm-accordion-wrapper crm-fatal-error-details-block'; } else {
  element.className = 'crm-accordion-wrapper collapsed
  crm-fatal-error-details-block'; } }

We are using Joomla 3.4.5.


texts: Where can I find CiviCRM 5.26 for WordPress?

texts:
I'm stuck in a conundrum, trying to update CiviCRM 5.22.1 to 5.28.3, but the database upgrade fails, possibly related to wordpress 5.5 already being installed, but also possibly due to requiring the PHP Internationalization extension (PHP-Intl), which is required after 5.27.
I want to try updating to 5.26 (or any 5.26.x) to see if I can at least get our donations pages to work again while sorting out the PHP-Intl extension, but I can't seem to find where I can dl it.


texts: CiviReport - Localize "Constituent Detail" group header

texts:
I'm localizing (Italian) the reports.
As in the object, the "Constituent Detail" group header (the ones with the blue background: RELATIONSHIP, CONTRIBUTION, PARTICIPANT, ..) are not sensible to translation.
I mean, that the translation in the .po file is present but the titles continue to came out in English.
I had also a look in the database and in the code, but with no result.

Can someone help me?

Thanks


texts: What can I do so that mailings sent through Civi are not marked as spam?

texts: I need to send a mailing but I've had problems before because a large share of the intented recipients never read it because the mailing was detected as spam. How can I solve this?


texts: Different Schema / Database in Multisite

texts:
We're planning to use CiviCRM for a large number of voters (~10M voters).
This questions is related to the one here.
We were wondering if it's possible to split these 10M voters into different schemas. We want to keep one large database server instead of multiple smaller ones. We could divide the contacts based on geographies and store each of them in a separate site. Each site has its own schema. That way when we're filtering contacts on one site, it doesn't have to scan the entire contact database.
My question is - can we specify the scehma using a prefix? Or use some other configuration to point to a particular schema for an installation?


texts: How should I configure multiple Drupal sites to share a CiviCRM database?

texts:
I have an existing CiviCRM instance on Drupal site (D1). I have a second Drupal site (D2), which does not have CiviCRM. I want to make the CiviCRM instance (data/contacts/settings) from D1 available inside of D2.

I want to have CiviCRM Views integration and CiviCRM Entity module working from both D1 and D2.

Reading the CiviCRM multisite documentation, it is still not clear to me what my ideal setup would be.

I am hoping that someone will share how they think it should be set up!


texts: Mailchimp CiviCRM Integration: "Sync Contacts" buttons don't show up on "Mailchimp Pull/Push Sync" screens

texts:
When trying to sync CiviCRM contacts to Mailchimp or updating CiviCRM from Mailchimp, the buttons "Sync contacts" don't show up on both screens:  "Mailchimp Pull Sync" and "Mailchimp Push Sync".
I've got installed CiviCRM 5.21.1 and I've tested it with Mailchimp CiviCRM extension versions 2.0 and 2.0.1.
Any help will be very much appreciated.


texts: Unable to use Price Set Details for Event Participants custom search if price set field option is disabled after a registrant has already selected it

texts:
Issue: After disabling an event price set field option that one or more participants had already selected in their registration, you are now unable to run the custom search "Price Set Details for Event Participants".

This has been an issue since 4.6 (at least), and reproduced today on the demo site (civicrm.demo.civihosting.com running 5.10.0), as well as the sandbox site (dmaster.demo.civicrm.org running 5.15.alpha1).

When might this happen? You've begun registration for an event, but due to lack of registrations or unforeseen circumstances, you need to cancel one the available options. You issue refunds to anyone who has already paid (not required to reproduce error), and disable the option so that no one else selects it.

How to reproduce:

Create an event price set, with a radio field with a couple of options (example: workshop 1, workshop 2)
Create an event and choose your price set
Register an event participant and select one of the price field options
Go to Search > Custom Searches > Price Set Details for Event Participants and get results for your event, all should be good
Edit the price field and disable the price field option your registrant selected
Repeat the Price Set search, you will now get an error

  DB Error: no such field

Further detail in ConfigAndLog file:

(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
UPDATE civicrm_temp_custom_06a7d4ad3c362837ef807a1493c88112
SET price_field_271 = 1.00,price_field_284 = 0.00,price_field_289 = 0.00,price_field_306 = 1.00,price_field_307 = 1.00
WHERE participant_id = 1562;
 [nativecode=1054 ** Unknown column 'price_field_289' in 'field list']
    [type] => DB_Error
    [user_info] =>
UPDATE civicrm_temp_custom_06a7d4ad3c362837ef807a1493c88112
SET price_field_271 = 1.00,price_field_284 = 0.00,price_field_289 = 0.00,price_field_306 = 1.00,price_field_307 = 1.00
WHERE participant_id = 1562;
 [nativecode=1054 ** Unknown column 'price_field_289' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
UPDATE civicrm_temp_custom_06a7d4ad3c362837ef807a1493c88112
SET price_field_271 = 1.00,price_field_284 = 0.00,price_field_289 = 0.00,price_field_306 = 1.00,price_field_307 = 1.00
WHERE participant_id = 1562;
 [nativecode=1054 ** Unknown column 'price_field_289' in 'field list']"]
)

You'll find with investigation that the participant in question is the one registered, and the "Unknown column 'price_field_[id]'" will be the price option that you disabled.

The likely file to be updated is CRM/Contact/Form/Search/Custom/PriceSet.php

Workaround: temporarily reenable the option, run the report, disable the option again.


texts: HOWTO reliably set default Country on Import?

texts:
We are trying to understand why importing contacts from CSV files with Address, City, State, Zip but no Country results in addresses with countries like Uruguay (for some CA residents), Yemen (for some South Dakota residents), and today, for the first time, for a bunch of CA residents, they were assigned "Guinea-Bissau". Although we have different staff doing different imports, the majority (e.g. ~3000 out of ~3060) of our imports DO end up with Country="United States"

In "Adminster > Localization > Languages, Currency, Locations" we have Default Country set to "United States". That was set when we first configured Civi long ago.

Is there some other setting that deals with setting the default country on import? Should we solve this by always adding a Home-Country column to CSV imports? That seems cumbersome, but will do if that's the only solution.

BTW, we're running WP 4.8.2 and CiviCRM 4.7.22.


texts: Feature Request: Partial Event Registrations (like abandoned carts)

texts:
Is it within the realm of possibility to have CiviCRM create a record of an authenticated users registration after they hit submit (before completing payment)? It would be awesome to use this to see what someone selected and judge why they did not complete payment. Sometimes, a user will have a payment error and quit through frustration (card decline, address mismatch, etc.) or spontaneously have to stop their registration (need to go, kid crying, etc.). It would be awesome if they could pick up their previous session and complete it.

Additionally, sometimes we encounter strange errors on CiviEvent registrations that I am having a hard time finding in the debug logs. It would be great if the partial registration could also have any errors attached to it somehow.

If this was enabled, extensions could also offer exit-detection and offer discounts to continue with a registration, or follow-up emails to complete it.

Thank you for your ideas and thoughts.


texts: WP - Errors after update from 4.6 LTS to 4.7

texts:
Upgrading seems to work fine, I checked folders and resources configuration because the paths weren't there anymore.
Then when I try to access the extensions menu I get the following error :

Cannot read unrecognized property CRM_Core_Config::$defaultSymbol.

And the extensions list isn't being displayed. I tried turning debugging on but nothing shows


texts: UI glitches and "Invalid Classname" error when editing summary fields via AJAX

texts:
When trying to edit fields on contact summary using AJAX hover method, the fields don't open up properly for editing (scroll bars are sometimes missing, and not enough space is revealed). On clicking save, I get a fatal error: "Invalid classname".

I'm on Drupal but not using JS or CSS aggregation.

[Edited:]

I had thought this was due to upgrading to 4.7.15. But my dev site (same version) does not have this problem.

[Edited to add more info]:

In the browser console, when loading the contact record I get this error:

Refused to execute script from 'https://my.site.com/index.php?q=civicrm/ajax/responsiveadminmenu/7242/en_US/1/2ChmFGPv&amp;1' because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.

Then when clicking on a field such as email or phone I get:

jquery.js:339 Uncaught SyntaxError: Unexpected token <

These errors do not come up on the dev site so I suspect they are related.


texts: l10n Translations does not show in settings

texts:
I'm using Civicrm v4.7.19 on Drupal,

for using another language (like ES/DE) I've been creating directory:
/public_html/sites/all/modules/civicrm/l10n

And the "mo" files placed in these addresses [both for testing]:
/public_html/sites/all/modules/civicrm/l10n/es_ES/civicrm.mo
/public_html/sites/all/modules/civicrm/l10n/de_DE/LC_MESSAGES/civicrm.mo

But the Localization settings page don't show the languages.


texts: CiviMail recipient listing behavior on Wordpress multisite

texts:
I am running CiviCRM 4.7.27 on WP 4.9.1. This is a multisite and I am seeing some odd behavior when composing an email with CiviMail regarding the "Groups" available recipients listing. For non-admin users of one any one of the sites, they are not getting the group they are permissioned to see when composing a CiviMail. I am not seeing any patterns on why they are seeing only the same 3 groups (we have over 50). Those 3 groups are tied to different organizations.

Is there a certain way this is supposed to be permissioned? How does civimail determine the group recipients for a multisite domain?


texts: easy way to link an (offline) payment to a participant

texts:
we are not using any CC payment but rely stricktly on bank transfer or cash payment. Especially with these bank transfer payments it takes time to link payments to event participants.

It would help if each participant could be given a unique payment reference of some kind to include in the comment of their bank transfer so linking that payment to an event participant would become easier.

Is this possible in Civi? or through an extension?


texts: Why can't I create a new report from a template?

texts: I am trying to create a dynamic event report from an existing standard template.  I go to Administer, click Civireports, then Create new report from template, choose Participant Report, then change all the columns and filters and get the results I need.  I rename the report from the Title tab.  I preview the report, and everything looks how I want it.  But then I have no option to save it anywhere.  Very frustrating.  Help please!


texts: Simple way to prevent one user seeing one contact

texts: My user would like a particular case worker to be prevented from accessing one specific client.  At present we're not using ACLs but I implemented one scheme that I could get to work on my test system but not on their system - I have almost given up trying to figure out why. I created a smart group with all clients except the excluded one, and a group with the case worker who could see only this group. Can anyone suggest another way this can be achieved?


texts:
Style tags cannot be saved in message templates and have in fact been stripped from current templates. We use a number of templates based on the Single Column Responsive Sample Template. In the last month, all the templates that used to contain a style tag that made the templates responsive have been stripped from the templates, including the sample template. Any attempts to re-add the style tag (or any style tag at all) seem to save fine, but on viewing do not have the style tag. Other changes are saved properly. I think this is since upgrading to 4.6.22, but am not sure of this.

Style tags can still be saved in CiviMail directly, just not in the templates.

CiviCRM 4.6.22 & Drupal 7.50


texts:
I am a CiviCRM user.  I am the informal technical support behind a CiviCRM member and the reason that they are a member (Florida Native Plant Society).

I seem to have a continual battle with limitations in the API.  I would like to know how I can interact with the people involved in development of the API.

I cannot claim to be a CiviCRM coding expert, but I am php fluent and MySQL fluent.  I think my experience with APIs (DonorPerfect and home brew, and getting around the CiviCRM api weirdnesses) might be useful to improving the CiviCRM api.

Shirley Denton
Communications Chair,
Florida Native Plant Society


texts:
Same issue in civi 4.7.3 and 4.7.8, on joomla 3.5.1.
Payment Options shows up in Registration (Test Drive) and Registration (Live)  but does not show up in front end, in the live site.
I have another site using civi 4.6 and I have no problems there.
Should show Paypal and Pay Later.


texts:
I'm building API extension that takes complex objects as parameters.

The API exporer does a brilliant job at parsing the objects, but drush less so.

Commands I am trying are:

`drush @contact cvapi Contact.getclif sequential=1 return="id" clif={"type":"raw","params":{"5":1,"6":1}} length=5`

`drush @contact cvapi Contact.getclif sequential=1 return="id" clif='{"type":"raw","params":{"5":1,"6":1}}' length=5`

Both fail to json_decode the object and my API method receives a JSON string.

I could decode the string in my API - but that feels a little hacky...

Am I doing something wrong?


texts: Upgrading WP to 5.0.1 deletes civicrm uploads folder

texts:
When upgrading a WP multisite to 5.0.1, it completely removed contents within the civicrm uploads directory. I then restored the folder from the backup and all worked.

But this is weird, does anyone know why this happens? Has it happened to anyone else? Not feeling secure to upgrade on production yet when I see things like this.

It makes you run a db upgrade for all sites on the network but that shouldn't have anything to do with the uploads folder.


texts: How to add a Matcher Plugin in CiviBanking as I get "No Matcher Plugin Found"?

texts:
I was able to Import Bank Statement To Civicrm with the help of this
CiviBanking : No valid booking date detected. Not imported!

Now my second task is to add Matcher Plugin.
In Wiki Docs,
I see a list of matchers

  Default Options - creates two default suggestions: manual
  reconciliation and ignore

  Batch Matcher - matches to payment batches

  Contribution Matcher - matches to existing contributions  Create

  Contribution Matcher - creates suggestions to create now contribtuions

  Ignore Matcher - can be configured to automatically ignore certain
  transactions

  Membership Matcher Plugin - records transactions as
  membership dues

  Recurring Contribution Matcher Plugin - reccords transactions as > installments of recurring contribtuions

  SEPA Matcher - intgrates with the CiviSEPA extension

I see a configuration in json format here :
https://github.com/Project60/org.project60.banking/blob/master/configuration_database/matcher/default/EnglishDefaults.json

{
    "generate": 1,
    "auto_exec": false,
    "manual_enabled": true,
    "manual_probability": "50%",
    "manual_show_always": true,
    "manual_title": "Manually processed",
    "manual_message": "Select this after you have manually processed this transaction.",
    "manual_contribution": "Please enter the resulting contribution ID here (if applicable):",
    "manual_default_source": "Offline",
    "manual_default_financial_type_id": 1,
    "ignore_enabled": true,
    "ignore_show_always": true,
    "ignore_probability": "0.1",
    "ignore_title": "Not CiviCRM related",
    "ignore_message": "Choose this option if you are positive that this transaction has nothing to do with CiviCRM.",
    "value_propagation": {
        "ba.name_id": "contribution.custom_14",
        "btx.financial_type_id": "contribution.financial_type_id",
        "btx.campaign_id": "contribution.campaign_id"
    },
    "lookup_contact_by_name" : {
        "soft_cap_probability": 0.8,
        "soft_cap_min": 10,
        "hard_cap_probability": 0.4
    }
}

Where do we need to add this configuration in database so that I can see the matcher plugin?


texts: civiEvent (or other public civi pages) and metatags

texts: is there a way to customize the metatags for civi pages? I'm using the metatag module on my Drupal installation and I would like to have the same functionality on my public civi pages, particularly with my event pages.


texts:
I get the following errors while importing a contact CSV file. I hope somebody can help with the issue. Civicrm 5 latest with WP 5 latest and the error is same with both PHP 5 and 7.2.

"Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: constraint violation
Error Details
Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`wp_23ye3`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL), 1452
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -3
    [message] => DB Error: constraint violation
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , street_address , supplemental_address_1 , city , state_province_id , postal_code , country_id , manual_geo_code , master_id ) VALUES ( 10 ,  1 ,  1 ,  0 , 'Lakhimi Nagar Hatigaon' , 'Dispur' , 'Guwahati' ,  1204 , '781006' ,  1101 ,  0 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wp_23ye3`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , street_address , supplemental_address_1 , city , state_province_id , postal_code , country_id , manual_geo_code , master_id ) VALUES ( 10 ,  1 ,  1 ,  0 , 'Lakhimi Nagar Hatigaon' , 'Dispur' , 'Guwahati' ,  1204 , '781006' ,  1101 ,  0 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wp_23ye3`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]
    [to_string] => [db_error: message="DB Error: constraint violation" code=-3 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_address (contact_id , location_type_id , is_primary , is_billing , street_address , supplemental_address_1 , city , state_province_id , postal_code , country_id , manual_geo_code , master_id ) VALUES ( 10 ,  1 ,  1 ,  0 , 'Lakhimi Nagar Hatigaon' , 'Dispur' , 'Guwahati' ,  1204 , '781006' ,  1101 ,  0 ,  0 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wp_23ye3`.`civicrm_address`, CONSTRAINT `FK_civicrm_address_master_id` FOREIGN KEY (`master_id`) REFERENCES `civicrm_address` (`id`) ON DELETE SET NULL)]"]
)"


texts: Dedupe rule for organization always firing on membership signup form

texts:
Our unsupervised rule for organizations is Organization name with a weight of 10 and the Postal Code length of 3 with a weight of 10 and a weight threshold of 20. We wanted to test behavior on a Membership signup form with the 'On behalf of my organization' option. For the organization data section, we entered different organizations with the same organization name but different postal codes first 3 characters and different emails. Everytime the organization data was updated. We thought it was supposed to recognize they were separate organizations create new records but it didn't.

We looked around and listened many times to the Civiteacher tutorials on dupes but it looks we are missing something.

In our project we have teachers buying reading clubs memberships for their classes on behalf of a school. It does occur that accross Canada we have different schools with the same name, but their postal code will differ. In that case we want to have different organization records created when people use the membership sign up form.

Are there references around that could explain what we are not understanding well or doing wrong?

Using CiviCRM 4.7.1 with Drupal 7.


texts:
I found out, that the date of joining and exiting a group is stored in log_civicrm_group_contact table, in the log_date column. Is it possible to get this value with API4?
Thank you!


texts: Make mailing labels from a list of contributions?

texts:
If I do a search on contacts, the actions menu has an option to generate mailing labels:

However, if I search on recent contributions, the actions does not allow mailing labels (although it does allow generation of Thank-you Letters for Contributions):

Is there a way to add the Mailing Labels action to the contribution actions list?


texts: CiviContribute adding $200 even to every transaction

texts:
CiviCRM 5.24.4/WP 5.4

Some freakish behavior going on with CiviContribute and Stripe processing. Based on Stripe logs, it looks like its originating with CiviContribute. Everything worked for at least one test transaction before I upgraded to 5.24.4, but, despite several restores and reconfigurations, I haven't been able to charge the right amount.

Here's the deal: if a user opts to make a $25 contribution, CiviContribute sends the charge to Stripe as $225. If they opt for $100, the charge is $300. Exactly $200 every time. Pretty weird.


texts: CiviEvent URLs - differ between Dashboard & Manage Events

texts:
I'm not sure when this broke, as I was just alerted to it.  Running Drupal 7 and CiviCRM 4.7.6.

Events receive differently structured URLs in Manage Events and Events Dashboard.

Manage Events shows a URL like http://www.mydomain.com/civicrm/event/info?id=66&reset=1

Event Dashboard shows a URL like http://www.mydomain.com/civicrm/event/info?reset=1&id=66

Both URLs work and take you to the event page.  However, if you embed the Dashboard URL into a mailing with link tracking enabled, the link will not redirect properly.  You receive the error below:

Sorry but we are not able to provide this at the moment.
Could not find valid value for id

Return to home page.

So, depending on how you navigated to the event page to obtain the URL, the link may or may not work when embedded into the mailings.

I'm not sure if there is a reason behind the differing formats for the two pages and it needs to be that way or if the resolution is in the redirection.


texts:
We have on a Ubuntu 18.04LTS server, Drupal 7.63 (latest) with CiviCRM 5.7, PHP 7.1.20, MySQL 5.7.23.

We have a profile form called User Profile that is only used for View/Edit Drupal User Account.  All users are synced with CiviCRM so that we can allow our website users to keep their details and preferences up to date and this works perfectly using this profile.

In order to have additional custom fields for a particular type of individual, we have a single additional contact sub-type, based on Individual.  The vast majority of our contact records are not of this sub-type.

We've just noticed an issue whereby when an individual updates their profile after they log in on our website, their contact sub-type is also changed on their CiviCRM record along with any other changes that are fine (e.g. their address).  The changing of the sub-type is not accessible from this profile form; the only way to change it is to log in as an admin and edit a contact's record.

I can reproduce this with just a save and with no details actually changed at all.

I am going to try and get a more detailed understanding of this by setting up a test site and going through the debugger, but I wondered if anyone else has seen this behaviour? As you can imagine, it's quite serious.


texts: Disable Automatic Receipts on Existing Recurring Donations

texts:
I'm on CiviCRM 5.8.1 on WordPress using the latest version of the Stripe extension, and I'm wondering if there's a way to disabled the automated receipts for existing recurring donations.

We'd like to change to a model where we're doing thank yous manually as needed when recurring donations come in, and while we can tell it not to send a receipt when we first enter a donation, I don't see anywhere that I can tell it to stop sending automated receipts if it's already doing it.

I do not have the "send receipt" box checked in the contribution page configuration for what that's worth.

Thanks for any ideas folks have.


texts:
I'm running CIVICRM (4.6.9) on a drupal 7 (current version) installation. I understand from my client (and I have not been able to duplicate this as it works fine at my end) that several of our participants are unable to complete registration (via Paypal) when they receive their email notification of being moved to "pending from waitlist." I'm trying to find out what participants are doing in case that may be the issue, but since it's consistent among 3 so far, am assuming the problem is real.

We don't use scripts or cron for this (or any other function in CIVICRM) - we change participants' status by editing it from within the participant listings.

Increasing the size of the allowable number of participants from 20 to 100, for example, does not change the "event full" status of an event either even though there are no where near that many registrants, regardless of status. Participants are still told the event is full and added to the waitlist when they register. Is this because there are still waitlist entries outstanding, or is it some sort of problem with CIVICRM?

Thanks!

Chris Hutcheson


texts: How do we preprocess CSV columns when using CiviCRM builtin import functionality?

texts:
We use CiviCRM's import data functionality (and api-csv-import-gui) to import partner's contributions from CSV files. This is working great because the CSV columns can be mapped to CiviCRM fields via a graphical user interface.

However, we've recently had the need to preprocess one of these fields and transform their data on import. This process can't be done outside CiviCRM for security reasons.

Can I still use CiviCRM's point-and-click mapping functionality while being able to preprocess a specific CSV column in PHP? Unfortunately I can't just map the columns-fields in code because the CSV columns change.


texts: Can CiviDiscount be used on a Contribution Page without Membership

texts: I have seen references to CiviDiscount on contribution pages for memberships.  Can it be used for a fundraising dinner?  Note - I often struggle between creating an event or contribution page for fundraising dinners - both have tradeoffs


texts:
On a Wordpress install I'm having problems with the main cron job. We're using Civihosting, so the cron job has been set up as a shell script that is fired every 15 minutes. The cron job is working on schedule as I've set it to notify me via email every time it runs.

I have a number of scheduled jobs set up within CiviCRM to fire every time the cron job runs. Looking at the log the only one of these that is getting triggered is the fetch_bounces job. So at least I can see that the cron task is doing something. The process_mailing job however is not getting triggered, despite being set up to run 'Always'.

Is this a known issue with version 4.6.2.? I'm about to update to 4.6.5 hoping that might fix this.


texts:
We've starting using checksum in civimail for membership renewals. The checksum link takes the user to a webform in which they can renew.

When they do renew the membership is being recorded as a new membership wiping out the member since date.

For example, one person has been a member since 2010. Now it reads 2016.

Anyone know why this is happening.

Thanks,
Andy
CIVICRM 4.5.8
Drupal 7
We've updated webforms and webforms-civicrm to latest version


texts: Where is the CiviCRM ERD / data-dictionary?

texts:
In a variety of contexts it is useful to have a Entity Relationship Diagram (ERD) / data-dictionary:

Using the API
(Xavier avert your eyes) querying the database with SQL
Developing extensions; and even
Refining the core.

Where is the definitive data-dictionary for CiviCRM? And how do we patch it?


texts: Create a Login page for wordpress users to access civicrm but not wordpress functionality

texts:
We have installed CiviCRM on Wordpress and I'd like to create a login page for all users of the CRM.

I've created all employees as users in Wordpress and contacts in CiviCRM.

How do I create a login page so they are immediately taken to CiviCRM and cannot see or access the Wordpress backend? Right now they all logging to Wordpress (not CIviCRM) and have to click the CiviCRM module in the left Wordpress menu.

In the demos on Drupal users cannot see the backend.

This topic is not covered int he documentation that I can see.


texts: Any happy IE8 users with civicrm image display issues?

texts:
We've discovered an issue while trying to display civicrm contact image via Drupal Views in Internet Explorer 8,  it shows famous red cross instead of image; interesting thing happens when direct image url is being loaded, here is it:

We're aware that currently (CiviCRM 4.6)  ImageCache presets don't play nice with Civicrm image (there are civicrm forum discussions here: https://forum.civicrm.org/index.php?topic=34929.0 and here: https://forum.civicrm.org/index.php?topic=32232.0 ) but no clear resolution so far.
We realize it's quite historical and rare case nowadays, however, have hope someone out here might be able to shed some light on this.


texts: How to restore the colour button in Ckeditor

texts: When I upgraded a site from 4.6 to 4.7 Ckeditor lost several buttons - Font, Size, Foreground Colour and Background Colour.  I figured out how to restore Font and Size but cannot see how to get the 2 colour buttons back.  I went to display preferences and set colorButtonbackStyle(Object) and  colorButtonforeStyle(Object) to true, saved and cleared caches, but no buttons showed up.  Am I wrong to use this GUI and so should I be updating a config file somewhere?


texts: Why won't contact ID display in a profile?

texts:
I want to display Contact ID as a View only field in a profile. I can add the field to the profile. Other View only fields display properly for a logged in user when they visit the relevant contribution page but the Contact ID field is blank. (The profile displays their name, address and phone number. Phone number is the only field they can edit.  They need to make all other changes by editing their Drupal user record.)

I believe I have tried all combinations of Drupal user account registration option? and What to do upon duplicate match under the Advanced Settings for the profile in case a specific combination was required.

The contact ID does show up in the email receipt, which is the most important part I suppose as the receipt is cc'd to someone who needs that contact ID.  However the "empty" Contact Id field on the contribution form will confuse the users.

Does anyone know if/how I can get the Contact ID value to display properly?

(Note: This non-appearance of the contact ID happens on our 4.4.20 installation and also on dmaster.demo.civicrm.org. I have only been able to check the contents of the email receipt on our installation.)


texts:
If you "become a member" by going through the normal route of "joining" through the website front-end -- using a CiviCRM profile and requiring the creation of a Joomla (in my case) account -- it is an easy one step process. However, my organization has a lot of older members who join through the mail or in person.

This means that you have to:
(1) Create a CiviCRM "Contact"
(2) Create a CiviCRM "Membership"
(3) Create a CiviCRM "Contribution" and
(4) Create a Joomla user that is connected to the CiviCRM "Contact".

That is a cumbersome four step process that is being handled in one go if you join through the website front-end. In addition, you cannot create a Profile form that has more than one "category" in it, which means you cannot create a profile form so that somebody already logged in can create a new member, accomplishing all of these tasks in one form, or on one page.

I have thought to myself, "Surely somebody out there has faced this problem and solved it," but after nearly 6 months of searching the web, reading the CiviCRM wiki, searching the old boards and the new Stack Exchange board, I can't even find anybody discussing it.

Does somebody have a solution to this problem?


texts: Chain API call multiple parameters issue

texts:
We haven't been able to get executed "is_active" parameter here:
 "api.Relationship.get": "is_active":1,"relationship_type_id":59}
while "relationship_type_id" works. Here's a full query:

CRM.api3('Contact', 'get', {
  "sequential": 1,
  "return": "display_name,id",
  "id": 150,
  "api.Relationship.get": {"is_active":1,"relationship_type_id":59}
}).done(function(result) {
  // do something
});

For now we use this workaround (straight value check basically):

CRM.api3('Contact', 'get', {
         "sequential": 1,
         "return": "display_name,id",
         "id": event,
         "api.Relationship.get": {"relationship_type_id": 59}
             }).done(function(result) {
                res = result.values[0]["api.Relationship.get"].values;
                   $.each(res, function( inx, val ) {
             if (val.is_active == 1) {
            // magic

API Explorer doesn't complain about syntax, so shouldn't multiple parameters work "out-of-box" here or there is some kind of "hidden ingredient" to be added?


texts: Is there a way to expose a CiviReport on a Wordpress page?

texts: Reports are not one of the component options available when using a shortcode in wordpress. What is the recommended way to expose a civireport on a wordpress page?


texts: Configure what gets added to recent items stack / Where to implement

texts:
For my organization it would be nice to define, what types of entities the "recent items" stack holds.

For example the list in the corresponding "recently viewed" widget gets flooded with the same activity entry when composing pdf letters for a group of contacts.

So it would be beneficial if there would be a configuration option to decide which entities/actions to include in the recent items stack.

This is related to recently viewed items stack: Add a configuration option for MAX_ITEMS in Recent.php and should be treated together.

I'll investigate how to accomplish this, but I appreciate any hint about the more advanced civi programmers would integrate this. Should I add a new configuration form? Should I extend CRM_Admin_Form_Setting_Miscellaneous?

Thanks in advance // nielo


texts: Can CiviCRM work by itself (e.g. without Drupal)?

texts:
I have CiviCRM connected with Drupal to sync users and other information. I am planning to make a new website to replace Drupal, perhaps without having it connected to CiviCRM.

Can CiviCRM work by itself? Can I "disconnect" it from Drupal and have it run alone?


texts: How to show/hide Profile based on Price set Total on a Contribution page?

texts:
I would like to hide/show my "Custom Profile Group" based on the value of "Price Set Total". I already have an extension with this Jquery, but seems to be not working. Any help would be appreciated. Thanks in advance.

  CRM_Core_Resources::singleton()->addScript("
     CRM.$(function($) {
        hideshowMainProfile();
    $('#priceset [price]').bind('keyup',hideshowMainProfile);

    function hideshowMainProfile() {
        let priceValue = $('#priceset [price]').val();
    if (priceValue.length > 1) {
      $('.crm-public-form-item.crm-group.custom_pre_profile-group').show();
    }
    else {
      $('.crm-public-form-item.crm-group.custom_pre_profile-group').hide();
    }
  }
    });
");


texts: CiviMobileAPI Extension vs APIv3 for mobile app integration

texts:
We are building a react-native mobile app for our members and want to include some CiviCRM data and functionality in the app. Starting with some rudimentary data display eg:

How long you've been a member
Renewal date
Lifetime giving totals etc

Later we'll look to add some more of Civi's functionality within the app.
Does someone have any experience in doing something similar? Is it better to work from the open source CiviMobile API extension (not using the CiviMobile App) or from CiviCRM's native APIv3?
Thanks,


texts: Dealing with CiviCRM contact records of Drupal blocked accounts

texts:
Is there a way to automate removing the contact records of Drupal accounts that are blocked such as because of spam? I am using the spambot module to block accounts and remove their spam.

I fear that there are thousands of bogus records in our CiviCRM with no way to confirm their legitimacy.

Drupal 7 and CiviCRM 4.7.27


texts: What is the timeframe for supporting Joomla 4.0? Is a compatible Civi version in the works for it, although Joomla 4.0 is still in alpha?


texts: Can inherited members receive scheduled reminders?

texts:
In the scenario that organizations that have memberships, and then people are associated with the organization by relationship (and inherit that membership), it would be good to be able to send a scheduled renewal notice to the people that currently have the relationship with the organization. (Let's call that relationship "Representative is / Representative of"). The organization itself may not have a valid email address, and even if they do, it is probably not the right one that renewal notices should go to. The people who are currently "Representative of" the organization may change over the years while the organizational membership remains constant.
I have been trying to set up such a flow (as follows):

Organization has membership
Individuals have a relationship with the organization that inherits the membership
A smart group filters these people (e.g. an active relationship, let's say) and this group is used in the scheduled reminders to limit reminders only to the appropriate people.
Cron jobs are being fired (and the "Send Scheduled Reminders" cron job in particular is being fired).

However, no reminders appear to be going out.
In researching, I found this PR and am trying to decipher if this relates.

After
A scheduled reminder is only excluded if

The membership triggering the reminder is inherited, and
The contact lacks relationship-based permission to edit the membership owner contact

Does this mean our entire scenario is unsupported? (ie. inherited memberships cannot receive Scheduled Reminders)?
There is also some description related to whether or not the relationship is permissioned for editing. In our scenario we would not choose to set this permissioning, but if that would solve this issue we might change our mind. I did a quick test and was not successful yet in getting a reminder to go out even with permissioning.


texts: Is it possible to export a newsletter to PDF

texts:
I have a newsletter that I have sent out to our contacts. I would like to export or save it as a PDF to post on our blog. I tried to copy the the HTML code into the blog, but the tables were not blog friendly. I am looking for 2 options
1) a way to remove the table formatting of the html code to then copy into a blog post
2) a way to export the newsletter that will preserve hyperlinks so that the PDF can be embedded in the web page.

Thank you


texts: Possible cause? CiviMail sent "400%" of queued messages, hit each recipient 4 time

texts:
On a well established site that uses CiviMail and Groups for a range of mailing lists, a message was sent out this morning as usual to a list of over 1400 people.

Inexplicably, each recipient received the mail 4 times. I have checked and the message was definitely only queued once, and was sent out by a single cron job. The report for the message makes clear that something very odd happened:

Intended Recipients 1411
Successful Deliveries   5644 (400.00%)
Tracked Opens   268
Click-throughs  50
[...]
Scheduled Date  May 20th, 2015 9:48 AM
Status  Complete
Start Date  May 20th, 2015 10:00 AM
End Date    May 20th, 2015 10:11 AM

Normally a cron such as this takes about 2 minutes to run. This one took substantially longer.

The CiviCRM installation was upgraded to the latest version on May 4th, however multiple messages have been sent successfully in the interim.

I cannot see any evidence of user error which would have caused this to occur.

Greatly appreciate any thoughts on how this came about, as the site owners are naturally reluctant to use the system again until the cause has been established.


texts: How to setup a contact journey and add them in specific mailing group after a delay?

texts:
I would like to setup a web signup form with 2 of our newsletter groups. After contacts sign up, I would like to send them 2 welcome emails after 10 days of delays. Then add them to the 1 of 2, or both newsletter whatever they have selected at the time of signup.

Setting up a form with groups, sending them welcome emails are an easy part using civirules.

I am struggling with how I can determine what group they were signed into at the beginning, so after 10 days of delay, they can go into that specific groups? I do not want to send them Newsletters before they receive the 2nd email. Any help would be appreciated. Thanks


texts:
Does anyone know what image extensions CIVI recognises.

I want to upload .TIF images to civi contacts.  Is there a way to do this as the extension is not recognised.

Thanks,
Andy


texts: Mapping custom fields to CiviCRM's standard fields

texts:
I have hired a freelancer to create CiviCRM Sign-Up form featuring Tell-A-Friend and validation email.

Using CiviCRM contact Caldera Processor, he created the form shown below but has an integration problem -  is not able to map created custom fields "Province" and "Municipality" into CiviCRM's standard fields "State/Province" and "City".

He is not able to use the standard fields as they do not allow him to have 2 pull-down menus (Province and Municipality – see picture below) and other features (Tell-A-Friend and verification email). Your comments and suggestions would be greatly appreciated.

[Note: Selecting a Province immediately populates the Municipality field.]

Environment: WordPress 5.2.2 and CiviCRM 5.15.1 hosted at AWS.


texts: Virtual event conference and networking platform recommendation

texts: Looking for virtual event conference and networking platform (such as Remo) that easily integrates with Drupal/CIVICRM for authentication and online profile access.


texts: Pay Later option not displaying on front end when Paypal option

texts:
Joomla 3.5.1 - Civicrm 4.7.8

I have created a Contribution page (plus a profile with some custom data in it) and wanted to give option to pay later. However, the Pay Later option is not showing on front end whilst the Paypal option is displayed. However, if I remove the option to use Paypal, then the pay later option appears (though with a permanent x in box which cannot be unselected).

I have attempted to replicate on demo site (which is older version - 4.6) and when I choose pay later option it does not display on front end either. However, I cannot remove option to pay by paypal (sandbox) as that breaks the page. So cannot see if pay later would show without paypal.

So, 2 problems 1) pay later not showing with paypal option available -

2) Permanent x in box of pay later when it can be seen on the front end after removing paypal option.

I think this may be a bug but not certain. Wanted advise first.


texts: Multi-select not working with crmUiSelect AngularJS select2 directive

texts:
I created a select2 element with CiviCRM's crmUiSelect AngularJS directive by using the following code in my controller:

$scope.options = [
  {"value": "foo", "label": "Foo"},
  {"value": "bar", "label": "Bar"},
  {"value": "baz", "label": "Baz"},
  {"value": "bat", "label": "Bat"}
];

and the following code in my template:

<select
  crm-ui-select="{allowClear: true}"
  ng-model="myVar"
  ng-options="option as option.label for option in options track by option.value"
  multiple="multiple"
  class="big"
>
</select>

{{myVar}}

It sort of worked, but here's what I ended up with:

As you can see in the above screenshot, this element has the following problems:

myVar is an array with only one element, even when multiple options are selected.
The list of options contains options which have already been selected (and the element actually allows these options to be selected more than once).

How can I fix this element so that it works as expected? I want myVar to become ["foo", "bar"] in the screenshot above, and I want the user to only see options which have not already been selected.


texts:
I currently generate an Event Report of upcoming events that shows how many participants are registered for each event, but I'd also like for it to show the max participants allowed. When looking through the fields available in the Columns tab, I don't see Max Participants or anything like it.

Any guidance would be appreciated!


texts: How can I get $params into my own scheduled job?

texts:
Looking for some help on getting $params to be passed on from the scheduled job -> GUI page -> into my scheduled job; so:

function civicrm_api3_job_ecocalculate($params) {

I'd like to be able to pass in e.g.

But when I try this I just get $params = null in my function;

What am I missing?


texts: Given the need in the EU to provide information about the cookies that a given site uses, is there any information available at CiviCRM (and maybe its extensions ecosystem) about the cookies that CiviCRM uses?


texts: Itemized Annual Statement of Contributions

texts: I can create a letter template containing the appropriate tokens from the Summary Fields but the only available token would be a Sum reflecting the entire year's donations. Is it possible to produce an end of the year statement that would reflect an itemized list of each individual contribution (including the final sum).


texts:
Couple issue I wanted to gets some input on.  First, has anyone ever seen this error message: LESS error: .black is undefined: failed at .black !important; sites/all/themes/shriver/style.less on line 1091, sites/all/themes/shriver/style.less

I'm thinking a file is missing.

Second question: The monthly contribution check box is all the way in the top left corner of the page instead of next to the text.

Any fixes??????


texts: Confirm From Email Error in Configure Event

texts:
I get this error while in the Configure Event -> Online Registration tab and trying to enable the Send Confirmation Email feature:

Warning: idn_to_ascii() expects parameter 3 to be integer, string given in /home2/nymissionary/public_html/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Rule/Email.php on line 58

A screenshot is shown below. I need your help so I can use this feature.

~ Ron


texts:
I'm new to civicrm so I'm not totally sure if I'm using all the right language here.

Something seems to be messed up with the way civiCRM is resolving system paths. Causing jQuery to fail in resolving its own path and/or paths to some of the assets.

This problem is manifesting itself as a javascript error which causes various front-end features to break.

I have attempted running the tools at: Admin > System Settings > Cleanup Caches and Update Paths. No effect.
I've looked at /wp-content/uploads/civcrm/civcrm.settings.php the paths look correct.
/wp-content/uploads/civicrm/templates_c/ is getting new files written, so I don't believe there is a permissions issue.

Any ideas?


texts:
Is there any extension or any other way to use regular contacts as event locations? This has been asked on several occasions in the forum, and the response has been "well, at least you can re-use event locations."

We have a membership organization of local businesses, and a monthly meeting that rotates among the board members' offices. So, being able to look up a member's office and select it as the venue would be far easier than re-entering the data. Moreover, the event location fields are limited— email address but no website?— whereas the contact records have custom fields for things like parking, security, and public transit information associated with the location.

By tying an eveny to a venue rather than a location, I wonder if it might be easier to record hosting an event as an activity for the organization as well.

Since event locations are stored in the civicrm.address table already (though they are inaccessible from any other part of the system), I wonder how difficult it would be to refactor events to use contact addresses. But leaving that aside, is there at least a workaround? I suppose we could use a contact reference custom field, but that would require a good deal of customization to display more than the contact name, I would think.


texts: Error: Please select at least one membership option

texts: After adding a new price set, the payment page looks okay until I click Confirm Contribution. Then this error appears.


texts:
I'm using the spark version of civicrm and can set up CiviCRM contacts to be administrators, but am having trouble with user authentication (allowing users to log in).

The spark version runs under Drupal and I've read through the Drupal directions, and maybe it's me, but the drupal interface doesn't seem to be particularly transparent.

Does anyone know how to allow authentication, or even if this is possible?


texts: Event Error - civi_flexmailer_required_tokens

texts:
Everytime I try to make an event, or access any page with event information, I get the following error:

You have requested a non-existent service "civi_flexmailer_required_tokens".

Using latest Civi 5, Wordpress 4.9


texts: TCPDF package is missing in the standard distribution

texts:
Since version 4.7.3 the files for the TCPDF package are missing. Please could someone in the know arrange to update the standard distribution! Thanks

See: Version 4.7.3: TCPDF package seems to be missing


texts: CiviRules triggers, but fails to send email

texts:
I'm using CiviCRM 5.18.4 on WordPress 5.4.1.  I have been successfully using CiviRules to send a welcome email when a contact adds a (pending) membership.

Now, I have created a rule that is supposed to send a different ("Membership Confirmation") email when we confirm the person's eligibility and donation:

Linked Trigger:  Membership is changed

Linked Condition(s):  Membership Status is one of   "New"

Linked Action(s):
Send e-mail from [our email address] using primary e-mailaddress with Template "Membership Confirmation" to the contact and bcc to [internal staff] Delay by 5 minutes

Have tried it with or without delay, and with various (simplified) email templates.  Result is consistent:  When we approve the donation, it successfully changes the membership status to NEW, and the Event IS TRIGGERED for that contact.  However, the emails do not get sent, and the emails do not appear in the "activities" list for that contact (although the donation and membership activities do).   No error is reported, and nothing at all appears in the CiviRules Log.

[Note:  I just installed the CiviRules Logger extension, I haven't seen any logs appearing even on events that trigger and work properly, so I don't really know if the logger is working.]

Any ideas?  Could something be wrong with the email format?  Is it the way I have written the rule?  Is something going wrong on the back end?

Thanks for any thoughts!

UPDATE:  I did finally get an error in the Civirules log:

2020-05-12 18:00    error   Rule: 'Membership Confirmation Email' with id 6 failed for contact 595 because of Failed to execute delayed action
Array

(
    [rule_title] => Membership Confirmation Email
    [original_error] => Civirules api action exception: id is not a valid integer. API call: Email.send with params: from_name="[org name]", from_email="[our email]", template_id="74", location_type_id="", alternative_receiver_address="", cc="", bcc="[internal staff email]", file_on_case="", contact_id="595", extra_data="Array"

[reason] => Failed to execute delayed action

)

Can anyone interpret that for me?  Which id is not a valid integer?


texts: Having issues updating to civiCRM 5.32.2

texts:
So I've downloaded the file to update to civiCRM 5.32.2 and I'm on WordPress 5.6.  When I upload the file to the plugins page it tells me that I need to overwrite the other version.  Cool no problem.  When I tell it to do that it tries for a few minutes and then it gives me a 503 error.

Service Unavailable The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try
again later.
Additionally, a 503 Service Unavailable error was encountered while
trying to use an ErrorDocument to handle the request.

If I then try to activate the new version of civiCRM the whole site crashes with a fatal error that says the following.

Warning: include_once(/home/enaosj1vvfz0/public_html/wp-content/plugins/civicrm/includes/civicrm.users.php):
failed to open stream: No such file or directory in
/home/enaosj1vvfz0/public_html/wp-content/plugins/civicrm/civicrm.php
on line 623
Warning: include_once(): Failed opening
'/home/enaosj1vvfz0/public_html/wp-content/plugins/civicrm/includes/civicrm.users.php'
for inclusion (include_path='.:/opt/alt/php74/usr/share/pear') in
/home/enaosj1vvfz0/public_html/wp-content/plugins/civicrm/civicrm.php
on line 623
Fatal error: Uncaught Error: Class 'CiviCRM_For_WordPress_Users' not
found in
/home/enaosj1vvfz0/public_html/wp-content/plugins/civicrm/civicrm.php:624
Stack trace: #0
/home/enaosj1vvfz0/public_html/wp-content/plugins/civicrm/civicrm.php(379):
CiviCRM_For_WordPress->include_files() #1
/home/enaosj1vvfz0/public_html/wp-includes/class-wp-hook.php(287):
CiviCRM_For_WordPress->setup_instance('') #2
/home/enaosj1vvfz0/public_html/wp-includes/class-wp-hook.php(311):
WP_Hook->apply_filters(NULL, Array) #3
/home/enaosj1vvfz0/public_html/wp-includes/plugin.php(484):
WP_Hook->do_action(Array) #4
/home/enaosj1vvfz0/public_html/wp-settings.php(420):
do_action('plugins_loaded') #5
/home/enaosj1vvfz0/public_html/wp-config.php(89):
require_once('/home/enaosj1vv...') #6
/home/enaosj1vvfz0/public_html/wp-load.php(37):
require_once('/home/enaosj1vv...') #7
/home/enaosj1vvfz0/public_html/wp-admin/admin.php(34):
require_once('/home/enaosj1vv...') #8
/home/enaosj1vvfz0/public_html/wp-admin/plugins.php(10):
require_once('/home/enaosj1vv...') # in
/home/enaosj1vvfz0/public_html/wp-content/plugins/civicrm/civicrm.php
on line 624 There has been a critical error on this website. Please
check your site admin email inbox for instructions.
Learn more about debugging in WordPress.

I have all of my other plugins deactivated so I know it's not a conflict there.  I've tried using multiple themes so no conflict there.  I've even addressed caching issues as described in another thread (Errors involving /wp-content/plugins/civicrm/civicrm/CRM/Extension/ClassLoader.php)
The only other suggestion my hosting company had was to unzip the file myself and replace the files manually which just seems like a good way to screw up my data.


texts: People tagged with "privacy: no bulk email" seem to be receiving bulk email

texts:
It seems pretty clear that contacts tagged with "NO BULK EMAILS (USER OPT OUT)" are still receiving bulk email. I see many contacts who continue to be listed as receiving bulk emails in the mailing tab and the activities tab. We tag contacts as No Bulk Emails both internally, as well as people using the self-service link at the bottom of emails. We have been using this Civi install for many years and I feel like this feature used to work fine.

Is anyone else experiencing this? Is there a setting I should check? Any helpful advice would be appreciated.

We have a standard install in Debian, Drupal 7.65, CiviCRM 5.10.3.


texts:
When i add an organisation the error message is Sorry an error occurred
Supervised rule for Organization does not exist
I don't seem to be able to add a Rule for Organisations.


texts:
My Specs

I migrated a production Drupal 7/Civicrm 7.x-4.7.9 site to my local machine.
For my stack, I  am running MAMP and PHP 5.6.32, the production server is on PHP 5.6.33

I downloaded all files, and databases (there are two, one for Civicrm and one for Drupal 7).

Took a while, but got it set up and running and changed all urls in the DB. no issues so far.

but now when I got to ...site\civicrm (yes for some reason the local is running on two back slashes in stead of one -- if this is an issue, otherwise it's secondary to the below unless related...)

And here is what I need help with:

I get this error:

Sorry but we are not able to provide this at the moment.
'civicrm/showevents':
Could not find access_callback in path tree,
Could not find page_arguments in path tree,
Could not find is_ssl in path tree

Things I've done so far: Cleared all cache

Any thoughts?

Thanks in Advance!!!


texts: AngularJS issues with Drupal 7 + CiviCRM

texts:
I recently installed CiviCRM 4.6.2 in our multisite Drupal 7 environment, running on IIS 8. I have CiviCRM 4.3.2 running on a Drupal 6 base without any issues on the same server; my plan is to migrate the D6 install and most of the data (contacts, etc) to D7.

Installation and configuration of CiviCRM went fine, as did importing contacts. However, I'm currently stuck on an issue that appears to have something to do with AngularJS and Windows/IIS paths, though I can't say that for sure.

When I go to Mailings -> New Mailing, it hangs - all it says on the page is "Initializing..." In Chrome's console, I see this error:

TypeError: a.headers is not a function
  at n (angular.js:9720)
  at angular.js:13248
  at n.$get.n.$eval (angular.js:14466)
  at n.$get.n.$digest (angular.js:14282)
  at n.$get.n.$apply (angular.js:14571)
  at l (angular.js:9698)
  at M (angular.js:9888)
  at XMLHttpRequest.F.onload (angular.js:9829)

In Drupal's watchdog log, I get this error (identifying path info changed):

LOCATION    https://www.fake.com/civicrm/ajax/angular-modules?l=en_US&r=fE7WM

REFERRER    https://www.fake.com/civicrm/a/

MESSAGE     Warning: file_get_contents(E:\webroot\drupalroot\sites\all\modules\civicrm/ang/crmMailingAB/E:\webroot\drupalroot\sites\all\modules\civicrm/ang/crmMailingAB\EditCtrl/report.html): failed to open stream: Invalid argument in Civi\Angular\Manager->getPartials() (line 203 of E:\webroot\drupalroot\sites\all\modules\civicrm\Civi\Angular\Manager.php).

It definitely looks to me like AngularJS is getting confused by Windows paths, but I'm not 100% sure that that's what's going on, nor how to fix it if I'm right.


texts: Is CiviCRM compatible with the CMS system Umbraco?

texts: Our organisation is interested in creating our new website using Umbraco, but we are unsure if our CiviCRM system would be compatible. Does anyone use CiviCRM with Umbraco or know if they work together?


texts: profile email notifications: can CiviCRM indicate what information has changed?

texts:
Members on our site can update their own profiles, using a custom profile that is set to send notification emails to administrators when an update is submitted.

The notification email contains all the data now in the profile -- but it would be great if the data that was changed was indicated by a different color, or maybe just some indication of which fields have a changed value.

I have no idea how CiviCRM handles versioning (if it even does), so I have no idea if this is even possible without significant custom development.

Anybody have any ideas? Thanks!


texts:
i want to import my own table that contains custom fields and custom fields data.

is  there a wizard that will understand that the first line title  is the custom-fields and that that the data that follow the same row is the data , so i dot have to manually create custom fields?

can i create a csv file with custom fields ( no data just the custom fields) and import it to civi , instead of manualy create each and every one of those ?


texts:
We'd like to send an SMS with the event title, start time and info page to contacts who've been registered to attend an event.

Theoretically, we should be able to do this with scheduled reminders, but haven't been able to get that working. It is setup is as follows:

We've also looked at using CiviRules to send that out, but as that relies on setting up a message template, we weren't able to add in the event tokens that we'd need.

Is anyone able to give any insight on how to make this happen?


texts: How to use Contribution Token {contribution.amount_level}?

texts:
The contribution tokens contain the token {contribution.amount_level}.
I find this tokens via find contributions -> Email send now
I was hoping this token would return information about the Price Set fields. Unfortunately it returns 'array' testing it.

Can someone please explain how to use this token? I find literally nothing…

My target: We do a little merchandise and publication selling, get 'orders' via Mail, add off-line contributions in CiviCRM (pay later - banking). What we want to do ist sending an Email confirming the order (including the ordererd items) and printing out a cover letter (containing payment instructions).
Now a price set used for contributions, containing our merchandising items, shipment costs, prices, quantities and so on looks perfect for that purpose - if one could get those price set informations into one simple mail. So I hoped that token would deliver exactly what is shown.

I know there are some topics dealing with tricky smarty operations (which is far beyond my understanding), but nowhere is explained what the {contribution.amount_level} is supposed to do or how to use it.

We are running CiviCRM 4.7.29


texts: I am using SparkPost for mail delivery of CiviCRM mass mailing.  SparkPost analytics show targeted and bounced emails etc but shows zero for clicks and opens.  How can i enable tracking of clicks and opens?


texts:
As sort of a followup to this question.  I am trying to retrieve all the contacts who have tag:5 AND who have tag:7.  I tried the following code:

CRM.api3('Contact', 'get', {
  "sequential": 1,
  "tag": [5,7]
  "return": ["tag","first_name"]
}).done(function(result) {
  // do something
});

However, this returns all the contacts who have tag:5 OR tag:7.  Is there any way to do this through the API?  The only other solution I can think of is sifting through the objects using some client-side javascript.


texts: How can I delete a custom field (other than GUI)?

texts:
I had a custom field group with a disabled field.

When I tried to delete the field (ID=59), the Warning window froze with CRM logo rotating.

When I tried to enable the field, it gave Error about DB Constraint Violation, but apparently enabled the field.

When I tried to delete the field then, the Warning window froze again with CRM logo rotating.

The screenshot contains combined messages - error from action 2 and warning window from action 3.
How can I fix the issue?
P.S. Editing the field 59 does not work either (also frozen logo after clicking save).

I am running CiviCRM 5 on Drupal 7.


texts: Email-to-activity processing – can't create subfolders of the inbox

texts:
When setting up a Civi site for a client, I turned on email-to-activity processing.  When you do this, Civi tries to set up two folders ('CiviMail/ignored' and 'CiviMail/processed') as subfolders of the inbox folder.  However, the mail server doesn't support this, and puts them in a different place in the folder hierarchy (on the same level as the inbox).

I've patched this for now but it doesn't seem like a good long-term solution.
 Has any one else run into this?  Any ideas on how I might deal with it in a longer-term way?  Seems like something that would be good to make configurable.

(The relevant code in Civi is in CRM/Mailing/MailStore/Imap.php)


texts:
I have a message in my installation as follows: "To prepare for CiviCRM v5.34+, please upgrade MySQL. The recommended version will be MySQL v5.7+ or MariaDB v10.1+."
My site is hosted on Siteground. They said I can't upgrade to MySql 5.7+ at the moment, but will be able to do so soon. I currently have this version of MySql: Server version: 5.6.40-84.0-log - Percona Server (GPL), Release 84.0, Revision 47234b3
What will happen if Civi upgrades to 5.34+ before I can upgrade to MySQL 5.7+.
Thank you.


texts: Can I specify the email location to send to?

texts:
In both CiviMail and when creating an Email activity, I can specify the contact recipient(s), but the recipient email address is always that contact's Primary email address.

Instead, I want to specify "send to Billing email" or "send to Home email". Is that possible out of the box, or is there a suitable workaround?


texts: Error (One of parameters is not of the type Integer) while clicking the 'mailing.viewUrl' in a sent mailing

texts:
In sent Mailings, the 'mailing.viewUrl' is rendered into:
https://terranova.tamera.org/civicrm/mailing/view?reset=1&id=95c21fb7cc1b7aac

and clicking it gives me this error:

  $Fatal Error Details = Array ( [message] => One of parameters (value: e05fa931f15dedbb) is not of the type Integer [code] => )

With the following stack trace:

  $backTrace = #0 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/Error.php(343): CRM_Core_Error::backtrace("backTrace", TRUE) #1 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Utils/Type.php(535): CRM_Core_Error::fatal("One of parameters (value: e05fa931f15dedbb) is not of the type Integer") #2 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(1519): CRM_Utils_Type::validate("e05fa931f15dedbb", "Integer") #3 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(1397): CRM_Core_DAO::composeQuery("\nSELECT CF.id as cfID,\n CF.uri as uri,\n CF.mime_typ...", (Array:2), TRUE) #4 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/BAO/File.php(332): CRM_Core_DAO::executeQuery("\nSELECT CF.id as cfID,\n CF.uri as uri,\n CF.mime_typ...", (Array:2)) #5 /home/tamera/www/www/sites/all/modules/civicrm/api/v3/Mailing.php(571): CRM_Core_BAO_File::getEntityFile("civicrm_mailing", "e05fa931f15dedbb") #6 /home/tamera/www/www/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(101): civicrm_api3_mailing_preview((Array:3)) #7 /home/tamera/www/www/sites/all/modules/civicrm/Civi/API/Kernel.php(168): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9)) #8 /home/tamera/www/www/sites/all/modules/civicrm/Civi/API/Kernel.php(99): Civi\API\Kernel->runRequest((Array:9)) #9 /home/tamera/www/www/sites/all/modules/civicrm/api/api.php(43): Civi\API\Kernel->runSafe("Mailing", "preview", (Array:3)) #10 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Mailing/Page/View.php(145): civicrm_api3("Mailing", "preview", (Array:3)) #11 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(311): CRM_Mailing_Page_View->run((Array:3), NULL) #12 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:15)) #13 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3)) #14 /home/tamera/www/www/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:3)) #15 /home/tamera/www/www/includes/menu.inc(527): civicrm_invoke("mailing", "view") #16 /home/tamera/www/www/index.php(21): menu_execute_active_handler() #17 {main}


texts: Fatal error when accessing Civicrm administrator page

texts:
I am unable to access the Civi administrator section on a website using Joomla 3.7.5, Civi 4.7.23 and running on PhP 7.0.
Joomla portion works fine, but when I access Components/Civicrm from the Joomla backend, I get a blank page with no error messages (although Joomla debugging is turned on).  Using Firefox Developer edition's debugger the response is "Page has no sources".

I then created a new Joomla user with superuser privileges. Logged in and got the following message (screenshot attached).

Since I can't login to change settings to display all errors and turn on backtrace, how do I troubleshoot? Any help would be appreciated.

Thanks,
Kate

Fatal error: Uncaught CRM_Core_Exception: [0: Transaction integrity error: Expected to find active frame thrown in /home/sherida1/public_html/jgs-live/administrator/components/com_civicrm/civicrm/Civi/Core/Transaction/Manager.php on line 107


texts: Tags for contact in drupal view shown on separate rows

texts: I'm creating a drupal view based on civicontact.  The fields are user id, user roles, I link to civicrm_uf_match table to get the contact id, then add a field for the tags associated with that contact.  The problem is that each tag is shown on a separate row.  This does not happen with user roles, the are shown as a single comma delimited text field, which is what I wanted to have happen with the civiCRM tags.  What am I doing wrong?


texts: Why, in Civicase, is 'other relationships' purely additive & why do they show up on every subsequent case?

texts: If I manually add someone to 'Other Relationships' in Civicase by using 'Add members to Case Resources', then that someone then shows up in ALL cases under 'other relationships' - not just for the client where I added the contact.  And, there is no way of removing them to correct the situation - I've looked at the database tables and can't find where this info is stored.  For example I added Joe Bloggs in 'Other Relationships' using 'Add members to Case Resources' - and now 'Joe Bloggs' shows up in ALL cases in 'other relationships' - but if I look at Joe Bloggs contact records it shows no relationships at all. Is this a bug or a WAD?  And how can I remove these contacts?


texts: Migrate CiviCRM from Joomla to Wordpress

texts: I don't even know where to start. I have been tasked with migrating an older version of CiviCRM (3.4.8) on Joomla 1.5 to a newer version of CiviCRM on Wordpress. I got a fresh install of CiviCRM done on Wordpress 4.4, but I'm not sure where to go from here. I'm not familiar with Joomla (this is not my website), so please be very specific. I need everything (users, customizations, whatever else) moved over without having to delete anything on the current site.


texts: How can I find the transaction date of a payment by check?

texts:
The question is double :

Is there a way to simply display this trxn date (not the Contribution date, but the date when the check was recorded) ?
The transaction is refered in civicrm_financial_trxn table : id, check #, trxn_date : how can I link this id to the contribution ?


texts:
A lifetime member notified me that they received an automated message their membership had expired (typically sent to those with annual memberships). (As they are not dead) this user type should not have received a message that their (lifetime) membership expired.

How can I remove "Lifetime" members (as a group) from receiving general (annual) membership expiration notices.
How can I find this message template? I looked in "Home › CiviCRM › Administer CiviCRM > Message Templates > User-driven Messages & User-driven Messages" as well as "Headers, Footers, and Automated Messages" and do not find a mailing with the subject header.

Thanks


texts: Is there a way to make a contact page immediately visually arresting?

texts:
As I mentioned in my previous question, I'd like a way to show that a contact page is special immediately upon opening the page. Some sort of flag or label, something like a graphic or colour change that stops people as soon as they open the page.
I understand tags and groups, but they require navigation off the initial view, as well as additional procedures that might be ignored in a rush.

Is this possible?


texts: What might cause contribution amounts to multiply by 100 instead of recording values with a decimal place

texts:
I'm working on a site where whenever a contribution is entered into civi with a decimal, it's multipled by 100. It's a lot like this old issue, except the site has not to my knowledge ever been localized and has always used USD.

In the localization settings if I change the decimal value to a comma and the thousands separator to a period and enter a contribution of $5,00 the contribution amount is 5. When I swap it back to the U.S. dollar defaults, entering 5.00 is a contribution amount of 500.  I can't replicate on any other site, but I can replicate when loading the civicrm database into a clean codebase and clean wordpress site. I've tested replacing the civicrm_setting table as this seemed like it may have been the culprit but that didn't help. Any clues to where else I could look for something problematic in the database?

Site is on 5.10.3 currently, it's an older install and no one remembers when this problem started.


texts: How do I display a custom field in an invoice?

texts:
I'd like to be able to display a custom field in the generated PDF invoice for a contribution. I've added the custom field to contributions, but it will not show up in the invoice.

Is it possible to display this custom field on the invoice? If so, how?


texts: Using a webform checksum for multiple contacts

texts:
I have set up a webform for users to create memberships. There needs to be 3 contacts within the webform: organisation (where the membership sits), main contact, representative.

I would like to email renewal notices with a checksum so the user can quickly update and renew membership. This somewhat works. The organisation information is displayed in the checksum link. However the main contact and representative is not. I can see why this does not work.

I can think of 2 ways round this:

Create custom fields for an organisation contacting main contact and representative information.
Create a login so users can update their contact information.

At the moment I am thinking the first option would be better suited. Can anyone think of a better solution?


texts: CiviCRM won't install (blank screen on initial configuration, GoDaddy shared hosting)

texts:
I successfully installed CiviCRM using FTP on the backend of my wordpress site hosted by godaddy. when I go to click on configure CiviCRM the next screen comes up blank

What am I doing wrong? I did install Charity theme from ThemeForest. But I went in and deactivated all of the plugins...


texts: View and subscribe to Public Smart Mailing groups using {action.subscribeUrl}?

texts:
I'd like to use {action.subscribeUrl} so email recipients can view and subscribe to public mailing lists. However, it does not show public Smart group mailing lists.

Is there a way to show Smart group public mailing lists using {action.subscribeUrl}?

Using CiviCRM 5.3.1 with WordPress.


texts: get name and email in exchange for free PDF

texts:
We would like to get leads by offering a free PDF in exchange for name and email.  Ideally, would like to eliminate bogus/spammy leads before either emailing them the PDF or allowing them into an online library where they could download it themselves. Any suggestions about the best way to go about this?

WordPress 4.8.1

CiviCRM 4.7.21


texts: My colleague is adding new members who have an individual membership type. We use civiCRM through Joomla. The "individual" setting is not saving.  She is doing it through the "Create New" button.  Should she be creating a new member through the "membership" button?


texts: Civimail New Mailing; "Track Click Throughs" and "Track Opens" off by default.

texts:
When doing a new mailing, you can choose "Track Click Throughs" and
"Track Opens". These are on by default. Is it possible to set them off by default?

Thanks,


texts: Replace Webform Date Select Dropdowns with Textfield

texts:
I am using a webform to edit cases in CiviCRM. I have a date field which I want to display, but keep disabled (the case start date). I want to replace the three select fields (day, month and year) with a single text field.

The three select fields cannot be disabled and I do not want users to be able to change the date, but only to view it. It would also look a lot neater if it was just a single field.

I tried the solution given here, which uses a template suggestion to overide the webform template, but this doesn't work for integrated CiviCRM (date) fields.

The solution referred to above was to create a template called webform-calendar.tpl.php with the following code:

<?php
 $idKey = str_replace('_', '-', $component['form_key']);
?>
<input type="text" id="edit-submitted-<?php print $idKey ?>" class="form-text <?php print implode(' ', $calendar_classes); ?>" alt="<?php print t('Open popup calendar'); ?>" title="<?php print t('Open popup calendar'); ?>" />

And also adding the following css:

.webform-container-inline.webform-datepicker  div.form-item.form-type-select {
    display: none;
}

This would then get triggered for the webform date field. But this template does not get triggered for the CiviCRM date field.

Can anyone suggest how I can either adpat this method or use a different way to replace the select fields with a single text field for the date, or at least disable the select fields?


texts: PHP Fatal error: Smarty error: [in string: (...)]: syntax error: (secure mode) (...) not allowed in if statement (...)

texts:
The CiviCRM doumentation describes, how to use Smarty to customize templates for mails and pdf's:
https://docs.civicrm.org/user/en/latest/common-workflows/tokens-and-mail-merge/#smarty
E.g.:
{capture assign=gift}{contact.custom_16}{/capture}
{if $gift == Yes}
  This membership is a gift from {contact.custom_17}.
{/if}

Or:
{capture assign=Anredestil}{contact.communication_style}{/capture}
<br/>vielen Dank für
{if $Anredestil eq 'Du'}Deine{else}Ihre{/if}

However, in certain conditions (especially but not limited to CiviCRM on Wordpress), this creates fatal errors like:
PHP Fatal error:  Smarty error: [in string:&lt;p&gt;{capture assign=Anredestil}Du{/capture}&lt;
br /&gt;vielen Dank f&amp;uuml;r {if $Anredestil eq &amp;quot;Du&amp;quot;}Deine{else}Ihre{/if} Spende.&lt;/p&gt; line 1]: syntax error: (secure mode) 'quot' not allowed in if statement (Smarty_Compiler.class.php, line 1399) in /html/wordpress/wp-content/plugins/c
ivicrm/civicrm/packages/Smarty/Smarty.class.php on line 1100

An obvious solution might be, to deactived the "secure mode" - however, this might create an unsafe situation.


texts:
We recevently update to 4.7.2 and this seems to have broken something in the API regarding the BETWEEN operator.

This used to work:

$result = civicrm_api3('Contribution', 'get', array(
  'sequential' => 1,
  'receive_date' => array('BETWEEN' => array("2015-10-01", "2015-12-31")),
));

Now it returns no results. However less than and likewise operators return correct results.

Is it a bug or am I using it wrong?


texts:
Some users may want to display Price Set options as standard buttons rather than as radio buttons.

I am sharing my CSS for this below.

See how it looks here (Joomla).


texts:
i need help, i'm trying to attach through civicrm_api3('Attach', 'create'..) a pdf file, passed with a rest call as simply text:

%PDF-1.3
1 0 obj
<< /Type /Catalog
... ecc

.
The attach works, but i thing that during it, the crm's file save function make an escape of some special chars... the results of content of pdf file is:

%PDF-1.3
1 0 obj
&lt;&lt; /Type /Catalog
... ecc

there is a way to avoid this behavior?

thanks


texts: Custom report with custom fields: Group By not correctly naming custom fields

texts:
Update I think the issue I'm running into is from this bug: https://issues.civicrm.org/jira/browse/CRM-18055

Using Civi 4.6.7 and Drupal 7.

This is my first custom report, and I'm attempting to let users sort by some custom fields. By reading through the docs and with the help of all y'all here on the forums, I got the fields added to the Sort dropdown:

class CRM_Report_Form_Special extends CRM_Report_Form {
  protected $_selectAliasesTotal = array();
  protected $_customGroupGroupBy = true;
  protected $_autoIncludeIndexedFieldsAsOrderBys = array( 'Activity' );
  protected $_customGroupExtends = array(
    'Activity',
  );

That part works great. What I can't get to work is when the user actually tries to sort by one of the custom fields, I always get a database error, as if the relevant columns don't exist:

FROM civireport_activity_temp_target tar
GROUP BY civicrm_activity_id  ORDER BY value_volunteer_activity_11_civireport.volunteer_activity_type_30 DESC  LIMIT 0, 50 [nativecode=1054 ** Unknown column 'value_volunteer_activity_11_civireport.volunteer_activity_type_30' in 'order clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT SQL_CALC_FOUND_ROWS GROUP_CONCAT(civicrm_contact_contact_target SEPARATOR ';') as civicrm_contact_contact_target, GROUP_CONCAT(civicrm_contact_contact_source_id SEPARATOR ';') as civicrm_contact_contact_source_id, GROUP_CONCAT(civicrm_contact_contact_assignee_id SEPARATOR ';') as civicrm_contact_contact_assignee_id, GROUP_CONCAT(civicrm_contact_contact_target_id SEPARATOR ';') as civicrm_contact_contact_target_id, civicrm_email_contact_target_email, civicrm_activity_id, civicrm_activity_source_record_id, civicrm_activity_status_id, civicrm_activity_details, civicrm_value_volunteer_activity_11_custom_30, civicrm_value_volunteer_activity_11_custom_43, civicrm_value_volunteer_activity_11_custom_31, civicrm_value_volunteer_activity_11_custom_42
FROM civireport_activity_temp_target tar
GROUP BY civicrm_activity_id  ORDER BY value_volunteer_activity_11_civireport.volunteer_activity_type_30 DESC  LIMIT 0, 50 [nativecode=1054 ** Unknown column 'value_volunteer_activity_11_civireport.volunteer_activity_type_30' in 'order clause']"]

[Edit]
 The field I want here is civicrm_value_volunteer_activity_11_civireport.volunteer_activity_type_30, instead of value_volunteer_activity_11_civireport.volunteer_activity_type_30, but I don't understand why the settings at the top of my post don't make that happen already...

I think that the custom fields should work here, right? I don't want to go mucking about with the various SQL statements to fix this, do I?
Thanks in advance for any help, and please let me know if I've left out relevant info!


texts: Upgrade from 5.14.1 to 5.15.0 throws error

texts:
Running on Drupal 7.67

Running the DB upgrade from 5.14.1 to 5.15.0 stalls on 'Update smart groups where jcalendar fields have been converted to datepicker', and afterwards retrying or reloading Civi shows same as error as the ConfigAndLog shows at the bottom:

Nov 17 12:58:43  [info] Running task: Cleanup old files

Nov 17 12:58:44  [info] Running task: Checking extensions

Nov 17 12:58:44  [info] Running task: Begin Upgrade to 5.15.alpha1

Nov 17 12:58:45  [info] Running task: Upgrade DB to 5.15.alpha1

Nov 17 12:58:46  [info] Running task: Upgrade DB to 5.15.alpha1: SQL

Nov 17 12:58:47  [info] Running task: Fix errant deferred revenue settings

Nov 17 12:58:47  [info] Running task: Fix cache key column name in prev next cache

Nov 17 12:58:48  [info] Running task: Update smart groups where jcalendar fields have been converted to datepicker

Nov 17 12:58:48  [info] Running task: Finish Upgrade DB to 5.15.alpha1

Nov 17 12:59:04  [info] $CRM_Queue_ErrorPolicy_reportError = Array
(
    [is_error] => 1
    [is_continue] => 0
    [exception] => Error 64: Cannot make non static method CRM_Core_DAO::copyCustomFields() static in class CRM_Event_BAO_Event in /home/tamera/www/dev/sites/all/modules/civicrm/local/code/CRM/Event/BAO/Event.php, line 2387
    [last_task_title] => Finish Upgrade DB to 5.15.alpha1
)

Any ideas?


texts: Staff restricted by ACLs cannot use/see any other groups

texts:
I have a group of CiviCRM users who are restricted by ACL to only be allowed to view and edit contacts in a certain geographic region (those contacts in a group called "Northern Region"). They also have view and edit permission on another group.

The problem is that the Manage Groups page only shows these two groups. If they add a new group it immediately dissapears!

Is this by design? It seems excessively limiting. I'd expect people to be able to see pretty much all groups, but only be able to see contacts within those groups that intersect with the contacts they're allowed by ACL.

Is there a work around?

Perhaps such staff are expected to create new groups as child groups of one of their ACL groups, but this is problematic because (a) it means that they can't make a group combining contacts from two+ groups and (b) it currently breaks access because of Bug #430

CiviCRM 5.10.3 / Drupal 7