-
Automating Import from csv file
Hello experts, We are looking at scheduled import to Anaplan through custom integration and I have a question around that. Context: There will be a csv file provided on a server periodically and the import needs to be automated. 1. I read that it it is only once I manually import a file to Anaplan, that there can be an…
-
Is there a way to lock a period when doing imports?
I have done dynamic cell access to lock periods in a module. This is working fine when doing direct input to anaplan. But when using import function, even if access is only ready only data is still loaded in Anaplan.
-
Continuously polling an operational model using Rest API
Hi Guys I have been requested by a client to continuously poll Anaplan Operational Model ( every 1 min) to EXPORT data from a module . Module is relatively small so about 20 rows and 2 cols . Right of the bat this doesn't sound like a great idea to me due to potential lock up of the model etc. therefore i wrote a Python…
-
Scripts and Java and MS Access
Hi, I have an overnight script that imports data from an MS Access query into a list, this worked fine with the old certs and the 1-3-3-3 environment. Now I have had to update my scripts and use 1.4.2 and there seems to be a problem with the url. Old script -jdbcurl "jdbc:odbc:EPOS" -jdbcquery "SELECT * FROM qry_EPOSLive"…
-
User Information
Hello, I am trying to create a model that pulls all the user information (Model roles, First Names etc) from each model in our system. This is really useful for Auditing purposes. Is there any way to import from the user lists in model settings to this model, or alternatively to create a dummy module in each model which…
-
Continuously polling and downloading data(every minute) from operational model
Hi All , I have a requirement to continually poll(every 1 min) and export data from an operational Anaplan model . I expressed my concerns about locking / slowing down model therefore to test it out i wrote a script which runs every min and downloads data from an operational model . Data to be downloaded is relatively…
-
Excel Add-In Licensing
Hi All, We would like end users to be able to use the Excel Add-In to access Anaplan modules, so they can build formatted reports using that data. Am I right in assuming that these users do not need to be Workspace Admins with a Model Builder license, as long as they are simply accessing the data in pre-built modules (i.e.…
-
Introduction to Data Integration
Audience: Model Builders, Data Integration Specialist Summary: Hungry to know more? Anaplan Advanced Topics are deeper dives into specific areas of Anaplan. Data is everywhere, and our customers are eager to know more about how they can get data from their databases and into their models. This process is called data…
-
Losing data from saved views & processes
Hi Team, I have a process that exports three saved views from 3 modules, however when I run it, it doesn’t capture all the data that’s in the module. I think some line items are missing. What is the best practice to either: * Ensure saved views are dynamic and update automatically for when new list items or line items get…
-
How to import multiple header rows into a module?
The import file is an export file from a module that I am working on. There are several header rows that I need to import into the module. How can I do this? Jan 19Jan 19Jan 19Jan 19Feb 19Feb 19Feb 19Feb 19Mar 19Mar 19Mar 19 ActualActualForecastForecastActualActualForecastForecastActualActualForecast…
-
Print or get source to target line item mapping through API
Hi Anaplan community, I wanted to ask whether there is a way to print out the line items' source --> Target mapping through the api. This is when a model builder is doing an import and gets to manually map data from the source file to the target line items. Much appreciated!
-
Excel Add in
We have a reports pack in excel which used the excel add in to link to various Anaplan modules. I recently created a copy of the model to run a scenario in but am not able to change my reports pack to link to this model rather than the usual live one. Does anyone have any experience of how to change which Anaplan model a…
-
Import from File vs Module
I’ve been running the Model Optimisation training in recent weeks and one of the benefits of Data Hubs we talk about is that Model to Models imports are faster than exporting to a file and re-importing from a file. The question is always “by how much?”, so these are the details of a test we did in April Performance test of…
-
CA Certificate Authentication and Forced Password Resets
Hi Experts. My client is concerned about the 90 day password reset for their system IDs. If they switch to using a CA (certificate authority) will they still need to reset the password for the system ID they associate the certificate to? I didn't see anything in the documentation about it so I thought I would ask here. The…
-
Anaplan to Tableau connection
Hello Everyone, I am trying to use Anaplan to view my data in tables but not lucky. Is there any way to obtain the data from Anaplan and see them in Tableau? Already tried a lot but no luck. Please guide Thanks in advance James
-
Postman POST command to run process is stuck in "NOT_STARTED"
Hi experts, Hope you can help with this. I'm running a process that runs an import action from Postman and I get a status 200 every time. The problem is the process isn't running. When I check the status I get "NOT_STARTED". Does anyone know why this is happening? The process is an import action that updates a boolean (1…
-
word count limit when import data
Hi Anaplan, I would like to know any word count limitation on Anaplan when we are import / create the data model ? Reason of this question because I got a data table but it seem I can't import the lines if the words over 60. Best Regards, Kiwi
-
Does the Anaplan styling in the excel add-in work?
Hello, Does the Anaplan styling in the excel add-in work? I have connected to the same module twice: first with 'Apply Anaplan Styling' option selected and second time with this option de-selected. I do not see any difference with the table display. Anaplan styles do not seem to be showing:
-
API Invocation failed
Hi Anaplanner, I want to import list to list form another workspace, but I get error API invocation failed: HTTP/1.1 401 Unauthorized, how to fixing? Thank you
-
Rogue data appearing after Import
I have a Module with many line items, and time using w/c and versions I have a saved view and it looks perfect. I have another Module with 3 line items, and time using w/c and versions. I import data from the 1st Module to the 2nd Module from Version: Latest Estimate to Version: Forecast -1. It imports data that does not…
-
Unable to import large file
attached screenshot
-
Updating Anaplan Connect 1.4.2 documentation to align with example batch files
Hi all, I recently updated to version 1.4.2 of the Anaplan Connect Client. I noticed that the format of the examples listed in the documentation is different to that of the example batch files provided in the download. I was having difficulty getting the script to work when following the documentation instructions, but as…
-
Adding a code to an item in a numbered list
I am working with the New UX and used "Form" to insert into a numbered list. I do not want to depend on the end user to create the "code". Is there a way to add the code to the list item via import? Cannot import by code because the code does not exist yet. With the Classic UX, I used a module to have the user enter…
-
Export Data Sources
Hi Team, Colleagues, I don't know if this has been brought up by now as I am not able to see any similar topic. Is there any possibility to check export data source, especially Module saved view it's pulling from? If not, are there any plans of upgrading to this feature? For us, would be a life saver as we use multiple…
-
deleting an Item in a list import
Hi All, I was trying to import a list from another but came to know that when i add an item in source list it gets reflected but if i delete an item in source list it does not gets reflected in target list. is there any way to implement that part?
-
Data import with non-numeric values
While importing data from one module to another, one of the fields "currency" is non-numeric. For example, we will have the following records: Product A, Customer B, 02/2020, 1000, GBP Product A, Customer B, 03/2020, 2000, USD In the case above, the data values are loaded correctly to both months, but only the first…
-
Deletion of numbered list consequences handling
I have created a module where i have some list formatted line items and some number formatted line items (all as columns) along with a Numbered list with display name as 1,2,3,4,.....(manually given by us) to create a blank view for the end user to enter records in each row(for reference; see the below attachment). The end…
-
Period format in export file.
Hello, I am saving some export definitions for my client. To print all the codes in a flat .csv export file, I would have to put 4 or 5 dimensions in the rows, but it's limited to 3. Instead, I am using the tabular method with a filter for time and version. The only problem is that when time is transposed Anaplan changes…
-
Import Issue
Hi, Please see attachment. Regards
-
Action on numbered list
I have created a numbered list and an action to add new items. Is there a way to ask the submitted to add a textfield so the new list item doesn’t appear under a List id number?