ADO - Select File on "Run"

TimWard70 · 2025-02-19T13:25:11+00:00

There was an error rendering this rich post.

Using Anaplan's traditional data import functionality when an import action linked to a csv file was triggered through a dashboard\UX page the end-user was prompted to select the file to import. The import uses the structure defined from the original file and applies it to the chosen file.

Can this same prompt be achieved using ADO so that a CSV file import can take advantage of the new transformation functionality (e.g. UID)?

Accepted answers

Loren075Keyser

Hello!

Yes, you can achieve the same prompt using ADO (Anaplan Data Import) to import a CSV file and take advantage of the new transformation functionality, such as UID. By setting up the import action through ADO, you can choiceadvantages configure it to prompt the end-user to select the file, just like with the traditional data import functionality. This allows you to leverage the enhanced transformation features while maintaining the user-friendly file selection process.

All comments

Loren075Keyser

Hello!

TimWard70

@Loren075Keyser Thanks for the message, I was excited by the news as I thought I had missed something.

I started an import from scratch and worked through importing a CSV to ADO and setting up it up to import to a model.

During that set-up I couldn't find an option to ask for the source file each time the integration is run. I checked in the connections, source data and Links sections. I also checked the elipses options and every other setting I could find in ADO and the UX, to no avail.

As a result, when I publish the import to the UX it simply imports the original CSV.

Is anyone able to give me a little more detail on what setting I need to apply to allow an end user to trigger an ADO action from the UX and be prompted for the file to use?

KR Tim

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…