Community forum

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


tfsuser
2011-10-17T18:29:57Z
Hi,
I am using VC to download files from an FTP site. the way I have the job set up is to run every 10 min for 2 hours and download the file with "overwrite if source file is newer" and "keep modified/created date". what I see is that the file is being downloaded every time the job runs.
when I open the ftp folder through windows the modified time stamp is 11:39AM but when I use the VC tool the modified time stamp shown is 3:39PM - is this a time-zone issue? I didn't see anywhere a time zone setting for the connection of job.
the second question is about keeping the modified date - when I look at my local directory I see the file with the time stamp of when the job was run, not the file's original modified time stamp.

thanks for the help
Ran Margalit
Sponsor
Forum information
Support
2011-10-17T18:52:26Z
There is currently no time zone setting in that Task or Connection. I am moving this topic to Feature requests.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tfsuser
2011-10-17T18:58:11Z
sorry if I wasn't clear. I am not requesting a new feature.
my issue is that when I look at the ftp site using VC FTP Explorer the modified time stamp is 3:39PM. but when I use a different ftp client I see the correct time stamp of 11:39AM.
why is this and how do I make VC see the right modified time stamp?

thanks
Ran
Support
2011-10-17T19:15:41Z
In your case, is which is the remote time and local time?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tfsuser
2011-10-17T19:31:19Z
well, I don't know.
when I use the VC tool it shows 3:39PM
but when I open the ftp site using Firefox it shows 11:39AM
my time zone is US eastern so the time stamp of 11:39AM is what I would expect.
Support
2011-10-17T19:34:35Z
So, you don't know where the FTP is located physically?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tfsuser
2011-10-17T19:47:05Z
no, sorry
I would just want the modified time stamp to say the same as if I would browse through Firefox or Windows Explorer :-)

how about the second question that I had - why would the modified time stamp be the time of when the job ran instead of 3:39PM? that would have solved my issue ...
Support
2011-10-17T19:51:21Z
I understand. But it is important for us to understand what is right and wrong - and in what way, hence the questions.

Before knowing this it is hard to answer the questions without us setting up a test environment for this.

My simple guess is that we pick the time and do not care about time zones at all but that is just a guess until we have tested this fully.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tfsuser
2011-10-17T19:55:41Z
thanks for the help.

if I had to guess I would say the ftp server is in NYC (we are a financial firm and we are ftping some financial data from a bank).

can/do you want to web-ex into my system or is there any way I can help here? it is preventing us from fully utilizing VC.
Support
2011-10-17T19:57:06Z
We will setup a test server tomorrow and hopefully we will find out where something is wrong and correct it as soon as possible.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2011-10-18T13:40:54Z
Please download and try 6.0.2. We have tried to convert to local time. This only works if the FTP supports MLSD - otherwise we will get it in an unknown time zone format.

You will see that in the FTP browser from VisualCron if MLSD or LIST command is used.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tfsuser
2011-10-18T14:43:41Z
thank you so much for the quick turn around.

I validated that through the tool FTP Terminal Explorer we are actually now seeing the right time stamp.

however, when the FTP download task runs it still has the wrong behavior: I have the "Overwrite if source file is newer" selected and "Keep modified/created date" checked but the files still get downloaded each time the task runs and the local files have the time stamp of the last run.
it seems to me that the task and the tool don't share the same code? I think the task needs the same fix as the tool had.

thanks again for your help
Ran
Support
2011-10-18T16:56:56Z
We did make some changes here but perhaps we missed something. We added some extra debugging so you can see current file time and original file time. You can turn on this debugging by going to Server tab->Extended debugging.

1. turn it on
2. download
3. turn it off

Then please post the relevant data. You should see something like:

"Checking if file..".

The information is stored in the log folder (of VisualCron installation) in a file called "log_serverDATE.txt".
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tfsuser
2011-10-18T18:21:48Z
I turned on the extended debug logging (Settings -> Extended debug logging) and ran the task, but I don't see the extended logging you mentioned above.
from Server ingo: Version 6.0.2; Protocol version: 6.0.1

here is what I have from the log file:

