Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [UR] General Discussion (https://www.kinook.com/Forum/forumdisplay.php?f=23)
-   -   Unicode support in CSV import (https://www.kinook.com/Forum/showthread.php?t=5564)

yfuser 02-13-2019 10:53 AM

Unicode support in CSV import
 
I have a CSV file that contains unicode characters. After I imported the CSV file, it display weird characters for those unicode characters. Haven't found a setting to correct this without changing my OS setting. Will be nice if it can be fixed. I can provide more details if needed. Thank you!

kinook 02-14-2019 02:50 PM

Please send or post the .csv file. Thanks.

yfuser 02-14-2019 04:08 PM

Hi, I have sent the file to support email. Please check, thanks!

kinook 02-14-2019 04:54 PM

2 Attachment(s)
You need to save the file in UTF-8 encoding with a BOM (byte order mark). One way to do this is using Visual Studio Code:

1) Open the .csv file
2) Choose command (Ctrl+Shift+P) Change File Encoding -> Reopen with Encoding -> UTF-8
3) Choose command Change File Encoding -> Save with Encoding -> UTF-8 with BOM

Then you can import into UR with the correct encoding.

yfuser 02-14-2019 07:22 PM

Thank you for the help! It's good news to me.


All times are GMT -5. The time now is 08:58 AM.


Copyright © 1999-2023 Kinook Software, Inc.