We are pleased to announce the new version March 2013 of time cockpit. In this version we have focused primarily on the following three goals:
- import data from Microsoft Excel and CSV files
- allow to maintain your data model in multiple languages
- make lists more expressive by adding charts to visualize information
Import Data from Excel or CSV Files
In previous versions of time cockpit you were already able to import data by writing python scripts or .NET code. But the overhead for importing just a few customers or projects was big. So we were looking for an easier way to get your data into time cockpit.
We decided to support Microsoft Excel and CSV files as data source for the new data importer. You can use the importer in two ways:
- Select an entity (e.g. Customer, Project ...) and let time cockpit build a template Excel or CSV file. You can then fill the generated template with your data and import it into time cockpit.
- If you already have an Excel or CSV file you want to import, you can tell the importer how to map the columns of the file to properties in time cockpit and then import your data.
Read more in the time cockpit documentation...
Multilingual Data Model
Up to now, we have always released time cockpit in English and in German, but you had to decide for a language when creating a new account. It was not possible to change that language later or to have several users that use different languages in one account.
In the new version we ship the data model in English and in German and each user can choose his preferred language and change it anytime. Additionally, you can add further languages to your data model. The following screenshot shows how you can add your own French localization for the Customer entity.
Please note that this feature does only affect the data model - that means names of entities, properties, and relations, headers in lists and forms, names of actions, validation messages of permissions and much more. Static text in the time cockpit UI is currently only available in English and German.
Visualize Information in Lists with Charts
The new version of time cockpit provides two new cell types for our lists: data bars and bullet graphs. Data bars allow you to display one value whereas bullet graphs can compare three values: an actual value, a projected value and a comparative value.
We have added data bars to some of our existing lists where we wanted to emphasize one specific key figure. The following list shows the remaining leave for all employees. We use the data bar to display the number of weeks of unused leave.
In the budgetary control of projects list we have added bullet graphs to show on the one hand the percentage of hours worked compared to the planned hours and on the other hand the percentage of billable hours.
If you want you can additionally display a comparative value in the graph. The result could look like in the following list. The blue bars show the actual hours spent on a project, the gray bars show the planned hours, and the black lines show the estimated project progress.
- The web version (Silverlight) now remembers settings like your last selected formatting profile, your selected device, the view mode in the calendar, etc. when you log out.
- The name of the logged in user and a logout button are shown in the web version (right top corner).
- In the full client you can send us an error report per email whenever an error occurs.
- Expression for the default form of an entity. You can specify, that time sheet entries should usually be opened with the form "APP_TimesheetForm", but when the field "Means of Transport" is set the form "USR_TravelTimesheetForm" should be used.
- IsVisible and IsEnabled expression for navigation commands, navigation sections and modules.
- You can now specify that a module should be opened on the server by default.
- Search in TCQL and Python editor
- Time cockpit can now track Microsoft Team Foundation Services for work item changes and check-ins.
- Book breaks in the time sheet calendar that overwrite all other bookings at the same time. That means you can book from 9:00 am to 5:00 pm and add a break booking for lunch from 12:00 pm to 12:30 pm instead of booking from 9:00 am to 12:00 pm and from 12:30 pm to 5:00 pm.
- If synchronization with the server does not work for some reason, time cockpit will warn you after one day instead of waiting 30 days.
- Overlapping time sheet entries are displayed in a more space-saving way.
- Relations can now be presented as radio button lists in addition to combo boxes.
- Performance in most lists is improved. Please note that templates for export to Microsoft Excel might have to be changed.