I have a DB table with paths to physical files. I read the table and then iterate through each row to copy file to a certain folder.
for some rows, even though a filename is listed in the DB, it doesn’t exist on the filesystem. I managed to make it work, but I want to keep a list of names for such missing/failed rows.
What I did was to create a Set node; with 3 variables,
in my SplitInBatches, I check the existence and depending on that, I update these values like this:
$node[“SetVars”].json[“countError”] = $node[“SetVars”].json[“countError”] + 1
Then I use this nodes values in the end to mail the resulting log.
Is there a better way to do this?