Importing time logs from CSV

EP Help General > Time Logs
 

pencil

This feature is not available for guest users.

 

You can have time logs stored as a CSV file imported to Easy Projects using a wizard.

 

pencil

To be imported to Easy Projects, a CSV file should have values in their respective places and separated by a list separator (default is a comma). An example of CSV file fields:

 

1.

Entry Date

 

2.

Duration

 

3.

Description

 

4.

Billable

 

pencil

A portion of a source CSV file might look like this:

<<

Entry Date,Duration,Description,Billable

5/19/2010,3,Test TimeEntry 01,true

5/20/2010,4,Test TimeEntry 02,true

5/20/2010,5,Test TimeEntry 03,false

>>

 

As you can see, the first line contains the names of fields the values correspond to. Whilst it is useful for some purposes, it may wreak havoc during import. For this reason, you will have the option to skip the first line while importing data from a CSV file.

 

 

To import an activity, follow these steps:

 

1.

Go to Tools | Import | Time logs.

2.

From a drop-down list in the User field, select the user you wish to import the time logs to.

2.

From a drop-down list in the Project field, select the project you wish to import the time  logs to.

3.

From a drop-down list in the Activity field, select the activity you wish to import the time  logs to.

3.

Once in the Import time logs screen, click on "Choose file", and find the source CSV file.

4.

Select a list separator.

5.

Select the Skip first line of the file checkbox (refer to the second pencil above) if required.

6.

Click 'Next'.

7.

Perform field mapping, i.e. link fields of time logs being imported with EP ones. Use 'Add fields' to get new fields to map.

8.

Click 'Import'.

 

 

You will get a message ‘Import completed. X records were imported successfully.’ if import has been successful.

 

 

Related topics: