Importing and Exporting Data

Script to export General List
Hi I am looking for a way to programmatically export the data from a General List to my local server. Any help here would be appreciated. Thanks Regards Prabakaran
Change the name of Excel Sheet during export
Hi all, I search to replace the name of Excel sheet when I export data (by default "Sheet 1") Someone has already done that ? Thanks in advance for your help!
Defining the default file for imports
Hi Is it possible to specify a default file for some import actions in Anaplan, so that whenever the user clicks on the action, instead of asking the file to upload "choose files", it automatically looks at a specific place for a specific file and runs the import?
How to bring in previous balance into current module? Or how do I bring in a rolling balance forward
I am creating a balance sheet. I am hoping if anyone can show me the best approach. I have two module. Previous balance module and current Balance sheet module. My previous balance module have no time scale. I want the previous Ending balance in my current module. I attached 2 screen shot to show you what I mean. When I…
Adjust Imports View
Hi team, I'm trying to adjust the view of the Imports tab in the Actions area so that all the text is visible. Currently the columns are a fixed width & I cannot adjust them. Likewise I am unable to extract the data to view it in Excel (where I can adjust columns etc) Anyone know how you can view all the data in this…
Script Update Current Date
Hello, I've read through the boards, and unless a topic is well hidden, I have been unable to solve what should be a simple solution. I have two issues: A) I am unable to write ("copy") a script from previous posts to update the Current Date line item in my Current Date Module. I created a process on my computer to update…
What is Branch?
Can someone explain in a simple language of what is a Branch?
Import to time based module with "ask each time" time selection
Hi! i have met the following issue. There are two modules: - Target Module: Time based (Year) - Source Module: no time dimension when doing import , I chose "ask each time " option for time dimension , and during import run i select that single year which is presented in the module. the import is running successfully but…
Import - Values inconsistent
Hi, PLease see details on the attachment. Regards,
Questions on Data Hubs and how to have Peak Performance?
All, Please check out my new article on Data Hubs: Purpose and Peak Performance. If you have any questions, please let me know. Link here Thanks, Rob
Anaplan Connect Using Linux Script(Certificate Based Authentication)
Hi Team, I am working on Anaplan Connect on Linux Platform tried run with credentials it worked, however, i am unable to run with certificate authentication. Getting an error" -certificate is unknown token" Please find the below code. #!/bin/sh # This example uploads a file and runs an import…
Direct link between anaplan and microsoft analysis services cubes
Hello, Does anyone now whether it is possible to either import or export data directly into a microsoft analysis services cube through the data utility tool? best cheap cordless vacuum thanks iosman
Export configuration
When I export a module with a layout: Grid, all Pages, I get 1 excel sheet per item from my list in page which is the result I want, My only issue is that the excel tab is generic whereas I would need it to have the name of the item in the page, Is it Something that could evolve?
Data Upload Metrics
One of the most common questions I get, regarding uploading data to Anaplan, is what the optimal chunk size is. This post will review my results for file uploads using cURL, Informatica, and Anaplan Connect v1.4. First, a bit of background on chunking. Files in Anaplan are stored in chunks (unless under 1mb, the minimum…
importing data into list item
Hi! I'm taking a lesson list's course which is before 102 and have a question about Central Library(list import). I imported the data of Employees.csv, following the guide, but unlike the guide, error occurred. So next I filled in all source blank like photo, then I imported successfully. Why error occurred regardless of…
Sharing Lists Between Models
Is there a way to share lists between models? We use a number of different models all for the same company which uses the same structure - and it would be really handy if it were possible create a 'shared' master list(s) in one model that could be referenced by all the other models.
How to Export a Dashboard to PDF?
Hi, I was wondering if there is a way in Anaplan to block the export in PDF and Excel of Dashboards and modules? The client have asked to limit that for confidentiality (e.g. for salary), I know the users will be able to copy and paste the data in Excel and so on, but theoretically we would need to block the direct…
File imported in random order
Hi I am importing a .csv file into my list .The file got imported succesfully,but I see the records are not in the same order as in the .csv file. ex. The first record in the .csv file appears in the middle of the record set in the list. Is there anyway , I can insist the records in my list are appearing in the same order…
Import - Values inconsistent
Hi, PLease see details on the attachment. Regards,
Import - Values inconsistent
Hi, PLease see details on the attachment. Regards,
FP&A Case Study: populate sales forecast module with Budget Units
Hi, I've been trying to upload the budget units (from the sheet input units from the 2017 budgeting excel file) into my Sales Forecast Calculation Module. In that module I look either at the actual units, and if not present, at the forecasted units to calculate revenue, COGS, ... However, I cannot manage to import the data…
Delta Load
Hi, How incremental load works from any data source(other than anaplan) to data hub in anaplan?
Anaplan Connect API - Load a Java Class
Hi, Please see attachment for the details of my query. Thanks in advance Regards,
Being able to copy a cell with lines of text separated by a line break from Anaplan to Excel
Posting on behalf of Thales Example: Car 1 and Car 2 are separated by a line break When copying the above cell to Excel, we get: It creates two cells. To keep the text in one cell, the current workaround is to use a space instead of a line break in Anaplan, but for some users, it is easier to separate two distinct elements…
Edit Dashboard
Dear Members, I am getting a Slider which I want to remove. Desired Format has no Slider. Please help me to remove the slider from Dashboard. Thanks.
Dashboard Header Module
Dear Members, Require your help in removing the Module Name from Dashboard. I have shared the Desired Format (How I want) and My Format (How I have). Please feel free to ask in any difficulty of understanding.
Create Child in Numbered List
I had the original Model, and I was trying to replicate it. The pic 01 and 02 are the Original ones. The pic 03, 04, 05, 06 are my Model. It is restricting me to enter the values:- Soft Drinks, Tea.... I even tried creating .txt file and import it but it failed too. I need your kind help for this. Please feel free to ask…
Import period format to Time Periods or Date formatted line items
As we drive to remove Text from our models, dealing with Dates is troublesome. When mapping files to Time Periods in modules, we can choose periods and define the format. For example, in my file I have YYYYMM. However, when I am trying to bring this data into a formatted list I do not have this choice. Even when formatting…
Import Failure while importing from one line item to another in same module.
Hi Can anyone explain me the cause of the error " No value loader exists for this type: NONE " . Any help would be appreciated. Thanks
Why won't my vendor roll up to my Total department. It seems to be only this vendor.
I created a a vendor call MISC. Its to group all the vendor under a certain amount to MISC rather than showing a bunch of vendor. When I select Total Department, MISC won't show up. But if I go to the specific department call N/A or No Department, which is the roll up level. It will show up. I tried moving N/A around to…

Importing and Exporting Data

Discussion List