How to Get Client Folder

tramirez · 2006-10-18

Hye,

Do you know how can I get the Folder where I'm executing the client (fin.exe or finsql.exe)?

If in one computer I have Two installations of Navision with the same version in two diferents folders:
c:\Program Files\Micorosft Business Solutions-Navision\Client 1\
c:\Program Files\Micorosft Business Solutions-Navision\Client 2\

How can I know wich Client has ran mi application?

I need to do this because I have one file saved in BLOB format in a Navision Table, and I need to export it (in runtime) in the Client folder.

So I need to know witch is the client folder, cause is possible that the instalation is not in the default path.

Any suggestions? :roll:

Thanks a lot!!

Waldo · 2006-10-19

I'm afraid this is not possible. In C/SIDE, you dont' have enough process information to do this. I checked the virtual tables an the system methods, but nothing seems useable.

If you had a process ID, it would be possible to find the working folder or path to exe using a custom made Automation control.

Alex_Chow · 2006-10-19

Try deleting the folder while Navision is running. If it's in use, it'll give you an error.

DenSter · 2006-10-20

yeah and if it is not in use, you'll only lose your NAV installation folder

ara3n · 2006-10-20

lol. Well he had a good idea, which I'll try to improve.

How about try to copy the executable from that location to a temp location and delete the executable and copy it back if you succeed.

One question I have though is why does he want to move it to Navision directory?

Waldo · 2006-10-20

DenSter wrote:

yeah and if it is not in use, you'll only lose your NAV installation folder

=D>

Ara3n. Question is: how can you get the folder where the executable is located? You would put it in a setup table?

ara3n · 2006-10-20

You would search through the virtual file table and search for fin.exe. Or you could put a computer + User setup table.

Waldo · 2006-10-20

For performance reasons, I would go for the second one...

ara3n · 2006-10-20

well Once you find it the first time, you don't need to search again. You would put in the setup table.

Waldo · 2006-10-20

Ah, combination of the two ... nice.

Tramirez ... I think you almost have a solution.

=D>

garak · 2006-10-21

My Solution is

Write an programm with vb, c# or wsh (wsh / WMI should be do this) to analyse the processes. Serach in the processes for fin.exe or finsql.exe. When you found the programm, you can get the process properties (like installation folder) and send it back to navision (for example as stream)

see next post.

Regards

garak · 2006-10-21

OK, so i've enougth time yet (came from an party) and i wrote now this little application:

Code for WMI Script that you must call from Navision

Set wmi = GetObject("winmgmts://./root/cimv2")

wql = "select * from win32_process where name='finsql.exe'"
Set result = wmi.ExecQuery(wql)

For each prozess in result
  WSHShell.echo "Prozessname " & Prozess.Name
  WSHShell.echo "ExPath = " & Prozess.ExecutablePath
Next

Here the navision code

IF EXISTS('D:\NavZUPs\GetExecuteFolder.vbs') THEN BEGIN
  IF ISCLEAR(WSHShell) THEN
    CREATE(WSHShell);  //WSHShell.Currentdirectory should also work (not tested)

  WSHExec := WSHShell.Exec('cscript D:\NavZUPs\GetExecuteFolder.vbs');
  
  WHILE NOT WSHExec.StdOut.AtEndOfStream DO BEGIN
    ExecFolder := WSHExec.StdOut.ReadALL;
    ExecFolder := copystr(ExecFolder,Strpos(ExecFolder,'ExPath = '),strlen(ExecFolder));
  END;
end;

The DOS - Prompt you can prevent when you call the vbs with parameter (no window)

Regards

So, good night. My bed calls.
Oh, my head, some of this beers was bad :-(

garak · 2006-10-22

There is an other way to solved this problem:

Make to Shortcuts on your desktop.
First to Client one
Second to Client two

In first shortcut you insert parameter id=%userprofile%\Client1.zup
and in the second id=%userprofile%\Client2.zup

with commandline you can get the parameters.
If you found client1.zup your application runs from folder
"c:\Program Files\Micorosft Business Solutions-Navision\Client 1\"
if you found client2.zup your application runs from folder
"c:\Program Files\Micorosft Business Solutions-Navision\Client 2\"

Regards

Waldo · 2006-10-22

garak wrote:

Oh, my head, some of this beers was bad :-(

I bet it were the last ones

With the last post:
How are you going to get from Navision which ZUP-file you're using?

garak · 2006-10-22

It was the last :!: But the others are delicious

How i going to get which zup file i'm using :?:

I use (F5) System \ Commandline <- gives the start parameter like database, server, company and id (id is the place where i store the zup)

Regards

Waldo · 2006-10-22

Never used it, never needed it, but definitally nice to know. Learned something new.

Thanks!

kine · 2006-10-23

WsShell: Automation 'Windows Script Host Object Model'.WshShell

CREATE(WsShell);
MESSAGE('%1',WsShell.CurrentDirectory);

As you can see, if you do not change the current directory, you can get the App folder through this. Because if you create shortcut for the .exe file, the default dir is the app dir.

How to Get Client Folder

Comments

Categories