Import UTF 8 error

I am trying to import items into _djc2_items. I have setup the configuration and mapped the fields. Exported the data from Excel as csv and then converted the csv file UTf-8 with notepad++
However when I try and import the data I continually get the error message
Invalid file encoding. CSV has to be UTF8 encoded!

Any ideas ?
Thanks

Comments

  • Also tried save as csv from excel choose tools web options encoding utf-8. The file contains url's ?
  • Managed to get past the encoding error by saving via notepad. Now get records ignored

    Message
    Product Import Summary
    Rows total: 353
    Rows examined: 353
    Starting from row: 0
    Limit: 400.
    Records added: 0
    Records updated: 0
    Warning
    Records ignored: 353
  • I think import is broken. Do you have a sample file that works inc a html url and £ symbol ?
  • Cant even import this simple file

    "Name","PostCode"
    "Adur District Council","BN43 6PR"

    Message
    Product Import Summary
    Rows total: 1
    Rows examined: 1
    Starting from row: 0
    Limit: 200.
    Records added: 0
    Records updated: 0
    Warning
    Records ignored: 1
  • After spending hours on this it seems the mysql field names are case sensitive. In import config I had he target as Name when it should be name. V annoying.
  • Hi,

    I downloaded your file and it's definitely not saved using UTF-8 (NO BOM). I attach a screen-shot from notepad++ and converted CSV file.


  • Thanks for checking. I had so many versions of the file. Trying to resolve.
Sign In or Register to comment.