You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@hop.apache.org by "Raja10D (via GitHub)" <gi...@apache.org> on 2025/04/09 06:55:59 UTC

[D] Handling Unreadable or Corrupted Excel and CSV Files in Apache Hop with Email Alerts (hop)

GitHub user Raja10D created a discussion: Handling Unreadable or Corrupted Excel and CSV Files in Apache Hop with Email Alerts

In my pipeline, I am receiving an Excel file and a CSV file as input and performing various transformation tasks. if the excel file is  unreadable or corrupted, i should trigger a mail to the client that the file is unreadable
for csv file also i need to trigger an email if it is unreadable or corrupted

I have already handled scenarios where the file is locked, missing, or empty in Hop, but I am unable to handle the scenario where the file is unreadable or corrupted.

Can anyone assist with the steps and Hop components that can be used to handle this situation?

GitHub link: https://github.com/apache/hop/discussions/5144

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org


Re: [D] Handling Unreadable or Corrupted Excel and CSV Files in Apache Hop with Email Alerts (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
GitHub user hansva added a comment to the discussion: Handling Unreadable or Corrupted Excel and CSV Files in Apache Hop with Email Alerts

When this happens, your pipeline will usually fail.
On the workflow level that triggers this pipeline, you can handle this by using an error hop from the pipeline action.
An example of this can be found [here](https://hop.apache.org//manual/latest/workflow/workflows.html#_example_workflow_walk_through)

GitHub link: https://github.com/apache/hop/discussions/5144#discussioncomment-12774994

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org


Re: [D] Handling Unreadable or Corrupted Excel and CSV Files in Apache Hop with Email Alerts (hop)

Posted by "Raja10D (via GitHub)" <gi...@apache.org>.
GitHub user Raja10D added a comment to the discussion: Handling Unreadable or Corrupted Excel and CSV Files in Apache Hop with Email Alerts

> When this happens, your pipeline will usually fail. On the workflow level that triggers this pipeline, you can handle this by using an error hop from the pipeline action. An example of this can be found [here](https://hop.apache.org//manual/latest/workflow/workflows.html#_example_workflow_walk_through)

Thank you, @hansva 
It is working perfectly.

GitHub link: https://github.com/apache/hop/discussions/5144#discussioncomment-12787138

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org