Kimai
Importör (CSV och JSON)
Möjliggör import av CSV-filer och JSON-data.
Erbjuds av
Kevin Papst
You can import the following data:
- Timesheet
- Clockify (Timesheet)
- Project
- Customer
- Grandtotal (Customer)
- Kimai v1
Supported formats: JSON and CSV
Changelog
## 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 many projects used the same name)
- 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
- Added: support Kimai Export CSV for import
- Added: logging for simpler debugging
- Changed: improved importing visible flags for customers and projects
- Changed: improve user mapping (and support setting the Alias during import)
## 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
- Changed: use annotation type for routes
## Version 2.4.0
Compatibility: requires minimum Kimai 2.0.30
- Added: skip some validations during timesheet import
## Version 2.3.0
Compatibility: requires minimum Kimai 2.0.9
- Added: support for meta-fields via column "meta.XXX" for customers
- Added: support for meta-fields via column "meta.XXX" for projects
- Added: support for column "name" for customer
- Added: support for column "name" for project
- Added: importer highlights invalid column mapping
- Removed: "(plugin)" from permission header
## Version 2.2.3
Compatibility: requires minimum Kimai 2.0.9
- Fixed: System-Menu is not highlighted on tabs
## Version 2.2.2
Compatibility: requires minimum Kimai 2.0.9
- Added: hint for Clockify imports, that rate configurations are not imported
- Added: deactivate certain validation rules in "Import from Kimai v1" command
- Removed: use `Import` validator group
## Version 2.2.1
Compatibility: requires minimum Kimai 2.0.9
- Fixed: detect invalid encoding for fields Activity, Project, Description
- Added: better preview and import result status
## Version 2.2.0
Compatibility: requires minimum Kimai 2.0.9
Better use with Kimai 2.0.15 to utilize new `Import` validator group.
- Added: command option `skip-teams` to prevent team sync
- Added: command option `check-already-imported` to prevent duplicate database entries
- Fixed: `string` vs `int` comparison
- Fixed: `isset` vs `array_key_exists`
- Fixed: `is_int` vs `is_numeric`
## Version 2.1.6
Compatibility: requires minimum Kimai 2.0.9
- Fixed: prevent error if tag name exceeds 500 character
## Version 2.1.5
Compatibility: requires minimum Kimai 2.0.9
- Fixed: duration parsing
## Version 2.1.4
Compatibility: requires minimum Kimai 2.0.9
- Added: identify auto-deactivation during batch imports
## Version 2.1.3
Compatible with Kimai 2.0
- Fixed: deactivate listener for import, reducing extra DB queries (now 1k imported rows = ~7k queries, instead of 22k before)
- Fixed: improved boolean parsing
- strings `yes`, `true`, `1` = true
- everything else (e.g. `no`, `false`, `0`, empty string) = false
## Version 2.1.2
Compatible with Kimai 2.0
- Fixed: catch any Exception during CSV import
## Version 2.1.1
Compatible with Kimai 2.0
- Fixed: use UserService to create new user with default settings
## Version 2.1.0
Compatible with Kimai 2.0
- Added: new tabs for different importer
- Added: support creating user during import
- Added: new importer for Clockify migrations
- Added: option to choose between global and project-specific activities
- Fixed: Highlight errors
## Version 2.0.2
Compatible with Kimai 2.0
- Fixed: proper error handling for invalid date-times
- Fixed: proper error handling for unknown users
## Version 2.0.1
Compatible with Kimai 2.0
- Fixed: fixed import form validation
- Fixed: replaced "Sensio-FrameworkExtraBundle" with Symfony attribute
## Version 2.0
Compatible with Kimai 2.0
- Fixed: compatibility with 2.0
- Added: moved Kimai 1 import command from core to plugin
## Version 1.2
Compatible with Kimai 1.22.0
- Fixed: import of float values for "rate", "hourly rate", "fixed rate" and "internal rate"
## Version 1.0
Compatible with Kimai 1.21.0
- Initial version with support for:
- Customer
- Project
Installation
Kopiera filer
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 ...Rensa cache
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=prodIt 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/Uppdateringar
Updating the plugin works exactly like the installation:
- Delete the directory
var/plugins/ImportBundle/ -
Execute all installation steps again:
- Kopiera filer
- Rensa cache
Kompatibilitet
Följande tabell innehåller en jämförelse mellan tillägg och obligatorisk minimiversion av Kimai.
| Paketversion | Minsta Kimai-version |
|---|---|
| 2.10.0 | 2.11.0 |
| 2.7.0 - 2.9.0 | 2.5.0 |
| 2.6.0 | 2.4.0 |
| 2.5.0 - 2.5.1 | 2.1.0 |
| 2.4.0 | 2.0.30 |
| 2.1.4 - 2.3.0 | 2.0.9 |
| 2.0.0 - 2.1.3 | 2.0 |
| 1.2 | 1.22.0 |
