Issue with assets and moving them from matrix to grid

[robinsowell]

This isn't a bug, because the import shouldn't be destructive and I don't really have a good alternative for how this should work.

But in assets, the exp_assets_selections table has columns for field_id and col_id, which point to the old matrix field id and column id. So while the importer properly populates the grid table, the asset images don't show because that table looks at the wrong field/column.

You can manually change them once you're sure you want to use the grid field by updating to switch the matrix id/column with the grid one.

I'm really not sure there's a good fix for this in the importer, since you don't want it changing those values in the actual import.

[kevincupp]

The importer is supposed to create new records in that table with the correct field_id and col_id:

https://github.com/EllisLab/PlayaMatrixImporter/blob/master/el_playamatrix_importer/libraries/matrix_importer.php#L345

If it's not, then I don't know what's happening.

[robinsowell]

Hrm- I'm not sure where it went wrong then. I'll do some digging and see if I can find out whether the records went missing on the import or on the update or if there was something else that happened during the period the two database backups were made.

Thanks Kevin!