OroCommerce Forums

Covering OroCommerce topics, including community updates and company announcements.

Forums Forums OroCommerce Import – Not Working

This topic contains 1 reply, has 2 voices, and was last updated by Andrey Yatsenko Andrey Yatsenko 6 months, 4 weeks ago.

The forum will run in the read-only mode starting from March 1. Please head to StackOverflow for support.

  • Creator
    Topic
  • #39831

    snb-me
    Participant

    Hello,

    I tried to import a list of products via CSV file to my orocommerce store.

    Once i validate the list it shows 0 errors and successfully validates the CSV file.

    But when i try to import it, it shows the following error and does not import the list.

    An exception occurred while executing ‘INSERT INTO oro_fallback_localization_val (serialized_data,
    fallback, string, text, localization_id) VALUES (?, ?, ?, ?, ?)’ with params [“Tjs=”, “”, null, “\x3c\x70\x3e\x42
    \x65\x72\x61\x69\x6e\x20\x77\x61\x74\x65\x72\x20\x69\x73\x20\x70\x72\x6f\x64\x75\x63\x65\x64\x20\x77\x69\x74\x68\x20
    \x73\x74\x61\x74\x65\x20\x6f\x66\x20\x74\x68\x65\x20\x61\x72\x74\x20\x6d\x6f\x64\x65\x72\x6e\x20\x74\x65\x63\x68\x6e
    \x6f\x6c\x6f\x67\x79\x20\x75\x6e\x64\x65\x72\x20\x75\x6c\x74\x72\x61\x2d\x68\x79\x67\x69\x65\x6e\x69\x63\x20\x63\x6f
    \x6e\x64\x69\x74\x69\x6f\x6e\x73\x20\x63\x6f\x6d\x70\x6c\x65\x74\x65\x6c\x79\x20\x75\x6e\x74\x6f\x75\x63\x68\x65\x64
    \x20\x66\x72\x6f\x6d\x20\x74\x68\x65\x20\x73\x6f\x75\x72\x63\x65\x20\x74\x6f\x20\x74\x68\x65\x20\x62\x6f\x74\x74\x6c
    \x65\x2e\x3c\x2f\x70\x3e\x0d\x0a\x3c\x70\x3e\x43\x45\x52\x54\x49\x46\x49\x43\x41\x54\x45\x53\x3a\x20\x0d\x0a\x3f\x20
    \x53\x61\x75\x69\x64\x6f\x20\x4f\x72\x67\x61\x6e\x69\x7a\x61\x74\x69\x6f\x6e\x20\x66\x6f\x72\x20\x53\x74\x61\x6e\x64
    \x61\x72\x64\x69\x7a\x61\x74\x69\x6f\x6e\x20\x61\x6e\x64\x20\x4d\x65\x74\x72\x6f\x6c\x6f\x67\x79\x20\x53\x41\x53\x4f
    \x2e\x0d\x0a\x3f\x20\x49\x6e\x74\x65\x72\x6e\x61\x74\x69\x6f\x6e\x61\x6c\x20\x51\x75\x61\x6c\x69\x74\x79\x20\x53\x74
    \x61\x6e\x64\x61\x72\x64\x73\x20\x96\x20\x4e\x53\x46\x0d\x0a\x3f\x20\x49\x6e\x74\x65\x72\x6e\x61\x74\x69\x6f\x6e\x61
    \x6c\x20\x51\x75\x61\x6c\x69\x74\x79\x20\x53\x74\x61\x6e\x64\x61\x72\x64\x73\x20\x96\x20\x41\x42\x57\x41\x2e\x20\x3c
    \x2f\x70\x3e\x0d\x0a”, null]:

    SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\x96 NSF\x0D…’ for column ‘text’ at row 1

Viewing 1 replies (of 1 total)
  • Author
    Replies
  • #39848
    Andrey Yatsenko
    Andrey Yatsenko
    Moderator

    What is CSV file encoding? Please change it to utf8 and try again.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

You will be redirected to [title]. Would you like to continue?

Yes No