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

Browser not supported