As a time cockpit administrator you can extend the data model of your subscription without any programming skills. Of course you will still receive updates for time cockpit even if you extended your data model.
- Add new tables and relations
Extend time cockpit’s data model with new tables and relations. Time cockpit will auto-generate lists and forms for data maintenance automatically. You can customize them if needed.
- Add new properties
Choose from a variety of support data types like text, numeric, date, etc.
- Add calculated properties
Add calculations that reflect your specific business logic using time cockpit’s formula language.
- Add validation rules
Time cockpit comes with a set of validation rules. Add additional ones to enforce business rules which are important for the consistency of your time recording database.
Data Access Permissions
Define data access permissions that fit to your company’s data access policies.
As a time cockpit administrator you can create rules that define which users can access which tables and data rows. You do not need programming skills for building up a permission system. You use time cockpit’s formula language for that purpose.
Permissions can depend on any user-related data in your time cockpit data model (e. g. is a user member of a certain group, is the user project manager for a specific project, etc.). Access permissions are enforced in the full client as well as in the online browser client.
Customize and extend time cockpit’s lists and forms to tailor them to your specific needs.
As a time cockpit administrator you can customize lists and forms without needing to know a programming language like Python, C#, or VB.NET. Define Lists and Forms in an XML format that is easy to learn and understand. Time cockpit contains an editor for such XML definitions in which you can try your configuration changes before you publish them for other users. Time cockpit respects your custom lists and forms in the full client and the online browser client.
OData Web API
Time cockpit provides a platform-independent OData Web Service that you can use to read and write data over the web. Your data model customizations are fully respected (e.g. custom tables, custom columns, validation rules, permissions, etc.). Here are some sample scenarios for time cockpit’s OData Web API:
- Data Analysis
Complement time cockpit’s powerful reporting engine with interactive data analysis capabilities of e.g. Microsoft Excel with Power Query. Use time cockpit’s OData feed as your data source.
- Data Integration
Integrate your time tracking data in your existing reporting DB or data warehouse using e.g. OData support of SSIS (SQL Server Integration Services).
- Custom Apps
Find more information on using the OData Web API in the time cockpit documentation.
Python is one of the world’s most commonly used scripting languages. Time cockpit supports IronPython scripts, therefore you have access to the entire Microsoft .NET Framework class library in your scripts. Use your favorite Python development environment or develop your scripts in time cockpit’s interactive Python editor. As a time cockpit administrator you can write scripts to automate certain tasks:
- Import or export data to other systems via CSV files, XML files, web services, etc.
- Automatically create and send Microsoft Office Excel reports (read more about reporting ...)
- Implement processes like vacation confirmation, creation of invoices, etc.
Time cockpit contains a command line tool to schedule scripts. Alternatively you can add your script to your time cockpit data model and let the user trigger it with a button or hyperlink (currently only limited support in the online browser client).
Read more about scripting in time cockpit’s online help ...
Deployment of Customizations
You do not need to worry about deploying your customizations. Time cockpit deploys them automatically.
Deploying customizations does not mean installing a new version of time cockpit. As an administrator you customize your time cockpit environment using the full client. When you are done, your changes are immediately visible in the online browser client. Your colleagues using the full client will receive your customizations automatically during the next synchronization.