Importing and Exporting Data

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…
List Update Behavior - Manually Add an Element vs Import the Element
Hello, I have noticed a behavior on the list updates and I am not sure if this is normal, or is it something I am doing wrong. I have the S2 Supplier list that is updated by users, based on a module, where they enter the name of the supplier and the parent. Next an import action is run to update the S2 Supplier list based…
Import Issue (simultaneous uploads by external APIs can not be recognized within Anaplan)
One of our major customer is asking this issue to be raised as an enhancement request. The issue that they face is summarized below: Import A (with 60,000 records) and Import B (30,000 records) will simultaneously happen from an external API action. Import A will time out, however upon completion Import B will recieve a…
Exporting a saved view
Hello, I've created a module with 2 lists and line items . I saved 3 views, in which i hided some line items of my module so the saved views are showing different line items of my module. I tried to export a saved view choosing 'Tabular multiple column' , I have in output a file with all the line items of my module and not…
Importing into module
I'm unable to replace the highlighted parts with the name of employees while importing. Can you help me to do it right ?
1.3.4.3 Update SYS07 Location Details Module - Issues importing data
Hi, While performing the step referenced above, the field Region does not upload. I think the reason is because the flat file "Countries" contain regions in the format "AMER, EMEA,APA", while the flat file "Locations" contain regions in the format "Americas, Europe, Asia Pacific". Im wondering if i am missing any step in…
Anaplan restful api uploads with zip files
Hello, I have a question about using the Anaplan integration API V2 guide. Is it possible to upload a csv document inside a .zip file to Anaplan? I'm able to manually upload a zip file with a csv in it, which works, but cannot figure out if its possible to do it with the API. I'm trying to do this with Postman but the data…
Updating Lists on Transaction Data Import
Colleagues, hi! I'm seeking your advice on the following case: on a weekly basis, there will be a transaction file with the unique "purpose of payment" texts for each transaction and potentially new suppliers that don't exist in Anaplan list yet. How can we achieve automatic update of supplier list upon import and having…
REV02 Import mapping Problem
i am trying to map Volume+Inputs file.csv data into module but Cant seem to get data map. Tried Multiple methods. But cant seem to find a way. If anybody can help then comment down. I m also attaching the problem.
Import action should not ignore Selective Access for a Workspace Administrator
Description of the enhancement required: Workspace admin with applied selective access to only one region had affected data in other regions because selective access does not work on Workspace admins. An example of the enhancement: As a workspace admin if I change my profile to only have access to a specific region, and…
Python and Anaplan: Pt 1—Setting Up Your Environment
Combining a scripting language such as Python with Anaplan can provide you and your team greater flexibility and functionality in your planning journey. If you've never used Python before, or want to check out some different ways and use cases of Python and Anaplan, look no further—this series of articles will introduce…
Mapping issues related to Activity 8.5.3
Hi, Need help in this Level 1 Model Building exercise. Though I did not get any errors after importing the data and mapping, the G3 Location Tab does not look right. Secondly, the pivot table in the line item view has to be changed. The volume needs to be before the Nutzo Bar. See mark up on Line Item screenshot (attached…
How to import a csv file into a module where the only reference is a single line item (text format)
Hi, Any idea how to import this csv file: into this module: The third column (PR Number) is in text format (8 characters truncated from the first column) and its not a list nor a parent/child of the first column (PR line). Parent of the first column (PR line) is something else i.e Material. I have nothing from Source to…
Initialize a specific dimension using another dimension from the same module
Hello I currently have the following problem : All the modules that constitute my model are run by a dimension "3 year Planning scenarios". This dimension is a list of different planning scenarios, each one has a different year of start as a setting ( initialized in a unique administration module) . What i'd like for my…

Importing and Exporting Data

Discussion List