Anaplan Connect: Dumpfile

Options
RalfdeGier
RalfdeGier Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Contributor
in Extensibility

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="https://community.anaplan.com/t5/user/viewprofilepage/user-id/32043">@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

 

 

Tagged:

Comments

  • tbeck
    tbeck Member, ALL USERS, GroupMember, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 5 Certified Master Anaplanner

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

    tbeck_0-1639579338170.png

     

    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

Categories