Expand my Community achievements bar.

Help with CSV processing multiple times.

Avatar

Level 2

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

1 Reply

Avatar

Level 7

@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