Anaplan Connect: Dumpfile

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:

<a href="/profile/Echo">@Echo</a> off

set AnaplanUser=
set WorkspaceId=
set ModelId=
set ServiceUrl="https://api.anaplan.com"
set AuthUrl="https://auth.anaplan.com"
set FileName="test.csv"
set FilePath="D:\Dataexchange\test.csv"
set processname="API - CSV - Import test"
set DumpName="D:\004. Bestanden\Foutmeldingen\test.txt"
set Chunksize=1

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
cd %~dp0
if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%
set Command=.\AnaplanClient.bat %Credentials%  %Operation%
@echo %Command%
cmd /c %Command%
Exit

Accepted answers

ben_speight

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.

All comments

JaredDolich

@RalfdeGier

Adding @rob_marshall to this one. He's really good with Curl scripts.

Misbah

@RalfdeGier

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.

Hope that helps

Misbah

ben_speight

When you run a process action, Anaplan Connect requires a directory because there may be multiple dump files from different imports.

DaanishSoomar

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.

tbeck

Hello, you can always add the time stamp to the end of the file description to create a custom name, unique to the folder.

IF %time:~0,2% = ":" Goto :LESS10

goto :MORE10

:LESS10
set /a HOUR=%time:~0,1%%time:~2,2%
Goto :FinTraitement

:MORE10
set /a HOUR=%time:~0,2%%time:~3,2%
Goto :FinTraitement
:FinTraitement

SET DATE_OF_TODAY=%date:~4,2%%date:~7,2%%date:~10,4%
SET TIME=%Time%
SET DATE_TIME=%date:~4,2%%date:~7,2%%date:~10,4%_%HOUR:~0,2%
SET DATE_TIME_HOUR_MIN=%date:~4,2%%date:~7,2%%date:~10,4%_%HOUR:~0,2%%time:~3,2%

Rem EXPORT FILE
SET ANAPLAN_EXPORT_ACTION="[AC_#.#]_Export_Name_(1)"SET FOLDER_FILE_NAME="\\Export_File_Path_(1)"%DATE_TIME_HOUR_MIN%.csv

Quick Links

Can you help?

Unanswered questions

Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…