Error Saving Family

[L.Maas]

Today spent some time troubleshooting a family. I have a family with a type catalog.

I made some modifications to the family and it crashed Revit

Restarted computer, reloading the family, making some moidifcations, saving...crash.

Revit 2016 (20150714_1515(x64)).
OS Windows 7 with SP1.

I often use type catalogs and make use of csv file editors (e.g. excel)  to modify or fill the type catalogs.

Reproducing the error:
-Save the family and the type catalog together in a folder
-Open the family in the family editor
-Save the family.
-ERROR.

Cause:
-During export from csv file editor extra (empty) column was generated by mistake.

Solution:
-Remove empty column (the last comma in every line).

However it is strange that while just saving the family in the family editor it should crash on the faulty type catalog.
Took a while to find cause of crash while first expecting something wrong with the family itself

Attached the family with type catalog used to create error.

[dzanta]

Couple of things to check:

1.  Is there an extra space within your table that is causing the hiccup?

2.  Have you tried creating the table with Notepad software and not Excel to see if it crashes?

[L.Maas]

The problem and solution are clear. When saving from excel it saved an extra (empty) column. This resulted in the comma at the end as shown in the screenshot of my earlier post. Removing those commas from the text file resolved the problem.

Strange thing was that when editing the family and then saving it 'crashed' Revit. I find it strange that wehn saving the family an error in the type catalog should crash revit. So it took me a while to find the solution (first thought it was the family itself that caused the problem).  

I think unrecoverable errors should not happen. It appears that this will be an easy 'bug' for Autodesk to resolve.

So I intended by my post to inform other people and Autodesk about this error (saving some troubleshooting time) and hopefully Autodesk will use it to remove this 'bug' from the software.