Importing and Exporting Data

Timestamp - Current Time (Formula)
Hi there, I realise this is not something new or possibly already somethere out there ... but wanted to raise it (possibly again) to show how important that would be. There are instances that multiple users are using the system. Sometimes there is a case that those same users use exactly the same processes/actions. Given…
How to upgrade from 1.3 Anaplan API to 2.0
Hello community, Could you please tell me how to upgrade from API version 1.3 to 2.0? Thank you
Level 1 Exam - Model Building Activity 4 importing data file Employee Details by Role.txt
Hi The text file Employees Details by Role.txt is not importing the data properly. As the columns are not in proper order. screen shot attached. Would appreciate some help. Regards Thiru
Filter with time as page selector
Hi, I am trying to create an import with user input and have time as pageselector. When I created a filter to import data with the rows having user input and time as current page it actually filters first and bring the data for all time periods. Now if I bring time period to row and apply filter it bring multiple year data…
Upload a file (internal error)
Hello, I try to upload a file in my model, with API via a windows script like below. I try to upload like the api use requirements, but I ave an internal error on the second step STEP 1 : upload a file as a single chunk CURL --user user@xxxx.fr:password --header "Content-Type:application/octet-stream" -X PUT -d…
Clear the Target for a Module Import
Hello everyone: Anaplan provides a lot of flexibility in regards to clearing data prior to imports. You can read about all the available options here. In particular, I am referring to: * Clearing the Target for Time * Clearing the Target for Dimensions other than Time I have always used the default settings such as Clear…
Auto Order Lists and API Enhancements - Help!
Anyone know where I can get the instructions on 9/26 release notes to automatically reorder lists and what the API enhancements are? Looks like some game changer upgrades! https://community.anaplan.com/t5/Releases/What-s-New-September-26-2020/ba-p/85429 Tag: @Misbah @DavidSmith @rob_marshall @LipChean_Soh @ChrisAHeathcote
Need help in importing data into module
Hi I am trying to load data from .csv file into Module using import option. Data from one column 'PO Approved Date' is not getting loaded into the module.Please see the screen shots attached. Any help would be appreciated. Thanks Regards Prabakaran
NEW BUTTON I ADDED TO EXPORT THE GRID, DOES NOT ACCEPT THE FILTER SETTING
Hi guys. previously, my task was to add a new button to a dashboard, that include an export action. 1) now this is completed because of your help. 2) this new button exports all the data and this is problem 3) new button and included action does not accept the grid filter setting, and the export is always like everything…
Import Action issue
Hi Anaplanners, There is something I need an assistance. I have created an action to import the data, and the Module is multi-dimensioned. During the creation of the action one of the dimension "Match on Names or Codes" is disabled, which means by default we have to match it manually. Can anyone please let me know why the…
Text Encoding
Hi Anaplanners, Can you please guide me which Text Encoding should be used while import, when the data set have some data in Chinese Language. Thank you!!
Unable to upload Model history for Supply Chain Model after completing L2 MB Conclusion Exam
Hi Im unable to upload Model history for Supply Chain Model although Ive completed the Conclusion Exam. Is there anything missing/undone to be able to activate the link to upload the Model history file.
Level 1 - Importing Data into Product Details and Employee Details modules
I am hitting errors when importing data into both modules for product details and employee details. I am not sure if I am mapping it correctly or if I have created the modules / dimensions correctly in the first place. When I look at the exaple Model, my modules look different to the modules in the example model - I have…
Import Export Action Button
Hi All, I have a module with a time range(a customized time range created in Anaplan by the user) of 3 years(2018,2019,2020) where data is input for each month for the current year. We are providing an export/import button to the user on the dashboard to upload the data for the current year. But I am observing that on…
Anaplan Connect Install 1.4.4
I am installing Anaplan Connect for the first time. When I try to run the import script, I get the below error message. I do have the WorkspaceID in there. I also want to runt the script on a shared drive in Unix if possible. Can anyone help? Thank you. ======================================================================…
Access right for Import
Hi, End users do not have access right to import data to a module that they can edit. The module contain a selective access list. What can be the reason and how can I fix it? Thanks, Xin
add export qlik extract of an existing report to a dashboard
hello. anybody to help how to create a Qlik extract for an existing report and add this function to a dashboard? thank you.
Text to Date conversion
Hi All, My import has dates in following format: "01-sep-20" and I want to convert it to monthly date "Sep 20". I was trying combinations of PERIOD, DATE, VALUE: PERIOD(DATE(VALUE(LEFT('DATE (txt)', 2), MID('DATE (txt)', 4, 3), VALUE(RIGHT('DATE (txt)', 2)) But it seems that it won't work because it doesn't recognize…
Log for load
Hi Anaplanners, Is there a way by which I can get log history of records, when data is loaded through Integration. Ideally, the history log in Anaplan can just let us know for the number of records which gets loaded, not the one which were ignored. Is there a way to find that through Anaplan? Ideally if we manually load a…
add a button to a board and assign an action to it
hello everybody. I am a new here. was assigned to a relatively easy task, but do not know how to solve it. to describe the case: 1) there is a working dashboard. 2) for example it has a grid and an extract button. 3) now my task is to add another extract button, to export what in the grid into a .txt file, so the managers…
add new item to an existing dashboard
hello. dear anaplan community. I am new here. I would need help with adding new items to an existing dashboard. anybody who can help? thank you.
Imports using API
In the link below, it says that in order to carry out an import, "You must be the user who created the import definition. You can only import using the import definitions that you have created". Does that mean that the imports are user-specific? Or would the API be able to use any action that had been set to admins only?…
Level 1 SYS08 Employees Details Module
Hi I was able to import the details without any error messages and I have progressed through to lesson 11. I just have one question about the module that I see. Why is the Dept Code in full such as 'Sales' and why is the country code in full such as 'Canada'. If it is the code shouldn't that column have only codes? Or is…
Issue Importing on Code
Hello, I am having issues importing data between development models via saved view. The model is trying to import Activity and Account Categories based on Name (or line #), whereas we need it to import based on Code. I'm not sure why this is defaulting to import based on Name, since these Activities and Account Categories…
Run an action in Anaplan using Informatica Cloud
Hi there, I have an action that will load data from my HUB model to Prod model. Usually we go into the actions tab and click Run on the action itself. Can i create a job in Informatica Cloud to run this action for me? When i create a new task in Informatica Cloud, it asks for a source and a target. Can i simply tell it to…
IS Summary
Hi All, I just wanted to understand the importance of Is summary in Anaplan. I have a module created with Is Summary switched on for a line item in my module which is preventing that line item from coming in the export view taken out by omitting summary items. When I remove the checkbox from is summary for that line item I…
Data import of different Dimension
I apologise for asking a basic question. As I have none to assist, so seeking assistance from Anaplan Community. The Source Data Module has Yearly Values. The Target Data Module will copy all the values in Weekly as well as Monthly. Please assist me, if any Document is there in Anapedia, mentioning the way out.…
Urgent ques
Hi Friends, I have Dev & Prod model sync. After that I have entered few data in Prod (imported 5 times) but didn't sync. Now I find data was wrongly entered and I need to revert back to data (2 times back as it was). If I restore to Model History, will I lose the sync. Or as sync hasn't to do anything with data, it won't…
ALM sync
Hi Friends, I need a help. I have Dev & Prod models synchronised. Now if the Prod model is removed into a new workspace will the sync be lost?
how to add Export Qlik Extract into an existing report
Hello guys. Can anybody help me to go through this? I need to add * Export Qlik Extract into an existing report thank you.

Importing and Exporting Data

Discussion List