Date fields exported as NULL about cakephp-csvview HOT 10 CLOSED

I'm on the same page. Having trouble getting DATETIMES to export as well.

from cakephp-csvview.

Maybe its not being casted to a string properly?

from cakephp-csvview.

I got around this for now by creating a virtual field in my entity that returned as a string:

protected function _getCreatedString() {
return (string) $this->_properties['created']; }

Then I just used the created_string property with $_extract and it worked.

from cakephp-csvview.

What is the type of that field? Perhaps CsvView should cast everything to a string before exporting, though that might slow down performance.

from cakephp-csvview.

The created field is the typical nullable DATETIME that's compatible with the Timestamp behavior.

from cakephp-csvview.

Hi @kyleweishaupt how can I properly used the added virtual field at $_extract? Can you please post a sample code? I still getting a null value. Thanks!

from cakephp-csvview.

I found the issue and will provide a fix in a few minutes.

PS: Any idea why the default for NULL columns is actually 'NULL'? Shouldnt it rather be empty string?
Overwriting this every time is kind of a PITA.

from cakephp-csvview.

@aguirre1017 All I did was add the name of the virtual field in the $_extract array. Here's what mine looks like:

$_extract = [
'id', 
'user.full_name', 
'name',
'email',
'notes',
'follow_up_date_timestamp',
'created_timestamp',
'modified_timestamp'
];

So instead of using just the created field, I used created_timestamp that is being created in the entity class.

Here is the code in my entity:

protected $_virtual = [
    'follow_up_date_timestamp',
    'created_timestamp',
    'modified_timestamp'
];      

protected function _getFollowUpDateTimestamp()
{
    return (!empty($this->_properties['follow_up_date'])) ? (string) $this->_properties['follow_up_date'] : null;
}

protected function _getCreatedTimestamp()
{
    return (!empty($this->_properties['created'])) ? (string) $this->_properties['created'] : null;
} 

protected function _getModifiedTimestamp()
{
    return (!empty($this->_properties['modified'])) ? (string) $this->_properties['modified'] : null;
}

Hope this helps for you!

from cakephp-csvview.

This is a nice hack, but quite some overhead for an issue that maybe could be fixed in a more central place. Imagine you want to export multiple tables/entities.

from cakephp-csvview.

Resolved with my PR #55 .

from cakephp-csvview.