Importing and Exporting Data

Remove Line Item Mapping when Item is Removed from Import Data Source
Within the Line Items tab of the import dialogue, please can line item sources be removed when these are removed from the import data source. Take the below as an example: If I were to remove Revenue from the import data source, the Revenue line item source would still appear on the left to be mapped to a line item target.…
Level 1 Model Building Exam - Model Building Activity 4
Hi, can anyone help me to figure out what's causing the error for importing the data into EMPO3 Employee Drivers by Role and Employee+Drivers+by+Role module? 1.1) If I load the original downloaded file of "Role List", it's showing the following error. 1.2) So I deleted the Parent column to load it as below. 2.1) After the…
Update Formula's Automatically
Hi All, Is there anyway by which formula's can be directly imported in a module for a line item? The blueprint view import option does allow to import a new line with a parent and a code from a file or any other module but is there anyway that the formula's also get updated automatically from another module or a csv file?…
3.5.4.1 Import Data into Distribution Center Details
Hello, I cannot get this to map properly no matter what I try. Importing into SYS07. Any pointers? Screenshots attached
Dynamic cell access for workspace admins
Hello Community , As a workspace admin , in a module for a line item , even on read access , it is noted that though values cannot be inputted manually , if we ran an action which loads in the line item , it is writing and ignoring the DCA example - source module target module - dca enabled , Running an import which loads…
File Download API using name instead of ID
Hi Everyone, I have an Anaplan ←→Azure integration pipeline where Azure Data Factory pulls some data using an export action via Anaplan APIs. We were using the name instead of the id when we run the download API. However, today observed that it no longer works. Getting a 404 Not Found. { "status": { "code": 404,…
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…
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…

Importing and Exporting Data

Discussion List