Importing and Exporting Data
Discussion List
-
Build Anaplan Line Items by Just Asking Claude. But What Happens to Your Data?
I asked Claude to add line items and a formula to a planning model in Anaplan, and it did the job in a few minutes from plain sentences. No special add-on, no clicking through menus myself. That is exciting, and it raises the question every team should ask first: what happens to our data? The short answer is that it…
-
ADO Pipeline using SFTP: Outbound PGP Encryption Support
ADO can handle inbound PGP encypted files (as per https://help.anaplan.com/pgp-encryption-in-pipelines-8f662578-1a51-467b-9817-3083f170511c). However, outbound there seems to not be a solution. Please provide a way to create an encryption key using PGP for files to be provided into a SFTP connection.
-
Preserve saved view layout in Data Orchestrator pipeline exports
Problem When an Anaplan saved view is used as a pipeline source, Data Orchestrator exports the data in a flat format rather than preserving the view’s pivot. For example, if time periods are displayed as columns in the saved view, the pipeline places Time in a single column and creates a separate row for each period. This…
-
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
-
How to add dymaic timestamp in the file in from ADO to Azure blob
Hi, I am using writeback pipeline to export data from anaplan to Azure blob using workflow and ADO. The requirement is adding date time in the file whenever it is triggered via ADO.
-
level3 sprint1 4.6.5 Sale Planning Model: DAT02 module
Hi, I am now struck in below excercise 4.6.5. As As per the ask i have done the below steps -Created a DAT05 module in datahub with Historic sales revenue for 2019 -In Sales model i have created DAT01 for Historic revenue and imported it from Datahub model -Created DAT02 PY revenue to CY. And used the below formula for…
-
Anaplan FCR - Ability to filter on import-map warnings within the mapping editor
In the Anaplan FCR map editor, users should be notified when there are validation warnings of already existing entries within a configured map they're attempting to open. More importantly, once the editor is opened, users should have the ability to filter on all rows with warnings. As an additional thought, users should…
-
Remove prefixed quote for text in Anaplan XL
Hello, I haven't used Anaplan XL in a while so now, I can't find a way to remove the prefixed quote for text data when using Anaplan XL. Can anyone show me how they figured out how to do that, please?
-
7.2.3 Activity: Import Data into Employee Details Module
When importing data into the SYS08 Employee Details module, my end results looks like the second photo when the goal is the first. I have imputed the correct mapping, and manually mapped the employee detail line items as well as changed the date format to YYYYMMDD. I'm not sure what the error is, I keep getting the error…
-
Can import actions be restricted from updating read-only items in a custom version list?
Hi everyone, I have a custom list that represents versions. Users need to be able to see all versions in UX pages and reports, but one specific version (Version 1) should be read-only. The problem is that when users run an import action, the action opens a dialog where they can select the version from a dropdown. Even…
-
Can import actions be restricted from updating read-only items in a custom version list?
Hi everyone, I have a custom list that represents versions. Users need to be able to see all versions in UX pages and reports, but one specific version (Version 1) should be read-only. The problem is that when users run an import action, the action opens a dialog where they can select the version from a dropdown. Even…
-
Export Anaplan data via API
Hi all! We have a connection via API with our client. They push data into Anaplan but now they request us to push data from Anaplan to their data lake. Is it possible to automate an export action, generate the .csv and client system get this files directly from Anaplan?
-
Ran into two issues this morning with selective access, and no items available for selecting
Hello, One of my models is generating this issue: "PLANNED Position # has selective access enabled and you may not have been granted access to any items." When I try to adjust the selective access, it then says "no items to select". I'm unsure what caused this issue and how to correct it. Any help sincerely appreciated.…
-
Introducing Anaplan Toolkit: side panel for model details, exports and model lock tracking
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
-
FCR: Security Profile Access rules do not apply to import task
Within the Security Profile Access we have specified entity access based on roles. This works fine for reporting purposes and for data input via a template. But within our month-end process we have also an import task. This import task ignores any rule defined within Security Profile Access. Please add functionality to…
-
7.2.3 Activity: Import Data into Employee Details Module error
Hi team, Missing out some step data while mapping, data was updated successfully attached screenshot (12error), however data is being uploaded with ignored values. Do I have to make any change in the module section? @noelle_murphy
-
7.2.1 Activity: Import Data into Product Details Module Question
Hi there, I am having trouble importing data and I think my mapping may be off. When I get to the Product Details Line Items, there are no selections available. Can anyone advise?
-
Level 1 Lesson 4.6.9 File Mapping Guide
Hi Everyone My import was successful however it doesn't match the guide Here's the result of my mapping Here's the guide Hope to hear from everyone soon!
-
Level 2| Sprint 1| 1.4.3.2 Import Data & Add Formula; Error: Item Not Located in P2 Products Family
The blueprint view screen shot for SYS12 SKU Details is shown below: The P2 Product Flat screenshot is: The P3 SKU Flat screen Shot is: The error detail message is: And the SYS12 SKU Details screenshot is: Any suggestion/advise what I am doing wrong. Thank you.
-
Bidirectional connectivity via Pipelines between ADO and Amazon S3, Azure Blob and GCS
Author: Kira Wagner is a Product Manager at Anaplan. Contributor Kurt Rodegast (@KurtR) is a Sr. Product Manager at Anaplan. Anaplan Data Orchestrator (ADO) now officially supports bidirectional connectivity for Amazon S3, Microsoft Azure Blob Storage, and Google Cloud Storage through Pipelines, significantly expanding our…
-
Connecting Amazon S3 to an Orchestration Platform
Author: Bhanu Chalotra is a Certified Master Anaplanner and Senior Consultant at Technology Modernization. In most real-world data environments, data doesn't originate in the platform where it's ultimately analyzed or consumed. Instead, it usually lands somewhere first, and more often than not, that "somewhere" is Amazon…
-
Ability to auto-name PDF based on context when exporting from Management Reporting
When exporting a PDF - the name is always the name of the page as it appears in the app. It would be good if you could configure this so that it recognises the context of what you were exporting, but could supplement this with text. E.g. if you were exporting a board pack, you could select the context of "Europe" and…
-
Near-Real-Time Anaplan → Claude MCP: Any Faster Than Bulk Export + MySQL?
We're looking to feed live or near-live Anaplan data into Claude through MCP, but our current approach — exporting CSV files via the Anaplan Bulk Export API, loading them into MySQL, and querying from there — has a significant lag (hour-long turnaround). Curious if anyone has found a faster path, whether that's through the…
-
ADO: Column Profiling
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: When transforming data with ADO, it's difficult to validate the integrity of the data: Column profiling tools would be useful. It…
-
ETA on ADO - Mulesoft - Boomi API integrations?
Hi! In London it was mentioned, any update on this?
-
Export a grid card options
Hello, I recently had an export issue with grid cards on the UX. A user Click the ellipsis (…) on the top of the grid card, wanting to export the grid as a CSV, but the only option was PDF. It didn't even show the export this view button, it was just export as PDF. I could go to the same page, and I was given the option of…
-
MB Level 2 Sprint 1: 1.5.2 Activity: Import Data into Beginning Inventory
Hi, I currently trouble importing data into the DAT01 Beginning Inventory module. Kindly advise.
-
"Failed to retrieve field list" error when importing saved view across models
Hi everyone, Has anyone run into this issue before? I am trying to import data into a Marketing model list using a saved view (Update B3 Product Dist in Mktg) from a source model (FinancialPlanning_Dev_Polaris). However, when I try to set up the import action, I get the following error: Select SourceFailed to retrieve…
-
Building a User-Filtered Export from a Module with Multiple Selectors
Good morning everyone. I need to build a module export with some specific requirements: users can select a currency type (USD/Local), Salary Type (1 or 2), Nomina Type (1 or 2), and Version (Forecast, TS, Plan). Currently, each of these filters is driven by an independent system module published in the NUX, each…
-
Stable User Access Export
Hi all, Has anyone found a way of exporting User Access from a saved view rather than directly from the Users tab? We're feeding the export into Azure Blob Storage and have had a couple of issues recently where changes to the standard Users export altered the filename/structure, impacting downstream processes. Ideally,…
Upcoming Events
-
Unlocking the Value of Community with Anaplan Community Bosses
Join us for an exclusive professional development roundtable designed to celebrate, connect, and elevate our premier platform advocates: the Anaplan Community Bosses. The Community Boss program stands at the very heart of our ecosystem, highlighting leaders who dedicate their time to guiding peer model builders and…
-
Designing for Fit, Utility, and Practical Guardrails with AnaplanXL
Join Anaplan experts for a practical introduction to AnaplanXL (AXL), the Excel add-in that connects Excel grids directly to governed Anaplan data. As the first session in our technical series, this event is designed to help: Model Builders understand the fundamental purpose of AXL: what AXL does, the basic guardrails for…