Importing and Exporting Data

Publish Export Actions to UX without creating a Process button
At present we can publish all other actions to UX except for Export Actions, without creating a process button. It would be nice to publish the export action without having to create a process button. We could create process button only for those which needs to be grouped together. When we have siloed export process of one…
Support of cyrillics and possible other national symbols in Anaplan Connect
Not quite critical, but It would be nice if Anaplan connect scripts could support names of the tables/fields written in local languages for example using cyrillic symbols. Currently such names are being corrupted into ??? characters and cannot be found by the database. This makes us to create additional views and thus…
Level 1 model building Part 10: OTH01 Non employee expense module
Hi Team, I have done as instructed in the training and imported the data from a csv file to the module. All data gets imported but there is no mapping for the "Total" column in Source to target mapping, which seems to throw result as zero. PFA pictures for more clarity. Do I need to use a formula in total column or I am…
L1MB Part 8: Data Import for REV02
Hi, I have a successful data import (Volume Inputs.csv data) for REV02 Volume Inputs Module but I don't see any data inputs in my module (see screenshots). Can anyone guide me on what I did wrong? Thanks!
8.5.2 question volume input
Hi guys my view for Rev02 is different to the one in 8.5.2 how do i fix it please? is it supposed to look like this? Learning content My Content
Export de données
Bonjour, Savez vous s'il est possible d'associer une action d'export à une vue ? Exemple : j'ai créé une action d'export des résultats le mois dernier, donc avec comme sélection "Sep 20". En relançant mon export ce mois-ci, j'ai à nouveau "Sep 20" alors que j'aurais souhaité avoir "Oct 20". Pourriez vous m'aider s'il vous…
Importing into system module
Hi Team, I am trying to Import data into SYS08 Employee Details as part of my Level 1 model builder training program, but while importing i am confused as in what to fill in the time dimension. 1) Since they are flat modules so time dimension should not come, so is that my mistake? do i need to remove time dimension from…
Level 1 - Lesson 7.2.1 and Lesson 7.2.3
Hi I am stuck trying to import data from the Product csv file and the Employee csv file. I think I am doing the mapping wrong. I tried all different combinations but failed. I have attached the screenshots of the messages I have been getting. I would appreciate some help. I can't see any imported data in the modules.…
Level 1 Model Building
I'm having problems on section 7 importing the file for SYS006. I believe my issue is with the mapping of the Time. I'm also having issues with SYS08 on seeing the data after importing the data. It is showing all 111 records did update with no errors. Any help would be greatly appreciated! Thanks! Terri
Import Saved view into list
Hi All - I am new to Anaplan and sure missing something obvious in implementing this use case. Could you please point me what I am doing wrong Use case: Create a button in dashboard for admins to add new Regions. As soon as a new region is added it should be saved in a list Here is what I did 1. Created a module (INP01…
Name an action on set up
I would like the ability to, when setting up an action initially, give that action a name that would be used in the Actions section of the model settings library and indicate if it is recurring or single use. Then by running that action it would either be kept with the name given - recurring - or be cleared from the…
Incremental data export to interface (informatica)
Hi All - I am looking for design suggestions to below the following use case. Please guide me . Thanks 1. We have a module for employee - role mapping (1:M) 2. Planners have an option to change employee role (add / delete) 3. There are other downstream systems looking for modified employee -role mapping data. Hence, the…
Level 2 - 3.3.3.2 - Dimension problem for Import data from Data Hub model to S&C model
Hi all, I am working on this task from Level 2: I have the following DAT04 module in the Data Hub model which was successfully imported from csv file called Weekly Safety Stock.csv (attached here): The same module in the S&C model is this: And I can't import the data from DAT04 from the Data Hub model to this one. It looks…
Anaplan Data Export using Cloud ETL - Snaplogic
As per the Business requirement, need to export the data from Anaplan (Not Manual). To define this, we used Snaplogic cloud tool to extract the data and do data manipulation by using Anaplan Read Snap. We can configure this Anaplan read snap in two ways 1. Basic Auth 2. Certificate + Keys based on above information, we can…
Anaplan to Qlikview Connection
Hello Everyone, Is there any API connector available for Qlikview? I want to import data directly to Qlikview from Anaplan Modules. Thanks, Sandeep
Excel extract in attached format
Hi All I want to take extract from new UX grid in attached excel format. This template has a special requirement of showing cells name which appears in drop down option highlighted in yellow in attached screenshot at top left corner. So when we select a value from drop down it refers to a particular cell in the sheet. Do…
Anaplan stops during large imports and processes
Recently I came across and issue where Anaplan users won't be able to work if another user is importing a big file or running a process. it was reported by users that during those time Anaplan stops responding and the dialog box appears which says some user is making changes. Does anyone faced same challenge and what can…
Not able to get correct hierarchy : Level 2 Sprint 1 G3 Location
Not able to get correct hierarchy : Level 2 Sprint 1 G3 Location need help Attaching screenshot for reference
4.6.6 Activity: Import Data into P1 Product Family List Unable to import data from product families
I am trying to upload the product family data into my model in lesson 4, and each time I try I get a notification saying "Multiple files inside an upload package are not currently supported." I was wondering if anyone knew how to troubleshoot this problem.
Data in 2 modules with exactly same lists
Hi Experts, I have a doubt. I have created a module i.e. Module 1 and also created another module i.e. Module 2 with exactly same lists as Module 1. In Module 1, have entered so many data, but that data is not appearing in Module 2, which is same as Module 1. Is it the expected behavior? where we have 2 exactly same…
Add flexibility to history export requests for Anaplan models
As a model builder, I would like to see greater flexibility to history export requests for Anaplan models. Context: The History Export function is critical for audit checks to understand if any particular user activity/imports/processes might have caused a data issue or some connection to break. It is important as part of…
Export/ Import
Hi All, I have a module created in the system with numbered list in the rows having duplicate entries and time in the columns with only one line item as named 'value' in the page selector for which the user inputs the values. Request your suggestion on how to create the export and the import action button for the same grid…
Activity 7.2.3 Importing into Employee Details
Please help with data import query. My file is not loading correctly despite several attempts. Name: most rows are empty, I am not sure why only a few are bringing the Name up Same with Country only a few which also have the name in the them For Name & Country it didn't automatically map, I had to manually map - why not…
Mapping Options for Module Import
When uploading a CSV a few more options about whether specific columns can be ignored or manually mapped (in a similar way to how imports to lists work)
multiple files upload in random order
Hi, I have a question with multiple file upload in a Process. The Process has A,B,C,D Action and the Action is sorted. A Action needs file a. B Action needs file b. C Action needs file c. D Action needs file d. But when I push the Process button, the place where upload the file is ordered random like below. b a d c How can…
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/#

Importing and Exporting Data

Discussion List