Use forums at sourceforge please

These forums are depricated, please use the forums at sourceforge.

These forums are depricated; please use the sourceforge forums ›
Submitted by rob on 14 December 2008 - 1:16pm
Tags:
»

Comments

#1 Fabien

Hi,
I've posted here twice about a topic without any answers. Anyway, I'm trying again... Its concerns the possibility to make a link between absence and working day in order to avoid the possibility to field hours if the day was noticed as an absence. Is it possible ?
Thanks a lot to give me a direction.
Fabien

9 Mar 2009 - 4:08pm

#2 tommo

I don't check here very often for messages, I prefer http://sourceforge.net/forum/?group_id=215962

I have asked Rob to merge these (or close this down), without success so far...

10 Mar 2009 - 8:56am

#3 andretenreiro

Hello,

I already have users with normal authentication and they already inserted data.

Now, I want those users to authenticate with LDAP but without losing any data.

What is the best way to accomplish this migration without compromising any data?

Thanks!

19 Feb 2009 - 8:57pm

#4 tommo

Changing to LDAP affects the authenication only. That is, to login the LDAP password is checked not the one stored in the timesheet DB.

So your existing users should map to LDAP users, and as long as they can do this then their data is safe.

10 Mar 2009 - 8:45am

#5 Fabien

Hi everyone,

As Tommo said before I add Bank holidays directly into the absences table (public entry, no user set).

I have set for each user the start page as the simple timesheet. I would like to know if there is any way to not allowing any action by user if a bank holiday is already added ? Because at the moment I can add working hours even if I have noticed an absence or holiday or bank holiday ! Is it possible to "freeze" a day if it is bank holiday ?

Thanks !

17 Feb 2009 - 11:23am

#6 tommo

No, it is not possible to freeze a day.

I don't think in general it is a good idea, in fact on the hours report this is shown separately because often "overtime" worked at weekends or bank holidays is treated specially.

10 Mar 2009 - 8:49am

#7 andretenreiro

Hello!

How can I set for each user his Holidays (hours) in the manner I can see the "Remaining Holidays" decreasing when user makes joy of its holidays hours?

16 Feb 2009 - 8:34pm

#8 tommo

With the limitation that users work 8 hours per working day, then this is implemented using the absence page and its reports.

10 Mar 2009 - 8:47am

#9 Fabien

Hi,
I have set up timesheet, it's working very well and fit nicely to my needs. I would like to know :
1/ if it is possible to set bank holidays for 2009, 2010 for all users ?
2/ if it is possible to set a kind of alert when an user put to much hours in a day, or how to define a maximum of working hours in a day and so on...
Thanks you very much
Fabien

13 Feb 2009 - 11:57am

#10 tommo

Bank holidays have to be added into the absences table (public entry, no user set). This can only be done by an SQL command in version v1.3.1. Look in svn /trunk/dev to get an example SQL script.

No there are no alerts, and no way to define a maximum hours per day.

13 Feb 2009 - 1:45pm

#11 Fabien

Thank you Tommo. I did it.
I have set for everyone the start page as the simple timesheet. So, now is there any way to not allowing any action by user if a bank holiday is added ? Because at the moment I can add working hours even if I have noticed an absence or holiday or bank holiday ! Is it possible to "freeze" a day if it is bank holiday ?

16 Feb 2009 - 10:08am

#12 kickingtires

using MySQL 5.0.51a , MyISAM vanilla install and getting the following:
"ERROR 1364 (HY000) at line 19: Field 'ssl_cipher' doesn't have a default value"

just to see if I could work around it, I removed the not null constraint on the user table for that and the x509 fields, but then got:

"ERROR 1292 (22007) at line 129: Incorrect date value: '' for column 'start_date'
at row 1

An unexpected error occured when creating the tables. Please report this."

Could you give me a pointer in right direction?

thanks

5 Feb 2009 - 8:11am

#13 kickingtires

the first error was a result of strict SQL being enable in default MySQL 5 install. To get past, go to MySQLAdmin->Startup Variables->Advanced->Various->SQL Mode and uncheck the box.

5 Feb 2009 - 11:47pm

#14 louie

We get the following error. Please help.

it doesn't compile

Parse error: syntax error, unexpected '{' in /var/www/html/ts/table_names.inc on line 1

THANK YOU SO MUCH FOR BRINGING THIS BACK TO LIFE......

2 Feb 2009 - 3:57pm

#15 rob

Hi Louie,

What version of PHP are you running? AFAIK Timesheet NG is only "stable" with PHP4.

We are looking to upgrade it to PHP 5 - will be in branch 1.4.x

Cheers
Rob

4 Feb 2009 - 1:49pm