TYPO3 Core

Hi,

Quite old feature request but... :-)

I'm able to show records from a MSSQL database with legacy tables that have nothing to do with TYPO3 (no uid, pid, or other columns). I did this:

- Created a tca.php with some fields of my 'Members' table
- Created a ext_tables.php
- Mapped pid to '1' (sysfolder/page with uid = 1) and uid columns to my primary key ('MemberID')

Configuration looks like that:

$TYPO3_CONF_VARS['EXTCONF']['dbal']['mapping'] = array(
'Members' => array(
'mapFieldNames' => array(
'pid' => '1',
'uid' => 'MemberID',
),
),
);

tca.php looks like that:

$TCA['Members'] = array(
'ctrl' => $TCA['Members']['ctrl'],
'interface' => array(
'showRecordFieldList' => 'firstname,lastname,email'
),
'feInterface' => $TCA['Members']['feInterface'],
'columns' => array(
'firstname' => array(
'exclude' => 0,
'label' => First Name',
'config' => array(
'type' => 'input',
'size' => '20',
'max' => '20',
'eval' => 'required,trim',
)
),
'lastname' => array(
'exclude' => 0,
'label' => 'Last Name',
'config' => array(
'type' => 'input',
'size' => '30',
'max' => '30',
'eval' => 'required,trim',
)
),
'email' => array(
'exclude' => 0,
'label' => 'Email',
'config' => array(
'type' => 'input',
'size' => '30',
'max' => '50',
'eval' => 'trim',
)
),
),
'types' => array(
'0' => array('showitem' => 'firstname;;;;1-1-1, lastname, email')
),
'palettes' => array(
'1' => array('showitem' => '')
)
);

Finally ext_tables.php looks like that:

$TCA['Members'] = array(
'ctrl' => array(
'title' => 'MEMBERS',
'label' => 'lastname',
'tstamp' => 'NOW',
'crdate' => 'NOW',
'cruser_id' => '0',
'default_sortby' => 'ORDER BY lastname',
'dynamicConfigFile' => t3lib_extMgm::extPath($_EXTKEY) . 'tca.php',
'iconfile' => t3lib_extMgm::extRelPath($_EXTKEY) . 'member.gif',
),
);

Records are shown but edit does not (yet) work. Furthermore, 'pid' cannot be mapped onto '0' (root).

Trick to be able to see DB values into the edit form is to use proper case in tca.php. For instance 'FirstName', 'LastName' instead of the default lowercase generated by kickstarter.

Problem is then to have a way to "unmap" invalid columns such as "tstamp" if they cannot be mapped to anything meaningful in the external database (and possibly map then back to some default value as I did "NOW" when SELECTing content from database.

Hi xavier,

When you use this trick, are you able to use ts object content and ts object records as if the records would have real pids and uids?

Hi Michael,

Did not try many things actually ;-)

But this was more to say that it already kinda exists and that we may hopefully build something on top of that instead of reinventing yet another special feature.