I have 4 files that need to be imported in anaplan, that have the exact same columns name and that will hence use the same action.
Is it possible to write a single script by 'cumulating' the actions and having something like : set Operation=-file "file1.csv" -put "data/ImportModule.csv" -import "New Hire from Employee.txt" -execute -file "file2.csv" - put "data/ImportList.csv"-import "New Hire from Employee.txt" -execute [same for file 3 and 4...]
Or would I need to have 4 different scripts ?
Thanks in advance for your help,
Solved! Go to Solution.
According to my knowledge, you have to have 4 different batch scripts to upload the files because here you are trying to import different files into same action. Consider the same in Anaplan manually we will do the uplaod one by one.
Lets wait for other experts to throw their answer :)
You can upload all of the files in one batch script, but the actions will need to be different as the actions are tied to the file name so please make the file names different. Also, for audit reasons, I am not sure you will want to overwrite the files.
Hope this helps,
Thank you for your answer. I am trying to implement the script with:
2 files: ACHATS.csv & DIV3.csv (that have the exact same format)
using the same process: "Charger les depenses"
My script looks like this, but doesn't seem to be working (I attached the bat file summary). Any idea of what is wrong ? Could it be due to the fact that the source label of the actions of the process does not have the same name as my two files ?
rem This example loads a source text file and runs an Anaplan import into a module.
rem For details of how to configure this script see doc\Anaplan Connect User Guide.doc
set Operation= – certificate “C:\Users\sweemaels\Documents\3. Clients\XXX\anaplan-connect-1-3-3-5\certificate-xxx.cer” - file "DIV3.csv" -put "C:\Users\sweemaels\XXX\4. Load - Templates\DIV3.csv" - file "ACHATS.csv"
-put "C:\Users\sweemaels\XXX\4. Load - Templates\ACHATS.csv" - process "Charger les depenses" -execute
rem *** End of settings - Do not edit below this line ***
setlocal enableextensions enabledelayedexpansion || exit /b 1
if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%
set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation%
cmd /c %Command%
Try removing the spaces between the "-" and the command. So, it is should be -certifcate, -put, -file, and -execute.
Hope this helps,
thanks for your answer.Unfortunetaly it doesn't look like it changes anything..