Author Topic: Cannot Import categories  (Read 4055 times)

Offline Zakawyka

  • Newbie
  • *
  • Posts: 7
  • Karma: +0/-1
    • View Profile
Cannot Import categories
« 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:
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

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile

Offline Zakawyka

  • Newbie
  • *
  • Posts: 7
  • Karma: +0/-1
    • View Profile
Re: Cannot Import categories
« Reply #2 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.

Regards
« Last Edit: May 25, 2021, 07:44:26 AM by Zakawyka »

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Cannot Import categories
« Reply #3 on: May 26, 2021, 01:47:36 AM »
It looks like your CSV editor broke something. Try OpenOffice

 

Powered by SMFPacks Social Login Mod