I thought I saw something like this on sourceforge -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Ian Holsman Sent: Tuesday, June 27, 2006 6:26 AM To: [email protected] Subject: Re: Time Tracking Tool Importance: Low
On 27/06/2006, at 6:48 AM, Jos Yule wrote: > > I'm in the prototype phase for designing a time tracking/invoicing > tool > for my small business. First i'd like to know if anyone has already > done this kind of thing? > > If not, i'd like to make something available to other looking for this > kind of functionality. > > I should note that this _IS NOT_ for planning or project management. > Its just a time entry, reporting and invoicing tool. > > Ok, here is what i've got so far, table wise: > > CLIENT - name, address, notes, etc. > PROJECT - name, description - high level > JOB - name, related to a project. (rate) > WORK - hours, date done, by (association to the django USER table). > I'm assuming WORK also is associated with JOB > So, i might have a 'new product page' JOB for the 'web site' PROJECT > for 'wizbang' CLIENT. > > I'd then do WORK, which is associated to a JOB. The JOB currently has > the Rate ($/hr). that OK for small stuff, but if you have 2 people on a JOB it will fall down. > > I also have an INVOICE table to which each WORK row is associated. you should probably associate it with the CLIENT, as the client will probably want a single invoice for the time period detailing the work being done overall (but your client may be different) > > I'm not really happy with the INVOICE and WORK associations, or how a > JOB has the rate. I've also just hacked on the django USER association > to WORK. allow a invoice to over-ride the rate. > > It works for now, but in looking to make it (possibly) usable for a > wider audience, what things would you change or want to see added? > Don't use the built-in USER? Where should the Rate be stored? What > other var's would you want to have tracked (keeping in mind this is > trying to be a small simple app)? features ? for me multi-currency and PDF invoice generation. but you may just want to use SQL-ledger of OFBIZ (or quickbooks) they are pretty easy to use, and cheaper than writing it yourself. regards Ian > > I know that reports need to go in too, but that can be done once the > schema is defined... > > Thanks for any suggestions, hints and comments. > > jos > > > > --------------------------------------------------------------------------- The information contained in this message may be privileged and / or confidential and protected from disclosure. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by replying to this message and deleting the material from any computer. --------------------------------------------------------------------------- --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
