如何将自定义属性添加到客户导出的CSV

debugcn 发表于 Dev

Zaheerabbas

我为customer.custom有4个自定义属性。我想在导出时将其添加到csv中。我仅将其添加到网格中以进行导出，但似乎无法正常工作。创建了csv，但数据未填充到csv中。以下是在grid.php中用于csv导入的代码。

       if ($this->_isExport) { 
     $this->addColumn('contact_job_title', array(
    'header' => Mage::helper('customer')->__('Contact Job Title'),
    'index'  => 'contact_job_title',
));
 $this->addColumn('contact_seq_no', array(
    'header' => Mage::helper('customer')->__('Contact Seq No'),
    'index'  => 'contact_seq_no',
));
$this->addColumn('debtor_acc_no', array(
    'header' => Mage::helper('customer')->__('Debtor Acc No'),
    'index'  => 'debtor_acc_no',
));
$this->addColumn('debtor_api_key', array(
    'header' => Mage::helper('customer')->__('Debtor Api Key'),
    'index'  => 'debtor_api_key',
));
    }

任何帮助将不胜感激。

Zaheerabbas

好吧，我找到了答案

只需添加属性以选择

protected function _prepareCollection()
{
    $collection = Mage::getResourceModel('customer/customer_collection')
        ->addNameToSelect()
        ->addAttributeToSelect('email')
         ->addAttributeToSelect('debtor_api_key') /* added attribute */
         ->addAttributeToSelect('contact_job_title')  /* added attribute */
         ->addAttributeToSelect('contact_seq_no')  /* added attribute */
         ->addAttributeToSelect('creditstatus')  /* added attribute */
         ->addAttributeToSelect('debtor_acc_no')  /* added attribute */
        ->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');

    $this->setCollection($collection);

    return parent::_prepareCollection();
}

和addcolumn仅用于导出

if ($this->_isExport) { 
        $this->addColumn('debtor_api_key', array(
            'header' => Mage::helper('customer')->__('Debtor Api Key'),
            'index'  => 'debtor_api_key',
        ));
        $this->addColumn('contact_job_title', array(
            'header' => Mage::helper('customer')->__('Contact Job Title'),
            'index'  => 'contact_job_title',
        ));
        $this->addColumn('contact_seq_no', array(
            'header' => Mage::helper('customer')->__('Contact Seq No'),
            'index'  => 'contact_seq_no',
        ));
        $this->addColumn('creditstatus', array(
            'header' => Mage::helper('customer')->__('Creditstatus'),
            'index'  => 'creditstatus',
        ));
        $this->addColumn('debtor_acc_no', array(
            'header' => Mage::helper('customer')->__('Debtor Acc No'),
            'index'  => 'debtor_acc_no',
        ));
    }