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

Page 11 of 12
Export & import categories
 
joharabroune
Jr. Member
 
Total Posts:  6
Joined:  2011-01-03
 

Export data flow path name of the class or I wrote a small detail. Add some tags to the XML file is developed, you can add categories of products to export.

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

I am using this script to import the categories and it is going well so far but i cannot work out how to make it import the meta tags, descriptions, page titles and url keys. I looked at the script and it would appear that this is something not included or am i just being stupid? Is there anyone else that has editied their script to do this and if so could they share it?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Barbados
Member
 
Total Posts:  32
Joined:  2008-09-04
 

this extension work like a charm in Magento ver. 1.5.0.1, At least I can import export configurable product!
but in version Magento ver. 1.4.0.1
only Export Profiles
Category
Categories are show no Export
Export Settings

Thus I am unable to export anything.

Edit: Ok Im confused about export.
This extension only export categories ?

Can someone explain how Ive managed to import/export configurable product ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
buzbuzzer
Jr. Member
 
Total Posts:  29
Joined:  2008-11-24
 
Barbados - 15 February 2011 05:51 PM

this extension work like a charm in Magento ver. 1.5.0.1, At least I can import export configurable product!
but in version Magento ver. 1.4.0.1
only Export Profiles
Category
Categories are show no Export
Export Settings

Thus I am unable to export anything.

Edit: Ok Im confused about export.
This extension only export categories ?

Can someone explain how Ive managed to import/export configurable product ?

Yes, it is added functionality from 1.5.0.1, and is not associated to this extension itself.  So the reason importing configurable products is not in 1.4.0.1 or even 1.4.2 is because it did not exist for those releases.

This extension just happens to append the same Admin page.

 
Magento Community Magento Community
Magento Community
Magento Community
 
kamaljoshi
Member
 
Avatar
Total Posts:  46
Joined:  2011-01-11
Ahmedabad
 

Thx guys, This really works.

 
Magento Community Magento Community
Magento Community
Magento Community
 
sfcadmin
Jr. Member
 
Avatar
Total Posts:  7
Joined:  2010-04-12
Baltimore, MD
 

If anyone is still looking for help importing or exporting categories, we offer a paid extension which comes with support which is capable of importing and exporting categories with all category attributes and details.

Magento Category Import Export Extension

 
Magento Community Magento Community
Magento Community
Magento Community
 
rjsherman
Jr. Member
 
Total Posts:  1
Joined:  2011-03-11
 

sfcadmin, does it work with 1.5.01?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Kurman
Jr. Member
 
Avatar
Total Posts:  2
Joined:  2011-02-28
 
Stefy - 30 March 2009 03:27 PM

Hi all..
somebody can help me please?…
I have always this error
“ Method “parse” not defined in adapter catalog/convert_adapter_category “

