Re: Issue while importing data using one of the mapping options 'Ask each time the import is run'

Hi,

I am trying to import data from one module to another. And in one of the mapping, I gave the option as 'Ask each time import is run'. The issue I am facing is it is not mapping to one particular record, instead, it is loading all the records into one record. mapping mapping

Importing from this module

Importing into this module

Accepted answers

VIGNESH.M

Hi Vamshi,

What I suggested will load data for one record based on the Item in the filter.

Next time, select the different record and load data for that record only.

Photo1.png.jpg

Your previous record data will be still the same.

~Vignesh

All comments

VIGNESH.M

Hi Vamshi,

In your case, "Ask each Time Import is Run" will import the sum of the records data into 1 particular record.

Example, the Sum of all records loaded into ITEM 1 which I selected.

Photo1.png.jpg

Try the alternate way to achieve the same,

Create a filter line item to select which particular record needs to be copied.

Apply the same filter in your import view and map the dimensions.

Photo1.png.jpg

~Vignesh

rob_marshall

@CommunityMember131103 ,

It depends on what you are attempting or wanting to do with this import. A couple of things to note:

all imports should be from a view where you can filter the appropriate data (something Vignesh mentioned above).
The filtering also helps you to only load the data you need to load (detailed members like months vs. Quarters, as well as, in your case, Record List and not "All Records").

From what I can see in your mapping, you might have the the mapping incorrect. If your record list is long (longer than 5 members), I am not sure you will want to be prompted everytime this action is run. Instead, change the mapping, as well as your view,

Line items in the columns (so you can use Column Headings)
remove the parent levels of Record List (so you only get the detailed members). The parent levels can also be "removed" from the view using a filter. If the Record List is a numbered list, you will need to have a line item showing the code so you can link on that.
Place Time in the Page axis, but you will need to use a SYSytem module to only bring in the months, assuming you are not loading into a Quarter or Year module
Your mapping would then look like the following:

Hope this helps,

Rob

CommunityMember131103

@VIGNESH.M

Thanks for the reply.

What you suggested will load only data for one record. What I am looking for data should be loaded for each recorded separately on the prompt.

And records will keep on adding. So in future data should be intact for the old records that are loaded. Import should only change the data for the new record.

VIGNESH.M

Hi Vamshi,

What I suggested will load data for one record based on the Item in the filter.

Next time, select the different record and load data for that record only.

Photo1.png.jpg

Your previous record data will be still the same.

~Vignesh

CommunityMember131103

@VIGNESH.M

So but every time someone has to change the filter manually?

VIGNESH.M

Yes, Vamshi.

CommunityMember131103

But That is not what I am looking for. Import action will on the dashboard and the user just wants to select the one record at a time and import data.

DavidSmith

@CommunityMember131103

Can I ask why are you importing from module to module driven by users?

This is not "normal" Anaplan modelling so I'm interested/concerned as to why you need to do this.

We should be trying to minimise user driven actions wherever possible especially for data movements

David

CommunityMember131103

Hi @DavidSmith ,

Its a requirement from the user. Like I have data set in a module for several locations ad dimension.

Ex for Jan Loc A 30

Loc B 40

Loc C 50

this data keeps on changing

so in jan he want to take the snapshot of it

for record 1 Loc A jan 30

record 2 Loc B Jan 40

So if in Feb data changes to

Loc A 35

Loc B 45

Loc C 55

and he creates wants to create a new record

say record 3 Loc a Feb 35

other previous records data should not get altered.

ArunManickam

@DavidSmith

We do have similar examples. It is typical in Supply chain.

For eg,

Based on today's demand & supply situation, I have a gap of 50 units on a particular material. I want to release a Purchase requisition to buy 50 units of the material. System calculates for all materials that need to be top up like this. Lets call them "planned orders". If the planner decides to convert them to real orders, in this case as a "Purchase requisition" for exection, the planner has to tick on a boolean called "Release". Then at the end of the day or after the planner reviews all lines, an action has to be triggered by the user to import all the selected planned orders to get converted as "Purchase requisitions". The purchase requisition is a record and can be tracked when it was created, when it was delivered etc. Whereas planned orders are dynamic, changes with time & data. These cases need an import, typically triggered by the supply chain planners.

Arun

swapnil_J

HI @rob_marshall

Take the same example and suppose I want to do the import based on the last list item that I added into that list (the extra list (dimension) in the target module) then what should be my approach?

I believe it is not user friendly to ask end-user for which list item he has to save the snapshot when your list has more than 20 list items.

rob_marshall

@swapnil_J

I totally agree the action should not prompt the user when importing which is what I stated:

First, it is really not best practices to have endusers upload files to a production model because:

could possibly lose data integrity
data can no longer be audited back to the source (user can manipulate/change the data before they upload it)
when a user runs an action, it blocks the model for input by others, so now there could be a concurrency issue

Second, when a member or metadata is loaded, the member has to go into a list first and then the supporting metadata or transactional data goes into a module. So, if you are importing a new member to the list and then want to load supporting information to a module, you can do that with two actions:

load member to list
load supporting data to module.

By doing that, it will only load the data from that one file.

Rob

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385