[TYPO3-english] $TCA configuration

[Dmitry Dulepov]

Hi!

Tomaz Zaman wrote:
> I need it to sync categories with those that i have in SugarCRM, where
> categories are solved like this. Each category has an id, a name and a
> code. and in the users table there is a field that holds category codes
> in a CSV, not uids.
> I've imported those categories to TYPO3, and i want category codes in
> the relation field, not uids, just like SugarCRM

If you want to manage it all with TYPO3, you have to use uids. There is no other way.

If I were you, I would import SugarCRM categories to a separate table. This table should have these fields:
- uid (TYPO3)
- pid (TYPO3)
- title (from SugarCRM, also a TYPO3 label for the record)
- sugarcrm_id
- sugarcrm_code

This is a good solution because:
- it allows updates of SugarCRM categories to TYPO3 (add, delete, modify)
- it will show SugarCRM category title in the List module
- it will show SugarCRM category title in TYPO3 forms
- you can get category codes easily. Example: SELECT sugarcrm_code FROM tx_myext_sugarcrm_categories WHERE uid IN (SELECT sugarcrm_categories FROM fe_users)

Does this help?

-- 
Dmitry Dulepov
Facebook: http://www.facebook.com/dmitryd
Twitter: http://twitter.com/dmitryd
Skype: liels_bugs