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

Accepted answers

nathan_rudman

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

@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

All comments

nathan_rudman

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

@abhi1017

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

abhi1017

@anikdas @nathan_rudman Thanks for the Swift Reply

Working Perfect.👍

Mudarya

Is something similar available for integration with Hyperconnect as well?

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385