Congregation Ohr Torah

Ohr Torah Gabbai Tools

Step 1. Choose one or more EasyShul yahrzeit export file(s) to process:

Go to Yahrzeits module in EasyShul admin interface, use filter if needed, click Select All checkbox, then click Export button and save the exported file. Then choose the saved export file here.

Step 2. Choose Gabbai tool / operation to run:

Validate EasyShul's next yahrzeit date against our own calculation, flag missing information, etc.

Generates a list of yahrzeit announcements formatted for the electronic bulletin board in the lobby.

Typically select a file containing the upcoming week's yahrzeits.

Copy the output and paste it into the electronic board software configuration.

Output:

Generates a CSV file for importing into the OT Gabbai Google Calendar. Each yahrzeit becomes a calendar event on the Shabbat before the yahrzeit date (unless the yahrzeit is "bo bayom" on Shabbat).

Typically select a file containing the upcoming weeks/month yahrzeits.

Instructions for importing the CSV file into Google Calendar can be found here.

Output:

Generates a CSV file of yahrzeits in a calendrical layout, with a column for each month of the year.

Typically select file(s) containing an entire year's (all) yahrzeits, starting from today.

Tip: If sending output to a CSV file, open file in Excel, select columns B-O, set column width to 25, turn on Wrap Text, then save as Excel Workbook .xlsx to retain layout.

Output:

Coming soon if needed. What should it contain?

Step 3.