10/18/2011 2:18:50 PM Info Job started: Download Unrealized Gain Loss
10/18/2011 2:18:50 PM Debug Job (902) was added to processlist: Download Unrealized Gain Loss
10/18/2011 2:18:50 PM Info Skipping Condition check because the Job was run manually.
10/18/2011 2:18:50 PM Debug Next action: ActionContinue
10/18/2011 2:18:50 PM Debug Next action: ActionContinue
10/18/2011 2:18:50 PM Debug Task (1117) was added to processlist:
10/18/2011 2:18:50 PM Info User "Ran Margalit" - Ran Job: Download Unrealized Gain Loss
10/18/2011 2:18:50 PM Info Task started: (1117)
10/18/2011 2:18:50 PM Debug FTP Command Count: 1
10/18/2011 2:18:51 PM Debug ServerSystem: 'UNIX Type: L8'
10/18/2011 2:18:51 PM Debug FTP path separator: '/'
10/18/2011 2:18:51 PM Debug Current path: /
10/18/2011 2:18:51 PM Debug Change path before: /outgoing
10/18/2011 2:18:51 PM Debug Change path after: /outgoing
10/18/2011 2:18:51 PM Debug Changing path to: /outgoing
10/18/2011 2:18:51 PM Debug Current path: /outgoing
10/18/2011 2:18:51 PM Debug Before download
10/18/2011 2:18:52 PM Debug Creating write stream (test)
10/18/2011 2:18:52 PM Debug Getting file stream (test)
10/18/2011 2:18:52 PM Debug Set to nothing(test)
10/18/2011 2:18:52 PM Debug Closing stream (test)
10/18/2011 2:18:52 PM Debug After download
10/18/2011 2:18:52 PM Debug Commands done
10/18/2011 2:18:52 PM Debug Before dispose
10/18/2011 2:18:52 PM Debug Disposing timer
10/18/2011 2:18:52 PM Debug Trying to disconnect
10/18/2011 2:18:52 PM Debug Stopping watch
10/18/2011 2:18:52 PM Debug Before GetOutput
10/18/2011 2:18:52 PM Debug Before RaiseTaskCompleted
10/18/2011 2:18:52 PM Info Task completed: (1117)
10/18/2011 2:18:52 PM Debug Setting previous task in TaskProcessCompleted: (d7970305-8af1-4020-941d-1161f978c036) in job: Download Unrealized Gain Loss
10/18/2011 2:18:52 PM Debug Process status - About to SendTaskProcess (1117)
10/18/2011 2:18:52 PM Debug Process status - About to RemoveTaskProcess (1117)
10/18/2011 2:18:52 PM Debug Task (1117) was removed from processlist:
10/18/2011 2:18:53 PM Debug Job (902) was removed from processlist: Download Unrealized Gain Loss
10/18/2011 2:18:53 PM Debug Next execution (2) for job 'Download Unrealized Gain Loss' is: 10/18/2011 2:20:00 PM
10/18/2011 2:18:53 PM Info Job completed: Download Unrealized Gain Loss
10/18/2011 2:19:06 PM Debug Memory cleanup
10/18/2011 2:19:06 PM Debug Saving output files and clearing output memory.
10/18/2011 2:19:06 PM Debug Memory usage before cleanup: 113889280
10/18/2011 2:19:30 PM Debug Saving Jobs

the file was download again as before.
Support
2011-10-18T18:53:17Z
Please attach a screenshot of your download settings.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tfsuser
2011-10-18T19:07:19Z
here it is
tfsuser attached the following image(s):
Support
2011-10-19T10:04:06Z
Please test this attached installation if it works better.

You need to uninstall old version first.

Thank you.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tfsuser
2011-10-19T15:44:47Z
thanks so much! this works much better. it now preserves the modify time stamps of the files downloaded and the behavior is now correct.
thanks again for the help and the quick turn around!

is this version production ready - can I install it on my prod system or should I wait for a formal release?
Support
2011-10-19T16:00:26Z
You can install it in production. We will probably release something tomorrow.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
tfsuser
2011-10-20T15:58:51Z
Hi,
I am still seeing an issue: the download job runs and doesn't download the file anymore (which is good - the file didn't change on ftp site) but a different job that has a file trigger on the file does trigger. its like the event of file change is triggered anyway.
Support
2011-10-21T07:22:01Z
Ok, the problem is that we set the write time all the time. We will change this. But do you really need the Changed event - is not the Created event enough?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2011-10-21T15:33:23Z
Please test if the attached version works better.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top