Ray_C
Novice

Open Data Action Error

Jump to solution

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!

Labels: (1)
0 Kudos
Reply
2 Replies
michta
Nintex Employee
Nintex Employee

Re: Open Data Action Error

Jump to solution
Hi, Ray,

There is no way currently to run an error task when the Open Data doesn't contain any data. I'll discuss with the team for any workaround that we can think of.

Thanks,
Mike
0 Kudos
Reply
kbarton
Apprentice

Re: Open Data Action Error

Jump to solution

Hi Ray,

 

  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.

View solution in original post

0 Kudos
Reply