DataPort New Line Issue

franklin1232franklin1232 Member Posts: 35
We recently began pulling files directly from about 82 Linux Servers. Prior to that we had a 3rd party pulling the files and providing them too us. It appears the 3rd party company minapulated the files slightly before sending them since the dataport worked and now with the files we pull directly it does not.

I am not a NAV developer but did some debugging and it appears the issue is similar to the problem Notepad has reading files genearate in Linux. The Line Feed / Carrige Return are not being recognized by the <<New Line>> in the datport setup. The data port code is set to test the first 3 characters. HDR is ignore and DTL is processed. However the variable used to test is not filling line by line. Instead it fills to its max length of 50 characters. So the data port isn't seeing the line feeds. At the hex level the 3rd party files and the ones we pull are different but most softwares reconize both forms of line feed. Can we make NAV recognize the line feed? below is a sample.

HDRS01sales 081230
DTL013245510500000020143
DTL013245510600000069979
DTL013245522000000001097
DTL013245510400000025473

Comments

  • SavatageSavatage Member Posts: 7,142
    say you have 3 fields all crunched

    field1field2field3

    When the 3 fields are filled the dataport starts again.
    how is you dataport setup?

    None=Start & End Field Seperators?
    Record Separator <<New Line>>?

    is the data being imported into 1 variable & using copystr - cut into it's seperate fields?

    I assume DTL is the detail lines of the sales header. does the dataport have a
    LineNo := LineNo + 10000; type of code somewhere
Sign In or Register to comment.