DataPort New Line Issue

franklin1232
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
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
0
Comments
-
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 somewhere0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions