Importing and Exporting Data

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…
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…
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
add export qlik extract of an existing report to a dashboard
hello. anybody to help how to create a Qlik extract for an existing report and add this function to a dashboard? thank you.
Text to Date conversion
Hi All, My import has dates in following format: "01-sep-20" and I want to convert it to monthly date "Sep 20". I was trying combinations of PERIOD, DATE, VALUE: PERIOD(DATE(VALUE(LEFT('DATE (txt)', 2), MID('DATE (txt)', 4, 3), VALUE(RIGHT('DATE (txt)', 2)) But it seems that it won't work because it doesn't recognize…
Log for load
Hi Anaplanners, Is there a way by which I can get log history of records, when data is loaded through Integration. Ideally, the history log in Anaplan can just let us know for the number of records which gets loaded, not the one which were ignored. Is there a way to find that through Anaplan? Ideally if we manually load a…
add a button to a board and assign an action to it
hello everybody. I am a new here. was assigned to a relatively easy task, but do not know how to solve it. to describe the case: 1) there is a working dashboard. 2) for example it has a grid and an extract button. 3) now my task is to add another extract button, to export what in the grid into a .txt file, so the managers…

Upcoming Events

Community Challenge Recap: Annual rollover best practices
In this ACE Spotlight event, we will cover the most effective techniques for making your annual rollovers seamless and repeatable, based on the solutions from our latest Community Q&A Challenge.
ACE: Anaplan Workflow expanded
Join us for an upcoming Anaplan Community Experiences session focused on continuing your learning with Anaplan Workflow. In this event, we will explore best practices for designing and implementing workflow processes that support structured planning, approvals, and collaboration across teams. The session will provide…
Quarterly Platform Release Webinar
Registration will open soon for this event. Join us for our Quarterly Platform Release webinar where we highlight the latest enhancements and updates to the Anaplan platform. In this session, members of the Anaplan team will walk through key capabilities released this quarter, explain how they support better planning and…
ACE: Anaplan Workflow
Registration and events details will release closer to the event date. Join us for the third session in our Workflow Expanded series as part of the Anaplan Community Experience program. This session continues our exploration of Workflow best practices and builds on the lessons from the earlier events in the series. We will…
ACE: Anaplan Workflow
Registration and events details will release closer to the event date. Join us for the fourth session in our Workflow Expanded series as part of the Anaplan Community Experience program. In this session, we continue building on the concepts and best practices discussed throughout the series, with a focus on helping model…

Importing and Exporting Data

Discussion List