Importing and Exporting Data

Import current month data
I already have previous month data. Now I want to import only current month data. Please assist.
Number are being imported as thousand instead of decimals
Hi! My numbers are being imported as thousand instead of a decimal number. But in my blueprint, the number is set up to have a decimal delimiter as dot, and thousand delimiter as comma. and those are the values that should be entered. Does anyone know what is happening? thanks.
Export selected list members
I need to export only few list member details. Can someone suggest which will the possible way to do so?
Selective List Export
Can you please tell me is it possible to export particular two List Members and corresponding Line Items?
How to add filters to data export?
Hi Experts! We need to export only a small set of data from Anaplan modules (Ex: Export only ACTUAL data for 2017.05 for LINE ITEM 'REVENUE'). Please suggest if this is possible using standard functionality.
About the imported display method
Import to dashboard using anaplan connect. I want to display only items that have been imported and entered Is there a way to automatically display only items that have been imported and entered? Can you filter automatically? I'm worried about setting the line item formula or setting the filter. I would be happy if you…
Clearing/ updating old records while uploading data into Anaplan without knowing what to clear?
Hi All, I have an issue which needs to be addressed for a client. I do have a solution however would like to reach out to amazing community and get a different viewpoint on this if possible . Problem statement : we need to clear an item from a module however there is no simple way to identify the item to clear Below is a…
API customising for UPSERT ENDPOINT
It is required for the deployment of the UPSERT EndPoint as part of the Anaplan API to send only the new and changed entries from the SAP system to Anaplan instead of sending each time the full load file. We are currently trying to get Data from SAP via CPI( SAP Cloud Platform Integration) and we are facing this challange…
Anaplan Connect 1.4.3
Hi, Is there a way to configure the format of the dump file from tab delimited to comma separated values? In addition, is there any documentation that has a list of all the error messages that can occur within the application? I looked on the Anaplan Connect guide and whilst there is a small "troubleshoot" area, it seems…
Option to delete multiple saved view in one delete action
Hi Anaplan Team and community members, I think It would be great if we have a option to delete multiple saved view in a module in one action. Currently I am having a module with 321 saved view out of which I have to delete 167 views one by one which is consuming a lot of time. With a multiple select and delete option ,…
Automating Import from csv file
Hello experts, We are looking at scheduled import to Anaplan through custom integration and I have a question around that. Context: There will be a csv file provided on a server periodically and the import needs to be automated. 1. I read that it it is only once I manually import a file to Anaplan, that there can be an…
Is there a way to lock a period when doing imports?
I have done dynamic cell access to lock periods in a module. This is working fine when doing direct input to anaplan. But when using import function, even if access is only ready only data is still loaded in Anaplan.
Add all error types and description to Anaplan Connect User Guide
It would be a great addition to the Anaplan Connect User Guide to have all the different types of error that could be dumped whilst using the Anaplan Connect client to run actions/processes in Anaplan. It would be particularly useful for users not familiar with Anaplan (IT teams that manage the scheduling on behalf of the…
Model ID to display in Imports tab
It would be good to see model ID as a column in Actions->imports tab somewhere near Source Label & Source Object. I faced a specific issue when the model has a lot of imports, which were developed during a long period, and during this period, the source model was several times moved/renamed. Then it is nearly impossible to…
Scripts and Java and MS Access
Hi, I have an overnight script that imports data from an MS Access query into a list, this worked fine with the old certs and the 1-3-3-3 environment. Now I have had to update my scripts and use 1.4.2 and there seems to be a problem with the url. Old script -jdbcurl "jdbc:odbc:EPOS" -jdbcquery "SELECT * FROM qry_EPOSLive"…
User Information
Hello, I am trying to create a model that pulls all the user information (Model roles, First Names etc) from each model in our system. This is really useful for Auditing purposes. Is there any way to import from the user lists in model settings to this model, or alternatively to create a dummy module in each model which…
Continuously polling and downloading data(every minute) from operational model
Hi All , I have a requirement to continually poll(every 1 min) and export data from an operational Anaplan model . I expressed my concerns about locking / slowing down model therefore to test it out i wrote a script which runs every min and downloads data from an operational model . Data to be downloaded is relatively…
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…

Importing and Exporting Data

Discussion List