Magento

Hi there,

the skript seems to be just working for a small amount of data in the CSV files.
I tried to work with it and smaller files (up to 100) seem to work fine, but if I want to import a larger amount it seems to work at first (importer said everything is successfull), but after the import I can’t open the category administration anymore. I get an error 500 and it’s just fixable by importing my SQL-backup to the database.

I would appreciate if any one could help me with that.

Thanks,
Mathis

PS: I use 1.4.2 at the moment

Den Markin - 24 November 2011 01:15 AM

opacons - 29 September 2011 11:01 PM

I’m trying to get this extension working with 1.6. The export seems to work fine, but when I import the csv file, as exported, I get the error “Path provided is not a valid one.” for each category.

Any ideas?

Your root category should be active and has the same name as in source store. This extension uses path traversing by category name matching, so if it doesn’t find parent category by name, it fails.

Hi,

Firstly, a massive thank you to Santhosh and the other advice given - it’s helped me get on in leaps and bounds and I’m very grateful. If ever there was a newbie, I’m it!

But...now I’m getting exactly the same ‘Path provided is not a valid one’ result as quoted above each time I try to import categories and I believe I’ve followed all the advice correctly. Did you ever solve the problem?

Any input would be appreciated, thank you.

Brightondan

@Brightondan
Lets take this example:

You have a computer store, so you have these root categories in your magento store:
Hardware
-> displays
-> keyboards
Software
-> operating systems

So with your CSV you want to import some categories “LG Displays” (displays) and “Logitech” (keyboards) into hardware and “Microsoft” into software:

So that’s what a basic CSV could look like:

That is what you get in the magento backend:

Hardware
-> displays
------> LG Displays
-> keyboards
------> Logitech
Software
-> operating systems
------> Microsoft

Thanks Santhosh!

Worked on 1.6.2

I had to do a minor change in this file:
app\code\local\Santhosh\Import\Block\Adminhtml\Import.php

I changed the three occurrences of the javascript variable import to import1
so it works with the latest Firefox.

i have the same problem with my magento theme , thank you very much for helping me

Hello All -

I’m new to magento and about to tackle this extension. But before I do, does it allow me to import the url key, full description, page title, meta keywords and meta description fields?

hankgerard - 23 April 2012 04:46 PM

Hello All -

I’m new to magento and about to tackle this extension. But before I do, does it allow me to import the url key, full description, page title, meta keywords and meta description fields?

Hello,

yes, all include,
fields;
Name,Path,Is Active,Url Key,Description,Image,Page Title,Meta Keywords,Meta Description,Include In Menu,Display Mode,CMS Block,Is Anchor,Availabe Sort By,Default Sort By,Page Layout,Custom Layout Update

after install and export (.../magento.../var/export/catergory/catergories.csv) or import (/...magento.../var/import/catergory/catergories.csv)

Thank you for your response!

hello all..can someone help me fnd Categories.csv file?  a file with that name does not exist on my machine and I dont seem to see one on the forum.

in other words, i dont know to format the csv...what column names, layout of file, etc..

i love this extension it is a must for anyone working with thousands of sku’s/cats.  i use it on a few sites including enterprise, just installed it on 1.7 as well and have no issues.

Hello All!

I downloaded Santhosh’s zip folder with the module.
Copied all the files from the folder in the same exact locations as suggested.
Deleted cache.
Refreshed the dataflow import page in admin.

And I see NO link to import the categories.

Am I missing a step? Is there something that needs to be tweaked?

Using ver. 1.6.2.0

THANK YOU!!!

I figured it out… I had placed the app/design/adminhtml/santhosh folder in default7default instead of just under default.
Worked like a charm.
The only think that didn’t work for me is it didn’t keep the tree structure.

Den Markin - 24 November 2011 01:15 AM

opacons - 29 September 2011 11:01 PM

I’m trying to get this extension working with 1.6. The export seems to work fine, but when I import the csv file, as exported, I get the error “Path provided is not a valid one.” for each category.

Any ideas?

Your root category should be active and has the same name as in source store. This extension uses path traversing by category name matching, so if it doesn’t find parent category by name, it fails.

what will i do then? please help me? thanks

Hi, i have installed the extension and refreshed the cache. I’m using magento 1.4.1.1 .. I do not see ‘import categories’ in admin Import/export profiles. Please somebody help me with this. Thanks