Problems with Family Type Catalog

[lee.imbimbo]

I'm having trouble with a family I've created, and I can't seem to figure out why it isn't working.  I had this bright idea to create a Family that was not hosted, and then use a Type Catalog to create all the variants of that family.  Then go the next mile and I thought I'd make one Wall hosted and one ceiling hosted family, as they appear different depending on what they are doing.  That being said, it doesn't seem to like my Type Catalog, with my family.  I've linked a couple of files here to see if one of you can find where I messed up.

Grille - LinearSlotDiff - Slotted Grille - Not Hosted - 2023.rfa - The unhosted family

Grille - LinearSlotDiff - Slotted Grille - Not Hosted - 2023.xlsx - The excel file I used to create the csv file

Grille - LinearSlotDiff - Slotted Grille - Not Hosted - 2023.txt - the txt file created from the excel file

[RLY_15]

Delete the blank rows.

I think what's happening is that the family still attempts to read the blank rows (,,,,,,,,,,,,, in the .txt) as data.

It sees an empty field for a text parameter, that's acceptable, check next column.

It sees an empty field for a text parameter, that's acceptable, check next column.

etc.... until it hits a length parameter. That can't be empty. So it throws you the = formula error.

[lee.imbimbo]

@RLY_15, So I think you're on the right track, I got rid of the extra rows, and now it's saying that it doesn't like Row 1 Col 3.  Again I don't see anything wrong with this one, so I don't know what it's deal is.  Any ideas.  I've attached the updated TXT file that's generating the problem.

[RLY_15]

https://knowledge.autodesk.com/support/revit/learn-explore/caas/CloudHelp/cloudhelp/2021/ENU/Revit-C...

At some point in time, Integers moved from ##number##general to ##other##. Couldn't tell you exactly when, but that would explain the error you're describing.

Also, just because it might come up later, you currently have your Air Terminal defined as a Mechanical Equipment family.

[barthbradley]

"GrilleQty##number##general"  to "GrilleQty##OTHER##"  

FWIW: Open your Family and Export Family Types. Then you can compare this exported file with your text file.  This was the first thing I noticed and changing "GrilleQty##number##general"  to "GrilleQty##OTHER##"  seemed to resolve error.  I loaded all Types into Project.   No errors. 

...btw: this was the error that was resolved: