Need the Import Scripts | file name append with date & time stamp

Hi Guys,

I need import action batch script to take the file name with (Date & Time details) and every time same file name keep on changing with updated date & time stamp.

Example: File name : Import_File_Name_30062020_0930.csv

and next time the file name to run the same import scripts is below:

File name: Import_File_Name_01072020_1030.csv

Thanks in advance

Accepted answers

anikdas

@xrprasadx

Please look at this thread (seems duplicate):

https://community.anaplan.com/t5/Anaplan-Platform/Integration-Anaplan-Connect/m-p/75428#M15594

xrprasadx

================Working Script=================================

@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="username:password"
set WorkspaceId="Type WorkspaceID"
set ModelId="Type ModelID"
set DumpName="Client Location for Dumping the Errored data from Import"
set Chunksize=1

for %%F in (E:\anaplan\filename_*.csv) do set filename=%%F
echo %filename%
pause
set Operation==-file "File_Name.csv" -put "%filename%"
set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -file "File_Name.csv" -put "%filename%" -process "ProcessName" -execute -output "C:\Desktop\Archive\folderName"

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% -workspace %WorkspaceId% -model %ModelId% %Operation%
@Echo %Command%
cmd /c %Command%

move E:\anaplan\filename_*.csv "C:\Desktop\Archive\"
pause

=========================================================================================

All comments

Misbah

@xrprasadx

Haven't done any such thing in the past. I am not even certain if that is the possibility in Integration activities as Anaplan Connect will look for the same file in the server. I might be wrong here but let's see what others have to say. @ben_speight can you help here.

anikdas

@xrprasadx

Please look at this thread (seems duplicate):

https://community.anaplan.com/t5/Anaplan-Platform/Integration-Anaplan-Connect/m-p/75428#M15594

Harsha

Hey,

just a thought, what if you write script to rename file from Import_File_Name_30062020_0930.csv to Import_File_Name.csv in the same path before Anaplan connect script kicks in.

mv src_name dest_name

ben_speight

If you specify a server file using -file, the server file name is completely independent of the local file name (if you don't, the server file defaults to the local file name). If you use a YYYYMMDD format for the name, it is easier to sort them and find the most recent.

xrprasadx

Thankyou

anikdas

@xrprasadx

Yes that can also work, in the end Anaplan Connect will look for a fixed name

xrprasadx

================Working Script=================================

@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="username:password"
set WorkspaceId="Type WorkspaceID"
set ModelId="Type ModelID"
set DumpName="Client Location for Dumping the Errored data from Import"
set Chunksize=1

move E:\anaplan\filename_*.csv "C:\Desktop\Archive\"
pause

=========================================================================================

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…