texts: What does this import error mean? "Invalid value for field(s) : ... Country input value not in country table"

texts:
I am getting a crazy import error message:

  Invalid value for field(s) : Addressee must be one of the configured format options. Check Administer >> System Settings >> Option Groups >> Addressee for valid values; State/Province; Country input value not in country table: The Country value appears to be invalid. It does not match any value in CiviCRM table of countries.

What is wrong?


texts:
I have a survey which I am asking people to sign on line. The fields are activities and it is a campaign petition.

I also have a bunch of surveys filled in offline on paper.

I can upload the activities - which I have done but these people don't show up as having signed the petition. I have to do two separate searches - one for the activities and one for the petition.

Has anybody got any idea how I can have this data in one place. I can't just sign the petition for multiple people because civicrm is too clever for that (or so it seems to me!)

Ideas very welcome!


texts: Why does searching by contribution source use always the "Like" statement?

texts:
I'm currently using CiviCRM 5.21.1.

When I try to search for contributions by typing specific "Contribution Source" under "Contributions -> Find Contributions", it shows me all contribution records which contribution source is not only just "ABC" but also "ABCD" and "ABCDE".

This is because "Find Contributions" searches with a "Contribution Source Like ABC%" condition, not "Contribution Source = 'ABC'". In other words, for the search, a wildcard was attached automatically at the end of the word and the "Like" statement was used in the search condition instead of an equal statement.

I know that I can find the list what I want by using "Search Builder" but I want to get the numbers of Total Amount and Average, so I need to use "Find Contributions".

Does anyone have the same issue as me? Please, help me.


texts: What's the rationale behind the new Civi folder in civicrm?

texts: From a cursory glance, everything in Civi seems to be namespaced and everything in CRM is not. I'm guessing the answer has something to do with this.


texts:
I create a general rule to search my database of 29000 contacts for matching emails - I know there are a few at least, and it says there are none. Also I give it a weight and match that in the threshold but after saving the rule and going back to it, the weight has reset to 0. the same happens with the length setting.

Any clues?

Myles
Civi 4.6.10 on drupal


texts: Is there a way to to do this without multiple layers of installation on multiple computers (this would be intended for 4-5 staff members regularly using Civi for donor outreach).


texts: Multi lingual site not working with drupal language switcher

texts: I have set the localization to inherit the cms language which I thought meant I could use the drupal language switcher. I have made an events view. The dates translate when I change language with the drupal date switcher block, but the title and description can only be seen if I use the civicrm switcher block (which I don't want to use). How can I fix this?  I'm using Drupal 7 with Civi 5.1.0.


texts: Using CiviGrant as the applicant/recipient

texts:
Our charity doesn't offer grants but applies for a fair few. Having had a play around with CiviGrant, I can't see any immediate problem with using the component as a way of tracking grants that we've applied for and received etc. but the documentation from Civi suggests it's only for managing grants going out of the charity:

  In contrast to CiviContribute, which tracks money going into your organisation, CiviGrant tracks money going out of your organisation. CiviGrant has a data structure and workflows that support the grant application process with the ability to manage the amount applied for, amount received and any reports necessary for the process.

I created a sample organisation as a contact to attach to the grant and all seems OK to use as a way of managing incoming grants. Just wondering if the community knows something I don't as to why this might not work e.g scaling, reports etc.


texts:
I've just spent the day trying to set up bounce processing, and have it working for civimail, but found out that it doesn't work for transactional emails? I tried installing the transactional emails extension by unzipping it to my ext folder with the rest of my extensions, but it doesn't show up.
Has anyone had luck installing it?
I'm on CiviCRM 4.7.27 on Joomla 3.8.6


texts: Why isn't there a CiviRules action to change membership status?

texts: As per the title: why isn't there an action in CiviRules to be able to change membership status i.e. from active to cancelled? This seems like something a lot of people would use. Is anyone working on something?


texts: Can civirules be triggered off a custom field of type date for eg Date equals Now

texts:
Client is thinking about several date fields for a contact eg, when are they available to start volunteering' and want an alert for it. My presumption was 'oh let's do it with Activities' but actually I wondered if CiviRules could do this.

I ran a test and saw I can use Field value comparison, and set the field to 'is equal to' - but assume that NOW won't work out-of-the-box but happy to be told otherwise.

Assuming not, can you give me a pointer or know if this has been tried and is 'too hard basket'?

EDIT: so a custom field shows 'date i am available to volunteer' for a volunteer which will be sometime in the future. And the Admin want to get a reminder/notification say 5 days before that date is reached.

So I think the Linked Condition is eg Condition = Field value comparison, and Description is Contact.custom_127 = NOW

And Linked Action would be:
Add Activity to Contact. Type: Email. Status:Scheduled. Subject: check availability. Assignee: Peter DavisFZ

BUT if it ends up needing to be an Activity then I can also think about creating it at the outset on the form.

Reason I wondered about CiviRules is that I though "ha, with civicrm entity I can probably trigger a notification directly via Drupal Rules", and then i remembered CiviRules and wanted to find out more of what it could do ;-)


texts: How to test for CiviCRM status messages in selenium?

texts:
CiviCRM presents status messages in a slick overlay, which looks neat for human users but has been hard for me to test for in Selenium. It appears the messages first appear within the main page content, but are then moved into the overlay div, where they appear on-screen only for several seconds before fading.

I'm guessing CiviCRM's own Selenium tests have standardized a variation on  assertText() that works with this overlay, but I've not dug around enough to find it.

How would one detect the presence of a given status message, in Selenium IDE and in phpunit?


texts: I am logged into our website, setting up a Contribution Page, and I need to set up a Payment Processor, but I am receiving and error message: ****The 'administer payment processors' permission is required to add or edit a payment processor.****


texts: Is the Intuit processor active/functional?

texts:
I have a question from a group that uses Intuit with their POS system and were wondering if they could integrate their CiviCRM payments directly into that same account.

I see there is a Wiki page from 2013 about setting up Intuit payments, but I can't even get the extension to install on CiviCRM 4.6.8. (I copied the .zip file from Github and unpacked in the CiviCRM Extensions directory but it doesn't show in the Extensions list, even after refreshing. I assume this means the extension is stale / not functional with a recent version of CiviCRM)

Is anyone using Intuit or should I consider this a lost cause and go to plan B?


texts: Error: "Could not find valid value for id" when registering - but only when registering from countries which are far away

texts:
We have a CiviCRM install, where this error happens - but only occasionally!
It's a multilingual site (english and german), and they have participants from all over the world.
It seems to me, that the error happens especially with people fomr "less developed countries", and we do find quite a number of these cases in the logfile (or people complaining via email), but I personally was not able to reproduce that error.

The system is up to date:

CiviCRM 5.11.0, Drupal 7.65, PHP 7.2

Excerpt from the CiviCRM logfile (ConfigAndLog)

Feb 25 00:23:56  [info] $Fatal Error Details = Array (
    [message] => Could not find valid value for id
    [code] => )

Feb 25 00:23:56  [info] $backTrace = #0
/html/sites/all/modules/civicrm/CRM/Core/Error.php(381):
CRM_Core_Error::backtrace("backTrac e", TRUE)
#1 /html/sites/all/modules/civicrm/CRM/Utils/Request.php(121): CRM_Core_Error::fatal("Could not find valid value for id")
#2 /html/sites/all/modules/civicrm/CRM/Event/StateMachine/Registration.php(52):
CRM_Utils_Request::retrieve("id", "Positive", Object
(CRM_Event_Controller_Registration), TRUE)
#3 /html/sites/all/modules/civicrm/CRM/Event/Controller/Registration.php(47):
CRM_Event_StateMachine_Registration->__construct(Objec
t(CRM_Event_Controller_Registration), TRUE)
#4 /html/sites/all/modules/civicrm/CRM/Core/Invoke.php(304): CRM_Event_Controller_Registration->__construct("Event Registration",
TR UE, "null", NULL, "false")
#5 /html/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:15))
#6 /html/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#7 /html/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:3))
#8 /html/includes/menu.inc(527): civicrm_invoke("event", "register")
#9 /html/index.php(21): menu_execute_active_handler()
#10 {main}

 (
     [message] => Could not find valid value for id
     [code] => )

The webserver's access log says:

154.100.184.0 - - [25/Feb/2019:00:23:54 +0100] "POST /civicrm/event/register HTTP/2.0" 200 1686
"https://******.de/civicrm/event/register?id=41&language=en"
"Mozilla/5.0 (Windows NT 6.1; rv:65.0) Gecko/20100101 Firefox/65.0"
******.de
154.100.184.0 - - [25/Feb/2019:00:23:56 +0100] "GET /sites/all/modules/civicrm/css/crm-i.css HTTP/2.0" 200 1024
"https://******.de/civicrm/event/register" "Mozilla/5.0 (Windows NT
6.1; rv:65.0) Gecko/20100101 Firefox/65.0" ******.de
154.100.184.0 - - [25/Feb/2019:00:23:56 +0100] "GET /sites/all/modules/civicrm/bower_components/font-awesome/css/font-awesome.min.css
HTTP/2.0" 200 31000 "https://******.de/civicrm/event/register"
"Mozilla/5.0 (Windows NT 6.1; rv:65.0) Gecko/20100101 Firefox/65.0"
******.de
154.100.184.0 - - [25/Feb/2019:00:23:56 +0100] "GET /sites/all/modules/civicrm/css/civicrm.css HTTP/2.0" 200 83907
"https://******.de/civicrm/event/register" "Mozilla/5.0 (Windows NT
6.1; rv:65.0) Gecko/20100101 Firefox/65.0" ******.de

I have no clue, where to look at...


texts:
Since myself new to civi and drupal combination in certain case we need drupal as backend for few functionalities/workflow, and few functionalities works civi as backend. So my concerns is where would be the theme get placed ..whether we need to build two themes for civi and drupal differently. or theming will be common in one place? Please advise

Thank you


texts:
How to change the encoding in pdf documents?
Cyrillic characters are not displayed in my pdf documents.
To display them, you need to change the encoding. Please tell me which file can this be done?
I tried to find the answer in other questions, but unfortunately I could not.

css

Report pdf

Report html


texts: Change billing date of recurring contribution (PayPal payment processor)

