Regarding Anaplan Connect Import Scripting

Deepu
Deepu
in Integrations and extensibility

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

 

 

 

 

Tagged:

Answers

  • alexpavel
    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
    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
    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. 

Categories