cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are troubleshooting an issue impacting community login, and it may be intermittently unavailable. Sorry for any inconvenience.

CSV file vs schedulers

AP_9587236
17-Peridot

CSV file vs schedulers

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 1

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

Announcements


Top Tags