ezfloat attribute type decimals number ?

Author Message

H-Works Agency

Thursday 18 November 2010 8:46:04 am

Hello,

I am using ezfloat for an attribute but it seems to round floating numbers to 2 decimals.

Is this normal ? How to make it store three or more decimals ?

Thanx in advance for any help.

EZP is Great

Gaetano Giunta

Sunday 21 November 2010 1:43:49 pm

Not really sure, but you might find some related info here: http://issues.ez.no/IssueView.php?Id=15116&activeItem=30

Principal Consultant International Business
Member of the Community Project Board

H-Works Agency

Thursday 25 November 2010 3:31:46 am

Thanks but the topic you provide is about ezmultiprice, not about ezfloat.

Does anybody know how to store 3 decimals for ezfloat attribute ?

EZP is Great

Steven Bressey

Friday 26 November 2010 3:35:41 pm

Hi Martin,

I have the exact same problem : I need to store 3 decimals float numbers in many objects, but after saving my object and going back to edit it, I can only see a 2 decimals number.

I checked in the ezcontentobject_attribute table in the mysql database and the value is still stored with 3 decimals. That is at least reassuring.

What embarasses me more is that if I edit my object again (in order to change some other attribute value fo example), my float attribute value is stored with only 2 decimals in the database, if I forget to put the 3 decimals value AGAIN and everytime I wish to edit my object.

I think there is an issue here , so if anyone could tell us if there is a setting somewhere to force the attribute value in back office to show more than 2 decimals, it would be nice.

http://www.alma.fr

H-Works Agency

Sunday 28 November 2010 5:02:49 am

Hi Steven,

Yes the good news is that db value isn't rounded.

Rounding must then happen thru a template operator both in front and admin siteaccess.

That would explain why db value is rounded when you resubmit your object form.

I am gonna try to find the solution and will keep you informed.

EZP is Great

Steven Bressey

Sunday 28 November 2010 5:18:59 am

OK, thanks Martin.

I'll keep digging on my side too, and will keep you informed as well if I find anything interesting.

http://www.alma.fr

H-Works Agency

Wednesday 08 December 2010 7:13:40 am

Hello,

The problem is due to the l10n('number') transformation.

To modify number of digits you have two solutions :

- Tedious but clean : Overriding content/datatype/edit/ezfloat.tpl templates and removing "l10n('number')"

- Simpler but dirty : Editing ./share/locales/eng-GB.ini => [Numbers] FractDigits=4 (instead of 2 if you want 4 decimals).

Why dirty ? : In this case you edit an install wide variable. You thus can't override this variable on a per-siteaccess basis (which would be a great feature).

EZP is Great

Steven Bressey

Wednesday 08 December 2010 11:19:25 pm

Hi Martin,

Thanks a lot for the information. I chose the 2nd solution as I also have some calculated float fields which Id' like to show on the website with 3 decimals, and therefore needed to specify somewhere the number of decimals to show when using l10n function.

But it's true that I'd rather override the locale configuration (in my own extension for example, which would be the cleanest way) than edit the install variable.

Anyway, thank you for the solution.

http://www.alma.fr

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 29 2025 23:52:04
Script start
Timing: Jan 29 2025 23:52:04
Module start 'layout'
Timing: Jan 29 2025 23:52:04
Module start 'content'
Timing: Jan 29 2025 23:52:04
Module end 'content'
Timing: Jan 29 2025 23:52:04
Script end

Main resources:

Total runtime0.0163 sec
Peak memory usage2,048.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0075 588.2578151.2266
Module start 'layout' 0.00760.0026 739.484436.7031
Module start 'content' 0.01010.0049 776.1875102.1406
Module end 'content' 0.01500.0013 878.328141.9766
Script end 0.0163  920.3047 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002415.0007140.0002
Check MTime0.00116.5322140.0001
Mysql Total
Database connection0.00138.035910.0013
Mysqli_queries0.002515.361730.0008
Looping result0.00000.251410.0000
Template Total0.00095.810.0009
Template load0.00074.480510.0007
Template processing0.00021.268410.0002
Override
Cache load0.00053.236910.0005
General
dbfile0.001710.442880.0002
String conversion0.00000.048240.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs