Import & Export problem with categories
-- 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?
сайт з перекладами www.benefit.in.ua
PS. спасибо переводить Webmoney : Z207635098627 R152456839841 или ЯД 410011027999056
Please Log in or Create an account to join the conversation.
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.
Please Log in or Create an account to join the conversation.
can you show example? im not sure what right understand youXavier 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 ?
сайт з перекладами www.benefit.in.ua
PS. спасибо переводить Webmoney : Z207635098627 R152456839841 или ЯД 410011027999056
Please Log in or Create an account to join the conversation.
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
Please Log in or Create an account to join the conversation.
сайт з перекладами www.benefit.in.ua
PS. спасибо переводить Webmoney : Z207635098627 R152456839841 или ЯД 410011027999056
Please Log in or Create an account to join the conversation.
To have the good tree you have to check if your categories have the good parent categories in the parent_category column.
Please Log in or Create an account to join the conversation.
сайт з перекладами www.benefit.in.ua
PS. спасибо переводить Webmoney : Z207635098627 R152456839841 или ЯД 410011027999056
Please Log in or Create an account to join the conversation.
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.
Please Log in or Create an account to join the conversation.
yes, hika-products-export buttonXavier wrote: Are you using the Export button in the toolbar of the product menu ?
сайт з перекладами www.benefit.in.ua
PS. спасибо переводить Webmoney : Z207635098627 R152456839841 или ЯД 410011027999056
Please Log in or Create an account to join the conversation.
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"
Please Log in or Create an account to join the conversation.
i dont have mass action in system on my main site, but have on demo siteXavier 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"
if i try use same way (http://my_main_site/administrator/index.php?option=com_hikashop&ctrl=massaction i see warning:
сайт з перекладами www.benefit.in.ua
PS. спасибо переводить Webmoney : Z207635098627 R152456839841 или ЯД 410011027999056
Please Log in or Create an account to join the conversation.
With 2.2.0 the massaction must be present.
Do you have any class/controller override ?
Please Log in or Create an account to join the conversation.
re-install, now i see mass action option, "category_parent_is" its a same as "parent_category"? and what i must to do with new csv file?)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"
сайт з перекладами www.benefit.in.ua
PS. спасибо переводить Webmoney : Z207635098627 R152456839841 или ЯД 410011027999056
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
upd. not all categories and sub was export with cyrillic names (not use any special symbols + */ etc)
сайт з перекладами www.benefit.in.ua
PS. спасибо переводить Webmoney : Z207635098627 R152456839841 или ЯД 410011027999056
Please Log in or Create an account to join the conversation.
Excel should be compatible with UTF8. I don't think that such software does not handle this type of encoding.
Regards,
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
Please Log in or Create an account to join the conversation.
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
сайт з перекладами www.benefit.in.ua
PS. спасибо переводить Webmoney : Z207635098627 R152456839841 или ЯД 410011027999056
Please Log in or Create an account to join the conversation.