Options

Format text with Ascii2Ansi in dataport

sergio_navsergio_nav Member Posts: 17
edited 2012-01-19 in NAV Three Tier
Hi,

I need import file with dataport, but I have a problem with boolean fields.

My interface is in spanish, and my options are "Sí" and "No" (with accent)

When I import a csv file, NAV say me

"Yoy cannot import because "SÝ" is not an option"

Can I use Ascii2Ansi funtion in field format?

cc4f85ad.png

Please help me!

thanks!!!
Sergio

Comments

  • Options
    SavatageSavatage Member Posts: 7,142
    Why not import into variable - so you can then control the data better

    "Yoy cannot import because "SÝ" is not an option"

    Example import that field into variable MYBOOLEAN

    if MYBOOLEAN = "SÝ" then
    REALBOOLEAN := YES else REALBOOLEAN := NO;

    hope that make sence

    Or are you saying SY works But SÝ doesn't?
  • Options
    kinekine Member Posts: 12,562
    I think the problem is codepage. If Sí is in Nav prezeted as SÝ, it could be because difference between windows codepage and DOS codepage. If the CSV is created from excel, try to save it as CSV (DOS) type, not CSV(Windows) or anything else.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.