Multiple outputs from 1 Anaplan Connect Script or 1 Process

DeveloperCYT
DeveloperCYT
in Integrations and extensibility

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"
Tagged:

Best Answer

  • DeveloperCYT
    DeveloperCYT
    Answer ✓

    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%

Answers

  • dpiggot1
    dpiggot1

    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" "

     

  • Stan
    Stan

Categories