Importing and Exporting Data

Export Inquiry
Hi, Hi, I would like to ask if Anaplan has an option to export data in this format? The client requirement is that we can export data in this format so they can load it to another system. I have tried the export definition txt file and it is not the same. Appreciate the assistance Regards,
importing data about time
Hi. When I import data and map. I have to unify the time format(like below) or not?(there are Y-M-D and D-M-Y)
Anaplan Connect 1.4.2 JDBC export: Could not connect to the database
I'm trying to use the new JDBC export in Anaplan Connect 1.4.2, but I get the error "Could not connect to the database. Retrying in x seconds." I'm using a connection string identical to what I use for JDBC imports, so I know that's solid. Additionally, I am using integrated security, and I do have sqljdbc_auth.dll in the…
Informatica Cloud: using Hosted Agent with Anaplan connector
Informatica connectors typically give you the choice between 2 types of runtime options: - one or more secured agent(s) that run(s) on a managed server - a hosted agent managed by Informatica that lives in the cloud The feedback I got from Anaplan was that the Informatica Anaplan connector is only compatible with the…
Insert item to dimension via Excel Add in
Good afternoon all, Iv'e just downloaded the Excel Add in V3.2 . I have managed to create a tab based on the view on my module. The module has my numbered list 'expense' as dimension + several line items. The objective of using the Excel Add in would be to enable the user to manage their expense as well as adding new ones.…
importing duplicate data into list
Hi. I want to import duplicate data into list like below. When I imported, data which is second same data was rejected. How can I do this? projectA (parent)----employee1、employee2 (child) projectB----employee1、employee3
FIND MULTIPLE DELIMITERS
I am trying to take a 3 part Unique ID with delimiters and separate it at the delimiters. I can achieve this for the first 2, but not the last part. ex: 123-0542-236541 LEFT(NAME(ITEM(LIST)), Delimiter in Item Name - 1) = 123 RIGHT(NAME(ITEM(LIST)), Delimiter in Item Name) = 0542 Delimiter in Item Name = FIND("-", Item…
Import file with several sheets
Hi, I have a module where I have a number of line items and two lists as dimension. One as rows and one as page selector. I want to build a function to export all data from that module, edit it in excel and then import the same file again, and hence get the values updated in Anaplan. Now to the issue: When the file is…
Import to list with default value
Hi, I have an excel file that needs to be imported into Anaplan and update a list. However, I want all the new list-items to be part of a subset, which I want to set at the same time as I import the list. I do not however have any column in my import file to use for setting the subset (that is, a column that says TRUE to…
Add Search Field
Add a search field when setting up an import source from another Anaplan model. Currently, we have to scroll to look for the desired list, module, or saved view.
File Import Error: No Value Loader exists for this type: NONE
Hi Everyone, I am facing a issue which is: My source is: .csv file Target is: Module (Importing into 8 line items) Line Items: Format Lift% Number Volume Status List formatted Activity Type List formatted Activity Cost Number Display Type Text Display Cost Number $/unit Number Select Scenario Boolean The file format &…
Automatic Mapping - Not Working
The names are not getting mapped automatically, is there an order issue or is there anything else?
Hierarchical structures from a customer provided list
we all understand the traditional way of building a hierarchy normally following a top down approach. We sit with a challenge requiring that the hierarchy needed to build up from the bottom up using a lowest level reference code. As per the attached picture. Each lowest level will have a specific code identifying where it…
Importing boolean from Informatica for List subset
I am trying to populate a subset using an import triggered through Informatica. Here is how the import is set up in Anaplan ("SS PortCo in Hierarchy" is the list subset): Screenshot 1 Now from Informatica standpoint, every record captured by the query needs to be added to the subset so I am using a hard coded expression…
How to convert Date to 445 calendar week
Hi All, The requirement from the client is that they will upload the sales history for an SKU by date into Anaplan. Hence there will be 3 columns SKU, Date, Quantity. The model calendar is set as 445 calendar and the end of fiscal year is last Sunday. The problem is I want to convert this flat upload so that I can…
Hierarchy change
Hi All, Wanted to ask for a best solution of this question if possible. I have a process hierarchy which consists of 3 levels, and I need to extend it by adding 2 more levels between levels 1 and 2 (so whatever is on Level 3 now should go to level 5, and whatever is on Level 2 will be transferred to Level 4). What is the…
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…

Importing and Exporting Data

Discussion List