Allocation hours import file
When you have numerous daily or interval time-off hours to define, you can import them using a text file.
When you want to create, edit, or delete a few interval hours, you can do it manually.
Import file format
-
Use a column delimiter such as tab, comma, or semicolon.
-
Start each date on a new line.
-
Convert other file formats such as Microsoft Excel to text files before importing them.
-
To import daily allocations, create the text (.txt) file using the following format:
<date> <hours>
Where <date> specifies the month, day, and year in your regional format.
Where <hours> specifies the number of allocated time-off hours.
-
To import interval allocations, create the text (.txt) file using the following format:
<date> <hours> <start time> <end time>
Where <date> specifies the month, day, and year in your regional format.
Where <hours> specifies the allocated time-off.
Where <start time> and <end time> have a 15-minute format (0, 15, 30, 45).
These two times form an inclusive range.
Error handling
-
If there are syntax errors, they are ignored silently (that is, no error messages are displayed).
-
Interval allocations only
-
Duplicate rows are not imported.
-
Intervals not in 15-minutes increments are not imported.
-
The End Time must be larger than the Start Time.
-
Example: Daily allocation hours
The following example use the regional formats for the United States, where the date is in the format mm/dd/yyyy.
|
Date |
Hours |
|---|---|
|
01/10/2003 |
50.5 |
|
01/11/2003 |
55 |
Using German regional format (dd.mm.yyyy), the lines would be:
|
Date |
Hours |
|---|---|
|
10.01.2003 |
50.5 |
|
11.01.2003 |
55 |
Example: Interval allocation hours
This example shows an import file for an entire day.
|
Date |
Hours |
Start Time |
End Time |
|---|---|---|---|
|
11/30/2017 |
0 |
0:00 |
0:30 |
|
11/30/2017 |
1 |
0:30 |
1:00 |
|
11/30/2017 |
2 |
1:00 |
1:30 |
|
11/30/2017 |
0.5 |
1:30 |
2:00 |
|
11/30/2017 |
1.5 |
2:00 |
2:30 |
|
11/30/2017 |
0 |
2:30 |
3:00 |
|
11/30/2017 |
2 |
3:00 |
3:30 |
|
11/30/2017 |
1 |
3:30 |
4:00 |
|
11/30/2017 |
0.5 |
4:00 |
4:30 |
|
11/30/2017 |
0.25 |
4:30 |
5:00 |
|
11/30/2017 |
1 |
5:00 |
5:30 |
|
11/30/2017 |
0 |
5:30 |
6:00 |
|
11/30/2017 |
1 |
6:00 |
6:30 |
|
11/30/2017 |
2 |
6:30 |
7:00 |
|
11/30/2017 |
0.5 |
7:00 |
7:30 |
|
11/30/2017 |
1.5 |
7:30 |
8:00 |
|
11/30/2017 |
0 |
8:00 |
8:30 |
|
11/30/2017 |
2 |
8:30 |
9:00 |
|
11/30/2017 |
1 |
9:00 |
9:30 |
|
11/30/2017 |
0.5 |
9:30 |
10:00 |
|
11/30/2017 |
0.25 |
10:00 |
10:30 |
|
11/30/2017 |
0 |
10:30 |
11:00 |
|
11/30/2017 |
2 |
11:00 |
11:30 |
|
11/30/2017 |
1 |
11:30 |
12:00 |
|
11/30/2017 |
0.5 |
12:00 |
12:30 |
|
11/30/2017 |
0.25 |
12:30 |
13;00 |
|
11/30/2017 |
1 |
13:00 |
13:30 |
|
11/30/2017 |
0 |
13:30 |
14:00 |
|
11/30/2017 |
1 |
14:00 |
14:30 |
|
11/30/2017 |
2 |
14:30 |
15:00 |
|
11/30/2017 |
0.5 |
15:00 |
15:30 |
|
11/30/2017 |
0.25 |
15:30 |
16:00 |
|
11/30/2017 |
1 |
16:00 |
16:30 |
|
11/30/2017 |
0 |
16:30 |
17:00 |
|
11/30/2017 |
1 |
17:00 |
17:30 |
|
11/30/2017 |
2 |
17:30 |
18:00 |
|
11/30/2017 |
0.5 |
18:00 |
18:30 |
|
11/30/2017 |
1.5 |
18:30 |
19:00 |
|
11/30/2017 |
0 |
19:00 |
19:30 |
|
11/30/2017 |
0 |
19:30 |
20:00 |
|
11/30/2017 |
2 |
20:00 |
20:30 |
|
11/30/2017 |
1 |
20:30 |
21:00 |
|
11/30/2017 |
0.5 |
21:00 |
21:30 |
|
11/30/2017 |
0.25 |
21:30 |
22:00 |
|
11/30/2017 |
1 |
22:00 |
22:30 |
|
11/30/2017 |
0 |
22:30 |
23:00 |
|
11/30/2017 |
1 |
23:00 |
23:30 |
|
11/30/2017 |
2 |
23:30 |
24:00 |