RSS
Home Forum v3
Welcome, Guest
Please Login or Register.    Lost Password?
Com-Property Forum
Modules
Last Properties

Total Area
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Total Area
#1487
Total Area 2 Years, 1 Month ago Karma: 0
Hi! I am located in USA and really appreciate the wonderful work!
I have one question regarding the Total Area: Because in Europe we use m2 here it is used Acres (ac). That is easy to change but the problems is the numeric value that it is hard coded.
we can do 2 m2 but cannot do 0,27 ac.

Is there a way to bypass this problem?

Thank you very much!
jptferreira
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1501
Re:Total Area 2 Years, 1 Month ago Karma: 0
similar problem with total area in Asia, what I did is manually change the database value type with phpMyAdmin and it will allow you to input decimals
djmagic
Junior Boarder
Posts: 22
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1515
Re:Total Area 2 Years, 1 Month ago Karma: 0
Please don't call me lazy.... Can you give me the table and field so I can perform the change? That was a very good catch! Thanks!
jptferreira
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#1516
Re:Total Area 2 Years, 1 Month ago Karma: 0
Sorry.... I just did it and it worked great. I have to learn not to be lazy. It is weekend and I was planning to take a break but it was really easy to find the field and change it.
Thanks a lot!
jptferreira
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#6764
Re:Total Area 1 Year, 6 Months ago Karma: 1
Can anybody from you, explain how you solve that , because i face the same problem.
Thanks a lot in advance
debonair86
Fresh Boarder
Posts: 11
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#6768
Re:Total Area 1 Year, 6 Months ago Karma: 59
change in DB via phpmyadmin
area
covered_area
from integer to decimal

ALTER TABLE `jos_properties_products` CHANGE `area` `area` DECIMAL( 5, 2 ) NOT NULL
ALTER TABLE `jos_properties_products` CHANGE `covered_area` `covered_area` DECIMAL( 5, 2 ) NOT NULL
administrator
Admin
Posts: 544
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#6773
Re:Total Area 1 Year, 6 Months ago Karma: 1
Great thx so much
debonair86
Fresh Boarder
Posts: 11
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#9391
t 1 Year ago Karma: 0
temistinoh
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2011/05/02 14:29 By administrator.
The administrator has disabled public write access.
 
Go to topPage: 1
Com-Property Forum
Modules
Last Properties
Powered by Kunenaget the latest posts directly to your desktop