Microsoft Dynamics AX (Archived)

System.ArgumentException: The path is not of a legal form - while reading csv in batch

(1) Share

Report

Posted on by Gautam

3,945

Hi all,

Greetings of the day,

We are trying to read csv from a directory using batch job, but when batch job executes its thows error - System.ArgumentException: The path is not of a legal form .

Suggest us how do we proceed.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi.,

Please specify the filepath in UNC format like @"\\MachineName\Sample\Sample.csv".

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

Hi Chaitanya ,

Thanks for your reply,

our path is somewhat like this - C:\Import ,

how do we convert it into UNC.

Thanks .

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

UNC path in your case would be @"C:\Import\Sample.csv"

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

Hi,

here is my code , I have added "@" before file path but still no luck

void readFilesFromDirectory( )

{

System.IO.DirectoryInfo directory;

System.IO.FileInfo[] files;

System.IO.FileInfo file;

InteropPermission permission;

str _filePattern = "*.csv";

Table1 tab;

str _folderPath;

str fileName;

counter filesCount;

counter fileCounter;

System.Environment env;

;

try

{

_folderPath = "@"+ "C:\Import";

permission = new InteropPermission(InteropKind::ClrInterop);

permission.assert();

directory = new System.IO.DirectoryInfo(_folderPath);

files = directory.GetFiles(_filePattern);

filesCount = files.get_Length();

for (fileCounter = 0; fileCounter < filesCount; fileCounter++)

{

file = files.GetValue(fileCounter);

fileName = file.get_FullName();

tab.Name = fileName; // storing file name in table

tab.insert();

}

CodeAccessPermission::revertAssert();

}

catch(Exception::CLRError)

{

}

}

Thanks

Gautam

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

Please try with the statement _folderPath = @"C:\Import";

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

Hi,

I tried this piece of code _folderPath = @ledgerParameters.filepath // we are storing that file path in parameter table

but it throws same exception : - System.ArgumentException: The path is not of a legal form.

at System.IO.Path.LegacyNormalizePath(String path, Boolean fullCheck, Int32 maxPathLength, Boolean expandShortPaths)

Thanks

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

What is the value that getting stored in filepath field. Please use winapiserver::pathexists to check whether the path is getting recognised or not.

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

Hi ,

in file path field we are storing directory path from where we need to read csv.

like - C:\Import

Thanks

Was this reply helpful? Yes No

Community site session details

System.ArgumentException: The path is not of a legal form - while reading csv in batch

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

System.ArgumentException: The path is not of a legal form - while reading csv in batch

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates