Magento Forum

   
Page 1 of 3
How to use this extension? 
 
factfinder
Member
 
Avatar
Total Posts:  37
Joined:  2008-10-01
Pforzheim, Germany
 

This extension enables some modify functions, to change or extend the export data.
After installing this extension, nothing will happen first but from now on, you are able to use some more functions at the “Advanced Profiles” of the Dataflow Extension.

The easiest way to use this extension is this:
- create a simple export profile first at “System” > “Import/Export” > “Profiles”
- the profile should be an export profile
- configure the profile and click “Save and Continue Editing”
- a new tab appears labeled with “Profile Actions XML” => click it
- copy the whole XML code from the now visible textfield
- create a new advanced profile at “System” > “Import/Export” > “Advanced Profiles”
- insert the XML code you copied before into the textfield “Actions XML”
- each action of the export is defined at the XML tag “<action></action>”. The following XML code activates the Dataflow Extension. It contains all possible settings. The description for these tags you find afterwards.

<action method="unparse" type="exportextension/modifier">
    <var 
name="remove_line_breaks">true</var>
    <var 
name="remove_html_tags">true</var>
    <var 
name="add_categories">true</var>
    <var 
name="category_field_name">category</var>
    <var 
name="category_delimiter">#</var>
    
<var name="category_first_level">-1</var>
    <var 
name="category_path_delimiter"><![CDATA[>]]></var>
</
action>
- it is important, this XML block is set at the right position in the profile:
-- it should be placed afterwards the mapping action (<action type="dataflow/convert_mapper_column" method="map">)
-- and before the convert action (<action type="dataflow/convert_parser_..." method="unparse">)
- the whole profile could look like this:
<action type="catalog/convert_adapter_product" method="load">
    <var 
name="store"><![CDATA[4]]></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[4]]></var>
    <var 
name="url_field"><![CDATA[0]]></var>
</
action>

<
action type="dataflow/convert_mapper_column" method="map">
    <var 
name="map">
        <
map name="sku"><![CDATA[sku]]></map>
        <
map name="name"><![CDATA[name]]></map>
    </var>
    <var 
name="_only_specified">true</var>
</
action>

<
action method="unparse" type="exportextension/modifier">
    <var 
name="remove_line_breaks">true</var>
    <var 
name="remove_html_tags">true</var>
    <var 
name="add_categories">true</var>
    <var 
name="category_field_name">category</var>
    <var 
name="category_delimiter">#</var>
    
<var name="first_category_level">-1</var>
    <var 
name="category_path_delimiter"><![CDATA[>]]></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>
- after saving it, you can run the profile. The data file should be found at the configured direction


Short description of each setting for the Dataflow Extension
- remove_line_breaks: if the value of this tag is “true”, linebreaks will be removed from the content
- remove_html_tags: if the value of this tag is “true”, html tags will be removed from the content
- add_categories: if the value of this tag is “true”, each product will be extended with category names.
The following tags, are only used, if “add_categories” is “true”. They configure the additional category field:
- category_field_name: this value defines the used name of the category field. The default value of this tag is “category”. This tag is only expedient, if you export the fieldnames aor if you allready have another field with the defaultname “category”.
- category_delimiter: if a product is at more than one categories, each category will added and they will be delimited by this string. The default value is “#”.
- category_first_level: this value defines the level of the first exportable category. If it is 2 or greater, the first category names of the category tree won’t be added to the data. The values 1 and 0 are the same, because there is no level 0 - the root category has level 1. If the value is set to “-1”, only the proper category name will be added to the product. The default value of this tag is “1”.
- category_path_delimiter: if the category paths are exported (category_first_level is not -1), each category at the path will be delimited by this string. The default value is “>”. Example: catA1>catA2#catB1>catB2>catB3


PS: I hope my english is understandable. If you find any mistakes, write me a PM smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
factfinder
Member
 
Avatar
Total Posts:  37
Joined:  2008-10-01
Pforzheim, Germany
 

Two new features were added:

<var name="add_absolute_url_to_field">product_url</var>
    <var 
name="add_image_url_to_field">image_url</var>

Now it is possible to export the absolute product and image link:
- add_absolute_url_to_field; wit this tag you can set a field name, which will be used to add the absolute product link. if this field does not exists, it will be added. if it exists, it will be overwritten.
- add_image_url_to_field; this tag works at the same way, but exports the absolute image link.

 
Magento Community Magento Community
Magento Community
Magento Community
 
marioseq
Jr. Member
 
Total Posts:  2
Joined:  2010-04-07
 
Rudi@Omikron - 03 December 2009 01:58 AM

Two new features were added:

<var name="add_absolute_url_to_field">product_url</var>
    <var 
name="add_image_url_to_field">image_url</var>

Now it is possible to export the absolute product and image link:
- add_absolute_url_to_field; wit this tag you can set a field name, which will be used to add the absolute product link. if this field does not exists, it will be added. if it exists, it will be overwritten.
- add_image_url_to_field; this tag works at the same way, but exports the absolute image link.

