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 |