Importing and Exporting Data

Anaplan Connect - Running the proccess/imports
Hi All, I need your help regarding process or imports in anaplan connect. In the import or process when any of mapping is selected as ' ask everytime while import'. How can we complete that process or import successfully using Anaplan connect
Anaplan Connect cannot connect to database
Hi, We recently set up a new database to export data from Anaplan to Azure. The database is a SQL database on Azure VM. I am trying to set up connection. Export out of Anaplan is always successfull, but keeps failing when connecting to the database. Jdbc connection string: Anaplan connect is also running on a VM.…
4.6.7
I used the mapping column 3 family code to P2 product family column headers to parent column 1 product code to code I get the error another row has already been processed with this key and invalid name 53 failed
Update Current Timestamp by adding a New Action Type
As workspace admin, I would like to have the possibility to update the current timestamp in UTC timezone by having a New Action type created ( similar to the below picture ). This could work in a very similar way as the very nice new feature "Update Current Period": 1. Create in a module without any dimensions a line-item…
Actions Tab Improvements
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Looking to review trend Process executions and durations. How often is this impacting your users? We are currently implementing API…
How to import date from one model to another
I'm not sure if there was a new update that changed the process? I cannot import a date from one model to another. I am trying to import the dates from A01 to A06. I think the checkbox on the mapping page is new. I've tried different variations but can't seem to get it to work. Thanks in advance
Import status
When the end user imports a file on the UX, he gets this success message: But in fact on the view details part, we can see failures : Does anyone knows why the message the end user gets ain't "completed with failures" instead of completed successfully ?
How to Import from Source to Target with Different Number of Dimensions
Have you ever faced a scenario where you wanted to import the data from one module to another with different set of dimensions and you were not able to successfully achieve it? Usually such type of data movement can easily be achieved through formulae but in some cases writing formula might not be the solution, for example…
L2 Model Building Conclusion: Failed Import into Shipping Expenses OTH01 Module
Hello Anaplan Community, I've been stuck for too long trying to import the shipping costs from my Saved View into OTH01. I've tried numerous saved views but can't seem to resolve the errors. I've deleted all Saved Views and started over because I think I am confusing myself. Below are screenshots of where I am currently…
Organizing templates for data imports
Author: Vinay Varadaraj Mirajkar is a Certified Master Anaplanner and Senior Solution Architect at Anaplan. I am sure many of us have seen the below message many times in our experience, and at times it may be very time consuming to retrieve the file which was used to create the import action. And there are also chances…
Data is not getting updated into Production model through integration
Hi Team, I am having issue regarding the updating the records into the production model via integration and action is marked as production data. In test, data is getting updated correctly with same action but in prod action is running but records are not getting updated. Anyone can advise on this issue please? Thanks…
Ways to bring Import Action Timestamp into a line item in Anaplan
Hi All, Is there a direct way in Anaplan by which we can bring the last run time/date of an action to a line item in Anaplan?
Import to numbered List
Hi People, I want to import transactional data into the model from excel csv file. I formed a numbered list, where I am importing this csv file, identifying the unique key by using a combination of properties, but there are other columns that are not forming part of the combination. (basically, those are values/number…
Anaplan & Fluence Connection
Does anyone know how the connection between anaplan and fluence works… or can point me in the right direction for documentation?
Trying to get .xlsx from Anaplan Connect but comes out as csv
I have an export that I am trying to run through anaplan connect 4.2.1 however it is causing some issue When I run the export direct in anaplan, it comes out directly as an .xlsx file, but in anaplan connect its format is .xlsx but excel won't open it, and if I rename the extension to .csv, it opens correctly. So it seems…
7.2.3 Activity: Import Data into Employee Details Module
When importing data into the SYS08 Employee Details module, my end results looks like the second photo when the goal is the first. I have imputed the correct mapping, and manually mapped the employee detail line items as well as changed the date format to YYYYMMDD. I'm not sure what the error is, I keep getting the error…
SUM Function Example
I tried to create a simple SUM function. In a video it explains transaction as Line Item whereas I failed it as Line Item. So I tried using Transaction as a List. It worked out. Can you please let me know, if I am right or wrong? I have shared Screenshots for reference.
Anaplan Connect: Wake-Up Script
Preface: Utilizing CA Certificates is the best practice for Anaplan Data Integrations. The wake-up script is best leveraged with CA Certificate authentication in the individual scripts for security purposes. If you would like to learn more about CA Certificates, click on this guide. Note: Basic Authentication used for demo…
Create Shipping Export Module and Create a Saved View
In Level 2 Model Building : Conclusion, there's an 'Activity: Prepare Data Exports' that tell us to Create Shipping Export Module and Create a Saved View. I've made the formula and choose the format and summary method but I'm not sure if it was right. Here is the blueprint of my INV05 And here is the screenshot of the…
Please add filters to the IMPORT actions columns.
Trying to find a source or target in a list of 500+ imports is quite a time consuming process. Adding a filter or a sort to the columns would be such a big improvement I used to copy and paste the import actions into excel, but now it seems you have changed the format of the table and this is no longer possible, so now…
How to tackle duplication import into numbered list with list formatted properties ?
When importing into the list having properties as list formatted it create new list item with every import even if unique identifier already exists While importing transactional data into a List (Numbered List) which has properties Country formatted as Country, Year formatted as Year and Amount formatted as Number. In…
Importing Values to Booleans via Model to Model
Hello, I hope you are all doing well and good. I would like to ask about a challenge that I'm currently experiencing. Situation is, I need to create an action, just a simple action that will be published to the NUX. This will be an Import action within the same module via a Saved View. Please refer to the encircled line…
1.5.6.2 Import Data into Historic Volumes Module
Hi I am having the much trouble trying to import data to the module: I've matched all Run the upload and says it is successful: But then there is no data loaded? I also not that the Time is incorrect? Have spent about 3 hours trying to mitigate this with no resolution. Please help! 😞
Data Import for REV02 module
I'm getting this error while importing data for REV02 module. PFA screenshots.
Why are there items appearing in the source mapping of an action that are not present in the LIS
Why are there items appearing in the source mapping of an already existing import action that are not present in the Line Item Subset? I have updated the LIS and still in source mapping I can see items which are not present in the LIS.
OEG Best Practice: Data Hubs: Purpose and peak performance
You may have heard about a model called a Data Hub, but perhaps you aren’t confident that you understand the fundamentals, primary functions, or considerations when architecting one. There are three main advantages to incorporating a Data Hub: Single source of truth : Stores all transactional data from the source system.…
Mule4 with Anaplan Execute Export streaming Integration (Unparseable date issue)
Hello Team, We are using Execute export streaming Anaplan operation connector in Mule 4. But we are getting the following exception from the Anaplan connector while performing the export option! org.mule.modules.mulesoftanaplanv3.internal.client.AnaplanV2Client: Exception while parsing currentTime java.text.ParseException:…
Can i export a dashboard in pdf from the mobile app?
My client uses Anaplan on mobile devices. Is there a feature to export a dashboard screen in the form of a pdf? I am not referring to Management Reporting slides. I am talking about plain simple dashboards containing grids and charts, designed specifically for the Anaplan mobile app. When you try sharing the page, it goes…
CloudWorks: Stop hiding flows if model is archived or stop a schedule if flow was hidden
When a model is archived all related flows becomes hidden. If, for testing purposes, there was a schedule set, it keeps running (and failing) in the background even though administrators are no longer able to see or change the flow. One can always bring archive back and stop/change the flow, but it would be much easier if…
Anaplan: Valid To period - 9999
Hi Expert, Good day! Would like to seek your insights on how to upload the ValidTo period as 12/31/9999 and in Anaplan it will become blank (Date format). Since in Anaplan unable to load this period format unless set the format as text. Is there any workaround to handle this one or a system limitation? Thank you in…

Importing and Exporting Data

Discussion List