The M-Files Community will be updated on Tuesday, April 2, 2024 at 10:00 AM EST / 2:00 PM GMT and the update is expected to last for several hours. The site will be unavailable during this time.

This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Change the data type of existing property

Hi All,

What is the best move to do when you want to change the data type of an existing property definition?

In this case our client created a property with a data type Number (integer) after a year they noticed that there's a limitation when using number integer and they want to change the data type to a text. In M-Files rules it cannot modify the data type of a property definition that already has a value in more objects.

Is there a way to transfer all the existing values in metadata card into new property definition?

Any suggestions are appreciated.

Thank you!

-Mess

Parents
  • This is one option to copy values to a text property using built-in functionality:

    1. Create the new property definition
    2. In the Automatic Values tab, set simple concatenation and add the existing property as a placeholder
    3. Add the text property to the class(es) where the number property is used
    4. Recalculate the automatic value of the text property
    5. Go back to the property definition settings and remove the automatic value setting ("No automatic value"). Now it's a normal user-defined property.

    Note that if there can be objects from other classes where users have added that number property to the object metadata manually (i.e. not coming from class settings), you need to deal with these separately.

  • Hi Joonas,

    Got it. I really appreciate the information and advice you have shared.

    Cheers!!

    -Mess

Reply Children
No Data