Release 1.14 - Reports, invoices & search bookmark

The release 1.14.3 was just published, after the major release was already released on the 23th of April. Sorry for the late posting, but some bugs popped up that needed to be fixed before this announcement.

Attention
This release includes a critical backward compatibility break: dropped SQLite support and FTP installation package (see announcement).

List of notable changes

• A new translation language was added: Greek
• Prevent overbooking of budgets (can be deactivated)
• Differentiate between billable and non-billable timesheets
• Duplicate timesheet entries via dialog for immediate adjustments
• Create bookmarks to change the default search of all listings (including invoice and export)
• Highlight invisible/deactivated items with light yellow background
• Change select box for colors: pre-select from a configured list via dropdown
• Redesigned action-toolbar on detail pages
• Export preview with money and time totals grouped by customer

Configurations

• Configure start of “financial year”
• Improved “Sunday being first day of week”
• Select report as initial view after login
• Configure the initial reporting view

Invoices

• Added preview grouped by customer
• Batch generation of invoices
• Added invoice archive with search
• Save payment date for invoices
• Export list of generated invoices

Calendar

• Display a daily total in “week” and “day” view
• Delete a time entry in the calendar view via drag & drop

New reports

• Monthly view for all users
• Yearly view for all users
• Project overview
• Inactive projects

Security issues

David Woodhouse from Aegis9 and Mohammed Al Oraimi reported a security issue related to CSV exports, called Dynamic Data Exchange or DDE payload attack (Users can add DDE payloads in timesheet descriptions). This is not a Kimai problem, but applies to all programs that support user input and CSV export. Microsoft actually calls this problem a “feature” of Excel. Advice: Do not rely on CSV for data exchange if you use Excel, export XSLX instead.

Thank you!

Thanks to all of you for using and supporting Kimai, especially:

• all clients and donors who help me to keep up the work for Kimai
• the developers who contributed their time
• the translators at Weblate
• the security researcher out there, who privately disclose any issue
• everyone else contributing at GitHub, too many to name you all

Thanks for being part of the Kimai community ❤️

Want to upgrade? Click here to find out how.

Full changelog

You can find all commits here.

Implemented enhancements:

• Tags in invoices #2525
• Monthly view for all users #2460
• Invoices -> new field to save the date when the invoice was payed #2449
• More columns for the spreadsheet exporter #2355
• Projects: Make data field “time budget” available in “eye” function of list view #2343
• Reporting: Not only for users, also for projects #2265
• Calendar: add day-total per day on the calendar-view #2252
• Batch generation of invoices for all customers #2178
• allow time entry for reporting / initial view #2131
• Calendar: provide possibility to delete a time entry in the calendar view #2124
• Disallow reports for inactive users #2048
• Listexport of generated Invoices from a certain state #1955
• User - restrict permission on changing Name, Title, and Profile Image #1935
• change select box for colors #1919
• Display a “time/budget”-bar on the projects overview #1912
• Support tags in invoices #2526 (kevinpapst)
• show daily sum in calendar week and day view #2519 (kevinpapst)
• added activity events for plugins #2516 (kevinpapst)
• Added drag & drop area to delete entries from the calendar #2513 (kevinpapst)
• update backend and frontend libraries #2512 (kevinpapst)
• Inactive projects, bookmark export search, billable timesheets #2503 (kevinpapst)
• New report + UI improvements #2494 (kevinpapst)
• Highlight invisible items #2493 (kevinpapst)
• allow to pre-define colors to choose from #2481 (kevinpapst)
• project overview #2467 (kevinpapst)
• Create multiple invoices at once #2465 (kevinpapst)
• add subtotal and payment date to invoices #2450 (cayacdev)
• Set default search options #2445 (kevinpapst)
• improve project view table #2441 (kevinpapst)
• Fix deprecations #2440 (kevinpapst)
• Added version ID for simpler comparison #2439 (kevinpapst)
• Allow to configure default report per user #2430 (kevinpapst)
• Show budget and time-budget in listing views #2429 (kevinpapst)
• Timesheet validator: prevent overbooking budgets #2422 (kevinpapst)
• Page actions #2420 (kevinpapst)
• More columns in spreadsheet exports #2413 (kevinpapst)
• Invoice archive - search and export #2408 (kevinpapst)
• Drop SQLite support #2405 (kevinpapst)
• allow to select reports as initial view #2403 (kevinpapst)
• User profile layout #2402 (kevinpapst)
• remove redundant translation key #2394 (kevinpapst)
• refactored templates to match controller #2391 (kevinpapst)
• Performance improvements #2329 (kevinpapst)
• Translations update from Weblate #2293, #2474 and #2401 (weblate)

Fixed bugs:

• The dates in the header row of the table on the Reporting page are not in the correct format for English (US) #2492
• The table Reporting page does not respect the user’s First day of the week setting #2475
• API Timesheets collection fails with error 500 instead of 404 #2466
• The calendar view on the DateRangePicker does not respect the user’s First day of the week setting #2459
• Cleaning Dashboard from projects out of date #2390
• Unreadable dirty modal notice #2370
• Fix calendar view for drag&drop entries with tags in dropdown-mode #2520 (kevinpapst)
• fix sunday being first day of week #2483 (kevinpapst)
• fix api 404 on page parameter #2468 (kevinpapst)
• allow increasing invoice numbers per day #2433 (kevinpapst)
• hide expired projects in team-projects widget #2432 (kevinpapst)
• Widget fixes #2373 (kevinpapst)