Importing and Exporting Data

Anaplan connective with SAP BODS - Data exchange
Hi All Need details related to Anaplan connectivity with SAP BODS 1. Do we need Hyperconnect ( informatica ) to connect with SAP BODS 2. If yes do we have a standard SAP connector We are wanting to have DB to DB connections . Regards Manas Malhotra
Importing and Exporting Data
Hi all, This is not working for me(The employee Details). I have selected various combinations for mapping but report not coming right. Guide me on the correct details to map please from the attached. Thanks in anticipation! Regards, Eboseremen
Import Error
Dear, Whilst importing a .txt file into the Datahub we encounter the error 'unmatched delimiter character at line 100968 character 17'. Tried looking in the datafile and erasing the datarow and uploading again but nonetheless we have the same problem. Hope somebody can help.
Wrong Display of Import and Mapping Assignment 7
Hi all, After importing and mapping of products details using both view options, my report is not in line with the sample on the training manual. The value of size did not display properly. See attached. How do I map to get the correct result
Ignoring some columns when mapping timescale through column headers
When we get a source file with time in the columns it is very common to have columns that are not relevant for the mapping. As time usually requires using an "automatic" mapping it is quite inconvenient that columns that are not relevant are processed as a FAILURA in Anaplan. It would be fantastic to have the option to…
Why might the most recent entry in History not match the data shown in a module?
We have a module whose data is populated from a CSV. We import the CSV to a numbered list, and then import the numbered list to the module. We can see non-zero data in the module, but when we show the history for a populated cell, the data values in the cell are zero. Why might this be? Strangely, the row below, which is…
Lesson 8.5.3 Import Data into Volume Inputs Module
how to make time in correct form so that i can get output
Import Data into Product Details Module
Why i am getting constant value for size????
Sprint 1 Importing Data 1.3.10.2
Hi, When I import country data it is not rolling up to the parent. I have configured the parent in the G2 Country list but it does not roll up after the import. I have attached a couple of screenshots to show the same. Appreciate your help
PlanIQ - failure to add Attributes in Forecast Model
Hi Community, When in PlanIQ I run a Data Collection that contains historical data and attributes, the Data Collection fails. I receive an error message saying that attributes don't include all items in historical data (screenshot attached), which is not true, because I use exactly the same list of items in both…
App Related Exports
Similar to how you can export a list of all models in a workspace, we need the ability to export the Apps in a workspace with a report of the connected models. Additionally, as pages & apps are archived when the connected model are archived, knowing the connected apps/pages with archived models should also be included in…
New UX: Model Status/Refresh Messaging on New UX Page
Idea is to have a message or status on the New UX page in order to notify user that something is happening in the model that is causing the model to queue or be blocked (examples include: save state, actions, etc.). The lack of messaging causes massive frustration for users who think the New UX page is "slow". The classic…
L1M1 12.4.6 activity. Create Saved Views for Employee
Hi All, How to add E2 Employees#: Active? directly to pivot. I tried to find the option but failed. I have subset E2 Employees#: Active? in E2 Employees#. How can I add this subset to pivot? Please help. Thanks, Balarama Krishna
Struck at L1M1 12.4.6 Activity: Create Saved Views for Employee Expenses
Hi All, I am struck at this. The training materilas asks Create a new saved view: * Pivot the view: * Pages: E2 Employees#: Active? * Columns: Time * Row: Line Items * Filter: Show Forecast Months only * Save and name the view: Forecast Periods My Pivot shows In my saved view everything is showing correct but I am not…
regarding facing problem in level 1 lesson activity 7.2.3
i am facing problem in level 1 lesson 7.2.3 import data of employee details
about sum functon **** we can get the data last from 6 months actuals?
i have actuals data from last 6 months ..i have created last 6 months line item to get the data here .. Then how can i write the formula here .. Example Jan Feb Mar Apr May Jun July Aug Sep Actuals 100 200 300 400 500 600 700 800 900 last 6 months 0 0 0 0 0 0 0 0 0 Present my module is like above format so i need last 6…
Model to model Import
Hi All, Which function will go for avoiding duplicates when we are importing from model to model?
Help me with 7.2.1 Activity: Import Data into Product Details Module
Hi All. I am brain storming with this issue from last 12 hrs and checked all possibilities to do Import Data into Product Details Module task. I deleted my SYS06 module and recreated and checked if the formulas in line items are correct etc. Also check size list under general lists. I attached all the screen shots required…
502 Error for Large files
I am trying to load a very large file using a library partially built by Jesse Wilson. I am using the attached code, but am receiving the following error after about 40 minutes. For smaller files (files that take less than 30 minutes, everything works fine) 502 Server Error: Bad Gateway for url:…
Anaplan Connect Export Scripts Question
Hi Dear All I started learning export data by using Export Script through Anaplan guideline, but I found the script is a little different from the script which I found here. And my question is whether I write scripts by copying which one, an errors came to me, would anyone can help me to check my scripts? Thank you And I…
New UX: Ability to view and export "codes" as labels in grid view
When producing a grid table, it would be useful to have the option to also bring through the code in a separate column/row next to the display name and have the ability to show or hide these depending on the user requirements. Likewise, having the option to export with the code. A small example is below. I note the export…
2.3.9.1 Import Data into DAT03 Historic Volumes module
I do not understand why I have to upload the file again...
Split admin and users input in the logging
In the history logging, split the changes made by regular users and by admin users (automated or workspace admin) so you can easily check what has been entered by users. As an alternative this can even already be achieved by splitting the manual input and the process driven changes. Currently we cannot see what changes…
Anaplan Connect - Put file gives Array Index Out of Bounds
Hi, I am having some issues with running one of my Anaplan Connect scripts to import a file & run a process. When trying to upload the file, I receive an error "Array Index Out of Bounds: 0". When I run the process from the Anaplan website and import the same file there, it works perfectly. When I run the script, using…
Import data error
Hi, In the above mapping, how could I correct the errors. The drop downs don't have other options to select. Can someone please advise. What am I missing? Thanks, Balaji
Level 2 Sprint 1 1.6.2.2 Create Saved View for Export
While importing Shipping Metrics.csv to module DAT02 Shipping Metrics, you may get invalid data format error. To solve the problem: simply edit the date format by Untangling Anaplan Time Mapping: to edit the FY( fiscal year) use: ??YY This solves the error. FYI
L2 - 1.5.6.2 Import Data into Historic Volumes Module - Issues uploading data
Hi, Im having issues importing the historic volumes file. Below my selection for importing the data But when i run the import, the data is ignored. See below Can anybody help? Thanks
ANAPLAN API 1.3 WTH PYTHON || IMPORT FAILED
Hi All, I am trying to import an file into Anaplan. I have run the import action using python. I am getting status code 200 and when i have checked import status it's showing successful but the data load is not happened in the module. Kindly help PFA Thanks, Sai
Cloudworks : Failed to Load Action Steps
Hi, I am encountering an error in cloudworks, when I am trying to create a process and I select an action, it says 'Failed to Load Action Steps' This is happening for a all the models and their process in a particular workspace. Earlier the same actions were working perfectly. Any help will be appreciated Regards, Aakash…
RESTAPI : Run a process with an import action
Hi, I'd like to know if it's possible to run a process with an or several import(s) action in RESTAPI ? I successed to import data using only an Import action. As we don't have an example on the documentation, I tried to just change the importTrigger function. I change "/imports/{importID}" (see below…

Importing and Exporting Data

Discussion List