Reading Excel from NAS

danielecacchi
danielecacchi Member Posts: 13
edited 2011-08-15 in NAV/Navision Classic Client
I've a Native database 5.0.

I've created a function to import data from excel files (through "Excel Buffer" functions).
As soon as I'm working from usual client (windows authentication) , it works fine.

If I try to work from NAS (with the same windows login) , I receive the error:
"The call to member Open failed.....", saying it can't access to the excel file that I correctly open from Client 5.0.

Is NOT supported reading excel files with under NAS?
Thank you in advance

Comments

  • danielecacchi
    danielecacchi Member Posts: 13
    I've simulated everything on my computer (Vista): The service for native database , the client 5.0 and the NAS service (started with my own windows login which is member of the administartors of the computer).
    And Excel 2007 installed.

    I use a report with the classic
    ExcelBuf.OpenBook(FileName,SheetName) and ExcelBuf.ReadSheet
    to open and read excel files.

    Well , with client 5.0 launching the report --> everything right;
    with nas.exe called in a dos session --> everything right;
    with NAS I've the error in the event viewer:

    "This message is for C/AL programmers:

    The call to member Open failed. Microsoft Office Excel returned the following message:
    Impossibile accedere al file "\\miocomputer\Input\nomefile.xls". I motivi possibili sono:
    • Il nome o il percorso" ,

    where the message is truncated, but it says that it cannot access to the file, maybe the name or path is wrong.

    Is there anyone reading excel file in NAS ? As I'm supposing excel 2007 not supporting undergroung reads.
  • Belias
    Belias Member Posts: 2,998
    what if you digit the path in your "run..." window?(start>run..) from winxp?(i don't know where's on vista) :lol:
    if the file is opened, the problem is somewhere else, if not, try to locate your file with the syntax appeared in the error, then digit it as the input file and retry
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • danielecacchi
    danielecacchi Member Posts: 13
    The error I show is taken from the EventViewer of my PC, and if I double click on the excel file name in the error , I open the excel correctly.
    As soon as I'm in a interactive environment , I've no problem.
    If I'm in the service environment , I've all the problems. ](*,)
  • jannestig
    jannestig Member Posts: 1,000
    this post seems to solve the issue.

    viewtopic.php?f=23&t=26971&hilit=excel+NAS&start=15
  • danielecacchi
    danielecacchi Member Posts: 13
    jannestig wrote:
    this post seems to solve the issue.

    viewtopic.php?f=23&t=26971&hilit=excel+NAS&start=15

    Thank you for help.
    Yes , I've Read , but I am a step after.

    That is , in function OpenBook (Table 370) there is :
    ..
    IF NOT CREATE(XlApp,TRUE) THEN
    ERROR(Text000);

    XlApp.Workbooks.Open(FileName);

    And the previous post there was the error Text000.("Excel not found")

    On the contrary , my service is stopping in XlApp.Workbooks.Open(FileName).

    I've re-installed excel , I've installed the NAS service in a dos session started with "Run as administrator" , but nothing.
  • Wog
    Wog Member Posts: 13
    Hello.

    Have you found solution for this?
    I have the same problem on Windows Server 2008 and NAS running as a service on it.

    Thank you.
  • KYDutchie
    KYDutchie Member Posts: 345
    Hi all,

    there are a couple of things you need to make sure off.
    1. The NAS cannot handle any form of screen out/input, so make sure that your excel app is running in the background.
    2. The user account that runs the NAS must have access to the excel file, excel buffer table.
    3. When you load an excel sheet through the excel buffer table, the trigger will pop up a dialog window. You will have to prevent that with the GUIALLOWED statement.

    When you have done all this, it will work. We did it like this.

    Hope this helps,

    Willy
    Fostering a homeless, abused child is the hardest yet most rewarding thing I have ever done.
  • Wog
    Wog Member Posts: 13
    Thank you for your advice, but I think this is not the problem I have here.
    The problem started after server upgrade to Windows Server 2008 and exe upgrade from NAV400SP3 to NAV500SP1.
    Before upgrade the same process worked fine on NAS.
  • mafi
    mafi Member Posts: 2
    Hi,
    Has anyone solved this problem?
    I have exactly the same problem.
  • mafi
    mafi Member Posts: 2
    The solution I have found here:
    http://social.msdn.microsoft.com/Forums/en/innovateonoffice/thread/b81a3c4e-62db-488b-af06-44421818ef91

    Regards.
  • InfoWissler
    InfoWissler Member Posts: 10
    Does anyone have an idea how to solve this on Windows Server 2003 R2 + Excel 2010?

    The folder C:\Windows\System32\config\systemprofile\Desktop already exists.

Categories