Importing and Exporting Data

Using Saved Exports as Import Data Sources
I suggest implementing a feature where we can use Saved Export Definitions as Import Data Sources. Right now we can use a File or Connect to Anaplan Model - I would love to be able to select Saved Export Definitions in addition to current option of Lists, Modules and Saved Views. The natural place for this, in my opinion,…
AWS S3 Bucket Unique Identifiers
Is using the combination of properties function standard practice, when importing AWS data via Cloudworks or is getting a unique identifier added many times better? Currently the csv has no unique ID but I will push for one from my AWS admin if any examples can be mentioned. Its an AWS Detailed Billing Report with c14m…
Use setting grids as a model Import Dat Source
There are certain fields in the settings tables of a model that would be very useful to be able to easily import into a module for further calculation/model usability. The uses I have already encountered would be: * The 'user settings' table - this would allow filters and dynamic cell access more easily based on role, or…
DATA02 SKU: Invalid Parent Error Message
When importing the sku information, I am unable to locate the correct parent and it is throwing off my import for my model. Has anyone experienced this message? Also is there a guide on what chocolates, sours, etc there are? I have never seen the "Thats a Fine Howdy Do!" Product line
1.4.3 Activity: Create System Module: Product not importing in the correct column
Hello! Im wondering if someone can help me with this matter. I am trying to import the SKU list in this model but the product are not importing in the correct column. (see screenshoots attached) Everything else appears to have imported correctly. Please assist.
Level 2-Sprint 2 Import Historic data Action
Hi, I'm working on sprint 2, my model has successfully run action 9.1. the issue is that it's ignoring most of the data. Can you tell me if this is ok or should I modify something on the action import source Also attached is my Import structure Best!
Activity Record of List Members
Currently there is no ability to see a detailed record of the list members created after running an import into a list - you can only see that X number of members have been created or updated. Additionally, there is no record of the DateTime that list members were created. Including a Created Date and Time (UTC) column and…
Sort Lists greater than 1 million items
Order Lists is extremely helpful (https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Order-list.html) but we have a couple key lists that are over 1 million items, so Order Lists does not work for them. We are looking at around 11 million items for current year and prior year data. We have…
Actions tab -> Imports Tab -> Can we have the ability to export this data into an excel file?
Or can there be a way to combine the data on the Actions tabs with the Imports tabs to pull an entire listing of my Imports and Processes? I am constantly copying and pasting data from the Imports tab into an excel file so I can filter and find the necessary imports and where they come from. Especially after…
Required Account Flat csv,Depart ment csv,
Hi, i was preparing level2 to sprint1 ne but unable to find the account csv ,department csv etc.
Invalid Parent Error
I keep getting an invalid parent error and then manually having to select the parent after importing. I now have a list with 400 that have to be mapped to the parent manually. I'm not understanding why this is happening and how to fix it. For context I am duplicating a list from 1 model into another and have set up the new…
3.3.5.2 Inventory Ordering Module Formulas Shipping Method & shipping time weeks is not showing up
I am having trouble checking my formulas. My Shipping Method & shipping time weeks is not showing up and I think it is because in the SYS 08 SKU Details the distribution center is not showing up. It is showing up in the list but not in a line item? Why is that happening?
ALM APIs: This is how we use it
Application Lifecycle Management APIs (ALM APIs) were released earlier this year, and their purpose is to make model change management more scalable, automatable, and integrate with other systems. We have seen the ALM APIs being leveraged in 3 distinctive ways: * to orchestrate and run multiple model deployments (model…
Level 2 - Sprint 1 - 1.3.10.4 Check Your Work- Output not matching
Level 2 - Sprint 1 - 1.3.10.4 Check Your Work - Output not matching After completing the import processes, the G3 Location list in your Data Hub model should look like this example: My saved - Build country looks like this Expected output as My getting output as Please help with the resolution of the issue. Regards Srini
Level 2 : 1.3.10.2 Import Data into G2 Country List
Level 2 : 1.3.10.2 Import Data into G2 Country List I am trying to import data as per the instructions but i am getting Screen shot 1 : Screenshot 2 : My saved view looks like Please help for resolving the issue please. Regards, Srini
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…

Importing and Exporting Data

Discussion List