[CK-Ledger-users] Re: Porting of SQL-Ledger to run on top of phpgroupware

[C K Wu <ck...@ch...>]

Hi, Brian,

I'll check this out too.

Cheers,
CK

Brian Johnson wrote:

> I don't know if this will help - I haven't used pg_dump before
>
> I think this is a dump of all the timetrack tables from phpgroupware
>
> You might be able to use this to set up the timetrack module tables
>
> -----Original Message-----
> From: C K Wu [mailto:ck...@ch...]
> Sent: Monday, February 18, 2002 8:28 PM
> To: Brian Johnson; ck-...@li...
> Subject: Re: Porting of SQL-Ledger to run on top of phpgroupware
>
> Hello, Brian,
>
> Thanks for checking out CK-Ledger.  Nice to hear that the
> software is useful in an actual business setting.
>
> Brian Johnson wrote:
>
> > Awesome idea!
> >
> > This has a lot of potential and thanks for all the work already done.
> >
> > I have a couple of feature requests:
> >
> > 1. could the main contact/company info be the phpgroupware addressbook?
> It
> > would be great if there was one contact database.  It seems logical that
> the
> > main phpgw addressbook should be the one used.  This would allow the
> > reduction of duplication of identical information and therefore
> optimization
> > of the database
> >
>
> This is definitely the way to go.  However, there was discussion on a major
> overhaul of phpgroupware's addressbook/Infolog around June last year with
> the possibility of adding a CRM module.  I would probably wait until the
> formal release of phpgroupware 0.9.14 before working on the integration.
>
> >
> > 2. could we integrate it with a time tracking utility to allow users to
> > input time and charge it based on time spent (I'm in a service industry
> > where we bill based on time).  I have modified the timetrack module to
> work
> > this way - I could send you the code.  It allows users to create a project
> > linked to a contact in the addressbook and then enter time for each
> project.
> > Currently, I set a billout rate for each employee so that we can track it
> > against budget figures but there is no method for invoicing.  The
> automatic
> > linking of this time info to your ledger package for billing and payment
> > tracking would be ideal.  Unfortunately, the service module currently
> would
> > require us to summarize the time info and manually create invoices
> >
> > I'm desperately looking for a replacement to Quickbooks Pro and your
> package
> > seems like a potential winner!  You may be surprised to note that despite
> > the large numbers of SME that bill based on time (pretty much all
> > consultants), there are hardly any accounting packages that can handle
> their
> > needs.  Quickbooks Pro is about the only one, and it still has definite
> > problems.
> >
> > I'm not a programmer, but I can do a bit of php coding modification and I
> > certainly can help you layout a program flow algorithym prior to
> > programming.
>
> Please, do send me the code.  This is exactly what I envisage to be the
> benefit
> of porting SQL-Ledger over to phpgroupware.  Please also send me your
> program
> flow algorithm, especially if it fit with your business' manual billing
> workflow.
>
> By the way, if you find any major error with CK-Ledger-0.0.5, do give me
> a yell.  I am planning to upgrade the project from pre-alpha to alpha.
>
> Best Regards,
> CK
>
>   ------------------------------------------------------------------------
>                   Name: ttrack.dump
>    ttrack.dump    Type: unspecified type (application/octet-stream)
>               Encoding: quoted-printable