Import Locations with correct Parent from one single CSV file fails

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

Best regards

Michael

  • Hi Michael,

    According to: https://docs.microfocus.com/itom/SMAX:2021.11/ImportDataFormat

    • The files should be imported in a logical order, based on the dependencies between the record types. If a record file includes a field that references a related record, the file for the related record type should be imported first. 

    So this doesn't look possible, because even though you have an ordered import, you cannot guarantee that the previous line is finished executing (i.e. gone through all Rules) before it attempts the next line...

    Regards,

    Ben

    Ben Rabau 

    EMEA Professional Services