How to export data to txt file (for SaaS Model)

julkifli33

Hi All,
I notice we are no longer able use File anymore for extension SaaS model.


how do we export data to txt ?
any advice?
Thanks

ftornero

Hello @julkifli33 .

You must to use DownloadFromStream

Something like this

    procedure CreateTxtFile(FileName: Text)
    var

        InStr: InStream;
        OutStr: OutStream;
        tmpBlob: Record TempBlob temporary;
        CR: char;
        LF: char;

    begin
        CR := 13;
        LF := 10;
        tmpBlob.Blob.CreateOutStream(OutStr);        
        OutStr.WriteText('First line'+ CR + LF);
        OutStr.WriteText('Second line'+ CR + LF);
        OutStr.WriteText('Third line'+ CR + LF);        
        tmpBlob.Blob.CreateInStream(InStr);
        DownloadFromStream(InStr, '', '', '', FileName); 
    end;

Regards.

ftornero

Hello @julkifli33 .

You must to use DownloadFromStream

Something like this

    procedure CreateTxtFile(FileName: Text)
    var

        InStr: InStream;
        OutStr: OutStream;
        tmpBlob: Record TempBlob temporary;
        CR: char;
        LF: char;

    begin
        CR := 13;
        LF := 10;
        tmpBlob.Blob.CreateOutStream(OutStr);        
        OutStr.WriteText('First line'+ CR + LF);
        OutStr.WriteText('Second line'+ CR + LF);
        OutStr.WriteText('Third line'+ CR + LF);        
        tmpBlob.Blob.CreateInStream(InStr);
        DownloadFromStream(InStr, '', '', '', FileName); 
    end;

Regards.

julkifli33

Hi ftornero
thank you very much.
its working !