Importing and Exporting Data

4.6.5
It gives an error message when importing saying another row has already been imported with this key and Invalid name
Synchronize filters across tables in Excel add-in
Add ability to synchronize filters across tables in Excel add-in. Working with the Excel add-in and extracting data from different modules, some of the filters across the different extracts overlap. A good example hereof is forecast cycle or specific versions. Currently, we have to change the forecast cycle in each sheet…
Show/hide data labels for end users on a chart card
It could be great if end users can have the choice to show/hide data labels on a chart cards, or as an option for export. we think it's more ergonomic to hide them on a board and display the tooltips. However, this poses a problem when a user wants to export the chart card because he does not have this option.
Excel Add In 3.2 Last Refresh cell
In Excel Addin 3.2, the 'Last Refresh' cell has been moved, adding a new row before the data compared to 3.0. There should be an option to keep the old format. This will allow users to upgrade from 3.0 to 3.2 where they have many formulas referencing data in a row which would be moved.
8.5.2
I am having an error with importing to rev1. Check photos
Custom Time Mapping
Hi Community, If the client has a custom time dimension file how would you go about mapping this file into Anaplan and then dynamically sum the sales by region by account by product by month? Find example data set below. I would normally do a custom time mapping to map from the clients time to Anaplan inherent time period…
Activity 11.3.2 Import data into P&L Actual & Budget - not working
Hi, I have been trying to import data into the DATA01 P&L Actual & Budget Module with no success. I have also checked the Example model and noted that there is no data in this module - I am not sure why? Please see my mapping screenshots Please help as I am stuck
7.2.3 mapping errors
I am having trouble mapping but can not figure out what I am doing wrong. I manually put in the dates for start and leave in the format YYYYMMDD as well. Can anyone help me get past this point without errors? Thank you.
Level 1 Model Building Lesson 10 - Import Data
Hello, I encountered a mapping issue when I tried to import the Employee drivers into the model. The source data has no time period but the mapping requires a time period. How do I fix this? Appreciate your help! Many Thanks Rachael
"error parsing key for this row no values" error while Importing a list from a list in another model
Hi I do not have a module setup for an import of the list from another list from other model. and I get this error 'error parsing key for this row no values'. How can I get rid of this error. Thanks in advance!
Data import error in Level1 training
Hi. I receive the below error when uploading the Employment Details csv file. It doesn't refer to a particular part of the mapping, so I have a hard time figuring out where to find the issue. My mapping setting is as follows. Can you please help?
API Python Workspace and Model IDs
Hello, I have successfully setup my Python environment. I did have a question around a specific requirement. https://community.anaplan.com/t5/Best-Practices/Using-Python-3-with-the-Anaplan-API/ta-p/33150 From the above link, I have tried the “get models”, “get modelinfo”, and “getworkspaces” Python scripts. What I am…
Importing User Data For Selective Access with multiple Items
Hello, I'm trying to design a process to update my user access by importing user data from a module. It works for the most part, except when one user needs access to multiple items in a selective access list. I've tried importing the list items as "Property 1, Property 2", but I get an error "Item not located in Property…
1.5.6.2 Import Data into Historic Volumes Module
Am i right to assume the formatting of the volumn line item is incorrect?
Unsupported Media Type : POSTMAN
Hi, I am trying to upload a ".csv" file into Anaplan using Postman. Below is the API used. PUT https://api.anaplan.com/2/0/workspaces/((workspace_id}}/models/{{model_id}}/files/{{file_id}} But it is throwing an error of "Unsupported Media Type". Below images(also uploaded) are the configurations used. Can someone help me…
Anaplan Power BI Connector
Hi I am using the Anaplan Connector to load data into my Power BI Desktop. Is there a way to do the same to Power BI cloud version? If so what are the steps required?
Field Separator for Export File from View
Is it possible to export data from AnaPlan using a pipe separator for columns. I can't find where this can be changed from a comma. Thanks
Retrieve Model ID and Workspace ID via API then load as CSV?
Hello All, I was wondering if it is possible to retrieve Workspace ID and Model IDs of any given Model which then can be pulled into a CSV file? Then imported into my current model? What I am looking for is something like this: 1) Retreive Current Model Details via API, extract into CSV. *Looking for ways to grab either:…
Dynamic exports - Export actions linked to saved view with filters or user selection
As a model builder I would like to set-up exports that are connected to saved views and that synchronize with a dashboard to provide end-users with dynamic and efficient exports and ensure sustainable integration with other systems. An example: A module is published to dashboard with month as headers. I want an export…
SYS08 Employee Details
How do I resolve the greyed out items? Please help.
Error while importing data into SYS08 Employee Details module
Error while importing data into SYS08 Employee Details module
how to import locations.csv in level 1 model building
how to import locations.csv in level 1 model building
Mapping the products.csv file in level 1 training
Hi, I created a hierarchy of product family and products. I need help with mapping the products.csv file. Please find the screenshots attached.
Regarding Email Notification via Anaplan Connect Script .
Dear Expert , Hope you are doing great! I am looking for your kind advice on Subjected Matter . I am working for Anaplan Connect Script for Import ., where we need to trigger mail to support team in case of any error while importing to Anaplan model . Could you please help me with the details and sample script to write and…
how can I automate or schedule a process with in Anaplan
Hi, I am looking for a functionality about how can I automate or schedule a process with in Anaplan, which transfers data from one model to another model with out clicking manually each time on that process in dashboard?.. I appreciate your help on it. Thanks! Suman
Got struck in 8.5.3 import volume file
While mapping i am a bit confused how to map time dimension to the source and line item mapping .please help me out on . I am attaching screen shot of what i mapped in the import
New UX and blocking actions
Hi all, I'm starting to implement the new UX to replace some of our existing dashboards and I would like to know if users working on a page are affected by blocking actions (import/export) as it happens in the model. This is one of our biggest challenge (ie: reduce blocking actions) to increase the anaplan adoption in our…
Importing List Formatted Line Items into List Formatted Line Items (Numbered List)
Hi, I have been getting import errors when trying to import a line item formatted as a numbered list into a different line item formatted as the same numbered list. We import directly from our source into a list formatted line item and the only workaround I've been able to come up with is to make a new line item, make the…
Model Builder 7.2.1 Import Data into Product Details Module
Hi All I have spent considerable amount of time trying to Solve this.. Can Someone please help.
One question regarding level 1 - Activity 7.2.3 : Import Data into Employee Details Module
Hello there, I meet one issue when I import data into employee details module for level 1, activity 7.2.3. The result can be seen from screenshot (refer to Result.PNG). Here we can see that Name, Country, Start Date and Leave date columns were not imported at all. The imported report can be seen from screenshot (Import…

Importing and Exporting Data

Discussion List