Hi,
I want to be able to export 6 views of the same module to external file (xls). I have saved the 6 views and i have exported and saved the processes. I would like to have 1 script to run the 6 outputs, but if i use a script with all six, it only runs the final process. I did try creating one process with the 6 actions, but that also just runs the final action.
This is the script (well similar)
Thanks
rem OUTPUT the Promo history set Operation=-export "Report 1" -execute -get "M:\file1.xls" set Operation=-export "Report 2" -execute -get "M:\file2.xls" set Operation=-export "Report 3" -execute -get "M:\file3.xls" set Operation=-export "Report 4" -execute -get "M:\file4.xls" set Operation=-export "Report 5" -execute -get "M:\file5.xls" set Operation=-export "Report 6" -execute -get "M:\file6.xls"
Solved! Go to Solution.
Ahh i think i have solved it.. i need to have the trigger information between each process in the script. This then runs them one after another.
Give msyelf Kudos 🙂
set Operation=-export "Audit - 1" -execute -get "C:\Audit 1.xls" setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser% set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation% @echo %Command% cmd /c %Command% set Operation=-export "Audit - 2" -execute -get "C:\Audit 2.xls" setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser% set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation% @echo %Command% cmd /c %Command%
Hi, have you thought of just putting in a line break?
set Operation="-export "Report 1" -execute -get "M:\file1.xls" ^ -export "Report 2" -execute -get "M:\file2.xls" ^ -export "Report 3" -execute -get "M:\file3.xls" ^ -export "Report 4" -execute -get "M:\file4.xls" ^ -export "Report 5" -execute -get "M:\file5.xls" ^ -export "Report 6" -execute -get "M:\file6.xls" "