Hi everyone, I'm trying to automatically export dump files when the Anaplan connect API has run. With normal imports/exports, it works fine and I'm able to specify a name for the txt-file. When I use a process, I'm not able to give the txt a name. I can only specify the folder. Is there any way to give the dumpfile a custom name?
I use the following code:
set processname="API - CSV - Import test"
set DumpName="D:\004. Bestanden\Foutmeldingen\test.txt"
set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -file %FileName% -put %FilePath% -process %processname% -execute -output %DumpName%
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% %Operation%
cmd /c %Command%
Name your export action exactly what you want the file name to be.
For example if you want your file name to be "Extract Data.txt", your export action should be named as "Extract Data" and you can wrap this export action into a process and you can name process whatever you wish to.
When you run a process action, Anaplan Connect requires a directory because there may be multiple dump files from different imports.
If you need more control over dump file naming, then you can run each import directly (using -import instead of -process) and then specify a file in -output. Otherwise, the naming convention used is stable so you can rename/move the file afterwards in your script.
Interesting discussion here. If Ben's solution does not work for you, consider seeking out 3rd party resources on Google for custom batch scripting or PowerShell scripts that may be able to produce what you are looking for. Though Anaplan does not support these resources.