AbanteCart Community

eCommerce construction => Installation and Configuration => Fresh Installation => Topic started by: Zakawyka on May 23, 2021, 03:45:05 PM

Title: Cannot Import categories
Post by: Zakawyka on May 23, 2021, 03:45:05 PM
I just installed 1.3.0
I removed sample categories, created few new ones and exported those as csv. Fields received are:

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
Title: Re: Cannot Import categories
Post by: Basara on May 24, 2021, 01:07:58 AM
Try the example CSV file https://abantecart.atlassian.net/wiki/spaces/AD/pages/16777227/Import+Wizard#ImportWizard-Categoriesimportexample
Title: Re: Cannot Import categories
Post by: Zakawyka on May 25, 2021, 07:41:48 AM
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.

Title: Re: Cannot Import categories
Post by: Basara on May 26, 2021, 01:47:36 AM
It looks like your CSV editor broke something. Try OpenOffice