How can I run external Application from Navision

ik
ik Member Posts: 22
edited 2004-07-15 in Navision Attain
Where can I find example of run external Application from Navision.
I think I should using RunObject -> RunCommand but don't know
format of this string parametr.

Thanx.

Comments

  • Savatage
    Savatage Member Posts: 7,142
    http://www.mibuso.com/forum/viewtopic.p ... =hyperlink
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Christian_Buehl
    Christian_Buehl Member Posts: 145
    1. use the command shell interface (see C/AL help for usage) 
    retval := SHELL('anyBatch.bat');
IF retval <> 0 THEN ERROR('Problemn wit Batchfile');


    2. Ose an ocx (Here an example with the Navision Pad OCX) 
    Var: OCX_App	 Type:Automation	Subtype: 'Navpad20'.Form	

OCX_App.EditText := 'Your text line 1';
OCX_App.Pad;

    Or use calling the Webinterface with Perl-CGI or PHP in background (I didn't tried yet, but I'm thinking about calling a hyperlink with parameters)
  • Savatage
    Savatage Member Posts: 7,142
    You can open a WinWord-Document within Navision with the SHELL-statement such as ..

    SHELL ('C:\Office\WinWord.EXE D:\Documents\Navision\MyDocument.doc);

    But you can achieve the same with the Hyperlink statement:

    hyperlink('D:\Documents\Navision\MyDocument.doc');

    Of course this works with all registered document types:
    hyperlink('MySheet.xls'); --> opens Excel
    hyperlink('MyDok.pdf'); --> opens Acrobat

    Marcus Fabian
    m.fabian@thenet.ch
    +41 79 439 78 72
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Christian_Buehl
    Christian_Buehl Member Posts: 145
    I wold not use the hyperlink statement for opening a program.
    Reason is that you connect to the document and you open the application which (usually) is linked to the file extension.
    Sometimes this works, sometimes not, sometimes an unexpected application is opened. And you can only open the document but not do any modifications.

    A much better method is to use the Automation Controller (see many examples here in the forum) for controlling.
  • DenSter
    DenSter Member Posts: 8,307
    Christian Buehl wrote:
    <snip>
    And you can only open the document but not do any modifications.
    <snap>
    I thought hyperlink just opens the application that is linked to the file's extension? I'm pretty sure that if you launch Word like this that you can modify the document.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Christian_Buehl
    Christian_Buehl Member Posts: 145
    Sorry for this misunderstanding.
    What I meant was, that you can't take control by navision what should happen with the document. E.g. to insert any data from the database into Word. The only thing you can do is open the document and do the rest manually.

    If you have associated any other application like Wordpad or Staroffice with the .doc extension, this application will open instead of Word. So it's not clear what's happening when you use the hyperlink.
    Unlike Unix Windows is not storing the related application in datafiles, applications are identified only by the extension. As I'm not personally a friend of using only Microsoft Products for all and everything I have to consider these arguments. Otherwise MS will have sometimes unlimited control on my Company due to the monopilizing practize MS is showing the last time.
  • KWA
    KWA Member Posts: 5
    Maybe you can use the Application with the Automation Server. A lot of common Applications (e.g. Word,Outlook etc.) give you the abillity.


    Kind Regards
  • PaLPiTaTioN
    PaLPiTaTioN Member Posts: 55
    I tried the HYPERLINK-procedure for opening a CSV-file, but alas the users with a Dutch Excel'97 get all output data in one column. I use an English Excel'2000 which works alright.

    The SHELL-procedure would require a default installation location for Excel; something I can't be sure about.

    I can't try the Automation Server, because I can't choose Automation as a type for Global Variables. Does anyone know if I'm missing some Navision module or something?


    edit: meanwhile I found a solution for my problem by using SHELL. I found out that I can just pick the default installation location for all pcs here have Office installed in that directory.

Categories