Import & Export problem with categories

Hi try make imp\exp (csv) operation from J2.5 to J3 (last versions) all information transfer but categories structure not
-- url of the page with the problem -- : demo3.benefit.in.ua/
-- HikaShop version -- : 2.2.0
-- Joomla version -- : 3.1.5 Stable
-- PHP version -- : 5.3.6
-- Browser(s) name and version -- : Mozilla 22.0
-- Error-message(debug-mod must be tuned on) -- : was some errors like this column not exist but not make PrtScr (forget)

How to make export with saved categories structure?

Hi,

When you export, thanks to check your csv file content.
The categories are at the top of the csv file, are there the good structure in the csv ?

If yes, so the problem can potentially come from the export, else from the import.
You can edit this csv file to set back the good structure.

Xavier wrote: Hi,
When you export, thanks to check your csv file content.
The categories are at the top of the csv file, are there the good structure in the csv ?

Hi,

You can see the documentation about export/import here:
www.hikashop.com/support/support/documen...hikashop-import.html

The content you need to read is:

This will add one product with 2 categories attached: the category with the id 2 and the one with the id 13. You can find ids of categories on the category listing in the column called ID on the right of the listing.

Since version 1.4.1, you can import a tree of categories which will be created if they don't exist already in HikaShop with the option "Create automatically missing categories" set to "yes". For example, you could have something like:

parent_category,categories

product category,main category 1;main category 2;main category 3

main category 1,sub category 1;sub category 2

parent_category - is empty in csv file for all products

For products, it's normal to not have parent category, parent categories are only used for the categories.

To have the good tree you have to check if your categories have the good parent categories in the parent_category column.

hi in categories i dont see tree (add my csv file in attach)

Your csv don't have the categories structure.
That's why when importing in back, the categories don't have parent/children.

Are you using the Export button in the toolbar of the product menu ?
The categories should be in that csv, before the products.

Xavier wrote: Are you using the Export button in the toolbar of the product menu ?

I can't reproduce the problem on my end, the categories are well exported.

Thanks to try to export the categories via the mass actions.
Via the menu System > Mass action, create a new massaction with the data "Category" you don't need to select a trigger neither a filter. In the action select "exportCsv" and check the two fields "parent_category" and "category_name"

Xavier wrote: Via the menu System > Mass action, create a new massaction with the data "Category" you don't need to select a trigger neither a filter. In the action select "exportCsv" and check the two fields "parent_category" and "category_name"

Warning: include(/home/virtwww/site/http/administrator/components/com_hikashop/controllers/massaction.php): failed to open stream: No such file or directory in /home/virtwww/site/http/administrator/components/com_hikashop/hikashop.php on line 46 Warning: include(): Failed opening '/home/virtwww/site/http/administrator/components/com_hikashop/controllers/massaction.php' for inclusion (include_path='.:') in /home/virtwww/site/http/administrator/components/com_hikashop/hikashop.php on line 46 controller massaction not found

Thanks to try to re-install the HikaShop component over your current install.
With 2.2.0 the massaction must be present.

Do you have any class/controller override ?

Xavier wrote: I can't reproduce the problem on my end, the categories are well exported.

Thanks to try to export the categories via the mass actions.
Via the menu System > Mass action, create a new massaction with the data "Category" you don't need to select a trigger neither a filter. In the action select "exportCsv" and check the two fields "parent_category" and "category_name"

next problem is that file encoding in utf8 and cyrillic symbols unreadable in exel. now i have 200+ position and can manual replace into categories for my demo site but if somebody have much more products its be a problem

upd. not all categories and sub was export with cyrillic names (not use any special symbols + */ etc)

i found next answer on forum:
file in UTF-8 should begin with a standard BOM signature 0xEF, 0xBB, 0xBF ( ru.wikipedia.org/wiki/UTF8 ). Without it, Excel does not recognize UTF-8.

or/and solution: open file in windows notepad, that save it in utf-8 (program should automatically detect the file encoding format ) and after that cyrillic be normal viewed in exel