Importing and Exporting Data

Set formatting when export to excel
When end user export data to Excel, both number and text are right-aligned. My end user want to set text is left-aligned and number is right-aligned. Is it possible to set export formatting of each line item when export to excel?
Simultaneous processing (multi-threading) of Anaplan actions
As a user and/or model builder, I want to be able to run actions simultaneously where possible to speed up the data processing and list maintenance actions. This function should also allow other actions to be run only after certain actions have finished running successfully. As an example, if I want to load trial balance…
Extracting Data From Anaplan With Qlik
Qlik has two data analytics tools—the older one, QlikView, and the modern one, Qlik Sense. They both share similar scripting and the same data files. Data extracted with QlikView can be used by Qlik Sense and vice versa. Many enterprises still rely on QlikView and the QlikView Publisher to handle data reloads while they…
add processId, actionId, fileId as columns in Settings (for API development)
This will speed up API development and runtime both. The API requires ID's as parameter, however Anaplan UI shows only the Name. When using API for sending data to Anaplan or triggering a process we now use the name for searching the id. Currently this requires additional looping in our API framework. If we know from the…
Inconsistency on importing data from module to module
Hi All, Does anyone encountered this scenario on importing from the same module. I'm trying to import the value of Aug 20 - Actual to Sep 20 - Budget using a saved view. Here's the result: Item B to F imported the Aug 20 value. But item A seems to add .04. I also tried to zero out Aug 20 then run the import again and…
Financial planning tool selection - Adaptive planning vs Anaplan
Looking for advice as to how to make an informed decision on choosing adaptive vs anaplan for financial planning. Data sets are not too huge and the cost and simplicity of the tools are important factors in the selection process.
Condition-Based Trigger for Email Reporting
The current MAILTO function requires clicking the cell in order for an email to be generated. It would be very helpful if this click action occurs automatically only if a certain logical condition is met. For example, if the sum of all sales from last week reaches a certain threshold or is below a certain threshold, the…
model building activity 6 add formulas to REP04 module line items
hello. is there anybody, who can help with the LEVEL 1 Model Building Exam? I do not know what formulas to write in the model building activity 6
Order Issue when importing to a numbered list from a HUB module
Dear Community, Background: I have an attribute module in the HUB to manage a list (non-numbered). Further, I've built a process to build (by importing) the list in the spoke model as a numbered list. A numbered list is required in the spoke model because it is the lowest level of a hierarchy with duplicated names. Issue:…
Alphabetically ordered list
Hello all, I have a list of employees without alphabetical order in my model. On the dashboard, I can create a new employee in the list but I want the whole list to become ordered alphabetically when displaying for example. Would it be possible to help me ? Regards,
Anaplan Connect Import source file
Hi Experts, I hope all is well and safe. Would like to seek your assistance with regards to Anaplan Connect script source file. Noticed that when I run the Anaplan Connect script it keeps on getting the old source file in the import process instead of the new source file declared in the script. Please see attached file as…
Cross-workspace data link
Hi, need some explanation as what is "cross-workspace data link" which is eligible at enterprise level edition ? Tried a few search, but nothing relevant showed up. * Could you please enlight me and what use cases you believe this has the most value for you ?
Level 1 Model Building Exam - Model Buliding Activity 4
Hi, I'm trying to download "Employee Details By Role.text" data but it down loads in to the internet explorer. I have attached the screen shots. Can I please request some help on this. Regards, Nayani
Easily Integrate Data From Google BigQuery With Anaplan Connect
Users can leverage Anaplan Connect for bi-directional integrations with Google BigQuery. This free connector makes integrations between Anaplan models and Google BigQuery via Java Database Connectivity (JDBC) drivers that leverage the power of BigQuery's standard SQL. Users can easily pull any data from BigQuery—such as…
Duplicate item in the import file
In User storry 2.2 we need to update the territory with the accounts name, but each account should be map to a Single territory. At 4.4 we should update Territory to accounts with the file. But the file have one duplicate and generate the followint Warning.
Timestamp - Current Time (Formula)
Hi there, I realise this is not something new or possibly already somethere out there ... but wanted to raise it (possibly again) to show how important that would be. There are instances that multiple users are using the system. Sometimes there is a case that those same users use exactly the same processes/actions. Given…
How to upgrade from 1.3 Anaplan API to 2.0
Hello community, Could you please tell me how to upgrade from API version 1.3 to 2.0? Thank you
Level 1 Exam - Model Building Activity 4 importing data file Employee Details by Role.txt
Hi The text file Employees Details by Role.txt is not importing the data properly. As the columns are not in proper order. screen shot attached. Would appreciate some help. Regards Thiru
Filter with time as page selector
Hi, I am trying to create an import with user input and have time as pageselector. When I created a filter to import data with the rows having user input and time as current page it actually filters first and bring the data for all time periods. Now if I bring time period to row and apply filter it bring multiple year data…
Upload a file (internal error)
Hello, I try to upload a file in my model, with API via a windows script like below. I try to upload like the api use requirements, but I ave an internal error on the second step STEP 1 : upload a file as a single chunk CURL --user user@xxxx.fr:password --header "Content-Type:application/octet-stream" -X PUT -d…
Auto Order Lists and API Enhancements - Help!
Anyone know where I can get the instructions on 9/26 release notes to automatically reorder lists and what the API enhancements are? Looks like some game changer upgrades! https://community.anaplan.com/t5/Releases/What-s-New-September-26-2020/ba-p/85429 Tag: @Misbah @DavidSmith @rob_marshall @LipChean_Soh @ChrisAHeathcote
Need help in importing data into module
Hi I am trying to load data from .csv file into Module using import option. Data from one column 'PO Approved Date' is not getting loaded into the module.Please see the screen shots attached. Any help would be appreciated. Thanks Regards Prabakaran
NEW BUTTON I ADDED TO EXPORT THE GRID, DOES NOT ACCEPT THE FILTER SETTING
Hi guys. previously, my task was to add a new button to a dashboard, that include an export action. 1) now this is completed because of your help. 2) this new button exports all the data and this is problem 3) new button and included action does not accept the grid filter setting, and the export is always like everything…
Import Action issue
Hi Anaplanners, There is something I need an assistance. I have created an action to import the data, and the Module is multi-dimensioned. During the creation of the action one of the dimension "Match on Names or Codes" is disabled, which means by default we have to match it manually. Can anyone please let me know why the…
Text Encoding
Hi Anaplanners, Can you please guide me which Text Encoding should be used while import, when the data set have some data in Chinese Language. Thank you!!
Unable to upload Model history for Supply Chain Model after completing L2 MB Conclusion Exam
Hi Im unable to upload Model history for Supply Chain Model although Ive completed the Conclusion Exam. Is there anything missing/undone to be able to activate the link to upload the Model history file.
Level 1 - Importing Data into Product Details and Employee Details modules
I am hitting errors when importing data into both modules for product details and employee details. I am not sure if I am mapping it correctly or if I have created the modules / dimensions correctly in the first place. When I look at the exaple Model, my modules look different to the modules in the example model - I have…
Import Export Action Button
Hi All, I have a module with a time range(a customized time range created in Anaplan by the user) of 3 years(2018,2019,2020) where data is input for each month for the current year. We are providing an export/import button to the user on the dashboard to upload the data for the current year. But I am observing that on…
Anaplan Connect Install 1.4.4
I am installing Anaplan Connect for the first time. When I try to run the import script, I get the below error message. I do have the WorkspaceID in there. I also want to runt the script on a shared drive in Unix if possible. Can anyone help? Thank you. ======================================================================…
Access right for Import
Hi, End users do not have access right to import data to a module that they can edit. The module contain a selective access list. What can be the reason and how can I fix it? Thanks, Xin

Importing and Exporting Data

Discussion List