Importing and Exporting Data

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…
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.
2.3.10 Activity: Create Demand Forecast_unable to see FY21 data
Hi, As per process I have created DEM03 Demand Forecast Module. It shows FY20 data but FY21 data is missing in the data. Could anyone please assist me If I am wrong anywhere. Please refer below screenshots. required output- I got below output -
Volumes for DATA02 SKU
Hi team, I have mapped the data SKU.csv as per below screenshot. And under DATA02 sku line items mapped volumes However, only Jan 2019 and Jan 2020 data is visible in the sheet attached jpg, Please guide me with steps to rectify so that volumes are visible under each month.
Turn off export functionality from cards in NUX
Hi, Is there a possibility to turn off the export functionality in the NUX, like there was in the classic dashboard? It is crucial for my use case that the end user cannot export the grids from the cards to excel for example. Thanks!
Optimizer: process incl. optimizer action with import on timeout should continue in case of timeout
For optimizer actions, there is the possibility in the action setup to enable "Import on timeout" to fetch back the results from Gurobi processing when the specified timeout is reached but the desired MIPGap is not achieved yet. If the optimizer action is embedded within a process, the process is shown as failed when this…
level2 - Create Inventory Ordering Saved View and Export- export setting
I am trying to do this activity: This is my export view: I used Tabular multiple column export, and got this result: which is differ from expected one: Which export setting needs? Regards Roya
Importing data but get different results
Hello community, I'm getting an issue while importing data with a csv, below i've attached data i'm trying to import but suddenly i get this kind of results which does not correspond to the data i supposed to get instead of getting 58.88 in anaplan ,i'm getting 5,887728739E9 even if i have set the format to 2 decimals.…
7.2.3 Activity: Import Data into Employee Details Module
Hi everyone, I'm a newbie to Anaplan. I have checked and tried every suggestion in this forum regarding this problem. Kindly help me out. Attached are the screenshots of everything I have done. Any suggestion would be appreciated. Currently stuck. Thanks
Run Process 9 Import Data from the Hub
Hi Team, While I'm Running the process I'm getting error. Please help me to run the process sucessfuly.
8.5.2 Activity: Import Data into Price Book Module issue?
Hi everybody. I import the Pricebook.csv file to REV01 Price Book module. Everything seems in order until the importing process is completed. As you see on the screenshots after importing the file the prices don't represent the correct value as in the .csv file. Where have I done wrong?
7.2.1 Activity: Import Data into Product Details Module - Invalid line item identifier
Hi, For L1 Model Building activity 7.2.1, I am having some issues importing the data file for SYS06 Product Details module. I am getting the following error "Invalid line item identifier" when importing the file Below my mapping selection Doe Does anybody know what the issue might be? Thank you
L1MB - 7.2.1 Activity
It seems that there is "Product" data but I cannot see data in Column SIZE. It is not allowing me to import it again. Any suggestions?
Ability to auto-name PDF based on context when exporting from Management Reporting
When exporting a PDF - the name is always the name of the page as it appears in the app. It would be good if you could configure this so that it recognises the context of what you were exporting, but could supplement this with text. E.g. if you were exporting a board pack, you could select the context of "Europe" and…
2.3.9.1 Import data P3 SKU
I am having a hard time importing the data from the DAT03 Historic Volumes module, Export saved view. Everything else seems to be mapped correctly, but the P3 SKU is not. Do I need to change the target item to display the SKU? Thank you!

Importing and Exporting Data

Discussion List