CSV import with Scandinavian letters broken since TB1.4

[312erik123]

Hello,

I upgraded to TB1.4 and since then TB wont accept CSV-imports where I use scandinavian letter (åäö etc). This is quite the problem for me - anyone else expericened the same problem? Any solutions?

When looking at the CSV import page, fields with these characters arn't even being read...

Br.

Erik

Edited February 27, 2023 by 312erik123

[the.rampage.rado]

Make a file and db backup and update to edge. It should be fixed in to-be-1.5.

https://github.com/thirtybees/thirtybees/commit/b13ae185818fa83bb65813fc58bd64a159e36e9f

 

 

[312erik123]

Great, many thanks! I just replaced the two files from the commit and works as expected!

[the.rampage.rado]

A quick question.... why don't you update the whole store? Just in the last 2 weeks there are 2 security commits.

[312erik123]

We'll kind of figured that it was safer to stay on a stable release for a production environment...but maybe I'll set up a test environment and do the upgrade.

Do you have good experience with the 1.5 alpha/beta?

[the.rampage.rado]

No issues, not a single commit is reverted in probably one year. Few new minor features and many, many fixes and code improvements, plus as I said couple of security fixes.

EDIT: Just keep in mind one quirk in this update - email transport functionality was moved to a module. Nothing is changed but you have to install the module and configure your shop to use it. After update to currentedge there are couple of db fixes aswell. 😉 

Edited February 27, 2023 by the.rampage.rado

[312erik123]

Hello,

This issue has kind of re-appeared, now most of, not all, scandinavian letters are changed to chinese(?) characters... On bleeding edge...Anyone else? @the.rampage.rado Do you know anything?

Br.

Erik

Edited August 31, 2023 by 312erik123

[led24ee]

First make sure that You use UTF-8 encoding, second there is difference between CSV formats in TB1.1 and 1.4 (I have no info about 1.2 and 1.3)

[312erik123]

Just now, led24ee said:

First make sure that You use UTF-8 encoding, second there is difference between CSV formats in TB1.1 and 1.4 (I have no info about 1.2 and 1.3)

The strange this is that it only changes some of the characters:

 

Checked it on a prestashop site where the import works without any problems...

[312erik123]

6 hours ago, led24ee said:

First make sure that You use UTF-8 encoding, second there is difference between CSV formats in TB1.1 and 1.4 (I have no info about 1.2 and 1.3)

Seems as it was the UTF-8 enconding - thanks for pointing me in the right direction!

[led24ee]

You're welcome.