# Question
Title: How can I specify quantity of tickets on event participant import?
I'm trying to figure out if there is there a way to specify quantity of tickets? Like a person bought 2 tickets but civi participant import processes doesn't seem to let me specify that.

Any suggestions?

# Answer
There isn't a way to record multiple tickets directly - CiviCRM expects every event participant to have a contact record.

The simplest solution is to create a custom field associated with Event participants (or even with the participant role) that indicates the number of tickets booked. The only issue there is whether you can import the custom field - it should be possible, but I admit that I haven't tried this.

One way to get round the issue would be to import a duplicate event participant for the person who booked - but that could be confusing, as there's no way to tell when a duplicate is intentional. (The import process should allow you to skip duplicate checking).

A more complicated solution would be to create a new contact record for the guest (and create a relationship between that record and the person who booked), then import the event participant for that guest record. You can then go back in after the event and add in their real details (assuming you find out who the guest is).

This is assuming you're not also importing event fee information - it's not something we currently track, so I can't really help there - it's possible there are solutions available involving event fees/contributions.
> 1 votes

---
Tags: civievent, import
---


# Question
Title: How to make a membership renewal form pre-filled with last year's values?
I'm looking for some implementation advice (using Joomla 3.4 and CiviCRM 4.6.9).

A client has a price set in place for membership that includes several standard membership levels, plus a few extra optional add-on services members can select. That works well for signups. But for renewals we'd like to be able to remind them what they paid the previous year, which they could then update or accept as given.

My first thoughts on how to do this:

1. Have a membership renewal page that pre-fills and pre-selects values based on the selections they made the previous year? I don't see a way to set up a membership contribution page in such a way that would do this (can't call up contribution info in a profile for the contribution page?). Could I do this with a hook (which one?)? Or would I need to use the API?
2. I know 4.6.9 has new invoicing capabilities, could that be used in some way to pre-set the contribution form selection? Or could I set up a process flow whereby we manually create the invoice based on values from last year, and send them an invoice that has a link to a contribution page where they can pay the amount due shown on the invoice?

Any advice would be appreciated -- anyone implemented anything like this before?

# Answer
I am not commenting on the key part of your question (too late at night) but just want to be sure that you are aware of ability to send out 'checksum' in your reminder emails, so when the link is clicked by the renewing member they arrive at a Contribution/membership page and the user is temporarily logged in so the form pre-fills. That way the system knows who they are and will treat them as an existing member who is trying to renew. It won't, afaik, show how much they paid last time, but it will default to their existing Membership Type - which might be the same thing depending on how you set up your Price Set and Membership Types. Good luck
> 1 votes

# Answer
So you are trying to make membership renewal

you can include membership sign up in Contribution page please refer to the document below - Try this first and if you are not sure please let me know

http://wiki.civicrm.org/confluence/display/CRMDOC/Configure+Online+Contribution+Pages+for+Membership+Signup+and+Renewal

Question: are you going to make renewal manually or user will sign up manually

For Invoice : once you manage to create the above profile you can renew membership with pay later option which will create an invoice attached to contribution which you can send in Post or Email and once you receive the payment you can update the contribution to completed
> 0 votes

---
Tags: civimember, contribution-page, invoice
---


# Question
Title: Administrative activity under wrong admin user
I'm having a very strange (I think problem). I am logged in to the back end of my Joomla site with my superuser credentials. Several months ago I set up a test contact "Ritson The Dog" with the email as ritson@heritagemuse.com (He's a very talented puppy but has trouble with the opposable thumb thing).

Now, every administrative activity within CiviCRM shows Ritson The Dog as the Source Contact name. I looked through the forums and haven't been able to find where the default "Source" is set, but I think that may be the problem. Any thoughts?

Is there a way to batch change each contact activity record so that the source contact can be me and not my dog? Thanks, Kate

# Answer
> 1 votes
Usually the source is the logged in user. Are you by any way logged in as Ritson? Or did you accendentially overwrite your own civicrm profile?

# Answer
> 1 votes
As long as you don't mind losing any Ritson-specific activity, you should be able to merge the two records - this will change the 'source contact' to your record.

Change Ritson's email to match your own. You can use the Contacts \> Find and Merge Duplicate Contacts to match them, but it's simpler to just search for your email - you can select the two records on the search results list and then select 'Merge Contacts' from the action list.

On the Merge Contacts page, make sure that your record is the original, and Ritson's is the duplicate (if they aren't, click on 'Flip between original and duplicate contacts').

Make sure the contact information is **not** selected (as this will overwrite your record), and then select 'Move related... Activities'.

(You can move the other related data as well, but be aware that if the records have memberships of the same type, they will also overwrite your existing membership - there is an option to create a 'new' membership that will ensure both are kept)

---
Tags: contacts, admin, activity
---


# Question
Title: Is there an accepted standard for storing data as a year?
To preface this, I'm using CiviCRM's integration on Drupal 7, with the Webform integration module.

I'm looking to store a number of custom fields as a year. It appears that I am able to use the Date field type to store a date in the format of "YYYY", which sounds like what I want to do. However, the widget that is presented to the user to input the data requires you to choose a specific date from a date picker rather than a year, even if it only stores the year.

On top of that, when I use the Webform module integration with CiviCRM, the widget that I am presented with has 3 dropdowns, one for month, one for day, and one for year.

Ideally both the backend widget and the Webform widget would simply be a select box that allows you to pick only the year starting about 60 years back and ends 20 years in the future. I'm sure I could just make a select box to do just that, but I don't want to manually edit the values in a select box just to get a simple date field.

Does anyone know if there is a way to handle this the way I'm describing or am I stuck using a full date field to simply store a year?

# Answer
> 1 votes
You can achieve this in Webform by hiding the day and month fields as well as deselecting the enable pop-up calendar option on the webform component. There you can also set how far back you'd like the years to go.

However, Civi still stores the entire date. I believe the date will be stored as Today's date, 2015 12:00 am if you select 2015 for example.

# Answer
> 1 votes
I think "year only" widgets could be improved in CiviCRM. Until that happens, you might be better off with a custom field of type "number".

In the webform you can specify a minimum and maximum amount to limit it to reasonable years.

---
Tags: drupal, webform-civicrm, dates
---


# Question
Title: Where does the content of a bulk sms get stored?
Emails, pdf's, and single sms get their content stored in the field "Details" in the activity.

That is evidently not happening with bulk sms. Where do CiviCRM store the content of a bulk sms that has been sent out?

# Answer
> 1 votes
I figured it out.

It is stored in the table civicrm\_mailing as body\_text or body\_html

---
Tags: sms, activity, civisms
---


title: Case ID in e-mails from case

text:
# Question
Title: Case ID in e-mails from case
When sending e-mails from a case in CiviCRM the subject line contains a hashed case id between square brackets. It looks something like `[case #a234db] Subject of the e-mail` which is not really user friendly.

I have traced this behaviour back to the originating issue on https://issues.civicrm.org/jira/browse/CRM-5916 and the last comment is from Coleman in 2010:

> Perhaps this has already crossed your minds, but for orgs that are trying to offer friendly and personal services, adding a person's case number (or hash thereof) to message subjects is, well, kind of tactless. I know my org won't want to use this feature for this reason.
>
> Has anyone explored more unobtrusive options such as hashing the reply-to address or other message metadata?

My question is the same as in line with Coleman. Are there any options to solve the inbound e-mail processing and filing e-mails on cases whilst being user friendly in the subject.

Has anyone thought of a technique to do so? If so I might have time and funding to work on this.

**References header**

My first thought is to use the references header in the incoming e-mail to scan whether this is a reply to an e-mail send from within CiviCRM and then link it to the originating e-mail activity. More info on the reference header is given here: https://stackoverflow.com/a/7591704/3853493

What do you think?

# Answer
> 2 votes
UPDATE: I know this doesn't fully answer the question but noting the ability to change the code to an id or remove the subject code is now an extension: https://lab.civicrm.org/extensions/caseidinsubject

I originally had some doubts, but in 7 years have never had a problem, but for one org we removed the hash and just use the actual case id by editing the civimail template, and see code below for the processing side. It also accepts just \[1234\] without the # symbol. This was more for staff ease of use than for the recipient - this way they can send from their email program and bcc the email processor.

I don't have a scientific study to reference, but anecdotally many non-technical people don't "read" emails the same way people who stare at code all day do. Your experience may be different.

Here's the block from CRM/Activity/BAO/Activity.php that has the modification:

```
$matches = array();
$subj_to_match = CRM_Utils_Array::value('subject', $params);
if (preg_match('/\[case #([0-9a-h]{7})\]/', $subj_to_match, $matches)) {
  $key        = CRM_Core_DAO::escapeString(CIVICRM_SITE_KEY);
  $hash       = $matches[1];
  $query      = "SELECT id FROM civicrm_case WHERE SUBSTR(SHA1(CONCAT('$key', id)), 1, 7) = '$hash'";
} elseif (preg_match('/\[case #(\d+)\]/', $subj_to_match, $matches)) {
  $hash       = $matches[1];
  // this seems like an odd query but we are checking the id actually exists
  $query      = "SELECT id FROM civicrm_case WHERE id = '$hash'";
} elseif (preg_match('/\[#(\d+)\]/', $subj_to_match, $matches)) {
  // technically this is a subset of the one below, but keeping it allows a subject that had both and prioritize this one
  $hash       = $matches[1];
  // this seems like an odd query but we are checking the id actually exists
  $query      = "SELECT id FROM civicrm_case WHERE id = '$hash'";
} elseif (preg_match('/\[(\d+)\]/', $subj_to_match, $matches)) {
  $hash       = $matches[1];
  // this seems like an odd query but we are checking the id actually exists
  $query      = "SELECT id FROM civicrm_case WHERE id = '$hash'";
}
if (!empty($matches)) {
  $caseParams = array(
    'activity_id' => $activity->id,
    'case_id' => CRM_Core_DAO::singleValueQuery($query),
  );
  if ($caseParams['case_id']) {
    $merge_info = CRM_Mergetrack_BAO_Mergetrack::getLatest(array('type' => 'civicrm_case', 'id' => $caseParams['case_id']));
    if (!empty($merge_info)) {
        $caseParams['case_id'] = $merge_info['new_id'];
    }
    CRM_Case_BAO_Case::processCaseActivity($caseParams);
  }
  else {
    self::logActivityAction($activity, "unknown case hash encountered: $hash");
  }
}

```

