Magento

Good day,

I’m just dropping this to the community for testing purposes. This script imports categories trough a CSV file. It is not the fastest, but does it’s job.

See attachment for full details (source, original documentation and working examples).

Import Categories.zip  (File Size: 175KB - Downloads: 953)

Thank you for publsihing. I did install it into the magento folder structure with no result. Checked the fiile rights, changed it to 777 and no result. There is no entity if i add a new import profile, just Products or Customers.
I did check the database, there was no tabe created. So I did check the files. There are two files under local > Postbeeld >importcatalogs>Model>Mysql4:
Importcatalogs.php
and Importcatalogs>Collection.php
Both files contain just: ÿÿÿÿÿÿÿÿÿÿÿ
Maybe that is the error for not showing under Profiles.

My apologies if it doesn’t function at this moment. I dropped this here just to release it as soon as possible. I currently do not have the time to setup a testserver and test it myself.

Does the attached screenshot help you?

The module can be found at System -> Import/Export -> Import Categories.

Click thumbnail to see full-size image

doesn’t show up after install. I think it goes without saying that people would rather have working than quick.

I’ll look in to it as soon as i can find the time for it and try to make a complete working package. I’ll keep you posted.

To give you an estimate about it’s speed, it does about a line per second when you have a lot of categories (if you have a few, it only takes a second for 10 lines).

I found out what’s wrong, it’s the config file under:

It must be named

hey paul,

can this script handle updates to existing categories?

cheers
brendan

Sure it can, just make sure the admin-name of the category remains the same.

There’s an error in the Log.php file that gives me an error in 1.3.2

Change:

postbeeld/importdbproducts/edit/tabs/log.phtml

to:

postbeeld/importcatalogs/edit/tabs/log.phtml

The Import Categories link under Import/Export wouldn’t open otherwise.

Still waiting to test a csv, but so far so good.

Thanks

I’ve included the previously mentioned fixes posted in this threat.

Installation
- Merge the contents of the magentofolder with your magentoinstallation
- Make sure cache is disabled
- Logout and Login

To test with the files:
- Create a category with category_id = 4 and a category with category_id = 5.
- Create 5 storeviews with the storeviewcodes: nl, en, fr, es and de.

(i’ve updated one of the testfiles, removed some languages.)

Import Categories.zip  (File Size: 215KB - Downloads: 850)

HI Paul,

thank You for publishing the new module version. Works like a charm.

Hi,

I’m running 1.3.2.4 and am getting the following when I run the profile:

Warning: fopen(/var/www/vhosts/incego.com/httpdocs/m/atago/var/catalog_reports/catalog_log_2010_02_23_18_46_23.html) [function.fopen]: failed to open stream: No such file or directory in /var/www/vhosts/incego.com/httpdocs/m/atago/app/code/local/Postbeeld/Importcatalogs/controllers/Adminhtml/ImportcatalogsController.php on line 653
Trace:
#0 [internal function]: mageCoreErrorHandler(2, ‘fopen(/var/www/...’, ‘/var/www/vhosts...’, 653, Array)
#1 /var/www/vhosts/incego.com/httpdocs/m/atago/app/code/local/Postbeeld/Importcatalogs/controllers/Adminhtml/ImportcatalogsController.php(653): fopen(’/var/www/vhosts...’, ‘a+’)
#2 /var/www/vhosts/incego.com/httpdocs/m/atago/app/code/local/Postbeeld/Importcatalogs/controllers/Adminhtml/ImportcatalogsController.php(101): Postbeeld_Importcatalogs_Adminhtml_ImportcatalogsController->_logProduct(’?runAction()
#4 /var/www/vhosts/incego.com/httpdocs/m/atago/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(248): Mage_Core_Controller_Varien_Action->dispatch(’run’)
#5 /var/www/vhosts/incego.com/httpdocs/m/atago/app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#6 /var/www/vhosts/incego.com/httpdocs/m/atago/app/Mage.php(459): Mage_Core_Controller_Varien_Front->dispatch()
#7 /var/www/vhosts/incego.com/httpdocs/m/atago/index.php(65): Mage::run()
#8 {main}

Thanks for your help.

Please tell me this has the ability to set meta data and meta keywords for each category?

Hi!

I load the module fitted, but I can not load a csv file, csv my sample has the following form

csv:
“store”,"parent”,"identifier”,"name”,"is_active”,"url_key”,"description”,"image”,"pagetitle”,"is_anchor"
“website_base”,"58”,"libro01”,"libro01”,"1”,"libro01”,"libro01”,"”,"”,"1"
“store_catalan”,"”,"libro01","Modelauto’s postvervoer”,"”,"”,"”,"","Modelauto’s postvervoer","”
“store_castellano”,"”,"libro01","Car models postal transport”,"”,"”,"”,"","Car models postal transport","”

and the error is
Invalid row data format.

In csv also proved that store did not have “, for example
website_base,"58”,"libro01”,"libro01”,"1”,"libro01”,"libro01”,"”,"”,"1"
as as in your example.

Other question, support this module, adding new attributes?, by request of customer, the category has additional attributes to the default given by magento

Any idea???

Thank you so much!

After almost two years away from Magento I am about to dive back in and give it another try. Incredibly I see that the folks at Magento, Inc. have still not written a category import option. WTF? REALLY?

Is the Categories Import Module in this thread working yet?

Browsing through Magento Connect I see a few people selling Category Import/Exporter extensions but none of them have any reviews and none of them show any screencasts of them in use. Has anyone tried any of them?

Hi Pezomatic,

I’ve recently used it successfully in one of our recent projects, that was a Magento 1.4 installation. I currently have a lot on my plate, so am not responding so much to the questions.

As for support for the extra fields, it currently only supports the following fields:
store
parent
identifier
name
is_active
url_key
description
image
pagetitle
is_anchor

Although it shouldn’t be to hard to add some additional fields.

Open up the following file: app/code/local/Postbeeld/Importcatalogs/controllers/Adminhtml/ImportController.php and go to line 385. There you see the coldata being parsed. It shouldn’t be to difficult to add some extra cols. I haven’t got time to test it out right now, maybe sometime in the future.