José, Ese componente solo sirve para ftp.Bart te sugirió qué crearás el ftp como un VFS o virtual file system. De ahí simplemente puedes hacer output directamente al vfs o simplemente copiar archivos con el paso adecuado. Gusto ver que hop se está usando en México y por una compañía qué tanto bien trae a los mexicanos. DiegoSent from my Galaxy -------- Original message --------From: José Alberto García Catalán <jose.alberto...@hotmail.com> Date: 11/10/23 5:36 am (GMT+10:00) To: users@hop.apache.org Subject: Re: Connect to FTPS server
Hi Bart, this is a short about the error message: 2023/10/10 16:35:18 - hr-file-outbound-processor-employeetime - Starting action [send-files] 2023/10/10 16:35:18 - hr-file-outbound-processor-employeetime - exec(5, 0, send-files) 2023/10/10 16:35:18 - send-files - Starting action 2023/10/10 16:35:18 - send-files - Start of FTP Put action 2023/10/10 16:35:18 - send-files - Opened FTP connection to server [ftp-fa.fahorro.com.mx] 2023/10/10 16:35:18 - send-files - set passive ftp connection mode 2023/10/10 16:35:18 - send-files - set ASCII transfer mode 2023/10/10 16:35:18 - send-files - set timeout to 0 2023/10/10 16:35:18 - send-files - set control encoding to ISO-8859-1 2023/10/10 16:35:18 - send-files - logged in with user fah_integracion 2023/10/10 16:35:18 - send-files - ERROR: Error putting to FTP : Connection closed without indication. 2023/10/10 16:35:18 - send-files - ERROR: org.apache.commons.net.ftp.FTPConnectionClosedException: Connection closed without indication. 2023/10/10 16:35:18 - send-files - at org.apache.commons.net.ftp.FTP.getReply(FTP.java:568) 2023/10/10 16:35:18 - send-files - at org.apache.commons.net.ftp.FTP.getReply(FTP.java:556) 2023/10/10 16:35:18 - send-files - at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:1222) 2023/10/10 16:35:18 - send-files - at org.apache.commons.net.ftp.FTP.sendCommand(FTP.java:1148) 2023/10/10 16:35:18 - send-files - at org.apache.commons.net.ftp.FTP.cwd(FTP.java:422) 2023/10/10 16:35:18 - send-files - at org.apache.commons.net.ftp.FTPClient.changeWorkingDirectory(FTPClient.java:1151) 2023/10/10 16:35:18 - send-files - at org.apache.hop.workflow.actions.ftpput.ActionFtpPut.execute(ActionFtpPut.java:459) 2023/10/10 16:35:18 - send-files - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:655) 2023/10/10 16:35:18 - send-files - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:795) 2023/10/10 16:35:18 - send-files - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:795) 2023/10/10 16:35:18 - send-files - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:795) 2023/10/10 16:35:18 - send-files - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:795) 2023/10/10 16:35:18 - send-files - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:795) 2023/10/10 16:35:18 - send-files - at org.apache.hop.workflow.Workflow.executeFromStart(Workflow.java:439) 2023/10/10 16:35:18 - send-files - at org.apache.hop.workflow.Workflow.startExecution(Workflow.java:300) 2023/10/10 16:35:18 - send-files - at org.apache.hop.workflow.engines.local.LocalWorkflowEngine.startExecution(LocalWorkflowEngine.java:249) 2023/10/10 16:35:18 - send-files - at org.apache.hop.run.HopRun.runWorkflow(HopRun.java:433) 2023/10/10 16:35:18 - send-files - at org.apache.hop.run.HopRun.runWorkflow(HopRun.java:384) 2023/10/10 16:35:18 - send-files - at org.apache.hop.run.HopRun.run(HopRun.java:201) 2023/10/10 16:35:18 - send-files - at org.apache.hop.run.HopRun.main(HopRun.java:924) 2023/10/10 16:35:18 - send-files - ERROR: Error quiting FTP connection : Broken pipe (Write failed) 2023/10/10 16:35:18 - hr-file-outbound-processor-employeetime - Starting action [log-send-files] 2023/10/10 16:35:18 - hr-file-outbound-processor-employeetime - exec(6, 1, log-send-files) 2023/10/10 16:35:18 - log-send-files - Starting action 2023/10/10 16:35:18 - send-files - Ocurrio un error al enviar los archivos 2023/10/10 16:35:18 - hr-file-outbound-processor-employeetime - Finished action [log-send-files] (result=[false]) 2023/10/10 16:35:18 - hr-file-outbound-processor-employeetime - Finished action [send-files] (result=[false]) 2023/10/10 16:35:18 - hr-file-outbound-processor-employeetime - Finished action [update-records-processed-employeetime] (result=[false]) 2023/10/10 16:35:18 - hr-file-outbound-processor-employeetime - Finished action [file-outbound-processor-employeetime] (result=[false]) 2023/10/10 16:35:18 - hr-file-outbound-processor-employeetime - Finished action [records-to-process-employeetime] (result=[false]) 2023/10/10 16:35:18 - hr-file-outbound-processor-employeetime - Finished action [count-records-to-process-employeetime] (result=[false]) 2023/10/10 16:35:18 - hr-file-outbound-processor-employeetime - Workflow execution finished 2023/10/10 16:35:18 - hr-file-outbound-processor-employeetime - Workflow duration : 3.161 seconds [ 3.161" ] HopRun exit. Attached is the entire log. And this is my FTP pipeline configuration: Env vars: I'm checking the VFS documentation, thanks!!! De: Bart Maertens <bartm...@apache.org> Enviado: lunes, 9 de octubre de 2023 11:46 p. m. Para: users@hop.apache.org <users@hop.apache.org> Asunto: Re: Connect to FTPS server Hi José, Can you provide some more details about the error you get when trying to connect? FTPS is supported in almost all transforms and actions that allow you to set a file/folder path through VFS [1] (check the FTPS line and syntax). Hope that helps! [1] https://hop.apache.org//manual/latest/vfs.html#_apache_vfs_file_system_types Regards, Bart On Tue, Oct 10, 2023 at 7:08 AM José Alberto García Catalán <jose.alberto...@hotmail.com> wrote: Hello guys, In a workflow I'm trying to use the FTP pipeline to put files to and FTPS server, however we got an error. Our FTPS server is an FTP server with a digital certificate. The question is: Is it possible to connect the FTP pipeline to our FTPS server? Thanks in advance,
