This would appear on the Individual contact page, in the same area as Hebrew birthday,

Mourner Gender criteria not returning results when the Yahrzeit Search is run.

Selection criteria:
Group=Active Yahrzeits
Mourner Gender Male

(tried Female also and same result)
Returns no records.

Setup includes mourners with gender set to Male or Female.

Not sure if this already exists, But is there a token to include the Hebrew name of a deceased and father's Hebrew name in an email or document?

Hi Sarah,
Have 4.6.9 CiviCRM. Tried to install V2.2 of hebrewcalendarhelper extension and I get the following error 'parent_id is not a valid integer'.

hebrewhelperinstall.txt

Any ideas please?
Thanks Garry

For email reminders to be sent directly to the email address of the mourner

The enhancement for email reminders is complete. The documentation is at: https://github.com/sgladstone/com.fountaintribe.hebrewcalendarhelper/wiki/Automated--reminders

For PDF/hard-copy reminders, the PDFs will be emailed to a staff member/volunteer

https://github.com/sgladstone/com.fountaintribe.hebrewcalendarhelper/wiki/Automated--reminders

There will be a CiviCRM scheduled job set to run daily. The daily scheduled job will have 3 required parameters: "group_names", "message_template_name", "email_address"

To have hard-copy reminders go out 15 days in advance: the job parameters would be:
group_names=mourners of a yahrzeit in 15 days
message_template=15 day yahrzeit message
staff_contact=CiviCRM contact id of "[email protected]"

If there are 25 people observing a yahrzeit in exactly 15 days, then "[email protected]" will get an email with 1 PDF, containing the reminder letters for all 25 mourners. In a larger organization, "[email protected]" will likely get an email daily, each with one PDF attached. They could print and mail things immediately upon receiving the email, or they could wait a few days and print and mail a bunch. In a smaller organization, "[email protected]" would get an email with a PDF attachment infrequently, as many days there are no yahrzeits at all.

The assumption with the PDF, is that a staff member/volunteer would print the PDF and put the letters into envelopes.

Just noticed that the calculation appears to be incorrect.
Here the example i have noticed it for
Contact gender: Female
Date of birth: 19th January 2006
Hebrew date of birth: 19 Tevet 5766
Next Hebrew Birthday: January 5, 2018
Earliest Possible Bar/Bat Mitzvah Date (Starts at sunset on this date): December 26, 2018

Therefore when i Calculate the Hebrew bat mitzvah date back i get 19 Tevet 5779 so 13 years old.
Is there something i have configured incorrectly or is this field calculated as 13 years for both males and females

Calculate job will not run using cron. Works fine when run manually.

https://wiki.civicrm.org/confluence/display/CRMDOC/Managing+Scheduled+Jobs#ManagingScheduledJobs-URLmethod

states "Specific Job via URL works only for API entity = job

Note that you can execute API actions only from the API entity "job"; this is hard-coded into cron.php. So you can't call any of the built in API functions (other than those under entity "job") using cron.php, but you also can't create a new API action So for instance, if you create new API entity called "myapi" with API action "my action" then you would be able to call that action via the Scheduled Jobs page but you will not be able to call it via cron.php. "

A possible workaround for this problem is here: http://forum.civicrm.org/index.php/topic,28215.0.html
I tried this but still got the following error:
Fatal error: Call to a member function saveLastRun() on null in /home/cremorne/www/www/prodwp/wp-content/plugins/civicrm/civicrm/CRM/Core/JobManager.php on line 122

Any thoughts here on this one please?

Dates that fall in Adar are set as Adar II even if that year was not a leap year.
For example try converting March 5, 2020 and it will convert it to 9 Adar II even though this year is not a leap year.

Tokens that are set to only print Yahrtzeit "in x days" are not respecting the "in x days" filter and the token prints information from every available Yahrzeit relationship.
I tested on Civi 5.0.1 and 5.3.1

Multiple (same) records returned when yahrzeit date range used.

Selection criteria:
Group=Active Yahrzeits
Date From 1/9/2016
...Through 31/08/2017

Returns multiple records for the same mourner/deceased combination due to hebrew date falling on different English months in different years.

Mutiple same records issue.pdf

Could a search perhaps by hebrew date be done so the multiple record situation does not occur?

