Loading...
 
Features / Usability

Features / Usability

Forum List Topic List

Forums » Features / Usability » Unable to import Categories from CSV file
 
Thread actions
PDF Print this page
  • Print all pages

    • Unable to import Categories from CSV file

    Posted by Pierre TCHEKOUTEU 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

    Regions.csv (70 b)
    Reads: 1271
    Link
    Posted by Bernard Sfez / Tiki Specialist posts: 8633 Israel
    Pierre TCHEKOUTEU wrote:

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





    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

    Link
    Posted by Pierre TCHEKOUTEU 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

    Link

    Posted by Jonny Bradley posts: 126886 United Kingdom
    Pierre TCHEKOUTEU wrote:

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


    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

    Link
    Posted by Pierre TCHEKOUTEU 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

    Link

    Posted by Zac 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.
    Link