does not produce output when i run MonarchDataPrepStudio.Automation dos command "C:\Program Files\Altair Monarch 2021\DPS\MonarchDataPrepStudio.Automation.exe" /dpwx:"C:\Users\Dhiraj_2\Desktop\data\custsalesrpt\product analyze.dpwx" /expall:"C:\Use

Dhiraj_21261
Dhiraj_21261 Altair Community Member
edited May 2022 in Community Q&A

Hi,

 

I like to automate batch file to automatically provide excel file in a folder by executing MonarchDataPrepStudio.Automation.exe with a workspace.

Executed below command but does not output the excel file.

"C:\Program Files\Altair Monarch 2021\DPS\MonarchDataPrepStudio.Automation.exe" /dpwx:"C:\Users\Dhiraj_2\Desktop\data\custsalesrpt\product analyze.dpwx" /expall:"C:\Users\Dhiraj_2\Desktop\data\custsalesrpt\output\custsales.xlsx"

 

Any suggestions?

 

Kind Regards

 

 

Dhiraj

Tagged:

Best Answer

  • CPorthouse
    CPorthouse
    Altair Employee
    edited May 2022 Answer ✓

    The /expall command does not take any arguments and is used to export all named exports that have been defined in the workspace.

    Are you able to share the output of the command line.  You should see something similar to:

    MonarchDataPrepStudio.Automation.exe /dpwx:"C:\Users\cporthouse\Desktop\DPS Summary All by Measure.dpwx" /expall MonarchDataPrepStudio.Automation.exe Version 17.1.0.30357  Export to C:\Users\cporthouse\Desktop\summary.xlsx completed Rows Exported: 21 Elapsed time: 0m:0s

Answers

  • CPorthouse
    CPorthouse
    Altair Employee
    edited May 2022 Answer ✓

    The /expall command does not take any arguments and is used to export all named exports that have been defined in the workspace.

    Are you able to share the output of the command line.  You should see something similar to:

    MonarchDataPrepStudio.Automation.exe /dpwx:"C:\Users\cporthouse\Desktop\DPS Summary All by Measure.dpwx" /expall MonarchDataPrepStudio.Automation.exe Version 17.1.0.30357  Export to C:\Users\cporthouse\Desktop\summary.xlsx completed Rows Exported: 21 Elapsed time: 0m:0s
  • Dhiraj_21261
    Dhiraj_21261 Altair Community Member
    edited May 2022

    Hi Chris,

    Great. It works.

    Thank you.

    Kind Regards

     

    Dhiraj

     

  • Dhiraj_21261
    Dhiraj_21261 Altair Community Member
    edited May 2022

    Hi Chris,

     

    Good morning,

     

    I have a date range as a filter in one of the tables in the workspace for the data prep stedio.

     

    Is there a way to pass the date range parameters to the filter via the command line automation.

     

    Kind Regards

     

    Dhiraj

     

     

Categories