Importing and Exporting Data

Stop a process in CloudWorks
I kindly ask to add a "stop" option in CloudWorks Integrations Menu, because I have a process which is stuck and I need to spent a lot of time to delete and re-create it every time a process doesn't work. Thanks in advance!
Save model out of Anaplan
Hello, I'm soon going to lose my access to my talent builder workspace that I was assigned to obtain my model builder certification. However, I'd like to not lose the models I've built in this workspace. Therefore, is there anyway to save my models out of Anaplan (like a file on my computer for eg) to upload them later in…
Date Format Conversion
I have source data DATE format as 01-01-19(MM-DD-YY) . I need to map this date format to destination format as JAN19(MMYY). 01-01-19(MM-DD-YY) -> JAN19 (MMYY). Kindly someone help me in this .
What is Anaplan Live!???
Hi there! I would like to know... What is Anaplan Live Event? I can see pop-ups every day but I can't find clear information about the event. Thank you in advance!
Change 100items at the same time,from "Clear target prior to import" to "Only update imported cells"
Hello Anaplan! It will be very helpful to bulk updates in the Actions settings. In particular, the setting "Clear target prior to import" to "Only update imported cells" in 100 items at the same time, rather than doing so 1 by 1. Anaplan, Could you create something to do so? Thank you in advance!
Change 100items at the same time,from "Clear target prior to import" to "Only update imported cells"
Hi there! I would like to know how can I change one settings characteristic in my Actions. In particular, would be to change from "Clear target prior to import" to "Only update imported cells" in 100 items at the same time, rather than doing so 1 by 1. It would be very usefull. Thank you in advance Community!
L1 Model Building - Lesson 7 Data Mapping issue
I was able to import everything but the formula CODE(ITEM('E2 Employees#')) does not seen to be working. I see everything correctly EXCEPT data in Code line. Any ideas? I already tried saving the downloaded file with opening.
How to get data to come in
Hi, We are currently have a module that is dimensioned by a list of dates. Trying to figure out what is the best formula to use to bring List data in as a date for a LI.
7.2.1 product data import
Hey Community, I tried different ways to import data, but still i am not able to match code , can you please help me out. I am attaching screenshot below.
Anaplan Connect - Export Script
Hi, I am getting the following error, followed by a list of options in my CMD window when i run my batch file. My batch file is as follows (minus credentials and export names); @echo off Set AnaplanUser="Username:Password" Set WorkspaceId="XXX" Set ModelId="XXX" Set Operation=-export "XXX" -get "XXX" rem *** End of setting…
DEM 01 Volume Growth rates
Hi there! I've uploaded the file as per the exercise, changed the date to the MMM-YY format. It says 96 items updated. However, the module is showing the value only for January. Please help me with this! Tulsi
Export List of Users Access
Does anyone know how I can export a list of what users has access to each entity within Anaplan?
Level 1 Model Building Exam Activity 4 - Roles Import Error
Hi there, I've been stuck on the import into the SYS08 Employee Details Module (Activity 4). When I run the import, I get the error below: I think this is what's preventing me from sourcing the right answer for Question 5, since the mapping on activity 5 works well for me. Here's how I set up the Roles list: and I've added…
Input module
Hello everyone, I've created an input module where user can fill automatically some data. I need to create a rule to load the new data entered by the user in a collection module. The collection module should has the same dimension as the input one, but I'm not sure which formula I need to use. I don't want to use a Boolean…
no values for FY20
Hello all, i am doing level 2 Sprint 2 activity 2.3.9, where i need to use FY 2019 data in order to populate FY20 (ofset formula). My model calendar is at FY 20 while time range is for 2019. but for some reason when i scroll to the right there is no 2020. i might have missed something in previous steps, and now i am…
Unable to find correct formula
Can anyone help me with this, please? I'm unable to get the correct formula for this.
INV01 Ordering Inventory Export
My export file seems to have everything okay except for the 3rd number onwards on the first row. And I used this formula IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
Renaming line items should be propagated to import definitions
Currently renaming a line item correctly updates all module formulaic references. However, it does not get propagated to import definitions and Anaplan silently "ignores" the change i.e. the target column stops getting populated without any error or warning. Ideally name changes should get reflected in all aspects of the…
Data import analysis
Would be very beneficial if Anaplan provided more details on the data imported. Besides the normal error log, it would be helpful if e.g. max/min values, outliers, exceptions, trends, most/least frequent items, dimension items count etc. could be displayed upon import to help the user do a quick sanity check of the data…
Rename List Items
Hello, I have a List with names only and no codes. The names in the source system are now increasing beyond 60 characters. I want to change the naming convention in order to accommodate the size limitation. I know I will need to add a code in order to change the existing names. However, if I rename List items, will all…
Exporting Saved View & Tabular Multiple Column
Before I go off to support and see if it's a "problem" just want to make sure that it's not me! Have a saved view that has filters on the page selectors and am then looking to export this view using the tabular multiple column option (there are three dimensions as rows already) but when the export is run I get every…
Allow Multiple Item Mappings on Imports
Sometimes when I import data into a line item or column, even though they match directly with the existing column, I still have to manually map the items. Sometimes I have a very large list of items which can span to over a hundred. When the auto-map does not work I have to manually map each one. How possible could it be…
Anaplan Cloudworks and Connections
Anaplan, Director of Product Management, Dib Banerjee, with Sean Culligan @sean_culligan and Kirill Barshevsky @kirill.barshevs share some insight into how Cloudworks can help you better integrate data into your Anaplan use case.
L1 SYS08 Employee Details module - Import and Mapping Issue
Can anybody please write down the steps for the particular SYS08 - import and correct mapping As after several attempts and struggling to get it right . Appreciate your support guys.
Level 2 Sprint 1: 1.3.12 - Can't see "Build Region" and others in "Build Geography Hierarchy"
Hello, I am on "1.3.12 Create a Process with Multiple Imports" of Level 2 Model Building: Sprint 1. I edited "1. Build Geography Hierarchy" process but can't find the below highlighted Imports: Instead, I can see the below imports where the action name seems to be the path from which I imported the saved views. Are they…
Import Error : Shipping Metric
I tried to run process 9 - Import data from Hub. The issue is similar although it's failing to import into the Shipping Metrics. No details of failure is provided. I checked for data mapping by trying to import just the shipping metric Not able to successfully import the shipping metric. Can someone point me what's the…
Level 1 Exam - SYS08 importing employee details and data in "Role" cannot seen....need solution
Unable to pull data from DEM02 module into DEM03 module
Dear Experienced Anaplanners, I am at Level 2 Sprint 2 trying to use formulae to add data to Demand modules. As per the lesson, I've created DEM01, DEM02 and DEM03 modules. DEM01 and DEM02 are Volume Growth Rate by Month and Volume Growth Rate by Week modules respectively. I have used formulae to pull data from DEM01 to…
Data Import error
The target mapping The Source mapping The dimensions are different in source and target. I am unsuccessful and having issues with successfully importing into the module. Any suggestions on where I'm going wrong?
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello, I can't seem to figure this error out. Any advice? Thanks!! -Michael

Importing and Exporting Data

Discussion List