I have an workflow where i download set of reports from abc.com and perform few validation and merge operation to the downloaded excel reports and upload them to the server application. So i have created a workflow which is running successfully but the issues are:
1.The reports from abc.com are downloaded to downloads folder in the machine. If the process run for second instance then it will download the report and will be saved as task_tt (1).csv. But for excel operation i fetch the file is task_tt.csv. So either i should replace the file(But the downloaded file is just incremented) or delete the file before starting the instance which will download and perform merge operations.
2.But deleting each file is not a viable option because for few instances, few files are not downloaded and deleting operation would be failed since there are no file found with that name to delete.Is there a way to delete entire download folder on one go instead of deleting each file by its name? or any way to achieve this instead of deleting.
3.If my process instance is failed to execute for any reason is there a way to restart the process from where it failed instead of running it from the initial step.
Could you guys please advise on this?