Importing and Exporting Data

Create Hierarchial list using import
Hi, I am trying to create a list as shown in the attached image. Here i have'nt created the seperate list for 5804 (which is like parent list). To avoid sparsity & size constrain, i am trying to create parent & child list in the same list. I know how to create in the tool for less items. Can someone tell me how to use…
Create Hierarchial list using import
Hi, I am trying to create a list as shown in the attached image. Here i have'nt created the seperate list for 5804 (which is like parent list). To avoid sparsity & size constrain, i am trying to create parent & child list in the same list. I know how to create in the tool for less items. Can someone tell me how to use…
Anaplan Import Message Error
Hi All, I'm trying to upload actuals into my model however I keep getting Error Message 1. As I workaround I tried splitting the file into pieces to upload it. But while doing that I recieved Error Message 2. Can someone help me out with these error messages and let me know if there is any other work around this issue.…
Anaplan Import Message Error
Hi All, I'm trying to upload actuals into my model however I keep getting Error Message 1. As I workaround I tried splitting the file into pieces to upload it. But while doing that I recieved Error Message 2. Can someone help me out with these error messages and let me know if there is any other work around this issue.…
Amending existing Imports
Hi, Apologies if this has already been covered elsewhere. I'd like to be able to edit existing import processes without the need of recreating them. The specific use case is that I provide self-service functionality for users to interact with apps and load data and metadata and I tend to do so via .csv upload. I then…
Import Date from CSV
Hi, I want to run a script to update the date on a daily basis. I have a batch file that creates a csv file with header Date and the date underneath on row 2 in format 08-02-2018 also tried 08/02/2018 However i can not import this to a module with a item formatted date, as it will not recognise it as a date , no matter…
Change to Import in ALM production list
In a production list, I have added one new property to the list and updated an existing import action to import data into this property. This action remains unchanged otherwise. This change was made in the development model In the production model, after the changes have been pushed from dev, and running the above action,…
Import 2 number list with identic Parent and Code
Hello, In Model 1: I have 2 Number List: Payer Sold to, with parent Payer Every line in organization, also exist in Sold to list. As example: Name: Parent: Code: Aushan _______ 12 - Payer Aushan Aushan 12 - Sold to Aushan Aushan 15 - Sold to In Model 2: I have 2 Number List, as well: Payer Sold to, with parent Payer I copy…
Import error when list name is same as parent name
Hi, I am trying to import the data to my list for which i am getting an error as "New property combination found but name or code already exists" when list name is same as parent name. Ex: B is a parent of another list with same name. Do i need to manually add list in these situations or is there any solution for this. And…
Importing Properties - Don't Update
I have a module with single applies to that is my list of transactions. This has various line items (essentially properties). I then have an import routine which updates these values, my question is can you have it so that it doesn't update if there's already something there so only does the blanks? Thanks Andrew
Looking for a source file for my import
Hi, I have some import actions defined on my list, but I do not know where the source files are located. I would like to have an insight into these files and edit them. Is there any way to track them down? Please help.
Exporting Revision Tag details in excel
Hi there, Just wondering if there is an option of exporting Revision Tag details in Excel or other formats? I am trying to get all revision tags exported in excel for detailed documentation purposes. Thanks, Vish
Locking data in a module after import
Hi All, We have a requirement where the client wants to fix data in a module after an import so as to prevent accidental override of data if another user run the import process in the same module. Is there a way to implement this locking of data. Regards, Prateek
List matching error of importing data
Hi all, Sorry for my vague question. In our model, data import error is happend at the specific module when using "match on names or codes". If I use "Map items manually", importing data always suceeds. What is the possibilities of list unmatch cause do you think? Thank you. ****
Import data in modules with different versions
Hi, I am trying to import data in a module. It works perfectly, except that it automatically copies over the same data in the different versions, even if I specify in the import pannel the it only applies to one version. Did someone already experience this? Do you have a solution? Thank you!
Solving User Security in Exports
Hi Fellow Anaplaners We had an issue of providing user security while giving capability to user to export the report. Wanted to share, all the challenges we had and how we worked around them. Problem: Users wanted to export a report which had Sales target data of Organisations Sales hierarchy and business units. My report…
How to set up import mapping
Hi, Given that the following line items are in a module. Sales amount: Nubmers for actual, previous forecast version and budget have been already populated Current Version: Checked if current version Previous Version: Checked if previous version I would like to copy the value of 'Sales amount' checked in the 'Previous…
ERROR: "API invocation failed: Illegal argument"
Good morning, i receive following error when trying to edit the import data source: "API invocation failed: Illegal argument" In the same time even if source is pointed to production and users have access to the workspace- system gives error "You do not have access to the source workspace" Any thoughts?
Importing custom timestamps
Hi There, I'm trying to import property that has unrecognized date/time format, e.g. Sun, Mar 5, 2017 9:07 PM I see that date format allows setting custom format and use "?" to ignore certain positions. Unfortunately I cannot find more details or examples how this can be used to import above data. Thank you!
Numbered Lists import
Hi, I am trying to import transaction data into a module. To represent each individual transaction, I want to use a numbered list. Also, since there are many transactions in the csv, I want Anaplan to automatically identify and create the required no. of transactions in the numbered list. How can I import and create this…
Prefered Sources for Anaplan to Anaplan import
Hi, I find it usefull to use the following practice : import from Anaplan model should be setup as such : * import from saved views : 90% (even 100% in some contexts) * import from list : 9% (or 0%) * import from module : 1% (or 0%) Whenever possible, all imports should be made out of saved views. It takes 5 to 10 minutes…
Working with the Module Line Items Export
Whenever I need to dig into the model by line item, I always export the module line items (Settings -> Modules -> Line Items tab) and quickly filter it in excel. The only problem is, when you filter down onto a subset, you lose the ability to see what module the line items apply to. For those of you that use VBA in Excel,…
Exporting Revision Tag details in excel
Hi there, Just wondering if there is an option of exporting Revision Tag details in Excel or other formats? I am trying to get all revision tags exported in excel for detailed documentation purposes. Thanks, Vish
Error on Importing Codes for Line Items
Hi, I already have line items in my module but I forgot to include the codes when I first created those line items. Now, I would like to add their codes through import. However, when I try to import, this is the error: distinct names found for same code - check mapping and/or data. What could be the cause of error and the…
How do I clear out a module for items that are not in an import file
I need to clear out list items that are not in my import file but only for a selected version
Can't import model after SSO is enabled for Anaplan
Hi, We are enabled Single Sign-on for Anaplan recently, but we found we can't 'Import' model now as it requires user and password. However, we don't use user name and password any more. How do we solve this issue? Thanks, -Julie
Import Date
Hey All , I have two modules with no dimensions and format as date PFB Screenshot -1 I have to Import those dates into another module with no dimension & Format as date (Refer screenshot -2) (Module - Module Connect) . I am not able to run it , Please dont advise me to use formulas as i need this Import to Happen . Kindly…
Import data with a timescale "week"
Hi. I want to import data from a model to another model. Nothing extraordinary. My two models have a timescale “week”.The two modules are in “day”. All the records are rejected with the message:“Invalid date or timescale identifier”. Where is the problem ?
How do I clear out a module for items that are not in an import file
I need to clear out list items that are not in my import file but only for a selected version
Using imports as a copy method within a module
A fellow anaplanner had the following question in the FAQ-section. Since Im but a humble user I can't give him a reply there. So here is the question: [quote]We have a situation where we want to import from within the same module from one line item to another. We ran the import two times with different source and…

Importing and Exporting Data

Discussion List