topic Re: [resolved] All file update 'date and time' in ftp in Data Quality

[resolved] All file update 'date and time' in ftp

Anonymous — Sat, 16 Nov 2024 10:16:06 GMT

Hi,
I'm load data to text and put the file in ftp. I run the job in different date.
But i have problem when checking the file on ftp, all date and time will update not for current file only. "11/7/2016 1:16:42 PM"
Please refer attachment. Why does this happen?

Thanks

Re: [resolved] All file update 'date and time' in ftp

Anonymous — Tue, 08 Nov 2016 04:28:28 GMT

This should not happen. May be you can try to move the older files in a different folder.
Also please share your job details especially ftp component to get more details around it.

Re: [resolved] All file update 'date and time' in ftp

Anonymous — Tue, 08 Nov 2016 04:36:12 GMT

Thanks for you feedback. Below is the setting in ftp component for your reference.

Re: [resolved] All file update 'date and time' in ftp

Anonymous — Tue, 08 Nov 2016 04:45:28 GMT

By any chance in your local directory you have older files too or you only have the latest file?

Re: [resolved] All file update 'date and time' in ftp

Anonymous — Tue, 08 Nov 2016 05:42:46 GMT

In local directory have older filer too. What should I do?

Re: [resolved] All file update 'date and time' in ftp

Anonymous — Tue, 08 Nov 2016 05:47:59 GMT

In the file Mask in the ftp directory you are using "MA1_*".txt". This will pull all the files from your local directory.
1. Either you can create 1 folder under S01_MA1 folder on the local machine and keep the latest file there and copy from there to ftp server. Delete this file at the end of the run
2. Dynamically create the file name dynamically (if it is feasible) and use that in the file mask

Re: [resolved] All file update 'date and time' in ftp

Anonymous — Tue, 08 Nov 2016 07:17:07 GMT

Thank you very much for your feedback and advice.