Importing and Exporting Data

Importing Multiple Rows based on a Quantity Value based Cell?
Hi Everyone, I was wondering if anyone knows or has experience creating duplicates of an Input Row and all of it's associated components based on a quantity line item? For example, if I wanted to create 5 new employees that will have the same salary and reside in the same state and cost center. Is there any techniques that…
Import and Automate Current Date Import to Anaplan Using Python
Connect or Python Summary As a supply chain Anaplan data integration modeler, you might be asked by your business partner to display actuals for elapsed periods and forecasts for unelapsed periods. If you are not using the current period, which must be manually updated by a workspace administer, and you want to automate…
Backup - Archive PY cells
Rather than functioning towards excel for the previous year / excluded year data to save for future. There must be a process which will archive the data as soon as year got changed in TIME settings (with the warning popup) within given model and ready to refer as and when require. [Benefit]: Get rid of multiple models…
Timeout error while CA Certificate Authentication for file Import.
Dear Expert , I am trying to Import Data into Anaplan via Anaplan Connect Script. I am trying to Import with Certificate based authentication in Script but getting time out error as shown below. Could you please help me with the solution to deal with .Is there any ways to see the error log?? Script : @Echo off rem For…
Level 2 Sprint 1 DAT03 cells blank
I am at the end of Level 2 Sprint 1. I am going through the checklist to make sure everything was completed. When I got to DAT03 I noticed there is no data in any of the cells. When I did the first import, there was data there. So, I reimported the data from Historic Volumes and it said the import was successful, but I…
TIP: Anaplan API with Postman
Doing some work with the Anaplan API recently I found myself annoyed with having to copy/paste the tokenValue you need for each subsequent command after authenticating via https://auth.anaplan.com/token/authenticate. Below are some tips I found on how to automate it: * Create yourself a Postman Environment and store your…
Automate Process Running in Anaplan Model
Hi Guys, Is there an easy method of scheduling process running in Anaplan? Our consolidation process is not live and requires data pushes through inport actions within the model - that we need to run at certain hours. Basically we would need to open Anaplan model and run the process that we can even attach to a welcome…
3.3.5.1 Create Inventory Ordering Module Beginning inventory
My beginning inventory is in Negative. Why is this happening? Is there anything wrong with Beginning inventory or ending inventory formula? I have attached screenshots.
Lesson 2.3.9 Running import - Process 9
Hi I got this error when I run the process. I noticed there are two source models for the same action in the supply chain model. One created by Anaplan and another created by me when I built the Data Hub model. As follows: Then I tried to map the source object model I created when I completed the Data Hub model to the…
Level 2 Sprint 1 DAT03 Historic Volumes error
I imported data into my DAT03 and it populated all of the categories, but when I compared it to the screen shot I realized I have data in my Jan19 column and it's not in the Anaplan example. How do I get the data out of that row? I reviewed the previous steps about setting up the time range and it looks like what they…
Level 3 query
Hi Friends, I am not able to understand the exact requirement of the question. What is the total sales target for the medium sales account in Canada?
L1 Model building - error when import data to modules
Hi, I am still in the training course and now in lesson 7.2.3 When I tried to import the data to the module, I couldn't map most of the fields and got a lot error message So basically all the empty fields are not catching up with the source file. Does anyone have similar issues? Thanks!
NEW UX - Export Boards as PDFs process
Hi Anaplan, It would be great if the NEW UX had the capability to export boards as PDFs for reporting. Many customer are asking for this as they have previously created many reports using this in the OLD UX so would like to see the functionality in the NEW UX. Thanks, Usman
Error when updating hierarchies with list items
I'm trying to update a list hierarchy from a module, which I have updated with an import file, and everything seems to be working just fine, that is, my list items are updated. However, since I have the same list item occurring several times in my import file, and also in the module I import from, I get the error message…
Search an item in Module in a specific range
* Module dimension: Department, Country * Line item: User Name. (Formatted with a fake User List) I'd like to get all unique User Names from a specific Department 'ABC' and ALL Countries, with these unique user names, I'll able to build a list. I tried to create a subsidiary view in the module, dimensioned with fake User…
Ability to add dimension headers in exports
There should an option to add the dimension header that are placed in rows while exporting by end user using the export option is grid. For example if I am using the SKU list as the row dimension and user is trying to export the data from the grid published in pages, there should be an option to get the SKU as the header…
L2 Sprint 1 G2 import from SYS06
I am trying to import SYS06 data into the G2 Country List. I have reloaded my Country flat list. When I ran the import this is the result I got:
Mapping error with dates
Hi, I'm getting a mapping error with my dates because they are not formatted identically. How can I fix this without going in and mapping each date to one another manually? Thank you Pics attached
L2 Sprint 1 G1 Import from saved view in SYS05 Region
I have been trying to import the saved view in SYS05 Region and I keep getting errors and I don't know why. It seems like there is a disconnect between what is in my G1 list and SYS05 Region file. Thank you for your help.
8.3.2 REV02 Date Upload problem
Hi All, I am uploading data into the Level 1 Practice model for lesson 8.3.2 and am having trouble mapping dates- the format I am using is showing invalid, even thought I have selected the periods>YYYYMM format. Any troubleshooting ideas would be appreciated!
Setting chunkcount for export actions
I noticed that every time I save an export definition, the chunk-count definition is set to 1. However other files created earlier have their chunk-count set to 0. Is there a way to select the chunk-count definition when creating an export action? (small file, no need to chunk. And only files with chunkCount 0 or large…
What should be the date format for jan-20 while importing in to lists
In the attached source file how to import in to the list with format jan-20 and what should be custom fixed position....
DigitalCPX 2020: Expert Advice: Anaplan API & Python w/ Christophe Keomanivong
Fully on board with Connected Planning? Looking at expending your sources to the world wide web? In this session, we will illustrate how to use Python to import data into Anaplan from any remote source. https://www.youtube.com/watch?v=MyhxirGAGI8 We will focus on getting started using Python as your steppingstone for…
Delta load to Anaplan with informatica cloud(hyper connect)
Is there a provision to load only the change or new data instead of importing the full file to an Anaplan module in using Anaplan/Informatica Hyperconnect?
Fail a process if any subsidiary action contains errors
I would like the option to fail an entire process if one or more actions within that process contains errors. For example, if any errors exist when updating a list, I do not want the next import to run that loads properties of that list into a module.
Anaplan Connect Error
Hi All, I have an issue while uploading the file via Anaplan connect. Following is a snippet of the error. > > _2021-02-26 17:35:07 INFO [c.a.client.Service :83 ] 1532 |-- > Initializing Service..._ > _2021-02-26 17:35:07 INFO [a.BasicAuthenticator:26 ] 1532 |-- > Authenticating via Basic..._ > _2021-02-26 17:35:11 INFO…
Level1 Model Building: Import into DAT01 PL Actual and Budget module failed
Hi All, I am facing issue on importing data into P&L Actual and Budget Module For your information, i have mapped time as Period (YYYYMM) Import into DAT01 P&L Actual and Budget module failed: The column headers in the file you are attempting to import do not match the import definition. Have attached mapping and error…
Scheduling refresh in Power BI
I am using Anaplan Connector for Power BI to export data from Anaplan to Power BI, instead of manually refreshing, is there a way to schedule the refresh in Power BI ?
Import failure based on module cell count?
I have just submitted this to Anaplan support, but wanted to run it by the Hive Mind. Any insight into what's going on here would be appreciated. I will update this thread with any answer I receive from Anaplan support! We had a very puzzling issue last week that prevented loading of data. We resolved the issue, but the…
Jumbled Process
Hi All, I have a process named "Import From Data lake SP SG FOM" where lots of actions were placed. For instance, My actions in the following order . Today date.csv and import stock Expiry DC-9205,9209,9207 are to be uploaded files. When I publish the process in the dashboard and click to upload the files, the upload…

Importing and Exporting Data

Discussion List