Anaplan Connect 1.3.3.5 - multiple files import

Good evening,

I have 4 files that need to be imported in anaplan, that have the exact same columns name and that will hence use the same action.

Is it possible to write a single script by 'cumulating' the actions and having something like : set Operation=-file "file1.csv" -put "data/ImportModule.csv" -import "New Hire from Employee.txt" -execute -file "file2.csv" - put "data/ImportList.csv"-import "New Hire from Employee.txt" -execute [same for file 3 and 4...]

Or would I need to have 4 different scripts ?

Thanks in advance for your help,

Sarah

Accepted answers

ben_speight

This should be fine. Anaplan Connect processes the command line options in the order that they appear. You actually only need to specify -file once - after that every -put will be to that file (if no -file was specified before a put then the file name is used). Likewise, you only need to specify -import once - until another import, export, action or process is specified then that will be run by any subsequent -execute. If you need to collect a dump file (using -output) you must do so before you run that import again. The file names you provide are confusing though - importing into a module requires a different import action to importing into a list, although they can both use the same source.

All comments

kavinkumar

HI Sarah,

According to my knowledge, you have to have 4 different batch scripts to upload the files because here you are trying to import different files into same action. Consider the same in Anaplan manually we will do the uplaod one by one.

Lets wait for other experts to throw their answer 🙂

Thanks ,

Kavin.

rob_marshall

@sweemaels ,

You can upload all of the files in one batch script, but the actions will need to be different as the actions are tied to the file name so please make the file names different. Also, for audit reasons, I am not sure you will want to overwrite the files.

Hope this helps,

Rob

ben_speight

sweemaels

Hi Ben,

Thank you for your answer. I am trying to implement the script with:

2 files: ACHATS.csv & DIV3.csv (that have the exact same format)

using the same process: "Charger les depenses"

My script looks like this, but doesn't seem to be working (I attached the bat file summary). Any idea of what is wrong ? Could it be due to the fact that the source label of the actions of the process does not have the same name as my two files ?

@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="8a81b00xxxxe0a01727ac0"
set ModelId="FDADAA9xxxx4F346FC3827A"
set Operation= – certificate “C:\Users\sweemaels\Documents\3. Clients\XXX\anaplan-connect-1-3-3-5\certificate-xxx.cer” - file "DIV3.csv" -put "C:\Users\sweemaels\XXX\4. Load - Templates\DIV3.csv" - file "ACHATS.csv"
-put "C:\Users\sweemaels\XXX\4. Load - Templates\ACHATS.csv" - process "Charger les depenses" -execute

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%
pause

Capture_42658.JPG

rob_marshall

@sweemaels ,

Try removing the spaces between the "-" and the command. So, it is should be -certifcate, -put, -file, and -execute.

Hope this helps,

Rob

sweemaels

Hi Rob,

thanks for your answer.Unfortunetaly it doesn't look like it changes anything..

Kind regards,

Sarah

rob_marshall

Sarah,

What does the error message say?

Quick Links

Can you help?

Unanswered questions

How to extract Previous Column Ending Balance as Current Opening Balance (without time dimension)
I want to track the Opening balance, drawdown, and ending balance for the following specific dates. I created the following dates in General List. Then I created the following module to track the balance, which there is a line item called Beginning balance which is the previous value of the Ending Balance. Draw/Repayment…
Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…