TASKS
-----------------------------------------------------
(1) Run XYZTool.exe from "C:\Sample path\XYZTool.exe"
(2) Wait till the "Continue to enter data" Window appears
(3) Click "Continue" from "Continue to enter data" Window
(4) Wait till the "Input XYZ" Window appears
(5) Clears "Y" and "Z" input text box from the "Input XYZ" Window
(6) Set "X" input text box to "SampleX" and "Z" to "SampleY" - (Sets text from script code, not from DB/Table)
(7) Clears, and Set Input text "X" by Reading from CSV/Excel/MySql the list line-by-line (per macro repetition/loop) found in the "X" column and by relating "windows_user" (get current Windows username and match "windows_user" column). (Each loop, clears and inputs line-by-line from "X" column relating the current Windows user to the "X" input box) – (Loops start from Task (7))
(8) Click "OK" from the "Input XYZ" Window
(9) Wait and If the "XYZ Main" window appears, click "OK", goto Task (7), and continue Loop. 
(10) Else, wait "Thank you. X, Y, and Z Input are correct." window, and click "OK". And Exit/Stop AutoIT


TASKS-LOG
-----------------------------------------------------
(1-Log1) Set "Log_RunExe" to "Yes" if the task is a success, if not Set "Log_RunExe" to "No"
(2-Log1) Set "Log_Window_1" to "Yes" if the task is a success, if not Set "Log_Window_1" to "No"
(3-Log1) Set "Log_Button_1" to "Yes" if the task is a success, if not Set "Log_Button_1" to "No"
(4-Log1) Set "Log_Window_2" to "Yes" if the task is a success, if not Set "Log_Window_2" to "No"
(5-Log1) Set "Log_Clear_1" to "Yes" if the task is a success, if not Set "Log_Clear_1" to "No"
(6-Log1) Set "Log_Input_1" to "Yes" if the task is a success, if not Set "Log_Input_1" to "No"
(7-Log1) Set the "Log_Loop_Finish" column to "Yes", When the number of loops is finished. 
(10-Log1) Set the "Log_Success_DataY" column from the last "Y" input box text 
(10-Log2) Set the "Log_Success_DataX" column from the last "X" input box text 
(10-Log3) Set the "Log_Task_Finish" column to "Yes"

(General-Log1) Set the "Log_Fail_Reason" column to the corresponding error, if any task fails (window not responding, AutoIt quits unexpectedly etc..)



NB-MARK WELL
-----------------------------------------------------
NB(1) Number of loops = Number of rows found in "X" column by matching the current Windows username and "windows_username" column 
NB(2) Sample CSV/Excel Input Data and Log files are found under the "Sample" folder
NB(3) All Log input shall match the Windows username, and "windows_username", "X" and "Y" columns
NB(4)- Read/Write data to CSV/Excel/MySql without opening CSV/Excel/MySql file
NB(5)- Loop shall start from Task (7)


QUESTIONS
-----------------------------------------------------
Question(1)= CSV/Excel/Mysql choice is available to choose for the fastest, most stable, and lowest resource consumption. If any better platform is available, kindly suggest

Question(2)= Is it possible to log the time taken to finish the loop? 
For Example= 1- Set "Log_Elapsed_Time_Loop" to the time taken to finish the loop and Set "Log_Elapsed_Loops" to the number of loops taken to finish the loop. 
             2- Set "Log_Elapsed_Time_Fail" to the time taken to fail a task and "Log_Elapsed_Loops_Fail" to the number of loops to end the loop.
			 
Question(3)= Is there any AutoIt alternative that is a faster, reliable, light, and low-resource platform for automation?

Question(4)= When running the current project, is it possible to achieve 10 or more loops (to accomplish in 1 second?