Importing and Exporting Data

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/#
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…
Cloudworks Integration run vs Schedule
Now using the cloudworks integrations and have come across an annoying situation. Once I set a schedule for an integration the option to run it now disappears. Only way I can find to run it now is to cancel the schedule (deactivating not sufficient) and then rebuild the schedule after I have run it and made any changes.…
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

Importing and Exporting Data

Discussion List