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
ChrisHeathcote
Community Boss

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

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 Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

4 REPLIES 4
ChrisHeathcote
Community Boss

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

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 Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
akssaju
Contributor

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

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

Thank you!

ChrisHeathcote
Community Boss

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

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 Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

akssaju
Contributor

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

Now it worked. Thank you!