# Question
Title: Civi contribution details correct but why does Paypal log show wrong name?
So, person 1 pays membership fee using credit card via Paypal standard. Transaction goes through fine. Membership record is updated correctly

On the Paypal log however the payment show as for person 2; but when you drill down it then shows it correctly for person 1. In Civi, Person 1 and Person 2 have a relationship

Out of a few hundred recent payments I can see 2 that this has occurred for: its not a show stopper but Im curious about why?

# Answer
Is there any chance that Person 1 may have used a PayPal account or credit card belonging to Person 2? We'll frequently see payments that have different names: if I pay with your card, from PayPal's perspective, you've made the payment even though I've entered my name as the contact in CiviCRM.
> 2 votes

---
Tags: civimember, paypal, logs
---


title: civi crm get request not working

text:
# Question
Title: civi crm get request not working
I'm working on a ruby on rails application and trying to pull data from a civi crm server. I'm sending the get request from Rails but ending up with

```
{"IP":"some IP","level":"security","referer":"","reason":"Destructive HTTP GET","is_error":1,"error_message":
"SECURITY: All requests that modify the database must be http POST, not GET."}

```

Can someone tell me why is that and how to get data from civicrm server?

# Answer
Please post the full url you call, but you probably have an error on the url, it should have an action=get (or getcount or get\*) param. If it doesn't, it blocks the access, because it doesn't know it's a read only action that can actually be performed over a GET method

However, as Jaap mentioned, I would recommend you to use POST all the time, no matter the action you want to perform, it's easier and cleaner.

FYI, in my client libraries, I tend to have the action+entities as get param and all the rest into post. The main reason is that it's giving cleaner logs to help understand what's going on, without leaking any sensitive information

Please share if you write a gem to wrap up the rest call inside a ruby framework, I'd be interested to use it on one of my project (sinatra, but probably going to work the same)
> 2 votes

---
Tags: api
---


# Question
Title: Could anyone review our extension for donation receipts?
We developed an extension for issuing donation receipts. Initial development was funded by seven German organizations and they just released the extension under a free license.

It can be found in the CiviCRM Extension directory some documentation is in the CiviCRM Wiki.

Would anyone who is eligible to do so review the extension so it can be marked for automated distribution? Obviously everyone is also very welcome to test the extension's functions and provide feedback ^\__^

Thanks!

# Answer
Awesome

Did you look at the extension from Karin? Do you know how it compares? https://civicrm.org/extensions/cdn-tax-receipts
> 1 votes

---
Tags: civicontribute, extension, contributions, receipts
---


# Question
Title: When should I use activities vs. events?
If I have a weekly (free) meeting and I want to track attendance, is it better to use an activity or an event to do so? What are some of the pluses and minuses of each? Please define the differences.

# Answer
Jon -

If you use events to track your attendance, you actually get the benefit of both (since event registrations also generate activities). :-) Depending on your version of Civi (which unfortunately you didn't specify), you may be able to create your event as a recurring event. You could then import your attendance lists (assuming of course all your attendees are already in Civi; if not, then you'll need to import the contact info first, *then* import the participant records).

My thought is that if you go ahead and go the route of events, you're already situated to take online registrations down the road if that becomes a need, and/or to register people in advance and then send scheduled reminders. I think that going the activity route might work quite well in the short term, but prove limiting in the long run as your needs and use of Civi evolve.

Hope this helps, Lesley
> 10 votes

# Answer
The big differences in my mind are publishing and participant attributes.

An event comes with an info page, which can contain a location and map. Likewise, you can allow participants to register directly. Those are nice features, but they require setting up the text, location, registration fields, etc. An activity doesn't need any of this, but it will neither display anywhere on your site nor allow for people to add themselves.

An event also allows for details of a contact's participation in it. The participant record (which connects one contact to one event) has a status, role, and registration date along with the potential to record additional information. On an activity, a contact is the source, target, or assignee, but that's it. If you remove them from the activity, they're gone--there's no way to indicate they were supposed to join but cancelled. Similarly, there's no way to say that these people want barbeque and those people want a veggie plate. Finally, if you have more than 20 or so attendees, an activity's attendee list can get unwieldy: after a certain number of targets or assignees, CiviCRM won't let you remove people from an activity via the user interface.

There are further distinctions, but these are the big showstoppers: if you want the meetings listed on your site or you want to distinguish among attendees, you've got to use an event. Events are more complicated to set up, but with the event template and recurring event features, you can cut down on the amount of setup.
> 4 votes

---
Tags: civievent, activities
---


# Question
Title: Finding memberships with 'Status Override' set
I was asked recently if there was a way to find all members who have the 'Status Override' setting turned on. I didn't see an option in the advanced search or member search:

As an alternative, I made a smart group that finds all **Primary Members** that have a **Membership Status** of "Current" and a membership **End Date** in the past (e.g. "Prior to previous day"). This should find all memberships that are hard-coded as "Current" although they are technically expired (right?) but is not actually finding all overridden memberships.

Is there a way to search on whether the membership status is overridden, regardless of what the status is?

# Answer
> 4 votes
CiviCRM has a search builder and the field Override status is available in the search builder.

# Answer
> 1 votes
Search Builder will do this. Select `Membership` `Status Override` `=` `Yes` and it'll return the contacts with that.

# Answer
> 1 votes
Yes, there is in 4.7/master. I submitted CRM-17364 with patches, but an alternative/tidier patch was accepted into master only.

---
Tags: civimember, search
---


# Question
Title: Why do field labels in Event Registration forms not display correctly
I am using Civievent in version 4.6.10 with Wordpress 4.3.1. Have set up a training event and using a registration form. When I display the form in Test mode it works fine, but when in Live mode the field labels do not display - I just get the * for the required fields and the box to enter the data. Even stranger, when I look at the HTML code that is generated, it looks identical for this section - the label text is in the code for every field! If I try and submit the form without entering any data, I get the error messages as expected for the compulsory fields, but the field labels are then displayed, just for the compulsory fields! Any ideas anyone?

I have used both a preset profile and a customised profile to generate the form, with the same result.

# Answer
> 6 votes
This is specifically a problem with Bootstrap. In its infinite wisdom, it has laid claim to the class "label" to display an element like it's a tag or label. Unfortunately, you just have to add the following CSS, which overrides everything that Bootstrap adds:

```
.crm-container .label {
  display: inherit;
  padding: inherit;
  font-size: inherit;
  font-weight: inherit;
  line-height: inherit;
  color: inherit;
  text-align: inherit;
  white-space: inherit;
  vertical-align: inherit;
  border-radius: inherit;
}

```

Big picture, this is a deep-seated problem with Bootstrap: the class names it uses are way too broad and common. Other UI frameworks play much more nicely and prefix their magical classes with something that'll avoid this kind of namespace clash.

# Answer
> 2 votes
The problem was in the 'label' element in the CSS - the theme I am using set the label to white color, because within the main theme it is used for labels on buttons, normally white on a colored button. I edited the Civcrm CSS file to override the color. Just means I have to remember to re-edit it whenever there is a CiviCRM update!

# Answer
> 0 votes
That sounds like a css problem. Can you do "inspect element" where you would expect the label and find out if the label text is made invisible, or transparent or the same color as the background?

A good place to change CSS problems with your template like this with is to add an extra css file to your filesystem and then add it to "Custom css URL" in Administer - System Settings - Resource URL's.

This way upgrades of your theme and an upgrade of your CiviCRM will not impact these CSS overrides.

# Answer
> 0 votes
You can change this with the help of civicrm element class or you can made changes in civicrm css because if you apply css based html element then it will apply to all the element.

---
Tags: civievent
---


title: Mandrill extension error

text:
# Question
Title: Mandrill extension error
I have civicrm 4.6.5 running on Drupal 7.38 with the Mandrill 2 extension for bulk email. I set up a webhook in mandrill to speak to civi and I sent a test bulk email (including fake email addresses) with mandrill to make sure it all works. It all works fine except that Mandrill has been sending me 6 bounce notifications per ever since that email which included 1 fake email address.

mandrill posts this error under the webhook : Error: POST to https://www.msite.org/civicrm/ajax/mte/callback?mandrillSecret=\*********989c failed with 500:

Drupal posts :Notice: Undefined index: event in CRM\_Mte\_BAO\_Mandrill::processMandrillCalls() (line 84 of /srv/bindings/.../code/sites/all/extensions/biz.jmaconsulting.mte-2.0/CRM/Mte/BAO/Mandrill.php).

# Answer
Could this bug be your issue: https://github.com/JMAConsulting/biz.jmaconsulting.mte/issues/93
> 1 votes

# Answer
It happening due to fake mail id. You are getting 6 time same error because it will configure in mandrill account to send mail in maximum 6 attempt.

To avoid this error please validate the email id before sending the mail.
> 0 votes

---
Tags: mandrill, bounce
---


# Question
Title: Why does the mailer processQueue method 'shuffle' the array of possible locks?
https://github.com/civicrm/civicrm-core/blob/a2976e7c0c2515379e98ee9b5ebcf51acde4e540/CRM/Mailing/BAO/Mailing.php#L2867

```
  $lockArray = range(1, $mailerJobsMax);
  shuffle($lockArray);

  // check if we are using global locks
  foreach ($lockArray as $lockID) {
    $cronLock = Civi::lockManager()->acquire("worker.mailing.send.{$lockID}");
    if ($cronLock->isAcquired()) {
      $gotCronLock = TRUE;
      break;
    }
  }

```

Why do we randomise the order of the array using shuffle()? Is there a good reason for doing this?

# Answer
> 3 votes
I don't know the original authors' intent but can find some background and share a theory:

1. *Background*: To figure out the origin of some code, it sometimes helps to spot-check the branches in the old Subversion repository. This can require a bit of digging (to trace through incidental merges and cleanups in the history), but ultimately the `shuffle()` originated in r35243 and CRM-8460. Alas, there's no commentary in there about this detail. You could ping the original author.
2. *Theory*: Statistically, shuffling reduces the number of lock-acquisition attempts in one typical scenario. Suppose you're starting up a bunch of workers at the same time. (Maybe you're starting 5 workers, but you've set a limit of 10 workers.) Compare what happens with and without random polling order:

* (Without `shuffle()`) When worker #2 starts and tries its first attempt at lock-acquisition, there's a 100% chance of failure, so it will have to do a second lock-acquisition attempt. Similarly, when worker #3 starts and tries its first lock-acquisition, there's a 100% chance of failure.
    * (With `shuffle()`) When worker #2 starts and tries its first lock-acquisition, there's 10% (1/10) chance of failure. Similarly, when worker #3 starts, there's a 20% chance.

Now, even if we accept this theory, it might not amount to much. In a typical Civi deployment, you have a single server with maybe 1-10 workers, and locks are acquired infrequently. The total overhead isn't very high (esp. in comparison to the work being done). However, if one had thousands of workers, or if the communications channels were slow, or if you had to acquire the locks frequently (every second), then it would add up... so it wouldn't be surprising if some folks viewed it as a generally good practice to shuffle when polling.

# Answer
> 0 votes
~~There doesn't seem to be a good reason, so: https://github.com/civicrm/civicrm-core/pull/7338~~

Tim's answer demonstrates that there is a good reason, so PR closed =\]

---
Tags: civimail, php
---


# Question
Title: What is the status of the make it happen for permissions on activities and cases?
The make it happen listed here is something we're interested in having. What does it mean to be a "confirmed" make it happen? Is this particular capability coming soon?

