phpgwtimetrack-developers — Mailling List for developers

[Phpgwtimetrack-developers] FW: [phpGroupWare-developers] Feedback wanted: Phpgwtimtrack test release

[Bob S. <bo...@pr...>]

If anyone else has these problems, let me know. 

-----Original Message-----
From: Camden Spiller [mailto:ca...@ar...] 
Sent: Tuesday, May 08, 2001 1:18 PM
To: Bob Schader
Subject: Re: [phpGroupWare-developers] Announcing: Phpgwtimtrack test
release


Hi Bob,

I actually havn't had much opportunity to really test it out yet, but I
was talking to someone who installed phpgw 0.9.10 from scratch and then
installed the .9.10 timetrack test1 release and here's what he found (in
his words)....

------------------ snip ----------------
1. If you are a member of multiple groups, i.e. the "Admin" group and
the "Default" group, the setup pages won't display.  Once I removed
myself from the "Default" group I could see the setup page.

Bob's Reply: I have always been a member of both these groups, and never
had a problem accessing these pages. Of course, the last few weeks of
development was geared towards making sure the upgrade process worked
properly, and the main installation was never tested on the final
release version of phpgroupware 0.9.10, so it could be something was
introduced either by my upgrade coding or changes in the final version
of phpgroupware 0.9.10? 

2. On my new install of phpgroupware and timetracker the setup page only
displayed a table with the phrase "Step 1 - TimeTrack Database Setup
Options" in it.  The Install and Cancel buttons were not available.

It appears that this is because it thought my version of timetrack (as
found in the phpgw_applications table) was 0.0.0.  Because there was no
'if' statement that matched this in the setup/index.php script, it gave
me no options to install.

I managed to fix this my manually setting $previous_ttver to "none"
after line 176 in the setup/index.php script.  Obviously this isn't a
permanent solution, but it worked well as a temporary work around.

Bob's Reply: This could be an acceptable fix as far as I can tell, but
you must have had a really old release of timetrack to have the version
set to 0.0.0. Another possible solution would be to manually update the
version string before upgrading (via any MySQL client).

------------------ end snip ----------------

I havn't looked in to his statements yet, but I wanted to pass them
along to you in case you were looking for feedback.

Thanks again,

Camden


>
> P.S. Any feedback on installation, upgrading, use, etc?
>

[Phpgwtimetrack-developers] CVS updates for timetrack

[Camden S. <ca...@ar...>]

I went ahead and taged everything in the repository now and added the new
code from Bob's 0.9.10 test release.

If anyone wants the 0.9.9 compatable version they can do check it out from
the repository like:
cvs co -r phpgw0_9_9compat timetrack

otherwise, you'll get the latest working 0.9.10 code by doing a normal
co timetrack

Thanks Bob!

Camden

----- Original Message -----
From: "Bob Schader" <bo...@pr...>
To: "Camden Spiller" <ca...@ar...>
Sent: Wednesday, May 02, 2001 6:32 PM
Subject: Re: [phpGroupWare-developers] Announcing: Phpgwtimtrack test
release


