I just installed 1.3.0
I removed sample categories, created few new ones and exported those as csv. Fields received are:
categories.category_id
categories.parent_id
categories.sort_order
categories.status
categories.date_added
categories.date_modified
category_descriptions[0].category_id
category_descriptions[0].language_id
category_descriptions[0].name
category_descriptions[0].meta_keywords
category_descriptions[0].meta_description
category_descriptions[0].description
categories_to_stores[0].category_id
categories_to_stores[0].store_id
I filled those fields and when I try to import i'm being switched to WISARD and some strange things happen: after selectin a delimiter and CATEGORIES I am asked to make a map, but something strange is wi th list of parameters offered: there is no category id there, there is no parent_id there, etc. BTE, there are 3 lines in the file : titls and 2 new categories.
After Load Wizard say - not enough data fer TWELVE records.
and this is funny reply:
Task Failed
Import Process has been completed. 1027 row(s) processed. 4108 row(s) with errors.
For more details see log file categories_import_4.txt
What I am doing wrong? is anywhere there a Categories .csv template?
Kind regards
Hello.
Try the example CSV file https://abantecart.atlassian.net/wiki/spaces/AD/pages/16777227/Import+Wizard#ImportWizard-Categoriesimportexample
Thank you for the link. There is no documentation either how to create the file or how to use it so I assumed the folowing:
the first line contains partially names from the table [aboh_categories] with missing fields [category_id] and [parent_id], with underscore replaced by space in others.
Format of fields varies: the first two are numbers (no wrapper).
[Name] field is of text format, and the name itself includes all parents separated by comma (usually it is /, but anyway)
[meta ..] - text fields with wrapper
[seo url] and [image] format unknown as there is no wrapper but the field filled with text.
DID NOT WORK - Screenshots are attached.
I added two fields from table [aboh_categories] -> [category_id] and [parent_id] , changed the first line to
category id,parent id,status,sort order,name,description,meta keywords,meta description,seo url,image
The same result.
Please note that there are two unidentified symbols in front of STATUS.
Regards
It looks like your CSV editor broke something. Try OpenOffice