Loading...
 
Features / Usability

Features / Usability


Unable to import Categories from CSV file

posts: 3 France

Hello I'm trying to import Categories on my tiki web site
and always get the message below

The file does not have the required header: category, description, parent


Import Categories Fail

So I tried to Test with a sample file without adding anything else and I encoured the same Message.

I'm on a Brand new Tiki installation the latest release (22)

Please Help

here's the sample file

thanks a lot

posts: 8406 Israel
Pierre TCHEKOUTEU wrote:

Hello I'm trying to import Categories on my tiki web site
and always get the message below

The file does not have the required header: category, description, parent


Import Categories Fail

So I tried to Test with a sample file without adding anything else and I encoured the same Message.

I'm on a Brand new Tiki installation the latest release (22)

Please Help

here's the sample file

thanks a lot


IMO is should be :
category,description,parent
vegetable,vegetable,
potato,,vegetable

or category,description,parent
vegetable,,vegetable,
potato,,vegetable

posts: 3 France
Bernard Sfez / Tiki Specialist wrote:

IMO is should be :
category,description,parent
vegetable,vegetable,
potato,,vegetable

or category,description,parent
vegetable,,vegetable,
potato,,vegetable


Hello Bernard
I'm bery honored for your reply
I used to follow your youtube tutorial
I'm a beginner on tiki platform

unfortunately
even with your examples (both of them), I have the same message
please can you provide me with a working sample file ?

Thanks you very much


posts: 126754 United Kingdom
Pierre TCHEKOUTEU wrote:

Hello I'm trying to import Categories on my tiki web site
and always get the message below

The file does not have the required header: category, description, parent


Hi Pierre

Seems the file you were importing has a BOM "header" in it, which the code wasn't handling properly. So for now resave the file as UTF-8 without BOM and all should work as expected.

I have fixed this in Tiki 22.x now so if you can update easily that it should work ok now with your existing files. If it's a good fix then i'll backport it to 21.x too.

More on this here.

HTH! mrgreen

posts: 3 France
Jonny Bradley wrote:

Hi Pierre

Seems the file you were importing has a BOM "header" in it, which the code wasn't handling properly. So for now resave the file as UTF-8 without BOM and all should work as expected.

I have fixed this in Tiki 22.x now so if you can update easily that it should work ok now with your existing files. If it's a good fix then i'll backport it to 21.x too.

More on this here.

HTH! mrgreen


FANTASTIC
save the file to UTF-8 solve the issue
Thank you so much


posts: 72 United States
Had this same issue today on Tiki 21.1. Was trying to upload a .csv created in Excel. When you SaveAs in Excel there are several different CSV options. I was not able to use the CSV UTF-8 format, but CSV did work. Just leaving this here in case other have the same issue.