Dataport Export (add to existing file)

stefangur

I thought ther was a flag to determine if an export will add data to an existing file or give the 'file overwirte question', but I can't find it (or I'm wrong).
Any other idea to add data with an export dataport to an existing file or is it the hard way with file create or open, and so on?

g_dreyer

I don't think that there is a flag to append to a file.

Search the forum for adding to a file, I think it requires you to open the file, go to the end of the file and continue writing.

Regards,
gus

Morten_Solberg

It is possible to add data to an existing file.
Translate this VBScript to C/AL Code:

dim filesys, filetxt
Const ForReading = 1, ForWriting = 2, ForAppending = 8
Const FileName = "C:\SomeFile.txt"
Set filesys = WScript.CreateObject("Scripting.FileSystemObject")
Set filetxt = filesys.OpenTextFile(FileName, ForAppending, True)
filetxt.WriteLine("Your text goes here.")
filetxt.Close
Set FileSys = Nothing

Jelias1

The previous example uses the scrrun.dll Automation object. You can declare a variable of this type within Navision, then use the routine as scripted above. The FileSystemObject is very powerful and gives you complete control of file IO and querying.
Note: In order for this to run scripting must be enabled in any antivirus software that you have.
Hope this helps.