cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

2010 Workflow to read rows from Excel and insert into list never terminates

There is a workflow which reads rows from Excel, process data and insert items into a SharePoint list. The workflow runs as expected for lesser number of rows in excel(works well for 10,16,108, 112 rows). But, when the number of rows increases (we tested it for 250), the workflow never terminates its instance. It goes till the last action in the workflow and repeats itself again from the first action.

There are loops in the workflow to read cells in excel and convert them to SOAP XMLs. All the excel data is processed and is inserted into SharePoint list using a single web service (lists.asmx) call. The workflow comes out of all the loops and executes the actions outside the loops, like creating items in the list, sending notifications, but it never terminates and unfortunately re-execute the actions like reading Excel, creating SOAPs and adding items into SharePoint list.

Labels: (1)
Reply
3 Replies
Workflow Hero

Re: 2010 Workflow to read rows from Excel and insert into list never terminates

Try to process your excel by lots. Firstly get rows 1-50, then 51-100, etc, perhaps you can do it on an user defined action.

Accept as Solution Reply
Workflow Hero

Re: 2010 Workflow to read rows from Excel and insert into list never terminates

Thanks for your input Fernando, but we are already reading and processing excel one row at a time.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: 2010 Workflow to read rows from Excel and insert into list never terminates

Can you share the workflow in a screen shot that you used to convert excel list into a SP list?

Abhinav Kumar

0 Kudos
Accept as Solution Reply