Importing and Exporting Data

Reduced number of items to map to
Hi, I am trying to map 30+ columns, similar to how one of my models is set up but in the new model I can only map 3 columns. The source data is the same for both. Does anyone know how to increase this? Thanks, Tom
7.2.1 Activity: Help needed
Hello, Having trouble with Activity 7.2.1, I keep getting this failure and I'm not understanding what's wrong. Please help, thank you. Below are screenshots of the failure and my mapping.
Action with multiple source models
Hi community, I have a page with 2 source models: Model A and Model B. I want to add an action card which runs a process from Model A. When I add the process to the action card, it automatically adds a process from Model B to the card. And the 2 processes don't have the same name. So, if the user selects Model B and runs…
need help for practice
Hi All I want to populate "text line item" which shows string between 1st and 2nd commas of the items in the module. How can i do it. which function should i use here Thank you & regards Yash
11.3.4 Actual and Forecast Values are the same
Hi there, My actual and forecast values are showing the same output. My forecast values should be different as seen in the example, but I can't figure out how to show the different output for the forecast values.
2.3.9.1 Import data into DAT03 Historic Volumes Module
Hello, I have been having difficulty completing the 2.3.9.1 activity. I utilized this forum to address my previous issues but I am still having trouble. The Historic Volumes aren't being populated. 9.2 and 9.3 seem to have populated appropriately. Please see the screenshots attached.
Lvl2 1.7.3.1
I am not able to import P3 SKU from the data hub saved view
Sales Planning Model: A2 List
Hi, I'm having trouble when trying to import into the Sales Planning Model: A2 List in the Sales Planning Model. I created the necessary System Module in the Data Hub in order to use to populate the A2 List. I also filtered the module so only the valid Account>Product combos show and saved as a view. I then imported this…
8.5.3 Activity: Import Data into Volume Inputs Module
Hi everyone, I'm getting this error message and I don't know what I'm doing wrong.
Failing to import Data In Region Flat -- Model Building activity Level 2 Sprint 1
Region Flat List in Tree View: Region Flat List in Grid View I'm getting this error while importing the data:
2.3.9.1 Import data into DAT03 "Expected week number in date/period"
Hi Anaplan fam! Since I have read almost every post about importing into DAT03 and checked the instructions many times, it seems I have exhausted all possible options. The only way I can import from Datahub is by using Match names in the Time tab. When I add line item "Offset Volumes for 1st Forecast Year", the value is…
Custom scripting line item calculations
I would love a way to be able to use my custom python scripts and the vast amount of Python libraries on line items in a module, rather than use the Anaplan formulas out of the box. It would save time on export/import data to the Anaplan model. I'm assuming the formulas that are used now are some form of Java or C++? Maybe…
Level 2 - Sprint: Activity import Data into DAT03 Historic Volumes Module
Hi guys, I've been trying to inport the 'Historic volume.csv' to the DAT03 Historic Volume Module for the past 2 hours. I already watched all the videos about importing data to module, etc. But I keep receiving this error, "invalid line item identifier", and I don't know what else I can try. Could someone give me a hint?…
Error in key for this row; refers to invalid list item
Hi everyone, " Error in key for this row; refers to invalid list item : Headcount " I get the above error when I tried to import data into Numbered List, which is uniquely identified by combination of properties. Actually, the list item which is formatted by some "xyz" list has list item ' Headcount' Even after that, I am…
Get metadata for import action returns the target line items instead of File headers
Hello everyone, We were looking to query the mappings of a file that was being uploaded in the model through the endpoint of get metadata for import action. the link Anaplan Integration API V2 Guide and Reference · Apiary suggests the below statement: " You can use the API to obtain metadata for an import definition for…
Recent Data Export Format Change
Hello, The data exported to excel from a module has recently had formatting changes. As of today, when I export a module from a dashboard it appears to no longer have formating. I think this could possibly be related to the maintenance performed over the weekend (05/14/22). Has anyone else noticed this? Will the formatting…
Get Import ID from Anaplan
Does anyone have a guide or can provide assistance on how to get the API ID from Anaplan from a model?
Not getting Task Id while running API call(Export Action)
Hi all, I am using python for integration. After authentication part, I got Export Id through API call. Now using that Export Id for getting Task Id with API Post Method : headers = {'Authorization': 'AnaplanAuthToken %s' % token, 'Content-Type': 'application/json'} data = json.dumps({'localName': "en_US"}) response =…
Clear Large Amount of Data
Good Afternoon, I hope someone can help, so far it has taken me over 2 hours to clear out a large amount of data in a module (more than 500000 cells). Is there any quick way of doing it? I still got 7 more to clear data from. For some reason when importing data in Anaplan, it did not clear out all data before the import,…
SYS06 Sprint 1 L2 Mapping Problem
Please help , I am not getting the desired result.
Review SYS05 Region Details Module
I am not able to connect SYS05 , SYS06 , SYS07. Please guide Please resolve
【Action】Successful message
Hi, I tried to run Action in APP page. But I couldn't check the successful message. I want to check the number of import data. (I can check failure log.) Is Anaplan maintenance team doing any maintenance?
Execute Snap Logic jobs from Anaplan
Hi, We are using Snap Logic as our integration tool from GCP to Anaplan. Want to check if there a way to execute a Snap Logic job from Anaplan? Also, if your integration tool in not Snap Logic, Did you invoke or trigger a job in the integration platform from Anaplan? -- Selva.
Importing into list from subsidiary view
Hello, I am trying to import data into list by creating an saved view in a module. That module has a line item of subsidiary view. That line item is not getting mapped to list subset. Explanation: I have 3 lists L1, L2, L3 (all are hierarchy lists) One list created for requirement to use it as dependent drop down - LD I…
Level 2 - 1.7.3.2 Import into SYS08 SKU Details module - Help please
Hi I need some help here please: I think I've imported data in the Supply Chain Model P3 SKU correctly, however when I update the model SYS08 it is blank. I attach screen shots of my : P3 SKU SYS08 Blue Print Help much appreciated. Thanks, Chris.
DATA02_LEVEL 1 model import issue
Hello Community, I am trying to import SKU.Volumes data into the DATA02 module However, I am facing issues while importing. Below is the step 1 STEP 2 STEP 3 STEP 4 STEP 5 FINAL OUTPUT Can someone please guide me? Thank you in advance
Import Lineitem with subset List
Hi, I want to import Lineitem with subset List. I have this below table. We are making production planning by weekly. Week has subset List, which is Lastest week. I want to import Production Planning only Latest week and its amount > 0. I tried to use filter, but it depends on particular week List. How can I import…
Import and Export Function Process
Hello, I am new to the anaplan software and would like to know the step by step process for adding a Export and Import button on a dashboard. Also I will need to add an Export filter so that I can select what department, version and Time I would like to see when the data is exported. Thank you.
Enhancements to API
Would like to see additional enhancements to the API, things like retrieving line item blueprints, list/module editing, list properties, etc. This would enable customers to control their Anaplan environments with various automations.
Custom return code for API / Anaplan Connect
It would be nice to be able sending custom return codes/messages to the API / Anaplan Connect. This will help us in be more proactively in case of errors. Think about a validation dashboard, which check data consistency. It could be that after a new data feed some functional data errors are flagged up at this dashboard…

Importing and Exporting Data

Discussion List