Search code examples
typo3tca

Remove unused fields (rename with prefix) / TCA Overrides

I customized the TCA of tt_address in my custom sitepackage. In EXT:my_package/Configuration/TCA/Overrides/tt_content.php I have this code, which works fine in the backend.

$GLOBALS['TCA']['tt_address']['types']['0'] = [
    'showitem' => '
        --palette--;LLL:EXT:tt_address/Resources/Private/Language/locallang_db.xlf:tt_address_palette.name;name,
        --palette--;LLL:EXT:tt_address/Resources/Private/Language/locallang_db.xlf:tt_address_palette.organization;organization,
        image,,
        --palette--;LLL:EXT:tt_address/Resources/Private/Language/locallang_db.xlf:tt_address_palette.address;address,        
        --palette--;LLL:EXT:tt_address/Resources/Private/Language/locallang_db.xlf:tt_address_palette.contact;contact,
        --palette--;;paletteHidden,    
        --div--;' . 'LLL:EXT:core/Resources/Private/Language/locallang_tca.xlf:sys_category.tabs.category, categories        
    '    
];

$GLOBALS['TCA']['tt_address']['palettes'] = [
    'name' => [
        'showitem' => 'gender, title,,--linebreak--,
            first_name, , last_name,--linebreak--,
            name,'
    ],
    'address' => [
        'showitem' => 'address, zip, city'
    ],    
    'organization' => [
        'showitem' => 'company'
    ],
    'contact' => [
        
        'showitem' => 'phone, mobile, fax, --linebreak--,
        email,  www,'
    ], 
    'paletteHidden' => [
        'showitem' => 'hidden',
    ],
];

$GLOBALS['TCA']['tt_address']['ctrl'] = [
    'label' => 'company'
];

If I analyze the database structure, most of the tt_address fields will be renamed respectively removed. But not all fields are unused. As you can see above the hidden field (on palletteHidden) is used and I need it in a fluid condition. So I didn't apply the changes on the database.

enter image description here

What do I have to adjust so that the database analysis no longer wants to adjust the table tt_address and all fields are retained?

What do I have to adjust so that the database analysis no longer wants to adjust tt_address and all fields are retained

Solution

  • Fields which should be added or dropped are identified by:

    • all combined ext_tables.sql files
    • dynamically fields which might be computed out of the $GLOBALS['TCA']['<tablename>']['ctrl'] section for fields like hidden, deleted, starttime, endttime, fe_group, ...
    • dynamically fields for category relations

    I guess you are removing/overriding parts of the $GLOBALS['TCA']['<tablename>']['ctrl']

    please check the configuration module to get some more hints.