MantisBT - v2.0 Release (Closed)
View Issue Details
0000449v2.0 Release (Closed)[All Projects] Generalpublic2010-05-25 08:552010-06-21 21:11
Reporteradolfo 
Assigned Tocaseydk 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Versionv2.0.0 
Summary0000449: budget field format
DescriptionNot valid format in budget field.

My configuration is 12.345.678,90 EUR a the language is Spanish 'es'

Please see attach file
TagsNo tags attached.
related to 0000459closed caseydk budget field format 
child of 0000440closed caseydk Various Bug's 
Attached Filespng budget.png (140,265) 1969-12-31 16:00
https://bugs.web2project.net/file_download.php?file_id=87&type=bug
png

Notes
(0000898)
caseydk   
2010-05-25 10:11   
Are you really using v1.0?
(0000900)
adolfo   
2010-05-25 11:29   
No, Version 2.0.0-pre

Now I see the Project field, (must be select before send the issue).

sorry.

I'm working directly with Version 2.0.0-pre, to test it.
(0000902)
adolfo   
2010-05-28 07:20   
(Last edited: 2010-05-29 00:24)
one more thing,

If edit field budget with 1.750,00 and save it the project, later w2p show 1.75

(0000903)
adolfo   
2010-05-29 00:27   
The problem is in the database, because I'm try change it directly and don't permit update with comma "123.456.789,00" and always take dot as decimal point.

I have utf_8 and utf8_spanish_ci y project database.
(0000907)
caseydk   
2010-05-29 10:45   
The system interprets it in the "American notation" where thousands are denoted with commas and the dot is the decimal point. I'm not sure of a better way to approach this at the moment.

What standards are there for these notations?
(0000916)
adolfo   
2010-05-30 23:53   
All Europe use this notation 123.456.789,00 €

I thought you were using the currency format of the user's preferences to display the amounts in W2P, I think that is a good way, like most applicantions do.
(0000921)
caseydk   
2010-05-31 11:35   
Yes, displaying things in a particular format is the easy part..

The difficult part is processing your input properly so it gets stored properly.
(0000930)
adolfo   
2010-05-31 23:27   
(Last edited: 2010-06-01 00:48)
Please visit this pages.

http://www.entrebits.cl/foros/temas-generales/7586-validar-la-entrada-de-un-campo-numerico-y-dar-formato-al-resultado.html
http://www.php.net/manual/en/function.number-format.php
http://webcoder.info/downloads/validate.html
http://www.merlyn.demon.co.uk/js-valid.htm


I think that the solution or posible solution are inside.

(0000939)
caseydk   
2010-06-02 20:44   
The core functionality is wired in r1132-1133.

If your CURRENCYFORM value is set properly, it should work as designed. I've also added scrubbing on the input side of things to make sure they're stored properly in the database.

Issue History
2010-05-25 08:55adolfoNew Issue
2010-05-25 08:55adolfoFile Added: budget.png
2010-05-25 10:11caseydkNote Added: 0000898
2010-05-25 11:29adolfoNote Added: 0000900
2010-05-25 12:17caseydkRelationship addedchild of 0000440
2010-05-25 12:17caseydkProjectv1.0 Release (Closed) => v2.0 Release (Closed)
2010-05-28 07:20adolfoNote Added: 0000902
2010-05-29 00:24adolfoNote Edited: 0000902
2010-05-29 00:27adolfoNote Added: 0000903
2010-05-29 10:45caseydkNote Added: 0000907
2010-05-30 23:53adolfoNote Added: 0000916
2010-05-31 11:35caseydkNote Added: 0000921
2010-05-31 23:27adolfoNote Added: 0000930
2010-06-01 00:16adolfoNote Edited: 0000930
2010-06-01 00:20adolfoNote Edited: 0000930
2010-06-01 00:28adolfoNote Edited: 0000930
2010-06-01 00:48adolfoNote Edited: 0000930
2010-06-02 20:44caseydkNote Added: 0000939
2010-06-02 20:44caseydkStatusnew => resolved
2010-06-02 20:44caseydkResolutionopen => fixed
2010-06-02 20:44caseydkAssigned To => caseydk
2010-06-04 11:10caseydkRelationship addedrelated to 0000459
2010-06-21 21:11caseydkStatusresolved => closed
2010-06-21 21:11caseydkFixed in Version => v2.0