Move file Changing the data in the excel

Help Studio
, ,
1

Hi I am facing a strange scenario with my bot automation:

Please find below the steps of the Bot

1.The bot downloads a file from a website.
2.The bot deletes an old file named “Close Status.xlsx” in the Input folder.
3.A delay of 5 seconds is introduced after deleting the file.
4.Move the newly downloaded file(Step 1) to the Input folder and renames it to “Close Status.xlsx” using the Move file activity

Problem : The data inside the Excel file is getting modified; specifically, the column values are getting swapped. This issue occurs when running the bot in run mode, but not in debug mode.

Can anyone help me resolve this issue?

2

Instead of deleting the old file and waiting, just set “overwrite” to true for the Move File activity.

There’s no way moving a file is changing the data. It’s no different than if you just dragged and dropped the file. My guess is you aren’t ending up moving the file you think you’re moving.

3

Overwrite is already enabled. The file is getting deleted and moving the new file. The issue is very strange

4

If overwrite is selected, there’s no need to delete the old file and then wait. It’ll be overwritten.

I suggest using Debug to confirm that it’s moving the file it should be moving. Or even that the file that’s downloaded is what you expect it to be. Put a breakpoint on the next activity after you download it, then go manually look at the file.