Importing and Exporting Data

How to get the export ID other than the API method
Hi, In the Anaplan account, where to find the export id in the account? I tried through the Rest API-Postman and I am getting just the square brackets. Is there any other way to find the export id?
Versions
Hi community, While building a model I came up with some questions regarding versions. In my model I have some values that I refer to as "actuals" and I want to be able to import them monthly. And all the other modules that I previously built should update their values, with this I mean: the past values should remain the…
Large transaction data imports with Code > 60 characters
Hi all, I'd need some experience sharing regarding some challenging data imports that have the following : - Large volume of transactions - Multiple attributes (> 10) to load - Unique code would be > 60 characters if we want to follow planuals and best practices to have a good performance load Has anyone solved this…
Action Time-Out on Importing Numbered list security into Users > Selective Access
Hello all, I am building security actions and processes. I have a number of lists with selective access. My imports on non-numbered lists all work fine with the import line items formatting as the lists. One of my lists that has selective access is a numbered list. Instead of the import line items being the list, I have…
Do we have any option to get the JSON format response using Get chunk data API ?
1.) Get chunk data API is returning the response as an application/octet-stream format, we have any option to get the JSON format response using this API ? Get chunk data API - /workspaces/{workspaceID}/models/{modelID}/files/{fileID}/chunks/{chunkID}
Is it possible to Retrieve cell data based on Task Id/Job Id.
2.) Is it possible to Retrieve cell data based on Task Id/Job Id. Retrieve cell data API - /workspaces/{workspaceID}/models/{modelId}/views/{viewId}/data?format=v1
Is there a limit for parallel processes
Hi Community members, I am using Anaplan Connect v2.0 to import/export data in Anaplan. I would like to understand whether Anaplan allows multiple processes to run at the same time, or is there is any limit that it can run only one or a few at any given point of time? Any documentation link which I can refer for it, will…
Help figuring out Data Import into List Action
Hi, I have a Action that was not set up by myself and trying to figure out how the Action is working. How I'm interpreting the Action is that it populates the List by Puling LI's from a module called D02a. But that module is dimensioned by the List so I would think that List would have to be populated first. So I need help…
Anplan import job log file in CloudWorks integration
Hi All, I have created a integration task in Anaplan CloudWorks using Anaplan import action. I am not able to get log / error log file (in case import action ignore rows due to duplicity). Is the any way to get error log / log file on email from CloudWorks Anaplan import integration task ? OR How to get error log / log…
CloudWorks vs OneCloud
Hi, Can anyone explain the difference between Cloudworks & Onecloud & when to use what? I gathered that Onecloud has both cloud & on-premise options as compared to Cloudworks, however I'm not sure which is more effective - features wise, cost etc. Also, in terms of Data Integration with ERP tools (cloud/on-premise) - how…
How to Create Connection Between Anaplan and Power BI with API 2.0
Power BI is a popular reporting tool. One of the reasons is that in Power BI you can get data from different sources, and there is an increased interest of our customers and Anaplan builders to be able to import data from Anaplan. In order to make this connection, we developed a solution to set up the integration. It is…
Option for the default file format for new exports from classic dashboards
In a May Anaplan release the platform was updated such that when users in classic dashboards created a new ad-hoc export, the default file format was now .csv, not .xls. In many respects this was an improvement and certain customers preferred the .csv setting, but some customers need the files to be in an Excel format and…
Hey, How can i Autogenerate Codes in a Non-Numbered list?
Remove Column Headers when exporting
Hello! I would like to export a csv without column headers. I was able to remove the display name, but I can't find a solution for column headers. Can you help me out? Thank you
Lookup Sales Based on drop down list
Hi, I need to retrieve the historical sales based on the selected Store from dropdown list of my module. Here in Module 1, the Store List has no sales for specific SKU that is why we're going to get the sales from the similar store. Module 1 Dimension : SKU, Store List, Time (Line Items: For Expansion?, Similar Store…
Tell us your thoughts on ALM via a short survey!
Customers and Partners, Please take this short survey, which should take you less than 10 minutes to complete, to tell us your thoughts about ALM. Thank you, User Experience Research Team
Export Button based export filters Error
Hi, I manage a model that has export filters at the bottom of the dashboards. There are multiple dashboards. They are the same export filters; Version, year, and department. There is also an export button to export based on the export filter selections. The export buttons were working a few days ago and today we are…
Trigger API from Anaplan (native solution)
I would like to be able to trigger the API from Anaplan (e.g. button on a dashboard). This will enable sending data to another Anaplan model or to a different system event based by an end-user, rather then scheduling it outside Anaplan. Eventually it will enable much better integrations with 3th party solutions (advanced…
Running an Action to Export with a Mapping from Informatica
Hi, I'm trying to execute an Action to export data with the use of a Mapping in Informatica. I've executed many exports with mappings in the past, but for some reason with this action, I'm only receiving the headers. There are no rows of data. The strange thing is that when I run this action directly in Anaplan I get the…
Informatica - Export to Flat File
Hello, I have built a Mapping Task in Informatica to run an Anaplan action that yields a flat file export to a specific target. The process works well. The only question I have is that when selecting target formatting options, Anaplan suggests that you select Double Quotes as a text qualifier. The problem then is that all…
Facing Problem for 8.5.3 Activity: Import Data into Volume Inputs Module
Hi @noelle_murphy & Team, I'm facing an issue with "8.5.3 Activity: Import Data into Volume Inputs Module" while importing the File. Can anyone please help me in this?
Error Message when loading into a List
Hi, Could you please explain what this error message implies? I believe that it is saying that it rejected the duplicated in that column of data that I loaded into the List, is this correct? Thank you
anaplan sprint 2 1.3.10.1 - country import help
Import was successful However, something is off and can anybody help me what I did wrong? My G2 Country List has the code and parent assigned correctly Here is the check your work from anaplan course
Import special characters
Hi When I am importing "ñ"(alphabet with special character) into text formatted line item through csv file, it is taking as "Ã±". But I need "ñ". Could anyone please help me on this. Regards Shirisha.
Level 10-2-5 Boolean not showing the check box
Hello, can anyone help me with this please? I do not know why Boolean doesnt show the check box after importing data (please see a screenshot) I have been struggling with this for a long time. Any help will be greatly appreciated!
Updating hierarchy lists from user selection
Hi, lets say I have this hierarchy: A1, A2, A3, A4, A5, A6, some users need to change A4 from a module, this change need to update the list A4 and obviously this will impact A5-A6 lists. So I was thinking in creating a action that imports from this module into the list A4 but the point is that only the items changed by the…
Building Tableau Export for modules
Hi Team, I have module "ABC" where it has some 4 dimensions and 5 line items where each line item has a subsidiary view. I want to make a Tableau export with the above-mentioned module. Kindly help me with the procedure. Regards, Venkatesh
Unable to export view to Excel
Hi All, I am currently unable to export a view from an app page to Excel. When I select this option the screen goes blank and nothing happens. This feels like a bug but could there be a setting needs to be updated to enable this as I am able to export to a csv.
11.3.4- Values Not Matched
In this lesson, my values don't match those of the example. Everything was fine until I put in the formulas. When mapping, everything matched perfectly. May someone assist with finding the issue? The formulas are in correctly.
Store Start Date and Time (UTC) for Actions/Process Indefinitely
Reviewing past models or model history (archived) for even our current live models the Start Date and Time (UTC) for Actions/Processes is not populated for anything that's been run more than ~1 month ago. This feels like a gap in how this field should function. Proposal: The Start Date and Time (UTC) for Actions/Processes…

Importing and Exporting Data

Discussion List