Magento高级配置文件导出-在URL之前添加IMAGE路径 [英] Magento advanced profiles export - Prepend URL to IMAGE path
问题描述
进入Magento仅仅两周,就设法使用Advanced Export Profiles(非常方便),我想做的是在输出列之一中添加url值,特别是图像url.我想将url附加到路径输出的开头.
Just a couple of weeks into Magento, managed to get going with the Advanced Export Profiles (Very Handy), What I would like to do is Prepend a url value to one of the output columns, specifically the image url. I would like to append the url to the beginning of the path output.
有人可以协助吗?
<action type="catalog/convert_adapter_product" method="load">
<var name="store"><![CDATA[0]]></var>
<var name="filter/price/from"><![CDATA[0.01]]></var>
<var name="filter/price/to"><![CDATA[999999]]></var>
<var name="filter/visibility"><![CDATA[4]]></var>
<var name="filter/status"><![CDATA[1]]></var>
</action>
<action type="catalog/convert_parser_product" method="unparse">
<var name="store"><![CDATA[0]]></var>
<var name="url_field"><![CDATA[0]]></var>
</action>
<action type="dataflow/convert_mapper_column" method="map">
<var name="map">
<map name="name"><![CDATA[ItemTitle]]></map>
<map name="upc"><![CDATA[EANBarCode]]></map>
<map name="description"><![CDATA[ItemTextDescription]]></map>
<map name="sku"><![CDATA[SKU]]></map>
<map name="qty"><![CDATA[StockLevel]]></map>
<map name="price"><![CDATA[CostPrice]]></map>
<map name="manufacturer"><![CDATA[Brand]]></map>
<map name="ebaycategory1"><![CDATA[eBayCategory1]]></map>
<map name="ebaycategory2"><![CDATA[eBayCategory2]]></map>
<map name="image"><![CDATA[Image1]]></map>
<map name="description"><![CDATA[ListingDescription]]></map>
<map name="name"><![CDATA[ListingTitle]]></map>
<map name="msrp"><![CDATA[OriginalRetailPrice]]></map>
<map name="conditionnote"><![CDATA[SellerNotes]]></map>
</var>
<var name="_only_specified">true</var>
</action>
<action type="dataflow/convert_parser_csv" method="unparse">
<var name="delimiter"><![CDATA[,]]></var>
<var name="enclose"><![CDATA["]]></var>
<var name="fieldnames">true</var>
</action>
<action type="dataflow/convert_adapter_io" method="save">
<var name="type">file</var>
<var name="path">var/export</var>
<var name="filename"><![CDATA[testing123.csv]]></var>
</action>
推荐答案
我刚刚注册,所以无法对Emi的答案发表评论.我要感谢他,因为他是对的,但是您也需要更改一小段代码.简而言之,这是我的解决方案.
I just registered, so I can not make a Comment on the Answer of Emi. I want to thank him, because he is right, but there is one small piece of Code you have to change too. Here is my solution in short.
I've also made a more detailed blog-entry in my private blog: https://www.timoschindler.de/vollstaendige-urls-in-dataflow-exportierten-csv-dateien-von-magento/ Unfortunately it is in German ;). If you have any Problems, just let me know and I can translate it.
首先,我添加了文件app/code/local/Mage/Dataflow/Model/Convert/Mapper/MyColumn.php
First I added the file app/code/local/Mage/Dataflow/Model/Convert/Mapper/MyColumn.php
<?php
class Mage_Dataflow_Model_Convert_Mapper_MyColumn extends Mage_Dataflow_Model_Convert_Mapper_Column
{
public function map()
{
$batchModel = $this->getBatchModel();
$batchExport = $this->getBatchExportModel();
$batchExportIds = $batchExport
->setBatchId($this->getBatchModel()->getId())
->getIdCollection();
$onlySpecified = (bool)$this->getVar('_only_specified') === true;
if (!$onlySpecified) {
foreach ($batchExportIds as $batchExportId) {
$batchExport->load($batchExportId);
$batchModel->parseFieldList($batchExport->getBatchData());
}
return $this;
}
if ($this->getVar('map') && is_array($this->getVar('map'))) {
$attributesToSelect = $this->getVar('map');
}
else {
$attributesToSelect = array();
}
if ($this->getVar('prepend') && is_array($this->getVar('prepend'))) {
$prepend = $this->getVar('prepend');
} else {
$prepend = array();
}
if (!$attributesToSelect) {
$this->getBatchExportModel()
->setBatchId($this->getBatchModel()->getId())
->deleteCollection();
throw new Exception(Mage::helper('dataflow')->__('Error in field mapping: field list for mapping is not defined.'));
}
foreach ($batchExportIds as $batchExportId) {
$batchExport = $this->getBatchExportModel()->load($batchExportId);
$row = $batchExport->getBatchData();
$newRow = array();
foreach ($attributesToSelect as $field => $mapField) {
$prepend_2 = isset($prepend[$field]) ? $prepend[$field] : '';
$newRow[$mapField] = isset($row[$field]) ? $prepend_2 . $row[$field] : null;
}
$batchExport->setBatchData($newRow)
->setStatus(2)
->save();
$this->getBatchModel()->parseFieldList($batchExport->getBatchData());
}
return $this;
}
}
然后我将app/code/core/Mage/Dataflow/Model/Convert/Profile/Collection.php复制到app/code/local/Mage/Dataflow/Model/Convert/Profile/Collection.php,如果在代码:
then I copied app/code/core/Mage/Dataflow/Model/Convert/Profile/Collection.php to app/code/local/Mage/Dataflow/Model/Convert/Profile/Collection.php and changed one if in the code:
/** @var $varNode Varien_Simplexml_Element */
foreach ($actionNode->var as $key => $varNode) {
if ($varNode['name'] == 'map') {
$mapData = array();
foreach ($varNode->map as $mapNode) {
$mapData[(string)$mapNode['name']] = (string)$mapNode;
}
$container->setVar((string)$varNode['name'], $mapData);
} else {
仅此而已!现在,一个简单的Dataflow XML看起来像:
Thats all! A simple Dataflow XML now looks like:
<action type="dataflow/convert_mapper_myColumn" method="map">
<var name="map">
<map name="sku"><![CDATA[Artikelnummer]]></map>
<map name="name"><![CDATA[Artikelbezeichnung]]></map>
<map name="image"><![CDATA[image]]></map>
</var>
<var name="prepend">
<map name="image"><![CDATA[https://www.bier-kaufen.de/media/catalog/product]]></map>
</var>
<var name="_only_specified">true</var>
</action>
这篇关于Magento高级配置文件导出-在URL之前添加IMAGE路径的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!