texts:
Is it possible to change the billing date for someone's recurring contribution (e.g. monthly donation)?

We're using CiviCRM 4.7 and Joomla 3.7 (if that matters) and the PayPal payment processor. Thought we could ask PayPal to change that but the answer was no.

Thanks much for any pointers.


texts: What does the CiviCRM Contact Reference Field Drupal module do? And, if I select On to enable it, the selector changes to orange, rather than green, which I assume means 'proceed with caution if enabling this module'. So I'm not enabling it. Should I?


texts: how do I find a new page I just created so that I can link it on another page?

texts: I just created a new Basic page, and I want to link to it on another page, but I can't find it when I browse for it in the Create Link option.  I'm VERY new to this platform.


texts:
We were running into issues with how CiviCRM activities are showing in Drupal Calendar (Views). Drupal is adjusting the provided activity date/time based on the user configured time zone. For us, this is desired behavior because we have users crossing multiple time zones who want to see the time the activity is executed in whatever time zone they are in.

After a little research (and finding these threads:
https://issues.civicrm.org/jira/browse/CRM-9683,
https://forum.civicrm.org/index.php/topic,23411.msg98329.html#msg98329,
What timezones should we use on the server and database?, though there are many more tangentially related ones)
 it appears that CiviCRM assumes that all users will be in the same timezone and stores activity date/times as the local time into the database. Drupal expects that the stored times are in UTC, hence our issue. Would a "simple" fix of converting the activity datetime column format to a timestamp format in mysql be a reasonable fix? I'm worried that we're going to run into this in multiple places...

Thanks!

As an aside, I think it would make sense as a future change for CiviCRM to respect the Drupal user configurable time zones.


texts: How to add pre-existing case id to webform

texts:
Similar to contact id, I find that it would often be beneficial to add the case id to a webform for email submitted via a webform.
Is there a token or a work-around to add the case id for pre-existing cases to a webform that updates a case?
Hopefully to add some clarity:
I am currently trying to create a rule that sends out an email when a webform is submitted. In order to add a link to the relevant data in the email, I need the case id. If I can get the case id on the webform itself, then I can use tokens to populate the case in the email.
So, much like contact id is an option under each contact on the webform, I'd like the case id as an option.

Example:
I load a prefilled webform with a url ending in ?cid2=XXX&case1=XXXX.
On that webform, there is a field that displays the case id.
I create a rule to send the submission once that form is submitted and include a link to edit relevant info by forming the link the same way ?cid2=XXX&case1=XXXX in the email sent out.


texts:
I've upgraded CiviCRM multiple times since we last ran an event which requires payments, and are now at 4.7.17 on Joomla 3.6.5 with MySQL 5.7.18.

When many (not all) users try to register they encounter "DBError: no such field" and the debug info points to Unknown column 'card_type' in 'field list', 1054 and the query

INSERT INTO civicrm_financial_trxn (to_financial_account_id , trxn_date , total_amount , fee_amount , net_amount , currency , status_id , payment_instrument_id ) VALUES ( 10 ,  20170607160037 ,  3200 ,  0 ,  3200 , 'SEK' ,  2 ,  4 )  [nativecode=1054 ** Unknown column 'card_type' in 'field list']

and the backtrace shows this

...
#14 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(487): DB_DataObject->insert()
#15 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/FinancialTrxn.php(66): CRM_Core_DAO->save()
#16 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Contribute/BAO/Contribution.php(3364): CRM_Core_BAO_FinancialTrxn::create((Array:11))
#17 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Contribute/BAO/Contribution.php(236): CRM_Contribute_BAO_Contribution::recordFinancialAccounts((Array:22))
#18 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Event/Form/Registration/Confirm.php(1038): CRM_Contribute_BAO_Contribution::add((Array:22), (Array:0))
#19 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Event/Form/Registration/Confirm.php(611): CRM_Event_Form_Registration_Confirm::processContribution(Object(CRM_Event_Form_Registration_Confirm), (Array:35), NULL, "6642", TRUE, FALSE, (Array:10))
#20 /var/www/events/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php(453): CRM_Event_Form_Registration_Confirm->postProcess()
...

However, in my database the field does actually exist, as shown by this create statement generated from the table

CREATE TABLE `civicrm_financial_trxn` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Gift ID',
    ...
   `card_type` int(10) unsigned DEFAULT NULL COMMENT 'FK to accept_creditcard option group values',
    ...

How can this happen? What do I do next? Should I try re-running the database upgrade script?


texts: Bounce processor scheduled job is working but not flagging emails as bounced

texts:
We've had a bounce processor set up (and working) for about 2 years. Recently, I'd guess the last two months I'm not exactly sure when this started, it has not been fully working.
I can see the bounced messages arrive in the bounce email account. After the Bounce fetcher runs (we have it set to run hourly) it moves the emails to the processed folder. What it does not do is then mark the emails on the contact records as bounced.
The scheduled job log shows no errors.
Full message:
Finished execution of Bounces fetcher with result: Success (1)

We are in Drupal 7, CiviCRM 5.27.7.
Has anyone else experienced this? I'm not sure where to poke around next to find out where the breakdown might be.


texts: Event Reporting to call out Custom Fields in related Contribution Record

texts: Is it possible (via extension perhaps) to get a custom field from a related contribution record to be included in a Event Report ?  For example, in a paid event registration, this would create a associated contribution record and a custom field created in the contribution record.  How can I do a Event report which will include the Contribution record custom field ?  the current Report function doesn't seem to allow that.  Thanks.


texts: How do I add a new settings page for my extension?

texts:
I am trying to develop a module extension which needs to store some settings, I went through the documentation and found this to be the way to create settings.

Now when I put default as NULL the setting is not reflected in the table, if I put any value as default the setting is added to civicrm_setting table.

Also, though the settings have option to specify attributes for admin form, I couldn't figure out a way to present a new settings form for my module.

Is there anything else which I need to do apart from adding the setting folder and the following code to extension.php

function multisite_civicrm_alterSettingsFolders(&$metaDataFolders = NULL){
     _multisite_civix_civicrm_alterSettingsFolders($metaDataFolders);
}


texts: Find Contacts who are in one and only one group?

texts: i could write a sql query but is there a way to do this search from the UI?


texts: Add another position to a contact or enable fullt-text search for position field

texts:
in CiviCRM running on WordPress I had to recognize that it creates problems when filling in two positions into the position field when adding a contact. The main problem is that you've got to type the exact name of the position when searching for a certain contact that's got that position. If this contact has got two positions, however, CiviCRM won't show that contact unless you search for both positions. Then, however, the search does not make any sense, since you would have to know all position of your contacts in advance...

Am I making a mistake here or is there a solution to that problem?

Thanks a lot for looking at this!
Best regards
Jannis

Edit: I am using the German translated version where the field 'position' is called 'Funktion'. So in an earlier version of this post it said 'function' instead of 'position'. Thanks a lot, @jitendrapurohit, for pointing at that problem! :)


texts: How to create a non report based dashlet

texts:
Expanding on this question here: dashlet creation

If I wanted to create my own dashlet with somewhat static content I'm wondering how that is accomplished, I have a loose idea below but not sure if it is correct.

How do I register the dashlet itself, since I won't be starting from a report - can I add a row to the database itself?

That row in the database would then point to a URL similar to the others (i.e. civicrm/dashlet/blog?reset=1). If I point to my own /dashlet/goodinfo... do I need to create both a supporting tpl and php file (kept neatly in a custom/override folder) or will a tpl file suffice?

I may be headed down an entirely incorrect path - open to suggestions!


texts: Drupal Views - Show "Contribution" + Drupal User fields

texts:
A client requires one of their reports include information from both CiviContribute, but also Drupal user fields (such as login name).

We're trying to build this as a View.

However, when creating the view, and the "Show" dropdown, we select "CiviCRM Contribution", but cannot get access to the "Users" fields.

Anyone have a solution for this?


texts: Attachment URLs incomplete on remote server only

texts:
I'm working locally on my Mac with the latest version of CiviCRM on latest WordPress, served by MAMP. Using the API, I create an attachment to a contact, and those attachments successfully display after being retrieved through the API. The URL comes back as http://localhost/civicrm?page=CiviCRM&q=civicrm%2Ffile&reset=1&id=15&eid=29&fcs=...

However, when I upload the code and database records to the remote server for testing, the one thing that doesn't work are my attachments. The URLs come back from the API missing a slash: http://remotedomain.comcivicrm?page=CiviCRM&q=civicrm%2Ffile&reset=1&id=15&eid=29&fcs=... Notice the missing slash after the `.com?

I've double checked the configuration in civicrm.settings.php. Both localhost and remotedomain.com have a / in the URL base. I checked the various settings in the admin interface, but nothing looks amiss.

What could be causing this issue?


texts: How to make a daily bithday report at morning?

texts: Every day a person receives a list of who has a birthday on that day. But this happend at evening, when it useless, How to make it at morning?


