Help with CSV processing multiple times.

[DawnmarieD]

I have a Fusion scenario that takes a csv document, finds a related parent task by reference number on the csv file, then creates a subtasks for each of the entries on the csv, then creates and embeds in each subtask an issue/request. Everything works great except it won't stop. The csv processes over and over, I have five entries on the csv but end up with like 15 it keeps creating repeated subtasks and issues? What have I done wrong?

There are 2 other paths depending on the name of the document uploaded that don't seem to have the same issue. Perhaps because of the status begin changed at the end of the process? These 2 documents are placed in a corresponding folder at the Project Level. I thought because I was putting the problem csv at the task level that maybe why it was repeating because of the background making it viewable at the Project Level. That wasn't it - when I moved the doc to a folder at the project level like the others same result.

Final thought is perhaps the Watch Time isn't enough for the file to filter through so it keeps seeing it as new. Maybe I need to pull this scenario from the others?

I'm not sure this is explaining my issue accurately and I'm not "great" at Fusion. Happy to provide more information as needed to help resolve this issue. Screen shot attached to see flow - again happy to elaborate if it's helpful.

Thank you in advance,

Dawnmarie

[Rite18]

@DawnmarieD  think below

- can use stop  scenario module at the end of the process

- scenario setting can be updated for run only once 

- can think of a router with a condition/counter to check a condition and block/route the process

[Sven-atClient]

Hi @DawnmarieD 

So either the CSV has more rows than you expect - or the WatchRecord Module is getting multiple bundles when you expect only one event. 

I think the issue is that your scenario starts with a watch record module: Have you tried replacing that with a WatchEvents module?

I don't see an issue with your flow: 
you download, then parse the CSV and then for each row do things in WF.