Exporting multiplication sign in dynamics nav

Answers

• Options

  ftornero Member Posts: 522

  2019-10-25

  Hello @mjbng
  
  You could use the function NAV2Win in this codeunit to change the text value of your field before export with the dataport.
  

  OBJECT Codeunit 50003 Import/Export functions
  {
    OBJECT-PROPERTIES
    {
      Date=10/25/19;
      Time=04:47:49 PM;
      Modified=Yes;
      Version List=;
    }
    PROPERTIES
    {
      OnRun=BEGIN
            END;
  
    }
    CODE
    {
      VAR
        NAV@1000000001 : TextConst 'ENU="€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§¨©ª«¬­®¯°±²³´µ¶·¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþ "';
        WIN@1000000000 : TextConst 'ENU=ÇüéâäàåçêëèïîìÄÅÉæÆôöòûùÿÖÜø£Ø׃áíóúñѪº¿®¬½¼¡«»€‚„…ÁÂÀ©†‡ˆ‰¢¥Š‹ŒŽãÑ’“”•–—¤ðÐÊËȘÍÎÏ™š›œ¦ÌÓßÔÒõÕµþÞÚÛÙýݯ´­±ž¾¶§÷¸°¨·¹³²Ÿ ';
  
      PROCEDURE Win2NAV@1000000009(_Text@1000000000 : Text[250]) : Text[250];
      BEGIN
        //To import data from Windows to Navision
        EXIT(CONVERTSTR(_Text, WIN, NAV));
      END;
  
      PROCEDURE NAV2Win@1000000011(_Text@1000000000 : Text[250]) : Text[250];
      BEGIN
        // To export data form Navision to Windows
        EXIT(CONVERTSTR(_Text, NAV, WIN));
      END;
  
      BEGIN
      END.
    }
  }
  

  
  Regards

  0
• Options

  rnjbng Member Posts: 82

  2019-10-25

  It's a pretty good code but unfortunately when the multiplication sign goes to Notepad it just puts í sign using the above function.

  0
• Options

  ftornero Member Posts: 522

  2019-10-25

  Hello @mjbng,
  
  I tested the code before posted and works in my computer.
  
  I write the symbol in a customer name:
  
  
  
  Exported with a dataport without using the function:
  
  
  
  
  Exported using the function:
  
  
  
  And I get the right symbol:
  
  
  
  Maybe is a issue with the code page of your computer that is not the same than mine.
  
  Regards
  

  0