INNOV-AI

Innovation and Research from Réunion Island, France

Back   Home

Parse a CSV file from remote connection @ CONNECT - Connections @ MentDB Weak

> Start the server
> (or start the server for the first time (embedded mode - H2 Database))
> (or start the server for the first time (remote mode - MySQL 8 Database))
> Open the MentDB Weak Editor

Click on 'CONNECT' tab, open 'Remote file', right click on 'demo_cm_file' and select 'GEN > PARSE CSV FILE'

MQL INPUT
script create post "demo.file.csv.parse" false 1 
  (param
  	(var "[fileName]" {true} "The file name" is_null:false is_empty:false "test.csv")
  ;) 
  "Parse a CSV file" 
{

	#Load the connection id;
	json load "cm" (cm get "demo_cm_file");
	-> "[localDir]" (json select "cm" /localDir);
	
	csv parse "T" (concat [localDir] "/" [fileName]) "," "'" "A,B,C" {
	
		log trace [T_A];
	
	};
	
} "Return nothing";
start: 2026-01-17   end: 2026-01-31   v_start: 401   v_end: