Hi Team,
Is there a way that I can set a fixed Directory destination for an Export Action?
I want to always extract to the same directory so the data can be referenced by an Excel Macro
Thanks
Mark
Hi Mark,
Yes, with Anaplan connect we can save the export in the predefined directory.
~Vignesh M
Hi,
No I was just Exporting using the Actions and was going to use a Macro to drag the data into a seperate Excel file
Could Anaplan Connect handle this operation better?
Yes, with Anaplan connect you can use an argument to specify a permanent destination. Then just click the batch script and the export will land in the folder where you want to execute the macros
Here's an example export script:
@echo off set AnaplanUser="Anaplan.User@anaplan.com:Password" set WorkspaceId="8a1234567897c12b014bf01234567890" set ModelID="CD1234D60CA84E9A123C1C5D061C1234" set Operation=-export "Employee by Department.xls" -execute -get "C:\Employee.xls" 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
You can define the destination using the get part of the script
However, you will need Java for Anaplan connect to run
Let me know if you need addtional help setting this up
Regards,
Anirudh
Thanks!
Hi
Assuming you are using Chrome as your browser
I use Chrome extension called download router using which you can default your download location by file type , web address and many other things
I use anaplan.com as domain and specify where the file is to be downloaded . When i run export action from anaplan it downloads to my specified directory
hope this helps
Thanks Anirudh!
The problem with this is that the Anaplan connect scripts are outside the Anaplan environment
So you use Anaplan then have to got to run a batch file elsewhere, would be nice to have it contained within the environment.
Unless there is a way to embed an Anaplan Connect script within a dashboard??
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…