[TYPO3-dev] DAM fields not migrated to FAL?

[Fabian Thommen]

Quite an old post, but i'am working at a DAM to FAL migration.

I'm using dam_falmigration.

"copyright" field:

In tx_dam there is a "copyright" field, which is not there in filemetadata in TYPO3 6.2 and so not converted. This copyright field is showing up again in filemetadata in TYPO3 7 LTS

See here: forge.typo3.org/issues/67319 and git.typo3.org/Packages/TYPO3.CMS.git/commit/2dc1bdf

But if you migrated from DAM to FAL you can map this later, because there is a field "_migrateddamuid" in  sys_file glue the entries to the old DAM table "tx_dam":

sys_file._migrateddamuid=tx_dam.uid

So using this SQL statment you can migrate it, after adding the copyright field to the  sys_file_metadata:

"UPDATE sys_file_metadata,sys_file,tx_dam SET sys_file_metadata.copyright=tx_dam.copyright  WHERE sys_file._migrateddamuid=tx_dam.uid AND sys_file_metadata.file=sys_file.uid"

For the ident field I wrote an extension, which adds it to sys_file_metadata, ext key is taywa_filemetadata_ident

using this statement:

 "UPDATE sys_file_metadata,sys_file,tx_dam SET sys_file_metadata.ident=tx_dam.ident  WHERE sys_file._migrateddamuid=tx_dam.uid AND sys_file_metadata.file=sys_file.uid"