Dataport + special characters issue when importing from file

(0) Share

Report

Posted on by vagalume13

Alright folks,

So, heres' the case.

I need to import load of rows into a table e.g. Staff.

Details such as first name , last name, etc are saved in Greek characters.

Created my dataport just fine, setting the values that I want to import.

In order to see that it is working , I first used the export option which exports existing data from staff table in a text. That file, exports the data and all greek characters show great.

If I try to import the same file with some new values, etc. all greek characters are non sense symbols, etc.

How do I correct this ?

I have read about the ANSI and ASCII converting issues, etc. I am running an old version of Nav apparently, so somehow I need to convert those characters while the text file is imported so they show ok.

I have no idea about C/AL coding whatsoever. I am aware that I must declare something in the C/AL Globals, etc. but I need some help with this.

Thanks in advance.

All responses (1)

Answers (0)

Suggested answer

THE Italian on at

Like (0)

Report

RE: Dataport + special characters issue when importing from file

Dataport has been discontinued right after NAV 2009 and they have the limitation to still not being unicode aware.

I would better invest time in move this environment to the latest supported version (version 15.x) instead of focusing in creating not reusable private IP.

If you cannot make it with dataport, you could always create a codeunit that process files.