Hi, I am trying to upload excel sheet which has more than 100 rows. O

rohandhondilalk over 9 years ago

Hi,

I am trying to upload excel sheet which has more than 100 rows. Once I upload and proceed it is creating a Task before going to the next screen. Whilst if I upload a excel , which has 9 rows and proceed it is going to the next screen, without creating a task. I have enabled Activity chaining across the flow.
Any idea on how we can upload the excel which has more than 100 rows and which should not terminate Task generation and just go to next screen?

Discussion posts and replies are publicly visible

0 Stefan Helzle
A Score Level 3
over 9 years ago

There is a limit in chaining of how many nodes can be between the user input tasks. If there is more nodes the second task is not directly shown, but assigned to the user like any other task. This is expected behaviour and I suggest that you find a way around it.

The last time we did something similar we just sent an email to the user to notify him that the import has completed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rohandhondilalk over 9 years ago

Hi, Thanks but we have minimum requirement of 100- 15000 rows to read from an excel
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Stefan Helzle
A Score Level 3
over 9 years ago

How is your current implementation? A loop in the process? This will not work. And regardless of the chaining problem, doing that in process is very slow so your import might run for hours. Do you write the data to DB? There is a plugin that might help you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Andrew P Gramann
Certified Lead Developer
over 9 years ago

You can usually replace any loop or MNI with a single script task that uses apply(). I would look into that option as a starting point.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rohandhondilalk over 9 years ago

Hi Stefanh791, Yes there is a loop in my process and we are writing the data to DB.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rohandhondilalk over 9 years ago

Hi Andrewg, Can you please elobarate on your answer, so that I can understand clearly.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel