Change Datatype of Fields

[blendo]

Hi @ projoectmanagement team,

i change the database field types of

estimated_effort
and
actual_effort

into float.
I had to change it in the ProjectTasks/vardefs.php, too.

Now i can type in half hours as 0.5 or 15 minutes as 0.25

Greets blendo

[intersol]

This change itţs a MUST. It should be integrated into the CVS:

[kimvette]

This change itţs a MUST. It should be integrated into the CVS:

I agree. Any reasonable company bills in quarter-hour increments.

[kimvette]

(this is 4.0.1)

Changed: the schema for estimated and actual effort to float (5,3) for max of 99,999 hours and 999 % of and hour

Changed: ../ProjectTask/vardefs.php (data entry validation) to validate for a 'float' rather than an 'int' for estimated and actual effort form field submissions

Changed: ../ProjectTask/EditView.html to allow entry of 9 characters and size of 10 for the estimated and actual effort input controls

We allowed for nine digits - five to the left of the decimal and four to the right, because very large software projects may require tens of thousands of hours (with sub-tasks obviously taking less). Not allowing fractions of an hour is bad so you would obviously want to allow at least tenths and hundredths of an hour to enter .25. .50, etc. and likewise some companies may bill in five-minute or ten-minute increments depending on the nature of the business. Two additional decimal places (total of four): because they're there; no harm in allowing them.

Change:

vardefs.php:
line 191 and
line 197 from 'int' to 'float'

Change:

EditView.html:
line 163 and
line 188
attributes changed from size="5" maxlength="4"
size="10" maxlength="9"

Change:
Database Table: project_task
columns: `estimated_effort` and `actual_effort`
data type: from `int` to `float(5,3)`

[ryansa]

good job. i like the way.

[cywolf]

ryansa: Please stop posting these inane responses. You should only post when you have something useful to add.

[neusagudo]

In our case, a MUST would be to be able to see project tasks and tasks in calendar. We are coordinating many trainers for technical courses (every course is a project) . Every project task is a session, and we need to know the calendars out teachers are doing.

Right now it cannot be done, but just making the project tasks visible from calendar view would solve that and would be wonderful for keeping track of your trainers avaiability!!!

Neus Agudo
neus.agudo@apif.info

[Generic]

Hello,

I'm using SugarCRM OpenSource v. Version 4.5.0g (Build 1234) at the moment but I would like to update to the most current version.

I followed the instructions in this thread and my users work with the decimal amounts. So I'm wondering what happens to my customized installation if I apply the patch? Do I have to re-apply changes in the files or does the installer check if they were changed? I checked the database update script and at least those 2 customized fields seem not to be changed.

I would be happy if anybody of you with such an customized installation would share his experience with updating SugarCRM, esp. if the installation could break...

Thank you kindly,
Generic

[dotcomguy]

(this is 4.0.1)
Change:

vardefs.php:
line 191 and
line 197 from 'int' to 'float'

Change:

EditView.html:
line 163 and
line 188
attributes changed from size="5" maxlength="4"
size="10" maxlength="9"

Change:
Database Table: project_task
columns: `estimated_effort` and `actual_effort`
data type: from `int` to `float(5,3)`

Thanks for posting this. The patch works great!

[hamedu139]

please help me in update sugarCRM OpenSource v. Version 4.5.0g (Build 1234)