FYI:Workaround to produce current year's yahrzeit list for High Holidays is on export of the data based on the search criteria above is to manually remove the multiple records in a spreadsheet and then print the list.

With Yahrtzeit there is an option to have Yahrtzeit begins on evening of ... and is on morning of ...
Would be nice to have the same options for birthdays.

Shabbat Before yahrzeit not displayed due to Festival of Pesach.

Have been updating our records and found that the 'shabbat before the yahrzeit date' was empty for the yahrzeit date of 20th Nisan 5777 (Sunday 16th April 2017). The 'shabbat after yahrzeit contains the correct value.

I am assuming this is a hebcal issue but it would be great if we could cater for this somehow and put in e.g. Pesach 5 CH"M for Sat 15th April 2017 (19 Nisan 5777). This logic would need to apply for other festivals which fall on the shabbat during the year too.

PHP Interpreter was set to version 7.1 from 5.6

Fatal error: Uncaught Error: Call to undefined function split() in /home/cremorne/www/www/devwp2/wp-content/xxcustom/com.fountaintribe.hebrewcalendarhelper-3.2.2/com.fountaintribe.hebrewcalendarhelper-3.2.2/utils/HebrewCalendar.php:4269 Stack trace: #0 /home/cremorne/www/www/devwp2/wp-content/xxcustom/com.fountaintribe.hebrewcalendarhelper-3.2.2/com.fountaintribe.hebrewcalendarhelper-3.2.2/utils/HebrewCalendar.php(3639): HebrewCalendar->util_convert2hebrew_date('2018', '8', '2', '1', 'yy') #1 /home/cremorne/www/www/devwp2/wp-content/xxcustom/com.fountaintribe.hebrewcalendarhelper-3.2.2/com.fountaintribe.hebrewcalendarhelper-3.2.2/CRM/Hebrewcalendarhelper/Form/Search/YahrzeitSearch.php(191): HebrewCalendar->util_convert_today2hebrew_date('yy') #2 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/Contact/Form/Search/Custom.php(129): CRM_Hebrewcalendarhelper_Form_Search_YahrzeitSearch->buildForm(Object(CRM_Contact_Form_Search_Custom)) #3 /home/cremorne/www/www/devwp2/wp-content/plugins/civicrm/civicrm/CRM/ in /home/cremorne/www/www/devwp2/wp-content/xxcustom/com.fountaintribe.hebrewcalendarhelper-3.2.2/com.fountaintribe.hebrewcalendarhelper-3.2.2/utils/HebrewCalendar.php on line 4269

Can you help please?
Regards
Garry

enhancement request: add wedding date and wedding date parsha as a token in the religious or hebrew dates region on the contact record. Wedding date may be problematic for those contacts who have married more than once, so how do you store the latest wedding date versus the history.

Hi Sarah,

Fixed...setting was incorrect on the record.

Thanks Garry
.

Some organizations want to configure settings for this extension. Such as "earliest possible bar/bat mitzvah date" could be 13 for everyone ( does not depend on gender), or allow girls to be a bat mitzvah at 12

Currently, the extension is not working with PHP 8.x

As a workaround, you can patch the line 155 in /html/sites/default/files/civicrm/ext/com.fountaintribe.hebrewcalendarhelper/hebrewcalendarhelper.civix.php (replace curly braces {} by [] ).

This would be done automatically, if the extension was regenerate using civix (which only the maintainer can do...).

However, I was not able to test the extension completely to make sure everything still works with PHP 8.x

In HebrewCalendar.php can you add a relationship of 'friend of' as mourners sometimes want their dear friends who has passed on to be called and this is not catered for from what I can see in the code.

Error message:

Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to InnoDB. Using MyISAM tables will result in data integrity issues.

Though this seems to work in many system environments, it better should be solved.

enhancement request: add seating info including seat number, available if it is free or vacant or not available as some contacts pay for it during the year, storage box for men especially to hold tallit, prayer books, section of shul for different seats e.g. fixed seats, removable seats, cloth, padded seats, upstairs, downstairs etc and seat comments which is a free text entry area to record comments related to the seat.
I actually set this up on the contact record for manual entry and called the region Seating Information but never implemented it.
If this data was entered then the next step would be to produce a seating plan or layout if possible and or a listing of seat numbers with the assigned contact's name for printing to place on the foyer wall for High Holidays. Need to sort this by name and / or seat number sequence.

