Topic: Timesheet app

[Jeff C]

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

[ralph]

Hi Jeff,

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

cheerio,

Ralph

[Jeff C]

Ralph,

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

-jeff

[Charlie Brady]

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

[guestHH]

Hi Jeff,

http://www.achievo.org/

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

Regards,
guestHH

[Jeff C]

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

[Jeff C]

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

[guestHH]

restarted httpd ?

[guestHH]

sorry, you did I see... let me think here....

[guestHH]

Did you import the mysql Achievo tables tables?

[Jeff C]

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

[Bill Talcott]

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...

[Jeff C]

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

[brian read]

I'd also be interested in a howto.

Cheers

Brian

[guestHH]

what template Jeff?

Regards,
guestHH

[Michael Doerner]

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

[Jeff C]

Michael,

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

I will work on a howto over the weekend.

Thanks!

-jeff

[guestHH]

Ok got it Jeff, I totally missed your template posting earlier. That's why I didn't understand your question.

Regards,
guestHH

[Jeff C]

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

[Bill Talcott]

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...

[Jeff C]

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