How to export data using TextBuilder in Business central.
Views (63)
Amol Salvi
18,698
Like
Share
Report
Today we will see how we can data from business central table using new data type Text Builder.
To check how this data type work build small program as below which pick up data from customer table and export the data in text file.
pageextension 50101 CustomerMasterExtension extends "Customer List"
{
actions
{
addlast(General)
{
action(DataExport)
{
Caption='Data Export to Text';
ApplicationArea=All;
PromotedCategory=Process;
Promoted=true;
Image=ExportDatabase;
trigger OnAction()
var
CustomerMaster :Record Customer;
Tempblob:Codeunit "Temp Blob";
TextFileBuilder :TextBuilder;
FileName:Text;
InStreamData:InStream;
OutStreamData:OutStream;
begin
FileName:='CustomerData.Txt';
TextFileBuilder.AppendLine('Customer No'+','+'Customer Name'+','+'Balance');
If CustomerMaster.FindSet() then repeat
CustomerMaster.SetAutoCalcFields(CustomerMaster.Balance);
TextFileBuilder.AppendLine(CustomerMaster."No."+','+CustomerMaster.Name+','+Format(CustomerMaster.Balance));
until CustomerMaster.Next()=0;
Tempblob.CreateOutStream(OutStreamData);
OutStreamData.WriteText(TextFileBuilder.ToText());
Tempblob.CreateInStream(InStreamData);
DownloadFromStream(InStreamData,'','','',FileName);
end;
}
}
}
}
If you look at the above code it is taking required data from customer table and export the data in text file as below.
To get more insight of data type have a look at MS documentation from below link
Hope this will help you.
Stay tuned for more.
This was originally posted here.
*This post is locked for comments