Integration- Anaplan Connect

Highlighted
Regular Contributor

Integration- Anaplan Connect

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

4 REPLIES 4
Highlighted
Community Boss

Re: Integration- Anaplan Connect

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


Nathan Rudman, Anaplan Model Builder
Highlighted
Certified Master Anaplanner

Re: Integration- Anaplan Connect

@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
Thanks
Anik
Highlighted
Regular Contributor

Re: Integration- Anaplan Connect

@anikdas @nathan_rudman Thanks for the Swift Reply

 

Working Perfect.👍

 

 

 

Highlighted
New Contributor

Re: Integration- Anaplan Connect

Is something similar available for integration with Hyperconnect as well?