Importing and Exporting Data

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…
Level 2 Conclusion Issue on Importing data DEM04 to DAT02
Hi Anaplan Community, I am facing an importing problem. Although I think I'm doing everything as it should, I get an error message every time. I have attached all the pictures and it can be seen that I must be doing something wrong with time mapping. But I couldn`t make it. I really appriciate your help. Thanks in advance.…
Level 2 Sprint1 1.3.10.3 Import Data into G3 Location List
The expected result is : But the result I got is as below : Can anyone please help me why my result is not as expected exactly? Do I need to delete the rows I have highlighted to get as expected result?
Import and export data treasure hunt
We're restructuring the Import and export data section of Anapedia, and we'd like to find out if our new structure is intuitive. Try our imports and exports treasure hunt and see what you can find! The exercise finishes today, but if you have a spare 5 to 10 minutes, why not have a go?
Level 2: Conclusion Create Inventory Ordering Saved View and Export
For creating the export and saved view for Inventory Ordering, my beginning inventory is different from the data given by Anaplan to check. This is due to the data imported while attempting my Sprint 3 exam to update Submit Purchase Order Request? So shall I delete the data imported to match it to the exported data? Kindly…
Level 2 Activity 2.3.9.1 Import data into DAT03 Historic Volumes module
Hello there, I came across one error when I deal with activity 2.3.9.1 Import data into DAT03 Historic Volumes module at level 2 ( refer to Process failed error.PNG). I have made sure that Actions -> Import Data Sources is correct and updated ( refer to Export.PNG). I have also verified the Source Model ( Source…
Hiding or removing the line item (on the 1st line) of an export from a module
I am performing an export from a module and the user of my export wants to have the extract so that the line item name is not appearing at the top. The line item is sitting on the "pages" dimension on the "pivot" view. In the layout tab, I have it set to: Grid Current Page Omit Summary Items Omit Empty Rows However in the…

Importing and Exporting Data

Discussion List