Great suggestions here. I am working with 1T CSV Uploader which splits the bigger files into smaller ones and uploades them one by one. There is a logic behind that generates a number of files but there is no existing record check.
I am struggling with a similar issue in the sense that I give my customers the option to connect their environments via API or upload CSVs daily. For the CSVs, we are talking about files with 10Ks of records that need to be uploaded daily but only new ones to be added to db and the others to be updated with a new status, if any.
I think I got what you are trying to do here but it needs to make sense for me in words first before I can put it into WFs so I have a question:
- Is the backend wf set searching, updating and deleting records in the uploaded list before pushing it to the database or is it pushing it to the db first and then searches, updates and deletes records in the db?
Also, I fail to understand what this does
I guess, as stupid as this sounds, that I could use a word explanation of the workflows to try to replicate in my case. I would appreciate a lot if somebody can help with this.
Thanks a lot