SHELL function and ftp.exe

Answers

• mihail_kolev Member Posts: 379

  2009-10-15

  This one may be useful: viewtopic.php?f=32&t=31440
  

  What am I missing??

  I guess double quotes ("").
  
  make it '"ftp.exe -s:C:\DOCUME~1\sge\LOKALE~1\Temp\sendftp.txt"'

  -Mihail- [MCTS]

  0
• Tintin25 Member Posts: 14

  2009-10-15

  mihail_kolev wrote:

  This one may be useful: viewtopic.php?f=32&t=31440
  

  What am I missing??

  I guess double quotes ("").
  
  make it '"ftp.exe -s:C:\DOCUME~1\sge\LOKALE~1\Temp\sendftp.txt"'

  
  I already tried that...stil saying that a sign is not allowed...

  0
• DenSter Member Posts: 8,307

  2009-10-15

  Have you tried the full path? So "Documents And Settings" instead of "Docume~1"?

  Daniel Rimmelzwaan
  RIS Plus, LLC

  0
• Tintin25 Member Posts: 14

  2009-10-15

  DenSter wrote:

  Have you tried the full path? So "Documents And Settings" instead of "Docume~1"?

  
  Yeah, the thing is the path must not have any spaces and according to the documentation to fill the space you have to use something like this %~f0, and I think the problem is the sign "~".
  
  But on the other hand I also tried just place the sendftp.txt and xml file in a local directory like c:\temp so the function call is SHELL('ftp.exe -s:C\Temp\sendftp.txt') - just hardcoded it. Again if I execute it from Nav it will give a error but if I execute from cmd: ftp.exe -s:C\Temp\sendftp.txt no problem.

  0
• matttrax Member Posts: 2,309

  2009-10-15

  I assume ftp.exe can be called from any path? You haven't changed to that directory in the command prompt and then run it, right?

  Matt Traxinger - ArcherPoint

  0
• Tintin25 Member Posts: 14

  2009-10-15

  matttrax wrote:

  I assume ftp.exe can be called from any path? You haven't changed to that directory in the command prompt and then run it, right?

  
  Yep thats correct but I not sure if I follow you regarding changing directory. Can you give me an example?
  
  We have just upgraded from a Navision 3.60 to a Nav 2009 version and I not sure SHELL function have changed...

  0
• ara3n Member Posts: 9,258

  2009-10-15

  shell function has changed in 2k9.
  
  You need to hit F1 and you'll the documentation.
  
  Basically parameters need to be passed separately
  
  SEHLL('FTP.EXE',pARAM1, pARAMETER2);

  Ahmed Rashed Amini
  Independent Consultant/Developer
  
  
  blog: https://dynamicsuser.net/nav/b/ara3n

  0
• Tintin25 Member Posts: 14

  2009-10-16

  Hello all
  
  Thanks for all the help and you all lead me in the right direction.
  
  The solution to my problem is:
  
  ShellRetCode := SHELL('c:\windows\system32\ftp.exe', '-s:' + Command_File);
  
  As noticed you have to specify the hole directory where ftp.exe is located and as ara3n pointed out the SHELL function have changed since (i'm just a junior consultant ).

  0
• DenSter Member Posts: 8,307

  2009-10-16

  Tintin25 wrote:

  i'm just a junior consultant

  Don't sell yourself short, you got the job done didn't you. Besides, senior consultants learn new things every day, so get used to being in "figuring out mode"
  
  Thanks for the follow up, that's what makes this a very valuable post :thumbsup:

  Daniel Rimmelzwaan
  RIS Plus, LLC

  0