EspoCRM version: 10.0.11
MySQL
PHP: 8.4
Hi,
when I import URLs with special characters (like ä, ö, ü, ß, or Cyrillic or Greek letters) into a field of type "URL Multiple", the import fails for these rows. If I type the same URL into the field by hand, it works. A normal "URL" field also imports these URLs without problems.
Steps to reproduce:
1. Administration > Entity Manager > Account > Fields > Add Field
2. Choose type "URL Multiple", label "Websites", save
3. Make a CSV file (UTF-8) with this content:
name;websites
Test 1;https://de.wikipedia.org/wiki/Straße
Test 2;"müller-bäckerei.de,https://ru.wikipedia.org/wiki/Москва"
Test 3;https://www.example.com
4. Administration > Import, choose Account, upload the file, delimiter ";", header row checked
5. Map "name" to Name and "websites" to Websites, run the import
6. Open the import and look at the errors
Expected:
All 3 rows are imported, the same way as when I enter the URLs by hand.
Actual:
Only row 3 is imported. Rows 1 and 2 show this error:
Validation – field "websites" – type "pattern"
Logs: nothing
It looks like the form encodes the special characters before saving (ß becomes %C3%9F), and the import does this for "URL" fields but not for "URL Multiple" fields.
Saving a link with special characters by hand works flawlessly, only the import doesnt work
Thanks!
MySQL
PHP: 8.4
Hi,
when I import URLs with special characters (like ä, ö, ü, ß, or Cyrillic or Greek letters) into a field of type "URL Multiple", the import fails for these rows. If I type the same URL into the field by hand, it works. A normal "URL" field also imports these URLs without problems.
Steps to reproduce:
1. Administration > Entity Manager > Account > Fields > Add Field
2. Choose type "URL Multiple", label "Websites", save
3. Make a CSV file (UTF-8) with this content:
name;websites
Test 1;https://de.wikipedia.org/wiki/Straße
Test 2;"müller-bäckerei.de,https://ru.wikipedia.org/wiki/Москва"
Test 3;https://www.example.com
4. Administration > Import, choose Account, upload the file, delimiter ";", header row checked
5. Map "name" to Name and "websites" to Websites, run the import
6. Open the import and look at the errors
Expected:
All 3 rows are imported, the same way as when I enter the URLs by hand.
Actual:
Only row 3 is imported. Rows 1 and 2 show this error:
Validation – field "websites" – type "pattern"
Logs: nothing
It looks like the form encodes the special characters before saving (ß becomes %C3%9F), and the import does this for "URL" fields but not for "URL Multiple" fields.
Saving a link with special characters by hand works flawlessly, only the import doesnt work
Thanks!

Comment