texts:
When visiting a Drupal8 + CiviCRM 5.4.0 website with Varnish, Varnish caching works fine until you hit the /civicrm/contribute/transact?reset=1&id=x page and leaving this page by clicking an other url (Drupal), a CiviCRM cookie (can't find matching session) doesn't gets unset which breaks Varnish.

I found a similar issue here:
https://issues.civicrm.org/jira/browse/CRM-8765


texts: I have accidentally deleted a contact and need to get all their information back, how do I do this?


texts: What's best practice in terms of handling Gift Aid within CiviCRM

texts:
I'm just setting up the 3.0 beta Gift aid extension (https://github.com/compucorp/uk.co.compucorp.civicrm.giftaid and https://civicrm.org/extensions/gift-aid-extension-uk), as provided by Compucorp (and for which many thanks) for CiviCRM 4.6.

However I'm a tad confused, because there's also the Gift Aid Online Submission extension from Veda Consulting (https://civicrm.org/extensions/uk-hmrc-online-gift-aid-submission). Studying the available documentation, neither extension appears to reference or make mention in any way of the other. I've a vague memory from CiviCon London a few years back that the online submission extension builds on the Compucorp extension by enabling straightforward submission direct to HMRC, but I'm not clear. Can anyone cast any light?

If I can get some clarity, through my own experience and that of other folks that have gone through this I'll be happy to write it up in a way that might be helpful to other users.


texts: Registration Profile Selection Reverts after Save & Close

texts:
Joomla 3.4x

Civi 4.6.10 (can't update due to error described here)

PHP 5.5.30

Online registration is enabled, primary registration uses Profile A on top, and Profile B on the bottom.

Additional Registrations use Profile C. Originally the client had selected Profile B for additional registrations, but realized they didn't need to collect that information.

If you remove Profile B from Additional Registrations and then Save and Cancel to close the Event, Profile B does not appear in the form.

If you remove Profile B from Additional Registrations and use Save & Close, the form reverts to using Profile C and B.

Very maddening as the default that most people take is Save & Close.

Has anyone else experienced this and is there a resolution?


texts:
We are running a conference, when sending a receipt to someone how do we select one of the stored templates which we have created e.g late payment?

Thanks


texts: Why does this use of the API for Events work in the Explorer, but not in the Message Template?

texts:
I'm trying to use the CiviCRM API to show a list of upcoming events (in the confirmation email a user receives when they sign up for an event).

When I try the operation in the API Explorer it appears to return exactly what I want, but when I apply the code (in this case, the Smarty code) in the Message Template, the filtering to only show events after the date specified doesn't seem to take any effect. It just shows all the events.

{php}
  $this->assign("param_start_date", array('>' => "2013-10-22 18:00:00"));
  $this->assign("param_options", array('sort' => "start_date"));
{/php}
{crmAPI var='result' entity='Event' action='get' return="title,start_date" start_date=$param_start_date options=$param_options}
{foreach from=$result.values item=event}
  {$event.event_title}
{/foreach}

I got the above code using the API Explorer by:

Selecting 'Event' as the entity.
'Get' as the method. 'Event Title'
and 'Event Start Date' as the Fields to return.
'Event Start Date' as
the parameter, with '>' as the operator and '2013-10-22 18:00:00' as
the value.
Selecting 'Sort' as an option, with value 'start_date'.


texts:
How does CiviCRM keep our data secure?  Is the program web-based? Or is it desktop based?  I am interested in downloading and trying CiviCRM for our organization but can't find an information on security features.

Thank you.


texts: Is it possible to automatically email individuals once I manually add them to a group?

texts:
I'm with a small non-profit, and we'd like new additions to our general mailing list to automatically receive a "welcome" email when we manually add them to the list (a group in Civi). Is this possible?

I read that we could set up an "automated message," but my impression is that this will only work if we have a subscribe button on our site that the individual must click on.

My preference would be to continue inputting new contacts manually then have an automatic email go out when I add them to the mailing list group, but I am open to new suggestions if this is not possible.

Could you provide insights on this or point me in the right direction? I am very new here; please let me know if I need to include more info and apologies for my ignorance. Looking forward to your input.


texts: Thank-you letters WYSIWYG vs html source content

texts:
Drupal 7.72
Civi 5.24.5
I recently added an IF statement to our receipts and Thank-You letters to comply with Florida Charity Regulations. The state of FL requires us to have a statement on our receipts for donors from FL. So I did a IF 'FL' then... It works with the System Workflow Templates for online and offline receipts. However, for checks we send a Thank-You Letter as a receipt. That kinda works. The difference I see is, the Thank-You letter has a WYSIWYG with it but the System Workflow Template online/offline does not. The WYSIWYG shows {if $stateProv eq 'FL'} but the html source has {if $stateProv eq & #39;FL& #39;} (I added spaces so it displays without converting to ')  If I change the html source to {if $stateProv eq 'FL'} it works but even though we check "Update Template" it still needs to have this changed every time we use the Thank-You letter template.

How do I fix the Thank-You letter?
Where do I find the WYSIWYG settings in CiviCRM? I tried to find where to disable that or even find what WYSIWYG we are using so I could Google a fix to make '' stick.


texts: Must my command-line tool be an extension?

texts:
I have made a standalone tool which i start with the command-line to see possible updates in the database to use the actual translations, and a program to compare an existing database with a new installation.
Now you can use the sql-files in the localization-files only with a new installation and i use the new po-files to find possible updates after the normal upgrading in CiviCRM. The translated strings in the database are now never upgraded with new Transifex translations.
After making the programs i looked how extensions work, but this is not really an extension for users but may be something for the system administrator.
Are there other kinds of extensions?


texts: Log / report for emails sent using Events > Find Participants?

texts: I sent a dozen or so emails using Events > Find Participants > Email - Send now. At least some of them arrived successfully (recipients are responding), but I can't find a log or report in CiviCRM that can confirm that they were all sent. Is there one?


texts:
I have setup a custom field with 4 options. In my spreadsheet I've tried various combinations of columns which would allow me to import data and select required options. But nothing is working!

Custom Data - Checkbox Options - Red, Blue, Green, Black

In my CSV file I've tried combinations such as

"Red,Blue"

'Red,Blue'

Red,Blue

Is it possible to import data for check box custom data?

Thanks

Alan


texts:
When I log in with the username of certain users and try to edit a field and save, I get a Network Error. However, If I log in with another users or as the admin, I can edit the field with no problem at all. Same computer, same profile to edit.

Why this network error depending on the user?

Thanks!


texts: Manage Case ─ display activities in chronological order

texts:
Joomla 3.9.2
CiviCRM 5.12.0

On the Manage Case page, the activities are now displayed in a clever order (overdue first, then the rest in newest-to-oldest order). I can imagine that this makes sense in some situations, but it doesn't in ours, so I need to tweak the code to have a simple ASCENDING order (oldest last). Previously, I had tweaked civicrm/templates/CRM/Case/Form/ActivityTab.tpl to replace
class="nestedActivitySelector crm-ajax-table" data-page-length="10" with
class="nestedActivitySelector crm-ajax-table" data-page-length="50" data-order='[[0,"asc"]]'> (see also this post), but this tweak no longer has any effect.

Can some kind developer please point to the part of the code which I need to change? Thank you.


texts:
EDIT: OK... I followed the instructions in the link that's in my comment, but I'm back at exactly the situation described below in OP. I guess that's good - at least there's some consistent thing wrong. I did the whole from-zero fresh install of Drupal and CiviCRM again, and this time, on the subsequent db restore, instead of dropping the existing, fresh db first, I left the db in place and truncated tables and reloaded them with the backup data. Didn't make any difference. Any help with this is HIGHLY appreciated!

--

I've got a CiviCRM 5.10.4 install (yeah, I know, old - it will be brought up to date as soon as I solve the present problem) running on Drupal 7.67, and I want to migrate the whole thing to a different hosting platform. Specifically, I'm moving from a platform where I don't have shell access, and also direct admin access to the db, to one where I do have both (RHEL7 Linux and MySQL)

Briefly: I tried just taking a gzip of the filesystem tree and a dump of the db, and putting these in their new places, but it didn't work. Can't quite remember what error I saw, now. Yes, my database settings in the Drupal settings are correct, and I've looked in the civicrm.settings.php as well, and don't see anything that raises any flags yet.

So next, I tried doing a fresh install of Drupal 7.67 and Civi 5.10.4 on the new platform. That fresh install worked fine. So THEN I tried wiping out the fresh clean database, and restoring it with the backup from my production system.

What happens now is that I can get the Drupal login screen, but when I try to login, I get a 404. Specifically, it's trying to redirect me to /node?destination=node, and I'm not sure what this means. I try entering URL /civicrm/dashboard by hand (deliberately only giving relative URLs here, figuring my domain part is irrelevant), but I still get 404 (The requested URL /civicrm/dashboard was not found on this server). I'm a noob at Apache configuration, so I'm not sure if this could be caused by the web server. I have carefully set the filesystem permissions also for best security, using good advice found on the web. I have a feeling this is not caused by the permissions, but am open to anything :)

I have a feeling I just need to tweak something, either in the db or the filesystem or both, and it'll work, but have no clue what or where. Can anyone help? Thanks.


texts: Why have menu links to extensions eg DataViz, CiviDiscount, LogViewer now give the civi home page

texts:
After upgrading to 5.3.1 and clearing out templates_c and doing two drush cc all we are still finding sites where then menu link to eg CiviDiscount or LogViewer just show the civi home page

What is the long term fix for this?


texts:
My wordpress is installed and uses localhost:/run/mysqld/mysqld/socket
but civicrm only works if I point to localhost

Is there a way to install civicrm through file socket ?


texts: Our organization pro-rates dues based on the join date. CiviDiscount can handle this (albeit a bit manual in terms of changing dates) through an automatic code based on 'member status' -- but the problem is those who are joining don't yet have a 'member status' of 'new'. How can this be configured so someone who is completing the application for the first time can't receive a discount we'd like everyone to get except members (in terms of renewal).


texts: URL issue with AWS load balancer and SSL certificate

texts:
I recently installed Civicrm on AWS. App works great! However, when I creat a load balancer with a SSL certificate and point the Domain towards the LB, I get a 503 page. If I don't use SSL, everything works fine.

What am I missing?


texts: When I imported new contacts, some contacts got error "record", what is that?

texts:
When I imported contacts using a CSV some rows were not imported even though their formatting was fine and matched all the other rows. When I downloaded the errors, the error was called "record". Anyone know what that means?
I've now tried repeatedly re-entering the same six rows that were considered "record" errors and even though the data seems fine CiviCRM still won't import the contacts. Let me know what I'm doing wrong!

Thanks,

Evann


texts:
I'm using latest drupal 7 and civicrm.

I have an existing drupal/civi install which uses the same database, and i'd like to switch to having separate databases - is that possible?

The civi side is the important part fwiw.

Thanks!


texts: How can I see which contacts have been assigned which roles and permissions?

texts:
How can i find out which contacts have been assigned which roles? I am looking to ensure that only a few key staff can access and edit our database...
I can see we have two roles set up but I don't know how to find out who has been assigned which role...


texts: Is there a way to open the honoree section by default?

texts: I would like to have the honoree section on a civicontribute page default to being open, instead of having the user find and click on the honoree title in order to see the fields. They could still close it if they don't want to use it. Is there a way to do that?


texts:
We have installed the mailchimp plugin from veda consulting.  The plugin was working until recently

when I try to access this
page https://www.fremantlechamber.com.au/civicrm/mailchimp/settings?reset=1

I get the error below.  I checked the groups and they are all correctly
synced to the plugin and not referencing a list in Mailchimp that does
not exist.

Sorry but we are not able to provide this at the moment.
Invalid MailChimp List ID: e33355b9f6

Return to home page. https://www.fremantlechamber.com.au/

Can you please assist.


texts: Replace default Datatables script to most recent [custom buit] one

texts:
How do one properly replace default 3-rd party packages without loosing changes after updates?

Namely, in need of Datatable CVS File Export, we've grabbed a custom DataTables built with all bells&whistles included from Download Builder page https://datatables.net/download/ and have just replaced stuff in    \civicrm\packages\jquery\plugins\DataTables\media\js\

However, changes will be obviously lost after civicrm core update. Is there any recommended technique to handle such things?

Thanks!


texts: Re-install Buildkit on Ubuntu for Windows

texts:
I have just installed BuildKit on Ubuntu for Windows as root by mistake. Is there a way I can uninstall and start again? Can I just delete the buildkit folder?

Also, I don't need to install Apache, PHP and MySQL, as these are already installed. Is there a particular command for installing the build kit without these? I was following the instructions at https://docs.civicrm.org/dev/en/latest/tools/buildkit/.


texts:
I'm new here, but I'm sure not the only one who speaks Spanish. I would like to know what solutions you have used for the problem of the 2 surnames that are used in Spanish.

Which is the best solution for integrating both surnames into Civicrm?

PD. There should be an standard integrated solution to Civicrm, since Spanish is the most spoken language in the world after Chinese. ;)


texts:
Database table Table: civicrm_contact_push_notification_messages
Is huge. 51GB to be precise.
The main field is %display_name has created activity.
Is this the table that shows up what emails have been sent under a user's activity tab? Or something else.
Does anyone know?
Thakns!
Caroline


texts: Is there a way to bulk edit relationship permissions?

texts: I have about 70 organizations that we imported with individuals - that will have permissions to view and update information.  Is there a way to make sure they can have that permission when we import or bulk edit that information.  Right now I am adding permissions one by one.


texts: How can I add an additional email id for "work" through API?

texts:
I need to add an email id to a CiviCRM contact through the API. Existing email ids of the contact should be kept unchanged and the new email added as type "Work" (the contact doesn't have any "Work" emails yet, if that should make it easier).

I tried to find a suitable API call through the API Explorer (civicrm/api/explorer) but the autocomplete didn't offer an Email field anywhere.

I also found an old forum post using some civicrm_location_update($params). But this left me confused and I can't find anything like it in the API Explorer.


texts: Hosting a paid event with a member ticket and a non-member ticket

texts: Consider the following situation. Martin is a member of our non-profit organization and would like to register for a seminar that we host. We offer either a member ticket of $150 and a non-member ticket of $250. Obviously, Martin opts for the member ticket. How does CiviCRM control whether Martin is indeed a member and is allowed to register for the $150 ticket?


texts:
I want to make a weekly/fortnight backup of CiviCRM running on Wordpress. Two things I need to do:

Backup on same machine
Replicate the database on another machine.

Looking for simple steps to achieve both

OS : Windows , Separate databases for Wordpress and CiviCRM


texts: Can I use {contact.checksum} in membership confirmation receipt

texts:
I am using CiviCRM with WordPress 5.3.2.

I've managed to use the {contact.checksum} feature to send folks a link to edit their profile, in a one-off or bulk email.

Now, I would like to include that capability in the membership confirmation receipt.  I tried including it in the "Receipt Message", but apparently html isn't allowed there.  Should I try to insert it into the relevant system Workflow message?

I would also like to include it in the "Thank you footer" of the contribution (so that users can immediately edit their own data, without waiting for the email. But the link just give error ("No user/contact ID was specified, so the Profile cannot be used in edit mode.")  Is there any way to do this?


texts: Support for distributing benefits in Turkish

texts: Can CiviCRM be quickly setup in a cloud so that it's primary function is to distribute benefits (cash, food, etc) with user interface in Turkish?


texts: Three minute payment confirmation url response delay for payment processor

texts:
I have a coop.symbiotic.moneticoclassique payment-processor set up and right now everything but the response to the payment gateway works.

The user pays for an item and is redirected to the payment gateway. When paying for the item, there is always a 30 second wait time for the payment to get approved.
The payment gateway then redirects the user back to the approved page showing the payment was successful.
The payment gateway then sends an email noting the successful payment that was made. However, about sixty seconds later another email arrives noting the payment was processed but the return_url had an error.

After some troubleshooting, I found that between step 1 and 2, the web server logs the HTTP 200 OK response to the payment gateway three minutes after the transaction has already been redirected to the thank you for your payment page. Does anyone know what possible causes CiviCRM would have to take 3 minutes to process the payment gateways request on the payment confirmation url?


texts:
We require an offsite payment processor that works with webforms and can take card payments.

Paypal Express doesn't work.
Paypal standard can't take card payments with an account.

Are there any other offsite payment processes like paypal express please?

Thanks,
Andy

Drupal 7. CIVICRM 4.5.8


texts: Make a search box for a priceset on a donation page

texts:
Right now we are using WordPress but planning to switch to Drupal in the next several months. So Drupal fixes are good answers.

We have a contribution page setup with a priceset that is quite large and only getting larger as we grow. In a year from now, that list will be well over 100 active pricefields with 100 disabled. I would like to add a search box at the top so that people can start typing the name and have it auto-fill options from the priceset.

My current best option is to break the list down by Class of ... But I would prefer to just have one "Pay Tuition" link.


texts: Multiple errors after upgrading to 4.7.21 and Joomla 3.7.3

texts:
E.g. here: https://www.evergreenmtb.org/support-us/donate

All those files (listed in Chrome's Console w/ errors) do exist, permissions are 644... what am I missing? This started after upgrading to 4.7.21 and Joomla 3.7.3.

Any pointers greatly appreciated : )


texts: How do I make street address not a required field?

texts: When creating a contributions page for member dues, street address, city, country are all required fields. I do not want them to be. How can I make them not-required fields?


texts: Can you assign an owner to an event & can that person later run a report to see info about their events (in particular a list of attendees/wait list)?

texts:
I am evaluating civiCRM for a large homeschool coop. Our members teach study groups for the kids. So when we create an event (study group), we want to be able to assign an event owner (aka study group leader) to the event. Then we would like for that person to be able to pull up a list of study groups they are running and see who is registered for it. Having a hard time testing this out on the demo sites since I can't seem to create a login to test things out with a regular kinda member. Thanks.

EDIT: probably would use Drupal if we decided to use civiCRM, since it seems like we would need to use Webform CiviCRM Integration in order to get something else working the way we need.


texts: How do I edit the organization's contact information on an invoice automatically generated when a person signs up for a CiviEvent and chooses to Pay Later (also for event registration confirmation)?  The invoice was created by a developer the organization no longer uses, and the organization's address and phone have changed.  We currently have Joomla 3.3.1 and CiviCRM 4.4.5


texts: Can you create a mailing list based on a relationship setting?

texts: We want to create a mailing list for a subset of people based on their relationship status. Is this possible?


texts: Should I change mysql.connect_timeout variable in php.ini?

texts: MySQL has been losing connection on me while trying to complete the upgrade. I am wondering if I should change the php.ini variable mysql.connect_timeout = 60 to a value of -1 (unlimited) and if this will help?


texts: How to include smarty script with mosaico email

texts:
I used to use a name personalisation in civimail with smarty script...

{capture assign=nickname}{contact.nick_name}{/capture} Dear {if $nickname}{contact.nick_name}{else}{contact.sort_name}{/if}

I was testing if this script would render in mosaico 2.x, it seems doesn't work. Is there any workaround? Thanks


texts: I have loaded Civicrm on a localhost. Everything works fine. I enabled the Mosaico extension. To do this I installed an ImageMagick plugin on Wordpress, enabled the Flexmailer and the Shoreditch theme. When I go into Mosaico, I get the message Warning Experimental Beta Version Use with Care. The templates are also blank as per the illustration. Is there a way around this issue?


texts: Events 'missing' after upgrade to 4.7.19

texts:
On a civi 4.7.19 / joomla 3.70 installation I have problems accessing events after the 4.7.19 ugrade (events worked OK on 4.7.18/3.7.0).
I have current events displaying on the front page via the civievent module that can't be 'seen' in the event dashboard (no current events showing) or in Manage Events (only some old events show here). If I 'Search All', I get a 'None Found' message even though there is also a message saying 'Event 1-50 of 224'. When I try plugging the ID of a current event into the edit URL for one of these old events I get the error 'You do not have permission to access this page'.
In case it's important, I have a 'Performance warning: Missing indices' alert on the status page, but the 'Update Indices' button does not seem to achieve anything as it comes back after confirming an update with the same Missing indices alert.


texts: Event Registration - Duplicate Matching Impossible

texts:
Our organizzation is running CiviCRM 4.6.8. We are setting up an event and participants can register online. while configuring the on-line registration page, we get the error:

  Duplicate Matching Impossible The selected profiles do not contain the
  fields necessary to match registrations with existing contacts. This
  means all anonymous registrations will result in a new contact.

We have specified a custom profile to register participants. The profile includes as mandatory field, the ID number of the person as per their South African Identity document or passport. This field will allow us to uniquely identify each participant.

We have also created a custom dedupe rule  (unsupervised) as follows:
Field -> ID Number
Length -> left this blank
Weight -> 30
Weight Threshold to Consider Contacts 'Matching': 30

Why do we get this error and how can we resolve it?
We need to ensure that a participant can register only once for this event, as it is a competition.


texts: crm-menubar.css not loading after upgrade to 5.35.1

texts:
My client's CiviCRM instance was 18 months out of date and we have finally bought it up to latest version Joomla (3.9.25) and CiviCRM (5.35.1).
I noticed the CiviCRM menu wasn't showing at the top of the page where it would usually be but it was displayed down the left hand side (and without styling). So I check if all of the css files were loaded and found crm-menubar.XXXX.css had a status of canceled.
Clicking the Reset Paths button brings a version of menubar.XXXX.css back for a while.
On further investigation menubar.XXXX.css is trying to be loaded from {Joomla_root}/media/civicrm/persist/contribute/dyn/ folder. Reset Paths definitely creates the file in that folder but the scheduled task Clean-up Temporary Data and Files removes it.
Is there a way to get the menubar.XXXX.css to persist?


texts: Display both regular and discounted fees in events page

texts:
is there a way to display both regular and discounted fees in an event page?

I would want to put the regular price under our Early Bird price.


texts:
Running Joomla 3.9.0
Civicrm 5.7.0
PHP 7.0.2

Recently update Civicrm to 5.7.0 - Prior version and my cron job was working fine. Now it hasn't run since November 7th

Run cli.php

php /var/www/clients/client1/web2/web/administrator/components/com_civicrm/civicrm/bin/cli.php -s domain_name.com -u user -p password -e Job -a execute

Output is

PHP Warning:  include_once(/var/www/clients/client1/web2/web/administrator/components/com_civicrm/civicrm/../..//default/civicrm.settings.php): failed to open stream: No such file or directory in /var/www/clients/client1/web2/web/administrator/components/com_civicrm/civicrm/civicrm.config.php on line 118
PHP Warning:  include_once(): Failed opening '/var/www/clients/client1/web2/web/administrator/components/com_civicrm/civicrm/../..//default/civicrm.settings.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/clients/client1/web2/web/administrator/components/com_civicrm/civicrm/civicrm.config.php on line 118
Could not load the settings file at: /var/www/clients/client1/web2/web/administrator/components/com_civicrm/civicrm/../..//default/civicrm.settings.php

I have looked at some of the patches. But the patches are older than the version I have.

Any help would be greatly appreciated.
Thank you


texts:
We recently ran our first civiEvent with online bookings (and quite complex pricing). I installed civiDiscount and configured two coupon codes for groups who should be free - the event organisers and the National Council of the parent organisation.
I set the discount level to 100%, and while the coupons were registered as having been used, it did not change the price on the registration form at all.
When I set one of the discounts to 99%, it worked as it should.
Fortunately, all our payments were offline, but it meant we couldn't report reliable income figures.

From my reading of the documentation, a 100% discount should be possible, so is this in fact a bug?

Richard


texts: Minor flaw in CiviCRM registration page for EFF

texts:
Excuse me for being OCD = perfectionist, but when RSVPing for an EFF event, there was no [register], [Submit], [Complete your registration] etc, but only a [Review your registration].
As a professional CRM company, I'd expect CiviCRM to have something this simple be correct:
Change the "review your registration" (which DOESN'T - you're LOOKING at your information right there!!) to "register".   Maybe you're thinking that it goes through an audit process making sure data is entered in the *'d (mandatory) fields.  But still... you are submitting the registration!
Thanks


texts: How to get the value of a disabled form field in webform civicrm?

texts: I have 2 radio buttons whose values I can access on page 2 using $form_state['input']['submitted']['nameoffield'] when the field is not conditionally hidden. When conditionally hidden however (and pre-filled) I can't access the value, presumably because the field is disabled. What is the best way to access a pre-filled civicrm value on the second page of the webform?


texts: I would like to know if it is possible to find a person on the database only with the CIVI number, and how can I do it?


texts: Removing Membership Status Message on Front End Webform

texts:
We recently sent out emails to our affiliates, providing them with a link outfitted with some checksum tokens. The link goes to a webform w/ CiviCRM Integration. The token and webform work fine -- they are able to fill out the required information and pay for their membership.

Some users, however, are getting confused by the message "x membership has a status of 'x'" at the top of the webform page, thinking that their membership is expired, cancelled, etc. based on what they see.

The organization, before my arrival, had tried to set up the membership feature, however it was never fully realized, leading to me having to create a new set of membership types to work with. I've gone ahead and expired the old memberships, re-titling the type to "2013 Membership", however that still leaves the aforementioned message visible to the person utilizing the checksum link. I could just delete the old membership type, as we plan to do a fresh install in the future without this information, however we have payments associated with the membership type that I don't want to go down that route, yet.

I'm assuming I'll have to make the change somewhere in a template file, however I wanted to check first before I go messing around with it, in case I'm missing an option somewhere inside the front end of Civi.

Edit: Here is an example of the message users see. I'm interested in removing the first line in the green box. Users will not see the second line as this is a new webform that everyone will be submitting for the first time.


texts: Getting Groups Associated with Campaigns using REST API

texts:
CiviCampaign allows you to 'include group(s)' as a part of a Campaign. Is there a way to 'get' which groups have been associated for a given campaign ID using the REST API? The GET API for Campaign doesn't provide this information.
(Sample result below of a GET for Campaign)
{

"is_error": 0,
"version": 3,
"count": 1,
"id": 9,
"values": [
    {
        "id": "9",
        "name": "AAA",
        "title": "AAA",
        "start_date": "2020-10-19 13:35:00",
        "campaign_type_id": "5",
        "is_active": "1",
        "created_id": "202",
        "created_date": "2020-10-19 13:36:07",
        "last_modified_id": "202",
        "last_modified_date": "2020-10-19 13:36:07"
    }
]}


texts: Our members often receive discounts in our community as a benefit to their membership. Is there a way to pull their membership data into an online membership card or something? I am just thinking like an image that pulls member's name, membership level, current standing, and member since date. Then member could either save it to their phone or print it out.


texts:
Since upgrading to 4.7.3 on WordPress, some of our Cases seem to be losing a relationship role.  They are not linked to the case from the contact record either, even after re-adding them to the case.  This is a custom relationship role.  Additionally, these contacts are not displaying a number of activities.  I'm assuming these activities are related to the cases, but since I can't see them, I'm just assuming at this point.  I don't see any activity in the CiviCRM logs.  Has anyone else seen anything similar?

EDIT:
On further digging, playing, breaking, reviewing, and linking, I believe that I have found a bug.  However, I'd love to see some confirmation.  I have a case, associated with a custom created relationship in a Case Role.  This is not the client, but a special type of case manager.  When looking at the case, everything appears as one would expect.  Clicking on this special case manager contact record takes me to the correct record.  However, there is no case listed in the Cases tab.  In the Relationships tab, the relationship to the case is there, along with the More -> Manage Case # link.  When I click on that, things do not show correctly.  There is shows the case name as the contact record and does not show the correct Role relationships.

Additionally, it is a very different URL structure. The case URL from the Case Dashboard looks like:

https://example.com/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fview%2Fcase&reset=1&id=32&cid=9462&action=view&context=dashboard&selectedChild=case

While the URL from the contact record Relationships tab looks like:

https://example.com/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fview%2Fcase&action=view&reset=1&cid=95409&id=32


texts: Certain Emails, not all are falling into SPAM

texts:
We have an install where on certain contacts if you send an email directly from the contact record it goes through correctly. If an email is triggered via CiviRules it goes to SPAM. The email content is the same as well as the from address. This also happens when emails are sent from CiviMail (traditional). We are using mail() for outbound mail.

Is there a process difference when mail is triggered by CiviRules or CiviMail rather then directly from the contact record?

Install is in WordPress 5.2.2 with CiviCRM 5.13.4.

The SPF record for the domain references the web server.


texts:
Our organization has families defined by relationships (but not put into households) and is looking to print a directory with a column of family members:

        NAME          FAMILY
        Bob Smith     Susan Smith (spouse)
                      Jimmy Smith (child)
                      Katie Smith (child)

I know I can export the spouse display name, but when I export "Individual > Parent of > Display Name" this only lists one child.

How can I export all children?


texts: I cannot find Participant Count and Max Participants in Edit Price option for price sets WordPress

texts:
In Drupal, I have the option in a price set, price option to limit the number of people who can book at a certain price.

I do not see this option in a wordpress install (civi version 5.13)

Do I need to turn this option on somewhere?


texts: I am looking to upgrade an extension - for now I have been updating extensions by disabling - then uninstalling the old extension - and then installing and enabling the new extension.  While that has worked for the most part, when I was going to upgrade Mosaico, I was worried if by using my typical method - I would lose all the templates I created.  With that being said - is there a better way to upgrade the extension - and if I do what I typically do, will I lose any data?


texts: Update smart group counts errors with syntax error (AND instead of WHERE in sql)

texts:
This is a bit of a corner case.  This is reproduced in http://d46.demo.civicrm.org.

Go to Contacts => Manage Groups

Click on Update Smart Group Counts (left side below the Find Groups box)

It will error with a syntax error.  It errors on the smart group LYBUNT.

This smart group was created with Search => Custom Searches => Contributions made in Year X and not Year Y.


texts: Outbound email configuration. Different sending addresses with different servers

texts:
We have an issue to solve to operate as well in our Country (Italy).

Any organization in our Country must use Certified Email (https://en.wikipedia.org/wiki/Certified_email) to send fiscal and official requests to public organization.
This create a config problem inside CiviCRM, which I try to explain:

we must use more than one address to outbound email
the normal address can send all, using the normal and easy configuration
the Certified Email address must use IMAP and the specific server to send messages
we didn't find a possibility to configure this difference
there are more than these problems to manage inbound email.

Any idea to solve it?
TIA


texts:
Bar and pie charts no longer render - and I didn't do anything on my end. I just get a little box now where there used to be a chart.

I've cleared caches and just did an upgrade from 4.4.5 to 4.6.4 in the hopes it would be solved - no joy.

Resources and extension directories are set; I'm stumped here. Any ideas? Thanks!

Further info:

Update: After turning debugging on and off (and seeing no errors), bar graphs now work on the report pages, but not in the dashlets, unless viewing the dashlet fullscreen, in which case they now appear. This is for Firefox and Safari; in Chrome, the graphs don't appear under any circumstances, even when viewing the full report. Hmmm...


texts: full-text search not working consistently; case search in custom field not working

texts:
First, I'll explain how I stumbled upon the issue. We need some serious, working search functionality.

I set up a custom field for cases. I set up the custom field to be searchable.

I then created a test case and populated my new field with latin text "Lorem....".

I then tried to find my new case with case search and "lorem" in my custom field. It couldn't find it.

I then tried to find the new case with the new field using "full-text search". It couldn't find it again. I then started testing full-text search. It seems to be hit and miss.

Perhaps it's user error, and in that case, please advise what I'm doing wrong. I would appreciate it.

For the following tests, I'm using "all tables" and yes, I have wildcards enabled.
Full-text search doesn't find "lorem" which is in my case custom field. Full-text search doesn't find "john" which is in the name of several contacts (john, johnson...).
Full-text search doesn't find "j" which is in many fields in many tables.
Full-text search only finds four hits for "a" which are all names of contacts.
Full-text search doesn't find "max" which is in at least four contact's names.
Full-text search does find three hits for "bob" all within contact's names.
Full-text search does find two hits for "sheep" which are all in case descriptions.

Can anyone shed some light on these inconsistent results?

Thanks so much!


texts: Problem with contribution - redirect to Home Page

texts:
I have two types of contribution page (for different purposes) one requires sign in and the other does not.
When a user goes to go to either contribution page for the very first time and clicks on confirm payment, the system goes into an endless loop that ends up on the Home page.  If from there one goes to the  contribution page again, it works fine.

Any Ideas what could be causing this?  Oddly it does not happen when someone registers to an event.

Please any feedback is welcome, I need this fixed before the end of ther year.

Thank you

Edited:

I figured out the problem, but not yet the solution.  it has to do with the URL intial URL has www.xxxx.com once it is sent back to the Home page the URL is xxxx.com (no www)

the setting in the civicrm.settings.php does not have the www.  Is this right???  should it have the www???  any help is appreciated.

thank you


texts: How can I hide contact tabs depending on user role?

texts:
I want to give all Drupal Users with a specific role access to basic contact information from our database, but I don't want them to see things like the list of activities, groups joined, notes, cases, etc.

Is there a way to give some users the ability to view only access to a specific set of contact data?


texts: Recalculating final payment value on Civicrm Webform

texts:
I'm trying to recalculate the final payment value of a contribute page that I'm using on a webform.

Depending on the value of certain fields recorded when submitting the form (the fields are custom fields attached to contacts), the membership fee needs to increase or decrease.

I've looked at the civicrm preprocess and postprocess hooks although it seems they're only called when the form is finally submitted. I need to chance the value before the form is submitted so the correct payment value is passed to the payment processor.


texts: Error messages galore from contact.php and mailing.php, but eveything works? Should I worry? how do I fix it?

texts:
I've just migrated a civiCRM instance from Joomla! to Drupal. Everything I've tried so far works and it's the best thing ever. I find everything we want to do so much easier to get around in Drupal.

One problem:

When a user makes a new account, using a civiCRM profile I've made, I get all these errors:

  Notice: Undefined index: contact_sub_type in
  CRM_Contact_BAO_Contact::formatProfileContactParams() (line 2010 of
  [redacted]/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php).
  Warning: in_array() expects parameter 2 to be array, null given in
  CRM_Contact_BAO_Contact::formatProfileContactParams() (line 2011 of
  [redacted]/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php).
  Notice: Undefined index: contact_sub_type in
  CRM_Contact_BAO_Contact::formatProfileContactParams() (line 2012 of
  [redacted]/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php).
  Notice: Trying to get property of non-object in
  CRM_Mailing_BAO_Mailing->getTemplates() (line 763 of
  [redacted]/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php).
  Notice: Trying to get property of non-object in
  CRM_Mailing_BAO_Mailing->getTemplates() (line 767 of
  [redacted]/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php).
  Notice: Trying to get property of non-object in
  CRM_Mailing_BAO_Mailing->getTemplates() (line 777 of
  [redacted]/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php).
  Notice: Trying to get property of non-object in
  CRM_Mailing_BAO_Mailing->getTemplates() (line 781 of
  [redacted]/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php).

They are filling in custom fields at this point of registration, and some of them are multi valued if that has any bearing on anything.

Also when updating details of a user I get:

  Notice: Trying to get property of non-object in
  CRM_Mailing_BAO_Mailing->getTemplates() (line 781 of
  [redacted]/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php).
  Notice: Trying to get property of non-object in
  CRM_Mailing_BAO_Mailing->getTemplates() (line 767 of
  [redacted]/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php).
  Notice: Trying to get property of non-object in
  CRM_Mailing_BAO_Mailing->getTemplates() (line 777 of
  [redacted]/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php).
  Notice: Trying to get property of non-object in
  CRM_Mailing_BAO_Mailing->getTemplates() (line 763 of
  [redacted]/sites/all/modules/civicrm/CRM/Mailing/BAO/Mailing.php).

Again, we are updating those custom multi valued fields using a profile. No, I tell a lie, there are still custom fields, but not multi valued ones here.

This does not happen updating user details using the civiCRM administrative interface. Everything is fine there.

Any hints what the issue could be? does it matter? I'm yet to find anything that does not work, it just regularly throws these errors up. It does matter from a user experience point of view, I at least want to hide these messages. I have not quite finished testing everything though.

This is also on new hosting, so databases have been restored and such. Possibly there is something this host is not doing? but I can't think what it could be.

[edit] Found something that does not work. Removing contacts from a group. When I remove a contact from a group they are immediately added back with a status of "Added (by API)" Date added being the time you removed the group. You see this immediately in the administrative interface. Not sure that this is possibly related.
[edit again] no, only some groups. Some groups remove just fine, I think this is group thing is a drupal group sync thing (greatest thing ever by the way!)[edit again] yes, group sync thing, I had an extra rule making a bit of an infinite loop: not related to the above problem. ignore this please.


texts:
I am looking for an elegant solution for the following. It shouldn't be very difficult but I am new to CiviCRM and I want to make the right decisions.

We only have one membership option. Members pay 10,- euro per year. This membership automatically renews until it is cancelled by the member.

If someone becomes a new member, there is a 'joining fee'. A new member pays 10,- extra. So in the first year a new member pays 20,-, in the following years they pay 10,- per year.

I want to use CiviSEPA to handle the payments.


texts: How do I reply to an email in CiviCRM (Activity or CiviCase)

texts:
I have CiviCRM set up to import e-mails that are sent to our main support desk.  These e-mails come in as "Inbound Email" activity types.  At this time we are manually importing those e-mails into a CiviCase case to keep track of them.

My question is how do you reply to these emails?  When I look at the activity itself, it does not have an option to reply.  When I connect the inbound email activity to a Case, I can compose a new email as an action in the case, but I still don't have an option to reply to an email.

By "reply to an email" what I am looking for is to have a new email window opened, with the email I am replying to already in the email compose window and quoted, and the subject set, and the "to" and "cc" lines set, so that I am all ready to compose a reply.

Is this possible?  Or is there an extension to support this?  It seems like such a basic function I'm really confused that I don't see it.

Thank you


texts:
i use wordpress 4.2.2 and civiCrm 4.6.3.
I have created a file CiviCron.php:

// create a new cURL resource
$ch = curl_init();
// set URL and other appropriate options
curl_setopt($ch, CURLOPT_URL, "http://www.auroratrezzo.it/wordpress/wp-content/plugins/civicrm/civicrm//bin/cron.php?name=user&pass=password&key=key-site");
curl_setopt($ch, CURLOPT_HEADER, 0);
// grab URL and pass it to the browser
curl_exec($ch);
curl_close($ch);

I have configurated cPanel cron job:

php /home/informac/CiviCron.php

I recived this error:

Fatal error:  Function name must be a string in /home/informac/public_html/wordpress/wp-content/plugins/section-widget/olt-checklist/loader.php on line 64

Why ??

Marco


texts:
Can I create a block like of CiviCRM autocomplete search using "Search AutoComplete" module?

https://www.drupal.org/project/search_autocomplete

I have tried to figure out but cant seem to work it out? anyone tried, any suggestion please?


texts:
I am currently trying to setup an online membership signup form for our organisation.

I am in the early stages at the moment but so far I have created the bare bones of the form by creating a profile containing the various fields that need to be on the form.
After doing this I wanted to test completing the form online so that members / organisations are added to Civi. When clicking on Use - Create mode I am able to view the form and complete it etc (This only appears however to be when I am still logged into my session). If I try the URL in private mode or on a difference browser then I get the following error:

(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.
The requested Profile (gid=16) is disabled OR it is not configured to be used for 'Profile' listings in its Settings OR there is no Profile with that ID OR you do not have permission to access this profile. Please contact the site administrator if you need assistance.)

What could be the cause of this?

The other issue I am coming across is that I want to use this profile via a Contribution page, however when setting up the Contribution page, under the profile tab section, the drop down Include Profile (top of page) will not list the profile I have created so I cannot add it.

As per below I have created a profile called "Membership Form" however this profile is not showing in the dropdown list to add to the Contribution page.

Any help would really be appreciated - I am pretty new to CiviCRM.

Thanks in advance everyone :)


texts: How to save a file in civicrm file table?

texts:
I planning to save the user submitted file in the civicrm file table.  I have tried these code to get the submitted file name, but it doesn't work
function postprocess(){
    $file = $this->_submitValues['uploadFile'];

}

Any help would be appreciated!
Update :
This is my code, i can get the title, option value except the uploaded file name.where am i going wrong ??
function buildQuickForm() {
    $this->add('text', 'title', ts('Title'),'' ,TRUE);
    $this->add('File', 'uploadFile', ts('Upload the file'),  TRUE);
    $this->add('select', 'option', ts('option'),
      array(
        '0' => ts('- select -'),
        '3' => ts('option 1'),
        '4' => ts('option 2')
      )
    );

    $this->addButtons(array(
      array(
        'type' => 'submit',
        'name' => ts('Submit'),
        'isDefault' => TRUE,
      ),
    ));
  }

  function postprocess(){

    foreach($this->_submitValues as $key => $values){
      civi::log()->debug($key);
      civi::log()->debug($values);
    }

  }


texts:
My organisation is primarily (but not solely) a network of other organisations, so on Civi we have lots of "organisation" contact types, and lots of individual contacts. Some of these individuals are representative or contact person of their organisation to our organisation. I use the relationship tool to connect individuals to organisations as respresentatives (I made a new relationship type), and that works really well.

Some organisations haven't nominated someone to be a rep, or we haven't got them into CiviCRM properly yet (we're still slowly setting up). What I'm struggling to work out is how to run a search of organisations which don't yet have that relationship type with anyone. Is this possible anyhow?

Thanks.


texts: I am trying to create an event report but I am not able to filter a specific event in the Event filter, it shows as "None found" even when there are active events present and there is no error in the browser console. Kindly help me to fix the issue.


texts:
Our volunteer group uses Civicrm. It runs under Drupal. We host with ..(cough cough) Godaddy. Recently their Cpanel automatically switched us from PHP 5.4 to 7 and our Civicrm 4.7.7 crashed with errors.

To cut a long story short after their techs told us it was a malicious attack, and we went into melt down changing passwords etc, we find it was simply the PHP version change.

So back on topic, we had our Civi working fine under 5.4php and after the crash we went back from PHP 7 to 5.4. Now just one of our reports throws an error:

Parse error: syntax error, unexpected 'class' (T_CLASS), expecting identifier (T_STRING) or variable (T_VARIABLE) or '{' or '$' in at line 304

Here is the code around line 304

),
      'civicrm_membership' => array(
        'dao' => CRM_Member_DAO_Membership::class,
        'fields' => array(
          'membership_status' => array(
            'title' => ts('Membership Status'),
            'name' => 'status_id',
            'default' => TRUE,

This is line 304 specifically: 'dao' => CRM_Member_DAO_Membership::class,

After doing some reading i found a statement that the use of the word class in php is a reserved word and shouldn't be used. Not really sure what that means. However Our report that was working no longer works.

Am i missing maybe a duplicate here or is it something more than i can handle?

Cheers and Gday from Australia


texts: How to remove an old email link from an event page

texts:
I have created a new event page and on the online registration page I have entered the 'Confirm From email' address that I want to use. However, when someone registers for the event the confirmation email is being sent to a different email address that was used for an event in 2018. This alternative email address was listed as disabled on the 'From email addresses' list and I have since deleted it but messages are still being sent to it from this new event page. I can't find anywhere in the CiviCRM system where this email address exists to change or delete this association with the event page.
Where can I look to edit or delete this association?


texts: Reply-to e-mail address using CiviMail in 4.6.3 defaults to system default

texts:
We recently upgraded to 4.6.3, and now the reply-to email address in CiviMail e-mails defaults to the system e-mail, not the From sender e-mail address, as previously. I could not duplicate on the demo site (at http://d46.demo.civicrm.org ), perhaps because the demo site is running 4.6.5.

A real bummer, any help fixing appreciated. Was this a 4.6.3 bug that has now been fixed in 4.6.5?

Thanks.


texts: How do I create recurring events in 4.6?

texts: I am using CiviCRM 4.6.8 and I don't find the new (supposedly since 4.6) recurring events feature. What am I doing wrong?


texts: Settings - Drupal Integration Not Listing Tables

texts:
When I go to the Settings - Drupal Integration page I do not see the print out of the array that needs to be added to settings.php. I know this was here before.

I have cleared the CiviCRM cache and the Drupal cache.

I am running CiviCRM 4.6.24.

Does anyone have any ideas?

Much appreciated.

Thanks!


texts: Why is there a Location Type AND a Checkbox for billing addresses?

texts:
In CiviCRM you have a location type named billing. In addition to that, there is a checkbox named "Billing location for this contact".

As far as i know, CiviCRM will use the address that has the checkbox ticked whenever you do things that require a billing address such as creating an invoice - the location type is not relevant (correct me if I am wrong).

Having two options to mark an address as the billing address is extremely confusing for users. The location type cannot be disabled either and renaming the label is obviously not a good idea either.

Can anyone tell me why billing addresses are handled this way? Is there actually a chance to change that in a future release and if yes what would be the requirements to do so?


texts: unsubscribe via email token gives wrong address

texts: The unsubscribe via email does not use the correct email address. I have "myname"@gmail.com but when I send a test it adds this strange email address u.77.3.61020d9ae6a273d5@gmail.com as the email address.


texts: What's the best way to make use of the GDPR extension's capabilities via webforms in Drupal?

texts: I've generally used webforms integrated with CiviCRM on Drupal sites for mailing list sign-ups. Been looking at how to simply link those with the GDPR extension so that the acceptance of privacy policy etc. is logged. Anyone got a slick solution?


texts: Live Paypal transactions showing as Test

texts:
I'm very nearly there with setting up PayPal Standard. I'm using WordPress 4.8.2 and CiviCRM 4.7.22 at present.

I have set up a PayPal sandbox account and everything seems to be working nicely with the exception that it is showing up as (test) in CiviCRM - it took me a while to work this out and find it in the contribution search. I am  definitely using the live link (if I use the test link, it goes to a different PayPal sandbox account that I have set up for that and that works as expected to produce a test contribution record.

I have tried it with a membership contribution and an event contribution. If I switch to the dummy payment processor (no other changes) it gets treated as a live contribution, so I think it must be something to do with PayPal but can't see how.

Is there some other setting I might have missed? Any suggestions very welcome.


texts: Multiple item tax sub-totals are shown incorrectly on confirmation pages and emails

texts:
We have a site with tax and invoicing enabled on contribution settings.
Drupal 7 civi 5.24.6
Where there is just one item to purchase on a page. The totals and subtotals appear as expected...
Payment amounts from Contribution confirmation page

Payment amounts from confirmation email

But when multiple taxable items are available on a contribution page the taxable subtotals show incorrectly...
Payment amounts from Contribution confirmation page

Here the total VAT (tax) amount shows as £260, when it should be £520- but both line items show correctly and the Payment Total is the correct overall total
Payment amounts from confirmation email

The email acknowledgement for these items is even more broken
The amount before tax shows £2860 instead of £2600, basically a tax amount has been added here.
total VAT line is fine at £520, but the Total Tax line is only showing £260
Again the overall total is correct.
Anyone any idea where these different amounts are being drawn from? How to correct this?


texts: I'm trying to disable a particular system workflow message from being sent out - "Events - Pending Registration Expiration Notice". I've had a look in the event configuration and have found nothing that would indicate being able to disable this message per event. Is there another place that this can be disabled?


texts: Import exceeding max. number of processes on host

texts:
Getting a 500 error on importing CSV content. Consulted with web host, who found the cause of the 500 Internal Server Error. When I click on the import more than 30 processes is spawned from my account. The limit on my plan is 30 processes and this causes the error as the limit is exceeded. The processes are:

Code:
php admin.php

They advised me to contact Civi or check the import settings in order to lower the number of processes spawned simultaneously. You should configure it to wait for the process to complete and then spawn new ones.

How do I do this?


texts: Best WordPress theme framework for correct display of CiviCRM?

texts:
For those who develop for CiviCRM on WordPress, what theme frameworks do not work with CiviCRM, what theme frameworks do work without problems, and which seem best for displaying CiviCRM content?

I've looked at Genesis, and Gantry.


texts: I'd like to remove some deprecated code from CiviCRM core, but I'm not sure if it might be used by other extensions in the CiviCRM universe. Is there a way to search the code of all known extensions?


texts:
Core updates are frequent, so are some extension updates.

How frequently do people update?   All of them or only sometimes?

Do you always up date to the latest version or pick one that is a little older?

How do you know the update is not loaded with dodgy code or ransomware?

Working with highly sensitive data and I am concerned about the vetting process for updates.

Thanks in advance


texts: Is there a way to display the latest mail in CiviMail?

texts: We use CiviMail for our organization's newsletter. In addition to a signup form, we would like to have a "click to view our latest newsletter" link which shows the most recent newsletter from CiviMail. Is there a way to automatically do this that doesn't involve changing the link manually every time a new newsletter is sent out?


texts:
As I understand it I can use CiviCRM's Access Control Lists to to control the groups that users can see and work with. But I'm not clear on a few points about this:

If a user does not have the permission to see a given group (for example in a list of groups) can they still see and work with the contacts in that group? Or to put it another way, when the ACL refers to a "group of contacts" does the permission that is granted by the ACL apply to the group, or the contacts within that group, or both?

And following on from that, if a contact is in two groups, and a user has permission to view one group but not the other, can the user see the contact at all?


texts: Profile is disabled OR it is not configured

texts:
I made the mistake of messing with an extension today, and now if I go to "search" for a contact using advanced search or find contacts, i receive this error: Sorry but we are not able to provide this at the moment.
The requested Profile (gid=24) is disabled OR it is not configured to be used for 'Profile' listings in its Settings OR there is no Profile with that ID OR you do not have permission to access this profile. Please contact the site administrator if you need assistance.

I have no idea what I would have done that would have triggered this error.  Any assistance would be greatly appreciated.

Thanks,
Matt


texts: Can Drupal Views filter contacts based on Smart Groups

texts:
Taking the liberty of creating this new ticket since the previously similarly titled (since retitled by me) post was not really addressing the issue.

Laryn is correct when he said on the above post that

  From what I can tell, this stale issue in JIRA is as far as it went towards integrating Civi Smart Groups into Views.

A lot of the discussion occurred in this forum post.

I am hoping a current project will help/force us to get back to this. But at this point the question is has anyone else either worked on this, or need this and could help fund us to deliver it.


texts: Outlook Extension / Filing previously sent emails into CiviCRM

texts: I just installed the CiviCRM Outlook extension and am finding it useful.  However, the right click menu option for recording emails that have already sent isn't appearing.  Changing my ribbon settings in Outlook are also not working.  Anyone have an idea of what to do? Are there other ways to record sent emails to CiviCRM?


texts: Domain Access and CIVICRM ACL of data and drupal

texts:
I have CIVICRM Drupal 7 install with several sub-domains. It's working fine until I have tried to control access to contacts based on the subdomain/drupal users and their roles.

I have tried following the guide from the CIVICRM documentation here

However, I am finding it a little confusing as it appears to refer to both ACL "users" and "roles" and CMS "users" and "roles" interchangeably though they clearly are not.

I am trying to achieve more-or-less the exact example case given on the page:

  A charity based in Chicago has three regional offices, and needs to give its fundraising staff the ability to create and edit contact records for prospective donors. They have decided that the fundraising department in each office can only have access to its local contacts. While the permission add contacts can be granted to authenticated users in the CMS (Drupal, Joomla! or WordPress), if view all contacts and edit all contacts were also assigned in this way, there would be no way to differentiate between the three groups of donors (locations). This could only be achieved with a CiviCRM ACL

I would like to also have certain groups of contacts - created by specific drupal roles - also propagate to all users.

The article explains in some detail how to create CIVICRM groups anf ACL roles but not how to link them to Drupal roles or the domain of origin of a contact.

How would I do this, or is there a reasonable guide to achieving such a setup?


texts: Create User Account profile creates error Undefined index: location_type_id in CRM_Dedupe_BAO_Rule

texts:
Drupal 7.59
Civi 4.7.27
Webform 4.17
Webform CiviCRM Integration 4.20

We are in the process of switching over from WordPress to Drupal for our CMS.

With the /user/register, when you click Create Account it does create a Drupal User and a Civi  Contact. However you get the following error message.

Notice: Undefined index: location_type_id in CRM_Dedupe_BAO_Rule->sql() (line 96 of */sites/all/modules/civicrm/CRM/Dedupe/BAO/Rule.php).

Where do I edit this form to change the location type (I am assuming it is the address that is mislabled)?


texts:
I am working on a redesign of an existing site.  I've gone ahead and created a local site and imported the CiviCRM database.  The client wants to allow the user to add a discount code while subscribing to an on-line magazine (part of the redesign).  I've followed these directions https://wiki.civicrm.org/confluence/display/CRMDOC/Extensions and got to installing the manage extensions page where when I click on the install CiviDiscount Module Extension it redirects me to the log in page on the live site.

I am thinking that there must be a configuration issue somewhere.


texts: Blocking Double Click on Form Submit Button

texts:
I have a pop-up that loads a form. Currently the user can double click the submit button on the form which results in multiple submissions. This can cause some serious issues depending on the purpose of the form.

Any suggestions on the best way to block double click of submit buttons on forms loaded within pop-ups?


texts: What is the best practice for tracking total number of attendees?

texts:
I have been using activities to track "events" for my Church. These are not events that one would register to attend but rather things like Bible Study, Sunday Worship, etc. I've been double working by creating the activities and then creating drupal nodes for the public calendar. I don't want to have to do that anymore. I tried to find a way to get an Activity feed from Civi (with ability to filter by activity type) so that I could use Feeds in Drupal to import them to nodes but could never find a solution. Events has a feed that works with Feeds and so I'm thinking of moving to using civiEvent to track these. Here's the issue....Most of these "events" we don't track who actually attends but instead only the total number of people in attendance. I thought of creating custom fields to input this on the Events but that then shows that data publicly when the Event is viewed.

Any suggestions on how I can stop double working and still be able to track this information?


texts: Howto Edit the billing name on a billing address

texts:
CiviCRM 5.16.3

In the billing address section on contact view, we can see a full Name and Address. When we edit or quick edit the contact, the full name is not seen or editable. How can we edit it?

Note: as to how that name is getting there, my current guess is via webform civicrm or an extension but I need to verify. I believe what is happening is someone is using another persons credit card to pay, and it's updating the billing address with that persons name. Then, when a receipt goes out in the future, some of our templates are pulling that instead of the billing name/address used in the checkout form (I think..)


texts: Scheduled reminders have stopped working in v.4.7.8

texts:
Just discovered that scheduled reminders have stopped working and appear to have done so since updating CiviCRM to v4.7.8 on 3rd June.  The following error message is in the scheduled jobs log:
Summary
Finished execution of Send Scheduled Reminders with result: Failure, Error message: Cannot build query. Variable "@memberTypeValues" is unknown.
Details
Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}

Full message:
Finished execution of Send Scheduled Reminders with result: Failure, Error message: Cannot build query. Variable "@memberTypeValues" is unknown.

Other points to note:

Wordpress version 4.5.2
Other CRON is working
No extensions are installed
Scheduled mailings are going out OK

Can anyone tell me where I should be looking for errors or are there any known bugs?
Many thanks


texts: Can I run a Test Installation? If so, how?

texts:
I'm part of a non-profit organization - the Center for Jewish Nonviolence - that is looking to use CiviCRM. We are very impressed with what we've seen on your website thus far and want to move forward but have two outstanding questions.

First, can Civi be downloaded onto an individual computer and played around with? How so?
The hope is to test out the system itself (outside the demos) and get started with our work.

Secondly, if we wished to start an account now then delete it, would that be possible?

I've read through the first part of the guide and can't locate an answer to my questions. Could you let me know how to proceed or point me in the right direction?

Thanks so much!

Sincerely,
Michael D. Evers


texts:
Editing a custom message template and am trying to insert an image from the wysiwig editor. Link shows up as:

I tried editing to

 Still doesn't work.

What am I missing?

Thanks,
Kate


texts: Idea for extension Someone Else Pays - any feedback?

texts:
We are thinking about creating a native CiviCRM extension Someone Else Pays.

In CiviCRM you could use the soft credits (with a new soft credit type) to register another contact pay for an event registration, a membership and in theory any contribution.

Our customer Domus Medica is using that at the moment. We encounter some issues though. Some of the issues are possibly bugs but some are also because we think soft credits is originally not meant to cater for this. It was meant to cater for soft credits. So we prefer to create an extension rather than fix a few issues in a hackish way and then finding out we have some more.

At this point in time our thinking would be to:

generate a new table (sep_contribution_payer) where the contribution_id and the paying contact_id are stored if there is a different payer
add a new collapse window on the contribution forms (also membership and event registration) to show this link if it is there, and enable the setting of 'someone else pays' in the UI
create API's (get, create, delete)

Any comments, suggestions, tips, offers to co-fund?


texts: CC Option in Contribution - Email Receipt

texts:
I need my Receipt to be CC'd to specific (Sponsor of the user) whenever I email my receipt to the actual user - How do I achieve this?

Note: each user will have a different sponsor

Is their a way I can do ?

Or do I have to add CC option in the Form ?

Thanks in advance


texts: Does anyone have recent experience with CiviCRM for RSForm?

texts:
This Joomla plugin is supposed to provide the ability to update a civiCRM contact record based on a matching email address submitted in an RSForm submission.

Does anyone have recent experience with this plugin? Will it work with latest RSForms and civiCRM 5.21.x?


texts: Pledge payment off contact dashboard: "DB Error: No Such Field"

texts:
Drupal 7 / CiviCRM 4.7

When I create a Pledge and view it in my contact dashboard, I can see all of my pledge payments and their dates. If I select "Make Payment" it sends me to a page like: civicrm/contribute/transact?reset=1&id=31&pledgeId=3 and then errors out, "DB Error: No Such Field".

Is this implemented currently in CiviCRM, or is there a configuration missing?


texts:
My european organization (~ 500 members) wants to buy a membership software. So far we have used a german site, but due to their advertisements within e-mails sent by us, we are not satisfied. In addition, e-mails are not registered by my club as its sender, but an extremely spam-suspicious address is generated (e.g. 1239123jasdka83@[member sofware].de) and our mail is sent to the respective member. This is not a sign of security or quality. Therefore we would like to use new software.

The following points are extremely important to us:

Automated/semi-automated member maintenance: We do not want to enter member data manually on the software. Therefore it is possible to link an online membership application (already existing) with the software or can it connect to our website for the membership application?
Automated direct debit procedure: It must be possible for contributions to be collected from members on a specific date or other day, depending on their profile. If it is possible, how long should it take to set up automation?
The automated direct debit system must be compatible with our membership fee schedule: there is a deadline, assumed to be 01.01, where fees are debited from all members. This day is therefore fixed. If a member joins, 2 months or less before the next deadline, he only has to pay the fee on the deadline.
If a member joins, but more than two months before the next key date, a full membership fee will be deducted on his entry date. In addition, a regular membership fee will be deducted on the 01.01. key date. Can this unique constellation be mapped in your software?

To the another important point:

Emails must be able to be sent from OUR mail address to members. The mails must of course arrive without advertising.

If the above three points are feasible, we are interested in any appropriate software and would like to get an estimate of the monthly/annual costs and how to proceed.

Thank you for your helpful answers.


texts: Alternatives to editing civicrm.settings.php

texts:
The drupal hosting system that we are currently using prevents us from making any changes to civicrm.settings.php which I find is sometimes necessary or at least the most sensible solution in certain situations. (One example is to set domain IDs when using Domain Access.) I believe the file is regenerated regularly so changes wouldn't last long anyway.
I am hoping that someone who knows what they're doing can suggest an elegant way that I could put any code meant for civicrm.settings.php in another file elsewhere, preferably on the site level for multisite situations.

Thanks!


texts:
I wrote an custom contact import script for our NGO. The old contact data only contains valid country / state abbreviation names. For example CH / ZH = Switzerland / Zürich.

When I now want to create a new address over the API I don't see a way to fill out the 'state_province_id' field.

I'm able to get the country id with this syntax:

$result = civicrm_api3('Country', 'getsingle', array(
        'sequential' => 1,
        'return' => "id",
        'iso_code' => $row["V"],
    ));

if(isset($result["id"])){
   $params["api.address.create"][0]["country_id"] = $result["id"];
}

But how can I do the same with the State/Province, since there is no  entity I can choose in the API?


texts: Can a person inside a group be granted ACL Access to the group?

texts:
I've been trying to set up ACL's for a number of different chapters in a national organization's civicrm.  The idea is that the secretary for each chapter would be able to access members in that chapter and update their information.

So I
1.) Keep track of who is a member in the chapter through relationships between the members and the organization contact record for the chapter.
2.)Created a smart-group that generates a list of members who have an active relationship with the organization's contact.
3.) Created an ACL group and added the chapter's secretary
4.) Created an ACL Role for the Chapter
5.) Assigned the ACL group for the chapter to it's ACL role.
6.) Created several rules (view the group (which in this case is the smart-group based on the relationships), edit the group, edit custom fields)

However whenever I login as the secretary for that chapter, I am unable to view the members of the chapter, or my own civicrm contact page.

When I do the same with a 'test' login, it works.

I suspect that there is something weird happening because the contact for the chapter's secretary is in the smart-group that I am assigning them to have these ACL rules over.

Has anyone else had this problem?  Am I just doing it wrong, or is this some kind of bug?

Thanks,
Matt.