Format text with Ascii2Ansi in dataport

sergio_nav

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?



Please help me!

thanks!!!

Savatage

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?

kine

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.