> Camden,
> The only thing I have changed since the test release
> is to try and start converting the pages to templates. And as far
> as that goes, I have really only started one of the pages.
> Basically I copied the php file to the templates directory, renaming
> it and proceeding to strip out the php code and templatize it.
> I think you could go ahead and do the tag, etc from the test release,
> as so far only one new file is added, and it is not ready yet.
> Bob
>
> P.S. Any feedback on installation, upgrading, use, etc?
>
> Camden Spiller wrote:
> >
> > Hi Bob,
> >
> > Have you done any further of developments on the 0.9.10 release? If you
> > want, send me a zip of your latest code I'll goahead and tag everything
> > that's in the CVS repository now as "phpgw0.9.10compat" and goahead and
> > check in all this new stuff.
> >
> > Thanks,
> >
> > Camden
> >
> > ----- Original Message -----
> > From: "Bob Schader" <bo...@pr...>
> > To: "Phpgroupware-Developers"
> > <php...@li...>;
"Phpgwtimetrack-Developers"
> > <php...@li...>
> > Sent: Friday, April 27, 2001 3:03 PM
> > Subject: [phpGroupWare-developers] Announcing: Phpgwtimtrack test
release
> >
> > > I have made a test release of phpgwtimetrack available
> > > at my ftp server, for anyone that would like to test
> > > and/or use it. I especially would be interested if anyone
> > > using PostgreSQL could let me know if it works with
> > > that DB. This version is built against phpgroupware
> > > 0.9.10 as released on sourceforge. The test release
> > > can be downloaded at
> > > ftp://ftp.product-des.com/pub/timetrack-0.9.10test1.zip
> > > File size is 245,040 bytes.
> > >
> > > Please read the files in the doc directory first. But
> > > if you really insist otherwise, simply extract the
> > > zipfile into your phpgroupware directory, login to
> > > phpgroupware as an admin, and if timetrack is already
> > > installed, access it's index page for an upgrade link,
> > > or if it isn't installed, manually set you URL to
> > > http://yourdomain.com/phpgroupware/timetrack/setup
> > > (Change "phpgroupware" to match your installation.
> > >
> > > I would have put this on sourceforge, but don't have the
> > > time right now.
> > >
> > > _____________________________
> > > Bob Schader
> > > CAD Systems Admin
> > > Product Design Intl., Inc.
> > > 4880 36th St. SE, Suite 100
> > > Grand Rapids, MI 49512
> > > (616) 667-2600 x104
> > >
> > >
> > > _______________________________________________
> > > Phpgroupware-developers mailing list
> > > Php...@li...
> > > http://lists.sourceforge.net/lists/listinfo/phpgroupware-developers
> > >
>

[Phpgwtimetrack-developers] Announcing: Phpgwtimtrack test release

[Bob S. <bo...@pr...>]

I have made a test release of phpgwtimetrack available
at my ftp server, for anyone that would like to test
and/or use it. I especially would be interested if anyone
using PostgreSQL could let me know if it works with
that DB. This version is built against phpgroupware
0.9.10 as released on sourceforge. The test release
can be downloaded at
ftp://ftp.product-des.com/pub/timetrack-0.9.10test1.zip
File size is 245,040 bytes.

Please read the files in the doc directory first. But
if you really insist otherwise, simply extract the
zipfile into your phpgroupware directory, login to
phpgroupware as an admin, and if timetrack is already
installed, access it's index page for an upgrade link,
or if it isn't installed, manually set you URL to
http://yourdomain.com/phpgroupware/timetrack/setup
(Change "phpgroupware" to match your installation.

I would have put this on sourceforge, but don't have the 
time right now.

_____________________________
Bob Schader
CAD Systems Admin
Product Design Intl., Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512
(616) 667-2600 x104

[Phpgwtimetrack-developers] Upgrade plans for Timetrack and phpgroupware 0.9.10

[Bob S. <bo...@pr...>]

This is just an announcement to everyone who plans to
upgrade phpgroupware to 0.9.10 and who currently uses
phpgwtimetrack.

The current release of phpgroupware has what I consider
a few serious bugs when it comes to upgrading the
addressbook tables properly, especially when timetrack
is installed. There are currently 2 issues involved,
which are:

1. When setup upgrades the addressbook table by copying
it to phpgw_addressbook, it re-assigns integer id's
in a consecutive order, but if anyone has deleted
contacts, then the original data will not neccessarily
be consecutive in the first place, so any tables which
reference the contact by an id will have incorrect
data returned.

2. Again, while the addressbook is being updated, company
name information is blindly pulled from the company
field, ignoring any company_id fields which are joined
against the customers table to get the company name from
an ID. Supposedly a fix was added to handle this situation,
but it must have got lost somewhere in cvsland.

Do not despair. Thankfully, the current setup leaves the
original addressbook table unchanged and does not drop it.
This is a good thing. I will have an option available for 
those upgrading timetracker which will allow re-doing the
upgrade of the addressbook table to another phpgw_addressbook
table in a way that will preserve all data.

I hope to have a beta release of phpgwtimetracker for
phpgroupware 0.9.10 available within the next week or so. 
If anyone would like an advance copy of what I have so far, 
let me know. I haven't bothered with CVS in quite awhile, 
so you can't get it there.

_____________________________
Bob Schader
CAD Systems Admin
Product Design Intl., Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512
(616) 667-2600 x104

Re: [Phpgwtimetrack-developers] companies.php questions.

[Bob S. <bo...@pr...>]

Yeah, that un-created profiles thing can be a major hassle. I believe
I documented this issue in the doc/USING file, but who reads docs
anyway? Most of the docs in there have not been kept uptodate
with some changes, but for the most part they still work.

As far as other bugs not already mentioned (customers, profiles, etc)
I am not aware of anything in particular. We have been using it where
I work since about October of last year. Our "production" server
is still running 0.9.4, but I have a parallel version of 0.9.9p1 installed
for testing and even a 0.9.10pre18 version on a new server I am
setting up (Timetrack doesn't work at all with the 0.9.10 series).

I did make one recent custom change to our production server recently,
which I will probably also make available in time. It was mainly an edit
to the jobslist.php page to remove the SUM(jd.num_hours) cross join
in the query for displaying the number of hours worked on a job in this
list, and added a total report to the details link, changing the text of the
"Num Hours" with "Details". The reason for this was that with our current
data having a total number of jobs over 300, and about 3000 job_detail
records, the response time to display this page was getting quite pathetic
on our current server. I suppose the best way to implement this would be
a config option so you could decide to display totals there or not.

I have a bunch of "todo" items for new features scribbled on paper here
and there, I really need to sit down and bring them all together. I would
say the biggest bug then is the lack of additional features, most notable
of which require the use of other backend database tools (my favorite
is phpMyAdmin) for correcting mistakes which do not yet have methods
internal to timetracker, like deleting jobs, changing a job number, etc,
plus there is no current method to export data, we still resort to manually
printing out the timesheets each week to turn them in.

Someone else had also submitted a patch recently to me which also deals
with the customers page, I truthfully have not even had time yet to look
at either of them. Hopefully this weekend.

Bob Schader

----- Original Message -----
From: <ti...@xi...>
To: <php...@li...>
Sent: Thursday, March 22, 2001 5:28 PM
Subject: RE: [Phpgwtimetrack-developers] companies.php questions.


> > I got a notice from sourceforge on the patch you submitted,
> > haven't had time to look at it yet, and now it looks like
> > sourceforge is down. Anyway, I currently do not plan on
> > making updates to CVS for the 099 compatible version, as
> > I will probably use CVS to concentrate on 0.9.10
> > compatibility when I can get to it. I(we) can still provide
> > updates to the 099 release through patches and file releases.
>
> As far as I can see, there aren't any other major problems with
> the 099 version - my boss is quite keen to start using it now. If we
> make any updates, I'll keep the list posted. If I have a chance I'll
> be looking at the user editing to add blank profiles automatically -
> took me quite a while to work out why setting changes weren't
> happening. Are there any other bugs to work on?
>
> That won't be immediate, tho, since I've still got lots to do getting the
> rest of phpGW going cleanly.
>
>
>
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpgwtimetrack-developers
>

RE: [Phpgwtimetrack-developers] companies.php questions.

[<ti...@xi...>]

> I got a notice from sourceforge on the patch you submitted,
> haven't had time to look at it yet, and now it looks like
> sourceforge is down. Anyway, I currently do not plan on
> making updates to CVS for the 099 compatible version, as
> I will probably use CVS to concentrate on 0.9.10
> compatibility when I can get to it. I(we) can still provide
> updates to the 099 release through patches and file releases.

As far as I can see, there aren't any other major problems with 
the 099 version - my boss is quite keen to start using it now. If we
make any updates, I'll keep the list posted. If I have a chance I'll
be looking at the user editing to add blank profiles automatically - 
took me quite a while to work out why setting changes weren't 
happening. Are there any other bugs to work on?

That won't be immediate, tho, since I've still got lots to do getting the 
rest of phpGW going cleanly.

RE: [Phpgwtimetrack-developers] companies.php questions.

[Bob S. <bo...@pr...>]

I got a notice from sourceforge on the patch you submitted,
haven't had time to look at it yet, and now it looks like
sourceforge is down. Anyway, I currently do not plan on
making updates to CVS for the 099 compatible version, as
I will probably use CVS to concentrate on 0.9.10
compatibility when I can get to it. I(we) can still provide
updates to the 099 release through patches and file releases.

More than likely, the upload of customers.php to sourceforge
probably ruined it's formatting. If you could forward the file
directly to me (or the list) as a zipped attachment, it would
be easier to work with.

Have you also removed the {output} from customers.tpl yourself?
If so, could you post that back here as well? My job activities
have been overloading me lately. I did not see any specific
questions in your email, so I hope I was able to help.

Bob Schader
_____________________________
Bob Schader
CAD Systems Admin
Product Design Intl., Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512
(616) 667-2600 x104

-----Original Message-----
From: php...@li...
[mailto:php...@li...]On Behalf
Of ti...@xi...
Sent: Wednesday, March 21, 2001 10:57 PM
To: php...@li...
Subject: [Phpgwtimetrack-developers] companies.php questions.


Greetings:

I'm working on a phpGroupWare install for my employer, and I've started
trying to get the timetracker module installed - they seem to like it, and
I've
got 0.99p1 of phpGW going, and I'm installing the 0.99-compatible
timetracker module from sourceforge.

Just uploaded a replacement customer.php to sourceforge - cleaned up
the template handling to fix the duplicate row bug. It also needs the
removal of {output} from customers.tpl.

[Phpgwtimetrack-developers] companies.php questions.

[<ti...@xi...>]

Greetings: 

I'm working on a phpGroupWare install for my employer, and I've started 
trying to get the timetracker module installed - they seem to like it, and  I've 
got 0.99p1 of phpGW going, and I'm installing the 0.99-compatible 
timetracker module from sourceforge. 

Just uploaded a replacement customer.php to sourceforge - cleaned up 
the template handling to fix the duplicate row bug. It also needs the 
removal of {output} from customers.tpl.

RE: [Phpgwtimetrack-developers] Contacts class LDAP

[Bob S. <bo...@pr...>]

Since my current plans call for providing an id to a contact
record inside the customer table, instead of having a customer
id linked inside the contacts table, this is probably not much
of a concern to me at this point. This is being done for 2 reasons:
1. To be more inline with the way Quickbooks works.
2. To lessen integration issues in regards to phpgw.

Bob

_____________________________
Bob Schader
CAD Systems Admin
Product Design Intl., Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512
(616) 667-2600 x104

-----Original Message-----
From: php...@li...
[mailto:php...@li...]On Behalf
Of Miles Lott
Sent: Monday, March 19, 2001 12:16 AM
To: php...@li...
Cc: php...@li...
Subject: [Phpgwtimetrack-developers] Contacts class LDAP


The contacts class ldap backend is being written now.  So long
as you are using the contacts class for all read/write, it will
hopefully be transparent if you wish to change to ldap.
It is NOT yet useable.  FYI, the configs for this have been in
setup for a month or two, via config.php.

Since I know there will be debate about proper dn's etc.,
please take a moment to do the following if you are interested.
In current cvs addressbook, click the export button.  In the
dropdown will be a selection, 'phpgw LDIF'.  Select this,
uncheck the download button, and view the output in the browser.
Assuming you had some contacts entered, you should see the
proposed format for these entries.

I am nowhere near completing this, so it would be good to
comment on it now before we move too far.  Also note that
LDAP account dn's under ou=People or whatever would not be
affected by this.

-- 

Miles Lott - http://milosch.net
Handspring Visor USB and BeOS FS support for Linux
phpGroupWare - http://www.phpgroupware.org

[Phpgwtimetrack-developers] Re: [phpGroupWare-developers] Contacts class LDAP

[Dan K. (Seek3r) <da...@ku...>]

Very very cool!
Finally start showing off the real value of teh contacts class design

Miles Lott wrote:
> 
> The contacts class ldap backend is being written now.  So long
> as you are using the contacts class for all read/write, it will
> hopefully be transparent if you wish to change to ldap.
> It is NOT yet useable.  FYI, the configs for this have been in
> setup for a month or two, via config.php.
> 
> Since I know there will be debate about proper dn's etc.,
> please take a moment to do the following if you are interested.
> In current cvs addressbook, click the export button.  In the
> dropdown will be a selection, 'phpgw LDIF'.  Select this,
> uncheck the download button, and view the output in the browser.
> Assuming you had some contacts entered, you should see the
> proposed format for these entries.
> 
> I am nowhere near completing this, so it would be good to
> comment on it now before we move too far.  Also note that
> LDAP account dn's under ou=People or whatever would not be
> affected by this.
> 
> --
> 
> Miles Lott - http://milosch.net
> Handspring Visor USB and BeOS FS support for Linux
> phpGroupWare - http://www.phpgroupware.org

[Phpgwtimetrack-developers] Contacts class LDAP

[Miles L. <mi...@sp...>]

The contacts class ldap backend is being written now.  So long
as you are using the contacts class for all read/write, it will
hopefully be transparent if you wish to change to ldap.
It is NOT yet useable.  FYI, the configs for this have been in
setup for a month or two, via config.php.

Since I know there will be debate about proper dn's etc.,
please take a moment to do the following if you are interested.
In current cvs addressbook, click the export button.  In the
dropdown will be a selection, 'phpgw LDIF'.  Select this,
uncheck the download button, and view the output in the browser.
Assuming you had some contacts entered, you should see the
proposed format for these entries.

I am nowhere near completing this, so it would be good to
comment on it now before we move too far.  Also note that
LDAP account dn's under ou=People or whatever would not be
affected by this.

-- 

Miles Lott - http://milosch.net
Handspring Visor USB and BeOS FS support for Linux
phpGroupWare - http://www.phpgroupware.org

Re: [Phpgwtimetrack-developers] phpgw->link()

[Bob S. <bo...@pr...>]

Go ahead and commit it, as long as everything is already uptodate
with CVS. I have not yet been committing changes to CVS for
the 0.9.10 updates (table name changes, etc). Persinally,
I think it's kind of stupid the way they keep flipping back and forth
on this issue. I see no reason that $PHP_SELF should NOT
work (except in cases where php is being run as a CGI
method and not a module.
Bob

----- Original Message -----
From: "Camden Spiller" <ca...@ar...>
To: <php...@li...>
Sent: Sunday, March 18, 2001 7:11 PM
Subject: Re: [Phpgwtimetrack-developers] phpgw->link()


> I checked out the latest timetrack cvs yesterday along with updating my
copy
> of phpGroupWare-0.9.9-patches it was back to throwing errors with all
those
> PHP_SELF links.
>
> I found a message Jengo sent to the list on 3/8/01 stating the new rules
for
> link():
> 1) You _MUST_ send it the file name ... no more of this <a href="' .
> $phpgw->link()
> . '">   I made the poor choice to add the $PHP_SELF feature in the past.
> Basicly,
> it was becuase I was too lazy to type the filename ... :)
> 2) You have to pass the appname AND the first slash
> Example:  link('/calendar/edit.php')
> 3) webserver_url will be added automaticly ... don't pass it
>
> I've already got the link() changes ready to commit, but let me know if
you
> want me to hold off.
>
> Thanks,
>
> Camden
>
>
> ----- Original Message -----
> From: "Bob Schader" <bo...@pr...>
> To: <php...@li...>
> Sent: Sunday, March 18, 2001 5:19 PM
> Subject: Re: [Phpgwtimetrack-developers] phpgw->link()
>
>
> > Camden,
> > I already thought I had this fixed by just changing any
> > $PHP_SELF var's to "" instead. It was working fine
> > with 0.9.9 the last time I checked.
> > Bob
> >
> > ----- Original Message -----
> > From: "Camden Spiller" <csp...@su...>
> > To: <php...@li...>
> > Sent: Sunday, March 18, 2001 1:08 AM
> > Subject: [Phpgwtimetrack-developers] phpgw->link()
> >
> >
> > > I've converted the all the $phpgw->link()'s to
> > > $phpgw->link("/timetrack/pagename.php") as required per 0.9.9 ... any
> > reason
> > > not to commit this to CVS now?
> > >
> > > Camden
> > >
> > >
> > > _______________________________________________
> > > Phpgwtimetrack-developers mailing list
> > > Php...@li...
> > > http://lists.sourceforge.net/lists/listinfo/phpgwtimetrack-developers
> > >
> >
> >
> > _______________________________________________
> > Phpgwtimetrack-developers mailing list
> > Php...@li...
> > http://lists.sourceforge.net/lists/listinfo/phpgwtimetrack-developers
> >
>
>
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpgwtimetrack-developers
>

