When I load the data for a botflow it is only setting itself to Run 1 Time. I want it to run all the records I load but I am going to run it using RPA central so I do not want to have to change that manually.
Is there a way to change the default to run all instead of run once? Only happens if I ask the botflow to load excel into a database. ('open data')
Solved! Go to Solution.
Are you using the loop option to reference something in the Excel data that you imported? I'm not 100% positive that a loop is necessary, but it could resolve the issue.
No loop, just loading the data into a database using the import data from excel - Data Open - option.
Not sure where a loop would be placed?
Just to describe a little more....
I am trying to load data automatically when Nintex starts the script from RPA Central. So the script is started and then the data is loaded in the sript. Somehow it sets the run times to 1 instead of running for records 1 to end, or all records.
If i change from run once to run all and then save the script and open the data again it doesn't set it to one. But if I load a new spreadsheet it sets it to one. So I was hoping there was some sort of default setting I was not aware of.
If you put a loop immediately after the Open Data, you could then specify the "Exact times" that it loops. In the "times" field of that loop, you could say[*TOTAL_RECORDS]. This "variable" is found under the magic wand, Botflow, Total Records.
So import data
place column 1, record 1 into website. place column 2, record 1 into website, place column 3, record 1 into website.
Now it will repeat those same steps for the number of records you have.
Does that help at all? Someone else can pitch in if I'm leading down the wrong path. haha
Not sure where you are going with that. I'm trying to get the data to advance as part of the normal flow, as it naturally does but isn't opting to read all records, just the first one and I don't want to have to change that manually since my script is automated. RPA will advance the data to each field naturally and my script only reads one data item per script rotation.
Start script, read data, run task using that data, end script, move to next data and repeat all steps. So I really am having trouble understanding what a loop might do in this case.
I spoke with Support and development @devinweber You were right about requiring a loop to maintain the records if loading data in a script, after starting the script. You must mark the data record within the script when you are finished with each record.
Look for first unprocessed record- skipping those already processed
run logic - Do something fun and exciting
mark record as done - continue with loop until you have read all the data
At the last record exit the loop
Things to be aware of:
So until NIntex has a fix for autoloading data and the data being stuck at First Record, I may opt-out of RPA Central for scheduled jobs and choose .bat files.
If anyone else has something clever they've done please let me know.