Level 3 Import to A2 Account>Product# list

prakashdevaguptapu
New Contributor

Level 3 Import to A2 Account>Product# list

Hi,

 

In Level 3  Activity 4.6.4  Import data from the Data Hub model to populate the A2 Account>Product# list

 

Here I have created a Saved view in Data But for Module SYS14 Create Account>Product to import this data to A2 Account>Product# list. But could not import successfully. I have seen both Product List and Account List as dimensions in saved view SYS14 but in the A2 list  I can only see Account list members populated which is a combination  list.

 

I am struggling to populate products in A2 to list. Need Help to solve Import Issues.

 

A2 List.png

Saved View.png

1 ACCEPTED SOLUTION

Accepted Solutions
ankit_cheeni
Super Contributor

Hi @prakashdevaguptapu  

What would be helpful is to revisit importing into numbered list 

Some questions I think you should be looking at:

 

1. Why do you see Account list members in A2 list and that too in bold? This could also mean you might have had items added but present at the bottom of the list (and these would not be bold). Understanding the difference is key to understanding the basics of lists.

 

2.  Why do you have A2 as a numbered list? Can it work without being a numbered list? (Answer is No, but think why)

 

3. Now that we know it has to be a numbered list, check what all do you need to complete the import - e.g. parent/code/display name etc. and see if you are doing the right mappings for all these.

 

Honestly, you only need to think about point 3 for the certification but understanding 1 and 2 are more crucial to your growth as a model builder/SA. 

 

Cheers!

View solution in original post

5 REPLIES 5
Misbah
Moderator

@prakashdevaguptapu 

 

A2 Account - Products is supposed to contain only Accounts at first because you will be uploading Products into this list from SYS14 module. Now it is all how you import and how you map. Since it is Level 3,  expectation is that you do it on your own.

 

If I was you I would check the import action. Remember Account- Product is a numbered list - and imports get trickier with numbered list

 

Good Luck

Misbah

Miz Logix

prakashdevaguptapu
New Contributor

Hi Misbah,

 

Thanks for addressing the issue. I have tried unchecking the Number list Dialogue box and Imported the Data, but I could update the products for only the first Account CANDYATE for rest of the accounts the following error is showing up which i Have attached in the below images. Can you suggest me how to proceed to solve this issue! I have stuck on this issue for a day now.

Mapping.png

Error.png

ankit_cheeni
Super Contributor

Hi @prakashdevaguptapu  

What would be helpful is to revisit importing into numbered list 

Some questions I think you should be looking at:

 

1. Why do you see Account list members in A2 list and that too in bold? This could also mean you might have had items added but present at the bottom of the list (and these would not be bold). Understanding the difference is key to understanding the basics of lists.

 

2.  Why do you have A2 as a numbered list? Can it work without being a numbered list? (Answer is No, but think why)

 

3. Now that we know it has to be a numbered list, check what all do you need to complete the import - e.g. parent/code/display name etc. and see if you are doing the right mappings for all these.

 

Honestly, you only need to think about point 3 for the certification but understanding 1 and 2 are more crucial to your growth as a model builder/SA. 

 

Cheers!

Misbah
Moderator

@prakashdevaguptapu 

 

As @ankit_cheeni mentioned please revisit the lesson of Importing into Numbered list. I can see fundamental flaw in your dealing with imports into numbered list. Spend few moments there and I am confident you will figure it out what went wrong with your import

 

Misbah

Miz Logix

Ghita
New Contributor

Hi

I've been trying to to this import the whole day, and now I'm stuck ...

I don't manage to get the existing code account>product to be used as the unique identifier. Instead a new code is created, here are my screenshots :

Saved view :

Ghita_1-1654673442203.png

 

Import mapping :

Ghita_2-1654673468607.png

 

Import :

Ghita_0-1654673366400.png

4359 items have been imported

 

Please help me understand what I'm doing wrong here, I've tried - to my knowledge - everything !

 

thank you for your help