Fixed Export Destination

MarkTurkenburg_*8288

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

Accepted answers

VIGNESH.M

Hi Mark,

Yes, with Anaplan connect we can save the export in the predefined directory.

~Vignesh M

All comments

anirudh

Hi Mark,

Are you using Anaplan connect?

MarkTurkenburg_*8288

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?

Thanks

anirudh

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

VIGNESH.M

Hi Mark,

Yes, with Anaplan connect we can save the export in the predefined directory.

~Vignesh M

MarkTurkenburg_*8288

Thanks!

karank_*4578

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

MarkTurkenburg_*8288

Thanks Anirudh!

DeveloperCYT

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??

Quick Links

Can you help?

Unanswered questions

How to use Client ID and Client Secret for API request directly?
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
12_ [COMPLETE GUIDE] Uphold Support Number
At Uphold customer support ⭐+1-888-355-2348 accounts may be temporarily disabled or restricted for various reasons. Raise a concern on priority basis at Uphold support ⭐+1-888-355-2348 if you notice any suspected malicious activity, or a problem during account recovery. To contact Uphold support directly at…
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…