Hi Everyone, I am currently trying to get past the authentication stage of Anaplan connect using a batch file with java keystore. However I am unable to get past the authentication stage, below is the screenshot of the error: Was wondering if it was an error on the or my batch file (and not the authentication details) The sample script (note I tried removing the certificate as mentioned in another post, but it returned the same results): @Echo off set KeyStorePath="...jks" set KeyStorePass="...." set KeyStoreAlias="...." set WorkspaceId="...." set ModelID="..." set CACertPath= "...crt" set DumpName="" set Chunksize=1 set Operation=-debug -service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -file %FileName1% -put %FilePath1% -output %DumpName% rem *** End of settings - Do not edit below this line *** setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 set Credentials=-certificate %CACertPath% -keystore %KeyStorePath% -keystorepass %KeyStorePass% -keystorealias %KeyStoreAlias% set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation% @Echo %Command% cmd /c %Command% pause Thanks in advance for your time.
... View more
Hi Everyone, thanks for your time. Would like to ask if anyone knows if it would be possible to update multiple modules at once across different sheets with the show changes option in the excel add-in (similar to how refresh worksheet works). Currently I am able to only do it for each sheet, am asking to see if I missed out anything. Took a look as well on the multi-sheet connection, seems like this connection is only for a single module having different sheets for selectors and not across different modules, unless I misunderstood or took a wrong step.
... View more
Hey there @gavina, Late reply but if you refer to Anapedia, it is apparently stated that setting default files via API is not possible. https://help.anaplan.com/anapedia/Content/Import_and_Export/Import_Data_into_Models/Overview_Private_Default_Files.htm Yours Sincerely, WeeMeng
... View more
Hi, This is the first time I am using Anaplan connect. While creating the script and looking at the documents, i drafted a script that allowed me to first upload, import thru an action followed by lastly a process.
I have apparently uploaded the file successfully however I am met with problems with my action that imports the file into a list.
To add on the specific error shown is: errorMessage - The uploaded file is no longer available; please upload the file again. In addition, moving to my model, if i run the action manually it now faced the same problem, which it did not just minutes ago. Further if I manually do the import by selecting the exact file, it shows me: an internal error occurred in some instances.
From the above, I would conclude that the import had an error, however from the cmd prompt, the import seemed fine
Below is the script
@Echo off rem For Windows OS : This example explains the usage of basic Authentication with Anaplan Connect. rem It also loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script visit https://help.anaplan.com/anapedia/Content/Downloads/DL_Downloads.html
set AnaplanUser="...:..." set WorkspaceId="..." set ModelId="..." set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set FileName="123.csv" set FilePath="C:\Users\123.csv" set ImportName="test import" set DumpName="Client Location for Dumping the Errored data from Import" set Chunksize=1 set Process = "Test Anaplan Connect" set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -file %FileName% -put %FilePath% -import %ImportName% -execute -process %Process% -execute -output %DumpName%
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% %Operation% @Echo %Command% cmd /c %Command% pause
Thank you in advance for the help.
... View more