Version 2019.02 improves importing recurring events from Excel and CSV files. Support has been added for additional fields that specify when a recurring series should end (by date or number of occurrences) and a recurrence interval, such as every 2 months. The mapping of these fields can be specified when importing.
Supported fields related to recurring events are described below. The newly supported column names and variations are in green. If the file you're importing uses these column names or variations, the mapping will be automatically determined. If you use other column names for these fields, you might need to manually specify the mapping.
Field Name |
Variations |
Description |
Recurrence |
Recurrence Summary, Recurs, Repeat, Repeats |
This field specifies a basic recurrence pattern for the event. The first occurrence of the series is specified by the Start field. Supported values are "Daily", "Weekly", "Monthly", and "Yearly". This field should be blank for events that don't recur.
This field can be used as an alternative to the separate Recurs Daily, Recurs Weekly, Recurs Monthly, and Recurs Yearly fields. |
Recurs Daily |
Daily, Recur Daily |
A flag indicating an event that recurs daily. The first occurrence and day-of-week are determined by the Start field. |
Recurs Weekly |
Weekly, Recur Weekly |
A flag indicating an event that recurs weekly. The first occurrence and day-of-week are determined by the Start field. |
Recurs Monthly |
Monthly, Recur Monthly |
A flag indicating an event that recurs monthly. The first occurrence and day-of-month are determined by the Start field. |
Recurs Yearly |
Yearly, Recur Yearly |
A flag indicating an event that recurs yearly. The first occurrence and day-of-year are determined by the Start field. |
Recurrence End Date |
Recurrence End, Recurrence Stop Date, Recurrence Stop |
The date when the specified recurrence pattern should end. No additional events will occur after the specified date. Leave blank if the event isn't recurring, doesn't have a known ending date, or if a value has been specified in the Number of Occurrences field. |
Number of Occurrences |
Max Occurrences, Maximum Occurrences, Occurrence Count, Recurrence Count, Occurrences |
The maximum number of occurrences of the specified recurring series. Leave blank if the event isn't recurring, doesn't have a known number of occurrences, or if a value has been specified in the Recurrence End Date field. |
Recurrence Interval |
Recur Interval, Repeat Interval, Interval |
A number indicating the interval between occurrences of the specified recurrence pattern. For example, if the recurrence pattern is daily and recurrence interval is set to 4, the recurring event will repeat every 4 days. Leave this number blank if the event isn't recurring or should repeat without an interval. |