Integration- Anaplan Connect

abhi1017
abhi1017
in Integrations and extensibility

Hi Community,

 

I have to integrate Anaplan model to the ERP System(SAP)  using Anaplan Connect.

The file generated from ERP system is accompanied by date and time stamp,run on daily basis.

Is there any option/solution wherein i can ignore the date and time stamp generated from ERP system and consider only the file name.?

 

Thanks in Advance.

~Abhi

Tagged:

Best Answers

  • nathan_rudman
    nathan_rudman
    Answer ✓

    do you mean date and timestamp in the name of the file ?

     

    yes you can ignore that, but depends a lot on the system where you run AC.

    but you can use the bash placeholder *

    "filename*".txt

     

    How to do that exactly is a bash question

  • anikdas
    anikdas
    Answer ✓

    @abhi1017 

    Fortunately or unfortunately, I know which project this is for and I know the CS BP on the account is handling that with customer and you guys right now. This is for anyone who is also looking for similar solutions in future.

    P.S. You do need to move the file from source location once it is processed.

     

    @echo off
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 AnaplanUser=""
set WorkspaceId="8a81b08e664b157b01669ceb5db46654"
set ModelId="060195F8DCA84A428D646A612B3AA328"

for %%F in (C:\Users\Anonymous\Documents\anaplan-connect\Data\DC_Demand*.csv) do set filename=%%F
set Operation==-file "DC_Demand.csv" -put "%filename%"
set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -file "DC Demand.csv" -put "%filename%" -import "Demand Import" -execute	

rem *** End of settings - Do not edit below this line ***
setlocal enableextensions enabledelayedexpansion || exit /b 1
cd %~dp0
Download and Setup
Version 1.4.4 4 � Anaplan 2020
if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%
set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation%
@echo %Command%
cmd /c %Command%

move C:\Users\Anonymous\Documents\anaplan-connect\Data\DC_Demand*.csv "C:\Users\Anonymous\Documents\anaplan-connect\Archive\"
pause

Answers

Categories