Date icons for user selection missing from Yahrzeit custom search page.

CiviCRM date icons missing from page.docx

Have upgraded development systems recently as follows:
mySQL 5.7.23
PHP 7.1
CiviCRM 5.12.0

After searching data with Yahrzeit Search it fails and shows the error like SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_name.contact_b.mourner_name'

I have used versions as follows :
CiviCRM 5.9
HEBREW CALENDAR 4.0.0
Mysql 5.7.24

Db error on temp table when a yahrzeit date falls in Sh'vat when the Calculate job is run as below:
Quick fix take the apostrophe out of the string so Sh'vat becomes Shvat. This allows the Calculate job to run successfully although it produces on screen:
"5776-2-30: inside verify function :

2/30/5776 Test heb: 2/30/5776

5776-2-30: inside verify function :

2/30/5776 Test heb: 2/30/57761"

Sample Log
Sep 10 20:26:38 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)

[code] => -2
[message] => DB Error: syntax error
[mode] => 16
[debug_info] => INSERT INTO civicrm_fountaintribe_yahrzeits_temp ( mourner_contact_id,
  mourner_name, 
  deceased_contact_id,
  deceased_name, 
  deceased_date, d_before_sunset,
  hebrew_deceased_date, yahrzeit_date ,
  yahrzeit_hebrew_date_format_hebrew, yahrzeit_hebrew_date_format_english,
  yahrzeit_date_display, relationship_name_formatted, yahrzeit_type,
  mourner_observance_preference, plaque_location,
  yahrzeit_erev_shabbat_before, yahrzeit_shabbat_morning_before,
  yahrzeit_erev_shabbat_after , yahrzeit_shabbat_morning_after,
  yahrzeit_date_morning, yahrzeit_relationship_id
  )
        VALUES(2149, 'XXXX' , 2715,
        'XXXX', 
         '1945-2-9' , 'Yes',
        '26 Sh'vat 5705' , '2017-02-21',
        'כו שבט התשעז', '26 Sh\'vat 5777',
        '21 February 2017 starting at sunset ', 'husband', '0',
        '0', 'Unknown or No Plaque',
        '2017-02-17', '2017-02-18', '2017-02-24', '2017-02-25',
        '2017-02-22', '20'  ) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'vat 5705' , '2017-02-21',
        'כו שבט התשעז', '26 Sh\'vat 5777',
        '21' at line 17]

enhancement request: add bar/batmitzvah parsha as a token in the religious or hebrew dates region on the contact record.

Hi Sarah,
Just started the monthly letter production and found that the various Shabbat Parashat values are empty. See the attachment for an example. When I export the data to perform a form letter the shabbat Parashat values are empty too.

Help please.
Regards
Garry

Custom Search not displaying selected field values like Mourner's Name.
V2.7 installed in CiviCRM 4.6.9.
Have setup a 'Yahrzeit observed by' relationship between mourner and deceased and set yahrzeit preference also. Tried both values but no change when Custom Search run.

Result of search is the Mourner's name,Deceased Hebrew Name, Relationship to Mourner and Mourner details (far right of screen) are not displayed.

Created a letter to go out to Yarzeit observers.
Had someone who's month and father passed away in same timeframe of different years.
This year the Mom's fell out in Dec and the Dad's in Jan.
When using the token for month_cur the dad's as well as Mom for next year came up since the mom is in JAN 2023.

Token needs to be fixed.

Hi Sarah,
I am trying to automate the Yahrtzeit reminder and I forgot how to setup the scheduled job.
At the bottom of this page of the wiki: https://github.com/sgladstone/com.fountaintribe.hebrewcalendarhelper/wiki/Automated--reminders

5- Make sure that scheduled job is enabled and matches the screen print below: (use the smart group and template from steps 1 and 2 above)

There is no screen print below. Can you please add it?

Thanks

This is an enhancement request to add related shabbat parsha as a token.
If the yahrzeits dates calculated co-incide with say parsha Eikev then it would be great to have this related shabbat parsha available as a token for either the email or pdf actions from the results of the yahrzeits custom search.

enhancement request: add tribe as a token.
This data could be selected from a list of values namely, Cohen, Levi or Israelite (default value israelite).
To be stored in religious region on contact record

We would like to exclude expired/cancelled members from the Yahrzeit search. Thanks