Make database fields from fields that live in serialized fields

Make database fields from fields that live in serialized fields


Sparse, or serialized fields do not live as a column in the database table. Instead, their values are stored in JSON arrays in a separate field. As a result, these fields cannot be searched or sorted by.

If such a sparse field is created as 'manual', this module can unserialize the field. Its field definition and values will then be migrated to a proper database column. A real life use case where you encounter many of such fields is the Magento-OpenERP connector.

For technical reasons, many2many and one2many fields are not supported.