Problem with some special charactes importing CSV file.

[paconde]

Hello, when importing a CSV file, I have problems with some special characters, such as "Ñ" or "º". Is there any solution?

[BeeBombshell]

Hi @paconde, I have created an issue discussing the problems you have been facing. Somebody will get back to you soon. To keep track, you can follow this issue. 🙂

[htuerker]

Hi, @paconde!

I've investigated the problem, there isn't an actual problem related to the Rowy application itself. Everything works well on my machine.

However, I'd like to share my opinions to help you find the problem.

• I am guessing that your machine already supports those special characters as they look nice in your text editor. But, � actually represents the "replacement char" which is used to indicate problems when a system is unable to render a character.
• First, let's be sure that it's not a client issue. Could you check if it appears the same on your firestore console
  
• If so, how you export your CSV data might be the source of this problem. It should be Unicode(UTF-8) encoded.

---

Feel free to tag me for your following questions, I'd like to give more help with more details.

[RajGM]

We can use icnov to translate non-english characters to printable ones.
https://stackoverflow.com/questions/54583483/how-to-read-special-characters-from-csv-files-in-javascript

[RajGM]

But I am getting dependencies error while trying to install icnov.

[RajGM]

`npm WARN config global --global, --local are deprecated. Use --location=global instead.
npm ERR! code ERESOLVE
npm ERR! ERESOLVE could not resolve
npm ERR!
npm ERR! While resolving: @craco/craco@6.4.3
npm ERR! Found: react-scripts@5.0.0
npm ERR! node_modules/react-scripts
npm ERR! peer react-scripts@"^5" from craco-swc@0.5.1
npm ERR! node_modules/craco-swc
npm ERR! dev craco-swc@"^0.5.1" from the root project
npm ERR! react-scripts@"^5.0.0" from the root project
npm ERR!
npm ERR! Could not resolve dependency:
npm ERR! peer react-scripts@"^4.0.0" from @craco/craco@6.4.3
npm ERR! node_modules/@craco/craco
npm ERR! peer @craco/craco@"^6 ^7" from craco-swc@0.5.1
npm ERR! node_modules/craco-swc
npm ERR! dev craco-swc@"^0.5.1" from the root project
npm ERR! dev @craco/craco@"^6.4.3" from the root project
npm ERR!
npm ERR! Conflicting peer dependency: react-scripts@4.0.3
npm ERR! node_modules/react-scripts
npm ERR! peer react-scripts@"^4.0.0" from @craco/craco@6.4.3
npm ERR! node_modules/@craco/craco
npm ERR! peer @craco/craco@"^6 ^7" from craco-swc@0.5.1
npm ERR! node_modules/craco-swc
npm ERR! dev craco-swc@"^0.5.1" from the root project
npm ERR! dev @craco/craco@"^6.4.3" from the root project
npm ERR!
npm ERR! Fix the upstream dependency conflict, or retry
npm ERR! this command with --force, or --legacy-peer-deps
npm ERR! to accept an incorrect (and potentially broken) dependency resolution.
npm ERR!
npm ERR! See C:\Users\RajGM\AppData\Local\npm-cache\eresolve-report.txt for a full report.

npm ERR! A complete log of this run can be found in:
npm ERR! C:\Users\RajGM\AppData\Local\npm-cache_logs\2022-09-18T17_43_50_307Z-debug-0.log`