Validating Data for Import

When importing data from Excel, for most of the columns in the spreadsheet, the only validation is to make sure that the data meet the software database requirements for the fields. For example, if the text is too long to fit the field, it will be truncated. If it is the wrong format (e.g., there is text where a number is required), it will be ignored.

When importing items into the system hierarchy, the following additional validation requirements apply:

An example of how the rows in the import spreadsheet translate to the system configurations in the software is shown next.

Level

Item #

Item Name

1

1

System A

2

1

Sub-system A.1

3

1

Component A.1.1

3

2

Component A.1.2

2

2

Sub-system A.2

3

1

Component A.2.1

3

2

Component A.2.2

1

2

System B

2

1

Component B.1

2

2

Component B.2

 

Row

Level

 

Row

Level

 

Row

Level

 

Row

Level

1

1

 

1

1

 

1

1

 

1

2

2

2

 

2

2

 

2

2

 

2

2

3

3

 

3

3

 

3

3

 

3

3

4

3

 

4

3

 

4

5

 

4

3

5

2

 

5

4

 

5

2

 

5

4

6

3

 

6

4

 

6

4

 

6

4

VALID

 

VALID

 

INVALID

 

INVALID

 

Related Topics and Links