Text File UTF-8 Encoding

Comments

• Options

  FDickschat Member Posts: 380

  2010-11-12

  NAV uses internally and when writing files ASCII, not ANSI. You will need to convert the data to ANSI before writing the file. Search the forum for ASCII ANSI, you will find lots of tips.

  Frank Dickschat
  FD Consulting

  0
• Options

  EL_TORRESHDZ Member Posts: 3

  2010-11-26

  Thanks now i can write character like é and Á in the text file encode ANSI but I need write the text file from NAV in default encode UTF-8 not in ANSI

  0
• Options

  Malajlo Member Posts: 294

  2015-01-06

  This can be done using PowerShell.
  .tmp file is temporary ANSI file, ptFileName is a full path to file (ie. c:\temp\filename.txt)
  

  WHS	Automation	'Windows Script Host Object Model'.WshShell	
  
  IF ISCLEAR(WHS) THEN CREATE(WHS) ;
  pwrShell := '%SystemRoot%\syswow64\WindowsPowerShell\v1.0\powershell.exe' ;
  pwrShellCmd := STRSUBSTNO('"Get-Content %1.tmp | Out-File %1 -Encoding UTF8"',ptFileName) ;
  whsWait := TRUE ;
  i := WHS.Run(pwrShell + ' ' +pwrShellCmd,whsWait,whsWait) ;
  ERASE(ptFileName+'.tmp') ;
  

  0
• Options

  code_eater Member Posts: 5

  2015-01-07

  Hi
  Just my 2 cents in this:
  
  In 2013 there was a new System-Property "Textencoding" introduced. Have a sample here:
  
  http://msdn.microsoft.com/en-us/library ... 1(v=nav.71).aspx
  
  Using this, I think you don't need ASCIItoANSI Conversion anymore while exporting data.
  
  Hope this helps.
  Thomas

  0
• Options

  Kowa Member Posts: 918

  2015-01-07

  I have written some PowerShell conversion functions which you can easily adapt to all existing codepages by selecting the source/target file encoding.
  http://www.msdynamics.de/viewtopic.php?f=17&t=25726
  Keep in mind that these conversion can only work properly if a special character is part of a specific codepage. You can convert any codepage to unicode but not vice versa if the file contains characters which can't be mapped.
  Don't import these converted files to NAV without converting them back to the OEM codepage, unless you can make use of the file encoding parameter that was introduced in NAV 2013 R2.

  Kai Kowalewski

  0
• Options

  Rikt-It Member Posts: 37

  2015-01-08

  Hi
  
  I have used
  
  http://blogs.msdn.com/b/nav/archive/201 ... -2013.aspx
  
  to export / import files with Swedish special signs åäö..
  
  Regards
  
  Christer

  Regards
  Christer in Stockholm, Sweden

  0