 |
 Chinese Computing Help Desk |
Custom Search
|
|
|
| Home / What's New » Downloads » Chinese festivals calendar for Outlook |
Download Chinese Festivals for your
|
|||||||||||||||
| Buddha's Birthday / Fozu Danchen | Ghost Festival / Zhongyuan Jie |
| Chinese New Year / Guo Nian | Laba Festival / Laba Jie |
| Confucius' Birthday / Kongzi Danchen | Lantern Festival / Yuanxiao Jie |
| Double Ninth / Chongyang Jie | Matsu/Mazu/Tin Hau/A-Ma Festival |
| Double Seventh / Qixi Jie | Mid-Autumn Festival / Zhongqiu Jie |
| Dragon Boat Festival / Duanwu Jie | Qingming Jie / Tomb Sweeping Day |
| Winter Solstice / Dongzhi | |
These festivals are not the same as official government holidays, although there is some overlap. This calendar shows Confucius' Birthday on the traditional lunar dates as celebrated in Hong Kong and Macau, not on the Western calendar date of September 28th as officially celebrated in Taiwan (and under consideration in the mainland) as Teachers' Day. The Mazu Festival is mostly popular in the south, and the Laba Festival is more of a northern tradition. There are many other traditional festivals confined to smaller areas, and I encourage you add and edit as you wish using Excel. Editing instructions are below.
Did You Know?
Outlook Already Includes Many International Holidays
Government holidays for Hong Kong and many other locations are hiding in a dialog box within Outlook 2003, 2007 and 2010, just waiting to be added:
- In Outlook, open the Tools menu, click "Options",
- In the Preferences tab, under "Calendar", click the "Calendar Options..." button,
- In the Calendar Options window, under "Calendar Options", click the "Add Holidays" button,
- Select Hong Kong or other locations. (NOTE: if you uncheck anything those holidays may be uninstalled, so leave your home country checked ...or "ticked" as they say in HK and the UK.)
The Hong Kong calendar will also include official government holidays like Christmas and July 1st (Hong Kong SAR Establishment Day) in addition to most Chinese traditional festivals. Be certain this is what you want.
How to Edit Before Installation
If you want to make any changes to my file, please do so before importing. (Remember to save it again as a .csv file, not a spreadsheet.) After importing, you can remove these using my instructions below but it is tedious.
For locations/holidays not included in Outlook or in my download file, you can build your own import file using my file as a template.
Other examples of changes you can make in the file:
- Turn on Reminders (set "Reminder on/off" to "TRUE").
- Change the date format if your PC does not use the US or EU locales I offer, so that the file will import correctly.
- Change Mandarin to Cantonese (like translating Chongyang Jie to "Chung Yeung").
- Some may not be interested in the Mazu Festival, which is mainly celebrated in Taiwan, Macao and other southern coastal communities.
- Buddha's Birthday, the Laba Festival, and the lunar date of Confucius' Birthday are also more regional.
- You can also add more local festivals like the Monkey God Festival.
I have tested this file with Outlook 2002, 2003, 2007 and 2010. Installation is a simple process, using "Import and Export..." on the File menu. For your convenience every step is illustrated below.
Note: if your PC is not set for the US or UK date formats I have used in these files (see the "Downloads" links above), please open the file in Excel and format the date cells with your locale. Then re-save as a CSV file.
1) On the File menu, select "Import and Export...":
2) Select "Import from another program or file" and click "Next":
3) Select "Comma Separated Values (Windows)" and click "Next":
4) Click the "Browse..." button:
5) Navigate to the .csv file and click "OK":
6) Consider changing the "Options" if you have previously imported the this file or if you already have events with the same details. Then click "Next":
7) Select "Calendar" and click "OK":
8) The file should appear in the next dialog with a checkmark next to it. If there is no checkmark, click "Change Destination..." or the "Back" button to determine if you have made any mistakes in previous steps; or if you made any changes to the file it may contain errors. You should not have to click "Map Custom Fields". If everything looks OK, click "Finish".
9) You should see this progress indicator:
10) Sample of an imported event opened from the Calendar:
How to Remove After Installation
To remove any holiday from this file after import, you must sort the calendar as a list to find them as a group. These are not "Recurring" Outlook events, because lunar calendar dates do not fall on the same days each solar year. Here is how to remove them:
In Outlook 2002 or 2003, View > Arrange By > Current View > Events, sort by subject, then select and delete in groups.
In Outlook 2007, View > Current View > Events, sort by subject, then select and delete in groups.
In Outlook 210, View > Change View > List, sort by subject, then select and delete in groups.
To get back to your old view, go back to Current View and select Calendar Day/Week/Month.
I've imported this into Outlook 2002, 2003, 2007 and 2010, and I have synchronized with Palm, Blackberry and Android devices with good results, but please feel free to help test, improve, correct, criticize and suggest anytime.
Return to downloads introduction/overview
Try this download too: MS Word Pinyin macro
