Home > Uncategorized > Task Calculator Google Gadget

Task Calculator Google Gadget

July 26, 2007

Some time ago I decided to keep track of my daily activities and schedules using Google Calendar. What I need today is an overview – to check how much time I actually spent on a particular activity. I would like to check out how much time it took me to work on my client’s project, or how many enjoyable hours were assigned to playing basketball.

Recently I have come up with a few code lines which demonstrate how to start an integration of Google Calendar and Zend Framework. Today I decided to proceed with it and get down to the project again. I started working on Google Gadget, – a tool which is supposed to perform this kind of integration. Right now the gadget is capable of downloading the tasks from an average-size calendar, calculate the total work time for all the records in a calendar, as well as for the records whose titles correspond to a given phrase. It is possible to define several phrases. All in all, it seems to be a quite promising herald of a project that a wide group of net surfers might find very useful. The project is available at: http://code.google.com/p/task-calculator/ To find the gadget you need to go here: http://task-calculator.googlecode.com/svn/trunk/TaskCalculatorGadget/WebContent/gadget.xml. Speaking from my experience, this gadget has already proved its usefulness and sufficiency. I can easily calculate the time devoted to work vice versa the blissful hours spent on entertainment. Such “searching for lost time” makes me think about getting down to work and trying to finish this project… Anyone willing to join me and pay his tribute to the internet? You are more than welcome, the project is open, the license you need is GPLv3. Its temporary name is Task Calculator but, as I have doubts about that, it seems to me that Task Report would sound better. I am not sure yet.

 

September 27, 2007

Some time ago I began working on a new project – Task Calculator. Its function is to create a report which would sum up the total work time – I need such data for invoicing my client. The work time data are recorded in Google Calendar. The Project is still only a proof of concept – the concept itself proved right, the calculator does all the counting – however, there are still a couple of issues to be improved.

In order to start the calendar you obviously need to have your account in Google. The Task Calculator works as a gadget embedded on Google Home Page. First you have to search for the private address of XML calendar in calendar settings.

Next you need to install the gadget Taks Calculator – click here. Then you copy the URL address from Google Calendar and place it the gadget settings. There is a possibility of adding the key words, which will appear in a report.

If everything works fine, you will see the following report on a monitor.

Now you can view the summary, the monthly report or the listing of all tasks. You are welcome to use the calculator!

 

Categories: Uncategorized Tags: , ,
  1. July 14th, 2009 at 18:29 | #1

    Hi, this app is *almost* exactly what I need, thanks for developing it! Is there any way to make it work with multiple calendars?

    I have about seven different calendars in gcal, to keep track of each job separately (plus sport, free time etc). When I use this app, it can only ever track one calendar at a time.

    Thanks!

  2. July 14th, 2009 at 18:36 | #2

    @Sonja – You can add more than one TaskCalculator gadget to IGoogle.

  3. September 3rd, 2009 at 10:23 | #3

    Hey,

    Great idea and thanks for this. It would be nice if google calendar will support tags/categories so you can easily filter on those a bit more solid variables.

  4. September 3rd, 2009 at 11:30 | #4

    @1hoog I agree with You. But now, I have to tag my “profit centers” using string keywords, for example:
    PROJECT1 / working on foo
    PROJECT2 / working on bar

  5. Anna
    September 4th, 2009 at 04:03 | #5

    this app is EXACTLY what I have been looking for! THanks very much for coding this!
    However I have a problem – I entered the private address of the XML calendar and pressed enter, but nothing comes up in the summary….. don’t know why, please help, thanks!

  6. September 4th, 2009 at 05:20 | #6

    @Anna I don’t know why it isn’t working for you.

    Are you using a modern web browser? Is JavaScript enabled? Is
    your calenar very very huge ?

    Please try try this calendar URL: (it’s Warsaw Java User group feed)
    http://www.google.com/calendar/feeds/7dmp09fjl82d57m3dgu4gj020g@group.calendar.google.com/public/basic

    Please inform me.

  7. Anna
    September 4th, 2009 at 06:16 | #7

    @Antoni Jakubiak hey, that works! So it is probably my calendar’s problem – yes, my calendar is quite large… is that the problem? Btw I tried making my calendar public and it still didn’t work. Should I try waiting for longer for it to load or something?

  8. Michel Lecoq
    June 7th, 2010 at 22:36 | #8

    Hi Antoni,
    I am using your tasks calulator with my gmail acount and I find it great.

    In addition, I am now administering a Google apps domain.
    I would like each user of this google apps domain to use the Tasks Calculator to report its activity.
    I have tried to do this in two ways; but none of them worked:

    1) Get the private xml address of the detailed agenda of each user and include the gadget as many times as necessary in my Igoogle page to obtain the calculation results.
    However, It seems that it is not possible to share the details of an agenda with a non google acount (external to the google apps domain)

    2) Include the Tasks Calculator in the Igoogle page of each user. But It seems that there is no Igoogle page for a google apps acount, or at least I did not find it.

    Could you please help resolve this issue

  9. June 8th, 2010 at 17:16 | #9

    Hello Michel!

    1. I coudn’t find private xml address for calednard in apps. I think, it might not work.
    2. There is iGoogle page for each user, eg.: http://start.jakubiak.biz/

    This gadget will not work without private.xml URL. This gadget has to be rewriten, to use google auth, and then it might be able to do that. Unfortunatelly it is quite complicated.

    Best regards!

  10. michel.lecoq
    June 9th, 2010 at 08:24 | #10

    @Antoni Jakubiak
    Hi Antoni
    Thanks for your answer. I am disapointed I will not be able to use Tasks Calculator for my Google Apps domain, at least for now.
    Do you have an idea whether this is going to be possible sometime, and when ?
    About the http://start.jakubiak.biz/ : is this Igoogle page associated with a Google Apps acount ?

    Best regards

  1. No trackbacks yet.