Problem with importing floating values
i'm trying to import latitude and longitude values from CSV file. These values have various length. DB column uses DECIMAL type and my TCA looks like:
'longitude' => array(
'exclude' => 1,
'label' => 'longitude',
'config' => array(
'type' => 'input',
'size' => 11,
'max' => 11,
'eval' => 'trim',
'default' => '0.00'
Not sure why but it doesn't import values after comma, so source value is for example 14,563235 and in database i have only 14.00000000
Any thoughts ?
Updated by Francois Suter over 6 years ago
- Status changed from New to Needs Feedback
- Assignee set to Francois Suter
It is not optimal, but I think it's the best solution. The limitation is really related to the TYPO3 Core and TCEmain in particular. It cannot be helped on the side of external_import. Are you okay with me closing this bug?