Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear colleagues,
I would like to create an “Error Dashboard” in my application that would show the following:
The problem is I load many files from different folders with the help of “*” and let’s say 95% of those flat files are correct.
I want to get each end every Error Message for each of the “wrong” 5% of flat files.
Example:
Table_1:
Load
Field1,
Field2,
Field3
From
[..\Folder1\*.xlsx];
Table_2:
Load
Field4,
Field5,
Field6
From
[..\Folder2\*.xlsx];
Is that possible to create such a dashboard? How can I get each and every error message for each and every “wrong” file?
Thank you very much!
BR
Vitalii
Look into this document which might help you create if statements to look into all the errors
Another useful link:
Thanks!:)
Sunny,
I used that info and created some variables:
let vError=ScriptError;
let vErrorDetails=ScriptErrorDetails;
let vErrorCount=ScriptErrorCount;
let vErrorList=ScriptErrorList;
Later I showed them in the front end in a text object like that: =$(vError...)
Problem:
- Only vErrorCount showed me value "2", though I damaged only one file in one place, so there should be only one error
- vErrorList showed me "Error: Garbage after expression "Not"", though the full text of error message would be "Field 'Line#' not found" (the one that I damaged/renamed)
- other variables show just "-"
- I still cannot see the name of the file where the error took place
Are there any solutions to that?
Thanks a lot!
BR
Vitalii
May be load your files using for loop instead of *