I’m crazying.... :(

Thank you…

1. Make Sure you installed the ImpCat in a right way, please follow

this

2. disable and enable cache

3. disable compile which is in System->Tools->compilation
then Run Compilation Process again

most of people forget the 3rd options.

Enjoy!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Kurman
Jr. Member
 
Avatar
Total Posts:  2
Joined:  2011-02-28
 
Shawn - 12 March 2011 01:35 AM

sfcadmin, does it work with 1.5.01?

it works fine with 1.5.01
smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
Fisheye
Jr. Member
 
Avatar
Total Posts:  4
Joined:  2009-11-23
 

We have a good paid for module with full support, which allows you to assign specific category ID’s whilst importing, useful for moving your catalogue from one site to another. Also import all normal Category Attributes, inc images, meta display etc.

Find out more about our Magento Category Import / Export Module here.

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Dezire
Jr. Member
 
Total Posts:  9
Joined:  2009-11-05
 

Hi everybody,

I need Help!

how i do this? i need export all the products in stock and I need the following information

I’d like to export the whole name of the category, not just the numbers of them

Name;Url;Sku;Manufacturer;Ean;categories

How i do that export?

Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
oe_eduardo
Jr. Member
 
Avatar
Total Posts:  29
Joined:  2011-02-03
London
 

Hi,

I know 3 ways to export the categories:

1 using the import export utility
http://www.magentocommerce.com/wiki/import-export_and_data_manipulation/import-export

2 using the api

//create soap object
$proxy = new SoapClient(’http://your.domain.com/api/soap?wsdl’);

// create authorized session id using api user name and api key
// $sessionId = $proxy->login(’apiUser’, ‘apiKey’);
$sessionId = $proxy->login(’yourUser’, ‘yourKey’);

$magResult = $allCategories = $proxy->call($sessionId, ‘category.tree’);

//print_r (array_to_csv($magResult));

echo ‘<pre>’;
print_r($magResult);
echo ‘<pre>’;

3- using the Mage::getModel

require_once ‘yourPathTo\app\Mage.php’;
Mage::app();

$category = Mage::getModel ( ‘catalog/category’ );
$tree = $category->getTreeModel ();
$tree->load ();

$ids = $tree->getCollection ()->getAllIds ();

if ($ids) {
$file = “../var/import/catwithid.csv”;
file_put_contents($file,"catId, catName\n");
foreach ( $ids as $id ) {
$string = $id . ‘, ‘ .$category->load($id)->getName() . “\n”;
file_put_contents($file,$string,FILE_APPEND);
}
}

Hope that help,

I know i have to learn the Dataflow Profiles to import export al least as a way of respect to the magento people that made lot of efort to have a nice open functionality to import export.

probably i will today....

edu

 
Magento Community Magento Community
Magento Community
Magento Community
 
talvinder
Jr. Member
 
Total Posts:  3
Joined:  2011-12-13
 

Hii

PLz help, when i import I got the following error

<br /> <font size=\’1\’><table class=\’xdebug-error\’ dir=\’ltr\’ border=\’1\’ cellspacing=\’0\’ cellpadding=\’1\’> <tr><th align=\’left\’ bgcolor=\’#f57900\’ colspan=\"5\"><span style=\’background-color: #cc0000; color: #fce94f; font-size: x-large;\’>( ! )</span> Fatal error: Call to undefined method ImpCat_Catalog_Model_Convert_Adapter_Category::getStoreById() in D:\\wamp\\www\\magento_practice\\app\\code\\local\\ImpCat\\Catalog\\Model\\Convert\\Adapter\\Category.php on line <i>42</i></th></tr> <tr><th align=\’left\’ bgcolor=\’#e9b96e\’ colspan=\’5\’>Call Stack</th></tr> <tr><th align=\’center\’ bgcolor=\’#eeeeec\’>#</th><th align=\’left\’ bgcolor=\’#eeeeec\’>Time</th><th align=\’left\’ bgcolor=\’#eeeeec\’>Memory</th><th align=\’left\’ bgcolor=\’#eeeeec\’>Function</th><th align=\’left\’ bgcolor=\’#eeeeec\’>Location</th></tr> <tr><td bgcolor=\’#eeeeec\’ align=\’center\’>1</td><td bgcolor=\’#eeeeec\’ align=\’center\’>0.0004</td><td bgcolor=\’#eeeeec\’ align=\’right\’>381512</td><td bgcolor=\’#eeeeec\’>{main}( )</td><td title=\’D:\\wamp\\www\\magento_practice\\index.php\’ bgcolor=\’#eeeeec\’>..\\index.php<b>:</b>0</td></tr> <tr><td bgcolor=\’#eeeeec\’ align=\’center\’>2</td><td bgcolor=\’#eeeeec\’ align=\’center\’>0.0040</td><td bgcolor=\’#eeeeec\’ align=\’right\’>749768</td><td bgcolor=\’#eeeeec\’>Mage::run( )</td><td title=\’D:\\wamp\\www\\magento_practice\\index.php\’ bgcolor=\’#eeeeec\’>..\\index.php<b>:</b>80</td></tr> <tr><td bgcolor=\’#eeeeec\’ align=\’center\’>3</td><td bgcolor=\’#eeeeec\’ align=\’center\’>0.0174</td><td bgcolor=\’#eeeeec\’ align=\’right\’>1979152</td><td bgcolor=\’#eeeeec\’>Mage_Core_Model_App->run( )</td><td title=\’D:\\wamp\\www\\magento_practice\\app\\Mage.php\’ bgcolor=\’#eeeeec\’>..\\Mage.php<b>:</b>640</td></tr> <tr><td bgcolor=\’#eeeeec\’ align=\’center\’>4</td><td bgcolor=\’#eeeeec\’ align=\’center\’>0.6601</td><td bgcolor=\’#eeeeec\’ align=\’right\’>10754552</td><td bgcolor=\’#eeeeec\’>Mage_Core_Controller_Varien_Front->dispatch( )</td><td title=\’D:\\wamp\\www\\magento_practice\\app\\code\\core\\Mage\\Core\\Model\\App.php\’ bgcolor=\’#eeeeec\’>..\\App.php<b>:</b>349</td></tr> <tr><td bgcolor=\’#eeeeec\’ align=\’center\’>5</td><td bgcolor=\’#eeeeec\’ align=\’center\’>0.6670</td><td bgcolor=\’#eeeeec\’ align=\’right\’>11144872</td><td bgcolor=\’#eeeeec\’>Mage_Core_Controller_Varien_Router_Standard->match( )</td><td title=\’D:\\wamp\\www\\magento_practice\\app\\code\\core\\Mage\\Core\\Controller\\Varien\\Front.php\’ bgcolor=\’#eeeeec\’>..\\Front.php<b>:</b>176</td></tr> <tr><td bgcolor=\’#eeeeec\’ align=\’center\’>6</td><td bgcolor=\’#eeeeec\’ align=\’center\’>0.6751</td><td bgcolor=\’#eeeeec\’ align=\’right\’>11726832</td><td bgcolor=\’#eeeeec\’>Mage_Core_Controller_Varien_Action->dispatch( )</td><td title=\’D:\\wamp\\www\\magento_practice\\app\\code\\core\\Mage\\Core\\Controller\\Varien\\Router\\Standard.php\’ bgcolor=\’#eeeeec\’>..\\Standard.php<b>:</b>250</td></tr> <tr><td bgcolor=\’#eeeeec\’ align=\’center\’>7</td><td bgcolor=\’#eeeeec\’ align=\’center\’>0.8376</td><td bgcolor=\’#eeeeec\’ align=\’right\’>14125856</td><td bgcolor=\’#eeeeec\’>Mage_Adminhtml_System_Convert_ProfileController->batchRunAction( )</td><td title=\’D:\\wamp\\www\\magento_practice\\app\\code\\core\\Mage\\Core\\Controller\\Varien\\Action.php\’ bgcolor=\’#eeeeec\’>..\\Action.php<b>:</b>420</td></tr> <tr><td bgcolor=\’#eeeeec\’ align=\’center\’>8</td><td bgcolor=\’#eeeeec\’ align=\’center\’>0.8500</td><td bgcolor=\’#eeeeec\’ align=\’right\’>14656168</td><td bgcolor=\’#eeeeec\’>ImpCat_Catalog_Model_Convert_Adapter_Category->saveRow( )</td><td title=\’D:\\wamp\\www\\magento_practice\\app\\code\\core\\Mage\\Adminhtml\\controllers\\System\\Convert\\ProfileController.php\’ bgcolor=\’#eeeeec\’>..\\ProfileController.php<b>:</b>250</td></tr> </table></font>

 
Magento Community Magento Community
Magento Community
Magento Community
 
amitsamsukha
Jr. Member
 
Avatar
Total Posts:  3
Joined:  2011-02-28
 

HI ..
thanks for this Extension
its working fine for Category Import.
But in case i didn’t specify store than the Function used
$store = $this->getStoreById($this->getBatchParams(’store’));
is not working because ”$this->getBatchParams(’store’)” gives 0 hmmm

In this case we have to use the default Store like
$store = Mage::app()->getStore();

it works in any condition.. smile

so my suggestion is to Use

if (empty($importData['store'])) {
            
if (!is_null($this->getBatchParams('store'))) {
//                $store = $this->getStoreById($this->getBatchParams('store'));
                
$store Mage::app()->getStore(); // get Default Store in this case.
            
else {
                $message 
Mage::helper('catalog')->__('Skip import row, required field "%s" not defined''store');
                
Mage::throwException($message);
            
}
        } 
else {
            $store 
$this->getStoreByCode($importData['store']);
        
}
 
Magento Community Magento Community
Magento Community
Magento Community
 
neit
Jr. Member
 
Total Posts:  18
Joined:  2010-06-16
 

Hello

I have been looking at this over the last few weeks
and santhosh script with a small modification was able
to import 46000 categories for version Magento ver. 1.6.2.0
but it appears to killed the front end and nothing but shop banners
appears now. This may be related to the number of categories, i’m not sure.

When I try to export this catgories i get the following:

Starting profile execution, please wait…
Warning: Please do not close the window during exporting data
Starting export profile execution.
Loaded 45832 records

But the data records do not export, the categories.csv file is created
in the export folder but with no data.

Any advice would be great.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 11 of 12