Google Calendar Invoice Creator
by oliveOil
Posted: 23-Nov-07
Description:
This application reads an RSS feed from your Google Calendar in which every created appointment the number of hours worked for a project represents. Based on the title it filters the appointments, calculates the total of hours and creates your invoice in html or text version. Obviously you need a Google account to use this application.
1.Make a new Calendar in Google Calendar where you keep track of your hours worked on projects.\n
2. Add an appointment to the Calendar, give it a project name and drag it down for it's duration.
3. In Google Calendar go to [settings] -> [Calendars]
4.Click on [edit settings] -> [Calendar details]
5. Here you find in Calendar address a button [xml]
<6. If you click on this button you get a popup with the [rss address]
7. this url has to be pasted in the applications RSS settings view to get the calendar entries in the application
8. When your address is right and the application finds rss entries it will automatically switch to the Invoice view.
9. Add the project name in the Project list and select it, select the right period and you should see a summary of the worked hours in the Invoice.
10. If you click the 'Layout' button in the 'HTML' tab you can edit the layout of your invoice.
11. If you click the 'Text Summary' tab you get a resume of your worked hours in text format.
++ v1.8 No month pattern needed anymore(uses Google data full format), update service implented
++ v1.7 reads date format: Jun 20, 2008 too
++ v1.6 mar 12 2008 Installs now on vista with new air player
++ v1.5 mar 8 2008
fixed date parsing bug when more days appointment in calendar, better error handling, created higher resolution for printing
++ v1.4 feb 27 2008 fixed date parsing bug
|
|
|
| Cost: | Free |
| Language: | English |
| Version: | 1.8 Beta |
| Requires: |
Adobe AIR 1.5 |
| Downloads: | 4624 |
| Trial: | No |
PUBLISHER INFORMATION
REVIEWS
Hi oliveOil,
I love your program but I have some problems regarding the currency field. When I'm using the "$" sign, I get this on the invoice : "9 hours * nbsp;15.00 = nbsp;135.00", I don't know what is wrong.
The other problem I have is that the company name, address and other information that I entered in the client registration don't appear on the invoice, why?
Thanks for your diligence!
Martin
Add a Comment | Flag this Review
Hi Iene,
>Could not retrieve date from summary: Wanneer: vr 3. okt 2008 13:30 - 18:00
In update 1.8 I realy fixed this problem since you don't have to fill in a Month Pattern anymore.
Add a Comment | Flag this Review
Add a comment to this review using the text field provided. You can edit or delete your posted comment at any time.
Hi oliveOil, I installed everything like you mention above. At first it worked. After I had put in all my agenda items it couldn't refresh anymore. I keep getting the following error:
Could not retrieve date from summary: Wanneer: vr 3. okt 2008 13:30 - 18:00
CEST<br>
<br>Status van afspraak: bevestigd
Match the Hours 'Month pattern: jan|feb|mar|apr|may|jun|jul|aug|sep|oct|nov|dec' to your Google Calendar language settings
what did I do wrong? I tried to change the language settings but it didn't help...
thanks,
Lene
Add a Comment | Flag this Review
Add a comment to this review using the text field provided. You can edit or delete your posted comment at any time.
This is what happens when I hit refresh from the settings area. I tried making setting changes but it seems to default to dd/mm/yyyy. In USA the standard is mm/dd/yyyy
Thanks, I love the concept.
Could not retrieve date from summary: When: Fri Jun 20, 2008 8:30am to 2:30pm
PDT<br>
<br>Event Status: confirmed
Try matching the Hours 'Month pattern' to your Google Calendar summary date settings
Add a Comment | Flag this Review
Add a comment to this review using the text field provided. You can edit or delete your posted comment at any time.
Is not able to load my calendar from google. Errors every time.
Add a Comment | Flag this Review
Add a comment to this review using the text field provided. You can edit or delete your posted comment at any time.



Add a comment to this review using the text field provided. You can edit or delete your posted comment at any time.