Fetch excel file through NAS

pralaykumardas

Hello,

I implemented many projects through NAS. Recently I got surprised when I integrated NAS with excel file. The details of the project is given below,

We have to read some auto generated excel file through NAS by a scheduler. We installed NAS in Windows Server 2008 R2. Excel file reading code was written in a codeunit. While we call the codeunit, it reads the excel file from a particular location and writes in a particular table. We followed these three scenario.

i. We developed a manual button and called the codeunit behind the button.

Result: Data from the excel file was fetched and written in the NAV table perfectly.

ii. We called the codeunit from a timer and attached the timer at CompanyOpen Trigger. Set the timer for a particular time, by coding.

Result: Data from the excel file was fetched and written in the NAV table perfectly as per the time set in timer.

iii. We called the codeunit from a timer and attached the timer with NAS. Set the timer for a particular time, by coding.

Result: NAS is not able to fetch the excel file. I checked the process and followed that the function was called perfectly. problem appeared while calling excel file.

iv. I creted an exe of same function in dot net application.

Result: It worked fine when I ran it manually. Problem of excel fetching appeared when I attached it with SQL Server scheduler.



I tested my all applications in Windows Server 2008. I went through many posts where it was mentioned that NAS cannot fetch Excel file if it runs in Windows Server 2008. Is it true? If no then where is my fault? If yes is there any solution to overcome the problem?

Thanks in advance for your valuable reply

Chinmoy

I am sure you must have checked the user security option, but that is the first thing that comes to my mind. Does the user account who is running NAS service have access to the folder and the excel file you are trying to read?

Chn

ppavuk

check this: viewtopic.php?f=23&t=55207

pralaykumardas

Thanks ppavuk for the reply. I already checked these forums. I also mentioned that some people tested that NAS cannot fetch MS Office in Windows Server 2008 environment. That's why I build an exe in dot net which behaved same. So there must be some problem with dot net framework in 2008 Server.
Yesterday I tested all of them in Windows Server 2003 Environment and executed perfectly.

mdPartnerNL

You also found the topic in which you needed to add two folders? It does work when login as the nas domain account user? Can you create a excel file? On what moment does it go wrong?

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision Classic Client' forum]