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:


Video

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

comments powered by Disqus

Rainer Stropek

Rainer Stropek

Co-founder, architect, developer

Bio

I am co-founder and CEO of the company software architects and have been serving this role since 2008. At software architects my team and I are developing the award-winning SaaS solution time cockpit. Previously, I founded and led IT consulting firms that worked in the area of developing software solutions based on the Microsoft technology stack.

In my work I focus on .NET development and software architecture. I have written some books and articles on C#, database development, Windows Azure, Windows 8 development, WPF, and Silverlight. Regularly I speak at conferences, do workshops and conduct trainings in Europe and the US. Since 2010 I have been MVP for Windows Azure.

I graduated the Higher Technical School Leonding (AT) for MIS with honors and hold a BSc (Hons) Computer Studies of the University of Derby (UK).

Contact

Twitter: @rstropek
Facebook
Google+
Xing
LinkedIn

Authors