Project

Profile

Help

Import time entries into Planio via CSV files » History » Sprint/Milestone 2

Gregor Schmidt, 03/13/2018 10:40 AM

1 1 Gregor Schmidt
# Import time entries into Planio via CSV files
2
3
You probably know, that you may book time on issues or projects via [Planio Time Tracking](https://plan.io/time-tracking/). However, if you've decided to track your time outside of Planio, it's also possible to import your time entries from Comma Separated Values (CSV) files using the importer in Planio.
4
5
{{>toc}}
6
7
There are two steps to this process. First, you need to prepare a CSV file for import. Second, you have to carry out the import. We’ll cover both in this guide.
8
9
## Preparing the CSV file
10
11
You need to export your time entries or time bookings in the CSV format. You can save most Excel sheets as CSV files by clicking on **File -\> Save As…** and then selecting **Comma Separated Values** as the format from the drop-down menu.
12
13
Your CSV file can have the following headers. You’ll find a sample CSV file here: attachment:example.csv.
14
15 2 Gregor Schmidt
| Values   | Notes                                                                                                                                                                                                                        |                                                                                                                              |
16
| -------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------- |
17
| Activity | This field is used to determine the kind of activity. This should map to an existing activity and it needs to be enabled within the target project. You’ll find their names in **Project page -\> Settings -\> Activities**. | This field is optional. Alternatively, you may select a fixed activity for all new time entries when configuring the import. |
18
| Issue    | A time entry may belong to a single issue. Fill this column with the issue ID (e.g. `4711`).                                                                                                                                 | This field is optional. If left blank, the time entry will be associated with the overall project.                           |
19
| Date     | Enter the date in your preferred date format (e.g. MM/DD/YYYY or DD.MM.YYYY).                                                                                                                                                | This field is mandatory.                                                                                                     |
20
| Hours    | Enter a number for the spent time in hours (e.g. 15).                                                                                                                                                                        | This field is mandatory.                                                                                                     |
21
| Comment  | Enter a comment describing the work.                                                                                                                                                                                         | This field is optional.                                                                                                      |
22 1 Gregor Schmidt
23
## Importing the CSV File
24
25
Now, you have a CSV file ready for import. The next step is to import it into Planio. You’ll find the button for the Import on the spent time page in the sidebar.
26
27
{{figure(Click on Import in the sidebar on the right)
28
!time-entries-page@2x.png!
29
}}
30
31
Then, select your CSV file using the file picker.
32
33
{{figure(Upload the CSV file using the file picker)
34
!file-selector@2x.png!
35
}}
36
37
On the next page, you can select options for importing the CSV File
38
39
{{figure(Select the options for importing the CSV file based on how your CSV file is formatted)
40
!import-options@2x.png!
41
}}
42
43
| Option          | Notes                                                                                                |
44
| --------------- | ---------------------------------------------------------------------------------------------------- |
45
| Field separator | You can select between comma separated values or semicolon separated values                          |
46
| Field wrapper   | You can select between double quotes or single quotes.                                               |
47
| Encoding        | You can select the encoding for the CSV file                                                         |
48
| Date format     | You can select one of five date formats (YYYY-MM-DD, DD/MM/YYYY, MM/DD/YYY, DD.MM.YYY or DD-MM-YYYY) |
49
50
First you have to select a target project for the import. Then, you have to map the values from the CSV files to time entry fields in Planio. You can select each value from the drop-down menu beside each attribute. You’ll also see a file content preview further down, so you can make sure you’re importing the right data.
51
52
{{figure(Assign each column in the CSV file to a time entry field)
53
!field-mapping@2x.png!
54
}}
55
56
Once you’re done assigning the values to each field, you can click on import to start the import.
57
58
If you encounter any problems, you'll see a page with the errors and the import will not be carried out. You can restart the import once you've fixed the problems in the CSV file.
59
60
{{figure(A list of the errors encountered during the import)
61
!import-error@2x.png!
62
}}
63
64
If all goes well, you’ll see a list of the imported time entries.
65
66
{{figure(You'll see a list of the created time entries.)
67
!successful-import@2x.png!
68
}}
69
70
That's how you can import time entries or time bookings into Planio using the CSV importer.