Hi team.

I don't succeed to import Locations with correct Parent when they are in the same csv file. I succeed when they are in different files.

Region file looks like this:

LocationType,Name,DisplayName,FullName,ParentLocation.Name
Region,test45-region01,test45-region01,test45-region01,,

Country file looks like this:

LocationType,Name,DisplayName,FullName,ParentLocation.Name
Country,test45-country01,test45-country01,test45-country01,test45-region01
Country,test45-country02,test45-country02,test45-country02,test45-region01

City file looks like this:

LocationType,Name,DisplayName,FullName,ParentLocation.Name
City,test45-city01,test45-city01,test45-city01,test45-country01

The expected and correct result (Parent field is properly set) looks like this:

I merged the data into one file and change the values to:

LocationType,Name,DisplayName,FullName,ParentLocation.Name
Region,test47-region01,test47-region01,test47-region01,,
Country,test47-country01,test47-country01,test47-country01,test47-region01
Country,test47-country02,test47-country02,test47-country02,test47-region01
City,test47-city01,test47-city01,test47-city01,test47-country01

I get failure error messages with this description:

"failure": "ParentLocation.Name=test47-region01"
"failure": "ParentLocation.Name=test47-region01"
"failure": "ParentLocation.Name=test47-country01"

And the Parent field is not properly set:

I have tried to add a comma at the end of the last three lines in the merged CSV file and the import still doesn't succeed.

Do you know what I am doing wrong?

How can I solve this issue?

Best regards