Importing and Exporting Data

Losing data from saved views & processes
Hi Team, I have a process that exports three saved views from 3 modules, however when I run it, it doesn’t capture all the data that’s in the module. I think some line items are missing. What is the best practice to either: * Ensure saved views are dynamic and update automatically for when new list items or line items get…
How to import multiple header rows into a module?
The import file is an export file from a module that I am working on. There are several header rows that I need to import into the module. How can I do this? Jan 19Jan 19Jan 19Jan 19Feb 19Feb 19Feb 19Feb 19Mar 19Mar 19Mar 19 ActualActualForecastForecastActualActualForecastForecastActualActualForecast…
Print or get source to target line item mapping through API
Hi Anaplan community, Based on clients needs, I wanted to figure out a way to print out the line items' source --> Target mapping through the Anaplan API. This is when a model builder is doing an import and gets to manually map data from the source file to the target line items but here we can quickly have an array or list…
Print or get source to target line item mapping through API
Hi Anaplan community, I wanted to ask whether there is a way to print out the line items' source --> Target mapping through the api. This is when a model builder is doing an import and gets to manually map data from the source file to the target line items. Much appreciated!
Import from File vs Module
I’ve been running the Model Optimisation training in recent weeks and one of the benefits of Data Hubs we talk about is that Model to Models imports are faster than exporting to a file and re-importing from a file. The question is always “by how much?”, so these are the details of a test we did in April Performance test of…
Postman POST command to run process is stuck in "NOT_STARTED"
Hi experts, Hope you can help with this. I'm running a process that runs an import action from Postman and I get a status 200 every time. The problem is the process isn't running. When I check the status I get "NOT_STARTED". Does anyone know why this is happening? The process is an import action that updates a boolean (1…
word count limit when import data
Hi Anaplan, I would like to know any word count limitation on Anaplan when we are import / create the data model ? Reason of this question because I got a data table but it seem I can't import the lines if the words over 60. Best Regards, Kiwi
API Invocation failed
Hi Anaplanner, I want to import list to list form another workspace, but I get error API invocation failed: HTTP/1.1 401 Unauthorized, how to fixing? Thank you
Time Display of Line Items Formatted based on Time Formatting in the Module
Treat line items in a dashboard based on the Time Formatting in the module when displaying data. For a simple example, I have a customer code, customer name, and its monthly revenue in a module. I only want to see the customer code and customer name at the beginning once, as it is does not have time applied to it, but I…
Rogue data appearing after Import
I have a Module with many line items, and time using w/c and versions I have a saved view and it looks perfect. I have another Module with 3 line items, and time using w/c and versions. I import data from the 1st Module to the 2nd Module from Version: Latest Estimate to Version: Forecast -1. It imports data that does not…
Unable to import large file
attached screenshot
Updating Anaplan Connect 1.4.2 documentation to align with example batch files
Hi all, I recently updated to version 1.4.2 of the Anaplan Connect Client. I noticed that the format of the examples listed in the documentation is different to that of the example batch files provided in the download. I was having difficulty getting the script to work when following the documentation instructions, but as…
Allow for multiple list items in user selective access when importing from a module into users
We use imports to update our user list with selective access, but cannot do this when one user can have multiple access, e.g. access to multiple countries in a list, because the line item in the module has to be dimensionned by the list itself and in the list we can only select one item. Alternatively we may run the action…
Adding a code to an item in a numbered list
I am working with the New UX and used "Form" to insert into a numbered list. I do not want to depend on the end user to create the "code". Is there a way to add the code to the list item via import? Cannot import by code because the code does not exist yet. With the Classic UX, I used a module to have the user enter…
Export Data Sources
Hi Team, Colleagues, I don't know if this has been brought up by now as I am not able to see any similar topic. Is there any possibility to check export data source, especially Module saved view it's pulling from? If not, are there any plans of upgrading to this feature? For us, would be a life saver as we use multiple…
deleting an Item in a list import
Hi All, I was trying to import a list from another but came to know that when i add an item in source list it gets reflected but if i delete an item in source list it does not gets reflected in target list. is there any way to implement that part?
Ability to change the format type of labels when exporting
Description of the enhancement required: When exporting labels for a number formatted field the output is in text format in all export file types currently. We need the ability to select the label format when exporting, so a numeric formatted field can remain number formatted when exported if desired. If we make this…
Data import with non-numeric values
While importing data from one module to another, one of the fields "currency" is non-numeric. For example, we will have the following records: Product A, Customer B, 02/2020, 1000, GBP Product A, Customer B, 03/2020, 2000, USD In the case above, the data values are loaded correctly to both months, but only the first…
Deletion of numbered list consequences handling
I have created a module where i have some list formatted line items and some number formatted line items (all as columns) along with a Numbered list with display name as 1,2,3,4,.....(manually given by us) to create a blank view for the end user to enter records in each row(for reference; see the below attachment). The end…
Period format in export file.
Hello, I am saving some export definitions for my client. To print all the codes in a flat .csv export file, I would have to put 4 or 5 dimensions in the rows, but it's limited to 3. Instead, I am using the tabular method with a filter for time and version. The only problem is that when time is transposed Anaplan changes…
Import Issue
Hi, Please see attachment. Regards
Action on numbered list
I have created a numbered list and an action to add new items. Is there a way to ask the submitted to add a textfield so the new list item doesn’t appear under a List id number?
Excel Add-in 3.2 - Push data back to Anaplan ?
Good afternoon, We would like to use the Anaplan Excel add in to enable user to modify data from a view and push it back to Anaplan via Excel. Apparently the last available version to download is the 3.2 that doesn't allow a two ways connection. Version 2.6 allowed it, but is not available for download anymore. Any other…
Anaplan Connect Error - One Drive
Hi team, I am receiving the below error when trying to perform a simple upload using Anaplan Connect & One Drive. This action will perform if I change the directory of Anaplan Connect & the batch file to the local C: I have reviewed the Anaplan Connect help document & saw there is a section about Network drives (pg 43) but…
Module or line item id using restful API
Hi Guys Does anyone know if we can export module / line items ids using anaplan rest api? Using rest api i can export workspace /model/files IDs etc however i cant seems to find any unique keys for modules /line items . Surely there has to be unique IDs for modules / line items behind the scene . Thanks
Consistent columns headers in model history
Description Currnently, the columns headers seen in model history are dynamic and change depending on what is in the history. We would like the column headers to be consistent and not change depending on what is in the history. Example of Enhancement All column headers remain the same, regardless of the content. Benefit /…
Anaplan Connect Error - Process
Hi team, I'm trying to use Anaplan connect to run a Import process but my script is incorrect. I attempted to modify my working import script per the instructions in the Anaplan Connect guide (pg 27) but it is not working Below is my script and error, any help would be appreciated!
Simple Import failing and cant see why
Hi, I have a saved view in one Module in Finance Model and it has about 20 fields, one of which is Unique called 'NPD Ref Code' I am importing this view into a list in NPD Model, using 'NPD ref Code' and selecting 'Name only' It is giving me an error on a record "New property combination found but name or code already…
need to do a look up formula
Hi, I need to do a lookup in my line items so that I can import the data into a module. I have a flat hierarchy factory list. I have 2 line items Inbound Qty and Lot Numbers. I've split them so that I can see: Factory 1 inbound Factory 1 Lot Number Factory 2 Inbound Factory 2 Lot Number I'm not sure what formula to use in…
Importing forecast numbers with forecast version and time scaled into a module without forecast vers
Hi All, I am trying to import forecast numbers from one module having forecast versions(list) and Anaplan time into a module only with time-scale. The idea is to have a page selector(forecast) in the target module and when users select the respective months ,they should be able to see the numbers forecasted in that…

Importing and Exporting Data

Discussion List