Importing and Exporting Data

Data Import from excel
How do I import an excel data grid with no unique ID and no unique combination of property? Note: Customer is looking for keeping anaplan as system of records and wish to generate a unique ID within Anaplan, but key thing is it has to be a import/ not insert using dashboard. Thanks Arun
Update the Data in Current Module
In my current module which is dimensionalized by a numbered list I added additional 4 line items .. and I have a csv file based on which I want to update my current module. However, the dimension is a numbered list and display name has a logic to it. I have lot of other keys which can be unique to update the data, however,…
Set default file to everyone
Would be really handy if Anaplan did either one of the following actions for import data sources: * Set the default file type as everyone or; * Permanently saves files regardless of default file type selected. This would really assist in debugging and remapping import files.
Ability to automate export of blueprint view for module through API/Anaplan Connect
It would be very useful to have the ability to automate the export of a blueprint view of a module through Anaplan Connect or the Anaplan API - in this way we could compare an export of a blueprint view of a module automatically, to check if the structure of a model had changed over time. I have been working with a client…
Anaplan Connect - Export via JDBC
Hi guys, This is my first time really getting to grips with Anaplan Connect and I'm trying to PoC exporting out a simple table of "Region Name" & "Region Code" using Anaplan Connect via JDBC into a SQL table. My scripts are as follows: ---------.bat script----------- @echo off rem rem rem set…
Upload - Non Mapped Source Items Identification
Hi team, Is there a way to identify Source Items in a list that have not been mapped to an item in the target for a Upload to a module in Grid Mode? I am aware you can manually identify the non-mapped items by scanning the Mapping tab but this seems inefficient and error prone (especially with large data sets). When you…
Manage Import Data Sources - Timing
Hi team, How long does Anaplan retain a file that has been uploaded to the 'Manage Import Data Sources' item in the Action Settings? It seems to retain the data for a certain length of time and then if you attempt to edit the Action to which the uploaded data is associated with you will receive the attached error Thanks…
Display Action Notes on the Pop-Up Message, before a Process/Action is Run
In the Actions menu, all processes and actions has a text based "Notes" section. Being very upfront, I honestly didn't even know this section existed until about a few months ago, but I definitely think it can be further leveraged. It would be great if these notes could appear every time, next to your action, before you…
Download A File Using API V1.3 - Do I Always Need to Delete File First?
Hi Anaplanners! I finally have gotten around to asking this question that's been bothering me since I started using the APIs to download a file. I get inconsistent results when I test this on my own so I thought I'd ask the Community. The use case: I want to download a file (export) based on a view from a module using API…
Hyperconnect read and write to SQL database
Hi, I've been researching this and could not get a definitive answer from either here or the Infomatica forums. Can Hyper connect read from on-prem SQL tables, import into Anaplan, and write back to on-prem tables in a SQL database?
Import for Weekly Data
I am trying to import Historical Weekly Data, but am constantly getting error. Please assist how to import Weekly Data? I tried several times, I have attached Screenshot.
Anaplan Integration & Anaplan Connect
Hello Community, I'm reaching again support for some questions I have, some of which may appear silly for some experienced users. I've been trying to find an easy way to obtain Action's ID in Anaplan as those are used for our B2BI integrations with other ERP and EPM systems. Initially, I thought I can easily get them from…
Prompt for Import Data Source name and Import Action name
Something that would considerably help with building cleaner models would be if users could enter names for import data sources and import actions during the import dialogue. This would prompt model builders to assign a considered name, and substantially help to identify import data sources and import actions after the…
Define import name while creating import
When I am creating a new Import Action, I would find it beneficial to define the name of that Import when I am setting it up for the first time. Today I have to go back into my Import list and rename after the import has been established. By defining the name while I set up the import, it would alleviate the need to…
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…

Importing and Exporting Data

Discussion List