"Attribute ... cannot be NULL" error for optional attributes while importing data

[pinja]

I'm using the import wizard for importing data, but am getting this error for some fields, even if they aren't required (they're required in a business process, though). I could put some dummy values in but that seems silly. Any way to fix this?

[pinja · Accepted solution]

Not completely sure yet, but it seems that the problem was that some business rules changed certain fields into required fields (e.g. if field A is true, then field B is required). Disabling those rules seems to have helped.

EDIT: It works!! Yay.

[Samxx]

I have getting the same error: Attribute 'name' cannot be NULL trying to import a solution to a new environment. I have been through all my columns and form names and everywhere I can think of and cannot find where this issue lies. I have no workflows or business rules, just several tables and forms in a solution. 

The output XML suggests the issue is in a form, but having checked the form, everything has a 'name'

Any ideas on how to go to resolve this, other than recreating all the tables and forms manually on the other environment, which will take days. 

[Samxx]

This is the XML output. Not sure if anyone would know where to look?

<Row ss:AutoFitHeight="0" type="Form">

                <Cell ss:StyleID="s137" name="Time">

                    <Data ss:Type="String">

                        09:14:25.01

                    </Data>

                </Cell>

                <Cell ss:StyleID="s137" name="ItemType">

                    <Data ss:Type="String">

                        Form

                    </Data>

                </Cell>

                <Cell ss:StyleID="s137" name="Id">

                    <Data ss:Type="String">

                    </Data>

                </Cell>

                <Cell ss:StyleID="s137" name="Name">

                    <Data ss:Type="String">

                        sk_Booking

                    </Data>

                </Cell>

                <Cell ss:StyleID="s137" name="LocalizedName">

                    <Data ss:Type="String">

                        Booking

                    </Data>

                </Cell>

                <Cell ss:StyleID="s137" name="OriginalName">

                    <Data ss:Type="String">

                        Booking

                    </Data>

                </Cell>

                <Cell ss:StyleID="s137" name="Description">

                    <Data ss:Type="String">

                    </Data>

                </Cell>

                <Cell ss:StyleID="s137" name="Status">

                    <Data ss:Type="String">

                        Failure

                    </Data>

                </Cell>

                <Cell ss:StyleID="s137" name="ErrorCode">

                    <Data ss:Type="String">

                        0x80040200

                    </Data>

                </Cell>

                <Cell ss:StyleID="s137" name="ErrorText">

                    <Data ss:Type="String">

                        Attribute 'name' cannot be NULL

                    </Data>

                </Cell>

            </Row>