topic Re: How to create a JMP script that pulls data from multiple directories using FTP? in Discussions

How to create a JMP script that pulls data from multiple directories using FTP?

chadw — Fri, 09 Jan 2015 19:27:14 GMT

Hello,

I am trying to create a JMP script that would connect to an FTP server and then pull in datasets from multiple directories. Using the File > Open Internet, I have been able to connect to the FTP server and view it as a web page but I am limited to only the Home directory.

So my question is, is it possible to create a JMP script that connects to an FTP server and then navigate to pre-defined directories to pull in data?

Thanks for the help!

Re: How to create a JMP script that pulls data from multiple directories using FTP?

jara95 — Thu, 15 Jan 2015 15:08:23 GMT

If your JMP program runs in Windows, you can create the FTP script and run it using JSL.

Below the JSL example copies all files having names starting with FILE_NAME in the FTP directory using mget command.

ftp_txt="

\!nopen 192.168.1.10

\!nuser FTP_USER_ID PASSWORD

\!nftp

\!ncd FOLDER/LOCATION/

\!nlcd C:\LOCAL\FOLDER

\!nprompt

\!nmget FILE_NAME*

\!nbye

\!n

save text file("c:\test.ftp",ftp_txt);

cmd_txt = "ftp -v -n -s:c:\test.ftp";

save text file("c:\jmp_ftp.bat",cmd_txt);

wait(1);

open("c:\jmp_ftp.bat");

Re: How to create a JMP script that pulls data from multiple directories using FTP?

chadw — Thu, 15 Jan 2015 19:40:22 GMT

Thanks for this solution jara95! It is kind of round-about way of going about it, but it definitely works.

Re: How to create a JMP script that pulls data from multiple directories using FTP?

Craige_Hales — Fri, 16 Jan 2015 13:18:36 GMT

JMP 11 has another way to use programs like FTP, see this post on the RunProgram function which lets you control command line programs by sending them commands from JSL and reading their output with JSL.

Thanks to jara95 for the hint on the FTP options and commands...I needed that.