How to add new attributes in Cutstomer Export CSV file in magento

Question

I want to add new attributes in Customer Export CSV file. My fields are date of birth and Gender.

I have added the below code in code/core/Mage/Adminhtml/Block/Customer/Grid.php

$this->addColumn('dob', array(
        'header'    => Mage::helper('customer')->__('Date of Birth'),
        'type'      => 'datetime',
        'align'     => 'center',
        'index'     => 'dob',
        'gmtoffset' => true
    ));
$this->addColumn('gender', array(
        'header'    => Mage::helper('customer')->__('Gender'),
        'index'     => 'gender'
    ));

In admin panel under manage customer it shows new files with same name but empty data and also in CSV file it added the title for both the fields but fields are empty.

How can i add new fields in customer export file in magento?

Marko Krstic Marko Krstic · Accepted Answer · 2014-10-10T07:41:27

instead of your gender code, put this:

$genders = $this->_getGenderOptions();
$this->addColumn('gender', array(
    'header'    => Mage::helper('customer')->__('Gender'),
    'index'     => 'gender',
    'type'      =>  'options',
    'options'   =>  $genders
));

then, in that Grid class create new method:

private function _getGenderOptions()
{
    $options = Mage::getResourceSingleton('customer/customer')->getAttribute('gender')->getSource()->getAllOptions();
    $array = array();

    foreach ($options as $option)
    {
        if($option['label'] == "")
            continue;

        $array[$option['value']] = $option['label'];
    }

    return $array;
}

and in the method

protected function _prepareCollection();

add by loading the collection:

->addAttributeToSelect('dob')
->addAttributeToSelect('gender')

it should look like:

$collection = Mage::getResourceModel('customer/customer_collection')
        ->addNameToSelect()
        ->addAttributeToSelect('email')
        ->addAttributeToSelect('dob') // new code
        ->addAttributeToSelect('gender') // new code
        ->addAttributeToSelect('created_at')
        ->addAttributeToSelect('group_id')
        ->joinAttribute('billing_postcode', 'customer_address/postcode', 'default_billing', null, 'left')
        ->joinAttribute('billing_city', 'customer_address/city', 'default_billing', null, 'left')
        ->joinAttribute('billing_telephone', 'customer_address/telephone', 'default_billing', null, 'left')
        ->joinAttribute('billing_region', 'customer_address/region', 'default_billing', null, 'left')
        ->joinAttribute('billing_country_id', 'customer_address/country_id', 'default_billing', null, 'left');

and that's it!

How to add new attributes in Cutstomer Export CSV file in magento

1 Answers