I create a good macro code for you
Remember the only way to create automation is study. study and study or pay a professional coder.
It’s a excellent way to have unlimited random extraction from csv.
Csv:
MESSAGE 1,MESSAGE 2,MESSAGE 3,MESSAGE 4,MESSAGE 5,MESSAGE 6,MESSAGE 7,MESSAGE 8,MESSAGE 9,MESSAGE 10
Macro code:
{
"Name": "Random_Csv",
"CreationDate": "2020-10-26",
"Commands": [
{
"Command": "times",
"Target": "10",
"Value": ""
},
{
"Command": "executeScript_Sandbox",
"Target": "var min = 0; var max = 0; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber;",
"Value": "Row"
},
{
"Command": "executeScript_Sandbox",
"Target": "var min = 0; var max = 9; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber;",
"Value": "Column"
},
{
"Command": "csvReadArray",
"Target": "test.csv",
"Value": "MyCsv"
},
{
"Command": "echo",
"Target": "Loop Number: ${!TIMES}\\n\\n Row Number: ${Row}\\n\\n Column Number: ${Column}\\n\\n Random Message From Csv: ${MyCsv[${Row}][${Column}]}",
"Value": "#shownotification"
},
{
"Command": "end",
"Target": "",
"Value": ""
}
]
}
Log
[status]
Playing macro Random_Csv
[info]
Executing: | times | 10 | |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 0; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Row |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 9; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Column |
[info]
Executing: | csvReadArray | test.csv | MyCsv |
[info]
Executing: | echo | Loop Number: ${!TIMES}\n\n Row Number: ${Row}\n\n Column Number: ${Column}\n\n Random Message From Csv: ${MyCsv[${Row}][${Column}]} | #shownotification |
[echo]
Loop Number: 1
Row Number: 0
Column Number: 7
Random Message From Csv: MESSAGE 8
[info]
Executing: | end | | |
[info]
Executing: | times | 10 | |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 0; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Row |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 9; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Column |
[info]
Executing: | csvReadArray | test.csv | MyCsv |
[info]
Executing: | echo | Loop Number: ${!TIMES}\n\n Row Number: ${Row}\n\n Column Number: ${Column}\n\n Random Message From Csv: ${MyCsv[${Row}][${Column}]} | #shownotification |
[echo]
Loop Number: 2
Row Number: 0
Column Number: 1
Random Message From Csv: MESSAGE 2
[info]
Executing: | end | | |
[info]
Executing: | times | 10 | |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 0; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Row |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 9; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Column |
[info]
Executing: | csvReadArray | test.csv | MyCsv |
[info]
Executing: | echo | Loop Number: ${!TIMES}\n\n Row Number: ${Row}\n\n Column Number: ${Column}\n\n Random Message From Csv: ${MyCsv[${Row}][${Column}]} | #shownotification |
[echo]
Loop Number: 3
Row Number: 0
Column Number: 5
Random Message From Csv: MESSAGE 6
[info]
Executing: | end | | |
[info]
Executing: | times | 10 | |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 0; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Row |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 9; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Column |
[info]
Executing: | csvReadArray | test.csv | MyCsv |
[info]
Executing: | echo | Loop Number: ${!TIMES}\n\n Row Number: ${Row}\n\n Column Number: ${Column}\n\n Random Message From Csv: ${MyCsv[${Row}][${Column}]} | #shownotification |
[echo]
Loop Number: 4
Row Number: 0
Column Number: 5
Random Message From Csv: MESSAGE 6
[info]
Executing: | end | | |
[info]
Executing: | times | 10 | |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 0; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Row |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 9; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Column |
[info]
Executing: | csvReadArray | test.csv | MyCsv |
[info]
Executing: | echo | Loop Number: ${!TIMES}\n\n Row Number: ${Row}\n\n Column Number: ${Column}\n\n Random Message From Csv: ${MyCsv[${Row}][${Column}]} | #shownotification |
[echo]
Loop Number: 5
Row Number: 0
Column Number: 4
Random Message From Csv: MESSAGE 5
[info]
Executing: | end | | |
[info]
Executing: | times | 10 | |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 0; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Row |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 9; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Column |
[info]
Executing: | csvReadArray | test.csv | MyCsv |
[info]
Executing: | echo | Loop Number: ${!TIMES}\n\n Row Number: ${Row}\n\n Column Number: ${Column}\n\n Random Message From Csv: ${MyCsv[${Row}][${Column}]} | #shownotification |
[echo]
Loop Number: 6
Row Number: 0
Column Number: 0
Random Message From Csv: MESSAGE 1
[info]
Executing: | end | | |
[info]
Executing: | times | 10 | |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 0; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Row |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 9; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Column |
[info]
Executing: | csvReadArray | test.csv | MyCsv |
[info]
Executing: | echo | Loop Number: ${!TIMES}\n\n Row Number: ${Row}\n\n Column Number: ${Column}\n\n Random Message From Csv: ${MyCsv[${Row}][${Column}]} | #shownotification |
[echo]
Loop Number: 7
Row Number: 0
Column Number: 6
Random Message From Csv: MESSAGE 7
[info]
Executing: | end | | |
[info]
Executing: | times | 10 | |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 0; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Row |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 9; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Column |
[info]
Executing: | csvReadArray | test.csv | MyCsv |
[info]
Executing: | echo | Loop Number: ${!TIMES}\n\n Row Number: ${Row}\n\n Column Number: ${Column}\n\n Random Message From Csv: ${MyCsv[${Row}][${Column}]} | #shownotification |
[echo]
Loop Number: 8
Row Number: 0
Column Number: 1
Random Message From Csv: MESSAGE 2
[info]
Executing: | end | | |
[info]
Executing: | times | 10 | |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 0; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Row |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 9; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Column |
[info]
Executing: | csvReadArray | test.csv | MyCsv |
[info]
Executing: | echo | Loop Number: ${!TIMES}\n\n Row Number: ${Row}\n\n Column Number: ${Column}\n\n Random Message From Csv: ${MyCsv[${Row}][${Column}]} | #shownotification |
[echo]
Loop Number: 9
Row Number: 0
Column Number: 8
Random Message From Csv: MESSAGE 9
[info]
Executing: | end | | |
[info]
Executing: | times | 10 | |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 0; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Row |
[info]
Executing: | executeScript_Sandbox | var min = 0; var max = 9; var randomNumber = Math.floor(Math.random() * (max - min)) + min; return randomNumber; | Column |
[info]
Executing: | csvReadArray | test.csv | MyCsv |
[info]
Executing: | echo | Loop Number: ${!TIMES}\n\n Row Number: ${Row}\n\n Column Number: ${Column}\n\n Random Message From Csv: ${MyCsv[${Row}][${Column}]} | #shownotification |
[echo]
Loop Number: 10
Row Number: 0
Column Number: 3
Random Message From Csv: MESSAGE 4
[info]
Executing: | end | | |
[info]
Executing: | times | 10 | |
[info]
Macro completed (Runtime 20.51s)