(I emailed the make it happen lead and one other address associated with make it happen and haven't heard anything yet) Thanks!

# Answer
> 2 votes
The project has been funded for a "phase 1" MVP targeting 4.7 release in late January, which in brief will:

* Provide an acl hook for cases and option lists
* Not create a UI at this time
* Leave the door open for other entities to be affected by this hook such as activities, but that work will likely be 6 months or so away

---
Tags: activities, civicase
---


title: How do I change price after X years?

text:
# Question
Title: How do I change price after X years?
I'm setting up a Civi install and i'm wondering how to go about these requirements:

* Residents who join in their first year pay $40 for the duration of their graduate medical training program. Residents who are in their 2nd or last year of their training program pay $20 each year.
* Medical students who join in their first year pay $20 for the duration of their undergraduate medical training program. Students who are in their 2nd or last year of their training program pay $10 each year.

Can we dynamically change the membership amount somehow?

Thanks

# Answer
> 3 votes
I'm a little unclear about the requirements, but if the status of a contact's year is known then perhaps you can use CiviDiscount.

Automatic discounts can be applied to existing members and contact types.

---
Tags: civimember
---


# Question
Title: Civicrm 4..6.10-drupal is missing directory CRM/common
Upgraded from 4.1.15 to 4.6.10 with no errors, setup file system ownership & permissions, cleared template\_c cache, ran drush cvapi system.flush Working but layouts are wrong and the log file contains errors with "User warning: Smarty error: unable to read resource : "CRM/common/action.tpl" in trigger\_error() (line 1094 of ../sites/all/modules/civicrm/packages/Smarty/Smarty.class.php).

Directory modules/civicrm/CRM does not contain a common directory.

# Answer
> 2 votes
Ive resolved my issue by drilling into the fine Civicrm template documentation. The log file leaves out the initial part of the directory so whats being referenced is actually sites/all/modules/civicrm/templates/CRM/common which does exist in 4.6.10. Whats missing is the file action.tpl, it was present in Ver 4.1.

Root cause though was having an old custom tpl file in sites/all/civicrm\_templates/CRM/common which called action.tpl.

Fixed by deleting the old custom tpl files, then working through the version control checking the issue documentation to see if custom tpl files are still needed.

# Answer
> 0 votes
Yes, I have also get the same issue today after upgrading the civicrm. Common folder is missing from all 4.6.10 version.

---
Tags: installation
---


# Question
Title: Assign civi group by membership subscription?
Is it possible to automactically assign contacts to a civi-group by membership subscription?

Then when membership expired or remove contacts will be remove from that group?

We need it for our joomla website so we can assign user to a joomla group by this plugin here https://github.com/lcdservices/CiviCRM-Group-Sync (we tried using civi-authenticate plugin for joomla, but thats dont work properly)

We are struggling, so will appreciate any help.

Thanks Julash

# Answer
> 1 votes
in principe you could do that with the CiviRules extension (which you can get from https://civicrm.org/extensions/civirules). With this extension you can set up a trigger 'new membership' (or possibly a change of membership status?), add a condition for the specific membership type if required and add an action to automatically add the contact to a group. There is a cookbook on CiviRules on the Wiki documentation: http://wiki.civicrm.org/confluence/display/CRMDOC/CiviRules+Cookbook

---
Tags: civimember, joomla, groups
---


title: Is CiviCase suited for this scenario?

text:
# Question
Title: Is CiviCase suited for this scenario?
CiviCRM Version : 4.6.10
Joomla Version : 3.4.5

Is CiviCase suited for the following scenario? If so, out of the box? Or would it need to be extended?

Scenario:
Member opens a case (on front-end) to begin process of earning certification
2 Path Options:

* 1. Earn (defined # of) credits over a set period of time (by attending courses).
    + a. Org Staff adds approved (3rd party) credit courses to system (not CiviEvents).
    + b. Courses viewable by member on front-end (case management).
    + c. Member checks a course once attended/completed.
    + d. Course credits are applied to Member Certification Credits.
    + e. Once required amount of credits are earned, Member requests certification approval.
    + f. Org Staff confirms credits actually earned (against rosters), Approves/Denies Certification.
* 2. (Pay For) and Download exam to complete and submit to Org Staff.
    + a. Member submits payment via front-end form
    + b. Thank you page displays link to downloadable exam
    + c. Member completes exam and submits to Org Staff (via email/snail mail)
    + d. Org Staff Approves/Denies Certification

Already using Civi for Membership/Org Events, etc.
Want to keep this functionality within Civi, it is our current members that will be applying for the certification.
Again, the courses are via a 3rd party, we do not want any involvement setting them up in Civi Events. Only to put them in a list of pre-approved creditable courses that the user can check off.

# Answer
> 2 votes
It wouldn't do this out of the box. You've indicated you don't want to use CiviEvent but if you did then you would be able to do online payments. You could use CiviContribute too for online payments.

Something like Moodle might be a better fit.

# Answer
> 1 votes
I see you are using Joomla.

If migrating to Drupal *would* be an option, this would give you very powerful features for frontend exposure of forms and data to your users. The Drupal modules Webform and Views are deeply integrated with CiviCRM, so you can - for example - let users view and edit their case activities in very flexible ways. And that's a crucial part of your project, If I understand it right.

Since your process is not a small task to implement anyhow, switching to Drupal might be worth considering to get this powerful functionality.

To answer your question: With Drupal views and webforms, I would see a chance to manage your processes with CiviCase. To go ahead, I would recommend setting up a Drupal development environment to build a prototype and see what works for you and what doesn't. With Joomla or Wordpress, such functionality does not exist (yet), but I also have to admit that I'm less familiar with these CMS.

---
Tags: civicase, joomla
---


# Question
Title: Drupal Views Field: Relationship Type B-to-A?
I'm creating blocks to show a Drupal user's relationships on their user page. I've been able to create the views necessary to show the Display Names of the contacts in both the user's A to B relationships and of B to A relationships. I'd like to display the name of the relationship as well for each contact. **There is a Views Field for Relationship Type A-to-B, but I can't find a Relationship Type B-to-A field. Any ideas?** If one does not exist or cannot be created by tweaking something in the Views UI, how would I go about creating the field in code?

Drupal 7.41, CiviCRM 4.6.6, CiviCRM\_Entity module 2.x

# Answer
It is correct that not all fields from the CiviCRM RelationshipType entity are available in the the views by default. The socialistic party in the Netherlands had the same problem. And I created a drupal module for them to fix this.

You can find the module at https://github.com/SPnl/nl.sp.drupal-civicrm-views-enhancement

This module adds the name-a-b, label-a-b, name-b-a, label-b-a, contact-type-a, contact-type-b, contact-sub-type-a, contact-sub-type-b, description, is-reserved, is-active to drupal views.
> 3 votes

---
Tags: drupal, drupal-views, relationships
---


# Question
Title: Can I avoid HTML formatting being escaped during API import?
I need to import HTML formatted content to a custom event field for a larger number of events.

During import via the API, HTML tags are being escaped and rewritten: `<a href=“https://example.com“>Linktext</a>` becomes `<a href=“https://example.com“>Linktext</a>`.

Is there a way to avoid this and preserve the tags as they are?

# Answer
> 5 votes
You can edit /CRM/Utils/API/HTMLInputCoder.php: CRM\_Utils\_API\_HTMLInputCoder-\>getSkipFields returns a list of fields that will be skipped on encoding. Add an entry for your custom-field to this list prevents the html-input from being escaped. The entry must be "custom\_" + custom-field-id.

---
Tags: api, import, html
---


# Question
Title: How to modify the country list and their id?
I would like to edit the country list to add some countries, for example British West Indies. How do I do that? directly into the table civicrm\_country?

I also want to know if I can add my own dropdown custom field with my own key-value country list. It seems I can only add 10 choices, and then one by one. Isn´t there a way to paste my key-value country list into a field?

Many thanks!

# Answer
You can obviously edit the data directly in the table. Extension https://github.com/CiviCooP/org.civicoop.general.api.country provides an API for Country, you could use that as well
> 4 votes

---
Tags: county
---


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

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

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

This is Civi 4.6.10, Wordpress.

# Answer
In your own cron job you could reload the cache for groups by calling civicrm\_api3\_job\_group\_rebuild() (https://github.com/civicrm/civicrm-core/blob/master/api/v3/Job.php#L629), then cycle through the group to fill your custom field.
> 1 votes

---
Tags: hooks, developer, smartgroups
---


# Question
Title: Customers Recieving Error Code on Renewal
When customers try to renew their membership through our normal form, they recieve this:

"Payment Processor Error message: 1: 103 This transaction cannot be accepted."

Not sure what this means or how to fix it, but many of our customers can't renew their memberships because of this.

I wonder if this has anything to do with the technical updates that Auth.net did in mid-August?

Any help would be appreciated.

# Answer
It sounds like an Auth.net password issue. Check this out from their support page on the 103 error:

> This error is generated when your Authorize.Net account is in Password-Required Mode and you are not sending a valid Transaction Key or hash fingerprint with your transaction request.

https://support.authorize.net/authkb/index%3Fpage%3Dcontent%26id%3DA852
> 1 votes

# Answer
It happened when authorized account in password required mode.

https://support.authorize.net/authkb/index?page=content&id=A852

To fix this issue remove the password protected mode in authorized. net account. Below I have mentioned the steps to turn off password protected mode.

To turn Password-Required Mode off:

Click Settings under Account in the main left side menu.Click Password-Required Mode under Security Settings.Uncheck the box next to Require Password for ALL Transactions.Click Submit.
> 0 votes

---
Tags: authorize.net
---


title: Imports timing out

text:
# Question
Title: Imports timing out
I'm having troubles with large imports of any sort (contacts, memberships, etc.) if the file is too large (over 2000 rows) the operation seems to time out. The import stops and the wordpress login page loads.

When I check on the import it seems to have stopped half way through with only some of the records imported.

Is there a server setting I should adjust to fix this?

# Answer
This could be due to the max. execution time (php limit) which is a server setting. Whether you can adjust it depends on your hosting arrangement so you may want to approach your admin/hoster with that question.
> 3 votes

# Answer
You need to increase you php execution time. Also maximum upload file size is 2mb.
> 1 votes

---
Tags: wordpress, import
---


title: CiviDiscount automatic problem

text:
# Question
Title: CiviDiscount automatic problem
Is this an acceptable config for an automatic discount for students?

http://d46.demo.civicrm.org/civicrm/cividiscount?reset=1
(screenshots below)

When I go to view the discount, the Automatic section is empty. On my own sites I can't get the automatic discount to apply when I view an event page that satisfies the criteria. I've seen issues like this that are marked closed on github from May. https://github.com/dlobo/org.civicrm.module.cividiscount/pull/98. I've tried the current git version and have the same issues.
So I think it's more likely that my configuration is wrong since the view of the discount shows the Automatic Discount field to be empty.
Can someone look this over and tell me if there's an error?

\[ \[\]

Thank you!

# Answer
> 1 votes
On the demo, I'm able to get the automatic discount to work. But also see the Automatic Discount as empty. See attached.

# Answer
> 0 votes
As it turns out, it was not an acceptable config. Removing 'country' made the auto-discount work.

---
Tags: cividiscount
---


# Question
Title: Can a recurring email be setup to send to a group?
Can an email to a group be setup to send every week? We have a weekly event that we want to send the same email to attendees reminding them to come.

# Answer
> 1 votes
Yes you could use schedule reminders for sending e-mails to participants of events.

You could setup the reminder to run a week before the event takes place. I would assume that it will also works with a recurring event.

---
Tags: email
---


title: Having trouble with pledges

text:
# Question
Title: Having trouble with pledges
I have users with pledges set up for the total amount they have agreed to pay this year. They make payments on these pledges via contribution pages. The payments are not being matched to the pledge however, because the pages are not properly configured. However, every time I set a contribution page to accept pledges (in the "amounts" setting tab), it reverts back to not accepting pledges after the "save." Has anyone else encountered this bug? Do you know what I could do to circumvent it?

I would just go and apply the payments to the pledges manually, but apparently that is not possible either, without an extension. Connecting existing contribution to pledge If you have an extension you are willing to share, that would be amazing.

# Answer
> 1 votes
I have now reported this bug here; https://issues.civicrm.org/jira/browse/CRM-17651

The bug only shows up when using price fields for a contribution page. There are good reasons for using price sets, however, and there is no reason I can see not to allow pledges when using the price set functionality.

If you have any fixes or workarounds that allow me to still use the price sets, please let me know!

---
Tags: civicontribute, contributions, contribution-page, pledges, civipledge
---


# Question
Title: 500 server error for live contribution page
Latest Wordpress version with multisite setup in wordpress - not Civi. Upgraded to civicrm 4.6.10 - also existed with civi 4.5.8 - no changes.

I can go to an existing page via the wordpress side (example.com/donate) and the civi - content shows fine. However, if I click contribute on that page (or use the live link from civi back end) I get a 500 server error. No obvious messages with debugging turned on (Are there log files I should review?)

Happens with stripe and paypal and even the manual option of sending by check!

It does not seem to like example.com/donate/?page=CiviCRM&q=civicrm/contribute/transact

or

http://example.org/civi?page=CiviCRM&q=civicrm/contribute/transact&reset=1&id=1

EDIT:

Turned on PHP error reporting on my host and was delivered an error message about my google calendar plugin.

Fatal error: Class 'WP\_Requirements' not found in /root/www/wp-content/plugins/google-calendar-events/google-calendar-events.php on line 46

Deactivation of the Plugin allows the system to process normally.

Same issue: posted yesterday to developer - no response yet: https://wordpress.org/support/topic/plugin-not-compatible-with-civicrm-profiles

# Answer
Turned on PHP error reporting on my host and was delivered an error message about my google calendar plugin.

Fatal error: Class 'WP\_Requirements' not found in /root/www/wp-content/plugins/google-calendar-events/google-calendar-events.php on line 46

Deactivation of the Plugin allows the system to process normally.

Same issue: posted yesterday to developer - no response yet: https://wordpress.org/support/topic/plugin-not-compatible-with-civicrm-profiles
> 0 votes

# Answer
Check your civicrm config log file. You are getting donate page working because of cache file. To get the proper error message, you need to remove the civicrm temporary (templates\_c) folder and enable the debugging. Also check for common folder in civicrm ( in version 4.6.10 it's missing for drupal release).
> 0 votes

---
Tags: civicontribute, wordpress, error
---


# Question
Title: Simple Donate Form Extension - what is path for front end - joomla
This is with CiviCRM 4.6.8 on Joomla 3.4.3.

I successfully installed the Simple Donate Form Extension and it works from within CiviCRM Dashboard, ie, Admin menu settings, CiviContribute menu Test/Live. But, I am not able to make it live on the frontend of the website. I've created a new menu item with the `Menu Item Type` selected as `CiviCRM => Contribution Page => Simple Donate Test` to no avail. The default CiviCRM form continues to appear. There is little documentation on this other than just set it and forget it.

*Please advise.*

# Answer
> 2 votes
I believe you have to add: **?page=CiviCRM&q=civicrm/simple/#/donation** to the end of your URL. That was how I got it to work for me, although I am using Wordpress.

# Answer
> 1 votes
You need to give menu link like below.

**For test page** \- /civicrm/simple?test=1#/donation

**For live page** \- /civicrm/simple/#/donation

---
Tags: civicontribute, extension, contribution-page, 4.6.8, simple-donate-form
---


title: Current Employer Autocomplete Field

text:
# Question
Title: Current Employer Autocomplete Field
In drupal the webform integration module allows an autocomplete field where you can search to add an employer from existing contacts. On my wordpress site however i am trying to allow users to update their current employer but it is just giving a text field with no autocomplete.

Are profiles able to use an autocomplete field for current employer? If not what are my other options?

# Answer
There have been many discussions in past about this on old forum eg this one which refers to this extension \- which looks like it needs testing for 4.6
> 2 votes

---
Tags: wordpress, profile, relationships
---


title: Mixed content error on SSL site

text:
# Question
Title: Mixed content error on SSL site
I'm trying to sort out an AJAX bug (edits to contacts not being saved) and the console error says:

```
Mixed Content: The page at 'https://studentleadership.ca/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontact%2Fview&reset=1&cid=9532' was loaded over HTTPS, but requested an insecure XMLHttpRequest endpoint 'http://studentleadership.ca/wp-admin/admin.php?page=CiviCRM&q=civicrm/ajax/inline'. This request has been blocked; the content must be served over HTTPS.`enter preformatted text here`

```

Originally I thought that it was because the resource URLs weren't set to https, but I changed that and nothing happened.

I checked the base url and the base url is still http://. It won't update when I change it to https://, it saves but when I go back to the page it says http://

# Answer
Check your `CIVICRM_UF_BASEURL` value in `civicrm.settings.php` and check also the settings under Administer --\> System Settings --\> Resource URLs.

In the latter you can force civicrm to load css/js via https.
> 4 votes

# Answer
To fixed this issue we use drupal secure pages module. From this module configuration we configure redirect to http is resources are not found at secure URL. Also we exclude the JavaScript and ajax from secure pages.

Check if there is any module like secure pages in WordPress.
> 0 votes

---
Tags: civicrm.settings.php, ajax, ssl
---


title: CiviCRM cron doesn't trigger all tasks

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

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

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

# Answer
Have a look in your bounce and/or email-to-activity inboxes. We had this bug where UTF-8 in the display name caused the whole cron run to repeatedly crash, and cron would not run until I moved the offending message.
> 1 votes

# Answer
These are related: Cron job fatal error - scheduled emails won't send. AddThis 5.0.7 issue and Cron job fatal error - scheduled emails won't send. AddThis 5.0.7 issue

I have found that with WordPress the best way is to use wp-cli and the best way to configure that is to use SSH. To be
> 0 votes

---
Tags: civimail, cron-job
---


title: Paypal payment processor not working

text:
# Question
Title: Paypal payment processor not working
This is our form http://manningmedia.net/glos/test/ , built under contribution page by loading user profile on it, it must be redirecting to standard paypal website after submitting, but it is redirecting to thankyou page only. We have already set payment processor as "standard paypal" and enabled contribute component also, but stil it is not working, please help.

# Answer
Check your contribution page configuration for amount tab. May be you have unchecked the Execute real- real time monetary transaction.
> 1 votes

---
Tags: paypal
---


# Question
Title: Is there a way to disconnect CiviCRM contacts and Drupal Users via the UI?
I have a connection between a Drupal User and a CiviCRM contact that I would like to remove. I found this Q&A which describes how to do that on the database level.

I was however wondering if there is any way to do that via the UI. Any hints? (Using CiviCRM 4.6.9 and latest Drupal.)

# Answer
There is no way to do this via the UI. I am not sure what to suggest if you don't have easy access to the db.
> 0 votes

# Answer
This is just a top-of-the-head thought and I am not sure I've thought through all the ramifications, but could you:

1. Create a new contact (blank, essentially, or with the same name)
2. Run a search that pulls both of these, and select to merge them
3. Flip the contacts so the old contact is considered the duplicate contact
4. Check the boxes to transfer all the info **except the Drupal user** to the new contact in the process of merging?

Test first, obviously!
> 2 votes

---
Tags: user-account
---


# Question
Title: All dashlets display "Object Moved" after host name change
We've changed server host name recently and all seems to be fine excluding dashlet reports disappearance: there is just "Object Moved, This document may be found here" like on this screen grab http://awesomescreenshot.com/0375gftva1

We've checked carefully all paths at:

* civicrm.settings.php
* Administer - System Settings - Directories
* Administer - System Settings - Resource URLs
* Administer - System Settings - Cleanup Caches and Update Paths

Also

* Cache has been instantly cleared,
* Refresh Dashboard button used,
* each report has been enabled / disabled / updated,
* log files in ConfigAndLogs folder has been monitored,
* page has been inspected using XHR inspector in Firefox,
* as well as server logs.

There are several suspicious messages in Drupal Watchdog though, like:

```
* undefined index: columns in CRM_Contact_Page_AJAX::dashboard()
(line 610 of /civicrm/CRM/Contact/Page/AJAX.php).

* $Fatal Error Details = Array ( [callback] => Array ( [0] =>
 CRM_Core_Error [1] => handle ) [code] => -5 [message] =>
DB Error: already exists [mode] => 16 [debug_info] => INSERT INTO civicrm_menu
(domain_id , path , breadcrumb ) VALUES

```

..but it's unclear how it might be relevant to this case, especially when cache has been cleared almost instantly. Any clue, please?

# Answer
In "own question - own answer" mode .. again. Well, it turned that server name resolves as **www.hostname.tld** while all paths we used were in just **hostname.tld** format.
> 1 votes

---
Tags: dashboard, dashlet, migration
---


# Question
Title: How to search for contacts not in a group through the Search Builder
I'm trying to search for contacts who do NOT belong to a given group. I'm using the Search Builder.

For Record Type, I select Contacts. Then for Field, I select Group(s). Then I select the ≠ operator. And finally I select the group name.

The problem is that it adds a search criteria that I didn't specify. After making the search, it displays my search criteria as:

`Group(s) ≠ MyGroupName ...AND...
Group Status "Added"`

I did not specify any group status and in this context it doesn't make sense for the Search Builder to automatically add it. So, am I doing something wrong or does this seem like a bug?

# Answer
You could also use the custom search Include/Exclude, which lets you search for contacts who are not member of a group
> 4 votes

# Answer
**Revised answer:**

There are 3 types of group status: Added, Removed and Pending.

I initially assumed the system is using Added status, to find people who are currently not in the group and have the Added status in that group. But the query logic fails.

I suspect that to avoid including the removed and pending members, the AND Group Status "Added" was included when looking for groups. I think you have found a bug.
> 1 votes

---
Tags: groups, search-builder
---


# Question
Title: mailing labels for contributors AND their spouses/families
i want to create mailing labels for everyone who donated at X event. Alice, Barbara and Carol all contributed. I want to also make sure that their spouses (Xander, Yancy and Zelda) are also included on the labels so they don't feel left out. When I search for contributors and make the PDF labels, only A,B,C show up. How can I make sure that spouses are included? Fingers crossed I don't have to go in and update all 1300 contact files. Thanks in advance!

# Answer
> 1 votes
This is not possible with the standard functionality.

However it is possible to develop custom tokens which will print the name of the spouse. I don't know if you have any experience with developing customisations for Civicrm

---
Tags: mailing
---


# Question
Title: Individual Update Employer address/profile informaiton
Using profiles individuals are able to update their own information. However i need an individual to be able to update their employers information. What solutions are there using wordpress for this?

# Answer
for WP or Joomla i think the only in-built option is if your Contact has a Permissioned Relationship with their Employer then they should be able to view and edit some details about their Employer via their Contact Dashboard.

But my quick test on demo (i guessed the url to get to the dashboard since i don't 'know' WP) doesn't show the permissioned Relationships I just created for 'demo, demo' on the Contact Dashboard, which I assumed (wrongly) was just a setting but MyContacts/Organisation was checked - hmm .

So either there is another setting that I have forgotten, or this is something I didn't know was a limitation in WP, or something else ;-)

But try it on your local anyway.

Also worth nothing that you can provide 2nd degree permissions via a setting (which i do see on WP)
> 1 votes

---
Tags: profile
---


# Question
Title: civirules extension -- send an email, SMS or PDF actions not available
I've installed the CiviRules extension but I am missing some actions that I thought to be built in. Send an email, SMS or PDF actions are not available.

Linked Trigger: Address is changed Linked Conditions: None

See screenshot.

Drupal version - 7.41 CiviCRM - 4.6.10 CiviRules - 1.1

# Answer
> 14 votes
Those come in separate extensions. You'll need to install these:

# Answer
> 3 votes
As DaveFF mentioned, they are separate extension that enable the Email, PDF and SMS API's. Part of those extensions is to add CiviRules actions if it finds out you have CiviRules enabled in your installation.

---
Tags: civirules
---


# Question
Title: Need clarification on switching CiviCRM hosting from a host/consultant
We are currently hosting with a company that also assists us with are CIVI Crm. We are interested in moving our site to a new host and would like to know if the CIVI will move with it? Without having in-depth knowledge of the "back-end" of Joomla/CIVI... I would like to speak with a representative to get a clear understanding of how we can continue to use CiVI and yet obtain a new hosting company. Please, could somebody call me and help us through this transition? Thank you, Tacey Martinek-978-772-2787

# Answer
> 3 votes
Yes, you can move your Civi installation to new hosting (though it is recommended to use a knowledgeable/experienced provider to do so; and you sound like you are on board with that idea). A good place to start is with one of the providers listed here: https://civicrm.org/partners-contributors

Here is some background on those providers listed and some tips on selecting a new provider: https://civicrm.org/about-service-providers

# Answer
> 1 votes
CiviCRM is a crowd-sourced open source software, which means that there is no company with representatives to call you back and talk through these things unless you hire someone to do so. I recommend removing your phone number from this public post, just as a matter of privacy protection. There are software-as-service companies that do this, www.civisites.com comes to mind.

Who set up your current site? They are probably the best person to talk you through this. If not them, then who is your current host? Your current hosting company should be able to help you move your data to a new hosting company, sometimes for a small fee. Your new hosting company may be able to help you move your civi information and installation as well.

If you have specific troubles in moving your installation, you can post your question on this forum and friendly community members will work to help you out, if they can.

---
Tags: import
---


# Question
Title: updated database from backend, issues when searching that field - Geocoding issue with Postal Code update
So I was playing with the contact mapping option for a search profile. I noticed that mapping did not work when the postal code was entered with a space in it. Example: "E1C E1C" rather than "E1CE1C" When I tried to view the map I would get: *Error This address does not contain latitude/longitude information and cannot be mapped.*

So I decided to run an update on the database: UPDATE `civicrm_address` SET `postal_code` = REPLACE(`postal_code`, ' ', '').

Which was successfull.. But still when trying to view map that error appears for the contacts that once had the space in their postal code.

If I go into the contact edit, edit the address field, change nothing, and just hit save, the issue is resolved. But I don't want to have to do that for every contact. Surely there most be a way to force it to update?

I hope I was clear with my issue. Any help would be appreciated.

I've also run the Clean-up Temporary Data and Files (cleanup) Job, but still the same issue.

Would I be correct to assume it may have something to do with updating the Geocode?

Civicrm: 4.6.10 Joomla: 3.4.5

Thanks!

I've been able to correct this issue by running the Geocode and Parse Addresses Job.

Thansk!

# Answer
> 1 votes
I've been able to correct this issue by running the Geocode and Parse Addresses Job.

Thansk!

# Answer
> 1 votes
After running the update command on database, you need to clear the civicrm cache (also make empty the civicrm\_cache table) and delete the civicrm temporary file.

---
Tags: database, upgrade
---


title: postsave stop database update

text:
# Question
Title: postsave stop database update
User is adding a new email. Call to civicrm\_pre detects a problem that requires that the update not happen. It hasn't actually happened by the time civicrm\_post or post\_save\_civicrm\_email is called. The update actually happens after post\_save is called.

How do I abort the update?

# Answer
While I suppose you could empty the `$params` array, it would be a bit clumsy. Meanwhile you'll need a way to notify the user in context, so something form-specific would be helpful.

Instead of using hook\_civicrm\_pre, you might consider using hook\_civicrm\_validateForm(). You'd be able to run the same checks, but in case the value is no good, you could send the user back to fix it.
> 2 votes

---
Tags: database
---


# Question
Title: Formatting of formatted text in print case and activiy audit
I'm sure this shoudl be fairly straight forward. I think i'm looking in the wrong place.

When I try to print the report of a case (civicrm/case/report/print?) or undertake an activity audit of a case, any text that has been entered usinjg the WYSIWYG editor is displayed as raw text. So any paragraphs are enclosed within

brackets etc.

Practically, this prevents these functions being used as the printed reports are nearly illegible (due to no line breaks and lots of angle brackets everywhere).

Hope this is clear and someone's got a quick solution.

I'm thinking i'll need to recreate these functions as a complete drupal view of the case, but would appreciate any other suggestions / approaches

# Answer
I see - a custom field, not the main details field.

A couple things I think. There is a security issue with not escaping the fields, so in that sense it is being correct to escape the brackets etc, but better would be some type of sanitizing that leaves formatting but removes malicious parts. I'm not sure if this is the job of the wysiwyg editor itself or the civi code that handles the data.
> 0 votes

---
Tags: custom-fields, civicase
---


# Question
Title: How do i delete unknown addresses from a group
I am generating a list to send a mailing to via postal mail. I have created the group and now need to delete contacts from the group who don't have an address.

# Answer
You can use use Search Builder (Search \> Search Builder) to search for contacts in a group and add another search field like contact City (Primary or whichever address field you are using) is empty.

You can then select the results and delete, or remove from the group.
> 4 votes

---
Tags: contacts
---


# Question
Title: How to handle irrelevant employers we don't really want as separate contacts?
So, sometimes a contact's employer is entirely irrelevant, we have basically no value in keeping that information. Or maybe there's no reason not to note it, but it's not an organization we care about.

How should we manage this type of situation? I don't really want to clutter our contact lists with all sorts of random companies just because they employ someone. Is my thinking sensible in terms of avoiding making extra contacts?

Can/should I make an employer field that is custom that doesn't require the entry to have its own contact record? Should we just accept the excessive contact records? Or should we leave employer blank whenever we don't think we want a contact record for that institution?

Basically, the employer part seems confusing. It seems it would have made more sense to just make it a simple field like any other and choose to enter employers and add the relationship in just those cases where it seemed worthwhile, and it would then make it far easier to deal with cases where we want more info, such as for people who have multiple employers and/or track their employment changes over time…

# Answer
The employee/employer connection is a relationship - you can add it from the relationship tab, and include start and end dates to build up an employment history. I assume it's also in the initial contact record entry form because a lot of people do want to record the current employer.

If you're really sure you don't need a separate contact, and don't need information about how individuals are employed, then there isn't much point in recording it. If you're picking up the data and don't want to lose it, maybe just add it as a note? That way the information is there, but you don't have superfluous contact records (and you don't have to worry about whether they're still employed by the same organisation a year later).

We have a similar situation - sometimes the organisation is needed, because that's the source of our contact with the individual, but sometimes we only know their employer because they've signed up to our newsletter with their work email - it doesn't have any impact on our connection with them. It's tempting to fill up every field just because it's there, but if it's never going to be used, it's just more data that needs to be checked and updated.
> 0 votes

# Answer
One of the distinct advantages of CiviCRM is that nobody is limiting your number of contacts. Although there is admittedly a bit of overhead in maintaining organizations--mainly in merging different wordings and abbreviations of the same place--this is less trouble than you'd go through to prevent these contacts from being created.

Like the proverbial tree falling in the forest, a contact in your database doesn't make a sound if nobody's searching for it. Mark your important contacts in ways that you'll find them, but a contact that's just in there as an employer won't clutter up your work unless you're making grossly over-broad queries.

(Besides, who knows if they'll end up as the employer of other contacts? You might consider a workplace giving program.)

Most importantly, don't let the mere existence of a contact in your database signify anything to you. Segment your data based upon location, activity, opt-ins to lists, and so forth. If a contact is exclusively an employer of another contact, with no further information, they'll never have any of this other data--the information that you should really be basing your communications and analysis on.

In short, don't fight this core feature of CiviCRM. It's innocuous, and it would be confusing and/or expensive to work around.
> 2 votes

---
Tags: contacts, custom-fields, relationships, contact-types, data-model
---


# Question
Title: Should the No-Overwrite extension be the normal behaviour?
I've seen cases where admin users have changed their contact details when adding someone else to an event.

I came across the No Overwrite extension, which makes First and Last names uneditable - great extension! Any reason why this shouldn't be the default behaviour?

# Answer
Changing the default behaviour is a tricky process, because some will want to keep the existing one as the default.

When I create a new site, I add a handful of "mandatory" extensions, like this one (glad you like it! ;), and it's my default, I think it's not too much of a trouble and allows everyone to have the civi tailored the way they want without disturbing the 10k other installations

X+
> 4 votes

# Answer
Just being devil's advocate here, because I think the No Overwrite extension is great, but in the cases when you see your name somewhere and it's wrong, it's irritating if you can't fix it. It may be a typo, or your first and/or last name may have changed due to one of a whole variety of life events that could have happened since the information was entered.

The alternative to allowing people to fix their names is to require a call or email to the office--staff time that costs nonprofits money.

Also, although I'm quite aware that many people ignore all this, it takes a certain amount of bravado to go on a form, blow past the warning box which offers to give you a blank form, and pro-actively replace a series of pre-populated fields.

Most individuals would never think of doing such a thing, and many charities have never had a problem like this. On the other hand, it seems to be par for the course for trade association members. That CiviCRM allows for either option (flexibility by default, or structure via Xavier's extension) is a real benefit.
> 2 votes

---
Tags: contacts, user-account
---


# Question
Title: Why is there a hyphen following the postal code with this address format?
The token `{contact.postal_code}{contact.postal_code_suffix}` is returning an extra hyphen at the end of the string: **10023-7890-** not **10023-7890**.

The actual content shown in the Settings - Addresses is as follows

```
{contact.addressee} {contact.street_address}
{contact.supplemental_address_1} {contact.supplemental_address_2}
{contact.city}{, }{contact.state_province}{ }{contact.postal_code}{-}{contact.postal_code_suffix}
{contact.country}

```

How can I get rid of it? Thanks, K.

---

Sorry - the cut & paste I did had the extra hyphen after country. However, the actual content shown in the Settings - Addresses is as follows: {contact.addressee} {contact.street\_address} {contact.supplemental\_address\_1} {contact.supplemental\_address\_2} {contact.city}{, }{contact.state\_province}{ }{contact.postal\_code}{-}{contact.postal\_code\_suffix} {contact.country}

The extra hyphen after {contact.country} does not appear in the mailing label or address display format, but it is still appearing everywhere.

I've tried editing the address settings by adding each token but the problem remains. Any other thoughts?

# Answer
> 1 votes
It looks like **CiviCRM automatically includes the postal code suffix** in the `{civicrm.postal_code}` token, so I think you can just remove the suffix and hyphen from your address configuration.

Using your stated configuration in **Administer \> Localization \> Address Settings**, I see the same behaviour on http://d46.demo.civicrm.org when printing address labels.

Using this format (with postcode suffix and hyphen removed), I see the suffix included in the output of the postal\_code token.

```
{contact.addressee} {contact.street_address}
{contact.supplemental_address_1} {contact.supplemental_address_2}
{contact.city}{, }{contact.state_province}{ }{contact.postal_code}
{contact.country}

```

Results in -

# Answer
> 0 votes
You have use country field just after the postal code suffix field and you '-' after country. If country field value is is blank then obviously you will get '-' after postal code suffix.

---
Tags: addresses, address-labels
---


# Question
Title: How can I show only Cases that have no Case Manager?
I asked a similar question recently, but I wanted an answer specifically for Drupal Views. I'm broadening my scope now.

I thought I had an answer to my question via Case Reports. I can show only those cases without managers by implementing the "Case Role(s)" filter and setting it to "Is not one of" "Case Manager". This gives me the results I expect. However, I can't actually navigate to individual cases from the report. Instead when I click on the case subject, a modal window pops up that shows very little information about the case.

I would like to have a list of cases without managers with links to manage the case.

I'd prefer a built-in civi solution, but I'm fair with PHP and not averse to some custom coding if need be.

# Answer
If you set up the page view as mentioned in your other post here, you can add a global text field with a rewrite to `civicrm/contact/view/case?id=[id]&cid=[id_1]&action=view`.

If you need to set it up for folks that may have **multiple case types** then filter this page by a single case type.

After you have this view behaving as desired, add an attachment and on the attachment, change the case type filter to your next case type.

Add an attachment for each additional case type.
> 1 votes

---
Tags: civicase
---


# Question
Title: Finding contacts in Group A AND Group B?
It seems like there must be a way to search for (and hopefully perform group operations on)contacts that are in both Group A AND Group B but I can't find it. Suggestions?

# Answer
You can use Search Builder (Search \> Search Builder) to search for contacts in a group A and add another search field for contacts in Group B. See screenshot from demo.
> 12 votes

# Answer
Under Search \> Custom Search there is a search called Include / Exclude Search which is specifically for this purpose ie including/excluding specific Tags and Groups. You can see it here on the demo site.

I don't know if it delivers what you need but worth knowing about.
> 3 votes

---
Tags: groups
---


# Question
Title: Changes in display of batch data entry form in 4.6.x
In 4.3.x and 4.4.x, it was possible to see the name and email of the donor when entering a contribution: http://screencast.com/t/vH0CG33LDPU

In 4.6.x, only the name is now displayed: http://screencast.com/t/65HG1fBZ7ZH

For some of our clients, this is extremely problematic because they either need to see whether a particular donor has an email address in the system (so they can exclude them from the email receipt) or because they have multiple contacts with similar names in Civi and use the email address to distinguish among them. My developer colleague tells me this change was made in core. My question is, is there a straightforward way to change what is displayed in the contact name field or will it be necessary to resort to code changes?

Thanks, Lesley

# Answer
From UI perspective, it is not currently possible to include an email in the select box. Some code changes need to be done.

I was just skimming the code of `Common.js` file where this functionality seems to be handled.

I guess the `formatSelection` function is the one which returns to what is seen after the selection of the contacts from the dropdown. You can make a change here to include the email to be concatenated to the name. Something like:

```
var email = (row.extra.email !== '' ? ' - ' + row.extra.email + ' ' : '');

```

and then add this to the label.

Well, modification in this file may not be recommended as changes done here are too core and may affect some other functionality elsewhere. This file is called in almost all the pages of CiviCRM and hence this change would affect all the dropdown present in it.
> 1 votes

# Answer
I was looking at the demo and noticed matching contacts show with their emails, is that not sufficient?
> 0 votes

# Answer
It looks like that particilair feature on contribution batch entry paged disappeared. And it looks like there is no option for changing the display of the selected contact in a contact reference field. You are not the only one who finds this a pity.

I do think it would be really wonderful if we could configure the contact reference a bit more. We could enable/disable the e-mail field for looking up but it would be also wonderful if we could show it.

What you could do then is to develop this feature yourself or find and fund a developer to do so.
> 0 votes

---
Tags: civicontribute
---


# Question
Title: When importing activities can you use an external id?
Is there a standard way to import activities with an external identfier in the same way as contacts to help us identifiy what has been previously imported.

otherwise, I guess we would just have to create a custom field.

# Answer
At first, I thought you meant importing activities and joining them to contacts with the contacts' external IDs. This is the most common way I do activity imports.

However, reading closer, it sounds like you want to have an external ID field for the activity. You'll need to create a custom field for this. Also, you should remember that your custom field will not do the same magic as the contact external ID field: nothing will enforce that the value is unique, and nothing will automatically match activities based upon this field.

It still might be useful for cross-referencing your imported activities with the source, but you'll have to apply your own logic to the field.
> 3 votes

---
Tags: activities, import
---


title: Trying to do a search using tags

text:
# Question
Title: Trying to do a search using tags
I have tags set in my database. A few that I want to search by are D1 School, D1AA School and Recruiter. I want to find all contacts that have D1AA School and Recruiter checked off but I can't find any search that does 'and' and it only does 'or'. That gives me any contact that has D1AA School or Recruiter checked. I am trying to create groups based on the tags so I can do a mailing.

# Answer
You can use the Search Builder (Search menu item \> Search builder; see this answer about searching for Groups A and B, it's the same concept) or a custom include/exclude search.

Once you have the search results, you can add the resulting contacts to a group for your mailing.
> 1 votes

---
Tags: search, tags
---


title: Pending from incomplete transaction

text:
# Question
Title: Pending from incomplete transaction
Registrants have status recorded as Pending from incomplete transaction even after PayPal has collected fee and confirmed payment

I have been over the PayPal processor setup multiple times and believe I have followed the text.

I have created an event and assigned the PayPal processor to it. When I do a registration civicrm accepts the registration and presents me to the PayPal site. the payment is made , charging the registrant and completing the payment to my merchant account, PayPal returns me to the registration page with the message "Your registration payment has been submitted to test *( test is the name of the fees for this event)* for processing. Please print this page for your records." PayPal merchant account sends out a notice to both my PayPal merchant email and the registrant email confirming the transaction.

when I look in the event registration list to view the registrants, there are no attendees paid. Only when I look in Pending from incomplete transaction do I find the listing with the pending notice attached.

CiviCRM version: 4.6 CMS version: wordpress 4.3.1 MySQL version: 5.5.42 PHP version: 4.0.10.7

# Answer
Check PayPal IPN is configured properly or not.
> 1 votes

---
Tags: payment-processor
---


# Question
Title: Article selection while creating a mailing?
I'm using Civicrm into my Joomla 3.4.5 site. Is it possible to select some articles into my joomla article's archive and insert them directly into a civicrm mail while i create a new mailing within the mailing template creation process? Thank you!

# Answer
Check out the Content Tokens extensions and see if it fulfill your needs, if that doesn't suits you can always create your own tokens, have a look at @Coleman's post.
> 1 votes

---
Tags: joomla
---


# Question
Title: Clear custom multiple records fieldset occurences
My goal is to free all contacts of a specific custom fields group. In other words I want to clear all occurrences of a multiple records custom field set. May I truncate the `civicrm_value_<customfieldsetname><id>` table, is there an api method or how can I safely achieve this?

Thanks in advance // nielo

# Answer
Pretty sure you can truncate the civicrm\_value\_customname table. I've done that before with no ill effects (assuming you don't have custom code running off those values).
> 2 votes

# Answer
Why do you need that?

Do you want to keep the fields, but only empty?

Deleting the fields would make the most sense to me. That can be done via the web interface.
> 0 votes

---
Tags: custom-fields
---


# Question
Title: Is CiviCRM right for a non-profit medical group?
Would CiviCRM be appropriate for a 501(c)(3) medical group practice's philanthropic endeavors?

# Answer
> 4 votes
Without knowing what your organization is trying to do, it is difficult to provide meaningful feedback. You should take a look at CiviCRM's features and see if it fits your need. At the bottom of the site you'll find some useful links, including:

Browse case studies, Contact an ambassador, Introductory webinars, Watch videos, Try a demo, Read documentation, Ask a question, Find an expert

# Answer
> 0 votes
If you are needing to track/administer contacts, organizations, contact relationships and outgoing grants, then yes, CiviCRM would suit your organization quite well.

See this link for the grant component: What is CiviGrant?

---
Tags: activities, evaluating-civicrm
---


# Question
Title: When editing a membership Civi sends receipt and confirmation even with box unchecked
Using WP4.3.1 and CIviCRM 4.6.9 I also had this happen on the current CiviCRM.org demo site for WP.

When editing a membership Civi sends receipt and confirmation even when the box for "Send Confirmation and Receipt?" is Unchecked.

Is this a bug or am I missing something? Of course we do NOT want to send receipts for most edits we make!

# Answer
> 4 votes
Have you checked that the mails are actually being sent out?

In civiCRM 4.6.4 I have found that I receive the following pop-up when editing a membership record with an attached contribution record (this does not seem to occur when there is no contribution recorded with the membership), but if the "Send Confirmation and Receipt" box is unchecked, no mails are actually sent out even though I got the message below.

---
Tags: civimember, receipts
---


# Question
Title: How do I fix auto-renewal memberships? (Auth.net)
We're recently having trouble with auto-renewal memberships again. When a member's membership should renew, the members are getting charged through Authorize.net but it's not updating the membership status through Civi. Not sure what to check or how to fix this issue.

# Answer
> 2 votes
We had the same issue in CiviCRM 4.6.4 - our configuration inside our Authorize.Net portal was incomplete and we followed the steps outlined at

http://wiki.civicrm.org/confluence/display/CRMDOC/Authorize.net+Configuration

under Automated Recurring Billing. After putting in the correct URL for authorize.net to post to, memberships started to update.

Another thing to note is it's obnoxious to test because authorize.net processes their ARB transactions once every 24 hours at something like 2am so you won't know right away if it's working.

Pulled out the relevant text here:

"CiviCRM will need to be notified of the success of recurring contributions via a Silent Post URL. Within Authorize.net, go to Account \> Settings \> Silent Post URL (within the Transaction Format Settings section). On that page, enter the URL:

Drupal: https://yoursite.org/sites/all/modules/civicrm/extern/authorizeIPN.php

Joomla: https://yoursite.org/administrator/components/com\_civicrm/civicrm/extern/authorizeIPN.php

WordPress: https://yoursite.org/wp-content/plugins/civicrm/civicrm/extern/authorizeIPN.php

*If you fail to do this, one-time contributions will succeed normally, and recurring contributions will be processed successfully by Authorize.net, but the contribution status will be stuck at Pending.*"

# Answer
> 0 votes
This is really more of a comment.

We found recently that we were not getting the payments into the memberships. The IPNs were there but they didn't go anywhere. There was an error being logged after messages said everything worked. Turned out that the civicrm\_line\_item table had been corrupted. When the entity was civicrm\_memberhip sometimes the entity id (which should have been the membership id) was the same as the contribution id. Once that was corrected the payments were recorded in payment tab of the member.

The creation of the contribution record wasn't happening. The transaction to create them was being rolled back because of the line item issue.

Not all members were affected and the cause of the corruption is still being investigated.

From the log:

Oct 01 08:24:41 \[info\] Contribution record updated successfully

Oct 01 08:24:43 \[info\] Receipt sent

Oct 01 08:24:43 \[info\] Success: Database updated

Oct 01 08:25:27 \[info\] $backTrace = #0 /home/fshares/public\_html/sites/all/modules/civicrm/CRM/Core/Error.php(897): CRM\_Core\_Error::backtrace("backTrace", TRUE) 1 internal function: CRM\_Core\_Error::exceptionHandler(Object(DB\_Error))

/home/fshares/public\_html/sites/all/modules/civicrm/packages/PEAR.php(931): call\_user\_func((Array:2), Object(DB\_Error))

/home/fshares/public\_html/sites/all/modules/civicrm/packages/DB.php(976): PEAR\_Error-\>PEAR\_Error("DB Error: constraint violation", -3, 16, (Array:2), "INSERT INTO civicrm\_membership\_payment (membership\_id , contribution\_id ) VAL...")

/home/fshares/public\_html/sites/all/modules/civicrm/packages/PEAR.php(564): DB\_Error-\>DB\_Error(-3, 16, (Array:2), "INSERT INTO civicrm\_membership\_payment (membership\_id , contribution\_id ) VAL...")

/home/fshares/public\_html/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR-\>raiseError(NULL, -3, NULL, NULL, "INSERT INTO civicrm\_membership\_payment (membership\_id , contribution\_id ) VAL...", "DB\_Error", TRUE)

/home/fshares/public\_html/sites/all/modules/civicrm/packages/DB/mysql.php(899): DB\_common-\>raiseError(-3, NULL, NULL, NULL, "1452 \** Cannot add or update a child row: a foreign key constraint fails (\`fs...")

---
Tags: civimember, authorize.net
---


# Question
Title: Where in the DB are CiviCase timelines and sequences stored?
Please can someone tell me, where in the DB are CiviCase timelines and sequences stored?

# Answer
Generally, `civicrm_case_type.definition`

If the `definition` is `NULL`, then it will fallback and search for an XML file.

The loading logic is in `CRM_Case_XMLRepository`.
> 4 votes

---
Tags: civicase
---


title: CiviMail Does Not Send To A Whole Group

text:
# Question
Title: CiviMail Does Not Send To A Whole Group
Evening Everyone;

I have found an issue with CiviCRM 4.4.14 (Drupal 7.39) which I can not fathom. I have checked everything that I can think of and nothing obvious springs out.

I have a non-Smart Group of 369 contacts (361 with e-mails- so technically 361). When I go to CiviMail and generate a mailing it will only send to 311 (with duplicates filtered 308) which I can not get to rise. I have checked the following:

* That they have a primary e-mail address
* That they are not flagged as do not e-mail/no bulk e-mails
* They are not dead (something from the old forums) suggested null deceased
* They are not on any stop flags
* They are not on hold
* The organisations they are members of are "current" memberships

Everything says they should receive the mail.

Oddly, the previous mailing reports reported much more; at 354, but as far as I am aware there were no unsubscribes since that mailing.

has anyone else experienced this?

**edit** Having made a copy of the group and removed all the contacts without an e-mail address; it appears that having a blank e-mail address does not cause the issue. In that case it would only send to 311 of 361.

I have also searched the old forums and have found similar issues Missing contact in mass-mailing Warning : Undefined offset and missing group members in mailout list et. al. but it does not appear that there were many ideas beyond what I have already tried.

Analysing the group, there is nothing obvious that would explain the missing 50, like a type of contact, or the like.

**edit 11 Sept** I have now had a change to go through the mailing and the relevant group to work out what is going on and I am no further.

Just a few quick stats which may prompt someones thought process:

* There were 54 contacts in the group (of 362) which the CiviMail did not go to - 7 additional members of the group did not have e-mail addresses
* 50 of those 54 contacts had a surname starting with **S** however 1 contact starting with S did have the mailing sent to them.
* There is a mixture of *current* and *grace* memberships; other contacts with those memberships received the mailing.
* There is a one organisation and the rest are individuals with a variety of sub-types; other contacts with those sub-types received the mailing.
* None are pending/on hold/etc

Something of note though which may be significant.

I went to the original group, to pick out and create a new group of those that did not receive the mailing. When it came to the letter S (and 50 of the 51 needed selecting) I clicked the checkbox to select all the members of the group so that I could then de-select the one who did.... it would not let me.

On the select records option it still showed *0 selected records* and it errored when I tried to add it to the new group I created. I had to manually select all 50 records for it to work.

I also tried to send a CiviMail to the group of 54. It would only estimate that I would be sending it to 4 recipients. This would suggest to me that I am looking at the 50 contacts with surnames starting S.....

**edit 25 Sept** This issue continues for us and I am still running into dead ends in terms of leads.

* Of the 54 contacts, 4 have been discounted as they are duplicates within the mailing group
* Of the 50 that remain, I have them additionally in a separate group that I can select all and send an e-mail to and they will appear on the e-mail screen. This suggests that the actual e-mails are valid without any stray spaces.
* This affects the same contacts across all the groups. We know that there was not an issue on 26th August when a civiMail was sent out which contained many of the group, but then fell over between then and 4th September.

Obviously I will be trying to send the monthly mailing to all the recipients on the list manually to see if anything bounces back; but that probably won't explain why this specific list of people, surname starting **S**, can not be sent anything via CiviMail.

# Answer
> 6 votes
I finally gave up and forwarded this our developer who found that indeed, the issue was the is\_deceased flag which had become NULL of their own accord!

It could be noted that manually setting all the flags via the GUI does not resolve this issue.

It would be interesting at some point to work out whether there was a specific action on the website that caused these flags to become NULL vice 0.

# Answer
> 4 votes
Probably you have already covered that but just to make sure: All contacts are in the goup and have the status "added" and NOT "removed" or "pending"?!

To find out go to \>Contacts \>Manage Groups and click on the link "Contacts" next to the the group in question. You will then see all contacts in the group and also be able to filter for those that are added, removed or pending.

# Answer
> 1 votes
Have you sent already an email to that group since you have discovered the missing ones?

I think you have covered all the common reasons to get a contact excluded in your analysis (death, opt-out, no email, don't send email flag...), I can think of two reasons:

1) Assume something wrong at the data level

(eg. if you had a lot of dedupe, merge, import, api calls, upgrades...) something might have gone wrong at one time and how have now ghosts in the machine, that need to be found and killed.

Can you send an email to the group, go to the report of who received it and compare to the original group list and try to find a couple of the missing 50.

Is there a pattern or something weird/different? you might have to look using the api explorer or sql. The main stuff to look at are the emails and groupcontact entities.

2) a bugus email format

Another reason, especially if you find them clustered (assuming sorted by contact id probably, so not so easy to identify) is that one of the email is invalid, and the cronjob sending them choke on it, die and don't sent the emails after the invalid ones.

This is probably not your case, because this would mean that civi says it will send to the full group, but never finishes the mailing and keeps the 50 left. I mostly mention it because it used to be a problem on older versions of civi.

X+

---
Tags: civimail, groups, mailing
---


title: Notification of new membership sign up

text:
# Question
Title: Notification of new membership sign up
I would like to be able to send a notification email to the office manager when a member joins through an online form. The office manager should be notified for each new member.

How can I do this?

The membership form is set up as a contribution page.

I'm using CiviCRM 4.6.10 on Drupal 7.41.

# Answer
> 3 votes
If you use confirmation mails, it should be fairly simple:

1. go to "Contributions" --\> "Manage Contribution Pages"
2. next to the contribution page in question, use the link "configure" and then "Thank-You and receipting"
3. tick the box "Email Receipt to Contributor" (if not ticked already) enter your office manager's email-address in the cc or bcc field

# Answer
> 5 votes
You can use the advanced setting in a profile to email someone each time it it used. See "Notify when profile form is submitted?" in screenshot.

# Answer
> 1 votes
As an alternative you could also use the CiviRules extension (https://civicrm.org/extensions/civirules) in combination with the extension for the email API (https://civicrm.org/extensions/e-mail-api). You could then set up a rule with membership added as a trigger, the membership type and/or status as conditions if required and the email send as action.

---
Tags: drupal, civimember, contribution-page
---


# Question
Title: CiviCRM with Worpdress defaults to incorrect host?
I installed CiviCRM on my desktop installation of WordPress and everything worked fine. So I installed it on my working website, and after quite a bit of wrangling with the sysops, I got it to install. My problem is, when I go to configure it, it defaults to a different host than mine (eg., my host is nmsta.org and it goes to sfclt.org). I suspect the problem is in the database because it persists when I uninstall and reinstall it, even with two different versions. Any ideas where to start?

# Answer
> 1 votes
A clean installation of CiviCRM wouldn't come with any built-in hosts, so this sounds like a configuration issue, either in the CiviCRM settings or the WordPress settings. Perhaps if you search your codebase and database for the incorrect domain it would highlight the incorrect setting?

---
Tags: configuration
---


# Question
Title: Webform 'previous page' button gives 500 server error
W7 Pro SP1 Firefox v.42, IE11, Chrome 46

The version of CiviCRM I’m using has a multipage Webform that I’m having problems with.

Everything works fine as long as I don’t try to use the form’s ‘previous page’ button, but if I do I get an HTTP 500 Server Error

With Firefox I initially get a ‘white screen of death’ (an empty browser – address field, bookmarks bar etc all there, but no content). If I then try the browser’s back button I get a “Document Expired” error message & if I keep clicking the browser’s back button I get back to the form’s ‘Begin’ page

I’ve tried it in Chrome & I get a “Server error 500” message & in IE I get ”HTTP 500 Internal Server Error”

My understanding is that a “500server error” is a very general error message, just saying that there’s a problem with the/a server....so, not that much help really!

My regional branch of the organisation is run by/hosted by another organisation, so to access the database I’m going via the host orgs server as well as the server at the parent organisation (Healthwatch England), which is where the database is & I don’t have admin access to either of them.

After searching for info on this I’ve tried increasing the cache size in firefox, but it hasn’t helped. I’m not sure what else to try.....has anyone come across anything like this before & resolved it?

Any help much appreciated!

# Answer
> 2 votes
Check your civicrm log file under ../files/civicrm/Configlog/.

# Answer
> 1 votes
A 500 Server error will in most cases give a PHP error message in the log files. Are you able to look into the apache/nginx error logging? Or ask people who can?

That would help finding out what happens.

# Answer
> 0 votes
I'm just an end user so I don't have access to the server or any logs. Because I kept encountering the error even when the developers said it was sorted I thought I'd look into it myself & maybe pass on whatever I found out, but they finally got it sorted yesterday afternoon, though I've no idea what they did as I can't communicate directly with them.

Thanks anyway for your answers guys.

---
Tags: webform-civicrm, error, webserver
---


# Question
Title: Has anyone tried Stripe payments through OmniPay?
The Stripe payment processor extension works okay for the most part, but when there is an issue, it seems hard to get any answers or feedback. I am curious if anyone has tried integrating Stripe payments through the OmniPay extension, and if so how that went?

# Answer
> 2 votes
I think Stripe through the Omnipay extension is not working at the moment. We are looking into Stripe as well and will wait for the regular extension to be updated like Parvez mentioned.

---
Tags: payment-processor, stripe, omnipay
---


title: Restrict CiviCase Status changes

text:
# Question
Title: Restrict CiviCase Status changes
Does anyone know how to restrict available CiviCase Status types based on what the current status is?

I.e. I want not to be able to go to "application rejected" until it has passed through "application awaiting review".

If this isn't possible out of the box, does anybody know what would be involved in developing that functionality?

Thank you,

John

# Answer
The form validation hook: http://wiki.civicrm.org/confluence/display/CRMDOC/hook\_civicrm\_validateForm

When you say "until it has passed through...", in the hook you could look up the prior activity revisions.
> 2 votes

# Answer
the easiest is probably a little jQuery wrangling, you can see an example in this extension which sets a default case status based on the case type: https://github.com/PUMNL/nl.pum.casestatus
> 1 votes

---
Tags: civicase
---


# Question
Title: How do I set up PhpStorm for CiviCRM development?
I've acquired PhpStorm and I was wondering if there was any guidance on the best way to set it up for CiviCRM development. I saw there was a little information about coding style setup but there are a few other aspects.

* I notice that .idea isn't excluded in CiviCRM's .gitignore by default?
* How can I configure PhpStorm to run the web tests?

With a comprehensive answer we might be able to create a more comprehensive docs page to help others get up and running.

# Answer
> 1 votes
Regarding your first question you can set up phpstorm to use another project directory rather than the .idea direcory in your civicrm root.

I usually have an install of Drupal with CiviCRM plus drupal modules plus extensions and only the extensions are link to git.

I am also curious on how to use web tests in php storm... Did not know it was possible...

---
Tags: developer
---


# Question
Title: How and when should I create custom data fields?
I need at least 50 different "categories" or "custom fields". Everything from Contact Info like Name, Address, etc. to specific information that I would have to uniquely name. I am getting extremely confused on how to do any of it. Is there a tutorial on here, or something? I am really new at this.

# Answer
> 11 votes
Welcome to Civi! A great place to start is this wiki post about Groups vs Tags vs Custom Fields:

http://wiki.civicrm.org/confluence/plugins/servlet/mobile#content/view/86213742

There are also sections of the Civi book that might help:

http://book.civicrm.org/user/organising-your-data/groups-and-tags/

http://book.civicrm.org/user/organising-your-data/custom-fields/

# Answer
> 1 votes
Under your 'Administer' menu there's a 'Customize data and screens' and then a "custom fields" option. There you can add all the fields that you need.

---
Tags: contacts, custom-fields, groups, tags
---


# Question
Title: Civisualize extension doesn't show up as available when uploaded to extension directory
I downloaded the master zip file from this extension to my extension directory of civicrm.

https://github.com/TechToThePeople/civisualize

I unzipped it in the extension directory. flushed cache. The extension does not show up in the list in civicrm/admin/extensions?reset=1

I'm using CiviCrm 4.6.5 According to the latest changes in github project, the extension should be compatible.

# Answer
> 3 votes
You may also need to check the uploaded extension's file permissions and user settings.

Also, clear cache.

# Answer
> 0 votes
The Civizualize extesion became visible in the extensions list only after installing another extension. I have no idea why that is. But it now works.

# Answer
> 0 votes
It shows up for me after pressing "Refresh" on the Extensions page (I'm not sure if that is what you mean by "flushed cache"):

---
Tags: civireport, civisualize
---


# Question
Title: Security Configuration and Programming Guidance
I'm a security person. I have a non-profit that wants to use CiviCRM. What are the nitty-gritty details that I need to know? I will handle the hard technical stuff for them. The only information of value they are trying to protect is user real name and email address. But, they are considered very sensitive and high value. No money is exchanged with users. Their activity history is not considered sensitive, just the fact they are associated with the site. There will be millions of users and high site visibility.

Thank You

# Answer
CiviCRM is a good system if you want your data to remain secure. I would recommend installing on a hardened server following the normal instructions, and ensure you keep the security patches for your CMS and CiviCRM applied when they come out. Drupal, WordPress and Joomla! all have security announcement lists you can subscribe to. See https://civicrm.org/security for CiviCRM's.

During configuration you will want to ensure that the permissions are configured to prevent inappropriate access to data (eg see http://wp46.demo.civicrm.org/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fadmin%2Faccess%2Fwp-permissions&reset=1 after logging with user demo password demo). For example, CiviCRM: view all contacts and CiviCRM: edit all contacts should be reserved to Administrative users, and CiviCRM: skip IDS check should be disabled for all users (IDS is Intrusion Detection System).
> 1 votes

# Answer
I think this is more a question on how to set up your configuration (which I am no expert on so I will not get into that) rather than programming in CiviCRM?
> 0 votes

---
Tags: configuration, security
---


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

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

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

How can i solve this issue?

# Answer
Once you upgrade to 4.7 it will be super easy due to the new configurator UI.

See https://civicrm.org/blogs/colemanw/big-changes-wysiwyg-editing-47

4.7 is now available for beta testing, be sure to give it a try :)
> 1 votes

# Answer
Check out the answers to

How do I override the default CKEditor configuration?

and

Is there a way to enable or install the full version of CKEditor in CiviCRM 4.6.x?

Might be some help there.
> 0 votes

---
Tags: civimail, ckeditor
---


title: Geocoding contacts using google api

text:
# Question
Title: Geocoding contacts using google api
I have geocoding enabled but getting the contacts geocoded seems hit and miss.

I can get them geocoded if I go into the record and resave the address field (without making any changes). The small red "map" icon then comes up and they seem to get geocoded in the saving process. I have only a 1000 records so I can go through them manually.

However when I try to do the batch geocoding I just get this - which I don't understand although it seems to be saying I have an invalid start id. Any ideas how I could start to trouble shoot this?

Parameters raw (from db settings): geocoding=\[1 or 0\] required parse=\[1 or 0\] required start=\[contact ID\] optional-begin with this contact ID end=\[contact ID\] optional-process contacts with IDs less than this throttle=\[1 or 0\] optional-1 adds five second sleep

Parameters parsed (and passed to API method): a:6:{s:7:"version";i:3;s:9:"geocoding";s:17:"\[1 or 0\] required";s:5:"parse";s:17:"\[1 or 0\] required";s:5:"start";s:48:"\[contact ID\] optional-begin with this contact ID";s:3:"end";s:62:"\[contact ID\] optional-process contacts with IDs less than this";s:8:"throttle";s:42:"\[1 or 0\] optional-1 adds five second sleep";}

Full message: Finished execution of Geocode and Parse Addresses with result: Failure, Error message: start is not a valid integer

Thanks!

# Answer
It looks like you still need to configure the job parameters for geocoding, for instance for the 'geocoding' parameter it expects 0 or 1, but literally "\[0 or 1\]" is being passed.

So if I want to geocode starting at cid 1 and end at cid 1000, but skip address parsing, I would pass the following parameters:

geocoding=1 parse=0 start=1 end=1000 throttle=1

If you're running this as a scheduled job, you can go to the scheduled jobs page (administer\>system settings\>scheduled jobs) and 'edit' your geocoding job. The box called 'Command Parameters' is where you would edit this information.

Some more info here: http://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs
> 4 votes

# Answer
I would also try just switching to the Yahoo geocoder under Settings -\> Mapping and Geocoding Providers. Yahoo has been working well and fast for me. Try limit=2000 in the Address geocoder Scheduled Job, though there does not seem to be a rate limit set by Yahoo, at least there was not in October. I geocoded over 100,000 addresses overnight in October.

Here's the result of the scheduled job I just ran manually -

Parameters raw (from db settings): limit=2000

Parameters parsed (and passed to API method): a:2:{s:7:"version";i:3;s:5:"limit";s:4:"2000";}

Full message: Finished execution of Address geocoder with result: Success (Addresses Evaluated: 40 Addresses Geocoded: 40 Street Addresses Parsed: 29 )
> 1 votes

---
Tags: geocoding
---


# Question
Title: Why are you allowed to set DB field length on Text fields?
I know the documentation says you should leave it the same, but suppose I know I want the text field to be only 3 characters every time?

I can set it fine in custom fields, but when I go to enter data, and a user mistakenly puts in more than 3 characters, it throws a database error. Is there somewhere else besides the custom field specification where I can set up CiviCRM to validate user input?

(note: this can be reproduced on the civicrm demo server)

# Answer
> 4 votes
being able to set a length make sense. As you describe, you might want to have the length limited, because it's a zip code, a country code, a whatever you know has a fixed length.

The problem is not on the database definition, but on the user interface, that should prevent being able to put more chars that the field can accept.

Where do you experience the problem? is this in the back-office or using profiles?

Would be awesome if you could correct civicrm core to the check is done at the interface level (don't make the field longer than what the database can store) instead of the ugly error triggered by the database.

(You might want to check on the next version of civi see if you're lucky and that has already been fixed)

X+

---
Tags: custom-fields, database, error
---


# Question
Title: Reply-to address problems when reusing mailings
We're currently using 4.6.8 with Drupal 7, and we're currently finding that if you re-use an old mailing, but then change the From address, the Reply-to field remains according to the original mailing and is not changed. The result is that the Reply-to field is set incorrectly, confusing recipients as well as the owner of the incorrect Reply-to email address. Is anyone else having this problem?

# Answer
> 1 votes
The issue was that the replyto\_email field wasn't being updated by angular to pass it back to the database. I believe this was fixed in https://issues.civicrm.org/jira/browse/CRM-17650

---
Tags: civimail
---


# Question
Title: Is Civi supposed to redirect after a contribution form submission?
When submitting a contribution form, I first get taken to what seems like a truncated URL: `https://mysite.example.com/donate/?page=CiviCRM&q=civicrm/contribute/transact`. The HTTP response code is 302 and I get redirected to `https://mysite.example.com/donate/?page=CiviCRM&q=civicrm/contribute/transact&_qf_Confirm_display=true&qfKey=ea68d5378e175112aace8d733a982f53_5648`. Then the response code is 200 and the page displays all fine. I'm seeing all of this in the Network tab of the browser's developer tool.

My question is whether this is the intended behavior of Civi. This redirect seems rather odd to me.

I'm using Civi 4.6.8 with Wordpress 4.3.1 (multisite). I use a shortcode to load the contribution form into the Wordpress page (but without hijacking the whole page).

UPDATE:
I tried this on the Civi Wordpress demo site - http://wp46.demo.civicrm.org/contribution-page \- and I get the absolutely same behavior. First a truncated URL and a redirect to the complete URL. I also tried the test-drive link on the backend: http://wp46.demo.civicrm.org/wp-admin/admin.php?page=CiviCRM&q=civicrm%2Fcontribute%2Ftransact&reset=1&id=1&action=preview . When clicking Confirm Contribution there is again a redirect and then we get to the complete URL. So this redirect behavior doesn't seem to be related to the use of the shortcode.

# Answer
So when filling the form, you submit it (the data is into the post, so you have the feeling it's truncated as you don't see the params in the log/net tab). Once that data is processed, it needs to display something (the confirmation that everything went well).

They are two ways of doing that: \- either the result of the post is the confirmation message \- or you redirect to another page that displays the confirmation message

the second one (the one yo experienced) has several benefits: it's easier to redirect to another page (so you have a completely custom and different thank you page from outside of civi, and as importantly, it allows you to reload the confirmation page without resubmitting the contribution (that's why you have warning from your browser when you reload a page after you submit something)

Now, that design choice made many years ago doesn't make that much sense when you have forms in ajax (eg. with payment providers like stripe), but I don't think it's a problem to do a redirect, it doesn't create a major speed difference.

So in short: it's normal behaviour, nothing to worry about ;)
> 2 votes

---
Tags: wordpress, contribution-page, redirect
---


# Question
Title: How to permanently delete contact with API?
I'm creating an automated test script. It creates a test contact, does some stuff, then cleans up after itself by deleting the contact.

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

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

# Answer
> 12 votes
You can pass the `skip_undelete` parameter to the API, ie.

```
$result = civicrm_api3('Contact', 'delete', array(
  'sequential' => 1,
  'id' => 9999999999999999999, // replace with your contact's Id.
  'skip_undelete' => 1,
));

```

Obviously a lot of care has to be taken over specifying the id to delete...

---
Tags: api, 4.6
---