Skip to main content
A
AP_958723617-Peridot
17-Peridot
August 4, 2021
Question

CSV file vs schedulers

  • August 4, 2021
  • 1 reply
  • 609 views

I am updating csv for every 15 mins in Repository using scheduler. If i opened CSV file using the option "open with Excel", csv is not updating in Repository for every 15 mins. But if i opened CSV file using "Edit with notepad++", it is updating for every 15 mins. Why? 

1 reply

P
PEHOWE17-Peridot
17-Peridot
August 5, 2021

Hello @AP_9587236,
 

Are you creating a new file name every 15 min, or reusing the same file name?

 

When you open the CSV file with Notepad++ it creates a working copy and does not lock the original file.

Since the original file is not locked when the timer process runs it updates the same file name.

 

When you open a file with Excel, it locks the file from being updated by another process to insure that the file is not corrupted. 

 

Does this information help?
What goal are you trying to accomplish?

 

Peter

Terms & ConditionsCookie settingsAccessibility statement