Importing and Exporting Data

7.2.4 help needed
I cant seem to remove the entry (sales) in the department row so that it can reflect exactly what was given in the example. Please how can I resolve this?
Level 2 Run Process 9 Import Data from the Hub
Hi, I am stuck at the Level 2 Run Process 9 Import Data from the Hub. Can anyone help me on this.
Mapping Issues due to dates
Hi, I'm currently having mapping issues with the current Flat File I'm trying to load into Anaplan. It is saying it can not match up the dates, but I'm hoping I will not have to manually change the dates on my flat file verses getting a way for Anaplan to read the dates to map the data. Please advise. Thank you
SYS08 Employee Details module (Importing Name issue)
Hello Everyone, I am unable to get 'Names' in the following module but the rest of the items seem fine. Anyone can help Please? Thank you in advance
Importing Data - Parent Error
Please view the screenshots attached. I'm not sure what I am doing wrong at this point. I know that it should be mapped Location Name, Country, and Location Code. But I keep getting an invalid parent error. I've toggled between items uniquely identified by options and continue to get an error message..
Using Anaplan as Source in SSIS
I need to Get data from Anaplan and import them into a SQL Server using Microsoft Integration Services (SSIS). Does Anaplan support it? (e.g. WebService)? If yes, who can provide me the WSDL File?
parent-child hierarchy
Hi I am having two lists(A & B) , where list A is parent of list B. In list A there is a list item "Miscellaneous" which code is "MISC" In list B there is a list item "Miscellaneous" where parent is "Miscellaneous" in list A and code is "Miscellaneous" While importing the list items into list B with code, the item…
Warning while loading data into list
Hello, I was trying to load the data into a list from a saved view that has multiple duplicate values. The file has been loaded successfully but with a warning "Another row has already been processed with this key" I want this warning to be removed how can I remove that please help me with this? PFA the screenshot.
List import error : Top level of item
Hi, I want to import List from module. I have this type of List(▲test) , has top level of item. I want to import from this module. But when I tried this, I received error message. This message says that List_All has failed. I tried restrict the level of items and hide top level of item, But I cannot solve it. Do you have…
7.2.3 Help
How do I get the codes to not show up in this exercise? I know that from the example, commission % should be the last row.
Transactional API tutor
The purpose of this Transactional API tutor script based on Python is to facilitate the learning process of Transactional API Calls using the Anaplan platform. This version contemplates the most common Transactional API calls until November 09, 2020. Download the Python Script file using the file attachment located to the…
Import complete but with failures
I am trying to import the countries list (CSV file) into the G2 Country List. When I ran the import this is the result I receive. Anyone who can guide me?
2.3.9 Level 2 - Sprint 2 Import into DAT03 Historic Volumes using actions
For 2.3.9.1 nothing is populating whenever I run Process 9 Import Data from the Hub. I didn't even get an error as most did, it's just zeros. My data hub numbers are there but nothing happens.
8.5.3 Activity: Import Data into Volume Inputs Module
Hello everyone, I am getting an error when trying to import data into the volume modules. I'm pretty sure I'm doing something wrong with the time source--->target column. (see screenshots attached) Thanks in advance!
Allow user to choose time format on exports
When exporting, different scenarios will give you a different format for time. This would be an option within the Export dialog, similar to how you select the date format when importing a file. Specifically, exporting with two dimensions on columns will give you the date format MMM YY. This can cause issues in other…
Import write access to List
Hi, I want to import write access to Lists. I have this type of table. UsersCustomeraxxx1,xxx2bxxx2,xxx3 But the List item is shown by #1,#2 in User setting. How can I import to List? And I want to set the write access to combination List. Now if I set this write access. UsersCustomerProductaxxx1,xxx2yyy1bxxx2yyy2,yyy3 I…
L1MB- 7.2.1 Help Please
I'm very close to the desired result but I cannot figure out what I am doing wrong. This is what I got after mapping:
Workflows
Dear Community, I am using Talent Builder Workspace, where I have access to create My Pages. I am trying to sync up workflow module to actual workflow status defined in lists in My pages, But I am not seeing a provision of imports in the new UX. Any thoughts, how can I resolve it? Thanks
Level 3 sprint 1 - 4.6.4 activity
Hi I have imported the data for 4.6.4 activity however it is showing as numbers instead of product and I have also chosen the display name as display under general list property. Initially display name was there but now after chosing P2 product list as display name , it has gone blank where I am going wrong?
Ability to include a Line Item in a Line Item Subset via an import process
Currently, the only way to include a Line Item in a Line Item Subset is to manually go into the Line Item Subset and check the Boolean to add it. What I'm proposing is the ability to import into a Line Item Subset's "include Booleans" so that one can include/exclude Line Items from a Line Item Subset based on a Boolean…
Level 3 Model Building (Importing Module data into List from Data Hub)
Hi, I'm having problems importing data from my Level 3 Model Building Data Hub into the other Level 3 Model's List. I need to Import that from my Module SYS14 Create Account> Product into the List A2 Account>Product. I created the LI's in the Module in the List as Properties, but I'm having trouble pulling in the data from…
Headers in export files
When Exporting files from Anaplan I would like the possibility to remove the list name from the header when adding properties properties in the export file. Today I can only choose Include or exclude Row Label headers. I would like to have the possibility to exclude the name of the list in the header. From above export I…
How to perform activities while starting as a beginner with no application on the system?
Could you please help how do I get to access the application hands on for practice and further to perform activities to answer the exam questions through my system LIVE. I'm a beginner trying to give L1 exam. I have completed entire course theory with certain practical activities yet to be practiced. Any help is highly…
4.8.2
I've been having an issue with locating my error in the model for the Parent Error I keep getting everything is mapped out correctly and I've literally lost 2 days trying to figure this out it's not because of lack of effort. But now I fear I won't have my lessons done in time to stay on pace to finish. I really need some…
Retrieve more than 1000000 cells using anaplan API
Hi Everybody, I am trying to automate some task by retrieving data from Anaplan using the Anaplan API. Seems like the maximum of cells we can retrieve using the API is 1000000 cells. Since I have a lot of models that have more than 1000000 cells, I am wondering if there is a way to get the data by chunk or any other way.…
Level 3 Sprint 1 2.2 importing Baseline Financial Forecast Data
Hi all, I know that there is a ground rule saying that level 3 model building should be and only be done personally, but I thought asking some help on import error could probably slip through this rule. I'm getting some error when importing the CSV file < Baseline Financial Forecast.CSV> provided by the course, error…
Translation of time list for views and exports
Recently I've been working on an implementation of Anaplan to a non-english speaking customer (portuguese in my case). As part of that journey I was very pleased with the fact that in the data imports Anaplan can translate time from different excel languages into the standard time list - in other words months in Excel…
Current Day
Actually we have a module that includes a column with dates, and we want that Anaplan identifies if a date from the column has passed or not yet. For that we have created a line item, and we would like the logic behind the formula to be something like this: IF the date (from the column) is prior to the date (current day)…
L2 Conclusion Import Currency Error
I am trying to import Currency List but somehow it doesn't work.I am stuck at this activity. I am also attaching the screenshots of Error. Don't know whether its a mapping issue or something. Also I tried mapping via Name or Code but still it doesn't work.
Default Export Excel Format
Hi, I am keen to have the default export to excel option changed to the xlsx version rather than the 1997-2003 xls format. While I know you can change this when exporting it would make sense to have the newer version as the default to allow for quicker exporting. Surely 99% of users would prefer it in this format ? I…

Importing and Exporting Data

Discussion List