Importing and Exporting Data

Import Action Categories and Separators
The import action management section often becomes messy because ALL import actions are saved. Would love the ability to create sections and separators, to better organize the import actions I intend to repeat. The following example was created from dummy imports, but it would be great if this feature were built in. I…
Unable to Import to the Same Module Using Saved View
Hello, I am having this difficulty since last night, I can't figure out how to address this issue. If anyone has encountered this issue before, what did you do to solve this? Situation: 1. I have created saved views inside the same module. I'm using saved views to import to the very same module. 2. The module has a custom…
Level1 Training 8.5.3 Activity: Import Data into Volume Inputs Module
How can I set Mapping tab? Is it correct below? Souce column header →Time Location Code →G3 Location Product Code →Products Fixed Items →Volume inputs line items
Add-Ins - Quickly Edit/Amend connections
As a model builder/user I would like to be able to quickly amend my connections so that they can easily be re-pointed to different Workspaces and Models. I will know that this is successful when I will be able to quickly change my connections and re-point to different workspace and models, perhaps with a functionality…
time mapping while importing the exported module
Hi all, I am trying to import data using the export file of the module which has weekly time scale. Every other dimension mapping is ok instead of the time mapping as the exported file has week as time dimension but the target has format of ddmmyyyy to ddmmyyyy. I am attaching the screenshot of the exported file and the…
Local settings for .csv imports - Booleans
Hello, I faced a problem when importing boolean values to anaplan as part of csv file. Our company uses localized version of MS Excel, which when saving a file containing boolean values to text/csv, keeps them not as TRUE or FALSE, but as local equivalents ИСТИНА and ЛОЖЬ. I can try to change my own excel settings, so I…
maximum number when creating numbered list
HI, Is there a limit as to the number of items you can import using numbered list? Is there a maximum number you can import in the numbered list? Thanks, Ana
is anaplan hosted in saudi arabia ?
hello I wanted to know if Anaplan is cloud is hosted in Saudi arabia ? and also is Anaplan integrate easily with SAP S4 Hana ERP ?
Exporting Flat Lists from Saved View from the Hub to Spoke Model and Create Hierarchy
Dear Community, I am building 4 flat lists in the Hub as below. L4 is the lowest level, L3 is L4's parent, L3 is L2's parent and L1 is L2's parent. The next step would be to create saved views to build Level 1 to Level 4 in the spoke model based on the parent - child relation assigned below. Do I need to build a separate…
Level Model 2 Sprint 1 - Create System Modules. Import Using Blueprint View or Grid View
Hi Guys, I just started with LM2, already having questions. I'm pretty sure I'll have many more down the road. In the activity, when it says SYS05 Region Details module: SYS06 Country Details module: Few questions I have: 1. Do I use Data View or Blueprint View to Import. I understand Blueprint View is used when only…
Level 3 Sprint 3 DAT04 Import issues
Hello I'm having issues importing data into the the DAT04 module form the spoke model (Data Hub). I raised a question about a similar issue i was having in Sprint 2 and got it to work but now I'm having the same issues for the second import at the start of Sprint 3! Can anyone confirm where I'm going wrong?... Thanks
RESTful API for automating recurring data loads
Hello, I am trying to understand if the RESTful API can help for a use case of automating a recurring monthly data load to a DataHub with a file that is being reloaded on a daily basis with up-to-date data. When i review the documentation, i see the need for a manual UI step to create the action, so the file is uploaded in…
Default subset setting
Suggest to add ability for model builder to change the default setting for list subsets. I.e. add option to select whether a subset setting should be true or false for any new list items added. This will make it easier and more flexible to work with subsets, and help avoid having to create a dummy module and action to…
Level 1 Model Building - Importing Data
Hi In going through the import data files (e.g. Products), I came to understand that although the parent-child hierarchy is defined in the Lists, 1) the data for the parent (Product Family - Chocolate, Sours, Taffy, Fudge) still have to be defined in the import file. 2) the mapping for the parent (Product Family) still…
Run an Import process via postman
Hello Experts , I'm new to Anaplan and currently exploring the Rest API's . I'm doing a POC on the below requirement . The requirement is to send a csv file from a SAP system to ANAPLAN using an Import action (Expectation is the details of the csv file gets updated in the import table in ANAPLAN) . Below steps have been…
Several modules in 1 dashboard but presentation issue when exported
Before anaplan, i have this excel which contains 1 tab where all the financial statements are reflected with consistent time period. When developed in anaplan the 3 financial statements were developed in separate modules and were just combined into 1 dashboard in the model. Now the expectation when exported to excel is to…
Find the import ID from file ID
Hello Experts , I'm new to Anaplan and trying to integrate anaplan using Rest API . We are sending data to anaplan for which I would need an import ID . However , I have been provided with a file ID by ANAPLAN . Could anyone guide as to how import ID can be retreived from a file ID ? Also if someone can explain the…
How to synch user on the page with items of list displayed on the page
Hello, So I've been trying something I thought easy but encountered some problems, what I've been doing wrong, here is the situation : => User going on a page to enter some info about themselves in a board (grid). They open the page. They have to select their user name, as "Name", because their name in the database is…
Data Export
Hi, How can I hide a specific line item/column when exporting? Please see screenshot. Thank you.
What is json and why is it used in Anaplan
Hi Friends, What is json and why is it used in Anaplan? Also what is Apiary?
OAuth for Integration?
Hey community, I can't find any info on using OAuth for integrations. Is this possible, and if so is there documentation somewhere I can access? Thanks!
Level 2 Sprint 2 - Off Set Volumes for first forecast year
Hi I'm currently working through Sprint 2 on Anaplan's Lvl 2 training course and I'm having an issue with my OFFSET formula. The formula itself is correct (as the course later confirms) though it doesn't seem to pull through any data from the Volume line item? (See attached) Line item formula: IF 'SYS01 Time Settings By…
Do Read my Latest Article on Imports and Import Data Sources
Community, Here is my latest article on the best practices about Import & Import Data Sources. Please do read it. Imports and Import Data Sources as Production Data - Anaplan Community Thank You @rob_marshall for reviewing it and giving it a fine touch.
Facing trouble in importing .csv to Anaplan without Time Dimension in the Source file
Hello Everyone, Hope you all are doing great! My name is Bhumika, I am learning Anaplan. with the help of Anaplan Community. I am facing a trouble, as I am trying to Import the .csv Data File to one of my Modules. I have downloaded .CSV file from the Lessons only, but that .CSV file doesnt contain Time Dimension. How to…
Solution Architect Eligiblity
Not available unless: You are a member of the Audience: Customers Qualified for Solution Architect what does this mean??
Level 1 Model Building 8.5.3 Activity
Hello, I tried to import data by following the instructions but cannot. Here are the screenshots and csv file I am trying to import. Some data is imported but they are wrong figures compared to csv file. If someone can help how to correctly import the csv file, which is very helpful. Thank you so much.
Import bulk users into a list having selective access
Hello, If there is a list hierarchy and we enabled the selective access to it. now for each list item, I want to add bulk users at a time. Is there any method or can we use any module to import bulk users? Thanks, Mahesh Kumar
Data Integration in Anaplan
Hi Friends, Please tell me, using this Python Code, if I want to import Data from Oracle Data Base. What are the steps I need to follow? Is this the only step for Basic Authentication? # Insert the Anaplan account email being used username = '' ----------------- # If using cert auth, replace cert.pem with your pem…
Progress Bar in the New UX?
Hi Community! I recently saw a demo in the New UX that showed a progress bar as Anaplan stepped through various actions after clicking the action button. The progress bar appeared to be dynamically updating after each action was run. Does anyone have any examples they can point me to that shows how this can be done,…
Copy Paste Formatting into other Tools (Excel)
Description: Much like this example, Anaplan formats in odd and weird ways when moving into Excel. Numbers being copied pasted into excel should retain a numbered format instead of scientific notation when pasted into Excel. Example of Enhancement: Values copied from Anaplan have a format attached to the value in the…

Importing and Exporting Data

Discussion List