Re: [Phpgwtimetrack-developers] phpgw->link()

[Camden S. <ca...@ar...>]

I checked out the latest timetrack cvs yesterday along with updating my copy
of phpGroupWare-0.9.9-patches it was back to throwing errors with all those
PHP_SELF links.

I found a message Jengo sent to the list on 3/8/01 stating the new rules for
link():
1) You _MUST_ send it the file name ... no more of this <a href="' .
$phpgw->link()
. '">   I made the poor choice to add the $PHP_SELF feature in the past.
Basicly,
it was becuase I was too lazy to type the filename ... :)
2) You have to pass the appname AND the first slash
Example:  link('/calendar/edit.php')
3) webserver_url will be added automaticly ... don't pass it

I've already got the link() changes ready to commit, but let me know if you
want me to hold off.

Thanks,

Camden


----- Original Message -----
From: "Bob Schader" <bo...@pr...>
To: <php...@li...>
Sent: Sunday, March 18, 2001 5:19 PM
Subject: Re: [Phpgwtimetrack-developers] phpgw->link()


> Camden,
> I already thought I had this fixed by just changing any
> $PHP_SELF var's to "" instead. It was working fine
> with 0.9.9 the last time I checked.
> Bob
>
> ----- Original Message -----
> From: "Camden Spiller" <csp...@su...>
> To: <php...@li...>
> Sent: Sunday, March 18, 2001 1:08 AM
> Subject: [Phpgwtimetrack-developers] phpgw->link()
>
>
> > I've converted the all the $phpgw->link()'s to
> > $phpgw->link("/timetrack/pagename.php") as required per 0.9.9 ... any
> reason
> > not to commit this to CVS now?
> >
> > Camden
> >
> >
> > _______________________________________________
> > Phpgwtimetrack-developers mailing list
> > Php...@li...
> > http://lists.sourceforge.net/lists/listinfo/phpgwtimetrack-developers
> >
>
>
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpgwtimetrack-developers
>

