Importer (CSV a JSON)

Umožňuje importovat soubory CSV prostřednictvím správy.

Kevin Papst
Nabízí
Kevin Papst

You can import the following CSV data:

  • Timesheet
  • Clockify (Timesheet)
  • Toggl Track (Timesheet)
  • Project
  • Customer
  • Grandtotal (Customer)
  • Kimai v1

Supported formats: CSV and JSON

Instalace

Kopírovat soubory

Extract the ZIP file and upload the included directory and all files to your Kimai installation to the new directory:

var/plugins/ImportBundle/

The file structure needs to look like this afterwards:

var/plugins/
├── ImportBundle
│   ├── ImportBundle.php
|   └ ... more files and directories follow here ...

Vymazat mezipaměť

After uploading the files, Kimai needs to know about the new plugin. It will be found once the cache was re-built. Call these commands from the Kimai directory:

How to reload Kimai cache

bin/console kimai:reload --env=prod

It is not advised, but in case the above command fails you could try:

rm -r var/cache/prod/*

You might have to set file permissions afterwards:

Adjust file permission

You have to allow PHP (your webserver process) to write to var/ and it subdirectories.

Here is an example for Debian/Ubuntu, to be executed inside the Kimai directory:

chown -R :www-data .
chmod -R g+r .
chmod -R g+rw var/

You might not need these commands in a shared-hosting environment. And you probably need to prefix them with sudo and/or the group might be called different from www-data.

Aktualizace

Updating the plugin works exactly like the installation:

  • Delete the directory var/plugins/ImportBundle/
  • Execute all installation steps again:
    • Kopírovat soubory
    • Vymazat mezipaměť

Seznam změn

Version 2.15.0

Compatibility: requires minimum Kimai 2.21.0

  • Refactoring: Use attributes for importer service injection
  • Refactoring: Use new repository and query methods
  • Refactoring: Activate PHPStan bleeding edge rules

Version 2.14.0

Compatibility: requires minimum Kimai 2.17.0

  • Allow 4MB upload file size and 5000 rows per file
  • Deactivate timesheet validators during Kimai1 import: TimesheetLockdown, TimesheetLongRunning, TimesheetZeroDuration

Version 2.13.0

Compatibility: requires minimum Kimai 2.17.0

  • Support importing seconds
  • Fixed Clockify duration import rounding issue (see #4838)
  • Added quick links from Customer and Project listing

Version 2.12.0

Compatibility: requires minimum Kimai 2.11.0

  • Added: toggl timesheet importer
  • Added: format a few value types in preview
  • Added: internal API improvements
  • Fixed: user column name detection in timesheet importer
  • Fixed: removed translated column header detection in timesheet importer (caused too many problems)

Version 2.11.0

Compatibility: requires minimum Kimai 2.11.0

  • Added: Validate Hourly/Internal/Fixed rate
  • Changed: Translate detected column headers

Version 2.10.0

Compatibility: requires minimum Kimai 2.11.0

  • Simplify timesheet example data to prevent confusion
  • Fix Doctrine deprecations

Version 2.9.0

Compatibility: requires minimum Kimai 2.5.0

  • Fixed: timesheet importer created project multiple times (if it existed under the same name multiple times)
  • Change: import route annotation from correct namespace

Version 2.8.0

Compatibility: requires minimum Kimai 2.5.0

  • Added: new created users during import require to change password
  • Changed: Improved error message upon wrong mimetype

Version 2.7.0

Compatibility: requires minimum Kimai 2.5.0

  • Changed: moved some translations to core, allowing more languages
  • Fixed: column “Rate” is not required for timesheets

Version 2.6.0

Compatibility: requires minimum Kimai 2.4.0

  • Improved importing visible flags for customers and projects
  • Support Kimai Export CSV for import
  • Improve user mapping (and support setting the Alias during import)
  • Added logging for simpler debugging

Version 2.5.1

Compatibility: requires minimum Kimai 2.1.0

Fixed: Column “Billable” is not correctly imported

Version 2.5.0

Compatibility: requires minimum Kimai 2.1.0

Use annotation type for routes

Version 2.4.0

Compatibility: requires minimum Kimai 2.0.30

Added: skip some validations during timesheet import

Demo

Tento plugin můžete otestovat na demo.kimai.org:

Uživatelské jméno: susan_super
Heslo: password

Více testovacích účtů naleznete zde.

Nabízí

Kevin Papst

Building Kimai since 2009

V případě dotazů se obraťte přímo na vývojáře pomocí těchto kontaktních údajů.
Top