I am looking for a workaround/steps that can resolve our issue of getting an Error when importing a database with no records in it. We have a scheduled botflow via RPA Central that pulls in an excel file but on a rare occasion, there are no records in the file. RPA stops and produces an error that it can't import data due to no records (attached). The 'Open Data' action doesn't have the normal settings to run an error task. Thanks for any wisdom that you can share!
Solved! Go to Solution.
We have this similar issue to. What we have done is to create actions to open Excel and look for data in cell A2 (assuming your data has headers). Then use an If/Else action. If it finds data close Excel and then runs the open data step. Else, close Excel and closes down the bot. If you wanted an error task you can place it before the close bot steps. You may need to do some minimize steps when you close Excel due to pop ups that ask if you want to save even though you didn't do anything. We use this for about 20 bots so it has proven successful for us.