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

Question

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.

Mo Abdolrahim · Answer

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.

Steve_Caiels · Answer

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.

ann_21588 · Answer

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.