Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Jeff C on August 08, 2002, 07:26:07 PM

Title: Timesheet app
Post by: Jeff C on August 08, 2002, 07:26:07 PM
I have a client who is looking for a simple timesheet app to track hourly workers.  Nothing fancy, just tracking and basic reports.

Any suggestions?

-jeff
Title: Re: Timesheet app
Post by: ralph on August 08, 2002, 07:45:33 PM
Hi Jeff,

yepp, phproject ( c. contrib howtos on www.e-smith.org or www.star-support.com/downloads/mitel/contrib... )

cheerio,

Ralph
Title: Re: Timesheet app
Post by: Jeff C on August 08, 2002, 07:56:47 PM
Ralph,

phpProjekt is a great tool but way overkill for this client.  Any other ideas?

-jeff
Title: Re: Timesheet app
Post by: Charlie Brady on August 08, 2002, 08:48:31 PM
Jeff C wrote:
>
> I have a client who is looking for a simple timesheet app to
> track hourly workers.  Nothing fancy, just tracking and basic
> reports

http://freshmeat.net/search?q=timesheet

Charlie
Title: Re: Timesheet app
Post by: guestHH on August 08, 2002, 08:57:11 PM
Hi Jeff,

http://www.achievo.org/

very cool, it's in use in out office.

Regards,
guestHH
Title: Re: Timesheet app
Post by: Jeff C on August 08, 2002, 10:41:16 PM
RequestedDeletion,

Achievo looks like just the ticket for us.  Any hints or tips on install?

Would you mind sharing your template files with me via email?

Thanks - jeff
Title: Re: Timesheet app
Post by: Jeff C on August 09, 2002, 03:22:52 AM
I have installed Achievo and the mysql databases.  I built a template called 93Achievo and put it in:

/etc/e-smith/templates-custom/etc/conf/httpd.conf

The text in the template is:

#-------------------------------------------
# Achievo-0.8.1
#-------------------------------------------

Alias /achievo /opt/achievo-0.8.1


    Options -Indexes
    AllowOverride None
    order allow,deny
    allow from all
    AddType application/x-httpd-php .php .php3
    php_flag  magic_quotes_gpc  off
    php_flag  track_vars        on

#------------------------------------------------

I then do: /sbin/e-smith/expand-template /etc/e-smith/htppd.conf
and restart httpd

When I point a browser to https://server/achievo I get a file not found error.

Any clues?

-jeff
Title: Re: Timesheet app
Post by: guestHH on August 09, 2002, 03:39:00 AM
restarted httpd ?
Title: Re: Timesheet app
Post by: guestHH on August 09, 2002, 03:39:56 AM
sorry, you did I see... let me think here....
Title: Re: Timesheet app
Post by: guestHH on August 09, 2002, 03:42:47 AM
Did you import the mysql Achievo tables tables?
Title: Re: Timesheet app
Post by: Jeff C on August 09, 2002, 04:14:12 AM
I threw all the files in an ibay just to check it out and it's working fine.  Looks like a pretty cool product.

I'm confused. :<

Cheers,

-jeff
Title: Re: Timesheet app
Post by: Bill Talcott on August 09, 2002, 06:37:56 PM
Hmmmm, this looks pretty cool. Any chance you could do a step-by-step HowTo for us newbies? I wasn't really looking for something like this, but after seeing it, it might come in handy...
Title: Re: Timesheet app
Post by: Jeff C on August 09, 2002, 07:04:59 PM
Bill,

I'll be glad to do the howto as soon as I get it running :>

I am still having no luck with the template fragment.  Once that is done, the rest is easy.

-Jeff
Title: Re: Timesheet app
Post by: brian read on August 09, 2002, 07:05:30 PM
I'd also be interested in a howto.

Cheers

Brian
Title: Re: Timesheet app
Post by: guestHH on August 09, 2002, 07:10:59 PM
what template Jeff?

Regards,
guestHH
Title: Re: Timesheet app
Post by: Michael Doerner on August 10, 2002, 02:07:32 AM
Jeff,

>
I built a template called 93Achievo and put it in:
/etc/e-smith/templates-custom/etc/conf/httpd.conf
<

shouldn't this be
/etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf ?

and
>
/sbin/e-smith/expand-template /etc/e-smith/htppd.conf<

should be:
/sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf ?

Regards,
Michael
Title: Re: Timesheet app
Post by: Jeff C on August 10, 2002, 09:24:46 AM
Michael,

That did the trick.  I simply was playing in the wrong sandbox.

I will work on a howto over the weekend.

Thanks!

-jeff
Title: Re: Timesheet app
Post by: guestHH on August 10, 2002, 12:44:56 PM
Ok got it Jeff, I totally missed your template posting earlier. That's why I didn't understand your question.

Regards,
guestHH
Title: Re: Timesheet app
Post by: Jeff C on August 11, 2002, 04:19:31 AM
HF,

You still hold a place of esteem in my world :>

I can easily build an rpm to place all the files and fragments, but I'm no programmer and don't know how to do the mysql database stuff from a spec file.

If someone can help me with that piece I am sure I can build an rpm.

-jeff
Title: Re: Timesheet app
Post by: Bill Talcott on August 15, 2002, 12:30:31 AM
While an RPM would make things easier, I'd almost prefer a HowTo (if it's versioned stuff). I like to know how to do things, rather than depending on someone else to package up the new version when it comes out...
Title: Re: Timesheet app
Post by: Jeff C on August 15, 2002, 09:53:12 AM
Here is the mini howto for installing Achievo on an SME 5.1.2 server.  

The folks at http://www.achievo.org have an excellent and very easy howto to do the basic install.  Follow their instructions carefully and it will work first time.  Those instructions are at:  

http://www.achievo.org/support/manual/installation/

I suggest untarring the achievo file to /opt/achievo-0.8.1 instead of their suggestion.

Once untarred, follow the steps in the howto to create the mysql database and user.  I use phpMyAdmin to do the actual database and user creation but the instructions given will allow you to do it manually if you don't have phpMyAdmin.

To template this for an SME box follow the next steps:

# mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf
# cd /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf
# pico 93Achievo

Then insert the following text, making sure the paths are correct.

#-------------------------------------------
# Achievo-0.8.1
#-------------------------------------------

Alias /achievo /opt/achievo-0.8.1


Options -Indexes
AllowOverride None
order allow,deny
allow from all
AddType application/x-httpd-php .php .php3
php_flag magic_quotes_gpc off
php_flag track_vars on

#------------------------------------------------

Save and exit, then:

# /sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
# service httpd restart

That's all there is to it.  You should now have a working app in http://yourdomain.com/achievo

Hope this helps....

-jeff