How to handle EOF in dataport with empty <Newline

tomik
tomik Member Posts: 3
Hi All,

I have to import data which is structered:
BOM Component parent nr.<TAB>Description<NewLine>
BOM Component nr.<TAB>Quantity<Newline>
<NewLine>
BOM Component parent nr.<TAB>Description<NewLine>
BOM Component nr.<TAB>Quantity<Newline>
BOM Component nr.<TAB>Quantity<Newline>
<NewLine>
BOM Compionent parent nr.<TAB>Description<NewLine>
BOM Component nr.<TAB>Quantity<Newline>
<NewLine>
<NewLine>
<NewLine>
<NewLine>

Dataport has one DataItem Integer, which handels data and creates BOM Components.

Problem is that dataport stops importing after first <NewLine> that is "alone". Why NAvision stops there? Is there ant way to continue after that first <NewLine>? Should I use InStream?

Best Regards,
Tomi

Answers

  • kine
    kine Member Posts: 12,562
    You need to change the DataItem separator in Dataport properties.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • tomik
    tomik Member Posts: 3
    Hi kine,

    I changed DataItem seperator to <None> and made calculation for empty DataItem[1] > 2 then Dataport.break. This seems to work fine.

    Thank you!