The "mergetrack" part is a separate extension (I'd call it unstable and it has some core hacks). Recently the same org has started sending out emails automatically on case creation, and then often the case has been merged in between the time the email goes out and the reply comes back, and so it was getting filed on the deleted case. You can remove those 4 lines.

---
Tags: civimail, civicase
---


title: Logging functionnality disabled

text:
# Question
Title: Logging functionnality disabled
I used to have Logging functionnality activated on one of my civicrm instance but when i look at `log_civicrm_address`, nothing seems to be logged since quite a while.

When i look at the config screen `Administer -> System settings -> Misc (Undelete, PDFs, Limits, Logging, Captcha, etc.)`, the logging functionnality is disabled and neither set to `Yes` or `No`.

How can i re-enable this (and any idea why it's like that) ?

**EDIT**

CiviCRM is in version 4.6.5 and logging was activated in 4.2 (or maybe before).

# Answer
> 1 votes
Finally, i have found out that the disabling of Logging is caused by one of two things :

* Trigger permissions is not available on your instance (thanks Parvez for spotting that)
* You are in a multilingual configuration

In my cases, all our sites are multilingual so that's why i can't add the logging functionnality. For the site i was asking, the site was first monolingual and became multilingual which explain why i have been able to enable it and why i can't anymore.

I guess the multilingual triggers don't play nicely with logging triggers.

# Answer
> 1 votes
I don't have an idea why it got turned off; perhaps an upgrade cleared it?

At any rate, a fresh install does not set a default selection on these radio buttons. You should be able to simply select `Yes` and then save.

# Answer
> 0 votes
We use the logging functions for most of our clients. Really depends on what version of CiviCRM your on as to what the problem might be so if you could share that I may be able to point you in the right direction.

Also theres no danger in trying to turn it back on, it wont drop the old logging tables, it'll check for their existence prior to doing anything. If they exist then triggers will simply be added to the base CiviCRM tables.

---
Tags: logging
---


# Question
Title: How to include individual information within organization record
I admin a CiviCRM 4.6 site running on Joomla 2.5. It's a company-based membership organization, and we're looking for a better way to keep track of prospect activity. Here are a few considerations:

1. We process memberships manually, so all main members are organizations, with individuals receiving the "employee of" membership status.
2. We want to keep track of activities such as phone calls and emails from within the organization record, in case we get a new main point of contact for a particular company, the activity record stays in the same place.
3. We've created a separate category for individuals called "Main Contact" used for reports, so when we pull a list of members, we get the main contact person's information.

With this in mind, is it possible to have particular fields (such as name, title, email, phone, etc.) from the designated "Main Contact" pulled into the organization's record? I've worked with databases that did this, where you entered in the ID number for the main contact into the company record and it pulled in and linked the individual's information. Then, when running a report for members, you can set it to pull just member organizations, but have the person's name and contact info. It would also allow for easier prospect management, by being able to have a record of all activity stay with the company. So a new email from the company profile would go to the "Main Contact."

If this isn't possible, any ideas for a workaround?

# Answer
> 1 votes
Not sure if this is a helpful answer, but do you already know that when you create an Activity eg for a Phone Call, you can mark it as being 'with' both the Organisation and the Individual? Eg I would go to the Individuals record, add the Activity to them and then also find/add their Employer so the Activity record shows on both contacts.

# Answer
> 0 votes
I'm not quite sure if I understand what you are trying to achieve, when you say category, I guess you are referring to a custom field? If so what kind of custom filed?

What you describe is doable although I believe it will require some customization.

The only out-of-the-box way to do it that I can think of would be to use a **Contact Reference** custom field, which is the very useful auto-complete filed you find along the vast pages of CiviCRM (see custom fields documentation). You could have the Main Contact filed in the Organization's contact summary or in its own Tab, it wont give you the rest of information you are asking for but it will give a shortcut (a link to view the contact) to that particular contact.

Another option would be to create a custom extension to achieve your goal, hook\_civicrm\_searchColumns in conjunction with a few changes in the appropriate template will do the trick. I have a very similar case to yours, the difference is the Main Contact field is used for the Membership entity, we collect the information when the Membership is created, and we output it in the Membership Tab of the organization, in the Find Membership search result and also in some membership reports.

Hope that clarifies the path to go, let me know if you need more information.

(The black box pops up on hover)

---
Tags: civimember, civireport, activities
---


# Question
Title: Installing Direct Debit UK and Smart Debit extensions for civi 4.6
Has anybody installed the Direct Debit UK and Smart Debit extensions for Civi 4.6 (specifically) 4.6.10?

I've searched but can't find a definitive answer regarding compatability.

And, do these extensions work with webforms?

I know I could fire in, install and find out; but wanted to see if I could learn from other people's experience.

Cheers!

Craig

# Answer
we are the extension maintainers so hopefully can help with any questions. Yes, they're actively used and installed however they're not explicitly designed to work with webform.

We've just released a 4.6 ready version of the extensions that needed it, the rest are 4.6 compatible already and should indicate so.

Let us know if you need anything else.
> 2 votes

---
Tags: webform-civicrm, payment-processor, contribution-page, recurring-contributions
---


title: Non renewable memberships

text:
# Question
Title: Non renewable memberships
I want to create a membership type that is non-renewable. Let's say a membership that lasts for 6 months and is free.

If someone is already a member and clicks Join again (which is effectively a renewal) then I do not want them to be able to extend their membership (in other words an extra 6 months free). Is this possible?

# Answer
> 2 votes
I don't think non-renewable memberships are possible at the moment. Your options are to play with CiviDiscount and/or CiviRules.

You could offer a discount to get the first period free, or as petednz suggested look at negative discounts. I think the negative discount (fixed amount not %age) will need to be applied to existing members.

You could also have people add them selves to a group (say Trial), which gives the same privileges that the membership would provide, then perhaps CiviRules could be used to change the group to another say Trial expired, after 6 months.

# Answer
> 1 votes
I revised what I did here. Instead I used a Drupal rule to check the contribution path when someone renews, and then used the API to check if an existing trial membership had ever existed. I then executed some jQuery to hide the first row (the free trial) on the membership signup price set. This has the advantage of retaining membership upsell.

# Answer
> 0 votes
I would look at CiviDiscount and see if it can let you provide a negative discount for the membership and make it only available to people who have no Membership Status or similar.

---
Tags: civimember
---


title: Activities and Nodes in One Calendar

text:
# Question
Title: Activities and Nodes in One Calendar
I currently use Drupal's Calendar module to display CiviCRM activities on a Views Calendar. I also have another content type that displays nodes on a Views Calendar. Is it possible to display both CiviCRM activites and content type nodes in one calendar?

I tried the CiviCRM Entity module, but activities don't seem to be available as a field.

# Answer
> 2 votes
Drupal Views starts off with a base table - do you want to look at: User, Nodes, CiviCRM activities and so on.

So if the base table is Nodes, then it's looking at nodes for the date info and displaying them.

If the base table is CiviCRM Activities, it's looking at those for the date info and displaying them.

But currently in Views you cannot combine this data. They are two separate views.

Back in the forums there has always been discussions about combining Drupal node dates and CiviCRM event dates - it's the same problem.

So out of the box there is not really a solution for this.

---
Tags: drupal-views, calendar
---


# Question
Title: why are my expired memberships showing as current?
can't give any other details than looking at my memberships, I see every single membership is showing as current despite we are LONG past the date when the memberships expired.

All memberships were imported from a csv.

# Answer
> 2 votes
Is your cron running and is in the scheduled jobs "Update Membership Statuses" enabled?

If both are active what is in the "View Job Log" of "Update Membership Statuses"?

You can also run "Update Membership Statuses" manually once to see if this will solve your problem.

---
Tags: civimember
---


title: Can't create custom field

text:
# Question
Title: Can't create custom field
I can't seem to create any custom fields. I'm on the `/civicrm/admin/custom/group` page and I choose the "Add Set of Custom Fields" button. After filling out the form (setting "Used For" = Contribution) and hitting the Save button, I'm taken back to the `/civicrm/admin/custom/group` page, but my new Custom Data group isn't visible.

There are no error messages in the browser, nor in Watchdog. What could be going wrong here? I'm logged in as user\_id=1.

I'm using CiviCRM 4.6.10 on Drupal 7.41.

# Answer
> -1 votes
Is there an error in the log file in sites/default/files/civicrm/ConfigAndLog/ ?

---
Tags: custom-fields, contributions
---


title: Why won't civicrm/greeter load?

text:
# Question
Title: Why won't civicrm/greeter load?
I'm starting to learn extensions with http://wiki.civicrm.org/confluence/display/CRMDOC/Create+a+Module+Extension . I already need trouble-shooting advice. I can't figure out how to get civicrm/greeter to load. If I try to browse to it, I get the main civicrm page instead. Can anyone help me find the step I've missed.

# Answer
> 2 votes
I found my problem. civicrm/greeter didn't load because I had a typo (extentions as opposed to extensions) in my Extension Resource URL. Once I fixed that, it all fell into place.

---
Tags: extension
---


title: All admin Accounts are blocked

text:
# Question
Title: All admin Accounts are blocked
All our admin accounts are blocked accidentally. I have access to remote server as root. How do I reactivate the accounts

# Answer
Accounts are handled by the CMS, so it depends if you are using drupal, wordpress or Joomla.

Check the documentation of your CMS on you to enable then again, and you should be able to access your site again
> 1 votes

---
Tags: admin
---


# Question
Title: Why can't I import Individual Prefixes into the database?
When importing, Induvidual Prefixes don't seem to "take" and apply. Why is this, and how does one get around it?

# Answer
> 4 votes
Why?, well I have no idea (sorry to dissapoint!)

How to get around - well, it would appear that civi requires the numeric Value (1,2,3), rather than the label (Mr, Mrs etc) for the option. To find the values for substitution one can go to:

> **administer \> System Settings \> Option Groups**

and hit the "options" link to the right of "Individual Contact Prefixes". The prefixes in your csv will need to be substituted with these values.

Hope that helps...

# Answer
> 2 votes
Make sure the prefixes in the import exactly match the ones configured. If you have "Mr." configured but the import has "Mr", the record is imported without error but the prefix is not set (as of 4.6.10)

---
Tags: import
---


# Question
Title: Creating Couples as a Single 'Individual'
I am working for a non-profit and we are coming from a database that has couples as a single contact. To me, this makes sense because very often when things like donations come in, they come from the couple. In the rare instances that they don't there can be exceptions made. This also makes sense to me from a contact perspective because it allows for simple recording of contact data and simple creation of mailing lists.

As such, is there any way in CiviCRM to modify the data structure add a spouse field and spouse surname field to the Individual contact type?

As a further note, it would be great if this were searchable as part of the name in basic search.

# Answer
It would be better to create a relationship between the two - the Partner relationship type is there out of the box.

This will take account of each partner having different email addresses and different mailing preferences. Even different addresses.

You mailing list can be created from an Advanced Search for the Partner relationship with no difficulty.

All this allows you to segment your contacts more usefully.

This approach also negates the problem you add about searching on name.
> 2 votes

# Answer
If you don't want to associate the contribution with an individual, you can attribute contributions to Household records.

You'd still have to create individual records for each person, and add a relationship between them and the household. Because you can give relationships an end date, the information will remain in the system even if the individual's circumstances change - whereas if someone gets divorced, you'd have to remove the 'spouse' data, and the relationship would no longer appear.

The relationship would also remain in the system if you use the Partner' relationship, but using the Household means you can record the contribution without having to know who was specifically responsible for the contribution (e.g. if it was from a joint account).

Each record (individuals and household) would appear in the search, but I don't think the basic search listing indicates the relationship.
> 1 votes

---
Tags: contacts, relationships
---


title: Workarounds for Yahoo email throttling?

text:
# Question
Title: Workarounds for Yahoo email throttling?
My server host has informed me that Yahoo has massively throttled emails send from CiviMail (and thus we may be close to being blacklisted).

I have created a temporary smart group for all yahoo email addresses, to exclude from all mailings for the time being - but obviously just excluding all yahoo recipients forever is not an optimal solution to this problem.

I'm not getting bounces from this list. It's about 20,000 recipients total, about 4k of which are yahoo addresses. We send about 1-3 emails every other week or so.

Does anyone have any ideas on a workaround to maybe throttle the email delivery to Yahoo addresses separately from the rest of our list, or otherwise convince Yahoo that we're not spamming them?

# Answer
> 1 votes
Do you have DKIM keys on your domain? Yahoo and gmail get fed up real quick with poorly structured headers...

You could also switch to a service like sendgrid... and manage your reputation there. They will help you with that. You can also easily set up dkim keys to their server so they can be verified as sending email on your domain's behalf...

# Answer
> 0 votes
An update on this situation.

The realization that we were getting no bounces on this list seemed strange to me - zero bounces seems a little too good to be true. So after much scrounging, I found that gmail has been marking EVERY bounce notification over almost two years as spam - and so they weren't being processed by Civi as bounces. So of course Yahoo hates us - they're telling us we're wasting their time and we're effectively ignoring them.

We've fixed that and processed the notifications that remained in the spam box (only 30 days worth out of two years...yikes). While we work our way back into Yahoo's good graces, we've split out all yahoo addresses into their own mailing group, and then subdivided it into subgroups of about 1000 addresses each, and any time we do a mailing we're excluding the main yahoo group and re-sending it separately to each sub group over several days. It's sub-optimal (and sucks for time-sensitive messages) but is better than being blacklisted.

---
Tags: civimail, mailserver
---


# Question
Title: wordpress installation no zip file in download
Have downloaded CiviCRM 4.6 for Wordpress from CiviCRM website. Went to Wordpress "add new Plugins" "Upload" and instructions say to locate (from plugin "add new") zip file but my civiCRM download did not include a zip file?

# Answer
The version of CiviCRM for Wordpress that can be downloaded here: https://civicrm.org/download/list is a .zip file - if your initial download isn't a zip, check that you've downloaded the right version (e.g. the Drupal version is .tar.gz file).

That .zip file is what Wordpress is looking for - however, it's probably wiser to follow the instructions at http://wiki.civicrm.org/confluence/display/CRMDOC/Installing+CiviCRM+for+WordPress as @petednz-fuzion mentions.

The instructions recommend uploading the CiviCRM .zip to your WordPress plugin folder and then extracting the files - Wordpress' internal plugin installation process can manage this, but there are additional steps that WordPress will miss. (This is why CiviCRM isn't available in the Wordpress plugins listing - the installation isn't completely automatic)
> 1 votes

---
Tags: wordpress
---


# Question
Title: Drupal 7 unable to reach CiviCRM installer
I'm trying to install CiviCRM (4.6.10) on a fresh copy of Drupal 7 (7.41) but I can't start the CiviCRM installer.

**Error messages:** When I visit http://your\_domain\_or\_IP\_address/sites/all/modules/civicrm/install/index.php I get a Server Error 500. Looking at my logs they read:

```
PHP Fatal error:  require_once(): Failed opening required 'WP_PLUGIN_DIR/civicrm/civicrm//CRM/Core/ClassLoader.php' (include_path='.:/usr/lib/php:/usr/local/lib/php:/usr/local/php56/lib/php') in /home/hostname/public_html/test/d7/sites/all/modules/civicrm/install/index.php on line 75
PHP Warning:  require_once(WP_PLUGIN_DIR/civicrm/civicrm//CRM/Core/ClassLoader.php): failed to open stream: No such file or directory in /home/hostname/public_html/test/d7/sites/all/modules/civicrm/install/index.php on line 75

```

From Drupal

```
Notice: Undefined index: description in drupal_check_module() (line 1232 of /home/hostname/public_html/test/d7/includes/install.inc).
(Currently using CiviCRM settings does not exist CiviCRM settings file does not exist. It should be created by CiviCRM install)

```

**What I've tried:** setting folder permissions to 755 or 777. I have uploaded the CiviCRM files via ftp and also using the URL. I have re-installed Drupal 7.

I was able to successfully install CiviCRM on Wordpress on the same server but I'm stuck on the Drupal install.

To be clear, I downloaded and uploaded different CiviCRM installation. One specific to Wordpress (for Wordpress) and one for Drupal. The modules show up in my Drupal Modules section.

Any idea what I can do to kick start the installer?

# Answer
> 2 votes
It mentions WP\_PLUGIN, are you sure you downloaded the civicrm version for drupal, and not the one for wordpress?

You can't just re-use the same civicrm code base between wordpress and drupal, you'll need to download the CMS specific version again

X+

# Answer
> 2 votes
"CiviCRM has been successfully installed"!

The solution in my case was suggested by "jitendrapurohit" by clearing my cookies and cache. I re-opened the installer in an incognito window and it came up the first time and installed successfully.

# Answer
> 0 votes
My thoughts too Xavier, it is strange that it starts looking for WP\_PLUGIN if you are indeed using the Drupal installer

---
Tags: installation
---


# Question
Title: Restrict contacts available to be assigned to an activity
We're looking to restrict the contacts that are available when assigning an activity. Has anyone done this before?

The email function is really useful, but due to the sensitive nature of some of the information, we want to remove the possibility of human error as someone could accidentally choose the wrong contact to assign.

It would be great if this could be restricted by group the same was a custom contact reference field can be done.

# Answer
> 5 votes
The EntityRef field on the form can be given that restriction. Best way to do it is probably via a hook, e.g.

```
hook_civicrm_preProcess($formName, &$form) {
  if (is_a($form, 'CRM_Activity_Form_Activity')) {
    $form->_fields['assignee_contact_id']['attributes']['api']['params']['group'] = 1;
  }
}

```

(where "hook" is the name of your module and "1" is the id of the group)

Note use of `is_a` rather than the `$formName` so we also catch the case activity form.

---
Tags: activities, groups
---


# Question
Title: Contribution Page Include Profile Dropdown not displayed
I am relatively new to CiviCRM and it is really great.

But now i came to the first problem, which i am not able to solve.

I want to include profiles to a contribution page and in the documentation it says there should be a dropdown box but in my case there is no dropdown as you can see on the image. I already tried to delete the cache as suggested in another post. But that didnt work neither.

Can someone help me? Am I doing something wrong or is it a bug?

Greetings and thanks in advance Max

# Answer
> 1 votes
I solved the issue by deactivating several plugins

its probably a javascript problem

Thanks

---
Tags: profile, contribution-page
---


# Question
Title: Force membership sign-ups to register as user
As the title already says, I am trying to create a WordPress user for each person paying a membership fee.

Therefore I already checked the *Anyone can register* box in the WordPress settings.

What it should look like:

1. a person navigates to my site where the signup form (contribution page) is displayed (this works so far)
2. when he signs up he has to register as a user (so insert a password and username) - this part doesnt work so far there is only the email field and the billing fields.

Can somebody help me to achieve that?

# Answer
> 2 votes
When you create a Profile, in the Advanced Settings (at least for Drupal) there is an option to 'require user account creation'. So if you have this selected in the Profile, and then set that Profile to show on your Membership page then I would expect anyone completing the form to create a user account.

# Answer
> 0 votes
i just managed to do create a contribution page with a forced user sign up.

My problem now: i dont know what i configured different i compared every field with the other page and everything is the same. Also i tried to create another page with user sign up but there it again doesnt work.

I dont know how to solve this problem -.-

I know i can duplicate the page but i want to set up wordpress on a new server once i know how to configure civicrm and therefore i need to know how to configure that signup ...

Has anybody an idea?

# Answer
> -1 votes
you probably need to build a CiviCRM extension / WordPress plugin for this.

1. In the buildForm hook add a new field for username and password.
2. In the post hook take these details and create a user.

Reply here if you need further help,

---
Tags: wordpress, civimember, contribution-page, user-account, registration
---


# Question
Title: Running CiviCRM unit tests with an extension installed
(Please note - I am not asking how to create unit tests for an extension.)

If I want to see how an extension - or combination of extensions - impacts CiviCRM's functionality, I think it'd be really neat to run the standard UTs (thanks buildkit & vagrant :) with an extension installed.

My understanding at the moment is that Civi Unit Tests initialise a new copy of the DB when they're run, and mess about with it a lot.

Please can anyone tell me where/when I should hook in enabling extension functionality?

John

# Answer
> 2 votes
Agree that the typical configuration is to have a separate, headless database for running tests.

Your problem sounds similar to (but slightly different from) the problem of running unit-tests provided by extensions. In both cases, one wants to activate the extension on the headless database, so we may borrow some techniques from extension testing.

If I were you, I'd try preparing a DB snapshot with the extension preinstalled, e.g.:

```
cd ~/buildkit/build/mybuild

# Put the extension source code somewhere under `civicrm`, e.g
git clone https://mygit.example.com/myextension sites/all/modules/civicrm/tools/extensions

# Activate the extension in your main DB, e.g.
drush cvapi extension.install key=com.example.myextension

# Update the DB snapshot for your build
civibuild snapshot mybuild

cd sites/all/modules/civicrm/tools/extensions

# Restore DB & run tests at the same time
civibuild restore mybuild && ./scripts/phpunit CRM_AllTests

```

Each time you restore the DB, it resets both the main DBs (Civi+CMS) as well as the headless test DB using the latest snapshot.

You can repeat the last command whenever you want to run the tests. This ensures that the extension is active (even if some test went mucking around with extension data).

You can change `CRM_AllTests` to `api_v3_AllTests`, `api_v3_SyntaxConformanceTest`, `CRM_Myextension_MyTest`, or any other test class.

---
Tags: civicrm-buildkit
---


# Question
Title: I am a bit lost on CiviCRM's functionality
A friend of mine recommended CiviCRM to me as I am looking for a simple solution that helps me create an online platform able to inspire, initiate, facilitate and implement social bottom-up change.

I am looking fo a space that allows me to create a community in which every member is able to initiate their own projects, connect with members, invite members to join projects, create events etc.

I was trying to check out the demo of the system but could not enter and only got an error. Is there a chance to maybe find a introduction video, a different link to a demo or somebody who could maybe explain better to me what the system you have can do and how I could use it for the creation of the platform?

# Answer
tl;dr: start by reading the book :)

I think the most important thing for you to know at this point is that Civi is a *tool* not a complete *solution*. You'll get out of it what you put into it.

It's certainly possible to do those things by combining CiviCRM with other tools (namely Drupal or Wordpress + plug-ins), and if you do your homework and put in the time to craft the final product it could be perfect. Or if you don't, it could be a mess.

Here's an analogy to your requirement:

> I want to purchase a blender that can make healthy, delicious smoothies full of organic fruit, yoghurt or non-dairy milk (depending on the user's preference) and supplemental protein and/or vegetable powders. I want to be able to serve these beverages in tall, ice cold glasses to about a dozen friends on a weekly basis.

Well, if you know what you're doing, get the right ingredients, assemble it correctly (important: *put the lid on!*), and combine the final product with the right serving containers, yes your blender can do that (although one might argue that *you* are making the smoothies, not the blender). If you don't, it'll probably just make a mess all over your kitchen floor and ceiling.

But I digress about blenders. From your description it sounds like you are wanting to build a basic social networking site. CiviCRM doesn't do that at all. But if you use Drupal or WP to build a site with the social networking features you need, plugging CiviCRM into it can give you some additional features like mailing lists, fundraising tools, paid membership management, among others. If you don't need those things and just want a basic social networking site, then you probably don't need CiviCRM.
> 2 votes

# Answer
The demo has been down for most of the day today (11/19/15). And if you really want to test CiviCRM functionality you should create a sandbox (testing instance) for your self. Bitnami's CiviCRM installer is an easy and fast way to get started.

I think the biggest hurdle you're going to face, is to control what your users can do, for example allowing a user to manage their own events only and not allow them to edit other users' events. I suggest reading this case study. Getting this sort of functionality is not going to be out-of-the-box and you will need a significant amount of help.
> 1 votes

# Answer
You also might want to consider something like the Organic Groups module that integrates with Drupal (https://www.drupal.org/project/og). It is very flexible, but needs some work and knowledge to set it up for your individuals needs.
> 1 votes

---
Tags: wordpress, installation
---


# Question
Title: What is the best way to record in-kind contributions?
I am working with an organisation that would like to record in-kind contributions and pro bono support. These are gifts that they receive from other organisations in the form of services or support rather than cash.

They would like to record these contributions so that they can report on the value to the organisation - e.g. 'in the last year we have received £10,000 of in-kind support'.

What is the best way of recording this in CiviCRM? Should they just create another financial type for this? Will this cause any problems as it isn't actually money?

# Answer
If you create a separate financial type for in-kind donations, you can both track those separately and exclude them from the contribution reports (so as not to confuse things when you try to report on actual monetary gifts). So far none of the clients I have that track their in-kind gifts in this fashion have encountered difficulties with it.

Hope this helps, Lesley
> 5 votes

---
Tags: contributions
---


title: Read-only access to CiviCRM

text:
# Question
Title: Read-only access to CiviCRM
I would like to enable members of our Board of Directors to view our CiviCRM database without giving them permission to make changes. I.e., read-only access. Can this be done?

# Answer
You didn't specify which CMS you're using but between your CMS permissioning and Civi ACLs, that should be possible. See here for some info: http://book.civicrm.org/user/initial-set-up/permissions-and-access-control/

Just a thought to consider though... if you want to present particular sets of data to your board members in a simplified way, creating Views (if you're using Drupal) or similar presentations might be a viable alternative. Sometimes the back-end, administrative angle of Civi can be a bit confusing for folks who don't use it regularly, particularly if they're not very technical.

Hope this helps, Lesley
> 8 votes

# Answer
In Drupal (and I would assume the same in other cms) add a new role and give 'access civicrm' permission and also give 'view all contacts'.

This is the minimum permissions setup and should allow them only to view contacts. You should not then need to do anything with ACL's.

You may also want to give the permission 'access all custom data' if you are using custom data fields.

Ensure you do not grant the 'edit all contacts' permission for obvious reasons.

You may then want to selectively also give them access to other components such as civicontribute etc.
> 3 votes

---
Tags: permissions, acl
---


# Question
Title: How to change the default Activity dashlet to include activities other than "scheduled"?
CiviCRM 4.6.9. Drupal 7.30

How can I change the default Activity dashlet to include activities other than scheduled activities? By default, it only shows scheduled activities

# Answer
> 2 votes
You would need to change the code. But there is another way to get the Activities on your dashboard. Go to Reports, select Contact Reports and then Activities. If you then set all filters as you wish and tick the 'Available for Dashboard' option, and save the report as "My Desired Activities" (or any other name :-)) you should have a new dashlet available for your dashboard with your settings for activities?

# Answer
> 0 votes
I have found the file I need to modify. CRM/Activity/BAO/Activity.php

Change

if ($input\['context'\] != 'activity') { $commonClauses\[\] = "civicrm\_activity.status\_id = 1 ; }

to

if ($input\['context'\] != 'activity') { $commonClauses\[\] = " (civicrm\_activity.status\_id = 1 or civicrm\_activity.status\_id = 7 )"; }

---
Tags: dashlet
---


# Question
Title: How to copy an existing letter template?
I have created a custom letter template in CiviCRM, with letterhead, footers, graphics etc. It is saved under an assigned name. Now I want to use that template to create others for specific purposes, which will use the same basic format but differ slightly in detail.

How do I copy? If I open the original and change it, it overwrites the template I'm trying to keep.

# Answer
If you use that template when either sending an individual Mail or a CiviMailing you should have an option at the bottom to save as new template.
> 4 votes

# Answer
The best way I've found to do this is by copying the source code from your original.

To do this, edit your 'master' template that you want to use as your base. Go to the HTML Format section of your template and click the Source button in the Toolbar. This changes your WYSIWYG template into HTML and CSS code that can be copied.

Select all of that code and copy it to the clipboard. Go back to the template listing page, and add a new template. In the HTML Format section of the new template, click the Source button. Now paste your copied code into the HTML Format field. Click Source one more time, and you've got your 'master' template copied into a new template. You can make any changes you would like without overriding the 'master'.

You can use the same process on headers and footers as well.
> 2 votes

---
Tags: templates
---


# Question
Title: 4.6.9 upgrade fails - DB_Error:already exists -5
I've attached a screenshot of the error I get when trying to upgrade from 4.6.8 to 4.6.9

I have the rest of the trace, but not sure if I should post all of it.

Thanks in advance for your help.

# Answer
Have you taken an Backup before upgrading - if so, please check the old DB civicrm\_country table and verify that you have "Saint Barthelemy" country do exist or not - If it has then do delete it and run the upgrade again
> 1 votes

---
Tags: drupal, upgrade, database, error
---


# Question
Title: How to edit extensions git URL in www.civicrm.org/extensions
We are moving the main repository of one of our public extensions. How do we edit the git url in an existing node in www.civicrm.org/extensions ?

# Answer
Make sure you're logged in to civicrm.org, find your extension's listing in the search, then on your extension page click the Edit tab. You can also edit the name, development status and description.
> 1 votes

---
Tags: extension, civicrm.org
---


title: Email was not sent

text:
# Question
Title: Email was not sent
CiviCRM 4.6.10 for Drupal 7.41 Outbound email setting: either "Mail" or "Sendmail" Both system test were successfully, CiviCRM contribution form email receipts are working. However, no mails were received when test from Activity's "Send an email" and "Scheduled Reminder"

P.S. On the same server and same outbound settings, my other instance with CiviCRM 4.26 works just fine.

Can someone please help?

# Answer
> 1 votes
Emails can be tricky.

First question (depending on the answer I might have more):

Are all these mails sent to the same email address? Or could it be that some email addresses have a problem and others not?

---
Tags: email
---


# Question
Title: Is it possible to show scheduled meetings in an Outlook calendar?
I am working with an organisation that would like to show scheduled meetings and other activities in an MS Outlook calendar. The activities should show as calendar items in the calendar of the staff member who added them. So if a member of staff organises a meeting with a client this will appear in their calendar.

Is this possible?

They are using CiviCRM 4.6 on Drupal 7

# Answer
In Administer -\> Customize Data and Screens -\> Display Preferences you can enable "Include ICal Invite to Activity Assignees". That add an ICal Invite to the meetings and other activities and they can then be accepted and placed in the Calendar.
> 2 votes

---
Tags: drupal, activities, calendar
---


# Question
Title: How can I display only Cases without Case Managers using Drupal Views
I'm using CiviCRM 4.6.9, if it makes a difference.

I want to use Drupal Views to display only CiviCase cases that *do not* have case managers.

I feel as though I'm close... so close, but I'm not quite there yet. This is what I have set up.

I have a view that displays cases in a table format. I've add a *subject* field and a *contact* field to the view. I then added *CiviCRM Case Contact: Case Contact's ID* as a relationship, and to that I've added *CiviCRM Contacts: CiviCRM Relationship (starting from contact A)* which is set to use only the case manager relationship type, but is not required.

For filters, I've added *(CiviCRM Relationship (starting from contact A)) CiviCRM Relationships: Case ID (empty)*.

This **almost** works as I want it to. However, if a single client has multiple cases, and any one of those cases is assigned a case manager, none of their other cases will show up. I think this happens because the relationship is fetched via the clients ID number and not via the case ID, though as far as I can see, there are no views relationships that will allow me to fetch a case relationship via the case ID.

I can supply more information if needed.

Any help is greatly appreciated.

# Answer
> 2 votes
You are close. Add a Contact A relationship and use CiviCRM Relationship (starting from contact A).

Add both Display Names fields.

In filters, add CiviCRM Relationships: Contact ID B and set it to empty.

Here is a copy of a view of CiviCRM Cases.

And a pic of the filter:

**Update to solve multiple cases:**

To solve the folks with multiple case types issue, I created this page view but filtered for only one case type. I then added attachments to the view page for all other case types.

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


title: Is Vanco stable in civiCRM 4.4?

text:
# Question
Title: Is Vanco stable in civiCRM 4.4?
I saw this thread: Is Vanco a supported payment processor?

However the phrase is "will work through 4.4". Does this mean this is a stable, PCI compliant version of Vanco's processor for 4.4? Or should I revert back to 4.1 of civiCRM in order to be stable and PCI Compliant? I was a little worried since the 4.4 version was not publicly available.

Thanks for the feedback.

# Answer
Becca, the Vanco processor has been upgraded to 4.4 and is being utilized by several organizations. It is publicly available in git hub.

Hope this helps!
> 3 votes

# Answer
I don't know about Vanco, but I do know that CiviCRM v4.1 itself is not PCI compliant because it has not been receiving security updates for many years now.

4.4 is the minimum version of CiviCRM that still receives security support (although this too will probably end sometime in early 2016).
> 2 votes

# Answer
We recently discovered that due to some security updates at Vanco, our Vanco extension for CiviCRM 4.4.x may have some issues with using the processor in 'test mode' ( it works fine for live transactions).

We will fix that soon and add the updated 4.4.x extension to CiviCRM Extensions Directory.

Also, we are planning to work on Vanco extension for CiviCRM 4.6.x and will release it as soon as possible.
> 2 votes

---
Tags: payment-processor, vanco
---


# Question
Title: Webform civicrm integration not respecting permissions
On my webform, I enabled 2 contacts. Contact 1 has 'Existing user' enabled and set to 'static' and default value is 'current user'. Contact 2 has 'Existing user' enabled and set to 'drop down' and default value is 'relationship to contact 1' relationship = 'child of'.

My goal is that contact 1 can go to that form and select one of his children and fill out the form. The form doesn't respect the filter and displays all civicrm contacts in the drop down menu.

I also tried setting default values to use filters and set the filter to contact type to= campers, I also enabled the 'Enforce Permissions'. The drop down still displays all civicrm contacts for contact 1 even though he only has permissions to edit his/her child.

# Answer
Figured it out thanks to @Colemanw.

The relationship permissions are only for dashboard access and do not act as ACL permissions.

I installed this extension which transforms relationship permissions into ACL permissions. Now it is simple, I simply enable the 'Enforce Permission' option in the'Existing User' field and the drop down only shows the intended contacts.

Yosef
> 5 votes

# Answer
This doesn't answer your question specifically, but we create this exact functionality through Views and a Webform. The view does most of the heavy lifting.

We create a CiviCRM contact view, we use a contextual filter for the current user, add contact id for the child and render it in a table that displays the child's name and an Edit Now link to the Webform with a url of node/1?cid1=\[id\].

In our case, we use households as the relationship (that's why there are quite a few relationships), but it would be easier if you only had to use Child of.

On the webform, I only have one contact (the child) and it is set to static.
> 1 votes

---
Tags: webform-civicrm
---


title: How to troubleshoot Scheduled Reminders

text:
# Question
Title: How to troubleshoot Scheduled Reminders
A bit of background: I have several scheduled reminders triggered by activity types, which started to work unexpectedly after installing the CiviRules extensions. Once the extension is installed and enabled, after a scheduled reminder is triggered, it sends the message every time the cron job runs (every minute, as the activities are created on form submission from the frontend) and on top of that it doesn't log any activities to the targeted contact. Checking the job log I get this:

```
Parameters parsed (and passed to API method):
a:1:{s:7:"version";i:3;}

Full message:
Finished execution of Send Scheduled Reminders with result:
Failure, Error message: API (ActionLog, get) does not exist (join the API team and implement it!)

```

This was reported twice already, here and here, there was also a open issue, see CRM-17128, which was marked as closed, Cannot Reproduce, for obvious reasons if the issue has to do with CiviRules, which I believe it is, I've tested it on a fresh and clean install with CiviCRM 4.6.4/4.6.8/4.6.10 and Wordpress 4.3.1 and I can confirm that the issues only appears after installing/enabling CiviRules and it reverts back after uninstalling it. I've opened an issue in the CiviRules github project and I'm waiting for a reply but menawhile, my question:

Where to start debugging scheduled reminders?

Any help would be appreciated.

PS: no errors in Civi logs (debug and backtrace enabled) and no errors neither in apache/mysql logs.

# Answer
> 3 votes
Thanks to @jaapjansma from CiviCoop for all his help and support. The issue has now been solved and merged into the main CiviRules development, if anyone is facing this issue, check out the fix and PR here.

As an answer (kind of) to the question:

I couldn't find a straightforward way to debug so, in this case the *Reminder Sent* or *Membership Reminder sent* activity that Civi creates when a Schedule reminder is triggered wasn't created, that was the lead to investigate, using CiviCRM's debugging documentation (in a test environment, of course), turned out that the activity was created but with improper values, therefore the Schedule Reminder cron job would keep sending messages until the activity was completed.

Posting this as an answer just for the record.

---
Tags: wordpress, scheduled-reminders
---


# Question
Title: Why does CiviCRM keep logging me out of the website admin?
When I am doing various things in CiviCRM and want to save the changes, I keep getting logged out of the admin panel. As an example, but not the only scenario, I was trying to set up a custom profile for an event form. Set up the profile name and other data, hit save....went straight to the WP login screen! Anyone got any ideas? Most other functions working OK, but this is really annoying! Also happens when editing an event details, and select 'save and done' - 'save' works OK! HELP!

Using latest CIVICRM build 4.6.10 and Google Chrome on Windows 10.

# Answer
Check that the URL configured for your WordPress site matches the URL in your CiviCRM civicrm.settings.php

If these have different URLs, you will appear to be logged out when you move "between sites". This sounds like it could match what you're describing.

The URLs must match for all of protocol (http vs HTTPS), domain (example.org vs example.com) and hostname (www.example.com vs example.com).
> 5 votes

# Answer
I was about to give up on this issue when I found the solution! When you install Wordpress one of the settings is the base URL for the site, and you can choose the URL format to include or exclude the 'www.' part. When I installed Wordpress, I decided to exclude the www from the base URL, but when I set up Civicrm I put the www in the base URL! I know there is some settings in the .htaccess that sorts all this out but it appears that if these settings are different, for some features of CiviCRM, there ends up with a 'redirect' path in the URL. Result - confusion and logout! If anyone else has this problem, don't just look at the settings for sub-domains/directories, look at the www settings as well! I changed my paths to be consistent, and no longer get logged out!!
> 2 votes

# Answer
File permission issue?

It seems that your web server user does not have permission to write to the temporary/file folder....

Your files should in general have 755 permissions for directories and 644 for files... The owner of the files should be the the web server process for this to work properly...

Quick fix to set directories to 755 and files to 644, assuming linux install ...

sudo find /yourwwwroot/wp-content/plugins/civicrm -type d -exec chmod 755 {} +

sudo find /yourwwwroot/wp-content/plugins/civicrm -type f -exec chmod 644 {} +

sudo find /yourwwwroot/wp-content/plugins/files/civicrm -type d -exec chmod 755 {} + sudo find /yourwwwroot/wp-content/plugins/files/civicrm -type f -exec chmod 644 {} +

Oh and also check the file owner... if you copied it, it might belong to you and not the web server so it's process can't write to it...

Hope this helps...
> 1 votes

# Answer
This is happening to me as well on my Civicrm installation under Wordpress. I think I have linked it to a path problem but I don't know how to fix it. I have wordpress in its own directory and am using a .htaccess file in the root and directory of the installation. Using Civicrm 4.6.10 with Wordpress 4.3.1.
> 0 votes

---
Tags: civievent, wordpress
---


# Question
Title: Not be able to set up Membership Type and Payment Type
We want to build similar form as described here :https://glos.us/civicrm/profile/create?gid=15&reset=1 , into our new site here: http://manningmedia.net/glos/test/, We are not be able to show **Membership Type** and **Payment Type** fields on our new website, from where can we setup that ? to show it above the form.

# Answer
The links to the forms you've provided look like stand-alone CiviCRM Profiles.

To allow for membership registration with online payment, you need to set up a Contribution Page, which allows you to configure payment options and the types of memberships that can be selected, as well as on screen messages and email receipts. You'll include the profile you want completed in the set up as well.

The CiviCRM book explains in full detail how you can set up a Contribution page: http://book.civicrm.org/user/contributions/setup/
> 2 votes

---
Tags: civimember
---


title: Embed CiviEvent RSS Feed in CiviMail

text:
# Question
Title: Embed CiviEvent RSS Feed in CiviMail
Somebody already asked this on the old forums but there's no reply. I can see how to search for events by date then create an RSS or html version of the search results, but how do I display this in a Mailing? I'm sure it can't be that difficult but I've not managed to figure it out yet...

Thanks

# Answer
Would this be of help? https://civicrm.org/extensions/fancy-tokens

" There are several tokens for different time periods of upcoming events, such as 7 days, 3 weeks, and 3 months. After inserting the token into the body of the message, you can change the numeric portion of the token to whatever you prefer. This token will produce a nicely formatted HTML list of upcoming events, ie events starting after now() but before the end of the time period chosen. All event titles will be hyperlinked to the event information page."
> 1 votes

---
Tags: civimail, civievent
---


# Question
Title: It is possible to deduplicate contacts entered in a Webform?
I haven't found this issue in any other topic, sorry if it's been already asked.

I'm trying to automatically deduplicate contacts which enter to Civi from a registration Webform, but I haven't found a way. Is it possible?

Thanks in advance

# Answer
They are merged, based on the "Unsupervised" deduplication rules: civicrm/contact/deduperules?reset=1

By default the unsupervised rules for individuals are based on email-only. So if someone fills in a Webform with an email that already exists in civicrm then those data will be merged.

You can change these rules: http://book.civicrm.org/user/common-workflows/deduping-and-merging/
> 3 votes

---
Tags: drupal, webform-civicrm, duplicate-contacts
---


title: Image Extention .tif

text:
# Question
Title: Image Extention .tif
Does anyone know what image extensions CIVI recognises.

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

Thanks, Andy

# Answer
> 2 votes
You can add file types in Safe File Extension Options in the admin console. (I don't know if it's *advised*, but it's certainly *possible* :)

Go to Administer \> System Settings \> Safe File Extensions, then click 'Add Safe File Extension'. Enter the file extension (without the dot) in the Label field, make sure it's enabled, then save.

Edit: **However**, this doesn't actually help with .tif files. TIFFs aren't meant for web use, so (presumably) the image processing in CiviCRM or the CMS isn't designed to deal with TIFF files - it looks like CiviCRM has an additional check to stop the upload because of this. There are probably modules for Drupal that will add this capacity (Imagemagick comes to mind), but I don't know if they'll be picked up by CiviCRM.

If you don't need the images to be TIFF files, I'd recommend using a progamme like Irfanview ( http://www.irfanview.com/ ) to convert them to jpgs.

If you do need to have the files as TIFFs, then add a custom file field for the contact record - this will allow you to upload the files, but won't display a thumbnail. (You can always upload a jpg version as well to get the thumbnail).

# Answer
> 0 votes
I do think the extension check for uploading contact pictures is hard coded in CiviCRM. This might be on purpose or accidentialy.

---
Tags: extension, images
---


# Question
Title: Report error: Bad menu record in database
I'm using drupal 7 with CiviCRM 4.4.6

This error appear frequently when I view my report (including dashboard):

```
Bad item

Array
(
    [path] => /6
)

```

> Sorry but we are not able to provide this at the moment.
> Bad menu record in database
> Return to home page.

The path "/6" differ according to the report ID.

I'm not sure how this could happen, and when this error appear, all civicrm related functions will show error.

Anyone know what's the problem and how to solve it?

Addition:
After following @Prem Patel suggestion, this is what I found in \***/files/civicrm/ConfigAndLog file

```
Nov 26 17:17:19  [info] $backTrace = #0 /home/warrior/www/www/sites/all/modules/civicrm/CRM/Core/Error.php(322): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/warrior/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(239): CRM_Core_Error::fatal("Bad menu record in database")
#2 /home/warrior/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:1))
#3 /home/warrior/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#4 /home/warrior/www/www/sites/all/modules/civicrm/drupal/civicrm.module(456): CRM_Core_Invoke::invoke((Array:4))
#5 [internal function](): civicrm_invoke("report", "instance", "6")
#6 /home/warrior/www/www/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:3))
#7 /home/warrior/www/www/index.php(21): menu_execute_active_handler()
#8 {main}

```

# Answer
> 1 votes
Check after rebuilding the civicrm menu. You will get more details in your civicrm log file. Just enabled the debugging and logging from below link

site-name/civicrm/admin/setting/debug?reset=1

\***/files/civicrm/ConfigAndLog

---
Tags: civireport
---


# Question
Title: Can I tell if a contact has used their checksum to view/change their info?
I sent out an email message to people. I included a link with their checksum to a profile so they can review/update their info.

I can tell from the civicrm\_log or civicrm\_contact if they changed any of their contact info, but what if I want to know just if they visited the page even if they didn't change anything? Or if they changed something in the profile that is a custom field which doesn't update the log or contact?

Is there something on the drupal side maybe? The contacts don't have a drupal user.

# Answer
We set up a group specifically to track who has completed the profile and use the profile setting option to auto-add them to this group.

This way we have a group of everyone who completed the profile that we can exclude from future mailings prompting them to complete again.

This obviously won't track if someone has just visited the page, but for us, we're only interested in submissions.
> 2 votes

# Answer
If you sent this out via CiviMail with 'clickthrough' on then you might be able to confirm who used the link with the checksum
> 1 votes

# Answer
One thing you could do is to add piwik campaign parameters to the URL. If you use a code for your mailing as "Campaign name" and the civicrm contactid as "Keyword" you can track via piwik if people visited the page. You could also use the checksum, but that is more difficult to compare. https://piwik.org/docs/tracking-campaigns-url-builder/

With Google Analytics you can probably do something similar.
> 1 votes

---
Tags: checksum
---


# Question
Title: How do I modify a core CiviCRM file (to change a search order)?
Looks like one of core CiviCRM files (namely part of mySQL query at CRM/Contact/BAO/Query.php) has to be changed in order to achieve "Search results sort by Last Name". What would be the best (I mean, most proper) way in CiviCRM to do this?

# Answer
The answer is already here. According to tiny mention at the bottom of http://wiki.civicrm.org/confluence/display/CRMDOC/Directories page, it is possible (and, more important, it works!) to copy modofyed core files to **Custom PHP Path Directory** (at civicrm/admin/setting/path?reset=1) , preserving original files/folders structure, so next time CiviCRM gets security updates, changes should be kept (unless original file / function major changes).
> 1 votes

---
Tags: api, extension, hooks, developer, mysql
---


# Question
Title: CiviDiscount - applying sales tax on discounted price rather than original price
I found this in the CiviCRM issue tracker - https://issues.civicrm.org/jira/browse/CRM-16861

This is a pretty major bug for us - Has anyone resolved this issue on their own?

Essentially, when a discount code is applied, tax is applied to the original amount rather than the discounted amount.

# Answer
We've patched Cividiscount extension which now ensures that the discount also gets applied to VAT/Sales Tax when it's applied to price options. Here is the PR link: https://github.com/dlobo/org.civicrm.module.cividiscount/pull/131

Have also updated the ticket: https://issues.civicrm.org/jira/browse/CRM-16861

Thanks
> 4 votes

# Answer
we're about to release a patch for this which will fix the discount. I'll push back to this thread once released, hopefully within the next couple of working days.
> 1 votes

---
Tags: civicontribute, cividiscount, taxes
---


# Question
Title: Custom Mailing Labels and "Merge labels for contacts with the same address"
**This is not a duplicate of Is it possible to change the Mailing label format?**

While printing Mailing Labels, we've found that Addressee Tokens don't work as expected when "Merge labels for contacts with the same address" is ticked.

Mean, if one wants to get "Mr & Mrs Smith", {addressee} token should be used at **civicrm/admin/setting/preferences/address?reset=1**; we've tried to add "contact.formal\_title", but it doesn't get merged properly, only first value is printed, so it looks like:

```
 "Mr Smith Title
Mr A & Mrs B Smith "

```

instead of

```
Mr Smith Title  A & Mrs Smith Title B Smith

```

There is a **mergeSameAddress** function at \civicrm\CRM\Core\BAO\Address.php which works with **&$rows** parameter, but there is no "formal\_title" in a $row according to **print\_r**:

```
  [contact_type] => Individual
            [display_name] => H S W
            [do_not_mail] => 0
            [first_name] => H S
            [last_name] => W
            [prefix_id] =>
            [is_deceased] => 0
            [addressee_id] => 1
            [addressee_display] => H S W
            [addressee_custom] =>
            [address_id] => 20144
            [street_address] => 111
            [supplemental_address_1] => 111
            [supplemental_address_2] =>
            [city] =>
            [postal_code_suffix] =>
            [postal_code] => 111
            [address_name] =>
            [county_id] =>
            [state_province_id] =>
            [country_id] => 1226
            [individual_prefix] =>
            [addressee] => H S W
            [county] =>
            [state_province_name] =>
            [state_province] =>
            [country] => 111

```

What would be a proper way to add formal\_title as a part of a merged address value (assuming appending formal\_title to a first name)? Currently, **Prefix** works as desired, but it exists in a $rows, so can be easily retrieved. Not sure why formal\_title is not a part of this and it's not clear, where $rows data is came from.

**UPDATE**

Desired result has been achieved by modifying two core files:

1. civicrm/CRM/Core/BAO/Address.php

line 1059

> 'formal\_title' =\> $rows\[$rowID\]\['formal\_title'\],

line 1095

replace

> $family = trim(implode(" & ", array\_keys($first\_names)) . " " . $last\_name);

to

> $family = trim(implode(" & ", array\_keys($first\_names)));

2. civicrm/CRM/Contact/Form/Task/Label.php line 167

> $returnProperties\['formal\_title'\] = 1;

Just curious, how to make it according to best practices of CiviCRM development.

# Answer
The answer is already here. According to a tiny mention at the bottom of http://wiki.civicrm.org/confluence/display/CRMDOC/Directories page, it is possible (and, more important, it works!) to copy modified core files to Custom PHP Path Directory (at civicrm/admin/setting/path?reset=1) , preserving original files/folders structure, so next time CiviCRM gets security updates, changes should be kept (unless original file / function major changes).
> 3 votes

---
Tags: developer, mailing, address-labels
---


title: PayPal and Failing IPN's Issues

text:
# Question
Title: PayPal and Failing IPN's Issues
I am currently having issues with PayPal communicating with our website and CiviCRM. Half of the recurring contributions have not shown up over the past couple months and every one-time donation has listed as "Pending/Incomplete Transaction over the past week. Our current version of Civi is 4.4.3. We have checked the URLs and our web host has white-listed all IPN's even though they don't think anything was being blocked. We have also applied a few patches of code from newer versions and we are still having issues. Is anyone else having this problem. This is a bit out of the scope of my knowledge. Thanks.

# Answer
Does Paypal insist on an SSL certificate? Maybe yours is not compliant?
> 1 votes

# Answer
Did you configure IPN link correctly in your paypal accunt? Also you need to configure it in your server configuration file.
> 0 votes

---
Tags: civicontribute
---


# Question
Title: What's the quickest way to set up a developer environment on windows?
Wondering how to set up a dev environment with buildkit on Windows with the least amount of pain. Is there a shortcut like a prepackaged virtual machine image?

# Answer
you also need bash, it MIGHT be doable with cygwin (https://www.cygwin.com/), but I think it would be a considerable amount of pain.

The least pain imo would be: install Virtualbox, install Ubuntu on it and then follow How do I set up dev environment with buildkit?
> 3 votes

# Answer
Start with WAMP:

http://www.wampserver.com/en/

Windows, Apache, mySQL, PHP
> 2 votes

# Answer
I expect the WAMP stuff would be pretty straightforward as Kalanh suggests. But doing a buildkit might throw up some issues...I already get some issues on my Ubuntu machine, let alone Windows :-)
> 1 votes

---
Tags: civicrm-buildkit
---


# Question
Title: Deactivating Events - Registration Cancellation Notice
every time i delete a participant in an event, a registration cancellation notice is sent to them. I would like to deactivate that function - I system workflow messages I can only change the content, but not deactivate this. I may have to change civievent code. Any hints where and how? Best wishes, Michael

# Answer
This could either already solve your question and if not give a very good idea of where to look: https://civicrm.org/extensions/prevent-sending-event-registration-confirmation-back-office
> 2 votes

---
Tags: civievent
---


# Question
Title: How can I deal with "internal server error" during installer?
I'm trying to install, but it gives me this error:

> The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, webmaster@.... and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

LOG:

```
File does not exist: /home/master-folder/public_html/my-domain/500.shtml, referer: my-domain. /wp-admin/options-general.php?page=civicrm-install
File does not exist: /home/master-folder/public_html/my-domain/500.shtml, referer: my-domain. /wp-admin/options-general.php?page=civicrm-install
File does not exist: /home/master-folder/public_html/my-domain/404.shtml, referer: my-domain. /wp-login.php?redirect_to=http%3A%2F%2Fmy-domain.com%2Fwp-admin%2F&reauth=1
File does not exist: /home/master-folder/public_html/my-domain/favicon.ico, referer: my-domain. /wp-login.php?redirect_to=http%3A%2F%2Fmy-domain.com%2Fwp-admin%2F&reauth=1
File does not exist: /home/master-folder/public_html/my-domain/404.shtml
File does not exist: /home/master-folder/public_html/my-domain/demo
File does not exist: /home/master-folder/public_html/my-domain/404.shtml
File does not exist: /home/master-folder/public_html/my-domain/robots.txt

```

thanks

# Answer
> 1 votes
Is this before displaying the first step of install or once you start the install?

If this is during the installation, it might mean that your timeout is configured in a way that it considers the page dead before it properly has the time to finish the install.

You might want to workaround that by either changing the configuration to allow longer running pages, or try installing from the commandline (using wp-cli).

If it is before displaying anything, it might be that you haven't used the proper url or didn't put the files at the right place or...

If you follow the steps on that page, it should get you a running civi:

http://wiki.civicrm.org/confluence/display/CRMDOC/Installing+CiviCRM+for+WordPress

# Answer
> 0 votes
It's basically file permission issue. You need to check permission for those files that are responsible for this error.

---
Tags: wordpress, error, installation
---


title: Problem with membership import

text:
# Question
Title: Problem with membership import
I completed a membership import. Online screen messages indicate that the import was successful, but none of the members appear on reports and contacts do not have membership relationship. What could be wrong?

# Answer
I solved this problem.

When I did the initial import, I used a dummy start date value of 01/01/1961 for members that had a null value for start date. I believe this date caused the problem. I changed the date to 01/01/1995 and the import worked, plus I can see the data.
> 2 votes

---
Tags: civimember, import
---


title: Buildkit Issue - permissions?

text:
# Question
Title: Buildkit Issue - permissions?
I've encountered a problem (only recently) with buildkit, where when it comes time for me to run:

*~/buildkit/bin/civibuild install "civi46" --url "http://civi46" --admin-pass "password" --web-root "/var/www/civi46"*

I get

*++ CMS\_DB\_HOSTPORT=127.0.0.1:3306 ++ pushd /var/www/civi46 ++ '\[' -f sites/default/settings.php '\]' ++ rm -f sites/default/settings.php rm: cannot remove \`sites/default/settings.php': Permission denied*

But when I run

*sudo ~/buildkit/bin/civibuild install "civi46" --url "http://civi46" --admin-pass "password" --web-root "/var/www/civi46"*

I get

*\+ bower install -f bower ESUDO Cannot be run with sudo Additional error details: Since bower is a user command, there is no need to execute it with superuser permissions. If you're having permission errors when using bower without sudo, please spend a few minutes learning more about how your system should work and make any necessary repairs. http://www.joyent.com/blog/installing-node-and-npm https://gist.github.com/isaacs/579814 You can however run a command with sudo using --allow-root option*

This takes place even if I (shudder) set settings.php to have 777.

Even if I try to install civi manually after that, it is missing the files lang.php and civicrm-version.php.

With these copied from elsewhere, and the correct install details, clicking install results in "cannot lock table civicrm\_acl - doesn't exist". Of course it doesn't exist. I need you to create it, silly install.php!

# Answer
The `civibuild` command is designed to run as a regular shell user (e.g. `john`) -- without `root` permissions. The source code should all be owned by the shell-user, and the data files should be owned by a mix of `www-data`/`apache`/`www`/`john`. No files should should be owned by `root`.

The exact errors have varied (depending on the revision and the commands used), so I generally run a search to identify files with errant permissions, e.g.

```
## Searching for files owned by root (or not by john)
find ~/.npm/ ~/.composer/ ~/.drush/ ~/buildkit/ -user root
find ~/.npm/ ~/.composer/ ~/.drush/ ~/buildkit/ ! -user $(whoami)
find ~/.npm/ ~/.composer/ ~/.drush/ ~/buildkit/ ! -user john -a ! -user www-data

## Changing owner from root to john
find ~/.npm/ ~/.composer/ ~/.drush/ ~/buildkit/ -user root -exec chown john {} \;

```

Note that this search covers several folders, including:

* The caches generated by various build tools (eg `npm`, `composer`, `drush`)
* The caches generated by buildkit (eg `~/buildkit/app/tmp`)
* The actual build (eg `~/buildkit/build/mybuild`)

Additionally, if I've recently run `amp config` to change the permission policy, fixing the permissions on existing files can be pretty fiddly. I find easiest to delete the old build (e.g. `civibuild destroy mybuild` or `rm -rf ~/buildkit/build/mybuild`) and then recreate it.
> 1 votes

---
Tags: civicrm-buildkit
---


# Question
Title: How to set page title in an angular page?
I have created an angular page and module and it does exactly what I wanted it to do. However the page title is CiviCRM and I want to change that. How do I do that?

I have tried to set it in the javascript:

```
angular.module('myemma').config(function($routeProvider) {
  $routeProvider.when('/my-emma-accounts', {
    controller: 'MyemmaMyEmmaAccounts',
    templateUrl: '~/myemma/MyEmmaAccounts.html',
    title: 'MyEmma accounts',

    // If you need to look up data when opening the page, list it out
    // under "resolve".
    resolve: {
      accounts: function(crmApi) {
        return crmApi('MyEmmaAccount', 'get', {});
      }
    }
  });
});

```

However the code above does not seem to work.

# Answer
Short answer: add this to the top of your main angular html template:

```
<h1 crm-page-title>{{ts('Hello')}}</h1>

```

More info:

* Documentation can be found in the crmUi code.
* This feature is in 4.7+ (although if you use it in 4.6 it won't crash - it just won't look as good).
* Note the support for setting document title seperately if you wish.
> 3 votes

---
Tags: angular
---


# Question
Title: Send e-mail to multiple contacts as as separate mails
If I do a search, and then want to send en e-mail to the resulting contacts, (by using "**Send mail**", not by using "Send Mass Mailing") all of the contacts get put in the "To:" field.

But I want to either

* send all these e-mails separately. (x e-mails, with only 1 recipient per e-mail
* or put these recipients in the **BCC:** field instead of the **To:**

How can I achieve this?

# Answer
> 3 votes
As the previous answer states correctly, CiviCRM does in fact send individual emails to each contact you selected. The simplest way to know this is thats the only way tokens would work properly. If everyone was just to'd in one big list they'd all see one set of tokens (mail merge fields) which would not be correct.

If you wish to add others then you can using the BCC and CC fields but they'll get copied into every single email i.e. if 50 contacts are emailed then they'll get copied into those 50 emails.

# Answer
> 2 votes
Did you try? Because if I'm right CiviCRM does show all in the To, but actually sends them separately.

Even in Send Mail you can have token replacement, and that would not be possible if only one mail would be sent.

---
Tags: email
---


title: How to debug PayPal IPN issue?

text:
# Question
Title: How to debug PayPal IPN issue?
Environment: Joomla: 3.4.4, CiviCRM: 4.6.2, PHP: 5.4.45, MySQL: 5.5.42-37.1 HTTP only, no HTTPS, On Shared Hosting at HostGator

The site is a few months old, and we've had 30-50(?) online payments (member dues, events, donate) via PayPal Standard, but all of the transactions remain "Pending".

I've followed and double checked "Configure Paypal to Talk to CiviCRM" here ... http://wiki.civicrm.org/confluence/display/CRMDOC/PayPal+Website+Payments+Standard+and+Recurring+Contributions

* IPN is Enabled
* IPN points the sites home page, including "http://" (http://my-site.org) ... (worth noting the home page is managed by Joomla, not CiviCRM, but since the url is a "place holder' it does not make any difference I assume)
* Auto Return: On
* Payment Data Transfer: Off

I enabled the Joomla Redirect Component to catch any 404's, assume some how the IPN URL is wrong. But there have been no IPN related 404s in there. This makes me think the issue is either 1) the link back from the IPN is valid, but not being processed, or 2) the IPN never reaches the site.

I have enabled Logging in the CiviCRM Admin, but where should I look for IPN details? There are many log\_civicrm\_% tables in mysql, but none seem to log IPN details.

I assume PayPal IPN Simulator might give me some clues, but how do I construct a test URL?

# Answer
I kept pulling my hair out until we migrated to paypal pro (with it's own set of issues :)) but a couple of things to look at:

1. Check apache error log,
2. Paypal has a log that shows details of all IPN calls to server.
3. Make sure you have correct URL for http vs. https
4. Check civicrm log files in files/civicrm/ConfigandLog
5. Make sure firewall rules (and especially modsecurity) are letting things post
6. Don't know about joomla but in drupal, I always need to disable IDS (Intrusion Detection) for anon users and it often triggers false positives.
> 2 votes

# Answer
I found and fixed the problem. In this case the root cause was the site was moved at go-live. Interesting to note the CiviCRM Admin panels and CiviCRM frontend pages all worked fine.

I found IPN listeners in here: `/administrator/components/com_civicrm/civicrm/extern/`

I pinged the listeners URLs like:

```
http://my-site.org/administrator/components/com_civicrm/civicrm/extern/ipn.php

```

And got this error:

```
Could not load the settings file at: /home2/my-site/public_html/joomla3/administrator/components/com_civicrm/civicrm.settings.php

```

`/joomla3/` was the development subdomain.
> 2 votes

---
Tags: joomla, paypal, ipn
---


title: Mailing taking weeks to complete

text:
# Question
Title: Mailing taking weeks to complete
We sent out a pre-event bulk email to all event attendees on Nov 3. Today, we were informed by someone who just received their email today (Nov 30 - I can confirm in her message header that it arrived to her mailbox Nov 30, it wasn't that she just didn't see it until today). The Mailing Report lists that the mailing was successfully delivered to all 175 recipients, and that the start date was Nov 3, and the ending date was Nov 30.

Why in the world would it take nearly 4 weeks to complete a mailing to 175 individuals? How can we tell if it was just this one individual who didn't receive it until today? (The Activity includes the start date of the bulk email, but not the date that the activity was completed for her.)

Edited to add:

Now that I can find the reports, I see that the entire list didn't receive the mailing until yesterday.

Looking into the job scheduling and logging, I discovered that the job has been starting as scheduled every 15 minutes. However, the job log does not show that the job has finished executing until the time stamp that the mailing actually went out yesterday. SO... would this have been a problem with the server rather than with civi? Is there a way to get warning notices if a mailing hasn't completed within a certain amount of time so this doesn't surprise me (or less technically minded colleagues) later?

Further edit:

In an exchange with my hosting support (civihosting.com), we've decided that since it is working now, we won't pursue it to determine the reason. Kudos to anyone who can think of more information, though.

# Answer
> 3 votes
> How can we tell if it was just this one individual who didn't receive it until today?

The Successful Deliveries Report (Mailings \> Scheduled & sent Mailings \> Report \> Successful Deliveries) should show you the time each person was sent their email. You can also look at the mailings tab on each recipient.

I tested this on a sandbox where the **Send Scheduled Mailings** job was not active and set the **Mailer Batch Limit = 1**, and **Mailer Throttle Time = 120000**.

I had to execute the job manually multiple times, once for each email to go out. Perhaps your job did not process fully and then finished the next time it was run.

# Answer
> 1 votes
Mailings can be complicated. Do you know if you have a limit set for Mailer Batch limit or Mail Throttle time?

/civicrm/admin/mail?reset=1

---
Tags: civimail
---


title: Missing display option in dashlet

text:
# Question
Title: Missing display option in dashlet
I am not able to see any display option in civiCRM 4.6.10 Version of Joomla to show report on dashlet in bar/pie format under **access** tab in report instance. Please help from where i can activate the bar/pie option. I am getting tabular report when i check option

**Available for Dashboard? Users with appropriate permissions can add this report to their dashboard.**

# Answer
The option you're looking for isn't under the Access tab. It's below all the tab data. See the attached screenshot.

Note that most reports do NOT offer the ability to view a chart - make sure your report does! If you'd like to test, use the "Contribution Summary" report, which supports charts.

After you've changed the view, press the "Update Report" button, and on the dashboard, press "Refresh Dashboard Data" and you should be in business.
> 3 votes

---
Tags: webform-civicrm, payment-processor, contribution-page, recurring-contributions
---


title: Cannot see On Hold column in Views 3

text:
# Question
Title: Cannot see On Hold column in Views 3
I am trying to create a view in Drupal listing all contacts marked as 'on hold' due to their email bouncing.

I am unable to find this 'on hold' field for selection in Views. Is this by design or is there some fault with my install. If this is by design, is there a way to show this in Views so I can complete this 'report'?

# Answer
I believe the difference maker here is the CiviCRM Entity module. I have two Civi installs, one with it installed and one without. The install that has CiviCRM Entity has "CiviCRM Email: On Hold" as a field, just like Catorghans' answer indicates. The install that does not have the module only has the Email fields listed in your screenshot.

If you are able to install the module, Mark, I think you will find your solution. It is an excellent module that exposes a significant number of data fields to Drupal and Views. Out of the box only certain fields are exposed to Drupal as usable fields.
> 2 votes

# Answer
I see it under Email..

CiviCRM Email: On Hold
> 1 votes

---
Tags: drupal, contacts, drupal-views
---


title: On Import, where is county field?

text:
# Question
Title: On Import, where is county field?
I've noticed upon matching mapping fields in the import process that for some fields in the file they are missing in the CiviCRM drop-downs. For instance, for a field named "Home County' the CiviCRM drop-down for 'County does not appear. But choose 'Employee of' and 'County' appears. In fact, it is one of the only other, unrelated fields that it appears.

Please advise. Thank you in advance.

# Answer
The issue is almost certainly that the "County" field is not enabled by default, which suppresses it in the import dialog.

Go to **Administer menu \> Localization \> Address Settings**, and under "Address Editing", see if the "County" box is checked. If not, check it. Restart your import and the field should appear.

I also confirmed your report that County appears even if disabled as a field for related contacts. That's a bug, though a very low priority one!
> 3 votes

# Answer
Check the country field is there for which (contact, events, etc.) you are trying to import or not. Suppose you are trying to import contact then you need to check the country field is there or not for contact (you can check it by creating a new contact link). If there is no country field, then you need to add a custom field for contact.
> 0 votes

---
Tags: import, 4.6.10, fields, county, field-mapping
---


# Question
Title: Dashboard problem after installing reverse proxy server
We recently tightened up the URLs on the server so that everything now goes through https://domain\_name.com. There was initially a problem with the dashboard widgets not loading (just hanging on "Loading..."), so I installed nginx reverse proxy, which stopped the "Loading..." issue, but now I get the following displayed where each widget would be:

**Not Found
The requested URL /administrator/ was not found on this server.
Apache Server at domain\_name.com Port 443**

Everything else is working fine. It's just a problem with the dashboard widgets. Any ideas where to start looking for a solution? Thanks.

CiviCRM 4.6.8, Joomla 3.4.3.

# Answer
> 0 votes
It turned out to be a hosting problem. The /etc/hosts file had two conflicting entries, associating the host name with two different IP addresses. So I removed one of them, and Bob was my uncle.

---
Tags: dashboard, nginx
---


title: YTD growth as a dashlet

text:
# Question
Title: YTD growth as a dashlet
I want to display a dashlet showing growth percentage YTD this year, comparing with the same period last year.

I used the extension Advanced Fundraising reports to achieve this, but that extension gave me performance issues related to other site-specific features.

Now I am looking into Drupal Views, in the combination with this extension Drupal Views as CiviCRM dashlets.

However, I am struggling with how to use Drupal Views to calculate percentage growth of YTD CiviCRM contributions amount.

How to show the difference between YTD total contribution amount, and the same period last year as percentage, in a CiviCRM Dashlet?

# Answer
If you turn on dashboard caching with a long duration it might mitigate the performance issues enough for you to use the Advanced Fundraising reports?
> 1 votes

---
Tags: extension, drupal-views, dashlet, custom-reports
---


title: CiviDiscount based on group membership

text:
# Question
Title: CiviDiscount based on group membership
CiviDiscount gives an easy way to say, "Members get a lower price on a certain event", but I have the opposite situation - "attendees of a certain event get a discount on a membership". Can anyone tell me how to do this?

It seems like I should be able to use the "advanced API filter" to find event attendees - but I can't find any examples of how to use that option.

# Answer
Would using the Group Based Pricing extension be an option? You could then in theory create a smart group for those contacts that have attended the event and use that group in the price configuration?
> 2 votes

# Answer
I think the advanced api just allows you to add fields that would apply to contact.get api - e.g we use it like {"custom\_67" : "Retiree"}
> 1 votes

# Answer
Would this "Event Additional Signup" extension do the job: https://civicrm.org/extensions/event-additional-signup ?
> 0 votes

# Answer
If 'Participant' is allowed as an 'entity' in the entity box, {"event\_id": "nn"} where nn = event\_id of the event whose participants should get a discount seems like it should work w/out your having to put attendees into a group
> 0 votes

---
Tags: civievent, civimember, api, cividiscount
---


# Question
Title: Add Membership Token to PDF Template Joomla
I have been banging my head on this for a few days. I created a PDF Template for our members so I can run a search of members in Expired or Grace, then PDF a letter reminding them to pay their membership. I see the tokens for contacts, however cannot figure out how to add a token for Membership Type. Any suggestions

Joomla 3.4.1 CiviCrm 4.6.0

# Answer
> 2 votes
Are you searching for Contacts or Memberships? By default, Basic and Advanced Search return Contacts.

Your search needs to return Memberships, not Contacts if you want the membership tokens to be available in the PDF letter.

a) use Search \>\> Find Memberships

b) use Search \>\> Advanced Search and set "Display results as" to Memberships

In both cases you should have the "Print PDF Letters for Memberships" action that will let you include the Membership Type token.

---
Tags: civimember, joomla, tokens, templates
---


# Question
Title: CiviEvent registration with pay later prevented with "missing fields" error
We're running 4.6.8 on WordPress 4.2.4. I'm not finding guidance on this searching the web. Here's the CiviEvent registration page link:

http://civicrm.jrpc.org/?page=CiviCRM&q=civicrm/event/register&page\_id=111

We have an event that when registering by PayPal - it all works. But if "pay later" is chosen - it's complaining about missing fields that have already been filled out (address), or for the first and last name- it complains about the Country and Billing Name & Address that are not in our requested profile. Full error below:

Please correct the following errors in the form fields below:

```
Billing First Name is a required field.
Billing Last Name is a required field.
Street Address is a required field.
City is a required field.
State/Province is a required field.
Postal Code is a required field.
Country is a required field.

```

Any ideas? Our last event (before a few civievent upgrades), this feature worked fine.

# Answer
You may want to have a look at this issue.
> 2 votes

# Answer
There have been discussions in past about what happens if a required filled is in the Billing address block but is not ALSO included in a Profile. Not sure how closely that matches your scenario but try JIRA 15118

Otherwise googling for "pay later" and 'billing' and 'required' might score you something. hth
> 1 votes

# Answer
You just needs to unchecked the **billing address required** option under event configuration fees tab.

Sitename/civicrm/event/manage/fees/?reset=1&action=update&id=...
> 1 votes

---
Tags: civievent
---


title: CiviEvent Scheduled Reminder using SMS

text:
# Question
Title: CiviEvent Scheduled Reminder using SMS
I have to following use case:

I need to send SMSes to the guardians / parents of the event participants when the participants did not attend/no-show 15 minutes after the event starts.

I am incline to write a scheduled job to scan the civicrm status and then send out the SMS via the CiviCRM REST APIs.

Would this be the correct approach or there is already building blocks that are out-of-the-box that I can leverage on to implement the use case.

thanks.

# Answer
> 3 votes
You could use the two extensions CiviRules and SMS API.

We are using those two in combinations, to send a sms whenever certain triggers and conditions are met.

---
Tags: civievent, scheduled-reminders, sms
---