Anyone know of a way to convert an existing field from one type to another. At present, we create a new field and then use import/export or filters and mass updates to populate the new field before decommissioning the old field.
Hi Greg Barrass
Are you instance ondemand or onsite?
If it is ondemand you can ask SugarCRM support to provide you the backup of instance and database. Configure it on some server and use sql queries to convert data from one field to another. Write down the sql queries and ask SugarCRM support to run them into ondemand database.
If it is onsite then you can write down the sql queries as well and run them into database.
We were on site but changed to on demand recently. Understand using SQL is a solution, hoping that there was an add on that carried out the conversion process seamlessly. Looks like it is what it is. Just cumbersome to do a cleanup and not well received by customers when we advise what needs to be done.
Retrieving data ...