Loading CSV containing special characters to an application table
Hi all, I have a dashboard with an SQL table editor component. Through the component in the dashboard, I can save text to the table, including special characters. For example, there is no problem in ...
Thank you. As I suspected, it's an encoding issue. The file is UTF-8, whereas OneStream largely reasons in UTF-16 (traditional default in Windows/.Net world). There are two ways to fix this, as far as I can see:
- just convert the file to UTF-16 before uploading it, for example with Notepad++, or
- turn the file bytes back to string and then from there to UTF-16 bytes using the Encoding classes.
Here's some (untested) code that should send you in the right direction:
' at the top Imports System.Text [...] ' get the encodings we need Dim utf8 As Encoding = encoding.UTF8 Dim utf16 As Encoding = Encoding.Unicode ' turn original bytes into String ... Dim text As String = utf8.GetString(fileinfo.XFFile.ContentFileBytes) ' ... and from there to UTF16 bytes Dim toUpload As Byte() = utf16.GetBytes(text) ' upload utf16 bytes BRApi.Utilities.LoadCustomTableUsingDelimitedFile(si, _ SourceDataOriginTypes.FromFileUpload, filePath, _ toUpload, _ "|", "App", "LOAD_TABLE", "Merge", lfieldtokens, True)
