Dataport Export (add to existing file)

stefangur
stefangur Member Posts: 6
edited 2005-01-11 in Navision Attain
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?

Comments

  • g_dreyer
    g_dreyer Member Posts: 123
    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
    Morten_Solberg Member Posts: 24
    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
    Jelias1 Member Posts: 35
    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.

Categories