Fixed Len Import Dataport Problems

Pavlos
Pavlos Member Posts: 19
edited 2004-06-10 in Navision Attain
Hi to all,

I've created a dataport in order to import data from a fixed length ascii file into a table (I've created) in navision. There are two problems with this dataport that I can't figure out.
1. When I run the dataport it inserts ONLY the first record and discards the rest.
2. There is a description field (that has an item description in Greek). I've done the convertion from ansi to ascii and I still can't get the proper characters. Instead when I'm doing ansi to OEM conversion from my file editor and then import I get the proper characters.

Please help me I've spent a lot of time trying to find out a solution.
Thanks in advance.
Pavlos

Comments

  • Tommy_Schou
    Tommy_Schou Member Posts: 117
    1)
    Are you sure that you have set the property RecordSeparato correctly on the dataport. If it only import 1 record it could be because it thinks there is only one :)

    2)
    Ehhmm.. ok! :) Find out what Ascii no's your characters has and then find out what character that corresponds to in navision. Then convert accordingly.
    Best regards
    Tommy
  • Pavlos
    Pavlos Member Posts: 19
    Hi Tommy,
    thanks for your reply.

    I've managed to figure out what the problem was. The problem was the format of the file. The file in unix format so by using my text editor I've convert the file in dos format so I've solved my first problem. For the second problem I've used again my editor to convert ANSI to OEM and it works! Although this is not the best solution. Does anybody knows any tool in navision that I can use in order to convert a unix file to dos file from within the navision instead of using an external editor?

    Thank you.
  • Tommy_Schou
    Tommy_Schou Member Posts: 117
    You shouldn't have to convert it. The conversion can be done inside the dataport. You just have to know the values of the characters you want to convert and write the appropiate code in the dataport.

    Did you solve your problem with regards to it only reading the first record? Or was that also because of it being a unix file? It shouldn't be a problem to read unix files into navision. You just have to remember that the line-break on unix is on LF but in DOS it is CRLF. Thus if you dataport assumes LF as the line/record break then everything should be working! :)
    Best regards
    Tommy

Categories