Importateur
Un greffon qui permet d'importer des fichiers CSV à travers un écran d'administration.

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.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
Copier les fichiers
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 ...
Effacer le 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=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/
Mises à jour
Updating the plugin works exactly like the installation:
- Delete the directory
var/plugins/ImportBundle/
-
Execute all installation steps again:
- Copier les fichiers
- Effacer le cache
Compatibilité
Le tableau suivant contient une comparaison entre le greffon et la version minimale requise de Kimai.
Version groupée | Version minimale de Kimai |
---|---|
2.7.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 |
Essayez-le
Vous pouvez tester ce greffon à l'adresse suivante demo.kimai.org:
Nom d'utilisateur: susan_super
Mot de passe: kitten