Yetiforcecrm: Change a field from text to currency

[liviubbo]

Hy all !

Can i change a text field that ALREADY has values in it (only numbers) to be a currency field and not deleting the data in it?
Example : i have a entry that has a text field and value 33. I want to change it to currency field that doesnt change the value 33, only the field type. I need this for reports. I have made a mistake when i implemented Yetiforce and i didnt realise that i need currency type field for that. Now i have about 400 entries and i cannot create a report because it`s text field.

[vovpff]

@liviubbo I think you can change field UItype and typeofdata for this field in vtiger_fields database table but you mast be very carefull

[liviubbo]

Thanks! i will try it on local first. THX

[vovpff]

@liviubbo another one solution: Add new currency field and transfer data from text field to this new one by SQL. After that you can remove text. In this case I don't know what happens with text field history data.

[liviubbo]

I guess i will do the second one. :) Its safer.