Importing and Exporting Data

Custom scripting line item calculations
I would love a way to be able to use my custom python scripts and the vast amount of Python libraries on line items in a module, rather than use the Anaplan formulas out of the box. It would save time on export/import data to the Anaplan model. I'm assuming the formulas that are used now are some form of Java or C++? Maybe…
Level 2 - Sprint: Activity import Data into DAT03 Historic Volumes Module
Hi guys, I've been trying to inport the 'Historic volume.csv' to the DAT03 Historic Volume Module for the past 2 hours. I already watched all the videos about importing data to module, etc. But I keep receiving this error, "invalid line item identifier", and I don't know what else I can try. Could someone give me a hint?…
Get metadata for import action returns the target line items instead of File headers
Hello everyone, We were looking to query the mappings of a file that was being uploaded in the model through the endpoint of get metadata for import action. the link Anaplan Integration API V2 Guide and Reference · Apiary suggests the below statement: " You can use the API to obtain metadata for an import definition for…
Recent Data Export Format Change
Hello, The data exported to excel from a module has recently had formatting changes. As of today, when I export a module from a dashboard it appears to no longer have formating. I think this could possibly be related to the maintenance performed over the weekend (05/14/22). Has anyone else noticed this? Will the formatting…
Get Import ID from Anaplan
Does anyone have a guide or can provide assistance on how to get the API ID from Anaplan from a model?
Not getting Task Id while running API call(Export Action)
Hi all, I am using python for integration. After authentication part, I got Export Id through API call. Now using that Export Id for getting Task Id with API Post Method : headers = {'Authorization': 'AnaplanAuthToken %s' % token, 'Content-Type': 'application/json'} data = json.dumps({'localName': "en_US"}) response =…
Clear Large Amount of Data
Good Afternoon, I hope someone can help, so far it has taken me over 2 hours to clear out a large amount of data in a module (more than 500000 cells). Is there any quick way of doing it? I still got 7 more to clear data from. For some reason when importing data in Anaplan, it did not clear out all data before the import,…
SYS06 Sprint 1 L2 Mapping Problem
Please help , I am not getting the desired result.
Review SYS05 Region Details Module
I am not able to connect SYS05 , SYS06 , SYS07. Please guide Please resolve
【Action】Successful message
Hi, I tried to run Action in APP page. But I couldn't check the successful message. I want to check the number of import data. (I can check failure log.) Is Anaplan maintenance team doing any maintenance?
Execute Snap Logic jobs from Anaplan
Hi, We are using Snap Logic as our integration tool from GCP to Anaplan. Want to check if there a way to execute a Snap Logic job from Anaplan? Also, if your integration tool in not Snap Logic, Did you invoke or trigger a job in the integration platform from Anaplan? -- Selva.
Importing into list from subsidiary view
Hello, I am trying to import data into list by creating an saved view in a module. That module has a line item of subsidiary view. That line item is not getting mapped to list subset. Explanation: I have 3 lists L1, L2, L3 (all are hierarchy lists) One list created for requirement to use it as dependent drop down - LD I…
Level 2 - 1.7.3.2 Import into SYS08 SKU Details module - Help please
Hi I need some help here please: I think I've imported data in the Supply Chain Model P3 SKU correctly, however when I update the model SYS08 it is blank. I attach screen shots of my : P3 SKU SYS08 Blue Print Help much appreciated. Thanks, Chris.
DATA02_LEVEL 1 model import issue
Hello Community, I am trying to import SKU.Volumes data into the DATA02 module However, I am facing issues while importing. Below is the step 1 STEP 2 STEP 3 STEP 4 STEP 5 FINAL OUTPUT Can someone please guide me? Thank you in advance
Import Lineitem with subset List
Hi, I want to import Lineitem with subset List. I have this below table. We are making production planning by weekly. Week has subset List, which is Lastest week. I want to import Production Planning only Latest week and its amount > 0. I tried to use filter, but it depends on particular week List. How can I import…
Import and Export Function Process
Hello, I am new to the anaplan software and would like to know the step by step process for adding a Export and Import button on a dashboard. Also I will need to add an Export filter so that I can select what department, version and Time I would like to see when the data is exported. Thank you.
Enhancements to API
Would like to see additional enhancements to the API, things like retrieving line item blueprints, list/module editing, list properties, etc. This would enable customers to control their Anaplan environments with various automations.
Custom return code for API / Anaplan Connect
It would be nice to be able sending custom return codes/messages to the API / Anaplan Connect. This will help us in be more proactively in case of errors. Think about a validation dashboard, which check data consistency. It could be that after a new data feed some functional data errors are flagged up at this dashboard…
Personal Export Settings
We've always used the standard Excel format as that was top of the list, now you've changed it to csv with the release 14/05/22; however, csv doesn't keep the formatting so we had formulas that failed in other Excel workbooks when we pasted the Anaplan export in. It's resolved by the user changing the export format to…
8.2.2 Activity: Add Volume Inputs Module
I am having a challenge creating the volume input module properly as the location is showing Region. How can I change from the Region format?
2.3.9 Activity: Historic Volumes to Baseline Forecast and 2.3.9.1
Hi - Super stuck on Activity 2.3.9 and 2.3.9.1 for the past 3 days. Any help would be much appreciated. Question 1 - for 2.3.9, what am I supposed to do here? The directions or lack thereeof are super unclear. 2. When I'm try to run Action 9, I get this error: "Import into DAT03 Historic Volumes module unsuccessful: Ensure…
Percentage format issue
Hello Anaplan Community, I am at the beginning of the training program and have encountered an issue with the percentage formatting while creating several modules in Anaplan. Let me explain : I am importing data from a csv file with bonus percentages by department. In my source file, the value of my bonus % is as a decimal…
Importing data Into Half Year Columns or cells
Hello, I have a module where I taken time ranges in weeks and Available Aggregation as Half-Year. Now I have a source file with the time range of Half Year (H1 FY20, H2 FY20) (Except half years, I don't have a data in weeks or months in my source file) . In my module my half year values are aggregation of months and weeks.…
2.3.9.1 Import data into DAT03 Historic Volumes module - DAT03 Historic Volumes'.Export" failing
Hello Community, Need your help I am not able to pull the data into the Supply Chain model from the Data Hub model. I get following error. I checked older posts, didn't find a solution for my problem. I have attached all related screenshots. Can someone take a look and advise. 9.1 Import Historic Volumes Model object…
2.3.9.1 Import data into DAT03 Historic Volumes module
I am unable to match my training screen with Anaplan document. and i received fail message for 9.2 Import opening stock. attached documents is the screen shots of my actions please support .
Converting a list to another list
Hi everyone, I recently discovered something within Anaplan that has made my life a lot easier when uploading data. For reference, I work at a mid-size firm and we have data that comes from our accounting software, and data that comes from our enterprise reporting software. Sometimes the naming conventions of things are…
export to S3 using cloudworks failing
I am trying to export data from anaplan to S3. I have set up the connection and it went fine. But the export fails with the message as follows: Your integration failed because of invalid connection. Check your integration setup and try again. Not sure what I am doing wrong here.
Code Generation on duplicate information entered by users.
Hey Folks, I am trying to generate code in the module in which user list is already applied, due to request from the team I want if the same information is entered by the user1 and use2 it should update the counter accordingly surpassing the users. for ex. if I have user 1 entered information as "abc" so the generated code…
Level 1 Activity 6 - No Medical Costs
Hi All, Desperately need help here! Why only the one field is not returning the results? EMP02 - Formula & Results In my REP04 File Results and Formula
New Formula Idea : Convert boolean into a number and stop IF BOOLEAN THEN X ELSE XX
Hello community, I have to do a lot of controls (boolean) and base and theses controls give me a value based on its true or not. I do a lot of these technicals line items for : -Controlling element -Color Coding -... I code it in 3 steps : * 1) Business Element (Number) : Uselly a business value * 2) Control (Boolean) :…

Importing and Exporting Data

Discussion List