Visokio website     Downloads     Video tutorials     KnowledgeBase  
Publishing: Suppress emailing attached files if file is empty? - Visokio Forums
Publishing: Suppress emailing attached files if file is empty?
  •     rajeshbalu29 August 19, 2015 2:50PM
    Hi Team,
    I'm trying to publish users set of data with a criteria through email output. Is there a way to restrict sending mail if there is no data?
  • 8 Comments
  •     tjbate August 24, 2015 9:48AM
    Rajesh

    If you are using an Email Output block rather than a Batch Configuration File to manage your automated email publishing and delivery, and you want to add validation steps prior to sending any email Report, consider using the Validate Data Block Reporting Tab to define the logical validations (such as non-empty file) to be applied prior to sending various pre-defined email reports.
  •     rajeshbalu29 August 24, 2015 6:31PM
    Hi Team,

    Thanks for the response. Validate data works fine but we need attach the data in the message text when its successful else should not send mail. currently iam getting a mail as Validation successful if its having any record else no mail is generated.
    Can you please further help me on how to attach the data in the email. I have attached the snipping which i had configured in Validate Data.

    Thanks
    Rajesh B
  •     rajeshbalu29 September 1, 2015 4:17PM
    Hi Tom,
    As discussed i used validate data but if the value is 0 its throws an error and I'm getting a chain failure message from the scheduler. how to ignore chain failure if the data is published only when there is no data but should work if the whole chain failed because of someother reason.

    Thanks
    Rajesh B
  •     tjbate September 3, 2015 3:29PM
    Rajesh

    I set up a test file using row filters to toggle between accepting and rejecting rows to simulate daily refreshes which alternate between refreshing files with non-zero record counts and zero record counts. Note I have used Custom Validation with the formula function ALLRECORDCOUNT tested to be greater than zero. When this Validation succeeds, data set passes to Email Output block and non-zero record report is delivered according to the settings in the Email output block. Note that the Auto-publish box at the bottom of the Email Output block is ticked, but the option to deliver empty data sets via Auto-publish is NOT ticked.

    If you are having problems with the Scheduler, it may be because you need to include an extra refresh or save task in between file cycles that may be changing from empty to populated.

    image
  •     rajeshbalu29 September 3, 2015 4:04PM
    Thanks for getting me the screen shot. I configured the same way but still iam getting a mail with just the header as I'm attaching the the data file under data tab. please find the snipping as attached for your reference. I would like to restrict the email output to publish when there is no records.

    Please advise.

    Thanks
    Rajesh B
    Attachments
    1st link.png 45K
    2nd link.png 35K
  •     richard September 4, 2015 9:13AM
    Hi Rajesh

    As discussed over the phone, I will investigate this at try to put together an example using scheduler which meets your requirements.

    Richard
  •     chris September 18, 2015 5:43AM
    Hi Rajesh,

    I've discussed this with Richard. Can you let me know a convenient time to call/discuss this issue? Please feel free to send me a private email.

    Regards

    Chris

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership