checking for files that fail to import in bulk import function

Question

So here's my situation: I need to import multiple Excel files into a raw data set. I've already figured out how to do that basic part (based on using the "*" wildcard in the file name), but I need to be able to track any files that fail due to incorrect schema or column names or whatever.

My preferred solution would be to have a log file of some description that would give me the basic warning message that I get from the "Results" window, saying which file failed and what the problem was. I would need to have it possibly iterate it through the list of Results lines to do so. Can anyone offer suggestions?

Thanks in advance.

DiganP · Accepted Answer

@plundgren There are logs being generated for every time you press the 'run' button in designer.

You can turn them on by going to Options > User Settings > Edit User Settings. In the default section, you can overwrite the system settings and turn on your logs. You can then read in these logs and parse them accordingly.