Target mapping for imports into a model

Highlighted
Occasional Contributor

Target mapping for imports into a model

Hi,

I really do not understand target mapping when importing data for a model. Is there anyone who can help me with understanding this (may be with an example, since I am that much lost with this topic).

 

Thank you

14 REPLIES 14
Highlighted
Certified Master Anaplanner

Re: Target mapping for imports into a model

Hi @nimesha ,

 

The easiest, and best practice, is to have codes everywhere.

 

Once you link the column to the list the mapping should be there automatically.

If that's not possible you could always open the tab of the specific list and switch to manual mapping. There you can link the elements as you wish.

 

There is a bit more meat around this topic here.

 

All the best,

 

 

Highlighted
Occasional Contributor

Re: Target mapping for imports into a model

Hi MaartenGijbels 

 

Many thanks for the reply.

 

I do not get any automatic mapping and whatever the mapping I do get unsuccessful. Even the link that you say does not exactly say how to do this mapping thing properly. Please help.

 

Thanks

Nimesha

Highlighted
Occasional Contributor

Re: Target mapping for imports into a model

Actually it seems like I get only some of the data and I get below error message. I guess I am not selecting correct source for the target. Could you please tell me how to find out, what should select in the source tabs.

 

Thanks a lot

Nimesha

Screen Shot 2020-08-31 at 8.11.29 pm.pngScreen Shot 2020-08-31 at 8.12.46 pm.png

Highlighted
Occasional Contributor

Re: Target mapping for imports into a model

Hi @nimesha ,

In Module Import Process Source and Target Names(line items) will auto match if they  visually  same ,incase if auto match not happened than we always have an option of manual mapping . 

 

From your Screenshot "line item identifier errors " normally cause if the respective line item is not mapped ( left blank) or if the format of that respective line item is in different format ( source : text but formatted as number).

 

To avoid this we can edit the respective action and check the mappings of respective line items ( source vs Target).

 

 

 

Thanks

Raghavimg2.pngimg1.png

Highlighted
Certified Master Anaplanner

Re: Target mapping for imports into a model

It's a bit of a pain,

 

But could you add a screenshot of your source and every tab within the import process? That will probably clarify a lot.

 

You could prepare by paying specific attention to tabs that are suspiciously empty.

 

Maarten

Highlighted
Occasional Contributor

Re: Target mapping for imports into a model

Hi, 

 

Yeah it is a pain as I have wasted good 5 to 6 hours only on this importing data thing. I even deleted whole employee details module and created freshly. Tried to manual map, but still did not work. I have attached step wise screenshots of what I have done. Can someone please tell what I am doing wrong.

 

Thanks

NimeshaScreen Shot 2020-09-01 at 4.21.48 pm.pngScreen Shot 2020-09-01 at 4.22.09 pm.pngScreen Shot 2020-09-01 at 4.22.21 pm.pngScreen Shot 2020-09-01 at 4.22.34 pm.png

Certified Master Anaplanner

Re: Target mapping for imports into a model

Hi @nimesha ,

 

On the screen of your 2nd and 3rd step you see additional tabs. (1 for the employee list and 1 for the line items.)

 

Could you open these? This is were the mapping comes into play.

 

Do the employees in your first column automatically map with the employees in your list?

Do the column headers link to the line items?

 

All the best,

Highlighted
Occasional Contributor

Re: Target mapping for imports into a model

Hi Maarten,

 

Attached are those screenshots that you asked for. No, 1st column comes empty. I am the one who selected employees in that.

 

Really appreciate your support.

NimeshaScreen Shot 2020-09-01 at 5.42.37 pm.pngScreen Shot 2020-09-01 at 5.42.51 pm.pngScreen Shot 2020-09-01 at 5.42.58 pm.png

Highlighted
Occasional Contributor

Re: Target mapping for imports into a model

Hi @nimesha ,

 

From your Screenshots what i understood is "Start Date & End Date" line items failing with errors , can you check the formats in source file and line items formats in module .

In your 3rd Step we can check whether Source file Date records are matching or not & also we also have multiple date formats. ( Pls check attached screenshots ) 

 

 

Thanks

date1.PNGdate2.PNG