Importing and Exporting Data

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
Level 2 - Sprint 2 - 2.3.9.1 Import DAT03 Historic Volumes module
Hi I have got this error message however I tried to do it. I am not sure where I am going wrong. I followed the Anaplan community replies thread but am unable to follow. Obviously this is why I am still getting the error message. Some help will be greatly appreciated. I have attached screen shots of the DATA HUB Model…
Model 1 - Importing Data Error
I'm stuck because I keep getting the same error. I've downloaded and saved the spreadsheet several ways, but nothings working. Please help - I'm Stuck!!!
Export multiple modules into unique file
As a Model Builder I want to create a Process to trigger multiple Export actions at once, each export linked to a different module. However, the Process generates as many files (csv, Excel, txt,...) as the number of Export Actions within the Process. It would be better if the Process could generate a single file (CSV,…
Publishing of the dropdown option
Hi, I have two different hierarchy of lists. Both have n number of hierarchy. List one has display name as Priya and the other list is referred as Priya | Anaplan, Priya | Java. The display name for second list is the combination of first list and course. Here, Priya | Anaplan, Priya | Java have same Priya. As first list…
Unknown Error while Importing a Subset
Hi! There is a very simple import where the end-user checks a boolean for the items they want to keep in a subset and then runs an action that takes the boolean value to the list and updates the subset. Clean and straight. However, user is not getting a peculiar error. Can you help me understand the reason behind this…
L2 - Sprint 1 DAT03 Historic Volume import
Hi, I'm trying to import the above but keep getting the attached error message. Can I please get help in identifying the error. Regards, Nayani
Create new List Item from Module
Hi all, I have a hierarchical list of Customers where the bottom two levels are Customer and Branch. I've got a separate hierarchy for products which as its bottom level has SKU. Due to space considerations our Anaplan consultant created a level below Branch for SKU, where items are only created where there is data. We've…
Importing data from big query
We have a problem to build and import the data from GCP bigquery. It need to be automated. I will appreciate the approach and if possible some sample code (written in python etc) to get the data from bigquery into anaplan datahub
Labeling import prompt for end users
With the current import process, when users are prompted for files, it simply says 'Upload a file for input into [insert module name(s)]'. It would be helpful if we could associate which file is used for which action as the end user selects the file. Example: uploading 2 files into the same module, with different…
Import Data into P1 Product Family List
Hello! I am having issues importing data from the product+family csv file. When I run the import, the model says the import was successful. However, when I check the Tree View, no new data shows up under "All Products". I did not have any issues with importing all the geographical data so I'm not sure why the product…
Data Tags as a comment feature for developers
Hi team, As a Model Builder and BAU Support Team Specialist, I am interested in documenting enhancements in our models. Using only the Notes feature as a commenting tool, it is getting really hard to track them all after a couple of years of the model being rolled out. At some level of complexity of the model, it is…
Creating a version with import action - access settings
Hi, When manually adding versions, you have the option to select access setting. By default, it is Write. See photo below. However, if you try to create a new version via import action, you can't specify the access setting. The new version created, has by default No Access. I wanted to automate the version creation using…
Level 2 Sprint 1 Lesson 1.6.4.2
Hi I have now renamed the actions and processes as required by the lesson 1.6.4.2 I find I have an extra ACTION in PROCESS 1. It is ACTION 1.7 Initially the lesson while importing asked us to import only the Distribution centre and the Product Code. Subsequently there was a step to add a formula for import of CODE which I…
Automated version creation
Hi, I am trying to allow non-admins to create versions in a model using AN connect. The idea is for Anaplan connect to import a custom versions list into the native versions. The issue is that versions created in this way have access set to None by default. In contrast, when you add versions manually, your default access…
Broken saved view caused by renamed LI part of the saved view
Hello, I have recently stumbled upon the following case: I have a saved view part of an Import action. I've done optimization to the relevant module during which some of my Line items got renamed. A week later when the Import action needed to be executed, it failed due to unmapped items. It turned out that the renamed Line…
Set formatting when export to excel
When end user export data to Excel, both number and text are right-aligned. My end user want to set text is left-aligned and number is right-aligned. Is it possible to set export formatting of each line item when export to excel?
Simultaneous processing (multi-threading) of Anaplan actions
As a user and/or model builder, I want to be able to run actions simultaneously where possible to speed up the data processing and list maintenance actions. This function should also allow other actions to be run only after certain actions have finished running successfully. As an example, if I want to load trial balance…
Extracting Data From Anaplan With Qlik
Qlik has two data analytics tools—the older one, QlikView, and the modern one, Qlik Sense. They both share similar scripting and the same data files. Data extracted with QlikView can be used by Qlik Sense and vice versa. Many enterprises still rely on QlikView and the QlikView Publisher to handle data reloads while they…
add processId, actionId, fileId as columns in Settings (for API development)
This will speed up API development and runtime both. The API requires ID's as parameter, however Anaplan UI shows only the Name. When using API for sending data to Anaplan or triggering a process we now use the name for searching the id. Currently this requires additional looping in our API framework. If we know from the…
Inconsistency on importing data from module to module
Hi All, Does anyone encountered this scenario on importing from the same module. I'm trying to import the value of Aug 20 - Actual to Sep 20 - Budget using a saved view. Here's the result: Item B to F imported the Aug 20 value. But item A seems to add .04. I also tried to zero out Aug 20 then run the import again and…
Financial planning tool selection - Adaptive planning vs Anaplan
Looking for advice as to how to make an informed decision on choosing adaptive vs anaplan for financial planning. Data sets are not too huge and the cost and simplicity of the tools are important factors in the selection process.

Importing and Exporting Data

Discussion List