Date in export file name

Baba Majekodunmi_21731 said:

Okay, I will defer to @Mahmoud Abdolrahim and @Steve Caiels on this. I normally use the naming macros available within Automator and/or feed the exports to a database (Access or SQL).

Sometimes I also use the distribution node to move all processed files to a folder and have them renamed. But I see the value in your method too.

------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325
------------------------------
-------------------------------------------
Original Message:
Sent: 02-26-2020 03:33 PM
From: Tim Schrupp
Subject: Date in export file name

That notation to append current date to filenames has been working great in both Automator and desktop.  However, I need to export files with the date as current date + 1, and haven't seen any way to do that.  The export will be created as an Automator process, so it shouldn't matter whether it will work in a desktop project.

Example, a file exported today would be created as Filename_02262020.txt, and I need to export to Filename_02272020.txt.

------------------------------
Tim Schrupp
Enterprise BI Developer
------------------------------

Original Message:
Sent: 02-26-2020 02:39 PM
From: Baba Majekodunmi
Subject: Date in export file name

Hi @Tim Schrupp!

Impressive stuff. I'm not sure that you can define dynamic export naming convention at all within a Model or Project, at least with regards to desktop. As you know this is available in Automator. Is the automator process not working as intended? Or is it longer/require more steps than you would prefer?

@Mahmoud Abdolrahim and @Steve Caiels, who do you gentlemen think?


------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325

Original Message:
Sent: 02-26-2020 11:58 AM
From: Tim Schrupp
Subject: Date in export file name

I have several files being exported via Monarch 15 and Automator where I am appending the current date to the file name in the export settings as follows:

\\server\path\filename_&[mm]&[dd]&[yyyy].ext

I now have a need to export with a different date, mostly as <current date> + 1.

I can do this with a post-process script, but would prefer to define it in the Monarch/Automator project.  Does anyone know a way that this can be done?

------------------------------
Tim Schrupp
Enterprise BI Developer
------------------------------
"

To assign previous day macro use the following syntax:
previous day: &[yy]&[mm]&[dd.-1d]
Previous month: &[yy]&[mm.-1m]&[dd]
Previous year: &[yy.-1y]&[mm]&[dd]

replace minus sign with plus sign for future date: previous day: &[yy]&[mm]&[dd.+1d]

When month changes, the syntax should be &[yy]&[mm.-1m]&[dd.-1d]
When year changes, the syntax should be &[yy.-1y]&[mm.-1m]&[dd.-1d]

demo1_&[yyyy.-1y]&[mm.-1m]&[dd.-1d].xlsx  (if date is 09/16/2019 the file name will be: demo1_20180816.xlsx)
demo1_&[yyyy]&[mm.-3m]&[dd].xlsx (if date is 09/16/2019 the file name will be: demo1_20190617.xlsx)
Regards
Mo

------------------------------
Mahmoud Abdolrahim
Senior Implementation & Integration Engineer
Datawatch Corporation
MA
(978) 935-3840
------------------------------
-------------------------------------------
Original Message:
Sent: 02-26-2020 03:52 PM
From: Baba Majekodunmi
Subject: Date in export file name

Okay, I will defer to @Mahmoud Abdolrahim and @Steve Caiels on this. I normally use the naming macros available within Automator and/or feed the exports to a database (Access or SQL).

Sometimes I also use the distribution node to move all processed files to a folder and have them renamed. But I see the value in your method too.

------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325
------------------------------

Original Message:
Sent: 02-26-2020 03:33 PM
From: Tim Schrupp
Subject: Date in export file name

That notation to append current date to filenames has been working great in both Automator and desktop.  However, I need to export files with the date as current date + 1, and haven't seen any way to do that.  The export will be created as an Automator process, so it shouldn't matter whether it will work in a desktop project.

Example, a file exported today would be created as Filename_02262020.txt, and I need to export to Filename_02272020.txt.

------------------------------
Tim Schrupp
Enterprise BI Developer

Original Message:
Sent: 02-26-2020 02:39 PM
From: Baba Majekodunmi
Subject: Date in export file name

Hi @Tim Schrupp!

Impressive stuff. I'm not sure that you can define dynamic export naming convention at all within a Model or Project, at least with regards to desktop. As you know this is available in Automator. Is the automator process not working as intended? Or is it longer/require more steps than you would prefer?

@Mahmoud Abdolrahim and @Steve Caiels, who do you gentlemen think?


------------------------------
Baba Majekodunmi
Solutions Consultant
Altair Engineering Inc.
Manassas VA
978-275-9325

Original Message:
Sent: 02-26-2020 11:58 AM
From: Tim Schrupp
Subject: Date in export file name

I have several files being exported via Monarch 15 and Automator where I am appending the current date to the file name in the export settings as follows:

\\server\path\filename_&[mm]&[dd]&[yyyy].ext

I now have a need to export with a different date, mostly as <current date> + 1.

I can do this with a post-process script, but would prefer to define it in the Monarch/Automator project.  Does anyone know a way that this can be done?

------------------------------
Tim Schrupp
Enterprise BI Developer
------------------------------
"