Importing a .txt file through Role Tailored Client

TESDarrenA
TESDarrenA Member Posts: 11
edited 2010-08-26 in NAV Three Tier
Hi,

Is anyone successfully importing .txt files through the RTC into NAV?

I'm not having much luck reading it into the excel buffer table.

I get "The specified Path is Invalid"


If I run the same code through classic client it works perfect. ](*,)

Cheers for your time.

Comments

  • kriki
    kriki Member, Moderator Posts: 9,133
    In RTC, the path is NOT on the client but on the service tier.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • manger
    manger Member Posts: 3
    Is it possible in the RTC to access to the local files ?
    Something like IMPORT in the classic client ?
  • bbrown
    bbrown Member Posts: 3,268
    Use UNC path to specify the file location.
    There are no bugs - only undocumented features.
  • thmartin
    thmartin Member Posts: 90
    manger wrote:
    Is it possible in the RTC to access to the local files ?
    Something like IMPORT in the classic client ?

    There are some functions to handle this. UPLOAD, DOWNLOAD etc.
    You can find find an example for importing a BLOB in Codeunit 419 3-Tier Automation Mgt..
    Thomas Martin
    NAV Developer
  • BardurKnudsen
    BardurKnudsen Member, Microsoft Employee Posts: 137
    I suggest that you look into codeunit 419 "3-Tier Automation Mgt." for inspiration. NAV2009 has some new C/AL commands for handling up- and download to/from the server, e.g. DOWNLOAD(FromFile,DialogTitle,ToFolder,ToFilter,ToFile). The functions are defined both for files and streams.
    Bardur Knudsen
    Microsoft - Dynamics NAV

Categories