Importing Categories with Sub Categories

[Barrett]

I used a tab separator in my file.

Code \t Name \t Active \t Parent_Cat \r

This will fail and only see 3 fields if the Parent_Cat field is empty

I had to do the import in 2 separate files.
First with Parent Cats Only.
Second with Sub Cats Only.

It is reproduceable for me.

[Barrett]

Re: Importing Categories with Sub Categories

I used a tab separator in my file.

Code \t Name \t Active \t Parent_Cat \r

This will fail and only see 3 fields if the Parent_Cat field is empty

I had to do the import in 2 separate files.
First with Parent Cats Only.
Second with Sub Cats Only.

It is reproduceable for me.

Using Beta 3 now

Would not recognize my parents and subcats file again
would not recognize file with an empty field
seems worse than before
created parent cats only file 3 fields
success on that
created subcats only file with 4 fields full
success on this

[Alex Kruglyak]

Re: Importing Categories with Sub Categories

Hi Barrett,

Was this functional pre-5.5?

Thanks.

[Barrett]

Re: Importing Categories with Sub Categories

As far as I can remember. I don't recall having to do anything special on working with 5.0 importing the cats.

[Barrett]

Re: Importing Categories with Sub Categories

Bug still present in MM5.5 RC1

[Alex Kruglyak]

Re: Importing Categories with Sub Categories

It's on our list.

Thanks.

[Alex Kruglyak]

Re: Importing Categories with Sub Categories

Hi Barrett,

Can you please send me the flat file that's failing for you offline.
I'm having trouble reproducing the issue.

Thanks.

[Alex Kruglyak]

Re: Importing Categories with Sub Categories

Hi Barrett,

I was able to reproduce your issue and it's actually been in MM5 since PR1.

The issue was; the import mechanism only counts the first 5 rows to determine how many columns to display. In your flat file, the first 5 rows did not have a parent category code. Instead, they had an empty tab.
This threw the import off by having the process die on the second column.

An easy workaround for this would be to move any of your category rows that have a parent category code to the top of the file.

This issue will be fixed in 5.5.

Thanks.