texts: Display events by categories for current year, and past 3 years

texts:
I am on Wordpress 4.7.5 and CiviCRM 4.7.19. I have tried the CiviEvent Widget but it does not do enough for me. I have tried modifying it but my skills are too beginner.

I would like to display my events by event type on a wordpress page. Then for each event type, I would like to have a past events page where the past events for 2017, 2016 and 2015 are displayed.

Illustration:

Events page
Event Type 1
- event
- event
- past events page link
Event Type 2
- event
- event
- past events page link
Event Type 3
- event
- event
- past events page link

Past Events page for Event type 1
2017
- event
- event
2016
- event
- event
2015
- event
- event

What I have tried as an alternative: Created event types as post categories, then created years as sub-categories. Then inserted civicrm event as a post under the relevant sub-category. Then I intended to create page templates that display the posts under certain categories. However, I realised that I am unable to filter out the on-going events and past events. In addition, this means that I need to modify the page templates each year to get the id for the new categories. Example, for 2018, I will have to create 3 2018 sub-categories under each event type. I would prefer it to be an auto-thing.


texts: How can I integrate custom fields in CiviCRM?

texts: Is there any way to integrate custom fields in the CiviCRM. If yes how can Integrate the fields in the CRM? as I am having a Bulk SMS service website I want to add some custom fields in the CRM


texts: Set up for a Scheduled Reminder using case activity

texts:
Using Civi 4.7.8 (about to go 4.7.10) I want to create a scheduled reminder such that when the status of a custom activity type (which I've called 'Decision') changes to 'Completed', the case coordinator gets an email notification. I'm just struggling a little with some of the settings and naming conventions being used, so I thought by posting a question here I could:

a) get some useful clarity,
b) perhaps help make things clearer for others in a similar state of confusion, and
c) maybe help move towards a more consistent naming/labelling regime for activity contacts.

