topic Re: Automatic trigger after a file is uploaded to FTP server in Talend Studio https://community.qlik.com/t5/Talend-Studio/Automatic-trigger-after-a-file-is-uploaded-to-FTP-server/m-p/2302384#M74372 Hi sreedevi, <BR />You can use tWaitForFile component to achieve this. <BR />1) In order to identify whether its the required file, there are multiple ways <BR /> a) Mention ".csv" extension / naming convention of the file (e.g. *Invoice*.csv) in File Mask property <BR /> b) tSchemaComplianceCheck component can do at the load time (not the ideal solution) <BR />2) In order to make sure file is successfully uploaded on FTP site before your job start processing the file - you need to check option in Advanced settings - "Wait for file to be released" <BR />Please take a look at the screen shots attached for further details. Hope this helps. <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA6b.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149875iF5FA2BFD8DA19ADE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA6b.jpg" alt="0683p000009MA6b.jpg" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MEiI.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132775i747F2B355EB964ED/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MEiI.jpg" alt="0683p000009MEiI.jpg" /></span> Tue, 02 Jul 2013 08:46:41 GMT Anonymous 2013-07-02T08:46:41Z Automatic trigger after a file is uploaded to FTP server https://community.qlik.com/t5/Talend-Studio/Automatic-trigger-after-a-file-is-uploaded-to-FTP-server/m-p/2302381#M74369 Hi All, <BR />I have a requirement like this.ie,Immediately after a data file is being uploaded to the ftp server , a process to automatically open the file and check whether this is the required csv file and try to import this into the db. <BR />Please note that we should't consider a file in transmit (ie only when the file upload is completed the process should consider this as a file).Can I achieve this requirement with Talend ? Please advice. <BR />Thanks, <BR />Sreedevi.S Sat, 16 Nov 2024 11:59:09 GMT https://community.qlik.com/t5/Talend-Studio/Automatic-trigger-after-a-file-is-uploaded-to-FTP-server/m-p/2302381#M74369 Anonymous 2024-11-16T11:59:09Z Re: Automatic trigger after a file is uploaded to FTP server https://community.qlik.com/t5/Talend-Studio/Automatic-trigger-after-a-file-is-uploaded-to-FTP-server/m-p/2302382#M74370 Hi <BR />How do you decide the file is the required csv file or not? What is the basis? <BR />Shong Mon, 01 Jul 2013 12:57:23 GMT https://community.qlik.com/t5/Talend-Studio/Automatic-trigger-after-a-file-is-uploaded-to-FTP-server/m-p/2302382#M74370 Anonymous 2013-07-01T12:57:23Z Re: Automatic trigger after a file is uploaded to FTP server https://community.qlik.com/t5/Talend-Studio/Automatic-trigger-after-a-file-is-uploaded-to-FTP-server/m-p/2302383#M74371 Hi Shong, <BR />Thanks for the reply.I have posted the requirement.Not sure how to accomplish.I think i can check against the schema to decide whether its the needed csv .Please suggest a flow that is suitable for this requirement. <BR />Thanks, <BR />Sreedevi Tue, 02 Jul 2013 03:55:16 GMT https://community.qlik.com/t5/Talend-Studio/Automatic-trigger-after-a-file-is-uploaded-to-FTP-server/m-p/2302383#M74371 Anonymous 2013-07-02T03:55:16Z Re: Automatic trigger after a file is uploaded to FTP server https://community.qlik.com/t5/Talend-Studio/Automatic-trigger-after-a-file-is-uploaded-to-FTP-server/m-p/2302384#M74372 Hi sreedevi, <BR />You can use tWaitForFile component to achieve this. <BR />1) In order to identify whether its the required file, there are multiple ways <BR /> a) Mention ".csv" extension / naming convention of the file (e.g. *Invoice*.csv) in File Mask property <BR /> b) tSchemaComplianceCheck component can do at the load time (not the ideal solution) <BR />2) In order to make sure file is successfully uploaded on FTP site before your job start processing the file - you need to check option in Advanced settings - "Wait for file to be released" <BR />Please take a look at the screen shots attached for further details. Hope this helps. <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA6b.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149875iF5FA2BFD8DA19ADE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA6b.jpg" alt="0683p000009MA6b.jpg" /></span> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MEiI.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132775i747F2B355EB964ED/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MEiI.jpg" alt="0683p000009MEiI.jpg" /></span> Tue, 02 Jul 2013 08:46:41 GMT https://community.qlik.com/t5/Talend-Studio/Automatic-trigger-after-a-file-is-uploaded-to-FTP-server/m-p/2302384#M74372 Anonymous 2013-07-02T08:46:41Z Re: Automatic trigger after a file is uploaded to FTP server https://community.qlik.com/t5/Talend-Studio/Automatic-trigger-after-a-file-is-uploaded-to-FTP-server/m-p/2302385#M74373 Hi Nishad,<BR />Thank you so much for the reply.I will try the same.<BR />Sreedevi Tue, 02 Jul 2013 10:10:16 GMT https://community.qlik.com/t5/Talend-Studio/Automatic-trigger-after-a-file-is-uploaded-to-FTP-server/m-p/2302385#M74373 Anonymous 2013-07-02T10:10:16Z