Re: [Phpgwtimetrack-developers] Re: [phpGroupWare-developers] Table name changes - netledger import

[Bob S. <bo...@pr...>]

I have played with importing some data into Quickbooks, it seems to be
rather loose about accepting the data (will create new jobs, etc).
Bob

----- Original Message -----
From: "Camden Spiller" <ca...@ar...>
To: <php...@li...>
Cc: <php...@li...>
Sent: Saturday, March 17, 2001 6:37 PM
Subject: [Phpgwtimetrack-developers] Re: [phpGroupWare-developers] Table
name changes - netledger import


> It looks like NetLedger will let you import a QIF (Quicken) file without
> replacing all the existing NetLedger data.
>
> Has anyone tried that?
>
> ----- Original Message -----
> From: "Michael and Michele Dean" <md...@kc...>
> >
> > We also looked at doing SMBXML (NetLedger's transaction DTD), but it
> > seems you have to pay a fee for the priviledge to use it.  The fee we
> > were quoted was 5 figures (!!!!!!!).  IIRC, NetLedger either takes IIF
> > or QIF as a "seed" for the account, but does not do ad-hoc imports.  For
> > that, you would need SMBXML.
>
>
>
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpgwtimetrack-developers
>

Re: [Phpgwtimetrack-developers] Re: [phpGroupWare-developers] Table name changes

[Bob S. <bo...@pr...>]

Camden,
No, I haven't had the time yet to add this flag. I am still aways of
from getting to it. Hopefully in the next week or 2.
Bob

----- Original Message -----
From: "Camden Spiller" <ca...@ar...>
To: <php...@li...>
Sent: Saturday, March 17, 2001 6:56 PM
Subject: [Phpgwtimetrack-developers] Re: [phpGroupWare-developers] Table
name changes


> Hey Bob,
>
> Have already you added that flag to the job_details table mark the record
as
> locked?
>
> I'm currently using NetLedger for my billing but need to be able to tell
> within timetrack what's not been billed for yet.
>
> Camden
>
> > > Then, on a weekly basis, a user with designated payroll acls would
> > > review the timesheet data in timetracker, make any corrections, etc,
> > > and then create a "timer activities" iif file that can be imported
> > > into Quickbooks for Timesheets in Quickbooks. At that point, a flag
> > > would be set on the Timetrack data that locks it from further changes.
>
>
>
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpgwtimetrack-developers
>

Re: [Phpgwtimetrack-developers] phpgw->link()

[Bob S. <bo...@pr...>]

Camden,
I already thought I had this fixed by just changing any
$PHP_SELF var's to "" instead. It was working fine
with 0.9.9 the last time I checked.
Bob

----- Original Message -----
From: "Camden Spiller" <csp...@su...>
To: <php...@li...>
Sent: Sunday, March 18, 2001 1:08 AM
Subject: [Phpgwtimetrack-developers] phpgw->link()


> I've converted the all the $phpgw->link()'s to
> $phpgw->link("/timetrack/pagename.php") as required per 0.9.9 ... any
reason
> not to commit this to CVS now?
>
> Camden
>
>
> _______________________________________________
> Phpgwtimetrack-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpgwtimetrack-developers
>

[Phpgwtimetrack-developers] phpgw->link()

[Camden S. <csp...@su...>]

I've converted the all the $phpgw->link()'s to
$phpgw->link("/timetrack/pagename.php") as required per 0.9.9 ... any reason
not to commit this to CVS now?

Camden

[Phpgwtimetrack-developers] Re: [phpGroupWare-developers] Table name changes

[Camden S. <ca...@ar...>]

Hey Bob,

Have already you added that flag to the job_details table mark the record as
locked?

I'm currently using NetLedger for my billing but need to be able to tell
within timetrack what's not been billed for yet.

Camden

> > Then, on a weekly basis, a user with designated payroll acls would
> > review the timesheet data in timetracker, make any corrections, etc,
> > and then create a "timer activities" iif file that can be imported
> > into Quickbooks for Timesheets in Quickbooks. At that point, a flag
> > would be set on the Timetrack data that locks it from further changes.

[Phpgwtimetrack-developers] Re: [phpGroupWare-developers] Table name changes - netledger import

[Camden S. <ca...@ar...>]

It looks like NetLedger will let you import a QIF (Quicken) file without
replacing all the existing NetLedger data.

Has anyone tried that?

----- Original Message -----
From: "Michael and Michele Dean" <md...@kc...>
>
> We also looked at doing SMBXML (NetLedger's transaction DTD), but it
> seems you have to pay a fee for the priviledge to use it.  The fee we
> were quoted was 5 figures (!!!!!!!).  IIRC, NetLedger either takes IIF
> or QIF as a "seed" for the account, but does not do ad-hoc imports.  For
> that, you would need SMBXML.

[Phpgwtimetrack-developers] future development - suggestion

[Geoffrey M. <gm...@51...>]

Hi, 

It's really good to hear that things are going to be under development with changes 
that will make Timetrack even more useful. 

In regard to changes in the Customers and Addressbook relationship, you might also 
consider some linkage/discussion to the Projects module that is in development. 
This module also uses "customers" but this is internal to their sql schema. A link 
to this module would allow for more functionality accross phpgroupware. 

Regards, 
G. 

bo...@pr... wrote: 
> 
>I have decided that to better allow importing and exporting of data 
>to Quickbooks, I plan on redesigning the Customers table that 
>Timetrack uses. The way I plan it, once this is completed, Timetrack 
>will not really need custom addressbook code, as it will be more 
>centered on the customers list itself. I plan on having the Customers 
>list link to contacts in the addressbook instead of the current method 
>of having contacts in the addressbook linked to the customers table. 
>For the groupware developers, this is mainly a heads up to alert you 
>so that you no longer have to support the current mess in regards to 
>Timetrack interacting with the addressbook. However, if you are 
>going to still use the customers table in it's current form, it might 
>more likely be renamed to something like "organizations" or "companies" 
>or something like that. 
>If anyone would like to help me out with implementing this, feel free 
>to contact me. I will publish a new "customers" schema soon. 
>_____________________________ 
>Bob Schader 
>CAD Systems Admin 
>Product Design Intl., Inc. 
>4880 36th St. SE, Suite 100 
>Grand Rapids, MI 49512 
>(616) 667-2600 x104 
>_______________________________________________ 
>Phpgwtimetrack-developers mailing list 
>Php...@li... 
>http://lists.sourceforge.net/lists/listinfo/phpgwtimetrack-developers 

-----
geoffrey makstutis
                  51% studios
                  architecture+design
                  1-5 clerkenwell road
                  london ec1m 5pa
                  [t]020 7251 6963
                  [f]020 7251 6964
                  [w]www.51pct.com
gm...@51...

[Phpgwtimetrack-developers] Re: [phpGroupWare-developers] Future direction of phpgwtimetrack

[Dan K. <da...@ku...>]

Bob Schader wrote:
> 
> I have decided that to better allow importing and exporting of data
> to Quickbooks

Oh now *this* woudl really be awesome. If you can generate an qiff file,
then I could even use this with my Netledger.com account that I use to
manage the accounting for Clear River Technologies.

I would be more than willing to help if you need

-- 

Seek3r (aka Dan Kuykendall)
phpGroupWare Project Leader (http://www.phpgroupware.org)
OGS Project Leader (http://www.ogsproject.org)

[Phpgwtimetrack-developers] Re: [phpGroupWare-developers] Future direction of phpgwtimetrack

[Miles L. <mi...@ya...>]

I have some time off for now to help with this, especially as pertains
to the contacts class.  Find me in IRC sometime - I think I have seen
you there?

TTYS
Miles Lott

Bob Schader wrote:
> 
> I have decided that to better allow importing and exporting of data
> to Quickbooks, I plan on redesigning the Customers table that
> Timetrack uses. The way I plan it, once this is completed, Timetrack
> will not really need custom addressbook code, as it will be more
> centered on the customers list itself. I plan on having the Customers
> list link to contacts in the addressbook instead of the current method
> of having contacts in the addressbook linked to the customers table.
> 
> For the groupware developers, this is mainly a heads up to alert you
> so that you no longer have to support the current mess in regards to
> Timetrack interacting with the addressbook. However, if you are
> going to still use the customers table in it's current form, it might
> more likely be renamed to something like "organizations" or "companies"
> or something like that.
> 
> If anyone would like to help me out with implementing this, feel free
> to contact me. I will publish a new "customers" schema soon.
> 
> _____________________________
> Bob Schader
> CAD Systems Admin
> Product Design Intl., Inc.
> 4880 36th St. SE, Suite 100
> Grand Rapids, MI 49512
> (616) 667-2600 x104
> 
> _______________________________________________
> Phpgroupware-developers mailing list
> Php...@li...
> http://lists.sourceforge.net/lists/listinfo/phpgroupware-developers

-- 

Miles Lott - http://milosch.net
Handspring Visor USB and BeOS FS support for Linux

[Phpgwtimetrack-developers] Future direction of phpgwtimetrack

[Bob S. <bo...@pr...>]

I have decided that to better allow importing and exporting of data
to Quickbooks, I plan on redesigning the Customers table that
Timetrack uses. The way I plan it, once this is completed, Timetrack
will not really need custom addressbook code, as it will be more
centered on the customers list itself. I plan on having the Customers
list link to contacts in the addressbook instead of the current method
of having contacts in the addressbook linked to the customers table.

For the groupware developers, this is mainly a heads up to alert you
so that you no longer have to support the current mess in regards to
Timetrack interacting with the addressbook. However, if you are
going to still use the customers table in it's current form, it might
more likely be renamed to something like "organizations" or "companies"
or something like that.

If anyone would like to help me out with implementing this, feel free
to contact me. I will publish a new "customers" schema soon.

_____________________________
Bob Schader
CAD Systems Admin
Product Design Intl., Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512
(616) 667-2600 x104

[Phpgwtimetrack-developers] RE: working, but still a few questions

[Bob S. <bo...@pr...>]

Geoffrey,

Apparently, there is more work to be done. As long as you can somehow
migrate the company name from the addressbook to the customer list,
there should be no problem using a current installation. Apparently,
as long as entries are made in the customers list, then you should
start seeing the addressbook data again, albeit perhaps with double
entries (not sure why that's happening) and a Company name of "Not Set".
There is also another bug in the customers list code that appears to
display the last company in the list twice (minor issue right now, I
think, as long as everyone is aware of it and they don't go deleting the
customer thinking it's a  duplicate).

I currently don't have the time to write a migration script, but you
could do the following (in sql):
select company_name from addressbook; (output to a file)
Eliminate duplicate entries from this output.
Input the entries into the Customers table using any number of sql
import methods (Company Name is only required field) ID is autoinc).
Then you should be able to do a cross join to update the company_id
in the addressbook according to a match of the company_name from both
tables.

If your current addressbook isn't that large, just enter the customer
data manually, then you should be able to edit the addressbook entries
and set the company name from the drop downs.

As I mentioned in the last message, I am currently looking at a complete
changeover of how the customers list is used, and since 0.9.10 is also
going through major changes in the addressbook, it will be better that
way. So once that is completed, that should address items 1 and 2 that you
voiced.

_____________________________
Bob Schader
CAD Systems Admin
Product Design Intl., Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512
(616) 667-2600 x104

-----Original Message-----
From: Geoffrey Makstutis [mailto:gm...@51...]
Sent: Thursday, March 08, 2001 12:54 PM
To: bo...@pr...
Subject: working, but still a few questions


Bob,

I've got timetrack working with the addressbook. But only if I create a
whole new
installation. It looks like if you try to add Timetrack to an existing
installation
with a populated addressbook, you will lose all the addressbook entries.

This leads me to a couple of questions/suggestions (I hope I'm not being too
presumptuous. I'm trying to be helpful, honest...):

1. Under the current arrangement you could only ever have company names in
your
addressbook if they are also customers. Is this an unnecessary limitation?
It
precludes the possibility of suppliers and other types of entry in the
addressbook.

2. Do you need the link between customers and the addressbook to be so
'hard'?
Would it not be more efficient to have the option of creating a customer
from the
addressbook rather than a company from the customers?

I'm a fairly pedestrian PHP author, don't know classes very much, but I'd be
happy
to act as a tester for ongoing development and maybe help out on other
aspects
(graphics, design, etc.).

Regards,
Geoffrey

RE: [Phpgwtimetrack-developers] Addressbook problems (plus additional errata)

[Bob S. <bo...@pr...>]

Initial patch for addressbook is attached. It is the whole
index.php file from the addressbook directory. Place the
file into the <phpgroupware_dir>/addressbook directory.
I still need to also fix the view.php file in there to display
to company name properly.

I found the cause of this problem relates to the fact that
the SQL code I originally contributed to this code was doing
a cross join with a WHERE clause that specified 
WHERE addressbook.company_id = customers.company_id
this would fail if these weren't set, so I fixed it by
adding an "OR addressbook.company_id = ''", but then I
had to also test this id for 0 when printing the
company name. If it is zero, "Not Set" is printed in the
company field.

At some point, I would like to add a method to migrate any
older data, using the addressbook.company_name field to populate
the customers table, but I have also been toying with the idea
of redoing the whole customers schema to better match the iif
standard that Quickbooks uses for it's customers data, thereby
in essence reversing the current dependency of Timetrack on
addressbook code, instead focusing on the customers list, which
would then provide links to addressbook contacts inside the
customers list, instead of providing links to customers
inside the addressbook list. 

_____________________________
Bob Schader
CAD Systems Admin
Product Design Intl., Inc.
4880 36th St. SE, Suite 100
Grand Rapids, MI 49512
(616) 667-2600 x104