samuelsov
  • Member for 6 years, 10 months
  • Last seen more than a week ago
civiCRM Cron only run one mail_report scheduled jobs?
8 votes

You have to create 3 instances of the mail_report scheduled job. To do that, use Add New Scheduled Job button on the Settings - Scheduled Jobs page (civicrm/admin/job?reset=1) On the creation page, ...

View answer
Is there a recommended way to customise the quicksearch?
7 votes

I found it quite hard to replace the customization done with hook_civicrm_contactListQuery (CiviCRM <= 4.4) with the new hook_civicrm_apiWrappers (CiviCRM >= 4.5). So I am sharing my results here. ...

View answer
How to write custom report SQL
5 votes

There was a pretty good 101 session about custom report in CiviCon Denver 2015. Unfortunately, there don't seems to be a video about it. You can check resources here : https://denver2015.civicrm.org/...

View answer
Error "Unknown Error" when uploading a file with CKEditor
Accepted answer
5 votes

After digging, i have found that the problem was in the function packages/kcfinder/core/class/uploader.php :: checkFilePath This function forbids an upload if you have a symbolic link in your path. ...

View answer
Selecting location type or multiple email/phone fields in Reports
Accepted answer
4 votes

Old question but for a CiviCRM only solution, I found that Extended Report has a Report Extended Report - Flexible contact report that does an aggregation of all the phone numbers. As of version 5.8, ...

View answer
ER diagram for the latest Civicrm , Foreign key in Structure, test cases/plans
Accepted answer
4 votes

2) You can use a tool like SchemaSpy to extract the structure of the database, have the foreign key displayed in a table or on a schema and navigate easily between related tables. You can see an ...

View answer
What character is VALUE_SEPARATOR?
Accepted answer
4 votes

In fact, if you use HEX() function, you can guess it's the ASCII code 01 which is not really readable : MySQL> SELECT substring(besoins_sp__114, 1,1) FROM ...

View answer
What is the best practice to change Email Address
4 votes

Here is what we usually do : either let people change their information by logging in the system, either after sending an email with a checksum link to let them update their own information. You can ...

View answer
How to get the new record ID, when adding a record to a multi-value custom field using the API?
Accepted answer
4 votes

I don't think it's possible using the api right now. So what you could do in the mean time is create a custom function to do it and ideally emulate the api call using the same input params and ...

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

As mentionned here : You can export the first name, last name and the internal ID Re-import the data by matching the internal ID This process should regenerate the sort name and display name based ...

View answer
How Can I Attach a PDF Certificate for a Membership Payment?
4 votes

I don't think it's possible right now without coding. If you are not afraid of coding, what you could do is something like : add you membership certificate after the content of the receipt (in ...

View answer
Can I set a premium for a $20 minimum on a recurring contribution, but $80 for a one-time contribution?
3 votes

I just came across this question and we have solved a similar problem a few years ago, i.e. we want to count the total value of recurring contributions (e.g. a $10 recurring should count as much as a $...

View answer
API Get Contacts which are members of a certain group
3 votes

Andrei and Flying answer seems good to me but if i look at civicrm api examples in the core code, you should be able to do this : $result = civicrm_api3('Contact', 'get', array( 'return' => "...

View answer
How do I proceed to make CiviCRM bilingual
3 votes

Languages options allow you to limit the preferred language for your contacts. It's not related to multilingual setting. To enable multilingual, you need to go to : menu Administer -> Localization ->...

View answer
What does "Result Column? 'In Sector' Cannot be checked with participant" mean?
Accepted answer
3 votes

There are two fields Searchable? and Results Column? that make sense only for Public Pages and contact profile. The field Searchable ? should be automatically unchecked when setting the visibility to ...

View answer
Which value to use for tag_id to create EntityTag
Accepted answer
3 votes

A few advices : when you chain, you shouldn't have to define the entity_table. If you want to define it anyway, the entity_table should be the database table - i.e. civicrm_contact in your case. ...

View answer
Admin language does not change
3 votes

Unfortunately, if you change the language after the installation, the data that has been loaded during installation in the database will not be translated. I am not aware of an easy way of fixing ...

View answer
Membership receipt email template not showing correct dates
2 votes

The dates are only updated when the payment is completed. If you allow for offline payment (e.g. cheque), then the dates are not updated yet when the invoice email is sent. In that case, the subject ...

View answer
Translating CiviEvent Public pages
2 votes

All those strings should be in transifex (and compiled in the .mo files). Please keep in mind that the string might contains HTML and what you see as one big paragraph on the screen might be in fact ...

View answer
Unable to cancel a PayPal_Standard recurring transaction
Accepted answer
2 votes

As far as i know, Paypal Standard doesn't support cancellation of recurring payment from within CiviCRM. You need to cancel it from your Paypal account. If you want to have this ability, you need to ...

View answer
API Contact>DuplicateCheck Not Working?
2 votes

Here is a piece of code that works : $res = civicrm_api3('Contact', 'duplicatecheck', array( 'match' => array( 'contact_type' => 'Individual', 'first_name' => 'Jane', ...

View answer
Adding barcode in Event confirmation email
2 votes

I just found this forum post : https://forum.civicrm.org/index.php?topic=23767.0 which seems to propose a solution based on a old version of CiviCRM but the method is still valid in principle : ...

View answer
How do I add/change columns in CiviReports?
2 votes

You can add new columns if they are custom fields that you have created. You just need to ensure that the fields are defined as "Searchable" otherwise the fields won't be available in the columns tab. ...

View answer
Searching for incomplete fields
2 votes

Yes, you need to use the Search builder : Menu search -> Search builder. Then you can choose the record type, the field and most important the operator : you have empty or is null (not defined) ...

View answer
How can I find out how many individuals are inputted onto our civi system
2 votes

Simplest way : menu Search -> Find Contacts is - any contact type - -> replace by the contact type you want to count (Household or Individual) click Search button In the result, you will see the ...

View answer
Difference between 'active' and 'disabled'
2 votes

A bit off-topic but if you want to limit the number of places for an option, instead of creating a custom field, you could create a price field item with price option and specify Max Participants. ...

View answer
Testing a module which uses CiviCRM php api
Accepted answer
2 votes

I'm not an expert of testing but i'm pretty sure that SimpleTest creates a new instance of Drupal with a new database each time the testing process is ran. CiviCRM is not a standard Drupal module and ...

View answer
Add extra field to group contact - relation
2 votes

If i understand correctly, in your example, you have 2 organizations contact called "Group 1" and "Group 2" and one individual contact called "User 1". In that case, I can think of several way of ...

View answer
Is Iframe based payment gateway integration with civicrm possible?
2 votes

I don't think it's easy. I have tried without success a couple years ago. The return page will go to the iframe rather than the parent page and i didn't find a way to close the iframe and having the ...

View answer
Copy CiviVolunteer volunteer needs when creating a repeating event
2 votes

I think you can find all you need about this question at https://issues.civicrm.org/jira/browse/VOL-37 Note also that CiviVolunteer 2.0 beta is planned for a release on September (2015) - https://...

View answer