Small and medium business | Business Central, N...

Shift_JIS encoding in Business Central SaaS version

(0) Share

Report

Posted on by Dharmender

Hi All,

In BC SaaS version, it is only possible to export a file with TextEncoding::Windows/UTF-8/ASCII.

But one our customer want to export file with specific encoding type (shift_jis) and which is possible in NAV and BC Onprem versions with help of .NET variables. Is there any workaround to achieve below source code in BC SaaS version?

//[DotNet Variable: FilestreamWriter , FileEncoding ]

TextFile.WRITEMODE(TRUE);

TextFile.TEXTMODE(TRUE);

TextFile.CREATE(FileName);

TextFile.CREATEOUTSTREAM(FileOutStream);

FilestreamWriter := FilestreamWriter.StreamWriter(FileOutStream,FileEncoding.GetEncoding('shift_jis'));

Thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

In BC Online there is an encoding codeunit avalible in the system app.T

The codeunit 1406 called Encoding. Takes a text and a Destination codepage as parameter. Maybe you can use that function?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,718 Super User 2025 Season 2 on at

Like (0)

Report

Hi, I think what Inge mentioned should be codeunit 1486 "Encoding". You can have a try.

And, some info in MS Docs:

File Handling and Text Encoding
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-file-handling-and-text-encoding

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Dharmender 88 on at

Like (0)

Report

Thanks ZHU for your suggestion.

My basic requirement is to export data from BC SaaS with Shift-JIS encoding text file.

Tried with the following code but Japanese characters showing ????? format.

//65001:codepage for utf-8, 932: codepage for shift_jis.

Encoding.Convert(65001, 932, HeaderLineJPText);

-----------------------------------------------------------------------------

12100077777777?)?????????? 02180005?????????????

-----------------------------------------------------------------------------

Was this reply helpful? Yes No
Dharmender 88 on at

Like (0)

Report

Thank Bruvik for your suggestion.

Tried encoding codeunit but still it not working. exported file showing ???

//65001:codepage for utf-8, 932: codepage for shift_jis.

Encoding.Convert(65001, 932, HeaderLineJPText);

Was this reply helpful? Yes No
Suggested answer

Dharmender 88 on at

Like (1)

Report

Thanks all for your time and suggestions. Achieved final result with following code.

//DotNetEncoding: Codeunit DotNet_Encoding;

//DotNetStreamWriter: Codeunit DotNet_StreamWriter;

//932 : codepage for shift-jis encode

//Fine Code

TempBlob.CreateOutStream(OutStr);

DotNetEncoding.Encoding(932);

DotNetStreamWriter.StreamWriter(OutStr, DotNetEncoding);

DotNetStreamWriter.WriteLine(HeaderLineJPText);

DotNetStreamWriter.Flush();

//Bad code

TempBlob.CreateOutStream(OutStr);

DotNetEncoding.Encoding(932);

DotNetStreamWriter.StreamWriter(OutStr, DotNetEncoding);

OutStr.Write(HeaderLineJPText);

OutStr.WriteText();

Was this reply helpful? Yes No