Documentation | MentDB Weak Server
Generate MQL to UPLOAD files to a remote sFTP connection

  • To generate MQL to UPLOAD files to a remote sFTP connection:
  • Right click on 'demo_cm_sftp' and select 'GEN > UPLOAD FILES'
  • script create post "demo.file.sftp.upload" false 1 
      	(var "[localDirectory]" {true} "The local directory" is_null:false is_empty:false "/Users/jimmitry/Desktop/ftp")
      	(var "[filter]" {true} "The file filter from the remote directory" is_null:false is_empty:false ".*png")
      	(var "[remoteDirectory]" {true} "The remote directory" is_null:false is_empty:false "/Users/jimmitry/Desktop")
      "Upload file through SFTP" 
    	try {
    		#Connect to the SFTP server;
    		sftp connect "session1" {cm get "demo_cm_sftp";};
    		#Move to the remote directory;
    		sftp cd "session1" [remoteDirectory];
    		#Get all local files;
    		json load "files" (file dir_list_regex [localDirectory] [filter] true true);
    		#Put all files;
    		-> "[nbFiles]" (json count "files" "/");
    		for (-> "[i]" 0) (< [i] [nbFiles]) (++ "[i]") {
    			-> "[filename]" (json select "files" (concat "/[" [i] "]"));
    			sftp put "session1" (concat [localDirectory] "/" [filename]) (concat [localDirectory] "/" [filename]) "RESUME";
    		sftp disconnect "session1";
    	} {
    		#Close objects;
    		try {sftp disconnect "session1";} {} "[sub_err]";
    		#Generate an error;
    		exception (1) ([err]);
    	} "[err]";
    } "Return nothing";
  • Update the script and save
  • Execute buttons
Services     Supporters     Contact     About     Legal notice © 2023