# Question
Title: Error uploading an image in email wysiwyg
I get this error when I try to upload an image in the email wysiwyg...

Could not load the settings file at: /srv/bindings/34923847/code/profiles/civicrm\_starterkit/modules/civicrm/../..//default/civicrm.settings.php

I have no problem uploading images for contacts. All my directories and resource urls seem to be good. I'm running civicrm 4.6.5 on D7. I started having this problem once I upgraded from civicrm 4.4.7 to 4.6

# Answer
> 2 votes
CiviCRM Starterkit is installed as a Drupal installation profile, so it's got the civicrm module directory inside /profiles/civicrm\_starterkit/modules rather than /sites/all/modules. CiviCRM is assuming that you can go up two levels from the folder where it's currently running and then over to the `default` folder to find civicrm.settings.php. That's not the case here.

A couple of things to do, then:

1. To deal with this in the short run, you might copy your settings file into code/profiles/default as a short-term hack.
2. File a bug report because obviously something's making an inaccurate assumption.
3. Consider whether using Pantheon and civicrm-starterkit is giving you any benefit. Just because something *can* work doesn't mean it's worth the extra effort dealing with a quirky host and an unmaintained distribution.

# Answer
> 0 votes
I had this same error message pop up while trying to run the scheduled jobs via url. Si I dug a little deeper and I was able to fix this by adding the custom code from the civicrm starterkit which is in these files:

Config.civicrm.php session.php Drupal.php

It's a little lengthy to describe each edit but if you download the starte rkit and a regular version of civicrm 4.4.7 you can vimdiff those files I mentioned and paste the custom starterkit code in your civicrm files it should work. A little messy but it did the trick

---
Tags: civimail, drupal, wysiwyg, ckeditor, pantheon
---


# Question
Title: Payment Processor Error message: 10525: Invalid Data This transaction cannot be processed. The amount to be charged is zero
When using CiviCRM 4.6.4, we notice when adding a $0 (Free) item to a price set, and a user contributes, they are asked to confirm, but then get this error with our Paypal Website Payment Pro processor:

```
Payment Processor Error message: 10525: Invalid Data This transaction cannot be processed. The amount to be charged is zero.

```

When someone chooses a $0 amount, no Paypal payment method is presented on the form, yet it still seems to opt-in to using that processor. We have no other payment processors enabled.

How do we fix?

We also notice that when using CiviDiscount,if we make a 100% off CODE for a membership, it is also rejected by Paypal with the above error.

# Answer
**Update your site to CiviCRM 4.6.7**

This was a bug, reported at https://issues.civicrm.org/jira/browse/CRM-14536

We had this problem on our site, and it was fixed as of 4.6.7. Update your site to the latest version, and you should be all set!
> 2 votes

---
Tags: civicontribute, civimember, paypal
---


# Question
Title: Civicase . how to copy a timeline or sequence
we're setting up a few case types, each of which has half a dozen timelines. Once we have set up one timeline, is there any way of duplicating it? I imagine that the timeline definition is stored in XML somewhere, in which case can I simply cut and paste in the XML?

Thanks.

Using CiviCRM 4.6.8 and Joomla 3.4.3.

# Answer
> 0 votes
The XML which contains the timeline data is stored in civicrm\_case\_type.definition as a BLOB.

# Answer
> 0 votes
As far as I know in principle yes. But my experience with CiviCase is mainly CiviCRM 4.4 and before. I do not know where the case type XML files are stored from 4.5 onwards but you should be able to find that in the CiviCRM documentation wiki.

---
Tags: civicase
---


# Question
Title: Can't see Note type custom field in reports
After setting up a custom data set "Member Details", I later added a new text area field called "Notes" to the set. My problem is that I find no way to get any membership report to show the Notes field. It isn't in the checkbox list of columns. I know the Notes field could potentially be a lot of text, but I don't care too much what it does to the report table. We have very short notes.

To see the Notes fields I must generate a report, click a contact, then click the Memberships tab, then click the View link on the right. So it's sort of cumbersome. I would like to be able to view a lot of notes at once in a report table format.

# Answer
Have you confirmed that your notes field is searchable? If it is, then the next step would be to check whether there are any ACLs working on that particular custom data set that might be restricting access.

Hope this helps, Lesley
> 3 votes

---
Tags: 4.6.8
---


# Question
Title: Upcoming activities in Case Control Panel - extend time span?
In the control panel for CiviCase by default you see activities scheduled for the next two weeks under "My upcoming activities".

Is it possible to extend or control this timeframe? If so, how?

# Answer
The definition is hardcoded in the view. See CRM\_Case\_BAO\_Case::createCaseViewsQuery().

So you need to change the mysql view definition in the database. Copy and paste the "CREATE OR REPLACE..." code in the above function into phpmyadmin (or whatever) and change the 14 as desired. But it might get changed on upgrades if that view definition changes.

The original spec said "default", but then making it configurable I expect was just time/budget/priority.

See also How can I modify what is displayed on the civicase dashboard?
> 3 votes

---
Tags: civicase
---


title: One Password for All?

text:
# Question
Title: One Password for All?
When someone signs up or registers, we need to generate a username and password. But for the password, we would like one (1), the same password for everyone.

Is this possible? And if so, how do I set it up?

Also for importing people in, and for new sign ups.

Thank you so much.

# Answer
> 5 votes
There is no setting to have the same password for all people signing in. If you have a CiviCRM installation that is accessible from outside your domain in any way I would strongly advocate you do NOT allow the same password for everyone. All security and integrity recommendations would mention that you do NOT allow all your users to have the same password?

# Answer
> 1 votes
If you go to Admin \> Users and Permissions \> Synchronize Users to Contacts ie at path wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/synchUser&reset=1 you will see the option "Synchronize Users to Contacts: CiviCRM will check each user record for a contact record. A new contact record will be created for each user where one does not already exist. Do you want to continue?" You can use this to generate the WP user for each record. Then you should be able to send them out an email telling them how to use their email to 'request new password'

Note the last instruction is based on Drupal know how, not WP but hope it works for you.

Afaik the integration will only take across an email address for the user. Hence if you have used a WP plugin to keep name and address, or a Drupal user fields/profile, then you will need to either use sql query or Export that additional data from WP/Drupal and import based on matching with the civi contact record based on matching the email address

---
Tags: civicontribute, wordpress
---


# Question
Title: How to display a contribution page in a drupal block (NOT USING WEBFORM)
Normally Webforms would be a go-to solution but I have an urgent need and it is lacking recurring contributions + a few other necessities.

I have a contribution page and would like to put in panels or a drupal block. I realize I can display a drupal block on a contribution page, but is it possible to display the page (no header, footer, etc.) in a block using an API call? I know hooks are used when civicrm creates a page but I'm looking to do this in a drupal block (without something crazy like an iframe?

# Answer
I don't think it'll work, no. Normally this might be done with `&snippet=1`, but it looks like that has a different meaning on contribute pages:
> 1 votes

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


# Question
Title: PayPal Security notice, do I need to take action / upgrade Civi?
Do I need to upgrade CiviCRM? Should I be concerned? I'm running CiviCRM 4.4.4.

See below:

> This is a reminder email. If you have already taken action, please ignore this notification.
>
> We’re contacting our merchants with some important information in response to an industry-wide security upgrade which is not unique to PayPal. This change involves upgrading Secure Sockets Layer (SSL) certificates over the course of 2015 and 2016. Our upgrade efforts for API endpoints are scheduled to start in June 2015.
>
> Because these changes are technical in nature, we advise that you consult with your partner, website vendor, or individuals responsible for your PayPal integration. They will be able to identify what, if any, changes are needed. Please forward the information below to your technical contact for evaluation. We are here to help your technical contact work through this to ensure you continue to process payments through your current integration with us.
>
> Full technical details can be found in our Merchant Security System Upgrade Guide. In addition, our 2015-2016 SSL Certificate Change microsite contains a schedule of our service upgrade plan.
>
> Questions can be directed to our Merchant Technical Services team on our Technical Support website. Click here for more information.

# Answer
It seems it is about your ssl connection, so it's on the openssl layer connected to your webserver (apache or nginx).

Test your ssl connection with that site, https://www.ssllabs.com/ssltest/ it will tell you what needs to be improved.

In short, nothing to do with civicrm, but upgrading to the latest version is always a good idea anyway
> 8 votes

# Answer
This is a notice regarding BOTH your website's SSL, and the ability of CiviCRM to use your system PHP and SSL libraries to connect to Paypal's SSL.

**SHA-256 support on your site**

If you use SSL on your website, you need to check that your certificate is SHA-256. This can be done quickly using shaaaaaaaaaaaaa.com, and you can get a more thorough review from SSL Labs (check for SHA-256 support in the results).

Note that this will affect not just PayPal but also common browsers in the near future. This is not CiviCRM specific.

**SHA-256 support in your hosting stack**

If your PHP or cURL libraries are old, or your server's root CAs do not match the updated certificates Paypal are migrating to, you may experience issues with payment when they update.

Unless your hosting environment is shockingly outdated you're probably fine, but you should either test in advance that your hosting environment will handle the upgrade, OR be prepared for issues arising on September 30 when Paypal undertake their migration.
> 5 votes

---
Tags: paypal
---


title: How to get all the groups for a contact

text:
# Question
Title: How to get all the groups for a contact
Starting from a contact ID, i need to find all the groups to which the contact belongs.

I know that i can use api `GroupContact` but it doesn't work for smart groups (in CiviCRM 4.5)

Is there any api calls that will retrieve all groups at once ? Otherwise, what would be the best way ?

# Answer
To get the Groups, you can use the `GroupContact` API

```
$result = civicrm_api3('GroupContact', 'get', array(
  'sequential' => 1,
  'contact_id' => <contact_id>,
));

```

