Item is not Active

Hello,
I'm using excel for loading initial parameters into a queue. At certaing point I have got an issue, process start loaing empty rows in the queue. Really dont know where to catch them ... I have filtered rows from excel "avoid empty rows" but they are still there. The issue is clearly explained in the picture attached.
Can you help me here ?
Thanks. Br. Marco.
 

Attachments

  • Item si not Active.PNG
    Item si not Active.PNG
    12 KB · Views: 4

Pete_L

Active Member
How are you loading the items from Excel into the work queue? How are you filtering? Please post details so we can assist better.

It looks like the source worksheet contains blank rows that Excel believes are there, but contain no data. A good way to tell is to open the worksheet in Excel manually and pressing CTRL-END. If the cursor ends up in a row that contains no data, then you have this issue.. Best way to remove the blank rows is to load the data from Excel into a collection, then applying the Remove Blank Rows action from the Collections VBO. After that is done, then load the data from the collection to the work queue.
 
Top