Import Data into Product Details Module

nayani_fernando

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

Import_Screen_85488.docx

Accepted answers

Puneeth H P

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 .

level 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

All comments

Puneeth H P

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 .

level 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

Thanks Puneeth. It worked.

LRanaplan

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

Anilkumarch

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

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

2020-11-3_92307.png

Anilkumarch

@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.

JosephA

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

SYS06_Product_Details_from_Products_(2)_92310.csv

Anilkumarch

@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

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

no code.png

JosephA

not sure if my set up is completely wrong. SOS please 🙂

Anilkumarch

Product Code and Product Family details needs to populated using formula.
Product code = Code(Item(Product list)) and Product Family = Parent(Item(Product List))

JosephA

awesome!!. Thank you. After the formula, this is what I got. Do I still need to worry about Product family code ?

Anilkumarch

Not required. Looks good

JosephA

Thank you very much!!. now I can go to bed 🙂

JosephA

I'm having the same issue with 7.2.4, I did the formula this time for code and department, but for the code, it returned a name and not a code after I imported, and then country, start date and leave date, not sure if that is a formula as well. Any thoughts on what my mistake is?

Employees SYS08.png

JosephA

I think my mistake is here, but I've tried correcting and to no avail. This is not as straightforward as I thought. I wonder how many customers get frustrated 🙂

KARASAGE

Hi Guys,

When I import the data I do not get the same thing as you guys and I dont understand why.

Capture d’écran 2021-01-06 à 15.19.35.png

Niraj.B

Hello,

Instructions are missing here. It should have clearly specified that we are populating the Size. The other 2 fields will come as a formula in next task. I spend 45 mins on this until I found this forum.

abhinandan

Hi @Puneeth H P I am facing issue related to this 7.2.1 Activity: Import Data into Product Details Module.

I want to understand how can I remove Time dimension from the module ?

Also I have followed steps mentioned by you for the mapping but for rows are getting ignored and I am getting drop down list for the size column to fill the data. Can you please help .

error_7_101148.PNG

Niraj.B

Hello Abhinandan,

Time dimension can be removed by going to blueprint mode and removing from there.

abhinandan

Okay thanks for your help. Its done

juanacevedo

Hi,

Im struggling with the mapping of "7.2.1 Activity: Import Data into Product Details Module".

Im getting the error below

Below what I am choosing for "source".

Can anybody help?

Thank you

Quick Links

Can you help?

Unanswered questions

A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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