Read lines from file

[Joel_Bailie (Joel Ray Bailie)]

I am doing this in my Epicor Kinetic function…

using (StreamReader reader = new StreamReader(Path.Combine(filePath, FileName)))

and get this when I try to save, Is there something else I should be using so it will last?

The ‘System.IO.StreamReader.StreamReader(string)’ constructor cannot be called.

It is a warning now but will become an error in the future. Have you guys seen this? If so, how did you address it?

[klincecum (Kevin Lincecum)]

Checking if file exists in a BPM method directive

Did someone say my name? The safer way has already been provided. We introduced a new Sandbox class for custom code that (among other things), allows you to access the file system in a way that is safe and portable as we continue to evolve how Kinetic is hosted. I created a gist with code samples that show how to use this. You will see that the syntax is almost identical. You replace System.IO with Sandbox.IO. The biggest difference is that instead of working with arbitrary absolute…

Where is your file, I could whip up a quick example, or point you to one.

[aarong (Aaron Gulley)]

**Correct Way Using the Sandbox **

To read a file in your function, instead of this:

using (StreamReader reader = new StreamReader(Path.Combine(filePath, FileName)))

var filePath = new FilePath(ServerFolder.CompanyData, "SubFolder", "FileName.txt");
using (var streamReader = this.Sandbox.IO.File.OpenText(filePath))
{
    string line = streamReader.ReadLine();
    this.output = $"First line: {line}";
}

Key Fixes

• FilePath is used instead of raw string paths.
• this.Sandbox.IO.File.OpenText(filePath) is used instead of new StreamReader(...).

Example Folder Setup

You can only use ServerFolder.CompanyData or ServerFolder.UserData. So if your file is in \\EpicorServer\CompanyData\Folder_Name\myfile.txt, the correct path would be:

var filePath = new FilePath(ServerFolder.CompanyData, "Folder_Name", "myfile.txt");

SaaS

var folderPath = new FilePath(ServerFolder.CompanyData, "Folder_Name");
folderPath.Combine(this.FileName); 
var filePath = folderPath;

I personally add sections like this to functions that use uploaded files.

// Rename the file to a unique name if it already exists
string uniqueFileName = Guid.NewGuid().ToString() + "_" + this.callContextClient.CurrentUserId + "_" + this.FileName;
var backupPath = new FilePath(ServerFolder.CompanyData, "Folder_Name");
backupPath.Combine(uniqueFileName);

if (this.Sandbox.IO.File.Exists(filePath))
{
  this.Sandbox.IO.File.Move(filePath, backupPath, overwrite: true);
  filePath = backupPath;
}

[Joel_Bailie (Joel Ray Bailie)]

@aarong

var filePath = new FilePath(ServerFolder.CompanyData, "SubFolder", "FileName.txt");
using (var streamReader = this.Sandbox.IO.File.OpenText(filePath))
{
    string line = streamReader.ReadLine();

Thanks folks!!!

[klincecum (Kevin Lincecum)]

@aarong

**Correct Sanctioned Way Using the Sandbox **

FTFY

[aarong (Aaron Gulley)]