Importing and Exporting Data

Import Final Demand Forecast into DAT02 Module
Good Morning, While doing this activity in the Conclusion course, I got stuck Indeed, they are asking us to Import the Demand data into the DATA02 SKU Volumes module. But in the Level 1 model, there is not a module called data2. So do we have to create this module? If yes which line item, what to put as page selector, rows…
Level 2 - Conclusion: Export data from INV01
I am currently working on the Conclusion for Level 2. When preparing the export saved view for INV01 Beginning Inventory, I noticed I have significantly different numbers in my module as compared to the example .csv and the screenshot from the course. I am wondering if there is something obvious I am missing, or if I need…
Import error: invalid name
Hello, I am trying to run a import into a list in order to update the item code as per what the user inputs. However I get this error: This is the module view I am importing . I want "New VAT Number" to be the new item code: Here is the action: What is wrong? Thanks, Luca
Invalid Parent when Importing into List
Hi! I have this list called Strategic Customer. I have a module based off this list called Strategic Customer Details. the parent hierarchy of this list is Strategic Account Owners. In the module, I have a line item to choose a different Strategic Account Owner for a Strategic Customer. The choose new SAM line item is…
getting Error while importing a large file which was successfully uploaded few days ago.
Hi Anaplanners, I am getting error while running a import action by uploading a large size file. The same file was successfully uploaded with the same action 3 weeks ago. I have tried all the ways:- tried after by clearing cache and cookies tried to make new import action with the same file. restarted my system and…
Random number generator
Is there a way to generate random numbers from a defined range of numbers so that the numbers being changed regularly in a module every time we refresh the model or just run an action?
Actions Used in Pages
Currently we can find , In which Dashboard the Process and actions were published by referring "Used in Dashboards" column in Actions tab. Similar to that, we shall have "Used in Pages" column so that we can find in which Page(s), the given process or action was published.
Selecting the Time to import data from other model - edit prompt
Hi, I have an action to import data from one model to another. When press to start this action I have a prompt page to select the Time, it means I need to choose the year of the budget that I want to import. The year that I need to import does not appear in the Time dropdown list of the action prompt. I checked the modules…
Incorrect decimal placement importing from csv file
Hi, I've noticed strange behaviour when importing into a number formatted cell in Anaplan from a csv file. My csv file is directly exported from a Workday report, and the csv file contains 2 decimal places for some entries, but some entries are rounded to 0.dp where the two d.ps are ".00". Anaplan is incorrectly putting…
404 error when using API imports endpoint
Hi! When I try to use the imports endpoint I only get a 404 not found error. The api documentation I have been following is I first noticed the issue when running this: https://github.com/qkeddy/anaplan-audit-history so I tried with Postman and I got the same error message. If I run a GET to the specific model or workspace…
2.3.8.2 Import into DEM01 Module
Hello, I'm attempting to import Volume Growth Rates.csv. When mapping the time (column headers) on the file, I select Periods, but there is no Y-M or M-Y option. I assume something is messed up that I'm unaware of. Any feedback would be appreciated. Sean O
4.6.6 Activity: Import Data into P1 Product Family List
What is the source P1 Product family, Parent and Code in 4.6.6 Activity: Import Data into P1 Product Family List and how it is mapped. Please help with the information.
Anaplan Informatica Hyperconnect
Hi Is Microsoft Azure Synapse SQL Connector for Informatica cloud available with Anaplan Hyperconnect?
HELP IN IMPORTING DATA
Look when i am importing weekly data in my INV01 when i want to map time with column headers Time (2019-12-29 - 2020-01-04, 2020-01-05 - 2020-01-11, 2020-01-12 - 2020-01-18, ...) this shows up but data in my 'csv' and 'inv' in form of WEEK 1 FY20 but in mapping dialog it shows Time (2019-12-29 - 2020-01-04, 2020-01-05 -…
SAP integration
Suggest to build native integration with SAP solutions. A lot of Anaplan customers use SAP solutions such as SAP ECC, S/4 HANA, SAP BW etc. and heavily depend on large amounts of data flowing back and forth into Anaplan. Integrating with these solutions often require an extra layer such as AWS or similar which then again…
Import error (parent item has a child item that is in a different list)
Hi all, I'm getting the following error in one of my import: Import into Hub_0_Product_Group Marketing L8 # list failed: Parent item has a child item that is in a different list: You can only add a child to a parent item, if any existing children of that parent item belong to the same list. Do you have any tip/advice to…
7.2.3 Activity: Import Data into Employee Details Module error
Hi team, Missing out some step data while mapping, data was updated successfully attached screenshot (12error), however data is being uploaded with ignored values. Do I have to make any change in the module section? @noelle_murphy
Allow filtering of tabular multi column exports from transactional api
When defining tabular multi column (TABULAR_MULTI_COLUMN) exports from the UI, you're allowed to specify a boolean line item to filter the results. This functionality is not built out within the transactional API. The API documentation alludes to this option being the case, but it is not supported. Without this filter you…
Mapping timescale during import and ignoring some columns
Hi I would like to know how do I ignore several columns from the source CSV file while importing data , where the first columns contains list and apart from several columns I want to ignore, Column headers are mapped to time. Attaching screen shots for your reference. In the source file attached , the first column simply…
Problem of inporting a List from Model to an other
Hello Anaplan Community, I want to import the same list from a model 1 to model B but I have this message that pops up every time. Can you tell me the reason behind this ? Thanks in advance !
Text format validation
I would like validation functionality for text formats in Anaplan. When entering names of products or items in Anaplan and importing them into external systems, import errors occur if the input contains strings that the external system cannot import. Having text input validation functionality in Anaplan would facilitate…
Clear an entire module
Scenario: If I am importing data into a module and a line item no longer exists in the source file, the Clear Before Import will not clear that line item as it will only clear line items that are coming in from the file. This can lead to numbers being off. Current workaround: Create a duplicate module that is filled with…
Import is zeroing out a field that it shouldn't be
Hi team, Got one that for the life of me I cannot solve. I import the below file and the numbers load as intended. You can see the imported numbers below and the mapping from the import The trouble I run into is when I run a second import. looking at the data im importing, there is no line going to CC 3602 and GL 65566,…
Import Scripts run successfully but target module did not update as expected
Hi, We're able to set up a scheduled import actions using Java scripts with certificate authentication and it appears to run successfully according to the import history, but the target module in ANAPLAN is not being updated as expected. It seems like it is still importing the old csv file instead of the new one. Also, we…
Set one column of source data as "Not Applicable" for this import
Dear Anaplan Community I am looking for a way to "ignore" one column of data from the source file as irrelevant when uploading its data into module. Source file contains columns as below. Column D is actually the code of Column C inside Anaplan model. And Column D is there because client wants visibility into expense type…
Is it possible to have an anaplan export automated having 2 dimensions in columns?
I am trying to create an automated export of a view that has time, as well as line items in columns. I have tried this via Cloudworks and Informatica but it is not working. When I am manually running an export in anaplan its working fine but not via integration.
Level 1 Exam - Model Building Activity 4 importing data into SYS08 Employee Details Module
Hi Team, I need your help on this data importing. I have downloaded the Employe Details by Role.txt file but, I see the data is not being mapped correctly into the SYS08 Employee details module. Downloaded CSV format : I have tried by converting CSV to txt format. Still the data is not being mapped properly while…
Issues with CloudWorks Integration
we have been facing issues with CloudWorks integrations from couple of days. Below are some of the observations: When a integration runs on CloudWorks on one of the model, the whole workspace gets stuck. Integrations are failing with no error logs. Getting notifications about the integrations failing but those actully…
Anaplan API 2.0 Python Library - [Updated March 2022]
* Getting Started * Gathering the Necessary Information * Authentication * Getting Anaplan Resource Information * Uploads * Executing Actions * Downloading a File * Get Available Workspaces and Models * Example Code After a significant amount of refactoring, I'm very pleased to announce the latest release of my Python…
Import Issues
Hi All, I'm currently facing two issues related to import. I have one module (split in three tables in UX) in which the user imports data. Here's the module: The import action works perfectly well for me but not for them. Apparently, the system is considering the comas as decimal separator while they consider it as…

Importing and Exporting Data

Discussion List