Importing and Exporting Data

Regex Formula
It would be very helpful to include a regex style formula in Anaplan so we can pre-process text fields ahead of an integration, or even help to cleanse messy inbound text. Currently if we want to remove special characters, or parse strings into cleaner formats we have to specify one by one the characters we wish to remove…
Exporting Saved View from Tabular Single Column
Hi, I'm trying to export a module saved view for tabular single columns, but the export includes every line item. However, when I check "current line item" it doesn't capture what's present in the saved view. Has anyone encountered this and has a solution?
Importing same data into two versions - best approach
Hi, I need to import the same data into two versions (there are more than 2 versions, but only 2 are applicable for this requirement). I could have two independent import functions to import the data twice, once into the first version and another time into the second version but this is a slower process for the user.…
Why is my import not working??
Hi everyone, I am trying to run an import and it is not working. Or rather, Anaplan tells me it worked wonderfully but it's actually ignoring the data. And I really can't figure why… I've used a csv file, I've mapped the dates correctly, but it is somehow ignoring the data. Any help welcome, please! Flavie.
Add message Import csv file into module and examples in Import learning section
Recently, we noted Anaplan import process delete / zero out more records than source csv file, and learned it's related to Clear target prior to import which was ticked although at same time " Matched item in source" for all non-time dimensions and "Matched items only" for Time Dimension. What happened? - system import…
3.5.4.1 Level 2 Sprint 3 Supplied By
There is no supplied by in the original data imported into the original models.
Populating list subset based on a Boolean from a specific version of a module
All, I need to update my hierarchical list subset from a module with versions. I have a module dimensioned with my list and a saved view in forecast version with a Boolean formatted line item (already populated and true for several items) based on which I need to update my list subset using action but I couldn't find my…
2.3.9.3 Update Historic Volumes for Baseline Forecast
I am having trouble adding a line item as my model has exceeded size. Here is what I am seeing on my screen.
Application of Filter Condition on Tabular Multiple Column Export
Hi Team, We see a challenge in not getting the Cost Center dimension when filtered to the saved view, it is not getting exported as per the Named Saved views instead we get all the Cost centers as default to the module. This feature is required for us to have it in the Tabular Multiple Column Export for the Integration…
L2 Sprint 2 2.3.9.1 Import data into DAT03 Historic Volumes module
H All, What happens in this case. I already pulled DATA from DATA HUB model in to Supply chain model DAT03 Historic Volumes module manually. What happens if I run the process 9 9.1 Import Historic Volumes9.2 Import Opening Stock9.3 Import Shipping Metrics Will I receive any errors in DATA in supply chain. Or The earlier…
Import Data Sources / Imports
When in the actions area, there are a couple of different tabs and I've performed some changes previously in terms of updating source models, etc when we have archived old ones, however I would appreciate guidance when looking between Import data sources and Import tabs - I've added elements to Import Data Sources, how do…
Bulk Copy On Items Within Modules and Bulk Copy Actions On Dashboards
Hi Anaplan, Currently the ability to 'Bulk Copy' of data only exists a list items data to be copied to another list item across the entire model. My idea is to have the ability to 'Bulk Copy' but only within a module from a list item to another list item within that model. Meaning that the data being copied only happens…
How to set actions between PROD models (via DEV models)
Hello, I have a question regarding interactions between models and ALM. I have 4 models: Demand DEV, Demand PROD, Supply DEV and Supply PROD, I need to establish a link between the Demand PROD and Supply PROD models. My question is how shall I set the action in the Supply DEV that will then be deployed in the Supply PROD…
"Line Item identifier(s) were not mapped and ignored" during data import
Hello! I am running an import from saved view into a model and I am facing this notification - it is not an error, but at the same time nothing gets imported because of it. Weird thing that this line item was indeed mapped and it was mapped automatically. Any idea what could be wrong here? Thank you!
Importing file that has one column whose first row is empty
Hello everyone, I'm struggling with the import of a file: there is one column that has the first row empty, therefore the file won't upload properly. I can't remove the column from the combination of properties because I need it to generate the unique key. The only solution I've found so far is importing the file with…
Import action not getting filtered
Hi, I'm working on an approval process that should work as follows: Global team take choose if SKUs in my product Hierarchy should be Kept or Disco. Module: OUT000_SKU Planning with dimension: SKU 9 Digit. Global team click a action to send data to Regions: Module used: INP000_SKU Planning Global Approvals; dimension Brand…
Community Perspective: Using OAUTH2 to develop custom Anaplan connector for Azure
Introduction The release of OAUTH2 authentication for the Anaplan API opens the door to developing more native connectors across all the major cloud platforms. In this article, I explain how you can configure a custom connector on Azure for use in Logic Apps. The benefit of a custom connector is that you can expose all the…
HTTP Error 422
I had an import which loads salesforce data into Anaplan using the RestAPI fail today with the 422 error code below: { "status": { "code": 422, "message": "Unprocessable Entity" }, "path": "/2/0/workspaces/8a81b08e5cdbe172015cfb45189104ca/models/43955D63B8BD4E3FA3EA72776BE2CC41/files/113000000080", "timestamp":…
Automate/Improve Resetting Next Item Index for Lists
Problem: There is no automated or pre-emptive way to reset the “Next item index” on a list without first clearing the list. Issues Caused: When using a data hub with a large data set that is refreshed daily, we regularly exhaust the item index. This causes the import process to fail and results in refreshing of all…
2.3.8.2 Import into DEM01 Module
Hi everyone, I am trying to do the import into de DEM01 Module, but I keep getting this error. I've seen some similar questions here at the Community but can't really figure it out what everybody did to correct it. I am attaching some screenshots so you can see what I am doing. I really don't know what else I can do. Any…
Ability to Add Data Write Action to Existing Process
1. It would be really a game changer if we are able to add Data Write Actions to the existing processes, It would not only scale up the usage of the Data Write Action but also would save a lot of time and effort and would save us from creating multiple saved views and actions. 2. Currently, Data Write actions can only…
Import clearing out data even if list item is not mapped but time is mapped?
During a file import or module to module import, is it possible that even though the list item is unmapped or is not present in the file but since the time period matches, the other items are updated regardless of not being mapped?
Bulk API Integration
Hi All, If I upload a file to Anaplan server using Bulk API, can a user manually run the import action from actions page in Anaplan to import the uploaded file into the Anaplan Model, are there any limitations or pre-requisite? For example I understand if I am uploading the file using basic authentication with a user ID…
Building a Chat Bot - Part 3: Interacting with Anaplan from Slack
Since you’ve reached this point, I believe it is useful to remind you what we achieved so far. In both Part 1 for AWS and Part 1 for GCP, we used both platforms in order to host a function that can generate a new token every time that you need one. This could be very helpful in any integration scenario that you can come up…
Problem by selecting Zone with my Export button on UX page
Hello, I have created a UX page, and I would like to add an export button in it. The export button should export : Fixed unit of measure (here PAL or TO) : I would like 1 button for PAL and another one for TO Flexible Country Zone : Depending of what it's filtered by the user I succeed to do the first point, however I…
Question for Level 1 Activity 4.8.2: Import Data into E2 Employees# List
Hello there, I have one question regarding the activity 4.8.2 in level 1 where I imported the data successfully but employees of departments all shows up like numbers (please refer to why number.PNG). As you can see from the screenshots enclosed, the mapping was correctly done before importing (refer to Import set up.PNG)…
Management Reporting slides download for multiple page selector at once
Currently we can download slides for each page selector by one by one .It would be great if we can download one slide for all item in page selectors at one click . Scenario - In page selector , we have 100 employees Data in slide changes according to page selector (using dynamic text ) .Customer wants to export slide for…
Export data from Anaplan to SQL server through Anaplan Connect script
Hi Anaplan Connect experts, I need some help. I know how to write a Anaplan script to load data from SQL Server to Anaplan module. I need sample script from you, how to export data from Anaplan to SQL server. Could you share me your sample script please? Thank you & regards, Anil
Ability to copy/paste values incl. hidden decimals from Excel
When copy/pasting values from an Excel table to Anaplan, it only includes the decimals shown in Excel. E.g. if the value 0.5499 is in Excel but the cell in Excel is set to only show one decimal place, the value displayed will be 0.5. When copy/pasting to Anaplan, 0.5 will be used and not the full 0.5499. This issue can of…
Is it possible to get an Import's affected/target List via the API?
I have some c# code that uses the Anaplan v2 API. One thing it does is perform various imports based on conditions. I would like to know which lists are affected by each import, but as far as I can tell it's not possible to get that part of metadata about an import.

Importing and Exporting Data

Discussion List