INNOV-AI

> 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 XML ITEM'

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

	#Initialization;
	-> "[targetPath]" "/data/item";

	#Load the connection id;
	json load "cm" (cm get "demo_cm_file");
	-> "[localDir]" (json select "cm" /localDir);

	#Load the file;
	xml load "xmlId1" (file load (concat [localDir] "/" [fileName]));

	-> "[nb]" (xml count "xmlId1" [targetPath]);
	
	#Parse the tab;
	for (-> "[i]" 1) (<= [i] [nb]) (++ "[i]") {

		#Get value;
		-> "[to_use]" (xml select text "xmlId1" (concat [targetPath] "[" [i] "]"));

		#Your action here ...;
		log trace (concat "[to_use]=" [to_use]);

		
	
	};
	
} "Return nothing";