Jaap Jansma - CiviCooP
  • Member for 6 years, 10 months
  • Last seen more than a month ago
How to create a Drupal View with multiple CiviCRM relationships?
Accepted answer
9 votes

You can use the relationship section of a view for this. A relationship in a view is a relationship between entities don't confuse it with the relationship you have between contacts. So you could set ...

View answer
How do I print the "received date" on an invoice?
Accepted answer
7 votes

I came accross the same issue. The invoice date gives the current date and that is in most cases not correct. We have used the receive date of the contribution in the invoice template as follows. ....

View answer
CiviRules - where is the data stored in the database? - backdating
Accepted answer
6 votes

Be really careful of what you are doing. But the delayed actions are stored in the civicrm_queue_item database table. The column release_time indicates the date from which the action is going to be ...

View answer
Email me every time someone makes a contribution
6 votes

If you need a more complicated workflow you could also use the CiviRules extension. That way you could send an email to a backoffice manager when certain criteria are met and when other criteria are ...

View answer
Mass deletion of bad addresses
5 votes

If you completly want to delete the addresses, you could also delete them from the database with a query like DELETE FROM civicrm_address WHERE location_type_id = xx AND contact_id IN (SELECT ...

View answer
Using event listeners in my extensions
Accepted answer
5 votes

I have found why it was not working. I was looking in the user interface whether my tokens showed up in the list with tokens a user can use. But they did not. After digging all the core code I found ...

View answer
Mixed content error on SSL site
Accepted answer
4 votes

Check your CIVICRM_UF_BASEURL value in civicrm.settings.php and check also the settings under Administer --> System Settings --> Resource URLs. In the latter you can force civicrm to load css/js ...

View answer
Reproduce CiviCRM configuration: best practice
4 votes

Usually I copy the site that is the best way to ensure all things are correct. But I can imagine that is sometimes cumbersome. I have therefor used an extension org.civicoop.configitems (https://...

View answer
Is there any paid extension or all are free?
Accepted answer
4 votes

In the CiviCRM extension directory all extensions are free. It is common in open source to share your work for free. I am a freelance CiviCRM developer and all my extensions are free. However I get ...

View answer
Will there be a LTS release of CiviCRM 4.6.x that supports PHP 7+
4 votes

When PHP 5.6 reaches it end of life. It means basicly that no further updates are coming from the official php group. But it means you can still keep php 5.6 on your server it does not stop from ...

View answer
Creating ACL for Smart Groups
4 votes

Smart Groups could be a pain in the ass in CiviCRM. They are a powerful feature but when it does not work it is hard to get it working again. There are some alternatives to smart groups. The SQL ...

View answer
Why is the column called "Soft Credit For" when it seems to show "Soft Credit from"?
4 votes

Good question. There is probably no explanation except that the developer who implemented it called it this way. Maybe by mistake. If you feel this is wrong you can file an issue and if you have ...

View answer
Today's-Date token for PDF
4 votes

You could create a custom token and add the format you want. An example of such a token in a custom format (a long with lots of other tokens) you could find in the extension no.maf.tokens This ...

View answer
Finding memberships with 'Status Override' set
Accepted answer
4 votes

CiviCRM has a search builder and the field Override status is available in the search builder.

View answer
If my website in in WP, can i install CiviCRM in drupal?
3 votes

Welcome! What Masswear says is not right. You can have your website in wordpress and have CiviCRM in a Drupal installation. You can the connect your wordpress site to civicrm with a plugin called ...

View answer
How to get my Green Party email address added to the CiviMail from dropdown list
3 votes

This is a setting in CiviCRM setting under Administer --> System settings --> Outbound E-mail. There is a checkbox to allow different from e-mail addresses. If this is checkbox is set to no you can ...

View answer
Send an email to activity targets when activity is created via the API
3 votes

You can solve this in two ways: Use schedule reminders. You can then use all the activity tokens. Draw back is that this one sends e-mail based on the (scheduled) date of the activity. Use CiviRules ...

View answer
What is best practice for updates?
3 votes

There is no clear policy for this. But it is good to put CiviCRM behind a firewall/VPN. That way you can only access civicrm if your ip address is allowed. For connecting external websites/application ...

View answer
Has this member data been encrypted?
Accepted answer
3 votes

There is no encryption in CiviCRM. This sound something that your database dump got corrupted. Or that you imported in a database with another collation (character set) than the source database.

View answer
Custom field - Drop down. How to create?
3 votes

You can create custom fields under Administer --> Customize Data and Screens --> Custom Fields. You first create a custom group for the event. You could even limit this group to a certain type of ...

View answer
What is a line item? And what is a financial item and how are those two linked together?
Accepted answer
3 votes

The solution to my question is to use the Order API. The order API does create a contribution, line items and the underlyning financial items etc...

View answer
Create invoices in CiviCase
Accepted answer
3 votes

I have two comments: CiviCRM is not really good in invoicing. So my advice would be to do the invoicing part in a seperate system, usually an accounting software might do the job I have made an ...

View answer
Charts using data from CiviCRM to show on Drupal website
3 votes

There is also Civisualize, a data visiualisation extension: https://civicrm.org/extensions/civisualize-missing-data-visualization-extension And you could also use external tools for data ...

View answer
Anonymous users can't View details of a Contact in a public directory Listing
3 votes

It is not possible to expose contacts to anonymous users. The only place where this is possible is with registered participants for an event because you could create a public participant listing. ...

View answer
Email-to-activity processing – create Activity at future date
3 votes

You could use the CiviRules extension (https://civicrm.org/extensions/civirules) for this. Every time an incoming email activity is created in CiviCRM civirules could create a follow up activity in ...

View answer
Extension Upgrade Failed: Download failed - ZIP file is unavailable or malformed
Accepted answer
3 votes

You could do a manual upgrade: download the zipfile from https://civicrm.org/extensions/civirules remove the civirules directory from your extension folder on the server extract the downloaded zip ...

View answer
INSTALLER fails. Database can't "SELECT GET_LOCK" at civicrm/install/index.php(271)
Accepted answer
3 votes

Another solution is to upgrade at least to CiviCRM 4.6.16 or to CiviCRM 4.7.7 or you can also patch your installation. If you are familair with patches you can also download a patch from the civi ...

View answer
Drupal Views Field: Relationship Type B-to-A?
Accepted answer
3 votes

It is correct that not all fields from the CiviCRM RelationshipType entity are available in the the views by default. The socialistic party in the Netherlands had the same problem. And I created a ...

View answer
Membership Name-Your-Own Price (above Minimum) on Contribution Page
3 votes

At a client of us they have the same use case. They have a membership of a minimum fee of 5 euro a year but it could be anything more than that. They don't have online payments but their memberships ...

View answer
How do I set the print order for address labels?
3 votes

It is complicated to add a sort order on address labels. I think it is possible to add a sort order to your search and that sort order is used in printing labels. However, in a recent project, we ...

View answer
1
2 3 4 5 6