hello,
where exactly do i add this added features
do i added to the the “Profile Actions XML” profile?

thank you for your help

 
Magento Community Magento Community
Magento Community
Magento Community
 
factfinder
Member
 
Avatar
Total Posts:  37
Joined:  2008-10-01
Pforzheim, Germany
 

Yes, just add them to the profiles XML as child tag from

<action method="unparse" type="exportextension/modifier">
, then it should work.

 
Magento Community Magento Community
Magento Community
Magento Community
 
K_R_P
Jr. Member
 
Total Posts:  9
Joined:  2009-03-21
Denmark
 

I installed the extension hoping to get a list og all category names with full multishop URLs with category ID number in the next column.
Would that be possible by adding a little bit more code?

Thanks for any help

 
Magento Community Magento Community
Magento Community
Magento Community
 
factfinder
Member
 
Avatar
Total Posts:  37
Joined:  2008-10-01
Pforzheim, Germany
 

This extension can’t be used to create a category export, because it just extends the product export from Magento. As far as I know, even the Dataflow module from Magento does not support category exports.
Maybe there is another module for this issue?

 
Magento Community Magento Community
Magento Community
Magento Community
 
blitux
Jr. Member
 
Total Posts:  8
Joined:  2009-12-15
 

Hi,

I’ve tried to import the exported data, but it just don’t import the categories I have on the origin.

Is there another additional thing to do? Do I need to set up mappings or something like that?

Thanks.

 
Magento Community Magento Community
Magento Community
Magento Community
 
factfinder
Member
 
Avatar
Total Posts:  37
Joined:  2008-10-01
Pforzheim, Germany
 

Hi.
this is just an export-extension. It’s made to export data for price comparison services, search-services or other external services.
So it’s not possible to import the exported data with this extension again.
Sorry.

 
Magento Community Magento Community
Magento Community
Magento Community
 
seb2nim
Jr. Member
 
Total Posts:  28
Joined:  2008-11-19
 

Warning : in case of multi-store, there is an issue with category export :

Catogory export takes each category tree where product is mentioned. So even if you built an export for store A, and a product is both presented in store A and B, category export will output :
Root A>MyCategoryInStoreA and Root B>MyCategoryInStoreB

 
Magento Community Magento Community
Magento Community
Magento Community
 
factfinder
Member
 
Avatar
Total Posts:  37
Joined:  2008-10-01
Pforzheim, Germany
 

Hi.
Thanks for the notice. I’ve done some researches, but didn’t get a solution how to get the store id during the export.
Do somebody know a solution? Otherwise I will just continue searching. smile
Cheers.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brady
Guru
 
Avatar
Total Posts:  330
Joined:  2007-09-10
Orange County, CA
 

Magento 1.3.2.4 & Multiple Store Setup

Couple things I noticed:
Basically I want to pull in default Magento data, but full image URLs instead of relative URLs.

I use the code mentioned above, but can only get it to work if I include the categories too, which I don’t want to do. Also, when it pulls in the URL, it adds “https://” instead of just “http://”. Not a big deal to find & replace in Excel, but just a little annoyance.

Thanks for the extension!

 
Magento Community Magento Community
Magento Community
Magento Community
 
comodo
Jr. Member
 
Total Posts:  25
Joined:  2007-12-13
 

It works.

 
Magento Community Magento Community
Magento Community
Magento Community
 
realsmack
Jr. Member
 
Total Posts:  3
Joined:  2010-02-11
 

Love it.

Works just as advertised. However, can I get rid of the “Categories>” that precedes the category output?

 
Magento Community Magento Community
Magento Community
Magento Community
 
osbstores
Jr. Member
 
Total Posts:  1
Joined:  2010-08-09
 

I am trying desperately to use this but I have installed this other extension on my magento store that imports and exports all the fields in a store as well as all the categories.  So it will not add this info to it.  Anyone got a work about?

The product I have is from http://www.jc-websolutions.com/products-services/magento-services/magento-bundled-import-export-extension.html

I love it but I also want to use this new bit of info to pull the categories and such out.

Thanks for any help you can offer.

Rhonda Morin

 
Magento Community Magento Community
Magento Community
Magento Community
 
gaborabc
Jr. Member
 
Total Posts:  10
Joined:  2010-08-28
 

Hi,

It’s great tool, but I have a problem, if i export the product’s, the product URL I think is wrong:

http://www.domain.com/index.php/admin/catalog/product/view/id/1/s/canon-eos-5d-mark-ii-body/

How can I correct it?

Thanks!
Gabor

 
Magento Community Magento Community
Magento Community
Magento Community
 
solvium
Jr. Member
 
Total Posts:  2
Joined:  2010-10-14
Münster, Germany
 

Got the same problem as Gabor over here. Any solution for this, yet?

Apart of that, works like a charm!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
Page 1 of 3