Data Integration

Option to show how many cells have been updated by an import
Description of the enhancement: Option to show how many cells have been updated by an import which includes how many items were Cleared prior to import. There should be an option that the cells which have been updated in this way will be reported as updated in the results screen Workaround: To workaround this, users should…
Provide a more user friendly message when an export is cancelled
Description of the enhancement: Run an export from a model (helps if the export takes a few seconds). Click Cancel when the browser asks you to save the file. The export will fail and the message in Anaplan is: {code:none} An internal error occurred. Client abort: java.io.IOException: Broken pipe(caused by: I o: Broken…
Export Display name field
Description of the enhancement required: When exporting, user would like the field "Display name" removed as it adds additional clutter and confuses the customer. A story for why they want the enhancement: Client believes this would help him tidy and organize his lists/number lists a lot better.
Ability to see in blueprint mode if line items are mapped in an import
Description of the enhancement required: Add an "import from" column and "import to" column in modules to identify where a line item's values are coming from. An example of the enhancement: Once mapped to a source in an import action, a field would display the action that the line item is part of. How would it help their…
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…
The source object name column needs to be wider
Description of the enhancement: You can't see all the Source Object Name in Settings --> actions --> Import data Sources. The source object name column needs to be wider OR the columns should utilise the tool tips as they do for the Imports Column see screenshot
Source Models label to be editable for Import Data Sources that are marked as production
Description of the enhancement: The Source Models label needs to be editable for Import Data Sources that are marked as production and the label setting should be on the IDS tab rather than the Imports Tab
Ability to resize columns in IMPORTS & IMPORT DATA SOURCES
Description of the enhancement required: To get workspace more user friendly for models developers. I know that I can copy-paste to excel and read all hidden letters / words. An example of the enhancement: Step 1 click right mouse buton (choose "Column settings") Step 2 confirm column width and get better view (small…
Enhanced Messaging for Ignored Items in Import
Description of the enhancement required: Improve the messaging around why things are ignored so that there is a full breakdown of the successes, ignores, and failures in an import. An example of the enhancement: This could be full messaging upon completion of an import regarding the ignores. For example, it could be a…
Export History in Non .txt Format
Description of the enhancement: Ability to export history in a format other than .txt. An example of the enhancement: .xls format available for History export
Export Subsections of Users Tab
Description of the enhancement: We would like the ability to export subsections of the users tab in the model Settings. For example, we would like to be able to export the following: + Roles + Roles -> Modules + Roles -> Versions + Roles -> Lists + Roles -> Actions An example of the enhancement: Export button added to all…
Can I cancel an import/export?
How can I cancel an import or export?
Import mapping source of a line item/list to 'fixed item' or 'ask every time' remove 'Which target'
Description of the enhancement: Import Mapping: Mapping the source of a line item or list to 'fixed item' or 'ask every time' removes the 'Which target items to clear prior to import'. Can this remain there? As a user, I would like the 'Which target items to clear prior to import' option to remain on the line item/list…
Ability to format the layout of dashboard when exported to PDF
Description of the enhancement required & example of the enhancement: Ability to format the layout of dashboard when exported to PDF: - add page break between modules in dashboard - make the module page selection font size bigger
Provide ability to re-arrange Export labels
Use case: A list with over 20 properties. It is extremely difficult to reorder the labels in the Export dialog. It requires removing them all and then adding them 1 by 1.
"Omit Summary Items" should omit summary Line Items for Tabular Exports
Description of the enhancement: An Export with radio buttons "All Line Items" and "Omit Summary Items" selected results in Summary Line Items not being omitted. The "right" behaviour should be that Summary Line Items are omitted, or that a radio button with "Omit Summary Line Items" exists. Use case: 1) Exporting data from…
List exports to Excel limited to 65536 rows
There is a limit on the export of 65536 rows. Excel 2007 can handle 1048576 rows.
Improve Process Completed dialog box to highlight any errors
Description of the enhancement required: I am experiencing an issue for Non- Workspace Admin users performing an upload process. After running the process the dialog box reports Process Completed Success but upon reviewing View Details you can see there were errors. This is an issue for users who do not know that some of…
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.

Data Integration

Discussion List