Exporting multiplication sign in dynamics nav

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.

Answers

  • ftorneroftornero Posts: 269Member
    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
          [email protected] : TextConst 'ENU="€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§¨©ª«¬­®¯°±²³´µ¶·¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþ "';
          [email protected] : TextConst 'ENU=ÇüéâäàåçêëèïîìÄÅÉæÆôöòûùÿÖÜø£Ø׃áíóúñѪº¿®¬½¼¡«»€‚„…ÁÂÀ©†‡ˆ‰¢¥Š‹ŒŽãÑ’“”•–—¤ðÐÊËȘÍÎÏ™š›œ¦ÌÓßÔÒõÕµþÞÚÛÙýݯ´­±ž¾¶§÷¸°¨·¹³²Ÿ ';
    
        PROCEDURE [email protected]([email protected] : Text[250]) : Text[250];
        BEGIN
          //To import data from Windows to Navision
          EXIT(CONVERTSTR(_Text, WIN, NAV));
        END;
    
        PROCEDURE [email protected]([email protected] : Text[250]) : Text[250];
        BEGIN
          // To export data form Navision to Windows
          EXIT(CONVERTSTR(_Text, NAV, WIN));
        END;
    
        BEGIN
        END.
      }
    }
    

    Regards
  • rnjbngrnjbng Posts: 80Member
    It's a pretty good code but unfortunately when the multiplication sign goes to Notepad it just puts í sign using the above function.
  • ftorneroftornero Posts: 269Member
    Hello @mjbng,

    I tested the code before posted and works in my computer.

    I write the symbol in a customer name:

    xwttrd6nvo3g.png

    Exported with a dataport without using the function:

    tcaiewyzdipc.png


    Exported using the function:

    bmdcmbqb561m.png

    And I get the right symbol:

    4vaywmkdj0ak.png

    Maybe is a issue with the code page of your computer that is not the same than mine.

    Regards
Sign In or Register to comment.