Level 2 - 1.3.10.2 Import Data into G2 Country List - Error

akssaju

Hi,

 

1.3.10.2 Import Data into G2 Country List 

In the Data Hub model, import data from the source saved view into the target list: 

• Source: SYS06 Country Details module, Build Country saved view
• Target: G2 Country list

NOTE: This list is part of the geographic hierarchy. Remember to designate the Parent when importing the data.

 

There is showing an error while importing please help to figure it out. Screenshot attached.

 

Thank You.

ChrisAHeathcote

The error indicates that there are no codes mapped in the source.

Check the source view to see if the code column is populated. 

akssaju

I'm attaching screenshot of source module. Some code is missing can you please help to figure out this.

Thank you!

ChrisAHeathcote

The items that appear to have no code are the parent of the list and are not relevant in the import.

Open the saved view used to create the country list. Now right click on the row and click on 'select levels to show'. Ensure only country level is selected. Close and then save the view, replacing the existing view.

Re-run the import and the error should now not occur.

 

akssaju

Now it worked. Thank you!

stephaniejlw

Hi @ChrisAHeathcote,

 

I have only country level selected but continue to get an error that the parent is invalid.  Do you see what I've done wrong here?  Been stuck on this for a while.

Thanks,

Stephanie

ChrisAHeathcote

When importing the country list ensure that you map the region code to the parent in the import settings.

stephaniejlw

Hi @ChrisAHeathcote,

 

Thanks for your help.  I have mapped region to parent and attached a couple more screenshots.  For some reason it's a different error now.  Any advice is appreciated.

 

Thanks,
Stephanie