(I'll also be happy to improve the documentation based on what I learn.)

So the first thing that got me confused is - that in my activity - the involved parties look to be:

the person who reported the activity, as in the name that appears against "Reported by:". I believe this is the same as the creator of the activity, or as the documentation also calls it, the "Activity Source". Creating a new activity elsewhere in Civi, e.g. selecting 'New Activity' from the Contacts menu this field is labelled as "Added by:", so there's yet another name option.
The client of the case. In my activity this contact is called the 'Client', probably because the activity type that I'm interested in is used within the context of a case. In the scenario where we are selecting "New activity" from the "Contacts" menu this field is labelled as "With Contact". By process of elimination I reckon this contact is what's called in the documentation the 'Activity Target/s'.
The third type of contact is the activity assignee/s, which unlike the others looks to be unambiguously named both in the UI and in the documentation.

So I think I know which contact is which:
Reported by = Added by = Activity Source
Client = With Contact = Activity Target
Assigned to = Activity Assignee/s

In the reminder set-up I can specify my activity type and the status for that activity. I'm assuming here that these are essentially conditions for the reminder, i.e. a reminder can be be sent when an activity of the specified type and status exists.

Then I get confused again, because I now need to set a time, and for activities the options I have are to either set a specific date, or I can set a date/time relative to the "Activity Date Time". Assuming the "Activity Date Time" is the date and time set in the activity record, I can see that this date and time does not change if the activity gets edited (unless it is explicitly changed by editing the activity record).

Let's say I set the time for the reminder to be 1 hour after the Activity Date Time.

So, let's say a I create the activity, and it has a status when created that doesn't match the criteria for my reminder. Some time later, let's say two hours later, the activity is edited and the status is changed to match what my reminder is looking for, but the date and time of the activity are not edited. I now have a situation where my activity should trigger a reminder, and my target date/time is in the past.

Is it the case that because the criteria are met, and the target date/time is in the past, that the reminder will be sent? And is it the case that if I had instead set the time for the reminder to be three hours after the Activity Date Time, then the reminder would not be sent in this case because although the activity criteria are met, the time is in the future?

Is this how it works, or have I got it horribly wrong?


texts: Would it be feasible to store the fact that a scheduled reminder has been sent, without storing the content of the email?

texts:
Our DB is larger than we would like. Just two tables, activity and log_activity make up more than 25% of the DB size.

We send secheduled reminders for memberships and to potential new members who have visited our booth at expos. We want an activity that records an email was sent, but we don't need to store the content of the emails in the activity, just the subject is enough. We removed the content of the emails on our staging site and the tables dropped to about 30% of the original size.

At the moment when creating a scheduled reminder there is a tick box for "Record activity for automated email".  Would it be appropriate and feasible to have another tick box to indicate whether or not the content of the email should be stored in the activity?  (Probably for some schedule reminders of, say, payments owing storing the content of the email on each activity would be desirable.

Am I right in thinking this should be tackled via an extension?


texts: Automatic Membership Status Jobs Fails on Cron Run

texts:
We have setup the automated Cron job to run on the server every 15 minutes. This works great for newsletters and other jobs. However when it comes to the membership status job it always fails after running partially. I just get a error 500 from the server. We are trying to identify if it could be due to a particular membership type, membership record or CiviCRM.

We have updated CiviCRM a couple of times and the it is on the most stable long term versions i.e. 4.6.38 and Drupal 7.6x.

Has anyone come across this error?
In the command parameters can we add a command to run only by certain membership types? Does anyone know what this command will be? This way we can debug the issue in more detail.


texts: Has Let's Encrypt been put into production with CiviCRM?

texts:
https://letsencrypt.org/ is a new free, automated SSL certificate issuing service that simplifies SSL certificate issuance. Despite being a new CA (Certificate Authority), the certificates are recognized by all major browsers already because they are cross-signed by IdenTrust. The project is intended to facilitate much more pervasive encryption of the Internet - https://www.eff.org/deeplinks/2016/03/new-name-and-roadmap-lets-encrypt-client.

The Electronic Frontiers Foundation and others launched the service to the public in December 2015 (https://www.eff.org/deeplinks/2015/12/lets-encrypt-project-comes-fruition-2015-review), and it recently issued its 1,000,000th certificate (https://www.eff.org/deeplinks/2016/03/new-name-and-roadmap-lets-encrypt-client). Has anyone in the CiviCRM community started using Let's Encrypt in production despite the warning that it is only a beta (https://letsencrypt.readthedocs.org/en/latest/intro.html)? Any problems or gotchas?


texts: Call to undefined function _civicrm_api3_basic_get when using CiviRepeat module

texts:
I am using civicrm 4.7.17

When I go to the page sitename/admin/config/civicrm/civirepeat, I get the error

Call to undefined function _civicrm_api3_basic_get in Event.php on line 133

I figured out that the Event.php file is located in the civicrm/api/v3 folder and the function _civicrm_api3_basic_get is defined in the file utils.php in the same folder.

Why do I get the error even though the function has been defined.


texts: How can i show the Count of Contributions in a give time period?

texts:
I checked the awesome Summary Fields extension and the Advanced Fundraising Reports one but neither seem to quite offer this.

I could do this as a Drupal View but that won't give me the full suite of 'Actions' that might be required.


texts: Why is a shortcode being displayed to site visitors rather than the membership sign-up confirmation page?

texts:
Having just updated my Wordpress/Civi site to current versions 5.5.3 and 5.31.1 respectively I've been checking the site to ensure it's all still working as expected. On a membership sign-up form that is being displayed via a shortcode I notice that when the user clicks to submit the form, rather than seeing the confirmation page where they can check the information they have entered prior to making their payment at Paypal, they are seeing a page which just shows the shortcode.
As a logged-in admin user I get the same thing. If I change the configuration of the contribution page to turn off the confirmation page, the form then works as expected. If I turn the confirmation page back on and try again, as a logged-in user the confirmation page is displayed correctly, but if I try it in a different browser as an anonymous user, I still see just the shortcode.
The workaround is to disable the confirmation page, but it's less than ideal.
Looking at the browser console, when the form is inserted via shortcode, the resulting page has a string of JS errors of the form : "SyntaxError: Unexpected token '<'" which don't arise when viewing the contribution page itself (i.e. using the Civi URL). I don't know whether this is what's making the form break in this way.


texts: Why does the profile field contact subtype only display individual subtypes but not organisation subtypes?

texts:
If you visit here on the CiviCRM Demo site http://d46.demo.civicrm.org/civicrm/admin/uf/group/field?reset=1&action=browse&gid=16 (What I did to create this was create a new profile, for the purpose of batch updating via profile, called Subtype and add the field "Contact" "Contact Subtype". )
Looking at the preview of this field
the only options that are available are subtypes of Individual. Subtypes of Organisation do not show.

How I can get the Contact Subtype field to display organisation subtypes?


texts: Why am I getting no data when using PHP API on wordpress page?

texts:
CiviCRM 4.6.6 Wordpress 4.2.4

The code in my wordpress page:

[insert_php]
// Perform bootstrap
civicrm_initialize();

$result = civicrm_api3('Event', 'get', array(
  'sequential' => 1,
  'return' => "title,summary,custom_31",
  'event_type_id' => "",
));

print_r($result);
[/insert_php]

the ouput on my page:

Array
(
[is_error] => 0
[version] => 3
[count] => 0
[values] => Array
(
)

)

There should be data.

What am I doing wrong?

Thanks.


texts:
We are on the latest version of civicrm 5.3.1 and the lastest version of Masaico and now i am getting this error message when I try to edit and save a template:

  API permission check failed for MosaicoTemplate/create call;
  insufficient permission: require edit message templates and edit
  user-driven message templates and edit system workflow message
  templates

Thanks Karin!


texts:
I have some events that are over some by years, which are not showing up on my manage events.  I am trying to clean up the data but I can't even find my past events.

I also need to delete the Price sets but it won't let me do that because it's attached to the event.

I do need to keep the participants information.


texts:
One of the user noticed the Summary Fields weren't being updated.  Upon investigation I see that the triggers didn't exist anymore.  My guess is an upgrade to 4.6.26 wiped them out.  Unfortunately, I don't really know when they disappeared other than we had last payment dates of Jan 31.  What's odd is the test environment still has the triggers.  TTest was copied from production and upgraded.   Than about a week later prod was upgraded.

The configuration page for Summary Fields showed the Contribution Table Triggers: Enabled.  Funny since they didn't exist.  I can see that the job for summary fields ran every hour without any errors.

Saving the configuration page and kicking off the job recreated them and seems have updated the fields.

The question here is why didn't the job notice the triggers were missing and why did it report there were enabled?  Oh and I suppose what could have caused them to be deleted?


texts:
I have borrowed the title from this unanswered forum post by Laryn: DeDupe errors when Individuals have Membership (by relationship).

Just encountered the same error on a Civi 4.6.9 / Drupal 7 site. Laryn, did you get anywhere with this? Or can anyone shed any light? It appears that CRM_Member_BAO_Membership::createRelatedMemberships(), via some intermediate function calls, tried to insert a civicrm_membership record without specifying membership_type_id: our error & backtrace is very similar to Laryn's:

[debug_info] => INSERT INTO civicrm_membership (contact_id , status_id , owner_membership_id ) VALUES ( 15835 ,  2 ,  21422 )  [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (my_civicrm.civicrm_membership, CONSTRAINT FK_civicrm_membership_membership_type_id FOREIGN KEY (membership_type_id) REFERENCES civicrm_membership_type (id) ON DELETE CASCA)]

Excerpt from backtrace:

#10 .../civicrm/packages/DB/DataObject.php(1060): DB_DataObject->_query("INSERT INTO civicrm_membership (contact_id , status_id , owner_membership_id ...")
#11 .../civicrm/CRM/Core/DAO.php(450): DB_DataObject->insert()
#12 .../civicrm/CRM/Member/BAO/Membership.php(102): CRM_Core_DAO->save()
#13 .../civicrm/CRM/Member/BAO/Membership.php(310): CRM_Member_BAO_Membership::add((Array:6), (Array:0))
#14 .../civicrm/CRM/Member/BAO/Membership.php(1941): CRM_Member_BAO_Membership::create((Array:6), (Array:0))
#15 .../civicrm/CRM/Dedupe/Merger.php(1655): CRM_Member_BAO_Membership::createRelatedMemberships((Array:4), Object(CRM_Member_DAO_Membership))
#16 .../civicrm/CRM/Dedupe/Merger.php(512): CRM_Dedupe_Merger::addMembershipToRealtedContacts(6428)
#17 .../civicrm/CRM/Dedupe/Merger.php(1349): CRM_Dedupe_Merger::moveContactBelongings("6428", "36044")
#18 .../civicrm/CRM/Dedupe/Merger.php(660): CRM_Dedupe_Merger::moveAllBelongings("6428", "36044", (Array:6))
#19 .../civicrm/CRM/Dedupe/Merger.php(596): CRM_Dedupe_Merger::merge((Array:75), (Array:3), "safe", TRUE, TRUE)
#20 .../civicrm/CRM/Contact/Page/DedupeFind.php(97): CRM_Dedupe_Merger::batchMerge("11", "48", "safe", TRUE, TRUE)
#21 .../civicrm/CRM/Core/Invoke.php(312): CRM_Contact_Page_DedupeFind->run((Array:3), NULL)


texts: How to display CiviCRM menu for non-admin role using WordPress?

texts:
We would like to restrict access within the WordPress dashboard to the "subscriber" role settings but also have the ability for that user to access the CiviCRM. The only way we can get the CiviCRM link to show in the left navigation is to set the user's role to admin which we don't want. I found this thread here. How to show CiviCRM menu for non admin role using WordPress? However, we have not blocked any access to the menus so there does not seem to be an answer there for us.

We've adjusted the settings through CiviCRM > administer > Users & Permissions > Permissions (Access Control) > WordPress Access Control. So far, we haven't had any luck.

It looks like in the screenshot here that it is possible. (refer to the image in the WordPress Access Control section. https://book.civicrm.org/user/current/initial-set-up/permissions-and-access-control/ I only see the left navigation links for subscriber plus CiviCRM.

Thanks for any and all suggestions.


texts:
I'm consistently maxing out my "MySQL Time" on my shared hosting provider (rhymes with MiviMosting), causing both my host and users to get upset. I'm pretty much tripling what I'm allowed to have on the shared setup.

So now I'm looking for a VPS solution but am not sure what specs are ideal for running CiviCRM (the Drupal side goes nearly unused). Currently, I have 1GB disk space, 200MB RAM, and 20GB transfer. I'm well below the limits on disk space and bandwidth so my assumption is that it's the RAM that's holding me back. Are there other important considerations? Recommended hosts?


texts:
We recently upgraded to 5.4 and now when we create a new mailing, we are unable to enter any HTML content. The HTML area shows without the white editor area and any HTML options. The plain text area shows fine.

See the screen capture - the HTML area is blank while the Plain Text area has a white space to enter content.


texts:
Is there a way to manually override someone's CiviCRM ID?

A long time member of ours got his original ID number from our previous database. When we switched to Civi, it changed his ID. He would like his old ID number back.

Thanks!


texts: How to get rid of past events in the Event field lising (Select Box) on New Event Registration page Page

texts: In the New Event Registration page, Event field gets all the events from very beginning. How can I configure to display only the upcoming events.


texts: How can I access multiple values returned by a Form Field in Form Processor?

texts:
I am trying to configure CiviCRM Form Processor. I am using a form with a field of type "option group" (let's call it the Products field) where customers can choose a product. They can choose multiple products at a time, which are handed over to CiviCRM as an array of strings (according to API Explorer). I want to create a CiviCRM Activity for each of these options chosen in the Products field.
I already created an Action of type "Create/Update Activity" for each product, based on the condition "Array parameter contains" and I chose the Products field as the parameter. This works.
But my problem is, when creating the Activity, a custom field should be automatically set with the product name a.k.a. option group value. That is, I do not only want to check if the output array of the Products field contains a certain value, but I also want to use that value when creating the Activity.
I tried to use the pre-built Action "Others: Explode List" with the Products field as a param, to get access to each single product / option group value. But the API Explorer threw the error that this Action was given multiple values instead of a single one. So I suppose the Products field returns multiple values already.
Now I wonder how I can use these values in my create Activity Actions?
When I am editing an Action, I do have the choice to fill fields with the value of Input::products. But which value is that, if Products field returns multiple? How do I access the second value, for example?
I am thankful for any hint.


texts: How to make a Participant Listing menu link in Joomla

texts:
Bit of newbie question since we don't work with J! much. This is J! 3.4.3 in case that makes a difference.

I need to make a Participant Listing link. I have enabled it on the civi event, and the instructions there say

  Then create front-end links to the Participant Listing page using the Menu Manager. Select Participant Listing Page and enter 1 for the Event ID.

So I added a Menu, and added a Menu Item which allowed me to set the Menu Item Type to be Participant Listing (from a select) and that added a path in the Link field index.php?option=com_civicrm&view=Events&layout=participantlisting

Looking around for where to add '1' for the Event ID, I find under Options a "select event" but it shows no options in the selector and I have no idea if that is referring to civi events or some other 'concept'. Any pointers?


texts: Sync custom first and last name fields in Drupal with CiviCRM

texts:
We have an online training platform and had created custom first and last name fields to be used on their training certificates. Drupal asks for this information when they register for an account. However, this first and last name is not passed on to CiviCRM until they fill it out again during the subscription process.

How can I synchronize the first and last name fields in CiviCRM with the custom first and last name fields I created in Drupal? Thanks!

CiviCRM 4.7.15, Drupal 7


texts: Can't print participant's image in name badge

texts:
I'm trying to use the Name Badges feature to create badges for an NGO I work as a volunteer. So far I was able to set up the badge with the fields I need. Everything seems to be ok but, when I click to generate the PDF with the badges all the fields are there but the contact (participant) image. Even the QR Code is generated and printed.

I tried to debug in all the ways I know and found that, at /wp-content/plugins/civicrm/civicrm/CRM/Badge/BAO/Badge.php the imageURL has indeed the correct image path and file name.

The strange part is that even with the imageURL being correct, the image doesn't show up in the PDF. However, when I tried making imageURL a fixed value the image was printed (obviously, the same image for all participants).

As I ran out of options, would someone point me to any other way to figure out why this happens and how to fix it?

Any help is much appreciated.
Thanks!

CiviCRM 5.10.4

Wordpress 5.1

--- x ---

Thanks to a user's insight in lab.civicrm, I did some additional investigation and found that in db the imageURL is stored as

http://domain.org/civicrm?page=CiviCRM&amp ;q=civicrm/contact/imagefile&amp ;photo=0008_51c4b981d854da8af05e187aa199952b.jpeg

with &amp ; (I've added the space here because of the editor) instead of just &

I manually updated one record and the badge was generated with the image.

I can't say this was introduced as part of the update process or not, but a script to fix imageURL will make it work while the root cause is investigated.


texts: I want to override my CiviCRM settings. I am new with CiviCRM and I don't know where to put the line referenced in the attached image. Thanks in advance.


texts:
I was told to integrate Views 3 with Drupal 7 following this tutorial:

https://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration

However, I do not have this:

You should see a page with output that begins with: "$databases['default']['default']['prefix']= array("

So I'd like to know if that tutorial doesn't apply anymore or what I need to do to get that PHP config to show.

This is a fresh installation so I'm using latest versions of Drupal and CiviCRM

Thanks!


texts: CiviCase - Edit Actions with permission: "CiviCase: access my cases and activities"

texts:
Im Configurating CiviCase and I have seen that if a contact has the "CiviCase: access my cases and activities" permission, he cannot use the actions of the assigned roles.
I understand that this permission has certain limitations, but I think this should be available, maybe I am wrong, but I think it would be interesting to be able to eliminate the assigned roles or change the person from the role since the case is created by the user who edits it.


texts: Error al introducir un contacto -- Entered a contact name incorrectly

texts:
He introducido como segundo nombre el primer apellido de un contacto:
Irene Martínez Mas. Cómo puedo corregirlo? La aplicación me dice que no tengo permiso para hacerlo.

I have entered as the second name as the first name of a contact: How can I correct it? The message tells me that I do not have permission to do it.


texts: How to revert the demo sites to English? (Or change to another language)

texts:
The demo site is in Russian (or Chinese or French -- or any language you don't read fluently), how can I switch it to English (or my preferred language)?

As the demo sites are periodically reset to a default state (in English), waiting is an option, but not the fastest one.


texts: Why do the Extension stats differ so much between https://civicrm.org/extensions and https://stats.civicrm.org/?tab=sites

texts:
There is a quite a big difference. For example

Mosaico | 1452 | 1032


texts: For civiEvents in a Drupal View, how to display only one of a repeating event?

texts:
[apologies for cross posting. This question is also on Drupal answers, but since the options for filtering would be based on civiEvent fields, I am posting here as well)

We have a view that displays upcoming events. We use civiCRM for events. Some of our events are ongoing: they have the same title, but different dates. What logic could I use to display the next upcoming event, without displaying all upcoming events?

For instance, at the moment the events displayed are based on date. Any event that is not yet passed will display in the view. But for a class which repeats 10 times, I do not want 10 of the same title, just the next class and its date/time.


texts:
Registrants have status recorded as  Pending from incomplete transaction
even after PayPal has collected fee and confirmed payment

I have been over the PayPal processor setup multiple times and believe I have followed the text.

I have created an event and assigned the PayPal processor to it.
When I do a  registration civicrm accepts the registration and presents me to the PayPal site. the payment is made , charging the registrant and completing the payment to my merchant account, PayPal returns me to the registration page with the message "Your registration payment has been submitted to test ( test is the name of the fees for this event) for processing. Please print this page for your records."
 PayPal merchant account sends out a notice to both my PayPal merchant email and the registrant email confirming the transaction.

when I look in the event registration list to view the registrants, there are no attendees paid.
Only when I look in Pending from incomplete transaction do I find the listing with the pending notice attached.

CiviCRM version:     4.6
CMS version:     wordpress 4.3.1
MySQL version:     5.5.42
PHP version:     4.0.10.7


texts: Remove Individual's eMail as default when sending eMails

texts:
Sending ( not mass-sending ) of eMails:
the eMail address of th actual user is put to the send-from field.
Alternativley the organizations eMail address can ( and has to be selected
manually - this is error-prone )
Question: how can I make only our orgaizations eMail address to be displayed - or at least show this as default instead of the acual user's one?

best regards, Markus


texts:
My use case is that I want users to be able to pay for another user's Event Participation.

Currently, the display name is baked into the source:

I'm hoping to add a column "Contribution By" to record a link to this person instead.

How can I add a column into this table?


texts:
I just did our first email blast and it went pretty well. I'm using the token {action.optOutUrl} in the footer, plus the domain address, but that's it. The Opt Outs appear to have worked fine and they're labeled "No Bulk Emails (User Opt Out)" in the CiviCRM database. The bounces processed properly as well.

The weird thing was that the Mail Report shows that 5 people made "unsubscribe requests". How did they do that since the token isn't there?? Plus, their records aren't flagged with any red message, tho they do show up in Advanced Search. Did these people hit the spam button on their email programs? Will they get future emails? Am I supposed to do something with them? Thanks, in advance! Jim


texts: How can I send an event-specific PDF certificate to participants via email?

texts:
Using Civirules and the PDF Creation API extension I can send an email with an attached PDF containing tokenised content to a contact based on a specified trigger and conditions.

What I want to do is be able to send an email to an event participant (triggered by the change in their participant status) with an attached PDF that contains data pulled from both default and custom fields for that given event. Do-able? Feels like it should be, but when setting up the message template for the email and the PDF I don't know how I could specify suitable tokens for the event?


texts: Allowing multiple fianancial types for same price set single contribution page

texts:
Price sets and Contribution pages allow for donations to a "Financial Type" (and corresponding Financial Account)  This is great for managing different types of donations.

It is possible to generate contribution page and profile for that maps to a single financial type.  It is also possible within a single price set to specify an associate price set that maps to a financial type (I assume this will override the contribution page financial type.  But there is no way to dynamically select a price set. (btw - this would be a great feature!)

This means replicating the same values for multiple price sets and writing some code to show on a single page.  I'm looking at 10 different "Funds / Financial Types"

For example: Select from ($100, $500 and $1000 donation) to either the General fund or the Scholarship fund on a single page

I'm looking for something in wordpress, but webform-civicrm doesn't seem to allow this either.

Some approaches I've considered:

Create a massive price set with all potential Financial Types and use
some javascript to dynamically show/hide.  This seems really ugly and
hard to maintain.
Create a parent page with some javascript to dynamically load and
select from several contribution page URLS.  A bit cleaner, but IMO
hackish.
Set to a dummy financial type and then write a script to re-assign to the correct one based on a value in a profile.  I have not looked at the API to do this yet, but assume it would make fewer assumptions than javascript ....

BTW - I'm posting here as I think a common use case is a single page that dynamically sets the financial type based on a donor selection. Please comment if I'm right/wrong.


texts: Civi entity didn't automatically create the table in database

texts:
I created a new entity for my extension. These are the steps i followed:

Generated the skeletal files using civix generate:entity command
Edited the XML schema definitions as i needed.
Generate your DAO and SQL files using civix generate:entity-boilerplate command.
Generated the database upgrader.

After following these steps i found the 'auto_install.sql' has the sql query to create the table in DB. But when i uninstall the extension and reinstall it again it didn't created the table.
I even executed the sql query manually it works fine but when i reinstall it, it doesn't create the table.. what could be the reason?
Thank you very much in advance!


texts: Profile sync using CiviCRM WordPress Profile Sync

texts:
Following use-case:

CiviCRM has many contacts, including contacts of individuals with the same primary email address (e.g. one corporate email, two
    individuals (contacts) working there) -> forget that there may be
    methods of better organizing this.
Both contacts do not have a WP user account.
CiviCRM WordPress Profile Sync is working
One of the individuals registers with WP using THAT email
Which contact does the new WP user get associated with?
Testing it as best as I could the answer is: always with the lowest CiviCRM ID

I've tried to find if there's a reference to it in the plugin's PHP , or elsewhere.

Wondering if this is by default?

Cheers


texts:
Is there any way possible to have dedupe rules specific to particular profiles instead of for whole contact feature?

Example:-

Profile 1:-

Name
Email
Dob
Gender

Profile 2:-

Name
Dob
Gender

Dedupe Rule 1:- Name AND Dob AND Gender

Above rule is defined which applies to both profiles

how make it specific to Profile 2?


texts:
after update from 4.6.2 to 4.6.9 i have this error in:

Entità: Job Azione: fetch_activities
Summary
Finished execution of Process Inbound Emails with result: Failure, Error message: Process Activities failed

What can i do ?
Thanks

I delete all email account and the error persiste.


texts:
As part of our joining process we send out a membership pack to new members. This involves exporting the name and address details to a mail merge to produce a membership card.

What is the best way to track and process these new members? I was hoping to use the membership status but that only works on dates. Would a custom field or a tag or group be the best approach?

Regards

Steve


texts: How to remove a contact from a group with Webform?

texts: Judging from various questions here it appears possible to remove a contact from a group using a webform. e.g. See this question. But 'how?'  I have added the group to the webform and want to give the user a checkbox so they have the option to be removed from the group. But I'm stumped as to the next step.  What component can be configured to link to the group? I've added a 'select options' component but can't see how it can be configured.


texts: Multiple Contacts and Memberships Later Merged to One Membership

texts:
I have a problem that I'm not entirely certain how to work around. I have two contacts, who have been two separate members for a long period of time. But recently they married and are now sharing one membership (example: Two at same address). How would I record them sharing a single active membership while keeping their past data (as singles we'll say) available for them to review?

Thanks!

Matthew


texts: Trouble moving a Wordpress/CiviCRM install to a subdomain

texts:
I'm having trouble moving a Wordpress/CiviCRM install to a subdomain: from domain-name.com to sub.domain-name.com. What follows is the procedure I'm using (culled from forum articles Wordpress, and CiviCRM docs)--please advise where I'm going wrong. Any help would be greatly appreciated.

P.S. there are many permutations of the following steps and I've tried many of them. I do know that using PHPMyAdmin to export/import is not advised because Foreign Keys data is lost.

I dumped the original CiviCRM 4.6.9 database using SSH:

mysqldump --no-create-db=true -h db111111111.db.1and1.com
-udbo111111111 -pPassword db111111111 > exportedDatabases/db111111111.sql

I also dumped the original CiviCRM 4.6.9 without the domain and cache tables:

mysqldump -h db111111111.db.1and1.com -udbo111111111 -pPassword --no-create-db=true --ignore-table=db111111111.civicrm_domain --ignore-table=db111111111.civicrm_acl_cache --ignore-table=db111111111.civicrm_acl_contact_cache --ignore-table=db111111111.civicrm_cache --ignore-table=db111111111.civicrm_group_contact_cache db111111111 > exportedDatabases/db111111111-nocache.sql

I created a fresh WP site at sub.domain-name.com using same username and password as original.

I used PHPMyAdmin to create a fresh database db999999999 with the same password as db111111111.

I created a fresh install of CiviCRM 4.6.9 closely following CiviCRM install procedure for Wordpress and using db999999999:

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

The new CiviCRM 4.6.9 functions.

I uninstalled the native modules to match the original install.

I deactivated the new CiviCRM 4.6.9 plugin.

I dumped the new CiviCRM 4.6.9 db999999999 using SSH:

mysqldump --no-create-db=true -h db999999999.db.1and1.com -udbo999999999 -pPassword db999999999 > exportedDatabases/db999999999.sql

I also dumped the new CiviCRM 4.6.9 domain and cache tables:

mysqldump --no-create-db=true -h db999999999.db.1and1.com -udbo999999999 -pPassword db999999999 civicrm_domain civicrm_acl_cache civicrm_acl_contact_cache civicrm_cache civicrm_group_contact_cache > exportedDatabases/db999999999-5TABLES.sql

I used PHPMyAdmin to DROP all tables in db999999999.

I re-imported db999999999-5TABLES.sql into db999999999 using:

mysql -h db999999999.db.1and1.com -udbo999999999 -pPassword db999999999 < exportedDatabases/db999999999-5TABLES.sql

I used a text editor to modify all instances of '111111111' to '999999999' in db111111111-nocache.sql

I imported db111111111-nocache.sql into db999999999 using:

mysql -h db999999999.db.1and1.com -udbo999999999 -pPassword db999999999 < exportedDatabases/db111111111-nocache.sql

I deleted all files/folders in .../templates_c/*

There were no error messages until I (re)activated the CiviCRM 4.6.9 plugin when I get the cryptic error:

"DB Error: no such field"

Running the following did not change anything:

sub.domain-name.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/setting/updateConfigBackend&reset=1

sub.domain-name.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/admin/setting/path?reset=1

sub.domain-name.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/menu/rebuild&reset=1

Any help would be greatly appreciated.


texts: Is it possible to dynamically override the .tpl file path in CiviCRM?  Rather than use the corresponding TPL file to the Class.


texts: how can I add Members of a Groups (JCVA Color Guard group) to event participants for a Color Guard event

texts: I have created events for our association's color guard to present the colors for different and various Organisations and they are showing as Events in CiviCRM.  I would like to be able to place color guard groups members in these events and track who (color guard group members) is participating in what Color guard events.  I don't see a way to add group members as event participants.


texts: How can I pass CiviCRM first name and last name fields to Drupal API user_save

texts:
I am calling the Drupal API "user_save" to create a brand new Drupal user. This does create a new Drupal user. But this user does not have the CiviCRM first name or last name fields set. How can I pass first name and last name to the Drupal API "user_save"?

I investigated how CiviCRM handles passing the firstname and last name when someone registers online (which includes a profile that collects first name and last name). CiviCRM only has a mechanism to deal with this situation when someone is online, not using the API, per code in the CiviCRM core file /sites/all/modules/civicrm/drupal/civicrm_user.inc

This issue causes problems with my CiviCRM dedup rule, which is set to check for first name, last name and email. Since for any Drupal user created via the API does not pass the first name or last name, a new CiviCRM contact is created as well. (In addition to the Drupal user)

In my scenario I have a civicrm contact called "testfirst", "testlast", "test@test.com" in the backoffice. I create a Drupal user for this contact (using the API user_save). This contact does get associated with the new Drupal user. However, there is also a brand new contact with the email address "test@test.com" but no other data. This brand new contact is getting created because the unsupervised dedup rule is checking for all 3 fields (first name, last name, and email).


texts: Recently, our civiCRM update and we are not able to create a membership badge anymore.  This is all that pops up under "Actions..."


texts: How do I use the javascript field in the price_sets table of the database

texts:
I have noticed that there is a field called 'javascript' in the 'price_sets' table in the CiviCRM database.
The comments associated with this field are:
'Optional Javascript script function(s) included on the form with this price_set. Can be used for conditional'.
However I cannot find any documentation on how I should do this in the correct way, and have never seen it mentioned when using price sets through the UI.
I would really like to use this functionality, to limit what people can enter into a form, e.g. for event registration.
I know that this is not a fail safe method, but could limit confusion or mistakes from users.
Does anyone have experience of using this database field to add javascript functions to? An example would be great!


texts: How do I add a currently unsupported field to Views?

texts:
For example, the email_greeting_display field of the civicrm_contact table is not available as a field in Views.  How do I add that to a View?

See also How to include a token in a view?


texts: Joomla front end map function gives a narrow map

texts:
You can search for contacts using a profile from the Joomla front end, and permit mapping, but the map is very narrow, and you can't search for counties.

Inspecting the page with a debugger shows that the code is expecting to see files under the civicrm folder which is not in the front end components/com_civicrm folder.


texts: how to add two dropdowns parallel to each other, e.g. one drop down with name of the item and the second dropdown with the quantity of the item. I have tried to add two dropdowns but they appeared one below thee other. Basically what are I'm trying to do is to have an "Item" correspond to the "Quantity" to how many were sold. Please check the image below.


texts:
I am running CiviCRM 4.6.13 on Joomla 3.4.8.

I have created a membership directory following the wiki direction (https://wiki.civicrm.org/confluence/display/CRMDOC/Creating+a+website+member+directory).

At first, it worked just fine when previewed with "Use Profile-Listings Mode." Then I created a menu item to view the profile as a list in Joomla (Profile View Page with my Membership Directory profile selected).

When I click on the link I get an error "Permission Denied You do not have permission to view this contact record." And under that is a link "Back to Listings".

It seems that it is trying to take me to a specific individual record, and giving me an error based on that. But when I click on "Back to Listings" it actually takes me to the Profile listing just as I intend (except without the initial error). (However, at that time, it tells me "No fields in this Profile have been configured as searchable" even though almost all the fields have been set as searchable.)

The secondary problem is annoying, but why am I being taken to a page that says "Permission Denied You do not have permission to view this contact record." instead of to the profile list?

I can provide temporary credentials if you want to see the problem in action.


texts: How to extract views integration setting from the command line?

texts: Is there a way to output from the command line the views integration settings as listed in Administer > System Settings > CMS Database Integration? I need this as part of our upgrade script to automatically update settings.php (rewriting a php include file) every time a system upgrade is released.


texts: How to insert thankyou_text in petition thank you email?

texts:
We want the 'thank you message' in the petition sign up instead of the petition title in the thank you email sent.  This then allows for the thank you message shared after signing up to also be shared via email.
I've tried changing the code which stands at; Thank you for signing {$petition.title}.
To  {$thankyou_text}.
But the code isn't retrieving the text from the petition.  I've tried some derivations but believe I haven't got the right code to draw this in.
Does anyone understand my problem and can provide a solution of the code that should be used?


texts: How do I set up a cronjob to run scheduled jobs?

texts:
I have a Joomla 3.3.3 installation with CiviCRM 4.6.10 and Siteground is my host. I have never set up a cronjob before. I have tried to use Sitegrounds Cronjob tool in cPanel which uses Linux commands which I am also unfamiliar with.

The support staff helped me create a command string - /usr/local/php53/bin/php-cli /home/ashguild/public_html/home/administrator/components/com_civicrm/civicrm/bin/cron.php - but I get the following

ERROR: You need to send a valid user name and password to execute this file

I haven't been able to find out how to include the username/password in the string or even if that's really the problem. As you can tell, I am very inexperienced and would appreciate any help I can get. Thanks.


texts: Bounce handling with amazon-ses not working

texts:
I am trying to get the extension amazon-ses working. I have created an AWS account, signed up for SES mail, and verified my domain. DKIM and SPF are working and verified.  I signed up for SNS, created a topic and subscribed to it using the webhook address defined by the extension. Civimail is configured to send to amazon by SMTP. When I sent a civimail to the list, it was delivered, so the SMTP setup is correct.

However I received a warning note from Amazon saying that our bounce rate is too high. Ok, but in civimail it says there were zero bounces from that mail, so clearly the bounces are not coming back through the extension. How do I debug this setup?

I am aware that the extension is marked alpha code, but I would like to get it going if possible.  Any pointers would be appreciated.


texts: Is there a method in ACL of allowing anonymous access to some events and not others?

texts:
I want some CiviCRM events to be Member-only and some to be public. But I'm not seeing a way of creating an ACL permission for the anonymous user and then assigning it to an event.

The only way of doing seems to be to revert to Drupal permissioning, which is global and not selective.

Is there a way around this? I'm thinking make all events available to everyone and put ACLs on profiles attached to events?


texts:
I would like to display pictures which are defined as custom "File" fields within an event. I currently to this by generating URLs having the following format:

MY_URL?q=civicrm/file&reset=1&id=FILE_ID&eid=EVENT_ID

There's another question that has been answered and can be seen here.

Using this worked, until CiviCRM recently introduced a security patch (i'm on version 5.10.3). Now, the picture urls have some sort of hash attached to them (the url contains fcs=...). Since that update, I can't display the pictures anymore.

Is there a standard, API way of getting images defined in custom fields? I know there's an Attachment API, but when I try to retrieve my file I get the following error:

{

"error_code": 0,
"entity": "Attachment",
"action": "get",
"is_error": 1,
"error_message": "Failed to run permission check: Unrecognized target entity table (civicrm_event)"
}


texts: Set membership end date to today for cancelled status

texts:
How can I set the membership end date to today in the status rules for a cancelled status? I can only adjust in month/day/year relative to a discrete event member since/start end.
Thanks!

To clarify, when I change a membership to cancelled, I would like the end date for the membership to inherit automatically today's date, but I can't figure out how to specify that in the status rules. Is that not the place to do it?


texts: How do I partially hide Ajax supplied content?

texts:
I tried hiding the edit, delete, enable and disable links in contact relationships writing an extension in the hook _civicrm_alterContent and injecting jquery:

  $content= $content . "
    <script type='text/javascript'>
      CRM.$(document).ready(
        function($) {
          $( '.crm-contact-relationship-links span a:nth-child(2)' ).remove();
          $( '.crm-contact-relationship-links span:nth-child(2)' ).remove();
        }
      );
    </script>
  ";

The data I want to hide is supplied through Ajax and apparently out of Jquery's reach because I don't see the desired effect.

Then I tried it using the dataTable API:

        <script type='text/javascript'>

      CRM.$(document).ready(
        function($) {
          var table = $('table.crm-contact-relationship-selector-current').DataTable();
          table.$( '.crm-contact-relationship-links span a:nth-child(2)' ).remove();
          table.$( '.crm-contact-relationship-links span:nth-child(2)' ).remove();
        }
      );
    </script>

Without success!

Any suggestion to still reach my goal?


texts: Missing Custom Activity Field Data When the Activity is Filed on a Case.

texts:
As the title states. Data that I enter into custom activity fields, is saved and

I can view that saved data from the Activities tab in the Contact Summary.

Like this:

But after the activity is filed on a case most of the data fields appear empty when the data is viewed from within CiviCase.

These fields were working fine up until I updated the system to 5.4. It continues after I updated to CiviCRM 5.5.1. on WP version 4.9.8.

How can I troubleshoot/fix this error? I am not able to duplicate this issue on the demo system found at https://dmaster.demo.civicrm.org/.

Not sure if it is related but I'm not able to create a Public Profile to share as that is getting an error, "Identity is invalid, Certificate is Expired".


texts:
I have a WP civicrm install.  I am using a price set on a membership contribution page, but the total amount is not displaying.

All works fine on test drive but on the live page no total amount is displayed at all, either initially or when any items from the price set are chosen.

It seems like the price total calculation is working as when contribution is confirmed the next pages shows the correct amounts.


texts: Civimail sparkpost extension stats / is my mail being delivered?

texts: We are using the cividesk sparkpost extension on civicrm 5.5.3 and wordpress 4.9.8.  In the last few days, we have sent 2 emails to the full list which is about 6,000 emails each, so it should be showing around 12,000. Civimail shows almost all of the mail is successfully delivered. However sparkpost's summary report for the last 7 days shows 167 accepted, 12 bounced, 0 rejected, 256 rendered, and 179 targeted.  What do those numbers mean?


texts:
Here's the scenario:

we are using civicrm 4.6 with Wordpress
we want to accept payments for membership via PayPal
we don't want to take payment until membership request approved

So basically we want to accept membership applications that remain as Pending and then when we accept them we request PayPal payment to be made.

Any ideas?

I've created contribution page with 'pay later' option. This works great in that individual record and membership are created with status Pending. There is even an option to then manually record a payment to complete membership- but not via PayPal!

Now I don't know much about PayPal and IPN, but would it be feasible to have PayPal as a manual 'pay later' option that when invoked fired off email to customer asking them to make PayPal payment using a specific URL provided (or reference) and then PayPal via IPN notifies CiviCRM on success and membership then set to active? I'm guessing CiviCRM must have a PayPal 'listener' but does this only listen for responses made to request directly made from CiviCRM to start with or can responses come one way from PayPal to complete a transaction?

Any help appreciated.

Thanks


texts: Webform - autofilled fields using "Existing User"

texts:
I often use the "existing user" field in a Webform so that authenticated users don't have to re-enter info that we already have in CiviCRM.

This works well but I realized that collection fields that exist after a page break, meaning not in the same page as the "existing user" field, aren't populated and remain blank.

Am I missing something? Is there a way around this?


texts: wordpress/civicrm mobile optimi2ed themes

texts:
The existing thread is stale (2017), a lifecycle ago in internet terms.  Seeking theme which enables contact search/edit/update functionality and activity add via mobile theme.

civicrm mobile access on wordpress 2019 is cumbersome.


texts: Why does CiviMail stop sending after the first 1,000 messages?

texts: We have about 30k recipients in our lists and every time we send a mailing (New Mailing - Submit Mailing - Schedule Jobs - Execute Process Mailing) it stops after 1000 messages. We usually have to refresh the page and continue until it completes. How can we work around this? Thanks for your kind help.


texts:
I want to assign everyone in a particular group to an activity when I create the activity.

Currently I only see how to add each one individually. This happens frequently enough that I would like to just assign to the group and have the contacts show up in the list of assignees, or use some other method to attain the same result.

When adding a new activity I can narrow the search to my group, but then I still have to add each one separately.

I tried searching for contacts in a group, then look for an action of "create activity" but that didn't show in my list of actions.

Thanks in advance for any help you can offer.

CiviCRM 4.6.3 on Drupal 7.37 in a Linux Mint 17.1 VirtualBox


texts: Webform-civiCRM equivalent for Wordpress?

texts: I'm new to CiviCRM and I have a colleague who's using it with Drupal and loving the Webform-CiviCRM integration. I myself use Wordpress and would like to be able to stay with Wordpress but I understand that Webform-CiviCRM is Drupal based. We'd be using forms as a way for new users to register with our organization and I'm wondering how we can achieve similar functionality with forms while staying with Wordpress. Please advise. Thanks!


texts:
I try to change the language localisation of our site to dutch following the documentation at: http://wiki.civicrm.org/confluence/display/CRMDOC/i18n+Administrator%27s+Guide%3A+Using+CiviCRM+in+your+own+language

I uploaded our language files at sites/all/modules/civicrm/l10n/nl_NL
Now some of the backend interface (settings) shows in dutch.
But the admin menu and for instance event emails are still send in english.

When I change the language on the 4.6 sandbox the whole menu changes.
I already dropped civicrm_domain. What else can I do to get this working using civicrm 4.6.4 / drupal 7.38 ?


texts: I have set up a smart group to list current memberships by chapter. When I search contacts by a certain chapter I get 222 contacts. If I search by the smart group defined for that chapter I get 221 contacts. If I search memberships by that chapter I again get 222 contacts. I hit the update counts link in the groups page but the smart group count stays at 221.


texts: Member only page-login using civicrm database

texts:
We have a website, We also use civicrm for our membership and communications. Now we have our 16000 records entered into civi and all correct, can we restrict access to some member content pages(not written inside civi), Essentially we want to create a login for the member only content, have a script check with civi that the membership is still current, maybe check member id and email then allow access to the pages we want members to have access to. We dont want members to signup and pay for membership because the folks we represent dont do credit cards!! We just want a page or area of our website thats restricted to our members rather than the entire webiverse.

Or am I dreaming that it can be done?


texts: Setting up a view to list the current user's activity details

texts:
bit of help appreciated please!
I'd like to create a view that shows authenticated users the details of some specific activities that've been added to their record (added by a different user, the target is the 'with contact').
Fields to be shown

Activity type
Activity description

Filter type

Activity type

Where I'm falling down is setting the relationship or context to limit the results only to the currently logged-in user. I've had a look through Stackexchange but couldn't find what I'm looking for - would anyone be able to assist?


texts: What would cause Cannot create user, email: invalid!! on an civicrm integrated webform?

texts:
When submitting a webform (links below) on our site, an error message is generated: Cannot create user, email: invalid!!

This error message displays for all webforms and for all email addresses, whether it is a valid email address or not.

In only one of the forms listed below should a drupal user be created. The other two forms are only intended to add people to mailing lists.

What should I be looking at to help understand this?

Webform for Mailing list only:

https://www.jewishideas.org/resources-educators

https://www.jewishideas.org/newsletters-0

Webform should be adding a free membership, so a user record is desired:

https://www.jewishideas.org/university-membership


texts: Mosaico with WordPress Unexpected errors

texts:
I am working with the Mosaico extension in WordPress with Civi 4.7.20.

If I go to build a template the template builder loads OK. I get several errors when working on the template.

When a template loads the image placement areas do not show an image and if I upload an image I get an internal server error.
When I try to save an template I get an unexpected error, please contact us. This only occurs on the versafix-1 template the tedc15 template saves OK.

Not sure if it is a bug or configuration issue.


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

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


texts: How to add Thai language to CiviCRM in WordPress?

texts:
I'm using WordPress v4.9.5 and install CiviCRM v4.7.31
I want to activate 'Thai' language to CiviCRM, but there is no option to include this one into system.
I try to check at Administrator > Localization > Language, Currency, Locations
There is only one available which is "English (United States)"

I also try to contribute to translate project at https://www.transifex.com/civicrm/civicrm/translate/#th_TH but there is no progress yet, it's about 5%

I download l10n from https://download.civicrm.org/civicrm-4.7.31-l10n.tar.gz but don't know how to install these folders to CiviCRM (there are multiple folders of l10n, and sql folder which does not have Thai files)

Could anyone help me?


texts:
My CiviCRM does not seem to have CiviMembership. It is not listed on the administer menu on the top menu.

How do I proceed if I want to use CiviMembership?


texts: Wordpress Civicrm doesn't seem to generate invoice from other user roles except administrator

texts:
CMS: Wordpress 4.9.6

CiviCRM: 5.2.1

I'm trying to generate Invoice with the below url, Which is working fine when I login as administrator. but when I login as actual member to download Invoice from WordPress front end with the same url giving me this error

  Sorry, you are not allowed to access this page.

( I gave this civi permission

CiviCRM: view my invoices
Allow users to view/ download their own invoices

to all user roles).

http://devsri.mywebsite.com/wp-admin/admin.php?page=CiviCRM&q=civicrm/contribute/invoice&reset=1&id=48657&cid=35509

Its working when I give below(CiviCRM: access CiviCRM backend and API)permission

"CiviCRM: access CiviCRM backend and API" Master control for access to the main CiviCRM backend and API. Give to trusted roles only.

But I cant give this permission to a member just to download Invoice. In drupal its working with "CiviCRM: view my invoices" permission. I wonder if its a bug in Civi Wordpress??

Did anyone experience this? or Am I missing anything here?

TIA


texts: How to use Find Contribution to find folk who Donated via a line item on a Membership Price set

texts:
Scenario:

(FT = Financial Type)

A price set is created using eg Member Dues FT and Donation FT. Contribution page is submitted (which is FT = Member Dues).

A person submits the form above so have paid for Membership and made a Donation

Admin want to use Find Contributions to search for all folk who made a Donation. And from their perspective the person above should be listed, but they don't because Donation was a 'line item'.

Thoughts?

Could be an option be added to the Find Contribution interface to 'search by line item'? Other, probably better ideas?


texts: What data fields are available to me at receipt template

texts:
My CiviCRM 5.16.
When I try to add fields to receipt template, I discovered that I could add {$line.contribution_id} which shows the record ID of the contribution.
But adding {$line.creditnote_id} (which is also a field in table civicrm_contribution) shows nothing.

How can I know (or change) the data fields that are available for me to show on the receipts?

Thank you.


texts: Changing the content of the group that I have created

texts: How do I change the content of the group i have created?  The group that I have exists now is not what I intended to create but I am having difficulty changing it.


texts: "There has been a critical error on this website" after assigning CIVICRM_CRED_KEYS & CIVICRM_SIGN_KEYS to config

texts:
My wordpress site is down with error"There has been a critical error on this website" after assigning CIVICRM_CRED_KEYS & CIVICRM_SIGN_KEYS to civicrm config. removing those keys remains the same.
I had to manually disable civicrm and I can no longer activate it. Is there a way to reset these keys?
Edit: I restored old civicrm config and all is well now. Not sure what went wrong.


texts: How do I email a report automatically oh the 1st day of each month?

texts: I want to sent multiple reports (group membership lists) to different individuals (the co-ordinator of each group) on the 1st day of each month.  Scheduled jobs only allows hourly or daily mailing (not monthly) so I believe I may have to use CiviRules, but can I trigger a rule for a specific day of the month?  We use Civi with Drupal.


texts: CiviMail causes read timeout on Methods.pm

texts:
Version 4.6.9

When a scheduled bulk email is sent, Cron Daemon returns read timeout at /usr/local/share/perl5/Net/HTTP/Methods.pm line 271. Line 271 is inside the function sub my_readline. This has been going on for about a week, but it's been months since I've done any settings changes on the server.

Email delivery is unaffected according to CiviMail reports. I get this multiple times if sending lasts for multiple cron cycles. The Send Scheduled Mailings job shows no anomalies. Does anyone have experience resolving this error?


texts: will a scheduled reminder be sent after the specified date, if it hasn't been sent before?

texts:
Suppose, on a running installation, I add a reminder to be sent 1 day after membership end date.

Will this reminder suddenly be sent to all members that expired eg. in the last year, because they didn't receive it earlier ? Or is it sent only to exactly those members that have a membership end date between 24 and 48 hours ago ?


texts:
I haven't tested all the parts of civicase, but so far I have found that updates to activities, the main case record and custom fields are not locked.

Two users can update the same information with no warning or error at all.

Is this correct or is there a config option I have missed?

V5.17.4 on Drupal 7 if that makes a difference.


texts: How to respond to an email, quoting the reply

texts:
When an email arrives in my mail client, I can click on the reply button, and a new email is created that shows the text of the message I'm responding to, with the same subject letter as the original email.

My question is how to respond to emails in civicrm so it copies the original message's subject and quotes the original email's text?


texts:
Using Joomla 3.8.6, CiviCRM 5.0.0, php 7.0.29, mysql 5.6.39

The following error has occurred since upgrading to 5.0.0.

When adding a new case, I enter the minimum field data and click Save, and the window hangs, with the rotating CiviCRM symbol gif. There is an entry in the CiviCRM log, but it is so huge that I have not been able to make any sense of it. The log entry is about 3Mb big.

There is also an error in the Apache log:
File does not exist: .../media/fef/js/tabs.min.map

And this is what I'm seeing in the browser console:

POST https://...../administrator/?option=com_civicrm&task=civicrm/case/add&action=add&context=case&cid=30&snippet=json
500 (Internal Server Error)
send    @   jquery.js?r=2i4CQ:10254
ajax    @   jquery.js?r=2i4CQ:9738
fileUploadXhr   @   jquery.form.js?r=2i4CQ:346
$.fn.ajaxSubmit @   jquery.form.js?r=2i4CQ:254
doAjaxSubmit    @   jquery.form.js?r=2i4CQ:890
dispatch    @   jquery.js?r=2i4CQ:5226
elemData.handle @   jquery.js?r=2i4CQ:4878
click   @   crm.ajax.js?r=2i4CQ:466
(anonymous) @   jquery-ui.js?r=2i4CQ:12443
dispatch    @   jquery.js?r=2i4CQ:5226
elemData.handle @   jquery.js?r=2i4CQ:4878


texts: Contribute Widget showing Placeholder on Wordpress

texts:
There are a few posts that report this error but none of the solutions seemed to work for me.

Wordpress 4.9.4
Civi 4.7.27
http://radiowaterloo.ca/

I have a contribution widget in the Content Sidebar. On the home page, it displays "placeholder", similar to what others have reported. On any other page on the site, it displays as expected.

JSON output is also the same whether I look at the homepage or another page:

var jsondata3 = {"currencySymbol":"$","is_error":false,"is_active":true,"title":"FRIENDS OF CKMS FUNDING DRIVE 2018","logo":null,"button_title":"Contribute Now!","about":"CKMS NEEDS YOUR HELP!</big>
\r\n\r\nThe radio station is entirely run by volunteers and does not receive any ongoing funding from government or universities. The majority of our operations are funded by fees paid by the on-air hosts and donations from listeners like you!</big>
","num_donors":"2 Donors","money_raised":"Raised $ 30.00 of $ 2,500.00","campaign_start":"Campaign ends on March 24th, 2018","money_target":2500,"money_raised_percentage":"1%","money_target_display":"$ 2,500.00","money_low":0,"home_url":"Learn more.","homepage_link":null,"colors":{"title":"#000000","button":"#FFFFFF","bar":"#2786C2","main_text":"#000000","main":"#33FFF6","main_bg":"#FFFF00","bg":"#96C0E7","about_link":"#556C82"}};


texts:
I have the problem, that a bounce mailbox I am using ran full, and it's kind of hard to monitor , since the joblog of CiviCRM needs to be watched (Bounce Mail Cronjob).

Since Civi is managing the mailbox anyways, and moves mails to CiviMail/processed and CiviMail/ignored, shouldn't CiviCRM clean up afterwards and delete old mails? Or shouldn't there be at least an option for that?

Maybe there is an extension implementing that, but I haven't found anything yet.


texts:
I get an error 500 when trying to upload an image to server in CKEditor (for example when using print/merge document action), when the KCFinder new window opens. The URL called is :

https://subdomain.mysite.com/sites/all/modules/civicrm/packages/kcfinder/browse.php?cms=civicrm&type=images&CKEditor=html_message&CKEditorFuncNum=0&langCode=fr

I thought about a https related problem, but this URL :

https://subdomain.mysite.com/sites/all/modules/civicrm/packages/kcfinder/

...is working fine and opens the KCFinder file browser.

Does anyone encountered this problem ? I can't reproduce it on demo site, I am running CiviCRM 4.7.10 with Drupal 7.50. I don't have anything in Apache logs.

I suspect a file / folder permissions issue too, does anyone have an idea on what is going on ?

Thank you

EDIT

I was able to open the file browser using this URL :

https://subdomain.mysite.com/sites/all/modules/civicrm/packages/kcfinder/browse.php??cms=civicrm&type=images&CKEditor=html_message&CKEditorFuncNum=95&langCode=fr (note the "??" just after "browse.php")

...but

https://subdomain.mysite.com/sites/all/modules/civicrm/packages/kcfinder/browse.php?cms=civicrm&type=images&CKEditor=html_message&CKEditorFuncNum=95&langCode=fr (only one "?" after "browse.php") still gives me an error 500.

very confusing...


texts: I have set up scheduled reminder emails for events, but they do not seem to go out. I tested it by signing up for an event myself and did not receive a reminder email. Anyone got any idea on what I'm doing wrong?


texts: Missing mailing list subscription check box in Chrome, and Edge

texts:
The mailing list subscription check box missing form subscription page when I open the page in Chrome or Edge under win10, same with android tablet and mobile phone Chrome browser.
Works correctly in Firefox 47.0

Civi 4.7.9 under WordPress 4.5.3. with Hungarian settings.

Consequently no one can subcribe to the mailing list, and get "Please select one or more mailing lists." error message!


texts: How can I regenerate memberships shared by relationship?

texts:
Is there a way to do a one-time purge and regenerate of all memberships that are shared by a relationship? (I would be okay if it required doing some SQL directly in the database as long as it didn't conflict with anything else).

The issue is that some relationships were deleted directly in the database and I want to make sure all the memberships are up-to-date.


texts:
I need to do a de-dupe on a set of records.  Two groups were brought in with different External ID's for each contact.  I need to merge the contacts, but export the External ID that was kept and the External ID that was dropped.  Having the First Name/Last Name would be bonus.  This way, when I bring in additional data linked to an external ID, I can pre-write the corrected existing external ID from the map.

Contact A has an External ID of 123. Contact B has an External ID of 456. Contact A and B are the same person, but has two different External ID's from separate systems. I need to create a mapping, an exported CSV file, that maps 456 to 123, so that when I later bring in Note C related to Contact B via External ID 456, I can re-write the External ID to 123 and have Note C imported to Contact A with External ID 123.

Unfortunately, I don't see any kind of Export on the de-duping pages. I'm hoping that I am just missing it.  Any ideas how one might accomplish such a task without going line by line and copy/pasting to an Excel file?  (We're talking thousands here.)

Clear as mud yet?

Wordpress 4.5.3, CiviCRM 4.7.8
(Yes, I'm aware of the current de-dup flipping bug that is being fixed in 4.7.9.)


texts: Importing contacts and their relationships

texts:
this is really two questions, but may be answered via the first.

Q1: I have a large set of contacts (1400+) in a spreadsheet that already has a column for organisation (or household).  ie First name, Last Name, Organisation
When I go to import the contacts csv how can I auto-create the organisation contact and have the relationship set up so that an imported contact has the "Member of" relationship.
I have looked at https://wiki.civicrm.org/confluence/display/CRMDOC/Importing+Households+and+Household+Members

But i am not 100% clear on the instructions - is it saying to upload the Organisations first, then upload the members of the organisation

Q2:  if Q1 is not possible/practical or having imported contacts already that may not have existing relationship data, how can i bulk updated select/filtered contacts to add a relationship in one pass as doing them individually would be a very time consuming and error prone process.


texts: What should drush cvapi NotificationLog.retry sequential=1 system_log_id=XXX do?

texts:
Trying to re-run/retry some 'stuck'/"pending" notifications in the system log using:

drush cvapi NotificationLog.retry sequential=1 system_log_id=XXX

but that just produces an array with the JSON data in the log entry.

drush cvapi notification_log.retry id=748 used to do the trick.

Any ideas? Thanks.


texts: Can you import financial data into Sage accounts?

texts:
I am aware that you can export financial data from CiviCRM as an IIF or CSV file.  Can this data be imported into Sage accounts software?

Does anyone have any experience of this?


texts: How do I control the imported user role when using CiviCRM WordPress Member Sync?

texts:
I'm working on an inherited CiviCRM/WordPress site using the CiviCRM WordPress Member Sync https://wordpress.org/plugins/civicrm-wp-member-sync/ and the Members plugin https://wordpress.org/plugins/members/ and I can't find an answer to the question below in any docs.

In the past, someone used the Manual Synchronize feature of Member Sync to manually sync all CiviCRM members to WordPress, but all users were Administrators. After a reinstall of CiviCRM, an import of a CiviCRM database, and deleting all the old WordPress Administrators, I now need to manually sync the users again. But of course I don't want them synced as administrators; I need them synced as lower level roles in order to restrict access to page content and of course not give admin privledges.

How do I control the user role that the CiviCRM users are synced as WordPress users? I'm using the "Role" Synchronization Method.

Is this controlled by Association Rules? I need to add a rule for each CiviCRM membership level?

Will the "New User Default Role" in WordPress>General Settings override synced users Association Rules?

Do I need to use https://wordpress.org/plugins/groups/ ?


texts: Action "send mail" not available for new contact

texts:
Activity type id=8 (send mail) is shown for all contacts.
We made a new contact today, and "send mail" did not shown up in the activity drop down.

We don't have any idea where to look first, because the list of activity types is ok, and the new contact has the same subtype as all the others.


texts: What are the security considerations before allowing access AJAX API to anonymous users?

texts: We have an autocomplete-select list in one of our profiles that we want to use on a public page. I can see the call is blocked for anonymous users because of permissions on 'access AJAX API'. I'm trying and have failed to find further documentation on any security considerations before allowing allowing access AJAX API to anonymous users. If we enable this are there features in CiviCRM that would prevent an anonymous user from using the AJAX API maliciously?


texts:
I was wondering how would you configure CiviCase to link with CiviAccounts.

So for instance: you set up a new case to process a member's expense for train tickets. Can you link that from the case management to the accounts? So that you can keep a log of their interactions and processes, including finances.


texts: Dashboard Issue after attempted Installation on Wordpress 4.5

texts:
Attempting to install CiviCRM 4.7.6 on WP 4.5. Plugin activates fine. All checks on Installation screen are fine/OK.

On finish, there was a note about "Cron not running", but no error that was obvious.

The civicrm.settings.php file is not present in the installation.

When I click on CiviCRM to view the dashboard - It opens, but does not display the dashboard and no menu. None of the links go anywhere.

Any help is appreciated!

Near the bottom is an error message:
Powered by CiviCRM 4.7.6. System Status: Error
The Error link is a dead end/circular to the same page.


texts: How can I update a credit/debit card number, card billing address, or card expiration date to continue transaction processing - on Authorize.net

texts:
We're on CiviCRM 4.6.19, Drupal 7.50 and using Authorize.net for payment processing.

When a credit/debit card number, card billing address, or card expiration date has changed, should simply updating the subscription with the new card info in Authorize for an ongoing monthly sustainer continue the processing uninterrupted, on the same date?

UPDATE for clarification - The monthly/recurring amount will remain the same. The goal is to resume the same monthly/recurring contribution in the same amount by fixing an error with processing by updating the "subscription" in Authorize with the new card number, billing address and/or expiration date.


texts: civicrm/upgrade?reset=1 to 5.3.1 from 4.7.30

texts:
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
Your database is marked with an unexpected version number: 5.2.2. The automated upgrade to version 4.7.30 can not be run - and the 4.7.30 codebase may not be compatible with your database state. You will need to determine the correct version corresponding to your current database state. You may want to revert to the codebase you were using prior to beginning this upgrade until you resolve this problem.


texts:
how can I access the values in a nested array, e.g. when using get for contact entity
e.g. how can I adjust the following to get the first name? (not working for me at the moment)

$result = civicrm_api3('Contact', 'get', array(
   'sequential' => 1,
   'return' => array("first_name", "last_name", "email"),
   'id' => 28296
));
echo $result['values'][0]['first_name'];

if I use var_dump ($result) I get the following so the results are there:

array(5) { ["is_error"]=> int(0) ["version"]=> int(3) ["count"]=> int(1) ["id"]=> int(28296) ["values"]=> array(1) { [0]=> array(6) { ["contact_id"]=> string(5) "28296" ["first_name"]=> string(8) "Thirteen" ["last_name"]=> string(4) "Test" ["email_id"]=> string(5) "27750" ["email"]=> string(25) "thirteen.test@artigma.com" ["id"]=> string(5) "28296" } } }

thanks much!


texts: When exporting contacts using custom selected fields, results in "Undefined Index ...Mapping.php Line 622"

texts:
When trying to export a list of Contacts selecting a previously defined set of Export Fields, system throws this error:"Notice: Undefined index: in /home/.../Core/BAO/Mapping.php on line 622"

When exporting using primary fields, the export is successful.

What is the issue with Mapping.php?


texts:
I have configured mail-to-activity but when I run the task to fetch mails, I get an error message in job's log (without any details) and this kind of message in IMAP server log:

Oct  8 14:00:01 bazylia dovecot: imap-login: Aborted login (no auth attempts in 0 secs): user=<>, rip=10.117.113.20, lip=10.117.113.5, TLS, session=<OrpYmpYhbQAKdXEU>

This mail is 'kontakt@mydmain.com'.
I have set user name ('kontakt') and password and obviously CiviCRM can connect to IMAP server.
How can I debug this?


texts:
The 'Event Summary' part in the Events Dashboard has a very useful view of a participant status count per event, but it only shows a few events.
How can I customize it to show ALL events in the current year?

The 'Manage Events' page does not have this option to see how many people are in what status, per event.


texts: Need to add Contribution page for "in kind" donations with image upload

texts:
I am using CiviCRM 4.7 in Wordpress.
I have taken on a new project for a local charity, what they want is to have a donation page set up for furniture, clothing ect. They have plans of doing several other things as well and CiviCRM is a perfect fit, except I cannot for the life of me figure out how to create a custom contribution page with an image upload field. Any help would be appreciated.


texts: Is there a way to accept inbound SMS from contacts not in your database?

texts:
I have a client who has a service they'd like to merge into CiviSMS.  Strangers (i.e. not in the database) can send a text with a keyword; ideally it should create a contact with their phone number.  Using reports/Views, staff will review new incoming messages and respond to the contacts accordingly.

Is that possible with CiviSMS?


texts: How can I show only Cases that have no Case Manager?

texts:
I asked a similar question recently, but I wanted an answer specifically for Drupal Views. I'm broadening my scope now.

I thought I had an answer to my question via Case Reports. I can show only those cases without managers by implementing the "Case Role(s)" filter and setting it to "Is not one of" "Case Manager". This gives me the results I expect. However, I can't actually navigate to individual cases from the report. Instead when I click on the case subject, a modal window pops up that shows very little information about the case.

I would like to have a list of cases without managers with links to manage the case.

I'd prefer a built-in civi solution, but I'm fair with PHP and not averse to some custom coding if need be.


texts: Is Civicrm 4.7.20 compatible with PHP 7.? - only using core components and one extension, cividiscount

texts: I set up our website using Civicrm 4.7.20, MySQL 5.0.11, PHP 5.6 and Apache 2.4 some time ago; I will update (soon ISA) but want to know whether I can activate php 7 now?


texts: Adjusting the Contact selection display (e.g. New Contribution)

texts:
When adding a new contribution (as well as a few other places, I believe) we have the option to auto-complete a contact's name or create a new contact:

When we begin typing, a list of contacts appears, including email addresses if they have one:

Is there a way we can adjust this display to show different/additional information? For example, we may want to show city in small writing like the email address currently shows:

Adams, Daren
darena55@hotmail.co.in (Bangalore)


texts: There is an upgrade error from v4.5.8 to v4.6.11. Even i tried to upgrade to v4.6.0, it fails. Please suggest an solution how to fix it. I upgrade the existing database from v4.5.5 to 4.5.8 which is running without errors.


texts: Trouble getting Activity Information with api

texts:
I'm trying to get Activity information via the API, but have run into two issues:

I cannot seem to filter by a date stored in a custom field. I've tried formatting the date multiple ways ('Y-m-d', 'm-d-Y', 'YmdHis', etc), but it doesn't seem to have any impact.
Since I can't figure out to make the filter work, I thought I would do the filtering myself. But I can't seem to get the custom field to be returned in the results. When I try in the API Explorer, I get all kinds of data back for each activity. But when I copy / paste the PHP code, I only get a small amount of activity fields, and definitely not the custom field I need.

This is the code from the explorer that isn't working for me when I actually use it in code:

$result = civicrm_api3('Activity', 'get', array(
  'return' => "custom_46",
  'status_id' => "Scheduled",
  'activity_type_id' => "TDY",
));

The Explorer shows all activity data for each result. When running the generated PHP code in my code, I only get the Activity ID, Activity Type ID, Status ID, and Source Contact ID.


texts: Cleaning up images (or other files) in the custom folder

texts:
I'm wondering if anyone else has come up with a good way to manage their custom files (where documents and images which are attachments to contact records are stored.)

We have a fair amount of files in this folder. In addition, some of the contact images have been 'deleted' in Civi (i.e. mistakenly uploaded and replaced with a new image or updated with a newer image.)

Any way to cull through the files and remove files no longer in use?
Or to separate contact record images from pdfs attached to activity records?


texts:
I am trying to set up registration for an event that requires price sets. When I press Price Set I'm unable to add any. Has anyone else experienced this? Is there something I need to do first?

here's all I see:


texts: Why can Search results not be removed from mailing recipients?

texts:
When doing a contact search and using the action "Send email", a new draft mailing is created and a hidden group is assigned as recipients to the draft mailing. It is is displayed as "Search results" and has a different color.

If I click on the cross to remove it from the recipients, I get a message "This mailing was generated based on search results. The search results cannot be removed.". Why is that? I looked at the code where this restriction is enforced, but couldn't see anything that would suggest why search results cannot be deleted.


texts:
Can't seem to find an answer. Exporting PDF and Print reports for event check-in sheet at the front door. Want to either remove the link or the default Last/First name column to stop the 'view' link from appearing.

Howto?


texts: Is anyone using the bootstrap UI css in production in 4.6?

texts: I'm using bootstrap and it's very easy to work with, especially for form data.  I know there is a project, with documentation: http://wiki.civicrm.org/confluence/display/CRMDOC/Bootstrap+UI+for+CiviCRM but wondering if anyone is actually using it?  Also, I'm not sure how this is implemented - is it an extension?


texts: Membership not extended to all related contacts

texts:
Because a membership type was in use, I wasn't able to edit its relationship properties via the CiviCRM GUI. So I did it in MySQL (by editing membership_type_id and membership_direction fields in civicrm_membership_type).

I thought I created all related records the civicrm_membership table (each contact needs their own, even if the membership is inherited), but I must have missed some or encountered a bug because after doing this edit, I had to go through and Edit then Save some membership records in CiviCRM itself to fix them.

However this didn't work for everybody, and records with multiple relationships only passed on memberships to one of the two related records. Again, this may have been the result of an oversight on my part.


texts: Cron Job not working after Joomla 3.8.1 update

texts:
After upgrading Joomla to 3.8.1 the cron job stopped working as reported here. I have applied the update the Joomla.php file as suggested in the answers. This gets rid of the original error. However now I am getting this error:

    PHP Notice:  Constant JPATH_ISWIN already defined in /home/fava/public_html/libraries/import.legacy.php on line 64
    Notice: Constant JPATH_ISWIN already defined in /home/fava/public_html/libraries/import.legacy.php on line 64
    PHP Notice:  Constant JPATH_ISMAC already defined in /home/fava/public_html/libraries/import.legacy.php on line 65
    Notice: Constant JPATH_ISMAC already defined in /home/fava/public_html/libraries/import.legacy.php on line 65
    PHP Notice:  Constant JROUTER_MODE_RAW already defined in /home/fava/public_html/libraries/import.legacy.php on line 72
    Notice: Constant JROUTER_MODE_RAW already defined in /home/fava/public_html/libraries/import.legacy.php on line 72
    PHP Notice:  Constant JROUTER_MODE_SEF already defined in /home/fava/public_html/libraries/import.legacy.php on line 79
    Notice: Constant JROUTER_MODE_SEF already defined in /home/fava/public_html/libraries/import.legacy.php on line 79
    PHP Notice:  Constant JROUTER_MODE_RAW already defined in /home/fava/public_html/libraries/import.php on line 60
    Notice: Constant JROUTER_MODE_RAW already defined in /home/fava/public_html/libraries/import.php on line 60
    PHP Notice:  Constant JROUTER_MODE_SEF already defined in /home/fava/public_html/libraries/import.php on line 67
    Notice: Constant JROUTER_MODE_SEF already defined in /home/fava/public_html/libraries/import.php on line 67
    Error displaying the error page: Application Instantiation Error: Failed to start the session because headers have already been sent by "/home/fava/public_html/libraries/import.legacy.php" at line 64.

I have tried manually clearing the Joomla session table but no luck.
I have also update CiviCRM to 4.7.27 and applied the patches as mentioned here but the same error is still occurring.


texts: continue button missing for free event registration

texts:
If I configure a free event the online registration page has a "continue" button after the registration fields.

However if I have a paid event with a free (ie $0.00) price, when the $0.00 price is selected the payment (paypal) block disappears but no "continue" button displays?

civi 4.7.10
wordpress 4.6


texts: CiviMail - SMTP error when sending test email

texts:
I am running CiviCRM 4.6.8 on Wordpress 4.3.1.
I have configured my hosting providers SMTP details (as provided by them) under outbound email settings and when I click on "Save & Send Test Email", the email is sent successfully.

When I compose a new mailing under Mailing -> New Mailing, and click on the "Send Test" button to send a test email to myself, I get this error:

  Error in call to Mailing_send_test : Failed to set sender:
  b.167.72.4a390771944bc4a6@ [SMTP: Invalid response code received from
  SMTP server while sending email. This is often caused by a
  misconfiguration in Outbound Email settings. Please verify the
  settings at Administer CiviCRM >> Global Settings >> Outbound Email
  (SMTP). (code: 501, response: : domain missing or malformed)]

What is the problem here and how do I resolve it?


texts: How to get my Green Party email address added to the CiviMail from dropdown list

texts:
I am the Membership Secretary for the Croydon and Sutton Local Party. In the past I have been able to send out mailings to our members. However, since the update on civi my Green party email address cannot be manually entered so that I am unable to send out mailings.

How can I rectify this please so that my email can be added to the from section of a  mailing?


texts: Is this scheduled cronjob setup correctly?

texts:
I set up this cronjob. Does this cover whatever I set in the GUI Scheduled Jobs? Or, do I need to set up a cronjob for each? If for each, what is the purpose of this GUI?
As per Scheduled Jobs:

CIVI_ROOT="~/public_html/administrator/components/com_civicrm/civicrm"
PHP=nice -n19 /usr/bin/php
PARAMS= -j -s[domain] -u[user] -p[password] -a execute
*/1 * * * * cd $CIVI_ROOT; $PHP bin/cli.php $PARAMS


texts: How to see "How often do people log in"?

texts:
Is there a way to see in civicrm that How often do people log in or to list the users who logged at least once in last 2 months? I have look advanced search but I couldnt find any criteria for this?

Note: I am using CiviCRM 4.7.12


texts: I am trying to add contact created date in contact summary. I am sure that https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_summary/ helps the requirement. But I'm not getting how to implement this hook.Any help please?


texts: Multiple custom field sets in one contact tab (not the main one)?

texts:
Drupal 7.59, CiviCRM 5.5.1, Shoreditch alpha24.

Within a contact you can display a custom field set as an additional tab (or on main tab). On the main tab you can have groups of fields, including custom ones. Is it possible to organise several custom field sets into an extra tab? Then each set of fields could be collapsible/expandable, neatly organised etc, rather than having a mess of fields in a tab.

Ideally not heavy on coding, not looking to heavily modify CRM at all just hoping there was a simple way I hadn't found. I could achieve with view/profile, but that would need extra work while I currently envisage users using CRM natively.


texts: (Solved) CiviEvent mandatory key missing error

texts:
Drupal 7, Civi 5.12:
On submitting a live event booking I receive the following error:
Mandatory key(s) missing from params array: one of (activity_name, activity_type_id, activity_label)

The booking does update in Civi (both event and contribution) but the confirmation email and invoice do not get sent.

Any ideas please?


texts:
I have drupal running perfectly; with mysql support. But CiviCRM still giving me this error - “MySQL support not included in PHP.”

My PHP version is 5.6.31, as indicated in the screenshot below.


texts:
I'm getting a timeout (504 gateway timeout) when I try and preview a Print/Merge Document with more than 40 contacts in it. First attempt was with a Membership search, but also tried turning that into a group, using a Contact search and removing the membership related tokens - same problem.

Whilst I can't remember the details, I am sure that I have done much larger print/merge documents before (on earlier versions)

Using Civi 5.11.0, WordPress 5.2.2


texts: CKEditor with well-formatted html source code

texts: In my 4.7.24 as well as the demo site, CKEditor doesn't attractively format the source code. No indents or spaces. It's very hard to read.


texts: Can all related contacts be notified about upcoming membership renewals?

texts:
We have an uncommon relationship between association managers and my client's member organizations. Since there may be multiple contacts in an association management firm and there may be significant turnover, my client wants to send membership renewal information, including invoices to all the related contacts for each organization (all the members are organizational entities).

Is there a straightforward way to accomplish this? In most cases, the only contacts we have on file are the association managers, instead of a central email for the association.


texts: Fixing the CiviCRM db when someone deleted "phone" from system dropdown menu options

texts:
Got a problem with how someone (I suspect) has gone in to CiviCRM » Administer CiviCRM » Option Groups » Phone Type Options and thought "hey, we don't need a dropdown item of "phone" because that's kinda dumb" and summarily deleted it.

Now all the phone numbers whose type is set to "phone" (landline) are missing that part of the designation when it comes to displaying a contact record as this phone number type is essentially un-hooked (no pun intended) or disconnected (okay, couldn't resist that time).  Also, you can't designate it in new/updating phone numbers in the records as the drop-down phone type is no longer available.

A separate (technically savvy this time) staffer thought it would help if he added "phone" in as an option (without taking a briefing from me on the issue) which now has ID #7 associated with it and still hasn't restored the effectively lost data in the slightest.

This, as I suspected, requires a deep dive in to the database to fix the damage and restore the phone type options and values.  I've had a look and discovered that phone_type_id is the item we are looking for and that the phone (landlines) were using a value of 1.  I can find where there are tables such as civicrm_option_group and civicrm_option_values but my greater sense is that I'm more likely to bollox something at this stage as I really know little of how the database is organised and what everything really means.

Does anyone have some handy instructions to effectively restore the 'phone type options' data to what they originally were?  Much appreciated.

Yes, we have backups but it was about a week before the issue was discovered and other updating and transaction work has happened in the interim.


texts:
I know civiCRM allows invoice prefixes. This is very helpful in distinguishing civiCRM payments in our merchant account from other software systems (like our ecommerce store).

However, is it possible to have multiple invoice prefixes? We use civiCRM for both our donations/contributions and our event registrations. Is it possible to have a separate invoice prefix for our donations and for our events so that we can distinguish between the two in our merchant account reports? This would be simply for accounting purposes.

The only way around this that I can think of is to host two civiCRMs, one for events and one for contributions; however that would really bog down our server, and I'd rather not do that.

Thanks.


texts: Manage members of the OG_Sync Access Control Group

texts:
We are using Drupal Organic Groups, and the OG_Sync function that ships with CiviCRM Core to create corresponding CiviCRM Groups.  We are converting from an existing system where all editing is carried out by a central team (not using OG) to an OG-based system with distributed editors, and need to manage the transition, possibly over a considerable period.  We would like to be able to:

Disassociate the OG GroupManager role from the Author of the Group page (currently the Author is automatically the GroupManager).
OR ignore the GroupManager Role and set up another OG Role which has the same privileges (in particular to use CiviCRM Email to Group members), and is automatically sync'ed with the CiviCRM Access Control Group for that purpose - in the same way that Group Manager is at present.
Allow for more than one User/Contact to be automatically sync'ed with the Access Control Group - probably falls out of item 2.

Can anyone suggest a way forward on this?

With thanks, Tony


texts: Membership renewal receipt template not showing membership start- and end dates

texts:
In the membership renewal (online) receipt template, it says, here,

https://github.com/civicrm/civicrm-core/blob/master/xml/templates/message_templates/membership_online_receipt_text.tpl#L68

{foreach from=$value item=line}
   [....]
   {$line.start_date|string_format:"%20s"}
   {$line.end_date|string_format:"%20s"}
{/foreach}

That just prints blanks in all my renewals:

===========================================================
Membership Fee
===========================================================
Item                                  Fee  Membership Start Date  Membership End Date
--------------------------------------------------------------------------------------------------

 - Test X Membership...        $220.00 USD

--------------------------------------------------------------------------------------------------

Same for the HTML and PDF versions.

Membership signup receipts work fine, but they use

https://github.com/civicrm/civicrm-core/blob/master/xml/templates/message_templates/membership_online_receipt_text.tpl#L18

{if $mem_start_date}{ts}Membership Start Date{/ts}: {$mem_start_date|crmDate}

Does anyone else have this problem ? What could it be ?


texts: Has anyone mapped the CiviCRM Schema to Classes in SQLAlchemy?

texts: I would like to use Python and SQLalchemy to construct queries and create reports for Civicrm. Has anyone mapped the Classes and Relationships in order to use the ORM capabilities of SQLAlchemy?


texts: linking email subsciptions to WordPress blogs to CiviCRM

texts:
I am adding a blog to the WordPress site on which I am running CiviCRM. I want to include an email subscription to the blog. Ideally I'd like to link this subscription to the CiviCRM contact (for example: so that I can send subscribers extra emails or that I can send invitations to the blog to non subscribing members)

I have found a couple of solutions to the blog subscription (JetPack and Mailchimp) but neither link with the WordPress users or CiviCRM contacts.

I may well be able to use the Mailchimp CivCRM Integration plugin to link it all up, but I'd still rather avoid using Mailchimp because of the cost if the blog really takes off and I don't need any of the other functionality.

How to automatically create mailings from an RSS feed looks to have some of the functionality, but would still need development beyond my capabilities and I'm not sure its active.

Has anyone found any good solutions to this?


texts: After moving site to localhost links no longer work with clean urls enabled

texts:
CiviCRM 4.7.7 and Drupal 7.43 installation on MAMP stack on Mac. I downloaded the files and database from a live site to verify that the backup worked. The home page comes up fine but clicking on any links brings up a generic MAMP page:

When I turn off clean urls the links work properly. The links on the live site work fine with clean urls enabled.


texts: Print/Merge document .docx format download not working with sample civimail newsletter template

texts: The docx format and odt format are not working or showing blank document when a complex tempate or the default template is chosed "Sample Civimail newsletter template" itself is not working.