Importing and Exporting Data

Anaplan is not allow my export showing message Excel workbooks cannot support more than 65536 rows?
Google Sheets Add-on: Send formula driven figures back to Anaplan
The idea would be to receive information from Anaplan, have the ability to update the information using editable inputs (e.g increase sales forecast by 10%) and then send the result (of Anaplan data * 10%) back to the Anaplan module.
Import Shipping Expenses into OTH01 Module
Hi everyone, I'm still struggling with the import into the FP&A model (Level 2 Conclusion) Here's the mapping I have had: And here is the error I have got: Here's how my INV05 Shipping Export module looks like in a Blueprint mode: Is there any chance someone could help me, please?
Clear all items reset to "Match items in source" when a dimensions mapped on "Fixed item in" or info
Recently I had and issue with a Model where the import setting “Which target items to clear prior to import?” was set to “All items” but not visible in the import screen because the Diemension was remaped to single item. Altough the Dimensions was mapped to a single item, it was still cleared all items but that setting was…
Community perspective: Flat-file Data Load - CSV Encoding Issues
Problem: In the same way we cannot load .txt files (usually tab-delimited) through a data load action originally created with a .csv (comma delimited file), trying to load .csv files with different encoding parameters can result in an issue too. This is the error message you will get in both cases (attempting to load a…
Export data to .csv file from a module with page selector and filter is not working
Hi, Exporting data to CSV file from a module with page selector and filter is exporting incorrect results: Sample Data as per my example below, Anaplan is applying the filter (amount<>0) to the first month March 23 only. Zero's are getting exported for the intersections data available in first month (filter is not applied…
Issue with download SUM Demo Model
Hi, I'm trying to import model 'SUM Demo' Model into my workspace but I can't find it. Can you please help me? Thanks, Ana
Size.csv missing - unbale to import the data
Hi, I'm not able to import the Size.csv file into workspace due to the fact that I can't find it into the training or into the Anaplan. Error message displayed: he uploaded file is no longer available; please upload the file again. Can you please let me know where I should find the files? Thank you, Ana Maria
エクセルのToday関数のように現在の日付を特定する方法
みなさん、こんにちは。Anaplanモデルビルダーのセナです。本日は、エクセルのToday関数のように現在の日付を特定する方法を紹介したいと思います。現状Anaplanでは、エクセルのToday関数のように現在の日付を特定するためのネイティブ関数はなく、Idea Exchange では多くのビルダーに要求されており、保証はできませんが、今後の新機能として追加されるのに期待です！追加されない間は、以下の方法で実施してみてはいかがでしょうか？今回は、わかりやすく表現したかったため、"Power Automate"を使用しました。実際には、API叩けたら、どんなプログラミング言語やツールを使用してもOK！ 1.Power Automate…
Import script as stopped working, but the manual import runs succesfully
I am importing data from Snowflake and successfully saving the csv file, this has worked for about 2 years They changed their column headers, I then downloaded the new format csv, and created a new import using this file, which works 100% However, when i add the new import to the script it crashes at the import stage…
Import failure: The dimensions in the target module do not match the import definition
Hi Anaplanners, I'm stuck with two imports which have the same settings, from saved views based on same module, and to the same target module. However, one works, but the other one always runs into a failure with message "The dimensions in the target module do not match the import definition." I have two saved views from…
Cloudworks Integration "There was an internal server error" for BigQuery Data Source option
Hi experts, I was trying to export Anaplan data to BigQuery via Cloudworks. I have established a connection but when I am trying to set up the integration, I keep encountering the issue of "There was an internal server error" under the Data Source option. Can anyone provide any advice on how to resolve this?
Clubbing multiple excel exports
Hello All, We have a requirement from user where they want to club multiple excel exports from Anaplan as a single file (meaning each sheet in excel having the respective export from Anaplan). Is this possible? IF yes, can you suggest how to proceed. Report 1 -> Sheet1 of excel Report 2 -> Sheet2 of (of same excel)..and so…
Format while manually exporting data
When we manually export data from the anaplan model, several formats of the data can be exported. I want to know the difference between the two formats 1.Comma separated values(.csv) and Comma Separated values for Excel(.csv) 2.Excel(.xls) and Excel (.xls) not formatted 3.Excel Open XML(.xlsx) and Excel open XML(.xlsx) not…
Hi, I'm currently in 10.2.2 Activity: Import Data into Non Employee Expenses Module
In my first screenshot, you can see the source and target mapping for the data. In my second screenshot, I have correctly mapped the time corresponding to the format available. (See 1st screenshot in the column header for time to understand the format) In my third screenshot, there's an "import failed" window. I don't…
Export ignoring show/hide
Hi guys, I have created a saved view in one of my modules. my module has 4 dimensions + line items. Time, Cost center, GL account and version. My saved view has selected a few versions, cost centers and GL accounts. I use tabular single column for my export as I want all dimensions to be columns and only a single line item…
Why several actions in process are not updated?
Hello, I have been importing data from a data hub daily for several months now. In the last days the last 2 actions of the process are ignored on the update. The actions are very simple. It is importing a date from the data hub. I can't understand the issue. All the other actions are working properly. When I am launching…
4.8.2 Activity: Import Data into E2 Employees# List
Hi Anaplan community, Had a bit of trouble importing employee details into the list. I followed all instructions given in the community regarding this and even tried deleting and importing the list multiple times but it still displays employee number instead of name. Hope someone can help. Thank you!
Update Current Period Action from Data Hub Not Working
I’m having trouble with Updating the Current Period action using an imported line item from the Data Hub. I created a systems module and added a Current Period, time formatted line item with no dimensions in the Data Hub and Spoke Model. I created the action to Update the Current Period in the Data Hub and it worked…
1.5.6.2 Import Data into Historic Volumes Module. Need some help
Hi, I am having some trouble trying to import data to the module: I ran the upload and it is successful. But then all the volumes data in my module is all the same, meanwhile in the import file each volumes are different. Any idea where I went wrong? Please help 😞 Thank you
Hello,
I have a module dimensioned by Accounts on the rows, Users on the columns, and 1 Boolean line item which allows users to select certain accounts that apply only for that user. I am trying to create an action that allows the user to clear all of their selection by simply clicking an action button, as opposed to have click…
Ability to combine processes across models in CloudWorks
The use case is to orchestrate a data integration workflow in one CloudWorks schedule containing steps executing model-to-model imports from many processes residing in various models, e.g. update DataHuab lists and modules, then update planning model lists and modules, then update reporting model lists and update.
Sort Workspaces in Model>Model Import View
When setting up an import and selecting the "Connect to Anaplan Model" option, if you need to navigate to a different Workspace, you may be in for a bit of a maze. The workspaces are randomly sorted today, when nearly every other view (manage models from home page, new breadcrumb navigation in updated modeling experience)…
Exporting data to different tabs in excel
I'd looking for something that I think I've seen in other systems referred to as "explode" functionality, which would effectively create a new excel tab for every list item and export to that tab. So, if I have a department list (for example), I'd like to export data to excel and have a tab show up with the data for each…
Wrong date when doing an import
Hi everyone, I am importing data into a module which gives me the employment date of a list of employees (among other info). The module doesn't use time as a dimension. The import goes perfectly well, it doesn't mention any error. But then some of the dates are wrong. So I tried to copy these directly from Excel (simple…
Workflow triggers Import/Export
Having CloudWorks schedule imports between models is useful, but users still need to wait. Our users are participating in a workflow, data is ready to move from the source model when a workflow step is completed. Can we trigger imports or exports, or model-to-model imports from workflow?
Export - Data Source
Hi Community, I am thinking that would be very beneficial for model builders to have the possibility to view Data Sources for Export Definitions. For the large models with lots of external integrations and different export actions is pretty difficult to follow the source of a particular export if you can have dozens of…
Export defined in a model should be connected to a view
Hello Team, Currently, when we create exports and save them in actions - they are disconnected from real module views. Example: if you create a new export definition, based on a current view (with a filter or smth else) it is not possible to revisit and amend this view after some time and see what view is feeding an export…
Native scheduling action in Anaplan (w/o API. Connect or 3rd party integration tool)
Could Anaplan action iteself allowing for scheduling? (i.e. a common use case would be you have an action that brings data from Data Hub to Spoke models and data in Spoke models need to be refreshed everyday) - It would be super helpful to have this function built-in at the time the action/import is set up in Anaplan,…
Import from SQL Receiving Error - "Anaplan API: Cell text cannot contain tab character"
We are attempting to switch our source from excel files to a SQL server and are receiving this error when running the scripts for Anaplan Connect. The job is successful for the initial two tables but we're experiencing this error on the final table. The formatting and configuration is similar for all tables so unsure why…

Importing and Exporting Data

Discussion List