So if I have created a process that I use via a dashboard button.
Step 1: clears a list
Step 2: The file to upload selection is available
Step 3: You choose the file
Step 4: You hit run
The process runs manually without issue.
If I use the Anaplan Connect, I created a .bat file and can trigger this process and it apparently works just fine, but I am NOT having to select a file.
What do I need to do when I run this process?
Do I need to create an Import of the file as a first .bat and THEN run the process?
Or do I define the file and file path that the process uses?
The following is my script...minus removing any identifying Parameters:
rem For Windows OS : This example explains the usage of basic Authentication with Anaplan Connect.
rem It also loads a source text file and runs an Anaplan import into a module.
rem For details of how to configure this script visit https://help.anaplan.com/anapedia/Content/Downloads/DL_Downloads.html
rem set Put="C:\QlikDev\Anaplan\Templates\CY_GROWER_ANAPLAN_IMPORT.csv" -put %Put% -File %File%
rem set Action="IMPORT_CY_GROWER_ANAPLAN_IMPORT.csv" -action %Action%
set Action="CY Grower Orders Update"
set Operation=-service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -process %Action% -execute -output "ERROR PATH" - Do not edit below this line ***
rem set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -P
setlocal enableextensions enabledelayedexpansion || exit /b 1
if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%
set Command=.\AnaplanClient.bat -d -d %Credentials% %Operation%
cmd /c %Command%
Firstly, it is not good practice to clear a list each time prior to re-loading. Using a defined key in the data to create a code for the list removes the need for this
But to your issue, the AC script is effectively like running the action directly from the actions tab rather than a dashboard so there is no prompt.
You can run the import and load in one script. The -file defines the name of the file and the -put loads this onto the cloud. you can then run the import or the process using -import or -process
I hope this helps
You need to use -put <local path> in the command line to upload fresh data before running any import or process. Before you use -put, specify the file data source in the model using -f.