How do I import repetitions on tasks?
Michael Sahl
Henrik Bjerregaard
It is possible to import up to four repetitions on tasks, when importing tasks using import filters. Just select the appropriate column from your CSV-file in one of the fields named "Repetition".
The repetion should be specified as described below. You should probably always enclose the repetition in quotes " ", as it may contain commas (,) which will otherwise cause problems for the CSV file.
Format
A repetition needs to be specified as follows.
For tasks of the type repeat - exact times, the format is:
<periodname> <perioddetails> <fromtime> <totime> <userinitials> [<daystodeadline> [<nextdate>]] [<parameters>]
You may specify multiple user initials, to plan for multiple users; initials should be seperated by space.
For tasks of the type repeat - loose times, the format is:
<periodname> <perioddetails> <fromtime> <totime> <daystodeadline> [<nextdate>] [<parameters>]
A name in <> simply means that it is a field, it should be replaced with some value. Something in [ ] means that it is optional. There must be at least one space between each field; spaces are not allowed within a field, with the exception of <userinitials> and <parameters> where space seperates the initials/parameters.
Examples
| “Monthly FirstThu 10:00 12:00 HBP MSA” | First Thursday in each month; 10:00 to 12:00; for users HBP and MSA |
| “OddMonths 20 20:00 23:00 HBP SC” | Odd months on the 20th at 20:00 to 23:00 for users HBP and SC |
| “EvenMonths LastDay 20:00 23:00 HBP SC” | The last day of every even months from 20:00 to 23:00 for users HBP and SC |
| “MonthsJanAprJulOct 1 12:00 15:00 AB” | Every January, April, July and October 1st from 12:00 to 15:00 for user AB |
| “Annually 3Dec 10:00 11:30 QZ” | Every year on December 3rd from 10:00 to 11:30 for user QZ |
| “OddYears 12Dec 06:15 09:00 CC” | December 12th on odd years from 06:15 to 09:00 for user CC |
| “Daily 12:00 17:00 KL” | Every day from 12:00 to 17:00 for user KL |
| "Weekly Mon 10:00 14:00 KL StartDate=2022-01-01 EndDate=2022-12-31 NeverMonths=MarNov" | Every Monday in 2022, except in March and November |
| "4Weeks Fri 08:00 12:00 SC MS Offset=2022-01-23" | Friday in every 4th week, the week that includes 2022-01-23 is one of those match |
| "4Months Fri 08:00 12:00 SC MS Offset=2022-01-23" | Friday in every 4th month, the month that includes 2022-01-23 is one of those match |
Repeat - loose times
For task of the type repeat - loose times the follow examples also apply.
| “EveryNDays 14 20:00 23:00 -14” | '-14' means: 14 days to deadline |
| “EveryNWeeks 6 20:00 23:00 -14 2022-06-01” | next date is included |
| “EveryNMonths 2 20:00 23:00 -14” |
Period name
This should be one of the following:
| Period name | Description | Period details | Comments |
| Daily | Do it every day | - | The field <perioddetails> must not be included |
| Monthly | Do it on a specific day every month | <monthday> | |
| OddMonths | Do it on a specific day in January, March etc | <monthday> | |
| EvenMonths | Do it on a specific day in February, April etc | <monthday> | |
| Months<monthlist> | Do it on a specific day in the selected months | <monthday> | |
| Annually | Do it on a specific day once a year | <yearday> | |
| OddYears | Do it on a specific day in 2023, 2025 etc | <yearday> | |
| EvenYears | Do it on a specific day in 2022, 2024 etc | <yearday> | |
| Weekly | Do it every week on selected week days | <weekdays> | |
| OddWeeks | Do it in week 1,3,5 etc on selected week days | <weekdays> | |
| EvenWeeks | Do it in week 2,4,6 etc on selected week days | <weekdays> | |
| EveryNDays | Do it with an interval of a fixed number of days | <N> = number of days | Only for repeat - loose times |
| EveryNWeeks | Do it with an interval of a fixed number of weeks | <N> = number of weeks | Only for repeat - loose times |
| EveryNMonths | Do it with an interval of a fixed number of months | <N> = number of months | Only for repeat - loose times |
| StartDate | Do it just once, on a date that depends on the context | - | |
| WeekNos | Do it in selected weeks, on selected week days | <weeklist>,<weekdays> | There are two comma-seperated values in the <perioddetails> field |
| Week<N><I> | Do it in the I'th week of each N-weeks period, on selected week days | <weekdays> | N=3,4,5,6; I=1,2,...N; f.ex. Week42 or Week31 |
| Year<N><I> | Do it on a specified day in the I'th year of each N-year period | <yearday> | N=3,4,5; I=1,2,...N, f.ex. Year33 |
| <N>WeeksPeriodic | Do it every N'th week, on selected week days | <weekdays> | F.ex 60WeeksPeriodic; the Offset parameter specifies when the period starts |
| <N>Days | Do it every N'th day, on selected week days | <weekdays> | The Offset parameter specifies when the period starts |
| <N>Weeks | Do it every N'th week, on selected week days | <weekdays> | The Offset parameter specifies when the period starts |
| <N>Months | Do it every N'th month, on selected week days | <weekdays> | The Offset parameter specifies when the period starts |
| <N>Years | Do it every N'th year, on selected week days | <weekdays | The Offset parameter specifies when the period starts |
Daily, StartDate
The field <perioddetails> should not be included.
Example:
| “Daily 12:00 17:00 HBP SC” | every day from 12:00 to 17:00 |
Monthly, OddMonths, EvenMonths, Months<monthlist>
<perioddetails> then specifies the day of the month, either:
For Months<monthlist> the field <monthlist> is a list of 3-letter month names, eg. JanAprDec.
Examples:
| “Monthly 3 10:00 12:00 HBP MS” | the 3rd in every month |
| “Monthly LastDay 10:00 12:00 HBP MS” | the last day of every month |
| “OddMonths SecondMon 10:00 12:00 HBP MS” | 2nd Monday in odd months |
| “MonthsJanFebApr FirstFri 10:00 12:00 HBP MS” | first Friday in January,February and April |
Annually, OddYears, EvenYears, Year31, Year32, Year33, Year41 - Year44, Year51 - Year55
<perioddetails> then specifies the day of the year as NNXXX where NN is a date and XXX is a month.
2022 is included in Year31, Year42 and Year52, 2023 is included in Year32, Year43 and Year53.
Examples:
| “Annually 20Jan 10:00 12:00 HBP MS” | 20th of January every year |
| “OddYears 5Feb 10:00 12:00 MS HBP” | 5th of Feb. in odd years |
Weekly, OddWeeks, EvenWeeks, Week31, Week32, Week33, Week41 - Week44, Week51 - Week55, Week61 - Week66
<perioddetails> then specifies the weekdays as a list. Week 1 of a year is included in Week31, Week41, Week51 and Week61.
Example:
| “Weekly MonFri 10:00 12:00 HBP MS” | Monday and Friday every week |
WeekNos
<perioddetails> specifies a list of week numbers and a list of week days.
Example:
| "WeekNos 1,2,3,4,SatSun 10:00 12:00 HBP" | Saturday and Sundays in the first 4 weeks of the year |
<N>WeeksPeriodic
<perioddetails> specifies a list of week days
Example:
| "7WeeksPeriodic SatSun 10:00 12:00 HBP SC MS Offset=2022-04-01" | Saturday and Sundays in every 7th week, week 1 is the week containing 2022-04-01 |
<N>Days, <N>Weeks, <N>Months, <N>Years
<perioddetails> specifies a list of week days
Example:
| "6Weeks SatSun 10:00 12:00 HBP SC MS Offset=2022-04-01" | Saturdays and Sundays in every 6th week, week 0 is the week containing 2022-04-01, weeks 0,6,12,etc match |
EveryNDays, EveryNWeeks, EveryNMonths
<perioddetails> is a number of days/weeks/months
This only applies to tasks of type repeat - loose times and also specifies how the task is restarted, by specifying the days to deadline and next date.
Examples:
| "EveryNDays 11 10:00 12:00 HBP SC MS -10 2022-04-01" | Every 11 days |
Field types
Week days are months are specified as the english three letter abbreviations.
| monthday | Specifies a day in a month | See below |
| weekdays | List of week days | F.ex. MonTueWedThuFri or FriSatSun or MonSunHol; Hol means holidays |
| yearday | Specifies a day and month | F.ex. 24Dec or 1Mar or 17Aug |
| weeklist | Comma-seperated list of week numbers | F.ex. 1,2,4,11,42 |
| monthlist | List of months | F.ex. JanFebMar or JunJulAugSep |
monthday
| <N> | the N. day of the month |
| LastDay | the last day of the month |
| LastWorkday | the last workday (Mon - Fri) of the month |
| FirstWorkday | the first workday of the month |
| Last<XXX> | XXX is either Mon or Tue or Wed etc |
| Pneultimate<XXX> | XXX is either Mon or Tue or Wed etc |
| First<XXX> | XXX is either Mon or Tue or Wed etc |
| Second<XXX> | XXX is either Mon or Tue or Wed etc |
| Third<XXX> | XXX is either Mon or Tue or Wed etc |
| Fourth<XXX> | XXX is either Mon or Tue or Wed etc |
Parameters
Various parameters may be added to the end of the repetition; this is necessary as the repetition format cannot hold all the information the various repetition types require.
Each parameter consists of a name, followed by an equal sign (=), followed by a value. No space is allowed within a parameter.
| StartDate | Date | Don't match any date before this date |
| EndDate | Date | Don't match any date after this date |
| Holidays | Either "allow" or "global" or "skip" or "skip-weekend", default is "allow" | How holidays are handled allow: allow the repetition to match holidays global: use a global setting to determine how to handle holidats skip: skip to next workday skip-weekend: skip to next workday or weekend |
| NeverMonths | <monthlist> | A list of month that should never match |
| Offset | Date | Required for <N>Days, <N>Weeks, <N>Months, <N>Years and <N>WeeksPeriodic; specifies a date that indicates when the 0th period is; periods 0, N, N+1, N+2 etc match |
| Locked | Either 0 (not locked) or 1 (locked) | Affects the plannings that are created from the repetition: indicates if the planning should be locked; |
| Warning | Comma seperated list of user initials | Affects the plannings that are created from the repetition: indicates that a warning should sent if the user doesn't check in on the task, and it should also be sent to the list of users |