Importing and Exporting Data

Comparing two modules
Hi - Because of a unique use case, we had to create two modules with similar information except a couple of columns. I want to compare if the data is correct in the new model. Can you please suggest on how I can do this ? Sunl
ALM and History changes
I accidentally make an error and realize it instantly. So alter it back to the previous one. My history gets saved. Now I archive the model and later change it to standard one. Will Tenant Admin still be able to pull the history?
Delta load for Numbered lists
How to implement Delta load for Numbered lists in Anaplan ?
Level II Sprint III Model
Please suggest a Link from where I can download the FP&A Model.
History information seeking
Hi Friends, Any lights on how is ID values generated? It is sequential but why it starts with 200? I hope it's not year.
Anaplan Excel Add-In 3.3 (Read/Write Query)
Hi all, I understand the ability to create a read/write connection with Anaplan was reintroduced in v3.3 of the Excel add-in. Where does this feature reside? I am using v3.3.44.0 and below is a screenshot of my toolbar; I have full access and workspace admin permissions, I also have write access enabled on the version and…
Limitations Of List Members Of General LIst.
How many list members can we insert in a list at a time.
File Missing in Level 2 Sprint 3
Hi, Is there a .csv file for the Shipping Methods and Time taken for delivery? If not then it is not mentioned how should I populate it? Regards,
Add Filters for Data Import
I have Module A form where I want to import Data to Module B. I can't touch Module A, so I can't use Export function from Module A. As shown in the pictures, I want a filter Import of a particular country. I have worked on creating saved views and exporting but not sure whether same can be for Import as well. Any inputs…
Add a new Data Hub
What are best practices when is needed to create a new Data Hub due to workspace space limitation to 130GB? I have already built the Data Hub which contains historic data and data validation processes. I still need to load further years. The only option I have, without deleting the data already loaded is to create a new…
Safety stock import filling missing
I find the safety stock import .csv file is not uploaded in the Sprint. The image I uploaded is an old one shared in the community. Can someone please share the file or assist how can I download it?
How to import data without manual mapping for Numbered list?
Hi, I want to upload data into a module that has a numbered list as a dimension, as a result of this I have to manually map list elements manually to excel file rows Any technique for automatic data mapping of numbered list elements to excel rows? PFA Screenshots of my mappings for more clarifications:- 1. Source or Excel…
Issue with value addition
Hi Community, Can someone help me understand, why am I not able to fill in any values for Volume Line Items even manually.
SFDC Integration
What are the available ways to integrate SFDC with anaplan, How i can enable data flowing between these two systems?
Informatica doesn't find Anaplan Model as source/target model
Hi all, I'm trying to connect Salesforce and Anaplan via Informatica. I've setting up Salesforce and Anaplan add-in in informatica and 'test loging' works for both. When I am trying to create a new synchronisation task for an update, Informatica recognizes Salesforce. However for Anaplan, it seems that Informatica can't…
Selective push of line items through ALM
Hello fellow Anaplaners, I was wondering if it would be possible to selectively push line items/modules while synching models through ALM? The idea is - I would like to setup a master model and then migrate only the required functionalities/calculations to two different target models. With this setup, I will have to design…
import file amount rounding
hi anaplaner, i have problem about impor/upload file, when iam upload file number format, data in anaplan and excel file always different, ex: excel file 497.157.884.509 but in anaplan 497.157.000.000. how to fixing that problem?, and why is that? Thanks, Panji
Anaplan connect 1.4 Shell Script
Hi Leaders, I have got encountered with the below error as I try to do Anaplan connect version upgrade 1.3 to 1.4. Not able to figure out the error. Script: # This script executes a data load import to the model set JAVA_HOME="/****/jdk1.8.0_191/bin/java" set CertPath="/******/OpenSSL-Win64/bin/certificate.pem" set…
Importing into a list based on a specific value of the parent
Hi, I'm trying to add functionality to a model where G3 items in a list are deleted and replaced with other items in that same list. The model has the following Hierarchy: In the G3 list, each Resource is either a resource in the current scenario or in the future scenario, this is achieved by the 'Type' property: On a…
Error when importing a csv file into a module
I am facing an issue with exporting and importing a csv file. So I have a file that I am exporting with data for 12 months (Dates are formatted as Y-M, (i.e. 19-Jul) in the exported csv file). Then when I try and import the same file using custom mapping (Y-M) for Time, I get a failure dump and an error which reads: Import…
Importing a list data by end user
Hi, Just want to know, can end-user able to upload data into the Anaplan list? or only workspace admin can do it? Anyway, he can upload changing user access? Import Action can solve this issue but anything other than that? Thanks & Regards Sai Bharadwaj
See mappings for file imports
Hello, I constantly run into the same issue and I'm hoping that someone can help suggest a solution. When I create an action that imports from a csv file into a list or module, I always find it difficult to re-open up that import action and revise (or just view) the mapping that was previously created. Instead, I have to…
Excel Addin 3.3 - Filter on Line Item
Tried the new Addin, great improvements vs. 3.0 but still the same constraint of 1M cells. With that, I think we really need to have a Line Item filtering function to be able to control # of lines to download. Will this function be added? Thanks.
Length of Text value
Hi Anaplanners I have a question about the length of Text values.I tried to import a text data(500bytes) to a text format and failed.I was wondering if I had exceeded the length limit. Is there anyone can tell me the maximum length for Text values.Thanks!
Anaplan Connect 1.4.2 Shell Script
Hi, I was encountered with the below error code as I execute shell script. Shell Script : # This script executes a data load import to the model set JAVA_HOME="/****/jdk1.8.0_191/bin/java" set CertPath="/******/OpenSSL-Win64/bin/certificate.pem" set PrivateKey="/******/OpenSSL-Win64/bin/private2.key" set…
Tracking historical data in a live model without making the model huge
Hi Community, I've built a model where end users input information and it calculates outputs. This tool will be completed by end users on a adhoc basis, some will use it weekly or monthly, while others will it once in a while. One of the outputs, shown below, is based on live information in the model: As we want to keep a…
Territory Allocation Urgent
Import current month data
I already have previous month data. Now I want to import only current month data. Please assist.
Number are being imported as thousand instead of decimals
Hi! My numbers are being imported as thousand instead of a decimal number. But in my blueprint, the number is set up to have a decimal delimiter as dot, and thousand delimiter as comma. and those are the values that should be entered. Does anyone know what is happening? thanks.
Export selected list members
I need to export only few list member details. Can someone suggest which will the possible way to do so?

Importing and Exporting Data

Discussion List