Regarding Anaplan Connect Import Scripting

Dear Team ,

I am using Anaplan Connect on Windows server where i need to write Script for Import/export files from Windows server to Anaplan Application .

My Question he as below : Let say I have 1 folder in Windows server named Import Files where ETL jobs keep the file to load into Anaplan System . So once that file is loaded into Anaplan , We need to Moved that file from Import File Folder to Archived Folder by adding time stamp of load date and time . and post that Import File Folder get empty once file moved.

Ex - Import Folder -- > GLACCT_20210224_130302.txt(post this file loaded , folder should be empty)

Archived Folder -- >GLACCT_20210224_130302_20210225_230303.txt(folder must have files with added timestamp.)

Kindly do Advice on the same!

Warm Regards

Deepak

Accepted answers

All comments

alexpavel

@Deepu to achieve this you need to use Windows cmd batch commands and not Anaplan connect commands.

there are solutions out there.. just google "how to add a timestamp to a file in a windows batch"

MarkWarren

You can do the file move and rename in the Anaplan Connect batch file (after the import), or run a separate one after.
Here's one I created to do this:
(where you have the folders named "IMPORT" and "ARCHIVE")

@Echooff
for /f "delims=" %%a in ('wmic OS Get localdatetime ^| find "."') do set dt=%%a
set YYYY=%dt:~0,4%
set MM=%dt:~4,2%
set DD=%dt:~6,2%
set HH=%dt:~8,2%
set Min=%dt:~10,2%
set Sec=%dt:~12,2%

set stamp=%YYYY%%MM%%DD%_%HH%%Min%%Sec%

for /R "%CD%\IMPORT" %%f in (*.txt) do (
move /Y "%%f" "%CD%\ARCHIVE\%%~nf_%stamp%%%~xf"
)

DaanishSoomar

Hello Deepu,

Yes as the others mentioned you can achieve moving the file from one location to another using Commands. I have seen others successfully do this utilizing Windows PowerShell. Googling tips on how to move a file using batch scripting or PowerShell queries will be your best friend as Anaplan does not offer guidance on how to perform custom scripting.

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?