Hey everyone, I'm having issues with using a new certificate in Anaplan Connect 1-3-3-5. The error is "Anaplan API: Could not initialise service credentials (Runtime: The specified certificate path 'C:\Users\KBeltz\Documents\certificate-8936384729097362371525000942346120755' is invalid)" @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 certificate="C:\Users\KBeltz\Documents\certificate-8936384729097362371525000942346120755" set WorkspaceId="" set ModelId="" set Operation= -export "Current Forecast COP.csv" -execute -get "C:\Users\KBeltz\Documents\Current Forecast COP.csv" rem *** End of settings - Do not edit below this line *** setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %certificate% == "" set Credentials=-certificate %certificate% set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation% @echo %Command% cmd /c %Command% pause Any help would be much appreciated!
... View more
I figured out the way Anaplan generates the order of Singular Column exports. Columns are exported left to right in order they appear from top to bottom in your general lists. So a way to control the export columns is to go to your general lists and rearrange them on how you want the export to be. This is severly flawed. It's too easy and necessary to rearrange your lists logically, and if you have multiple developers in Anaplan, lists can constantly be rearranged by anyone. "Oh that makes sense to move"
... View more