Skip to main content
Answered

Import Attendance data from Clockify -> How to import attendance just with a date and duration?

  • March 30, 2022
  • 5 replies
  • 293 views

Forum|alt.badge.img+1

I am struggling to import data from Clockify.

While they do have a start and end time, it can span over multiple days. They also have a duration but this can lead to weird results as the source data then sometimes causes a rollover to the next day.

 

So ideally I would like to import one or multiple entries just with a date and a duration. I do not care about specific start/end times for this historical data.

Best answer by Marc

Hi @lsmith,

Personio calculates adds up hours on a daily basis, so it is not possible to rollover midnight in one period, I think that may cause the issue?

Only uploading a date and amount of hours is not possible. Depending on the file Clockify exports, my recommendation would be to split days that rollover to the next one into two time periods.

I am looking forward how other User handle this using Clockify for time tracking.

Best wishes
Marc

5 replies

Marc
Former Personio Employee
Forum|alt.badge.img+12
  • Former Personio Employee
  • Answer
  • April 1, 2022

Hi @lsmith,

Personio calculates adds up hours on a daily basis, so it is not possible to rollover midnight in one period, I think that may cause the issue?

Only uploading a date and amount of hours is not possible. Depending on the file Clockify exports, my recommendation would be to split days that rollover to the next one into two time periods.

I am looking forward how other User handle this using Clockify for time tracking.

Best wishes
Marc


Forum|alt.badge.img+1
  • Author
  • Busy Bee
  • April 1, 2022

Puh, if I need to split up time periods it is going to be a very painful process. Either a lot of manual work, or I need to write a script :-/


Marc
Former Personio Employee
Forum|alt.badge.img+12
  • Former Personio Employee
  • April 1, 2022

Hi @lsmith,

I see that this may cause some work depending on how the export files looks like. 

Maybe there is a possibility to adapt the exports in Clockify accordingly? 

Best wishes
Marc


Forum|alt.badge.img+1
  • Author
  • Busy Bee
  • April 1, 2022

Yeah will check with them ..

 

Another option would be to just not bother with the historical data. However while for absences (ie. vacations) there is a way to set the left over days from a specific date on .. I have not found a way to do the same for over-/under-time.


Lena
Former Personio Employee
Forum|alt.badge.img+12
  • Former Community Moderator
  • April 12, 2022

Hi @lsmith,

it is correct, for over-/under-time it currently not possible to import a balance, it needs to be entered via one adjustment, or is automatically calculated due to entered/imported attendances that are on top of the work schedule. :) 

Please let us know in case you need further support. 

Best Regards,
Lena