Exporting multiplication sign in dynamics nav

rnjbng

Hih Folks -

One of customer has a item description as SS MAT 140 TERRY PRO 18 WHT 39 × 80 where x is a actual multiplication sign and not X from the keyboard. When I create a simple dataport and export the description it comes as "SS MAT 140 TERRY PRO 18 WHT 39 í 80" where x is substituted with strange character.

Is there any way to get the actual multiplication sign to show on notepad. I know that Alt+0215 on notepad will give me the multiplication sign but I am not sure how to program the Alt+0215 in NAV.

Any help is highly appreciated.

Thanks
RJ.

ftornero

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

rnjbng

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

ftornero

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