Importing data

Importing data Feature added with v 1.6

Importing from Kimai v1
Importing projects
- All options
Importing timesheets
- All options
- Example
Links

Importing from Kimai v1

There is a dedicated chapter about migrating data from Kimai v1.

Importing projects

This will import projects and create missing customers on the fly.

An empty team (with the projects name) can be created for each project, therefor the teamlead options needs to be set. These teams will be assigned to the projects, but not to the customers.

bin/console kimai:import:customer --teamlead=anna_admin --delimiter=";" --comment="" ~/Downloads/import-customers.csv

All options

You can see all option by calling bin/console kimai:import:customer --help which will show:

Description:
  Import projects from CSV file

Usage:
  kimai:import:customer [options] [--] <file>

Arguments:
  file                         The CSV file to be imported

Options:
      --teamlead=TEAMLEAD      If you want to create empty teams for each project, give the username of the teamlead to be assigned
      --delimiter[=DELIMITER]  The CSV field delimiter [default: ","]
      --comment[=COMMENT]      A description to be added to created customers and projects. %s will be replaced with the current datetime [default: "Imported at %s"]

Help:
  This command allows to import projects from a CSV file, creating customers (if not existing) and optional empty teams for each project.
  Imported customer will be matched by name and optionally created on the fly.
  Required column names: Name, Customer
  Supported column names: Name, Customer, Comment, OrderNumber, OrderDate

Minimum content for a CSV file (using the delimiter ;):

Name;Customer
Project name;Customer name

Full content for a CSV file (using default delimiter ,):

Name,Customer,Comment,OrderNumber,OrderDate
Project name,Customer name,a longer comment,1234567890,2019-08-29

Importing timesheets

This will import timesheets and create on the fly:

missing customer
mising projects
missing activities

Users have to be existing before (mainly because the users timezone setting is used to import the timesheets).

bin/console kimai:import:timesheet --timezone=UTC --activity=global --delimiter=";" --customer="Imported customer" ~/Downloads/import-timesheets.csv

All options

You can see all option by calling bin/console kimai:import:timesheet --help which will show:

Description:
  Import timesheets from CSV file

Usage:
  kimai:import:timesheet [options] [--] <file>

Arguments:
  file                         The CSV file to be imported

Options:
      --timezone[=TIMEZONE]    The timezone to be used. Supports: "valid timezone names", the string "user" (using the configured users timezone) and the string "server" (PHP default timezone) [default: "user"]
      --customer[=CUSTOMER]    A customer ID or name to assign for empty entries. Defaults to creating a new customer which is used for all un-linked projects
      --activity[=ACTIVITY]    Whether new activities should be "global" or "project" specific. Allowed values are "global" and "project" [default: "project"]
      --delimiter[=DELIMITER]  The CSV field delimiter [default: ","]
      --begin[=BEGIN]          Default begin if none was provided in the format HH:MM [default: "00:00"]
      --comment[=COMMENT]      A description to be added to created customers, projects and activities. %s will be replaced with the current datetime [default: "Imported at %s"]

Help:
  This command allows to import timesheets from a CSV file, which are formatted like CSV exports.
  Imported customer, projects and activities will be matched by name.
  Supported columns names: Date, From, To, Duration, Rate, User, Customer, Project, Activity, Description, Exported, Tags, Hourly rate, Fixed rate

Example

"Date","From","To","Duration","Rate","User","Customer","Project","Activity","Description","Exported","Tags","Hourly rate","Fixed rate"
"2020-05-04","15:50","17:51","7260","231.92","user@example.com","Customer LLC","My project", "Testing","some work has been done","0","foo,bar","115.00","0"

Date: format Y-m-d
From and To: should be given in 24h format
Duration: in seconds
Rate: A floating number of the records rate (optional, if you don’t set the value it will be calculated)
Hourly Rate: A floating number for the hourly rate (optional, if you don’t set the value it will be calculated)
Fixed Rate: A floating number for the fixed rate of this record (optional, you can skip this column)
Customer, Project and Activity: will be matched by name
User: will be matched by username or email
Exported: can be 0 or 1 (0 = new, 1 = exported)
Tags: comma separated list of tag names

Links

There is also a user contributed plugin for importing CSV data, which can be found here: https://github.com/neontribe/KimaiCvsImportBundle