-
Anaplan Connect network traffic flow
Hi all, I need to know the architecture of Anaplan Connect in order to decide how to set up the server where Anaplan Connect runs. Is the network traffic from Anplan Connect to Anplan and Anaplan to Anaplan Connect bi-directional? Thanks.
-
Anaplan Connect - Use of Certificate in script does not work
Hello, I have the following script written up to update a module to hold Today's date and time. The script worked fine when I was using my username and was prompted for the password. As I am looking to schedule this script everyday, I want ahead and downloaded the certificate linked to my user and changed the script as…
-
Cant edit saved Import
A month ago I created an Import from a CSV file to a numbered list, included the import in a process action and published the action to a dashboard. When a user clicks on the button they are asked to browse to a source CSV file and click OK. If the CSV file is in the expected format the Import works. However if something…
-
Import to a List
Hi, I have created an action to import from module to numbered list(List X) with properties. There is a list formated line item(Format: List A) exists in saved view. List A has list items in such a way that abc123 and ABC123 belongs to List A. When I run import action, action runs throwing error for above list item. Please…
-
Anaplan Connect to MS Access
Hi All, I am trying to use Anaplan Connect to import data from MS Access table to Anaplan list. The table has only one column containing list values. I have created Anaplan import action based on text file with similar structure i.e. one column file. I create jdbc.properties file as below jdbc.connect.url=…
-
Importing users in deployed mode
Hello Everyone, Could anyone please advise on how we can import the users in deployed mode? Is it possible to import the selective access fields as well? Thanks in advance..!!
-
Updating Organization List - best practice
Hi I have a module that works out accruals & prepayments by contracts and when each contract gets added it is mapped to an organization parent. The issue I have is that the organization list constantly changes each year and therefore needs to be remapped. I know if i delete and import a new organization list, i will lose…
-
Excel Add-In: why I have to add COM in every time in Excel
Hi Everyone, Anyone knows why each time when I open the Excel, my Anaplan Excel Add-in check box is lost? I have to manually add it back in, by clicking the below check box "Anaplan Excel Add-in"? How can I make it there always available by default? It worked for me in the past, but did not work now since I upgrade to…
-
Exporting data to other system but triggered inside Anaplan
Hi everyone, I would like to explore the possibility to trigger (with a button in Anaplan) a data export from Anaplan to another system. For some of our processes our Anaplan users are currently hitting a 'magic button' outside Anaplan to transfer data from Anaplan to a different target system. It would be nice for them to…
-
Mulesoft Anaplan Connect Import Issues
Hi, I am trying to do a Import of a csv file to Anaplan Model , it is throwing an exception "Invalid import ID provided:" Can somebody please help on the same.
-
Planning for Efficient Imports
Take time to determine the most efficient way of pulling your data in. With multiple views, it is common to think about each view separately, but when it comes to importing data, a holistic view is key. For instance, if you would like to see a current roll-up of sellers to teams and a historical view (i.e. – which seller…
-
ANAPLAN CONNECT - ISSUE WITH A MYSQL QUERY
Hi all, I'm trying to upload data from MySQL database. To do that I have made a batch file (windows script). In a first step, I have made a CSV file (fullfilled from a query exceuted in MySQL) and I have no issue to upload data using the script. ==> No issue to connect to ANAPLAN ==> All records have been uploaded In a…
-
Using NTLM Authentication with Anaplan Connect
While setting up your Anaplan Connect integration, if you encounter authentication errors with your proxy it may be because it uses NTLM. Anaplan Connect does not support this out of the box, but you can enable it by following these steps: * Navigate to http://jcifs.samba.org/ * Download the latest JCIFS jar file (1.3.19…
-
August 11 & 18, 2018 Release Discussion
Do you have feedback on the August 11 & 18, 2018 Anaplan platform releases? Share your thoughts below! Click the Reply button below to post.
-
.bat file returning "Access Denied." during attempt to run a process
We use SSO, and thus I am using a certificate. I am attempting to run a process, that runs an import from another Anaplan model. The import works when not utilizing Anaplan Connect. Is there anything wrong with my code? I am receiving an "Access Denied" response prior to the debug information, which is just the generic…
-
Do Import Actions have an expiry date?
Hi, The import actions sometimes throws an error dialogue stating 'the import action / the file you are looking for, is no longer available'. However, you will be able to run the action. Now, the question is how do I check the mapping if it was essential to know the mapping. Is there a workaround to it? Also, do the import…
-
Is it possible to suppress warnings for duplicate items during import to a list?
Hi, is it possible to somehow prevent a warning "Another row has already been processed with this key" when importing from a text file? In my case it is expected that there are duplicate items, so this warning is confusing for a user - it seems like something went wrong during the import. It would be much better if user…
-
Can I cancel an import/export?
How can I cancel an import or export?
-
Which PUT Method to use?
I've run into another issue with uploading a file using the Anaplan API. For this client I'm trying to do a data integration from a data migration tool called Scribe Online where the API connections are configured using a GUI. When Scribe receives the API specifications from anaplan.com/swagger.json it brings in the…
-
Requesting File ID from Rest API Throws 500 Internal Server Error
Hello, I've been attempting to get the file ID from a model using the following curl code adapted from the Anaplan API docs in Apiary. curl -v --include --header "Authorization: Basic encoded_username:password" --header "Content-Type: application/json"…
-
Anaplan REST - issue uploading file
Hi, I'm not Anaplan guy but doing an integation with Anaplan through the REST API. Export of data works fine. Issues come with the import. As first step, we have to upload the file. We are using PowerShell but any feedback if other language is also welcome. My question is: shall we use --upload-file in the url. In the API…
-
July 14, 2018 Release Discussion
Do you have feedback on the July 14, 2018 Anaplan platform release? Share your thoughts below! Click the Reply button below to post.
-
Exporting major modules for archiving purposes
Hello everyone, Do you have some insights to share on the process of archiving data outside of Anaplan? Indeed, our current customer would like to store Anaplan produced data – each closing – in another tool. The constraints of our context are: * Many modules from which to export * Many lists in those modules (each time…
-
June 16, 2018 Release Discussion
Do you have feedback on the June 16, 2018 Anaplan platform release? Share your thoughts below! Click the Reply button below to post.
-
Date Flipping from UK to US style
Hi, I am importing data froma csv into a module and i have 7 date fields, they are all formatted (short date) exactly the same as each other, when i import the data, i have ticked the format to show D-M-Y which correctly showed the dates and applied to all date fields as normal.. However when i import, 6 of the fields are…
-
Differences between api2.anaplan.com and api.anaplan.com
Hi, Documentstion is not clear... What are the differences between api and api2? Our client tool works with api2 but it doesn’t with api Thanks for any clarification
-
How to use Data Tags
Hi, I am trying to understand how to use data tags , I uderstand that we create tags in settings and assign the same to various objects in the model however I am not sure how and where can I use those tags.
-
Importing duplicate rows into a numbered list
One of the reasons for choosing a numbered list is that it supports duplicate combinations of properties. Does anyone know how you can import into a numbered list from a CSV containing duplicate rows? It is not acceptable to have to add anything to the CSV prior to import. For example the CSV has 3 columns headed List1,…
-
Anaplan Connect Batch Script Error: "Anaplan API: The Credentials supplied were invalid"
Hello, I am trying to set up a certificate to run my batch scripts instead of having my username and password included in the batch scripts. I have confirmed that the batch script works when including my username, and then manually typing in my password; however, when I replace the information with a new certificate that I…
-
Masking Username/Passsword Within Anaplan Connect Scripts or Certificate Based Authentication
Does Anaplan Connect support or provide functionality to mask/encrypt usernames and passwords within the batch files created to run jobs? Or is there a preferred method in setting up Anaplan Connect in which you will not need to explicitly state usernames and passwords within the batch file itself. Thanks for the help.