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

akssaju
Contributor

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisAHeathcote
Community Boss

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.

 

Chris
HeathcoteAndHerran.com

View solution in original post

4 REPLIES 4
ChrisAHeathcote
Community Boss

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

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

Chris
HeathcoteAndHerran.com
akssaju
Contributor

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

Thank you!

ChrisAHeathcote
Community Boss

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.

 

Chris
HeathcoteAndHerran.com
akssaju
Contributor

Now it worked. Thank you!