Importing and Exporting Data

Using Model Role to filter
I would like to filter a module which uses a list of users (either actual User list or a regular list which is a copy) by the Model Role each user has been assigned. Cannot seem to figure out how to import the model role into a module. Ideas?
Allow process to continue after action failure
As we schedule more processes via Hyperconnect where end users are not triggering themselves, we need to allow for processes to continue even upon an action failure. Perhaps allowing users to choose when creating the process whether or not they'd like the process to continue even if an action fails would be great. Just…
Improve time period imports for CSVs
The standard excel format for Month-Year is MMM-YY. I.e. if a user types Jan 20, excel will convert this to a numeric value and display Jan-20. Anaplan does not recognise this as a valid time period when importing. As this is the default excel format, it would be great if Anaplan could recongise this correctly. Rather than…
Import Issue
Hi Guys, I have an issue that I put in a document since for some reason I cannot paste a picture here on the body of this screen. I am sorry if I cannot provide the actual screenshot since it is the clients data. But I recreated it as much as I can. Please see the attachment for details. And again I appreciate the help…
Import error formula
Hi Members, I am adding formulas to the properties, I am thrown this error. The actual output (mentioned as output in pic) is shown. Please assist me with the correction, that needs to be done. Regards, Sravan.
Import in a numbered list
I am facing this error while importing the values in the numbered list. Can someone please highlight what this error means.
Import Action Error
Hi Anaplanners, Need help with the following error: Can you please let me know how to resolve this..? (See the pictures) Thanks in advance, Ankur Sonthalia.
Date formatted columns taking more inputs correctly
Issue: When you copy+paste a table into excel, excel's default behavior for "Date" formatted or similarly formatted information changes the data slightly to a "MMM-YY" format from a "MMM YY" format and you are unable to paste back into the model/load as a basic default using upload. Current Solution: 1) Manually re-enter…
Numbered list import error
Hello Friends, I was trying to import values into numbered list, I was thrown with this error. Please let me know, where I was wrong. Regards, Sravan.
Anaplan Connect 1.4.3 Export Process Error
Hello, I would like to seek some feedback on this issue that I'm having with Anaplan Connect 1.4.3 Export Process. My hunch is that, maybe it's related to Java -- I have this Java version on my Control Panel: =============================================== Currently, I have the below basic export script: @echo off set…
Specify a destination for Export
All exports are to the users download directory, is it possible to be able to select a location before downloading. We use some csv downloads as a source of data for an Excel process, and the main spreadsheet looks for a source, if we have it for several users, and the source is in different C:\users\.....download folders,…
Anaplan 4.3 - Export process
Hi Guys, I am using Anaplan 4.3 and I am planning to do an export process I was able to run the import process successfully but I cannot seem to run the export process successfully. I tried to copy the contents on the Anaplan Connect Document but it is different from the sample script in 4.3 folder. Anaplan Document from…
Unable to locate Account Flat List (.csv file) in LEVEL 2 MODEL BUILDING: SPRINT 1 Data Hub Model
While creating DAT03 Historic Volumes module for Sprint 1 - User Story 3, Level 2 Model Building Course, in the Dimensions: Account Flat list is included, but I'm unable to find the Accounts (.csv) file in the training module. Please Help.
Option for Reversing Journal Entry
Hi All, I'm a new member.. I just wanna know about options in reversing journal entry in Anaplan , there are 3 options : 1. Single-sided 2. Reverse next Month 3. Reverse next fiscal year could someone help me to describe the purpose of each options above Thank You and regards
Anaplan Connect - Multiple line Batch file
Hi team, I have a batch file where I want to split it into multiple rows due to being quite long. I looked online & read that if you use ^ at the end of the row it will continue into the next, this is not currently working & wondering if anyone has any ideas?
Import result shows values are adding up from multiple codes
Hi All, This issue is related from yesterday but with a different approach. We created a Gencon Module (transaction Data of client) and the Inventory Module (data from Gencon without the duplicates). Gencon List has duplicate RU text (Transaction Code) which will be imported to Inventory List eliminating the duplicates and…
More than one Numbered list import
Hi All, Please help to make me understand if I import the one numbered list in other numbered list using "CODE" in this case I can not see the parent of my current numbered list, so what should I do to see the data with parent hierarchy in more than one numbered list items. Regards, Vikas Jain
Is a source model mapping update needed after model name change?
Hey Everyone, I tested this, but want to be 100% sure before making the update. Can someone confirm that the Source Model mapping does not need to be updated if a model name is edited. I see that the existing Source Model's name does not change, but the imports appear to still be running correctly even though the name is…
Numbered List Import in Other Numbered List
**** All, Please guide me to upload numbered list as a list in other numbered list. I am trying to import using code like as given below but unable to import and getting error. Regards, Vikas Jain
Anaplan Connect - Export Process Script
Hi team, I have a Anaplan Connect script to export a process of 1 action (just for test purposes) but I cannot get it to work. Currently receiving the attached error. My script is below Thanks @echo off set AnaplanUser="email:PW" set WorkspaceId="8a81b09e6181d3600161b51408040171" set…
Import from a Staging Module to a numbered list
I am struggling with the following: I have a staging module, dimensioned by Users, where individual users can input some data (CostCode, Currency, Cost Type, Forecast Reference), and once completed, I want to run a process to create a new item in a numbered list (that holds the full set of approved transactions) and then…
How to create two or more import actions into the same module
Lets say i have a source file need to be imported into module. Few of the line items need to be cleared before import for all rows and few others need not. How can we create two import actions by keeping the same target module and same source file. One work around is splitting the module, but am i missing some other way?…
Data break down based on hierarchy
Hi, I'm wondering if there's a way of breaking data down from a top-level? The data file that I get is an import that comes in at level 2 in my hierarchy. I need to then take this data and show it applying some rules in a module uses my lowest level of data (l4). Thank You Hina 🙂
Module to Module Import
Hi , I have a module ,by versions ,Dimension is a number list . Line items - 1. line item 1> Data Type > List 2. line item 2 > Datatype > subset of list 3. line item 3 > Data Type > Subset of list 4. Other number formatted line item I want to import Budget data into forecast . Action is successful but "line item 2 and line…
Anaplan Integration with Amazon S3 using Informatica Cloud
Hello Team, We are currently trying to Integrate Anaplan with S3, Here Anaplan is the Source and we need to place files into the S3 Bucket. The metadata tables have been created in the relevant S3 bucket. The requirement is to have the CSV files containing the data from Anaplan and a Manifest file to be placed into the S3…
ALM Cell value
If a cell value is accidentally changed in Production. How can we revert back to the old cell value?
Model to Model data import from Module and ALM
Hi Experts Building a functionality to deploy to production which requires an automated Model - to - Model module data import through custom scheduling. We use ALM. Both modules, i.e, the source module in one model and the destination module in the other model are being built in DEV. Upon deployment to production, what…
Data Import into a Module using a numbered list
Hi, I would like to understand how an import action works for a mapping on a numbered list. I have an import action set up between 2 modules in 2 different models. Both the modules use the same numbered list. Since the mapping for the numbered list is on name or code the system ends up mapping on the name(Unique number Id)…
File to Module Import Doubling Number
Hey Anaplan Community, I am having difficulty achieving the desired result with a file import to a list and then module. I wanted to see what workarounds have been used. Below is a simplified example of what the file structure looks like. File: Style Manufacturing Pieces 12345 2 12345 2 12346 3 12346 3 The information is…
Your help is needed! Excel and PowerPoint add-ins: best practices
Hi all, I am reaching out to the Community to get your input about best practices for the Excel and PowerPoint add-ins. Please share your tips and tricks to make the use of the add-ins as efficient as possible! The suggested themes are: * Governance of the add-in: upgrade process, version control, COE management of the…

Importing and Exporting Data

Discussion List