Summary Report exported into multiple tabs and naming macro for date in exported file name problem

ann_21588
ann_21588 Altair Community Member
edited January 2019 in Community Q&A

is it possible to have a summary export distributed among multiple tabs that has a file name with the date variable? 

 

My summary report exports correctly into multiple tabs based on distinct value of first key with a constant file name.  When I add the current date variable to the exported file name, the file is created without interpreting the value for date variable.  For example, the file is created as &[mm]&[dd]&[yy]_SummaryExport.xlsx rather than 013119_SummaryExport.xlsx.

 

The converse is also true.  I have a detail file that exports correctly with a date variable in the file name.

 

Thanks for any suggestions.

 

______________

Ann Stapanowich

Analyst - Revenue Cycle

Mission Health System

 

 

This message and its attachments may contain confidential and/or legally-sensitive information that is intended for the sole use of the addressee(s). Any unauthorized review, use, disclosure, or distribution of the information contained in this message and its attachments is prohibited. If you have received this message or any of its attachments in error, please destroy all originals and copies of the same and notify the sender immediately.
Tagged:

Answers

  • Steve_Caiels
    Steve_Caiels
    Altair Employee
    edited January 2019
    Hi Ann,

    I'll look into this.  They are not mutually exclusive, as far as I know.  Which version of Automator are you using?  Is it a standard or Visual process?

    In the meantime, you should be able to export with a static file name, then add a distribution to include the date macro.

    Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Service
    Datawatch Corporation
    +44 203 868 0253
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 01-31-2019 11:10 AM
    From: Ann Stapanowich
    Subject: Summary Report exported into multiple tabs and naming macro for date in exported file name problem

    is it possible to have a summary export distributed among multiple tabs that has a file name with the date variable? 

     

    My summary report exports correctly into multiple tabs based on distinct value of first key with a constant file name.  When I add the current date variable to the exported file name, the file is created without interpreting the value for date variable.  For example, the file is created as &[mm]&[dd]&[yy]_SummaryExport.xlsx rather than 013119_SummaryExport.xlsx.

     

    The converse is also true.  I have a detail file that exports correctly with a date variable in the file name.

     

    Thanks for any suggestions.

     

    ______________

    Ann Stapanowich

    Analyst - Revenue Cycle

    Mission Health System

     

     

    This message and its attachments may contain confidential and/or legally-sensitive information that is intended for the sole use of the addressee(s). Any unauthorized review, use, disclosure, or distribution of the information contained in this message and its attachments is prohibited. If you have received this message or any of its attachments in error, please destroy all originals and copies of the same and notify the sender immediately.
  • ann_21588
    ann_21588 Altair Community Member
    edited January 2019
    Steve Caiels_21881 said:

    Hi Ann,

    I'll look into this.  They are not mutually exclusive, as far as I know.  Which version of Automator are you using?  Is it a standard or Visual process?

    In the meantime, you should be able to export with a static file name, then add a distribution to include the date macro.

    Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Service
    Datawatch Corporation
    +44 203 868 0253
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 01-31-2019 11:10 AM
    From: Ann Stapanowich
    Subject: Summary Report exported into multiple tabs and naming macro for date in exported file name problem

    is it possible to have a summary export distributed among multiple tabs that has a file name with the date variable? 

     

    My summary report exports correctly into multiple tabs based on distinct value of first key with a constant file name.  When I add the current date variable to the exported file name, the file is created without interpreting the value for date variable.  For example, the file is created as &[mm]&[dd]&[yy]_SummaryExport.xlsx rather than 013119_SummaryExport.xlsx.

     

    The converse is also true.  I have a detail file that exports correctly with a date variable in the file name.

     

    Thanks for any suggestions.

     

    ______________

    Ann Stapanowich

    Analyst - Revenue Cycle

    Mission Health System

     

     

    This message and its attachments may contain confidential and/or legally-sensitive information that is intended for the sole use of the addressee(s). Any unauthorized review, use, disclosure, or distribution of the information contained in this message and its attachments is prohibited. If you have received this message or any of its attachments in error, please destroy all originals and copies of the same and notify the sender immediately.
    We have Automator version 12.2 and Monarch version 14.2.  It occurs when exporting directly from Monarch.  Thanks for the work around suggestion.

    Ann

    ------------------------------
    Ann Stapanowich
    Revenue Cycle Analyst
    Mission Health
    Asheville NC
    (828) 651-4110
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 01-31-2019 12:10 PM
    From: Steve Caiels
    Subject: Summary Report exported into multiple tabs and naming macro for date in exported file name problem

    Hi Ann,

    I'll look into this.  They are not mutually exclusive, as far as I know.  Which version of Automator are you using?  Is it a standard or Visual process?

    In the meantime, you should be able to export with a static file name, then add a distribution to include the date macro.

    Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Service
    Datawatch Corporation
    +44 203 868 0253
    ------------------------------

    Original Message:
    Sent: 01-31-2019 11:10 AM
    From: Ann Stapanowich
    Subject: Summary Report exported into multiple tabs and naming macro for date in exported file name problem

    is it possible to have a summary export distributed among multiple tabs that has a file name with the date variable? 

     

    My summary report exports correctly into multiple tabs based on distinct value of first key with a constant file name.  When I add the current date variable to the exported file name, the file is created without interpreting the value for date variable.  For example, the file is created as &[mm]&[dd]&[yy]_SummaryExport.xlsx rather than 013119_SummaryExport.xlsx.

     

    The converse is also true.  I have a detail file that exports correctly with a date variable in the file name.

     

    Thanks for any suggestions.

     

    ______________

    Ann Stapanowich

    Analyst - Revenue Cycle

    Mission Health System

     

     

    This message and its attachments may contain confidential and/or legally-sensitive information that is intended for the sole use of the addressee(s). Any unauthorized review, use, disclosure, or distribution of the information contained in this message and its attachments is prohibited. If you have received this message or any of its attachments in error, please destroy all originals and copies of the same and notify the sender immediately.
  • Steve_Caiels
    Steve_Caiels
    Altair Employee
    edited February 2019
    ann_21588 said:

    We have Automator version 12.2 and Monarch version 14.2.  It occurs when exporting directly from Monarch.  Thanks for the work around suggestion.

    Ann

    ------------------------------
    Ann Stapanowich
    Revenue Cycle Analyst
    Mission Health
    Asheville NC
    (828) 651-4110
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 01-31-2019 12:10 PM
    From: Steve Caiels
    Subject: Summary Report exported into multiple tabs and naming macro for date in exported file name problem

    Hi Ann,

    I'll look into this.  They are not mutually exclusive, as far as I know.  Which version of Automator are you using?  Is it a standard or Visual process?

    In the meantime, you should be able to export with a static file name, then add a distribution to include the date macro.

    Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Service
    Datawatch Corporation
    +44 203 868 0253
    ------------------------------

    Original Message:
    Sent: 01-31-2019 11:10 AM
    From: Ann Stapanowich
    Subject: Summary Report exported into multiple tabs and naming macro for date in exported file name problem

    is it possible to have a summary export distributed among multiple tabs that has a file name with the date variable? 

     

    My summary report exports correctly into multiple tabs based on distinct value of first key with a constant file name.  When I add the current date variable to the exported file name, the file is created without interpreting the value for date variable.  For example, the file is created as &[mm]&[dd]&[yy]_SummaryExport.xlsx rather than 013119_SummaryExport.xlsx.

     

    The converse is also true.  I have a detail file that exports correctly with a date variable in the file name.

     

    Thanks for any suggestions.

     

    ______________

    Ann Stapanowich

    Analyst - Revenue Cycle

    Mission Health System

     

     

    This message and its attachments may contain confidential and/or legally-sensitive information that is intended for the sole use of the addressee(s). Any unauthorized review, use, disclosure, or distribution of the information contained in this message and its attachments is prohibited. If you have received this message or any of its attachments in error, please destroy all originals and copies of the same and notify the sender immediately.
    Hi Ann,

    Macro naming and distributions are only available in Automator.  I'm afraid the workaround suggestion won't be of any use to you in desktop Monarch, either.

    Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Service
    Datawatch Corporation
    +44 203 868 0253
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 01-31-2019 01:41 PM
    From: Ann Stapanowich
    Subject: Summary Report exported into multiple tabs and naming macro for date in exported file name problem

    We have Automator version 12.2 and Monarch version 14.2.  It occurs when exporting directly from Monarch.  Thanks for the work around suggestion.

    Ann

    ------------------------------
    Ann Stapanowich
    Revenue Cycle Analyst
    Mission Health
    Asheville NC
    (828) 651-4110
    ------------------------------

    Original Message:
    Sent: 01-31-2019 12:10 PM
    From: Steve Caiels
    Subject: Summary Report exported into multiple tabs and naming macro for date in exported file name problem

    Hi Ann,

    I'll look into this.  They are not mutually exclusive, as far as I know.  Which version of Automator are you using?  Is it a standard or Visual process?

    In the meantime, you should be able to export with a static file name, then add a distribution to include the date macro.

    Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Service
    Datawatch Corporation
    +44 203 868 0253

    Original Message:
    Sent: 01-31-2019 11:10 AM
    From: Ann Stapanowich
    Subject: Summary Report exported into multiple tabs and naming macro for date in exported file name problem

    is it possible to have a summary export distributed among multiple tabs that has a file name with the date variable? 

     

    My summary report exports correctly into multiple tabs based on distinct value of first key with a constant file name.  When I add the current date variable to the exported file name, the file is created without interpreting the value for date variable.  For example, the file is created as &[mm]&[dd]&[yy]_SummaryExport.xlsx rather than 013119_SummaryExport.xlsx.

     

    The converse is also true.  I have a detail file that exports correctly with a date variable in the file name.

     

    Thanks for any suggestions.

     

    ______________

    Ann Stapanowich

    Analyst - Revenue Cycle

    Mission Health System

     

     

    This message and its attachments may contain confidential and/or legally-sensitive information that is intended for the sole use of the addressee(s). Any unauthorized review, use, disclosure, or distribution of the information contained in this message and its attachments is prohibited. If you have received this message or any of its attachments in error, please destroy all originals and copies of the same and notify the sender immediately.
  • Mahmoud
    Mahmoud
    Altair Employee
    edited February 2019
    Steve Caiels_21881 said:

    Hi Ann,

    I'll look into this.  They are not mutually exclusive, as far as I know.  Which version of Automator are you using?  Is it a standard or Visual process?

    In the meantime, you should be able to export with a static file name, then add a distribution to include the date macro.

    Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Service
    Datawatch Corporation
    +44 203 868 0253
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 01-31-2019 11:10 AM
    From: Ann Stapanowich
    Subject: Summary Report exported into multiple tabs and naming macro for date in exported file name problem

    is it possible to have a summary export distributed among multiple tabs that has a file name with the date variable? 

     

    My summary report exports correctly into multiple tabs based on distinct value of first key with a constant file name.  When I add the current date variable to the exported file name, the file is created without interpreting the value for date variable.  For example, the file is created as &[mm]&[dd]&[yy]_SummaryExport.xlsx rather than 013119_SummaryExport.xlsx.

     

    The converse is also true.  I have a detail file that exports correctly with a date variable in the file name.

     

    Thanks for any suggestions.

     

    ______________

    Ann Stapanowich

    Analyst - Revenue Cycle

    Mission Health System

     

     

    This message and its attachments may contain confidential and/or legally-sensitive information that is intended for the sole use of the addressee(s). Any unauthorized review, use, disclosure, or distribution of the information contained in this message and its attachments is prohibited. If you have received this message or any of its attachments in error, please destroy all originals and copies of the same and notify the sender immediately.
    Hi Ann,
    I tested a summary export to multiple tabs based on a unique key in the Automator v12.2.50.47.
    I used date macro preceding the file name, and it worked for me.
    I used the following date macros in the file name and both worked just fine:
    &[mm]&[dd]&[yy]_export1.xlsx
    &[yyyy]&[mm]&dd]_export1.xlsx

    The last patch update for the Datawatch Server Automator v12.2 is 12.2.50.58.  I know you said you are using v12.2, but you may not installed the latest patch for v12.2.  It could be a bug in early version of Automator 12.2.
    I suggest you either apply the latest patch for version 12.2, or better yet, upgrade the Datawatch Server Automator v12.2 to Monarch Server Automator v15.3.0.
    Please contact the support@datawatch.com and request for a download link for the patch or upgrade.
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 01-31-2019 12:10 PM
    From: Steve Caiels
    Subject: Summary Report exported into multiple tabs and naming macro for date in exported file name problem

    Hi Ann,

    I'll look into this.  They are not mutually exclusive, as far as I know.  Which version of Automator are you using?  Is it a standard or Visual process?

    In the meantime, you should be able to export with a static file name, then add a distribution to include the date macro.

    Regards,
    Steve.

    ------------------------------
    Steve Caiels
    Professional Service
    Datawatch Corporation
    +44 203 868 0253
    ------------------------------

    Original Message:
    Sent: 01-31-2019 11:10 AM
    From: Ann Stapanowich
    Subject: Summary Report exported into multiple tabs and naming macro for date in exported file name problem

    is it possible to have a summary export distributed among multiple tabs that has a file name with the date variable? 

     

    My summary report exports correctly into multiple tabs based on distinct value of first key with a constant file name.  When I add the current date variable to the exported file name, the file is created without interpreting the value for date variable.  For example, the file is created as &[mm]&[dd]&[yy]_SummaryExport.xlsx rather than 013119_SummaryExport.xlsx.

     

    The converse is also true.  I have a detail file that exports correctly with a date variable in the file name.

     

    Thanks for any suggestions.

     

    ______________

    Ann Stapanowich

    Analyst - Revenue Cycle

    Mission Health System

     

     

    This message and its attachments may contain confidential and/or legally-sensitive information that is intended for the sole use of the addressee(s). Any unauthorized review, use, disclosure, or distribution of the information contained in this message and its attachments is prohibited. If you have received this message or any of its attachments in error, please destroy all originals and copies of the same and notify the sender immediately.

Categories