An observation that costed me full day of work
The macro scrapes the data from pages and writes to a CSV report.
After each iteration, the CSV file was overridden.
Spend a day debugging.
The issue was that the file name should not have any ‘|’, ‘:’.
however, the UIV did not have a prompt for that. The CSV file is created.
But the content is overridden each iteration
{
"Command": "comment",
"Target": "",
"Value": "",
"Description": ""
},
{
"Command": "store",
"Target": "reports|list.csv",
"Value": "reports_list_csv",
"Description": "The issue in a file name"
},
{
"Command": "store",
"Target": "7",
"Value": "link_position",
"Description": ""
},
{
"Command": "times",
"Target": "${link_position}",
"Value": "",
"Description": ""
},
{
"Command": "store",
"Target": "Itr #${!times} ",
"Value": "!csvLine",
"Description": ""
},
{
"Command": "comment",
"Target": "store // ${the_msg}",
"Value": "!csvLine",
"Description": ""
},
{
"Command": "echo",
"Target": "${!csvLine} ",
"Value": "",
"Description": ""
},
{
"Command": "csvSave",
"Target": "${reports_list_csv}",
"Value": "",
"Description": ""
},
{
"Command": "store",
"Target": "3",
"Value": "the_pos",
"Description": ""
},
{
"Command": "times",
"Target": "${the_pos}",
"Value": "",
"Description": ""
},
{
"Command": "store",
"Target": " -- Nested Loop itr #${!times} ",
"Value": "!csvLine",
"Description": ""
},
{
"Command": "echo",
"Target": "${!csvLine} ",
"Value": "",
"Description": ""
},
{
"Command": "csvSave",
"Target": "${reports_list_csv}",
"Value": "",
"Description": ""
},
{
"Command": "end",
"Target": "",
"Value": "",
"Description": ""
},
{
"Command": "end",
"Target": "",
"Value": "",
"Description": ""
}