Forums

Switch between attribute type

Permalink
Hi there,

Is it possible (and how) to change between 2 attribute types? I make a new attribute type based on the select attribute. I want to keep all the relations from the default select attribute ( i also kept the same DB structure ) so that should work i theorie. I probably need to change some ID's in the DB directly but i don't know which to change. Please help me out ;).
brianvandelden
 
Mainio replied on at Permalink Reply
Mainio
This is not allowed straight in the UI because if it was, every attribute type should write a conversion method from type A to type B which would add a massive overhead for their purpose. And this wouldn't even be possible because there are bunch of custom attribute types as well.

For simple attribute types that use the same attribute type tables and have same relation tables, you can do this just by swapping the "atID" column from "AttributeKeys" table. From your explanation it seems like this is the case.

E.g. I recently did this for a text attribute that I needed to switch to "Letterco Advanced Text" and that was easy because they both have their values in the atDefault table, so the update didn't mess anything up.
Mainio replied on at Permalink Reply
Mainio
By the way just re-thinking aloud: this could be possible also in the UI in this kind of situation if there was a way to check that both of the attribute types use the same table and have exactly the same kind of relations.