File Handling in Business Central SaaS

Hello readers,
Today I'm going to discuss on file handling in business central SaaS. 
Already other bloggers have been written for onpremis.

As we know that business central discontinued the File variable to handle the files. 

But we can handle this using FileStream. 

Below is the list that i will cover in my blog. 

File Handling in Business Central – SaaS

• Import Picture with/without Camera
• Export Picture
• Export to Excel
• Save as Report in PDF/Excel...
• Send Email with Report Attachment
• Export Data thru XMLPort
• Read/Append Text file

Import Picture with/without Camera:
To upload the picture in business central (SaaS), we need to extend “Camera Interaction” page in our project.
Another option is also available to upload files using stream.
For demo purpose I’m going to create a page extension of customer card.
Create a page extension of customer card in your project.

Add actions, Take Picture, Import picture as shown in below screenshot.

Add another action Import Picture as shown below Code

 action("Import Picture")

        {
          ApplicationArea = All;
          ToolTip = 'Import a picture file.';
          Caption = 'Import';
          Image = Import;

          trigger OnAction()var FileName: Text;
          PictureStream: InStream;
          FileFilter: Text;
          DialogCaption: Label 'Select a picture to upload';
          begin
            TestField("No.");
            if Image.HASVALUE then if not CONFIRM(OverrideImageQst)then exit;
            if UploadIntoStream(DialogCaption, '', FileFilter, FileName, PictureStream)then begin
              Image.ImportStream(PictureStream, FileName);
              Modify(TRUE);
            end;
          end;
        }

//======================\\

For Exporting see the below screen shot. 

Publish the extension, after publishing the extension login the business central , open the customer card as shown in below screen shot. 

Click on Take Picture to upload the customer picture.

Note:
Currently TakePicture only supported in inbuilt camera. Like Mobile, Tablet client.
You can also use in laptop or desktop but you need to install the Business Central App from Store.
Currently Camera is not supported in browsers.

To test another action click on Import Picture as shown in below screen shot.

For Exporting the picture just click on Export Picture, picture will automatically download in your download location. 

For today that's it, Thank you for reading.
Feel free to commenting your opinion.

Will cover the remaining in our next blog.