Compound Keys in Excel Import

Friday, August 29, 2014 by Rainer Stropek

If you are not familiar with time cockpit's importer, read more in Alex's blog article.

In the September version of time cockpit we have improved the importer for Excel and CSV files. It now supports compound keys. Compound keys are keys that consist of more than one column. This new feature is especially relevant if you want to import transactional data like time sheet records. In contrast to base data (e.g. customer, projects, etc.), transactional data typically does not have a primary key like a code or an ID. Therefore it is important to be able to mark multiple columns that form the primary key together.

The following screenshot shows how to set a compound key in time cockpit's importer:


The following short video demonstrates time cockpit's importer and the new compound key feature:

comments powered by Disqus