Importing and Exporting Data

Get the list of export files - Method not allowed
Hi, I am trying to use Anaplan API to run an export from a model in which I have FULL access. When I make the API call to get the list of export files, I received an error. The error code is 405 and the error message is "method not allowed". I made a research about this error and it seems like it occur when the user…
Getting Error on Model to Model Import
Hello Anaplanners, I am getting an error: 'Failed to retrieve field list from the selected data source. Please check your import settings and try again' while setting up a Model to Model Import. The dimensions are exactly the same in both the modules. Though few List Items in the Location list are missing, I feel its fine…
Need help with 1.5.7.2 Add Formula to SYS13 Line Item
Hi All, I am struck at this point. I have followed the notes carefully Add the formula for the Has Data? line item in the SYS13 Account SKU Filter module. Considerations for the formula: * How could you sum the data over all time periods? * All Periods is not an aggregation method at the model-level timescale. * The…
Level 1 Model Building SYS08 Employee Details Import mapping issue
When import Emloyees.csv into SYS08 Employee Details only 'Current Salary' and 'Commission %' fields get updated. other fields are empty. These are the steps I follow What am I missing? Thanks in advance!
Difficulty in importing level 2 Sprint 1 1.5.6.2 Import data into Historic Volumes Module
Hi, I'm facing difficulty in mapping Source row 1 to target time and source row 4 to target DAT03 and also to select which option in time tab. help me on this ,thanks in advance. I'm file with this
I do not understand why this is happening?
8.5.3 Activity: Import Data into Volume Inputs Module - Need Help with the mapping Mapping
Hi, I have got stuck with this mapping. Kindly help with explanation.
Percentage data to high when importing from csv file
Is seem to have problem with importing data for list items with type percentage. For example, in the Model builder 1 course i try to import data to list item Bonus % in the EMP01 Employee Drivers module. The format looks as follow: The data in the csv file is for example 0,12. So this should translate into 12% once…
1.5.6.2 Import Data into Historic Volumes Module
Hi Team, Please help me with this.my all imports are ignored. I Have attached a screenshot
Import Location List.
Good morning. I am trying to import the Locations list for the activity 4.6.5. "Import Data into G3 Locations List". The result is not as expected. Can someone please help me regarding the settings I should have in the Mapping option. Greetings,
Urgent: Can we copy a module into another model within the same workspace?
Can we copy a module into another model within the same workspace?
L2 Sprint 1 - 1.3.10.2 Import Data into G2 Country List
Hi @JaredDolich trust you can provide guidance here. What am I doing incorrectly here? Please share. Task request: 1.3.10.2 Import Data into G2 Country List In the Data Hub model, import data from the source saved view into the target list: Source: SYS06 Country Details module, Build Country saved view Target: G2 Country…
Is it possible for Anaplan to import data as "date" the format of which is like "28-May-13"?
Hello, Is it possible for Anaplan to import data as "date" the format of which is like "28-May-13"? * year: 2013 * month: 5 (May) * day: 28th I have already tried the following custom formatting: "dd-mm-yy." But this did not work out. Thank you very much in advance.
1.5.6.2 Import Data into Historic Volumes Module
Hi, Currently trying to import data into historic volumes Module, The datas are only going to the English products, i don't have any error messages when importing, could someone help me on this ? Thank you !:)
Level2 Conclusion- Currency Conversion
Given Activity : .csv file to be imported : When I am trying to import the above .csv file into the Country Currency list the data is getting imported as below: What mistake I am doing here I am not getting exactly. I need to get the import as below format as I have seen in the Anaplan community Anyone please guide me on…
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…

Importing and Exporting Data

Discussion List