Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Export/Fieldmapping/change name =>empty colomn
 
arthur_scholten
Jr. Member
 
Total Posts:  19
Joined:  2013-01-28
 

Hi,

I’m creating an export profile that I can send to a price comparing website.To comply with the specified format of that website, I change the colomn name in the Fieldmapping section of the dataprofile. But when I change “imageurl” to “imageurl2” and run the profile, all results of only this colomn are empty. Other colomns will be filled. Changing back the name to “imageurl” repairs the problem, but then the colomn nam is not as I wish.

The same problem occures when I change the colomn name of a customfield.

 
Magento Community Magento Community
Magento Community
Magento Community
 
nickcarter21
Jr. Member
 
Total Posts:  23
Joined:  2013-04-02
 

Can you please post here the xml snippet that you are using in dataprofile ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
arthur_scholten
Jr. Member
 
Total Posts:  19
Joined:  2013-01-28
 

Here is the code:

Thanx
Arthur

<code>
<action type="catalog/convert_adapter_product" method="load">
<var name="filter/weight/from"><![CDATA[0.011]]></var>
<var name="filter/weight/to"><![CDATA[100000]]></var>
<var name="store"><![CDATA[1]]></var>
<var name="filter/qty/from"><![CDATA[1]]></var>
<var name="filter/qty/to"><![CDATA[100000]]></var>
<var name="filter/status"><![CDATA[1]]></var>
</action>

<action type="catalog/convert_parser_product" method="unparse">
<var name="store"><![CDATA[1]]></var>
<var name="url_field"><![CDATA[1]]></var>
</action>

<action type="dataflow/convert_mapper_column" method="map">
<var name="map">
<map name="sku"><![CDATA[sku]]></map>
<map name="name"><![CDATA[Producttitel]]></map>
<map name="finalprice"><![CDATA[finalprice]]></map>
<map name="imageurl"><![CDATA[imageurl]]></map>
<map name="url"><![CDATA[url]]></map>
<map name="gr_ean"><![CDATA[gr_ean]]></map>
<map name="short_description"><![CDATA[Beschrijving]]></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">export</var>
<var name="filename"><![CDATA[beslist.csv]]></var>
</action>
</code>

 
Magento Community Magento Community
Magento Community
Magento Community
 
nickcarter21
Jr. Member
 
Total Posts:  23
Joined:  2013-04-02
 

Please have a look on following code structure and get back to me if you feel any problem in solving -

<action type="catalog/convert_adapter_product" method="load">
<var 
name="filter/weight/from"><![CDATA[0.011]]></var>
<var 
name="filter/weight/to"><![CDATA[100000]]></var>
<var 
name="store"><![CDATA[1]]></var>
<var 
name="filter/qty/from"><![CDATA[1]]></var>
<var 
name="filter/qty/to"><![CDATA[100000]]></var>
<var 
name="filter/status"><![CDATA[1]]></var>
</
action>

<
action type="catalog/convert_parser_product" method="unparse">
<var 
name="store"><![CDATA[1]]></var>
<var 
name="url_field"><![CDATA[1]]></var>
</
action>

<
action type="dataflow/convert_mapper_column" method="map">
<var 
name="map">
<
map name="sku"><![CDATA[sku]]></map>
<
map name="name"><![CDATA[Producttitel]]></map>
<
map name="price"><![CDATA[finalprice]]></map>
<
map name="image"><![CDATA[imageurl2]]></map>
<
map name="url"><![CDATA[url]]></map>
<
map name="gr_ean"><![CDATA[gr_ean]]></map>
<
map name="short_description"><![CDATA[Beschrijving]]></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[export.csv]]></var>
</action>

I have analyzed the code structure twice and hope you get your answer in this .

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top