topic Re: How to safely change property type? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-safely-change-property-type/m-p/250641#M203771 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>some time ago I have similar issue and I solved it in rather no very safe way but it seems to work normally.</SPAN><BR /><BR /><SPAN>The solution is that you should change the property to double in the model, before you run alfresco you must change values in database (you should write sql statements to copy values from float column to double column and change it type in database in alf_properties table). You should also set index.recovery.node to FULL so all lucene indicies are rebuild.</SPAN><BR /><BR /><SPAN>The problem is that you can loose some precision any way, since float can't hold some values which double can.</SPAN><BR /><BR /><SPAN>Anyway you can also try to write some action in java which reads Float from properties and then writes Double to property back, but I didn't check this solution.</SPAN><BR /><BR /><BR /><SPAN>Thanks</SPAN><BR /><SPAN>smicyk</SPAN></BODY></HTML> Sat, 06 Nov 2010 19:13:45 GMT smicyk 2010-11-06T19:13:45Z How to safely change property type? https://connect.hyland.com/t5/alfresco-archive/how-to-safely-change-property-type/m-p/250640#M203770 Hi everyone!I have a problem in my Alfresco customization. I created my custom content model and i set a property type to float instead of double. Now Alfresco rounds all the values stored in it. For example i have the value 12521.56 and he shows me 12521.6.So the solution would be to change the dat Sat, 06 Nov 2010 11:25:40 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-safely-change-property-type/m-p/250640#M203770 irinuca13 2010-11-06T11:25:40Z Re: How to safely change property type? https://connect.hyland.com/t5/alfresco-archive/how-to-safely-change-property-type/m-p/250641#M203771 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>some time ago I have similar issue and I solved it in rather no very safe way but it seems to work normally.</SPAN><BR /><BR /><SPAN>The solution is that you should change the property to double in the model, before you run alfresco you must change values in database (you should write sql statements to copy values from float column to double column and change it type in database in alf_properties table). You should also set index.recovery.node to FULL so all lucene indicies are rebuild.</SPAN><BR /><BR /><SPAN>The problem is that you can loose some precision any way, since float can't hold some values which double can.</SPAN><BR /><BR /><SPAN>Anyway you can also try to write some action in java which reads Float from properties and then writes Double to property back, but I didn't check this solution.</SPAN><BR /><BR /><BR /><SPAN>Thanks</SPAN><BR /><SPAN>smicyk</SPAN></BODY></HTML> Sat, 06 Nov 2010 19:13:45 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-safely-change-property-type/m-p/250641#M203771 smicyk 2010-11-06T19:13:45Z