Importing and Exporting Data

Data Import From Module 1 to Module 2
Hi Experts, I have a question. I have a module, lets say, Module 1, in which I have included 2 lists, Time and Version. Through this module, user enters data. I have another module, let's say, Module 2, where I have same 2 lists and time, but I do not have version in the second module. I want to copy data from the Module 1…
Level 2 Sprint 2 Model Calendar question, data not showing
Hi everyone, I followed sprint 2 step by step until I found out my data was not showing in DEM03, so I was searching for recommendations in the community and tried editing my model calendar. However, I think I messed up because, after a few changes, even my DEM01, DEM02, and DAT03 aren't showing data anymore. I tried…
Things to consider when building a robust import action
Import actions are foundational elements of an Anaplan model. Import actions can be scheduled via integration or can be called on demand via dashboards within an Anaplan model. Imports could happen from different sources such as lists, modules, saved views, and files (CSV, TXT). Import primarily import data into target…
8.5.3 Volumes Data Import REV02
Hi, I'm having a problem with the Time tab when importing the csv file. Is there anything in addition anyone would like me to provide to get a better idea of the problem?
Transactional APIs documentation
I'm so excited about Transactional APIs. But I can't find any documentation or technical description of how to use Transactional APIs. It would be nice to have something like that https://anaplanbulkapi20.docs.apiary.io/#
NUX Export Labels
In the current UX, you can include property labels when exporting. I would like this feature to be available in NUX as well.
Copy data from 1 Year to Next 2 Years
Hi Experts, I have been trying to test some scenarios in Anaplan. One scenario is I have to pick Actuals from Last Year for all periods and copy them to all periods to Current Year and Next Year For instance Current Year is 2020 Last Year is 2019 Next Year is 2021 Data of all periods from 2019 must be copied to all periods…
Ability to automate exports to PDF
As a model builder I want specific export to PDF to be saved in the list of exports so that a process can be created to group them together and run specific export to PDFs from dashboards in one go. I will know this is successful when I will be able to create a process and group a series of PDF exports together, which can…
Importing With Varied Dimensions
Have you ever faced a scenario where you wanted to import the data from one module to another with a different set of dimensions, and you were not able to successfully achieve it? Usually, such type of data movement can easily be achieved through formulae, but in some cases, writing formula might not be the solution—for…
Data Import
Hey I am having trouble with level 1 importing employee data in syso8 it says the following: Import into SYS08 Employee Details module failed: The column headers in the file you are attempting to import do not match the import definition.1 Line Item identifier(s) ("Active?") were not mapped and…
Cloudworks Available Services
Hi, I'm thrilled about Cloudworks and wanted to test it. It seems from the documentation that it should be possible to connect to third party systems, but when creating a new connection the only service available is S3. I wanted to perform a test on Azure. Is it possible and am I missing something ? Thanks for your help !
Integration between AWS S3 and Anaplan Using Rest API
Hello Team, I have a scenario where I need to integrate AWS S3 and Anaplan as for Imports and Exports. There is no integration tool so I have to use Rest API. If it's a system, I can store downloaded file but S3 being a cloud system, I have trouble placing Anaplan Rest API to make the connection with Anaplan. Thanks,
File Import Issue due to Control Panel Local Language Setting
Some users in Europe are facing issues importing offline excel file into Anaplan. Currently we have a workaround for this issue. If user changes his Format setting in Region and Language to “English”, then the upload is successful to Anaplan. Users have to change their local language setting every time they need to upload…
Integration between AWS S3 and Anaplan using Anaplan Connect
Hello, I have a scenario where I need to integrate AWS S3 and Anaplan as for Imports and Exports. There is no integration tool so I have to use Anaplan Connect. If it's a system, I can store downloaded Anaplan Connect folder but S3 being a cloud system, I have trouble placing Anaplan connect folder to make the connection…
Paste more than 10,000 cells
The limit of only being able to paste 10,000 cells is too small. Ideally it would be 100,000 to cater for larger data sets
Latest Article: Importing with Varied Dimensions
Please read out my latest article on Imports featured under best practices. https://community.anaplan.com/t5/Best-Practices/Importing-With-Varied-Dimensions/ta-p/89698 Misbah
Batch printing, exporting, emailing of NUX dashboards and worksheets
Description: As an Anaplan user, I would like to be able to print, export, or email Dashboards and/or Worksheets in the New UX based on a selection of list items relevant to the the Board/Worksheet. This process should be able to be scheduled (e.g. daily, weekly, monthy at a set time) or run on-demand by the user. The user…
Import Into user settings
Hi, I have one question related to import to user settings. I have created one dashboard for managing user access for end users, i have created one process to import changes into user settings. While testing i figured out i am not able to access process as i don't have workspace admin access. Is it compulsory to have…
Download Data file: Countries.csv
Anyone having a problem importing this above date file? I click on the download file but is not showing. Please advise, need to complete 4.6.4 Activity: Import Data Thanks. BA
Level 2 - Sprint 2 - 2.3.9.1 Import DAT03 Historic Volumes module
Hi I have got this error message however I tried to do it. I am not sure where I am going wrong. I followed the Anaplan community replies thread but am unable to follow. Obviously this is why I am still getting the error message. Some help will be greatly appreciated. I have attached screen shots of the DATA HUB Model…
Model 1 - Importing Data Error
I'm stuck because I keep getting the same error. I've downloaded and saved the spreadsheet several ways, but nothings working. Please help - I'm Stuck!!!
Export multiple modules into unique file
As a Model Builder I want to create a Process to trigger multiple Export actions at once, each export linked to a different module. However, the Process generates as many files (csv, Excel, txt,...) as the number of Export Actions within the Process. It would be better if the Process could generate a single file (CSV,…
Publishing of the dropdown option
Hi, I have two different hierarchy of lists. Both have n number of hierarchy. List one has display name as Priya and the other list is referred as Priya | Anaplan, Priya | Java. The display name for second list is the combination of first list and course. Here, Priya | Anaplan, Priya | Java have same Priya. As first list…
Unknown Error while Importing a Subset
Hi! There is a very simple import where the end-user checks a boolean for the items they want to keep in a subset and then runs an action that takes the boolean value to the list and updates the subset. Clean and straight. However, user is not getting a peculiar error. Can you help me understand the reason behind this…
L2 - Sprint 1 DAT03 Historic Volume import
Hi, I'm trying to import the above but keep getting the attached error message. Can I please get help in identifying the error. Regards, Nayani
Create new List Item from Module
Hi all, I have a hierarchical list of Customers where the bottom two levels are Customer and Branch. I've got a separate hierarchy for products which as its bottom level has SKU. Due to space considerations our Anaplan consultant created a level below Branch for SKU, where items are only created where there is data. We've…
Importing data from big query
We have a problem to build and import the data from GCP bigquery. It need to be automated. I will appreciate the approach and if possible some sample code (written in python etc) to get the data from bigquery into anaplan datahub
Labeling import prompt for end users
With the current import process, when users are prompted for files, it simply says 'Upload a file for input into [insert module name(s)]'. It would be helpful if we could associate which file is used for which action as the end user selects the file. Example: uploading 2 files into the same module, with different…
Import Data into P1 Product Family List
Hello! I am having issues importing data from the product+family csv file. When I run the import, the model says the import was successful. However, when I check the Tree View, no new data shows up under "All Products". I did not have any issues with importing all the geographical data so I'm not sure why the product…
Data Tags as a comment feature for developers
Hi team, As a Model Builder and BAU Support Team Specialist, I am interested in documenting enhancements in our models. Using only the Notes feature as a commenting tool, it is getting really hard to track them all after a couple of years of the model being rolled out. At some level of complexity of the model, it is…

Upcoming Events

Building Valuable Anaplan Workflows
Join us as Anaplan experts explore how organizations are using Anaplan Workflow to streamline business processes, improve collaboration, and drive greater efficiency across their connected planning ecosystem. Designed for model builders, solution architects, COE leaders, workspace administrators, and business process…
Driving Security, Compliance, and Governance with the Anaplan Audit Log
Join Anaplan experts for a practical deep dive into the Anaplan Audit Log and learn how organizations are using it to maintain robust security and compliance measures. Designed for workspace administrators, security and compliance teams, IT leads, and other hands-on Anaplan users looking to better understand how to track…
Anaplan's Quarterly Customer Platform Release Webinar
Anaplan's next quarterly platform release webinar will be held July 29 at 8:00 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience! Our expert-led session will equip you with live demonstrations to help you get the most out of new features and…
Building Smarter Models with Polaris and Planual
Join us as Anaplan experts share practical strategies for building smarter, more scalable models using Polaris and Planual best practices. During this session, attendees will learn how to: Learn how to align your model development with recommended Polaris and Planual best practices. See how to improve system performance…
ACE: Anaplan Workflow
Registration and events details will release closer to the event date. Join us for the fourth session in our Workflow Expanded series as part of the Anaplan Community Experience program. In this session, we continue building on the concepts and best practices discussed throughout the series, with a focus on helping model…

Importing and Exporting Data

Discussion List