Importing and Exporting Data

List Update Behavior - Manually Add an Element vs Import the Element
Hello, I have noticed a behavior on the list updates and I am not sure if this is normal, or is it something I am doing wrong. I have the S2 Supplier list that is updated by users, based on a module, where they enter the name of the supplier and the parent. Next an import action is run to update the S2 Supplier list based…
Import Issue (simultaneous uploads by external APIs can not be recognized within Anaplan)
One of our major customer is asking this issue to be raised as an enhancement request. The issue that they face is summarized below: Import A (with 60,000 records) and Import B (30,000 records) will simultaneously happen from an external API action. Import A will time out, however upon completion Import B will recieve a…
Exporting a saved view
Hello, I've created a module with 2 lists and line items . I saved 3 views, in which i hided some line items of my module so the saved views are showing different line items of my module. I tried to export a saved view choosing 'Tabular multiple column' , I have in output a file with all the line items of my module and not…
Importing into module
I'm unable to replace the highlighted parts with the name of employees while importing. Can you help me to do it right ?
1.3.4.3 Update SYS07 Location Details Module - Issues importing data
Hi, While performing the step referenced above, the field Region does not upload. I think the reason is because the flat file "Countries" contain regions in the format "AMER, EMEA,APA", while the flat file "Locations" contain regions in the format "Americas, Europe, Asia Pacific". Im wondering if i am missing any step in…
Anaplan restful api uploads with zip files
Hello, I have a question about using the Anaplan integration API V2 guide. Is it possible to upload a csv document inside a .zip file to Anaplan? I'm able to manually upload a zip file with a csv in it, which works, but cannot figure out if its possible to do it with the API. I'm trying to do this with Postman but the data…
Updating Lists on Transaction Data Import
Colleagues, hi! I'm seeking your advice on the following case: on a weekly basis, there will be a transaction file with the unique "purpose of payment" texts for each transaction and potentially new suppliers that don't exist in Anaplan list yet. How can we achieve automatic update of supplier list upon import and having…
REV02 Import mapping Problem
i am trying to map Volume+Inputs file.csv data into module but Cant seem to get data map. Tried Multiple methods. But cant seem to find a way. If anybody can help then comment down. I m also attaching the problem.
Import action should not ignore Selective Access for a Workspace Administrator
Description of the enhancement required: Workspace admin with applied selective access to only one region had affected data in other regions because selective access does not work on Workspace admins. An example of the enhancement: As a workspace admin if I change my profile to only have access to a specific region, and…
Python and Anaplan: Pt 1—Setting Up Your Environment
Combining a scripting language such as Python with Anaplan can provide you and your team greater flexibility and functionality in your planning journey. If you've never used Python before, or want to check out some different ways and use cases of Python and Anaplan, look no further—this series of articles will introduce…
Mapping issues related to Activity 8.5.3
Hi, Need help in this Level 1 Model Building exercise. Though I did not get any errors after importing the data and mapping, the G3 Location Tab does not look right. Secondly, the pivot table in the line item view has to be changed. The volume needs to be before the Nutzo Bar. See mark up on Line Item screenshot (attached…
How to import a csv file into a module where the only reference is a single line item (text format)
Hi, Any idea how to import this csv file: into this module: The third column (PR Number) is in text format (8 characters truncated from the first column) and its not a list nor a parent/child of the first column (PR line). Parent of the first column (PR line) is something else i.e Material. I have nothing from Source to…
Initialize a specific dimension using another dimension from the same module
Hello I currently have the following problem : All the modules that constitute my model are run by a dimension "3 year Planning scenarios". This dimension is a list of different planning scenarios, each one has a different year of start as a setting ( initialized in a unique administration module) . What i'd like for my…
10.2.2
I am running into errors with this import please help.
Multiple import steps in a Process - merge file selection?
Using the same csv file, I want to be able to import to different modules and it will be seamingless to the users. But the "Choose File" button appears twice when I click on the button even though it's the same file I'm importing. Is there a way to show it only once? Thank you.
Export action not working
HI, I created an export button and used March period when I created the export action. Now I published the button in the dashboard. In the dashboard I selected period June and clicked the Export button. I was expecting that June period will be exported but the exported data is for March period. How do we sync the export…
Am getting an error while importing data
invalid date identifier have validaed the date formats in the file but import fails with same error
What's wrong here?
Source (Line Item Type is Number) Target (Line Item Type is Number) Import Action: Failing even after every possible mapping
Level1 exam activity 5
Hi, I am having issue on level1 exam activity 5. I have seen queries regarding this . I changed Role format text to list and given top level is All roles in the configure tab.But still showing zeros (Bonus,car costs,phone costs, medical costs).I dont know where did i the mistake.i will share my screenshots.can anyone…
Why characters get garbled via model to model imports
Hello, I hope you are all doing well and good. I have a situation here. When I upload a text file(with special characters) to Model A's list and then import the list data from Model A to Model B, characters get garbled in Model B. text file -> Model A ***text encoding: Windows-31J(MS932), Totally no problem*** Model ->…
Statistical Forecasting algorithms into a user specific model
Hi - I am new to Anaplan and I have a quick question: Let's presume we are to develop a supply chain demand planning module for a client. Since we exactly know what all lists/line items are needed along with the hierarchy and the calculation formulae for different line items, I prefer to have that developed everything from…
2.3.8.2 Import into DEM01 Module
I seem to be having an issue uploading my data into this module. The module is set to month, yet when I try to set the import period, it is in weeks: Separator can be any non-alphanumeric character Y represents year number (1, 2 or 4 digits) W represents week number in year Further, entering a custom format of YY?MMM to…
8.5.3 Activity: Different data problem
Hello all, I am working on Level 1 activity 8.5.3. I imported the file without any problem but my numbers are different from the screenshot given by the course module. Could you please help me with that? Merve
Change import default name while setting it up
It will be good to have ability to change an import name the same time when you first create the import. For example, having a special field on import setting window, like in screenshot.
DAT05 Historic Revenue by Product
Hi, I'm trying to import historic quarterly 2019 data into the DAT05 Historical Revenue by Product module, but the time settings does not allow for me to select Quarters in the Time Scale column. Do I need to adjust the Time Settings for the Datahub model or is there something else I'm missing? Any guidance would be much…
Regarding Current version
Can current version be updated in Prod model after applying ALM through an import process?
Not able to run Anaplan Command through Talend Server (But the command is running fine through Local
I executed the below command through talend remote server java -classpath /home/talend/properties/eur_finance_bi/anaplan/anaplan-connect-1.4.3-jar-with-dependencies.jar com.anaplan.client.Program -k /home/talend/properties/eur_finance_bi/anaplan/<jks file path>.jks -ka <keystore> -kp <keystore password> -workspace…
Export in Anaplan API - What to do next?
Hi everyone! I'm new working with Anaplan and also with APIs. i've been managing it quite well but I'm stucked in one step hope you can help me overcoming this. I've already get al chunks of the export however I don't know how to download the data... the file exported 26 chunks and I get chunk id 0, 1, 2 and so on. So the…
Add comment field to a Time dimensioned module
We have a process that users import data via Excel to Anaplan. The file format is shown as attached. The business would like to add a comment field at the end of the column for each project (see screenshot. the comment field is just a mock-up on Excel and does not exist in Anaplan yet). To add a comment field in this time…
Add preview view and customisation options for exporting dashboards to PDF
The ideal scenario would be to have an interactive "export dashboard" dialogue box, allowing users to make basic layout changes to PDF exports of dashboards. With this, a user could preview the PDF before export, and make basic layout changes such as changing column widths (or just bringing the column widths already set in…

Importing and Exporting Data

Discussion List