Register

Import Data into Product Details Module

nayani_fernando
Occasional Contributor

Import Data into Product Details Module

Hi

I'm struggling with the 7.2.1 Activity: Import Data into Product Details Module.

 

I have attached the screen shot. Can I please get some help on this.

 

 

 

Thanks

 

 

 

21 REPLIES 21
Puneeth H P
Frequent Contributor

Re: Import Data into Product Details Module

Hi @nayani_fernando 

Here are we are importing only SIZE values from the Products.csv file in to the SYS06 module . 

In your screenshot there is a time dimension which is not needed . Remove time dimension from the module . 

And you would get import settings like below and module view . 

moddd.pnglevel 1 map.png

 

Here the data varies in Size and the mapping depends on the Code from the file to module . 

 

Hope this helps, let me know any further assistance needed on this . 

 

Thanks,

Puneeth HP

 

nayani_fernando
Occasional Contributor

Re: Import Data into Product Details Module

Thanks Puneeth. It worked.

LRanaplan
New Contributor

Re: Import Data into Product Details Module

I'm still having issues with it. How do I add Size?

 

LRanaplan_0-1605650177258.png

 

Anilkumarch
Certified Master Anaplanner

Re: Import Data into Product Details Module

Hi @LRanaplan 

 

The size detials are available in the file, so you need to the appropriate mapping with Size coloumn of the file and the size line item in the module.

 

Check your action mapping once and see that is as per @Puneeth H P  screenshots.

JosephA
Occasional Contributor

Re: Import Data into Product Details Module

Having same issue as well. What am I doing wrong with the way I set up module SYS06

 

2020-11-3.png

Anilkumarch
Certified Master Anaplanner

Re: Import Data into Product Details Module

@JosephA i see you have places the products in pages so you are seeing only one product. Go to the pivot option and keep the products in rows and line items in columns so that you can view all the data.

 

Anilkumarch_0-1606799601759.png

 

JosephA
Occasional Contributor

Re: Import Data into Product Details Module

this is the error report I'm getting once I do that

 

Anilkumarch
Certified Master Anaplanner

Re: Import Data into Product Details Module

@JosephA looks you are mapping size to product list in import action mapping. 

You need to map product code column with product list and size in line item(by selecting fixed line item).

JosephA
Occasional Contributor

Re: Import Data into Product Details Module

I did switch and here is what I get, I'm missing the code and product family code

no code.png