Error when we try to read Excel file with OpenXML variable or with Excel buffer. NAVISION 2015

Xhevat · 2016-03-14

We have a problem to open files from users client.

When we try to open Excel file with OpenXml dotnet variable, we get an error: A call to Microsoft.Dynamics.NAV.OpenXml.Spreadsheet.WorkbookReader.Open failed with this message: "C:\Test.xlsx"

Same problem we have when we try to open text files or xml file, we get an error that file cant't open.

We have installed navision service on Server, users are connected from theirs computer to server with Roletailored client.

Xhevat · 2016-03-15

Thank you RockWithNAV for your reply.

I have found the solution.

I have use UPLOAD() function to upload files from Client to Server:
https://msdn.microsoft.com/en-us/library/dd301144.aspx

RockWithNAV · 2016-03-14

Hey Xhevat,

See this link it may help you.

https://community.dynamics.com/nav/f/34/t/123879

Thanks
Blog rockwithnav.wordpress.com/

Xhevat · 2016-03-14

Thank you RockWithNAV for your reply.
Link did not help me.

Same problem is for all files.

With same user if we are on server we can open file, but if we try to open file from another computer with same user, we can't open file and we get error:

For Example if we try to open text file with "MyFile.OPEN(D:\Test.txt)". We get an error: "FIle

\Test.txt was not found".

RockWithNAV · 2016-03-14

Hi Xhevat,

What you said is
With same user if we are on server we can open file, but if we try to open file from another computer with same user, we can't open file and we get error:

Whenever you are opening any file, system always checks in Client Computer like if you made a path - C:/NAV/File on Server computer and you are accessing it on the server then it will easily ind but if you will try to execute it from from different computer SAY B computer then system will try to find this path C:/NAV/File on B computer only not on the server hence it will give this error.

If you have given a browse button logic to import then you need to write a code internally which will will copy the current clients browsed file to the server computer path.

Hope this helps

Thanks https://rockwithnav.wordpress.com/

Xhevat · 2016-03-14

Hi RockWithNAV.

We are using Domain Account User.

For Example with user: "Xhevatt", if I connect with remote on server where Nav Service is installed. I can open files and no error ocurr.

But if I am connected from another computer that is on domain with user: "Xhevatt" and if I try to open files from local computer, not from server, I am getting error that file was not found.

RockWithNAV · 2016-03-14

Hey Xhevat ,

You are taking Remote Desktop Connection(RDP) of the Server computer from user Xhevatt then it's working fine. this one I understood but am so sorry still I dint understood what you meant by

But if I am connected from another computer that is on domain with user: "Xhevatt"

Xhevat · 2016-03-15

Thank you RockWithNAV for your reply.

I have found the solution.

I have use UPLOAD() function to upload files from Client to Server:
https://msdn.microsoft.com/en-us/library/dd301144.aspx

RockWithNAV · 2016-03-15

Great Xhevat,

I too have faced your prob and solved the same way i mentioned, theres many .NET interop too from which you can handle this internal transmission of files. Explore Codeunit File Management (419).

Thanks

Blog -[url=" https://rockwithnav.wordpress.com/"] https://rockwithnav.wordpress.com/[/url]

Twitter - https://twitter.com/rockwithnav

Howdy, Stranger!

Quick Links

Categories

Error when we try to read Excel file with OpenXML variable or with Excel buffer. NAVISION 2015

Best Answer

Answers