Importing and Exporting Data

Anaplan Connect- export file with different versions
Hi, I'm trying to create an Anaplan connect to export an expense forecast file monthly, but don't know how to write an export script so that every time I run the bat file, it can export the latest version forecast. For example, in Jul, we did a Q3 fcst. I created an export action, the script is: set Operation=-export "the…
Error on Importing a list item
Hi Experts, Could you give me a clarification for this error? There is no detailed explanation for this. What does this error stands for?
Trying to map data to a line item from a list
Hi, I'm creating an upload into a list. I've then created a module that looks back and returns the values from the list. I need to be able to map certain factories to certain line items. So if my factory is 1 then i need the line item to be returns from another module with a certain heading. The reason I can't use a…
More than one value for non-numeric cell
Hello everyone, I am having some trouble with the model i am currently trying to build, i am trying to import, into a module i created, a file containing a table (in an CSV format of course) with two columns : The reference and the description of those references, so i created two line items (reference, and model…
Create a PDF/PPT Template in New UX to allow customers to create dashboards for exports
Let users create specific dashboards for PPT presentations or PDFs. Doesn't need to be a new board/worksheet, just a specific report that generates and export
Import User List into the model in Deployed Status
Being an Anaplan admin, I would to be able to upload User List into the model in Deployed Status following general approach of imports from files (with ability to upload .csv file). Currently, the only way to do it is to check the import in the system as "Production Data", re-upload source file directly in production model…
Anaplan List Import Error - "Property-based hierarchy import has disallowed duplicate properties..."
Hi there, I have spent a significant amount of time now attempting to get a simple import to work between 2 existing lists for the 299 case study. I keep receiving the error "Property-based hierarchy import has disallowed duplicate properties for given key in target data - cannot proceed". I have attached below an image of…
Anaplan Connect 1.3 Inquiry
Hi, I was just wondering where can we download the Anaplan Connect 1.3 version? I was able to do that using the pdf file I have but now I can't seem to download it anymore. Appreciate the assistance Regards,
Issue on import from module to module
Hi I have a module with Product List, Region List, Time by month and Line items. I am trying to copy the data from Line Item A to Line item B within the same module and it works fine when I do the mappings by column. But when I choose 'Ask each time import is run', it is tripling the data from Line item A to Line Item B.…
Period Mapping error while importing data between Module
Hi, Import data Between 2 Modules, I have been getting error for period mapping. Please let me know on what needs to mapped for time period Note: Here Time range is been used. and Time Scale is Month Thanks Asha
Hierarchies with numbered lists
I'm trying to create a list where: (a) There are two levels in the hierarchy, let's say "Level 2" and "Level 1", where Level 2 consolidates up into Level 1; (b) Level 2 and Level 1 are both numbered lists with a display name property (c) The members of the lists will be added to over time, and I want to update the members…
How to throw an error when all fields are not populated in a DB and user clicks a button
Hi, I have this table in this dashboard where a user needs to enter in these mandatory fields in order to save this data into a "history log", which is a separate module. How can i make it so that if all three of these fields are not entered in, when the user clicks the save button, it will throw an error? Right now I have…
Dynamic Cell Access and Copy Branch
Copy branch is widely used functionality with multiple use cases. We can copy a whole nested hierarchy with just a single click. Currently there is limited way to control what exactly will be copied... By default it just copies everything. Can we control that? We can remove write access on a module level and it is working…
Anaplan COnnect Inquiry
Hi, I just want to know. If your transporting data from 1 model to another using Anaplan Connect API. How would you be able to do that? I am familiar with the Anaplan Connect API importing csv to Anaplan Model base on the script below. I checked the documentation pdf of Anaplan Connect and there is an option there for…
Script to export General List
Hi I am looking for a way to programmatically export the data from a General List to my local server. Any help here would be appreciated. Thanks Regards Prabakaran
Change the name of Excel Sheet during export
Hi all, I search to replace the name of Excel sheet when I export data (by default "Sheet 1") Someone has already done that ? Thanks in advance for your help!
Defining the default file for imports
Hi Is it possible to specify a default file for some import actions in Anaplan, so that whenever the user clicks on the action, instead of asking the file to upload "choose files", it automatically looks at a specific place for a specific file and runs the import?
How to bring in previous balance into current module? Or how do I bring in a rolling balance forward
I am creating a balance sheet. I am hoping if anyone can show me the best approach. I have two module. Previous balance module and current Balance sheet module. My previous balance module have no time scale. I want the previous Ending balance in my current module. I attached 2 screen shot to show you what I mean. When I…
Adjust Imports View
Hi team, I'm trying to adjust the view of the Imports tab in the Actions area so that all the text is visible. Currently the columns are a fixed width & I cannot adjust them. Likewise I am unable to extract the data to view it in Excel (where I can adjust columns etc) Anyone know how you can view all the data in this…
Script Update Current Date
Hello, I've read through the boards, and unless a topic is well hidden, I have been unable to solve what should be a simple solution. I have two issues: A) I am unable to write ("copy") a script from previous posts to update the Current Date line item in my Current Date Module. I created a process on my computer to update…
What is Branch?
Can someone explain in a simple language of what is a Branch?
Import to time based module with "ask each time" time selection
Hi! i have met the following issue. There are two modules: - Target Module: Time based (Year) - Source Module: no time dimension when doing import , I chose "ask each time " option for time dimension , and during import run i select that single year which is presented in the module. the import is running successfully but…
Import - Values inconsistent
Hi, PLease see details on the attachment. Regards,
Questions on Data Hubs and how to have Peak Performance?
All, Please check out my new article on Data Hubs: Purpose and Peak Performance. If you have any questions, please let me know. Link here Thanks, Rob
Anaplan Connect Using Linux Script(Certificate Based Authentication)
Hi Team, I am working on Anaplan Connect on Linux Platform tried run with credentials it worked, however, i am unable to run with certificate authentication. Getting an error" -certificate is unknown token" Please find the below code. #!/bin/sh # This example uploads a file and runs an import…
Direct link between anaplan and microsoft analysis services cubes
Hello, Does anyone now whether it is possible to either import or export data directly into a microsoft analysis services cube through the data utility tool? best cheap cordless vacuum thanks iosman
Export configuration
When I export a module with a layout: Grid, all Pages, I get 1 excel sheet per item from my list in page which is the result I want, My only issue is that the excel tab is generic whereas I would need it to have the name of the item in the page, Is it Something that could evolve?
Data Upload Metrics
One of the most common questions I get, regarding uploading data to Anaplan, is what the optimal chunk size is. This post will review my results for file uploads using cURL, Informatica, and Anaplan Connect v1.4. First, a bit of background on chunking. Files in Anaplan are stored in chunks (unless under 1mb, the minimum…
importing data into list item
Hi! I'm taking a lesson list's course which is before 102 and have a question about Central Library(list import). I imported the data of Employees.csv, following the guide, but unlike the guide, error occurred. So next I filled in all source blank like photo, then I imported successfully. Why error occurred regardless of…
Sharing Lists Between Models
Is there a way to share lists between models? We use a number of different models all for the same company which uses the same structure - and it would be really handy if it were possible create a 'shared' master list(s) in one model that could be referenced by all the other models.

Importing and Exporting Data

Discussion List