Options

Carriage Return to end of Dataport

RabeRabe Member Posts: 27
edited 2003-08-19 in Navision Financials
Hello Everybody,

Looking for some light at the end of the tunnel :lol: .

Navison 2.6-D :

I am currently exporting data using a standard Navision dataport and then FTP the Data to another server. Client requested that the file should be appended to the original file (Which works like a bom :shock: ) The problem I'm facing is that navision does not add a carriage Return Character to the end of the created text file so that when you append to the original file the format is all wrong. (It adds the first line of the second text file to the last line of the first text file)

Thank you in Advance
Rabe Pienaar

Comments

  • Options
    Torben_R.Torben_R. Member Posts: 99
    Try this - works only with one DataItem:
    Change the property DataItemSeparator from <NewLine><NewLine> to <NewLine>

    Add two new Global Variables
    Char13 Char
    Text13 Text

    Add a new DataItem - Integer - to the Dataport.
    DataItemTableView: Number Const 1
    Add Text13 as a DataportField

    Code on OnPreDataItem
    Char13 := 13;
    Text13 := FORMAT(Char13);

    You will now have a Carrige Return at the end of the file.
  • Options
    RabeRabe Member Posts: 27
    Thank You Torben....

    Just what I was looking for
Sign In or Register to comment.