Do you know about integration data between SFTP (Filezila) to Anaplan?
I want to import data from SFTP file to Anaplan.
Hi @adisulyadi , I think you can able to achieve this with the help of Anaplan Connect. Write a batch script to export the file from SFTP and load the file in Anaplan with the batch script. Sample code: @echo off
REM Set the path to the Anaplan Connect executable set ANAPLAN_CONNECT_PATH=C:\Anaplan\AnaplanConnect\AnaplanConnect.bat
REM Set the SFTP connection details set SFTP_HOST=my.sftp.server.com set SFTP_PORT=22 set SFTP_USER=myusername set SFTP_PASSWORD=mypassword set SFTP_REMOTE_DIR=/path/to/remote/directory set SFTP_FILE_NAME=MySFTPFile.csv
REM Set the Anaplan import action ID set IMPORT_ACTION_ID=123456789
REM Set the name of the import file as defined in Anaplan set IMPORT_FILE_NAME=MyImportFile.csv
REM Set the path to the directory where the import file will be saved set IMPORT_FILE_DIR=C:\Anaplan\ImportFiles
REM Download the file from SFTP to the local directory sftp -oPort=%SFTP_PORT% %SFTP_USER%@%SFTP_HOST%:%SFTP_REMOTE_DIR%/%SFTP_FILE_NAME% "%IMPORT_FILE_DIR%%IMPORT_FILE_NAME%" if %ERRORLEVEL% NEQ 0 ( echo Error downloading file from SFTP exit /b 1 )
REM Execute the Anaplan import action using Anaplan Connect "%ANAPLAN_CONNECT_PATH%" import "%IMPORT_ACTION_ID%" -file "%IMPORT_FILE_DIR%%IMPORT_FILE_NAME%" -put "MyPutValue"
REM Exit the script with a success status exit /b 0
Hope this helps :). Regards, Venkatesh
Hello @adisulyadi,
Just to add to the above, I believe you have a few options on the table:
Hope that makes sense!
Cheers!
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the nodeβ¦
As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (JanβAug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025. If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025β¦
I have completed level 2 certificate still I am not confident. I want practice more, where I get small project for practice.