Paul-Tahoe
  • Member for 6 years, 9 months
  • Last seen more than a month ago
Label printing: how can I only combine people with relationship
2 votes

You could create two mailings one for people with a relationship and one for people without. Use the relationship report to find all the people with relationships. Add them to a group. Create ...

View answer
Find Contacts who are in one and only one group?
2 votes

Since sql is probably your best bet, the sql is pretty straight forward. SELECT c.display_name, g.name, count(*) FROM civicrm_group_contact gc, civicrm_contact c, ...

View answer
Where / how is the {domain} token formatted?
2 votes

I believe there are several domain tokens. domain.Name, domain.Address, domain.email, domain.phone. These are set on the Administer => Communications => Organization Address and Contact Info page. ...

View answer
CiviMail Unsubscribe link goes to an empty Wordpress page
2 votes

Did you check the access controls to make sure mail user has permission to access the subscribe/unsubscribe page. (note: I'm not sure if WordPress has this exact control) To get to the access ...

View answer
Is there a way to regenerate the display and sort names?
2 votes

If you have any familiarity with sql, the update statement is straight forward. Of course, test first in a test environment. Here is one that would work for individuals with sort name like Smith, ...

View answer
How can I have a fixed date membership with no rollover date?
2 votes

I tested this a bit and you are correct. If someone signs up Dec 31st they get the whole next year. Probably the easiest thing to do is not offer a discount for the Dec. Pay the full price and then ...

View answer
Import Contacts with Email field issue
1 votes

Yes it appears to be a bug. You should file one. Here seems to be the conditions: Importing update or fill, i.e. contact already exists Has no existing email address or any existing has is_primary ...

View answer
Navigation Menu Lost
1 votes

They developer released 4.0.2 which should fix the issue. Sounds like they may have an issue with their test env.

View answer
Somehow our summary fields got a old version of sumfields.php. What's the best way to get the current versions?
1 votes

I ended up just changing the version number in the info file to 3.1.0. Then on the Manage Extensions page it then said there was an upgrade. Hit upgrade and everything was good.

View answer
How do I prevent blank fields on a profile from overwriting existing data when using the profile to register or donations from existing contacts?
Accepted answer
1 votes

Created jira CRM-20731. This problem also sort of exists with creating a new contact without an address. The contact will get an address record with only the country and state province. I included ...

View answer
Changing our contact email address in Event Templates
1 votes

I assume the email address you are referring to is on the location tab. If so, the assumption is a location has a fixed email address. When you change the email address on a location it changes it ...

View answer
CiviCRM Dedupe - How does it really work?
Accepted answer
1 votes

For your specific example, "St. John's" "St Johns" "St. John's U.", you can set up a rule that would find a couple of these but sadly not all of them. As Erikh implies you could setup a rule that ...

View answer
Smart Group for Soft Credit Name
1 votes

I believe advanced search will be able to do this for you. (Main menu, Search and then Advanced Search) Below the basic search fields you should find a collapsed section for Contributions. Expand ...

View answer
How to Deal With Email Only Contact Records
Accepted answer
1 votes

I'm not sure you'll find the email only contacts will really be noticed with day to day operations. We have some, granted less then 5%, and I rarely come across them. Think about the kind of queries ...

View answer
HELP! civiCRM Administration Area Not Showing! [Joomla 3.6.5] [civicrm 4.7.16]
1 votes

You could try to go the page directly www.yoursite.org/administrator/?option=com_civicrm&task=civicrm/admin/setting/url&reset=1 If you have sql access you could change them back. They are ...

View answer
Administration menu
1 votes

It's to the right of the Reports menu and to the left of Support but I'm guessing the user you are using to access civicrm does not have the administer role so it doesn't show up. There are couple ...

View answer
Master address - not saving choice
1 votes

I'm not sure this is the answer Drew is looking for or it even addresses his issue. It sounds like it was working for him and then he had a timeout and it messed a number of them up. The comments, ...

View answer
CSV file import problem with file from Mac MS Office
1 votes

I use Mac MS Office all the time to create csv files to import into civi without issue. Civi parses the file looking for the correct format. It doesn't care what the file name is. So for some ...

View answer
Can we print mailing lables from CiviCRM?
1 votes

It's explained in the this online book. Civicrm Books Basically if you query of the contacts and select the ones you want, the action pulldown menu has a print mailing labels.

View answer
How can I add the "automated mailer task cron job"?
1 votes

There is some general information about scheduling jobs and running cron here User and Administrator Guide. You will find links to more details in both the guide and the link (Job parameters and ...

View answer
If statement not working if the smarty variable is not set
1 votes

Try this: {if "{note.note}" eq ""}None{/if}

View answer
Can a message template replace tokens with appropriate translations?
1 votes

This is not really an answer but a work around. You can use smarty's to look for the English and replace it with the French (which I'm guessing at). {if "{contact.gender}" eq "Female"} Femme {...

View answer
Using Search Builder to search on a field with custom location gives DB error
1 votes

For completeness, my comment probably should have been an answer… I think this is probably a bug. It doesn't matter if you create a new location type or use a pre-populated one. The sql has a ...

View answer
Exporting contacts merged to households causes DB error version 4.6.8
1 votes

The error you are hitting is: 126 Incorrect key file for table '/tmp/#sql_7ae3_0.MYI'; try to repair it A google search suggests you don't have enough space in /tmp for it to fully create the temp ...

View answer
Custom drupal contact display fields?
1 votes

You can make a field view only by editing the field checking the Disabled box near the bottom of the list of options. (IMHO, not a very good name for the box)

View answer
Issue upgrading from 4.34 - Fatal Error (value: is not of the type integer
1 votes

The code that is failing is trying to update a name_badge format. It looks like 3 new types of labels were added at some point but one of them had an issue and this code is updating that one. It ...

View answer
How To Record & Display External ID In Contact Summary?
1 votes

You could do this with a database trigger. If you are using external id for the existing members you could put a trigger on civicrm_contacts after insert that would populate external_id with the ...

View answer
Add membership details to summary tab
1 votes

I sort of did just this. Because there is a lot of white space next to the name, we display the membership info after the name. Because some of our contacts have multiple memberships and we care ...

View answer
Importing Household Address if Already Exists
1 votes

This is in answer to the how to create spouses from household members. Here is some sql. You can use it to create a csv to do an import update individual or paste into the Specify SQL Query box ...

View answer
CiviMail and unsubscribing from smart group
Accepted answer
1 votes

It looks like your smarties aren't being replaced when the message is being sent. The link should have a url to your civi something along this line: http://www.yourcivi/civicrm/mailing/unsubscribe?...

View answer