Import .csv from another tracker

erpreciso

Hello, I am considering migrating from my current tracker, Grindstone, to WorkingHours.
I'd like to import entries from that tracker, to avoid to re-enter all project labels.
I could create a .csv with label, start, duration, as example below, or I can reshape as required, however how can I import in WorkingHours?
Thanks!

Work Item,Start,Duration
Accounting,04/05/2021 19:07:12,0:12:37
Accounting,04/05/2021 20:46:01,0:00:13
Accounting,05/05/2021 19:54:48,0:06:36

WorkingHours version: 2.7.7.0
OS + version: Windows 11 Home, Version 21H2

timo

Currently it is not possible to import data from CSV into WorkingHours, sorry

NickLockett

I would like this functionality too

DidierRobert

Me too I need it! Because I bought WorkingHours et want transferring my data from my old time tracker app...

timo

The reason I am hesitant to implement this is that WorkingHours would require a very specific order of the columns and way of how the data is formatted. CSV ≠ CSV: You would have to manually or programmatically bring your CSV into the same format as the one WorkingHours would require. If I added a CSV import feature, I am afraid many users are not aware of this or don't know how to do this "reformatting" of data and in the end, noone would really benefit from it

Greg

Hello, in case in the future you will decide to implement such feature, I write here my upvote too.

I understand it can be an "advanced feature" for unexperienced users, besides it could be a nice entry point for advanced users who decide to migrate to WorkingHours app form other solutions.

About formatting, I guess specifying columns order and data format could be enough for semi-advanced users. Or at least, it's what I'm doing in my software (clearly explaining the CSV columns order and data format).

As well as, here in the forum, there could be a topic regarding how to import data.

Maybe it's just my fantasy, but thanks anyway for the attention.

timo

Greg If you are technically savvy, you could already manually (programmatically) add the data to the apps SQLite database. I wouldn't expect this to be tremendously more difficult than creating a CSV file with the data in a predefined format.
It's noted in the FAQs where you find the database file and there's also a few discussions here in the forum where I answered questions of other users who worked with the database directly (e.g. here)