To get all the smart groups to which the contact belongs, you can use this BAO function defined in GroupContactCache.php

```
$smartGroup = CRM_Contact_BAO_GroupContactCache::contactGroup($contactId);

```

returned `$smartGroup` will be the list of smart\_groups for the `contactId` passed
> 6 votes

# Answer
If you mean the api call "civicrm\_api3\_group\_contact\_get($params)" where you are passing contact\_id, I think it will return all groups, whether 'Smart' or not - did you try it? That call just passes contact\_id and if status is 'added' it should return the group
> 0 votes

# Answer
I am almost sure that the API GroupContact also returns Smart Group membership, my recommendation would be to test.
> 0 votes

---
Tags: api
---


title: civicrm dashboard won't load

text:
# Question
Title: civicrm dashboard won't load
civicrm 4.6.8/joomla 3.4.1/php 5.6.11

moved civi to new server

everything seems ok EXCEPT the civi home page which hangs trying to display the dashboard

here's the log dump from the error

http://pastebin.com/JY0xM3A6

so civi is losing connection to mysql ???

if i enter civi via another url
(eg http://..../administrator/?option=com\_civicrm&task=civicrm/event/manage&reset=1)

all is well. and i can navigate to every other civi screen and function without a problem. in place editing works fine.

but obviously hanging on the home page is a real problem for users.

my php environments are very similar (new host is slightly newer version).

http://yea.org/tmp/ChangeDetection%20-%20Comparison%20of\_%20phpinfo().html

yellow stuff is new host

tried trunc'ing dashboard\_contacts

php error\_reporting is the same as on the old site

any ideas to try?

# Answer
In my experience, this kind of thing is usually caused by something (a hosting setting?) trying to use a www.- site URL and CiviCRM using a non-www. site URL in the civicrm.settings.php files, or the othe way around.
> 1 votes

---
Tags: dashboard
---


title: Export Price Set Field Labels

text:
# Question
Title: Export Price Set Field Labels
A customer of mine has a contribution page setup with a price set (different payroll options) and they have specific labels for each amount in the price set.

When I go in to pull a custom report, I don't see an option to pull the field label; is this possible to do?

Is it possible to include these labels in the custom report that we export?

Thank you!!

# Answer
> 3 votes
You should install the extended reports extension and investigate the options available to you in **Extended Report - Contributions with Price Set data** or **Extended Report - Price Set Line Items**

---
Tags: civicontribute, civireport, price-sets
---


title: Unable to install v.4.6.x - Drupal7

text:
# Question
Title: Unable to install v.4.6.x - Drupal7
I tried all the day to install version **4.6.x of CiviCRM** on a brand new installation of **Drupal 7.39**, but each time I execute the installation here:

```
http://<your_drupal_home>/sites/all/modules/civicrm/install/index.php

```

I get a blank page and the following error in my logs :

```
PHP Fatal error: Class 'CRM_Core_Config' not found in /var/www/xxxx/sites/all/modules/civicrm/install/index.php on line 142

```

The method I used to install is simply downloading the compressed tarball and untaring it in the folder **/var/www/xxxx/sites/all/modules/**, and this after just having completed the installation of Drupal.

My confiuration is :

* Debian GNU/Linux 8 (jessie) server **with a private IP**
* Apache/2.4.10 (Debian)
* PHP Version 5.6.7-1 (with all prerequisites except using the PHP's bundled version of PCRE for which I cannot guarantee it has the **unicode properties support**)
* Content of the VirtualHost :

> ```
>  <VirtualHost 192.168.1.203:80>
>      ServerName xxxx
>      SetEnv CODE_SITE xxxx
>      DocumentRoot /var/www/xxxx
>      php_admin_flag  engine on
>      php_admin_value include_path "/var/www/xxxx/"
> </VirtualHost>
>
> ```

**EDIT 1**

> Nom I am sure that the PCRE version bundled in my PHP instance has the **unicode properties support** option enabled, since I could sucessfully execute (with no warnings) : `if(preg_match('/^\p{Arabic}+$/u', 'ﻎﺤﺤﺤﺤﺤﺣ')) echo 'OK'; else echo 'KOOOOOO'` and it displayed **OK**

Does anyone have any idea ?

# Answer
I finally succeeded to find the solution!

It was the VirtualHost's **include\_path** the problem! In fact it seems that CiviCRM's install script needs to add paths in it, and if it is already set, it cannot be modified with the PHP's native function `set_include_path(void)`.

So, I only had to **comment the VirtualHost's include\_path**, and it worked!

My VirtualHost looks like that now:

> ```
>  <VirtualHost 192.168.1.203:80>
>      ServerName xxxx
>      SetEnv CODE_SITE xxxx
>      DocumentRoot /var/www/xxxx
>      php_admin_flag  engine on
>      #php_admin_value include_path "/var/www/xxxx/" => this line must be deleted
> </VirtualHost>
>
> ```
> 3 votes

---
Tags: drupal, logs, installation, links
---


# Question
Title: How to notify CEO of large contributions?
How can you make an automatical notification to your CEO every time a contact donates more than 10 000?

# Answer
You could install the extensions CiviRules and Email API.

* Then you could set up a rule, which triggers on contribution added.
* The condition should be contribution total amount larger then 10 000.
* And then the action should be "send mail".
* There you have the possibility to select a template. If you have created a template containing tokens of contribution details (you can easily use the extension Summary Fields to have the appropriate contribution tokens), then you can use that specifically for this purpose.
* And then finally you can tick off a box to send the email to someone else than the contact itself. There you can write the email adress of your CEO.

Then your CEO will receive an automatical email containing the details (tokens) of the contact contributing more than 10.000
> 3 votes

---
Tags: civirules
---


# Question
Title: What are the best arguments to start using CiviCRM
From time to time I get the question about recommending CiviCRM to others. When recommending CiviCRM to others, what would be on the top of the list as the best "advantage"?

# Answer
> 4 votes
That depends on what they're comparing CiviCRM to. If they're comparing it to a current system of legacy software, Excel sheets, Google Forms, etc., that's different from someone who's comparing it to Salesforce or one of the other more serious competitors to CiviCRM. It also depends on what they want to use it for - pitching CiviCRM is very different for folks doing grassroots fundraising vs. case management.

To respond to some of these scenarios: There's a YouTube video of my lightning talk from CiviCon 2015 where I talk about CiviCRM vs. the competition here: https://youtu.be/TfIzV1sj9qY?t=14m34s. It's 5 minutes long - I meant to write it in a blog format, but haven't yet. In short: It's stories of how the other major vendors have screwed users over by jacking up license fees, created higher-end products at much higher prices than whatever they sell folks originally, or refusing to fix bugs at any cost. If you're a non-profit exec, these all cost you a lot of money.

If the person asking does community organizing or grassroots fundraising, CiviCRM is the only best-in-class CRM geared specifically toward those tasks.

If they're using Excel right now, it's the ability to get all their data in one place - not in someone's phone (or head), not spread across ten spreadsheets. Something as simple as "I want to send an e-mail to everyone we work with in San Diego" is a very difficult task without a CRM!

---
Tags: user
---


# Question
Title: Input in Memo/Rich Text Editor custom field results in error "There is a validation error with your HTML input"
When I try to submit an HTML link in a custom field of the type Memo/Rich Text Editor, in some cases I get the error message:

```
There is a validation error with your HTML input. Your activity is a bit suspicious, hence aborting

```

The input is a hyperlink in the most simple form:

```
<a href="https://www.example.com">Link text</a>

```

What's especially strange is that there are more fields of the same type in the same form that accept exactly the same HTML syntax.

I found no difference between using TinyMCE and CKEditor.

CiviCRM version is 4.4.19.

Any clues highly welcomed.

# Answer
The error you're getting is from the IDS (Intrusion Detection System). CiviCRM has a third-party IDS package that's bolted on, and it can certainly be overzealous. Its purpose is to prevent people from, e.g., submitting spam URLs into public forms.

However, assuming that you're logged in as an authenticated user and having this problem, the easiest solution is to grant yourself the "CiviCRM: skip IDS check" permission. You haven't specified your CMS, so I can't tell you where your permissions are, but grant your role that permission and you should see the error disappear.
> 4 votes

---
Tags: custom-fields, editor
---


# Question
Title: CiviCase - how to use for tracking grants we are applying for?
I've been asked to use CiviCase for tracking grants that my organisation is applying for but am unsure where to start. I'm trying it out with sample data, so I've created a contact called "Dummy Grant Body". I have also created a 'Case type' called 'Grant application'. So, under the "Dummy Grant Body" contact, I want to add activities like "initial grant enquiry", "grant application", "grant awarded/denied" etc. I have also been asked to do this in a way that shows grant deadlines/our activities in a timeline. I really don't know where to start and wonder if I need the help of a developer or is this something people have managed to do by themselves? Thank you! Lara

# Answer
> 1 votes
Have you had a look at CiviGrant? Although the workflow is not very detailed it does help to track what you have. You could set up a case type for the Grant process. This is something people have done by themselves. If you find you are stuck I would recommend you get functional support for a couple of hours. You might even need a developer (depending on what you want to achieve) but I would certainly NOT start there if you are not clear on where you need to go.

# Answer
> 1 votes
> I really don't know where to start and wonder if I need the help of a developer or is this something people have managed to do by themselves?

To a certain degree, this depends on the CiviCRM version you are using. 4.5 (if I am right) introduced a very nice configuration interface anyone can master. Before, case configuration required some tedious writing of XML config files etc.

Before getting to work, you should really try and understand the main concepts, i.e. the relationship between activities and cases, how contacts come in etc.. It boils down to this: First you define a case type and configure a fixed timeline of activities (typically, you will define specific activity types your case model requires). Now every time anyone creates a case of that type, the whole set of (future) activities is created along the timeline. A case has a target contact to which all the case data will be related. The details are covered here, a thorough reading should get you started.

It might also be a good exercise to analyze the process you are going to support with CiviCase. You can use Business Model and Notation (BPMN) for a graphical representation of your process/case. This will tell you, among other things, which activity types and roles you need.

# Answer
> 1 votes
There's an excellent article on this topic on the CiviCRM blog outlining your various options. It's from 2011, but the basics are all still relevant: Enhanced grant tracking: CiviGrant vs. CiviCase.

---
Tags: civicase
---


# Question
Title: All search modes redirect me to search page over and over.
The problem: **Every time I try to use any of the search functions (Find contacts, Advanced Search, full-text searh, etc), I fill out the fields, and when I hit "search", it takes me back to the blank search form.**

Background: We recently changed service providers and hosting for our entire site. At first, it seemed like CiviCRM did not get moved over, I was getting error messages like this:

Eventually, the IT service we work through (who arent specific to CiviCRM), got it to this:

Finally, he decided to instead uninstall and re-install CiviCRM. This worked, except he was then having trouble importing the existing Civi database. At this point the search was working, because I could use "Find Contacts", leave it blank and get two entries (the user doing the installation, and the organization I work for).

I know he has finally been able to import the database, because if I use the corner quicksearch, i can look for each individual contact, no problem, but trying to get a list of contacts has become impossible.

I've looked through the old forum and previous stack exchange questions but havent found anything. Any help, or pointing in the right direction would be greatly apprecieated!!!

# Answer
It sounds like your site is misconfigured at this point. There should never be a situation where QuickSearch shows more contacts than your other searches. Based on the initial screenshots, I'd look at the settings in `civicrm.settings.php`. However, at this point, you should consider hiring a CiviCRM professional to fix the issue - you may want to consider contacting someone from the CiviCRM Service Providers Association.
> 1 votes

---
Tags: wordpress, search
---


# Question
Title: Error message when trying to run scheduled email send - Joomla
I've acquired a site that is several generations of CiviCRM out of date - currently running 4.0.7.

I'm working through the upgrades and went to 4.1.0 where the new procedure for sending emails is implemented - unfortunately I can't get it to work

I'm trying to run it manually from the command line at the moment. The command I'm using is

php bin/cli.php -s demo1.network-midlands.co.uk -u \***** -p \***** -e Job -a execute

and every time I run it I get the following error

```
PHP Notice:  Undefined variable: cli in /var/www/vhosts/network-midlands.co.uk/demo1/administrator/components/com_civicrm/civicrm/bin/cli.php on line 30

PHP Fatal error:  Call to a member function callApi() on a non-object in /var/www/vhosts/network-midlands.co.uk/demo1/administrator/components/com_civicrm/civicrm/bin/cli.php on line 30

```

Lines 28-30 are as follows

```
$cli = new civicrm_Cli( );
$cli->initialize( ) || die(  );
$cli->callApi( ) || die(  );

```

it looks like $cli isn't getting defined on line 28 ($cli = new civicrm\_Cli( );)

Any clues?. I've since moved up to CiviCRM 4.1.2 to se eif that fixes it but it doesn't.

Note - Joomla is still at version 1.7 - I'm getting as many of the modules as up to date as possible before moving it all to Joomla 3

Thanks

# Answer
I don't think the problem is what you think it is (on line 28) because otherwise you should get that same notice (and fatal error) on line 29.

There are a whole bunch of bugs submitted on issues.civicrm.org relating to cron in early versions of 4.1. Since CiviCRM 4.2 supports Joomla 1.7, my advice is to upgrade to CiviCRM 4.2.20. Civi 4.2 was a "long term support" release, which means it was getting (some) fixes through April of this year. It should be in far better shape (especially as regards the cron system) than Civi 4.1.2.
> 1 votes

---
Tags: civimail, api, joomla, cron
---


# Question
Title: Can't log in to Drupal site: get redirected to random pages after submitting login form
I have one site with a very strange issue that I have been fighting for months and I'm clueless. All I know is that with CiviCRM disabled, the issue does not occur.

When I attempt to log in and submit the login form, instead of being logged in I get redirected to some random page and 404. For example, it will say

> Page /robots.txt not found

And I'm not logged in. The only way to log in is to disable CiviCRM via drush. Then everything works perfectly.

It's something in the DB because I can restore this DB to a fresh `settings.php` and `civicrm.settings.php` and the error persists.

The DB did go through an upgrade from D6 w/Civi4.5 to D7 w/Civi4.6, which is when the strange behavior started.

Thanks for your time and insights.

# Answer
> 2 votes
I discovered that this was caused by faulty PHP in the `template.php` file of my Drupal theme. Probably spent more than 40 hours trying to troubleshoot this, when in the end it was some custom code in my theme!

# Answer
> 1 votes
When I've experienced that general issue (Drupal login redirecting to wrong the page), it's been because Apache `mod_rewrite` was disabled.

However, some of your other symptoms are unfamiliar (eg being tied to Civi), so it may be a different issue.

---
Tags: drupal, upgrade
---


# Question
Title: Admin > system settings unavailable after wordpress database import
Part of my civicrm admin area and front-end forms are missing after import of wordpress database. I can see my contributions dashboard for example, but not the manage contribution pages section or any of the Administer area, so I cannot check systems setting \> resource urls, or cleanup cache etc. This means also that my forms are missing on the front end. I have reset my WP database and Civicrm database from a couple of days ago and it hasn't made any difference. Any ideas how I can fix this?

# Answer
> 0 votes
Thank you for your answers - upvoting your suggestions, all good answers. In my case it turned out that removing the temp files in civicrm/templates\_c/en\_US allowed those forms and backend areas to be rebuilt, so it was permissions in those files.

# Answer
> 2 votes
Sounds like a permissions problem. Make sure you are logged in as a user who has full "administer CiviCRM" permissions in Wordpress.

# Answer
> 1 votes
not files, your user ACL permissions (Admin\>Users & Permissions\>Access Control)- when you log in as an admin from WP. You can also 'sync users' in case your WP database import file had/has a different email address for you - check your Contact record in Civi - or create a new WP login for yourself as Admin and check

---
Tags: admin
---


# Question
Title: Custom participant fields not showing for anonymous users on event registration page
If I include custom (participant) fields in a profile on online event registration, these fields are not visible to logged-out visitors. If I visit the event registration page as admin I can see the custom fields.

I tried to reproduce this on the demo site, but could not.

Is there some permission that I am missing on my custom fields in order to have them appear on the event registration page for anonymous visitors?

\[civicrm-4.6.9, Drupal 7\]

# Answer
> 4 votes
I solved this by granting the Drupal permission "CiviCRM access all custom data" to the anonymous user role as per the documentation at the bottom of this page: http://book.civicrm.org/user/current/events/creating-an-event/

Note: this is a really freaky label on this permission. I find it very difficult to tick a box for anonymous users to "Access all custom data". What?

---
Tags: civievent, profile, custom-fields
---


# Question
Title: Does Summary Fields extension work on 4.6.x
The Summary Fields extension is listed as working with 4.4 and 4.5. I am testing it on 4.6.8 and when I go to the Summary Fields tab for a contact that does have some Contribution records I see blankness. I have debug and backtrace on but am not seeing any errors as such. I haven't used this Extension before so it is possible I am just not using it correctly. Does anyone have this working on 4.6 or is it known to fail?

# Answer
> 1 votes
I use Summary Fields on several 4.6 sites with no issues. Also - "Jamie" who left the comment is the author of Summary Fields, I'd follow their suggestion!

# Answer
> 0 votes
I attempted to use Summary Fields in a 4.6 Drupal installed CiviCRM and had an issue. I don't know any details of why, but it did load the Summary pages successfully, but took literally a couple of minutes for each page to load.

I am also holding back on upgrading a larger CiviCRM install at a non-profit purely because Summary Fields doesn't explicitly support the latest CiviCRM and my experience trying to install on this other site.

---
Tags: extension, summaryfields
---


title: Multiple Followups

text:
# Question
Title: Multiple Followups
I'm looking for a way to add multiple followups to an activity. I don't want people to have to go back into the activity and enter re-enter a new followup if possible. Rather, I was thinking of something like the Save + New Option that is present in other parts of the database. So far I looked at custom data to see if there were options I could modify but I'm still puzzled. If anyone has even the faintest of an idea I would really appreciate because it would at least give me somewhere to start.

Thanks a ton, V

# Answer
> 1 votes
Just a tip, not saying that this would completely cover your need...

If you install the new extension CiviRules, you have several automatic options.

I can imagine that you set up a rule like this:

* **Event:** Activity is changed
* **Condition:** Field value comparison for a certain field you have updated
* **Action (option A):** Create activity with a certain activity type, activity title, activity status and assignee contact. (Then it can turn up in a to do-list)
* **Action (option B):** install the Email API extension as well, and have the option to send a email directly to the assignee containing a template with contact info(tokens). (This is described here

So, instead of creating a separate Save and New option, you could have CiviRules automatically create the activity when you add certain values to the activity

---
Tags: scheduling, activity
---


# Question
Title: What is the scheduled job linked to Scheduled SMS Reminders?
In CiviCRM 4.5, you are now able to create Scheduled Reminders to be delivered by SMS as well as email.

We're having an issue with these reminders, however, I'm not sure which scheduled job triggers their delivery?

1. Send Scheduled SMS - Sends out scheduled SMS I thought this was the one to trigger bulk SMS deliveries that have been set up, the same and the Scheduled Email job?
2. Send Scheduled Reminders - Sends out scheduled reminders via email Refers specifically to the delivery of scheduled reminders, but the description refers to email only. Has the description just not been updated?

Would be really grateful if someone could point be in the right direction to investigate the other issue we're having.

Heather.

# Answer
I cannot answer your direct question, but I have an alternative solution.

We are using the extension CiviRules and the extensions SMS API and Email API to achieve the same.

Then you have the possibilities to set certain triggers/events, and conditions. At the end you can set different actions, and one of them is sending sms automatically via the SMS API

We are on 4.4, so you need to try it yourself though...
> 1 votes

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


# Question
Title: How do I create and access a database for civiCRM
I am trying to install CiviCRM in WordPress to see if the small NGO I work with might be able to use it. I got a domain name and installed WordPress through BlueHost.com and turned on the CiviCRM plugin. It says the following problems exist, and they all appear to have to do with a database. I don't have any experience with software/programming/IT. It appears I need to give access to CiviCRM to do stuff, but I have no idea how to do that.

I would really appreciate your help!! Thank-you very much!!

Sharone

CiviCRM Database Details

* Does the server exist?
OK (localhost)
* Are the access credentials correct?
That username/password doesn't work:
* Can I access/create the database? I can't create new databases and the database 'civicrm' doesn't exist. (user 'civicrm' doesn't have CREATE DATABASE permissions.)
* Can I access/create InnoDB tables in the database?
Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server. Could not determine if MySQL has InnoDB support. Assuming no.
* Can I create temporary tables in the database?
Could not login to the database.
* Can I create lock tables in the database? Could not connect to the database server.
* Can I create triggers in the database?
Could not login to the database.

# Answer
For testing purpose, it could have been nice to install it locally using a virtual box for example following this documentation: http://wiki.civicrm.org/confluence/display/CRMDOC/WordPress+Installation+Guide+for+CiviCRM+4.5.

But since you have stated that you have no experience in software/programming/IT, your best bet will be CiviCRM hosting providers: https://civicrm.org/providers/hosting
> 2 votes

---
Tags: wordpress, database, installation
---


# Question
Title: Contact which is both Organisation & Individual
Is there a way for me to create a new contact that is both an Organisation AND an Individual sub-type?

I have a case where I have created a new Individual contact, he is a 'Lecturer' which is a sub-contact type we have created within 'Individual'. But he also Advertises with us so I want to be able to add him as an Organisation - sub-type: 'Advertiser'.

I know I can attach multiple sub-contact types within the main contact type, for example:

\[Mr. John Smith\] - Individual: \[Member\], Individual: \[Lecturer\]

OR \[Mr. John Smith\] - Organisation: \[Society\], Organisation: \[Advertiser\]

I cannot seem to mix the two: \[Mr. John Smith\] - Individual: \[Lecturer\], Organisation: \[Advertiser\]. Is there an easy way to do this other than creating duplicate contacts under each contact type?

# Answer
> 4 votes
I would rather think like this:

Something he/she is --\> contact type

Something he/she does --\> group

If he is a person, then the contact type should be Individual. Maybe he works with or owns an Organization, then create a relationship.

To be a lecturer or an advertiser can change ( if he change job), but he will always be an Individual.

So to me it gives more sense to create two groups called Lecturer and Advertiser, and put this contact and the others in the corresponding groups.

# Answer
> 3 votes
No, you can not mix the two. To me it does not make sense to combine the two as they should be different legal entities. What I would do rather than create duplicate contact is create duplicate contact\_sub\_types? Or (if you have no specific data set for the contact\_sub\_type) use Tags to flag contacts as being a Lecturer? What would also make sense to me is to create Lecturer as a relationship? I assume he/she is Lecturer at some organization? Hope this helps!

# Answer
> 3 votes
What is he advertising? If he is advertising services, perhaps those services are done under a business name-- an Organization that perhaps you might want to record. Then it would make sense to create a relationship between his Individual record and his Organization record.

# Answer
> 1 votes
Seems to me the issue is that you have set things up so that Advertisers are a sub-type of Organisations, when in fact you have real Individuals who are also Advertisers, which suggests your structure doesn't match reality. What is the value to you have having a subtype for Advertisers at all? Could you have an Org SubType of 'Advertising Org' and a subtype for Individuals of 'Advertising Indiv'?

---
Tags: contacts
---


title: How to contribute to the documentation?

text:
# Question
Title: How to contribute to the documentation?
How do I contribute to the CiviCRM documentation?

I'd like to contribute to the Set-up page of the CiviMail documentation. There are some things that tripped me and I'd like to share them with others now that I figured them out.

Note: I tried clicking the link on the line "CiviCRM documentation is community driven. You can help improve documentation." (found at the bottom of the documentation pages), however it leads to a 404.

UPDATE: Here is the page which I wanted to edit: http://book.civicrm.org/user/current/email/setup/

# Answer
We're in a bit of a transition phase at the moment with the tools we use for writing documentation.

The authoritative user and admin guide is here: https://github.com/civicrm/civicrm-user-guide.

1. fork the repository (you'll need a github account to do that)
2. make the edit directly on your fork of the repository
3. submit a pull request back to the original repository with a summary of your edit, why you made it, etc.

If it is a small edit, then the above is all you need to do. If it is a larger edit (or if you just feel like it) then you probably want to submit a documentation ticket on jira to discuss what you are planning on doing https://issues.civicrm.org/jira/secure/CreateIssue!default.jspa

If you think that you'll be making a few edits, then here's a bit more reading that you might find useful.
> 6 votes

# Answer
"The CiviCRM User and Administrator Book - version 4.6" is at http://gitbook.civicrm.org/

To contribute see: http://gitbook.civicrm.org/the-civicrm-community/contributing-to-this-manual.html
> 3 votes

---
Tags: documentation
---


title: Error with CiviEvent Form

text:
# Question
Title: Error with CiviEvent Form
Having a few issues with Civievent forms.

Potential registrants are seeing these error messages.

1)Sorry but we are not able to provide this at the moment XML data could not be loaded. Make sure you specified the correct path.

2)When is does work and they click process. They see processing in the button and that screen never changes. They never know if it went through or not.

3) Confirmation emails are not being sent.

Any ideas with any of these ?

# Answer
> 1 votes
These error looks like an PHP error. Are you trying these in an fresh copy of CiviCRM ? please get the latest version and try the same

If you have any extension installed in CiviCRM please do disable all the extension and then try the same

---
Tags: civievent
---


# Question
Title: How can I make a custom report that displays info for three contacts based on relationships?
I've used Civix to make a duplicate of the default Relationship report, and I'd like to extend it to show basic information for a third contact. So we have Contact A and can specify criteria about the relationship with Contact B, and now I'd also like to specify criteria about the relationship with Contact C, if there is such a contact.

Civix helped generate a custom report extension and when I edit the PHP file, I can figure out how to duplicate some lines to produce the interface for the new columns and filters for Contact C.

The trouble I am having is in figuring how to properly name the duplicated array keys and variables so that I don't get "Unknown column" or similar SQL errors when I try to run it.

The goal is to be able to end up with a simple list based on a primary contact, showing (for example) their spouse's name and their child's name (given a relationship of "Spouse of" and "Child of"). If they have no spouse/child relationships then those columns would be blank.

Rather than hardcode SQL I would like to use the interface to allow selections of relationships for flexibility (and in case anyone else would have a use for it) but I am having a little difficulty as it is my first solid attempt to make a custom report with Civix.

At the moment these particular lines of the extension seem to be causing `** Unknown column 'relationship_type_c_civireport.label_a_c' in 'field list']` and `DB Error: no such field` errors. If anyone has a pointer, I would appreciate it!

# Answer
When starting on reporting I did a lot of debugging in my report and in the parent class to find out what was happening.

Your specific error: I strongly suspect `'relationship_type_c_civireport.label'` should be 'relationship\_type\_id\_c....' but I am not sure.

Check if there is a *postProcess* function in your class. If there is, it should call the parent *buildQuery* function to build the Query, you can check here how the query is build step by step.

Also, the select part of the query is build in the select function from `$this->_columns`. If you debug the values of `$this->_columns` you should be able to find your problem. Happy hunting! And keep going, it is hard work at first but you will get there.
> 2 votes

# Answer
If you are using Drupal then a View may be able to deliver you the required solution with less head aches.
> 2 votes

---
Tags: extension, civireport, civix, custom-reports
---


title: Paypal standard on contribution forms

text:
# Question
Title: Paypal standard on contribution forms
Getting this error when clicking on the paypal button on the contribution form:

Payment Processor Error message 10471: Transaction refused because of an invalid argument. See additional error messages for details. ReturnURL is invalid.

* I tried deleting the paypal standard as a payment processor to see what would happen but clicking the button gives the same error.

# Answer
You've probably done this, but the CiviCRM wiki provides instructions on how to set up the return URL for paypal.
> 1 votes

---
Tags: civievent, civicontribute, paypal
---


# Question
Title: I want to do something like "if campaign=xxx" {include footer} in System Workflow Messages
My colleague wants to include an email footer/signature for the email confirmation sent for event registrations, but only for the events managed by their office.

I know it's something similar to the answer on this question : Can I create a custom System Workflow Message for a particular Contribution Page?

But I'm just looking for the text required for campaigns. I've got as far as working out that the campaign ID=1

# Answer
> 2 votes
So you need to find out if the campaign id is assigned to a variable available in the message template.

I can't test right now, but if you enable debugging and add a {debug} if you template you *should* get a long and fugly table with all the variables available from the message.

then it's the same process as for the contribution page:

```
{if $campaignID == 1}
{* whatever you need to do on this message *}
{/if}

```

campaignID to be replaced by the variable available to the template as identified in the debug message.

---
Tags: civievent, system-workflow-messages
---


title: Changes in Quick Search/Search

text:
# Question
Title: Changes in Quick Search/Search
It seems that the ability to search on a list of last names (delimited by a space) was removed from searching. We are using version 4.6.4. Whether or not this was intentional, we need to be able to do this. Searching for each name (usually 80+ names) will be a much bigger pain. Is there any other way to do this search? We do know search builder can be used but hoping for a better, quicker way.

Thanks

# Answer
> 4 votes
This is by design - see https://issues.civicrm.org/jira/browse/CRM-15653 for an explanation and the reasoning.

Overall, I think this change was the right one - I worked with someone at a California-based public health organization who could never look up "California Department of Public Health", because basically all the organizations in their database had one of those words in the name! I'm sorry to hear that this change is a bug rather than an improvement for you.

I think Search Builder is a pretty good solution to this problem - you said you want something "better/quicker". I'm not sure how you're using Search Builder, but I would use "last name" "regex", then the names separated by the pipe character (this one: |). If that's still too much, and you're a developer (or have access to one), you can of course reverse the code changes in CRM-15653 on your local installation. If you go that route, be sure to check out CRM-15442, which is very similar.

# Answer
> 1 votes
Actually, it turns out that this doesn't help our client. I wasn't aware at the time but he uses the advanced search and needs to select a "Display As" selection, Activities for example. He tried to find a way to still use the search builder but wasn't successful. I ended up creating custom php changes to revert CRM-15653. This functionality was very important to his workflow.

---
Tags: search, quicksearch
---


# Question
Title: How can I make a civi event registration form that collects the individual's information as well as the organization to which they are affiliated?
How can I make a Civi event registration form that collects the individual's information as well as the organization to which they are affiliated? Would I have to use a webform? We're on 4.6.8, Drupal.

# Answer
> 1 votes
I have a number of webforms where the user is logged in and we have set the auto-complete to be based on the relationship between the user and their organisation.

Contact 1 is the individual and Contact 2 is the organisation.

I would imagine that using non-logged in users is similar, depending on how exposed the organisation list is? Would it make two contacts if there were none matching then create a relationship?

---
Tags: civievent, webform-civicrm
---


# Question
Title: Set Billing Address to be Not Required in Contribution Page
Authorize.net does not require a billing address. How can I configure my CiviCRM to also not require that on a Contribution page?

# Answer
I am surprised that Authorize.net does not require a billing address! I don't recall ever seeing that.

With that said, I would recommend you still require billing addresses. Right now the volume of fraudulent credit card transactions on non-profit sites seems to be skyrocketing and anything you can do to protect yourself would be prudent. The last thing you want is to have Authorize turn off your account due to fraud and you won't get any contributions then!
> 1 votes

# Answer
Does this issue correlate, ie do you have some fields that are required and are in the Billing Block and not otherwise available to the user via a profile? 15118

Only suggesting it as it just came up here
> 0 votes

---
Tags: contribution-page
---


# Question
Title: how to resend a mailing to corrected bounce addresses?
so i did a mailing, a handful of bounces on a vip group, so we took the time to find why the email addresses were invalid and fixed them.

How can we resent this email to the corrected emails? I did try to clone the mailing and exclude the ones that received the previous one, but civi is removing all the contacts, even those that didn't receive it.

# Answer
In Adv Search you can select the 'bounced' contacts for that specific mailing and then add them to a new group (or not) and fire a new Mailing off to them
> 4 votes

---
Tags: civimail
---


# Question
Title: Important Event Participants on CiviCRM 4.6.5 no longer supports external ID?
We've been importing event participation in 4.4.6 using their external ID (External Identifier). This appears to be no longer supported in 4.6.5.

Any way to get this to function again?

# Answer
> 1 votes
I found the problem: UPDATING events requires Internal ID, but skipping duplicate entries allows for the External ID. (Who knows why!)

---
Tags: civievent, import, 4.6
---


# Question
Title: How can I hide contact tabs depending on user role?
I want to give all Drupal Users with a specific role access to basic contact information from our database, but I don't want them to see things like the list of activities, groups joined, notes, cases, etc.

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

# Answer
> 2 votes
We often find that for most Drupal users who don't really 'need' access to civicrm, it is less painful for them to 'access' the data they should be able to get to via a Drupal View (which can be set with Role-based permissions). If you are not familiar with Drupal Views for Civi Contacts or CiviMemberships you may find something in our 'treasure trove' aka Views Library

# Answer
> 1 votes
In the Drupal admin bar, go to People. Click the Permissions tab. From there you can give each user role access to some of civicrm but not al of it. For example, you can choose not to allow access to civicontribute, or any financial data.

---
Tags: contacts, roles, contact-view
---


# Question
Title: CiviCRM Webform - Dedupe issue when using a shared address
We use webforms to register adults and children for events and memberships within the organisation. We require that adults register with an e-mail address but for children we do not expect this.

We have been testing more advanced dedupe rules (first name and last name and post code) to make sure that when children are registered for events they are allocated to their original contact record in CiviCRM. For better user experience we want to only have the address inputted once.

For some reason when the child entry uses a shared address from the parent the dedupe functionality does not seem to work. This seems to have been a historic issue that which was fixed (https://www.drupal.org/node/1368534) and quickly reviewing the code the logic seems to be there.

Can someone help and let me know if this is something I am missing on the set-up or a genuine bug.

If it is a bug how do we go about submitting for this module?

# Answer
Here is the commit originally made to fix that issue. I suggest you check the current version of the code to ensure that function is still working - seems possible that it may have been inadvertently broken during some restructuring around the way contact ids are stored.
> 3 votes

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


# Question
Title: Customize contacts screen to remove some fields
I am looking to remove some of the fields from the main contacts form - example Nickname, source etc. etc. - I am having a tough time finding the relevant information in Civicrm documentation and the only thing I find is display preferences which doesn't give me an option to disable fields

Any help will be appreciated

Thanks

# Answer
There was a blog sometime ago by Dalin that had a fairly in depth recipe if you want to take a look and see if that helps you make some progress. There is no option to do this through the UI - though it comes up reasonably often.
> 2 votes

---
Tags: contacts, summaryfields
---


# Question
Title: CiviCRM User Summit Sept 2016 - Any last minute ideas on how to convince another 20 people to register
CiviCRM User Summit - Any last minute ideas on how to convince another 20 people to register?

The Summit is September 24 & 25 See: https://civicrmusersummit.org/

What would make you want to come?

# Answer
> 2 votes
I received a somewhat clever promotion from DonorDrive yesterday to encourage behavior.

They were looking for survey respondents- anyone who filled out the survey within 25 minutes got an instant Starbucks gift certificate for $5 (printable).

I don't even like Starbucks, and I fell for it.

Maybe you could use this technique somehow?

---
Tags: community
---


# Question
Title: What will be the way to give user public access to check their contribution?
What will be the best way to give event registrant to check their payment and contribution status through an public front end form?

Is an email address with CAPTCHA authentication field appropriate to grantee the give access to real user preventing others/spammers?

The reason to do this through an extension is to give partial payment feature and refund request feature.

# Answer
The Contact Dashboard is a good way to show people their information.

Usually people need to login, you may be able to use a token to allow people to see it without logging in (not sure) but if payments are involved I would recommend people should have to login.
> 3 votes

# Answer
As Sanjay suggests you can use a checksum email, but requiring login is best. You should not need CAPTHCA. This presentation from CiviCON Denver 2015 "Frontend Partial Payments"

The framework should be available in GIT
> 2 votes

---
Tags: civimail, civievent, civicontribute, civimember, contribution-page
---


# Question
Title: Event registration using External Id to match contact.
Is is possible using a webform or profile to register for events using only the external id number. Matching the contact via email address (when a user is not logged in) always ends up being messy.

# Answer
Mike, without a customization you can not do this with events/profile. I am not sure if it can be done using a webform (the webform bypasses the event submission rules)

You can test this, not on your production site, by setting your unsupervised rule to only consider external\_ID and see if it works. I'm curious. If that works, then you should be able to use force that webform to use a different rule, but I believe that would also be custom.
> 1 votes

---
Tags: civievent, webform-civicrm
---


title: How to display events on a map?

text:
# Question
Title: How to display events on a map?
In the project I am working on a user can create an event with also a postal code information and address. I want to create a page where these events are all shown on a map, how can I do this with Civicrm or another wordpress plugin? The events are in Civicrm db.

# Answer
> 3 votes
I don't think there's anything out of the box that does this. But if you're comfortable with PHP/JavaScript then it's not too tricky.

I'd create a WordPress template for that particular page, grab the event data using the API, and manually populate a google map. Untested code based on a similar thing we did recently:

```
<?php

/*
Template Name: Your Template
*/

get_header();

?>

<script src="http://maps.googleapis.com/maps/api/js"></script>
<!--needs loading before the footer-->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>

<?php

//initialising CiviCRM Plugin
if (!civicrm_wp_initialize()) {
        return '';
    }

require_once 'api/api.php';

//Grab data from API
$result = api call

//print json-encoded version
echo "var events = " . json_encode($result);

?>

<script type="text/javascript">

//set up the map
var map;

function initialize() {

    //map properties
  var mapProp = {
    center: new google.maps.LatLng(53.156594, -3.847324),
    zoom:6,
    mapTypeId:google.maps.MapTypeId.ROADMAP
  };

  //set up map
  map=new google.maps.Map(document.getElementById("googleMap"),mapProp);

  //loop through event data
  jQuery.each(events.values, function(key, data) {

  //get lat and long
  //this is made up - adapt for where the lat/lng actually are in the data
  var latLng = new google.maps.LatLng(data.geo_code_1, data.geo_code_2);

 //create marker for each event
        var marker = new google.maps.Marker({
            position: latLng,
            title: socName,
            map: map
        });

    });

}

//initialize the map
google.maps.event.addDomListener(window, 'load', initialize);

</script>

            <h2><?php the_title(); ?></h2>
            <?php wp_reset_query(); ?>
            <div id="googleMap"></div>
            <?php the_content(); ?>

<?php get_footer(); ?>

```

Regarding the API calls, it looks like you'd need a few:

This'll get you the event title and its 'location block id':

```
$resultEvent = civicrm_api3('Event', 'get', array(
  'sequential' => 1,
  'return' => "loc_block_id,title",
));

```

you'd then need to look up the location block id for each event:

```
$resultLocBlock = civicrm_api3('LocBlock', 'get', array(
  'sequential' => 1,
  'id' => id from first query,
));

```

this'll then return an address ID, which you can look up with:

```
$resultAddress = civicrm_api3('Address', 'get', array(
  'sequential' => 1,
  'id' => address id from second query,
));

```

and the resulting array will contain the latitude and longitude.

It *might* be possible to do all the above in one go using chaining.

# Answer
> 0 votes
Create page in wordpress and include CiviCRM event using civiCRM Component in the page and also their are may wordpress plugins like (embed-google-map) you can use for map location

---
Tags: civievent, wordpress
---


# Question
Title: Mailchimp extension limits to most recent 25 lists
We have a Civi user connected to Mailchimp who has quite a few lists - from our testing (Mailchimp v 1.6, Civi v 4.4.6) the extension appears only to access the 25 most recent lists in Mailchimp. How can this limitation be increased?

# Answer
> 3 votes
The first thing I'd do is upgrade the extension from 1.6 to 1.8 to see if this issue has already been addressed. If it still remains, then I would create an issue at https://github.com/veda-consulting/uk.co.vedaconsulting.mailchimp/issues

# Answer
> 2 votes
Any use of the api without specifying the options.limit return only 25 results. So my guess is the MailChimp extension doesn't specify this option when retrieving the list of groups.

But as mentionned by Joe Murray, it's seems to be a bug in the extension that need to be fixed and an issue has been logged - https://github.com/veda-consulting/uk.co.vedaconsulting.mailchimp/issues/155

So there not much we can do here.

# Answer
> 2 votes
Follow up: This limitation has been removed and should be available in the next extension upgrade. See: https://github.com/veda-consulting/uk.co.vedaconsulting.mailchimp/pull/158/files

---
Tags: extension
---


# Question
Title: Warning when importing contacts/activities
warning pop up note when importing contacts or activities, same warning on the drupal demo site, go to contacts -\> import contacts/activities: 'Upload max filesize ('upload\_max\_filesize') should not exceed Post max size ('post\_max\_size') as defined in PHP.ini, please check with your system administrator'.

Is this something to worry about or this warning has always been there?

# Answer
This message means that your upload will likely fail on larger files. Update your PHP.ini file to fix this conflict.

More info: PHP change the maximum upload file size
> 4 votes

---
Tags: contacts, activities, import
---


title: Changing the CiviCRM Theme in Drupal

text:
# Question
Title: Changing the CiviCRM Theme in Drupal
Currently running CiviCRM 4.6.8 and Drupal 7.

I want my Civi theme to be different than the one I'm using for the Drupal front end. I'm all but certain I used to be able to do this through Drupal's "Appearance" tab. In fact, I've read a couple of things after Googling it that suggest that there's an option to change Civi's theme in *admin/appearance*, but I don't see that option.

I also saw some articles mentioning an extension or a module that will do exactly what I'm looking for. I'll use it if I have to, but I'd rather use whatever features are included if I can.

Thanks for any advice!

# Answer
you need to enable the civicrm theme module, that allows you to to set specific themes for backend and frontend pages. You don't need to download it, it's already there, you just need to enable it.

By default, it's the same theme that the other "normal" drupal pages and you need to have enabled the themes you want to assign to civi
> 6 votes

---
Tags: drupal, theme
---


# Question
Title: Upgraded civicrm but the previous jquery files are still being called
Upgrading from 4.0 to 4.1 by working through the fine documentation on wiki.civicrm.org. Cleared all drupal caches, deleted civicrm/templates\_c/\* and ConfigAndLog/\* ran civicrm/admin/setting/updateConfigBackend&reset=1, civicrm/admin/setting/path?reset=1

However menu dropdowns, tab expansion were not working since civicrm is still trying to open files from v4.0.8 namely in ../jquery/jquery-ui-1.8.11, ../plugins/jsTree.v.1.0rc2, jquery/jquery.js etc whereas V4.1.5 comes with jquery-ui-1.8.16 for example

Got the site operational by copying the old jquery files back into the codebase so most appears to be working.

What resets which jquery files are used?

# Answer
> 1 votes
you need to rebuild all the menu items please use the following Drupal sites: http:///index.php?q=civicrm/menu/rebuild&reset=1 and clear cache again

for more details please have a look at the below documents http://wiki.civicrm.org:8090/confluence/display/CRMDOC/Moving+an+Existing+Installation+to+a+New+Server+or+Location

# Answer
> 0 votes
Might be as simple as your browser's local cache. Try a force-refresh of the page.

---
Tags: upgrade, settings
---


# Question
Title: Household is missing from Dedupe rule page
A week ago I was deleting some rules in the 'find and merge contacts' page, and it appears to have deleted the entire block of household rules, so that there is no way I can add new household rules, and adding new households does not work due to no rules existing. The individual and organisation blocks are both there, but not the household one. How can I get this back?

# Answer
> 1 votes
If you have access to your db you might need to check the table civicrm\_dedupe\_rule\_group. If indeed you deleted the rows for Household, then you might be able to reinsert them there. I would suggest testing on a dev site if you have one.

These are the two rows I see

id contact\_type threshold used name title is\_reserved

3 Household 10 Supervised HouseholdSupervised Name and Email 0

6 Household 10 Unsupervised HouseholdUnsupervised Name and Email 0

---
Tags: contacts
---


# Question
Title: Why am I getting this message when setting up membership payment page?
Using 4.6.8 I have a monthly membership that is not auto-renew, and I am using a payment processor that supports recurring payments (Go Cardless for UK direct debit). Now I want to set up a membership payment page. In the 'Amounts' section I checked 'recurring contributions' but when I tried to save I get the message "You cannot enable both Recurring Contributions and Auto-renew memberships on the same online contribution page." Which isn't helpful as the membership isn't auto-renew. What am I doing wrong?

# Answer
> 2 votes
Isn't this because the auto-renew function on the Membership tab takes care of the recurring payment, so you don't need to also enable recurring Contributions? Does the Manual help clarify this for you?

---
Tags: civimember
---


# Question
Title: Does Google Hangouts SMS integrate with CiviCRM?
SMS seems to be hit and miss at the moment, with Twillo and Clickatell as the only choices. Since **Google Hangouts** can be used for SMS, is there a way to use that service, assuming the other two don't measure up? Is there anyone working on this, with an extension in anything resembling usable shape? What would it take, if nothing exists, to create something that uses Hangouts?

# Answer
> 1 votes
I have never seen this coming up for discussion and suspect the answer to that part of your question is 'no'. In terms of 'where to start', it would be worth looking at the two extensions Clickatell and Twilio but i suspect you have already looked at them.

Third option is to engage the services of a Professional or use the core teams Paid Issue Queue

---
Tags: sms, integration
---


# Question
Title: Consider Relationships in Contact Reports
Dear CiviCRM community!

I have a question. Our NGO need a report / list of all contacts for sending post letters. We now have some contacts that are married and they only want to get the letter once to one address. Since they contribute separately, we can not define them as a household and we created a relationship between them with the relationship function inside the contacts.

What would be the best practice to get these two people now in one list row, with a specific postal greeting and address between normal contacts who also need to be on this list?

Do I need to extend the relationship tab and write a custom report or is there an easier way with existing resources?

Thanks in advance for your suggestions!

Cheers Goran

# Answer
> 1 votes
When you do a contact Export or print Mailing Labels there should be options like "Merge labels for contacts with the same address". Does that take care of your need?

# Answer
> 0 votes
Can you create a Household contact and make them each members of the Household and direct your mailings to the Households? You should be able to preserve the Individual-ality of the contacts as they are... you're just adding another layer of data (which does add another layer of data entry to keep up, but you do gain the ability to target your data and data extraction appropriately).

# Answer
> 0 votes
If Pete's answer doesn't suffice, we wrote an extension for a client with similar needs that can help you.

Our extension adds tokens such as "Spouse's first name", "Spouse's last name", etc. Then, on CiviCRM 4.5+, you can use tokens as part of a postal/email greeting: https://civicrm.org/blogs/antrik/getting-started-new-name-and-greetings-features-45

You can even make the tokens conditional.

So to solve your problem, I'd create a smart group that grabs half of the people who are married (you may need to use an asymmetric relationship like "Head of Household" for this to work). If you're SQL-savvy, you can even change the existing relationships instead of creating new ones. I'd create a smart group of people who are NOT the Heads of Household.

Once you have the smart group, update your greeting IDs on the "Head of Household" records. Now, use Search Builder to search for everyone you want to appear in your report, but EXCLUDE the folks who are NOT the Heads of Household.

The result should be a list with the correct greetings and no secondary contacts.

All that said - Pete's answer is a lot easier, and in most cases will get you the same results! Please let me know if you need me to put the extension we wrote on Github.

---
Tags: civireport
---


# Question
Title: How should I generate a report (or view) showing contacts and people they have relationships to?
I would like to create a view, or custom report, whoever is easier, to show the following: -The names of all contacts in a specific group -Some of their contact information -The names of all contacts in specific relationships with them (parent-child, for example) -Some of the contact information of the above.

When I created a view, I wasn't able to filter by group membership. And when I went to create a report I wasn't sure where to get started. Got any tips for me?

# Answer
Our need was for class rosters which included the one or two adults approved to pick up the child from class.

The result is a list which displays a child's info on the same line as the adult(s) approved for pick up.

For this solution **we actually needed two views**; View A shows the adults and is embedded into View B which lists the kids, using the contact ID from each of View B's kids to connect to the adults. The key to this working is the Drupal module Views Field View. This allows us to insert a View into another view as a Field.

**===== View A "Picked Up By" (type: CiviCRM Contacts) =====**

***Format:*** Delimited text list (from the Drupal module Views Delimited List; this module is key because it allows us to insert the text OR into the result: "Adult A OR Adult B" and get both adults on the same line)

***Under Advanced \> Relationships***

We use 2 relationships to list the adults:

1. CiviCRM Contacts: CiviCRM Relationship (starting from Contact A)

~ Specific relationship type: Picked up by | Primary Pickup for (you could certainly use Parent | Child here)

~ Limit results only to active relationships
2. CiviCRM Relationship : Contact ID B

~ Relationship: the relationship you just setup, CiviCRM Relationship (starting from Contact A)

~ Identifier: CiviCRM Contact B

***Under Advanced \> Contextual Filters***

CiviCRM Contacts: Contact ID

* Do not use a relationship (if it forces you to use a relationship, then delete the relationships, create this contextual filter first, then create the relationships)
* When the filter value is NOT available, Hide view
* Specify validation criteria

-- Validator: Basic Validation

-- Action to take... : Hide view

***Fields***

* CiviCRM Contacts: First Name (using Relationship 2 - CiviCRM Contact B)

***Filter Criteria***

* CiviCRM Contacts: Is Deleted - False (using Relationship 2 - CiviCRM Contact B)

***Summary of how this works:*** The contextual filter takes the contact ID for the child (which will be supplied by the second view) and uses that as the contact ID for the first relationship. Then, the second relationship gets us to the adult as the Contact B of the Child/Adult relationship. Then you display the Name of the adult (and make sure that the adult hasn't been deleted with the filter criteria).

**===== View B "Rosters" (type: CiviCRM Contacts) =====**

***Format:*** Table

No contextual filters or relationships needed

***Fields***

* CiviCRM Contacts: Contact ID (this can be excluded from display, but needed later)
* Child's Name (we use Sort Name)
* Any other info you need for your kids
* Here's the all important field supplied from the Views Field View module: View: Include View

For this field, you select which other view (View A) you would like to embed into this view (View B). So, for View to include, you select View A ("Picked\_up\_by" in our case). For number of arguments, 1. For Argument #1, you use: \[id\] which is the contact id from the field you excluded from display above.

***Filter Criteria*** Filter the contacts in View B such that only the children you need listed are displayed, whether that is by tag (how we do it) or group or custom field.

This will also work with exposed filters as our rosters are divided up by a custom field "Grade" so we have an exposed filter on View B which allows us to select which Grade level we want to look at.
> 2 votes

# Answer
I will add this as an answer so i can add the screenshot. You 'should' be able to filter by Groups in a civicrm contact based View. In the screenshot you will see i have both Group Name and Group ID set as fields, and have Group ID set as an Exposed Filter. Hope that helps if only to confirm that something is amiss in the world of Views for you.

(Note: on the first site i went to do this on I also did not have them available, but that is a Pantheon based site where things keep changing on me, on the second which is a standard-hosted site it all worked as expected. So you may not be alone with the Group fields being unavailable)
> 2 votes

# Answer
I have managed to cobble together a view that mostly works:

go to admin/structure/views click "add new view" Show: civicrm contacts Display Format: Table fill out the rest of the fields as you like, then click "continue and edit"

In the view editor, click "advanced" under relationships, add the following:

CiviCRM Contacts: CiviCRM Relationship (starting from contact A) Choose the type of relationship you want. I chose Parent/child.

(CiviCRM Relationship (starting from contact A)) CiviCRM Relationships: Contact ID A Select "starting from contact A" Name this contact. I named it "child"

(CiviCRM Relationship (starting from contact A)) CiviCRM Relationships: Contact ID B Select "starting from contact A" Name this contact. I named it "parent."

Now that the relationships are in place, you can add your fields. for example, add a field "civicrm contacts: display name." it will give you the option to use a relationship. choose "child" from the drop down menu. Make sure to change the label to reflect what you've done. Then you can do the same thing again but this time pick "parent."

You will see a table that displays like so (please excuse my inability to create a table here):

Child Name | Parent Name

---

Tom Jones Jr | Tom Jones, Sr

---

Tom Jones Jr | Tabitha Jones

As you can see, the issue with this solution is that when a single child has two (or more) parents, that student is listed twice. If anyone has a solution to that issue, I'd be most grateful to have it. In an ideal world, the output would be as follows:

Child Name | Parent Name | Parent Name

---

Tom Jones Jr | Tom Jones, Sr | Tabitha Jones

---

I haven't yet reached that ideal state, but what I have does pull what I need, data-wise.
> 1 votes

---
Tags: civireport, drupal-views, custom-search, custom-reports
---


# Question
Title: How to fetch activity including custom fields using API
I hope this is a useful question + answer. I feel it's necessary to document some, um, quirks, of the API v3 around Activities and custom data, because as a developer this took me ages to figure out.

**I want to fetch all the details of a single activity, including custom fields.**

Currently (4.6.7):

* The normal activity get methods omit the custom fields.
* You can get the custom fields using some voodo, but then you don't get all the standard fields.

# Answer
Let's say `$params` is enough to find the **single** activity, e.g. `$params = ['activity_id' => 123]` where 123 is the known Id. But it could be any other API acceptable params.

```
$result = civicrm_api3('activity', 'getsingle', $params)
        + civicrm_api3('activity', 'getsingle',
                       [return:'custom_%,activity_type_id'] + $params);

```

The `custom_%` results in all custom fields being added. But this won't work without `activity_type_id` also being requested.

(You probably know, but the `$array1 + $array2` stuff in PHP means extend array 1 with key/value pairs from array 2 when the key from array 2 does not exist in array 1.)

## Alternative method

You can, list every field in the activity table as well as the custom stuff and in the `return` parameter to one API call.

However, this assumes that you know all the fields and that they won't change over time/upgrades. So the 2-call method above ensures that you're getting all CiviCRM has to offer on your activities. (Although you have to do extra calls to get the related contacts like targets and assignees etc. of course). It could be argued that you should only request what you want anyway.
> 2 votes

---
Tags: api, activities, 4.6
---


# Question
Title: How to find contacts that haven't confirmed their registration?
Coming through various channels (webform, newsletter subscription, api calls..) I have contacts that have never confirmed their subscription to a group.

If I go to the group tab, I can see that they belong to the group with the status "pending", and can manually confirm them

However, I didn't find on advanced search or custom a way to list all the pending ones (ideally, from longer than a few days ago), so I can send them a nudge "hey, you haven't confirmed your registration yet, please click here"

Is there an easy way to do that?

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

---
Tags: search, groups
---


title: Civicrm menu is hidden

text:
# Question
Title: Civicrm menu is hidden
After upgrading civicrm to the latest version 4.6.8 for drupal6 site, my civicrm menu is hidden. Kindly help me to fix the issue I am new to civicrm.

# Answer
> 2 votes
Try this steps :

1) Rebuild the menu by hitting this url `<your_site_name>/civicrm/menu/rebuild`

2) Clear Drupal cache using `drush cc all`

3) Clear browser cache -- mostly done with `Ctrl+Shift+Del`.

---
Tags: drupal
---


# Question
Title: drush civicrm-sql-dump dumps the drupal database - how do I get it to dump the civicrm database?
I've recently made some backup scripts to automate backup of my site and databases. One of the scripts uses drush to dump the drupal and civicrm databases with these commands:

```
drush @myserveralias cc all && drush @myserveralias sql-dump --gzip --result-file=mydrupaldatabase-150731.sql

drush @myserveralias cc all && drush @myserveralias civicrm-sql-dump --gzip --result-file=mycivicrmdatabase-150731.sql

```

My problem is that both of them dumps the drupal database - I would like the second one to dump the civi-database.

Should i somehow specify the civicrm database? My aliases.drushrc.php doesn't specify anything about databases under myserveralis - should it be specified there? My settings.php has this to say about databases:

```
$databases['default']['default'] = array(
'driver' => 'mysql',
'database' => 'drupal',
'username' => 'myusername',
'password' => 'mypassword',
'host' => 'localhost',
'port' => 3306,
'prefix' => 'drupal_',
'collation' => 'utf8_general_ci',
);
$databases['default']['default']['prefix']= array(
  'default' => 'drupal_',
  'civicrm_acl'                              => '`civicrm`.',
  'civicrm_acl_cache'                        => '`civicrm`.',
  'civicrm_acl_contact_cache'                => '`civicrm`.',
  'civicrm_acl_entity_role'                  => '`civicrm`.',
  ...

```

Thanks in advance for any help.

EDIT: I've updated drush to version 7.0.0, and the call to civicrm-sql-dump now fails with the following error:

```
PHP Fatal error:  Call to undefined function drush_sql_dump_execute() in /sites/all/modules/civicrm/drupal/drush/civicrm.drush.inc on line 995

```

I guess there's no longer a function in Drush called drush\_sql\_dump\_execute.

SECOND EDIT: I've updated to civicrm 4.6.8 and now it works as it should. I didn't get the chance to explore Alan's suggestions, though i know for sure that my civi-database is in a different database than Drupal. Thanks for your help and input. If anyone drops by here having this problem, I would recommend upgrading, as Jon says he hasn't seen this error in any of the newer versions of civi, and upgrading solved it for me. Leaving this open for now, if someone actually solves this for civi 4.4 and Drush 6, then they can provide an answer.

# Answer
> 3 votes
One answer to your question is that you can use the sql-dump drush command to dump your civicrm database by using this option:

```
 --database : The DB connection key if using multiple connections in settings.php.

```

For that to work, you'd have to edit your drupal settings file to include something like:

```
$database['civicrm'] = array('default' => array('driver' => .. etc.

```

A second answer is that the civicrm-sql-dump drush command does not use the drupal settings file, but the civicrm settings file, to get the db name and credentials, so the fact you're getting the same dump from both suggests that you might not be using a separate db for civicrm as you think. Maybe you're looking at the wrong civicrm.settings.php file?

It does look like you want to revert to the 6.x drush. I haven't ever seen the behaviour you describe, but I tend to use bash scripts for mysql backups anyway, to keep things simpler.

# Answer
> 1 votes
Just to submit as an answer rather than comment - I can confirm that I no longer see this behavior on any of my Civi installs, which are running 4.4.19 or 4.6.8. I saw this a bunch in 4.3 and earlier versions of 4.4, though only with drush, never with wp-cli.

---
Tags: database, backups, drush
---


# Question
Title: How to show Days in Case in Drupal Views?
Trying to create a Drupal View that shows total number of days in a case.

There are two methods I'm considering:

First, I imagine if I could turn the case start date and end date into "Days Ago" within the view I could perform a math calculation of \[end\_date\]-\[start\_date\] to get the number.

The other method I thought may work would be to create an aggregate table through views that displayed a daily case load. For example, on 1.1.15 list these 5 people that have ongoing cases. On 1.2.15 list these 5 people that have an open case. From there, I could group by contact name and count.

Anyone have any ideas or done something similar?

# Answer
> 3 votes
Got it!

**In Drupal added the Unix Timestamp format:** Administration/Regional and Language/Formats/Add Format. For the string I put in `U`. Added the Date Type Unix Timestamp

**In the View:** Added the Start and End Date fields. Under Date Format selected the Unix Timestamp type I just created. Added a Math Expression field with the expression `(([end_date]-[start_date])/86400)` since there are 86400 seconds in a day.

---
Tags: civicase, drupal-views, dates
---


# Question
Title: Create a Drupal View with MULTIPLE CiviCRM relationships?
I have read the answers to this question:

How to create a Drupal View with multiple CiviCRM relationships?

and it has helped me to create a Drupal view that links an individual to a household, but when I want to go in the other direction, the relationship only shows me ONE of the individuals in the household and not all of them.

How do I create a view that pulls ALL of the individuals associated with a household?

That is, how do I tell the view to pull all of the related entities and not just the first one?

EDIT: Here is the export for my view code:

```
$view = new view();
$view->name = 'household_members';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'civicrm_contact';
$view->human_name = 'Household Members';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'Household Members';
$handler->display->display_options['use_more_always'] = FALSE;
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '10';
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'fields';
/* Relationship: CiviCRM Contacts: CiviCRM Relationship (starting from Contact B) */
$handler->display->display_options['relationships']['relationship_id_b']['id'] = 'relationship_id_b';
$handler->display->display_options['relationships']['relationship_id_b']['table'] = 'civicrm_contact';
$handler->display->display_options['relationships']['relationship_id_b']['field'] = 'relationship_id_b';
$handler->display->display_options['relationships']['relationship_id_b']['label'] = 'Household Members';
$handler->display->display_options['relationships']['relationship_id_b']['relationship_type'] = '7';
/* Relationship: CiviCRM Relationships: Contact ID A */
$handler->display->display_options['relationships']['contact_id_a_']['id'] = 'contact_id_a_';
$handler->display->display_options['relationships']['contact_id_a_']['table'] = 'civicrm_relationship';
$handler->display->display_options['relationships']['contact_id_a_']['field'] = 'contact_id_a_';
$handler->display->display_options['relationships']['contact_id_a_']['relationship'] = 'relationship_id_b';
$handler->display->display_options['relationships']['contact_id_a_']['label'] = 'Members';
/* Relationship: CiviCRM Contacts: CiviCRM Relationship (starting from contact A) */
$handler->display->display_options['relationships']['relationship_id_a']['id'] = 'relationship_id_a';
$handler->display->display_options['relationships']['relationship_id_a']['table'] = 'civicrm_contact';
$handler->display->display_options['relationships']['relationship_id_a']['field'] = 'relationship_id_a';
$handler->display->display_options['relationships']['relationship_id_a']['label'] = 'Individual to Household';
$handler->display->display_options['relationships']['relationship_id_a']['relationship_type'] = '7';
/* Relationship: CiviCRM Relationships: Contact ID B */
$handler->display->display_options['relationships']['contact_id_b_']['id'] = 'contact_id_b_';
$handler->display->display_options['relationships']['contact_id_b_']['table'] = 'civicrm_relationship';
$handler->display->display_options['relationships']['contact_id_b_']['field'] = 'contact_id_b_';
$handler->display->display_options['relationships']['contact_id_b_']['relationship'] = 'relationship_id_a';
$handler->display->display_options['relationships']['contact_id_b_']['label'] = 'Household';
/* Field: CiviCRM Contacts: Contact ID */
$handler->display->display_options['fields']['id']['id'] = 'id';
$handler->display->display_options['fields']['id']['table'] = 'civicrm_contact';
$handler->display->display_options['fields']['id']['field'] = 'id';
$handler->display->display_options['fields']['id']['separator'] = '';
/* Field: CiviCRM Contacts: Contact Type */
$handler->display->display_options['fields']['contact_type']['id'] = 'contact_type';
$handler->display->display_options['fields']['contact_type']['table'] = 'civicrm_contact';
$handler->display->display_options['fields']['contact_type']['field'] = 'contact_type';
/* Field: CiviCRM Contacts: Display Name */
$handler->display->display_options['fields']['display_name']['id'] = 'display_name';
$handler->display->display_options['fields']['display_name']['table'] = 'civicrm_contact';
$handler->display->display_options['fields']['display_name']['field'] = 'display_name';
$handler->display->display_options['fields']['display_name']['relationship'] = 'contact_id_a_';
$handler->display->display_options['fields']['display_name']['label'] = 'Household Members';
$handler->display->display_options['fields']['display_name']['link_to_civicrm_contact'] = 0;
/* Field: CiviCRM Contacts: Display Name */
$handler->display->display_options['fields']['display_name_1']['id'] = 'display_name_1';
$handler->display->display_options['fields']['display_name_1']['table'] = 'civicrm_contact';
$handler->display->display_options['fields']['display_name_1']['field'] = 'display_name';
$handler->display->display_options['fields']['display_name_1']['relationship'] = 'contact_id_b_';
$handler->display->display_options['fields']['display_name_1']['label'] = 'Household Name';
$handler->display->display_options['fields']['display_name_1']['link_to_civicrm_contact'] = 0;
/* Contextual filter: CiviCRM Contacts: Contact ID */
$handler->display->display_options['arguments']['id']['id'] = 'id';
$handler->display->display_options['arguments']['id']['table'] = 'civicrm_contact';
$handler->display->display_options['arguments']['id']['field'] = 'id';
$handler->display->display_options['arguments']['id']['default_argument_type'] = 'fixed';
$handler->display->display_options['arguments']['id']['summary']['number_of_records'] = '0';
$handler->display->display_options['arguments']['id']['summary']['format'] = 'default_summary';
$handler->display->display_options['arguments']['id']['summary_options']['items_per_page'] = '25';

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['path'] = 'household-members';

```

# Answer
I'm not sure about proper Stack Exchange protocol here, but I just posted an answer for a different question about how to create a view that includes both guardians with their child all on the same line (if I should write out the same answer or modify it, I certainly can). Perhaps you would find it useful. I would think the same concept would apply to showing all members of a given household: https://civicrm.stackexchange.com/a/5227/105
> 1 votes

# Answer
If getting the list of Household members on the same line is not a concern, then creating the View is doable with two relationships, a filter and a couple of fields.

***Create a CiviCRM Contacts View***

**Relationships**

1. CiviCRM Relationship (starting from contact A); relationship type \> Household Member of | Household Member is
2. CiviCRM Relationships: Contact ID B; in this relationship, reference relationship #1

**Filter Criteria**

Contact Type = Household; in this filter, reference relationship #2 (Contact ID B)

**Fields**

* Whatever info you need for Contact A (the individuals in the household)
* Whatever info you need for the Household (say, sort name); in this field, reference relationship #2 (Contact ID B)

If you add a sort for the Household name (or whatever field you use for the Household), referencing relationship #2 (Contact ID B), you ensure all of your household members are grouped together.

I just verified with our own Civi install that this yields each household member, not just one.

Hope this helps!
> 0 votes

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


# Question
Title: PHP Undefined Index warnings when updating Drupal
I am running the latest CiviCRM with Drupal 7 (latest and all modules up to date). When I run Drupal database updates, such as when updating a module, I get the following errors:

```
Notice: Undefined index: admin/structure/types/manage/civicrm_activity/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_action_schedule/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_address/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_campaign/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_contact/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_contribution/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_contribution_page/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_email/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_entity_tag/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_financial_type/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_event/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_group/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_grant/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_membership/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_membership_type/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_participant/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_phone/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_price_set/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_price_field/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_price_field_value/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_relationship/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_relationship_type/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).
Notice: Undefined index: admin/structure/types/manage/civicrm_tag/fields in civicrm_entity_menu_alter() (line 23 of /home/mysite/www/www/sites/all/modules/civicrm_entity/civicrm_entity.module).

```

Any help would be appreciated.

Thanks.

# Answer
> 2 votes
I think this is some issues with civicrm entity module.

---
Tags: drupal
---