Muchas gracias Diego, si estamos evaluando Apache HOP para reemplazar software que actualmente utilizamos para nuestros procesos de integración de datos, queremos modernizar nuestras tecnologías y Apache HOP nos parece muy interesante.
Por seguridad no quise enviar este correo desde mi cuenta de correo laboral porque es la primera vez que les escribo. Vamos a probar con VFS, muchas gracias!!! ________________________________ De: Diego Mainou <[email protected]> Enviado: martes, 10 de octubre de 2023 02:16 p. m. Para: [email protected] <[email protected]> Asunto: RE: Connect to FTPS server 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. Diego Sent from my Galaxy -------- Original message -------- From: José Alberto García Catalán <[email protected]> Date: 11/10/23 5:36 am (GMT+10:00) To: [email protected] 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<http://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: [cid:32d72cd4-4b64-4aeb-9fc6-e0ea768c2588] [cid:c94f2ca2-9bbb-4873-80ff-b81942d18465] Env vars: [cid:32538aab-375b-4123-9b0a-4dec0cc388c0] I'm checking the VFS documentation, thanks!!! ________________________________ De: Bart Maertens <[email protected]> Enviado: lunes, 9 de octubre de 2023 11:46 p. m. Para: [email protected] <[email protected]> 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 <[email protected]<mailto:[email protected]>> 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,
