TimeKex - Импорт файлов Excel с табелями времени
Импортируйте ваши поддерживаемые в Excel табели времени в Kimai еженедельно. Также доступен импорт плоского клиента/проекта/активности из Excel.
Katja Glass Consulting
This application is designed to allow importing times, tracked in Excel, into Kimai by uploading the Excel files through the web frontend.
Documentation and Demo
The documentation of TimeKex as well as a running demonstration instance is available here.
The demonstration is running against the stable Kimai demo instance. Be aware that this demo instances is regularly rebuild.
Example excel files are located in the GitHub repository.
License
This project is using the MIT license (see LICENSE) for code and scripts.
Local Development and Compilation
TimeKex is a ReactJS Web Application. To run a local development version, you can use NPM to install all dependencies and start or build the app.
- Make sure to have NPM installed
- Download/clone this repository to a folder
<folder>
- Open the command line, go to that folder (cd
<folder>
) - Install packages using
npm install
- Start the development server with
npm start
- Build the app via
npm run build
Deployment
The TimeKex web application is a simple static HTML fileset which can run locally or on any Webserver. When you have build the app, it can simply be started by opening index.html
.
The final build folder contains next to the config.js also additional example configurations files which you might want to try. Just copy the content as config.js to apply the corresponding configuration. The current configuration files are using the Kimai demonstration server and users.
Excel Structure Timesheets
The Excel file is expected in a specific format. When the Excel file should contain a different structure, for example different column names, this can be changed by a source code updated and re-compiling the app. The file src/features/excelImport/ExcelSchema
is responsible to read in and map the corresponding Excel file to the specific object required for the application. Feel free to update the column names from the Excel file.
The package read-excel-file is used to read in the Excel file and use the corresponding schema for mapping. Please look into the package details to apply a different schema.
For the Excel file it is very important that the first sheet contains the time data and that the first row starts with the column names. There can be additional sheets and additional columns in the Excel file. The column order is also not relevant. Example file is available under ./exampleFiles
.