Importing and Exporting Data

Urgent help assistance
Hi Friends, I am struck with a difficult situation. I have Module 1 and this is the Data Hub and the Date is stored in Text Format. Every quarter I need to pull the data and make it look like Module 2. Now my problem is as the Date is in Text Format, I was trying to find the current year. By converting Text to Number and…
Requesting a serious help
Hi Friends, I want to create an Action process. That will automatically import the current year data. Please assist me in this.
Time out issues with Anaplan Connect v1.4.4 console while importing LARGE files
New to Anaplan, loading large volumes of historical transactional data to support multiple models. We have a clean structure and the process "works" but virtually every import into the module has our session in the console timeout. It appears that the file has loaded successfully, but when the console times-out, I lose…
Mapping numbered lists during module to module import
Hi all, Seems like this should be a straightforward one, but I can't figure it out.. I am trying to import data from one model into another model, using numbered lists. The Source module and Target module (which are in two separate models) both have a list called 'Towns' as a dimension. This list is a numbered list, but…
Import Data into SYS06 Product Details
1) Mapping Tab: I am confused as to what to insert in the time tab as in the course structure it was clearly given whether we want to import it as an actual or forecast data. But here whether to choose fixed time or Ask each time import is run? 2) Line Item tab: How to go back and check the target items having product…
Import Pop-Up
Hi Team, A user has just started receiving a strange Pop-Up when they use Data - Import when within a Module Normally you start with the Select Source pop-up and move to the mapping items etc while this has no mapping items etc Is this due to access levels? Thanks User Upload Pop-Up Normal Upload Pop-Up
import action not grabbing latest data file
I have an import action for importing data into a module. I've created a process for this action and a button for the process published to a dashboard. When i click the button....sometimes I have to select the file to upload and sometimes I don't. The data in the flat file has changed but I don't see that reflected in the…
Filter by formula
I have a particular existing module. Now I want to create a new module which will only have the filter records. Please assist.
Delete record without saved view or filter
Hi Friends, I have a Module from which I want to delete the highlighted records. But without using filter or saved view. I can use any formula to do so. Is is possible by any chance? Kindly help me, if you had worked in a similar restriction.
Importing a csv file - Question
Hello Anaplan experts! I am very new to Anaplan and am going through the courses to get my Level 1 certification. I am sure this is a vey silly question, but figured I would ask rather than keep spinning my wheels. I have a csv that is attached. I need to Import this file into a Geo Hierarchy, but am having trouble mapping…
L1MB-Part 8: Data Import For Rev
I'm not able to import the data correctly. The mapping of the columns seem off. I'm trying to use column headers for time but it keeps picking up the first column where it says Volume (See attached). Is this because the way I built the module (see screenshot)? Thanks, Kevin
Anaplan API WADL
Hi , We are looking to use the anaplan api with one of our ETL tools which allows us to setup a connection using a rest connection, however it's looking for a WADL. Is this something that exists or will we need to create this ourselves. Thanks D0nmac
Contents of import actions
For import actions it would be good to have a column in Imports tab. suggesting which of the source items(list or lineitems) are mapped to target. Not the natural mapping by anaplan but any thing which is manually mapped and saved rather than opening each action and figuring out.
Line Item Data Connections
If a line item name changes in the source, keep the mapping in actions so that it pulls from the new line item name automatically.
how to update list with hierarchies
i hv created a list with different properties and want to update some properties when end user done some changes in the property published on dashboard and same gets updated in the list. i hv created a system module with two line items same as property in the list and published on the dshboard. once user does some changes…
Model Building Level 2 Training - Import Issue
Hello, I am trying to upload data in OTH01 module of the FP&A model from INV05 in the supply chain model. Every thing looks perfect. I juste have a problem when matching the location. As you can see in the source module i have Mumbai as location while in the target module i have Bombay. Is it normal ? What module should i…
Import Data into SYS06 Product Details
I am having issues when I import, this is what I have done. Only one size gets imported
Bulk Copy multi month mapping
Dear all, Would be great to do a bulk copy being able to map multiple months either to the same month or to another month. So if for example I would like to copy data from Jan - Dec 2019 to Jan - Dec 2020 I would have to do this in 12 steps. Other posts have been shared that I also support, but are slightly different:…
Bulk Copy over a selection of two or more dimensions
Dear all, Would be great to bulk copy data on a certain combination of dimensions: For example to copy the data of one Store to a specific other store but just for a selection of months and a specific version. And make it possible to create an action out of it; it would allow end-users to pre-populate a new Product, Store,…
SYS08 Importing data
Hi all. I've been constantly running into issues importing the employee details csv file. I'm going to attach the three things I am seeing on my screen. Was anyone successfully able to import data? Let me know how I can do this.
Automatically export Permissioning
Is there an action for exports? I would like to export permissions (user, role>module, role>versions, etc) in a more automatic way so I can assure a less time consuming and recurrent backup.
Level 1 Model Building: EMP01 Employee Drivers import
I've been working on the Level 1 Model Building course and I'm a bit confused by this import. I'm sure I have followed all the directions exactly from setting up the EMP01 module to downloading the correct csv file for import, but the one thing I can't get right is the time that it's asking me for. It's asking me to…
Incremental data load for current month
Hi, I want to do a data load only for current Month data, I have a data file where I have complete year data but I want to Load data only for current month. We have created a boolean line item which filter my current month records based on current period setting in model. but Just wanted to know, can we setup a process to…
Data import from excel to List
HI all, I am loading data from excel to List and i have blank entries in the excel sheet which has business meaning, hence i am bit struggling to maintain blank entries in the list or how Anaplan recognizes the blank entries from excel records and loads automatically to the list. -Santosh
Importing between Models - Mapping
Hi, I currently have 2 models and I'm trying to pull staff costs from one over to the other. The module I'm trying to import into is dimensioned by employees and years. The module I'm trying to import from is dimensioned by employees, years, and versions. When I connect to the Anaplan model and select the module, the…
Percentage Issues: Level 2-Sprint 2
Hello, I have a problem when importing percentages from a CSV file into the DEM01 Volume Growth. In fact after importing, it looks like all the percentages from the CSV file have been multiplied by 100. Any one has faced this issue ? This is my number format configuration. I tried ti change it but it didn't have any impact…
Import into Parent Level using BreakBack
I would be really good if we can import data into the Parent Level when Breakback is enabled. Currently, it is not possible in the system . Hope to see this functionality soon in Anaplan!! 🙂 🙂
Import Error
Hi All, I am receiving an error 'Illegal Argument' while importing data from the saved view of the module to the same actual module within the same model. Please help me with the possible reasons. Thanks in advance. Sampriti Anand
Level 2 - Sprint 1 User Story 1 Rename the action
When I try to rename the "G1 Region from Level 2 Data Hub [Your Name]/ 'SYS05 Region Details" to "T3.1 Build Region", I can't find the right place to click on the "Rename" button (I also tried right click on Import items but in vain), also tried to click the "Rename the action" hyperlink but there is no demonstration…
"Omit Summary Items" on Exports should be an option for Imports
Currently, there is an option to "Omit Summary Items" when you are exporting data designed to exclude parent hierarchies. However, there is no such option for imports and this requires users to create saved views that manually exclude parent levels and can cause a lot of manual work for model builders. Without removing…

Importing and Exporting Data

Discussion List