csv.ctp.php

<?php
    // the view to create csv's
    $a = array_keys( ClassRegistry::init( Inflector::singularize( $this->name ) )->_schema );
    $needed = array(
        Inflector::singularize( $this->name ) => $a
    );

    $row = array();

    if ( !empty( $data ) )
    {
        foreach( $needed[key( $needed )] as $head )
        {
            $parts[] = Inflector::humanize( str_replace( '_id', '', $head ) );
        }

        $row[] = implode( ',', $parts );

        foreach( $data as $k => $array )
        {
            $parts = array();

            foreach( $array[key( $needed )] as $field => $value )
            {
                if ( $field != 'id' )
                {
                    if ( strpos( $field, '_id' ) && in_array( $field, $needed[key( $needed )] ) )
                    {
                        $parts[] = $array[Inflector::camelize( str_replace( '_id', '' , $field ) )][ClassRegistry::init( Inflector::camelize( str_replace( '_id', '' , $field ) ) )->displayField];
                    }

                    else if ( in_array( $field, $needed[key( $needed )] ) )
                    {
                        $parts[] = $value;
                    }
                    else
                    {
                        $parts[] = '';
                    }
                }
            }

            $row[] = implode( ',', $parts );
            unset( $parts );
        }
    }

    $csv = implode( "\n", $row );
    echo $csv;
?>