Excel import troubleshooting

LUY displays a notification if the Excel sheet cannot be imported. The invalid data in the Excel sheet can either be removed or corrected. There are different error messages for various kinds of invalid data:

Missing reference object

Error in step 1: Cannot resolve related object identified by Abc over relation end parent.

Reason: A building block refers to the building block Abc as its parent, but the row for Abc is either missing or Abc is renamed. 

User actions:

1. In all sheets of building blocks with a parent-child association, search for rows with the value Abc in the column named parent.

2. If you want to rename Abc, say, to Def, rename the reference, too.

3. If you want to delete Abc, delete the reference, too.

4. If the new name of Abc is invalid, use a valid name and rename the reference, too.

Object not found

Errors like the following in step 1: "Error in sheet GP-PROJ B-8: No object of type project with the name "new branches" found in file."

Reason: The project "new branches" is not found and cannot be used in a relation end. This can happen when a single building block or a complete building block type sheet is missing in the import file.

User actions:

1. Make sure that the sheets for all building blocks used in any relation end are included in the import file.

2. If not present, add the project "new branches" to the sheet "PROJ".

3. If you want to delete "new branches", delete all references to it, too.

Invalid position (ignored)

Warning in step 3: The value of property position for object expression with id 99 is not valid.

Reason: The position must be an integer number. The position is not imported.

User actions:

1. In all sheets of building blocks with a hierarchy with positions, search for the row with ID 99 (in the first column). Note that there is exactly one such row.

2. Remove the value in the position column.

Invalid numeric value

Warning in step 4: The value of property sample numeric property for object expression with ID 270 is not valid.

Reason: The value of sample number property must be numeric.

User actions:

1. In all sheets of building blocks with the property sample numeric property, search for the row with
   ID 270 (in the first column). Note that there is exactly one such row.

2. Correct the invalid value.