Hi @admin
If I use csvsave with a variable not defined ui vision skip del column and after the csv give the error number of columns is inconsistent on line.
I suggest every time there is a non defined variable and it will be saved in csv to store or nothing or a #VNF (value not found) or similar code because if ui vision skip the column the csv will be unusable for the error number of columns is inconsistent on line.
I add a code this save 3 column in database but one variable is not defined
Macro code (i add var20 to create the error)
{
"Name": "Store_Csv_Inconsistence",
"CreationDate": "2020-2-11",
"Commands": [
{
"Command": "store",
"Target": "true",
"Value": "!errorIgnore"
},
{
"Command": "store",
"Target": "one",
"Value": "var1"
},
{
"Command": "store",
"Target": "two",
"Value": "var2"
},
{
"Command": "store",
"Target": "three",
"Value": "var3"
},
{
"Command": "store",
"Target": "${var1}",
"Value": " !csvLine"
},
{
"Command": "store",
"Target": "${var20}",
"Value": " !csvLine"
},
{
"Command": "store",
"Target": "${var3}",
"Value": " !csvLine"
},
{
"Command": "csvSave",
"Target": "test.csv",
"Value": ""
}
]
}
Csv saved
old value one,old value two,old value three
old value one,old value two,old value three
one,three
one,three
one,three
Csv with expected result
old value one,old value two,old value three
old value one,old value two,old value three
one,#VNF,three
one,#VNF,three
one,#VNF,three
With the non skip column feature csv will not damaged and do not show the error number of columns is inconsistent on line.
Can you add this feature in new update please to prevent to damage csv with a non defined variable saved in csv please ?
Thanks